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

Line 670: dbms_lob.createtemporary (l_xfdf_string, false , dbms_lob.call);

666: l_str26 := '';
667: l_str27 := '';
668: l_str28 := '';
669: l_str29 := '';
670: dbms_lob.createtemporary (l_xfdf_string, false , dbms_lob.call);
671: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
672: current_index := 0;
673:
674: if xml_tab.count > 0 then

Line 671: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);

667: l_str27 := '';
668: l_str28 := '';
669: l_str29 := '';
670: dbms_lob.createtemporary (l_xfdf_string, false , dbms_lob.call);
671: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
672: current_index := 0;
673:
674: if xml_tab.count > 0 then
675: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);

Line 675: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);

671: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
672: current_index := 0;
673:
674: if xml_tab.count > 0 then
675: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);
676: dbms_lob.writeappend (l_xfdf_string, length (l_str12), l_str12);
677:
678: for table_counter in xml_tab.first .. xml_tab.last
679: loop

Line 676: dbms_lob.writeappend (l_xfdf_string, length (l_str12), l_str12);

672: current_index := 0;
673:
674: if xml_tab.count > 0 then
675: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);
676: dbms_lob.writeappend (l_xfdf_string, length (l_str12), l_str12);
677:
678: for table_counter in xml_tab.first .. xml_tab.last
679: loop
680: l_str8 := xml_tab (table_counter).tagname;

Line 684: dbms_lob.writeappend (l_xfdf_string, length (l_str14), l_str14);

680: l_str8 := xml_tab (table_counter).tagname;
681: l_str9 := xml_tab (table_counter).tagvalue;
682:
683: if l_str8 = 'LEGAL_EMPLOYER_NAME' then
684: dbms_lob.writeappend (l_xfdf_string, length (l_str14), l_str14);
685: elsif l_str8 = 'LU_NAME' then
686: dbms_lob.writeappend (l_xfdf_string, length (l_str22), l_str22);
687: elsif l_str8 = 'EMPLOYEE_NUMBER' then
688: dbms_lob.writeappend (l_xfdf_string, length (l_str16), l_str16);

Line 686: dbms_lob.writeappend (l_xfdf_string, length (l_str22), l_str22);

682:
683: if l_str8 = 'LEGAL_EMPLOYER_NAME' then
684: dbms_lob.writeappend (l_xfdf_string, length (l_str14), l_str14);
685: elsif l_str8 = 'LU_NAME' then
686: dbms_lob.writeappend (l_xfdf_string, length (l_str22), l_str22);
687: elsif l_str8 = 'EMPLOYEE_NUMBER' then
688: dbms_lob.writeappend (l_xfdf_string, length (l_str16), l_str16);
689: elsif l_str8 = 'SALARY_INCOME_TOTAL' then
690: dbms_lob.writeappend (l_xfdf_string, length (l_str20), l_str20);

Line 688: dbms_lob.writeappend (l_xfdf_string, length (l_str16), l_str16);

684: dbms_lob.writeappend (l_xfdf_string, length (l_str14), l_str14);
685: elsif l_str8 = 'LU_NAME' then
686: dbms_lob.writeappend (l_xfdf_string, length (l_str22), l_str22);
687: elsif l_str8 = 'EMPLOYEE_NUMBER' then
688: dbms_lob.writeappend (l_xfdf_string, length (l_str16), l_str16);
689: elsif l_str8 = 'SALARY_INCOME_TOTAL' then
690: dbms_lob.writeappend (l_xfdf_string, length (l_str20), l_str20);
691: elsif l_str8 = 'PAY_PERIOD' then
692: dbms_lob.writeappend (l_xfdf_string, length (l_str18), l_str18);

Line 690: dbms_lob.writeappend (l_xfdf_string, length (l_str20), l_str20);

686: dbms_lob.writeappend (l_xfdf_string, length (l_str22), l_str22);
687: elsif l_str8 = 'EMPLOYEE_NUMBER' then
688: dbms_lob.writeappend (l_xfdf_string, length (l_str16), l_str16);
689: elsif l_str8 = 'SALARY_INCOME_TOTAL' then
690: dbms_lob.writeappend (l_xfdf_string, length (l_str20), l_str20);
691: elsif l_str8 = 'PAY_PERIOD' then
692: dbms_lob.writeappend (l_xfdf_string, length (l_str18), l_str18);
693: elsif l_str8 = 'BENEFIT_NAME' then
694: dbms_lob.writeappend (l_xfdf_string, length (l_str24), l_str24);

Line 692: dbms_lob.writeappend (l_xfdf_string, length (l_str18), l_str18);

688: dbms_lob.writeappend (l_xfdf_string, length (l_str16), l_str16);
689: elsif l_str8 = 'SALARY_INCOME_TOTAL' then
690: dbms_lob.writeappend (l_xfdf_string, length (l_str20), l_str20);
691: elsif l_str8 = 'PAY_PERIOD' then
692: dbms_lob.writeappend (l_xfdf_string, length (l_str18), l_str18);
693: elsif l_str8 = 'BENEFIT_NAME' then
694: dbms_lob.writeappend (l_xfdf_string, length (l_str24), l_str24);
695: elsif l_str8 = 'CAR_PAY_PERIOD_START_DATE' then
696: dbms_lob.writeappend (l_xfdf_string, length (l_str28), l_str28);

Line 694: dbms_lob.writeappend (l_xfdf_string, length (l_str24), l_str24);

690: dbms_lob.writeappend (l_xfdf_string, length (l_str20), l_str20);
691: elsif l_str8 = 'PAY_PERIOD' then
692: dbms_lob.writeappend (l_xfdf_string, length (l_str18), l_str18);
693: elsif l_str8 = 'BENEFIT_NAME' then
694: dbms_lob.writeappend (l_xfdf_string, length (l_str24), l_str24);
695: elsif l_str8 = 'CAR_PAY_PERIOD_START_DATE' then
696: dbms_lob.writeappend (l_xfdf_string, length (l_str28), l_str28);
697: elsif l_str8 = 'INPUT_VALUE_NAME' then
698: dbms_lob.writeappend (l_xfdf_string, length (l_str26), l_str26);

Line 696: dbms_lob.writeappend (l_xfdf_string, length (l_str28), l_str28);

692: dbms_lob.writeappend (l_xfdf_string, length (l_str18), l_str18);
693: elsif l_str8 = 'BENEFIT_NAME' then
694: dbms_lob.writeappend (l_xfdf_string, length (l_str24), l_str24);
695: elsif l_str8 = 'CAR_PAY_PERIOD_START_DATE' then
696: dbms_lob.writeappend (l_xfdf_string, length (l_str28), l_str28);
697: elsif l_str8 = 'INPUT_VALUE_NAME' then
698: dbms_lob.writeappend (l_xfdf_string, length (l_str26), l_str26);
699: end if;
700:

Line 698: dbms_lob.writeappend (l_xfdf_string, length (l_str26), l_str26);

694: dbms_lob.writeappend (l_xfdf_string, length (l_str24), l_str24);
695: elsif l_str8 = 'CAR_PAY_PERIOD_START_DATE' then
696: dbms_lob.writeappend (l_xfdf_string, length (l_str28), l_str28);
697: elsif l_str8 = 'INPUT_VALUE_NAME' then
698: dbms_lob.writeappend (l_xfdf_string, length (l_str26), l_str26);
699: end if;
700:
701: if l_str9 is not null then
702: l_str9 := '';

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

699: end if;
700:
701: if l_str9 is not null then
702: l_str9 := '';
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_str9), l_str9);
707: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);

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

700:
701: if l_str9 is not null then
702: l_str9 := '';
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_str9), l_str9);
707: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
708: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

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

701: if l_str9 is not null then
702: l_str9 := '';
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_str9), l_str9);
707: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
708: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
709: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

Line 706: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);

702: l_str9 := '';
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_str9), l_str9);
707: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
708: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
709: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
710: else

Line 707: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);

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_str9), l_str9);
707: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
708: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
709: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
710: else
711: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);

Line 708: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

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_str9), l_str9);
707: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
708: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
709: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
710: else
711: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
712: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

Line 709: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

705: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
706: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
707: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
708: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
709: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
710: else
711: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
712: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
713: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);

Line 711: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);

707: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
708: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
709: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
710: else
711: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
712: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
713: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
714: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
715: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

Line 712: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

708: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
709: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
710: else
711: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
712: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
713: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
714: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
715: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
716: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

Line 713: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);

709: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
710: else
711: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
712: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
713: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
714: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
715: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
716: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
717: end if;

Line 714: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);

710: else
711: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
712: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
713: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
714: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
715: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
716: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
717: end if;
718:

Line 715: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

711: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
712: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
713: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
714: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
715: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
716: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
717: end if;
718:
719: if l_str8 = 'LOCAL_UNIT_NAME' then

Line 716: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

712: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
713: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
714: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
715: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
716: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
717: end if;
718:
719: if l_str8 = 'LOCAL_UNIT_NAME' then
720: dbms_lob.writeappend (l_xfdf_string, length (l_str15), l_str15);

Line 720: dbms_lob.writeappend (l_xfdf_string, length (l_str15), l_str15);

716: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
717: end if;
718:
719: if l_str8 = 'LOCAL_UNIT_NAME' then
720: dbms_lob.writeappend (l_xfdf_string, length (l_str15), l_str15);
721: end if;
722:
723: if l_str8 = 'NET_SALARY' then
724: dbms_lob.writeappend (l_xfdf_string, length (l_str19), l_str19);

Line 724: dbms_lob.writeappend (l_xfdf_string, length (l_str19), l_str19);

720: dbms_lob.writeappend (l_xfdf_string, length (l_str15), l_str15);
721: end if;
722:
723: if l_str8 = 'NET_SALARY' then
724: dbms_lob.writeappend (l_xfdf_string, length (l_str19), l_str19);
725: elsif l_str8 = 'EXTERNAL_COMPENSATION_TOTAL' then
726: /* if xml_tab.last = table_counter
727: or xml_tab (table_counter + 1).tagname <> 'PAY_PERIOD' then
728: dbms_lob.writeappend (

Line 728: dbms_lob.writeappend (

724: dbms_lob.writeappend (l_xfdf_string, length (l_str19), l_str19);
725: elsif l_str8 = 'EXTERNAL_COMPENSATION_TOTAL' then
726: /* if xml_tab.last = table_counter
727: or xml_tab (table_counter + 1).tagname <> 'PAY_PERIOD' then
728: dbms_lob.writeappend (
729: l_xfdf_string,
730: length (l_str17),
731: l_str17
732: );

Line 734: dbms_lob.writeappend (l_xfdf_string, length (l_str21), l_str21);

730: length (l_str17),
731: l_str17
732: );
733: end if;*/
734: dbms_lob.writeappend (l_xfdf_string, length (l_str21), l_str21);
735:
736: if xml_tab.last = table_counter then
737: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
738: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);

Line 737: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);

733: end if;*/
734: dbms_lob.writeappend (l_xfdf_string, length (l_str21), l_str21);
735:
736: if xml_tab.last = table_counter then
737: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
738: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
739: elsif xml_tab (table_counter + 1).tagname <> 'BENEFIT_NAME' then
740: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
741:

Line 738: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);

734: dbms_lob.writeappend (l_xfdf_string, length (l_str21), l_str21);
735:
736: if xml_tab.last = table_counter then
737: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
738: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
739: elsif xml_tab (table_counter + 1).tagname <> 'BENEFIT_NAME' then
740: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
741:
742: if xml_tab (table_counter + 1).tagname <> 'EMPLOYEE_NUMBER' then

Line 740: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);

736: if xml_tab.last = table_counter then
737: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
738: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
739: elsif xml_tab (table_counter + 1).tagname <> 'BENEFIT_NAME' then
740: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
741:
742: if xml_tab (table_counter + 1).tagname <> 'EMPLOYEE_NUMBER' then
743: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
744: end if;

Line 743: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);

739: elsif xml_tab (table_counter + 1).tagname <> 'BENEFIT_NAME' then
740: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
741:
742: if xml_tab (table_counter + 1).tagname <> 'EMPLOYEE_NUMBER' then
743: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
744: end if;
745: /* dbms_lob.writeappend (
746: l_xfdf_string,
747: length (l_str23),

Line 745: /* dbms_lob.writeappend (

741:
742: if xml_tab (table_counter + 1).tagname <> 'EMPLOYEE_NUMBER' then
743: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
744: end if;
745: /* dbms_lob.writeappend (
746: l_xfdf_string,
747: length (l_str23),
748: l_str23
749: );*/

Line 752: dbms_lob.writeappend (l_xfdf_string, length (l_str25), l_str25);

748: l_str23
749: );*/
750: end if;
751: elsif l_str8 = 'BENEFIT_VALUE' then
752: dbms_lob.writeappend (l_xfdf_string, length (l_str25), l_str25);
753:
754: if xml_tab.last = table_counter then
755: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
756: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);

Line 755: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);

751: elsif l_str8 = 'BENEFIT_VALUE' then
752: dbms_lob.writeappend (l_xfdf_string, length (l_str25), l_str25);
753:
754: if xml_tab.last = table_counter then
755: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
756: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
757: elsif xml_tab (table_counter + 1).tagname not in ('BENEFIT_NAME', 'CAR_PAY_PERIOD_START_DATE') then --'EMPLOYEE_NUMBER' then
758: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
759: if xml_tab (table_counter + 1).tagname = 'LU_NAME' then

Line 756: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);

752: dbms_lob.writeappend (l_xfdf_string, length (l_str25), l_str25);
753:
754: if xml_tab.last = table_counter then
755: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
756: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
757: elsif xml_tab (table_counter + 1).tagname not in ('BENEFIT_NAME', 'CAR_PAY_PERIOD_START_DATE') then --'EMPLOYEE_NUMBER' then
758: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
759: if xml_tab (table_counter + 1).tagname = 'LU_NAME' then
760: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);

Line 758: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);

754: if xml_tab.last = table_counter then
755: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
756: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
757: elsif xml_tab (table_counter + 1).tagname not in ('BENEFIT_NAME', 'CAR_PAY_PERIOD_START_DATE') then --'EMPLOYEE_NUMBER' then
758: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
759: if xml_tab (table_counter + 1).tagname = 'LU_NAME' then
760: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
761: end if;
762: end if;

Line 760: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);

756: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
757: elsif xml_tab (table_counter + 1).tagname not in ('BENEFIT_NAME', 'CAR_PAY_PERIOD_START_DATE') then --'EMPLOYEE_NUMBER' then
758: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
759: if xml_tab (table_counter + 1).tagname = 'LU_NAME' then
760: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
761: end if;
762: end if;
763: elsif l_str8 = 'INPUT_VALUE' then
764: dbms_lob.writeappend (l_xfdf_string, length (l_str27), l_str27);

Line 764: dbms_lob.writeappend (l_xfdf_string, length (l_str27), l_str27);

760: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
761: end if;
762: end if;
763: elsif l_str8 = 'INPUT_VALUE' then
764: dbms_lob.writeappend (l_xfdf_string, length (l_str27), l_str27);
765:
766: if xml_tab.last = table_counter then
767: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);
768: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);

Line 767: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);

763: elsif l_str8 = 'INPUT_VALUE' then
764: dbms_lob.writeappend (l_xfdf_string, length (l_str27), l_str27);
765:
766: if xml_tab.last = table_counter then
767: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);
768: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
769: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
770: elsif xml_tab (table_counter + 1).tagname = 'CAR_PAY_PERIOD_START_DATE' then
771: /* dbms_lob.writeappend (

Line 768: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);

764: dbms_lob.writeappend (l_xfdf_string, length (l_str27), l_str27);
765:
766: if xml_tab.last = table_counter then
767: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);
768: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
769: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
770: elsif xml_tab (table_counter + 1).tagname = 'CAR_PAY_PERIOD_START_DATE' then
771: /* dbms_lob.writeappend (
772: l_xfdf_string,

Line 769: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);

765:
766: if xml_tab.last = table_counter then
767: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);
768: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
769: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
770: elsif xml_tab (table_counter + 1).tagname = 'CAR_PAY_PERIOD_START_DATE' then
771: /* dbms_lob.writeappend (
772: l_xfdf_string,
773: length (l_str25),

Line 771: /* dbms_lob.writeappend (

767: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);
768: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
769: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
770: elsif xml_tab (table_counter + 1).tagname = 'CAR_PAY_PERIOD_START_DATE' then
771: /* dbms_lob.writeappend (
772: l_xfdf_string,
773: length (l_str25),
774: l_str25
775: );*/

Line 776: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);

772: l_xfdf_string,
773: length (l_str25),
774: l_str25
775: );*/
776: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);
777: elsif xml_tab (table_counter + 1).tagname not in ('INPUT_VALUE_NAME', 'CAR_PAY_PERIOD_START_DATE') then --'EMPLOYEE_NUMBER' then
778: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);
779: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
780: if xml_tab (table_counter + 1).tagname = 'LU_NAME' then

Line 778: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);

774: l_str25
775: );*/
776: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);
777: elsif xml_tab (table_counter + 1).tagname not in ('INPUT_VALUE_NAME', 'CAR_PAY_PERIOD_START_DATE') then --'EMPLOYEE_NUMBER' then
778: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);
779: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
780: if xml_tab (table_counter + 1).tagname = 'LU_NAME' then
781: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
782: end if;

Line 779: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);

775: );*/
776: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);
777: elsif xml_tab (table_counter + 1).tagname not in ('INPUT_VALUE_NAME', 'CAR_PAY_PERIOD_START_DATE') then --'EMPLOYEE_NUMBER' then
778: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);
779: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
780: if xml_tab (table_counter + 1).tagname = 'LU_NAME' then
781: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
782: end if;
783: end if;

Line 781: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);

777: elsif xml_tab (table_counter + 1).tagname not in ('INPUT_VALUE_NAME', 'CAR_PAY_PERIOD_START_DATE') then --'EMPLOYEE_NUMBER' then
778: dbms_lob.writeappend (l_xfdf_string, length (l_str29), l_str29);
779: dbms_lob.writeappend (l_xfdf_string, length (l_str17), l_str17);
780: if xml_tab (table_counter + 1).tagname = 'LU_NAME' then
781: dbms_lob.writeappend (l_xfdf_string, length (l_str23), l_str23);
782: end if;
783: end if;
784: end if;
785: end loop;

Line 787: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);

783: end if;
784: end if;
785: end loop;
786:
787: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
788: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
789: else
790: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
791: end if;

Line 788: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);

784: end if;
785: end loop;
786:
787: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
788: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
789: else
790: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
791: end if;
792:

Line 790: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);

786:
787: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
788: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
789: else
790: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
791: end if;
792:
793: p_xfdf_clob := l_xfdf_string;
794: hr_utility.set_location ('Leaving WritetoCLOB ', 20);