DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on BOM_SUB_COMPS_INTERFACE

Line 7316: UPDATE BOM_SUB_COMPS_INTERFACE

7312: AND ( assembly_item_number = l_old_item_num_table(bom_par_id_row_index) OR
7313: parent_source_system_reference = l_ss_ref_table(bom_par_id_row_index));
7314:
7315: FORALL bom_sub_id_row_index IN 1..l_item_rows_processed
7316: UPDATE BOM_SUB_COMPS_INTERFACE
7317: SET assembly_item_number = l_item_num_table(bom_sub_id_row_index)
7318: WHERE process_flag = p_rec_status
7319: AND batch_id = l_xset_id
7320: AND ( assembly_item_number = l_old_item_num_table(bom_sub_id_row_index) OR

Line 7324: UPDATE BOM_SUB_COMPS_INTERFACE

7320: AND ( assembly_item_number = l_old_item_num_table(bom_sub_id_row_index) OR
7321: parent_source_system_reference = l_ss_ref_table(bom_sub_id_row_index));
7322:
7323: FORALL bom_sub_id_row_index IN 1..l_item_rows_processed
7324: UPDATE BOM_SUB_COMPS_INTERFACE
7325: SET component_item_number = l_item_num_table(bom_sub_id_row_index)
7326: WHERE process_flag = p_rec_status
7327: AND batch_id = l_xset_id
7328: AND ( component_item_number = l_old_item_num_table(bom_sub_id_row_index) OR

Line 7332: UPDATE BOM_SUB_COMPS_INTERFACE

7328: AND ( component_item_number = l_old_item_num_table(bom_sub_id_row_index) OR
7329: comp_source_system_reference = l_ss_ref_table(bom_sub_id_row_index));
7330:
7331: FORALL bom_sub_id_row_index IN 1..l_item_rows_processed
7332: UPDATE BOM_SUB_COMPS_INTERFACE
7333: SET substitute_comp_number = l_item_num_table(bom_sub_id_row_index)
7334: WHERE process_flag = p_rec_status
7335: AND batch_id = l_xset_id
7336: AND ( substitute_comp_number = l_old_item_num_table(bom_sub_id_row_index) OR