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.FUN_XML_REPORT_PKG dependencies on DBMS_XMLGEN

Line 114: l_qryCtx DBMS_XMLGEN.ctxHandle;

110: errbuf OUT NOCOPY VARCHAR2,
111: retcode OUT NOCOPY NUMBER,
112: p_batch_id IN VARCHAR2 ) IS
113:
114: l_qryCtx DBMS_XMLGEN.ctxHandle;
115: l_result_clob CLOB;
116: l_current_calling_sequence varchar2(2000);
117: l_debug_info varchar2(200);
118:

Line 156: l_qryCtx := DBMS_XMLGEN.newContext(

152: put_starttag('?xml version="1.0" encoding="'||l_encoding||'"?');
153: put_starttag('NETTING_REPORT');
154:
155: --Bug: 13628570
156: l_qryCtx := DBMS_XMLGEN.newContext(
157: 'SELECT HOU.NAME AS OPERATING_UNIT,
158: FNA.AGREEMENT_NAME,
159: SYSDATE AS REPORT_RUN_DATE,
160: FNA.AGREEMENT_START_DATE,

Line 203: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'BATCH_DETAILS_SET');

199: AND YesNo.LOOKUP_CODE = FNA.SEL_REC_PAST_DUE_TXNS_FLAG
200: AND FNB.BATCH_ID = :BATCH_ID');
201:
202:
203: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'BATCH_DETAILS_SET');
204: DBMS_XMLGEN.setRowTag(l_qryCtx, 'BATCH_DETAILS');
205: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
206: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
207: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);

Line 204: DBMS_XMLGEN.setRowTag(l_qryCtx, 'BATCH_DETAILS');

200: AND FNB.BATCH_ID = :BATCH_ID');
201:
202:
203: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'BATCH_DETAILS_SET');
204: DBMS_XMLGEN.setRowTag(l_qryCtx, 'BATCH_DETAILS');
205: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
206: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
207: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
208:

Line 205: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);

201:
202:
203: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'BATCH_DETAILS_SET');
204: DBMS_XMLGEN.setRowTag(l_qryCtx, 'BATCH_DETAILS');
205: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
206: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
207: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
208:
209: l_batch_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

Line 206: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

202:
203: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'BATCH_DETAILS_SET');
204: DBMS_XMLGEN.setRowTag(l_qryCtx, 'BATCH_DETAILS');
205: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
206: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
207: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
208:
209: l_batch_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
210: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 209: l_batch_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

205: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
206: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
207: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
208:
209: l_batch_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
210: DBMS_XMLGEN.closeContext(l_qryCtx);
211: clob_to_file(l_result_clob);
212:
213:

Line 210: DBMS_XMLGEN.closeContext(l_qryCtx);

206: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
207: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
208:
209: l_batch_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
210: DBMS_XMLGEN.closeContext(l_qryCtx);
211: clob_to_file(l_result_clob);
212:
213:
214: l_debug_info := 'Select AP invoices...';

Line 255: l_qryCtx := DBMS_XMLGEN.newContext(

251: put_element('SUPPLIER_TAXPAYER_ID',rec.SUPPLIER_TAXPAYER_ID);
252: put_element('SUPPLIER_TAX_REGN_NUM',rec.SUPPLIER_TAX_REGN_NUM);
253:
254:
255: l_qryCtx := DBMS_XMLGEN.newContext(
256: 'SELECT
257: API.INVOICE_NUM,
258: ALC.DISPLAYED_FIELD AS INVOICE_TYPE,
259: API.INVOICE_DATE AS INVOICE_DATE,

Line 318: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'INVOICE_SET');

314: ORDER BY
315: API.INVOICE_NUM');
316:
317:
318: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'INVOICE_SET');
319: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');
320: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
321: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.supplier_id);
322: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.site_id);

Line 319: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');

315: API.INVOICE_NUM');
316:
317:
318: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'INVOICE_SET');
319: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');
320: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
321: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.supplier_id);
322: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.site_id);
323: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

Line 320: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);

316:
317:
318: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'INVOICE_SET');
319: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');
320: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
321: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.supplier_id);
322: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.site_id);
323: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
324: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);

Line 321: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.supplier_id);

317:
318: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'INVOICE_SET');
319: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');
320: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
321: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.supplier_id);
322: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.site_id);
323: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
324: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
325: l_temp_invoice_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

Line 322: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.site_id);

318: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'INVOICE_SET');
319: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');
320: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
321: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.supplier_id);
322: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.site_id);
323: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
324: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
325: l_temp_invoice_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
326: l_invoice_count := l_invoice_count + l_temp_invoice_count;

Line 323: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

319: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');
320: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
321: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.supplier_id);
322: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.site_id);
323: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
324: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
325: l_temp_invoice_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
326: l_invoice_count := l_invoice_count + l_temp_invoice_count;
327: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 325: l_temp_invoice_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

321: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.supplier_id);
322: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.site_id);
323: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
324: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
325: l_temp_invoice_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
326: l_invoice_count := l_invoice_count + l_temp_invoice_count;
327: DBMS_XMLGEN.closeContext(l_qryCtx);
328: clob_to_file(l_result_clob);
329:

Line 327: DBMS_XMLGEN.closeContext(l_qryCtx);

323: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
324: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
325: l_temp_invoice_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
326: l_invoice_count := l_invoice_count + l_temp_invoice_count;
327: DBMS_XMLGEN.closeContext(l_qryCtx);
328: clob_to_file(l_result_clob);
329:
330: put_endtag('SUPPLIER_RECORD');
331:

Line 380: l_qryCtx := DBMS_XMLGEN.newContext(

376: put_element('LOCATION',rec.LOCATION);
377: put_element('CUST_TAXPAYER_ID',rec.CUST_TAXPAYER_ID);
378: put_element('CUST_TAX_REGN_NUM',rec.CUST_TAX_REGN_NUM);
379:
380: l_qryCtx := DBMS_XMLGEN.newContext(
381: 'SELECT
382: RCT.TRX_NUMBER,
383: RCTT.NAME AS TRX_TYPE,
384: RCT.TRX_DATE,

Line 446: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'TRANSACTION_SET');

442: FNAR.OPEN_AMT,FNB.batch_id, RCT.CUSTOMER_TRX_ID, FNAR.APPLIED_DISC,FNAR.NETTED_AMT
443: ORDER BY
444: RCT.TRX_NUMBER');
445:
446: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'TRANSACTION_SET');
447: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');
448: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
449: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
450: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);

Line 447: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');

443: ORDER BY
444: RCT.TRX_NUMBER');
445:
446: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'TRANSACTION_SET');
447: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');
448: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
449: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
450: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);
451: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

Line 448: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);

444: RCT.TRX_NUMBER');
445:
446: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'TRANSACTION_SET');
447: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');
448: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
449: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
450: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);
451: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
452: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);

Line 449: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);

445:
446: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'TRANSACTION_SET');
447: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');
448: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
449: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
450: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);
451: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
452: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
453: l_temp_trx_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

Line 450: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);

446: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'TRANSACTION_SET');
447: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');
448: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
449: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
450: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);
451: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
452: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
453: l_temp_trx_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
454: l_trx_count := l_trx_count + l_temp_trx_count;

Line 451: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

447: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');
448: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
449: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
450: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);
451: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
452: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
453: l_temp_trx_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
454: l_trx_count := l_trx_count + l_temp_trx_count;
455: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 453: l_temp_trx_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

449: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
450: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);
451: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
452: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
453: l_temp_trx_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
454: l_trx_count := l_trx_count + l_temp_trx_count;
455: DBMS_XMLGEN.closeContext(l_qryCtx);
456: clob_to_file(l_result_clob);
457:

Line 455: DBMS_XMLGEN.closeContext(l_qryCtx);

451: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
452: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
453: l_temp_trx_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
454: l_trx_count := l_trx_count + l_temp_trx_count;
455: DBMS_XMLGEN.closeContext(l_qryCtx);
456: clob_to_file(l_result_clob);
457:
458: put_endtag('CUSTOMER_RECORD');
459:

Line 492: l_qryCtx DBMS_XMLGEN.ctxHandle;

488: errbuf OUT NOCOPY VARCHAR2,
489: retcode OUT NOCOPY NUMBER,
490: p_batch_id IN VARCHAR2 ) IS
491:
492: l_qryCtx DBMS_XMLGEN.ctxHandle;
493: l_result_clob CLOB;
494: l_current_calling_sequence varchar2(2000);
495: l_debug_info varchar2(200);
496:

Line 535: l_qryCtx := DBMS_XMLGEN.newContext(

531: put_starttag('NETTING_REPORT');
532:
533: --Bug: 13628570
534:
535: l_qryCtx := DBMS_XMLGEN.newContext(
536: 'SELECT HOU.NAME AS OPERATING_UNIT,
537: FNA.AGREEMENT_NAME,
538: SYSDATE AS REPORT_RUN_DATE,
539: FNA.AGREEMENT_START_DATE,

Line 583: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'BATCH_DETAILS_SET');

579: AND YesNo.LOOKUP_CODE = FNA.SEL_REC_PAST_DUE_TXNS_FLAG
580: AND FNB.BATCH_ID = :BATCH_ID');
581:
582:
583: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'BATCH_DETAILS_SET');
584: DBMS_XMLGEN.setRowTag(l_qryCtx, 'BATCH_DETAILS');
585: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
586: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
587: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);

Line 584: DBMS_XMLGEN.setRowTag(l_qryCtx, 'BATCH_DETAILS');

580: AND FNB.BATCH_ID = :BATCH_ID');
581:
582:
583: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'BATCH_DETAILS_SET');
584: DBMS_XMLGEN.setRowTag(l_qryCtx, 'BATCH_DETAILS');
585: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
586: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
587: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
588:

Line 585: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);

581:
582:
583: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'BATCH_DETAILS_SET');
584: DBMS_XMLGEN.setRowTag(l_qryCtx, 'BATCH_DETAILS');
585: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
586: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
587: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
588:
589: l_batch_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

Line 586: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

582:
583: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'BATCH_DETAILS_SET');
584: DBMS_XMLGEN.setRowTag(l_qryCtx, 'BATCH_DETAILS');
585: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
586: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
587: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
588:
589: l_batch_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
590: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 589: l_batch_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

585: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
586: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
587: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
588:
589: l_batch_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
590: DBMS_XMLGEN.closeContext(l_qryCtx);
591: clob_to_file(l_result_clob);
592:
593:

Line 590: DBMS_XMLGEN.closeContext(l_qryCtx);

586: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
587: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
588:
589: l_batch_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
590: DBMS_XMLGEN.closeContext(l_qryCtx);
591: clob_to_file(l_result_clob);
592:
593:
594: l_debug_info := 'Select AP invoices...';

Line 665: l_qryCtx := DBMS_XMLGEN.newContext(

661: put_element('SUPPLIER_ZIP',rec.SUPPLIER_ZIP);
662: put_element('CONTACT_FIRST_LAST_NAME',rec.CONTACT_FIRST_LAST_NAME);
663:
664:
665: l_qryCtx := DBMS_XMLGEN.newContext(
666: 'SELECT
667: API.INVOICE_NUM,
668: ALC.DISPLAYED_FIELD AS INVOICE_TYPE,
669: API.INVOICE_DATE AS INVOICE_DATE,

Line 725: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'INVOICE_SET');

721: ORDER BY
722: API.INVOICE_NUM');
723:
724:
725: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'INVOICE_SET');
726: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');
727: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
728: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.SUPPLIER_ID);
729: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.SITE_ID);

Line 726: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');

722: API.INVOICE_NUM');
723:
724:
725: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'INVOICE_SET');
726: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');
727: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
728: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.SUPPLIER_ID);
729: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.SITE_ID);
730: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

Line 727: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);

723:
724:
725: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'INVOICE_SET');
726: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');
727: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
728: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.SUPPLIER_ID);
729: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.SITE_ID);
730: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
731: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);

Line 728: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.SUPPLIER_ID);

724:
725: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'INVOICE_SET');
726: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');
727: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
728: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.SUPPLIER_ID);
729: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.SITE_ID);
730: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
731: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
732: l_temp_invoice_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

Line 729: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.SITE_ID);

725: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'INVOICE_SET');
726: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');
727: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
728: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.SUPPLIER_ID);
729: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.SITE_ID);
730: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
731: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
732: l_temp_invoice_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
733: l_invoice_count := l_invoice_count + l_temp_invoice_count;

Line 730: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

726: DBMS_XMLGEN.setRowTag(l_qryCtx, 'INVOICE_RECORD');
727: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
728: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.SUPPLIER_ID);
729: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.SITE_ID);
730: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
731: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
732: l_temp_invoice_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
733: l_invoice_count := l_invoice_count + l_temp_invoice_count;
734: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 732: l_temp_invoice_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

728: DBMS_XMLGEN.setBindValue(l_qryCtx,'SUPPLIER_ID', rec.SUPPLIER_ID);
729: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_ID', rec.SITE_ID);
730: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
731: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
732: l_temp_invoice_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
733: l_invoice_count := l_invoice_count + l_temp_invoice_count;
734: DBMS_XMLGEN.closeContext(l_qryCtx);
735: clob_to_file(l_result_clob);
736:

Line 734: DBMS_XMLGEN.closeContext(l_qryCtx);

730: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
731: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
732: l_temp_invoice_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
733: l_invoice_count := l_invoice_count + l_temp_invoice_count;
734: DBMS_XMLGEN.closeContext(l_qryCtx);
735: clob_to_file(l_result_clob);
736:
737: put_endtag('SUPPLIER_RECORD');
738:

Line 808: l_qryCtx := DBMS_XMLGEN.newContext(

804: put_element('CUSTOMER_STATE',rec.CUSTOMER_STATE);
805: put_element('CUSTOMER_POSTAL_CODE',rec.CUSTOMER_POSTAL_CODE);
806: --put_element('CONTACT_CUSTOMER_NAME',rec.CONTACT_CUSTOMER_NAME); /8787753
807:
808: l_qryCtx := DBMS_XMLGEN.newContext(
809: 'SELECT
810: RCT.TRX_NUMBER,
811: RCTT.NAME AS TRX_TYPE,
812: RCT.TRX_DATE,

Line 879: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'TRANSACTION_SET');

875: ORDER BY
876: RCT.TRX_NUMBER');
877:
878:
879: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'TRANSACTION_SET');
880: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');
881: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
882: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
883: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);

Line 880: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');

876: RCT.TRX_NUMBER');
877:
878:
879: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'TRANSACTION_SET');
880: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');
881: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
882: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
883: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);
884: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

Line 881: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);

877:
878:
879: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'TRANSACTION_SET');
880: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');
881: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
882: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
883: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);
884: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
885: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);

Line 882: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);

878:
879: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'TRANSACTION_SET');
880: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');
881: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
882: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
883: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);
884: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
885: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
886: l_temp_trx_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

Line 883: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);

879: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'TRANSACTION_SET');
880: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');
881: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
882: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
883: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);
884: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
885: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
886: l_temp_trx_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
887: l_trx_count := l_trx_count + l_temp_trx_count;

Line 884: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

880: DBMS_XMLGEN.setRowTag(l_qryCtx, 'TRANSACTION_RECORD');
881: DBMS_XMLGEN.setBindValue(l_qryCtx,'BATCH_ID', p_batch_id);
882: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
883: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);
884: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
885: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
886: l_temp_trx_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
887: l_trx_count := l_trx_count + l_temp_trx_count;
888: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 886: l_temp_trx_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

882: DBMS_XMLGEN.setBindValue(l_qryCtx,'CUST_ACCOUNT_ID', rec.CUST_ACCOUNT_ID);
883: DBMS_XMLGEN.setBindValue(l_qryCtx,'SITE_USE_ID', rec.SITE_USE_ID);
884: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
885: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
886: l_temp_trx_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
887: l_trx_count := l_trx_count + l_temp_trx_count;
888: DBMS_XMLGEN.closeContext(l_qryCtx);
889: clob_to_file(l_result_clob);
890:

Line 888: DBMS_XMLGEN.closeContext(l_qryCtx);

884: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
885: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
886: l_temp_trx_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
887: l_trx_count := l_trx_count + l_temp_trx_count;
888: DBMS_XMLGEN.closeContext(l_qryCtx);
889: clob_to_file(l_result_clob);
890:
891: put_endtag('CUSTOMER_RECORD');
892: