DBA Data[Home] [Help]

APPS.PER_NEW_HIRE_PKG dependencies on FND_GLOBAL

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

65:
66: g_e4_code varchar2(2) := 'E4';
67: g_w4_code varchar2(2) := 'W4';
68: g_t4_code varchar2(2) := 'T4';
69: g_eol varchar2(1) := fnd_global.local_chr(10) ;
70: g_delimiter varchar2(1) := ',';
71:
72: /****************************************************************
73: * This procedure sets character_set to out put file *

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

157: --
158: -- format new hire rocord
159: --
160:
161: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
162:
163: l_buffer := upper(p_record_identifier ||
164: rpad(p_federal_id,9,' ') ||
165: rpad(nvl(v_sit,'0'),8,'0') ||

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

234: --
235: -- format new hire rocord
236: --
237:
238: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
239:
240: l_buffer := upper(
241: p_record_identifier ||
242: rpad(nvl(v_ssn,' '),9,' ') || -- BUG4504074

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

287: --
288: -- format new hire rocord
289: --
290:
291: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
292:
293: l_buffer := upper(
294: p_record_identifier ||
295: lpad(to_char(p_number_of_employee),11,'0') ||

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

341: --
342: -- format new hire rocord
343: --
344:
345: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
346:
347: l_buffer := upper(p_record_identifier ||
348: p_creation_date ||
349: rpad(nvl(p_federal_id,' '),11,' ') ||

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

400: --
401: -- format new hire rocord
402: --
403:
404: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
405:
406: l_buffer := upper(p_record_identifier ||
407: lpad(' ',4,' ') ||
408: rpad(nvl(p_federal_id,' '),11,' ') ||

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

471: --
472: -- format new hire rocord
473: --
474:
475: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
476:
477: l_buffer := upper(
478: p_record_identifier ||
479: rpad(nvl(v_ssn,' '),9,' ') || -- BUG4504074

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

522: --
523: -- format new hire rocord
524: --
525:
526: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
527:
528: l_buffer := upper(
529: p_record_identifier ||
530: lpad(to_char(p_number_of_employee),7,' ') ||

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

562: --
563: -- format new hire rocord
564: --
565:
566: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
567:
568: l_buffer := upper(
569: p_record_identifier ||
570: lpad(to_char(p_number_of_employer),7,' ') ||