DBA Data[Home] [Help]

APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 8: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,

4: TYPE SumOfReqLineAllocQuantities is TABLE OF NUMBER
5: INDEX BY BINARY_INTEGER;
6:
7: TYPE PDOIheader IS RECORD (
8: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
9: document_number pon_auction_headers_all.document_number%TYPE,
10: org_id pon_auction_headers_all.org_id%TYPE,
11: contract_type pon_auction_headers_all.contract_type%TYPE,
12: language_code pon_auction_headers_all.language_code%TYPE,

Line 9: document_number pon_auction_headers_all.document_number%TYPE,

5: INDEX BY BINARY_INTEGER;
6:
7: TYPE PDOIheader IS RECORD (
8: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
9: document_number pon_auction_headers_all.document_number%TYPE,
10: org_id pon_auction_headers_all.org_id%TYPE,
11: contract_type pon_auction_headers_all.contract_type%TYPE,
12: language_code pon_auction_headers_all.language_code%TYPE,
13: po_start_date pon_auction_headers_all.po_start_date%TYPE,

Line 10: org_id pon_auction_headers_all.org_id%TYPE,

6:
7: TYPE PDOIheader IS RECORD (
8: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
9: document_number pon_auction_headers_all.document_number%TYPE,
10: org_id pon_auction_headers_all.org_id%TYPE,
11: contract_type pon_auction_headers_all.contract_type%TYPE,
12: language_code pon_auction_headers_all.language_code%TYPE,
13: po_start_date pon_auction_headers_all.po_start_date%TYPE,
14: po_end_date pon_auction_headers_all.po_end_date%TYPE,

Line 11: contract_type pon_auction_headers_all.contract_type%TYPE,

7: TYPE PDOIheader IS RECORD (
8: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
9: document_number pon_auction_headers_all.document_number%TYPE,
10: org_id pon_auction_headers_all.org_id%TYPE,
11: contract_type pon_auction_headers_all.contract_type%TYPE,
12: language_code pon_auction_headers_all.language_code%TYPE,
13: po_start_date pon_auction_headers_all.po_start_date%TYPE,
14: po_end_date pon_auction_headers_all.po_end_date%TYPE,
15: currency_code pon_auction_headers_all.currency_code%TYPE,

Line 12: language_code pon_auction_headers_all.language_code%TYPE,

8: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
9: document_number pon_auction_headers_all.document_number%TYPE,
10: org_id pon_auction_headers_all.org_id%TYPE,
11: contract_type pon_auction_headers_all.contract_type%TYPE,
12: language_code pon_auction_headers_all.language_code%TYPE,
13: po_start_date pon_auction_headers_all.po_start_date%TYPE,
14: po_end_date pon_auction_headers_all.po_end_date%TYPE,
15: currency_code pon_auction_headers_all.currency_code%TYPE,
16: fob_code pon_auction_headers_all.fob_code%TYPE,

Line 13: po_start_date pon_auction_headers_all.po_start_date%TYPE,

9: document_number pon_auction_headers_all.document_number%TYPE,
10: org_id pon_auction_headers_all.org_id%TYPE,
11: contract_type pon_auction_headers_all.contract_type%TYPE,
12: language_code pon_auction_headers_all.language_code%TYPE,
13: po_start_date pon_auction_headers_all.po_start_date%TYPE,
14: po_end_date pon_auction_headers_all.po_end_date%TYPE,
15: currency_code pon_auction_headers_all.currency_code%TYPE,
16: fob_code pon_auction_headers_all.fob_code%TYPE,
17: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,

Line 14: po_end_date pon_auction_headers_all.po_end_date%TYPE,

10: org_id pon_auction_headers_all.org_id%TYPE,
11: contract_type pon_auction_headers_all.contract_type%TYPE,
12: language_code pon_auction_headers_all.language_code%TYPE,
13: po_start_date pon_auction_headers_all.po_start_date%TYPE,
14: po_end_date pon_auction_headers_all.po_end_date%TYPE,
15: currency_code pon_auction_headers_all.currency_code%TYPE,
16: fob_code pon_auction_headers_all.fob_code%TYPE,
17: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
18: carrier_code pon_auction_headers_all.carrier_code%TYPE,

Line 15: currency_code pon_auction_headers_all.currency_code%TYPE,

11: contract_type pon_auction_headers_all.contract_type%TYPE,
12: language_code pon_auction_headers_all.language_code%TYPE,
13: po_start_date pon_auction_headers_all.po_start_date%TYPE,
14: po_end_date pon_auction_headers_all.po_end_date%TYPE,
15: currency_code pon_auction_headers_all.currency_code%TYPE,
16: fob_code pon_auction_headers_all.fob_code%TYPE,
17: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
18: carrier_code pon_auction_headers_all.carrier_code%TYPE,
19: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,

Line 16: fob_code pon_auction_headers_all.fob_code%TYPE,

12: language_code pon_auction_headers_all.language_code%TYPE,
13: po_start_date pon_auction_headers_all.po_start_date%TYPE,
14: po_end_date pon_auction_headers_all.po_end_date%TYPE,
15: currency_code pon_auction_headers_all.currency_code%TYPE,
16: fob_code pon_auction_headers_all.fob_code%TYPE,
17: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
18: carrier_code pon_auction_headers_all.carrier_code%TYPE,
19: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
20: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,

Line 17: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,

13: po_start_date pon_auction_headers_all.po_start_date%TYPE,
14: po_end_date pon_auction_headers_all.po_end_date%TYPE,
15: currency_code pon_auction_headers_all.currency_code%TYPE,
16: fob_code pon_auction_headers_all.fob_code%TYPE,
17: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
18: carrier_code pon_auction_headers_all.carrier_code%TYPE,
19: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
20: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
21: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,

Line 18: carrier_code pon_auction_headers_all.carrier_code%TYPE,

14: po_end_date pon_auction_headers_all.po_end_date%TYPE,
15: currency_code pon_auction_headers_all.currency_code%TYPE,
16: fob_code pon_auction_headers_all.fob_code%TYPE,
17: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
18: carrier_code pon_auction_headers_all.carrier_code%TYPE,
19: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
20: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
21: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
22: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,

Line 19: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,

15: currency_code pon_auction_headers_all.currency_code%TYPE,
16: fob_code pon_auction_headers_all.fob_code%TYPE,
17: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
18: carrier_code pon_auction_headers_all.carrier_code%TYPE,
19: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
20: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
21: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
22: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
23: source_reqs_flag pon_auction_headers_all.source_reqs_flag%TYPE,

Line 20: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,

16: fob_code pon_auction_headers_all.fob_code%TYPE,
17: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
18: carrier_code pon_auction_headers_all.carrier_code%TYPE,
19: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
20: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
21: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
22: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
23: source_reqs_flag pon_auction_headers_all.source_reqs_flag%TYPE,
24: bid_number pon_bid_headers.bid_number%TYPE,

Line 21: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,

17: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
18: carrier_code pon_auction_headers_all.carrier_code%TYPE,
19: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
20: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
21: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
22: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
23: source_reqs_flag pon_auction_headers_all.source_reqs_flag%TYPE,
24: bid_number pon_bid_headers.bid_number%TYPE,
25: order_number pon_bid_headers.order_number%TYPE,

Line 22: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,

18: carrier_code pon_auction_headers_all.carrier_code%TYPE,
19: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
20: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
21: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
22: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
23: source_reqs_flag pon_auction_headers_all.source_reqs_flag%TYPE,
24: bid_number pon_bid_headers.bid_number%TYPE,
25: order_number pon_bid_headers.order_number%TYPE,
26: vendor_id pon_bid_headers.vendor_id%TYPE,

Line 23: source_reqs_flag pon_auction_headers_all.source_reqs_flag%TYPE,

19: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
20: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
21: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
22: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
23: source_reqs_flag pon_auction_headers_all.source_reqs_flag%TYPE,
24: bid_number pon_bid_headers.bid_number%TYPE,
25: order_number pon_bid_headers.order_number%TYPE,
26: vendor_id pon_bid_headers.vendor_id%TYPE,
27: vendor_site_id pon_bid_headers.vendor_site_id%TYPE,

Line 29: global_agreement_flag pon_auction_headers_all.global_agreement_flag%TYPE,

25: order_number pon_bid_headers.order_number%TYPE,
26: vendor_id pon_bid_headers.vendor_id%TYPE,
27: vendor_site_id pon_bid_headers.vendor_site_id%TYPE,
28: agent_id pon_bid_headers.agent_id%TYPE,
29: global_agreement_flag pon_auction_headers_all.global_agreement_flag%TYPE,
30: po_min_rel_amount pon_auction_headers_all.po_min_rel_amount%TYPE,
31: po_agreed_amount pon_bid_headers.po_agreed_amount%TYPE,
32: bid_currency_code pon_bid_headers.bid_currency_code%TYPE,
33: rate_type pon_auction_headers_all.rate_type%TYPE,

Line 30: po_min_rel_amount pon_auction_headers_all.po_min_rel_amount%TYPE,

26: vendor_id pon_bid_headers.vendor_id%TYPE,
27: vendor_site_id pon_bid_headers.vendor_site_id%TYPE,
28: agent_id pon_bid_headers.agent_id%TYPE,
29: global_agreement_flag pon_auction_headers_all.global_agreement_flag%TYPE,
30: po_min_rel_amount pon_auction_headers_all.po_min_rel_amount%TYPE,
31: po_agreed_amount pon_bid_headers.po_agreed_amount%TYPE,
32: bid_currency_code pon_bid_headers.bid_currency_code%TYPE,
33: rate_type pon_auction_headers_all.rate_type%TYPE,
34: rate_date pon_auction_headers_all.rate_date%TYPE,

Line 33: rate_type pon_auction_headers_all.rate_type%TYPE,

29: global_agreement_flag pon_auction_headers_all.global_agreement_flag%TYPE,
30: po_min_rel_amount pon_auction_headers_all.po_min_rel_amount%TYPE,
31: po_agreed_amount pon_bid_headers.po_agreed_amount%TYPE,
32: bid_currency_code pon_bid_headers.bid_currency_code%TYPE,
33: rate_type pon_auction_headers_all.rate_type%TYPE,
34: rate_date pon_auction_headers_all.rate_date%TYPE,
35: rate_dsp pon_bid_headers.rate_dsp%TYPE,
36: create_sourcing_rules pon_bid_headers.create_sourcing_rules%TYPE,
37: update_sourcing_rules pon_bid_headers.update_sourcing_rules%TYPE,

Line 34: rate_date pon_auction_headers_all.rate_date%TYPE,

30: po_min_rel_amount pon_auction_headers_all.po_min_rel_amount%TYPE,
31: po_agreed_amount pon_bid_headers.po_agreed_amount%TYPE,
32: bid_currency_code pon_bid_headers.bid_currency_code%TYPE,
33: rate_type pon_auction_headers_all.rate_type%TYPE,
34: rate_date pon_auction_headers_all.rate_date%TYPE,
35: rate_dsp pon_bid_headers.rate_dsp%TYPE,
36: create_sourcing_rules pon_bid_headers.create_sourcing_rules%TYPE,
37: update_sourcing_rules pon_bid_headers.update_sourcing_rules%TYPE,
38: release_method pon_bid_headers.release_method%TYPE,

Line 41: po_style_id pon_auction_headers_all.po_style_id%TYPE,

37: update_sourcing_rules pon_bid_headers.update_sourcing_rules%TYPE,
38: release_method pon_bid_headers.release_method%TYPE,
39: initiate_approval pon_bid_headers.initiate_approval%TYPE,
40: acceptance_required_flag pon_bid_headers.acceptance_required_flag%TYPE,
41: po_style_id pon_auction_headers_all.po_style_id%TYPE,
42: progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE,
43: supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE
44: );
45:

Line 42: progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE,

38: release_method pon_bid_headers.release_method%TYPE,
39: initiate_approval pon_bid_headers.initiate_approval%TYPE,
40: acceptance_required_flag pon_bid_headers.acceptance_required_flag%TYPE,
41: po_style_id pon_auction_headers_all.po_style_id%TYPE,
42: progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE,
43: supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE
44: );
45:
46: TYPE PDOIline IS RECORD (

Line 43: supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE

39: initiate_approval pon_bid_headers.initiate_approval%TYPE,
40: acceptance_required_flag pon_bid_headers.acceptance_required_flag%TYPE,
41: po_style_id pon_auction_headers_all.po_style_id%TYPE,
42: progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE,
43: supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE
44: );
45:
46: TYPE PDOIline IS RECORD (
47: line_number pon_auction_item_prices_all.line_number%TYPE,