APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 601: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBOMI

597: FROM MTL_ITEM_BULKLOAD_RECS
598: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
599:
600: -- Updating bill header rows
601: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBOMI
602: SET TRANSACTION_TYPE = C_TRANSACTION_SYNC,
603: PROCESS_FLAG = 1
604: WHERE BUNDLE_ID IN
605: (SELECT BUNDLE_ID

Line 642: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBOMI

638: LOOP
639: EGO_IMPORT_PVT.Resolve_SSXref_on_Data_load( p_data_set_id => batches.set_process_id);
640: END LOOP;
641:
642: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBOMI
643: SET ORGANIZATION_ID = (SELECT ORGANIZATION_ID
644: FROM MTL_SYSTEM_ITEMS_INTERFACE
645: WHERE BUNDLE_ID = BBOMI.BUNDLE_ID
646: AND ROWNUM = 1),

Line 1859: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE(

1855: RAISE EGO_ORC_NO_STRUCTURE;
1856: END IF;
1857: l_hdr_source_sys_reference := l_xml_null_chk.getStringVal();
1858:
1859: INSERT INTO BOM_BILL_OF_MTLS_INTERFACE(
1860: transaction_id,
1861: batch_id,
1862: --source_system_id,
1863: source_system_reference,