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

Line 929: l_para_ctx dbms_xmlgen.ctxHandle;

925: l_fetch_from_gl_flag VARCHAR2(1);
926: l_xml_clob CLOB;
927: l_ctx NUMBER;
928: l_log_module VARCHAR2(240);
929: l_para_ctx dbms_xmlgen.ctxHandle;
930: l_encoding VARCHAR2(20);
931:
932: l_start_period_num NUMBER;
933: l_end_period_num NUMBER;

Line 1058: l_para_Ctx := dbms_xmlgen.newContext(l_array_sql(i));

1054: ,p_level =>C_LEVEL_EVENT
1055: ,p_module=>l_log_module);
1056: END IF;
1057:
1058: l_para_Ctx := dbms_xmlgen.newContext(l_array_sql(i));
1059: DBMS_XMLGEN.setRowSetTag(l_para_Ctx,NULL);
1060: DBMS_XMLGEN.setRowTag(l_para_Ctx, 'PARAMETER');
1061: l_xml_clob := DBMS_XMLGEN.GETXML(l_para_Ctx);
1062: l_xml_clob:= substr(l_xml_clob,instr(l_xml_clob,'>')+1);

Line 1059: DBMS_XMLGEN.setRowSetTag(l_para_Ctx,NULL);

1055: ,p_module=>l_log_module);
1056: END IF;
1057:
1058: l_para_Ctx := dbms_xmlgen.newContext(l_array_sql(i));
1059: DBMS_XMLGEN.setRowSetTag(l_para_Ctx,NULL);
1060: DBMS_XMLGEN.setRowTag(l_para_Ctx, 'PARAMETER');
1061: l_xml_clob := DBMS_XMLGEN.GETXML(l_para_Ctx);
1062: l_xml_clob:= substr(l_xml_clob,instr(l_xml_clob,'>')+1);
1063: DBMS_XMLGEN.closeContext(l_para_Ctx);

Line 1060: DBMS_XMLGEN.setRowTag(l_para_Ctx, 'PARAMETER');

1056: END IF;
1057:
1058: l_para_Ctx := dbms_xmlgen.newContext(l_array_sql(i));
1059: DBMS_XMLGEN.setRowSetTag(l_para_Ctx,NULL);
1060: DBMS_XMLGEN.setRowTag(l_para_Ctx, 'PARAMETER');
1061: l_xml_clob := DBMS_XMLGEN.GETXML(l_para_Ctx);
1062: l_xml_clob:= substr(l_xml_clob,instr(l_xml_clob,'>')+1);
1063: DBMS_XMLGEN.closeContext(l_para_Ctx);
1064:

Line 1061: l_xml_clob := DBMS_XMLGEN.GETXML(l_para_Ctx);

1057:
1058: l_para_Ctx := dbms_xmlgen.newContext(l_array_sql(i));
1059: DBMS_XMLGEN.setRowSetTag(l_para_Ctx,NULL);
1060: DBMS_XMLGEN.setRowTag(l_para_Ctx, 'PARAMETER');
1061: l_xml_clob := DBMS_XMLGEN.GETXML(l_para_Ctx);
1062: l_xml_clob:= substr(l_xml_clob,instr(l_xml_clob,'>')+1);
1063: DBMS_XMLGEN.closeContext(l_para_Ctx);
1064:
1065: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 1063: DBMS_XMLGEN.closeContext(l_para_Ctx);

1059: DBMS_XMLGEN.setRowSetTag(l_para_Ctx,NULL);
1060: DBMS_XMLGEN.setRowTag(l_para_Ctx, 'PARAMETER');
1061: l_xml_clob := DBMS_XMLGEN.GETXML(l_para_Ctx);
1062: l_xml_clob:= substr(l_xml_clob,instr(l_xml_clob,'>')+1);
1063: DBMS_XMLGEN.closeContext(l_para_Ctx);
1064:
1065: IF (C_LEVEL_EVENT >= g_log_level) THEN
1066: trace
1067: (p_msg =>'End of Genrating XML for Parameter'

Line 1090: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));

1086: OR i = 6 -- reverse relation query
1087: THEN
1088: fnd_file.put_line(fnd_file.output, '');
1089:
1090: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1091: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SUMMARY_ROWSET');
1092: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SUMMARY_ROW');
1093:
1094: IF p_currency IS NOT NULL

Line 1091: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SUMMARY_ROWSET');

1087: THEN
1088: fnd_file.put_line(fnd_file.output, '');
1089:
1090: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1091: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SUMMARY_ROWSET');
1092: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SUMMARY_ROW');
1093:
1094: IF p_currency IS NOT NULL
1095: THEN

Line 1092: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SUMMARY_ROW');

1088: fnd_file.put_line(fnd_file.output, '');
1089:
1090: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1091: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SUMMARY_ROWSET');
1092: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SUMMARY_ROW');
1093:
1094: IF p_currency IS NOT NULL
1095: THEN
1096: DBMS_XMLGEN.setBindValue(l_ctx,'TO_CURR',p_currency);

Line 1096: DBMS_XMLGEN.setBindValue(l_ctx,'TO_CURR',p_currency);

1092: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SUMMARY_ROW');
1093:
1094: IF p_currency IS NOT NULL
1095: THEN
1096: DBMS_XMLGEN.setBindValue(l_ctx,'TO_CURR',p_currency);
1097: DBMS_XMLGEN.setBindValue(l_ctx,'TO_DATE',p_rate_date);
1098: DBMS_XMLGEN.setBindValue(l_ctx,'TYPE',p_rate_type);
1099: END IF;
1100:

Line 1097: DBMS_XMLGEN.setBindValue(l_ctx,'TO_DATE',p_rate_date);

1093:
1094: IF p_currency IS NOT NULL
1095: THEN
1096: DBMS_XMLGEN.setBindValue(l_ctx,'TO_CURR',p_currency);
1097: DBMS_XMLGEN.setBindValue(l_ctx,'TO_DATE',p_rate_date);
1098: DBMS_XMLGEN.setBindValue(l_ctx,'TYPE',p_rate_type);
1099: END IF;
1100:
1101: ELSIF i = 3 -- forward relation query

Line 1098: DBMS_XMLGEN.setBindValue(l_ctx,'TYPE',p_rate_type);

1094: IF p_currency IS NOT NULL
1095: THEN
1096: DBMS_XMLGEN.setBindValue(l_ctx,'TO_CURR',p_currency);
1097: DBMS_XMLGEN.setBindValue(l_ctx,'TO_DATE',p_rate_date);
1098: DBMS_XMLGEN.setBindValue(l_ctx,'TYPE',p_rate_type);
1099: END IF;
1100:
1101: ELSIF i = 3 -- forward relation query
1102: OR i = 7 -- reverse relation query

Line 1106: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));

1102: OR i = 7 -- reverse relation query
1103: THEN
1104: fnd_file.put_line(fnd_file.output, '');
1105:
1106: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1107: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLSOURCE_ROWSET');
1108: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JRNLSOURCE_ROW');
1109:
1110: ELSIF i = 4 -- forward relation query

Line 1107: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLSOURCE_ROWSET');

1103: THEN
1104: fnd_file.put_line(fnd_file.output, '');
1105:
1106: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1107: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLSOURCE_ROWSET');
1108: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JRNLSOURCE_ROW');
1109:
1110: ELSIF i = 4 -- forward relation query
1111: OR i = 8 -- reverse relation query

Line 1108: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JRNLSOURCE_ROW');

1104: fnd_file.put_line(fnd_file.output, '');
1105:
1106: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1107: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLSOURCE_ROWSET');
1108: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JRNLSOURCE_ROW');
1109:
1110: ELSIF i = 4 -- forward relation query
1111: OR i = 8 -- reverse relation query
1112: THEN

Line 1115: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));

1111: OR i = 8 -- reverse relation query
1112: THEN
1113: fnd_file.put_line(fnd_file.output, '');
1114:
1115: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1116: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLDETAILS_ROWSET');
1117: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JOURNAL_ROW');
1118:
1119: ELSIF i = 5 -- forward relation query

Line 1116: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLDETAILS_ROWSET');

1112: THEN
1113: fnd_file.put_line(fnd_file.output, '');
1114:
1115: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1116: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLDETAILS_ROWSET');
1117: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JOURNAL_ROW');
1118:
1119: ELSIF i = 5 -- forward relation query
1120: OR i = 9 -- reverse relation query

Line 1117: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JOURNAL_ROW');

1113: fnd_file.put_line(fnd_file.output, '');
1114:
1115: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1116: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLDETAILS_ROWSET');
1117: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JOURNAL_ROW');
1118:
1119: ELSIF i = 5 -- forward relation query
1120: OR i = 9 -- reverse relation query
1121: THEN

Line 1124: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));

1120: OR i = 9 -- reverse relation query
1121: THEN
1122: fnd_file.put_line(fnd_file.output, '');
1123:
1124: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1125: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SLADETAILS_ROWSET');
1126: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SLA_ROW');
1127:
1128:

Line 1125: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SLADETAILS_ROWSET');

1121: THEN
1122: fnd_file.put_line(fnd_file.output, '');
1123:
1124: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1125: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SLADETAILS_ROWSET');
1126: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SLA_ROW');
1127:
1128:
1129: ELSIF i = 10 -- forward relation query

Line 1126: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SLA_ROW');

1122: fnd_file.put_line(fnd_file.output, '');
1123:
1124: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1125: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SLADETAILS_ROWSET');
1126: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SLA_ROW');
1127:
1128:
1129: ELSIF i = 10 -- forward relation query
1130: OR i = 13 -- reverse relation query

Line 1134: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));

1130: OR i = 13 -- reverse relation query
1131: THEN
1132: fnd_file.put_line(fnd_file.output, '');
1133:
1134: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1135: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLSOURCE_UNMATCHED_ROWSET');
1136: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JRNLSOURCE_UNMATCHED_ROW');
1137:
1138: ELSIF i = 11 -- forward relation query

Line 1135: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLSOURCE_UNMATCHED_ROWSET');

1131: THEN
1132: fnd_file.put_line(fnd_file.output, '');
1133:
1134: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1135: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLSOURCE_UNMATCHED_ROWSET');
1136: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JRNLSOURCE_UNMATCHED_ROW');
1137:
1138: ELSIF i = 11 -- forward relation query
1139: OR i = 14 -- reverse relation query

Line 1136: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JRNLSOURCE_UNMATCHED_ROW');

1132: fnd_file.put_line(fnd_file.output, '');
1133:
1134: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1135: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLSOURCE_UNMATCHED_ROWSET');
1136: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JRNLSOURCE_UNMATCHED_ROW');
1137:
1138: ELSIF i = 11 -- forward relation query
1139: OR i = 14 -- reverse relation query
1140: THEN

Line 1143: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));

1139: OR i = 14 -- reverse relation query
1140: THEN
1141: fnd_file.put_line(fnd_file.output, '');
1142:
1143: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1144: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLDETAILS_UNMATCHED_ROWSET');
1145: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JOURNAL_UNMATCHED_ROW');
1146:
1147: ELSIF i = 12 -- forward relation query

Line 1144: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLDETAILS_UNMATCHED_ROWSET');

1140: THEN
1141: fnd_file.put_line(fnd_file.output, '');
1142:
1143: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1144: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLDETAILS_UNMATCHED_ROWSET');
1145: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JOURNAL_UNMATCHED_ROW');
1146:
1147: ELSIF i = 12 -- forward relation query
1148: OR i = 15 -- reverse relation query

Line 1145: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JOURNAL_UNMATCHED_ROW');

1141: fnd_file.put_line(fnd_file.output, '');
1142:
1143: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1144: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLDETAILS_UNMATCHED_ROWSET');
1145: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JOURNAL_UNMATCHED_ROW');
1146:
1147: ELSIF i = 12 -- forward relation query
1148: OR i = 15 -- reverse relation query
1149: THEN

Line 1152: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));

1148: OR i = 15 -- reverse relation query
1149: THEN
1150: fnd_file.put_line(fnd_file.output, '');
1151:
1152: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1153: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SLADETAILS_UNMATCHED_ROWSET');
1154: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SLA_UNMATCHED_ROW');
1155:
1156: END IF;

Line 1153: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SLADETAILS_UNMATCHED_ROWSET');

1149: THEN
1150: fnd_file.put_line(fnd_file.output, '');
1151:
1152: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1153: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SLADETAILS_UNMATCHED_ROWSET');
1154: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SLA_UNMATCHED_ROW');
1155:
1156: END IF;
1157:

Line 1154: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SLA_UNMATCHED_ROW');

1150: fnd_file.put_line(fnd_file.output, '');
1151:
1152: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1153: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SLADETAILS_UNMATCHED_ROWSET');
1154: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SLA_UNMATCHED_ROW');
1155:
1156: END IF;
1157:
1158: l_xml_clob := DBMS_XMLGEN.GETXML(l_ctx);

Line 1158: l_xml_clob := DBMS_XMLGEN.GETXML(l_ctx);

1154: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SLA_UNMATCHED_ROW');
1155:
1156: END IF;
1157:
1158: l_xml_clob := DBMS_XMLGEN.GETXML(l_ctx);
1159: l_xml_clob:= substr(l_xml_clob,instr(l_xml_clob,'>',1,2)+1);
1160: DBMS_XMLGEN.closeContext(l_ctx);
1161:
1162: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 1160: DBMS_XMLGEN.closeContext(l_ctx);

1156: END IF;
1157:
1158: l_xml_clob := DBMS_XMLGEN.GETXML(l_ctx);
1159: l_xml_clob:= substr(l_xml_clob,instr(l_xml_clob,'>',1,2)+1);
1160: DBMS_XMLGEN.closeContext(l_ctx);
1161:
1162: IF (C_LEVEL_EVENT >= g_log_level) THEN
1163: trace
1164: (p_msg =>'End of Genrating XML for JE lines'