APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on PO_RELEASES

Line 1610: l_consumption_release_flag po_releases_all.consigned_consumption_flag%TYPE;

1606: ===========================================================================*/
1607: PROCEDURE validate_consumption_release(
1608: x_consumption_release_rec IN OUT NOCOPY rcv_shipment_line_sv.release_id_record_type
1609: ) IS
1610: l_consumption_release_flag po_releases_all.consigned_consumption_flag%TYPE;
1611: x_error_status VARCHAR2(1);
1612: BEGIN
1613: x_error_status := rcv_error_pkg.g_ret_sts_error;
1614:

Line 1617: FROM po_releases

1613: x_error_status := rcv_error_pkg.g_ret_sts_error;
1614:
1615: SELECT consigned_consumption_flag
1616: INTO l_consumption_release_flag
1617: FROM po_releases
1618: WHERE po_release_id = x_consumption_release_rec.po_release_id;
1619:
1620: IF (l_consumption_release_flag = 'Y') THEN
1621: IF (g_asn_debug = 'Y') THEN