DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on BOM_SUB_COMPS_INTERFACE

Line 7163: UPDATE BOM_SUB_COMPS_INTERFACE

7159: AND ( assembly_item_number = l_old_item_num_table(bom_par_id_row_index) OR
7160: parent_source_system_reference = l_ss_ref_table(bom_par_id_row_index));
7161:
7162: FORALL bom_sub_id_row_index IN 1..l_item_rows_processed
7163: UPDATE BOM_SUB_COMPS_INTERFACE
7164: SET assembly_item_number = l_item_num_table(bom_sub_id_row_index)
7165: WHERE process_flag = p_rec_status
7166: AND batch_id = l_xset_id
7167: AND ( assembly_item_number = l_old_item_num_table(bom_sub_id_row_index) OR

Line 7171: UPDATE BOM_SUB_COMPS_INTERFACE

7167: AND ( assembly_item_number = l_old_item_num_table(bom_sub_id_row_index) OR
7168: parent_source_system_reference = l_ss_ref_table(bom_sub_id_row_index));
7169:
7170: FORALL bom_sub_id_row_index IN 1..l_item_rows_processed
7171: UPDATE BOM_SUB_COMPS_INTERFACE
7172: SET component_item_number = l_item_num_table(bom_sub_id_row_index)
7173: WHERE process_flag = p_rec_status
7174: AND batch_id = l_xset_id
7175: AND ( component_item_number = l_old_item_num_table(bom_sub_id_row_index) OR

Line 7179: UPDATE BOM_SUB_COMPS_INTERFACE

7175: AND ( component_item_number = l_old_item_num_table(bom_sub_id_row_index) OR
7176: comp_source_system_reference = l_ss_ref_table(bom_sub_id_row_index));
7177:
7178: FORALL bom_sub_id_row_index IN 1..l_item_rows_processed
7179: UPDATE BOM_SUB_COMPS_INTERFACE
7180: SET substitute_comp_number = l_item_num_table(bom_sub_id_row_index)
7181: WHERE process_flag = p_rec_status
7182: AND batch_id = l_xset_id
7183: AND ( substitute_comp_number = l_old_item_num_table(bom_sub_id_row_index) OR