APPS.PON_CLM_UTIL_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 28: select nvl(amendment_flag,'N') into l_is_amendment from pon_auction_headers_all

24:
25: FUNCTION IS_AMENDMENT(p_auction_header_id IN NUMBER) RETURN VARCHAR2 IS
26: l_is_amendment varchar2(1);
27: BEGIN
28: select nvl(amendment_flag,'N') into l_is_amendment from pon_auction_headers_all
29: where auction_header_id = p_auction_header_id;
30: return l_is_amendment;
31: END IS_AMENDMENT;
32:

Line 40: from pon_auction_headers_all auh

36: BEGIN
37:
38: select auh.doctype_id
39: into l_doctype_id
40: from pon_auction_headers_all auh
41: where auh.auction_header_id = p_auction_header_id;
42: l_is_doc_federal := is_document_federal(l_doctype_id);
43:
44:

Line 93: update pon_auction_headers_all

89: message => 'BEGIN ::' || p_auction_header_id || ':::'
90: || p_style_id);
91: END IF;
92:
93: update pon_auction_headers_all
94: set po_style_id = p_style_id
95: where
96: auction_header_id = p_auction_header_id;
97:

Line 275: docNumber PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

271:
272: /* Bug 10056890 - Added the following function to return document number in CLM Format. */
273:
274: FUNCTION GET_DOCUMENT_NUMBER(p_auction_header_id IN Number) return varchar2 AS
275: docNumber PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
276: BEGIN
277: SELECT document_number INTO docNumber FROM pon_auction_headers_all
278: WHERE auction_header_id = p_auction_header_id;
279:

Line 277: SELECT document_number INTO docNumber FROM pon_auction_headers_all

273:
274: FUNCTION GET_DOCUMENT_NUMBER(p_auction_header_id IN Number) return varchar2 AS
275: docNumber PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
276: BEGIN
277: SELECT document_number INTO docNumber FROM pon_auction_headers_all
278: WHERE auction_header_id = p_auction_header_id;
279:
280: IF docNumber IS NULL THEN
281: RETURN p_auction_header_id;

Line 324: L_DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

320:
321: FUNCTION GET_CLM_COMMERCIAL_DOC_NUMBER(P_AUCTION_HEADER_ID IN NUMBER) RETURN VARCHAR2
322: IS
323: L_IS_DOCUMENT_FEDERAL NUMBER:=0;
324: L_DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
325: BEGIN
326:
327: /* Offer Enhancements Changes */
328: L_IS_DOCUMENT_FEDERAL:= IS_NEG_DOCUMENT_FEDERAL(P_AUCTION_HEADER_ID);

Line 367: update pon_auction_headers_all

363: module => l_api_name,
364: message => 'BEGIN ::' || p_auction_header_id || ':::'
365: || p_program_id);
366: END IF;
367: update pon_auction_headers_all
368: set umbrella_program_id = p_program_id
369: where
370: auction_header_id = p_auction_header_id;
371: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 404: FROM financials_system_params_all fsp, pon_auction_headers_all pah

400: END IF;
401:
402:
403: SELECT nvl(fsp.purch_encumbrance_flag, 'N'), pah.contract_type INTO l_encumberence_flag,l_outcome_document_type
404: FROM financials_system_params_all fsp, pon_auction_headers_all pah
405: where pah.auction_header_id = p_auction_header_id
406: and fsp.org_id = pah.org_id ;
407:
408: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN