1563: IF (l_debug = 1) THEN
1564: mydebug('After calling get_temp_tables ');
1565: END IF;
1566:
1567: SELECT mtl_material_transactions_s.NEXTVAL
1568: INTO new_txn_header_id
1569: FROM DUAL;
1570:
1571: IF (l_debug = 1) THEN
1620: IF (l_debug = 1) THEN
1621: mydebug(' source and destination sub location are not same ');
1622: END IF;
1623:
1624: SELECT mtl_material_transactions_s.NEXTVAL
1625: INTO new_txn_temp_id
1626: FROM DUAL;
1627:
1628: IF (l_debug = 1) THEN
2044: RAISE g_qty_not_avail;
2045: END IF;
2046:
2047: /**2706001 moved this out of below loop **/
2048: SELECT mtl_material_transactions_s.NEXTVAL
2049: INTO ser_transaction_temp_id
2050: FROM dual;
2051:
2052: /**2706001 was using cnt6 earlier **/