APPS.WMS_CROSS_DOCK_PVT dependencies on DUAL

Line 21: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;

17: l_ts VARCHAR2(30);
18: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
19: BEGIN
20:
21: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
22: l_msg:=l_ts||' '||msg;
23:
24:
25: inv_mobile_helper_functions.tracelog

Line 271: -- TODO: how to handle the dual maintainance: break it or add version

267: -- {{********************** check_crossdock ************************************}}
268: --
269:
270: -- original procedure name is 'crossdock'. add new procedure 'check_crossdock'
271: -- TODO: how to handle the dual maintainance: break it or add version
272:
273: PROCEDURE crossdock
274: (p_org_id IN NUMBER ,
275: p_lpn IN NUMBER ,

Line 2111: SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_id FROM DUAL;

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;

Line 2180: SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_id FROM DUAL;

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:

Line 2266: SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_id FROM DUAL;

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:

Line 2340: SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_id FROM DUAL;

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: