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_LTFR dependencies on DBMS_LOB

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

206: l_str10 := '';
207: l_str11 := '';
208:
209:
210: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
211: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
212:
213: current_index := 0;
214:

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

207: l_str11 := '';
208:
209:
210: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
211: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
212:
213: current_index := 0;
214:
215: IF gtagdata.count > 0 THEN

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

213: current_index := 0;
214:
215: IF gtagdata.count > 0 THEN
216:
217: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
218:
219:
220: FOR table_counter IN gtagdata.FIRST .. gtagdata.LAST LOOP
221:

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

225: IF l_str9 IN ('PERSON' ,'PERSON_END','RECORD_TYPE_K',
226: 'RECORD_TYPE_K_END','RECORD_TYPE_L','RECORD_TYPE_L_END') THEN
227:
228: IF l_str9 IN ('PERSON' ,'RECORD_TYPE_K','RECORD_TYPE_L') THEN
229: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
230: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
231: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
232: ELSE
233: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

226: 'RECORD_TYPE_K_END','RECORD_TYPE_L','RECORD_TYPE_L_END') THEN
227:
228: IF l_str9 IN ('PERSON' ,'RECORD_TYPE_K','RECORD_TYPE_L') THEN
229: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
230: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
231: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
232: ELSE
233: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
234: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

227:
228: IF l_str9 IN ('PERSON' ,'RECORD_TYPE_K','RECORD_TYPE_L') THEN
229: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
230: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
231: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
232: ELSE
233: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
234: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
235: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

229: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
230: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
231: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
232: ELSE
233: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
234: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
235: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
236: END IF;
237:

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

230: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
231: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
232: ELSE
233: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
234: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
235: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
236: END IF;
237:
238: ELSE

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

231: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
232: ELSE
233: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
234: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
235: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
236: END IF;
237:
238: ELSE
239:

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

238: ELSE
239:
240: if l_str9 is not null then
241:
242: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
243: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
244: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
245: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
246: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

239:
240: if l_str9 is not null then
241:
242: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
243: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
244: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
245: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
246: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
247: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

240: if l_str9 is not null then
241:
242: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
243: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
244: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
245: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
246: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
247: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
248: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

241:
242: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
243: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
244: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
245: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
246: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
247: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
248: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
249: else

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

242: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
243: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
244: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
245: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
246: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
247: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
248: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
249: else
250:

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

243: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
244: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
245: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
246: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
247: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
248: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
249: else
250:
251: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

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

244: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
245: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
246: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
247: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
248: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
249: else
250:
251: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
252: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

247: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
248: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
249: else
250:
251: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
252: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
253: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
254: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
255: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

248: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
249: else
250:
251: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
252: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
253: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
254: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
255: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
256: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

249: else
250:
251: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
252: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
253: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
254: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
255: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
256: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
257:

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

250:
251: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
252: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
253: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
254: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
255: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
256: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
257:
258: end if;

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

251: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
252: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
253: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
254: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
255: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
256: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
257:
258: end if;
259:

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

252: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
253: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
254: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
255: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
256: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
257:
258: end if;
259:
260: END IF;

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

260: END IF;
261:
262: END LOOP;
263:
264: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
265:
266: ELSE
267: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
268: END IF;

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

263:
264: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
265:
266: ELSE
267: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
268: END IF;
269:
270: p_xfdf_clob := l_xfdf_string;
271: