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_COLL_RPT_PKG dependencies on DBMS_XMLQUERY

Line 78: ctx DBMS_XMLQUERY.ctxType;

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

Line 80: qryCtx DBMS_XMLquery.ctxHandle;

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

Line 96: queryCtx DBMS_XMLquery.ctxType;

92: l_xml_header CLOB;
93: l_xml_header_length NUMBER;
94: l_errNo NUMBER;
95: l_errMsg VARCHAR2(200);
96: queryCtx DBMS_XMLquery.ctxType;
97: l_xml_query VARCHAR2(32767);
98: l_collector varchar2(200);
99: l_org_id varchar2(100);
100: TYPE ref_cur

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

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

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

295: l_query:=l_query||l_where;
296: l_query:=l_query||l_group_by;
297: --call procedure to calculate pmt_cnt and pmt_amt
298: FND_FILE.put_line( FND_FILE.LOG,'l_query_summ-->'||l_query);
299: ctx := DBMS_XMLQUERY.newContext(l_query);
300: -- FND_FILE.put_line( FND_FILE.LOG,'7.5');
301: END IF;
302: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);
303:

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

298: FND_FILE.put_line( FND_FILE.LOG,'l_query_summ-->'||l_query);
299: ctx := DBMS_XMLQUERY.newContext(l_query);
300: -- FND_FILE.put_line( FND_FILE.LOG,'7.5');
301: END IF;
302: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);
303:
304: -- Bind Mandatory Variables
305: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_from', p_date_from);
306: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_to', p_date_to);

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

301: END IF;
302: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);
303:
304: -- Bind Mandatory Variables
305: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_from', p_date_from);
306: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_to', p_date_to);
307:
308: --get the result
309: BEGIN

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

302: DBMS_XMLQUERY.setRaiseNoRowsException(ctx,TRUE);
303:
304: -- Bind Mandatory Variables
305: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_from', p_date_from);
306: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_to', p_date_to);
307:
308: --get the result
309: BEGIN
310: l_result := DBMS_XMLQUERY.getXML(ctx);

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

306: -- DBMS_XMLQUERY.setBindValue(ctx, 'p_date_to', p_date_to);
307:
308: --get the result
309: BEGIN
310: l_result := DBMS_XMLQUERY.getXML(ctx);
311: DBMS_XMLQUERY.closeContext(ctx);
312: l_rows_processed := 1;
313: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));
314: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);

Line 311: DBMS_XMLQUERY.closeContext(ctx);

307:
308: --get the result
309: BEGIN
310: l_result := DBMS_XMLQUERY.getXML(ctx);
311: DBMS_XMLQUERY.closeContext(ctx);
312: l_rows_processed := 1;
313: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));
314: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);
315: EXCEPTION

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

313: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));
314: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);
315: EXCEPTION
316: WHEN OTHERS THEN
317: DBMS_XMLQUERY.getExceptionContent(ctx,l_errNo,l_errMsg);
318: FND_FILE.put_line( FND_FILE.LOG,'l_errMsg-->'||l_errMsg);
319: IF l_errNo = 1403 THEN
320: l_rows_processed := 0;
321: END IF;

Line 322: DBMS_XMLQUERY.closeContext(ctx);

318: FND_FILE.put_line( FND_FILE.LOG,'l_errMsg-->'||l_errMsg);
319: IF l_errNo = 1403 THEN
320: l_rows_processed := 0;
321: END IF;
322: DBMS_XMLQUERY.closeContext(ctx);
323: END;
324: IF l_rows_processed <> 0 THEN
325: -- FND_FILE.put_line( FND_FILE.LOG,'8') ;
326: