APPS.PON_UNSOL_UTIL_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 12: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;

8: p_line_number IN NUMBER)
9: IS
10:
11: l_module_name VARCHAR2 (30);
12: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
13:
14: BEGIN
15: l_module_name := 'DELETE_LINE';
16:

Line 19: FROM pon_auction_headers_all

15: l_module_name := 'DELETE_LINE';
16:
17: SELECT doctype_id
18: INTO l_doctype_id
19: FROM pon_auction_headers_all
20: WHERE auction_header_id = p_auction_header_id;
21:
22: --Delete item references.
23: DELETE FROM

Line 155: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;

151: x_error_message OUT NOCOPY VARCHAR2)
152: IS
153:
154: l_module_name VARCHAR2 (30);
155: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
156:
157: CURSOR all_lines IS
158: SELECT line_number
159: FROM pon_bid_item_prices

Line 171: FROM pon_auction_headers_all

167: x_result := 'S';
168:
169: SELECT doctype_id
170: INTO l_doctype_id
171: FROM pon_auction_headers_all
172: WHERE auction_header_id = p_auction_header_id;
173:
174: --Delete item references.
175: DELETE FROM

Line 298: FROM pon_auction_headers_all

294: l_unsol_lines_allowed := 'N';
295:
296: SELECT Nvl(ALLOW_UNSOL_OFFER_LINES,'N')
297: INTO l_unsol_lines_allowed
298: FROM pon_auction_headers_all
299: WHERE auction_header_id = p_auc_header_id;
300:
301: RETURN l_unsol_lines_allowed;
302:

Line 320: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;

316: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
317: p_userid IN pon_bid_headers.created_by%TYPE,
318: p_vensid IN pon_bid_headers.vendor_site_id%TYPE)
319: IS
320: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
321: BEGIN
322: SELECT ah.trading_partner_id
323: INTO l_auctpid
324: FROM pon_auction_headers_all ah

Line 324: FROM pon_auction_headers_all ah

320: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
321: BEGIN
322: SELECT ah.trading_partner_id
323: INTO l_auctpid
324: FROM pon_auction_headers_all ah
325: WHERE ah.auction_header_id = p_auction_id;
326:
327: INSERT INTO pon_bid_item_prices
328: (