DBA Data[Home] [Help]

APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 47: line_number pon_auction_item_prices_all.line_number%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,
48: line_type_id pon_auction_item_prices_all.line_type_id%TYPE,
49: order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE,
50: line_origination_code pon_auction_item_prices_all.line_origination_code%TYPE,
51: item_id pon_auction_item_prices_all.item_id%TYPE,

Line 48: line_type_id pon_auction_item_prices_all.line_type_id%TYPE,

44: );
45:
46: TYPE PDOIline IS RECORD (
47: line_number pon_auction_item_prices_all.line_number%TYPE,
48: line_type_id pon_auction_item_prices_all.line_type_id%TYPE,
49: order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE,
50: line_origination_code pon_auction_item_prices_all.line_origination_code%TYPE,
51: item_id pon_auction_item_prices_all.item_id%TYPE,
52: item_revision pon_auction_item_prices_all.item_revision%TYPE,

Line 49: order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE,

45:
46: TYPE PDOIline IS RECORD (
47: line_number pon_auction_item_prices_all.line_number%TYPE,
48: line_type_id pon_auction_item_prices_all.line_type_id%TYPE,
49: order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE,
50: line_origination_code pon_auction_item_prices_all.line_origination_code%TYPE,
51: item_id pon_auction_item_prices_all.item_id%TYPE,
52: item_revision pon_auction_item_prices_all.item_revision%TYPE,
53: category_id pon_auction_item_prices_all.category_id%TYPE,

Line 50: line_origination_code pon_auction_item_prices_all.line_origination_code%TYPE,

46: TYPE PDOIline IS RECORD (
47: line_number pon_auction_item_prices_all.line_number%TYPE,
48: line_type_id pon_auction_item_prices_all.line_type_id%TYPE,
49: order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE,
50: line_origination_code pon_auction_item_prices_all.line_origination_code%TYPE,
51: item_id pon_auction_item_prices_all.item_id%TYPE,
52: item_revision pon_auction_item_prices_all.item_revision%TYPE,
53: category_id pon_auction_item_prices_all.category_id%TYPE,
54: item_description pon_auction_item_prices_all.item_description%TYPE,

Line 51: item_id pon_auction_item_prices_all.item_id%TYPE,

47: line_number pon_auction_item_prices_all.line_number%TYPE,
48: line_type_id pon_auction_item_prices_all.line_type_id%TYPE,
49: order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE,
50: line_origination_code pon_auction_item_prices_all.line_origination_code%TYPE,
51: item_id pon_auction_item_prices_all.item_id%TYPE,
52: item_revision pon_auction_item_prices_all.item_revision%TYPE,
53: category_id pon_auction_item_prices_all.category_id%TYPE,
54: item_description pon_auction_item_prices_all.item_description%TYPE,
55: unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE,

Line 52: item_revision pon_auction_item_prices_all.item_revision%TYPE,

48: line_type_id pon_auction_item_prices_all.line_type_id%TYPE,
49: order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE,
50: line_origination_code pon_auction_item_prices_all.line_origination_code%TYPE,
51: item_id pon_auction_item_prices_all.item_id%TYPE,
52: item_revision pon_auction_item_prices_all.item_revision%TYPE,
53: category_id pon_auction_item_prices_all.category_id%TYPE,
54: item_description pon_auction_item_prices_all.item_description%TYPE,
55: unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE,
56: ship_to_location_id pon_auction_item_prices_all.ship_to_location_id%TYPE,

Line 53: category_id pon_auction_item_prices_all.category_id%TYPE,

49: order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE,
50: line_origination_code pon_auction_item_prices_all.line_origination_code%TYPE,
51: item_id pon_auction_item_prices_all.item_id%TYPE,
52: item_revision pon_auction_item_prices_all.item_revision%TYPE,
53: category_id pon_auction_item_prices_all.category_id%TYPE,
54: item_description pon_auction_item_prices_all.item_description%TYPE,
55: unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE,
56: ship_to_location_id pon_auction_item_prices_all.ship_to_location_id%TYPE,
57: need_by_start_date pon_auction_item_prices_all.need_by_start_date%TYPE,

Line 54: item_description pon_auction_item_prices_all.item_description%TYPE,

50: line_origination_code pon_auction_item_prices_all.line_origination_code%TYPE,
51: item_id pon_auction_item_prices_all.item_id%TYPE,
52: item_revision pon_auction_item_prices_all.item_revision%TYPE,
53: category_id pon_auction_item_prices_all.category_id%TYPE,
54: item_description pon_auction_item_prices_all.item_description%TYPE,
55: unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE,
56: ship_to_location_id pon_auction_item_prices_all.ship_to_location_id%TYPE,
57: need_by_start_date pon_auction_item_prices_all.need_by_start_date%TYPE,
58: award_quantity pon_bid_item_prices.award_quantity%TYPE,

Line 56: ship_to_location_id pon_auction_item_prices_all.ship_to_location_id%TYPE,

52: item_revision pon_auction_item_prices_all.item_revision%TYPE,
53: category_id pon_auction_item_prices_all.category_id%TYPE,
54: item_description pon_auction_item_prices_all.item_description%TYPE,
55: unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE,
56: ship_to_location_id pon_auction_item_prices_all.ship_to_location_id%TYPE,
57: need_by_start_date pon_auction_item_prices_all.need_by_start_date%TYPE,
58: award_quantity pon_bid_item_prices.award_quantity%TYPE,
59: po_min_rel_amount pon_auction_item_prices_all.po_min_rel_amount%TYPE,
60: has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE,

Line 57: need_by_start_date pon_auction_item_prices_all.need_by_start_date%TYPE,

53: category_id pon_auction_item_prices_all.category_id%TYPE,
54: item_description pon_auction_item_prices_all.item_description%TYPE,
55: unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE,
56: ship_to_location_id pon_auction_item_prices_all.ship_to_location_id%TYPE,
57: need_by_start_date pon_auction_item_prices_all.need_by_start_date%TYPE,
58: award_quantity pon_bid_item_prices.award_quantity%TYPE,
59: po_min_rel_amount pon_auction_item_prices_all.po_min_rel_amount%TYPE,
60: has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE,
61: bid_currency_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE,

Line 59: po_min_rel_amount pon_auction_item_prices_all.po_min_rel_amount%TYPE,

55: unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE,
56: ship_to_location_id pon_auction_item_prices_all.ship_to_location_id%TYPE,
57: need_by_start_date pon_auction_item_prices_all.need_by_start_date%TYPE,
58: award_quantity pon_bid_item_prices.award_quantity%TYPE,
59: po_min_rel_amount pon_auction_item_prices_all.po_min_rel_amount%TYPE,
60: has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE,
61: bid_currency_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE,
62: promised_date pon_bid_item_prices.promised_date%TYPE,
63: job_id pon_auction_item_prices_all.job_id%TYPE,

Line 60: has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE,

56: ship_to_location_id pon_auction_item_prices_all.ship_to_location_id%TYPE,
57: need_by_start_date pon_auction_item_prices_all.need_by_start_date%TYPE,
58: award_quantity pon_bid_item_prices.award_quantity%TYPE,
59: po_min_rel_amount pon_auction_item_prices_all.po_min_rel_amount%TYPE,
60: has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE,
61: bid_currency_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE,
62: promised_date pon_bid_item_prices.promised_date%TYPE,
63: job_id pon_auction_item_prices_all.job_id%TYPE,
64: po_agreed_amount pon_auction_item_prices_all.po_agreed_amount%TYPE,

Line 63: job_id pon_auction_item_prices_all.job_id%TYPE,

59: po_min_rel_amount pon_auction_item_prices_all.po_min_rel_amount%TYPE,
60: has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE,
61: bid_currency_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE,
62: promised_date pon_bid_item_prices.promised_date%TYPE,
63: job_id pon_auction_item_prices_all.job_id%TYPE,
64: po_agreed_amount pon_auction_item_prices_all.po_agreed_amount%TYPE,
65: purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE,
66: bid_curr_advance_amount pon_bid_item_prices.bid_curr_advance_amount%TYPE,
67: recoupment_rate_percent pon_bid_item_prices.recoupment_rate_percent%TYPE,

Line 64: po_agreed_amount pon_auction_item_prices_all.po_agreed_amount%TYPE,

60: has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE,
61: bid_currency_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE,
62: promised_date pon_bid_item_prices.promised_date%TYPE,
63: job_id pon_auction_item_prices_all.job_id%TYPE,
64: po_agreed_amount pon_auction_item_prices_all.po_agreed_amount%TYPE,
65: purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE,
66: bid_curr_advance_amount pon_bid_item_prices.bid_curr_advance_amount%TYPE,
67: recoupment_rate_percent pon_bid_item_prices.recoupment_rate_percent%TYPE,
68: progress_pymt_rate_percent pon_bid_item_prices.progress_pymt_rate_percent%TYPE,

Line 65: purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE,

61: bid_currency_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE,
62: promised_date pon_bid_item_prices.promised_date%TYPE,
63: job_id pon_auction_item_prices_all.job_id%TYPE,
64: po_agreed_amount pon_auction_item_prices_all.po_agreed_amount%TYPE,
65: purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE,
66: bid_curr_advance_amount pon_bid_item_prices.bid_curr_advance_amount%TYPE,
67: recoupment_rate_percent pon_bid_item_prices.recoupment_rate_percent%TYPE,
68: progress_pymt_rate_percent pon_bid_item_prices.progress_pymt_rate_percent%TYPE,
69: retainage_rate_percent pon_bid_item_prices.retainage_rate_percent%TYPE,