DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on BOM_COMPONENT_OPS_INTERFACE

Line 7356: UPDATE BOM_COMPONENT_OPS_INTERFACE

7352: AND ( component_item_number = l_old_item_num_table(bom_ref_id_row_index) OR
7353: comp_source_system_reference = l_ss_ref_table(bom_ref_id_row_index));
7354:
7355: FORALL bom_comp_id_row_index IN 1..l_item_rows_processed
7356: UPDATE BOM_COMPONENT_OPS_INTERFACE
7357: SET assembly_item_number = l_item_num_table(bom_comp_id_row_index)
7358: WHERE process_flag = p_rec_status
7359: AND batch_id = l_xset_id
7360: AND ( assembly_item_number = l_old_item_num_table(bom_comp_id_row_index) OR

Line 7364: UPDATE BOM_COMPONENT_OPS_INTERFACE

7360: AND ( assembly_item_number = l_old_item_num_table(bom_comp_id_row_index) OR
7361: parent_source_system_reference = l_ss_ref_table(bom_comp_id_row_index));
7362:
7363: FORALL bom_comp_id_row_index IN 1..l_item_rows_processed
7364: UPDATE BOM_COMPONENT_OPS_INTERFACE
7365: SET component_item_number = l_item_num_table(bom_comp_id_row_index)
7366: WHERE process_flag = p_rec_status
7367: AND batch_id = l_xset_id
7368: AND ( component_item_number = l_old_item_num_table(bom_comp_id_row_index) OR