815: END IF;
816: -- Get the next tag ID for this new record
817: SELECT mtl_physical_inventory_tags_s.nextval
818: INTO l_tag_id
819: FROM dual;
820: IF (l_debug = 1) THEN
821: print_debug('Dynamic tag ID: ' || l_tag_id);
822: END IF;
823:
1543:
1544: -- Get a valid adjustment ID for the new record
1545: SELECT mtl_physical_adjustments_s.NEXTVAL
1546: INTO l_adj_id
1547: FROM dual;
1548: IF (l_debug = 1) THEN
1549: print_debug('New adjustment ID: ' || l_adj_id);
1550: END IF;
1551:
2437: Mydebug(' Start Processing the Implicit Physical Inventory Xfer ');
2438: /*
2439: SELECT mtl_material_transactions_s.nextval
2440: INTO l_transaction_header_id
2441: FROM dual;
2442: */
2443: Mydebug(' l_transaction_header_id ..'||l_transaction_header_id);
2444:
2445:
2600: End;*/
2601:
2602: ELSE
2603:
2604: SELECT mtl_physical_adjustments_s.nextval INTO l_adj_id FROM dual;
2605:
2606: mydebug(' Creating a new adjustment : '||l_adj_id );
2607:
2608: SELECT NVL(process_enabled_flag, 'N')