APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on EGO_IMPORT_BATCHES_B

Line 415: from ego_import_batches_b

411: and language = USERENV('LANG');
412:
413: CURSOR get_batch_type(l_batch_id NUMBER) IS
414: SELECT batch_type
415: from ego_import_batches_b
416: WHERE batch_id = l_batch_id;
417:
418: CURSOR c_is_enabled_for_gdsn(l_batch_id NUMBER)
419: IS

Line 543: FROM EGO_IMPORT_BATCHES_B

539: SET TRANSACTION_TYPE = C_TRANSACTION_SYNC,
540: PROCESS_FLAG = C_INIT_PROCESS_FLAG,
541: --CONFIRM_STATUS = 'UN',
542: SOURCE_SYSTEM_ID = (SELECT SOURCE_SYSTEM_ID
543: FROM EGO_IMPORT_BATCHES_B
544: WHERE BATCH_ID = ISTI.SET_PROCESS_ID)
545: WHERE BUNDLE_ID IN
546: (SELECT BUNDLE_ID
547: FROM MTL_ITEM_BULKLOAD_RECS

Line 556: FROM EGO_IMPORT_BATCHES_B

552: SET TRANSACTION_TYPE = C_TRANSACTION_SYNC,
553: PROCESS_FLAG = C_INIT_PROCESS_FLAG,
554: CONFIRM_STATUS = 'CN',
555: SOURCE_SYSTEM_ID = (SELECT SOURCE_SYSTEM_ID
556: FROM EGO_IMPORT_BATCHES_B
557: WHERE BATCH_ID = ISTI.SET_PROCESS_ID)
558: WHERE BUNDLE_ID IN
559: (SELECT BUNDLE_ID
560: FROM MTL_ITEM_BULKLOAD_RECS

Line 569: FROM EGO_IMPORT_BATCHES_B

565: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
566: SET TRANSACTION_TYPE = C_TRANSACTION_SYNC,
567: PROCESS_STATUS = C_INIT_PROCESS_FLAG,
568: SOURCE_SYSTEM_ID = (SELECT SOURCE_SYSTEM_ID
569: FROM EGO_IMPORT_BATCHES_B
570: WHERE BATCH_ID = EIUAI.DATA_SET_ID)
571: WHERE BUNDLE_ID IN
572: (SELECT BUNDLE_ID
573: FROM MTL_ITEM_BULKLOAD_RECS

Line 581: FROM EGO_IMPORT_BATCHES_B

577: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
578: SET TRANSACTION_TYPE = C_TRANSACTION_SYNC,
579: PROCESS_FLAG = C_INIT_PROCESS_FLAG,
580: SOURCE_SYSTEM_ID = (SELECT SOURCE_SYSTEM_ID
581: FROM EGO_IMPORT_BATCHES_B
582: WHERE BATCH_ID = EIAI.BATCH_ID)
583: WHERE BUNDLE_ID IN
584: (SELECT BUNDLE_ID
585: FROM MTL_ITEM_BULKLOAD_RECS

Line 593: FROM EGO_IMPORT_BATCHES_B

589: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
590: SET TRANSACTION_TYPE = C_TRANSACTION_SYNC,
591: PROCESS_FLAG = C_INIT_PROCESS_FLAG,
592: SOURCE_SYSTEM_ID = (SELECT SOURCE_SYSTEM_ID
593: FROM EGO_IMPORT_BATCHES_B
594: WHERE BATCH_ID = MICI.SET_PROCESS_ID)
595: WHERE BUNDLE_ID IN
596: (SELECT BUNDLE_ID
597: FROM MTL_ITEM_BULKLOAD_RECS

Line 629: FROM EGO_IMPORT_BATCHES_B

625:
626:
627: UPDATE EGO_UCCNET_EVENTS EUE
628: SET SOURCE_SYSTEM_ID = (SELECT SOURCE_SYSTEM_ID
629: FROM EGO_IMPORT_BATCHES_B
630: WHERE BATCH_ID = EUE.import_batch_id)
631: WHERE CLN_ID IN
632: (SELECT BUNDLE_ID
633: FROM MTL_ITEM_BULKLOAD_RECS