APPS.INV_RCV_INTEGRATION_APIS dependencies on DUAL

Line 558: FROM sys.dual;

554: --Generate transaction_interface_id if the parameter is NULL
555: IF (p_transaction_interface_id IS NULL) THEN
556: SELECT mtl_material_transactions_s.NEXTVAL
557: INTO l_transaction_interface_id
558: FROM sys.dual;
559: ELSE
560: l_transaction_interface_id := p_transaction_interface_id;
561: END IF;
562:

Line 568: FROM sys.DUAL;

564:
565: IF l_serial_control_code not in (1,6) THEN -- Bug 9008016
566: SELECT mtl_material_transactions_s.NEXTVAL
567: INTO l_serial_transaction_temp_id
568: FROM sys.DUAL;
569: ELSE
570: l_serial_transaction_temp_id := NULL;
571: END IF;
572:

Line 577: FROM sys.dual;

573: --Generate production_transaction_id if the parameter is NULL
574: IF (p_product_transaction_id IS NULL) THEN
575: SELECT rcv_transactions_interface_s.NEXTVAL
576: INTO l_product_transaction_id
577: FROM sys.dual;
578: ELSE
579: l_product_transaction_id := p_product_transaction_id;
580: END IF;
581:

Line 1436: FROM sys.dual;

1432: --Generate transaction_interface_id if necessary
1433: IF (p_transaction_interface_id IS NULL) THEN
1434: SELECT mtl_material_transactions_s.NEXTVAL
1435: INTO l_transaction_interface_id
1436: FROM sys.dual;
1437: ELSE
1438: l_transaction_interface_id := p_transaction_interface_id;
1439: END IF;
1440:

Line 1445: FROM sys.dual;

1441: --Generate production_transaction_id if the parameter is NULL
1442: IF (p_product_transaction_id IS NULL AND p_product_code = 'RCV') THEN
1443: SELECT rcv_transactions_interface_s.NEXTVAL
1444: INTO l_product_transaction_id
1445: FROM sys.dual;
1446: ELSE
1447: l_product_transaction_id := p_product_transaction_id;
1448: END IF;
1449:

Line 2096: FROM DUAL;

2092: END IF;
2093:
2094: SELECT SYSDATE + l_shelf_life_days
2095: INTO l_expiration_date
2096: FROM DUAL;
2097:
2098: IF TRUNC(l_expiration_date) <> trunc(p_expiration_date) THEN
2099: fnd_message.set_name('INV', 'INV_EXP_DATE_NOT_CONSIDER');
2100: fnd_msg_pub.ADD;

Line 2844: FROM dual

2840: /*
2841: BEGIN
2842: SELECT 1
2843: INTO l_exist
2844: FROM dual
2845: WHERE exists (SELECT 1
2846: FROM rcv_transactions_interface
2847: WHERE group_id = p_group_id
2848: AND item_id is null

Line 3095: FROM dual

3091: --BUG 3633752: Break up the query below. This is made
3092: --to improve performance
3093: SELECT 1
3094: INTO l_exist
3095: FROM dual
3096: WHERE exists (SELECT '1'
3097: FROM rcv_supply rs, wms_license_plate_numbers wlpn
3098: WHERE wlpn.lpn_id = l_lpn_id
3099: AND wlpn.lpn_id = rs.lpn_id

Line 3104: FROM dual

3100: AND rs.location_id <> l_location_id);
3101: ELSE
3102: SELECT 1
3103: INTO l_exist
3104: FROM dual
3105: WHERE exists (SELECT '1'
3106: FROM rcv_supply rs, wms_license_plate_numbers wlpn
3107: WHERE wlpn.license_plate_number = l_lpn_num
3108: AND wlpn.lpn_id = rs.lpn_id

Line 5099: FROM dual;

5095:
5096: BEGIN
5097: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
5098: INTO l_new_mol_rec.line_id
5099: FROM dual;
5100:
5101: INSERT INTO mtl_txn_request_lines
5102: (
5103: LINE_ID