APPS.PO_VAL_SHIPMENTS2 dependencies on RCV_ROUTING_HEADERS

Line 1375: -- Validate that receiving routing id exists in rcv_routing_headers

1371: RAISE;
1372: END receive_close_tolerance;
1373:
1374: -------------------------------------------------------------------------
1375: -- Validate that receiving routing id exists in rcv_routing_headers
1376: -------------------------------------------------------------------------
1377: PROCEDURE receiving_routing_id(
1378: p_id_tbl IN po_tbl_number,
1379: p_shipment_type_tbl IN po_tbl_varchar30,

Line 1399: -- Validate that receiving routing id exists in rcv_routing_headers

1395: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);
1396: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1397: END IF;
1398:
1399: -- Validate that receiving routing id exists in rcv_routing_headers
1400: FORALL i IN 1 .. p_id_tbl.COUNT
1401: INSERT INTO po_validation_results_gt
1402: (result_set_id,
1403: result_type,

Line 1424: FROM rcv_routing_headers rrh

1420: FROM DUAL
1421: WHERE p_receiving_routing_id_tbl(i) IS NOT NULL
1422: AND p_shipment_type_tbl(i) = 'STANDARD'
1423: AND NOT EXISTS(SELECT 1
1424: FROM rcv_routing_headers rrh
1425: WHERE rrh.routing_header_id = p_receiving_routing_id_tbl(i));
1426:
1427: IF (SQL%ROWCOUNT > 0) THEN
1428: x_result_type := po_validations.c_result_type_failure;