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_LOB

Line 875: IF (dbms_lob.getlength(x_lines_XML) > 0) THEN

871: replace_clob('', ' ', x_result, false);
872:
873: l_progress := 160;
874:
875: IF (dbms_lob.getlength(x_lines_XML) > 0) THEN
876: dbms_lob.append(x_lines_XML, x_result);
877: ELSE
878: x_lines_XML := x_result;
879: END IF;

Line 876: dbms_lob.append(x_lines_XML, x_result);

872:
873: l_progress := 160;
874:
875: IF (dbms_lob.getlength(x_lines_XML) > 0) THEN
876: dbms_lob.append(x_lines_XML, x_result);
877: ELSE
878: x_lines_XML := x_result;
879: END IF;
880:

Line 1110: IF (dbms_lob.getlength(p_src_clob) > 0 and length(p_replace_with) > 0)THEN

1106: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
1107: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);
1108: END IF;
1109:
1110: IF (dbms_lob.getlength(p_src_clob) > 0 and length(p_replace_with) > 0)THEN
1111: dbms_lob.createtemporary(x_result, false);
1112: l_variablePosition := DBMS_LOB.INSTR(p_src_clob, p_replace_str );
1113:
1114: l_progress := 120;

Line 1111: dbms_lob.createtemporary(x_result, false);

1107: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);
1108: END IF;
1109:
1110: IF (dbms_lob.getlength(p_src_clob) > 0 and length(p_replace_with) > 0)THEN
1111: dbms_lob.createtemporary(x_result, false);
1112: l_variablePosition := DBMS_LOB.INSTR(p_src_clob, p_replace_str );
1113:
1114: l_progress := 120;
1115: IF (l_variablePosition >=1) THEN

Line 1112: l_variablePosition := DBMS_LOB.INSTR(p_src_clob, p_replace_str );

1108: END IF;
1109:
1110: IF (dbms_lob.getlength(p_src_clob) > 0 and length(p_replace_with) > 0)THEN
1111: dbms_lob.createtemporary(x_result, false);
1112: l_variablePosition := DBMS_LOB.INSTR(p_src_clob, p_replace_str );
1113:
1114: l_progress := 120;
1115: IF (l_variablePosition >=1) THEN
1116: l_replace_str_length := length(p_replace_str);

Line 1121: dbms_lob.copy(x_result, p_src_clob, l_variablePosition-1, 1, 1);

1117: l_replace_with_length := length(p_replace_with);
1118:
1119: l_progress := 130;
1120: IF (l_variablePosition > 1) THEN
1121: dbms_lob.copy(x_result, p_src_clob, l_variablePosition-1, 1, 1);
1122: END IF;
1123: l_progress := 140;
1124: dbms_lob.append(x_result,p_replace_with);
1125: l_progress := 150;

Line 1124: dbms_lob.append(x_result,p_replace_with);

1120: IF (l_variablePosition > 1) THEN
1121: dbms_lob.copy(x_result, p_src_clob, l_variablePosition-1, 1, 1);
1122: END IF;
1123: l_progress := 140;
1124: dbms_lob.append(x_result,p_replace_with);
1125: l_progress := 150;
1126: l_variablePosition := l_variablePosition + l_replace_str_length;
1127:
1128: IF (p_replace_mutliple_occurances) THEN

Line 1131: l_new_variablePosition := DBMS_LOB.INSTR(p_src_clob,

1127:
1128: IF (p_replace_mutliple_occurances) THEN
1129: LOOP
1130: l_progress := 160;
1131: l_new_variablePosition := DBMS_LOB.INSTR(p_src_clob,
1132: p_replace_str, l_variablePosition);
1133: EXIT WHEN l_new_variablePosition < 1;
1134:
1135: l_progress := 170;

Line 1138: dbms_lob.copy(x_result, p_src_clob,

1134:
1135: l_progress := 170;
1136: IF (l_new_variablePosition > 1 and
1137: l_new_variablePosition <> l_variablePosition ) THEN
1138: dbms_lob.copy(x_result, p_src_clob,
1139: l_new_variablePosition - l_variablePosition,
1140: dbms_lob.getlength(x_result)+1, l_variablePosition);
1141: END IF;
1142:

Line 1140: dbms_lob.getlength(x_result)+1, l_variablePosition);

1136: IF (l_new_variablePosition > 1 and
1137: l_new_variablePosition <> l_variablePosition ) THEN
1138: dbms_lob.copy(x_result, p_src_clob,
1139: l_new_variablePosition - l_variablePosition,
1140: dbms_lob.getlength(x_result)+1, l_variablePosition);
1141: END IF;
1142:
1143: l_progress := 180;
1144: dbms_lob.writeappend(x_result, l_replace_with_length, p_replace_with);

Line 1144: dbms_lob.writeappend(x_result, l_replace_with_length, p_replace_with);

1140: dbms_lob.getlength(x_result)+1, l_variablePosition);
1141: END IF;
1142:
1143: l_progress := 180;
1144: dbms_lob.writeappend(x_result, l_replace_with_length, p_replace_with);
1145:
1146: l_progress := 190;
1147: l_variablePosition := l_new_variablePosition + l_replace_str_length;
1148: l_repeated_flag := TRUE;

Line 1156: IF ( (dbms_lob.getlength(p_src_clob)) - (l_variablePosition) > 0) then

1152: END IF;
1153: END IF;
1154:
1155: l_progress := 200;
1156: IF ( (dbms_lob.getlength(p_src_clob)) - (l_variablePosition) > 0) then
1157: if (l_repeated_flag) then
1158: dbms_lob.copy(x_result, p_src_clob,
1159: dbms_lob.getlength(p_src_clob)-l_variablePosition+l_replace_str_length+1,
1160: dbms_lob.getlength(x_result)+1, l_variablePosition-l_replace_str_length);

Line 1158: dbms_lob.copy(x_result, p_src_clob,

1154:
1155: l_progress := 200;
1156: IF ( (dbms_lob.getlength(p_src_clob)) - (l_variablePosition) > 0) then
1157: if (l_repeated_flag) then
1158: dbms_lob.copy(x_result, p_src_clob,
1159: dbms_lob.getlength(p_src_clob)-l_variablePosition+l_replace_str_length+1,
1160: dbms_lob.getlength(x_result)+1, l_variablePosition-l_replace_str_length);
1161: else
1162: dbms_lob.copy(x_result, p_src_clob,

Line 1159: dbms_lob.getlength(p_src_clob)-l_variablePosition+l_replace_str_length+1,

1155: l_progress := 200;
1156: IF ( (dbms_lob.getlength(p_src_clob)) - (l_variablePosition) > 0) then
1157: if (l_repeated_flag) then
1158: dbms_lob.copy(x_result, p_src_clob,
1159: dbms_lob.getlength(p_src_clob)-l_variablePosition+l_replace_str_length+1,
1160: dbms_lob.getlength(x_result)+1, l_variablePosition-l_replace_str_length);
1161: else
1162: dbms_lob.copy(x_result, p_src_clob,
1163: dbms_lob.getlength(p_src_clob)-l_variablePosition+1,

Line 1160: dbms_lob.getlength(x_result)+1, l_variablePosition-l_replace_str_length);

1156: IF ( (dbms_lob.getlength(p_src_clob)) - (l_variablePosition) > 0) then
1157: if (l_repeated_flag) then
1158: dbms_lob.copy(x_result, p_src_clob,
1159: dbms_lob.getlength(p_src_clob)-l_variablePosition+l_replace_str_length+1,
1160: dbms_lob.getlength(x_result)+1, l_variablePosition-l_replace_str_length);
1161: else
1162: dbms_lob.copy(x_result, p_src_clob,
1163: dbms_lob.getlength(p_src_clob)-l_variablePosition+1,
1164: dbms_lob.getlength(x_result)+1, l_variablePosition);

Line 1162: dbms_lob.copy(x_result, p_src_clob,

1158: dbms_lob.copy(x_result, p_src_clob,
1159: dbms_lob.getlength(p_src_clob)-l_variablePosition+l_replace_str_length+1,
1160: dbms_lob.getlength(x_result)+1, l_variablePosition-l_replace_str_length);
1161: else
1162: dbms_lob.copy(x_result, p_src_clob,
1163: dbms_lob.getlength(p_src_clob)-l_variablePosition+1,
1164: dbms_lob.getlength(x_result)+1, l_variablePosition);
1165: end if;
1166: END IF;

Line 1163: dbms_lob.getlength(p_src_clob)-l_variablePosition+1,

1159: dbms_lob.getlength(p_src_clob)-l_variablePosition+l_replace_str_length+1,
1160: dbms_lob.getlength(x_result)+1, l_variablePosition-l_replace_str_length);
1161: else
1162: dbms_lob.copy(x_result, p_src_clob,
1163: dbms_lob.getlength(p_src_clob)-l_variablePosition+1,
1164: dbms_lob.getlength(x_result)+1, l_variablePosition);
1165: end if;
1166: END IF;
1167: l_progress := 210;

Line 1164: dbms_lob.getlength(x_result)+1, l_variablePosition);

1160: dbms_lob.getlength(x_result)+1, l_variablePosition-l_replace_str_length);
1161: else
1162: dbms_lob.copy(x_result, p_src_clob,
1163: dbms_lob.getlength(p_src_clob)-l_variablePosition+1,
1164: dbms_lob.getlength(x_result)+1, l_variablePosition);
1165: end if;
1166: END IF;
1167: l_progress := 210;
1168: p_src_clob := x_result;

Line 1170: dbms_lob.freetemporary(x_result);

1166: END IF;
1167: l_progress := 210;
1168: p_src_clob := x_result;
1169: END IF;
1170: dbms_lob.freetemporary(x_result);
1171: END IF;
1172:
1173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1174: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.replace_clob completed:-->'||