APPS.EGO_IMPORT_UTIL_PVT dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 3881: UPDATE BOM_INVENTORY_COMPS_INTERFACE bici

3877: AND eime.LAST_MESSAGE_TIMESTAMP > msii.MESSAGE_TIMESTAMP
3878: );
3879:
3880: Debug_Conc_Log('Validate_Timestamp_With_Prod: Updated BOM_BILL_OF_MTLS_INTERFACE rowcount='||SQL%ROWCOUNT);
3881: UPDATE BOM_INVENTORY_COMPS_INTERFACE bici
3882: SET PROCESS_FLAG = 6,
3883: REQUEST_ID = l_request_id,
3884: PROGRAM_ID = l_prog_id,
3885: PROGRAM_APPLICATION_ID = l_prog_appid,

Line 3902: Debug_Conc_Log('Validate_Timestamp_With_Prod: Updated BOM_INVENTORY_COMPS_INTERFACE rowcount='||SQL%ROWCOUNT);

3898: AND eime.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
3899: AND eime.ORGANIZATION_ID = msii.ORGANIZATION_ID
3900: AND eime.LAST_MESSAGE_TIMESTAMP > msii.MESSAGE_TIMESTAMP
3901: );
3902: Debug_Conc_Log('Validate_Timestamp_With_Prod: Updated BOM_INVENTORY_COMPS_INTERFACE rowcount='||SQL%ROWCOUNT);
3903:
3904: RETCODE := '0';
3905: ERRBUF := NULL;
3906: Debug_Conc_Log('Validate_Timestamp_With_Prod: Done Successfully');

Line 5219: UPDATE BOM_INVENTORY_COMPS_INTERFACE

5215: WHERE PROCESS_FLAG = 1
5216: AND BATCH_ID = p_batch_id
5217: AND ( ITEM_NUMBER = p_old_item_number OR SOURCE_SYSTEM_REFERENCE = p_ss_ref );
5218:
5219: UPDATE BOM_INVENTORY_COMPS_INTERFACE
5220: SET COMPONENT_ITEM_NUMBER = p_item_number
5221: WHERE PROCESS_FLAG = 1
5222: AND BATCH_ID = p_batch_id
5223: AND ( COMPONENT_ITEM_NUMBER = p_old_item_number OR COMP_SOURCE_SYSTEM_REFERENCE = p_ss_ref );

Line 5225: UPDATE BOM_INVENTORY_COMPS_INTERFACE

5221: WHERE PROCESS_FLAG = 1
5222: AND BATCH_ID = p_batch_id
5223: AND ( COMPONENT_ITEM_NUMBER = p_old_item_number OR COMP_SOURCE_SYSTEM_REFERENCE = p_ss_ref );
5224:
5225: UPDATE BOM_INVENTORY_COMPS_INTERFACE
5226: SET ASSEMBLY_ITEM_NUMBER = p_item_number
5227: WHERE PROCESS_FLAG = 1
5228: AND BATCH_ID = p_batch_id
5229: AND ( ASSEMBLY_ITEM_NUMBER = p_old_item_number OR PARENT_SOURCE_SYSTEM_REFERENCE = p_ss_ref );

Line 5890: UPDATE BOM_INVENTORY_COMPS_INTERFACE bici

5886: AND bbmi.BUNDLE_ID = msii.BUNDLE_ID
5887: );
5888:
5889: Debug_Conc_Log('Validate_Timestamp_In_Batch: Updated BOM_BILL_OF_MTLS_INTERFACE rowcount='||SQL%ROWCOUNT);
5890: UPDATE BOM_INVENTORY_COMPS_INTERFACE bici
5891: SET PROCESS_FLAG = 6,
5892: REQUEST_ID = l_request_id,
5893: PROGRAM_ID = l_prog_id,
5894: PROGRAM_APPLICATION_ID = l_prog_appid,

Line 5908: Debug_Conc_Log('Validate_Timestamp_In_Batch: Updated BOM_INVENTORY_COMPS_INTERFACE rowcount='||SQL%ROWCOUNT);

5904: AND bici.ORGANIZATION_ID = msii.ORGANIZATION_ID
5905: AND bici.BUNDLE_ID = msii.BUNDLE_ID
5906: );
5907:
5908: Debug_Conc_Log('Validate_Timestamp_In_Batch: Updated BOM_INVENTORY_COMPS_INTERFACE rowcount='||SQL%ROWCOUNT);
5909:
5910: UPDATE MTL_SYSTEM_ITEMS_INTERFACE msii
5911: SET PROCESS_FLAG = 6,
5912: REQUEST_ID = l_request_id,