DBA Data[Home] [Help]

APPS.EGO_BOM_BULKLOAD_PVT_PKG dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 434: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

430: --Populate the Transaction IDs for current result fmt usage ID
431: --New Transaction ID. It will be replaced by old Transaction ID Seq.
432: --SET transaction_id = MSII_TRANSACTION_ID_S.NEXTVAL
433: UPDATE EGO_BULKLOAD_INTF
434: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
435: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND PROCESS_STATUS = 1 ;
436:
437: IF l_debug = 'Y' THEN
438: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering First Loop ');

Line 773: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

769: END LOOP;
770:
771:
772: UPDATE BOM_BILL_OF_MTLS_INTERFACE
773: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
774: WHERE REQUEST_ID = G_REQUEST_ID AND PROCESS_FLAG = 1
775: and Transaction_Id is null;
776:
777: