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_MISCACCRUALREPORT_PVT dependencies on DBMS_XMLGEN

Line 233: DBMS_XMLGEN.closeContext(l_qryCtx);

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

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 914: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);

910: -- create new context
911:
912: l_stmt_num := 50;
913:
914: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
915: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'MISC_DATA');
916: DBMS_XMLGEN.setRowTag (l_qryCtx,'MISC');
917:
918: -- get XML into the temporary clob variable

Line 915: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'MISC_DATA');

911:
912: l_stmt_num := 50;
913:
914: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
915: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'MISC_DATA');
916: DBMS_XMLGEN.setRowTag (l_qryCtx,'MISC');
917:
918: -- get XML into the temporary clob variable
919:

Line 916: DBMS_XMLGEN.setRowTag (l_qryCtx,'MISC');

912: l_stmt_num := 50;
913:
914: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
915: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'MISC_DATA');
916: DBMS_XMLGEN.setRowTag (l_qryCtx,'MISC');
917:
918: -- get XML into the temporary clob variable
919:
920: l_stmt_num := 60;

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

918: -- get XML into the temporary clob variable
919:
920: l_stmt_num := 60;
921:
922: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
923:
924: -- remove the header (21 characters) and append the rest to xml output
925:
926: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

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

922: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
923:
924: -- remove the header (21 characters) and append the rest to xml output
925:
926: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
927:
928: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
929: DBMS_LOB.erase (l_xml_temp, l_offset,1);
930: DBMS_LOB.append (x_xml_doc, l_xml_temp);

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

924: -- remove the header (21 characters) and append the rest to xml output
925:
926: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
927:
928: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
929: DBMS_LOB.erase (l_xml_temp, l_offset,1);
930: DBMS_LOB.append (x_xml_doc, l_xml_temp);
931: END IF;
932:

Line 936: DBMS_XMLGEN.closeContext(l_qryCtx);

932:
933:
934: -- close context and free memory
935:
936: DBMS_XMLGEN.closeContext(l_qryCtx);
937: CLOSE l_ref_cur;
938: DBMS_LOB.FREETEMPORARY (l_xml_temp);
939:
940: -- to add number of rows processed

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

950: -- create new context
951:
952: l_stmt_num := 80;
953:
954: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
955: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'record_num');
956: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
957:
958: -- get XML to add the number of rows processed

Line 955: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'record_num');

951:
952: l_stmt_num := 80;
953:
954: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
955: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'record_num');
956: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
957:
958: -- get XML to add the number of rows processed
959:

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

952: l_stmt_num := 80;
953:
954: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
955: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'record_num');
956: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
957:
958: -- get XML to add the number of rows processed
959:
960: l_stmt_num := 90;

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

958: -- get XML to add the number of rows processed
959:
960: l_stmt_num := 90;
961:
962: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
963:
964: -- remove the header (21 characters) and append the rest to xml output
965:
966: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN

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

962: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
963:
964: -- remove the header (21 characters) and append the rest to xml output
965:
966: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN
967: DBMS_LOB.erase (l_xml_temp, l_offset,1);
968: DBMS_LOB.append (x_xml_doc, l_xml_temp);
969: END IF;
970:

Line 973: DBMS_XMLGEN.closeContext(l_qryCtx);

969: END IF;
970:
971: -- close context and free memory
972:
973: DBMS_XMLGEN.closeContext(l_qryCtx);
974: CLOSE l_ref_cur;
975: DBMS_LOB.FREETEMPORARY (l_xml_temp);
976:
977: