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

Line 220: DBMS_XMLGEN.closeContext(l_qryCtx);

216: l_length := l_length - l_amount;
217: l_offset := l_offset + l_amount;
218: END LOOP;
219:
220: DBMS_XMLGEN.closeContext(l_qryCtx);
221:
222: -- Write the event log to fnd log file
223:
224: IF (l_eventLog) THEN

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

487: -- create new context
488:
489: l_stmt_num := 60;
490:
491: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
492: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'PARAMETERS');
493: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
494:
495: l_stmt_num := 70;

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

488:
489: l_stmt_num := 60;
490:
491: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
492: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'PARAMETERS');
493: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
494:
495: l_stmt_num := 70;
496:

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

489: l_stmt_num := 60;
490:
491: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
492: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'PARAMETERS');
493: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
494:
495: l_stmt_num := 70;
496:
497: -- get XML into the temporary clob variable

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

495: l_stmt_num := 70;
496:
497: -- get XML into the temporary clob variable
498:
499: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
500:
501: -- remove the header (21 characters) and append the rest to xml output
502:
503: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN

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

499: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
500:
501: -- remove the header (21 characters) and append the rest to xml output
502:
503: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
504: DBMS_LOB.erase (l_xml_temp, l_offset,1);
505: DBMS_LOB.append (x_xml_doc, l_xml_temp);
506: END IF;
507:

Line 510: DBMS_XMLGEN.closeContext(l_qryCtx);

506: END IF;
507:
508: -- close context and free memory
509:
510: DBMS_XMLGEN.closeContext(l_qryCtx);
511: CLOSE l_ref_cur;
512: DBMS_LOB.FREETEMPORARY (l_xml_temp);
513:
514: -- Standard call to get message count and if count is 1, get message info.

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

938: -- create new context
939:
940: l_stmt_num := 70;
941:
942: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
943: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'AP_PO_DATA');
944: DBMS_XMLGEN.setRowTag (l_qryCtx,'AP_PO');
945:
946: -- get XML into the temporary clob variable

Line 943: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'AP_PO_DATA');

939:
940: l_stmt_num := 70;
941:
942: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
943: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'AP_PO_DATA');
944: DBMS_XMLGEN.setRowTag (l_qryCtx,'AP_PO');
945:
946: -- get XML into the temporary clob variable
947:

Line 944: DBMS_XMLGEN.setRowTag (l_qryCtx,'AP_PO');

940: l_stmt_num := 70;
941:
942: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
943: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'AP_PO_DATA');
944: DBMS_XMLGEN.setRowTag (l_qryCtx,'AP_PO');
945:
946: -- get XML into the temporary clob variable
947:
948: l_stmt_num := 80;

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

946: -- get XML into the temporary clob variable
947:
948: l_stmt_num := 80;
949:
950: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
951:
952: -- remove the header (21 characters) and append the rest to xml output
953:
954: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);

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

950: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
951:
952: -- remove the header (21 characters) and append the rest to xml output
953:
954: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
955:
956: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
957: DBMS_LOB.erase (l_xml_temp, l_offset,1);
958: DBMS_LOB.append (x_xml_doc, l_xml_temp);

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

952: -- remove the header (21 characters) and append the rest to xml output
953:
954: l_count := DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx);
955:
956: IF (DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0) THEN
957: DBMS_LOB.erase (l_xml_temp, l_offset,1);
958: DBMS_LOB.append (x_xml_doc, l_xml_temp);
959: END IF;
960:

Line 963: DBMS_XMLGEN.closeContext(l_qryCtx);

959: END IF;
960:
961: -- close context and free memory
962:
963: DBMS_XMLGEN.closeContext(l_qryCtx);
964: CLOSE l_ref_cur;
965: DBMS_LOB.FREETEMPORARY (l_xml_temp);
966:
967: -- to add number of rows processed

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

977: -- create new context
978:
979: l_stmt_num := 100;
980:
981: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
982: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'RECORD_NUM');
983: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
984:
985: -- get XML to add the number of rows processed

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

978:
979: l_stmt_num := 100;
980:
981: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
982: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'RECORD_NUM');
983: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
984:
985: -- get XML to add the number of rows processed
986:

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

979: l_stmt_num := 100;
980:
981: l_qryCtx := DBMS_XMLGEN.newContext (l_ref_cur);
982: DBMS_XMLGEN.setRowSetTag (l_qryCtx,'RECORD_NUM');
983: DBMS_XMLGEN.setRowTag (l_qryCtx,NULL);
984:
985: -- get XML to add the number of rows processed
986:
987: l_stmt_num := 110;

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

985: -- get XML to add the number of rows processed
986:
987: l_stmt_num := 110;
988:
989: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
990:
991: -- remove the header (21 characters) and append the rest to xml output
992:
993: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN

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

989: DBMS_XMLGEN.getXML (l_qryCtx, l_xml_temp, DBMS_XMLGEN.none);
990:
991: -- remove the header (21 characters) and append the rest to xml output
992:
993: IF ( DBMS_XMLGEN.getNumRowsProcessed(l_qryCtx) > 0 ) THEN
994: DBMS_LOB.erase (l_xml_temp, l_offset,1);
995: DBMS_LOB.append (x_xml_doc, l_xml_temp);
996: END IF;
997:

Line 1000: DBMS_XMLGEN.closeContext(l_qryCtx);

996: END IF;
997:
998: -- close context and free memory
999:
1000: DBMS_XMLGEN.closeContext(l_qryCtx);
1001: CLOSE l_ref_cur;
1002: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1003:
1004: -- Standard call to get message count and if count is 1, get message info.