APPS.EGO_IMPORT_UTIL_PVT dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 4084: UPDATE BOM_INVENTORY_COMPS_INTERFACE bici

4080: AND eime.LAST_MESSAGE_TIMESTAMP > msii.MESSAGE_TIMESTAMP
4081: );
4082:
4083: Debug_Conc_Log('Validate_Timestamp_With_Prod: Updated BOM_BILL_OF_MTLS_INTERFACE rowcount='||SQL%ROWCOUNT);
4084: UPDATE BOM_INVENTORY_COMPS_INTERFACE bici
4085: SET PROCESS_FLAG = 6,
4086: REQUEST_ID = l_request_id,
4087: PROGRAM_ID = l_prog_id,
4088: PROGRAM_APPLICATION_ID = l_prog_appid,

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

4101: AND eime.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
4102: AND eime.ORGANIZATION_ID = msii.ORGANIZATION_ID
4103: AND eime.LAST_MESSAGE_TIMESTAMP > msii.MESSAGE_TIMESTAMP
4104: );
4105: Debug_Conc_Log('Validate_Timestamp_With_Prod: Updated BOM_INVENTORY_COMPS_INTERFACE rowcount='||SQL%ROWCOUNT);
4106:
4107: RETCODE := '0';
4108: ERRBUF := NULL;
4109: Debug_Conc_Log('Validate_Timestamp_With_Prod: Done Successfully');

Line 6003: UPDATE BOM_INVENTORY_COMPS_INTERFACE

5999: WHERE PROCESS_FLAG = 1
6000: AND BATCH_ID = p_batch_id
6001: AND ( ITEM_NUMBER = p_old_item_number OR SOURCE_SYSTEM_REFERENCE = p_ss_ref );
6002:
6003: UPDATE BOM_INVENTORY_COMPS_INTERFACE
6004: SET COMPONENT_ITEM_NUMBER = p_item_number
6005: WHERE PROCESS_FLAG = 1
6006: AND BATCH_ID = p_batch_id
6007: AND ( COMPONENT_ITEM_NUMBER = p_old_item_number OR COMP_SOURCE_SYSTEM_REFERENCE = p_ss_ref );

Line 6009: UPDATE BOM_INVENTORY_COMPS_INTERFACE

6005: WHERE PROCESS_FLAG = 1
6006: AND BATCH_ID = p_batch_id
6007: AND ( COMPONENT_ITEM_NUMBER = p_old_item_number OR COMP_SOURCE_SYSTEM_REFERENCE = p_ss_ref );
6008:
6009: UPDATE BOM_INVENTORY_COMPS_INTERFACE
6010: SET ASSEMBLY_ITEM_NUMBER = p_item_number
6011: WHERE PROCESS_FLAG = 1
6012: AND BATCH_ID = p_batch_id
6013: AND ( ASSEMBLY_ITEM_NUMBER = p_old_item_number OR PARENT_SOURCE_SYSTEM_REFERENCE = p_ss_ref );

Line 6674: UPDATE BOM_INVENTORY_COMPS_INTERFACE bici

6670: AND bbmi.BUNDLE_ID = msii.BUNDLE_ID
6671: );
6672:
6673: Debug_Conc_Log('Validate_Timestamp_In_Batch: Updated BOM_BILL_OF_MTLS_INTERFACE rowcount='||SQL%ROWCOUNT);
6674: UPDATE BOM_INVENTORY_COMPS_INTERFACE bici
6675: SET PROCESS_FLAG = 6,
6676: REQUEST_ID = l_request_id,
6677: PROGRAM_ID = l_prog_id,
6678: PROGRAM_APPLICATION_ID = l_prog_appid,

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

6688: AND bici.ORGANIZATION_ID = msii.ORGANIZATION_ID
6689: AND bici.BUNDLE_ID = msii.BUNDLE_ID
6690: );
6691:
6692: Debug_Conc_Log('Validate_Timestamp_In_Batch: Updated BOM_INVENTORY_COMPS_INTERFACE rowcount='||SQL%ROWCOUNT);
6693:
6694: UPDATE MTL_SYSTEM_ITEMS_INTERFACE msii
6695: SET PROCESS_FLAG = 6,
6696: REQUEST_ID = l_request_id,

Line 7047: delete FROM BOM_INVENTORY_COMPS_INTERFACE A

7043: Debug_Conc_Log('Duplicates exist');
7044:
7045: -- Duplicates exist so we go to BOM tables and delete as otherwise the Structure Import will fail due to duplicate structures in the interface table
7046:
7047: delete FROM BOM_INVENTORY_COMPS_INTERFACE A
7048: WHERE exists (SELECT 'x' FROM BOM_INVENTORY_COMPS_INTERFACE B
7049: WHERE
7050: B.PARENT_SOURCE_SYSTEM_REFERENCE = A.PARENT_SOURCE_SYSTEM_REFERENCE
7051: and B.COMP_SOURCE_SYSTEM_REFERENCE = A.COMP_SOURCE_SYSTEM_REFERENCE

Line 7048: WHERE exists (SELECT 'x' FROM BOM_INVENTORY_COMPS_INTERFACE B

7044:
7045: -- Duplicates exist so we go to BOM tables and delete as otherwise the Structure Import will fail due to duplicate structures in the interface table
7046:
7047: delete FROM BOM_INVENTORY_COMPS_INTERFACE A
7048: WHERE exists (SELECT 'x' FROM BOM_INVENTORY_COMPS_INTERFACE B
7049: WHERE
7050: B.PARENT_SOURCE_SYSTEM_REFERENCE = A.PARENT_SOURCE_SYSTEM_REFERENCE
7051: and B.COMP_SOURCE_SYSTEM_REFERENCE = A.COMP_SOURCE_SYSTEM_REFERENCE
7052: and