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

Line 318: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);

314: l_str6 := '';
315: l_str7 := '';
316: l_str10 := ' 317: l_str11 := '';
318: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
319:
320: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
321: dbms_lob.writeAppend( l_xml, length(l_str11), l_str11 );
322:

Line 320: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);

316: l_str10 := ' 317: l_str11 := '';
318: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
319:
320: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
321: dbms_lob.writeAppend( l_xml, length(l_str11), l_str11 );
322:
323: if PAY_NL_XDO_REPORT.vXMLTable.count > 0 then
324: dbms_lob.writeAppend( l_xml, length(l_str1), l_str1 );

Line 321: dbms_lob.writeAppend( l_xml, length(l_str11), l_str11 );

317: l_str11 := '';
318: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
319:
320: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
321: dbms_lob.writeAppend( l_xml, length(l_str11), l_str11 );
322:
323: if PAY_NL_XDO_REPORT.vXMLTable.count > 0 then
324: dbms_lob.writeAppend( l_xml, length(l_str1), l_str1 );
325: hr_utility.set_location('Before Procedure Write to clob: before loop',102);

Line 324: dbms_lob.writeAppend( l_xml, length(l_str1), l_str1 );

320: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
321: dbms_lob.writeAppend( l_xml, length(l_str11), l_str11 );
322:
323: if PAY_NL_XDO_REPORT.vXMLTable.count > 0 then
324: dbms_lob.writeAppend( l_xml, length(l_str1), l_str1 );
325: hr_utility.set_location('Before Procedure Write to clob: before loop',102);
326: FOR ctr_table IN PAY_NL_XDO_REPORT.vXMLTable.FIRST .. PAY_NL_XDO_REPORT.vXMLTable.LAST LOOP
327: hr_utility.set_location('Before Procedure Write to clob: Inside loop'||PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName,104);
328: l_str8 := PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName;

Line 334: /*dbms_lob.writeAppend( l_xml, length(l_str2), l_str2 );

330: if (substr(l_str8,1,11) = 'G_CONTAINER') then
331: if (l_str9 is null) then
332: l_str := l_str2||l_str8||l_str3;
333:
334: /*dbms_lob.writeAppend( l_xml, length(l_str2), l_str2 );
335: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
336: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 ); */
337: else
338: if (l_str9 = 'END') then

Line 335: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);

331: if (l_str9 is null) then
332: l_str := l_str2||l_str8||l_str3;
333:
334: /*dbms_lob.writeAppend( l_xml, length(l_str2), l_str2 );
335: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
336: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 ); */
337: else
338: if (l_str9 = 'END') then
339: l_str := l_str10||l_str8||l_str3;

Line 336: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 ); */

332: l_str := l_str2||l_str8||l_str3;
333:
334: /*dbms_lob.writeAppend( l_xml, length(l_str2), l_str2 );
335: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
336: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 ); */
337: else
338: if (l_str9 = 'END') then
339: l_str := l_str10||l_str8||l_str3;
340: /* dbms_lob.writeAppend( l_xml, length(l_str10), l_str10 );

Line 340: /* dbms_lob.writeAppend( l_xml, length(l_str10), l_str10 );

336: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 ); */
337: else
338: if (l_str9 = 'END') then
339: l_str := l_str10||l_str8||l_str3;
340: /* dbms_lob.writeAppend( l_xml, length(l_str10), l_str10 );
341: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
342: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 ); */
343: end if;
344: end if;

Line 341: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);

337: else
338: if (l_str9 = 'END') then
339: l_str := l_str10||l_str8||l_str3;
340: /* dbms_lob.writeAppend( l_xml, length(l_str10), l_str10 );
341: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
342: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 ); */
343: end if;
344: end if;
345: else

Line 342: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 ); */

338: if (l_str9 = 'END') then
339: l_str := l_str10||l_str8||l_str3;
340: /* dbms_lob.writeAppend( l_xml, length(l_str10), l_str10 );
341: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
342: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 ); */
343: end if;
344: end if;
345: else
346: if (l_str9 is not null) then

Line 349: /* dbms_lob.writeAppend( l_xml, length(l_str2), l_str2 );

345: else
346: if (l_str9 is not null) then
347:
348: l_str := l_str2||l_str8||l_str3||l_str4||l_str9||l_str5||l_str8||l_str3;
349: /* dbms_lob.writeAppend( l_xml, length(l_str2), l_str2 );
350: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
351: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 );
352: dbms_lob.writeAppend( l_xml, length(l_str4), l_str4 );
353: dbms_lob.writeAppend( l_xml, length(l_str9), l_str9);

Line 350: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);

346: if (l_str9 is not null) then
347:
348: l_str := l_str2||l_str8||l_str3||l_str4||l_str9||l_str5||l_str8||l_str3;
349: /* dbms_lob.writeAppend( l_xml, length(l_str2), l_str2 );
350: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
351: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 );
352: dbms_lob.writeAppend( l_xml, length(l_str4), l_str4 );
353: dbms_lob.writeAppend( l_xml, length(l_str9), l_str9);
354: dbms_lob.writeAppend( l_xml, length(l_str5), l_str5 );

Line 351: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 );

347:
348: l_str := l_str2||l_str8||l_str3||l_str4||l_str9||l_str5||l_str8||l_str3;
349: /* dbms_lob.writeAppend( l_xml, length(l_str2), l_str2 );
350: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
351: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 );
352: dbms_lob.writeAppend( l_xml, length(l_str4), l_str4 );
353: dbms_lob.writeAppend( l_xml, length(l_str9), l_str9);
354: dbms_lob.writeAppend( l_xml, length(l_str5), l_str5 );
355: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);

Line 352: dbms_lob.writeAppend( l_xml, length(l_str4), l_str4 );

348: l_str := l_str2||l_str8||l_str3||l_str4||l_str9||l_str5||l_str8||l_str3;
349: /* dbms_lob.writeAppend( l_xml, length(l_str2), l_str2 );
350: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
351: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 );
352: dbms_lob.writeAppend( l_xml, length(l_str4), l_str4 );
353: dbms_lob.writeAppend( l_xml, length(l_str9), l_str9);
354: dbms_lob.writeAppend( l_xml, length(l_str5), l_str5 );
355: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
356: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */

Line 353: dbms_lob.writeAppend( l_xml, length(l_str9), l_str9);

349: /* dbms_lob.writeAppend( l_xml, length(l_str2), l_str2 );
350: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
351: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 );
352: dbms_lob.writeAppend( l_xml, length(l_str4), l_str4 );
353: dbms_lob.writeAppend( l_xml, length(l_str9), l_str9);
354: dbms_lob.writeAppend( l_xml, length(l_str5), l_str5 );
355: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
356: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */
357: elsif (l_str9 is null and l_str8 is not null) then

Line 354: dbms_lob.writeAppend( l_xml, length(l_str5), l_str5 );

350: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
351: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 );
352: dbms_lob.writeAppend( l_xml, length(l_str4), l_str4 );
353: dbms_lob.writeAppend( l_xml, length(l_str9), l_str9);
354: dbms_lob.writeAppend( l_xml, length(l_str5), l_str5 );
355: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
356: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */
357: elsif (l_str9 is null and l_str8 is not null) then
358:

Line 355: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);

351: dbms_lob.writeAppend( l_xml, length(l_str3), l_str3 );
352: dbms_lob.writeAppend( l_xml, length(l_str4), l_str4 );
353: dbms_lob.writeAppend( l_xml, length(l_str9), l_str9);
354: dbms_lob.writeAppend( l_xml, length(l_str5), l_str5 );
355: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
356: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */
357: elsif (l_str9 is null and l_str8 is not null) then
358:
359: l_str := l_str2||l_str8||l_str3||l_str4||l_str5||l_str8||l_str3;

Line 356: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */

352: dbms_lob.writeAppend( l_xml, length(l_str4), l_str4 );
353: dbms_lob.writeAppend( l_xml, length(l_str9), l_str9);
354: dbms_lob.writeAppend( l_xml, length(l_str5), l_str5 );
355: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
356: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */
357: elsif (l_str9 is null and l_str8 is not null) then
358:
359: l_str := l_str2||l_str8||l_str3||l_str4||l_str5||l_str8||l_str3;
360: /* dbms_lob.writeAppend(l_xml,length(l_str2),l_str2);

Line 360: /* dbms_lob.writeAppend(l_xml,length(l_str2),l_str2);

356: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */
357: elsif (l_str9 is null and l_str8 is not null) then
358:
359: l_str := l_str2||l_str8||l_str3||l_str4||l_str5||l_str8||l_str3;
360: /* dbms_lob.writeAppend(l_xml,length(l_str2),l_str2);
361: dbms_lob.writeAppend(l_xml,length(l_str8),l_str8);
362: dbms_lob.writeAppend(l_xml,length(l_str3),l_str3);
363: dbms_lob.writeAppend(l_xml,length(l_str4),l_str4);
364: dbms_lob.writeAppend(l_xml,length(l_str5),l_str5);

Line 361: dbms_lob.writeAppend(l_xml,length(l_str8),l_str8);

357: elsif (l_str9 is null and l_str8 is not null) then
358:
359: l_str := l_str2||l_str8||l_str3||l_str4||l_str5||l_str8||l_str3;
360: /* dbms_lob.writeAppend(l_xml,length(l_str2),l_str2);
361: dbms_lob.writeAppend(l_xml,length(l_str8),l_str8);
362: dbms_lob.writeAppend(l_xml,length(l_str3),l_str3);
363: dbms_lob.writeAppend(l_xml,length(l_str4),l_str4);
364: dbms_lob.writeAppend(l_xml,length(l_str5),l_str5);
365: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);

Line 362: dbms_lob.writeAppend(l_xml,length(l_str3),l_str3);

358:
359: l_str := l_str2||l_str8||l_str3||l_str4||l_str5||l_str8||l_str3;
360: /* dbms_lob.writeAppend(l_xml,length(l_str2),l_str2);
361: dbms_lob.writeAppend(l_xml,length(l_str8),l_str8);
362: dbms_lob.writeAppend(l_xml,length(l_str3),l_str3);
363: dbms_lob.writeAppend(l_xml,length(l_str4),l_str4);
364: dbms_lob.writeAppend(l_xml,length(l_str5),l_str5);
365: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
366: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */

Line 363: dbms_lob.writeAppend(l_xml,length(l_str4),l_str4);

359: l_str := l_str2||l_str8||l_str3||l_str4||l_str5||l_str8||l_str3;
360: /* dbms_lob.writeAppend(l_xml,length(l_str2),l_str2);
361: dbms_lob.writeAppend(l_xml,length(l_str8),l_str8);
362: dbms_lob.writeAppend(l_xml,length(l_str3),l_str3);
363: dbms_lob.writeAppend(l_xml,length(l_str4),l_str4);
364: dbms_lob.writeAppend(l_xml,length(l_str5),l_str5);
365: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
366: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */
367: else

Line 364: dbms_lob.writeAppend(l_xml,length(l_str5),l_str5);

360: /* dbms_lob.writeAppend(l_xml,length(l_str2),l_str2);
361: dbms_lob.writeAppend(l_xml,length(l_str8),l_str8);
362: dbms_lob.writeAppend(l_xml,length(l_str3),l_str3);
363: dbms_lob.writeAppend(l_xml,length(l_str4),l_str4);
364: dbms_lob.writeAppend(l_xml,length(l_str5),l_str5);
365: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
366: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */
367: else
368: null;

Line 365: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);

361: dbms_lob.writeAppend(l_xml,length(l_str8),l_str8);
362: dbms_lob.writeAppend(l_xml,length(l_str3),l_str3);
363: dbms_lob.writeAppend(l_xml,length(l_str4),l_str4);
364: dbms_lob.writeAppend(l_xml,length(l_str5),l_str5);
365: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
366: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */
367: else
368: null;
369: end if;

Line 366: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */

362: dbms_lob.writeAppend(l_xml,length(l_str3),l_str3);
363: dbms_lob.writeAppend(l_xml,length(l_str4),l_str4);
364: dbms_lob.writeAppend(l_xml,length(l_str5),l_str5);
365: dbms_lob.writeAppend( l_xml, length(l_str8),l_str8);
366: dbms_lob.writeAppend( l_xml, length(l_str3),l_str3); */
367: else
368: null;
369: end if;
370: end if;

Line 371: dbms_lob.writeAppend( l_xml, length(l_str),l_str);

367: else
368: null;
369: end if;
370: end if;
371: dbms_lob.writeAppend( l_xml, length(l_str),l_str);
372: l_str := '';
373:
374: END LOOP;
375: dbms_lob.writeAppend( l_xml, length(l_str6), l_str6 );

Line 375: dbms_lob.writeAppend( l_xml, length(l_str6), l_str6 );

371: dbms_lob.writeAppend( l_xml, length(l_str),l_str);
372: l_str := '';
373:
374: END LOOP;
375: dbms_lob.writeAppend( l_xml, length(l_str6), l_str6 );
376: else
377: dbms_lob.writeAppend( l_xml, length(l_str7), l_str7 );
378: end if;
379: --set return output variable to CLOB xml file

Line 377: dbms_lob.writeAppend( l_xml, length(l_str7), l_str7 );

373:
374: END LOOP;
375: dbms_lob.writeAppend( l_xml, length(l_str6), l_str6 );
376: else
377: dbms_lob.writeAppend( l_xml, length(l_str7), l_str7 );
378: end if;
379: --set return output variable to CLOB xml file
380: p_xml := l_xml;
381: