DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on DBMS_LOB

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

738: l_str10 := ''||SUBSTR(l_employer_ssn,9,1)||'';
739: l_str_month := ''||l_effective_month||'';
740: l_str_year := ''||p_effective_year||'';
741:
742: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
743: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
744: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
745: clob_to_blob(l_xfdf_string,l_xfdf_blob);
746:

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

739: l_str_month := ''||l_effective_month||'';
740: l_str_year := ''||p_effective_year||'';
741:
742: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
743: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
744: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
745: clob_to_blob(l_xfdf_string,l_xfdf_blob);
746:
747: l_add_si_id := 0;

Line 744: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);

740: l_str_year := ''||p_effective_year||'';
741:
742: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
743: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
744: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
745: clob_to_blob(l_xfdf_string,l_xfdf_blob);
746:
747: l_add_si_id := 0;
748: l_add_si_arr_id := 0;

Line 796: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

792: END LOOP;
793: CLOSE csr_get_emp;
794:
795: j := 1;
796: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
797: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
798: l_str_er_name := ''||l_employer_name||'';
799: l_str_er_ssn_9 := ''||SUBSTR(l_employer_ssn,9,1)||'';
800: l_str_er_ssn_8 := ''||SUBSTR(l_employer_ssn,8,1)||'';

Line 797: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

793: CLOSE csr_get_emp;
794:
795: j := 1;
796: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
797: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
798: l_str_er_name := ''||l_employer_name||'';
799: l_str_er_ssn_9 := ''||SUBSTR(l_employer_ssn,9,1)||'';
800: l_str_er_ssn_8 := ''||SUBSTR(l_employer_ssn,8,1)||'';
801: l_str_er_ssn_7 := ''||SUBSTR(l_employer_ssn,7,1)||'';

Line 812: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);

808: l_str_er_ssn_0 := ''||'0'||'';
809: l_str_er_ssn_0a := ''||'0'||'';
810: l_str_month := ''||l_effective_month||'';
811: l_str_year := ''||p_effective_year||'';
812: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
813: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
814: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
815: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
816: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);

Line 813: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);

809: l_str_er_ssn_0a := ''||'0'||'';
810: l_str_month := ''||l_effective_month||'';
811: l_str_year := ''||p_effective_year||'';
812: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
813: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
814: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
815: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
816: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
817: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);

Line 814: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);

810: l_str_month := ''||l_effective_month||'';
811: l_str_year := ''||p_effective_year||'';
812: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
813: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
814: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
815: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
816: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
817: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
818: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);

Line 815: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);

811: l_str_year := ''||p_effective_year||'';
812: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
813: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
814: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
815: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
816: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
817: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
818: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
819: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);

Line 816: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);

812: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
813: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
814: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
815: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
816: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
817: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
818: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
819: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
820: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);

Line 817: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);

813: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
814: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
815: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
816: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
817: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
818: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
819: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
820: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
821: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);

Line 818: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);

814: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
815: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
816: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
817: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
818: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
819: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
820: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
821: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
822: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);

Line 819: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);

815: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
816: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
817: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
818: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
819: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
820: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
821: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
822: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
823: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);

Line 820: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);

816: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
817: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
818: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
819: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
820: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
821: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
822: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
823: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
824: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);

Line 821: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);

817: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
818: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
819: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
820: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
821: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
822: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
823: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
824: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
825: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);

Line 822: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);

818: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
819: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
820: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
821: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
822: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
823: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
824: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
825: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
826: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 823: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);

819: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
820: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
821: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
822: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
823: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
824: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
825: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
826: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
827: IF i > 0 THEN

Line 824: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);

820: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
821: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
822: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
823: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
824: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
825: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
826: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
827: IF i > 0 THEN
828: l_asi_processed := 0;

Line 825: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);

821: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
822: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
823: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
824: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
825: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
826: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
827: IF i > 0 THEN
828: l_asi_processed := 0;
829: ELSE

Line 826: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');

822: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
823: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
824: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
825: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
826: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
827: IF i > 0 THEN
828: l_asi_processed := 0;
829: ELSE
830: l_asi_processed := 1;

Line 831: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

827: IF i > 0 THEN
828: l_asi_processed := 0;
829: ELSE
830: l_asi_processed := 1;
831: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
832: END IF;
833:
834: WHILE l_asi_processed <> 1 LOOP
835:

Line 843: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);

839: l_str_total_ad := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
840: l_str_total_af := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
841: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
842: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
843: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
844: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
845: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
846: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
847: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 844: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);

840: l_str_total_af := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
841: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
842: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
843: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
844: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
845: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
846: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
847: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
848:

Line 845: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);

841: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
842: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
843: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
844: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
845: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
846: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
847: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
848:
849: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 846: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);

842: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
843: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
844: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
845: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
846: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
847: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
848:
849: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
850: l_str_er_name := ''||l_employer_name||'';

Line 847: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

843: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
844: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
845: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
846: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
847: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
848:
849: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
850: l_str_er_name := ''||l_employer_name||'';
851: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);

Line 849: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

845: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
846: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
847: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
848:
849: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
850: l_str_er_name := ''||l_employer_name||'';
851: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
852: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
853: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);

Line 851: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);

847: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
848:
849: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
850: l_str_er_name := ''||l_employer_name||'';
851: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
852: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
853: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
854: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
855: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);

Line 852: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);

848:
849: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
850: l_str_er_name := ''||l_employer_name||'';
851: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
852: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
853: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
854: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
855: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
856: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);

Line 853: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);

849: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
850: l_str_er_name := ''||l_employer_name||'';
851: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
852: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
853: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
854: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
855: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
856: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
857: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);

Line 854: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);

850: l_str_er_name := ''||l_employer_name||'';
851: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
852: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
853: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
854: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
855: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
856: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
857: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
858: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);

Line 855: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);

851: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
852: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
853: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
854: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
855: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
856: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
857: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
858: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
859: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);

Line 856: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);

852: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
853: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
854: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
855: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
856: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
857: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
858: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
859: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
860: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);

Line 857: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);

853: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
854: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
855: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
856: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
857: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
858: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
859: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
860: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
861: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);

Line 858: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);

854: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
855: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
856: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
857: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
858: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
859: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
860: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
861: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
862: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);

Line 859: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);

855: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
856: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
857: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
858: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
859: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
860: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
861: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
862: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
863: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);

Line 860: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);

856: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
857: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
858: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
859: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
860: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
861: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
862: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
863: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
864: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);

Line 861: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);

857: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
858: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
859: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
860: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
861: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
862: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
863: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
864: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
865: END IF;

Line 862: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);

858: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
859: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
860: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
861: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
862: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
863: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
864: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
865: END IF;
866:

Line 863: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);

859: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
860: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
861: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
862: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
863: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
864: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
865: END IF;
866:
867:

Line 864: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);

860: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
861: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
862: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
863: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
864: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
865: END IF;
866:
867:
868: WHILE j <= i LOOP

Line 881: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);

877: l_str7 := ''||substr(l_fm_asi_value,length(l_fm_asi_value)-2)||'';
878: l_str8 := ''||substr(l_fm_asi_value,1,length(l_fm_asi_value)-4)||'';
879: l_str9 := ''||substr(l_fm_asi_value,length(l_fm_asi_value)-2)||'';
880:
881: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
882: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
883: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
884: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
885: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);

Line 882: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);

878: l_str8 := ''||substr(l_fm_asi_value,1,length(l_fm_asi_value)-4)||'';
879: l_str9 := ''||substr(l_fm_asi_value,length(l_fm_asi_value)-2)||'';
880:
881: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
882: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
883: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
884: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
885: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);

Line 883: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);

879: l_str9 := ''||substr(l_fm_asi_value,length(l_fm_asi_value)-2)||'';
880:
881: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
882: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
883: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
884: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
885: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
887: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

Line 884: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);

880:
881: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
882: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
883: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
884: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
885: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
887: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
888: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 885: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);

881: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
882: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
883: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
884: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
885: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
887: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
888: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
889:

Line 886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);

882: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
883: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
884: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
885: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
887: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
888: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
889:
890: l_total_amount := l_total_amount + t_asi_emp_rec(j).asi_value;

Line 887: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

883: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
884: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
885: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
887: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
888: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
889:
890: l_total_amount := l_total_amount + t_asi_emp_rec(j).asi_value;
891: l_fm_total_value := to_char(l_total_amount,lg_format_mask);

Line 888: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');

884: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
885: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
887: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
888: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
889:
890: l_total_amount := l_total_amount + t_asi_emp_rec(j).asi_value;
891: l_fm_total_value := to_char(l_total_amount,lg_format_mask);
892:

Line 911: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);

907: l_str_total_af := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
908: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
909: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
910: l_str10 := '';
911: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
912: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
913: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
914: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
915: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);

Line 912: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);

908: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
909: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
910: l_str10 := '';
911: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
912: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
913: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
914: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
915: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
916: END IF;

Line 913: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);

909: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
910: l_str10 := '';
911: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
912: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
913: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
914: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
915: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
916: END IF;
917:

Line 914: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);

910: l_str10 := '';
911: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
912: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
913: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
914: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
915: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
916: END IF;
917:
918: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 915: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);

911: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
912: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
913: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
914: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
915: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
916: END IF;
917:
918: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
919:

Line 918: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

914: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
915: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
916: END IF;
917:
918: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
919:
920: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
921: clob_to_blob(l_xfdf_string,l_xfdf_blob);
922:

Line 920: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);

916: END IF;
917:
918: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
919:
920: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
921: clob_to_blob(l_xfdf_string,l_xfdf_blob);
922:
923: hr_utility.set_location('Finished creating xml data for Procedure report167 ',20);
924:

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

1255: l_str_rep_yyyy := ''||TO_CHAR(SYSDATE,'YYYY')||'';
1256: l_str_rep_mm := ''||TO_CHAR(SYSDATE,'MM')||'';
1257: l_str_rep_dd := '

'||TO_CHAR(SYSDATE,'DD')||'
';
1258:
1259: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1260: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1261: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1262: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1263:

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

1256: l_str_rep_mm := ''||TO_CHAR(SYSDATE,'MM')||'';
1257: l_str_rep_dd := '

'||TO_CHAR(SYSDATE,'DD')||'
';
1258:
1259: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1260: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1261: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1262: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1263:
1264: l_add_si_id := 0;

Line 1261: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);

1257: l_str_rep_dd := '

'||TO_CHAR(SYSDATE,'DD')||'
';
1258:
1259: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1260: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1261: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1262: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1263:
1264: l_add_si_id := 0;
1265: l_add_si_arr_id := 0;

Line 1359: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

1355: END LOOP;
1356: CLOSE csr_get_emp;
1357:
1358: j := 1;
1359: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1360: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1361: l_str_er_name := ''||l_employer_name||'';
1362: /**********l_str_er_ssn_9 := ''||SUBSTR(l_employer_ssn,9,1)||'';
1363: l_str_er_ssn_8 := ''||SUBSTR(l_employer_ssn,8,1)||'';

Line 1360: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

1356: CLOSE csr_get_emp;
1357:
1358: j := 1;
1359: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1360: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1361: l_str_er_name := ''||l_employer_name||'';
1362: /**********l_str_er_ssn_9 := ''||SUBSTR(l_employer_ssn,9,1)||'';
1363: l_str_er_ssn_8 := ''||SUBSTR(l_employer_ssn,8,1)||'';
1364: l_str_er_ssn_7 := ''||SUBSTR(l_employer_ssn,7,1)||'';

Line 1384: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);

1380: l_str_rep_yyyy := ''||TO_CHAR(SYSDATE,'YYYY')||'';
1381: l_str_rep_mm := ''||TO_CHAR(SYSDATE,'MM')||'';
1382: l_str_rep_dd := '

'||TO_CHAR(SYSDATE,'DD')||'
';
1383:
1384: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1385: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);

Line 1385: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);

1381: l_str_rep_mm := ''||TO_CHAR(SYSDATE,'MM')||'';
1382: l_str_rep_dd := '

'||TO_CHAR(SYSDATE,'DD')||'
';
1383:
1384: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1385: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);

Line 1386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);

1382: l_str_rep_dd := '

'||TO_CHAR(SYSDATE,'DD')||'
';
1383:
1384: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1385: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);

Line 1387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);

1383:
1384: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1385: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);

Line 1388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);

1384: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1385: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);

Line 1389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);

1385: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);

Line 1390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);

1386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);

Line 1391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);

1387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/

Line 1392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);

1388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1396:

Line 1393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);

1389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1396:
1397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);

Line 1394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);

1390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1396:
1397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);

Line 1395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/

1391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1396:
1397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);

Line 1397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);

1393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1396:
1397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1401:

Line 1398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);

1394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1396:
1397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1401:
1402: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);

Line 1399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);

1395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1396:
1397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1401:
1402: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1403: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);

Line 1400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);

1396:
1397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1401:
1402: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1403: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1404: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);

Line 1402: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);

1398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1401:
1402: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1403: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1404: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1405:
1406: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 1403: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);

1399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1401:
1402: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1403: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1404: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1405:
1406: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1407: IF i > 0 THEN

Line 1404: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);

1400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1401:
1402: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1403: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1404: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1405:
1406: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1407: IF i > 0 THEN
1408: l_asi_processed := 0;

Line 1406: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');

1402: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1403: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1404: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1405:
1406: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1407: IF i > 0 THEN
1408: l_asi_processed := 0;
1409: ELSE
1410: l_asi_processed := 1;

Line 1411: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

1407: IF i > 0 THEN
1408: l_asi_processed := 0;
1409: ELSE
1410: l_asi_processed := 1;
1411: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1412: END IF;
1413:
1414: WHILE l_asi_processed <> 1 LOOP
1415:

Line 1423: /*dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);

1419: /*****************l_str_total_ad := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1420: l_str_total_af := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';******************/
1421: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1422: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1423: /*dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1424: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);*/
1425: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1426: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1427: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 1424: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);*/

1420: l_str_total_af := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';******************/
1421: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1422: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1423: /*dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1424: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);*/
1425: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1426: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1427: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1428:

Line 1425: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);

1421: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1422: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1423: /*dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1424: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);*/
1425: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1426: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1427: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1428:
1429: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 1426: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);

1422: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1423: /*dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1424: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);*/
1425: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1426: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1427: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1428:
1429: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1430: l_str_er_name := ''||l_employer_name||'';

Line 1427: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

1423: /*dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1424: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);*/
1425: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1426: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1427: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1428:
1429: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1430: l_str_er_name := ''||l_employer_name||'';
1431: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);

Line 1429: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

1425: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1426: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1427: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1428:
1429: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1430: l_str_er_name := ''||l_employer_name||'';
1431: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1432: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1433: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);

Line 1431: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);

1427: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1428:
1429: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1430: l_str_er_name := ''||l_employer_name||'';
1431: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1432: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1433: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);

Line 1432: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);

1428:
1429: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1430: l_str_er_name := ''||l_employer_name||'';
1431: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1432: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1433: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);

Line 1433: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);

1429: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1430: l_str_er_name := ''||l_employer_name||'';
1431: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1432: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1433: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);

Line 1434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);

1430: l_str_er_name := ''||l_employer_name||'';
1431: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1432: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1433: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);

Line 1435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);

1431: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1432: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1433: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);

Line 1436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);

1432: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1433: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);

Line 1437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);

1433: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);

Line 1438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);

1434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/

Line 1439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);

1435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/
1443:

Line 1440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);

1436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/
1443:
1444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);

Line 1441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);

1437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/
1443:
1444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);

Line 1442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/

1438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/
1443:
1444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1446:

Line 1444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);

1440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/
1443:
1444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1446:
1447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1448: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);

Line 1445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);

1441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/
1443:
1444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1446:
1447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1448: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1449:

Line 1447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);

1443:
1444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1446:
1447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1448: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1449:
1450: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1451: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);

Line 1448: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);

1444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1446:
1447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1448: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1449:
1450: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1451: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1452: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);

Line 1450: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);

1446:
1447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1448: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1449:
1450: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1451: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1452: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1453: END IF;
1454:

Line 1451: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);

1447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1448: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1449:
1450: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1451: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1452: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1453: END IF;
1454:
1455:

Line 1452: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);

1448: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1449:
1450: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1451: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1452: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1453: END IF;
1454:
1455:
1456: WHILE j <= i LOOP

Line 1490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);

1486:
1487: l_str13 := ''||substr(l_fm_emp_total_value,1,length(l_fm_emp_total_value)-4)||'';
1488: l_str14 := ''||substr(l_fm_emp_total_value,length(l_fm_emp_total_value)-2)||'';
1489:
1490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1491: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1492: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1493: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1494: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);

Line 1491: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);

1487: l_str13 := ''||substr(l_fm_emp_total_value,1,length(l_fm_emp_total_value)-4)||'';
1488: l_str14 := ''||substr(l_fm_emp_total_value,length(l_fm_emp_total_value)-2)||'';
1489:
1490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1491: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1492: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1493: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1494: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1495: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);

Line 1492: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);

1488: l_str14 := ''||substr(l_fm_emp_total_value,length(l_fm_emp_total_value)-2)||'';
1489:
1490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1491: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1492: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1493: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1494: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1495: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1496: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

Line 1493: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);

1489:
1490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1491: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1492: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1493: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1494: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1495: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1496: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1497: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);

Line 1494: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);

1490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1491: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1492: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1493: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1494: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1495: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1496: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1497: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1498: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);

Line 1495: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);

1491: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1492: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1493: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1494: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1495: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1496: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1497: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1498: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1499: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);

Line 1496: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

1492: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1493: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1494: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1495: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1496: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1497: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1498: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1499: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1500: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);

Line 1497: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);

1493: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1494: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1495: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1496: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1497: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1498: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1499: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1500: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);
1501: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);

Line 1498: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);

1494: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1495: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1496: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1497: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1498: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1499: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1500: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);
1501: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);
1502: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 1499: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);

1495: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1496: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1497: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1498: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1499: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1500: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);
1501: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);
1502: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1503:

Line 1500: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);

1496: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1497: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1498: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1499: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1500: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);
1501: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);
1502: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1503:
1504: l_total_amount := l_total_amount + t_asi_emp_rec(j).emp_tot_value;

Line 1501: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);

1497: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1498: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1499: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1500: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);
1501: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);
1502: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1503:
1504: l_total_amount := l_total_amount + t_asi_emp_rec(j).emp_tot_value;
1505: l_fm_total_value := to_char(l_total_amount,lg_format_mask);

Line 1502: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');

1498: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1499: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1500: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);
1501: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);
1502: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1503:
1504: l_total_amount := l_total_amount + t_asi_emp_rec(j).emp_tot_value;
1505: l_fm_total_value := to_char(l_total_amount,lg_format_mask);
1506:

Line 1525: /*********************dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);

1521: l_str_total_af := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';*************************/
1522: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1523: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1524: l_str10 := '';
1525: /*********************dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);**************************/
1527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1529: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);

Line 1526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);**************************/

1522: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1523: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1524: l_str10 := '';
1525: /*********************dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);**************************/
1527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1529: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1530: END IF;

Line 1527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);

1523: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1524: l_str10 := '';
1525: /*********************dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);**************************/
1527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1529: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1530: END IF;
1531:

Line 1528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);

1524: l_str10 := '';
1525: /*********************dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);**************************/
1527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1529: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1530: END IF;
1531:
1532: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 1529: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);

1525: /*********************dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);**************************/
1527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1529: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1530: END IF;
1531:
1532: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1533:

Line 1532: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

1528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1529: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1530: END IF;
1531:
1532: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1533:
1534: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1535: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1536:

Line 1534: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);

1530: END IF;
1531:
1532: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1533:
1534: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1535: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1536:
1537: hr_utility.set_location('Finished creating xml data for Procedure report167 ',20);
1538:

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

2222: l_str7 := '
2223:
2224:
2225: ';
2226: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2227: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2228: if vXMLTable.COUNT > 0 then
2229: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2230: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

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

2223:
2224:
2225: ';
2226: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2227: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2228: if vXMLTable.COUNT > 0 then
2229: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2230: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
2231: l_str8 := vXMLTable(ctr_table).TagName;

Line 2229: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

2225: ';
2226: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2227: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2228: if vXMLTable.COUNT > 0 then
2229: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2230: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
2231: l_str8 := vXMLTable(ctr_table).TagName;
2232: l_str9 := vXMLTable(ctr_table).TagValue;
2233: if (l_str9 is not null) then

Line 2234: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );

2230: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
2231: l_str8 := vXMLTable(ctr_table).TagName;
2232: l_str9 := vXMLTable(ctr_table).TagValue;
2233: if (l_str9 is not null) then
2234: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2235: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2236: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2237: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2238: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

Line 2235: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);

2231: l_str8 := vXMLTable(ctr_table).TagName;
2232: l_str9 := vXMLTable(ctr_table).TagValue;
2233: if (l_str9 is not null) then
2234: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2235: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2236: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2237: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2238: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2239: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

Line 2236: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );

2232: l_str9 := vXMLTable(ctr_table).TagValue;
2233: if (l_str9 is not null) then
2234: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2235: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2236: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2237: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2238: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2239: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2240: elsif (l_str9 is null and l_str8 is not null) then

Line 2237: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );

2233: if (l_str9 is not null) then
2234: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2235: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2236: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2237: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2238: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2239: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2240: elsif (l_str9 is null and l_str8 is not null) then
2241: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

Line 2238: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

2234: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2235: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2236: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2237: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2238: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2239: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2240: elsif (l_str9 is null and l_str8 is not null) then
2241: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2242: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

Line 2239: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

2235: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2236: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2237: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2238: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2239: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2240: elsif (l_str9 is null and l_str8 is not null) then
2241: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2242: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2243: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

Line 2241: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

2237: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2238: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2239: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2240: elsif (l_str9 is null and l_str8 is not null) then
2241: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2242: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2243: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2244: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2245: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

Line 2242: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

2238: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2239: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2240: elsif (l_str9 is null and l_str8 is not null) then
2241: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2242: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2243: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2244: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2245: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2246: else

Line 2243: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

2239: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2240: elsif (l_str9 is null and l_str8 is not null) then
2241: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2242: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2243: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2244: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2245: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2246: else
2247: null;

Line 2244: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);

2240: elsif (l_str9 is null and l_str8 is not null) then
2241: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2242: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2243: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2244: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2245: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2246: else
2247: null;
2248: end if;

Line 2245: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

2241: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2242: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2243: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2244: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2245: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2246: else
2247: null;
2248: end if;
2249: END LOOP;

Line 2250: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );

2246: else
2247: null;
2248: end if;
2249: END LOOP;
2250: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
2251: else
2252: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
2253: end if;
2254: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

Line 2252: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );

2248: end if;
2249: END LOOP;
2250: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
2251: else
2252: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
2253: end if;
2254: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
2255: clob_to_blob(l_xfdf_string,p_xfdf_blob);
2256: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

Line 2254: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

2250: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
2251: else
2252: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
2253: end if;
2254: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
2255: clob_to_blob(l_xfdf_string,p_xfdf_blob);
2256: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
2257: --return p_xfdf_blob;
2258: EXCEPTION

Line 2284: l_length_clob := dbms_lob.getlength(p_clob);

2280: begin
2281: l_buffer_len := 20000;
2282: hr_utility.set_location('Entered Procedure clob to blob',120);
2283: select userenv('LANGUAGE') into g_nls_db_char from dual;
2284: l_length_clob := dbms_lob.getlength(p_clob);
2285: l_offset := 1;
2286: while l_length_clob > 0 loop
2287: hr_utility.trace('l_length_clob '|| l_length_clob);
2288: if l_length_clob < l_buffer_len then

Line 2293: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);

2289: l_chunk_len := l_length_clob;
2290: else
2291: l_chunk_len := l_buffer_len;
2292: end if;
2293: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
2294: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
2295: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
2296: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
2297:

Line 2301: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);

2297:
2298: fnd_file.put_line(fnd_file.log, l_varchar_buffer);
2299:
2300: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
2301: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
2302: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
2303: l_blob_offset := l_blob_offset + l_raw_buffer_len;
2304:
2305: l_offset := l_offset + l_chunk_len;

Line 2302: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);

2298: fnd_file.put_line(fnd_file.log, l_varchar_buffer);
2299:
2300: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
2301: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
2302: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
2303: l_blob_offset := l_blob_offset + l_raw_buffer_len;
2304:
2305: l_offset := l_offset + l_chunk_len;
2306: l_length_clob := l_length_clob - l_chunk_len;

Line 2307: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

2303: l_blob_offset := l_blob_offset + l_raw_buffer_len;
2304:
2305: l_offset := l_offset + l_chunk_len;
2306: l_length_clob := l_length_clob - l_chunk_len;
2307: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
2308: end loop;
2309: hr_utility.set_location('Finished Procedure clob to blob ',130);
2310: end clob_to_blob;
2311: