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.IEX_PAYMENT_CAMP_RPT_PKG dependencies on DBMS_XMLQUERY

Line 79: ctx DBMS_XMLQUERY.ctxType;

75: p_goal_amount NUMBER )
76: IS
77: l_api_name CONSTANT VARCHAR2(30) := 'gen_xml_data_pcamp';
78: l_api_version CONSTANT NUMBER := 1.0;
79: ctx DBMS_XMLQUERY.ctxType;
80: result CLOB;
81: qryCtx DBMS_XMLquery.ctxHandle;
82: l_result CLOB;
83: tempResult CLOB;

Line 81: qryCtx DBMS_XMLquery.ctxHandle;

77: l_api_name CONSTANT VARCHAR2(30) := 'gen_xml_data_pcamp';
78: l_api_version CONSTANT NUMBER := 1.0;
79: ctx DBMS_XMLQUERY.ctxType;
80: result CLOB;
81: qryCtx DBMS_XMLquery.ctxHandle;
82: l_result CLOB;
83: tempResult CLOB;
84: l_where VARCHAR2(8000):='';
85: l_group_by VARCHAR2(4000);

Line 97: queryCtx DBMS_XMLquery.ctxType;

93: l_xml_header CLOB;--varchar2(4000);
94: l_xml_header_length NUMBER;
95: l_errNo NUMBER;
96: l_errMsg VARCHAR2(200);
97: queryCtx DBMS_XMLquery.ctxType;
98: l_xml_query VARCHAR2(32767);
99: TYPE ref_cur IS REF CURSOR;
100: l_xml_stmt ref_cur;
101: l_rows_processed NUMBER;

Line 252: ctx := DBMS_XMLQUERY.newContext(l_query);

248: l_order_by :=' order by d.cust_account_id,p.payment_id';
249: l_query:=l_query||l_where;
250: l_query:=l_query||l_order_by;
251: FND_FILE.put_line( FND_FILE.LOG,'qry-->'||l_query);
252: ctx := DBMS_XMLQUERY.newContext(l_query);
253: --FND_FILE.put_line( FND_FILE.LOG,'21');
254: END IF;
255: --report mode SUMMARY
256: IF p_summ_det = 'SUMMARY' THEN

Line 305: ctx := DBMS_XMLQUERY.newContext(l_query);

301: l_query:=l_query||l_where;
302: l_query:=l_query||l_group_by;
303: --call procedure to calculate pmt_cnt and pmt_amt
304: FND_FILE.put_line( FND_FILE.LOG,'l_query_summ-->'||l_query);
305: ctx := DBMS_XMLQUERY.newContext(l_query);
306: -- FND_FILE.put_line( FND_FILE.LOG,'7.5');
307: END IF;
308: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);
309:

Line 308: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);

304: FND_FILE.put_line( FND_FILE.LOG,'l_query_summ-->'||l_query);
305: ctx := DBMS_XMLQUERY.newContext(l_query);
306: -- FND_FILE.put_line( FND_FILE.LOG,'7.5');
307: END IF;
308: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);
309:
310: -- Bind Mandatory Variables
311: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_from', p_date_from);
312: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_to', p_date_to);

Line 311: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_from', p_date_from);

307: END IF;
308: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);
309:
310: -- Bind Mandatory Variables
311: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_from', p_date_from);
312: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_to', p_date_to);
313:
314: --get the result
315: BEGIN

Line 312: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_to', p_date_to);

308: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);
309:
310: -- Bind Mandatory Variables
311: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_from', p_date_from);
312: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_to', p_date_to);
313:
314: --get the result
315: BEGIN
316: l_result := DBMS_XMLQUERY.getXML(ctx);

Line 316: l_result := DBMS_XMLQUERY.getXML(ctx);

312: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_to', p_date_to);
313:
314: --get the result
315: BEGIN
316: l_result := DBMS_XMLQUERY.getXML(ctx);
317: DBMS_XMLQUERY.closeContext(ctx);
318: l_rows_processed := 1;
319: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));
320: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);

Line 317: DBMS_XMLQUERY.closeContext(ctx);

313:
314: --get the result
315: BEGIN
316: l_result := DBMS_XMLQUERY.getXML(ctx);
317: DBMS_XMLQUERY.closeContext(ctx);
318: l_rows_processed := 1;
319: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));
320: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);
321: EXCEPTION

Line 323: DBMS_XMLQUERY.getExceptionContent(ctx,l_errNo,l_errMsg);

319: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));
320: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);
321: EXCEPTION
322: WHEN OTHERS THEN
323: DBMS_XMLQUERY.getExceptionContent(ctx,l_errNo,l_errMsg);
324: FND_FILE.put_line( FND_FILE.LOG,'l_errMsg-->'||l_errMsg);
325: IF l_errNo = 1403 THEN
326: l_rows_processed := 0;
327: END IF;

Line 328: DBMS_XMLQUERY.closeContext(ctx);

324: FND_FILE.put_line( FND_FILE.LOG,'l_errMsg-->'||l_errMsg);
325: IF l_errNo = 1403 THEN
326: l_rows_processed := 0;
327: END IF;
328: DBMS_XMLQUERY.closeContext(ctx);
329: END;
330: IF l_rows_processed <> 0 THEN
331: -- FND_FILE.put_line( FND_FILE.LOG,'8') ;
332: