APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on PO_RELEASES

Line 1761: l_consumption_release_flag po_releases_all.consigned_consumption_flag%TYPE;

1757: ===========================================================================*/
1758: PROCEDURE validate_consumption_release(
1759: x_consumption_release_rec IN OUT NOCOPY rcv_shipment_line_sv.release_id_record_type
1760: ) IS
1761: l_consumption_release_flag po_releases_all.consigned_consumption_flag%TYPE;
1762: x_error_status VARCHAR2(1);
1763: BEGIN
1764: x_error_status := rcv_error_pkg.g_ret_sts_error;
1765:

Line 1768: FROM po_releases

1764: x_error_status := rcv_error_pkg.g_ret_sts_error;
1765:
1766: SELECT consigned_consumption_flag
1767: INTO l_consumption_release_flag
1768: FROM po_releases
1769: WHERE po_release_id = x_consumption_release_rec.po_release_id;
1770:
1771: IF (l_consumption_release_flag = 'Y') THEN
1772: IF (g_asn_debug = 'Y') THEN