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 3486: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);

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

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

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

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

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

Line 3510: DBMS_LOB.writeappend (l_xfdf_string

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

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

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

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

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

Line 3519: DBMS_LOB.writeappend (l_xfdf_string

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

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

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

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

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

Line 3531: DBMS_LOB.writeappend (l_xfdf_string

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3548: DBMS_LOB.writeappend (l_xfdf_string

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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