DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on DBMS_LOB

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

889: l_str10 := ''||SUBSTR(l_employer_ssn,9,1)||'';
890: l_str_month := ''||l_effective_month||'';
891: l_str_year := ''||p_effective_year||'';
892:
893: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
894: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
895: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
896: clob_to_blob(l_xfdf_string,l_xfdf_blob);
897:

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

890: l_str_month := ''||l_effective_month||'';
891: l_str_year := ''||p_effective_year||'';
892:
893: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
894: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
895: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
896: clob_to_blob(l_xfdf_string,l_xfdf_blob);
897:
898: l_add_si_id := 0;

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

891: l_str_year := ''||p_effective_year||'';
892:
893: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
894: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
895: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
896: clob_to_blob(l_xfdf_string,l_xfdf_blob);
897:
898: l_add_si_id := 0;
899: l_add_si_arr_id := 0;

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

943: END LOOP;
944: CLOSE csr_get_emp;
945:
946: j := 1;
947: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
948: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
949: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
950: l_str_er_ssn_9 := ''||SUBSTR(l_employer_ssn,9,1)||'';
951: l_str_er_ssn_8 := ''||SUBSTR(l_employer_ssn,8,1)||'';

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

944: CLOSE csr_get_emp;
945:
946: j := 1;
947: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
948: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
949: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
950: l_str_er_ssn_9 := ''||SUBSTR(l_employer_ssn,9,1)||'';
951: l_str_er_ssn_8 := ''||SUBSTR(l_employer_ssn,8,1)||'';
952: l_str_er_ssn_7 := ''||SUBSTR(l_employer_ssn,7,1)||'';

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

959: l_str_er_ssn_0 := ''||'0'||'';
960: l_str_er_ssn_0a := ''||'0'||'';
961: l_str_month := ''||l_effective_month||'';
962: l_str_year := ''||p_effective_year||'';
963: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
964: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
965: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
966: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
967: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);

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

960: l_str_er_ssn_0a := ''||'0'||'';
961: l_str_month := ''||l_effective_month||'';
962: l_str_year := ''||p_effective_year||'';
963: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
964: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
965: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
966: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
967: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
968: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);

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

961: l_str_month := ''||l_effective_month||'';
962: l_str_year := ''||p_effective_year||'';
963: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
964: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
965: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
966: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
967: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
968: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
969: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);

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

962: l_str_year := ''||p_effective_year||'';
963: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
964: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
965: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
966: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
967: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
968: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
969: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
970: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);

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

963: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
964: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
965: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
966: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
967: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
968: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
969: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
970: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
971: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);

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

964: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
965: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
966: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
967: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
968: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
969: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
970: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
971: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
972: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);

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

965: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
966: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
967: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
968: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
969: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
970: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
971: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
972: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
973: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);

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

966: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
967: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
968: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
969: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
970: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
971: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
972: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
973: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
974: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);

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

967: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
968: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
969: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
970: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
971: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
972: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
973: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
974: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
975: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);

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

968: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
969: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
970: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
971: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
972: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
973: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
974: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
975: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
976: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);

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

969: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
970: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
971: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
972: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
973: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
974: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
975: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
976: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
977: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

970: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
971: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
972: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
973: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
974: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
975: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
976: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
977: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
978: IF i > 0 THEN

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

971: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
972: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
973: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
974: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
975: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
976: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
977: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
978: IF i > 0 THEN
979: l_asi_processed := 0;

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

972: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
973: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
974: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
975: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
976: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
977: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
978: IF i > 0 THEN
979: l_asi_processed := 0;
980: ELSE

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

973: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
974: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
975: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
976: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
977: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
978: IF i > 0 THEN
979: l_asi_processed := 0;
980: ELSE
981: l_asi_processed := 1;

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

978: IF i > 0 THEN
979: l_asi_processed := 0;
980: ELSE
981: l_asi_processed := 1;
982: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
983: END IF;
984:
985: WHILE l_asi_processed <> 1 LOOP
986:

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

990: l_str_total_ad := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
991: l_str_total_af := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
992: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
993: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
994: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
995: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
996: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
997: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
998: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

991: l_str_total_af := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
992: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
993: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
994: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
995: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
996: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
997: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
998: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
999:

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

992: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
993: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
994: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
995: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
996: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
997: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
998: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
999:
1000: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

993: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
994: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
995: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
996: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
997: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
998: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
999:
1000: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1001: l_str_er_name := ''||''||''; /* Bug No : 8299900 */

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

994: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
995: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
996: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
997: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
998: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
999:
1000: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1001: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1002: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);

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

996: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
997: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
998: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
999:
1000: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1001: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1002: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1003: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1004: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);

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

998: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
999:
1000: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1001: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1002: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1003: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1004: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1005: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1006: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);

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

999:
1000: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1001: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1002: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1003: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1004: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1005: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1006: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1007: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);

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

1000: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1001: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1002: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1003: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1004: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1005: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1006: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1007: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1008: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);

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

1001: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1002: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1003: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1004: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1005: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1006: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1007: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1008: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1009: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);

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

1002: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1003: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1004: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1005: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1006: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1007: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1008: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1009: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1010: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);

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

1003: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1004: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1005: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1006: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1007: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1008: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1009: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1010: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1011: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);

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

1004: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1005: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1006: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1007: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1008: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1009: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1010: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1011: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1012: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);

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

1005: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1006: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1007: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1008: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1009: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1010: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1011: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1012: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);

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

1006: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1007: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1008: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1009: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1010: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1011: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1012: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
1014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);

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

1007: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1008: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1009: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1010: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1011: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1012: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
1014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);

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

1008: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1009: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1010: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1011: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1012: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
1014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1016: END IF;

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

1009: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1010: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1011: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1012: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
1014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1016: END IF;
1017:

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

1010: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1011: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1012: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
1014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1016: END IF;
1017:
1018:

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

1011: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1012: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);
1014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1016: END IF;
1017:
1018:
1019: WHILE j <= i LOOP

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

1028: l_str7 := ''||substr(l_fm_asi_value,length(l_fm_asi_value)-2)||'';
1029: l_str8 := ''||substr(l_fm_asi_value,1,length(l_fm_asi_value)-4)||'';
1030: l_str9 := ''||substr(l_fm_asi_value,length(l_fm_asi_value)-2)||'';
1031:
1032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1033: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1034: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1035: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1036: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);

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

1029: l_str8 := ''||substr(l_fm_asi_value,1,length(l_fm_asi_value)-4)||'';
1030: l_str9 := ''||substr(l_fm_asi_value,length(l_fm_asi_value)-2)||'';
1031:
1032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1033: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1034: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1035: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1036: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1037: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);

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

1030: l_str9 := ''||substr(l_fm_asi_value,length(l_fm_asi_value)-2)||'';
1031:
1032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1033: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1034: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1035: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1036: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1037: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1038: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

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

1031:
1032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1033: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1034: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1035: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1036: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1037: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1038: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1039: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

1032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1033: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1034: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1035: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1036: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1037: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1038: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1039: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1040:

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

1033: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1034: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1035: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1036: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1037: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1038: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1039: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1040:
1041: l_total_amount := l_total_amount + t_asi_emp_rec(j).asi_value;

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

1034: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1035: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1036: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1037: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1038: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1039: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1040:
1041: l_total_amount := l_total_amount + t_asi_emp_rec(j).asi_value;
1042: l_fm_total_value := to_char(l_total_amount,lg_format_mask);

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

1035: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1036: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1037: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1038: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1039: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1040:
1041: l_total_amount := l_total_amount + t_asi_emp_rec(j).asi_value;
1042: l_fm_total_value := to_char(l_total_amount,lg_format_mask);
1043:

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

1058: l_str_total_af := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1059: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1060: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1061: l_str10 := '';
1062: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1063: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
1064: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1065: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1066: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);

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

1059: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1060: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1061: l_str10 := '';
1062: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1063: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
1064: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1065: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1066: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1067: END IF;

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

1060: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1061: l_str10 := '';
1062: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1063: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
1064: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1065: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1066: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1067: END IF;
1068:

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

1061: l_str10 := '';
1062: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1063: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
1064: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1065: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1066: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1067: END IF;
1068:
1069: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

1062: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1063: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);
1064: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1065: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1066: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1067: END IF;
1068:
1069: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1070:

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

1065: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1066: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1067: END IF;
1068:
1069: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1070:
1071: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1072: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1073:

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

1067: END IF;
1068:
1069: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1070:
1071: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1072: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1073:
1074: hr_utility.set_location('Finished creating xml data for Procedure report167 ',20);
1075:

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

1406: l_str_rep_yyyy := ''||TO_CHAR(SYSDATE,'YYYY')||'';
1407: l_str_rep_mm := ''||TO_CHAR(SYSDATE,'MM')||'';
1408: l_str_rep_dd := '

'||TO_CHAR(SYSDATE,'DD')||'
';
1409:
1410: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1411: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1412: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1413: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1414:

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

1407: l_str_rep_mm := ''||TO_CHAR(SYSDATE,'MM')||'';
1408: l_str_rep_dd := '

'||TO_CHAR(SYSDATE,'DD')||'
';
1409:
1410: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1411: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1412: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1413: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1414:
1415: l_add_si_id := 0;

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

1408: l_str_rep_dd := '

'||TO_CHAR(SYSDATE,'DD')||'
';
1409:
1410: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1411: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1412: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1413: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1414:
1415: l_add_si_id := 0;
1416: l_add_si_arr_id := 0;

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

1506: END LOOP;
1507: CLOSE csr_get_emp;
1508:
1509: j := 1;
1510: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1511: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1512: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1513: /**********l_str_er_ssn_9 := ''||SUBSTR(l_employer_ssn,9,1)||'';
1514: l_str_er_ssn_8 := ''||SUBSTR(l_employer_ssn,8,1)||'';

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

1507: CLOSE csr_get_emp;
1508:
1509: j := 1;
1510: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1511: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1512: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1513: /**********l_str_er_ssn_9 := ''||SUBSTR(l_employer_ssn,9,1)||'';
1514: l_str_er_ssn_8 := ''||SUBSTR(l_employer_ssn,8,1)||'';
1515: l_str_er_ssn_7 := ''||SUBSTR(l_employer_ssn,7,1)||'';

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

1531: l_str_rep_yyyy := ''||TO_CHAR(SYSDATE,'YYYY')||'';
1532: l_str_rep_mm := ''||TO_CHAR(SYSDATE,'MM')||'';
1533: l_str_rep_dd := '

'||TO_CHAR(SYSDATE,'DD')||'
';
1534:
1535: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1536: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1537: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1538: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1539: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);

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

1532: l_str_rep_mm := ''||TO_CHAR(SYSDATE,'MM')||'';
1533: l_str_rep_dd := '

'||TO_CHAR(SYSDATE,'DD')||'
';
1534:
1535: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1536: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1537: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1538: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1539: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1540: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);

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

1533: l_str_rep_dd := '

'||TO_CHAR(SYSDATE,'DD')||'
';
1534:
1535: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1536: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1537: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1538: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1539: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1540: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1541: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);

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

1534:
1535: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1536: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1537: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1538: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1539: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1540: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1541: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1542: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);

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

1535: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1536: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1537: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1538: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1539: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1540: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1541: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1542: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1543: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);

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

1536: /********dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1537: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1538: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1539: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1540: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1541: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1542: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1543: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1544: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);

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

1537: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1538: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1539: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1540: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1541: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1542: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1543: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1544: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1545: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);

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

1538: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1539: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1540: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1541: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1542: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1543: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1544: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1545: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1546: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/

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

1539: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1540: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1541: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1542: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1543: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1544: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1545: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1546: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1547:

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

1540: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1541: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1542: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1543: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1544: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1545: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1546: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1547:
1548: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);

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

1541: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1542: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1543: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1544: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1545: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1546: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1547:
1548: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1549: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);

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

1542: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1543: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1544: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1545: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1546: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1547:
1548: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1549: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1550: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);

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

1544: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1545: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1546: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1547:
1548: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1549: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1550: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1551: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1552:

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

1545: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1546: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1547:
1548: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1549: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1550: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1551: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1552:
1553: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);

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

1546: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);**********/
1547:
1548: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1549: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1550: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1551: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1552:
1553: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1554: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);

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

1547:
1548: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1549: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1550: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1551: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1552:
1553: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1554: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1555: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);

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

1549: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1550: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1551: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1552:
1553: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1554: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1555: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1556:
1557: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

1550: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1551: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1552:
1553: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1554: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1555: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1556:
1557: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1558: IF i > 0 THEN

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

1551: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1552:
1553: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1554: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1555: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1556:
1557: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1558: IF i > 0 THEN
1559: l_asi_processed := 0;

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

1553: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1554: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1555: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1556:
1557: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1558: IF i > 0 THEN
1559: l_asi_processed := 0;
1560: ELSE
1561: l_asi_processed := 1;

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

1558: IF i > 0 THEN
1559: l_asi_processed := 0;
1560: ELSE
1561: l_asi_processed := 1;
1562: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1563: END IF;
1564:
1565: WHILE l_asi_processed <> 1 LOOP
1566:

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

1570: /*****************l_str_total_ad := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1571: l_str_total_af := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';******************/
1572: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1573: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1574: /*dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1575: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);*/
1576: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1577: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1578: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

1571: l_str_total_af := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';******************/
1572: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1573: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1574: /*dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1575: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);*/
1576: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1577: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1578: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1579:

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

1572: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1573: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1574: /*dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1575: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);*/
1576: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1577: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1578: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1579:
1580: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

1573: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1574: /*dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1575: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);*/
1576: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1577: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1578: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1579:
1580: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1581: l_str_er_name := ''||''||''; /* Bug No : 8299900 */

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

1574: /*dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1575: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);*/
1576: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1577: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1578: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1579:
1580: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1581: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1582: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);

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

1576: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1577: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1578: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1579:
1580: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1581: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1582: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1583: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1584: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);

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

1578: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1579:
1580: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1581: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1582: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1583: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1584: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1585: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1586: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);

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

1579:
1580: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1581: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1582: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1583: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1584: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1585: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1586: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1587: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);

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

1580: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1581: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1582: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1583: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1584: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1585: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1586: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1587: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1588: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);

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

1581: l_str_er_name := ''||''||''; /* Bug No : 8299900 */
1582: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1583: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1584: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1585: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1586: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1587: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1588: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1589: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);

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

1582: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
1583: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1584: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1585: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1586: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1587: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1588: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1589: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1590: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);

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

1583: /******dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_9), l_str_er_ssn_9);
1584: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1585: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1586: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1587: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1588: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1589: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1590: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1591: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);

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

1584: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_8), l_str_er_ssn_8);
1585: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1586: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1587: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1588: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1589: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1590: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1591: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1592: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);

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

1585: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_7), l_str_er_ssn_7);
1586: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1587: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1588: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1589: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1590: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1591: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1592: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1593: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/

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

1586: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_6), l_str_er_ssn_6);
1587: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1588: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1589: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1590: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1591: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1592: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1593: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/
1594:

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

1587: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_5), l_str_er_ssn_5);
1588: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1589: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1590: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1591: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1592: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1593: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/
1594:
1595: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);

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

1588: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_4), l_str_er_ssn_4);
1589: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1590: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1591: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1592: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1593: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/
1594:
1595: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1596: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);

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

1589: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_3), l_str_er_ssn_3);
1590: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_2), l_str_er_ssn_2);
1591: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1592: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1593: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/
1594:
1595: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1596: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1597:

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

1591: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_1), l_str_er_ssn_1);
1592: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1593: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/
1594:
1595: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1596: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1597:
1598: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1599: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);

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

1592: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0), l_str_er_ssn_0);
1593: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn_0a), l_str_er_ssn_0a);********/
1594:
1595: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1596: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1597:
1598: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1599: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1600:

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

1594:
1595: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1596: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1597:
1598: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1599: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1600:
1601: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1602: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);

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

1595: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_addr), l_str_er_addr);
1596: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
1597:
1598: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1599: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1600:
1601: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1602: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1603: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);

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

1597:
1598: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1599: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1600:
1601: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1602: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1603: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1604: END IF;
1605:

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

1598: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
1599: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1600:
1601: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1602: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1603: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1604: END IF;
1605:
1606:

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

1599: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
1600:
1601: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_yyyy), l_str_rep_yyyy);
1602: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_mm), l_str_rep_mm);
1603: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_dd), l_str_rep_dd);
1604: END IF;
1605:
1606:
1607: WHILE j <= i LOOP

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

1637:
1638: l_str13 := ''||substr(l_fm_emp_total_value,1,length(l_fm_emp_total_value)-4)||'';
1639: l_str14 := ''||substr(l_fm_emp_total_value,length(l_fm_emp_total_value)-2)||'';
1640:
1641: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1642: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1643: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1644: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1645: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);

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

1638: l_str13 := ''||substr(l_fm_emp_total_value,1,length(l_fm_emp_total_value)-4)||'';
1639: l_str14 := ''||substr(l_fm_emp_total_value,length(l_fm_emp_total_value)-2)||'';
1640:
1641: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1642: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1643: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1644: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1645: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1646: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);

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

1639: l_str14 := ''||substr(l_fm_emp_total_value,length(l_fm_emp_total_value)-2)||'';
1640:
1641: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1642: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1643: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1644: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1645: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1646: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1647: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

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

1640:
1641: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1642: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1643: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1644: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1645: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1646: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1647: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1648: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);

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

1641: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ser), l_str_ser);
1642: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1643: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1644: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1645: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1646: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1647: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1648: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1649: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);

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

1642: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4);
1643: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1644: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1645: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1646: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1647: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1648: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1649: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1650: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);

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

1643: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5);
1644: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1645: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1646: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1647: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1648: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1649: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1650: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1651: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);

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

1644: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6);
1645: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1646: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1647: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1648: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1649: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1650: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1651: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);
1652: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);

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

1645: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7);
1646: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1647: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1648: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1649: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1650: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1651: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);
1652: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);
1653: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

1646: dbms_lob.writeAppend( l_xfdf_string, length(l_str8), l_str8);
1647: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1648: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1649: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1650: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1651: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);
1652: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);
1653: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1654:

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

1647: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1648: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1649: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1650: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1651: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);
1652: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);
1653: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1654:
1655: l_total_amount := l_total_amount + t_asi_emp_rec(j).emp_tot_value;

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

1648: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1649: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1650: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1651: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);
1652: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);
1653: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1654:
1655: l_total_amount := l_total_amount + t_asi_emp_rec(j).emp_tot_value;
1656: l_fm_total_value := to_char(l_total_amount,lg_format_mask);

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

1649: dbms_lob.writeAppend( l_xfdf_string, length(l_str11), l_str11);
1650: dbms_lob.writeAppend( l_xfdf_string, length(l_str12), l_str12);
1651: dbms_lob.writeAppend( l_xfdf_string, length(l_str13), l_str13);
1652: dbms_lob.writeAppend( l_xfdf_string, length(l_str14), l_str14);
1653: --dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1654:
1655: l_total_amount := l_total_amount + t_asi_emp_rec(j).emp_tot_value;
1656: l_fm_total_value := to_char(l_total_amount,lg_format_mask);
1657:

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

1672: l_str_total_af := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';*************************/
1673: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1674: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1675: l_str10 := '';
1676: /*********************dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1677: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);**************************/
1678: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1679: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1680: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);

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

1673: l_str_total_d := ''||substr(l_fm_total_value,1,length(l_fm_total_value)-4)||'';
1674: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1675: l_str10 := '';
1676: /*********************dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1677: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);**************************/
1678: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1679: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1680: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1681: END IF;

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

1674: l_str_total_f := ''||substr(l_fm_total_value,length(l_fm_total_value)-2)||'';
1675: l_str10 := '';
1676: /*********************dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1677: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);**************************/
1678: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1679: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1680: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1681: END IF;
1682:

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

1675: l_str10 := '';
1676: /*********************dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1677: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);**************************/
1678: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1679: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1680: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1681: END IF;
1682:
1683: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

1676: /*********************dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ad), l_str_total_ad);
1677: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_af), l_str_total_af);**************************/
1678: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_d), l_str_total_d);
1679: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1680: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1681: END IF;
1682:
1683: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1684:

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

1679: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_f), l_str_total_f);
1680: dbms_lob.writeAppend( l_xfdf_string, length(l_str10), l_str10);
1681: END IF;
1682:
1683: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1684:
1685: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1686: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1687:

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

1681: END IF;
1682:
1683: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1684:
1685: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1686: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1687:
1688: hr_utility.set_location('Finished creating xml data for Procedure report167 ',20);
1689:

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

2718: l_str7 := '
2719:
2720:
2721: ';
2722: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2723: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2724: if vXMLTable.COUNT > 0 then
2725: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2726: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

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

2719:
2720:
2721: ';
2722: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2723: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2724: if vXMLTable.COUNT > 0 then
2725: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2726: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
2727: l_str8 := vXMLTable(ctr_table).TagName;

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

2721: ';
2722: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
2723: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
2724: if vXMLTable.COUNT > 0 then
2725: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
2726: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
2727: l_str8 := vXMLTable(ctr_table).TagName;
2728: l_str9 := vXMLTable(ctr_table).TagValue;
2729: if (l_str9 is not null) then

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

2728: l_str9 := vXMLTable(ctr_table).TagValue;
2729: if (l_str9 is not null) then
2730: /* Added CDATA to handle special characters Bug No:8299900 */
2731: l_str9 := '';
2732: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2733: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2734: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2735: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2736: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

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

2729: if (l_str9 is not null) then
2730: /* Added CDATA to handle special characters Bug No:8299900 */
2731: l_str9 := '';
2732: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2733: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2734: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2735: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2736: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2737: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

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

2730: /* Added CDATA to handle special characters Bug No:8299900 */
2731: l_str9 := '';
2732: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2733: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2734: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2735: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2736: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2737: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2738: elsif (l_str9 is null and l_str8 is not null) then

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

2731: l_str9 := '';
2732: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2733: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2734: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2735: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2736: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2737: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2738: elsif (l_str9 is null and l_str8 is not null) then
2739: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

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

2732: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
2733: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2734: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2735: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2736: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2737: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2738: elsif (l_str9 is null and l_str8 is not null) then
2739: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2740: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

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

2733: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
2734: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
2735: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2736: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2737: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2738: elsif (l_str9 is null and l_str8 is not null) then
2739: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2740: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2741: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

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

2735: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
2736: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2737: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2738: elsif (l_str9 is null and l_str8 is not null) then
2739: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2740: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2741: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2742: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2743: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

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

2736: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
2737: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2738: elsif (l_str9 is null and l_str8 is not null) then
2739: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2740: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2741: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2742: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2743: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2744: else

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

2737: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
2738: elsif (l_str9 is null and l_str8 is not null) then
2739: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2740: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2741: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2742: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2743: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2744: else
2745: null;

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

2738: elsif (l_str9 is null and l_str8 is not null) then
2739: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2740: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2741: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2742: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2743: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2744: else
2745: null;
2746: end if;

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

2739: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
2740: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
2741: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
2742: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
2743: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
2744: else
2745: null;
2746: end if;
2747: END LOOP;

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

2744: else
2745: null;
2746: end if;
2747: END LOOP;
2748: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
2749: else
2750: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
2751: end if;
2752: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

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

2746: end if;
2747: END LOOP;
2748: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
2749: else
2750: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
2751: end if;
2752: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
2753: clob_to_blob(l_xfdf_string,p_xfdf_blob);
2754: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

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

2748: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
2749: else
2750: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
2751: end if;
2752: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
2753: clob_to_blob(l_xfdf_string,p_xfdf_blob);
2754: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
2755: --return p_xfdf_blob;
2756: EXCEPTION

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

2778: begin
2779: l_buffer_len := 20000;
2780: hr_utility.set_location('Entered Procedure clob to blob',120);
2781: select userenv('LANGUAGE') into g_nls_db_char from dual;
2782: l_length_clob := dbms_lob.getlength(p_clob);
2783: l_offset := 1;
2784: while l_length_clob > 0 loop
2785: hr_utility.trace('l_length_clob '|| l_length_clob);
2786: if l_length_clob < l_buffer_len then

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

2787: l_chunk_len := l_length_clob;
2788: else
2789: l_chunk_len := l_buffer_len;
2790: end if;
2791: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
2792: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
2793: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
2794: 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));
2795:

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

2795:
2796: fnd_file.put_line(fnd_file.log, l_varchar_buffer);
2797:
2798: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
2799: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
2800: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
2801: l_blob_offset := l_blob_offset + l_raw_buffer_len;
2802:
2803: l_offset := l_offset + l_chunk_len;

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

2796: fnd_file.put_line(fnd_file.log, l_varchar_buffer);
2797:
2798: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
2799: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
2800: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
2801: l_blob_offset := l_blob_offset + l_raw_buffer_len;
2802:
2803: l_offset := l_offset + l_chunk_len;
2804: l_length_clob := l_length_clob - l_chunk_len;

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

2801: l_blob_offset := l_blob_offset + l_raw_buffer_len;
2802:
2803: l_offset := l_offset + l_chunk_len;
2804: l_length_clob := l_length_clob - l_chunk_len;
2805: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
2806: end loop;
2807: hr_utility.set_location('Finished Procedure clob to blob ',130);
2808: end clob_to_blob;
2809: