APPS.WMS_TASK_LOAD dependencies on DUAL

Line 896: FROM dual;

892:
893: IF p_serial_allocated_flag = 'Y' THEN
894: SELECT mtl_material_transactions_s.NEXTVAL
895: INTO l_serial_transaction_temp_id
896: FROM dual;
897: END IF;
898: END;
899:
900: IF (l_debug = 1) THEN

Line 1884: FROM DUAL;

1880: IF p_insert = 'Y' THEN
1881: l_progress := '110';
1882: SELECT mtl_material_transactions_s.NEXTVAL
1883: INTO l_new_transaction_temp_id
1884: FROM DUAL;
1885: x_new_transaction_temp_id := l_new_transaction_temp_id;
1886:
1887: mydebug(l_proc_name || ': l_new_transaction_temp_id = ' || l_new_transaction_temp_id);
1888:

Line 2795: FROM DUAL;

2791: l_mtlt_serial_temp_id := l_rec_mtlt_to_copy_from.serial_transaction_temp_id;
2792:
2793: SELECT mtl_material_transactions_s.NEXTVAL
2794: INTO l_serial_transaction_temp_id
2795: FROM DUAL;
2796: ELSE
2797: l_serial_transaction_temp_id := NULL;
2798: l_mtlt_serial_temp_id := NULL;
2799: END IF;

Line 4637: FROM DUAL;

4633:
4634: l_serial_transaction_temp_id := NULL;
4635: SELECT mtl_material_transactions_s.NEXTVAL
4636: INTO l_serial_transaction_temp_id
4637: FROM DUAL;
4638: mydebug('l_serial_transaction_temp_id .. ' || l_serial_transaction_temp_id);
4639: IF p_suggested_uom <> rec_mmtt1.item_primary_uom_code
4640: THEN
4641: l_suggested_mtlt_qty := inv_convert.inv_um_convert

Line 5512: FROM DUAL

5508: mydebug('l_progress = ' || l_progress);
5509: BEGIN
5510: SELECT 1
5511: INTO l_other_tasks
5512: FROM DUAL
5513: WHERE EXISTS(SELECT 1
5514: FROM mtl_material_transactions_temp
5515: WHERE transaction_header_id <> p_transaction_header_id
5516: AND transfer_lpn_id = rec_transfer_lpns.transfer_lpn_id);

Line 5570: FROM DUAL

5566: mydebug('l_progress = ' || l_progress);
5567: BEGIN
5568: SELECT 1
5569: INTO l_other_tasks
5570: FROM DUAL
5571: WHERE EXISTS(SELECT 1
5572: FROM mtl_material_transactions_temp
5573: WHERE transaction_header_id <> p_transaction_header_id
5574: AND content_lpn_id = rec_content_lpns.content_lpn_id);

Line 7167: FROM DUAL

7163:
7164:
7165: SELECT 1
7166: INTO l_loaded
7167: FROM DUAL
7168: WHERE EXISTS(SELECT 1
7169: FROM mtl_material_transactions_temp
7170: WHERE (transfer_lpn_id = p_fromlpn_id
7171: OR content_lpn_id = p_fromlpn_id));

Line 7362: FROM DUAL

7358:
7359: BEGIN
7360: SELECT 1
7361: INTO l_item_cnt
7362: FROM DUAL
7363: WHERE EXISTS(
7364: SELECT 1
7365: FROM wms_lpn_contents wlc
7366: WHERE wlc.parent_lpn_id = p_fromlpn_id

Line 7391: FROM DUAL

7387:
7388: BEGIN
7389: SELECT 1
7390: INTO l_item_cnt
7391: FROM DUAL
7392: WHERE EXISTS(
7393: SELECT 1
7394: FROM wms_lpn_contents wlc, mtl_transaction_lots_temp mtlt
7395: WHERE wlc.parent_lpn_id = p_fromlpn_id

Line 11117: from dual

11113: -- program can come to here which means the LPN is not pregenerated LPN
11114: BEGIN
11115: select 'N'
11116: into l_multiple_pick
11117: from dual
11118: where exists (select 1
11119: from mtl_material_transactions_temp
11120: where transfer_lpn_id = pick_to_lpn_rec.lpn_id
11121: and transaction_header_id <>l_transaction_header_id);

Line 11134: from dual

11130: ELSE -- regular task but maybe the lpn has contains bulk tasks
11131: BEGIN
11132: select 'Y'
11133: into l_bulk_task_exist
11134: from dual
11135: where exists (select 1
11136: from mtl_material_transactions_temp
11137: where transfer_lpn_id = pick_to_lpn_rec.lpn_id
11138: and transaction_temp_id = parent_line_id -- bulk task

Line 11300: FROM DUAL

11296: l_count := 0;
11297: BEGIN
11298: SELECT 1
11299: INTO l_count
11300: FROM DUAL
11301: WHERE EXISTS
11302: ( SELECT 'x'
11303: FROM mtl_material_transactions_temp mmtt
11304: , mtl_secondary_inventories msi

Line 11995: FROM DUAL;

11991: IF p_serial_transaction_temp_id IS NULL THEN
11992:
11993: SELECT mtl_material_transactions_s.NEXTVAL
11994: INTO p_serial_transaction_temp_id
11995: FROM DUAL;
11996:
11997: l_progress := '50';
11998:
11999: UPDATE mtl_transaction_lots_temp