DBA Data[Home] [Help]

APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_BID_ITEM_PRICES

Line 67: award_quantity pon_bid_item_prices.award_quantity%TYPE,

63: ship_to_location_id pon_auction_item_prices_all.ship_to_location_id%TYPE,
64: need_by_date pon_auction_item_prices_all.clm_need_by_date%TYPE,
65: pop_start_date pon_auction_item_prices_all.need_by_start_date%TYPE,
66: pop_end_date pon_auction_item_prices_all.need_by_date%TYPE,
67: award_quantity pon_bid_item_prices.award_quantity%TYPE,
68: po_min_rel_amount pon_auction_item_prices_all.po_min_rel_amount%TYPE,
69: has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE,
70: bid_currency_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE,
71: promised_date pon_bid_item_prices.promised_date%TYPE,

Line 70: bid_currency_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE,

66: pop_end_date pon_auction_item_prices_all.need_by_date%TYPE,
67: award_quantity pon_bid_item_prices.award_quantity%TYPE,
68: po_min_rel_amount pon_auction_item_prices_all.po_min_rel_amount%TYPE,
69: has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE,
70: bid_currency_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE,
71: promised_date pon_bid_item_prices.promised_date%TYPE,
72: job_id pon_auction_item_prices_all.job_id%TYPE,
73: po_agreed_amount pon_auction_item_prices_all.po_agreed_amount%TYPE,
74: purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE,

Line 71: promised_date pon_bid_item_prices.promised_date%TYPE,

67: award_quantity pon_bid_item_prices.award_quantity%TYPE,
68: po_min_rel_amount pon_auction_item_prices_all.po_min_rel_amount%TYPE,
69: has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE,
70: bid_currency_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE,
71: promised_date pon_bid_item_prices.promised_date%TYPE,
72: job_id pon_auction_item_prices_all.job_id%TYPE,
73: po_agreed_amount pon_auction_item_prices_all.po_agreed_amount%TYPE,
74: purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE,
75: bid_curr_advance_amount pon_bid_item_prices.bid_curr_advance_amount%TYPE,

Line 75: bid_curr_advance_amount pon_bid_item_prices.bid_curr_advance_amount%TYPE,

71: promised_date pon_bid_item_prices.promised_date%TYPE,
72: job_id pon_auction_item_prices_all.job_id%TYPE,
73: po_agreed_amount pon_auction_item_prices_all.po_agreed_amount%TYPE,
74: purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE,
75: bid_curr_advance_amount pon_bid_item_prices.bid_curr_advance_amount%TYPE,
76: recoupment_rate_percent pon_bid_item_prices.recoupment_rate_percent%TYPE,
77: progress_pymt_rate_percent pon_bid_item_prices.progress_pymt_rate_percent%TYPE,
78: retainage_rate_percent pon_bid_item_prices.retainage_rate_percent%TYPE,
79: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,

Line 76: recoupment_rate_percent pon_bid_item_prices.recoupment_rate_percent%TYPE,

72: job_id pon_auction_item_prices_all.job_id%TYPE,
73: po_agreed_amount pon_auction_item_prices_all.po_agreed_amount%TYPE,
74: purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE,
75: bid_curr_advance_amount pon_bid_item_prices.bid_curr_advance_amount%TYPE,
76: recoupment_rate_percent pon_bid_item_prices.recoupment_rate_percent%TYPE,
77: progress_pymt_rate_percent pon_bid_item_prices.progress_pymt_rate_percent%TYPE,
78: retainage_rate_percent pon_bid_item_prices.retainage_rate_percent%TYPE,
79: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
80: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,

Line 77: progress_pymt_rate_percent pon_bid_item_prices.progress_pymt_rate_percent%TYPE,

73: po_agreed_amount pon_auction_item_prices_all.po_agreed_amount%TYPE,
74: purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE,
75: bid_curr_advance_amount pon_bid_item_prices.bid_curr_advance_amount%TYPE,
76: recoupment_rate_percent pon_bid_item_prices.recoupment_rate_percent%TYPE,
77: progress_pymt_rate_percent pon_bid_item_prices.progress_pymt_rate_percent%TYPE,
78: retainage_rate_percent pon_bid_item_prices.retainage_rate_percent%TYPE,
79: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
80: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,
81: award_shipment_number pon_bid_item_prices.award_shipment_number%TYPE,

Line 78: retainage_rate_percent pon_bid_item_prices.retainage_rate_percent%TYPE,

74: purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE,
75: bid_curr_advance_amount pon_bid_item_prices.bid_curr_advance_amount%TYPE,
76: recoupment_rate_percent pon_bid_item_prices.recoupment_rate_percent%TYPE,
77: progress_pymt_rate_percent pon_bid_item_prices.progress_pymt_rate_percent%TYPE,
78: retainage_rate_percent pon_bid_item_prices.retainage_rate_percent%TYPE,
79: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
80: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,
81: award_shipment_number pon_bid_item_prices.award_shipment_number%TYPE,
82: line_num_display pon_auction_item_prices_all.line_num_display%TYPE,

Line 79: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,

75: bid_curr_advance_amount pon_bid_item_prices.bid_curr_advance_amount%TYPE,
76: recoupment_rate_percent pon_bid_item_prices.recoupment_rate_percent%TYPE,
77: progress_pymt_rate_percent pon_bid_item_prices.progress_pymt_rate_percent%TYPE,
78: retainage_rate_percent pon_bid_item_prices.retainage_rate_percent%TYPE,
79: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
80: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,
81: award_shipment_number pon_bid_item_prices.award_shipment_number%TYPE,
82: line_num_display pon_auction_item_prices_all.line_num_display%TYPE,
83: group_line_id pon_auction_item_prices_all.group_line_id%TYPE,

Line 80: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,

76: recoupment_rate_percent pon_bid_item_prices.recoupment_rate_percent%TYPE,
77: progress_pymt_rate_percent pon_bid_item_prices.progress_pymt_rate_percent%TYPE,
78: retainage_rate_percent pon_bid_item_prices.retainage_rate_percent%TYPE,
79: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
80: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,
81: award_shipment_number pon_bid_item_prices.award_shipment_number%TYPE,
82: line_num_display pon_auction_item_prices_all.line_num_display%TYPE,
83: group_line_id pon_auction_item_prices_all.group_line_id%TYPE,
84: clm_info_flag pon_auction_item_prices_all.clm_info_flag%TYPE,

Line 81: award_shipment_number pon_bid_item_prices.award_shipment_number%TYPE,

77: progress_pymt_rate_percent pon_bid_item_prices.progress_pymt_rate_percent%TYPE,
78: retainage_rate_percent pon_bid_item_prices.retainage_rate_percent%TYPE,
79: bid_curr_max_retainage_amt pon_bid_item_prices.bid_curr_max_retainage_amt%TYPE,
80: has_bid_payments_flag pon_bid_item_prices.has_bid_payments_flag%TYPE,
81: award_shipment_number pon_bid_item_prices.award_shipment_number%TYPE,
82: line_num_display pon_auction_item_prices_all.line_num_display%TYPE,
83: group_line_id pon_auction_item_prices_all.group_line_id%TYPE,
84: clm_info_flag pon_auction_item_prices_all.clm_info_flag%TYPE,
85: clm_option_indicator pon_auction_item_prices_all.clm_option_indicator%TYPE,

Line 94: IDV_LINE_ID pon_bid_item_prices.idv_line_id%TYPE,

90: clm_base_line_num pon_auction_item_prices_all.clm_base_line_num%TYPE,
91: CONTRACT_TYPE pon_auction_item_prices_all.CLM_CONTRACT_TYPE%TYPE,
92: COST_CONSTRAINT pon_auction_item_prices_all.CLM_COST_CONSTRAINT%TYPE,
93: CLM_IDC_TYPE pon_auction_item_prices_all.CLM_IDC_TYPE%TYPE,
94: IDV_LINE_ID pon_bid_item_prices.idv_line_id%TYPE,
95: EXHIBIT_NUMBER pon_auction_item_prices_all.exhibit_number%TYPE, --ELINs project
96: -- Event Based Delivery Project
97: CLM_DELIVERY_EVENT_CODE pon_auction_item_prices_all.CLM_DELIVERY_EVENT_CODE%TYPE,
98: CLM_DELIVERY_PERIOD pon_auction_item_prices_all.CLM_DELIVERY_PERIOD%TYPE,

Line 100: CLM_PROMISE_PERIOD pon_bid_item_prices.CLM_PROMISE_PERIOD%TYPE,

96: -- Event Based Delivery Project
97: CLM_DELIVERY_EVENT_CODE pon_auction_item_prices_all.CLM_DELIVERY_EVENT_CODE%TYPE,
98: CLM_DELIVERY_PERIOD pon_auction_item_prices_all.CLM_DELIVERY_PERIOD%TYPE,
99: CLM_DELIVERY_PERIOD_UOM pon_auction_item_prices_all.CLM_DELIVERY_PERIOD_UOM%TYPE,
100: CLM_PROMISE_PERIOD pon_bid_item_prices.CLM_PROMISE_PERIOD%TYPE,
101: CLM_PROMISE_PERIOD_UOM pon_bid_item_prices.CLM_PROMISE_PERIOD_UOM%TYPE,
102: CLM_PROMISE_POP_DURATION pon_bid_item_prices.CLM_PROMISE_POP_DURATION%TYPE,
103: CLM_PROMISE_POP_DURATION_UOM pon_bid_item_prices.CLM_PROMISE_POP_DURATION_UOM%TYPE
104:

Line 101: CLM_PROMISE_PERIOD_UOM pon_bid_item_prices.CLM_PROMISE_PERIOD_UOM%TYPE,

97: CLM_DELIVERY_EVENT_CODE pon_auction_item_prices_all.CLM_DELIVERY_EVENT_CODE%TYPE,
98: CLM_DELIVERY_PERIOD pon_auction_item_prices_all.CLM_DELIVERY_PERIOD%TYPE,
99: CLM_DELIVERY_PERIOD_UOM pon_auction_item_prices_all.CLM_DELIVERY_PERIOD_UOM%TYPE,
100: CLM_PROMISE_PERIOD pon_bid_item_prices.CLM_PROMISE_PERIOD%TYPE,
101: CLM_PROMISE_PERIOD_UOM pon_bid_item_prices.CLM_PROMISE_PERIOD_UOM%TYPE,
102: CLM_PROMISE_POP_DURATION pon_bid_item_prices.CLM_PROMISE_POP_DURATION%TYPE,
103: CLM_PROMISE_POP_DURATION_UOM pon_bid_item_prices.CLM_PROMISE_POP_DURATION_UOM%TYPE
104:
105: );

Line 102: CLM_PROMISE_POP_DURATION pon_bid_item_prices.CLM_PROMISE_POP_DURATION%TYPE,

98: CLM_DELIVERY_PERIOD pon_auction_item_prices_all.CLM_DELIVERY_PERIOD%TYPE,
99: CLM_DELIVERY_PERIOD_UOM pon_auction_item_prices_all.CLM_DELIVERY_PERIOD_UOM%TYPE,
100: CLM_PROMISE_PERIOD pon_bid_item_prices.CLM_PROMISE_PERIOD%TYPE,
101: CLM_PROMISE_PERIOD_UOM pon_bid_item_prices.CLM_PROMISE_PERIOD_UOM%TYPE,
102: CLM_PROMISE_POP_DURATION pon_bid_item_prices.CLM_PROMISE_POP_DURATION%TYPE,
103: CLM_PROMISE_POP_DURATION_UOM pon_bid_item_prices.CLM_PROMISE_POP_DURATION_UOM%TYPE
104:
105: );
106:

Line 103: CLM_PROMISE_POP_DURATION_UOM pon_bid_item_prices.CLM_PROMISE_POP_DURATION_UOM%TYPE

99: CLM_DELIVERY_PERIOD_UOM pon_auction_item_prices_all.CLM_DELIVERY_PERIOD_UOM%TYPE,
100: CLM_PROMISE_PERIOD pon_bid_item_prices.CLM_PROMISE_PERIOD%TYPE,
101: CLM_PROMISE_PERIOD_UOM pon_bid_item_prices.CLM_PROMISE_PERIOD_UOM%TYPE,
102: CLM_PROMISE_POP_DURATION pon_bid_item_prices.CLM_PROMISE_POP_DURATION%TYPE,
103: CLM_PROMISE_POP_DURATION_UOM pon_bid_item_prices.CLM_PROMISE_POP_DURATION_UOM%TYPE
104:
105: );
106:
107: procedure AUTO_ALLOC_AND_SPLIT_REQ(p_auction_header_id IN NUMBER, -- 1