APPS.PON_AUCTION_PO_PKG dependencies on PON_BID_HEADERS

Line 41: * the po_number in pon_bid_headers table for a given org_id,po_number

37: END check_unique;
38:
39: /*-----------------------------------------------------------------
40: * check_unique: This procedure will check for the uniquesness of
41: * the po_number in pon_bid_headers table for a given org_id,po_number
42: * and bid_number. Added p_bid_number for bug 12344470 fix
43: *----------------------------------------------------------------*/
44:
45: PROCEDURE check_unique(org_id IN NUMBER,

Line 58: FROM pon_bid_headers pbh, pon_auction_headers_all pah

54: x_number_of_pos := 0;
55:
56: SELECT count(*)
57: INTO x_number_of_pos
58: FROM pon_bid_headers pbh, pon_auction_headers_all pah
59: WHERE pbh.order_number = po_number and
60: nvl(pah.org_id, -9999) = nvl(org_id,-9999) and
61: pbh.auction_header_id = pah.auction_header_id and
62: pbh.bid_number <> nvl(p_bid_number, -1);

Line 453: header_note pon_bid_headers.note_to_auction_owner%TYPE;

449: p_error_msg OUT NOCOPY VARCHAR2) IS
450:
451: newline varchar2(256);
452: tab varchar2(256);
453: header_note pon_bid_headers.note_to_auction_owner%TYPE;
454: line_note pon_bid_item_prices.note_to_auction_owner%TYPE;
455: msgBidHeaderNote varchar2(2000);
456: msgBidLineNote varchar2(2000);
457: x_msg_suffix VARCHAR2(3) := '';

Line 483: FROM pon_bid_headers pbh, pon_bid_item_prices pbip

479:
480: IF l_contract_type <> 'CONTRACT' THEN
481: SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13)), replace(pbip.note_to_auction_owner, fnd_global.local_chr(13))
482: INTO header_note, line_note
483: FROM pon_bid_headers pbh, pon_bid_item_prices pbip
484: WHERE pbh.auction_header_id = p_auction_header_id and
485: pbh.bid_number = p_bid_number and
486: pbip.bid_number = pbh.bid_number and
487: pbip.line_number = p_line_number;

Line 491: FROM pon_bid_headers pbh

487: pbip.line_number = p_line_number;
488: ELSE
489: SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13))
490: INTO header_note
491: FROM pon_bid_headers pbh
492: WHERE pbh.auction_header_id = p_auction_header_id and
493: pbh.bid_number = p_bid_number;
494: END IF; -- if contractType <> 'CONTRACT
495: