DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on BOM_COMPONENT_OPS_INTERFACE

Line 7203: UPDATE BOM_COMPONENT_OPS_INTERFACE

7199: AND ( component_item_number = l_old_item_num_table(bom_ref_id_row_index) OR
7200: comp_source_system_reference = l_ss_ref_table(bom_ref_id_row_index));
7201:
7202: FORALL bom_comp_id_row_index IN 1..l_item_rows_processed
7203: UPDATE BOM_COMPONENT_OPS_INTERFACE
7204: SET assembly_item_number = l_item_num_table(bom_comp_id_row_index)
7205: WHERE process_flag = p_rec_status
7206: AND batch_id = l_xset_id
7207: AND ( assembly_item_number = l_old_item_num_table(bom_comp_id_row_index) OR

Line 7211: UPDATE BOM_COMPONENT_OPS_INTERFACE

7207: AND ( assembly_item_number = l_old_item_num_table(bom_comp_id_row_index) OR
7208: parent_source_system_reference = l_ss_ref_table(bom_comp_id_row_index));
7209:
7210: FORALL bom_comp_id_row_index IN 1..l_item_rows_processed
7211: UPDATE BOM_COMPONENT_OPS_INTERFACE
7212: SET component_item_number = l_item_num_table(bom_comp_id_row_index)
7213: WHERE process_flag = p_rec_status
7214: AND batch_id = l_xset_id
7215: AND ( component_item_number = l_old_item_num_table(bom_comp_id_row_index) OR