DBA Data[Home] [Help]

APPS.PAY_ARCHIVER_REPORT_PKG dependencies on FND_FILE

Line 1723: fnd_file.put_line(fnd_file.output,

1719: lv_header_label := lv_emp_detail_header||lv_psd_header;
1720: --#11927527 end
1721: end if;
1722: --#11927527 start
1723: fnd_file.put_line(fnd_file.output,
1724: title_string( gv_title
1725: ,p_output_file_type));
1726: --#11927527 start
1727: ELSIF p_detail_level = '02' THEN

Line 1750: fnd_file.put_line(fnd_file.output,

1746: lv_header_label := lv_emp_sum_header||lv_psd_header;
1747: --#11927527 end
1748: end if;
1749: --#11927527 start
1750: fnd_file.put_line(fnd_file.output,
1751: title_string( gv_title||'(Summary)'
1752: ,p_output_file_type));
1753: --#11927527 start
1754: END IF;

Line 1761: fnd_file.put_line(fnd_file.output,

1757:
1758: /* write the title of the report based on the output file type */
1759:
1760: /* #11927527 Commented to change the title according to Detailed Level
1761: fnd_file.put_line(fnd_file.output,
1762: title_string( gv_title
1763: ,p_output_file_type)); */
1764:
1765: hr_utility.set_location(gv_package_name || '.archiver_extract', 90);

Line 1774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1770: ****************************************************************/
1771: hr_utility.trace('Output File Type = '||p_output_file_type);
1772:
1773: if p_output_file_type ='HTML' then
1774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1777: end if;
1778:

Line 1775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1771: hr_utility.trace('Output File Type = '||p_output_file_type);
1772:
1773: if p_output_file_type ='HTML' then
1774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1777: end if;
1778:
1779: fnd_file.put_line(fnd_file.output, lv_header_label);

Line 1776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1772:
1773: if p_output_file_type ='HTML' then
1774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1777: end if;
1778:
1779: fnd_file.put_line(fnd_file.output, lv_header_label);
1780:

Line 1779: fnd_file.put_line(fnd_file.output, lv_header_label);

1775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
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, '
');

3730: END IF;
3731: -- #11927527 end
3732:
3733: if p_output_file_type ='HTML' then
3734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3735: end if;
3736: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
3737:
3738: /**********************************************************