Technology Stack - EBS (MOSC)

MOSC Banner

Custom.Pll - How to Traverse a multirow datablock

edited Aug 20, 2021 10:53AM in Technology Stack - EBS (MOSC) Question

Hi,

In Oracle Apps Form - Mutirow Data block.-

-------------------------------------------------------------------------

HEADER - Information

-----------------------------------------------------------------------------

-----------------------------------------------------------------------------

LINE INFORMATION

SL     VENDOR_NAME     PRIMARY_VENDOR

------------------------------------------------------------------------------

1     VENDOR1                       Y  

2     VENDOR2                       N

3     VENDOR3                       Y

---------------------------------------------------------------------------------

In the above case One Item Can have multiple Vendor, but at one moment only One Vendor Can be primary.

This is Seeded Form (Approved Supplier List Form).

How I will Check the No of Vneodrs are made primary by Custom.pll.

How I will traverse the Multirow Data Block.

FIRST_RECORD;

        LOOP

         business_type    := NULL;

         flag := NULL;

        

         business_type    := name_in('ASL_SUPPLIERS.VENDOR_BUSINESS_TYPE');

         flag     := NVL(name_in('ASL_SUPPLIERS.ATTRIBUTE11'),'N');       

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center