DBA Data[Home] [Help]

APPS.PO_TERMS_SV dependencies on PO_HEADERS_ALL

Line 16: terms_id PO_HEADERS_ALL.terms_id%TYPE,

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,

Line 17: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%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, --

Line 18: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%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,

Line 19: note_to_vendor PO_HEADERS_ALL.note_to_vendor%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,

Line 20: note_to_receiver PO_HEADERS_ALL.note_to_receiver%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,

Line 21: shipping_control PO_HEADERS_ALL.shipping_control%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,
25: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE

Line 22: pay_on_code PO_HEADERS_ALL.pay_on_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: );

Line 23: bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%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: );
27:

Line 24: ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%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:
28: TYPE terms_cond_comp_rec_type IS RECORD (

Line 25: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%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 (
29: terms_id_eq VARCHAR2(1),

Line 285: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

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

Line 286: , x_terms_id OUT NOCOPY PO_HEADERS_ALL.terms_id%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

Line 287: , x_fob_lookup_code OUT NOCOPY PO_HEADERS_ALL.fob_lookup_code%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 --

Line 288: , x_freight_terms OUT NOCOPY PO_HEADERS_ALL.freight_terms_lookup_code%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: );

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

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:

Line 290: , x_receiver_note OUT NOCOPY PO_HEADERS_ALL.note_to_receiver%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:
294: PROCEDURE get_local_terms_conditions -- <2699404>

Line 291: , x_shipping_control OUT NOCOPY PO_HEADERS_ALL.shipping_control%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>
295: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

Line 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

Line 296: , x_pay_on_code OUT NOCOPY PO_HEADERS_ALL.pay_on_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: );

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

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:

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

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: --

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

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: