DBA Data[Home] [Help]

APPS.PER_NEW_HIRE_PKG dependencies on FND_GLOBAL

Line 107: g_eol varchar2(1) := fnd_global.local_chr(10) ;

103:
104: g_e4_code varchar2(2) := 'E4';
105: g_w4_code varchar2(2) := 'W4';
106: g_t4_code varchar2(2) := 'T4';
107: g_eol varchar2(1) := fnd_global.local_chr(10) ;
108: g_delimiter varchar2(1) := ',';
109:
110: /****************************************************************
111: * This procedure sets character_set to out put file *

Line 199: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

195: --
196: -- format new hire rocord
197: --
198:
199: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
200:
201: l_buffer := upper(p_record_identifier ||
202: rpad(p_federal_id,9,' ') ||
203: rpad(nvl(v_sit,'0'),8,'0') ||

Line 276: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

272: --
273: -- format new hire rocord
274: --
275:
276: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
277:
278: l_buffer := upper(
279: p_record_identifier ||
280: rpad(nvl(v_ssn,' '),9,' ') || -- BUG4504074

Line 329: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

325: --
326: -- format new hire rocord
327: --
328:
329: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
330:
331: l_buffer := upper(
332: p_record_identifier ||
333: lpad(to_char(p_number_of_employee),11,'0') ||

Line 383: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

379: --
380: -- format new hire rocord
381: --
382:
383: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
384:
385: l_buffer := upper(p_record_identifier ||
386: p_creation_date ||
387: rpad(nvl(p_federal_id,' '),11,' ') ||

Line 442: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

438: --
439: -- format new hire rocord
440: --
441:
442: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
443:
444: l_buffer := upper(p_record_identifier ||
445: lpad(' ',4,' ') ||
446: rpad(nvl(p_federal_id,' '),11,' ') ||

Line 535: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

531: --
532: -- format new hire rocord
533: --
534:
535: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
536:
537: l_buffer := upper(
538: p_record_identifier ||
539: rpad(nvl(v_ssn,' '),9,' ') || -- BUG4504074

Line 588: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

584: --
585: -- format new hire rocord
586: --
587:
588: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
589:
590: l_buffer := upper(
591: p_record_identifier ||
592: lpad(to_char(p_number_of_employee),7,' ') ||

Line 628: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

624: --
625: -- format new hire rocord
626: --
627:
628: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
629:
630: l_buffer := upper(
631: p_record_identifier ||
632: lpad(to_char(p_number_of_employer),7,' ') ||

Line 751: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

747: hr_utility.trace('l_opt_phone= ' || l_opt_phone);
748: hr_utility.trace('p_multi_state= ' || p_multi_state);
749: hr_utility.set_location(l_api_name,30);
750: --bug#8791766
751: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
752: --
753: -- format new hire rocord
754: --
755: l_buffer := p_record_identifier || -- 'FL Newhire Record'

Line 1225: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

1221: --
1222: -- format new hire rocord
1223: --
1224:
1225: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
1226:
1227: l_buffer := upper(
1228: rpad(nvl(p_federal_id,' '),9,' ') ||
1229: rpad(nvl(p_tax_unit_name,' '),30,' ') ||

Line 1302: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

1298: --
1299: -- format new hire rocord
1300: --
1301:
1302: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
1303:
1304: l_buffer := upper(
1305: rpad(nvl(v_ssn,' '),9,' ') ||
1306: rpad(nvl(p_last_name,' '),15,' ')||

Line 1404: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

1400: --
1401: -- format new hire rocord
1402: --
1403:
1404: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
1405:
1406: l_buffer := upper(
1407: rpad(nvl(v_ssn,' '),9,' ') ||
1408: rpad(nvl(p_first_name,' '),16,' ')||

Line 1697: l_pa_delimiter varchar2(1) := fnd_global.local_chr(9);

1693: is
1694: l_api_name varchar2(61) := g_package_name || '.pa_new_hire_record';
1695: l_buffer varchar2(2000);
1696: v_ssn varchar2(9);
1697: l_pa_delimiter varchar2(1) := fnd_global.local_chr(9);
1698: l_phone varchar(20);
1699: begin
1700:
1701: hr_utility.set_location('Entering...: ' || l_api_name,10);

Line 1901: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

1897: hr_utility.trace('p_loc_contact= ' || p_loc_contact);
1898:
1899:
1900: hr_utility.set_location(l_api_name,30);
1901: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
1902: l_first_name := remove_special_characters(p_first_name);
1903: l_middle_name := remove_special_characters(p_middle_name);
1904: l_last_name := remove_special_characters(p_last_name,'-');
1905: l_emp_city := remove_special_characters(p_emp_city,'-');

Line 2093: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

2089:
2090: hr_utility.trace('l_phone= ' || l_phone);
2091:
2092: hr_utility.set_location(l_api_name,30);
2093: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
2094: l_first_name := remove_special_characters(p_first_name);
2095: l_middle_name := remove_special_characters(p_middle_name);
2096: l_last_name := remove_special_characters(p_last_name,'-');
2097: l_emp_city := remove_special_characters(p_emp_city,'-');

Line 2292: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);

2288:
2289: hr_utility.trace('l_phone= ' || l_phone);
2290:
2291: hr_utility.set_location(l_api_name,30);
2292: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
2293: l_first_name := remove_special_characters(p_first_name);
2294: l_middle_name := remove_special_characters(p_middle_name);
2295: l_last_name := remove_special_characters(p_last_name);
2296: l_emp_city := remove_special_characters(p_emp_city);