');
1492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1493: end if;
1494:
1495: fnd_file.put_line(fnd_file.output, lv_header_label);
1496:
1497: if p_output_file_type ='HTML' then
1498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1499: end if;
Line 1498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1494:
1495: fnd_file.put_line(fnd_file.output, lv_header_label);
1496:
1497: if p_output_file_type ='HTML' then
1498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1499: end if;
1500:
1501: hr_utility.set_location(gv_package_name || '.archiver_extract', 100);
1502:
Line 1691: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
1687: if p_output_file_type = 'HTML' then
1688: lv_data_row := '
'||lv_data_row||'
';
1689: end if;
1690:
1691: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
1692: lv_data_row := lv_employee_data;
1693: END IF;
1694:
1695: /******* Federal Summary Level ********/
Line 1831: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
1827:
1828: if p_output_file_type = 'HTML' then
1829: lv_data_row := '
'||lv_data_row||'
';
1830: end if;
1831: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
1832: END LOOP;
1833: END IF; -- federal_bal.count
1834: /* Now Build employee static header with the new fetched person */
1835: emp_sum_static_data( lv_last_name,
Line 1999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
1995:
1996: if p_output_file_type = 'HTML' then
1997: lv_data_row := '
'||lv_data_row||'
';
1998: end if;
1999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2000: END IF;
2001:
2002:
2003: /********* State Balance by Summary(by jurisdiction level) *****/
Line 2167: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2163:
2164: if p_output_file_type = 'HTML' then
2165: lv_data_row := '
'||lv_data_row||'
';
2166: end if;
2167: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2168: END LOOP;
2169: END IF; /* state_bal.count */
2170: hr_utility.trace('Before building new emp header');
2171:
Line 2332: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2328:
2329: if p_output_file_type = 'HTML' then
2330: lv_data_row := '
'||lv_data_row||'
';
2331: end if;
2332: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2333: END IF;
2334:
2335: /******* County Balances by Summary (by Jurisdiction) ******/
2336:
Line 2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2444: lv_data_row := lv_prev_emp_data_row||lv_county_data_sum;
2445: if p_output_file_type = 'HTML' then
2446: lv_data_row := '
'||lv_data_row||'
';
2447: end if;
2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2449: END LOOP;
2450: END IF; --county_bal.count
2451: hr_utility.trace('End of printing COUNTY sum.....');
2452:
Line 2590: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2586:
2587: if p_output_file_type = 'HTML' then
2588: lv_data_row := '
'||lv_data_row||'
';
2589: end if;
2590: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2591: END IF;
2592:
2593: /********* City Balances by Summary (by Jurisdiction) *******/
2594:
Line 2692: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2688: lv_data_row := lv_prev_emp_data_row||lv_city_data_sum;
2689: if p_output_file_type = 'HTML' then
2690: lv_data_row := '
'||lv_data_row||'
';
2691: end if;
2692: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2693: END LOOP;
2694: END IF; -- city_bal.count
2695: hr_utility.trace('End of printing COUNTY sum.....');
2696:
Line 2826: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2822:
2823: if p_output_file_type = 'HTML' then
2824: lv_data_row := '
'||lv_data_row||'
';
2825: end if;
2826: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2827: END IF;
2828:
2829: /***** School balance by Summary (by jurisdiction) *****/
2830:
Line 2915: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2911: lv_data_row := lv_prev_emp_data_row||lv_school_data_sum;
2912: if p_output_file_type = 'HTML' then
2913: lv_data_row := '
'||lv_data_row||'
';
2914: end if;
2915: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2916: END LOOP;
2917: END IF; -- school_bal.count
2918: hr_utility.trace('End of printing SCHOOL sum.....');
2919: /**** Now, build employee static header with the new fetched ***/
Line 3010: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3006: if p_output_file_type = 'HTML' then
3007: lv_data_row := '
'||lv_data_row||'
';
3008: end if;
3009:
3010: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3011: END LOOP;
3012: END IF;
3013: END IF;
3014:
Line 3047: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3043:
3044: if p_output_file_type = 'HTML' then
3045: lv_data_row := '
'||lv_data_row||'
';
3046: end if;
3047: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3048: END LOOP;
3049: END IF;
3050:
3051: END IF;
Line 3075: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3071:
3072: if p_output_file_type = 'HTML' then
3073: lv_data_row := '
'||lv_data_row||'
';
3074: end if;
3075: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3076: END LOOP;
3077: END IF; -- county_bal.count
3078: END IF;
3079:
Line 3102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3098:
3099: if p_output_file_type = 'HTML' then
3100: lv_data_row := '
'||lv_data_row||'
';
3101: end if;
3102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3103: END LOOP;
3104: END IF; -- city_bal.count
3105: END IF;
3106:
Line 3127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3123:
3124: if p_output_file_type = 'HTML' then
3125: lv_data_row := '
'||lv_data_row||'
';
3126: end if;
3127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3128: END LOOP;
3129: END IF; -- school_bal.count
3130: END IF;
3131:
Line 3133: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');