6:
7: /* Bug 9891996 - Added External IDV field to the record type */
8:
9: TYPE PDOIheader IS RECORD (
10: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
11: document_number pon_auction_headers_all.document_number%TYPE,
12: org_id pon_auction_headers_all.org_id%TYPE,
13: contract_type pon_auction_headers_all.contract_type%TYPE,
14: language_code pon_auction_headers_all.language_code%TYPE,
7: /* Bug 9891996 - Added External IDV field to the record type */
8:
9: TYPE PDOIheader IS RECORD (
10: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
11: document_number pon_auction_headers_all.document_number%TYPE,
12: org_id pon_auction_headers_all.org_id%TYPE,
13: contract_type pon_auction_headers_all.contract_type%TYPE,
14: language_code pon_auction_headers_all.language_code%TYPE,
15: po_start_date pon_auction_headers_all.po_start_date%TYPE,
8:
9: TYPE PDOIheader IS RECORD (
10: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
11: document_number pon_auction_headers_all.document_number%TYPE,
12: org_id pon_auction_headers_all.org_id%TYPE,
13: contract_type pon_auction_headers_all.contract_type%TYPE,
14: language_code pon_auction_headers_all.language_code%TYPE,
15: po_start_date pon_auction_headers_all.po_start_date%TYPE,
16: po_end_date pon_auction_headers_all.po_end_date%TYPE,
9: TYPE PDOIheader IS RECORD (
10: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
11: document_number pon_auction_headers_all.document_number%TYPE,
12: org_id pon_auction_headers_all.org_id%TYPE,
13: contract_type pon_auction_headers_all.contract_type%TYPE,
14: language_code pon_auction_headers_all.language_code%TYPE,
15: po_start_date pon_auction_headers_all.po_start_date%TYPE,
16: po_end_date pon_auction_headers_all.po_end_date%TYPE,
17: currency_code pon_auction_headers_all.currency_code%TYPE,
10: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
11: document_number pon_auction_headers_all.document_number%TYPE,
12: org_id pon_auction_headers_all.org_id%TYPE,
13: contract_type pon_auction_headers_all.contract_type%TYPE,
14: language_code pon_auction_headers_all.language_code%TYPE,
15: po_start_date pon_auction_headers_all.po_start_date%TYPE,
16: po_end_date pon_auction_headers_all.po_end_date%TYPE,
17: currency_code pon_auction_headers_all.currency_code%TYPE,
18: fob_code pon_auction_headers_all.fob_code%TYPE,
11: document_number pon_auction_headers_all.document_number%TYPE,
12: org_id pon_auction_headers_all.org_id%TYPE,
13: contract_type pon_auction_headers_all.contract_type%TYPE,
14: language_code pon_auction_headers_all.language_code%TYPE,
15: po_start_date pon_auction_headers_all.po_start_date%TYPE,
16: po_end_date pon_auction_headers_all.po_end_date%TYPE,
17: currency_code pon_auction_headers_all.currency_code%TYPE,
18: fob_code pon_auction_headers_all.fob_code%TYPE,
19: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
12: org_id pon_auction_headers_all.org_id%TYPE,
13: contract_type pon_auction_headers_all.contract_type%TYPE,
14: language_code pon_auction_headers_all.language_code%TYPE,
15: po_start_date pon_auction_headers_all.po_start_date%TYPE,
16: po_end_date pon_auction_headers_all.po_end_date%TYPE,
17: currency_code pon_auction_headers_all.currency_code%TYPE,
18: fob_code pon_auction_headers_all.fob_code%TYPE,
19: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
20: carrier_code pon_auction_headers_all.carrier_code%TYPE,
13: contract_type pon_auction_headers_all.contract_type%TYPE,
14: language_code pon_auction_headers_all.language_code%TYPE,
15: po_start_date pon_auction_headers_all.po_start_date%TYPE,
16: po_end_date pon_auction_headers_all.po_end_date%TYPE,
17: currency_code pon_auction_headers_all.currency_code%TYPE,
18: fob_code pon_auction_headers_all.fob_code%TYPE,
19: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
20: carrier_code pon_auction_headers_all.carrier_code%TYPE,
21: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
14: language_code pon_auction_headers_all.language_code%TYPE,
15: po_start_date pon_auction_headers_all.po_start_date%TYPE,
16: po_end_date pon_auction_headers_all.po_end_date%TYPE,
17: currency_code pon_auction_headers_all.currency_code%TYPE,
18: fob_code pon_auction_headers_all.fob_code%TYPE,
19: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
20: carrier_code pon_auction_headers_all.carrier_code%TYPE,
21: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
22: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
15: po_start_date pon_auction_headers_all.po_start_date%TYPE,
16: po_end_date pon_auction_headers_all.po_end_date%TYPE,
17: currency_code pon_auction_headers_all.currency_code%TYPE,
18: fob_code pon_auction_headers_all.fob_code%TYPE,
19: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
20: carrier_code pon_auction_headers_all.carrier_code%TYPE,
21: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
22: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
23: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
16: po_end_date pon_auction_headers_all.po_end_date%TYPE,
17: currency_code pon_auction_headers_all.currency_code%TYPE,
18: fob_code pon_auction_headers_all.fob_code%TYPE,
19: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
20: carrier_code pon_auction_headers_all.carrier_code%TYPE,
21: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
22: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
23: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
24: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
17: currency_code pon_auction_headers_all.currency_code%TYPE,
18: fob_code pon_auction_headers_all.fob_code%TYPE,
19: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
20: carrier_code pon_auction_headers_all.carrier_code%TYPE,
21: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
22: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
23: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
24: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
25: source_reqs_flag pon_auction_headers_all.source_reqs_flag%TYPE,
18: fob_code pon_auction_headers_all.fob_code%TYPE,
19: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
20: carrier_code pon_auction_headers_all.carrier_code%TYPE,
21: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
22: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
23: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
24: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
25: source_reqs_flag pon_auction_headers_all.source_reqs_flag%TYPE,
26: bid_number pon_bid_headers.bid_number%TYPE,
19: freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
20: carrier_code pon_auction_headers_all.carrier_code%TYPE,
21: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
22: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
23: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
24: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
25: source_reqs_flag pon_auction_headers_all.source_reqs_flag%TYPE,
26: bid_number pon_bid_headers.bid_number%TYPE,
27: order_number pon_bid_headers.order_number%TYPE,
20: carrier_code pon_auction_headers_all.carrier_code%TYPE,
21: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
22: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
23: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
24: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
25: source_reqs_flag pon_auction_headers_all.source_reqs_flag%TYPE,
26: bid_number pon_bid_headers.bid_number%TYPE,
27: order_number pon_bid_headers.order_number%TYPE,
28: vendor_id pon_bid_headers.vendor_id%TYPE,
21: payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
22: ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
23: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
24: auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
25: source_reqs_flag pon_auction_headers_all.source_reqs_flag%TYPE,
26: bid_number pon_bid_headers.bid_number%TYPE,
27: order_number pon_bid_headers.order_number%TYPE,
28: vendor_id pon_bid_headers.vendor_id%TYPE,
29: vendor_site_id pon_bid_headers.vendor_site_id%TYPE,
28: vendor_id pon_bid_headers.vendor_id%TYPE,
29: vendor_site_id pon_bid_headers.vendor_site_id%TYPE,
30: vendor_contact_id pon_bid_headers.trading_partner_contact_id%TYPE,
31: agent_id pon_bid_headers.agent_id%TYPE,
32: global_agreement_flag pon_auction_headers_all.global_agreement_flag%TYPE,
33: po_min_rel_amount pon_auction_headers_all.po_min_rel_amount%TYPE,
34: po_agreed_amount pon_bid_headers.po_agreed_amount%TYPE,
35: bid_currency_code pon_bid_headers.bid_currency_code%TYPE,
36: rate_type pon_auction_headers_all.rate_type%TYPE,
29: vendor_site_id pon_bid_headers.vendor_site_id%TYPE,
30: vendor_contact_id pon_bid_headers.trading_partner_contact_id%TYPE,
31: agent_id pon_bid_headers.agent_id%TYPE,
32: global_agreement_flag pon_auction_headers_all.global_agreement_flag%TYPE,
33: po_min_rel_amount pon_auction_headers_all.po_min_rel_amount%TYPE,
34: po_agreed_amount pon_bid_headers.po_agreed_amount%TYPE,
35: bid_currency_code pon_bid_headers.bid_currency_code%TYPE,
36: rate_type pon_auction_headers_all.rate_type%TYPE,
37: rate_date pon_auction_headers_all.rate_date%TYPE,
32: global_agreement_flag pon_auction_headers_all.global_agreement_flag%TYPE,
33: po_min_rel_amount pon_auction_headers_all.po_min_rel_amount%TYPE,
34: po_agreed_amount pon_bid_headers.po_agreed_amount%TYPE,
35: bid_currency_code pon_bid_headers.bid_currency_code%TYPE,
36: rate_type pon_auction_headers_all.rate_type%TYPE,
37: rate_date pon_auction_headers_all.rate_date%TYPE,
38: rate_dsp pon_bid_headers.rate_dsp%TYPE,
39: create_sourcing_rules pon_bid_headers.create_sourcing_rules%TYPE,
40: update_sourcing_rules pon_bid_headers.update_sourcing_rules%TYPE,
33: po_min_rel_amount pon_auction_headers_all.po_min_rel_amount%TYPE,
34: po_agreed_amount pon_bid_headers.po_agreed_amount%TYPE,
35: bid_currency_code pon_bid_headers.bid_currency_code%TYPE,
36: rate_type pon_auction_headers_all.rate_type%TYPE,
37: rate_date pon_auction_headers_all.rate_date%TYPE,
38: rate_dsp pon_bid_headers.rate_dsp%TYPE,
39: create_sourcing_rules pon_bid_headers.create_sourcing_rules%TYPE,
40: update_sourcing_rules pon_bid_headers.update_sourcing_rules%TYPE,
41: release_method pon_bid_headers.release_method%TYPE,
40: update_sourcing_rules pon_bid_headers.update_sourcing_rules%TYPE,
41: release_method pon_bid_headers.release_method%TYPE,
42: initiate_approval pon_bid_headers.initiate_approval%TYPE,
43: acceptance_required_flag pon_bid_headers.acceptance_required_flag%TYPE,
44: po_style_id pon_auction_headers_all.po_style_id%TYPE,
45: progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE,
46: supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE,
47: idv_header_id pon_bid_headers.idv_header_id%TYPE,
48: clm_external_idv pon_bid_headers.external_idv%TYPE,
41: release_method pon_bid_headers.release_method%TYPE,
42: initiate_approval pon_bid_headers.initiate_approval%TYPE,
43: acceptance_required_flag pon_bid_headers.acceptance_required_flag%TYPE,
44: po_style_id pon_auction_headers_all.po_style_id%TYPE,
45: progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE,
46: supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE,
47: idv_header_id pon_bid_headers.idv_header_id%TYPE,
48: clm_external_idv pon_bid_headers.external_idv%TYPE,
49: umbrella_program_id pon_auction_headers_all.umbrella_program_id%TYPE,
42: initiate_approval pon_bid_headers.initiate_approval%TYPE,
43: acceptance_required_flag pon_bid_headers.acceptance_required_flag%TYPE,
44: po_style_id pon_auction_headers_all.po_style_id%TYPE,
45: progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE,
46: supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE,
47: idv_header_id pon_bid_headers.idv_header_id%TYPE,
48: clm_external_idv pon_bid_headers.external_idv%TYPE,
49: umbrella_program_id pon_auction_headers_all.umbrella_program_id%TYPE,
50: fair_opp_notice_flag pon_auction_headers_all.fair_opp_notice_flag%TYPE
45: progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE,
46: supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE,
47: idv_header_id pon_bid_headers.idv_header_id%TYPE,
48: clm_external_idv pon_bid_headers.external_idv%TYPE,
49: umbrella_program_id pon_auction_headers_all.umbrella_program_id%TYPE,
50: fair_opp_notice_flag pon_auction_headers_all.fair_opp_notice_flag%TYPE
51: );
52:
53: TYPE PDOIline IS RECORD (
46: supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE,
47: idv_header_id pon_bid_headers.idv_header_id%TYPE,
48: clm_external_idv pon_bid_headers.external_idv%TYPE,
49: umbrella_program_id pon_auction_headers_all.umbrella_program_id%TYPE,
50: fair_opp_notice_flag pon_auction_headers_all.fair_opp_notice_flag%TYPE
51: );
52:
53: TYPE PDOIline IS RECORD (
54: line_number pon_auction_item_prices_all.line_number%TYPE,