DBA Data[Home] [Help]

APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 10: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,

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,

Line 11: document_number pon_auction_headers_all.document_number%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,

Line 12: org_id pon_auction_headers_all.org_id%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,

Line 13: contract_type pon_auction_headers_all.contract_type%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,

Line 14: language_code pon_auction_headers_all.language_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,

Line 15: po_start_date pon_auction_headers_all.po_start_date%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,

Line 16: po_end_date pon_auction_headers_all.po_end_date%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,

Line 17: currency_code pon_auction_headers_all.currency_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,

Line 18: fob_code pon_auction_headers_all.fob_code%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,

Line 19: freight_terms_code pon_auction_headers_all.freight_terms_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,
23: bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,

Line 20: carrier_code pon_auction_headers_all.carrier_code%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,

Line 21: payment_terms_id pon_auction_headers_all.payment_terms_id%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,

Line 22: ship_to_location_id pon_auction_headers_all.ship_to_location_id%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,

Line 23: bill_to_location_id pon_auction_headers_all.bill_to_location_id%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,

Line 24: auction_origination_code pon_auction_headers_all.auction_origination_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,
28: vendor_id pon_bid_headers.vendor_id%TYPE,

Line 25: source_reqs_flag pon_auction_headers_all.source_reqs_flag%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,

Line 32: global_agreement_flag pon_auction_headers_all.global_agreement_flag%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,

Line 33: po_min_rel_amount pon_auction_headers_all.po_min_rel_amount%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,

Line 36: rate_type pon_auction_headers_all.rate_type%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,

Line 37: rate_date pon_auction_headers_all.rate_date%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,

Line 44: po_style_id pon_auction_headers_all.po_style_id%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,

Line 45: progress_payment_type pon_auction_headers_all.progress_payment_type%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,

Line 46: supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%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

Line 49: umbrella_program_id pon_auction_headers_all.umbrella_program_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
51: );
52:
53: TYPE PDOIline IS RECORD (

Line 50: fair_opp_notice_flag pon_auction_headers_all.fair_opp_notice_flag%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 (
54: line_number pon_auction_item_prices_all.line_number%TYPE,