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

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

327: l_str14 := '';
328: l_str15 := '';
329: l_str16 := '';
330: l_str17 := '';
331: dbms_lob.createtemporary (l_xfdf_string, FALSE , dbms_lob.CALL);
332: dbms_lob.OPEN (l_xfdf_string, dbms_lob.lob_readwrite);
333: current_index := 0;
334:
335: IF xml_tab.count > 0 THEN

Line 332: dbms_lob.OPEN (l_xfdf_string, dbms_lob.lob_readwrite);

328: l_str15 := '';
329: l_str16 := '';
330: l_str17 := '';
331: dbms_lob.createtemporary (l_xfdf_string, FALSE , dbms_lob.CALL);
332: dbms_lob.OPEN (l_xfdf_string, dbms_lob.lob_readwrite);
333: current_index := 0;
334:
335: IF xml_tab.count > 0 THEN
336: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

Line 336: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

332: dbms_lob.OPEN (l_xfdf_string, dbms_lob.lob_readwrite);
333: current_index := 0;
334:
335: IF xml_tab.count > 0 THEN
336: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
337: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
338:
339: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST
340: LOOP

Line 337: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);

333: current_index := 0;
334:
335: IF xml_tab.count > 0 THEN
336: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
337: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
338:
339: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST
340: LOOP
341: l_str8 := xml_tab (table_counter).tagname;

Line 345: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str14), l_str14);

341: l_str8 := xml_tab (table_counter).tagname;
342: l_str9 := xml_tab (table_counter).tagvalue;
343:
344: IF l_str8 = 'ORG_NAME' THEN
345: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str14), l_str14);
346: ELSIF l_str8 = 'NATIONAL_IDENTIFIER' THEN
347: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str16), l_str16);
348: END IF;
349:

Line 347: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str16), l_str16);

343:
344: IF l_str8 = 'ORG_NAME' THEN
345: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str14), l_str14);
346: ELSIF l_str8 = 'NATIONAL_IDENTIFIER' THEN
347: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str16), l_str16);
348: END IF;
349:
350: IF l_str9 IS NOT NULL THEN
351: l_str9 := '';

Line 352: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

348: END IF;
349:
350: IF l_str9 IS NOT NULL THEN
351: l_str9 := '';
352: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
353: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
354: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
355: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
356: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

Line 353: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

349:
350: IF l_str9 IS NOT NULL THEN
351: l_str9 := '';
352: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
353: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
354: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
355: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
356: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
357: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 354: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

350: IF l_str9 IS NOT NULL THEN
351: l_str9 := '';
352: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
353: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
354: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
355: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
356: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
357: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
358: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 355: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);

351: l_str9 := '';
352: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
353: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
354: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
355: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
356: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
357: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
358: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
359: ELSE

Line 356: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

352: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
353: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
354: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
355: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
356: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
357: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
358: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
359: ELSE
360: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

Line 357: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

353: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
354: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
355: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
356: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
357: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
358: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
359: ELSE
360: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
361: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 358: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

354: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
355: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
356: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
357: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
358: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
359: ELSE
360: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
361: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
362: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

Line 360: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

356: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
357: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
358: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
359: ELSE
360: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
361: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
362: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
363: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
364: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 361: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

357: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
358: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
359: ELSE
360: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
361: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
362: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
363: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
364: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
365: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 362: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

358: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
359: ELSE
360: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
361: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
362: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
363: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
364: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
365: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
366: END IF;

Line 363: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

359: ELSE
360: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
361: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
362: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
363: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
364: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
365: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
366: END IF;
367:

Line 364: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

360: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
361: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
362: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
363: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
364: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
365: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
366: END IF;
367:
368: IF xml_tab.LAST = table_counter THEN

Line 365: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

361: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
362: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
363: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
364: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
365: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
366: END IF;
367:
368: IF xml_tab.LAST = table_counter THEN
369: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);

Line 369: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);

365: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
366: END IF;
367:
368: IF xml_tab.LAST = table_counter THEN
369: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);
370: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
371: ELSIF l_str8 = 'HIRE_DATE' AND xml_tab (table_counter + 1).tagname = 'NATIONAL_IDENTIFIER' THEN
372: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);
373: ELSIF l_str8 = 'HIRE_DATE' AND xml_tab (table_counter + 1).tagname = 'ORG_NAME' THEN

Line 370: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);

366: END IF;
367:
368: IF xml_tab.LAST = table_counter THEN
369: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);
370: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
371: ELSIF l_str8 = 'HIRE_DATE' AND xml_tab (table_counter + 1).tagname = 'NATIONAL_IDENTIFIER' THEN
372: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);
373: ELSIF l_str8 = 'HIRE_DATE' AND xml_tab (table_counter + 1).tagname = 'ORG_NAME' THEN
374: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);

Line 372: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);

368: IF xml_tab.LAST = table_counter THEN
369: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);
370: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
371: ELSIF l_str8 = 'HIRE_DATE' AND xml_tab (table_counter + 1).tagname = 'NATIONAL_IDENTIFIER' THEN
372: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);
373: ELSIF l_str8 = 'HIRE_DATE' AND xml_tab (table_counter + 1).tagname = 'ORG_NAME' THEN
374: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);
375: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
376: ELSIF xml_tab (table_counter + 1).tagname = 'ORG_NAME' THEN

Line 374: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);

370: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
371: ELSIF l_str8 = 'HIRE_DATE' AND xml_tab (table_counter + 1).tagname = 'NATIONAL_IDENTIFIER' THEN
372: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);
373: ELSIF l_str8 = 'HIRE_DATE' AND xml_tab (table_counter + 1).tagname = 'ORG_NAME' THEN
374: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);
375: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
376: ELSIF xml_tab (table_counter + 1).tagname = 'ORG_NAME' THEN
377: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
378: END IF;

Line 375: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);

371: ELSIF l_str8 = 'HIRE_DATE' AND xml_tab (table_counter + 1).tagname = 'NATIONAL_IDENTIFIER' THEN
372: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);
373: ELSIF l_str8 = 'HIRE_DATE' AND xml_tab (table_counter + 1).tagname = 'ORG_NAME' THEN
374: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);
375: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
376: ELSIF xml_tab (table_counter + 1).tagname = 'ORG_NAME' THEN
377: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
378: END IF;
379: END LOOP;

Line 377: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);

373: ELSIF l_str8 = 'HIRE_DATE' AND xml_tab (table_counter + 1).tagname = 'ORG_NAME' THEN
374: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str17), l_str17);
375: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
376: ELSIF xml_tab (table_counter + 1).tagname = 'ORG_NAME' THEN
377: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
378: END IF;
379: END LOOP;
380:
381: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);

Line 381: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);

377: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
378: END IF;
379: END LOOP;
380:
381: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);
382: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
383: ELSE
384: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
385: END IF;

Line 382: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);

378: END IF;
379: END LOOP;
380:
381: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);
382: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
383: ELSE
384: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
385: END IF;
386:

Line 384: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);

380:
381: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);
382: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
383: ELSE
384: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
385: END IF;
386:
387: p_xfdf_clob := l_xfdf_string;
388: hr_utility.set_location ('Leaving WritetoCLOB ', 20);