DBA Data[Home] [Help]

APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_BID_ITEM_PRICES

Line 58: award_quantity pon_bid_item_prices.award_quantity%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,
62: promised_date pon_bid_item_prices.promised_date%TYPE,

Line 61: bid_currency_unit_price pon_bid_item_prices.bid_currency_unit_price%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,
65: purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE,

Line 62: promised_date pon_bid_item_prices.promised_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,
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,

Line 66: bid_curr_advance_amount pon_bid_item_prices.bid_curr_advance_amount%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,
70: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,

Line 67: recoupment_rate_percent pon_bid_item_prices.recoupment_rate_percent%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,
70: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
71: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,

Line 68: progress_pymt_rate_percent pon_bid_item_prices.progress_pymt_rate_percent%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,
70: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
71: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,
72: award_shipment_number pon_bid_item_prices.award_shipment_number%TYPE

Line 69: retainage_rate_percent pon_bid_item_prices.retainage_rate_percent%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,
70: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
71: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,
72: award_shipment_number pon_bid_item_prices.award_shipment_number%TYPE
73: );

Line 70: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%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,
70: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
71: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,
72: award_shipment_number pon_bid_item_prices.award_shipment_number%TYPE
73: );
74:

Line 71: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%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,
70: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
71: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,
72: award_shipment_number pon_bid_item_prices.award_shipment_number%TYPE
73: );
74:
75: procedure AUTO_ALLOC_AND_SPLIT_REQ(p_auction_header_id IN NUMBER, -- 1

Line 72: award_shipment_number pon_bid_item_prices.award_shipment_number%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,
70: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
71: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,
72: award_shipment_number pon_bid_item_prices.award_shipment_number%TYPE
73: );
74:
75: procedure AUTO_ALLOC_AND_SPLIT_REQ(p_auction_header_id IN NUMBER, -- 1
76: p_user_name IN VARCHAR2, -- 2