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

Line 915: l_qryctx DBMS_XMLGEN.ctxhandle;

911: RETURN CLOB
912: IS
913: x_result CLOB;
914: l_progress PLS_INTEGER;
915: l_qryctx DBMS_XMLGEN.ctxhandle;
916: l_log_string varchar2(400);
917: l_module_name varchar2(200);
918: l_start_date DATE;
919: l_end_date DATE;

Line 930: l_qryctx := DBMS_XMLGEN.newcontext(p_qryString);

926: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
927: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS'));
928: END IF;
929: -- Set the bind parameters
930: l_qryctx := DBMS_XMLGEN.newcontext(p_qryString);
931:
932: FOR i in 1..p_bind_params.COUNT
933: LOOP
934: DBMS_XMLGEN.setBindValue(l_qryctx, p_bind_params(i).name,

Line 934: DBMS_XMLGEN.setBindValue(l_qryctx, p_bind_params(i).name,

930: l_qryctx := DBMS_XMLGEN.newcontext(p_qryString);
931:
932: FOR i in 1..p_bind_params.COUNT
933: LOOP
934: DBMS_XMLGEN.setBindValue(l_qryctx, p_bind_params(i).name,
935: p_bind_params(i).value);
936: END LOOP;
937:
938: l_progress := 110;

Line 940: DBMS_XMLGEN.setRowTag(l_qryctx, p_row_tag);

936: END LOOP;
937:
938: l_progress := 110;
939: -- Set the row tag and rowset tag
940: DBMS_XMLGEN.setRowTag(l_qryctx, p_row_tag);
941: DBMS_XMLGEN.setRowsetTag(l_qryctx, p_row_settag);
942:
943: DBMS_XMLGEN.setNullHandling(l_qryctx, DBMS_XMLGEN.EMPTY_TAG);
944: DBMS_XMLGEN.setConvertSpecialChars(l_qryctx, TRUE);

Line 941: DBMS_XMLGEN.setRowsetTag(l_qryctx, p_row_settag);

937:
938: l_progress := 110;
939: -- Set the row tag and rowset tag
940: DBMS_XMLGEN.setRowTag(l_qryctx, p_row_tag);
941: DBMS_XMLGEN.setRowsetTag(l_qryctx, p_row_settag);
942:
943: DBMS_XMLGEN.setNullHandling(l_qryctx, DBMS_XMLGEN.EMPTY_TAG);
944: DBMS_XMLGEN.setConvertSpecialChars(l_qryctx, TRUE);
945:

Line 943: DBMS_XMLGEN.setNullHandling(l_qryctx, DBMS_XMLGEN.EMPTY_TAG);

939: -- Set the row tag and rowset tag
940: DBMS_XMLGEN.setRowTag(l_qryctx, p_row_tag);
941: DBMS_XMLGEN.setRowsetTag(l_qryctx, p_row_settag);
942:
943: DBMS_XMLGEN.setNullHandling(l_qryctx, DBMS_XMLGEN.EMPTY_TAG);
944: DBMS_XMLGEN.setConvertSpecialChars(l_qryctx, TRUE);
945:
946: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
947: l_log_string := 'get_xml: Invoking XMLgen for XML generation';

Line 944: DBMS_XMLGEN.setConvertSpecialChars(l_qryctx, TRUE);

940: DBMS_XMLGEN.setRowTag(l_qryctx, p_row_tag);
941: DBMS_XMLGEN.setRowsetTag(l_qryctx, p_row_settag);
942:
943: DBMS_XMLGEN.setNullHandling(l_qryctx, DBMS_XMLGEN.EMPTY_TAG);
944: DBMS_XMLGEN.setConvertSpecialChars(l_qryctx, TRUE);
945:
946: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
947: l_log_string := 'get_xml: Invoking XMLgen for XML generation';
948: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

Line 953: x_result:=DBMS_XMLGEN.getXML(l_qryctx);

949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
950: END IF;
951:
952: l_progress := 120;
953: x_result:=DBMS_XMLGEN.getXML(l_qryctx);
954:
955: l_progress := 130;
956: DBMS_XMLGEN.closecontext(l_qryctx);
957:

Line 956: DBMS_XMLGEN.closecontext(l_qryctx);

952: l_progress := 120;
953: x_result:=DBMS_XMLGEN.getXML(l_qryctx);
954:
955: l_progress := 130;
956: DBMS_XMLGEN.closecontext(l_qryctx);
957:
958: l_progress := 140;
959: return x_result;
960: