APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on PO_LINE_LOCATIONS

Line 1534: l_consigned_po_flag po_line_locations_all.consigned_flag%TYPE;

1530: ===========================================================================*/
1531: PROCEDURE validate_consigned_po(
1532: x_consigned_po_rec IN OUT NOCOPY rcv_shipment_line_sv.po_line_location_id_rtype
1533: ) IS
1534: l_consigned_po_flag po_line_locations_all.consigned_flag%TYPE;
1535: x_error_status VARCHAR2(1);
1536: BEGIN
1537: x_error_status := rcv_error_pkg.g_ret_sts_error;
1538:

Line 1541: FROM po_line_locations

1537: x_error_status := rcv_error_pkg.g_ret_sts_error;
1538:
1539: SELECT consigned_flag
1540: INTO l_consigned_po_flag
1541: FROM po_line_locations
1542: WHERE line_location_id = x_consigned_po_rec.po_line_location_id;
1543:
1544: IF (l_consigned_po_flag = 'Y') THEN
1545: IF (g_asn_debug = 'Y') THEN