2107: IF (l_debug = 1) THEN
2108: mydebug('Fetched Serials,count:'||l_ser_num_tab.COUNT);
2109: END IF;
2110:
2111: SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_id FROM DUAL;
2112:
2113: IF (l_debug = 1) THEN
2114: mydebug('new txn id :'||l_new_txn_id);
2115: END IF;
2176: IF (l_debug = 1) THEN
2177: mydebug('Fetched Serials,count:'||l_ser_num_tab.COUNT);
2178: END IF;
2179:
2180: SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_id FROM DUAL;
2181: IF (l_debug = 1) THEN
2182: mydebug('new txn id :'||l_new_txn_id);
2183: END IF;
2184:
2262: IF (l_debug = 1) THEN
2263: mydebug('Fetched Serials,count:'||l_ser_num_tab.COUNT);
2264: END IF;
2265:
2266: SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_id FROM DUAL;
2267: IF (l_debug = 1) THEN
2268: mydebug('new txn id :'||l_new_txn_id);
2269: END IF;
2270:
2336: IF (l_debug = 1) THEN
2337: mydebug('Fetched Serials,count:'||l_ser_num_tab.COUNT);
2338: END IF;
2339:
2340: SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_id FROM DUAL;
2341: IF (l_debug = 1) THEN
2342: mydebug('new txn id :'||l_new_txn_id);
2343: END IF;
2344: