APPS.WMS_WIP_XDOCK_PVT dependencies on DUAL

Line 16: FROM DUAL;

12: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13: BEGIN
14: SELECT TO_CHAR(SYSDATE, 'MM/DD/YYYY HH:MM:SS')
15: INTO l_ts
16: FROM DUAL;
17:
18: l_msg := l_ts || ' ' || msg;
19:
20: IF (g_header_printed = FALSE) THEN

Line 140: FROM DUAL

136:
137: BEGIN
138: SELECT 1
139: INTO l_count
140: FROM DUAL
141: WHERE EXISTS(
142: SELECT 1
143: FROM wip_material_shortages_v b, mtl_txn_request_lines l
144: WHERE l.lpn_id = l_lpn_id

Line 167: FROM DUAL

163: -- Checking to see if material is rejected
164: BEGIN
165: SELECT 1
166: INTO l_insp_cnt
167: FROM DUAL
168: WHERE EXISTS(
169: SELECT 1
170: FROM mtl_txn_request_lines
171: WHERE lpn_id = l_lpn_id

Line 978: FROM dual;

974: -- Need to create a new MMTT line and call TM here!
975: /*
976: SELECT mtl_material_transactions_s.NEXTVAL
977: INTO l_new_temp_id
978: FROM dual;
979:
980: SELECT mtl_material_transactions_s.NEXTVAL
981: INTO l_new_txn_hdr_id
982: FROM dual;

Line 982: FROM dual;

978: FROM dual;
979:
980: SELECT mtl_material_transactions_s.NEXTVAL
981: INTO l_new_txn_hdr_id
982: FROM dual;
983: */
984:
985: --mydebug('l_new_temp_id = ' || l_new_temp_id);
986: BEGIN

Line 1424: FROM DUAL;

1420: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1421: BEGIN
1422: SELECT mtl_material_transactions_s.NEXTVAL
1423: INTO new_txn_temp_id
1424: FROM DUAL;
1425:
1426: x_new_temp_id := new_txn_temp_id;
1427:
1428: SELECT mtl_material_transactions_s.NEXTVAL

Line 1430: FROM DUAL;

1426: x_new_temp_id := new_txn_temp_id;
1427:
1428: SELECT mtl_material_transactions_s.NEXTVAL
1429: INTO l_new_txn_hdr_id
1430: FROM DUAL;
1431:
1432: x_new_hdr_id := l_new_txn_hdr_id;
1433:
1434: SELECT *

Line 1571: FROM DUAL;

1567: END IF;
1568:
1569: SELECT mtl_material_transactions_s.NEXTVAL
1570: INTO ser_transaction_temp_id
1571: FROM DUAL;
1572:
1573: OPEN msnt(lot_row.serial_transaction_temp_id);
1574:
1575: LOOP

Line 1587: FROM DUAL;

1583: END IF;
1584:
1585: SELECT mtl_material_transactions_s.NEXTVAL
1586: INTO ser_row.transaction_temp_id
1587: FROM DUAL;
1588:
1589: ser_row.transaction_temp_id := ser_transaction_temp_id;
1590: inv_rcv_common_apis.insert_msnt(ser_row);
1591: /* Swapped the stmts, so that serial_transaction_temp_id is