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.EDR_UTILITIES dependencies on DBMS_LOB

Line 325: fnd_file.put_line(fnd_file.output, dbms_lob.SUBSTR(l_xml_document,32767) );

321: p_parameter_list=>evt.Parameter_List );
322:
323: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_XML_GOT') );
324: -- 3186732 start: fnd_message.set_token limit 3000 char, fnd_message.get limit 2000 char
325: fnd_file.put_line(fnd_file.output, dbms_lob.SUBSTR(l_xml_document,32767) );
326: -- 3186732 end: removed fnd_message set_name/set_token/get statements, write to output directly
327:
328: fnd_file.new_line(fnd_file.output, 2);
329: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_OK') );

Line 986: token_position:= DBMS_LOB.INSTR

982: --Bug 4074173 : start
983: user_data_token := '#EDR_USER_DATA';
984: --Bug 4074173 : end
985:
986: token_position:= DBMS_LOB.INSTR
987: (lob_loc => p_in_xml,
988: pattern => user_data_token,
989: offset => 1,
990: nth => 1);

Line 1018: DBMS_LOB.CREATETEMPORARY(x_replaced_clob, TRUE, DBMS_LOB.SESSION);

1014: l_pos number;
1015: l_first_char VARCHAR2(1);
1016: BEGIN
1017:
1018: DBMS_LOB.CREATETEMPORARY(x_replaced_clob, TRUE, DBMS_LOB.SESSION);
1019: DBMS_LOB.CREATETEMPORARY(l_temp_clob, TRUE, DBMS_LOB.SESSION);
1020:
1021:
1022: --Obtain the length of the source CLOB

Line 1019: DBMS_LOB.CREATETEMPORARY(l_temp_clob, TRUE, DBMS_LOB.SESSION);

1015: l_first_char VARCHAR2(1);
1016: BEGIN
1017:
1018: DBMS_LOB.CREATETEMPORARY(x_replaced_clob, TRUE, DBMS_LOB.SESSION);
1019: DBMS_LOB.CREATETEMPORARY(l_temp_clob, TRUE, DBMS_LOB.SESSION);
1020:
1021:
1022: --Obtain the length of the source CLOB
1023: l_len:=dbms_lob.getlength(p_source);

Line 1023: l_len:=dbms_lob.getlength(p_source);

1019: DBMS_LOB.CREATETEMPORARY(l_temp_clob, TRUE, DBMS_LOB.SESSION);
1020:
1021:
1022: --Obtain the length of the source CLOB
1023: l_len:=dbms_lob.getlength(p_source);
1024:
1025: --Set the amount to the 32 KB
1026: l_amount:=32767;
1027:

Line 1042: dbms_lob.read(p_source,l_len,1,l_buffer);

1038: --If this condition is true then size of CLOB is less than 32 KB
1039: if l_diff <= 32766 then
1040:
1041: --Therefore convert the CLOB to VARCHAR2
1042: dbms_lob.read(p_source,l_len,1,l_buffer);
1043:
1044: --Perform the replace operation
1045: l_buffer:=replace(l_buffer,p_srch_str,p_replace_str);
1046:

Line 1048: dbms_lob.writeappend(x_replaced_clob,length(l_buffer),l_buffer);

1044: --Perform the replace operation
1045: l_buffer:=replace(l_buffer,p_srch_str,p_replace_str);
1046:
1047: --Append the modified VARCHAR2 to an EMPTY CLOB.
1048: dbms_lob.writeappend(x_replaced_clob,length(l_buffer),l_buffer);
1049:
1050:
1051: --Size of input CLOB is greater than 32 KB
1052: else

Line 1064: dbms_lob.read(p_source,l_amount,l_offset,l_buffer);

1060:
1061:
1062: loop
1063: --Read 32 KB of the CLOB into buffer
1064: dbms_lob.read(p_source,l_amount,l_offset,l_buffer);
1065:
1066: --This statement is used to check for boundary condition
1067: --Check if the first character of the search String occurs anywhere,
1068: --at the boundary of the 32 KB buffer.

Line 1085: dbms_lob.writeappend(x_replaced_clob,length(l_buffer),l_buffer);

1081: --Perform the Replace operation for this buffer.
1082: l_buffer:=replace(l_buffer,p_srch_str,p_replace_str);
1083:
1084: --Append this buffer to the target CLOB
1085: dbms_lob.writeappend(x_replaced_clob,length(l_buffer),l_buffer);
1086:
1087: --Increment the offset by the amount already modified
1088: l_offset:=l_offset+l_amount;
1089:

Line 1103: dbms_lob.writeappend(x_replaced_clob,length(l_buffer),l_buffer);

1099: --Perform the replace operation
1100: l_buffer:=replace(l_buffer,p_srch_str,p_replace_str);
1101:
1102: --Append this buffer to the target CLOB
1103: dbms_lob.writeappend(x_replaced_clob,length(l_buffer),l_buffer);
1104:
1105: --Increment the offset by the amount already modified
1106: l_offset:=l_offset+l_amount;
1107:

Line 1123: dbms_lob.read(p_source,l_amount,l_offset,l_buffer);

1119: then
1120: --If difference is greater than zero, perform the replace operatiom
1121: --on this last chunk and append it to the target CLOB.
1122: l_amount:=l_diff+1;
1123: dbms_lob.read(p_source,l_amount,l_offset,l_buffer);
1124: l_buffer:=replace(l_buffer,p_srch_str,p_replace_str);
1125: dbms_lob.writeappend(x_replaced_clob,length(l_buffer),l_buffer);
1126:
1127: end if;

Line 1125: dbms_lob.writeappend(x_replaced_clob,length(l_buffer),l_buffer);

1121: --on this last chunk and append it to the target CLOB.
1122: l_amount:=l_diff+1;
1123: dbms_lob.read(p_source,l_amount,l_offset,l_buffer);
1124: l_buffer:=replace(l_buffer,p_srch_str,p_replace_str);
1125: dbms_lob.writeappend(x_replaced_clob,length(l_buffer),l_buffer);
1126:
1127: end if;
1128:
1129: end if;

Line 1143: l_pos:=dbms_lob.instr(p_source,p_srch_str,l_offset);

1139: while l_offset <= l_len
1140:
1141: loop
1142: --Search for the required string starting from specified offset
1143: l_pos:=dbms_lob.instr(p_source,p_srch_str,l_offset);
1144:
1145: if l_pos > 0 then
1146: --Search is a success
1147:

Line 1153: l_temp_len:=dbms_lob.getlength(x_replaced_clob);

1149: --of the search string
1150: l_amount:=l_pos-l_offset;
1151:
1152: --Push this into the target CLOB
1153: l_temp_len:=dbms_lob.getlength(x_replaced_clob);
1154: if l_amount > 0 then
1155: dbms_lob.copy(x_replaced_clob,p_source,l_amount,l_temp_len+1,l_offset);
1156: end if;
1157:

Line 1155: dbms_lob.copy(x_replaced_clob,p_source,l_amount,l_temp_len+1,l_offset);

1151:
1152: --Push this into the target CLOB
1153: l_temp_len:=dbms_lob.getlength(x_replaced_clob);
1154: if l_amount > 0 then
1155: dbms_lob.copy(x_replaced_clob,p_source,l_amount,l_temp_len+1,l_offset);
1156: end if;
1157:
1158: --Push the replacement string into the target CLOB
1159: if length(p_replace_str) > 0 then

Line 1160: dbms_lob.writeappend(x_replaced_clob,length(p_replace_str),p_replace_str);

1156: end if;
1157:
1158: --Push the replacement string into the target CLOB
1159: if length(p_replace_str) > 0 then
1160: dbms_lob.writeappend(x_replaced_clob,length(p_replace_str),p_replace_str);
1161: end if;
1162: l_offset:=l_pos+length(p_srch_str);
1163: else
1164: --The search String was not found from the specified offset

Line 1167: l_temp_len:=dbms_lob.getlength(x_replaced_clob);

1163: else
1164: --The search String was not found from the specified offset
1165: --Append, the chunk of source CLOB from the offset to the end, into the
1166: --target CLOB
1167: l_temp_len:=dbms_lob.getlength(x_replaced_clob);
1168: dbms_lob.copy(x_replaced_clob,p_source,l_len-l_offset+1,l_temp_len+1,l_offset);
1169: l_offset:=l_len+1;
1170: end if;
1171: end loop;

Line 1168: dbms_lob.copy(x_replaced_clob,p_source,l_len-l_offset+1,l_temp_len+1,l_offset);

1164: --The search String was not found from the specified offset
1165: --Append, the chunk of source CLOB from the offset to the end, into the
1166: --target CLOB
1167: l_temp_len:=dbms_lob.getlength(x_replaced_clob);
1168: dbms_lob.copy(x_replaced_clob,p_source,l_len-l_offset+1,l_temp_len+1,l_offset);
1169: l_offset:=l_len+1;
1170: end if;
1171: end loop;
1172: end if;

Line 1523: DBMS_LOB.CREATETEMPORARY(x_return_clob, TRUE, DBMS_LOB.SESSION);

1519:
1520: BEGIN
1521:
1522: --Create a temporary clob
1523: DBMS_LOB.CREATETEMPORARY(x_return_clob, TRUE, DBMS_LOB.SESSION);
1524:
1525: --Prefix the

 tag.

1526:   DBMS_LOB.WRITEAPPEND(X_RETURN_CLOB,5,'');

1527: 


Line 1526: DBMS_LOB.WRITEAPPEND(X_RETURN_CLOB,5,'');


1522: --Create a temporary clob

1523: DBMS_LOB.CREATETEMPORARY(x_return_clob, TRUE, DBMS_LOB.SESSION);

1524: 

1525: --Prefix the 
 tag.

1526:   DBMS_LOB.WRITEAPPEND(X_RETURN_CLOB,5,'');

1527: 

1528:   if P_PAYLOAD_TYPE = 'XMLPAYLOAD' then

1529:     --Payload is of type XMLPAYLOAD.

1530:     --Therefore all occurrences of '<' should be replaced by '<' and


Line 1532: DBMS_LOB.CREATETEMPORARY(l_temp_clob, TRUE, DBMS_LOB.SESSION);


1528: if P_PAYLOAD_TYPE = 'XMLPAYLOAD' then

1529: --Payload is of type XMLPAYLOAD.

1530: --Therefore all occurrences of '<' should be replaced by '<' and

1531: --all occurrences of '>' should be replaced by '>'

1532: DBMS_LOB.CREATETEMPORARY(l_temp_clob, TRUE, DBMS_LOB.SESSION);

1533: L_TEMP_CLOB := EDR_UTILITIES.CLOB_REPLACE(P_PAYLOAD,'<','<');

1534: L_TEMP_CLOB := EDR_UTILITIES.CLOB_REPLACE(l_TEMP_CLOB,'>','>');

1535: DBMS_LOB.COPY(X_RETURN_CLOB,L_TEMP_CLOB,DBMS_LOB.GETLENGTH(L_TEMP_CLOB),6,1);

1536: else


Line 1535: DBMS_LOB.COPY(X_RETURN_CLOB,L_TEMP_CLOB,DBMS_LOB.GETLENGTH(L_TEMP_CLOB),6,1);


1531: --all occurrences of '>' should be replaced by '>'

1532: DBMS_LOB.CREATETEMPORARY(l_temp_clob, TRUE, DBMS_LOB.SESSION);

1533: L_TEMP_CLOB := EDR_UTILITIES.CLOB_REPLACE(P_PAYLOAD,'<','<');

1534: L_TEMP_CLOB := EDR_UTILITIES.CLOB_REPLACE(l_TEMP_CLOB,'>','>');

1535: DBMS_LOB.COPY(X_RETURN_CLOB,L_TEMP_CLOB,DBMS_LOB.GETLENGTH(L_TEMP_CLOB),6,1);

1536: else

1537: --Otherwise, just append the contents of L_TEMP_CLOB into X_RETURN_CLOB

1538: DBMS_LOB.COPY(X_RETURN_CLOB,P_PAYLOAD,DBMS_LOB.GETLENGTH(P_PAYLOAD),6,1);

1539: end if;


Line 1538: DBMS_LOB.COPY(X_RETURN_CLOB,P_PAYLOAD,DBMS_LOB.GETLENGTH(P_PAYLOAD),6,1);


1534: L_TEMP_CLOB := EDR_UTILITIES.CLOB_REPLACE(l_TEMP_CLOB,'>','>');

1535: DBMS_LOB.COPY(X_RETURN_CLOB,L_TEMP_CLOB,DBMS_LOB.GETLENGTH(L_TEMP_CLOB),6,1);

1536: else

1537: --Otherwise, just append the contents of L_TEMP_CLOB into X_RETURN_CLOB

1538: DBMS_LOB.COPY(X_RETURN_CLOB,P_PAYLOAD,DBMS_LOB.GETLENGTH(P_PAYLOAD),6,1);

1539: end if;

1540: 

1541: --Append the 
 tag.

1542: DBMS_LOB.WRITEAPPEND(X_RETURN_CLOB,6,'
');


Line 1542: DBMS_LOB.WRITEAPPEND(X_RETURN_CLOB,6,'
');


1538: DBMS_LOB.COPY(X_RETURN_CLOB,P_PAYLOAD,DBMS_LOB.GETLENGTH(P_PAYLOAD),6,1);

1539: end if;

1540: 

1541: --Append the

tag.
1542: DBMS_LOB.WRITEAPPEND(X_RETURN_CLOB,6,'');
1543:
1544: RETURN X_RETURN_CLOB;
1545:
1546: END ADJUST_CLOB_FOR_DISPLAY;

Line 1566: DBMS_LOB.CREATETEMPORARY(X_OUTPUT, TRUE, DBMS_LOB.SESSION);

1562: --Create a temporary CLOB and copy the input contents from p_xml_file.
1563: --This is done because, the ECX API destroys the CLOB locator of the i/p
1564: --XML clob passed as parameter. Hence we create another CLOB and duplicate
1565: --the contents.
1566: DBMS_LOB.CREATETEMPORARY(X_OUTPUT, TRUE, DBMS_LOB.SESSION);
1567: DBMS_LOB.COPY(X_OUTPUT,p_xml_file,DBMS_LOB.GETLENGTH(p_xml_file));
1568:
1569: --Call the ECX api to perform the XSLT transformation.
1570: ECX_STANDARD.perform_xslt_transformation ( i_xml_file => X_OUTPUT,

Line 1567: DBMS_LOB.COPY(X_OUTPUT,p_xml_file,DBMS_LOB.GETLENGTH(p_xml_file));

1563: --This is done because, the ECX API destroys the CLOB locator of the i/p
1564: --XML clob passed as parameter. Hence we create another CLOB and duplicate
1565: --the contents.
1566: DBMS_LOB.CREATETEMPORARY(X_OUTPUT, TRUE, DBMS_LOB.SESSION);
1567: DBMS_LOB.COPY(X_OUTPUT,p_xml_file,DBMS_LOB.GETLENGTH(p_xml_file));
1568:
1569: --Call the ECX api to perform the XSLT transformation.
1570: ECX_STANDARD.perform_xslt_transformation ( i_xml_file => X_OUTPUT,
1571: i_xslt_file_name => p_xslt_file_name,