APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 4227: INSERT INTO bom_inventory_comps_interface

4223: END;
4224: Write_Debug('l_component_seq_id: ' || to_char(l_component_seq_id));
4225:
4226: Write_Debug('Inserting data into interface tables:');
4227: INSERT INTO bom_inventory_comps_interface
4228: (OPERATION_SEQ_NUM,
4229: COMPONENT_ITEM_ID,
4230: EFFECTIVITY_DATE,
4231: OLD_COMPONENT_SEQUENCE_ID,

Line 4883: UPDATE bom_inventory_comps_interface

4879: -----------------------------------------------------------------------------------------
4880: Write_Debug('Updating Bom Components Interface records for Create... ' );
4881: -- (a) Components: CREATE
4882: -----------------------------------------------------------------------------------------
4883: UPDATE bom_inventory_comps_interface
4884: SET
4885: acd_type = G_BOM_ADD_ACD_TYPE,
4886: change_transaction_type = 'CREATE',
4887: change_notice = p_change_notice,

Line 4931: UPDATE bom_inventory_comps_interface bici

4927: -----------------------------------------------------------------------------------------
4928: Write_Debug('Deleting/Updating Component Interface records for Create(Not present in ECO)... ' );
4929: -- (a) Components: DELETE/UPDATE: NOT already present in ECO
4930: -----------------------------------------------------------------------------------------
4931: UPDATE bom_inventory_comps_interface bici
4932: SET
4933: acd_type = decode(transaction_type, 'DELETE', G_BOM_DISABLE_ACD_TYPE, G_BOM_CHANGE_ACD_TYPE),
4934: change_transaction_type = 'CREATE',
4935: revised_item_sequence_id = p_revised_item_sequence_id,

Line 4984: UPDATE bom_inventory_comps_interface bici

4980: Write_Debug('Deleting/Updating Component Interface records for Create(Present in ECO)... ' );
4981: -- (b) Components: DELETE/UPDATE: already present in ECO
4982: -----------------------------------------------------------------------------------------
4983:
4984: UPDATE bom_inventory_comps_interface bici
4985: SET
4986: acd_type = decode(transaction_type, 'DELETE', G_BOM_DISABLE_ACD_TYPE,
4987: (SELECT bic.acd_type
4988: FROM bom_inventory_components bic