137: */
138: stmt_num := 2;
139: LOOP
140: UPDATE bom_bill_of_mtls_interface ori
141: SET transaction_id = mtl_system_items_interface_s.nextval,
142: transaction_type = upper(transaction_type),
143: bill_sequence_id = decode(upper(transaction_type), G_Insert,
144: bom_inventory_components_s.nextval,
145: bill_sequence_id)
286: nvl(c1rec.CB, user_id),
287: nvl(c1rec.LUL, user_id),
288: sysdate,
289: sysdate,
290: mtl_system_items_interface_s.nextval,
291: 2,
292: G_Insert,
293: req_id,
294: prog_appid,
572: nvl(c1rec.CB, user_id),
573: nvl(c1rec.LUL, user_id),
574: sysdate,
575: sysdate,
576: mtl_system_items_interface_s.nextval,
577: 2,
578: G_Insert,
579: req_id,
580: prog_appid,