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

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

3481: || l_iana_charset
3482: || '"?> ';
3483: l_str10 := '';
3484: l_str11 := '';
3485: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
3486: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
3487: current_index := 0;
3488:
3489: IF xml_tab.COUNT > 0

Line 3486: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);

3482: || '"?> ';
3483: l_str10 := '';
3484: l_str11 := '';
3485: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
3486: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
3487: current_index := 0;
3488:
3489: IF xml_tab.COUNT > 0
3490: THEN

Line 3491: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

3487: current_index := 0;
3488:
3489: IF xml_tab.COUNT > 0
3490: THEN
3491: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
3492:
3493: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST
3494: LOOP
3495: l_str8 := xml_tab (table_counter).tagname;

Line 3509: DBMS_LOB.writeappend (l_xfdf_string

3505: THEN
3506: IF l_str9 IN
3507: ('CAT_DETAILS')
3508: THEN
3509: DBMS_LOB.writeappend (l_xfdf_string
3510: , LENGTH (l_str2)
3511: , l_str2
3512: );
3513: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 3513: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

3509: DBMS_LOB.writeappend (l_xfdf_string
3510: , LENGTH (l_str2)
3511: , l_str2
3512: );
3513: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3514: , l_str8);
3515: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
3516: , l_str3);
3517: ELSE

Line 3515: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

3511: , l_str2
3512: );
3513: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3514: , l_str8);
3515: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
3516: , l_str3);
3517: ELSE
3518: DBMS_LOB.writeappend (l_xfdf_string
3519: , LENGTH (l_str4)

Line 3518: DBMS_LOB.writeappend (l_xfdf_string

3514: , l_str8);
3515: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
3516: , l_str3);
3517: ELSE
3518: DBMS_LOB.writeappend (l_xfdf_string
3519: , LENGTH (l_str4)
3520: , l_str4
3521: );
3522: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 3522: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

3518: DBMS_LOB.writeappend (l_xfdf_string
3519: , LENGTH (l_str4)
3520: , l_str4
3521: );
3522: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3523: , l_str8);
3524: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
3525: , l_str5);
3526: END IF;

Line 3524: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

3520: , l_str4
3521: );
3522: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3523: , l_str8);
3524: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
3525: , l_str5);
3526: END IF;
3527: ELSE
3528: IF l_str9 IS NOT NULL

Line 3530: DBMS_LOB.writeappend (l_xfdf_string

3526: END IF;
3527: ELSE
3528: IF l_str9 IS NOT NULL
3529: THEN
3530: DBMS_LOB.writeappend (l_xfdf_string
3531: , LENGTH (l_str2)
3532: , l_str2
3533: );
3534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 3534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

3530: DBMS_LOB.writeappend (l_xfdf_string
3531: , LENGTH (l_str2)
3532: , l_str2
3533: );
3534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3535: , l_str8);
3536: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
3537: , l_str3);
3538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

Line 3536: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

3532: , l_str2
3533: );
3534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3535: , l_str8);
3536: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
3537: , l_str3);
3538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
3539: , l_str9);
3540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

Line 3538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

3534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3535: , l_str8);
3536: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
3537: , l_str3);
3538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
3539: , l_str9);
3540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
3541: , l_str4);
3542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 3540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

3536: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
3537: , l_str3);
3538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
3539: , l_str9);
3540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
3541: , l_str4);
3542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3543: , l_str8);
3544: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

Line 3542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

3538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
3539: , l_str9);
3540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
3541: , l_str4);
3542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3543: , l_str8);
3544: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
3545: , l_str5);
3546: ELSE

Line 3544: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

3540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
3541: , l_str4);
3542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3543: , l_str8);
3544: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
3545: , l_str5);
3546: ELSE
3547: DBMS_LOB.writeappend (l_xfdf_string
3548: , LENGTH (l_str2)

Line 3547: DBMS_LOB.writeappend (l_xfdf_string

3543: , l_str8);
3544: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
3545: , l_str5);
3546: ELSE
3547: DBMS_LOB.writeappend (l_xfdf_string
3548: , LENGTH (l_str2)
3549: , l_str2
3550: );
3551: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 3551: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

3547: DBMS_LOB.writeappend (l_xfdf_string
3548: , LENGTH (l_str2)
3549: , l_str2
3550: );
3551: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3552: , l_str8);
3553: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
3554: , l_str3);
3555: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

Line 3553: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

3549: , l_str2
3550: );
3551: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3552: , l_str8);
3553: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
3554: , l_str3);
3555: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
3556: , l_str4);
3557: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 3555: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

3551: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3552: , l_str8);
3553: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
3554: , l_str3);
3555: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
3556: , l_str4);
3557: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3558: , l_str8);
3559: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

Line 3557: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

3553: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
3554: , l_str3);
3555: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
3556: , l_str4);
3557: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3558: , l_str8);
3559: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
3560: , l_str5);
3561: END IF;

Line 3559: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

3555: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
3556: , l_str4);
3557: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
3558: , l_str8);
3559: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
3560: , l_str5);
3561: END IF;
3562: END IF;
3563: END LOOP;

Line 3565: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);

3561: END IF;
3562: END IF;
3563: END LOOP;
3564:
3565: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
3566: ELSE
3567: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
3568: END IF;
3569: p_xfdf_clob := l_xfdf_string;

Line 3567: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);

3563: END LOOP;
3564:
3565: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
3566: ELSE
3567: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
3568: END IF;
3569: p_xfdf_clob := l_xfdf_string;
3570: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
3571: EXCEPTION