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

Line 1077: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);

1073: l_str10 := '';
1074: l_str11 := '';
1075:
1076:
1077: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1078: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1079:
1080: current_index := 0;
1081:

Line 1078: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

1074: l_str11 := '';
1075:
1076:
1077: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1078: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1079:
1080: current_index := 0;
1081:
1082: if TEL_DATA.count > 0 then

Line 1086: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

1082: if TEL_DATA.count > 0 then
1083:
1084:
1085:
1086: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1087:
1088: FOR table_counter IN TEL_DATA.FIRST .. TEL_DATA.LAST LOOP
1089: l_str8 := TEL_DATA(table_counter).TagName;
1090: l_str9 := TEL_DATA(table_counter).TagValue;

Line 1109: dbms_lob.writeAppend(l_xfdf_string, length(l_str10), l_str10);

1105: 'TIME_RECORD_TYPE')
1106: THEN
1107: /* IF l_str9 = 'EMP_RECORD'
1108: THEN
1109: dbms_lob.writeAppend(l_xfdf_string, length(l_str10), l_str10);
1110: END IF;
1111: */
1112: --fnd_file.put_line(fnd_file.log,'IF l_str8 ==> '||l_str8 );
1113: --fnd_file.put_line(fnd_file.log,'IF l_str9 ==> '||l_str9 );

Line 1116: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

1112: --fnd_file.put_line(fnd_file.log,'IF l_str8 ==> '||l_str8 );
1113: --fnd_file.put_line(fnd_file.log,'IF l_str9 ==> '||l_str9 );
1114:
1115:
1116: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1117: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1118: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1119:
1120:

Line 1117: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1113: --fnd_file.put_line(fnd_file.log,'IF l_str9 ==> '||l_str9 );
1114:
1115:
1116: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1117: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1118: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1119:
1120:
1121: ELSE

Line 1118: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

1114:
1115:
1116: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1117: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1118: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1119:
1120:
1121: ELSE
1122: --fnd_file.put_line(fnd_file.log,'ELSE l_str8 ==> '||l_str8 );

Line 1124: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

1120:
1121: ELSE
1122: --fnd_file.put_line(fnd_file.log,'ELSE l_str8 ==> '||l_str8 );
1123: --fnd_file.put_line(fnd_file.log,'ELSE l_str9 ==> '||l_str9 );
1124: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1125: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1126: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1127: /*
1128: IF l_str9 = 'ADDITIONAL_EMPLOYMENT_END' THEN

Line 1125: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1121: ELSE
1122: --fnd_file.put_line(fnd_file.log,'ELSE l_str8 ==> '||l_str8 );
1123: --fnd_file.put_line(fnd_file.log,'ELSE l_str9 ==> '||l_str9 );
1124: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1125: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1126: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1127: /*
1128: IF l_str9 = 'ADDITIONAL_EMPLOYMENT_END' THEN
1129: -- TO start a new person record

Line 1126: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

1122: --fnd_file.put_line(fnd_file.log,'ELSE l_str8 ==> '||l_str8 );
1123: --fnd_file.put_line(fnd_file.log,'ELSE l_str9 ==> '||l_str9 );
1124: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1125: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1126: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1127: /*
1128: IF l_str9 = 'ADDITIONAL_EMPLOYMENT_END' THEN
1129: -- TO start a new person record
1130: dbms_lob.writeAppend(l_xfdf_string, length(l_str11), l_str11);

Line 1130: dbms_lob.writeAppend(l_xfdf_string, length(l_str11), l_str11);

1126: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1127: /*
1128: IF l_str9 = 'ADDITIONAL_EMPLOYMENT_END' THEN
1129: -- TO start a new person record
1130: dbms_lob.writeAppend(l_xfdf_string, length(l_str11), l_str11);
1131:
1132: END IF;
1133: */
1134: END IF;

Line 1140: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

1136: ELSE
1137:
1138: if l_str9 is not null then
1139:
1140: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1141: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1142: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1143: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1144: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

Line 1141: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1137:
1138: if l_str9 is not null then
1139:
1140: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1141: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1142: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1143: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1144: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1145: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 1142: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

1138: if l_str9 is not null then
1139:
1140: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1141: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1142: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1143: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1144: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1145: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1146: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

Line 1143: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);

1139:
1140: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1141: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1142: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1143: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1144: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1145: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1146: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1147: else

Line 1144: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

1140: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1141: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1142: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1143: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1144: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1145: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1146: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1147: else
1148:

Line 1145: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1141: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1142: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1143: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1144: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1145: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1146: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1147: else
1148:
1149: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

Line 1146: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

1142: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1143: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1144: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1145: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1146: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1147: else
1148:
1149: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1150: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 1149: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

1145: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1146: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1147: else
1148:
1149: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1150: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1151: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1152: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1153: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 1150: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1146: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1147: else
1148:
1149: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1150: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1151: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1152: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1153: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1154: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

Line 1151: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

1147: else
1148:
1149: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1150: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1151: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1152: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1153: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1154: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1155:

Line 1152: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

1148:
1149: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1150: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1151: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1152: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1153: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1154: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1155:
1156: end if;

Line 1153: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1149: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1150: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1151: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1152: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1153: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1154: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1155:
1156: end if;
1157:

Line 1154: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

1150: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1151: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1152: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1153: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1154: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1155:
1156: end if;
1157:
1158: END IF;

Line 1165: --dbms_lob.writeAppend(l_xfdf_string, length(l_str11), l_str11 );

1161:
1162: END LOOP;
1163:
1164:
1165: --dbms_lob.writeAppend(l_xfdf_string, length(l_str11), l_str11 );
1166: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1167: else
1168: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1169: end if;

Line 1166: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );

1162: END LOOP;
1163:
1164:
1165: --dbms_lob.writeAppend(l_xfdf_string, length(l_str11), l_str11 );
1166: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1167: else
1168: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1169: end if;
1170:

Line 1168: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );

1164:
1165: --dbms_lob.writeAppend(l_xfdf_string, length(l_str11), l_str11 );
1166: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1167: else
1168: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1169: end if;
1170:
1171: --DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1172:

Line 1171: --DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

1167: else
1168: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1169: end if;
1170:
1171: --DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1172:
1173:
1174: p_xfdf_clob := l_xfdf_string;
1175: