APPS.WMS_CONTAINER2_PUB dependencies on DUAL

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

11: l_ts VARCHAR2(30);
12: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13: BEGIN
14:
15: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
16: l_msg:=l_ts||' '||msg;
17:
18:
19: inv_mobile_helper_functions.tracelog

Line 53: FROM DUAL

49: l_lpn_contents_exist VARCHAR2(20);
50: l_lpn_serial_contents_exist VARCHAR2(20);
51: CURSOR c_lpn IS
52: SELECT 'Check for empty LPN'
53: FROM DUAL
54: WHERE EXISTS
55: (SELECT 'Child LPN'
56: FROM WMS_LICENSE_PLATE_NUMBERS
57: WHERE parent_lpn_id = p_lpn_id);

Line 60: FROM DUAL

56: FROM WMS_LICENSE_PLATE_NUMBERS
57: WHERE parent_lpn_id = p_lpn_id);
58: CURSOR c_lpn_contents IS
59: SELECT 'Check for empty LPN'
60: FROM DUAL
61: WHERE EXISTS
62: (SELECT 'Non serialized items'
63: FROM WMS_LPN_CONTENTS
64: WHERE parent_lpn_id = p_lpn_id);

Line 67: FROM DUAL

63: FROM WMS_LPN_CONTENTS
64: WHERE parent_lpn_id = p_lpn_id);
65: CURSOR c_lpn_serial_contents IS
66: SELECT 'Check for empty LPN'
67: FROM DUAL
68: WHERE EXISTS
69: (SELECT 'Serialized items'
70: FROM MTL_SERIAL_NUMBERS
71: WHERE lpn_id = p_lpn_id);

Line 1769: FROM dual

1765: child_lpns_rec child_lpns_cursor%ROWTYPE;
1766:
1767: CURSOR delivery_detail_cursor(l_lpn_id IN NUMBER) IS
1768: SELECT 'x'
1769: FROM dual
1770: WHERE EXISTS (
1771: SELECT 'x'
1772: FROM wsh_delivery_details
1773: WHERE lpn_id = l_lpn_id