APPS.PON_UNSOL_AWARD_PKG dependencies on PON_BID_HEADERS

Line 26: FROM pon_bid_headers

22: last_updated_by = p_auctioneer_id,
23: award_shipment_number = NULL,
24: award_price = NULL
25: WHERE bid_number IN ( SELECT bid_number
26: FROM pon_bid_headers
27: WHERE auction_header_id = p_auc_header_id
28: AND bid_status = 'ACTIVE')
29: AND auction_line_number = -1;
30:

Line 77: FROM pon_bid_headers bh,

73: l_rec PON_AWARD_REC;
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

Line 194: FROM pon_bid_headers bh

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:
198: --This cursor will fetch all the bid lines with no award decision.

Line 207: FROM pon_bid_headers bh,

203: bl.bid_number,
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

Line 367: UPDATE PON_BID_HEADERS

363: CLOSE c_active_bids;
364:
365: FORALL k IN 1..l_rejected_bid_numbers.COUNT
366:
367: UPDATE PON_BID_HEADERS
368: SET AWARD_STATUS = 'REJECTED',
369: AWARD_DATE = SYSDATE,
370: last_update_date = SYSDATE,
371: last_updated_by = p_user_id