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