DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 3858: UPDATE BOM_BILL_OF_MTLS_INTERFACE bbmi

3854: );
3855:
3856: Debug_Conc_Log('Validate_Timestamp_With_Prod: Updated MTL_ITEM_CATEGORIES_INTERFACE rowcount='||SQL%ROWCOUNT);
3857:
3858: UPDATE BOM_BILL_OF_MTLS_INTERFACE bbmi
3859: SET PROCESS_FLAG = 6,
3860: REQUEST_ID = l_request_id,
3861: PROGRAM_ID = l_prog_id,
3862: PROGRAM_APPLICATION_ID = l_prog_appid,

Line 3880: Debug_Conc_Log('Validate_Timestamp_With_Prod: Updated BOM_BILL_OF_MTLS_INTERFACE rowcount='||SQL%ROWCOUNT);

3876: AND eime.ORGANIZATION_ID = msii.ORGANIZATION_ID
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,

Line 5213: UPDATE BOM_BILL_OF_MTLS_INTERFACE

5209: AND SOURCE_SYSTEM_ID = p_ss_id
5210: AND ( ITEM_NUMBER = p_old_item_number OR SOURCE_SYSTEM_REFERENCE = p_ss_ref );
5211:
5212: -- propagating to BOM tables
5213: UPDATE BOM_BILL_OF_MTLS_INTERFACE
5214: SET ITEM_NUMBER = p_item_number
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 );

Line 5871: UPDATE BOM_BILL_OF_MTLS_INTERFACE bbmi

5867: AND mici.BUNDLE_ID = msii.BUNDLE_ID
5868: );
5869:
5870: Debug_Conc_Log('Validate_Timestamp_In_Batch: Updated MTL_ITEM_CATEGORIES_INTERFACE rowcount='||SQL%ROWCOUNT);
5871: UPDATE BOM_BILL_OF_MTLS_INTERFACE bbmi
5872: SET PROCESS_FLAG = 6,
5873: REQUEST_ID = l_request_id,
5874: PROGRAM_ID = l_prog_id,
5875: PROGRAM_APPLICATION_ID = l_prog_appid,

Line 5889: Debug_Conc_Log('Validate_Timestamp_In_Batch: Updated BOM_BILL_OF_MTLS_INTERFACE rowcount='||SQL%ROWCOUNT);

5885: AND bbmi.ORGANIZATION_ID = msii.ORGANIZATION_ID
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,