[Home] [Help]
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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 (
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,