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

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

672: l_str12 := '';
673: l_str13 := '';
674: l_str14 := '';
675: l_str15 := '';
676: dbms_lob.createtemporary (l_xfdf_string, FALSE , dbms_lob.CALL);
677: dbms_lob.OPEN (l_xfdf_string, dbms_lob.lob_readwrite);
678: current_index := 0;
679:
680: IF xml_tab.count > 0 THEN

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

673: l_str13 := '';
674: l_str14 := '';
675: l_str15 := '';
676: dbms_lob.createtemporary (l_xfdf_string, FALSE , dbms_lob.CALL);
677: dbms_lob.OPEN (l_xfdf_string, dbms_lob.lob_readwrite);
678: current_index := 0;
679:
680: IF xml_tab.count > 0 THEN
681: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

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

677: dbms_lob.OPEN (l_xfdf_string, dbms_lob.lob_readwrite);
678: current_index := 0;
679:
680: IF xml_tab.count > 0 THEN
681: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
682: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
683:
684: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST
685: LOOP

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

678: current_index := 0;
679:
680: IF xml_tab.count > 0 THEN
681: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
682: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
683:
684: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST
685: LOOP
686: l_str8 := xml_tab (table_counter).tagname;

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

686: l_str8 := xml_tab (table_counter).tagname;
687: l_str9 := xml_tab (table_counter).tagvalue;
688:
689: IF l_str8 = 'ORG_NAME' THEN
690: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str14), l_str14);
691: END IF;
692:
693: IF l_str9 IS NOT NULL THEN
694: l_str9 := '';

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

691: END IF;
692:
693: IF l_str9 IS NOT NULL THEN
694: l_str9 := '';
695: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
696: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
697: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
698: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
699: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

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

692:
693: IF l_str9 IS NOT NULL THEN
694: l_str9 := '';
695: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
696: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
697: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
698: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
699: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
700: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

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

693: IF l_str9 IS NOT NULL THEN
694: l_str9 := '';
695: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
696: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
697: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
698: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
699: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
700: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
701: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

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

694: l_str9 := '';
695: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
696: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
697: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
698: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
699: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
700: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
701: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
702: ELSE

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

695: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
696: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
697: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
698: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
699: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
700: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
701: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
702: ELSE
703: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

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

696: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
697: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
698: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
699: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
700: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
701: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
702: ELSE
703: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
704: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

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

697: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
698: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
699: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
700: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
701: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
702: ELSE
703: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
704: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
705: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

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

699: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
700: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
701: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
702: ELSE
703: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
704: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
705: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
706: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
707: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

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

700: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
701: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
702: ELSE
703: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
704: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
705: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
706: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
707: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
708: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

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

701: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
702: ELSE
703: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
704: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
705: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
706: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
707: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
708: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
709: END IF;

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

702: ELSE
703: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
704: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
705: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
706: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
707: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
708: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
709: END IF;
710:

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

703: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
704: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
705: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
706: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
707: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
708: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
709: END IF;
710:
711: IF xml_tab.LAST = table_counter THEN

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

704: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
705: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
706: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
707: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
708: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
709: END IF;
710:
711: IF xml_tab.LAST = table_counter THEN
712: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);

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

708: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
709: END IF;
710:
711: IF xml_tab.LAST = table_counter THEN
712: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
713: ELSIF xml_tab (table_counter + 1).tagname = 'ORG_NAME' AND l_str8 <> 'REPORT_DATE' THEN
714: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
715: END IF;
716: END LOOP;

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

710:
711: IF xml_tab.LAST = table_counter THEN
712: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
713: ELSIF xml_tab (table_counter + 1).tagname = 'ORG_NAME' AND l_str8 <> 'REPORT_DATE' THEN
714: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
715: END IF;
716: END LOOP;
717:
718: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);

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

714: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
715: END IF;
716: END LOOP;
717:
718: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);
719: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
720: ELSE
721: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
722: END IF;

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

715: END IF;
716: END LOOP;
717:
718: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);
719: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
720: ELSE
721: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
722: END IF;
723:

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

717:
718: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);
719: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
720: ELSE
721: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
722: END IF;
723:
724: p_xfdf_clob := l_xfdf_string;
725: hr_utility.set_location ('Leaving WritetoCLOB ', 20);