eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_CLM_UTIL_PKG dependencies on PON_AUCTION_HEADERS

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 190: PADR.BIZRULE_ID = PAB.BIZRULE_ID AND PADR.DOCTYPE_ID = PON_AUCTION_HEADERS.DOCTYPE_ID AND

186: END IF;
187:
188: IF ProfileValue <> 'N' THEN
189: return ' exists ( SELECT PADR.DEFAULT_VALUE FROM PON_AUC_DOCTYPE_RULES PADR, PON_AUC_BIZRULES PAB WHERE
190: PADR.BIZRULE_ID = PAB.BIZRULE_ID AND PADR.DOCTYPE_ID = PON_AUCTION_HEADERS.DOCTYPE_ID AND
191: PAB.NAME = ''FEDERAL_NEGOTIATION'' AND PADR.DEFAULT_VALUE = ''Y'') ';
192: ELSE
193: return ' not exists ( SELECT PADR.DEFAULT_VALUE FROM PON_AUC_DOCTYPE_RULES PADR, PON_AUC_BIZRULES PAB WHERE
194: PADR.BIZRULE_ID = PAB.BIZRULE_ID AND PADR.DOCTYPE_ID = PON_AUCTION_HEADERS.DOCTYPE_ID AND

Line 194: PADR.BIZRULE_ID = PAB.BIZRULE_ID AND PADR.DOCTYPE_ID = PON_AUCTION_HEADERS.DOCTYPE_ID AND

190: PADR.BIZRULE_ID = PAB.BIZRULE_ID AND PADR.DOCTYPE_ID = PON_AUCTION_HEADERS.DOCTYPE_ID AND
191: PAB.NAME = ''FEDERAL_NEGOTIATION'' AND PADR.DEFAULT_VALUE = ''Y'') ';
192: ELSE
193: return ' not exists ( SELECT PADR.DEFAULT_VALUE FROM PON_AUC_DOCTYPE_RULES PADR, PON_AUC_BIZRULES PAB WHERE
194: PADR.BIZRULE_ID = PAB.BIZRULE_ID AND PADR.DOCTYPE_ID = PON_AUCTION_HEADERS.DOCTYPE_ID AND
195: PAB.NAME = ''FEDERAL_NEGOTIATION'' AND PADR.DEFAULT_VALUE = ''Y'') ';
196: END IF;
197: ELSE
198: return ' 1=1 ';

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 334: PON_AUCTION_HEADERS

330: IF L_IS_DOCUMENT_FEDERAL=1
331: THEN
332: SELECT DOCUMENT_NUMBER INTO L_DOCUMENT_NUMBER
333: FROM
334: PON_AUCTION_HEADERS
335: WHERE
336: AUCTION_HEADER_ID=(SELECT AUCTION_HEADER_ID_ORIG_ROUND
337: FROM
338: PON_AUCTION_HEADERS PAH2

Line 338: PON_AUCTION_HEADERS PAH2

334: PON_AUCTION_HEADERS
335: WHERE
336: AUCTION_HEADER_ID=(SELECT AUCTION_HEADER_ID_ORIG_ROUND
337: FROM
338: PON_AUCTION_HEADERS PAH2
339: WHERE
340: PAH2.AUCTION_HEADER_ID=P_AUCTION_HEADER_ID
341: );
342: ELSE

Line 345: PON_AUCTION_HEADERS

341: );
342: ELSE
343: SELECT DOCUMENT_NUMBER INTO L_DOCUMENT_NUMBER
344: FROM
345: PON_AUCTION_HEADERS
346: WHERE
347: AUCTION_HEADER_ID=P_AUCTION_HEADER_ID;
348: END IF;
349:

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