DBA Data[Home] [Help]

APPS.BOM_BULKLOAD_PVT_PKG dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 839: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

835: --Populate the Transaction IDs for current result fmt usage ID
836: --New Transaction ID. It will be replaced by old Transaction ID Seq.
837: --SET transaction_id = MSII_TRANSACTION_ID_S.NEXTVAL
838: UPDATE EGO_BULKLOAD_INTF
839: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
840: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND PROCESS_STATUS = 1 ;
841:
842: IF l_debug = 'Y' THEN
843: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering First Loop ');

Line 1568: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

1564: END LOOP;
1565: */
1566:
1567: UPDATE BOM_BILL_OF_MTLS_INTERFACE
1568: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
1569: WHERE REQUEST_ID = G_REQUEST_ID AND PROCESS_FLAG = 1
1570: AND Transaction_Id IS NULL;
1571:
1572: