APPS.PAY_AE_SI_REPORTS dependencies on DBMS_LOB

Line 2499: dbms_lob.writeAppend( l_xfdf_string, length(l_str_dd), l_str_dd);

2495: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
2496: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
2497: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
2498: dbms_lob.writeAppend( l_xfdf_string, length(l_str_mon), l_str_mon);
2499: dbms_lob.writeAppend( l_xfdf_string, length(l_str_dd), l_str_dd);
2500: l_str_seq_no := ''||l_tot_count||'';
2501: l_str_ee_ssn := ''||l_insured_ssn ||'';
2502: l_str_ee_name := ''|| substr(l_full_name,1,60) ||'';
2503: l_str_bsd := ''||substr(l_fm_l_basic_val,1,length(l_fm_l_basic_val)-3)||'';

Line 2517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);

2513: l_str_a4d := ''||substr(l_fm_l_allowance_4_val,1,length(l_fm_l_allowance_4_val)-3)||'';
2514: l_str_a4f := ''||substr(l_fm_l_allowance_4_val,length(l_fm_l_allowance_4_val)-1)||'';
2515: l_str_a5d := ''||substr(l_fm_total_val,1,length(l_fm_total_val)-3)||'';
2516: l_str_a5f := ''||substr(l_fm_total_val,length(l_fm_total_val)-1)||'';
2517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
2518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
2519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
2520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
2521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

Line 2518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);

2514: l_str_a4f := ''||substr(l_fm_l_allowance_4_val,length(l_fm_l_allowance_4_val)-1)||'';
2515: l_str_a5d := ''||substr(l_fm_total_val,1,length(l_fm_total_val)-3)||'';
2516: l_str_a5f := ''||substr(l_fm_total_val,length(l_fm_total_val)-1)||'';
2517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
2518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
2519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
2520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
2521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
2522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);

Line 2519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);

2515: l_str_a5d := ''||substr(l_fm_total_val,1,length(l_fm_total_val)-3)||'';
2516: l_str_a5f := ''||substr(l_fm_total_val,length(l_fm_total_val)-1)||'';
2517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
2518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
2519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
2520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
2521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
2522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
2523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);

Line 2520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

2516: l_str_a5f := ''||substr(l_fm_total_val,length(l_fm_total_val)-1)||'';
2517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
2518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
2519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
2520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
2521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
2522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
2523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
2524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

Line 2521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

2517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
2518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
2519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
2520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
2521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
2522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
2523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
2524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
2525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

Line 2522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);

2518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
2519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
2520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
2521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
2522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
2523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
2524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
2525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
2526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

Line 2523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);

2519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
2520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
2521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
2522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
2523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
2524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
2525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
2526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
2527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

Line 2524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

2520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
2521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
2522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
2523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
2524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
2525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
2526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
2527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
2528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

Line 2525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

2521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
2522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
2523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
2524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
2525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
2526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
2527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
2528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
2529: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

Line 2526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

2522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
2523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
2524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
2525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
2526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
2527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
2528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
2529: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
2530: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);

Line 2527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

2523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
2524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
2525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
2526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
2527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
2528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
2529: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
2530: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
2531: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);

Line 2528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

2524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
2525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
2526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
2527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
2528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
2529: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
2530: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
2531: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
2532: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);

Line 2529: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

2525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
2526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
2527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
2528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
2529: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
2530: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
2531: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
2532: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
2533: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);

Line 2530: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);

2526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
2527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
2528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
2529: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
2530: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
2531: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
2532: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
2533: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
2534: j := j + 1;

Line 2531: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);

2527: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
2528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
2529: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
2530: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
2531: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
2532: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
2533: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
2534: j := j + 1;
2535: l := l + 1;

Line 2532: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);

2528: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
2529: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
2530: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
2531: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
2532: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
2533: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
2534: j := j + 1;
2535: l := l + 1;
2536: IF j > i THEN

Line 2533: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);

2529: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
2530: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
2531: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
2532: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
2533: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
2534: j := j + 1;
2535: l := l + 1;
2536: IF j > i THEN
2537: l_new_processed := 1;

Line 2541: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pb),l_str_pb);

2537: l_new_processed := 1;
2538: END IF;
2539: IF l_new_count = 12/*8*/ THEN
2540: l_str_pb := ''||' '||'';
2541: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pb),l_str_pb);
2542: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
2543: l := 1;
2544: EXIT;
2545: END IF;

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

2538: END IF;
2539: IF l_new_count = 12/*8*/ THEN
2540: l_str_pb := ''||' '||'';
2541: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pb),l_str_pb);
2542: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
2543: l := 1;
2544: EXIT;
2545: END IF;
2546: END LOOP;

Line 2551: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pb),l_str_pb);

2547: IF l_new_processed = 1 THEN
2548: l_all_processed := 1;
2549: If l_new_count <> 12 then
2550: l_str_pb := ''||' '||'';
2551: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pb),l_str_pb);
2552: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
2553: End If;
2554: END IF;
2555: END LOOP;

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

2548: l_all_processed := 1;
2549: If l_new_count <> 12 then
2550: l_str_pb := ''||' '||'';
2551: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pb),l_str_pb);
2552: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
2553: End If;
2554: END IF;
2555: END LOOP;
2556: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

2552: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
2553: End If;
2554: END IF;
2555: END LOOP;
2556: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
2557: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
2558: clob_to_blob(l_xfdf_string,l_xfdf_blob);
2559: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
2560: EXCEPTION

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

2553: End If;
2554: END IF;
2555: END LOOP;
2556: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
2557: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
2558: clob_to_blob(l_xfdf_string,l_xfdf_blob);
2559: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
2560: EXCEPTION
2561: WHEN utl_file.invalid_path then

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

2996: null;
2997: END;
2998:
2999:
3000: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
3001: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
3002: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
3003: clob_to_blob(l_xfdf_string,l_xfdf_blob);
3004: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

2997: END;
2998:
2999:
3000: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
3001: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
3002: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
3003: clob_to_blob(l_xfdf_string,l_xfdf_blob);
3004: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
3005:

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

2998:
2999:
3000: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
3001: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
3002: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
3003: clob_to_blob(l_xfdf_string,l_xfdf_blob);
3004: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
3005:
3006: OPEN csr_get_def_bal_ids (p_employer_id);

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

3000: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
3001: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
3002: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
3003: clob_to_blob(l_xfdf_string,l_xfdf_blob);
3004: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
3005:
3006: OPEN csr_get_def_bal_ids (p_employer_id);
3007: FETCH csr_get_def_bal_ids into l_basic_sal_id,l_accomodation_id,l_social_id,l_child_social_id,l_cost_of_living_id,l_ol1_id,l_tp_id,l_ol2_id,l_ol3_id,l_ol4_id;
3008: CLOSE csr_get_def_bal_ids;

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

3170:
3171: WHILE l_all_processed <> 1 LOOP
3172: --Writing data for new employees
3173: l_new_count := 0;
3174: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
3175: l_str_er_name := ''||l_employer_name||'';
3176: l_str_er_ssn := ''||l_employer_ssn||'';
3177: l_str_year := ''||substr(p_effective_year,4,1)||'';
3178: l_str_mon := ''||p_effective_month||'';

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

3181: l_str_er_prev_total_d := ''||substr(l_fm_l_prev_total,1,length(l_fm_l_prev_total)-3)||'';
3182: l_str_er_prev_total_f := ''||substr(l_fm_l_prev_total,length(l_fm_l_prev_total)-1)||'';
3183: l_str_er_diff_total_d := ''||substr(l_fm_l_diff_total,1,length(l_fm_l_diff_total)-3)||'';
3184: l_str_er_diff_total_f := ''||substr(l_fm_l_diff_total,length(l_fm_l_diff_total)-1)||'';
3185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
3186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
3187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
3188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_mon), l_str_mon);
3189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_d), l_str_er_cur_total_d);

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

3182: l_str_er_prev_total_f := ''||substr(l_fm_l_prev_total,length(l_fm_l_prev_total)-1)||'';
3183: l_str_er_diff_total_d := ''||substr(l_fm_l_diff_total,1,length(l_fm_l_diff_total)-3)||'';
3184: l_str_er_diff_total_f := ''||substr(l_fm_l_diff_total,length(l_fm_l_diff_total)-1)||'';
3185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
3186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
3187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
3188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_mon), l_str_mon);
3189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_d), l_str_er_cur_total_d);
3190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_f), l_str_er_cur_total_f);

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

3183: l_str_er_diff_total_d := ''||substr(l_fm_l_diff_total,1,length(l_fm_l_diff_total)-3)||'';
3184: l_str_er_diff_total_f := ''||substr(l_fm_l_diff_total,length(l_fm_l_diff_total)-1)||'';
3185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
3186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
3187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
3188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_mon), l_str_mon);
3189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_d), l_str_er_cur_total_d);
3190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_f), l_str_er_cur_total_f);
3191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_d), l_str_er_prev_total_d);

Line 3188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_mon), l_str_mon);

3184: l_str_er_diff_total_f := ''||substr(l_fm_l_diff_total,length(l_fm_l_diff_total)-1)||'';
3185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
3186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
3187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
3188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_mon), l_str_mon);
3189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_d), l_str_er_cur_total_d);
3190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_f), l_str_er_cur_total_f);
3191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_d), l_str_er_prev_total_d);
3192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_f), l_str_er_prev_total_f);

Line 3189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_d), l_str_er_cur_total_d);

3185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
3186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
3187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
3188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_mon), l_str_mon);
3189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_d), l_str_er_cur_total_d);
3190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_f), l_str_er_cur_total_f);
3191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_d), l_str_er_prev_total_d);
3192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_f), l_str_er_prev_total_f);
3193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_d), l_str_er_diff_total_d);

Line 3190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_f), l_str_er_cur_total_f);

3186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_ssn), l_str_er_ssn);
3187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
3188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_mon), l_str_mon);
3189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_d), l_str_er_cur_total_d);
3190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_f), l_str_er_cur_total_f);
3191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_d), l_str_er_prev_total_d);
3192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_f), l_str_er_prev_total_f);
3193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_d), l_str_er_diff_total_d);
3194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_f), l_str_er_diff_total_f);

Line 3191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_d), l_str_er_prev_total_d);

3187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
3188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_mon), l_str_mon);
3189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_d), l_str_er_cur_total_d);
3190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_f), l_str_er_cur_total_f);
3191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_d), l_str_er_prev_total_d);
3192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_f), l_str_er_prev_total_f);
3193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_d), l_str_er_diff_total_d);
3194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_f), l_str_er_diff_total_f);
3195: l_total_total := 0 ;

Line 3192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_f), l_str_er_prev_total_f);

3188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_mon), l_str_mon);
3189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_d), l_str_er_cur_total_d);
3190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_f), l_str_er_cur_total_f);
3191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_d), l_str_er_prev_total_d);
3192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_f), l_str_er_prev_total_f);
3193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_d), l_str_er_diff_total_d);
3194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_f), l_str_er_diff_total_f);
3195: l_total_total := 0 ;
3196: l_total_basic := 0;

Line 3193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_d), l_str_er_diff_total_d);

3189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_d), l_str_er_cur_total_d);
3190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_f), l_str_er_cur_total_f);
3191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_d), l_str_er_prev_total_d);
3192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_f), l_str_er_prev_total_f);
3193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_d), l_str_er_diff_total_d);
3194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_f), l_str_er_diff_total_f);
3195: l_total_total := 0 ;
3196: l_total_basic := 0;
3197: l_total_ha :=0;

Line 3194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_f), l_str_er_diff_total_f);

3190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cur_total_f), l_str_er_cur_total_f);
3191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_d), l_str_er_prev_total_d);
3192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_prev_total_f), l_str_er_prev_total_f);
3193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_d), l_str_er_diff_total_d);
3194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_diff_total_f), l_str_er_diff_total_f);
3195: l_total_total := 0 ;
3196: l_total_basic := 0;
3197: l_total_ha :=0;
3198: L_TOTAL_A1 :=0;

Line 3338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);

3334: l_str_a4d := ''||substr(l_fm_l_allowance_4_val,1,length(l_fm_l_allowance_4_val)-3)||'';
3335: l_str_a4f := ''||substr(l_fm_l_allowance_4_val,length(l_fm_l_allowance_4_val)-1)||'';
3336: l_str_a5d := ''||substr(l_fm_total_val,1,length(l_fm_total_val)-3)||'';
3337: l_str_a5f := ''||substr(l_fm_total_val,length(l_fm_total_val)-1)||'';
3338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3339: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3340: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3342: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);

Line 3339: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);

3335: l_str_a4f := ''||substr(l_fm_l_allowance_4_val,length(l_fm_l_allowance_4_val)-1)||'';
3336: l_str_a5d := ''||substr(l_fm_total_val,1,length(l_fm_total_val)-3)||'';
3337: l_str_a5f := ''||substr(l_fm_total_val,length(l_fm_total_val)-1)||'';
3338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3339: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3340: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3342: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3343: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);

Line 3340: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

3336: l_str_a5d := ''||substr(l_fm_total_val,1,length(l_fm_total_val)-3)||'';
3337: l_str_a5f := ''||substr(l_fm_total_val,length(l_fm_total_val)-1)||'';
3338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3339: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3340: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3342: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3343: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

Line 3341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

3337: l_str_a5f := ''||substr(l_fm_total_val,length(l_fm_total_val)-1)||'';
3338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3339: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3340: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3342: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3343: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3345: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

Line 3342: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);

3338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3339: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3340: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3342: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3343: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3345: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3346: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

Line 3343: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);

3339: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3340: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3342: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3343: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3345: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3346: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

Line 3344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

3340: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3342: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3343: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3345: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3346: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3348: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

Line 3345: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

3341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3342: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3343: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3345: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3346: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3348: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3349: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

Line 3346: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

3342: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3343: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3345: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3346: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3348: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3349: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);

Line 3347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

3343: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3345: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3346: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3348: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3349: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3351: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);

Line 3348: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

3344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3345: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3346: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3348: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3349: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3351: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3352: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);

Line 3349: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

3345: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3346: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3348: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3349: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3351: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3352: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3353: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);

Line 3350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);

3346: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3348: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3349: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3351: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3352: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3353: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3354: L_TOTAL_HA := L_TOTAL_HA + l_accomodation_val;

Line 3351: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);

3347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3348: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3349: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3351: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3352: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3353: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3354: L_TOTAL_HA := L_TOTAL_HA + l_accomodation_val;
3355: L_TOTAL_A1 := L_TOTAL_A1 + l_allowance_1_val;

Line 3352: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);

3348: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3349: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3351: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3352: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3353: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3354: L_TOTAL_HA := L_TOTAL_HA + l_accomodation_val;
3355: L_TOTAL_A1 := L_TOTAL_A1 + l_allowance_1_val;
3356: L_TOTAL_A2 := L_TOTAL_A2 + l_allowance_2_val;

Line 3353: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);

3349: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3351: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3352: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3353: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3354: L_TOTAL_HA := L_TOTAL_HA + l_accomodation_val;
3355: L_TOTAL_A1 := L_TOTAL_A1 + l_allowance_1_val;
3356: L_TOTAL_A2 := L_TOTAL_A2 + l_allowance_2_val;
3357: L_TOTAL_A3 := L_TOTAL_A3 + l_allowance_3_val;

Line 3370: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);

3366:
3367: tp := l_new_count;
3368: WHILE tp <=6 LOOP
3369: l_str_seq_no := ''||' ' ||'';
3370: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3371: tp := tp + 1;
3372: END LOOP;
3373:
3374:

Line 3434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

3430: l_str_a4d := ''||substr(l_fm_l_total_a4,1,length(l_fm_l_total_a4)-3)||'';
3431: l_str_a4f := ''||substr(l_fm_l_total_a4,length(l_fm_l_total_a4)-1)||'';
3432: l_str_a5d := ''||substr(l_fm_l_total_total,1,length(l_fm_l_total_total)-3)||'';
3433: l_str_a5f := ''||substr(l_fm_l_total_total,length(l_fm_l_total_total)-1)||'';
3434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

Line 3435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

3431: l_str_a4f := ''||substr(l_fm_l_total_a4,length(l_fm_l_total_a4)-1)||'';
3432: l_str_a5d := ''||substr(l_fm_l_total_total,1,length(l_fm_l_total_total)-3)||'';
3433: l_str_a5f := ''||substr(l_fm_l_total_total,length(l_fm_l_total_total)-1)||'';
3434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

Line 3436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);

3432: l_str_a5d := ''||substr(l_fm_l_total_total,1,length(l_fm_l_total_total)-3)||'';
3433: l_str_a5f := ''||substr(l_fm_l_total_total,length(l_fm_l_total_total)-1)||'';
3434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

Line 3437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);

3433: l_str_a5f := ''||substr(l_fm_l_total_total,length(l_fm_l_total_total)-1)||'';
3434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

Line 3438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

3434: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

Line 3439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

3435: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3443: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

Line 3440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

3436: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3443: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);

Line 3441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

3437: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3443: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);

Line 3442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

3438: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3443: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3446: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);

Line 3443: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

3439: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3443: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3446: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);

Line 3444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);

3440: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3443: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3446: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3448: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/

Line 3445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);

3441: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3443: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3446: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3448: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3449: END IF;

Line 3446: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);

3442: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3443: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3446: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3448: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3449: END IF;
3450: IF j > i THEN

Line 3447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);

3443: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3446: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3448: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3449: END IF;
3450: IF j > i THEN
3451: l_new_processed := 1;

Line 3448: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/

3444: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3445: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3446: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3447: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3448: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3449: END IF;
3450: IF j > i THEN
3451: l_new_processed := 1;
3452: EXIT;

Line 3513: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

3509: l_str_a4d := ''||substr(l_fm_l_total_a4,1,length(l_fm_l_total_a4)-3)||'';
3510: l_str_a4f := ''||substr(l_fm_l_total_a4,length(l_fm_l_total_a4)-1)||'';
3511: l_str_a5d := ''||substr(l_fm_l_total_total,1,length(l_fm_l_total_total)-3)||'';
3512: l_str_a5f := ''||substr(l_fm_l_total_total,length(l_fm_l_total_total)-1)||'';
3513: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3514: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3515: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3516: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

Line 3514: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

3510: l_str_a4f := ''||substr(l_fm_l_total_a4,length(l_fm_l_total_a4)-1)||'';
3511: l_str_a5d := ''||substr(l_fm_l_total_total,1,length(l_fm_l_total_total)-3)||'';
3512: l_str_a5f := ''||substr(l_fm_l_total_total,length(l_fm_l_total_total)-1)||'';
3513: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3514: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3515: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3516: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

Line 3515: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);

3511: l_str_a5d := ''||substr(l_fm_l_total_total,1,length(l_fm_l_total_total)-3)||'';
3512: l_str_a5f := ''||substr(l_fm_l_total_total,length(l_fm_l_total_total)-1)||'';
3513: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3514: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3515: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3516: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

Line 3516: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);

3512: l_str_a5f := ''||substr(l_fm_l_total_total,length(l_fm_l_total_total)-1)||'';
3513: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3514: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3515: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3516: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

Line 3517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

3513: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3514: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3515: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3516: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

Line 3518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

3514: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3515: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3516: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

Line 3519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

3515: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
3516: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);

Line 3520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

3516: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
3517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);

Line 3521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

3517: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);

Line 3522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

3518: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);

Line 3523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);

3519: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
3520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3527: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/

Line 3524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);

3520: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
3521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3527: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3528: EXIT;

Line 3525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);

3521: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
3522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3527: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3528: EXIT;
3529: END IF;

Line 3526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);

3522: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
3523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3527: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3528: EXIT;
3529: END IF;
3530: END LOOP;

Line 3527: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/

3523: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4d), l_str_a4d);
3524: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a4f), l_str_a4f);
3525: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5d), l_str_a5d);
3526: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a5f), l_str_a5f);
3527: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3528: EXIT;
3529: END IF;
3530: END LOOP;
3531: --Writing data for terminated employees

Line 3568: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);

3564: IF l_new_count <> 5 then
3565: l_str_seq_no := ''||l_tot_term_count||'';
3566: l_str_ee_ssn := ''|| l_insured_ssn ||'';
3567: l_str_ee_name := ''|| substr(l_full_name,1,60) ||'';
3568: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3569: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
3570: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3571: l_str_a1d := ''||substr(l_fm_subject_si_val,1,length(l_fm_subject_si_val)-3)||'';
3572: l_str_a1f := ''||substr(l_fm_subject_si_val,length(l_fm_subject_si_val)-1)||'';

Line 3569: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);

3565: l_str_seq_no := ''||l_tot_term_count||'';
3566: l_str_ee_ssn := ''|| l_insured_ssn ||'';
3567: l_str_ee_name := ''|| substr(l_full_name,1,60) ||'';
3568: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3569: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
3570: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3571: l_str_a1d := ''||substr(l_fm_subject_si_val,1,length(l_fm_subject_si_val)-3)||'';
3572: l_str_a1f := ''||substr(l_fm_subject_si_val,length(l_fm_subject_si_val)-1)||'';
3573: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

Line 3570: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);

3566: l_str_ee_ssn := ''|| l_insured_ssn ||'';
3567: l_str_ee_name := ''|| substr(l_full_name,1,60) ||'';
3568: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3569: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
3570: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3571: l_str_a1d := ''||substr(l_fm_subject_si_val,1,length(l_fm_subject_si_val)-3)||'';
3572: l_str_a1f := ''||substr(l_fm_subject_si_val,length(l_fm_subject_si_val)-1)||'';
3573: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3574: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

Line 3573: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

3569: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
3570: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3571: l_str_a1d := ''||substr(l_fm_subject_si_val,1,length(l_fm_subject_si_val)-3)||'';
3572: l_str_a1f := ''||substr(l_fm_subject_si_val,length(l_fm_subject_si_val)-1)||'';
3573: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3574: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3575: l_total_term := l_total_term + l_subject_si_val;
3576: END If;
3577: If l_new_count <> 5 then

Line 3574: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

3570: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3571: l_str_a1d := ''||substr(l_fm_subject_si_val,1,length(l_fm_subject_si_val)-3)||'';
3572: l_str_a1f := ''||substr(l_fm_subject_si_val,length(l_fm_subject_si_val)-1)||'';
3573: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3574: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3575: l_total_term := l_total_term + l_subject_si_val;
3576: END If;
3577: If l_new_count <> 5 then
3578: l:= l + 1;

Line 3585: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);

3581:
3582: tp := l_new_count;
3583: WHILE tp <= 5 LOOP
3584: l_str_seq_no := ''||' '||'';
3585: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3586: tp := tp + 1;
3587: END LOOP;
3588:
3589:

Line 3604: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

3600: END;
3601:
3602: l_str_bsd := ''||substr(l_fm_l_total_term,1,length(l_fm_l_total_term)-3)||'';
3603: l_str_bsf := ''||substr(l_fm_l_total_term,length(l_fm_l_total_term)-1)||'';
3604: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3605: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3606: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3607: End If;
3608: IF l > k THEN

Line 3605: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

3601:
3602: l_str_bsd := ''||substr(l_fm_l_total_term,1,length(l_fm_l_total_term)-3)||'';
3603: l_str_bsf := ''||substr(l_fm_l_total_term,length(l_fm_l_total_term)-1)||'';
3604: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3605: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3606: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3607: End If;
3608: IF l > k THEN
3609: l_ter_processed := 1;

Line 3606: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/

3602: l_str_bsd := ''||substr(l_fm_l_total_term,1,length(l_fm_l_total_term)-3)||'';
3603: l_str_bsf := ''||substr(l_fm_l_total_term,length(l_fm_l_total_term)-1)||'';
3604: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3605: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3606: /************** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3607: End If;
3608: IF l > k THEN
3609: l_ter_processed := 1;
3610: EXIT;

Line 3627: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

3623: END;
3624:
3625: l_str_bsd := ''||substr(l_fm_l_total_term,1,length(l_fm_l_total_term)-3)||'';
3626: l_str_bsf := ''||substr(l_fm_l_total_term,length(l_fm_l_total_term)-1)||'';
3627: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3628: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3629: /*********** dbms_lob.writeAppend( l_xfdf_string, length(''),''); ************/
3630: EXIT;
3631: END IF;

Line 3628: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

3624:
3625: l_str_bsd := ''||substr(l_fm_l_total_term,1,length(l_fm_l_total_term)-3)||'';
3626: l_str_bsf := ''||substr(l_fm_l_total_term,length(l_fm_l_total_term)-1)||'';
3627: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3628: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3629: /*********** dbms_lob.writeAppend( l_xfdf_string, length(''),''); ************/
3630: EXIT;
3631: END IF;
3632: END LOOP;

Line 3629: /*********** dbms_lob.writeAppend( l_xfdf_string, length(''),''); ************/

3625: l_str_bsd := ''||substr(l_fm_l_total_term,1,length(l_fm_l_total_term)-3)||'';
3626: l_str_bsf := ''||substr(l_fm_l_total_term,length(l_fm_l_total_term)-1)||'';
3627: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3628: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3629: /*********** dbms_lob.writeAppend( l_xfdf_string, length(''),''); ************/
3630: EXIT;
3631: END IF;
3632: END LOOP;
3633: --Writing data for employees with changed salary

Line 3669: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);

3665: IF l_new_count <> 5 then
3666: l_str_seq_no := ''||l_tot_change_count||'';
3667: l_str_ee_ssn := ''|| l_insured_ssn ||'';
3668: l_str_ee_name := ''|| substr(l_full_name,1,60) ||'';
3669: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3670: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
3671: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3672: l_str_a1d := ''||substr(l_fm_changed_salary,1,length(l_fm_changed_salary)-3)||'';
3673: l_str_a1f := ''||substr(l_fm_changed_salary,length(l_fm_changed_salary)-1)||'';

Line 3670: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);

3666: l_str_seq_no := ''||l_tot_change_count||'';
3667: l_str_ee_ssn := ''|| l_insured_ssn ||'';
3668: l_str_ee_name := ''|| substr(l_full_name,1,60) ||'';
3669: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3670: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
3671: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3672: l_str_a1d := ''||substr(l_fm_changed_salary,1,length(l_fm_changed_salary)-3)||'';
3673: l_str_a1f := ''||substr(l_fm_changed_salary,length(l_fm_changed_salary)-1)||'';
3674: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

Line 3671: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);

3667: l_str_ee_ssn := ''|| l_insured_ssn ||'';
3668: l_str_ee_name := ''|| substr(l_full_name,1,60) ||'';
3669: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3670: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
3671: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3672: l_str_a1d := ''||substr(l_fm_changed_salary,1,length(l_fm_changed_salary)-3)||'';
3673: l_str_a1f := ''||substr(l_fm_changed_salary,length(l_fm_changed_salary)-1)||'';
3674: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3675: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

Line 3674: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

3670: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
3671: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3672: l_str_a1d := ''||substr(l_fm_changed_salary,1,length(l_fm_changed_salary)-3)||'';
3673: l_str_a1f := ''||substr(l_fm_changed_salary,length(l_fm_changed_salary)-1)||'';
3674: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3675: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3676: l_total_change := l_total_change + l_subject_si_val;
3677: END If;
3678: If l_new_count <> 5 then

Line 3675: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

3671: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
3672: l_str_a1d := ''||substr(l_fm_changed_salary,1,length(l_fm_changed_salary)-3)||'';
3673: l_str_a1f := ''||substr(l_fm_changed_salary,length(l_fm_changed_salary)-1)||'';
3674: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
3675: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
3676: l_total_change := l_total_change + l_subject_si_val;
3677: END If;
3678: If l_new_count <> 5 then
3679: n := n + 1;

Line 3686: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);

3682:
3683: tp := l_new_count;
3684: WHILE tp <= 5 LOOP
3685: l_str_seq_no := ''||' '||'';
3686: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
3687: tp := tp + 1;
3688: END LOOP;
3689:
3690:

Line 3705: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

3701: END;
3702:
3703: l_str_bsd := ''||substr(l_fm_l_total_change,1,length(l_fm_l_total_change)-3)||'';
3704: l_str_bsf := ''||substr(l_fm_l_total_change,length(l_fm_l_total_change)-1)||'';
3705: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3706: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3707: /************* dbms_lob.writeAppend( l_xfdf_string, length(''),''); ***********/
3708: End If;
3709: IF n > m THEN

Line 3706: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

3702:
3703: l_str_bsd := ''||substr(l_fm_l_total_change,1,length(l_fm_l_total_change)-3)||'';
3704: l_str_bsf := ''||substr(l_fm_l_total_change,length(l_fm_l_total_change)-1)||'';
3705: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3706: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3707: /************* dbms_lob.writeAppend( l_xfdf_string, length(''),''); ***********/
3708: End If;
3709: IF n > m THEN
3710: l_cha_processed := 1;

Line 3707: /************* dbms_lob.writeAppend( l_xfdf_string, length(''),''); ***********/

3703: l_str_bsd := ''||substr(l_fm_l_total_change,1,length(l_fm_l_total_change)-3)||'';
3704: l_str_bsf := ''||substr(l_fm_l_total_change,length(l_fm_l_total_change)-1)||'';
3705: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3706: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3707: /************* dbms_lob.writeAppend( l_xfdf_string, length(''),''); ***********/
3708: End If;
3709: IF n > m THEN
3710: l_cha_processed := 1;
3711: EXIT;

Line 3728: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

3724: END;
3725:
3726: l_str_bsd := ''||substr(l_fm_l_total_change,1,length(l_fm_l_total_change)-3)||'';
3727: l_str_bsf := ''||substr(l_fm_l_total_change,1,length(l_fm_l_total_change)-3)||'';
3728: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3729: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3730: /*********** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3731: EXIT;
3732: END IF;

Line 3729: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

3725:
3726: l_str_bsd := ''||substr(l_fm_l_total_change,1,length(l_fm_l_total_change)-3)||'';
3727: l_str_bsf := ''||substr(l_fm_l_total_change,1,length(l_fm_l_total_change)-3)||'';
3728: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3729: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3730: /*********** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3731: EXIT;
3732: END IF;
3733: END LOOP;

Line 3730: /*********** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/

3726: l_str_bsd := ''||substr(l_fm_l_total_change,1,length(l_fm_l_total_change)-3)||'';
3727: l_str_bsf := ''||substr(l_fm_l_total_change,1,length(l_fm_l_total_change)-3)||'';
3728: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
3729: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
3730: /*********** dbms_lob.writeAppend( l_xfdf_string, length(''),''); **********/
3731: EXIT;
3732: END IF;
3733: END LOOP;
3734:

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

3734:
3735: IF l_ter_processed = 1 AND l_new_processed = 1 AND l_cha_processed = 1 THEN
3736: l_all_processed := 1;
3737: END IF;
3738: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
3739: END LOOP;
3740:
3741: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
3742: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);

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

3737: END IF;
3738: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
3739: END LOOP;
3740:
3741: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
3742: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
3743: clob_to_blob(l_xfdf_string,l_xfdf_blob);
3744:
3745: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);

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

3738: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
3739: END LOOP;
3740:
3741: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
3742: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
3743: clob_to_blob(l_xfdf_string,l_xfdf_blob);
3744:
3745: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
3746: EXCEPTION

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

3993: OPEN csr_employer_name;
3994: FETCH csr_employer_name INTO l_employer_name;
3995: CLOSE csr_employer_name;
3996:
3997: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
3998: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
3999: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
4000: clob_to_blob(l_xfdf_string,l_xfdf_blob);
4001: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

3994: FETCH csr_employer_name INTO l_employer_name;
3995: CLOSE csr_employer_name;
3996:
3997: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
3998: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
3999: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
4000: clob_to_blob(l_xfdf_string,l_xfdf_blob);
4001: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4002:

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

3995: CLOSE csr_employer_name;
3996:
3997: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
3998: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
3999: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
4000: clob_to_blob(l_xfdf_string,l_xfdf_blob);
4001: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4002:
4003: OPEN csr_get_def_bal_ids (p_employer_id);

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

3997: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
3998: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
3999: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
4000: clob_to_blob(l_xfdf_string,l_xfdf_blob);
4001: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4002:
4003: OPEN csr_get_def_bal_ids (p_employer_id);
4004: FETCH csr_get_def_bal_ids into l_basic_sal_id,l_accomodation_id,l_social_id,l_child_social_id,l_cost_of_living_id,l_ol1_id,l_tp_id,l_ol2_id,l_ol3_id,l_ol4_id;
4005: CLOSE csr_get_def_bal_ids;

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

4126: WHILE l_all_processed <> 1 LOOP
4127: --Writing data for new employees
4128: l_new_count := 0;
4129: l := 0;
4130: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4131: WHILE j <= i LOOP
4132: /**** RESET ALL THE VARIABLES *****/
4133: l_basic_val := 0;
4134: l_accomodation_val := 0;

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

4259:
4260: l_str_er_name := ''||l_employer_name||'';
4261: l_str_year := ''||p_effective_year||'';
4262: l_str_month := ''||p_effective_month||'';
4263: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
4264: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
4265: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
4266: l := l + 1;
4267:

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

4260: l_str_er_name := ''||l_employer_name||'';
4261: l_str_year := ''||p_effective_year||'';
4262: l_str_month := ''||p_effective_month||'';
4263: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
4264: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
4265: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
4266: l := l + 1;
4267:
4268: If l <> 11 then

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

4261: l_str_year := ''||p_effective_year||'';
4262: l_str_month := ''||p_effective_month||'';
4263: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
4264: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
4265: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
4266: l := l + 1;
4267:
4268: If l <> 11 then
4269: l_tot_count := l_tot_count + 1;

Line 4292: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);

4288: l_str_ercd := ''||substr(l_fm_er_contribution,1,length(l_fm_er_contribution)-3)||'';
4289: l_str_ercf := ''||substr(l_fm_er_contribution,length(l_fm_er_contribution)-1)||'';
4290: l_str_tcd := ''||substr(l_fm_total_contribution,1,length(l_fm_total_contribution)-3)||'';
4291: l_str_tcf := ''||substr(l_fm_total_contribution,length(l_fm_total_contribution)-1)||'';
4292: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
4293: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
4294: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
4295: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
4296: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

Line 4293: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);

4289: l_str_ercf := ''||substr(l_fm_er_contribution,length(l_fm_er_contribution)-1)||'';
4290: l_str_tcd := ''||substr(l_fm_total_contribution,1,length(l_fm_total_contribution)-3)||'';
4291: l_str_tcf := ''||substr(l_fm_total_contribution,length(l_fm_total_contribution)-1)||'';
4292: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
4293: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
4294: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
4295: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
4296: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4297: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

Line 4294: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);

4290: l_str_tcd := ''||substr(l_fm_total_contribution,1,length(l_fm_total_contribution)-3)||'';
4291: l_str_tcf := ''||substr(l_fm_total_contribution,length(l_fm_total_contribution)-1)||'';
4292: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
4293: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
4294: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
4295: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
4296: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4297: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4298: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);

Line 4295: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);

4291: l_str_tcf := ''||substr(l_fm_total_contribution,length(l_fm_total_contribution)-1)||'';
4292: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
4293: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
4294: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
4295: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
4296: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4297: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4298: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4299: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);

Line 4296: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

4292: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
4293: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
4294: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
4295: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
4296: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4297: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4298: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4299: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4300: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

Line 4297: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

4293: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
4294: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
4295: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
4296: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4297: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4298: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4299: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4300: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4301: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

Line 4298: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);

4294: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
4295: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
4296: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4297: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4298: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4299: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4300: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4301: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4302: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

Line 4299: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);

4295: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
4296: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4297: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4298: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4299: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4300: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4301: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4302: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4303: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

Line 4300: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

4296: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4297: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4298: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4299: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4300: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4301: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4302: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4303: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4304: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

Line 4301: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

4297: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4298: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4299: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4300: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4301: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4302: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4303: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4304: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4305: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

Line 4302: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

4298: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4299: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4300: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4301: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4302: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4303: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4304: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4305: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4306: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);

Line 4303: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

4299: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4300: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4301: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4302: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4303: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4304: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4305: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4306: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4307: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);

Line 4304: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

4300: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4301: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4302: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4303: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4304: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4305: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4306: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4307: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4308: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);

Line 4305: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

4301: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4302: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4303: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4304: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4305: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4306: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4307: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4308: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4309: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);

Line 4306: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);

4302: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4303: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4304: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4305: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4306: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4307: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4308: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4309: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4310: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);

Line 4307: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);

4303: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4304: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4305: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4306: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4307: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4308: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4309: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4310: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4311: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);

Line 4308: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);

4304: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4305: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4306: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4307: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4308: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4309: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4310: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4311: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4312: l_total_basic := l_total_basic + l_basic_val;

Line 4309: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);

4305: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4306: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4307: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4308: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4309: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4310: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4311: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4312: l_total_basic := l_total_basic + l_basic_val;
4313: l_total_aa := l_total_aa + l_accomodation_val;

Line 4310: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);

4306: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4307: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4308: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4309: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4310: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4311: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4312: l_total_basic := l_total_basic + l_basic_val;
4313: l_total_aa := l_total_aa + l_accomodation_val;
4314: l_total_a1 := l_total_a1 + l_allowance_1_val;

Line 4311: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);

4307: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4308: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4309: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4310: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4311: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4312: l_total_basic := l_total_basic + l_basic_val;
4313: l_total_aa := l_total_aa + l_accomodation_val;
4314: l_total_a1 := l_total_a1 + l_allowance_1_val;
4315: l_total_a2 := l_total_a2 + l_allowance_2_val;

Line 4385: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

4381: l_str_ercd := ''||substr(l_fm_total_er,1,length(l_fm_total_er)-3)||'';
4382: l_str_ercf := ''||substr(l_fm_total_er,length(l_fm_total_er)-1)||'';
4383: l_str_tcd := ''||substr(l_fm_total_total,1,length(l_fm_total_total)-3)||'';
4384: l_str_tcf := ''||substr(l_fm_total_total,length(l_fm_total_total)-1)||'';
4385: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

Line 4386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

4382: l_str_ercf := ''||substr(l_fm_total_er,length(l_fm_total_er)-1)||'';
4383: l_str_tcd := ''||substr(l_fm_total_total,1,length(l_fm_total_total)-3)||'';
4384: l_str_tcf := ''||substr(l_fm_total_total,length(l_fm_total_total)-1)||'';
4385: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

Line 4387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);

4383: l_str_tcd := ''||substr(l_fm_total_total,1,length(l_fm_total_total)-3)||'';
4384: l_str_tcf := ''||substr(l_fm_total_total,length(l_fm_total_total)-1)||'';
4385: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

Line 4388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);

4384: l_str_tcf := ''||substr(l_fm_total_total,length(l_fm_total_total)-1)||'';
4385: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

Line 4389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

4385: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

Line 4390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

4386: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

Line 4391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

4387: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);

Line 4392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

4388: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4396: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);

Line 4393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

4389: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4396: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);

Line 4394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

4390: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4396: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);

Line 4395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);

4391: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4396: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);

Line 4396: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);

4392: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4396: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);

Line 4397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);

4393: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4396: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4401: End If;

Line 4398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);

4394: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4396: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4401: End If;
4402: If l <> 11 then

Line 4399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);

4395: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4396: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4401: End If;
4402: If l <> 11 then
4403: j := j + 1;

Line 4400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);

4396: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4397: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4398: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4399: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4400: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4401: End If;
4402: If l <> 11 then
4403: j := j + 1;
4404: End if;

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

4405: IF j > i THEN
4406: l_new_processed := 1;
4407: END IF;
4408: IF l = 11/*8*/ THEN
4409: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4410: l_total_basic := 0 ;
4411: l_total_aa := 0 ;
4412: l_total_a1 := 0 ;
4413: l_total_a2 := 0 ;

Line 4489: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

4485: l_str_ercd := ''||substr(l_fm_total_er,1,length(l_fm_total_er)-3)||'';
4486: l_str_ercf := ''||substr(l_fm_total_er,length(l_fm_total_er)-1)||'';
4487: l_str_tcd := ''||substr(l_fm_total_total,1,length(l_fm_total_total)-3)||'';
4488: l_str_tcf := ''||substr(l_fm_total_total,length(l_fm_total_total)-1)||'';
4489: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4491: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4492: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4493: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

Line 4490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

4486: l_str_ercf := ''||substr(l_fm_total_er,length(l_fm_total_er)-1)||'';
4487: l_str_tcd := ''||substr(l_fm_total_total,1,length(l_fm_total_total)-3)||'';
4488: l_str_tcf := ''||substr(l_fm_total_total,length(l_fm_total_total)-1)||'';
4489: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4491: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4492: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4493: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4494: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

Line 4491: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);

4487: l_str_tcd := ''||substr(l_fm_total_total,1,length(l_fm_total_total)-3)||'';
4488: l_str_tcf := ''||substr(l_fm_total_total,length(l_fm_total_total)-1)||'';
4489: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4491: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4492: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4493: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4494: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4495: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

Line 4492: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);

4488: l_str_tcf := ''||substr(l_fm_total_total,length(l_fm_total_total)-1)||'';
4489: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4491: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4492: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4493: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4494: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4495: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4496: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

Line 4493: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);

4489: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
4490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4491: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4492: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4493: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4494: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4495: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4496: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4497: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

Line 4494: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);

4490: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
4491: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4492: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4493: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4494: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4495: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4496: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4497: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4498: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

Line 4495: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);

4491: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aad), l_str_aad);
4492: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4493: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4494: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4495: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4496: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4497: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4498: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4499: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);

Line 4496: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);

4492: dbms_lob.writeAppend( l_xfdf_string, length(l_str_aaf), l_str_aaf);
4493: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4494: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4495: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4496: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4497: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4498: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4499: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4500: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);

Line 4497: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);

4493: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1d), l_str_a1d);
4494: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4495: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4496: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4497: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4498: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4499: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4500: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4501: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);

Line 4498: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);

4494: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a1f), l_str_a1f);
4495: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4496: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4497: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4498: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4499: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4500: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4501: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4502: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);

Line 4499: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);

4495: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2d), l_str_a2d);
4496: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4497: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4498: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4499: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4500: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4501: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4502: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4503: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);

Line 4500: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);

4496: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a2f), l_str_a2f);
4497: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4498: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4499: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4500: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4501: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4502: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4503: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4504: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);

Line 4501: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);

4497: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3d), l_str_a3d);
4498: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4499: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4500: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4501: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4502: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4503: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4504: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4505: end if;

Line 4502: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);

4498: dbms_lob.writeAppend( l_xfdf_string, length(l_str_a3f), l_str_a3f);
4499: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4500: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4501: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4502: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4503: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4504: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4505: end if;
4506: If l <> 11 then

Line 4503: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);

4499: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecd), l_str_eecd);
4500: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4501: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4502: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4503: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4504: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4505: end if;
4506: If l <> 11 then
4507: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 4504: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);

4500: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eecf), l_str_eecf);
4501: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercd), l_str_ercd);
4502: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ercf), l_str_ercf);
4503: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4504: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4505: end if;
4506: If l <> 11 then
4507: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4508: End If;

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

4503: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcd), l_str_tcd);
4504: dbms_lob.writeAppend( l_xfdf_string, length(l_str_tcf), l_str_tcf);
4505: end if;
4506: If l <> 11 then
4507: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4508: End If;
4509: EXIT;
4510: END IF;
4511: END LOOP;

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

4508: End If;
4509: EXIT;
4510: END IF;
4511: END LOOP;
4512: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4513: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
4514: clob_to_blob(l_xfdf_string,l_xfdf_blob);
4515: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
4516: /*EXCEPTION

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

4509: EXIT;
4510: END IF;
4511: END LOOP;
4512: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4513: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
4514: clob_to_blob(l_xfdf_string,l_xfdf_blob);
4515: hr_utility.set_location('Finished creating xml data for Procedure FORM6 ',20);
4516: /*EXCEPTION
4517: WHEN utl_file.invalid_path then

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

4774: OPEN csr_employer_name;
4775: FETCH csr_employer_name INTO l_employer_name;
4776: CLOSE csr_employer_name;
4777:
4778: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
4779: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
4780: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
4781: clob_to_blob(l_xfdf_string,l_xfdf_blob);
4782: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

4775: FETCH csr_employer_name INTO l_employer_name;
4776: CLOSE csr_employer_name;
4777:
4778: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
4779: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
4780: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
4781: clob_to_blob(l_xfdf_string,l_xfdf_blob);
4782: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4783:

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

4776: CLOSE csr_employer_name;
4777:
4778: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
4779: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
4780: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
4781: clob_to_blob(l_xfdf_string,l_xfdf_blob);
4782: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4783:
4784: /* Fetch Defined Balance IDs from EIT */

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

4778: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
4779: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
4780: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
4781: clob_to_blob(l_xfdf_string,l_xfdf_blob);
4782: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4783:
4784: /* Fetch Defined Balance IDs from EIT */
4785: OPEN csr_get_def_bal_ids (p_employer_id);
4786: FETCH csr_get_def_bal_ids into l_basic_sal_id,l_accommodation_id,l_social_id,l_child_social_id,l_cost_of_living_id,l_ol1_id,l_tp_id,l_ol2_id,l_ol3_id,l_ol4_id;

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

4821: l := 1;
4822: WHILE l_all_processed <> 1 LOOP
4823: --Writing data for new employees
4824: l_new_count := 0;
4825: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
4826: WHILE j <= i LOOP
4827: /**** RESET ALL THE VARIABLES *****/
4828: l_basic_val := 0;
4829: l_cost_of_living_val := 0;

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

4981:
4982: l_str_er_name := ''||l_employer_name||'';
4983: l_str_year := ''||p_effective_year||'';
4984: l_str_month := '' || p_effective_month || '';
4985: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
4986: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
4987: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
4988:
4989: /* Write into allowances columns and Employee Details columns */

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

4982: l_str_er_name := ''||l_employer_name||'';
4983: l_str_year := ''||p_effective_year||'';
4984: l_str_month := '' || p_effective_month || '';
4985: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
4986: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
4987: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
4988:
4989: /* Write into allowances columns and Employee Details columns */
4990: l_str_seq_no := ''||l||'';

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

4983: l_str_year := ''||p_effective_year||'';
4984: l_str_month := '' || p_effective_month || '';
4985: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name), l_str_er_name);
4986: dbms_lob.writeAppend( l_xfdf_string, length(l_str_year), l_str_year);
4987: dbms_lob.writeAppend( l_xfdf_string, length(l_str_month), l_str_month);
4988:
4989: /* Write into allowances columns and Employee Details columns */
4990: l_str_seq_no := ''||l||'';
4991: l_str_ee_ssn := ''||l_emp_ssn ||'';

Line 5013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);

5009: l_str_er_cont_f_total := '' ||substr(l_fm_er_cont_total,length(l_fm_er_cont_total)-1)||'';
5010: l_str_er_cont_d_total := ''||substr(l_fm_er_cont_total,1,length(l_fm_er_cont_total)-3)||'';
5011: l_str_total_cont_f := '' ||substr(l_fm_total_cont,length(l_fm_total_cont)-1)||'';
5012: l_str_total_cont_d := ''||substr(l_fm_total_cont,1,length(l_fm_total_cont)-3)||'';
5013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
5014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
5015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
5016: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
5017: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

Line 5014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);

5010: l_str_er_cont_d_total := ''||substr(l_fm_er_cont_total,1,length(l_fm_er_cont_total)-3)||'';
5011: l_str_total_cont_f := '' ||substr(l_fm_total_cont,length(l_fm_total_cont)-1)||'';
5012: l_str_total_cont_d := ''||substr(l_fm_total_cont,1,length(l_fm_total_cont)-3)||'';
5013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
5014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
5015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
5016: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
5017: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
5018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

Line 5015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);

5011: l_str_total_cont_f := '' ||substr(l_fm_total_cont,length(l_fm_total_cont)-1)||'';
5012: l_str_total_cont_d := ''||substr(l_fm_total_cont,1,length(l_fm_total_cont)-3)||'';
5013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
5014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
5015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
5016: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
5017: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
5018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
5019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold), l_str_cold);

Line 5016: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);

5012: l_str_total_cont_d := ''||substr(l_fm_total_cont,1,length(l_fm_total_cont)-3)||'';
5013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
5014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
5015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
5016: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
5017: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
5018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
5019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold), l_str_cold);
5020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf), l_str_colf);

Line 5017: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);

5013: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq_no), l_str_seq_no);
5014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
5015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
5016: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
5017: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
5018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
5019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold), l_str_cold);
5020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf), l_str_colf);
5021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd), l_str_socd);

Line 5018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);

5014: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_ssn), l_str_ee_ssn);
5015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
5016: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
5017: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
5018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
5019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold), l_str_cold);
5020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf), l_str_colf);
5021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd), l_str_socd);
5022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf), l_str_socf);

Line 5019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold), l_str_cold);

5015: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_eno), l_str_ee_eno);
5016: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
5017: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
5018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
5019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold), l_str_cold);
5020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf), l_str_colf);
5021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd), l_str_socd);
5022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf), l_str_socf);
5023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd), l_str_chd);

Line 5020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf), l_str_colf);

5016: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_name), l_str_ee_name);
5017: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
5018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
5019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold), l_str_cold);
5020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf), l_str_colf);
5021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd), l_str_socd);
5022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf), l_str_socf);
5023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd), l_str_chd);
5024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf), l_str_chf);

Line 5021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd), l_str_socd);

5017: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsd), l_str_bsd);
5018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
5019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold), l_str_cold);
5020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf), l_str_colf);
5021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd), l_str_socd);
5022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf), l_str_socf);
5023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd), l_str_chd);
5024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf), l_str_chf);
5025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd), l_str_accd);

Line 5022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf), l_str_socf);

5018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bsf), l_str_bsf);
5019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold), l_str_cold);
5020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf), l_str_colf);
5021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd), l_str_socd);
5022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf), l_str_socf);
5023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd), l_str_chd);
5024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf), l_str_chf);
5025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd), l_str_accd);
5026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf), l_str_accf);

Line 5023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd), l_str_chd);

5019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold), l_str_cold);
5020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf), l_str_colf);
5021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd), l_str_socd);
5022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf), l_str_socf);
5023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd), l_str_chd);
5024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf), l_str_chf);
5025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd), l_str_accd);
5026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf), l_str_accf);
5027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_dinars), l_str_total_dinars);

Line 5024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf), l_str_chf);

5020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf), l_str_colf);
5021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd), l_str_socd);
5022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf), l_str_socf);
5023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd), l_str_chd);
5024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf), l_str_chf);
5025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd), l_str_accd);
5026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf), l_str_accf);
5027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_dinars), l_str_total_dinars);
5028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_fills), l_str_total_fills);

Line 5025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd), l_str_accd);

5021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd), l_str_socd);
5022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf), l_str_socf);
5023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd), l_str_chd);
5024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf), l_str_chf);
5025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd), l_str_accd);
5026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf), l_str_accf);
5027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_dinars), l_str_total_dinars);
5028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_fills), l_str_total_fills);
5029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_f_total), l_str_ee_cont_f_total);

Line 5026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf), l_str_accf);

5022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf), l_str_socf);
5023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd), l_str_chd);
5024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf), l_str_chf);
5025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd), l_str_accd);
5026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf), l_str_accf);
5027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_dinars), l_str_total_dinars);
5028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_fills), l_str_total_fills);
5029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_f_total), l_str_ee_cont_f_total);
5030: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_d_total), l_str_ee_cont_d_total);

Line 5027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_dinars), l_str_total_dinars);

5023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd), l_str_chd);
5024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf), l_str_chf);
5025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd), l_str_accd);
5026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf), l_str_accf);
5027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_dinars), l_str_total_dinars);
5028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_fills), l_str_total_fills);
5029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_f_total), l_str_ee_cont_f_total);
5030: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_d_total), l_str_ee_cont_d_total);
5031: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_f_total), l_str_er_cont_f_total);

Line 5028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_fills), l_str_total_fills);

5024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf), l_str_chf);
5025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd), l_str_accd);
5026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf), l_str_accf);
5027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_dinars), l_str_total_dinars);
5028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_fills), l_str_total_fills);
5029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_f_total), l_str_ee_cont_f_total);
5030: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_d_total), l_str_ee_cont_d_total);
5031: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_f_total), l_str_er_cont_f_total);
5032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_d_total), l_str_er_cont_d_total);

Line 5029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_f_total), l_str_ee_cont_f_total);

5025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd), l_str_accd);
5026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf), l_str_accf);
5027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_dinars), l_str_total_dinars);
5028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_fills), l_str_total_fills);
5029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_f_total), l_str_ee_cont_f_total);
5030: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_d_total), l_str_ee_cont_d_total);
5031: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_f_total), l_str_er_cont_f_total);
5032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_d_total), l_str_er_cont_d_total);
5033: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f), l_str_total_cont_f);

Line 5030: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_d_total), l_str_ee_cont_d_total);

5026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf), l_str_accf);
5027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_dinars), l_str_total_dinars);
5028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_fills), l_str_total_fills);
5029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_f_total), l_str_ee_cont_f_total);
5030: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_d_total), l_str_ee_cont_d_total);
5031: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_f_total), l_str_er_cont_f_total);
5032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_d_total), l_str_er_cont_d_total);
5033: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f), l_str_total_cont_f);
5034: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d), l_str_total_cont_d);

Line 5031: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_f_total), l_str_er_cont_f_total);

5027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_dinars), l_str_total_dinars);
5028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_fills), l_str_total_fills);
5029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_f_total), l_str_ee_cont_f_total);
5030: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_d_total), l_str_ee_cont_d_total);
5031: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_f_total), l_str_er_cont_f_total);
5032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_d_total), l_str_er_cont_d_total);
5033: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f), l_str_total_cont_f);
5034: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d), l_str_total_cont_d);
5035: /* Calculate the total values of allowances for each row */

Line 5032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_d_total), l_str_er_cont_d_total);

5028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_fills), l_str_total_fills);
5029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_f_total), l_str_ee_cont_f_total);
5030: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_d_total), l_str_ee_cont_d_total);
5031: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_f_total), l_str_er_cont_f_total);
5032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_d_total), l_str_er_cont_d_total);
5033: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f), l_str_total_cont_f);
5034: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d), l_str_total_cont_d);
5035: /* Calculate the total values of allowances for each row */
5036: l_basic_total := l_basic_total + l_basic_val;

Line 5033: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f), l_str_total_cont_f);

5029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_f_total), l_str_ee_cont_f_total);
5030: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_d_total), l_str_ee_cont_d_total);
5031: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_f_total), l_str_er_cont_f_total);
5032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_d_total), l_str_er_cont_d_total);
5033: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f), l_str_total_cont_f);
5034: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d), l_str_total_cont_d);
5035: /* Calculate the total values of allowances for each row */
5036: l_basic_total := l_basic_total + l_basic_val;
5037: l_col_total := l_col_total + l_cost_of_living_val;

Line 5034: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d), l_str_total_cont_d);

5030: dbms_lob.writeAppend( l_xfdf_string, length(l_str_ee_cont_d_total), l_str_ee_cont_d_total);
5031: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_f_total), l_str_er_cont_f_total);
5032: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_cont_d_total), l_str_er_cont_d_total);
5033: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f), l_str_total_cont_f);
5034: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d), l_str_total_cont_d);
5035: /* Calculate the total values of allowances for each row */
5036: l_basic_total := l_basic_total + l_basic_val;
5037: l_col_total := l_col_total + l_cost_of_living_val;
5038: l_social_total := l_social_total + l_social_allow_val;

Line 5125: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bf_total), l_str_bf_total);

5121: l_str_total_er_cont_f_total := '' ||substr(l_fm_total_er_cont_total,length(l_fm_total_er_cont_total)-1)||'';
5122: l_str_total_er_cont_d_total := ''||substr(l_fm_total_er_cont_total,1,length(l_fm_total_er_cont_total)-3)||'';
5123: l_str_total_cont_f_total := '' ||substr(l_fm_total_cont_total,length(l_fm_total_cont_total)-1)||'';
5124: l_str_total_cont_d_total := ''||substr(l_fm_total_cont_total,1,length(l_fm_total_cont_total)-3)||'';
5125: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bf_total), l_str_bf_total);
5126: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);
5127: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5128: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5129: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);

Line 5126: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);

5122: l_str_total_er_cont_d_total := ''||substr(l_fm_total_er_cont_total,1,length(l_fm_total_er_cont_total)-3)||'';
5123: l_str_total_cont_f_total := '' ||substr(l_fm_total_cont_total,length(l_fm_total_cont_total)-1)||'';
5124: l_str_total_cont_d_total := ''||substr(l_fm_total_cont_total,1,length(l_fm_total_cont_total)-3)||'';
5125: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bf_total), l_str_bf_total);
5126: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);
5127: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5128: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5129: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5130: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);

Line 5127: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);

5123: l_str_total_cont_f_total := '' ||substr(l_fm_total_cont_total,length(l_fm_total_cont_total)-1)||'';
5124: l_str_total_cont_d_total := ''||substr(l_fm_total_cont_total,1,length(l_fm_total_cont_total)-3)||'';
5125: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bf_total), l_str_bf_total);
5126: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);
5127: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5128: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5129: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5130: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5131: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);

Line 5128: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);

5124: l_str_total_cont_d_total := ''||substr(l_fm_total_cont_total,1,length(l_fm_total_cont_total)-3)||'';
5125: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bf_total), l_str_bf_total);
5126: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);
5127: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5128: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5129: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5130: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5131: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5132: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);

Line 5129: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);

5125: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bf_total), l_str_bf_total);
5126: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);
5127: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5128: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5129: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5130: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5131: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5132: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5133: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);

Line 5130: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);

5126: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);
5127: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5128: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5129: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5130: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5131: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5132: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5133: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5134: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);

Line 5131: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);

5127: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5128: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5129: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5130: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5131: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5132: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5133: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5134: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5135: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);

Line 5132: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);

5128: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5129: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5130: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5131: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5132: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5133: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5134: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5135: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5136: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);

Line 5133: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);

5129: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5130: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5131: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5132: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5133: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5134: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5135: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5136: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5137: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);

Line 5134: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);

5130: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5131: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5132: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5133: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5134: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5135: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5136: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5137: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5138: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);

Line 5135: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);

5131: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5132: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5133: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5134: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5135: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5136: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5137: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5138: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5139: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);

Line 5136: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);

5132: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5133: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5134: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5135: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5136: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5137: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5138: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5139: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5140: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);

Line 5137: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);

5133: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5134: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5135: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5136: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5137: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5138: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5139: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5140: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5141: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);

Line 5138: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);

5134: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5135: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5136: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5137: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5138: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5139: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5140: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5141: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);
5142: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);

Line 5139: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);

5135: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5136: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5137: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5138: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5139: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5140: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5141: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);
5142: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);
5143: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 5140: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);

5136: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5137: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5138: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5139: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5140: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5141: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);
5142: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);
5143: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
5144: /* Reset total values, displayed at the end of each page */

Line 5141: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);

5137: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5138: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5139: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5140: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5141: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);
5142: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);
5143: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
5144: /* Reset total values, displayed at the end of each page */
5145: l_basic_total := 0;

Line 5142: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);

5138: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5139: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5140: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5141: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);
5142: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);
5143: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
5144: /* Reset total values, displayed at the end of each page */
5145: l_basic_total := 0;
5146: l_col_total := 0;

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

5139: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5140: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5141: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);
5142: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);
5143: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
5144: /* Reset total values, displayed at the end of each page */
5145: l_basic_total := 0;
5146: l_col_total := 0;
5147: l_social_total := 0;

Line 5180: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bf_total), l_str_bf_total);

5176: l_str_total_er_cont_f_total := '' ||substr(l_fm_total_er_cont_total,length(l_fm_total_er_cont_total)-1)||'';
5177: l_str_total_er_cont_d_total := ''||substr(l_fm_total_er_cont_total,1,length(l_fm_total_er_cont_total)-3)||'';
5178: l_str_total_cont_f_total := '' ||substr(l_fm_total_cont_total,length(l_fm_total_cont_total)-1)||'';
5179: l_str_total_cont_d_total := ''||substr(l_fm_total_cont_total,1,length(l_fm_total_cont_total)-3)||'';
5180: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bf_total), l_str_bf_total);
5181: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);
5182: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5183: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5184: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);

Line 5181: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);

5177: l_str_total_er_cont_d_total := ''||substr(l_fm_total_er_cont_total,1,length(l_fm_total_er_cont_total)-3)||'';
5178: l_str_total_cont_f_total := '' ||substr(l_fm_total_cont_total,length(l_fm_total_cont_total)-1)||'';
5179: l_str_total_cont_d_total := ''||substr(l_fm_total_cont_total,1,length(l_fm_total_cont_total)-3)||'';
5180: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bf_total), l_str_bf_total);
5181: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);
5182: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5183: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5184: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);

Line 5182: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);

5178: l_str_total_cont_f_total := '' ||substr(l_fm_total_cont_total,length(l_fm_total_cont_total)-1)||'';
5179: l_str_total_cont_d_total := ''||substr(l_fm_total_cont_total,1,length(l_fm_total_cont_total)-3)||'';
5180: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bf_total), l_str_bf_total);
5181: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);
5182: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5183: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5184: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);

Line 5183: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);

5179: l_str_total_cont_d_total := ''||substr(l_fm_total_cont_total,1,length(l_fm_total_cont_total)-3)||'';
5180: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bf_total), l_str_bf_total);
5181: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);
5182: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5183: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5184: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);

Line 5184: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);

5180: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bf_total), l_str_bf_total);
5181: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);
5182: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5183: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5184: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);

Line 5185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);

5181: dbms_lob.writeAppend( l_xfdf_string, length(l_str_bd_total), l_str_bd_total);
5182: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5183: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5184: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);

Line 5186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);

5182: dbms_lob.writeAppend( l_xfdf_string, length(l_str_colf_total), l_str_colf_total);
5183: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5184: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);

Line 5187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);

5183: dbms_lob.writeAppend( l_xfdf_string, length(l_str_cold_total), l_str_cold_total);
5184: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);

Line 5188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);

5184: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socf_total), l_str_socf_total);
5185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);

Line 5189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);

5185: dbms_lob.writeAppend( l_xfdf_string, length(l_str_socd_total), l_str_socd_total);
5186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);

Line 5190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);

5186: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chf_total), l_str_chf_total);
5187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);

Line 5191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);

5187: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chd_total), l_str_chd_total);
5188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5195: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);

Line 5192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);

5188: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accf_total), l_str_accf_total);
5189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5195: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5196: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);

Line 5193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);

5189: dbms_lob.writeAppend( l_xfdf_string, length(l_str_accd_total), l_str_accd_total);
5190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5195: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5196: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);
5197: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);

Line 5194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);

5190: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_f), l_str_total_allow_total_f);
5191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5195: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5196: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);
5197: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);
5198: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 5195: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);

5191: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_allow_total_d), l_str_total_allow_total_d);
5192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5195: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5196: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);
5197: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);
5198: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
5199: /* Reset total values, displayed at the end of each page */

Line 5196: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);

5192: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_f_total), l_str_total_ee_cont_f_total);
5193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5195: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5196: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);
5197: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);
5198: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
5199: /* Reset total values, displayed at the end of each page */
5200: l_basic_total := 0;

Line 5197: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);

5193: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_ee_cont_d_total), l_str_total_ee_cont_d_total);
5194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5195: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5196: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);
5197: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);
5198: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
5199: /* Reset total values, displayed at the end of each page */
5200: l_basic_total := 0;
5201: l_col_total := 0;

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

5194: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_f_total), l_str_total_er_cont_f_total);
5195: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_er_cont_d_total), l_str_total_er_cont_d_total);
5196: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_f_total), l_str_total_cont_f_total);
5197: dbms_lob.writeAppend( l_xfdf_string, length(l_str_total_cont_d_total), l_str_total_cont_d_total);
5198: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
5199: /* Reset total values, displayed at the end of each page */
5200: l_basic_total := 0;
5201: l_col_total := 0;
5202: l_social_total := 0;

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

5207: l_total_er_cont_total := 0;
5208: l_total_cont_total := 0;
5209: END IF;
5210: END LOOP;
5211: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
5212: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
5213: clob_to_blob(l_xfdf_string,l_xfdf_blob);
5214: hr_utility.set_location('Finished creating xml data for Procedure Monthly Contribution Federal ',20);
5215: EXCEPTION

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

5208: l_total_cont_total := 0;
5209: END IF;
5210: END LOOP;
5211: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
5212: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
5213: clob_to_blob(l_xfdf_string,l_xfdf_blob);
5214: hr_utility.set_location('Finished creating xml data for Procedure Monthly Contribution Federal ',20);
5215: EXCEPTION
5216: WHEN utl_file.invalid_path then

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

5271: l_str7 := '
5272:
5273:
5274: ';
5275: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
5276: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
5277: if vXMLTable.COUNT > 0 then
5278: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
5279: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

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

5272:
5273:
5274: ';
5275: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
5276: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
5277: if vXMLTable.COUNT > 0 then
5278: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
5279: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
5280: l_str8 := vXMLTable(ctr_table).TagName;

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

5274: ';
5275: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
5276: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
5277: if vXMLTable.COUNT > 0 then
5278: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
5279: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
5280: l_str8 := vXMLTable(ctr_table).TagName;
5281: l_str9 := vXMLTable(ctr_table).TagValue;
5282: if (l_str9 is not null) then

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

5279: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
5280: l_str8 := vXMLTable(ctr_table).TagName;
5281: l_str9 := vXMLTable(ctr_table).TagValue;
5282: if (l_str9 is not null) then
5283: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
5284: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
5285: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
5286: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
5287: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

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

5280: l_str8 := vXMLTable(ctr_table).TagName;
5281: l_str9 := vXMLTable(ctr_table).TagValue;
5282: if (l_str9 is not null) then
5283: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
5284: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
5285: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
5286: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
5287: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
5288: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

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

5281: l_str9 := vXMLTable(ctr_table).TagValue;
5282: if (l_str9 is not null) then
5283: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
5284: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
5285: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
5286: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
5287: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
5288: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
5289: elsif (l_str9 is null and l_str8 is not null) then

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

5282: if (l_str9 is not null) then
5283: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
5284: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
5285: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
5286: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
5287: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
5288: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
5289: elsif (l_str9 is null and l_str8 is not null) then
5290: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

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

5283: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
5284: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
5285: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
5286: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
5287: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
5288: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
5289: elsif (l_str9 is null and l_str8 is not null) then
5290: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
5291: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

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

5284: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
5285: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
5286: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
5287: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
5288: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
5289: elsif (l_str9 is null and l_str8 is not null) then
5290: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
5291: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
5292: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

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

5286: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
5287: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
5288: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
5289: elsif (l_str9 is null and l_str8 is not null) then
5290: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
5291: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
5292: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
5293: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
5294: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

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

5287: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
5288: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
5289: elsif (l_str9 is null and l_str8 is not null) then
5290: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
5291: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
5292: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
5293: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
5294: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
5295: else

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

5288: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
5289: elsif (l_str9 is null and l_str8 is not null) then
5290: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
5291: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
5292: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
5293: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
5294: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
5295: else
5296: null;

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

5289: elsif (l_str9 is null and l_str8 is not null) then
5290: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
5291: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
5292: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
5293: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
5294: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
5295: else
5296: null;
5297: end if;

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

5290: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
5291: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
5292: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
5293: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
5294: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
5295: else
5296: null;
5297: end if;
5298: END LOOP;

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

5295: else
5296: null;
5297: end if;
5298: END LOOP;
5299: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
5300: else
5301: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
5302: end if;
5303: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

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

5297: end if;
5298: END LOOP;
5299: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
5300: else
5301: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
5302: end if;
5303: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
5304: clob_to_blob(l_xfdf_string,p_xfdf_blob);
5305: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

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

5299: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
5300: else
5301: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
5302: end if;
5303: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
5304: clob_to_blob(l_xfdf_string,p_xfdf_blob);
5305: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
5306: --return p_xfdf_blob;
5307: EXCEPTION

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

5327: begin
5328: l_buffer_len := 20000;
5329: hr_utility.set_location('Entered Procedure clob to blob',120);
5330: select userenv('LANGUAGE') into g_nls_db_char from dual;
5331: l_length_clob := dbms_lob.getlength(p_clob);
5332: l_offset := 1;
5333: while l_length_clob > 0 loop
5334: hr_utility.trace('l_length_clob '|| l_length_clob);
5335: if l_length_clob < l_buffer_len then

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

5336: l_chunk_len := l_length_clob;
5337: else
5338: l_chunk_len := l_buffer_len;
5339: end if;
5340: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
5341: fnd_file.put_line(fnd_file.log,l_varchar_buffer);
5342: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
5343: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
5344: 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));

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

5342: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
5343: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
5344: 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));
5345: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
5346: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
5347: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
5348: l_blob_offset := l_blob_offset + l_raw_buffer_len;
5349: l_offset := l_offset + l_chunk_len;
5350: l_length_clob := l_length_clob - l_chunk_len;

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

5343: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
5344: 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));
5345: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
5346: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
5347: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
5348: l_blob_offset := l_blob_offset + l_raw_buffer_len;
5349: l_offset := l_offset + l_chunk_len;
5350: l_length_clob := l_length_clob - l_chunk_len;
5351: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

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

5347: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
5348: l_blob_offset := l_blob_offset + l_raw_buffer_len;
5349: l_offset := l_offset + l_chunk_len;
5350: l_length_clob := l_length_clob - l_chunk_len;
5351: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
5352: end loop;
5353: hr_utility.set_location('Finished Procedure clob to blob ',130);
5354: end clob_to_blob;
5355: ------------------------------------------------------------------