12: G_COMPARISON_SCOPE_ALL CONSTANT VARCHAR2(10) := 'ALL';
13:
14:
15: TYPE terms_and_cond_rec_type IS RECORD (
16: terms_id PO_HEADERS_ALL.terms_id%TYPE,
17: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%TYPE,
18: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,
19: note_to_vendor PO_HEADERS_ALL.note_to_vendor%TYPE,
20: note_to_receiver PO_HEADERS_ALL.note_to_receiver%TYPE,
13:
14:
15: TYPE terms_and_cond_rec_type IS RECORD (
16: terms_id PO_HEADERS_ALL.terms_id%TYPE,
17: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%TYPE,
18: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,
19: note_to_vendor PO_HEADERS_ALL.note_to_vendor%TYPE,
20: note_to_receiver PO_HEADERS_ALL.note_to_receiver%TYPE,
21: shipping_control PO_HEADERS_ALL.shipping_control%TYPE, --
14:
15: TYPE terms_and_cond_rec_type IS RECORD (
16: terms_id PO_HEADERS_ALL.terms_id%TYPE,
17: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%TYPE,
18: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,
19: note_to_vendor PO_HEADERS_ALL.note_to_vendor%TYPE,
20: note_to_receiver PO_HEADERS_ALL.note_to_receiver%TYPE,
21: shipping_control PO_HEADERS_ALL.shipping_control%TYPE, --
22: pay_on_code PO_HEADERS_ALL.pay_on_code%TYPE,
15: TYPE terms_and_cond_rec_type IS RECORD (
16: terms_id PO_HEADERS_ALL.terms_id%TYPE,
17: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%TYPE,
18: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,
19: note_to_vendor PO_HEADERS_ALL.note_to_vendor%TYPE,
20: note_to_receiver PO_HEADERS_ALL.note_to_receiver%TYPE,
21: shipping_control PO_HEADERS_ALL.shipping_control%TYPE, --
22: pay_on_code PO_HEADERS_ALL.pay_on_code%TYPE,
23: bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE,
16: terms_id PO_HEADERS_ALL.terms_id%TYPE,
17: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%TYPE,
18: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,
19: note_to_vendor PO_HEADERS_ALL.note_to_vendor%TYPE,
20: note_to_receiver PO_HEADERS_ALL.note_to_receiver%TYPE,
21: shipping_control PO_HEADERS_ALL.shipping_control%TYPE, --
22: pay_on_code PO_HEADERS_ALL.pay_on_code%TYPE,
23: bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE,
24: ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE,
17: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%TYPE,
18: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,
19: note_to_vendor PO_HEADERS_ALL.note_to_vendor%TYPE,
20: note_to_receiver PO_HEADERS_ALL.note_to_receiver%TYPE,
21: shipping_control PO_HEADERS_ALL.shipping_control%TYPE, --
23: bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE,
24: ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE,
25: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE
18: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%TYPE,
19: note_to_vendor PO_HEADERS_ALL.note_to_vendor%TYPE,
20: note_to_receiver PO_HEADERS_ALL.note_to_receiver%TYPE,
21: shipping_control PO_HEADERS_ALL.shipping_control%TYPE, --
22: pay_on_code PO_HEADERS_ALL.pay_on_code%TYPE,
23: bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE,
24: ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE,
25: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE
26: );
19: note_to_vendor PO_HEADERS_ALL.note_to_vendor%TYPE,
20: note_to_receiver PO_HEADERS_ALL.note_to_receiver%TYPE,
21: shipping_control PO_HEADERS_ALL.shipping_control%TYPE, --
22: pay_on_code PO_HEADERS_ALL.pay_on_code%TYPE,
23: bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE,
24: ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE,
25: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE
26: );
27:
20: note_to_receiver PO_HEADERS_ALL.note_to_receiver%TYPE,
21: shipping_control PO_HEADERS_ALL.shipping_control%TYPE, --
22: pay_on_code PO_HEADERS_ALL.pay_on_code%TYPE,
23: bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE,
24: ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE,
25: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE
26: );
27:
28: TYPE terms_cond_comp_rec_type IS RECORD (
21: shipping_control PO_HEADERS_ALL.shipping_control%TYPE, --
22: pay_on_code PO_HEADERS_ALL.pay_on_code%TYPE,
23: bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE,
24: ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE,
25: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE
26: );
27:
28: TYPE terms_cond_comp_rec_type IS RECORD (
29: terms_id_eq VARCHAR2(1),
281: PROCEDURE validate_freight_carrier_info(
282: p_carrier_rec IN OUT NOCOPY rcv_shipment_header_sv.FreightRecType);
283:
284: PROCEDURE get_global_terms_conditions -- <2699404>
285: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
286: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE
287: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
288: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
289: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
282: p_carrier_rec IN OUT NOCOPY rcv_shipment_header_sv.FreightRecType);
283:
284: PROCEDURE get_global_terms_conditions -- <2699404>
285: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
286: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE
287: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
288: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
289: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
290: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE
283:
284: PROCEDURE get_global_terms_conditions -- <2699404>
285: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
286: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE
287: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
288: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
289: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
290: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE
291: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
284: PROCEDURE get_global_terms_conditions -- <2699404>
285: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
286: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE
287: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
288: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
289: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
290: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE
291: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
292: );
285: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
286: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE
287: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
288: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
289: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
290: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE
291: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
292: );
293:
286: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%TYPE
287: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
288: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
289: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
290: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE
291: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
292: );
293:
294: PROCEDURE get_local_terms_conditions -- <2699404>
287: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%TYPE
288: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%TYPE
289: , x_supplier_note OUT NOCOPY PO_HEADERS_ALL.note_to_vendor%TYPE
290: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%TYPE
291: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
293:
294: PROCEDURE get_local_terms_conditions -- <2699404>
295: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
291: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%TYPE --
292: );
293:
294: PROCEDURE get_local_terms_conditions -- <2699404>
295: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
296: , x_pay_on_code OUT NOCOPY PO_HEADERS_ALL.pay_on_code%TYPE
297: , x_bill_to_id OUT NOCOPY PO_HEADERS_ALL.bill_to_location_id%TYPE
298: , x_ship_to_id OUT NOCOPY PO_HEADERS_ALL.ship_to_location_id%TYPE
299: , x_ship_via_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE
292: );
293:
294: PROCEDURE get_local_terms_conditions -- <2699404>
295: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
296: , x_pay_on_code OUT NOCOPY PO_HEADERS_ALL.pay_on_code%TYPE
297: , x_bill_to_id OUT NOCOPY PO_HEADERS_ALL.bill_to_location_id%TYPE
298: , x_ship_to_id OUT NOCOPY PO_HEADERS_ALL.ship_to_location_id%TYPE
299: , x_ship_via_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE
300: );
293:
294: PROCEDURE get_local_terms_conditions -- <2699404>
295: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
296: , x_pay_on_code OUT NOCOPY PO_HEADERS_ALL.pay_on_code%TYPE
297: , x_bill_to_id OUT NOCOPY PO_HEADERS_ALL.bill_to_location_id%TYPE
298: , x_ship_to_id OUT NOCOPY PO_HEADERS_ALL.ship_to_location_id%TYPE
299: , x_ship_via_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE
300: );
301:
294: PROCEDURE get_local_terms_conditions -- <2699404>
295: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
296: , x_pay_on_code OUT NOCOPY PO_HEADERS_ALL.pay_on_code%TYPE
297: , x_bill_to_id OUT NOCOPY PO_HEADERS_ALL.bill_to_location_id%TYPE
298: , x_ship_to_id OUT NOCOPY PO_HEADERS_ALL.ship_to_location_id%TYPE
299: , x_ship_via_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE
300: );
301:
302: --
295: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
296: , x_pay_on_code OUT NOCOPY PO_HEADERS_ALL.pay_on_code%TYPE
297: , x_bill_to_id OUT NOCOPY PO_HEADERS_ALL.bill_to_location_id%TYPE
298: , x_ship_to_id OUT NOCOPY PO_HEADERS_ALL.ship_to_location_id%TYPE
299: , x_ship_via_code OUT NOCOPY PO_HEADERS_ALL.ship_via_lookup_code%TYPE
300: );
301:
302: --
303: