APPS.PO_VAL_SHIPMENTS2 dependencies on RCV_ROUTING_HEADERS

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

1735: RAISE;
1736: END receive_close_tolerance;
1737:
1738: -------------------------------------------------------------------------
1739: -- Validate that receiving routing id exists in rcv_routing_headers
1740: -------------------------------------------------------------------------
1741: PROCEDURE receiving_routing_id(
1742: p_id_tbl IN po_tbl_number,
1743: p_shipment_type_tbl IN po_tbl_varchar30,

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

1759: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);
1760: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1761: END IF;
1762:
1763: -- Validate that receiving routing id exists in rcv_routing_headers
1764: FORALL i IN 1 .. p_id_tbl.COUNT
1765: INSERT INTO po_validation_results_gt
1766: (result_set_id,
1767: result_type,

Line 1788: FROM rcv_routing_headers rrh

1784: FROM DUAL
1785: WHERE p_receiving_routing_id_tbl(i) IS NOT NULL
1786: AND p_shipment_type_tbl(i) = 'STANDARD'
1787: AND NOT EXISTS(SELECT 1
1788: FROM rcv_routing_headers rrh
1789: WHERE rrh.routing_header_id = p_receiving_routing_id_tbl(i));
1790:
1791: IF (SQL%ROWCOUNT > 0) THEN
1792: x_result_type := po_validations.c_result_type_failure;