152: */
153: stmt_num := 1;
154: LOOP
155: UPDATE bom_inventory_comps_interface
156: SET transaction_id = mtl_system_items_interface_s.nextval,
157: component_sequence_id = bom_inventory_components_s.nextval,
158: transaction_type = upper(transaction_type)
159: WHERE transaction_id is null
160: AND process_flag = 1
173: */
174: stmt_num := 1;
175: LOOP
176: UPDATE bom_inventory_comps_interface
177: SET transaction_id = mtl_system_items_interface_s.nextval,
178: transaction_type = upper(transaction_type)
179: WHERE transaction_id is null
180: AND process_flag = 1
181: AND upper(transaction_type) in (G_UPDATE, G_DELETE)