APPS.PON_BUYER_SUMMARY_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 27: pon_auction_headers_all ah,

23: bh.trading_partner_contact_id,
24: bl.rank
25: FROM pon_bid_headers bh,
26: pon_bid_item_prices bl,
27: pon_auction_headers_all ah,
28: po_vendors pv,
29: hz_parties hp
30: WHERE ah.auction_header_id = bh.auction_header_id and
31: bh.auction_header_id = bl.auction_header_id

Line 64: FROM pon_auction_headers_all

60: into v_batch_id
61: from dual;
62: --
63: SELECT nvl(auction_type, 'REVERSE') INTO v_auction_type
64: FROM pon_auction_headers_all
65: WHERE auction_header_id = P_AUCTION_ID;
66: --
67: --
68: FOR auction_item IN c_auction_item (p_auction_id) LOOP

Line 180: from pon_auction_item_prices_all poi, pon_auction_headers_all poh

176: BEGIN
177:
178: select count(*)
179: into p_no_bid_open
180: from pon_auction_item_prices_all poi, pon_auction_headers_all poh
181: where poi.auction_header_id = p_auction_id
182: and poh.auction_header_id = poi.auction_header_id
183: and poh.open_bidding_date < sysdate
184: and nvl(poi.close_bidding_date, poh.close_bidding_date) > sysdate

Line 189: from pon_auction_item_prices_all poi, pon_auction_headers_all poh

185: and nvl(poi.number_of_bids,0) = 0 ;
186:
187: select count(*)
188: into p_no_bid_closed
189: from pon_auction_item_prices_all poi, pon_auction_headers_all poh
190: where poi.auction_header_id = p_auction_id
191: and poh.auction_header_id = poi.auction_header_id
192: and poh.open_bidding_date < sysdate
193: and nvl(poi.close_bidding_date, poh.close_bidding_date) <= sysdate

Line 198: from pon_auction_item_prices_all poi, pon_auction_headers_all poh

194: and nvl(poi.number_of_bids,0) = 0 ;
195:
196: select count(*)
197: into p_part_bid_open
198: from pon_auction_item_prices_all poi, pon_auction_headers_all poh
199: where poi.auction_header_id = p_auction_id
200: and poh.auction_header_id = poi.auction_header_id
201: and poh.open_bidding_date < sysdate
202: and nvl(poi.close_bidding_date, poh.close_bidding_date) > sysdate

Line 212: from pon_auction_item_prices_all poi, pon_auction_headers_all poh

208: and pbi.line_number = poi.line_number);
209:
210: select count(*)
211: into p_part_bid_closed
212: from pon_auction_item_prices_all poi, pon_auction_headers_all poh
213: where poi.auction_header_id = p_auction_id
214: and poh.auction_header_id = poi.auction_header_id
215: and poh.open_bidding_date < sysdate
216: and nvl(poi.close_bidding_date, poh.close_bidding_date) <= sysdate

Line 226: from pon_auction_item_prices_all poi, pon_auction_headers_all poh

222: and pbi.line_number = poi.line_number);
223:
224: select count(*)
225: into p_full_bid_open
226: from pon_auction_item_prices_all poi, pon_auction_headers_all poh
227: where poi.auction_header_id = p_auction_id
228: and poh.auction_header_id = poi.auction_header_id
229: and poh.open_bidding_date < sysdate
230: and nvl(poi.close_bidding_date, poh.close_bidding_date) > sysdate

Line 242: from pon_auction_item_prices_all poi, pon_auction_headers_all poh

238:
239:
240: select count(*)
241: into p_full_bid_closed
242: from pon_auction_item_prices_all poi, pon_auction_headers_all poh
243: where poi.auction_header_id = p_auction_id
244: and poh.open_bidding_date < sysdate
245: and poh.auction_header_id = poi.auction_header_id
246: and nvl(poi.close_bidding_date, poh.close_bidding_date) <= sysdate