APPS.BOMPASGR dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 187: set transaction_id = mtl_system_items_interface_s.nextval

183: ** assign transaction ids to all rows first
184: */
185: loop
186: update mtl_rtg_item_revs_interface
187: set transaction_id = mtl_system_items_interface_s.nextval
188: where transaction_id is null
189: and process_flag = 1
190: and rownum < 500;
191: EXIT when SQL%NOTFOUND;

Line 381: set transaction_id = mtl_system_items_interface_s.nextval,

377: */
378: stmt_num := 1;
379: loop
380: update bom_op_routings_interface ori
381: set transaction_id = mtl_system_items_interface_s.nextval,
382: routing_sequence_id = nvl(routing_sequence_id,
383: bom_operational_routings_s.nextval)
384: where transaction_id is null
385: and process_flag = 1

Line 561: mtl_system_items_interface_s.nextval);

557: prog_id,
558: sysdate,
559: sysdate,
560: sysdate,
561: mtl_system_items_interface_s.nextval);
562: goto update_rtg;
563: else
564: select starting_revision into c1rec.PR
565: from mtl_parameters

Line 624: mtl_system_items_interface_s.nextval);

620: prog_id,
621: sysdate,
622: sysdate,
623: sysdate,
624: mtl_system_items_interface_s.nextval);
625: end if;
626:
627: /*
628: ** update bom_op_routings_interface with the modified column values

Line 873: set transaction_id = mtl_system_items_interface_s.nextval,

869: ** assign transaction ids to all rows first
870: */
871: loop
872: update bom_op_sequences_interface
873: set transaction_id = mtl_system_items_interface_s.nextval,
874: operation_sequence_id = nvl(operation_sequence_id,
875: bom_operation_sequences_s.nextval)
876: where transaction_id is null
877: and process_flag = 1

Line 1579: set transaction_id = mtl_system_items_interface_s.nextval

1575: */
1576: stmt_num := 3;
1577: loop
1578: update bom_op_resources_interface
1579: set transaction_id = mtl_system_items_interface_s.nextval
1580: where transaction_id is null
1581: and process_flag = 1
1582: and rownum < 500;
1583: EXIT when SQL%NOTFOUND;

Line 2062: select mtl_system_items_interface_s.nextval

2058:
2059: while continue_loop loop
2060: for c3rec in c3 loop
2061: commit_cnt := commit_cnt + 1;
2062: select mtl_system_items_interface_s.nextval
2063: into dummy_txn
2064: from sys.dual;
2065:
2066: update bom_op_resources_interface