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

Line 235: DBMS_XMLGEN.closeContext(l_qryCtx);

231: l_length := l_length - l_amount;
232: l_offset := l_offset + l_amount;
233: END LOOP;
234:
235: DBMS_XMLGEN.closeContext(l_qryCtx);
236:
237: -- Write the event log to fnd log file
238:
239: IF (l_eventLog) THEN

Line 506: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);

502: -- create new context
503:
504: l_stmt_num := 60;
505:
506: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
507: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'PARAMETERS');
508: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
509:
510: -- get XML into the temporary clob variable

Line 507: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'PARAMETERS');

503:
504: l_stmt_num := 60;
505:
506: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
507: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'PARAMETERS');
508: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
509:
510: -- get XML into the temporary clob variable
511:

Line 508: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);

504: l_stmt_num := 60;
505:
506: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
507: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'PARAMETERS');
508: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
509:
510: -- get XML into the temporary clob variable
511:
512: l_stmt_num := 70;

Line 514: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);

510: -- get XML into the temporary clob variable
511:
512: l_stmt_num := 70;
513:
514: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
515:
516: -- remove the header (21 characters) and append the rest to xml output
517:
518: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN

Line 518: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN

514: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
515:
516: -- remove the header (21 characters) and append the rest to xml output
517:
518: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
519: DBMS_LOB.erase (l_xml_temp, l_offset,1);
520: DBMS_LOB.append (x_xml_doc, l_xml_temp);
521: END IF;
522:

Line 525: DBMS_XMLGEN.closeContext(l_qryCtx);

521: END IF;
522:
523: -- close context and free memory
524:
525: DBMS_XMLGEN.closeContext(l_qryCtx);
526: CLOSE l_ref_cur;
527: DBMS_LOB.FREETEMPORARY (l_xml_temp);
528:
529: -- Standard call to get message count and if count is 1, get message info.

Line 885: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);

881: -- create new context
882:
883: l_stmt_num := 40;
884:
885: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
886: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'WRITE_OFF_DATA');
887: DBMS_XMLGEN.setRowTag (l_qryCtx,'WRITE_OFF');
888:
889: -- get XML into the temporary clob variable

Line 886: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'WRITE_OFF_DATA');

882:
883: l_stmt_num := 40;
884:
885: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
886: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'WRITE_OFF_DATA');
887: DBMS_XMLGEN.setRowTag (l_qryCtx,'WRITE_OFF');
888:
889: -- get XML into the temporary clob variable
890:

Line 887: DBMS_XMLGEN.setRowTag (l_qryCtx,'WRITE_OFF');

883: l_stmt_num := 40;
884:
885: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
886: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'WRITE_OFF_DATA');
887: DBMS_XMLGEN.setRowTag (l_qryCtx,'WRITE_OFF');
888:
889: -- get XML into the temporary clob variable
890:
891: l_stmt_num := 50;

Line 893: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);

889: -- get XML into the temporary clob variable
890:
891: l_stmt_num := 50;
892:
893: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
894:
895: -- remove the header (21 characters) and append the rest to xml output
896:
897: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

Line 897: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

893: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
894:
895: -- remove the header (21 characters) and append the rest to xml output
896:
897: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
898:
899: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
900: DBMS_LOB.erase (l_xml_temp, l_offset,1);
901: DBMS_LOB.append (x_xml_doc, l_xml_temp);

Line 899: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN

895: -- remove the header (21 characters) and append the rest to xml output
896:
897: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
898:
899: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
900: DBMS_LOB.erase (l_xml_temp, l_offset,1);
901: DBMS_LOB.append (x_xml_doc, l_xml_temp);
902: END IF;
903:

Line 906: DBMS_XMLGEN.closeContext(l_qryCtx);

902: END IF;
903:
904: -- close context and free memory
905:
906: DBMS_XMLGEN.closeContext(l_qryCtx);
907: CLOSE l_ref_cur;
908: DBMS_LOB.FREETEMPORARY (l_xml_temp);
909:
910: -- to add number of rows processed

Line 924: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);

920: -- create new context
921:
922: l_stmt_num := 70;
923:
924: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
925: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'RECORD_NUM');
926: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
927:
928:

Line 925: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'RECORD_NUM');

921:
922: l_stmt_num := 70;
923:
924: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
925: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'RECORD_NUM');
926: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
927:
928:
929: -- get XML to add the number of rows processed

Line 926: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);

922: l_stmt_num := 70;
923:
924: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
925: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'RECORD_NUM');
926: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
927:
928:
929: -- get XML to add the number of rows processed
930:

Line 933: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);

929: -- get XML to add the number of rows processed
930:
931: l_stmt_num := 80;
932:
933: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
934:
935: -- remove the header (21 characters) and append the rest to xml output
936:
937: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN

Line 937: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN

933: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
934:
935: -- remove the header (21 characters) and append the rest to xml output
936:
937: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN
938: DBMS_LOB.erase (l_xml_temp, l_offset,1);
939: DBMS_LOB.append (x_xml_doc, l_xml_temp);
940: END IF;
941:

Line 944: DBMS_XMLGEN.closeContext(l_qryCtx);

940: END IF;
941:
942: -- close context and free memory
943:
944: DBMS_XMLGEN.closeContext(l_qryCtx);
945: CLOSE l_ref_cur;
946: DBMS_LOB.FREETEMPORARY (l_xml_temp);
947:
948: -- Standard call to get message count and if count is 1, get message info.