DBA Data[Home] [Help]

APPS.BOM_BULKLOAD_PVT_PKG dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 865: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

861: --Populate the Transaction IDs for current result fmt usage ID
862: --New Transaction ID. It will be replaced by old Transaction ID Seq.
863: --SET transaction_id = MSII_TRANSACTION_ID_S.NEXTVAL
864: UPDATE EGO_BULKLOAD_INTF
865: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
866: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND PROCESS_STATUS = 1 ;
867:
868: IF l_debug = 'Y' THEN
869: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering First Loop ');

Line 1625: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

1621: END LOOP;
1622: */
1623:
1624: UPDATE BOM_BILL_OF_MTLS_INTERFACE
1625: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
1626: WHERE REQUEST_ID = G_REQUEST_ID AND PROCESS_FLAG = 1
1627: AND Transaction_Id IS NULL;
1628:
1629: