APPS.INV_RCV_COMMON_APIS dependencies on DUAL

Line 77: FROM DUAL;

73:
74: IF g_rcv_global_var.transaction_header_id IS NULL THEN
75: SELECT mtl_material_transactions_s.NEXTVAL
76: INTO g_rcv_global_var.transaction_header_id
77: FROM DUAL;
78: END IF;
79:
80: gen_txn_group_id;
81:

Line 1216: FROM DUAL;

1212: l_mtlt_rec.secondary_quantity := l_new_secondary_quantity;
1213:
1214: SELECT mtl_material_transactions_s.NEXTVAL
1215: INTO l_mtlt_rec.serial_transaction_temp_id
1216: FROM DUAL;
1217:
1218: l_mtlt_rec.transaction_quantity := l_transaction_quantity * l_new_primary_quantity / l_primary_quantity;
1219: insert_mtlt(l_mtlt_rec); -- insert one line with new quantity and new txn_id
1220: l_tran_rec_tb(1).transaction_id := l_mtlt_rec.serial_transaction_temp_id;

Line 2882: FROM DUAL

2878: l_lpn_loaded := 0;
2879: BEGIN
2880: SELECT 1
2881: INTO l_lpn_loaded
2882: FROM DUAL
2883: WHERE EXISTS(
2884: SELECT 1
2885: FROM wms_dispatched_tasks wdt, mtl_txn_request_lines mtrl
2886: WHERE wdt.move_order_line_id = mtrl.line_id

Line 2933: FROM DUAL

2929: IF l_restrict_sub_code = 1 THEN -- item restricted to predefined subs
2930: BEGIN
2931: SELECT 1
2932: INTO l_dummy
2933: FROM DUAL
2934: WHERE EXISTS(
2935: SELECT 1
2936: FROM mtl_item_sub_inventories mis
2937: WHERE mis.organization_id = p_organization_id

Line 2956: FROM DUAL

2952: ELSE -- item not under subinventory restrictions.
2953: BEGIN
2954: SELECT 1
2955: INTO l_dummy
2956: FROM DUAL
2957: WHERE EXISTS(
2958: SELECT 1
2959: FROM mtl_secondary_inventories msi
2960: WHERE msi.organization_id = p_organization_id

Line 2985: FROM DUAL

2981: -- item under restricted locator control
2982: BEGIN
2983: SELECT 1
2984: INTO l_dummy
2985: FROM DUAL
2986: WHERE EXISTS(
2987: SELECT 1
2988: FROM mtl_secondary_locators msl
2989: WHERE msl.organization_id = p_organization_id

Line 3021: FROM DUAL

3017: ELSE -- item not under restricted locator control
3018: BEGIN
3019: SELECT 1
3020: INTO l_dummy
3021: FROM DUAL
3022: WHERE EXISTS(
3023: SELECT 1
3024: FROM mtl_item_locations mil
3025: WHERE mil.organization_id = p_organization_id

Line 3265: FROM DUAL;

3261: ELSE
3262: IF p_transaction_temp_id IS NULL THEN
3263: SELECT mtl_material_transactions_s.NEXTVAL
3264: INTO p_transaction_temp_id
3265: FROM DUAL;
3266: END IF;
3267:
3268: l_progress := '20';
3269: l_return :=

Line 3414: FROM DUAL;

3410: l_progress := '40';
3411:
3412: SELECT mtl_material_transactions_s.NEXTVAL
3413: INTO p_serial_transaction_temp_id
3414: FROM DUAL;
3415:
3416: l_progress := '50';
3417: END IF;
3418:

Line 4366: FROM dual

4362: IF p_document_type = 'INTSHIP' THEN
4363: BEGIN
4364: SELECT 'Y'
4365: INTO l_rcvreq_use_intship
4366: FROM dual
4367: WHERE EXISTS ( SELECT 1
4368: FROM rcv_shipment_lines
4369: WHERE shipment_header_id = l_shipment_header_id
4370: AND requisition_line_id IS NOT NULL

Line 5219: FROM DUAL

5215:
5216: BEGIN
5217: SELECT '1'
5218: INTO l_txn_cnt
5219: FROM DUAL
5220: WHERE EXISTS(
5221: SELECT '1'
5222: FROM mtl_serial_numbers
5223: WHERE inventory_item_id = p_inventory_item_id

Line 5606: FROM DUAL;

5602: BEGIN
5603: IF g_rcv_global_var.interface_group_id IS NULL THEN
5604: SELECT rcv_interface_groups_s.NEXTVAL
5605: INTO g_rcv_global_var.interface_group_id
5606: FROM DUAL;
5607: END IF;
5608: END gen_txn_group_id;
5609:
5610: PROCEDURE validate_trx_date(