DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on PO_LINE_LOCATIONS

Line 1685: l_consigned_po_flag po_line_locations_all.consigned_flag%TYPE;

1681: ===========================================================================*/
1682: PROCEDURE validate_consigned_po(
1683: x_consigned_po_rec IN OUT NOCOPY rcv_shipment_line_sv.po_line_location_id_rtype
1684: ) IS
1685: l_consigned_po_flag po_line_locations_all.consigned_flag%TYPE;
1686: x_error_status VARCHAR2(1);
1687: BEGIN
1688: x_error_status := rcv_error_pkg.g_ret_sts_error;
1689:

Line 1692: FROM po_line_locations

1688: x_error_status := rcv_error_pkg.g_ret_sts_error;
1689:
1690: SELECT consigned_flag
1691: INTO l_consigned_po_flag
1692: FROM po_line_locations
1693: WHERE line_location_id = x_consigned_po_rec.po_line_location_id;
1694:
1695: IF (l_consigned_po_flag = 'Y') THEN
1696: IF (g_asn_debug = 'Y') THEN