Custom.Pll - How to Traverse a multirow datablock
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');