APPS.PON_AUCTION_PO_PKG dependencies on PON_BID_HEADERS

Line 39: FROM pon_bid_headers pbh, pon_auction_headers_all pah

35: x_number_of_pos := 0;
36:
37: SELECT count(*)
38: INTO x_number_of_pos
39: FROM pon_bid_headers pbh, pon_auction_headers_all pah
40: WHERE pbh.order_number = po_number and
41: nvl(pah.org_id, -9999) = nvl(org_id,-9999) and
42: pbh.auction_header_id = pah.auction_header_id;
43:

Line 321: header_note pon_bid_headers.note_to_auction_owner%TYPE;

317: p_error_msg OUT NOCOPY VARCHAR2) IS
318:
319: newline varchar2(256);
320: tab varchar2(256);
321: header_note pon_bid_headers.note_to_auction_owner%TYPE;
322: line_note pon_bid_item_prices.note_to_auction_owner%TYPE;
323: msgBidHeaderNote varchar2(2000);
324: msgBidLineNote varchar2(2000);
325: x_msg_suffix VARCHAR2(3) := '';

Line 351: FROM pon_bid_headers pbh, pon_bid_item_prices pbip

347:
348: IF l_contract_type <> 'CONTRACT' THEN
349: SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13)), replace(pbip.note_to_auction_owner, fnd_global.local_chr(13))
350: INTO header_note, line_note
351: FROM pon_bid_headers pbh, pon_bid_item_prices pbip
352: WHERE pbh.auction_header_id = p_auction_header_id and
353: pbh.bid_number = p_bid_number and
354: pbip.bid_number = pbh.bid_number and
355: pbip.line_number = p_line_number;

Line 359: FROM pon_bid_headers pbh

355: pbip.line_number = p_line_number;
356: ELSE
357: SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13))
358: INTO header_note
359: FROM pon_bid_headers pbh
360: WHERE pbh.auction_header_id = p_auction_header_id and
361: pbh.bid_number = p_bid_number;
362: END IF; -- if contractType <> 'CONTRACT
363: