APPS.PO_TERMS_SV dependencies on PO_HEADERS_ALL

Line 567: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

563: -- EXCEPTIONS : -
564: --=============================================================================
565: PROCEDURE get_global_terms_conditions
566: (
567: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
568: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE
569: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
570: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
571: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE

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

564: --=============================================================================
565: PROCEDURE get_global_terms_conditions
566: (
567: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
568: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE
569: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
570: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
571: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
572: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE

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

565: PROCEDURE get_global_terms_conditions
566: (
567: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
568: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE
569: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
570: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
571: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
572: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE
573: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --

Line 570: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE

566: (
567: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
568: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE
569: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
570: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
571: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
572: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE
573: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
574: )

Line 571: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE

567: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
568: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE
569: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
570: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
571: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
572: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE
573: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
574: )
575: IS

Line 572: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE

568: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE
569: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
570: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
571: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
572: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE
573: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
574: )
575: IS
576: BEGIN

Line 573: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --

569: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
570: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
571: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
572: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE
573: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
574: )
575: IS
576: BEGIN
577:

Line 590: FROM po_headers_all

586: , x_freight_terms
587: , x_supplier_note
588: , x_receiver_note
589: , x_shipping_control --
590: FROM po_headers_all
591: WHERE po_header_id = p_po_header_id;
592:
593: EXCEPTION
594:

Line 627: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

623: -- EXCEPTIONS : -
624: --=============================================================================
625: PROCEDURE get_local_terms_conditions
626: (
627: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
628: , x_pay_on_code OUT NOCOPY PO_HEADERS_ALL.pay_on_code%TYPE
629: , x_bill_to_id OUT NOCOPY PO_HEADERS_ALL.bill_to_location_id%TYPE
630: , x_ship_to_id OUT NOCOPY PO_HEADERS_ALL.ship_to_location_id%TYPE
631: , x_ship_via_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE

Line 628: , x_pay_on_code OUT NOCOPY PO_HEADERS_ALL.pay_on_code%TYPE

624: --=============================================================================
625: PROCEDURE get_local_terms_conditions
626: (
627: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
628: , x_pay_on_code OUT NOCOPY PO_HEADERS_ALL.pay_on_code%TYPE
629: , x_bill_to_id OUT NOCOPY PO_HEADERS_ALL.bill_to_location_id%TYPE
630: , x_ship_to_id OUT NOCOPY PO_HEADERS_ALL.ship_to_location_id%TYPE
631: , x_ship_via_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE
632: )

Line 629: , x_bill_to_id OUT NOCOPY PO_HEADERS_ALL.bill_to_location_id%TYPE

625: PROCEDURE get_local_terms_conditions
626: (
627: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
628: , x_pay_on_code OUT NOCOPY PO_HEADERS_ALL.pay_on_code%TYPE
629: , x_bill_to_id OUT NOCOPY PO_HEADERS_ALL.bill_to_location_id%TYPE
630: , x_ship_to_id OUT NOCOPY PO_HEADERS_ALL.ship_to_location_id%TYPE
631: , x_ship_via_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE
632: )
633: IS

Line 630: , x_ship_to_id OUT NOCOPY PO_HEADERS_ALL.ship_to_location_id%TYPE

626: (
627: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
628: , x_pay_on_code OUT NOCOPY PO_HEADERS_ALL.pay_on_code%TYPE
629: , x_bill_to_id OUT NOCOPY PO_HEADERS_ALL.bill_to_location_id%TYPE
630: , x_ship_to_id OUT NOCOPY PO_HEADERS_ALL.ship_to_location_id%TYPE
631: , x_ship_via_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE
632: )
633: IS
634: BEGIN

Line 631: , x_ship_via_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE

627: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
628: , x_pay_on_code OUT NOCOPY PO_HEADERS_ALL.pay_on_code%TYPE
629: , x_bill_to_id OUT NOCOPY PO_HEADERS_ALL.bill_to_location_id%TYPE
630: , x_ship_to_id OUT NOCOPY PO_HEADERS_ALL.ship_to_location_id%TYPE
631: , x_ship_via_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE
632: )
633: IS
634: BEGIN
635:

Line 644: FROM po_headers_all

640: INTO x_pay_on_code
641: , x_bill_to_id
642: , x_ship_to_id
643: , x_ship_via_code
644: FROM po_headers_all
645: WHERE po_header_id = p_po_header_id;
646:
647: EXCEPTION
648: