');
1776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1777: end if;
1778:
1779: fnd_file.put_line(fnd_file.output, lv_header_label);
1780:
1781: if p_output_file_type ='HTML' then
1782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1783: end if;
Line 1782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1778:
1779: fnd_file.put_line(fnd_file.output, lv_header_label);
1780:
1781: if p_output_file_type ='HTML' then
1782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1783: end if;
1784:
1785: hr_utility.set_location(gv_package_name || '.archiver_extract', 100);
1786:
Line 2006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2002: if p_output_file_type = 'HTML' then
2003: lv_data_row := '
'||lv_data_row||'
';
2004: end if;
2005:
2006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2007: lv_data_row := lv_employee_data;
2008: END IF;
2009:
2010: /******* Federal Summary Level ********/
Line 2151: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2147:
2148: if p_output_file_type = 'HTML' then
2149: lv_data_row := '
'||lv_data_row||'
';
2150: end if;
2151: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2152: END LOOP;
2153: END IF; -- federal_bal.count
2154: /* Now Build employee static header with the new fetched person */
2155: emp_sum_static_data( lv_last_name,
Line 2323: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2319:
2320: if p_output_file_type = 'HTML' then
2321: lv_data_row := '
'||lv_data_row||'
';
2322: end if;
2323: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2324: END IF;
2325:
2326:
2327: /********* State Balance by Summary(by jurisdiction level) *****/
Line 2498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2494:
2495: if p_output_file_type = 'HTML' then
2496: lv_data_row := '
'||lv_data_row||'
';
2497: end if;
2498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2499: END LOOP;
2500: END IF; /* state_bal.count */
2501: hr_utility.trace('Before building new emp header');
2502:
Line 2665: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2661:
2662: if p_output_file_type = 'HTML' then
2663: lv_data_row := '
'||lv_data_row||'
';
2664: end if;
2665: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2666: END IF;
2667:
2668: /******* County Balances by Summary (by Jurisdiction) ******/
2669:
Line 2781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2777: lv_data_row := lv_prev_emp_data_row||lv_county_data_sum;
2778: if p_output_file_type = 'HTML' then
2779: lv_data_row := '
'||lv_data_row||'
';
2780: end if;
2781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2782: END LOOP;
2783: END IF; --county_bal.count
2784: hr_utility.trace('End of printing COUNTY sum.....');
2785:
Line 2923: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2919:
2920: if p_output_file_type = 'HTML' then
2921: lv_data_row := '
'||lv_data_row||'
';
2922: end if;
2923: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2924: END IF;
2925:
2926: /********* City Balances by Summary (by Jurisdiction) *******/
2927:
Line 3025: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3021: lv_data_row := lv_prev_emp_data_row||lv_city_data_sum;
3022: if p_output_file_type = 'HTML' then
3023: lv_data_row := '
'||lv_data_row||'
';
3024: end if;
3025: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3026: END LOOP;
3027: END IF; -- city_bal.count
3028: hr_utility.trace('End of printing COUNTY sum.....');
3029:
Line 3159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3155:
3156: if p_output_file_type = 'HTML' then
3157: lv_data_row := '
'||lv_data_row||'
';
3158: end if;
3159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3160: END IF;
3161:
3162: /***** School balance by Summary (by jurisdiction) *****/
3163:
Line 3248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3244: lv_data_row := lv_prev_emp_data_row||lv_school_data_sum;
3245: if p_output_file_type = 'HTML' then
3246: lv_data_row := '
'||lv_data_row||'
';
3247: end if;
3248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3249: END LOOP;
3250: END IF; -- school_bal.count
3251: hr_utility.trace('End of printing SCHOOL sum.....');
3252: /**** Now, build employee static header with the new fetched ***/
Line 3384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3380:
3381: if p_output_file_type = 'HTML' then
3382: lv_data_row := '
'||lv_data_row||'
';
3383: end if;
3384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3385: END IF;
3386:
3387: /***** PSD balance by Summary (by jurisdiction) *****/
3388:
Line 3481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3477: lv_data_row := lv_prev_emp_data_row||lv_PSD_data_sum;
3478: if p_output_file_type = 'HTML' then
3479: lv_data_row := '
'||lv_data_row||'
';
3480: end if;
3481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3482: END LOOP;
3483: END IF; -- PSD_bal.count
3484: hr_utility.trace('End of printing PSD sum.....');
3485: /**** Now, build employee static header with the new fetched ***/
Line 3581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3577: if p_output_file_type = 'HTML' then
3578: lv_data_row := '
'||lv_data_row||'
';
3579: end if;
3580:
3581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3582: END LOOP;
3583: END IF;
3584: END IF;
3585:
Line 3619: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3615:
3616: if p_output_file_type = 'HTML' then
3617: lv_data_row := '
'||lv_data_row||'
';
3618: end if;
3619: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3620: END LOOP;
3621: END IF;
3622:
3623: END IF;
Line 3647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3643:
3644: if p_output_file_type = 'HTML' then
3645: lv_data_row := '
'||lv_data_row||'
';
3646: end if;
3647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3648: END LOOP;
3649: END IF; -- county_bal.count
3650: END IF;
3651:
Line 3674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3670:
3671: if p_output_file_type = 'HTML' then
3672: lv_data_row := '
'||lv_data_row||'
';
3673: end if;
3674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3675: END LOOP;
3676: END IF; -- city_bal.count
3677: END IF;
3678:
Line 3699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3695:
3696: if p_output_file_type = 'HTML' then
3697: lv_data_row := '
'||lv_data_row||'
';
3698: end if;
3699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3700: END LOOP;
3701: END IF; -- school_bal.count
3702: END IF;
3703:
Line 3727: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3723:
3724: if p_output_file_type = 'HTML' then
3725: lv_data_row := '
'||lv_data_row||'
';
3726: end if;
3727: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3728: END LOOP;
3729: END IF; -- PSD_bal.count
3730: END IF;
3731: -- #11927527 end
Line 3734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');