APPS.PO_VENDORS_SV dependencies on PO_HEADERS_ALL

Line 551: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,

547:
548: =============================================================================*/
549: PROCEDURE get_terms_conditions
550: (
551: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
552: x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE,
553: x_ship_via_lookup_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE,
554: x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE,
555: x_freight_terms_lookup_code OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,

Line 552: x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE,

548: =============================================================================*/
549: PROCEDURE get_terms_conditions
550: (
551: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
552: x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE,
553: x_ship_via_lookup_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE,
554: x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE,
555: x_freight_terms_lookup_code OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,
556: x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --

Line 553: x_ship_via_lookup_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE,

549: PROCEDURE get_terms_conditions
550: (
551: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
552: x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE,
553: x_ship_via_lookup_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE,
554: x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE,
555: x_freight_terms_lookup_code OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,
556: x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
557: )

Line 554: x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE,

550: (
551: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
552: x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE,
553: x_ship_via_lookup_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE,
554: x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE,
555: x_freight_terms_lookup_code OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,
556: x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
557: )
558: IS

Line 555: x_freight_terms_lookup_code OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,

551: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
552: x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE,
553: x_ship_via_lookup_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE,
554: x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE,
555: x_freight_terms_lookup_code OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,
556: x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
557: )
558: IS
559: BEGIN

Line 556: x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --

552: x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE,
553: x_ship_via_lookup_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE,
554: x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE,
555: x_freight_terms_lookup_code OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,
556: x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
557: )
558: IS
559: BEGIN
560:

Line 571: FROM po_headers_all

567: x_ship_via_lookup_code,
568: x_fob_lookup_code,
569: x_freight_terms_lookup_code,
570: x_shipping_control --
571: FROM po_headers_all
572: WHERE po_header_id = p_po_header_id;
573:
574: EXCEPTION
575: WHEN OTHERS THEN