APPS.PON_UNSOL_AWARD_PKG dependencies on PON_BID_ITEM_PRICES

Line 17: UPDATE pon_bid_item_prices

13: BEGIN
14: x_status := 'SUCCESS';
15: IF(PON_UNSOL_UTIL_PKG.HAS_UNSOL_LINES(p_auc_header_id) = 'Y') THEN
16: --Unsolicited Lines Exist
17: UPDATE pon_bid_item_prices
18: SET award_status = 'REJECTED',
19: award_quantity = NULL,
20: award_date = sysdate,
21: last_update_date = sysdate,

Line 51: UPDATE pon_bid_item_prices

47: p_auctioneer_id IN NUMBER,
48: p_award_date IN DATE) IS
49:
50: BEGIN
51: UPDATE pon_bid_item_prices
52: SET award_status = 'REJECTED',
53: award_quantity = NULL,
54: award_date = p_award_date,
55: last_update_date = p_award_date,

Line 78: pon_bid_item_prices pbip

74:
75: CURSOR c_unsol_active_bids (c_auction_id NUMBER) is
76: SELECT bh.bid_number
77: FROM pon_bid_headers bh,
78: pon_bid_item_prices pbip
79: WHERE bh.auction_header_id = c_auction_id
80: AND bid_status = 'ACTIVE'
81: AND pbip.bid_number = bh.bid_number
82: AND pbip.auction_line_number = -1;

Line 137: l_award_quantity pon_bid_item_prices.award_quantity%TYPE;

133:
134: l_award_date DATE;
135:
136: l_neg_contract_type pon_auction_headers_all.contract_type%TYPE;
137: l_award_quantity pon_bid_item_prices.award_quantity%TYPE;
138: l_award_status pon_bid_item_prices.award_status%TYPE;
139:
140: BEGIN
141:

Line 138: l_award_status pon_bid_item_prices.award_status%TYPE;

134: l_award_date DATE;
135:
136: l_neg_contract_type pon_auction_headers_all.contract_type%TYPE;
137: l_award_quantity pon_bid_item_prices.award_quantity%TYPE;
138: l_award_status pon_bid_item_prices.award_status%TYPE;
139:
140: BEGIN
141:
142: l_award_date := SYSDATE;

Line 161: UPDATE PON_BID_ITEM_PRICES

157: --ELSE
158: -- l_award_quantity := NULL;
159: --END IF;
160:
161: UPDATE PON_BID_ITEM_PRICES
162: SET
163: award_status = l_award_status,
164: award_quantity = l_award_quantity,
165: award_date = l_award_date,

Line 193: SELECT bid_number, Decode((SELECT Count(*) FROM pon_bid_item_prices pbip WHERE pbip.bid_number = bh.bid_number),0,'N','Y') has_lines

189: p_note_to_rejected IN VARCHAR2) IS
190:
191: --This cursor will fetch all the active bids.
192: CURSOR c_active_bids IS
193: SELECT bid_number, Decode((SELECT Count(*) FROM pon_bid_item_prices pbip WHERE pbip.bid_number = bh.bid_number),0,'N','Y') has_lines
194: FROM pon_bid_headers bh
195: WHERE bh.auction_header_id = p_auction_header_id
196: AND bid_status = 'ACTIVE';
197:

Line 208: pon_bid_item_prices bl,

204: bl.auction_line_number,
205: bl.order_number,
206: bl.award_quantity
207: FROM pon_bid_headers bh,
208: pon_bid_item_prices bl,
209: pon_auction_item_prices_all al
210: where bh.bid_number = c_bid_number
211: AND bl.bid_number = bh.bid_number
212: AND bl.auction_line_number <> -1

Line 224: FROM pon_bid_item_prices bl

220: bl.bid_number,
221: bl.auction_line_number,
222: bl.order_number,
223: bl.award_quantity
224: FROM pon_bid_item_prices bl
225: WHERE bl.bid_number = c_bid_number
226: AND bl.auction_line_number = -1
227: AND nvl(bl.award_status,'NO') = 'NO');
228:

Line 257: UPDATE PON_BID_ITEM_PRICES

253: l_update_bid_header := 'Y';
254:
255: IF l_lines_rec.auction_line_number = -1 THEN
256: -- This is an unsolicited line with no award decision
257: UPDATE PON_BID_ITEM_PRICES
258: SET
259: award_status = 'REJECTED',
260: award_quantity = null,
261: award_date = sysdate,