APPS.HR_HRHD_INITIAL_LOAD dependencies on FND_GLOBAL

Line 152: l_file_name_part := fnd_global.conc_request_id;

148: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
149: end if;
150: fnd_profile.get('UTL_FILE_OUT', l_file_path);
151: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
152: l_file_name_part := fnd_global.conc_request_id;
153: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
154: if (l_file_path is not null)
155: Then
156:

Line 182: fnd_global.local_chr(400)||p_active_date||

178: exit when CSR_LOC_INITIAL_LOAD%NOTFOUND;
179:
180:
181: UTL_FILE.PUT_LINE(l_file_pointer,p_bg_id||
182: fnd_global.local_chr(400)||p_active_date||
183: fnd_global.local_chr(400)||p_effecive_status||
184: fnd_global.local_chr(400)||p_loc_id||
185: fnd_global.local_chr(400)||p_lang_code||
186: fnd_global.local_chr(400)||p_loc_desc||

Line 183: fnd_global.local_chr(400)||p_effecive_status||

179:
180:
181: UTL_FILE.PUT_LINE(l_file_pointer,p_bg_id||
182: fnd_global.local_chr(400)||p_active_date||
183: fnd_global.local_chr(400)||p_effecive_status||
184: fnd_global.local_chr(400)||p_loc_id||
185: fnd_global.local_chr(400)||p_lang_code||
186: fnd_global.local_chr(400)||p_loc_desc||
187: fnd_global.local_chr(400)||p_loc_style ||

Line 184: fnd_global.local_chr(400)||p_loc_id||

180:
181: UTL_FILE.PUT_LINE(l_file_pointer,p_bg_id||
182: fnd_global.local_chr(400)||p_active_date||
183: fnd_global.local_chr(400)||p_effecive_status||
184: fnd_global.local_chr(400)||p_loc_id||
185: fnd_global.local_chr(400)||p_lang_code||
186: fnd_global.local_chr(400)||p_loc_desc||
187: fnd_global.local_chr(400)||p_loc_style ||
188: fnd_global.local_chr(400)|| p_add_line_1||

Line 185: fnd_global.local_chr(400)||p_lang_code||

181: UTL_FILE.PUT_LINE(l_file_pointer,p_bg_id||
182: fnd_global.local_chr(400)||p_active_date||
183: fnd_global.local_chr(400)||p_effecive_status||
184: fnd_global.local_chr(400)||p_loc_id||
185: fnd_global.local_chr(400)||p_lang_code||
186: fnd_global.local_chr(400)||p_loc_desc||
187: fnd_global.local_chr(400)||p_loc_style ||
188: fnd_global.local_chr(400)|| p_add_line_1||
189: fnd_global.local_chr(400)||p_add_line_2||

Line 186: fnd_global.local_chr(400)||p_loc_desc||

182: fnd_global.local_chr(400)||p_active_date||
183: fnd_global.local_chr(400)||p_effecive_status||
184: fnd_global.local_chr(400)||p_loc_id||
185: fnd_global.local_chr(400)||p_lang_code||
186: fnd_global.local_chr(400)||p_loc_desc||
187: fnd_global.local_chr(400)||p_loc_style ||
188: fnd_global.local_chr(400)|| p_add_line_1||
189: fnd_global.local_chr(400)||p_add_line_2||
190: fnd_global.local_chr(400)|| p_add_line_3||

Line 187: fnd_global.local_chr(400)||p_loc_style ||

183: fnd_global.local_chr(400)||p_effecive_status||
184: fnd_global.local_chr(400)||p_loc_id||
185: fnd_global.local_chr(400)||p_lang_code||
186: fnd_global.local_chr(400)||p_loc_desc||
187: fnd_global.local_chr(400)||p_loc_style ||
188: fnd_global.local_chr(400)|| p_add_line_1||
189: fnd_global.local_chr(400)||p_add_line_2||
190: fnd_global.local_chr(400)|| p_add_line_3||
191: fnd_global.local_chr(400)||p_town_or_city||

Line 188: fnd_global.local_chr(400)|| p_add_line_1||

184: fnd_global.local_chr(400)||p_loc_id||
185: fnd_global.local_chr(400)||p_lang_code||
186: fnd_global.local_chr(400)||p_loc_desc||
187: fnd_global.local_chr(400)||p_loc_style ||
188: fnd_global.local_chr(400)|| p_add_line_1||
189: fnd_global.local_chr(400)||p_add_line_2||
190: fnd_global.local_chr(400)|| p_add_line_3||
191: fnd_global.local_chr(400)||p_town_or_city||
192: fnd_global.local_chr(400)||p_country||

Line 189: fnd_global.local_chr(400)||p_add_line_2||

185: fnd_global.local_chr(400)||p_lang_code||
186: fnd_global.local_chr(400)||p_loc_desc||
187: fnd_global.local_chr(400)||p_loc_style ||
188: fnd_global.local_chr(400)|| p_add_line_1||
189: fnd_global.local_chr(400)||p_add_line_2||
190: fnd_global.local_chr(400)|| p_add_line_3||
191: fnd_global.local_chr(400)||p_town_or_city||
192: fnd_global.local_chr(400)||p_country||
193: fnd_global.local_chr(400)||p_postal_code||

Line 190: fnd_global.local_chr(400)|| p_add_line_3||

186: fnd_global.local_chr(400)||p_loc_desc||
187: fnd_global.local_chr(400)||p_loc_style ||
188: fnd_global.local_chr(400)|| p_add_line_1||
189: fnd_global.local_chr(400)||p_add_line_2||
190: fnd_global.local_chr(400)|| p_add_line_3||
191: fnd_global.local_chr(400)||p_town_or_city||
192: fnd_global.local_chr(400)||p_country||
193: fnd_global.local_chr(400)||p_postal_code||
194: fnd_global.local_chr(400)||p_region_1||

Line 191: fnd_global.local_chr(400)||p_town_or_city||

187: fnd_global.local_chr(400)||p_loc_style ||
188: fnd_global.local_chr(400)|| p_add_line_1||
189: fnd_global.local_chr(400)||p_add_line_2||
190: fnd_global.local_chr(400)|| p_add_line_3||
191: fnd_global.local_chr(400)||p_town_or_city||
192: fnd_global.local_chr(400)||p_country||
193: fnd_global.local_chr(400)||p_postal_code||
194: fnd_global.local_chr(400)||p_region_1||
195: fnd_global.local_chr(400)||p_region_2||

Line 192: fnd_global.local_chr(400)||p_country||

188: fnd_global.local_chr(400)|| p_add_line_1||
189: fnd_global.local_chr(400)||p_add_line_2||
190: fnd_global.local_chr(400)|| p_add_line_3||
191: fnd_global.local_chr(400)||p_town_or_city||
192: fnd_global.local_chr(400)||p_country||
193: fnd_global.local_chr(400)||p_postal_code||
194: fnd_global.local_chr(400)||p_region_1||
195: fnd_global.local_chr(400)||p_region_2||
196: fnd_global.local_chr(400)||p_region_3||

Line 193: fnd_global.local_chr(400)||p_postal_code||

189: fnd_global.local_chr(400)||p_add_line_2||
190: fnd_global.local_chr(400)|| p_add_line_3||
191: fnd_global.local_chr(400)||p_town_or_city||
192: fnd_global.local_chr(400)||p_country||
193: fnd_global.local_chr(400)||p_postal_code||
194: fnd_global.local_chr(400)||p_region_1||
195: fnd_global.local_chr(400)||p_region_2||
196: fnd_global.local_chr(400)||p_region_3||
197: fnd_global.local_chr(400)||p_tel_no_1||

Line 194: fnd_global.local_chr(400)||p_region_1||

190: fnd_global.local_chr(400)|| p_add_line_3||
191: fnd_global.local_chr(400)||p_town_or_city||
192: fnd_global.local_chr(400)||p_country||
193: fnd_global.local_chr(400)||p_postal_code||
194: fnd_global.local_chr(400)||p_region_1||
195: fnd_global.local_chr(400)||p_region_2||
196: fnd_global.local_chr(400)||p_region_3||
197: fnd_global.local_chr(400)||p_tel_no_1||
198: fnd_global.local_chr(400)||p_tel_no_2 ||

Line 195: fnd_global.local_chr(400)||p_region_2||

191: fnd_global.local_chr(400)||p_town_or_city||
192: fnd_global.local_chr(400)||p_country||
193: fnd_global.local_chr(400)||p_postal_code||
194: fnd_global.local_chr(400)||p_region_1||
195: fnd_global.local_chr(400)||p_region_2||
196: fnd_global.local_chr(400)||p_region_3||
197: fnd_global.local_chr(400)||p_tel_no_1||
198: fnd_global.local_chr(400)||p_tel_no_2 ||
199: fnd_global.local_chr(400)||p_tel_no_3||

Line 196: fnd_global.local_chr(400)||p_region_3||

192: fnd_global.local_chr(400)||p_country||
193: fnd_global.local_chr(400)||p_postal_code||
194: fnd_global.local_chr(400)||p_region_1||
195: fnd_global.local_chr(400)||p_region_2||
196: fnd_global.local_chr(400)||p_region_3||
197: fnd_global.local_chr(400)||p_tel_no_1||
198: fnd_global.local_chr(400)||p_tel_no_2 ||
199: fnd_global.local_chr(400)||p_tel_no_3||
200: fnd_global.local_chr(400)||p_loc_info_13||

Line 197: fnd_global.local_chr(400)||p_tel_no_1||

193: fnd_global.local_chr(400)||p_postal_code||
194: fnd_global.local_chr(400)||p_region_1||
195: fnd_global.local_chr(400)||p_region_2||
196: fnd_global.local_chr(400)||p_region_3||
197: fnd_global.local_chr(400)||p_tel_no_1||
198: fnd_global.local_chr(400)||p_tel_no_2 ||
199: fnd_global.local_chr(400)||p_tel_no_3||
200: fnd_global.local_chr(400)||p_loc_info_13||
201: fnd_global.local_chr(400)||p_loc_info_14||

Line 198: fnd_global.local_chr(400)||p_tel_no_2 ||

194: fnd_global.local_chr(400)||p_region_1||
195: fnd_global.local_chr(400)||p_region_2||
196: fnd_global.local_chr(400)||p_region_3||
197: fnd_global.local_chr(400)||p_tel_no_1||
198: fnd_global.local_chr(400)||p_tel_no_2 ||
199: fnd_global.local_chr(400)||p_tel_no_3||
200: fnd_global.local_chr(400)||p_loc_info_13||
201: fnd_global.local_chr(400)||p_loc_info_14||
202: fnd_global.local_chr(400)||p_loc_info_15||

Line 199: fnd_global.local_chr(400)||p_tel_no_3||

195: fnd_global.local_chr(400)||p_region_2||
196: fnd_global.local_chr(400)||p_region_3||
197: fnd_global.local_chr(400)||p_tel_no_1||
198: fnd_global.local_chr(400)||p_tel_no_2 ||
199: fnd_global.local_chr(400)||p_tel_no_3||
200: fnd_global.local_chr(400)||p_loc_info_13||
201: fnd_global.local_chr(400)||p_loc_info_14||
202: fnd_global.local_chr(400)||p_loc_info_15||
203: fnd_global.local_chr(400)||p_loc_info_16||

Line 200: fnd_global.local_chr(400)||p_loc_info_13||

196: fnd_global.local_chr(400)||p_region_3||
197: fnd_global.local_chr(400)||p_tel_no_1||
198: fnd_global.local_chr(400)||p_tel_no_2 ||
199: fnd_global.local_chr(400)||p_tel_no_3||
200: fnd_global.local_chr(400)||p_loc_info_13||
201: fnd_global.local_chr(400)||p_loc_info_14||
202: fnd_global.local_chr(400)||p_loc_info_15||
203: fnd_global.local_chr(400)||p_loc_info_16||
204: fnd_global.local_chr(400)||p_loc_info_17||

Line 201: fnd_global.local_chr(400)||p_loc_info_14||

197: fnd_global.local_chr(400)||p_tel_no_1||
198: fnd_global.local_chr(400)||p_tel_no_2 ||
199: fnd_global.local_chr(400)||p_tel_no_3||
200: fnd_global.local_chr(400)||p_loc_info_13||
201: fnd_global.local_chr(400)||p_loc_info_14||
202: fnd_global.local_chr(400)||p_loc_info_15||
203: fnd_global.local_chr(400)||p_loc_info_16||
204: fnd_global.local_chr(400)||p_loc_info_17||
205: fnd_global.local_chr(400)||p_loc_info_18||

Line 202: fnd_global.local_chr(400)||p_loc_info_15||

198: fnd_global.local_chr(400)||p_tel_no_2 ||
199: fnd_global.local_chr(400)||p_tel_no_3||
200: fnd_global.local_chr(400)||p_loc_info_13||
201: fnd_global.local_chr(400)||p_loc_info_14||
202: fnd_global.local_chr(400)||p_loc_info_15||
203: fnd_global.local_chr(400)||p_loc_info_16||
204: fnd_global.local_chr(400)||p_loc_info_17||
205: fnd_global.local_chr(400)||p_loc_info_18||
206: fnd_global.local_chr(400)||p_loc_info_19||

Line 203: fnd_global.local_chr(400)||p_loc_info_16||

199: fnd_global.local_chr(400)||p_tel_no_3||
200: fnd_global.local_chr(400)||p_loc_info_13||
201: fnd_global.local_chr(400)||p_loc_info_14||
202: fnd_global.local_chr(400)||p_loc_info_15||
203: fnd_global.local_chr(400)||p_loc_info_16||
204: fnd_global.local_chr(400)||p_loc_info_17||
205: fnd_global.local_chr(400)||p_loc_info_18||
206: fnd_global.local_chr(400)||p_loc_info_19||
207: fnd_global.local_chr(400)||p_loc_info_20||

Line 204: fnd_global.local_chr(400)||p_loc_info_17||

200: fnd_global.local_chr(400)||p_loc_info_13||
201: fnd_global.local_chr(400)||p_loc_info_14||
202: fnd_global.local_chr(400)||p_loc_info_15||
203: fnd_global.local_chr(400)||p_loc_info_16||
204: fnd_global.local_chr(400)||p_loc_info_17||
205: fnd_global.local_chr(400)||p_loc_info_18||
206: fnd_global.local_chr(400)||p_loc_info_19||
207: fnd_global.local_chr(400)||p_loc_info_20||
208: fnd_global.local_chr(10)||fnd_global.local_chr(13));

Line 205: fnd_global.local_chr(400)||p_loc_info_18||

201: fnd_global.local_chr(400)||p_loc_info_14||
202: fnd_global.local_chr(400)||p_loc_info_15||
203: fnd_global.local_chr(400)||p_loc_info_16||
204: fnd_global.local_chr(400)||p_loc_info_17||
205: fnd_global.local_chr(400)||p_loc_info_18||
206: fnd_global.local_chr(400)||p_loc_info_19||
207: fnd_global.local_chr(400)||p_loc_info_20||
208: fnd_global.local_chr(10)||fnd_global.local_chr(13));
209:

Line 206: fnd_global.local_chr(400)||p_loc_info_19||

202: fnd_global.local_chr(400)||p_loc_info_15||
203: fnd_global.local_chr(400)||p_loc_info_16||
204: fnd_global.local_chr(400)||p_loc_info_17||
205: fnd_global.local_chr(400)||p_loc_info_18||
206: fnd_global.local_chr(400)||p_loc_info_19||
207: fnd_global.local_chr(400)||p_loc_info_20||
208: fnd_global.local_chr(10)||fnd_global.local_chr(13));
209:
210: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)

Line 207: fnd_global.local_chr(400)||p_loc_info_20||

203: fnd_global.local_chr(400)||p_loc_info_16||
204: fnd_global.local_chr(400)||p_loc_info_17||
205: fnd_global.local_chr(400)||p_loc_info_18||
206: fnd_global.local_chr(400)||p_loc_info_19||
207: fnd_global.local_chr(400)||p_loc_info_20||
208: fnd_global.local_chr(10)||fnd_global.local_chr(13));
209:
210: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
211: Then

Line 208: fnd_global.local_chr(10)||fnd_global.local_chr(13));

204: fnd_global.local_chr(400)||p_loc_info_17||
205: fnd_global.local_chr(400)||p_loc_info_18||
206: fnd_global.local_chr(400)||p_loc_info_19||
207: fnd_global.local_chr(400)||p_loc_info_20||
208: fnd_global.local_chr(10)||fnd_global.local_chr(13));
209:
210: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
211: Then
212: If UTL_FILE.IS_OPEN(l_file_pointer)

Line 339: l_file_name_part := fnd_global.conc_request_id;

335: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
336: end if;
337: fnd_profile.get('UTL_FILE_OUT', l_file_path);
338: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
339: l_file_name_part := fnd_global.conc_request_id;
340: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
341: if (l_file_path is not null)
342: Then
343:

Line 364: p_business_grp_id||fnd_global.local_chr(400)||

360: EXIT WHEN csr_job_initial_load%NOTFOUND;
361:
362:
363: UTL_FILE.PUT_LINE(l_file_pointer,
364: p_business_grp_id||fnd_global.local_chr(400)||
365: p_job_id||fnd_global.local_chr(400)||
366: p_eff_date||fnd_global.local_chr(400)||
367: p_eff_status||fnd_global.local_chr(400)||
368: p_lang_code||fnd_global.local_chr(400)||

Line 365: p_job_id||fnd_global.local_chr(400)||

361:
362:
363: UTL_FILE.PUT_LINE(l_file_pointer,
364: p_business_grp_id||fnd_global.local_chr(400)||
365: p_job_id||fnd_global.local_chr(400)||
366: p_eff_date||fnd_global.local_chr(400)||
367: p_eff_status||fnd_global.local_chr(400)||
368: p_lang_code||fnd_global.local_chr(400)||
369: p_job_descr||

Line 366: p_eff_date||fnd_global.local_chr(400)||

362:
363: UTL_FILE.PUT_LINE(l_file_pointer,
364: p_business_grp_id||fnd_global.local_chr(400)||
365: p_job_id||fnd_global.local_chr(400)||
366: p_eff_date||fnd_global.local_chr(400)||
367: p_eff_status||fnd_global.local_chr(400)||
368: p_lang_code||fnd_global.local_chr(400)||
369: p_job_descr||
370: fnd_global.local_chr(10)||fnd_global.local_chr(13));

Line 367: p_eff_status||fnd_global.local_chr(400)||

363: UTL_FILE.PUT_LINE(l_file_pointer,
364: p_business_grp_id||fnd_global.local_chr(400)||
365: p_job_id||fnd_global.local_chr(400)||
366: p_eff_date||fnd_global.local_chr(400)||
367: p_eff_status||fnd_global.local_chr(400)||
368: p_lang_code||fnd_global.local_chr(400)||
369: p_job_descr||
370: fnd_global.local_chr(10)||fnd_global.local_chr(13));
371:

Line 368: p_lang_code||fnd_global.local_chr(400)||

364: p_business_grp_id||fnd_global.local_chr(400)||
365: p_job_id||fnd_global.local_chr(400)||
366: p_eff_date||fnd_global.local_chr(400)||
367: p_eff_status||fnd_global.local_chr(400)||
368: p_lang_code||fnd_global.local_chr(400)||
369: p_job_descr||
370: fnd_global.local_chr(10)||fnd_global.local_chr(13));
371:
372: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)

Line 370: fnd_global.local_chr(10)||fnd_global.local_chr(13));

366: p_eff_date||fnd_global.local_chr(400)||
367: p_eff_status||fnd_global.local_chr(400)||
368: p_lang_code||fnd_global.local_chr(400)||
369: p_job_descr||
370: fnd_global.local_chr(10)||fnd_global.local_chr(13));
371:
372: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
373: Then
374: If UTL_FILE.IS_OPEN(l_file_pointer)

Line 538: l_file_name_part := fnd_global.conc_request_id;

534: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
535: end if;
536: fnd_profile.get('UTL_FILE_OUT', l_file_path);
537: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
538: l_file_name_part := fnd_global.conc_request_id;
539: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
540: if (l_file_path is not null)
541: Then
542:

Line 563: p_bg_id||fnd_global.local_chr(400)||

559: EXIT WHEN csr_org_initial_load%NOTFOUND;
560:
561:
562: UTL_FILE.PUT_LINE(l_file_pointer,
563: p_bg_id||fnd_global.local_chr(400)||
564: p_org_id||fnd_global.local_chr(400)||
565: p_eff_date||fnd_global.local_chr(400)||
566: p_eff_status||fnd_global.local_chr(400)||
567: p_lang_code||fnd_global.local_chr(400)||

Line 564: p_org_id||fnd_global.local_chr(400)||

560:
561:
562: UTL_FILE.PUT_LINE(l_file_pointer,
563: p_bg_id||fnd_global.local_chr(400)||
564: p_org_id||fnd_global.local_chr(400)||
565: p_eff_date||fnd_global.local_chr(400)||
566: p_eff_status||fnd_global.local_chr(400)||
567: p_lang_code||fnd_global.local_chr(400)||
568: p_bg_name||fnd_global.local_chr(400)||

Line 565: p_eff_date||fnd_global.local_chr(400)||

561:
562: UTL_FILE.PUT_LINE(l_file_pointer,
563: p_bg_id||fnd_global.local_chr(400)||
564: p_org_id||fnd_global.local_chr(400)||
565: p_eff_date||fnd_global.local_chr(400)||
566: p_eff_status||fnd_global.local_chr(400)||
567: p_lang_code||fnd_global.local_chr(400)||
568: p_bg_name||fnd_global.local_chr(400)||
569: p_loc_id||fnd_global.local_chr(400)||

Line 566: p_eff_status||fnd_global.local_chr(400)||

562: UTL_FILE.PUT_LINE(l_file_pointer,
563: p_bg_id||fnd_global.local_chr(400)||
564: p_org_id||fnd_global.local_chr(400)||
565: p_eff_date||fnd_global.local_chr(400)||
566: p_eff_status||fnd_global.local_chr(400)||
567: p_lang_code||fnd_global.local_chr(400)||
568: p_bg_name||fnd_global.local_chr(400)||
569: p_loc_id||fnd_global.local_chr(400)||
570: p_person_id||

Line 567: p_lang_code||fnd_global.local_chr(400)||

563: p_bg_id||fnd_global.local_chr(400)||
564: p_org_id||fnd_global.local_chr(400)||
565: p_eff_date||fnd_global.local_chr(400)||
566: p_eff_status||fnd_global.local_chr(400)||
567: p_lang_code||fnd_global.local_chr(400)||
568: p_bg_name||fnd_global.local_chr(400)||
569: p_loc_id||fnd_global.local_chr(400)||
570: p_person_id||
571: fnd_global.local_chr(10)||fnd_global.local_chr(13));

Line 568: p_bg_name||fnd_global.local_chr(400)||

564: p_org_id||fnd_global.local_chr(400)||
565: p_eff_date||fnd_global.local_chr(400)||
566: p_eff_status||fnd_global.local_chr(400)||
567: p_lang_code||fnd_global.local_chr(400)||
568: p_bg_name||fnd_global.local_chr(400)||
569: p_loc_id||fnd_global.local_chr(400)||
570: p_person_id||
571: fnd_global.local_chr(10)||fnd_global.local_chr(13));
572:

Line 569: p_loc_id||fnd_global.local_chr(400)||

565: p_eff_date||fnd_global.local_chr(400)||
566: p_eff_status||fnd_global.local_chr(400)||
567: p_lang_code||fnd_global.local_chr(400)||
568: p_bg_name||fnd_global.local_chr(400)||
569: p_loc_id||fnd_global.local_chr(400)||
570: p_person_id||
571: fnd_global.local_chr(10)||fnd_global.local_chr(13));
572:
573: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)

Line 571: fnd_global.local_chr(10)||fnd_global.local_chr(13));

567: p_lang_code||fnd_global.local_chr(400)||
568: p_bg_name||fnd_global.local_chr(400)||
569: p_loc_id||fnd_global.local_chr(400)||
570: p_person_id||
571: fnd_global.local_chr(10)||fnd_global.local_chr(13));
572:
573: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
574: Then
575: If UTL_FILE.IS_OPEN(l_file_pointer)

Line 731: l_file_name_part := fnd_global.conc_request_id;

727: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
728: end if;
729: fnd_profile.get('UTL_FILE_OUT', l_file_path);
730: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
731: l_file_name_part := fnd_global.conc_request_id;
732: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
733: if (l_file_path is not null)
734: Then
735:

Line 760: p_business_group_id||fnd_global.local_chr(400)||

756: EXIT WHEN csr_wkfrc_initial_load%NOTFOUND;
757:
758:
759: UTL_FILE.PUT_LINE(l_file_pointer,
760: p_business_group_id||fnd_global.local_chr(400)||
761: p_person_id||fnd_global.local_chr(400)||
762: p_assignment_id||fnd_global.local_chr(400)||
763: p_assignment_number||fnd_global.local_chr(400)||
764: p_effective_start_date||fnd_global.local_chr(400)||

Line 761: p_person_id||fnd_global.local_chr(400)||

757:
758:
759: UTL_FILE.PUT_LINE(l_file_pointer,
760: p_business_group_id||fnd_global.local_chr(400)||
761: p_person_id||fnd_global.local_chr(400)||
762: p_assignment_id||fnd_global.local_chr(400)||
763: p_assignment_number||fnd_global.local_chr(400)||
764: p_effective_start_date||fnd_global.local_chr(400)||
765: p_effective_end_date||fnd_global.local_chr(400)||

Line 762: p_assignment_id||fnd_global.local_chr(400)||

758:
759: UTL_FILE.PUT_LINE(l_file_pointer,
760: p_business_group_id||fnd_global.local_chr(400)||
761: p_person_id||fnd_global.local_chr(400)||
762: p_assignment_id||fnd_global.local_chr(400)||
763: p_assignment_number||fnd_global.local_chr(400)||
764: p_effective_start_date||fnd_global.local_chr(400)||
765: p_effective_end_date||fnd_global.local_chr(400)||
766: p_organization_id||fnd_global.local_chr(400)||

Line 763: p_assignment_number||fnd_global.local_chr(400)||

759: UTL_FILE.PUT_LINE(l_file_pointer,
760: p_business_group_id||fnd_global.local_chr(400)||
761: p_person_id||fnd_global.local_chr(400)||
762: p_assignment_id||fnd_global.local_chr(400)||
763: p_assignment_number||fnd_global.local_chr(400)||
764: p_effective_start_date||fnd_global.local_chr(400)||
765: p_effective_end_date||fnd_global.local_chr(400)||
766: p_organization_id||fnd_global.local_chr(400)||
767: p_probation_period||fnd_global.local_chr(400)||

Line 764: p_effective_start_date||fnd_global.local_chr(400)||

760: p_business_group_id||fnd_global.local_chr(400)||
761: p_person_id||fnd_global.local_chr(400)||
762: p_assignment_id||fnd_global.local_chr(400)||
763: p_assignment_number||fnd_global.local_chr(400)||
764: p_effective_start_date||fnd_global.local_chr(400)||
765: p_effective_end_date||fnd_global.local_chr(400)||
766: p_organization_id||fnd_global.local_chr(400)||
767: p_probation_period||fnd_global.local_chr(400)||
768: p_probation_units||fnd_global.local_chr(400)||

Line 765: p_effective_end_date||fnd_global.local_chr(400)||

761: p_person_id||fnd_global.local_chr(400)||
762: p_assignment_id||fnd_global.local_chr(400)||
763: p_assignment_number||fnd_global.local_chr(400)||
764: p_effective_start_date||fnd_global.local_chr(400)||
765: p_effective_end_date||fnd_global.local_chr(400)||
766: p_organization_id||fnd_global.local_chr(400)||
767: p_probation_period||fnd_global.local_chr(400)||
768: p_probation_units||fnd_global.local_chr(400)||
769: p_job_id||fnd_global.local_chr(400)||

Line 766: p_organization_id||fnd_global.local_chr(400)||

762: p_assignment_id||fnd_global.local_chr(400)||
763: p_assignment_number||fnd_global.local_chr(400)||
764: p_effective_start_date||fnd_global.local_chr(400)||
765: p_effective_end_date||fnd_global.local_chr(400)||
766: p_organization_id||fnd_global.local_chr(400)||
767: p_probation_period||fnd_global.local_chr(400)||
768: p_probation_units||fnd_global.local_chr(400)||
769: p_job_id||fnd_global.local_chr(400)||
770: p_assignment_status_type_id||fnd_global.local_chr(400)||

Line 767: p_probation_period||fnd_global.local_chr(400)||

763: p_assignment_number||fnd_global.local_chr(400)||
764: p_effective_start_date||fnd_global.local_chr(400)||
765: p_effective_end_date||fnd_global.local_chr(400)||
766: p_organization_id||fnd_global.local_chr(400)||
767: p_probation_period||fnd_global.local_chr(400)||
768: p_probation_units||fnd_global.local_chr(400)||
769: p_job_id||fnd_global.local_chr(400)||
770: p_assignment_status_type_id||fnd_global.local_chr(400)||
771: p_location_id||fnd_global.local_chr(400)||

Line 768: p_probation_units||fnd_global.local_chr(400)||

764: p_effective_start_date||fnd_global.local_chr(400)||
765: p_effective_end_date||fnd_global.local_chr(400)||
766: p_organization_id||fnd_global.local_chr(400)||
767: p_probation_period||fnd_global.local_chr(400)||
768: p_probation_units||fnd_global.local_chr(400)||
769: p_job_id||fnd_global.local_chr(400)||
770: p_assignment_status_type_id||fnd_global.local_chr(400)||
771: p_location_id||fnd_global.local_chr(400)||
772: p_employment_category||fnd_global.local_chr(400)||

Line 769: p_job_id||fnd_global.local_chr(400)||

765: p_effective_end_date||fnd_global.local_chr(400)||
766: p_organization_id||fnd_global.local_chr(400)||
767: p_probation_period||fnd_global.local_chr(400)||
768: p_probation_units||fnd_global.local_chr(400)||
769: p_job_id||fnd_global.local_chr(400)||
770: p_assignment_status_type_id||fnd_global.local_chr(400)||
771: p_location_id||fnd_global.local_chr(400)||
772: p_employment_category||fnd_global.local_chr(400)||
773: p_normal_hours||fnd_global.local_chr(400)||

Line 770: p_assignment_status_type_id||fnd_global.local_chr(400)||

766: p_organization_id||fnd_global.local_chr(400)||
767: p_probation_period||fnd_global.local_chr(400)||
768: p_probation_units||fnd_global.local_chr(400)||
769: p_job_id||fnd_global.local_chr(400)||
770: p_assignment_status_type_id||fnd_global.local_chr(400)||
771: p_location_id||fnd_global.local_chr(400)||
772: p_employment_category||fnd_global.local_chr(400)||
773: p_normal_hours||fnd_global.local_chr(400)||
774: p_frequency||fnd_global.local_chr(400)||

Line 771: p_location_id||fnd_global.local_chr(400)||

767: p_probation_period||fnd_global.local_chr(400)||
768: p_probation_units||fnd_global.local_chr(400)||
769: p_job_id||fnd_global.local_chr(400)||
770: p_assignment_status_type_id||fnd_global.local_chr(400)||
771: p_location_id||fnd_global.local_chr(400)||
772: p_employment_category||fnd_global.local_chr(400)||
773: p_normal_hours||fnd_global.local_chr(400)||
774: p_frequency||fnd_global.local_chr(400)||
775: p_grade_id||fnd_global.local_chr(400)||

Line 772: p_employment_category||fnd_global.local_chr(400)||

768: p_probation_units||fnd_global.local_chr(400)||
769: p_job_id||fnd_global.local_chr(400)||
770: p_assignment_status_type_id||fnd_global.local_chr(400)||
771: p_location_id||fnd_global.local_chr(400)||
772: p_employment_category||fnd_global.local_chr(400)||
773: p_normal_hours||fnd_global.local_chr(400)||
774: p_frequency||fnd_global.local_chr(400)||
775: p_grade_id||fnd_global.local_chr(400)||
776: p_position_id||fnd_global.local_chr(400)||

Line 773: p_normal_hours||fnd_global.local_chr(400)||

769: p_job_id||fnd_global.local_chr(400)||
770: p_assignment_status_type_id||fnd_global.local_chr(400)||
771: p_location_id||fnd_global.local_chr(400)||
772: p_employment_category||fnd_global.local_chr(400)||
773: p_normal_hours||fnd_global.local_chr(400)||
774: p_frequency||fnd_global.local_chr(400)||
775: p_grade_id||fnd_global.local_chr(400)||
776: p_position_id||fnd_global.local_chr(400)||
777: p_supervisor_id||fnd_global.local_chr(400)||

Line 774: p_frequency||fnd_global.local_chr(400)||

770: p_assignment_status_type_id||fnd_global.local_chr(400)||
771: p_location_id||fnd_global.local_chr(400)||
772: p_employment_category||fnd_global.local_chr(400)||
773: p_normal_hours||fnd_global.local_chr(400)||
774: p_frequency||fnd_global.local_chr(400)||
775: p_grade_id||fnd_global.local_chr(400)||
776: p_position_id||fnd_global.local_chr(400)||
777: p_supervisor_id||fnd_global.local_chr(400)||
778: p_act_termn_date||fnd_global.local_chr(400)||

Line 775: p_grade_id||fnd_global.local_chr(400)||

771: p_location_id||fnd_global.local_chr(400)||
772: p_employment_category||fnd_global.local_chr(400)||
773: p_normal_hours||fnd_global.local_chr(400)||
774: p_frequency||fnd_global.local_chr(400)||
775: p_grade_id||fnd_global.local_chr(400)||
776: p_position_id||fnd_global.local_chr(400)||
777: p_supervisor_id||fnd_global.local_chr(400)||
778: p_act_termn_date||fnd_global.local_chr(400)||
779: p_final_prcs_date||fnd_global.local_chr(400)||

Line 776: p_position_id||fnd_global.local_chr(400)||

772: p_employment_category||fnd_global.local_chr(400)||
773: p_normal_hours||fnd_global.local_chr(400)||
774: p_frequency||fnd_global.local_chr(400)||
775: p_grade_id||fnd_global.local_chr(400)||
776: p_position_id||fnd_global.local_chr(400)||
777: p_supervisor_id||fnd_global.local_chr(400)||
778: p_act_termn_date||fnd_global.local_chr(400)||
779: p_final_prcs_date||fnd_global.local_chr(400)||
780: p_primary_flag||

Line 777: p_supervisor_id||fnd_global.local_chr(400)||

773: p_normal_hours||fnd_global.local_chr(400)||
774: p_frequency||fnd_global.local_chr(400)||
775: p_grade_id||fnd_global.local_chr(400)||
776: p_position_id||fnd_global.local_chr(400)||
777: p_supervisor_id||fnd_global.local_chr(400)||
778: p_act_termn_date||fnd_global.local_chr(400)||
779: p_final_prcs_date||fnd_global.local_chr(400)||
780: p_primary_flag||
781: fnd_global.local_chr(10)||fnd_global.local_chr(13));

Line 778: p_act_termn_date||fnd_global.local_chr(400)||

774: p_frequency||fnd_global.local_chr(400)||
775: p_grade_id||fnd_global.local_chr(400)||
776: p_position_id||fnd_global.local_chr(400)||
777: p_supervisor_id||fnd_global.local_chr(400)||
778: p_act_termn_date||fnd_global.local_chr(400)||
779: p_final_prcs_date||fnd_global.local_chr(400)||
780: p_primary_flag||
781: fnd_global.local_chr(10)||fnd_global.local_chr(13));
782:

Line 779: p_final_prcs_date||fnd_global.local_chr(400)||

775: p_grade_id||fnd_global.local_chr(400)||
776: p_position_id||fnd_global.local_chr(400)||
777: p_supervisor_id||fnd_global.local_chr(400)||
778: p_act_termn_date||fnd_global.local_chr(400)||
779: p_final_prcs_date||fnd_global.local_chr(400)||
780: p_primary_flag||
781: fnd_global.local_chr(10)||fnd_global.local_chr(13));
782:
783: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)

Line 781: fnd_global.local_chr(10)||fnd_global.local_chr(13));

777: p_supervisor_id||fnd_global.local_chr(400)||
778: p_act_termn_date||fnd_global.local_chr(400)||
779: p_final_prcs_date||fnd_global.local_chr(400)||
780: p_primary_flag||
781: fnd_global.local_chr(10)||fnd_global.local_chr(13));
782:
783: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
784: Then
785: If UTL_FILE.IS_OPEN(l_file_pointer)

Line 1008: l_file_name_part := fnd_global.conc_request_id;

1004: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
1005: end if;
1006: fnd_profile.get('UTL_FILE_OUT', l_file_path);
1007: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
1008: l_file_name_part := fnd_global.conc_request_id;
1009: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
1010: if (l_file_path is not null)
1011: Then
1012:

Line 1051: p_business_group_id||fnd_global.local_chr(400)||

1047: if k <= p_phn_type.count
1048: then
1049:
1050: UTL_FILE.put_line(l_file_pointer,
1051: p_business_group_id||fnd_global.local_chr(400)||
1052: p_person_id||fnd_global.local_chr(400)||
1053: p_legislation_code||fnd_global.local_chr(400)||
1054: p_employee_number||fnd_global.local_chr(400)||
1055: p_applicant_number||fnd_global.local_chr(400)||

Line 1052: p_person_id||fnd_global.local_chr(400)||

1048: then
1049:
1050: UTL_FILE.put_line(l_file_pointer,
1051: p_business_group_id||fnd_global.local_chr(400)||
1052: p_person_id||fnd_global.local_chr(400)||
1053: p_legislation_code||fnd_global.local_chr(400)||
1054: p_employee_number||fnd_global.local_chr(400)||
1055: p_applicant_number||fnd_global.local_chr(400)||
1056: p_npw_number||fnd_global.local_chr(400)||

Line 1053: p_legislation_code||fnd_global.local_chr(400)||

1049:
1050: UTL_FILE.put_line(l_file_pointer,
1051: p_business_group_id||fnd_global.local_chr(400)||
1052: p_person_id||fnd_global.local_chr(400)||
1053: p_legislation_code||fnd_global.local_chr(400)||
1054: p_employee_number||fnd_global.local_chr(400)||
1055: p_applicant_number||fnd_global.local_chr(400)||
1056: p_npw_number||fnd_global.local_chr(400)||
1057: p_person_type_id||fnd_global.local_chr(400)||

Line 1054: p_employee_number||fnd_global.local_chr(400)||

1050: UTL_FILE.put_line(l_file_pointer,
1051: p_business_group_id||fnd_global.local_chr(400)||
1052: p_person_id||fnd_global.local_chr(400)||
1053: p_legislation_code||fnd_global.local_chr(400)||
1054: p_employee_number||fnd_global.local_chr(400)||
1055: p_applicant_number||fnd_global.local_chr(400)||
1056: p_npw_number||fnd_global.local_chr(400)||
1057: p_person_type_id||fnd_global.local_chr(400)||
1058: p_date_of_birth||fnd_global.local_chr(400)||

Line 1055: p_applicant_number||fnd_global.local_chr(400)||

1051: p_business_group_id||fnd_global.local_chr(400)||
1052: p_person_id||fnd_global.local_chr(400)||
1053: p_legislation_code||fnd_global.local_chr(400)||
1054: p_employee_number||fnd_global.local_chr(400)||
1055: p_applicant_number||fnd_global.local_chr(400)||
1056: p_npw_number||fnd_global.local_chr(400)||
1057: p_person_type_id||fnd_global.local_chr(400)||
1058: p_date_of_birth||fnd_global.local_chr(400)||
1059: p_town_of_birth||fnd_global.local_chr(400)||

Line 1056: p_npw_number||fnd_global.local_chr(400)||

1052: p_person_id||fnd_global.local_chr(400)||
1053: p_legislation_code||fnd_global.local_chr(400)||
1054: p_employee_number||fnd_global.local_chr(400)||
1055: p_applicant_number||fnd_global.local_chr(400)||
1056: p_npw_number||fnd_global.local_chr(400)||
1057: p_person_type_id||fnd_global.local_chr(400)||
1058: p_date_of_birth||fnd_global.local_chr(400)||
1059: p_town_of_birth||fnd_global.local_chr(400)||
1060: p_cntry_of_birth||fnd_global.local_chr(400)||

Line 1057: p_person_type_id||fnd_global.local_chr(400)||

1053: p_legislation_code||fnd_global.local_chr(400)||
1054: p_employee_number||fnd_global.local_chr(400)||
1055: p_applicant_number||fnd_global.local_chr(400)||
1056: p_npw_number||fnd_global.local_chr(400)||
1057: p_person_type_id||fnd_global.local_chr(400)||
1058: p_date_of_birth||fnd_global.local_chr(400)||
1059: p_town_of_birth||fnd_global.local_chr(400)||
1060: p_cntry_of_birth||fnd_global.local_chr(400)||
1061: p_date_of_death||fnd_global.local_chr(400)||

Line 1058: p_date_of_birth||fnd_global.local_chr(400)||

1054: p_employee_number||fnd_global.local_chr(400)||
1055: p_applicant_number||fnd_global.local_chr(400)||
1056: p_npw_number||fnd_global.local_chr(400)||
1057: p_person_type_id||fnd_global.local_chr(400)||
1058: p_date_of_birth||fnd_global.local_chr(400)||
1059: p_town_of_birth||fnd_global.local_chr(400)||
1060: p_cntry_of_birth||fnd_global.local_chr(400)||
1061: p_date_of_death||fnd_global.local_chr(400)||
1062: p_orig_dt_of_hire||fnd_global.local_chr(400)||

Line 1059: p_town_of_birth||fnd_global.local_chr(400)||

1055: p_applicant_number||fnd_global.local_chr(400)||
1056: p_npw_number||fnd_global.local_chr(400)||
1057: p_person_type_id||fnd_global.local_chr(400)||
1058: p_date_of_birth||fnd_global.local_chr(400)||
1059: p_town_of_birth||fnd_global.local_chr(400)||
1060: p_cntry_of_birth||fnd_global.local_chr(400)||
1061: p_date_of_death||fnd_global.local_chr(400)||
1062: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1063: p_eff_start_date||fnd_global.local_chr(400)||

Line 1060: p_cntry_of_birth||fnd_global.local_chr(400)||

1056: p_npw_number||fnd_global.local_chr(400)||
1057: p_person_type_id||fnd_global.local_chr(400)||
1058: p_date_of_birth||fnd_global.local_chr(400)||
1059: p_town_of_birth||fnd_global.local_chr(400)||
1060: p_cntry_of_birth||fnd_global.local_chr(400)||
1061: p_date_of_death||fnd_global.local_chr(400)||
1062: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1063: p_eff_start_date||fnd_global.local_chr(400)||
1064: p_eff_end_date||fnd_global.local_chr(400)||

Line 1061: p_date_of_death||fnd_global.local_chr(400)||

1057: p_person_type_id||fnd_global.local_chr(400)||
1058: p_date_of_birth||fnd_global.local_chr(400)||
1059: p_town_of_birth||fnd_global.local_chr(400)||
1060: p_cntry_of_birth||fnd_global.local_chr(400)||
1061: p_date_of_death||fnd_global.local_chr(400)||
1062: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1063: p_eff_start_date||fnd_global.local_chr(400)||
1064: p_eff_end_date||fnd_global.local_chr(400)||
1065: p_sex||fnd_global.local_chr(400)||

Line 1062: p_orig_dt_of_hire||fnd_global.local_chr(400)||

1058: p_date_of_birth||fnd_global.local_chr(400)||
1059: p_town_of_birth||fnd_global.local_chr(400)||
1060: p_cntry_of_birth||fnd_global.local_chr(400)||
1061: p_date_of_death||fnd_global.local_chr(400)||
1062: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1063: p_eff_start_date||fnd_global.local_chr(400)||
1064: p_eff_end_date||fnd_global.local_chr(400)||
1065: p_sex||fnd_global.local_chr(400)||
1066: p_full_name||fnd_global.local_chr(400)||

Line 1063: p_eff_start_date||fnd_global.local_chr(400)||

1059: p_town_of_birth||fnd_global.local_chr(400)||
1060: p_cntry_of_birth||fnd_global.local_chr(400)||
1061: p_date_of_death||fnd_global.local_chr(400)||
1062: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1063: p_eff_start_date||fnd_global.local_chr(400)||
1064: p_eff_end_date||fnd_global.local_chr(400)||
1065: p_sex||fnd_global.local_chr(400)||
1066: p_full_name||fnd_global.local_chr(400)||
1067: p_suffix||fnd_global.local_chr(400)||

Line 1064: p_eff_end_date||fnd_global.local_chr(400)||

1060: p_cntry_of_birth||fnd_global.local_chr(400)||
1061: p_date_of_death||fnd_global.local_chr(400)||
1062: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1063: p_eff_start_date||fnd_global.local_chr(400)||
1064: p_eff_end_date||fnd_global.local_chr(400)||
1065: p_sex||fnd_global.local_chr(400)||
1066: p_full_name||fnd_global.local_chr(400)||
1067: p_suffix||fnd_global.local_chr(400)||
1068: p_title||fnd_global.local_chr(400)||

Line 1065: p_sex||fnd_global.local_chr(400)||

1061: p_date_of_death||fnd_global.local_chr(400)||
1062: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1063: p_eff_start_date||fnd_global.local_chr(400)||
1064: p_eff_end_date||fnd_global.local_chr(400)||
1065: p_sex||fnd_global.local_chr(400)||
1066: p_full_name||fnd_global.local_chr(400)||
1067: p_suffix||fnd_global.local_chr(400)||
1068: p_title||fnd_global.local_chr(400)||
1069: p_last_name||fnd_global.local_chr(400)||

Line 1066: p_full_name||fnd_global.local_chr(400)||

1062: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1063: p_eff_start_date||fnd_global.local_chr(400)||
1064: p_eff_end_date||fnd_global.local_chr(400)||
1065: p_sex||fnd_global.local_chr(400)||
1066: p_full_name||fnd_global.local_chr(400)||
1067: p_suffix||fnd_global.local_chr(400)||
1068: p_title||fnd_global.local_chr(400)||
1069: p_last_name||fnd_global.local_chr(400)||
1070: p_first_name||fnd_global.local_chr(400)||

Line 1067: p_suffix||fnd_global.local_chr(400)||

1063: p_eff_start_date||fnd_global.local_chr(400)||
1064: p_eff_end_date||fnd_global.local_chr(400)||
1065: p_sex||fnd_global.local_chr(400)||
1066: p_full_name||fnd_global.local_chr(400)||
1067: p_suffix||fnd_global.local_chr(400)||
1068: p_title||fnd_global.local_chr(400)||
1069: p_last_name||fnd_global.local_chr(400)||
1070: p_first_name||fnd_global.local_chr(400)||
1071: p_middle_names||fnd_global.local_chr(400)||

Line 1068: p_title||fnd_global.local_chr(400)||

1064: p_eff_end_date||fnd_global.local_chr(400)||
1065: p_sex||fnd_global.local_chr(400)||
1066: p_full_name||fnd_global.local_chr(400)||
1067: p_suffix||fnd_global.local_chr(400)||
1068: p_title||fnd_global.local_chr(400)||
1069: p_last_name||fnd_global.local_chr(400)||
1070: p_first_name||fnd_global.local_chr(400)||
1071: p_middle_names||fnd_global.local_chr(400)||
1072: p_nationality||fnd_global.local_chr(400)||

Line 1069: p_last_name||fnd_global.local_chr(400)||

1065: p_sex||fnd_global.local_chr(400)||
1066: p_full_name||fnd_global.local_chr(400)||
1067: p_suffix||fnd_global.local_chr(400)||
1068: p_title||fnd_global.local_chr(400)||
1069: p_last_name||fnd_global.local_chr(400)||
1070: p_first_name||fnd_global.local_chr(400)||
1071: p_middle_names||fnd_global.local_chr(400)||
1072: p_nationality||fnd_global.local_chr(400)||
1073: p_national_identifier||fnd_global.local_chr(400)||

Line 1070: p_first_name||fnd_global.local_chr(400)||

1066: p_full_name||fnd_global.local_chr(400)||
1067: p_suffix||fnd_global.local_chr(400)||
1068: p_title||fnd_global.local_chr(400)||
1069: p_last_name||fnd_global.local_chr(400)||
1070: p_first_name||fnd_global.local_chr(400)||
1071: p_middle_names||fnd_global.local_chr(400)||
1072: p_nationality||fnd_global.local_chr(400)||
1073: p_national_identifier||fnd_global.local_chr(400)||
1074: p_email_address||fnd_global.local_chr(400)||

Line 1071: p_middle_names||fnd_global.local_chr(400)||

1067: p_suffix||fnd_global.local_chr(400)||
1068: p_title||fnd_global.local_chr(400)||
1069: p_last_name||fnd_global.local_chr(400)||
1070: p_first_name||fnd_global.local_chr(400)||
1071: p_middle_names||fnd_global.local_chr(400)||
1072: p_nationality||fnd_global.local_chr(400)||
1073: p_national_identifier||fnd_global.local_chr(400)||
1074: p_email_address||fnd_global.local_chr(400)||
1075: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||

Line 1072: p_nationality||fnd_global.local_chr(400)||

1068: p_title||fnd_global.local_chr(400)||
1069: p_last_name||fnd_global.local_chr(400)||
1070: p_first_name||fnd_global.local_chr(400)||
1071: p_middle_names||fnd_global.local_chr(400)||
1072: p_nationality||fnd_global.local_chr(400)||
1073: p_national_identifier||fnd_global.local_chr(400)||
1074: p_email_address||fnd_global.local_chr(400)||
1075: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1076: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||

Line 1073: p_national_identifier||fnd_global.local_chr(400)||

1069: p_last_name||fnd_global.local_chr(400)||
1070: p_first_name||fnd_global.local_chr(400)||
1071: p_middle_names||fnd_global.local_chr(400)||
1072: p_nationality||fnd_global.local_chr(400)||
1073: p_national_identifier||fnd_global.local_chr(400)||
1074: p_email_address||fnd_global.local_chr(400)||
1075: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1076: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1077: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||

Line 1074: p_email_address||fnd_global.local_chr(400)||

1070: p_first_name||fnd_global.local_chr(400)||
1071: p_middle_names||fnd_global.local_chr(400)||
1072: p_nationality||fnd_global.local_chr(400)||
1073: p_national_identifier||fnd_global.local_chr(400)||
1074: p_email_address||fnd_global.local_chr(400)||
1075: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1076: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1077: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1078: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||

Line 1075: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||

1071: p_middle_names||fnd_global.local_chr(400)||
1072: p_nationality||fnd_global.local_chr(400)||
1073: p_national_identifier||fnd_global.local_chr(400)||
1074: p_email_address||fnd_global.local_chr(400)||
1075: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1076: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1077: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1078: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1079: p_addr_type(k).p_country||fnd_global.local_chr(400)||

Line 1076: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||

1072: p_nationality||fnd_global.local_chr(400)||
1073: p_national_identifier||fnd_global.local_chr(400)||
1074: p_email_address||fnd_global.local_chr(400)||
1075: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1076: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1077: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1078: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1079: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1080: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||

Line 1077: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||

1073: p_national_identifier||fnd_global.local_chr(400)||
1074: p_email_address||fnd_global.local_chr(400)||
1075: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1076: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1077: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1078: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1079: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1080: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1081: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||

Line 1078: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||

1074: p_email_address||fnd_global.local_chr(400)||
1075: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1076: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1077: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1078: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1079: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1080: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1081: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1082: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||

Line 1079: p_addr_type(k).p_country||fnd_global.local_chr(400)||

1075: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1076: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1077: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1078: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1079: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1080: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1081: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1082: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1083: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||

Line 1080: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||

1076: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1077: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1078: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1079: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1080: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1081: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1082: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1083: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1084: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||

Line 1081: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||

1077: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1078: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1079: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1080: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1081: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1082: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1083: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1084: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1085: p_addr_type(k).p_region1||fnd_global.local_chr(400)||

Line 1082: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||

1078: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1079: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1080: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1081: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1082: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1083: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1084: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1085: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1086: p_addr_type(k).p_region2||fnd_global.local_chr(400)||

Line 1083: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||

1079: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1080: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1081: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1082: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1083: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1084: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1085: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1086: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1087: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||

Line 1084: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||

1080: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1081: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1082: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1083: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1084: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1085: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1086: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1087: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1088: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||

Line 1085: p_addr_type(k).p_region1||fnd_global.local_chr(400)||

1081: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1082: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1083: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1084: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1085: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1086: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1087: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1088: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1089: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||

Line 1086: p_addr_type(k).p_region2||fnd_global.local_chr(400)||

1082: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1083: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1084: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1085: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1086: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1087: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1088: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1089: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1090: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||

Line 1087: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||

1083: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1084: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1085: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1086: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1087: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1088: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1089: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1090: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1091: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||

Line 1088: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||

1084: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1085: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1086: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1087: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1088: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1089: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1090: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1091: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1092: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||

Line 1089: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||

1085: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1086: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1087: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1088: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1089: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1090: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1091: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1092: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1093: p_national_id_label||fnd_global.local_chr(400)||

Line 1090: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||

1086: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1087: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1088: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1089: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1090: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1091: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1092: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1093: p_national_id_label||fnd_global.local_chr(400)||
1094: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

Line 1091: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||

1087: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1088: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1089: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1090: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1091: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1092: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1093: p_national_id_label||fnd_global.local_chr(400)||
1094: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1095: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

Line 1092: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||

1088: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1089: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1090: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1091: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1092: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1093: p_national_id_label||fnd_global.local_chr(400)||
1094: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1095: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1096: fnd_global.local_chr(10)||fnd_global.local_chr(13));

Line 1093: p_national_id_label||fnd_global.local_chr(400)||

1089: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1090: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1091: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1092: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1093: p_national_id_label||fnd_global.local_chr(400)||
1094: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1095: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1096: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1097:

Line 1094: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

1090: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1091: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1092: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1093: p_national_id_label||fnd_global.local_chr(400)||
1094: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1095: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1096: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1097:
1098:

Line 1096: fnd_global.local_chr(10)||fnd_global.local_chr(13));

1092: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1093: p_national_id_label||fnd_global.local_chr(400)||
1094: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1095: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1096: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1097:
1098:
1099: else
1100:

Line 1102: p_business_group_id||fnd_global.local_chr(400)||

1098:
1099: else
1100:
1101: UTL_FILE.put_line(l_file_pointer,
1102: p_business_group_id||fnd_global.local_chr(400)||
1103: p_person_id||fnd_global.local_chr(400)||
1104: p_legislation_code||fnd_global.local_chr(400)||
1105: p_employee_number||fnd_global.local_chr(400)||
1106: p_applicant_number||fnd_global.local_chr(400)||

Line 1103: p_person_id||fnd_global.local_chr(400)||

1099: else
1100:
1101: UTL_FILE.put_line(l_file_pointer,
1102: p_business_group_id||fnd_global.local_chr(400)||
1103: p_person_id||fnd_global.local_chr(400)||
1104: p_legislation_code||fnd_global.local_chr(400)||
1105: p_employee_number||fnd_global.local_chr(400)||
1106: p_applicant_number||fnd_global.local_chr(400)||
1107: p_npw_number||fnd_global.local_chr(400)||

Line 1104: p_legislation_code||fnd_global.local_chr(400)||

1100:
1101: UTL_FILE.put_line(l_file_pointer,
1102: p_business_group_id||fnd_global.local_chr(400)||
1103: p_person_id||fnd_global.local_chr(400)||
1104: p_legislation_code||fnd_global.local_chr(400)||
1105: p_employee_number||fnd_global.local_chr(400)||
1106: p_applicant_number||fnd_global.local_chr(400)||
1107: p_npw_number||fnd_global.local_chr(400)||
1108: p_person_type_id||fnd_global.local_chr(400)||

Line 1105: p_employee_number||fnd_global.local_chr(400)||

1101: UTL_FILE.put_line(l_file_pointer,
1102: p_business_group_id||fnd_global.local_chr(400)||
1103: p_person_id||fnd_global.local_chr(400)||
1104: p_legislation_code||fnd_global.local_chr(400)||
1105: p_employee_number||fnd_global.local_chr(400)||
1106: p_applicant_number||fnd_global.local_chr(400)||
1107: p_npw_number||fnd_global.local_chr(400)||
1108: p_person_type_id||fnd_global.local_chr(400)||
1109: p_date_of_birth||fnd_global.local_chr(400)||

Line 1106: p_applicant_number||fnd_global.local_chr(400)||

1102: p_business_group_id||fnd_global.local_chr(400)||
1103: p_person_id||fnd_global.local_chr(400)||
1104: p_legislation_code||fnd_global.local_chr(400)||
1105: p_employee_number||fnd_global.local_chr(400)||
1106: p_applicant_number||fnd_global.local_chr(400)||
1107: p_npw_number||fnd_global.local_chr(400)||
1108: p_person_type_id||fnd_global.local_chr(400)||
1109: p_date_of_birth||fnd_global.local_chr(400)||
1110: p_town_of_birth||fnd_global.local_chr(400)||

Line 1107: p_npw_number||fnd_global.local_chr(400)||

1103: p_person_id||fnd_global.local_chr(400)||
1104: p_legislation_code||fnd_global.local_chr(400)||
1105: p_employee_number||fnd_global.local_chr(400)||
1106: p_applicant_number||fnd_global.local_chr(400)||
1107: p_npw_number||fnd_global.local_chr(400)||
1108: p_person_type_id||fnd_global.local_chr(400)||
1109: p_date_of_birth||fnd_global.local_chr(400)||
1110: p_town_of_birth||fnd_global.local_chr(400)||
1111: p_cntry_of_birth||fnd_global.local_chr(400)||

Line 1108: p_person_type_id||fnd_global.local_chr(400)||

1104: p_legislation_code||fnd_global.local_chr(400)||
1105: p_employee_number||fnd_global.local_chr(400)||
1106: p_applicant_number||fnd_global.local_chr(400)||
1107: p_npw_number||fnd_global.local_chr(400)||
1108: p_person_type_id||fnd_global.local_chr(400)||
1109: p_date_of_birth||fnd_global.local_chr(400)||
1110: p_town_of_birth||fnd_global.local_chr(400)||
1111: p_cntry_of_birth||fnd_global.local_chr(400)||
1112: p_date_of_death||fnd_global.local_chr(400)||

Line 1109: p_date_of_birth||fnd_global.local_chr(400)||

1105: p_employee_number||fnd_global.local_chr(400)||
1106: p_applicant_number||fnd_global.local_chr(400)||
1107: p_npw_number||fnd_global.local_chr(400)||
1108: p_person_type_id||fnd_global.local_chr(400)||
1109: p_date_of_birth||fnd_global.local_chr(400)||
1110: p_town_of_birth||fnd_global.local_chr(400)||
1111: p_cntry_of_birth||fnd_global.local_chr(400)||
1112: p_date_of_death||fnd_global.local_chr(400)||
1113: p_orig_dt_of_hire||fnd_global.local_chr(400)||

Line 1110: p_town_of_birth||fnd_global.local_chr(400)||

1106: p_applicant_number||fnd_global.local_chr(400)||
1107: p_npw_number||fnd_global.local_chr(400)||
1108: p_person_type_id||fnd_global.local_chr(400)||
1109: p_date_of_birth||fnd_global.local_chr(400)||
1110: p_town_of_birth||fnd_global.local_chr(400)||
1111: p_cntry_of_birth||fnd_global.local_chr(400)||
1112: p_date_of_death||fnd_global.local_chr(400)||
1113: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1114: p_eff_start_date||fnd_global.local_chr(400)||

Line 1111: p_cntry_of_birth||fnd_global.local_chr(400)||

1107: p_npw_number||fnd_global.local_chr(400)||
1108: p_person_type_id||fnd_global.local_chr(400)||
1109: p_date_of_birth||fnd_global.local_chr(400)||
1110: p_town_of_birth||fnd_global.local_chr(400)||
1111: p_cntry_of_birth||fnd_global.local_chr(400)||
1112: p_date_of_death||fnd_global.local_chr(400)||
1113: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1114: p_eff_start_date||fnd_global.local_chr(400)||
1115: p_eff_end_date||fnd_global.local_chr(400)||

Line 1112: p_date_of_death||fnd_global.local_chr(400)||

1108: p_person_type_id||fnd_global.local_chr(400)||
1109: p_date_of_birth||fnd_global.local_chr(400)||
1110: p_town_of_birth||fnd_global.local_chr(400)||
1111: p_cntry_of_birth||fnd_global.local_chr(400)||
1112: p_date_of_death||fnd_global.local_chr(400)||
1113: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1114: p_eff_start_date||fnd_global.local_chr(400)||
1115: p_eff_end_date||fnd_global.local_chr(400)||
1116: p_sex||fnd_global.local_chr(400)||

Line 1113: p_orig_dt_of_hire||fnd_global.local_chr(400)||

1109: p_date_of_birth||fnd_global.local_chr(400)||
1110: p_town_of_birth||fnd_global.local_chr(400)||
1111: p_cntry_of_birth||fnd_global.local_chr(400)||
1112: p_date_of_death||fnd_global.local_chr(400)||
1113: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1114: p_eff_start_date||fnd_global.local_chr(400)||
1115: p_eff_end_date||fnd_global.local_chr(400)||
1116: p_sex||fnd_global.local_chr(400)||
1117: p_full_name||fnd_global.local_chr(400)||

Line 1114: p_eff_start_date||fnd_global.local_chr(400)||

1110: p_town_of_birth||fnd_global.local_chr(400)||
1111: p_cntry_of_birth||fnd_global.local_chr(400)||
1112: p_date_of_death||fnd_global.local_chr(400)||
1113: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1114: p_eff_start_date||fnd_global.local_chr(400)||
1115: p_eff_end_date||fnd_global.local_chr(400)||
1116: p_sex||fnd_global.local_chr(400)||
1117: p_full_name||fnd_global.local_chr(400)||
1118: p_suffix||fnd_global.local_chr(400)||

Line 1115: p_eff_end_date||fnd_global.local_chr(400)||

1111: p_cntry_of_birth||fnd_global.local_chr(400)||
1112: p_date_of_death||fnd_global.local_chr(400)||
1113: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1114: p_eff_start_date||fnd_global.local_chr(400)||
1115: p_eff_end_date||fnd_global.local_chr(400)||
1116: p_sex||fnd_global.local_chr(400)||
1117: p_full_name||fnd_global.local_chr(400)||
1118: p_suffix||fnd_global.local_chr(400)||
1119: p_title||fnd_global.local_chr(400)||

Line 1116: p_sex||fnd_global.local_chr(400)||

1112: p_date_of_death||fnd_global.local_chr(400)||
1113: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1114: p_eff_start_date||fnd_global.local_chr(400)||
1115: p_eff_end_date||fnd_global.local_chr(400)||
1116: p_sex||fnd_global.local_chr(400)||
1117: p_full_name||fnd_global.local_chr(400)||
1118: p_suffix||fnd_global.local_chr(400)||
1119: p_title||fnd_global.local_chr(400)||
1120: p_last_name||fnd_global.local_chr(400)||

Line 1117: p_full_name||fnd_global.local_chr(400)||

1113: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1114: p_eff_start_date||fnd_global.local_chr(400)||
1115: p_eff_end_date||fnd_global.local_chr(400)||
1116: p_sex||fnd_global.local_chr(400)||
1117: p_full_name||fnd_global.local_chr(400)||
1118: p_suffix||fnd_global.local_chr(400)||
1119: p_title||fnd_global.local_chr(400)||
1120: p_last_name||fnd_global.local_chr(400)||
1121: p_first_name||fnd_global.local_chr(400)||

Line 1118: p_suffix||fnd_global.local_chr(400)||

1114: p_eff_start_date||fnd_global.local_chr(400)||
1115: p_eff_end_date||fnd_global.local_chr(400)||
1116: p_sex||fnd_global.local_chr(400)||
1117: p_full_name||fnd_global.local_chr(400)||
1118: p_suffix||fnd_global.local_chr(400)||
1119: p_title||fnd_global.local_chr(400)||
1120: p_last_name||fnd_global.local_chr(400)||
1121: p_first_name||fnd_global.local_chr(400)||
1122: p_middle_names||fnd_global.local_chr(400)||

Line 1119: p_title||fnd_global.local_chr(400)||

1115: p_eff_end_date||fnd_global.local_chr(400)||
1116: p_sex||fnd_global.local_chr(400)||
1117: p_full_name||fnd_global.local_chr(400)||
1118: p_suffix||fnd_global.local_chr(400)||
1119: p_title||fnd_global.local_chr(400)||
1120: p_last_name||fnd_global.local_chr(400)||
1121: p_first_name||fnd_global.local_chr(400)||
1122: p_middle_names||fnd_global.local_chr(400)||
1123: p_nationality||fnd_global.local_chr(400)||

Line 1120: p_last_name||fnd_global.local_chr(400)||

1116: p_sex||fnd_global.local_chr(400)||
1117: p_full_name||fnd_global.local_chr(400)||
1118: p_suffix||fnd_global.local_chr(400)||
1119: p_title||fnd_global.local_chr(400)||
1120: p_last_name||fnd_global.local_chr(400)||
1121: p_first_name||fnd_global.local_chr(400)||
1122: p_middle_names||fnd_global.local_chr(400)||
1123: p_nationality||fnd_global.local_chr(400)||
1124: p_national_identifier||fnd_global.local_chr(400)||

Line 1121: p_first_name||fnd_global.local_chr(400)||

1117: p_full_name||fnd_global.local_chr(400)||
1118: p_suffix||fnd_global.local_chr(400)||
1119: p_title||fnd_global.local_chr(400)||
1120: p_last_name||fnd_global.local_chr(400)||
1121: p_first_name||fnd_global.local_chr(400)||
1122: p_middle_names||fnd_global.local_chr(400)||
1123: p_nationality||fnd_global.local_chr(400)||
1124: p_national_identifier||fnd_global.local_chr(400)||
1125: p_email_address||fnd_global.local_chr(400)||

Line 1122: p_middle_names||fnd_global.local_chr(400)||

1118: p_suffix||fnd_global.local_chr(400)||
1119: p_title||fnd_global.local_chr(400)||
1120: p_last_name||fnd_global.local_chr(400)||
1121: p_first_name||fnd_global.local_chr(400)||
1122: p_middle_names||fnd_global.local_chr(400)||
1123: p_nationality||fnd_global.local_chr(400)||
1124: p_national_identifier||fnd_global.local_chr(400)||
1125: p_email_address||fnd_global.local_chr(400)||
1126: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||

Line 1123: p_nationality||fnd_global.local_chr(400)||

1119: p_title||fnd_global.local_chr(400)||
1120: p_last_name||fnd_global.local_chr(400)||
1121: p_first_name||fnd_global.local_chr(400)||
1122: p_middle_names||fnd_global.local_chr(400)||
1123: p_nationality||fnd_global.local_chr(400)||
1124: p_national_identifier||fnd_global.local_chr(400)||
1125: p_email_address||fnd_global.local_chr(400)||
1126: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1127: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||

Line 1124: p_national_identifier||fnd_global.local_chr(400)||

1120: p_last_name||fnd_global.local_chr(400)||
1121: p_first_name||fnd_global.local_chr(400)||
1122: p_middle_names||fnd_global.local_chr(400)||
1123: p_nationality||fnd_global.local_chr(400)||
1124: p_national_identifier||fnd_global.local_chr(400)||
1125: p_email_address||fnd_global.local_chr(400)||
1126: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1127: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1128: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||

Line 1125: p_email_address||fnd_global.local_chr(400)||

1121: p_first_name||fnd_global.local_chr(400)||
1122: p_middle_names||fnd_global.local_chr(400)||
1123: p_nationality||fnd_global.local_chr(400)||
1124: p_national_identifier||fnd_global.local_chr(400)||
1125: p_email_address||fnd_global.local_chr(400)||
1126: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1127: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1128: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1129: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||

Line 1126: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||

1122: p_middle_names||fnd_global.local_chr(400)||
1123: p_nationality||fnd_global.local_chr(400)||
1124: p_national_identifier||fnd_global.local_chr(400)||
1125: p_email_address||fnd_global.local_chr(400)||
1126: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1127: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1128: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1129: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1130: p_addr_type(k).p_country||fnd_global.local_chr(400)||

Line 1127: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||

1123: p_nationality||fnd_global.local_chr(400)||
1124: p_national_identifier||fnd_global.local_chr(400)||
1125: p_email_address||fnd_global.local_chr(400)||
1126: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1127: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1128: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1129: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1130: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1131: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||

Line 1128: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||

1124: p_national_identifier||fnd_global.local_chr(400)||
1125: p_email_address||fnd_global.local_chr(400)||
1126: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1127: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1128: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1129: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1130: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1131: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1132: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||

Line 1129: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||

1125: p_email_address||fnd_global.local_chr(400)||
1126: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1127: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1128: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1129: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1130: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1131: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1132: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1133: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||

Line 1130: p_addr_type(k).p_country||fnd_global.local_chr(400)||

1126: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1127: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1128: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1129: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1130: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1131: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1132: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1133: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1134: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||

Line 1131: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||

1127: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1128: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1129: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1130: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1131: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1132: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1133: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1134: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1135: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||

Line 1132: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||

1128: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1129: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1130: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1131: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1132: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1133: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1134: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1135: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1136: p_addr_type(k).p_region1||fnd_global.local_chr(400)||

Line 1133: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||

1129: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1130: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1131: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1132: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1133: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1134: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1135: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1136: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1137: p_addr_type(k).p_region2||fnd_global.local_chr(400)||

Line 1134: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||

1130: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1131: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1132: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1133: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1134: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1135: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1136: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1137: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1138: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||

Line 1135: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||

1131: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1132: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1133: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1134: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1135: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1136: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1137: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1138: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1139: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||

Line 1136: p_addr_type(k).p_region1||fnd_global.local_chr(400)||

1132: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1133: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1134: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1135: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1136: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1137: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1138: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1139: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1140: fnd_global.local_chr(400)||

Line 1137: p_addr_type(k).p_region2||fnd_global.local_chr(400)||

1133: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1134: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1135: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1136: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1137: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1138: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1139: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1140: fnd_global.local_chr(400)||
1141: fnd_global.local_chr(400)||

Line 1138: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||

1134: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1135: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1136: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1137: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1138: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1139: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1140: fnd_global.local_chr(400)||
1141: fnd_global.local_chr(400)||
1142: fnd_global.local_chr(400)||

Line 1139: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||

1135: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1136: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1137: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1138: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1139: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1140: fnd_global.local_chr(400)||
1141: fnd_global.local_chr(400)||
1142: fnd_global.local_chr(400)||
1143: fnd_global.local_chr(400)||

Line 1140: fnd_global.local_chr(400)||

1136: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1137: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1138: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1139: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1140: fnd_global.local_chr(400)||
1141: fnd_global.local_chr(400)||
1142: fnd_global.local_chr(400)||
1143: fnd_global.local_chr(400)||
1144: p_national_id_label||fnd_global.local_chr(400)||

Line 1141: fnd_global.local_chr(400)||

1137: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1138: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1139: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1140: fnd_global.local_chr(400)||
1141: fnd_global.local_chr(400)||
1142: fnd_global.local_chr(400)||
1143: fnd_global.local_chr(400)||
1144: p_national_id_label||fnd_global.local_chr(400)||
1145: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

Line 1142: fnd_global.local_chr(400)||

1138: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1139: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1140: fnd_global.local_chr(400)||
1141: fnd_global.local_chr(400)||
1142: fnd_global.local_chr(400)||
1143: fnd_global.local_chr(400)||
1144: p_national_id_label||fnd_global.local_chr(400)||
1145: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1146: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

Line 1143: fnd_global.local_chr(400)||

1139: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1140: fnd_global.local_chr(400)||
1141: fnd_global.local_chr(400)||
1142: fnd_global.local_chr(400)||
1143: fnd_global.local_chr(400)||
1144: p_national_id_label||fnd_global.local_chr(400)||
1145: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1146: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1147: fnd_global.local_chr(10)||fnd_global.local_chr(13));

Line 1144: p_national_id_label||fnd_global.local_chr(400)||

1140: fnd_global.local_chr(400)||
1141: fnd_global.local_chr(400)||
1142: fnd_global.local_chr(400)||
1143: fnd_global.local_chr(400)||
1144: p_national_id_label||fnd_global.local_chr(400)||
1145: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1146: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1147: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1148:

Line 1145: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

1141: fnd_global.local_chr(400)||
1142: fnd_global.local_chr(400)||
1143: fnd_global.local_chr(400)||
1144: p_national_id_label||fnd_global.local_chr(400)||
1145: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1146: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1147: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1148:
1149:

Line 1147: fnd_global.local_chr(10)||fnd_global.local_chr(13));

1143: fnd_global.local_chr(400)||
1144: p_national_id_label||fnd_global.local_chr(400)||
1145: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1146: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1147: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1148:
1149:
1150: end if;
1151: end loop;

Line 1163: p_business_group_id||fnd_global.local_chr(400)||

1159: if k <= p_addr_type.count
1160: then
1161:
1162: UTL_FILE.put_line(l_file_pointer,
1163: p_business_group_id||fnd_global.local_chr(400)||
1164: p_person_id||fnd_global.local_chr(400)||
1165: p_legislation_code||fnd_global.local_chr(400)||
1166: p_employee_number||fnd_global.local_chr(400)||
1167: p_applicant_number||fnd_global.local_chr(400)||

Line 1164: p_person_id||fnd_global.local_chr(400)||

1160: then
1161:
1162: UTL_FILE.put_line(l_file_pointer,
1163: p_business_group_id||fnd_global.local_chr(400)||
1164: p_person_id||fnd_global.local_chr(400)||
1165: p_legislation_code||fnd_global.local_chr(400)||
1166: p_employee_number||fnd_global.local_chr(400)||
1167: p_applicant_number||fnd_global.local_chr(400)||
1168: p_npw_number||fnd_global.local_chr(400)||

Line 1165: p_legislation_code||fnd_global.local_chr(400)||

1161:
1162: UTL_FILE.put_line(l_file_pointer,
1163: p_business_group_id||fnd_global.local_chr(400)||
1164: p_person_id||fnd_global.local_chr(400)||
1165: p_legislation_code||fnd_global.local_chr(400)||
1166: p_employee_number||fnd_global.local_chr(400)||
1167: p_applicant_number||fnd_global.local_chr(400)||
1168: p_npw_number||fnd_global.local_chr(400)||
1169: p_person_type_id||fnd_global.local_chr(400)||

Line 1166: p_employee_number||fnd_global.local_chr(400)||

1162: UTL_FILE.put_line(l_file_pointer,
1163: p_business_group_id||fnd_global.local_chr(400)||
1164: p_person_id||fnd_global.local_chr(400)||
1165: p_legislation_code||fnd_global.local_chr(400)||
1166: p_employee_number||fnd_global.local_chr(400)||
1167: p_applicant_number||fnd_global.local_chr(400)||
1168: p_npw_number||fnd_global.local_chr(400)||
1169: p_person_type_id||fnd_global.local_chr(400)||
1170: p_date_of_birth||fnd_global.local_chr(400)||

Line 1167: p_applicant_number||fnd_global.local_chr(400)||

1163: p_business_group_id||fnd_global.local_chr(400)||
1164: p_person_id||fnd_global.local_chr(400)||
1165: p_legislation_code||fnd_global.local_chr(400)||
1166: p_employee_number||fnd_global.local_chr(400)||
1167: p_applicant_number||fnd_global.local_chr(400)||
1168: p_npw_number||fnd_global.local_chr(400)||
1169: p_person_type_id||fnd_global.local_chr(400)||
1170: p_date_of_birth||fnd_global.local_chr(400)||
1171: p_town_of_birth||fnd_global.local_chr(400)||

Line 1168: p_npw_number||fnd_global.local_chr(400)||

1164: p_person_id||fnd_global.local_chr(400)||
1165: p_legislation_code||fnd_global.local_chr(400)||
1166: p_employee_number||fnd_global.local_chr(400)||
1167: p_applicant_number||fnd_global.local_chr(400)||
1168: p_npw_number||fnd_global.local_chr(400)||
1169: p_person_type_id||fnd_global.local_chr(400)||
1170: p_date_of_birth||fnd_global.local_chr(400)||
1171: p_town_of_birth||fnd_global.local_chr(400)||
1172: p_cntry_of_birth||fnd_global.local_chr(400)||

Line 1169: p_person_type_id||fnd_global.local_chr(400)||

1165: p_legislation_code||fnd_global.local_chr(400)||
1166: p_employee_number||fnd_global.local_chr(400)||
1167: p_applicant_number||fnd_global.local_chr(400)||
1168: p_npw_number||fnd_global.local_chr(400)||
1169: p_person_type_id||fnd_global.local_chr(400)||
1170: p_date_of_birth||fnd_global.local_chr(400)||
1171: p_town_of_birth||fnd_global.local_chr(400)||
1172: p_cntry_of_birth||fnd_global.local_chr(400)||
1173: p_date_of_death||fnd_global.local_chr(400)||

Line 1170: p_date_of_birth||fnd_global.local_chr(400)||

1166: p_employee_number||fnd_global.local_chr(400)||
1167: p_applicant_number||fnd_global.local_chr(400)||
1168: p_npw_number||fnd_global.local_chr(400)||
1169: p_person_type_id||fnd_global.local_chr(400)||
1170: p_date_of_birth||fnd_global.local_chr(400)||
1171: p_town_of_birth||fnd_global.local_chr(400)||
1172: p_cntry_of_birth||fnd_global.local_chr(400)||
1173: p_date_of_death||fnd_global.local_chr(400)||
1174: p_orig_dt_of_hire||fnd_global.local_chr(400)||

Line 1171: p_town_of_birth||fnd_global.local_chr(400)||

1167: p_applicant_number||fnd_global.local_chr(400)||
1168: p_npw_number||fnd_global.local_chr(400)||
1169: p_person_type_id||fnd_global.local_chr(400)||
1170: p_date_of_birth||fnd_global.local_chr(400)||
1171: p_town_of_birth||fnd_global.local_chr(400)||
1172: p_cntry_of_birth||fnd_global.local_chr(400)||
1173: p_date_of_death||fnd_global.local_chr(400)||
1174: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1175: p_eff_start_date||fnd_global.local_chr(400)||

Line 1172: p_cntry_of_birth||fnd_global.local_chr(400)||

1168: p_npw_number||fnd_global.local_chr(400)||
1169: p_person_type_id||fnd_global.local_chr(400)||
1170: p_date_of_birth||fnd_global.local_chr(400)||
1171: p_town_of_birth||fnd_global.local_chr(400)||
1172: p_cntry_of_birth||fnd_global.local_chr(400)||
1173: p_date_of_death||fnd_global.local_chr(400)||
1174: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1175: p_eff_start_date||fnd_global.local_chr(400)||
1176: p_eff_end_date||fnd_global.local_chr(400)||

Line 1173: p_date_of_death||fnd_global.local_chr(400)||

1169: p_person_type_id||fnd_global.local_chr(400)||
1170: p_date_of_birth||fnd_global.local_chr(400)||
1171: p_town_of_birth||fnd_global.local_chr(400)||
1172: p_cntry_of_birth||fnd_global.local_chr(400)||
1173: p_date_of_death||fnd_global.local_chr(400)||
1174: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1175: p_eff_start_date||fnd_global.local_chr(400)||
1176: p_eff_end_date||fnd_global.local_chr(400)||
1177: p_sex||fnd_global.local_chr(400)||

Line 1174: p_orig_dt_of_hire||fnd_global.local_chr(400)||

1170: p_date_of_birth||fnd_global.local_chr(400)||
1171: p_town_of_birth||fnd_global.local_chr(400)||
1172: p_cntry_of_birth||fnd_global.local_chr(400)||
1173: p_date_of_death||fnd_global.local_chr(400)||
1174: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1175: p_eff_start_date||fnd_global.local_chr(400)||
1176: p_eff_end_date||fnd_global.local_chr(400)||
1177: p_sex||fnd_global.local_chr(400)||
1178: p_full_name||fnd_global.local_chr(400)||

Line 1175: p_eff_start_date||fnd_global.local_chr(400)||

1171: p_town_of_birth||fnd_global.local_chr(400)||
1172: p_cntry_of_birth||fnd_global.local_chr(400)||
1173: p_date_of_death||fnd_global.local_chr(400)||
1174: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1175: p_eff_start_date||fnd_global.local_chr(400)||
1176: p_eff_end_date||fnd_global.local_chr(400)||
1177: p_sex||fnd_global.local_chr(400)||
1178: p_full_name||fnd_global.local_chr(400)||
1179: p_suffix||fnd_global.local_chr(400)||

Line 1176: p_eff_end_date||fnd_global.local_chr(400)||

1172: p_cntry_of_birth||fnd_global.local_chr(400)||
1173: p_date_of_death||fnd_global.local_chr(400)||
1174: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1175: p_eff_start_date||fnd_global.local_chr(400)||
1176: p_eff_end_date||fnd_global.local_chr(400)||
1177: p_sex||fnd_global.local_chr(400)||
1178: p_full_name||fnd_global.local_chr(400)||
1179: p_suffix||fnd_global.local_chr(400)||
1180: p_title||fnd_global.local_chr(400)||

Line 1177: p_sex||fnd_global.local_chr(400)||

1173: p_date_of_death||fnd_global.local_chr(400)||
1174: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1175: p_eff_start_date||fnd_global.local_chr(400)||
1176: p_eff_end_date||fnd_global.local_chr(400)||
1177: p_sex||fnd_global.local_chr(400)||
1178: p_full_name||fnd_global.local_chr(400)||
1179: p_suffix||fnd_global.local_chr(400)||
1180: p_title||fnd_global.local_chr(400)||
1181: p_last_name||fnd_global.local_chr(400)||

Line 1178: p_full_name||fnd_global.local_chr(400)||

1174: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1175: p_eff_start_date||fnd_global.local_chr(400)||
1176: p_eff_end_date||fnd_global.local_chr(400)||
1177: p_sex||fnd_global.local_chr(400)||
1178: p_full_name||fnd_global.local_chr(400)||
1179: p_suffix||fnd_global.local_chr(400)||
1180: p_title||fnd_global.local_chr(400)||
1181: p_last_name||fnd_global.local_chr(400)||
1182: p_first_name||fnd_global.local_chr(400)||

Line 1179: p_suffix||fnd_global.local_chr(400)||

1175: p_eff_start_date||fnd_global.local_chr(400)||
1176: p_eff_end_date||fnd_global.local_chr(400)||
1177: p_sex||fnd_global.local_chr(400)||
1178: p_full_name||fnd_global.local_chr(400)||
1179: p_suffix||fnd_global.local_chr(400)||
1180: p_title||fnd_global.local_chr(400)||
1181: p_last_name||fnd_global.local_chr(400)||
1182: p_first_name||fnd_global.local_chr(400)||
1183: p_middle_names||fnd_global.local_chr(400)||

Line 1180: p_title||fnd_global.local_chr(400)||

1176: p_eff_end_date||fnd_global.local_chr(400)||
1177: p_sex||fnd_global.local_chr(400)||
1178: p_full_name||fnd_global.local_chr(400)||
1179: p_suffix||fnd_global.local_chr(400)||
1180: p_title||fnd_global.local_chr(400)||
1181: p_last_name||fnd_global.local_chr(400)||
1182: p_first_name||fnd_global.local_chr(400)||
1183: p_middle_names||fnd_global.local_chr(400)||
1184: p_nationality||fnd_global.local_chr(400)||

Line 1181: p_last_name||fnd_global.local_chr(400)||

1177: p_sex||fnd_global.local_chr(400)||
1178: p_full_name||fnd_global.local_chr(400)||
1179: p_suffix||fnd_global.local_chr(400)||
1180: p_title||fnd_global.local_chr(400)||
1181: p_last_name||fnd_global.local_chr(400)||
1182: p_first_name||fnd_global.local_chr(400)||
1183: p_middle_names||fnd_global.local_chr(400)||
1184: p_nationality||fnd_global.local_chr(400)||
1185: p_national_identifier||fnd_global.local_chr(400)||

Line 1182: p_first_name||fnd_global.local_chr(400)||

1178: p_full_name||fnd_global.local_chr(400)||
1179: p_suffix||fnd_global.local_chr(400)||
1180: p_title||fnd_global.local_chr(400)||
1181: p_last_name||fnd_global.local_chr(400)||
1182: p_first_name||fnd_global.local_chr(400)||
1183: p_middle_names||fnd_global.local_chr(400)||
1184: p_nationality||fnd_global.local_chr(400)||
1185: p_national_identifier||fnd_global.local_chr(400)||
1186: p_email_address||fnd_global.local_chr(400)||

Line 1183: p_middle_names||fnd_global.local_chr(400)||

1179: p_suffix||fnd_global.local_chr(400)||
1180: p_title||fnd_global.local_chr(400)||
1181: p_last_name||fnd_global.local_chr(400)||
1182: p_first_name||fnd_global.local_chr(400)||
1183: p_middle_names||fnd_global.local_chr(400)||
1184: p_nationality||fnd_global.local_chr(400)||
1185: p_national_identifier||fnd_global.local_chr(400)||
1186: p_email_address||fnd_global.local_chr(400)||
1187: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||

Line 1184: p_nationality||fnd_global.local_chr(400)||

1180: p_title||fnd_global.local_chr(400)||
1181: p_last_name||fnd_global.local_chr(400)||
1182: p_first_name||fnd_global.local_chr(400)||
1183: p_middle_names||fnd_global.local_chr(400)||
1184: p_nationality||fnd_global.local_chr(400)||
1185: p_national_identifier||fnd_global.local_chr(400)||
1186: p_email_address||fnd_global.local_chr(400)||
1187: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1188: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||

Line 1185: p_national_identifier||fnd_global.local_chr(400)||

1181: p_last_name||fnd_global.local_chr(400)||
1182: p_first_name||fnd_global.local_chr(400)||
1183: p_middle_names||fnd_global.local_chr(400)||
1184: p_nationality||fnd_global.local_chr(400)||
1185: p_national_identifier||fnd_global.local_chr(400)||
1186: p_email_address||fnd_global.local_chr(400)||
1187: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1188: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1189: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||

Line 1186: p_email_address||fnd_global.local_chr(400)||

1182: p_first_name||fnd_global.local_chr(400)||
1183: p_middle_names||fnd_global.local_chr(400)||
1184: p_nationality||fnd_global.local_chr(400)||
1185: p_national_identifier||fnd_global.local_chr(400)||
1186: p_email_address||fnd_global.local_chr(400)||
1187: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1188: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1189: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1190: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||

Line 1187: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||

1183: p_middle_names||fnd_global.local_chr(400)||
1184: p_nationality||fnd_global.local_chr(400)||
1185: p_national_identifier||fnd_global.local_chr(400)||
1186: p_email_address||fnd_global.local_chr(400)||
1187: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1188: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1189: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1190: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1191: p_addr_type(k).p_country||fnd_global.local_chr(400)||

Line 1188: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||

1184: p_nationality||fnd_global.local_chr(400)||
1185: p_national_identifier||fnd_global.local_chr(400)||
1186: p_email_address||fnd_global.local_chr(400)||
1187: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1188: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1189: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1190: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1191: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1192: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||

Line 1189: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||

1185: p_national_identifier||fnd_global.local_chr(400)||
1186: p_email_address||fnd_global.local_chr(400)||
1187: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1188: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1189: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1190: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1191: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1192: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1193: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||

Line 1190: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||

1186: p_email_address||fnd_global.local_chr(400)||
1187: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1188: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1189: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1190: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1191: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1192: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1193: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1194: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||

Line 1191: p_addr_type(k).p_country||fnd_global.local_chr(400)||

1187: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1188: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1189: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1190: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1191: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1192: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1193: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1194: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1195: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||

Line 1192: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||

1188: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1189: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1190: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1191: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1192: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1193: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1194: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1195: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1196: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||

Line 1193: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||

1189: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1190: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1191: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1192: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1193: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1194: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1195: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1196: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1197: p_addr_type(k).p_region1||fnd_global.local_chr(400)||

Line 1194: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||

1190: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1191: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1192: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1193: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1194: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1195: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1196: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1197: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1198: p_addr_type(k).p_region2||fnd_global.local_chr(400)||

Line 1195: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||

1191: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1192: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1193: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1194: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1195: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1196: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1197: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1198: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1199: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||

Line 1196: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||

1192: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1193: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1194: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1195: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1196: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1197: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1198: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1199: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1200: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||

Line 1197: p_addr_type(k).p_region1||fnd_global.local_chr(400)||

1193: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1194: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1195: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1196: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1197: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1198: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1199: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1200: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1201: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||

Line 1198: p_addr_type(k).p_region2||fnd_global.local_chr(400)||

1194: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1195: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1196: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1197: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1198: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1199: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1200: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1201: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1202: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||

Line 1199: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||

1195: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1196: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1197: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1198: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1199: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1200: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1201: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1202: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1203: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||

Line 1200: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||

1196: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1197: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1198: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1199: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1200: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1201: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1202: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1203: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1204: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||

Line 1201: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||

1197: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1198: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1199: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1200: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1201: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1202: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1203: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1204: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1205: p_national_id_label||fnd_global.local_chr(400)||

Line 1202: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||

1198: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1199: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1200: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1201: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1202: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1203: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1204: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1205: p_national_id_label||fnd_global.local_chr(400)||
1206: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

Line 1203: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||

1199: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1200: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1201: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1202: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1203: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1204: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1205: p_national_id_label||fnd_global.local_chr(400)||
1206: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1207: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

Line 1204: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||

1200: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1201: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1202: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1203: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1204: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1205: p_national_id_label||fnd_global.local_chr(400)||
1206: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1207: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1208: fnd_global.local_chr(10)||fnd_global.local_chr(13));

Line 1205: p_national_id_label||fnd_global.local_chr(400)||

1201: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1202: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1203: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1204: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1205: p_national_id_label||fnd_global.local_chr(400)||
1206: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1207: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1208: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1209:

Line 1206: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

1202: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1203: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1204: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1205: p_national_id_label||fnd_global.local_chr(400)||
1206: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1207: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1208: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1209:
1210: else

Line 1208: fnd_global.local_chr(10)||fnd_global.local_chr(13));

1204: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1205: p_national_id_label||fnd_global.local_chr(400)||
1206: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1207: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1208: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1209:
1210: else
1211:
1212: UTL_FILE.put_line(l_file_pointer,

Line 1213: p_business_group_id||fnd_global.local_chr(400)||

1209:
1210: else
1211:
1212: UTL_FILE.put_line(l_file_pointer,
1213: p_business_group_id||fnd_global.local_chr(400)||
1214: p_person_id||fnd_global.local_chr(400)||
1215: p_legislation_code||fnd_global.local_chr(400)||
1216: p_employee_number||fnd_global.local_chr(400)||
1217: p_applicant_number||fnd_global.local_chr(400)||

Line 1214: p_person_id||fnd_global.local_chr(400)||

1210: else
1211:
1212: UTL_FILE.put_line(l_file_pointer,
1213: p_business_group_id||fnd_global.local_chr(400)||
1214: p_person_id||fnd_global.local_chr(400)||
1215: p_legislation_code||fnd_global.local_chr(400)||
1216: p_employee_number||fnd_global.local_chr(400)||
1217: p_applicant_number||fnd_global.local_chr(400)||
1218: p_npw_number||fnd_global.local_chr(400)||

Line 1215: p_legislation_code||fnd_global.local_chr(400)||

1211:
1212: UTL_FILE.put_line(l_file_pointer,
1213: p_business_group_id||fnd_global.local_chr(400)||
1214: p_person_id||fnd_global.local_chr(400)||
1215: p_legislation_code||fnd_global.local_chr(400)||
1216: p_employee_number||fnd_global.local_chr(400)||
1217: p_applicant_number||fnd_global.local_chr(400)||
1218: p_npw_number||fnd_global.local_chr(400)||
1219: p_person_type_id||fnd_global.local_chr(400)||

Line 1216: p_employee_number||fnd_global.local_chr(400)||

1212: UTL_FILE.put_line(l_file_pointer,
1213: p_business_group_id||fnd_global.local_chr(400)||
1214: p_person_id||fnd_global.local_chr(400)||
1215: p_legislation_code||fnd_global.local_chr(400)||
1216: p_employee_number||fnd_global.local_chr(400)||
1217: p_applicant_number||fnd_global.local_chr(400)||
1218: p_npw_number||fnd_global.local_chr(400)||
1219: p_person_type_id||fnd_global.local_chr(400)||
1220: p_date_of_birth||fnd_global.local_chr(400)||

Line 1217: p_applicant_number||fnd_global.local_chr(400)||

1213: p_business_group_id||fnd_global.local_chr(400)||
1214: p_person_id||fnd_global.local_chr(400)||
1215: p_legislation_code||fnd_global.local_chr(400)||
1216: p_employee_number||fnd_global.local_chr(400)||
1217: p_applicant_number||fnd_global.local_chr(400)||
1218: p_npw_number||fnd_global.local_chr(400)||
1219: p_person_type_id||fnd_global.local_chr(400)||
1220: p_date_of_birth||fnd_global.local_chr(400)||
1221: p_town_of_birth||fnd_global.local_chr(400)||

Line 1218: p_npw_number||fnd_global.local_chr(400)||

1214: p_person_id||fnd_global.local_chr(400)||
1215: p_legislation_code||fnd_global.local_chr(400)||
1216: p_employee_number||fnd_global.local_chr(400)||
1217: p_applicant_number||fnd_global.local_chr(400)||
1218: p_npw_number||fnd_global.local_chr(400)||
1219: p_person_type_id||fnd_global.local_chr(400)||
1220: p_date_of_birth||fnd_global.local_chr(400)||
1221: p_town_of_birth||fnd_global.local_chr(400)||
1222: p_cntry_of_birth||fnd_global.local_chr(400)||

Line 1219: p_person_type_id||fnd_global.local_chr(400)||

1215: p_legislation_code||fnd_global.local_chr(400)||
1216: p_employee_number||fnd_global.local_chr(400)||
1217: p_applicant_number||fnd_global.local_chr(400)||
1218: p_npw_number||fnd_global.local_chr(400)||
1219: p_person_type_id||fnd_global.local_chr(400)||
1220: p_date_of_birth||fnd_global.local_chr(400)||
1221: p_town_of_birth||fnd_global.local_chr(400)||
1222: p_cntry_of_birth||fnd_global.local_chr(400)||
1223: p_date_of_death||fnd_global.local_chr(400)||

Line 1220: p_date_of_birth||fnd_global.local_chr(400)||

1216: p_employee_number||fnd_global.local_chr(400)||
1217: p_applicant_number||fnd_global.local_chr(400)||
1218: p_npw_number||fnd_global.local_chr(400)||
1219: p_person_type_id||fnd_global.local_chr(400)||
1220: p_date_of_birth||fnd_global.local_chr(400)||
1221: p_town_of_birth||fnd_global.local_chr(400)||
1222: p_cntry_of_birth||fnd_global.local_chr(400)||
1223: p_date_of_death||fnd_global.local_chr(400)||
1224: p_orig_dt_of_hire||fnd_global.local_chr(400)||

Line 1221: p_town_of_birth||fnd_global.local_chr(400)||

1217: p_applicant_number||fnd_global.local_chr(400)||
1218: p_npw_number||fnd_global.local_chr(400)||
1219: p_person_type_id||fnd_global.local_chr(400)||
1220: p_date_of_birth||fnd_global.local_chr(400)||
1221: p_town_of_birth||fnd_global.local_chr(400)||
1222: p_cntry_of_birth||fnd_global.local_chr(400)||
1223: p_date_of_death||fnd_global.local_chr(400)||
1224: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1225: p_eff_start_date||fnd_global.local_chr(400)||

Line 1222: p_cntry_of_birth||fnd_global.local_chr(400)||

1218: p_npw_number||fnd_global.local_chr(400)||
1219: p_person_type_id||fnd_global.local_chr(400)||
1220: p_date_of_birth||fnd_global.local_chr(400)||
1221: p_town_of_birth||fnd_global.local_chr(400)||
1222: p_cntry_of_birth||fnd_global.local_chr(400)||
1223: p_date_of_death||fnd_global.local_chr(400)||
1224: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1225: p_eff_start_date||fnd_global.local_chr(400)||
1226: p_eff_end_date||fnd_global.local_chr(400)||

Line 1223: p_date_of_death||fnd_global.local_chr(400)||

1219: p_person_type_id||fnd_global.local_chr(400)||
1220: p_date_of_birth||fnd_global.local_chr(400)||
1221: p_town_of_birth||fnd_global.local_chr(400)||
1222: p_cntry_of_birth||fnd_global.local_chr(400)||
1223: p_date_of_death||fnd_global.local_chr(400)||
1224: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1225: p_eff_start_date||fnd_global.local_chr(400)||
1226: p_eff_end_date||fnd_global.local_chr(400)||
1227: p_sex||fnd_global.local_chr(400)||

Line 1224: p_orig_dt_of_hire||fnd_global.local_chr(400)||

1220: p_date_of_birth||fnd_global.local_chr(400)||
1221: p_town_of_birth||fnd_global.local_chr(400)||
1222: p_cntry_of_birth||fnd_global.local_chr(400)||
1223: p_date_of_death||fnd_global.local_chr(400)||
1224: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1225: p_eff_start_date||fnd_global.local_chr(400)||
1226: p_eff_end_date||fnd_global.local_chr(400)||
1227: p_sex||fnd_global.local_chr(400)||
1228: p_full_name||fnd_global.local_chr(400)||

Line 1225: p_eff_start_date||fnd_global.local_chr(400)||

1221: p_town_of_birth||fnd_global.local_chr(400)||
1222: p_cntry_of_birth||fnd_global.local_chr(400)||
1223: p_date_of_death||fnd_global.local_chr(400)||
1224: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1225: p_eff_start_date||fnd_global.local_chr(400)||
1226: p_eff_end_date||fnd_global.local_chr(400)||
1227: p_sex||fnd_global.local_chr(400)||
1228: p_full_name||fnd_global.local_chr(400)||
1229: p_suffix||fnd_global.local_chr(400)||

Line 1226: p_eff_end_date||fnd_global.local_chr(400)||

1222: p_cntry_of_birth||fnd_global.local_chr(400)||
1223: p_date_of_death||fnd_global.local_chr(400)||
1224: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1225: p_eff_start_date||fnd_global.local_chr(400)||
1226: p_eff_end_date||fnd_global.local_chr(400)||
1227: p_sex||fnd_global.local_chr(400)||
1228: p_full_name||fnd_global.local_chr(400)||
1229: p_suffix||fnd_global.local_chr(400)||
1230: p_title||fnd_global.local_chr(400)||

Line 1227: p_sex||fnd_global.local_chr(400)||

1223: p_date_of_death||fnd_global.local_chr(400)||
1224: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1225: p_eff_start_date||fnd_global.local_chr(400)||
1226: p_eff_end_date||fnd_global.local_chr(400)||
1227: p_sex||fnd_global.local_chr(400)||
1228: p_full_name||fnd_global.local_chr(400)||
1229: p_suffix||fnd_global.local_chr(400)||
1230: p_title||fnd_global.local_chr(400)||
1231: p_last_name||fnd_global.local_chr(400)||

Line 1228: p_full_name||fnd_global.local_chr(400)||

1224: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1225: p_eff_start_date||fnd_global.local_chr(400)||
1226: p_eff_end_date||fnd_global.local_chr(400)||
1227: p_sex||fnd_global.local_chr(400)||
1228: p_full_name||fnd_global.local_chr(400)||
1229: p_suffix||fnd_global.local_chr(400)||
1230: p_title||fnd_global.local_chr(400)||
1231: p_last_name||fnd_global.local_chr(400)||
1232: p_first_name||fnd_global.local_chr(400)||

Line 1229: p_suffix||fnd_global.local_chr(400)||

1225: p_eff_start_date||fnd_global.local_chr(400)||
1226: p_eff_end_date||fnd_global.local_chr(400)||
1227: p_sex||fnd_global.local_chr(400)||
1228: p_full_name||fnd_global.local_chr(400)||
1229: p_suffix||fnd_global.local_chr(400)||
1230: p_title||fnd_global.local_chr(400)||
1231: p_last_name||fnd_global.local_chr(400)||
1232: p_first_name||fnd_global.local_chr(400)||
1233: p_middle_names||fnd_global.local_chr(400)||

Line 1230: p_title||fnd_global.local_chr(400)||

1226: p_eff_end_date||fnd_global.local_chr(400)||
1227: p_sex||fnd_global.local_chr(400)||
1228: p_full_name||fnd_global.local_chr(400)||
1229: p_suffix||fnd_global.local_chr(400)||
1230: p_title||fnd_global.local_chr(400)||
1231: p_last_name||fnd_global.local_chr(400)||
1232: p_first_name||fnd_global.local_chr(400)||
1233: p_middle_names||fnd_global.local_chr(400)||
1234: p_nationality||fnd_global.local_chr(400)||

Line 1231: p_last_name||fnd_global.local_chr(400)||

1227: p_sex||fnd_global.local_chr(400)||
1228: p_full_name||fnd_global.local_chr(400)||
1229: p_suffix||fnd_global.local_chr(400)||
1230: p_title||fnd_global.local_chr(400)||
1231: p_last_name||fnd_global.local_chr(400)||
1232: p_first_name||fnd_global.local_chr(400)||
1233: p_middle_names||fnd_global.local_chr(400)||
1234: p_nationality||fnd_global.local_chr(400)||
1235: p_national_identifier||fnd_global.local_chr(400)||

Line 1232: p_first_name||fnd_global.local_chr(400)||

1228: p_full_name||fnd_global.local_chr(400)||
1229: p_suffix||fnd_global.local_chr(400)||
1230: p_title||fnd_global.local_chr(400)||
1231: p_last_name||fnd_global.local_chr(400)||
1232: p_first_name||fnd_global.local_chr(400)||
1233: p_middle_names||fnd_global.local_chr(400)||
1234: p_nationality||fnd_global.local_chr(400)||
1235: p_national_identifier||fnd_global.local_chr(400)||
1236: p_email_address||fnd_global.local_chr(400)||

Line 1233: p_middle_names||fnd_global.local_chr(400)||

1229: p_suffix||fnd_global.local_chr(400)||
1230: p_title||fnd_global.local_chr(400)||
1231: p_last_name||fnd_global.local_chr(400)||
1232: p_first_name||fnd_global.local_chr(400)||
1233: p_middle_names||fnd_global.local_chr(400)||
1234: p_nationality||fnd_global.local_chr(400)||
1235: p_national_identifier||fnd_global.local_chr(400)||
1236: p_email_address||fnd_global.local_chr(400)||
1237: fnd_global.local_chr(400)||

Line 1234: p_nationality||fnd_global.local_chr(400)||

1230: p_title||fnd_global.local_chr(400)||
1231: p_last_name||fnd_global.local_chr(400)||
1232: p_first_name||fnd_global.local_chr(400)||
1233: p_middle_names||fnd_global.local_chr(400)||
1234: p_nationality||fnd_global.local_chr(400)||
1235: p_national_identifier||fnd_global.local_chr(400)||
1236: p_email_address||fnd_global.local_chr(400)||
1237: fnd_global.local_chr(400)||
1238: fnd_global.local_chr(400)||

Line 1235: p_national_identifier||fnd_global.local_chr(400)||

1231: p_last_name||fnd_global.local_chr(400)||
1232: p_first_name||fnd_global.local_chr(400)||
1233: p_middle_names||fnd_global.local_chr(400)||
1234: p_nationality||fnd_global.local_chr(400)||
1235: p_national_identifier||fnd_global.local_chr(400)||
1236: p_email_address||fnd_global.local_chr(400)||
1237: fnd_global.local_chr(400)||
1238: fnd_global.local_chr(400)||
1239: fnd_global.local_chr(400)||

Line 1236: p_email_address||fnd_global.local_chr(400)||

1232: p_first_name||fnd_global.local_chr(400)||
1233: p_middle_names||fnd_global.local_chr(400)||
1234: p_nationality||fnd_global.local_chr(400)||
1235: p_national_identifier||fnd_global.local_chr(400)||
1236: p_email_address||fnd_global.local_chr(400)||
1237: fnd_global.local_chr(400)||
1238: fnd_global.local_chr(400)||
1239: fnd_global.local_chr(400)||
1240: fnd_global.local_chr(400)||

Line 1237: fnd_global.local_chr(400)||

1233: p_middle_names||fnd_global.local_chr(400)||
1234: p_nationality||fnd_global.local_chr(400)||
1235: p_national_identifier||fnd_global.local_chr(400)||
1236: p_email_address||fnd_global.local_chr(400)||
1237: fnd_global.local_chr(400)||
1238: fnd_global.local_chr(400)||
1239: fnd_global.local_chr(400)||
1240: fnd_global.local_chr(400)||
1241: fnd_global.local_chr(400)||

Line 1238: fnd_global.local_chr(400)||

1234: p_nationality||fnd_global.local_chr(400)||
1235: p_national_identifier||fnd_global.local_chr(400)||
1236: p_email_address||fnd_global.local_chr(400)||
1237: fnd_global.local_chr(400)||
1238: fnd_global.local_chr(400)||
1239: fnd_global.local_chr(400)||
1240: fnd_global.local_chr(400)||
1241: fnd_global.local_chr(400)||
1242: fnd_global.local_chr(400)||

Line 1239: fnd_global.local_chr(400)||

1235: p_national_identifier||fnd_global.local_chr(400)||
1236: p_email_address||fnd_global.local_chr(400)||
1237: fnd_global.local_chr(400)||
1238: fnd_global.local_chr(400)||
1239: fnd_global.local_chr(400)||
1240: fnd_global.local_chr(400)||
1241: fnd_global.local_chr(400)||
1242: fnd_global.local_chr(400)||
1243: fnd_global.local_chr(400)||

Line 1240: fnd_global.local_chr(400)||

1236: p_email_address||fnd_global.local_chr(400)||
1237: fnd_global.local_chr(400)||
1238: fnd_global.local_chr(400)||
1239: fnd_global.local_chr(400)||
1240: fnd_global.local_chr(400)||
1241: fnd_global.local_chr(400)||
1242: fnd_global.local_chr(400)||
1243: fnd_global.local_chr(400)||
1244: fnd_global.local_chr(400)||

Line 1241: fnd_global.local_chr(400)||

1237: fnd_global.local_chr(400)||
1238: fnd_global.local_chr(400)||
1239: fnd_global.local_chr(400)||
1240: fnd_global.local_chr(400)||
1241: fnd_global.local_chr(400)||
1242: fnd_global.local_chr(400)||
1243: fnd_global.local_chr(400)||
1244: fnd_global.local_chr(400)||
1245: fnd_global.local_chr(400)||

Line 1242: fnd_global.local_chr(400)||

1238: fnd_global.local_chr(400)||
1239: fnd_global.local_chr(400)||
1240: fnd_global.local_chr(400)||
1241: fnd_global.local_chr(400)||
1242: fnd_global.local_chr(400)||
1243: fnd_global.local_chr(400)||
1244: fnd_global.local_chr(400)||
1245: fnd_global.local_chr(400)||
1246: fnd_global.local_chr(400)||

Line 1243: fnd_global.local_chr(400)||

1239: fnd_global.local_chr(400)||
1240: fnd_global.local_chr(400)||
1241: fnd_global.local_chr(400)||
1242: fnd_global.local_chr(400)||
1243: fnd_global.local_chr(400)||
1244: fnd_global.local_chr(400)||
1245: fnd_global.local_chr(400)||
1246: fnd_global.local_chr(400)||
1247: fnd_global.local_chr(400)||

Line 1244: fnd_global.local_chr(400)||

1240: fnd_global.local_chr(400)||
1241: fnd_global.local_chr(400)||
1242: fnd_global.local_chr(400)||
1243: fnd_global.local_chr(400)||
1244: fnd_global.local_chr(400)||
1245: fnd_global.local_chr(400)||
1246: fnd_global.local_chr(400)||
1247: fnd_global.local_chr(400)||
1248: fnd_global.local_chr(400)||

Line 1245: fnd_global.local_chr(400)||

1241: fnd_global.local_chr(400)||
1242: fnd_global.local_chr(400)||
1243: fnd_global.local_chr(400)||
1244: fnd_global.local_chr(400)||
1245: fnd_global.local_chr(400)||
1246: fnd_global.local_chr(400)||
1247: fnd_global.local_chr(400)||
1248: fnd_global.local_chr(400)||
1249: fnd_global.local_chr(400)||

Line 1246: fnd_global.local_chr(400)||

1242: fnd_global.local_chr(400)||
1243: fnd_global.local_chr(400)||
1244: fnd_global.local_chr(400)||
1245: fnd_global.local_chr(400)||
1246: fnd_global.local_chr(400)||
1247: fnd_global.local_chr(400)||
1248: fnd_global.local_chr(400)||
1249: fnd_global.local_chr(400)||
1250: fnd_global.local_chr(400)||

Line 1247: fnd_global.local_chr(400)||

1243: fnd_global.local_chr(400)||
1244: fnd_global.local_chr(400)||
1245: fnd_global.local_chr(400)||
1246: fnd_global.local_chr(400)||
1247: fnd_global.local_chr(400)||
1248: fnd_global.local_chr(400)||
1249: fnd_global.local_chr(400)||
1250: fnd_global.local_chr(400)||
1251: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||

Line 1248: fnd_global.local_chr(400)||

1244: fnd_global.local_chr(400)||
1245: fnd_global.local_chr(400)||
1246: fnd_global.local_chr(400)||
1247: fnd_global.local_chr(400)||
1248: fnd_global.local_chr(400)||
1249: fnd_global.local_chr(400)||
1250: fnd_global.local_chr(400)||
1251: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1252: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||

Line 1249: fnd_global.local_chr(400)||

1245: fnd_global.local_chr(400)||
1246: fnd_global.local_chr(400)||
1247: fnd_global.local_chr(400)||
1248: fnd_global.local_chr(400)||
1249: fnd_global.local_chr(400)||
1250: fnd_global.local_chr(400)||
1251: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1252: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1253: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||

Line 1250: fnd_global.local_chr(400)||

1246: fnd_global.local_chr(400)||
1247: fnd_global.local_chr(400)||
1248: fnd_global.local_chr(400)||
1249: fnd_global.local_chr(400)||
1250: fnd_global.local_chr(400)||
1251: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1252: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1253: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1254: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||

Line 1251: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||

1247: fnd_global.local_chr(400)||
1248: fnd_global.local_chr(400)||
1249: fnd_global.local_chr(400)||
1250: fnd_global.local_chr(400)||
1251: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1252: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1253: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1254: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1255: p_national_id_label||fnd_global.local_chr(400)||

Line 1252: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||

1248: fnd_global.local_chr(400)||
1249: fnd_global.local_chr(400)||
1250: fnd_global.local_chr(400)||
1251: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1252: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1253: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1254: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1255: p_national_id_label||fnd_global.local_chr(400)||
1256: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

Line 1253: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||

1249: fnd_global.local_chr(400)||
1250: fnd_global.local_chr(400)||
1251: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1252: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1253: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1254: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1255: p_national_id_label||fnd_global.local_chr(400)||
1256: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1257: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

Line 1254: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||

1250: fnd_global.local_chr(400)||
1251: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1252: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1253: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1254: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1255: p_national_id_label||fnd_global.local_chr(400)||
1256: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1257: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1258: fnd_global.local_chr(10)||fnd_global.local_chr(13));

Line 1255: p_national_id_label||fnd_global.local_chr(400)||

1251: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1252: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1253: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1254: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1255: p_national_id_label||fnd_global.local_chr(400)||
1256: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1257: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1258: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1259: end if;

Line 1256: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

1252: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1253: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1254: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1255: p_national_id_label||fnd_global.local_chr(400)||
1256: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1257: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1258: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1259: end if;
1260: end loop;

Line 1258: fnd_global.local_chr(10)||fnd_global.local_chr(13));

1254: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1255: p_national_id_label||fnd_global.local_chr(400)||
1256: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1257: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1258: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1259: end if;
1260: end loop;
1261: end if;
1262:

Line 1269: p_business_group_id||fnd_global.local_chr(400)||

1265: for k in p_phn_type.first .. p_phn_type.last
1266: loop
1267:
1268: UTL_FILE.put_line(l_file_pointer,
1269: p_business_group_id||fnd_global.local_chr(400)||
1270: p_person_id||fnd_global.local_chr(400)||
1271: p_legislation_code||fnd_global.local_chr(400)||
1272: p_employee_number||fnd_global.local_chr(400)||
1273: p_applicant_number||fnd_global.local_chr(400)||

Line 1270: p_person_id||fnd_global.local_chr(400)||

1266: loop
1267:
1268: UTL_FILE.put_line(l_file_pointer,
1269: p_business_group_id||fnd_global.local_chr(400)||
1270: p_person_id||fnd_global.local_chr(400)||
1271: p_legislation_code||fnd_global.local_chr(400)||
1272: p_employee_number||fnd_global.local_chr(400)||
1273: p_applicant_number||fnd_global.local_chr(400)||
1274: p_npw_number||fnd_global.local_chr(400)||

Line 1271: p_legislation_code||fnd_global.local_chr(400)||

1267:
1268: UTL_FILE.put_line(l_file_pointer,
1269: p_business_group_id||fnd_global.local_chr(400)||
1270: p_person_id||fnd_global.local_chr(400)||
1271: p_legislation_code||fnd_global.local_chr(400)||
1272: p_employee_number||fnd_global.local_chr(400)||
1273: p_applicant_number||fnd_global.local_chr(400)||
1274: p_npw_number||fnd_global.local_chr(400)||
1275: p_person_type_id||fnd_global.local_chr(400)||

Line 1272: p_employee_number||fnd_global.local_chr(400)||

1268: UTL_FILE.put_line(l_file_pointer,
1269: p_business_group_id||fnd_global.local_chr(400)||
1270: p_person_id||fnd_global.local_chr(400)||
1271: p_legislation_code||fnd_global.local_chr(400)||
1272: p_employee_number||fnd_global.local_chr(400)||
1273: p_applicant_number||fnd_global.local_chr(400)||
1274: p_npw_number||fnd_global.local_chr(400)||
1275: p_person_type_id||fnd_global.local_chr(400)||
1276: p_date_of_birth||fnd_global.local_chr(400)||

Line 1273: p_applicant_number||fnd_global.local_chr(400)||

1269: p_business_group_id||fnd_global.local_chr(400)||
1270: p_person_id||fnd_global.local_chr(400)||
1271: p_legislation_code||fnd_global.local_chr(400)||
1272: p_employee_number||fnd_global.local_chr(400)||
1273: p_applicant_number||fnd_global.local_chr(400)||
1274: p_npw_number||fnd_global.local_chr(400)||
1275: p_person_type_id||fnd_global.local_chr(400)||
1276: p_date_of_birth||fnd_global.local_chr(400)||
1277: p_town_of_birth||fnd_global.local_chr(400)||

Line 1274: p_npw_number||fnd_global.local_chr(400)||

1270: p_person_id||fnd_global.local_chr(400)||
1271: p_legislation_code||fnd_global.local_chr(400)||
1272: p_employee_number||fnd_global.local_chr(400)||
1273: p_applicant_number||fnd_global.local_chr(400)||
1274: p_npw_number||fnd_global.local_chr(400)||
1275: p_person_type_id||fnd_global.local_chr(400)||
1276: p_date_of_birth||fnd_global.local_chr(400)||
1277: p_town_of_birth||fnd_global.local_chr(400)||
1278: p_cntry_of_birth||fnd_global.local_chr(400)||

Line 1275: p_person_type_id||fnd_global.local_chr(400)||

1271: p_legislation_code||fnd_global.local_chr(400)||
1272: p_employee_number||fnd_global.local_chr(400)||
1273: p_applicant_number||fnd_global.local_chr(400)||
1274: p_npw_number||fnd_global.local_chr(400)||
1275: p_person_type_id||fnd_global.local_chr(400)||
1276: p_date_of_birth||fnd_global.local_chr(400)||
1277: p_town_of_birth||fnd_global.local_chr(400)||
1278: p_cntry_of_birth||fnd_global.local_chr(400)||
1279: p_date_of_death||fnd_global.local_chr(400)||

Line 1276: p_date_of_birth||fnd_global.local_chr(400)||

1272: p_employee_number||fnd_global.local_chr(400)||
1273: p_applicant_number||fnd_global.local_chr(400)||
1274: p_npw_number||fnd_global.local_chr(400)||
1275: p_person_type_id||fnd_global.local_chr(400)||
1276: p_date_of_birth||fnd_global.local_chr(400)||
1277: p_town_of_birth||fnd_global.local_chr(400)||
1278: p_cntry_of_birth||fnd_global.local_chr(400)||
1279: p_date_of_death||fnd_global.local_chr(400)||
1280: p_orig_dt_of_hire||fnd_global.local_chr(400)||

Line 1277: p_town_of_birth||fnd_global.local_chr(400)||

1273: p_applicant_number||fnd_global.local_chr(400)||
1274: p_npw_number||fnd_global.local_chr(400)||
1275: p_person_type_id||fnd_global.local_chr(400)||
1276: p_date_of_birth||fnd_global.local_chr(400)||
1277: p_town_of_birth||fnd_global.local_chr(400)||
1278: p_cntry_of_birth||fnd_global.local_chr(400)||
1279: p_date_of_death||fnd_global.local_chr(400)||
1280: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1281: p_eff_start_date||fnd_global.local_chr(400)||

Line 1278: p_cntry_of_birth||fnd_global.local_chr(400)||

1274: p_npw_number||fnd_global.local_chr(400)||
1275: p_person_type_id||fnd_global.local_chr(400)||
1276: p_date_of_birth||fnd_global.local_chr(400)||
1277: p_town_of_birth||fnd_global.local_chr(400)||
1278: p_cntry_of_birth||fnd_global.local_chr(400)||
1279: p_date_of_death||fnd_global.local_chr(400)||
1280: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1281: p_eff_start_date||fnd_global.local_chr(400)||
1282: p_eff_end_date||fnd_global.local_chr(400)||

Line 1279: p_date_of_death||fnd_global.local_chr(400)||

1275: p_person_type_id||fnd_global.local_chr(400)||
1276: p_date_of_birth||fnd_global.local_chr(400)||
1277: p_town_of_birth||fnd_global.local_chr(400)||
1278: p_cntry_of_birth||fnd_global.local_chr(400)||
1279: p_date_of_death||fnd_global.local_chr(400)||
1280: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1281: p_eff_start_date||fnd_global.local_chr(400)||
1282: p_eff_end_date||fnd_global.local_chr(400)||
1283: p_sex||fnd_global.local_chr(400)||

Line 1280: p_orig_dt_of_hire||fnd_global.local_chr(400)||

1276: p_date_of_birth||fnd_global.local_chr(400)||
1277: p_town_of_birth||fnd_global.local_chr(400)||
1278: p_cntry_of_birth||fnd_global.local_chr(400)||
1279: p_date_of_death||fnd_global.local_chr(400)||
1280: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1281: p_eff_start_date||fnd_global.local_chr(400)||
1282: p_eff_end_date||fnd_global.local_chr(400)||
1283: p_sex||fnd_global.local_chr(400)||
1284: p_full_name||fnd_global.local_chr(400)||

Line 1281: p_eff_start_date||fnd_global.local_chr(400)||

1277: p_town_of_birth||fnd_global.local_chr(400)||
1278: p_cntry_of_birth||fnd_global.local_chr(400)||
1279: p_date_of_death||fnd_global.local_chr(400)||
1280: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1281: p_eff_start_date||fnd_global.local_chr(400)||
1282: p_eff_end_date||fnd_global.local_chr(400)||
1283: p_sex||fnd_global.local_chr(400)||
1284: p_full_name||fnd_global.local_chr(400)||
1285: p_suffix||fnd_global.local_chr(400)||

Line 1282: p_eff_end_date||fnd_global.local_chr(400)||

1278: p_cntry_of_birth||fnd_global.local_chr(400)||
1279: p_date_of_death||fnd_global.local_chr(400)||
1280: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1281: p_eff_start_date||fnd_global.local_chr(400)||
1282: p_eff_end_date||fnd_global.local_chr(400)||
1283: p_sex||fnd_global.local_chr(400)||
1284: p_full_name||fnd_global.local_chr(400)||
1285: p_suffix||fnd_global.local_chr(400)||
1286: p_title||fnd_global.local_chr(400)||

Line 1283: p_sex||fnd_global.local_chr(400)||

1279: p_date_of_death||fnd_global.local_chr(400)||
1280: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1281: p_eff_start_date||fnd_global.local_chr(400)||
1282: p_eff_end_date||fnd_global.local_chr(400)||
1283: p_sex||fnd_global.local_chr(400)||
1284: p_full_name||fnd_global.local_chr(400)||
1285: p_suffix||fnd_global.local_chr(400)||
1286: p_title||fnd_global.local_chr(400)||
1287: p_last_name||fnd_global.local_chr(400)||

Line 1284: p_full_name||fnd_global.local_chr(400)||

1280: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1281: p_eff_start_date||fnd_global.local_chr(400)||
1282: p_eff_end_date||fnd_global.local_chr(400)||
1283: p_sex||fnd_global.local_chr(400)||
1284: p_full_name||fnd_global.local_chr(400)||
1285: p_suffix||fnd_global.local_chr(400)||
1286: p_title||fnd_global.local_chr(400)||
1287: p_last_name||fnd_global.local_chr(400)||
1288: p_first_name||fnd_global.local_chr(400)||

Line 1285: p_suffix||fnd_global.local_chr(400)||

1281: p_eff_start_date||fnd_global.local_chr(400)||
1282: p_eff_end_date||fnd_global.local_chr(400)||
1283: p_sex||fnd_global.local_chr(400)||
1284: p_full_name||fnd_global.local_chr(400)||
1285: p_suffix||fnd_global.local_chr(400)||
1286: p_title||fnd_global.local_chr(400)||
1287: p_last_name||fnd_global.local_chr(400)||
1288: p_first_name||fnd_global.local_chr(400)||
1289: p_middle_names||fnd_global.local_chr(400)||

Line 1286: p_title||fnd_global.local_chr(400)||

1282: p_eff_end_date||fnd_global.local_chr(400)||
1283: p_sex||fnd_global.local_chr(400)||
1284: p_full_name||fnd_global.local_chr(400)||
1285: p_suffix||fnd_global.local_chr(400)||
1286: p_title||fnd_global.local_chr(400)||
1287: p_last_name||fnd_global.local_chr(400)||
1288: p_first_name||fnd_global.local_chr(400)||
1289: p_middle_names||fnd_global.local_chr(400)||
1290: p_nationality||fnd_global.local_chr(400)||

Line 1287: p_last_name||fnd_global.local_chr(400)||

1283: p_sex||fnd_global.local_chr(400)||
1284: p_full_name||fnd_global.local_chr(400)||
1285: p_suffix||fnd_global.local_chr(400)||
1286: p_title||fnd_global.local_chr(400)||
1287: p_last_name||fnd_global.local_chr(400)||
1288: p_first_name||fnd_global.local_chr(400)||
1289: p_middle_names||fnd_global.local_chr(400)||
1290: p_nationality||fnd_global.local_chr(400)||
1291: p_national_identifier||fnd_global.local_chr(400)||

Line 1288: p_first_name||fnd_global.local_chr(400)||

1284: p_full_name||fnd_global.local_chr(400)||
1285: p_suffix||fnd_global.local_chr(400)||
1286: p_title||fnd_global.local_chr(400)||
1287: p_last_name||fnd_global.local_chr(400)||
1288: p_first_name||fnd_global.local_chr(400)||
1289: p_middle_names||fnd_global.local_chr(400)||
1290: p_nationality||fnd_global.local_chr(400)||
1291: p_national_identifier||fnd_global.local_chr(400)||
1292: p_email_address||fnd_global.local_chr(400)||

Line 1289: p_middle_names||fnd_global.local_chr(400)||

1285: p_suffix||fnd_global.local_chr(400)||
1286: p_title||fnd_global.local_chr(400)||
1287: p_last_name||fnd_global.local_chr(400)||
1288: p_first_name||fnd_global.local_chr(400)||
1289: p_middle_names||fnd_global.local_chr(400)||
1290: p_nationality||fnd_global.local_chr(400)||
1291: p_national_identifier||fnd_global.local_chr(400)||
1292: p_email_address||fnd_global.local_chr(400)||
1293: fnd_global.local_chr(400)||

Line 1290: p_nationality||fnd_global.local_chr(400)||

1286: p_title||fnd_global.local_chr(400)||
1287: p_last_name||fnd_global.local_chr(400)||
1288: p_first_name||fnd_global.local_chr(400)||
1289: p_middle_names||fnd_global.local_chr(400)||
1290: p_nationality||fnd_global.local_chr(400)||
1291: p_national_identifier||fnd_global.local_chr(400)||
1292: p_email_address||fnd_global.local_chr(400)||
1293: fnd_global.local_chr(400)||
1294: fnd_global.local_chr(400)||

Line 1291: p_national_identifier||fnd_global.local_chr(400)||

1287: p_last_name||fnd_global.local_chr(400)||
1288: p_first_name||fnd_global.local_chr(400)||
1289: p_middle_names||fnd_global.local_chr(400)||
1290: p_nationality||fnd_global.local_chr(400)||
1291: p_national_identifier||fnd_global.local_chr(400)||
1292: p_email_address||fnd_global.local_chr(400)||
1293: fnd_global.local_chr(400)||
1294: fnd_global.local_chr(400)||
1295: fnd_global.local_chr(400)||

Line 1292: p_email_address||fnd_global.local_chr(400)||

1288: p_first_name||fnd_global.local_chr(400)||
1289: p_middle_names||fnd_global.local_chr(400)||
1290: p_nationality||fnd_global.local_chr(400)||
1291: p_national_identifier||fnd_global.local_chr(400)||
1292: p_email_address||fnd_global.local_chr(400)||
1293: fnd_global.local_chr(400)||
1294: fnd_global.local_chr(400)||
1295: fnd_global.local_chr(400)||
1296: fnd_global.local_chr(400)||

Line 1293: fnd_global.local_chr(400)||

1289: p_middle_names||fnd_global.local_chr(400)||
1290: p_nationality||fnd_global.local_chr(400)||
1291: p_national_identifier||fnd_global.local_chr(400)||
1292: p_email_address||fnd_global.local_chr(400)||
1293: fnd_global.local_chr(400)||
1294: fnd_global.local_chr(400)||
1295: fnd_global.local_chr(400)||
1296: fnd_global.local_chr(400)||
1297: fnd_global.local_chr(400)||

Line 1294: fnd_global.local_chr(400)||

1290: p_nationality||fnd_global.local_chr(400)||
1291: p_national_identifier||fnd_global.local_chr(400)||
1292: p_email_address||fnd_global.local_chr(400)||
1293: fnd_global.local_chr(400)||
1294: fnd_global.local_chr(400)||
1295: fnd_global.local_chr(400)||
1296: fnd_global.local_chr(400)||
1297: fnd_global.local_chr(400)||
1298: fnd_global.local_chr(400)||

Line 1295: fnd_global.local_chr(400)||

1291: p_national_identifier||fnd_global.local_chr(400)||
1292: p_email_address||fnd_global.local_chr(400)||
1293: fnd_global.local_chr(400)||
1294: fnd_global.local_chr(400)||
1295: fnd_global.local_chr(400)||
1296: fnd_global.local_chr(400)||
1297: fnd_global.local_chr(400)||
1298: fnd_global.local_chr(400)||
1299: fnd_global.local_chr(400)||

Line 1296: fnd_global.local_chr(400)||

1292: p_email_address||fnd_global.local_chr(400)||
1293: fnd_global.local_chr(400)||
1294: fnd_global.local_chr(400)||
1295: fnd_global.local_chr(400)||
1296: fnd_global.local_chr(400)||
1297: fnd_global.local_chr(400)||
1298: fnd_global.local_chr(400)||
1299: fnd_global.local_chr(400)||
1300: fnd_global.local_chr(400)||

Line 1297: fnd_global.local_chr(400)||

1293: fnd_global.local_chr(400)||
1294: fnd_global.local_chr(400)||
1295: fnd_global.local_chr(400)||
1296: fnd_global.local_chr(400)||
1297: fnd_global.local_chr(400)||
1298: fnd_global.local_chr(400)||
1299: fnd_global.local_chr(400)||
1300: fnd_global.local_chr(400)||
1301: fnd_global.local_chr(400)||

Line 1298: fnd_global.local_chr(400)||

1294: fnd_global.local_chr(400)||
1295: fnd_global.local_chr(400)||
1296: fnd_global.local_chr(400)||
1297: fnd_global.local_chr(400)||
1298: fnd_global.local_chr(400)||
1299: fnd_global.local_chr(400)||
1300: fnd_global.local_chr(400)||
1301: fnd_global.local_chr(400)||
1302: fnd_global.local_chr(400)||

Line 1299: fnd_global.local_chr(400)||

1295: fnd_global.local_chr(400)||
1296: fnd_global.local_chr(400)||
1297: fnd_global.local_chr(400)||
1298: fnd_global.local_chr(400)||
1299: fnd_global.local_chr(400)||
1300: fnd_global.local_chr(400)||
1301: fnd_global.local_chr(400)||
1302: fnd_global.local_chr(400)||
1303: fnd_global.local_chr(400)||

Line 1300: fnd_global.local_chr(400)||

1296: fnd_global.local_chr(400)||
1297: fnd_global.local_chr(400)||
1298: fnd_global.local_chr(400)||
1299: fnd_global.local_chr(400)||
1300: fnd_global.local_chr(400)||
1301: fnd_global.local_chr(400)||
1302: fnd_global.local_chr(400)||
1303: fnd_global.local_chr(400)||
1304: fnd_global.local_chr(400)||

Line 1301: fnd_global.local_chr(400)||

1297: fnd_global.local_chr(400)||
1298: fnd_global.local_chr(400)||
1299: fnd_global.local_chr(400)||
1300: fnd_global.local_chr(400)||
1301: fnd_global.local_chr(400)||
1302: fnd_global.local_chr(400)||
1303: fnd_global.local_chr(400)||
1304: fnd_global.local_chr(400)||
1305: fnd_global.local_chr(400)||

Line 1302: fnd_global.local_chr(400)||

1298: fnd_global.local_chr(400)||
1299: fnd_global.local_chr(400)||
1300: fnd_global.local_chr(400)||
1301: fnd_global.local_chr(400)||
1302: fnd_global.local_chr(400)||
1303: fnd_global.local_chr(400)||
1304: fnd_global.local_chr(400)||
1305: fnd_global.local_chr(400)||
1306: fnd_global.local_chr(400)||

Line 1303: fnd_global.local_chr(400)||

1299: fnd_global.local_chr(400)||
1300: fnd_global.local_chr(400)||
1301: fnd_global.local_chr(400)||
1302: fnd_global.local_chr(400)||
1303: fnd_global.local_chr(400)||
1304: fnd_global.local_chr(400)||
1305: fnd_global.local_chr(400)||
1306: fnd_global.local_chr(400)||
1307: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||

Line 1304: fnd_global.local_chr(400)||

1300: fnd_global.local_chr(400)||
1301: fnd_global.local_chr(400)||
1302: fnd_global.local_chr(400)||
1303: fnd_global.local_chr(400)||
1304: fnd_global.local_chr(400)||
1305: fnd_global.local_chr(400)||
1306: fnd_global.local_chr(400)||
1307: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1308: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||

Line 1305: fnd_global.local_chr(400)||

1301: fnd_global.local_chr(400)||
1302: fnd_global.local_chr(400)||
1303: fnd_global.local_chr(400)||
1304: fnd_global.local_chr(400)||
1305: fnd_global.local_chr(400)||
1306: fnd_global.local_chr(400)||
1307: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1308: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1309: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||

Line 1306: fnd_global.local_chr(400)||

1302: fnd_global.local_chr(400)||
1303: fnd_global.local_chr(400)||
1304: fnd_global.local_chr(400)||
1305: fnd_global.local_chr(400)||
1306: fnd_global.local_chr(400)||
1307: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1308: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1309: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1310: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||

Line 1307: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||

1303: fnd_global.local_chr(400)||
1304: fnd_global.local_chr(400)||
1305: fnd_global.local_chr(400)||
1306: fnd_global.local_chr(400)||
1307: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1308: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1309: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1310: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1311: p_national_id_label||fnd_global.local_chr(400)||

Line 1308: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||

1304: fnd_global.local_chr(400)||
1305: fnd_global.local_chr(400)||
1306: fnd_global.local_chr(400)||
1307: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1308: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1309: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1310: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1311: p_national_id_label||fnd_global.local_chr(400)||
1312: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

Line 1309: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||

1305: fnd_global.local_chr(400)||
1306: fnd_global.local_chr(400)||
1307: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1308: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1309: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1310: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1311: p_national_id_label||fnd_global.local_chr(400)||
1312: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1313: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

Line 1310: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||

1306: fnd_global.local_chr(400)||
1307: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1308: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1309: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1310: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1311: p_national_id_label||fnd_global.local_chr(400)||
1312: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1313: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1314: fnd_global.local_chr(10)||fnd_global.local_chr(13));

Line 1311: p_national_id_label||fnd_global.local_chr(400)||

1307: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
1308: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1309: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1310: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1311: p_national_id_label||fnd_global.local_chr(400)||
1312: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1313: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1314: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1315:

Line 1312: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

1308: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1309: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1310: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1311: p_national_id_label||fnd_global.local_chr(400)||
1312: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1313: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1314: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1315:
1316: end loop;

Line 1314: fnd_global.local_chr(10)||fnd_global.local_chr(13));

1310: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1311: p_national_id_label||fnd_global.local_chr(400)||
1312: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1313: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1314: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1315:
1316: end loop;
1317: end if;
1318:

Line 1325: p_business_group_id||fnd_global.local_chr(400)||

1321: for k in p_addr_type.first .. p_addr_type.last
1322: loop
1323:
1324: UTL_FILE.put_line(l_file_pointer,
1325: p_business_group_id||fnd_global.local_chr(400)||
1326: p_person_id||fnd_global.local_chr(400)||
1327: p_legislation_code||fnd_global.local_chr(400)||
1328: p_employee_number||fnd_global.local_chr(400)||
1329: p_applicant_number||fnd_global.local_chr(400)||

Line 1326: p_person_id||fnd_global.local_chr(400)||

1322: loop
1323:
1324: UTL_FILE.put_line(l_file_pointer,
1325: p_business_group_id||fnd_global.local_chr(400)||
1326: p_person_id||fnd_global.local_chr(400)||
1327: p_legislation_code||fnd_global.local_chr(400)||
1328: p_employee_number||fnd_global.local_chr(400)||
1329: p_applicant_number||fnd_global.local_chr(400)||
1330: p_npw_number||fnd_global.local_chr(400)||

Line 1327: p_legislation_code||fnd_global.local_chr(400)||

1323:
1324: UTL_FILE.put_line(l_file_pointer,
1325: p_business_group_id||fnd_global.local_chr(400)||
1326: p_person_id||fnd_global.local_chr(400)||
1327: p_legislation_code||fnd_global.local_chr(400)||
1328: p_employee_number||fnd_global.local_chr(400)||
1329: p_applicant_number||fnd_global.local_chr(400)||
1330: p_npw_number||fnd_global.local_chr(400)||
1331: p_person_type_id||fnd_global.local_chr(400)||

Line 1328: p_employee_number||fnd_global.local_chr(400)||

1324: UTL_FILE.put_line(l_file_pointer,
1325: p_business_group_id||fnd_global.local_chr(400)||
1326: p_person_id||fnd_global.local_chr(400)||
1327: p_legislation_code||fnd_global.local_chr(400)||
1328: p_employee_number||fnd_global.local_chr(400)||
1329: p_applicant_number||fnd_global.local_chr(400)||
1330: p_npw_number||fnd_global.local_chr(400)||
1331: p_person_type_id||fnd_global.local_chr(400)||
1332: p_date_of_birth||fnd_global.local_chr(400)||

Line 1329: p_applicant_number||fnd_global.local_chr(400)||

1325: p_business_group_id||fnd_global.local_chr(400)||
1326: p_person_id||fnd_global.local_chr(400)||
1327: p_legislation_code||fnd_global.local_chr(400)||
1328: p_employee_number||fnd_global.local_chr(400)||
1329: p_applicant_number||fnd_global.local_chr(400)||
1330: p_npw_number||fnd_global.local_chr(400)||
1331: p_person_type_id||fnd_global.local_chr(400)||
1332: p_date_of_birth||fnd_global.local_chr(400)||
1333: p_town_of_birth||fnd_global.local_chr(400)||

Line 1330: p_npw_number||fnd_global.local_chr(400)||

1326: p_person_id||fnd_global.local_chr(400)||
1327: p_legislation_code||fnd_global.local_chr(400)||
1328: p_employee_number||fnd_global.local_chr(400)||
1329: p_applicant_number||fnd_global.local_chr(400)||
1330: p_npw_number||fnd_global.local_chr(400)||
1331: p_person_type_id||fnd_global.local_chr(400)||
1332: p_date_of_birth||fnd_global.local_chr(400)||
1333: p_town_of_birth||fnd_global.local_chr(400)||
1334: p_cntry_of_birth||fnd_global.local_chr(400)||

Line 1331: p_person_type_id||fnd_global.local_chr(400)||

1327: p_legislation_code||fnd_global.local_chr(400)||
1328: p_employee_number||fnd_global.local_chr(400)||
1329: p_applicant_number||fnd_global.local_chr(400)||
1330: p_npw_number||fnd_global.local_chr(400)||
1331: p_person_type_id||fnd_global.local_chr(400)||
1332: p_date_of_birth||fnd_global.local_chr(400)||
1333: p_town_of_birth||fnd_global.local_chr(400)||
1334: p_cntry_of_birth||fnd_global.local_chr(400)||
1335: p_date_of_death||fnd_global.local_chr(400)||

Line 1332: p_date_of_birth||fnd_global.local_chr(400)||

1328: p_employee_number||fnd_global.local_chr(400)||
1329: p_applicant_number||fnd_global.local_chr(400)||
1330: p_npw_number||fnd_global.local_chr(400)||
1331: p_person_type_id||fnd_global.local_chr(400)||
1332: p_date_of_birth||fnd_global.local_chr(400)||
1333: p_town_of_birth||fnd_global.local_chr(400)||
1334: p_cntry_of_birth||fnd_global.local_chr(400)||
1335: p_date_of_death||fnd_global.local_chr(400)||
1336: p_orig_dt_of_hire||fnd_global.local_chr(400)||

Line 1333: p_town_of_birth||fnd_global.local_chr(400)||

1329: p_applicant_number||fnd_global.local_chr(400)||
1330: p_npw_number||fnd_global.local_chr(400)||
1331: p_person_type_id||fnd_global.local_chr(400)||
1332: p_date_of_birth||fnd_global.local_chr(400)||
1333: p_town_of_birth||fnd_global.local_chr(400)||
1334: p_cntry_of_birth||fnd_global.local_chr(400)||
1335: p_date_of_death||fnd_global.local_chr(400)||
1336: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1337: p_eff_start_date||fnd_global.local_chr(400)||

Line 1334: p_cntry_of_birth||fnd_global.local_chr(400)||

1330: p_npw_number||fnd_global.local_chr(400)||
1331: p_person_type_id||fnd_global.local_chr(400)||
1332: p_date_of_birth||fnd_global.local_chr(400)||
1333: p_town_of_birth||fnd_global.local_chr(400)||
1334: p_cntry_of_birth||fnd_global.local_chr(400)||
1335: p_date_of_death||fnd_global.local_chr(400)||
1336: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1337: p_eff_start_date||fnd_global.local_chr(400)||
1338: p_eff_end_date||fnd_global.local_chr(400)||

Line 1335: p_date_of_death||fnd_global.local_chr(400)||

1331: p_person_type_id||fnd_global.local_chr(400)||
1332: p_date_of_birth||fnd_global.local_chr(400)||
1333: p_town_of_birth||fnd_global.local_chr(400)||
1334: p_cntry_of_birth||fnd_global.local_chr(400)||
1335: p_date_of_death||fnd_global.local_chr(400)||
1336: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1337: p_eff_start_date||fnd_global.local_chr(400)||
1338: p_eff_end_date||fnd_global.local_chr(400)||
1339: p_sex||fnd_global.local_chr(400)||

Line 1336: p_orig_dt_of_hire||fnd_global.local_chr(400)||

1332: p_date_of_birth||fnd_global.local_chr(400)||
1333: p_town_of_birth||fnd_global.local_chr(400)||
1334: p_cntry_of_birth||fnd_global.local_chr(400)||
1335: p_date_of_death||fnd_global.local_chr(400)||
1336: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1337: p_eff_start_date||fnd_global.local_chr(400)||
1338: p_eff_end_date||fnd_global.local_chr(400)||
1339: p_sex||fnd_global.local_chr(400)||
1340: p_full_name||fnd_global.local_chr(400)||

Line 1337: p_eff_start_date||fnd_global.local_chr(400)||

1333: p_town_of_birth||fnd_global.local_chr(400)||
1334: p_cntry_of_birth||fnd_global.local_chr(400)||
1335: p_date_of_death||fnd_global.local_chr(400)||
1336: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1337: p_eff_start_date||fnd_global.local_chr(400)||
1338: p_eff_end_date||fnd_global.local_chr(400)||
1339: p_sex||fnd_global.local_chr(400)||
1340: p_full_name||fnd_global.local_chr(400)||
1341: p_suffix||fnd_global.local_chr(400)||

Line 1338: p_eff_end_date||fnd_global.local_chr(400)||

1334: p_cntry_of_birth||fnd_global.local_chr(400)||
1335: p_date_of_death||fnd_global.local_chr(400)||
1336: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1337: p_eff_start_date||fnd_global.local_chr(400)||
1338: p_eff_end_date||fnd_global.local_chr(400)||
1339: p_sex||fnd_global.local_chr(400)||
1340: p_full_name||fnd_global.local_chr(400)||
1341: p_suffix||fnd_global.local_chr(400)||
1342: p_title||fnd_global.local_chr(400)||

Line 1339: p_sex||fnd_global.local_chr(400)||

1335: p_date_of_death||fnd_global.local_chr(400)||
1336: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1337: p_eff_start_date||fnd_global.local_chr(400)||
1338: p_eff_end_date||fnd_global.local_chr(400)||
1339: p_sex||fnd_global.local_chr(400)||
1340: p_full_name||fnd_global.local_chr(400)||
1341: p_suffix||fnd_global.local_chr(400)||
1342: p_title||fnd_global.local_chr(400)||
1343: p_last_name||fnd_global.local_chr(400)||

Line 1340: p_full_name||fnd_global.local_chr(400)||

1336: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1337: p_eff_start_date||fnd_global.local_chr(400)||
1338: p_eff_end_date||fnd_global.local_chr(400)||
1339: p_sex||fnd_global.local_chr(400)||
1340: p_full_name||fnd_global.local_chr(400)||
1341: p_suffix||fnd_global.local_chr(400)||
1342: p_title||fnd_global.local_chr(400)||
1343: p_last_name||fnd_global.local_chr(400)||
1344: p_first_name||fnd_global.local_chr(400)||

Line 1341: p_suffix||fnd_global.local_chr(400)||

1337: p_eff_start_date||fnd_global.local_chr(400)||
1338: p_eff_end_date||fnd_global.local_chr(400)||
1339: p_sex||fnd_global.local_chr(400)||
1340: p_full_name||fnd_global.local_chr(400)||
1341: p_suffix||fnd_global.local_chr(400)||
1342: p_title||fnd_global.local_chr(400)||
1343: p_last_name||fnd_global.local_chr(400)||
1344: p_first_name||fnd_global.local_chr(400)||
1345: p_middle_names||fnd_global.local_chr(400)||

Line 1342: p_title||fnd_global.local_chr(400)||

1338: p_eff_end_date||fnd_global.local_chr(400)||
1339: p_sex||fnd_global.local_chr(400)||
1340: p_full_name||fnd_global.local_chr(400)||
1341: p_suffix||fnd_global.local_chr(400)||
1342: p_title||fnd_global.local_chr(400)||
1343: p_last_name||fnd_global.local_chr(400)||
1344: p_first_name||fnd_global.local_chr(400)||
1345: p_middle_names||fnd_global.local_chr(400)||
1346: p_nationality||fnd_global.local_chr(400)||

Line 1343: p_last_name||fnd_global.local_chr(400)||

1339: p_sex||fnd_global.local_chr(400)||
1340: p_full_name||fnd_global.local_chr(400)||
1341: p_suffix||fnd_global.local_chr(400)||
1342: p_title||fnd_global.local_chr(400)||
1343: p_last_name||fnd_global.local_chr(400)||
1344: p_first_name||fnd_global.local_chr(400)||
1345: p_middle_names||fnd_global.local_chr(400)||
1346: p_nationality||fnd_global.local_chr(400)||
1347: p_national_identifier||fnd_global.local_chr(400)||

Line 1344: p_first_name||fnd_global.local_chr(400)||

1340: p_full_name||fnd_global.local_chr(400)||
1341: p_suffix||fnd_global.local_chr(400)||
1342: p_title||fnd_global.local_chr(400)||
1343: p_last_name||fnd_global.local_chr(400)||
1344: p_first_name||fnd_global.local_chr(400)||
1345: p_middle_names||fnd_global.local_chr(400)||
1346: p_nationality||fnd_global.local_chr(400)||
1347: p_national_identifier||fnd_global.local_chr(400)||
1348: p_email_address||fnd_global.local_chr(400)||

Line 1345: p_middle_names||fnd_global.local_chr(400)||

1341: p_suffix||fnd_global.local_chr(400)||
1342: p_title||fnd_global.local_chr(400)||
1343: p_last_name||fnd_global.local_chr(400)||
1344: p_first_name||fnd_global.local_chr(400)||
1345: p_middle_names||fnd_global.local_chr(400)||
1346: p_nationality||fnd_global.local_chr(400)||
1347: p_national_identifier||fnd_global.local_chr(400)||
1348: p_email_address||fnd_global.local_chr(400)||
1349: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||

Line 1346: p_nationality||fnd_global.local_chr(400)||

1342: p_title||fnd_global.local_chr(400)||
1343: p_last_name||fnd_global.local_chr(400)||
1344: p_first_name||fnd_global.local_chr(400)||
1345: p_middle_names||fnd_global.local_chr(400)||
1346: p_nationality||fnd_global.local_chr(400)||
1347: p_national_identifier||fnd_global.local_chr(400)||
1348: p_email_address||fnd_global.local_chr(400)||
1349: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1350: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||

Line 1347: p_national_identifier||fnd_global.local_chr(400)||

1343: p_last_name||fnd_global.local_chr(400)||
1344: p_first_name||fnd_global.local_chr(400)||
1345: p_middle_names||fnd_global.local_chr(400)||
1346: p_nationality||fnd_global.local_chr(400)||
1347: p_national_identifier||fnd_global.local_chr(400)||
1348: p_email_address||fnd_global.local_chr(400)||
1349: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1350: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1351: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||

Line 1348: p_email_address||fnd_global.local_chr(400)||

1344: p_first_name||fnd_global.local_chr(400)||
1345: p_middle_names||fnd_global.local_chr(400)||
1346: p_nationality||fnd_global.local_chr(400)||
1347: p_national_identifier||fnd_global.local_chr(400)||
1348: p_email_address||fnd_global.local_chr(400)||
1349: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1350: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1351: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1352: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||

Line 1349: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||

1345: p_middle_names||fnd_global.local_chr(400)||
1346: p_nationality||fnd_global.local_chr(400)||
1347: p_national_identifier||fnd_global.local_chr(400)||
1348: p_email_address||fnd_global.local_chr(400)||
1349: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1350: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1351: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1352: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1353: p_addr_type(k).p_country||fnd_global.local_chr(400)||

Line 1350: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||

1346: p_nationality||fnd_global.local_chr(400)||
1347: p_national_identifier||fnd_global.local_chr(400)||
1348: p_email_address||fnd_global.local_chr(400)||
1349: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1350: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1351: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1352: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1353: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1354: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||

Line 1351: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||

1347: p_national_identifier||fnd_global.local_chr(400)||
1348: p_email_address||fnd_global.local_chr(400)||
1349: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1350: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1351: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1352: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1353: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1354: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1355: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||

Line 1352: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||

1348: p_email_address||fnd_global.local_chr(400)||
1349: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1350: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1351: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1352: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1353: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1354: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1355: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1356: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||

Line 1353: p_addr_type(k).p_country||fnd_global.local_chr(400)||

1349: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
1350: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1351: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1352: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1353: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1354: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1355: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1356: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1357: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||

Line 1354: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||

1350: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
1351: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1352: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1353: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1354: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1355: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1356: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1357: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1358: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||

Line 1355: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||

1351: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
1352: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1353: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1354: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1355: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1356: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1357: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1358: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1359: p_addr_type(k).p_region1||fnd_global.local_chr(400)||

Line 1356: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||

1352: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
1353: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1354: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1355: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1356: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1357: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1358: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1359: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1360: p_addr_type(k).p_region2||fnd_global.local_chr(400)||

Line 1357: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||

1353: p_addr_type(k).p_country||fnd_global.local_chr(400)||
1354: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1355: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1356: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1357: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1358: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1359: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1360: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1361: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||

Line 1358: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||

1354: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
1355: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1356: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1357: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1358: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1359: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1360: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1361: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1362: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||

Line 1359: p_addr_type(k).p_region1||fnd_global.local_chr(400)||

1355: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
1356: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1357: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1358: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1359: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1360: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1361: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1362: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1363: fnd_global.local_chr(400)||

Line 1360: p_addr_type(k).p_region2||fnd_global.local_chr(400)||

1356: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
1357: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1358: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1359: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1360: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1361: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1362: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1363: fnd_global.local_chr(400)||
1364: fnd_global.local_chr(400)||

Line 1361: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||

1357: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
1358: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1359: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1360: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1361: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1362: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1363: fnd_global.local_chr(400)||
1364: fnd_global.local_chr(400)||
1365: fnd_global.local_chr(400)||

Line 1362: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||

1358: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
1359: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1360: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1361: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1362: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1363: fnd_global.local_chr(400)||
1364: fnd_global.local_chr(400)||
1365: fnd_global.local_chr(400)||
1366: fnd_global.local_chr(400)||

Line 1363: fnd_global.local_chr(400)||

1359: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
1360: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1361: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1362: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1363: fnd_global.local_chr(400)||
1364: fnd_global.local_chr(400)||
1365: fnd_global.local_chr(400)||
1366: fnd_global.local_chr(400)||
1367: p_national_id_label||fnd_global.local_chr(400)||

Line 1364: fnd_global.local_chr(400)||

1360: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
1361: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1362: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1363: fnd_global.local_chr(400)||
1364: fnd_global.local_chr(400)||
1365: fnd_global.local_chr(400)||
1366: fnd_global.local_chr(400)||
1367: p_national_id_label||fnd_global.local_chr(400)||
1368: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

Line 1365: fnd_global.local_chr(400)||

1361: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
1362: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1363: fnd_global.local_chr(400)||
1364: fnd_global.local_chr(400)||
1365: fnd_global.local_chr(400)||
1366: fnd_global.local_chr(400)||
1367: p_national_id_label||fnd_global.local_chr(400)||
1368: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1369: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

Line 1366: fnd_global.local_chr(400)||

1362: p_addr_type(k).p_primary_flag ||fnd_global.local_chr(400)||
1363: fnd_global.local_chr(400)||
1364: fnd_global.local_chr(400)||
1365: fnd_global.local_chr(400)||
1366: fnd_global.local_chr(400)||
1367: p_national_id_label||fnd_global.local_chr(400)||
1368: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1369: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1370: fnd_global.local_chr(10)||fnd_global.local_chr(13));

Line 1367: p_national_id_label||fnd_global.local_chr(400)||

1363: fnd_global.local_chr(400)||
1364: fnd_global.local_chr(400)||
1365: fnd_global.local_chr(400)||
1366: fnd_global.local_chr(400)||
1367: p_national_id_label||fnd_global.local_chr(400)||
1368: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1369: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1370: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1371:

Line 1368: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

1364: fnd_global.local_chr(400)||
1365: fnd_global.local_chr(400)||
1366: fnd_global.local_chr(400)||
1367: p_national_id_label||fnd_global.local_chr(400)||
1368: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1369: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1370: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1371:
1372: end loop;

Line 1370: fnd_global.local_chr(10)||fnd_global.local_chr(13));

1366: fnd_global.local_chr(400)||
1367: p_national_id_label||fnd_global.local_chr(400)||
1368: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1369: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1370: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1371:
1372: end loop;
1373: end if;
1374:

Line 1381: p_business_group_id||fnd_global.local_chr(400)||

1377: then
1378:
1379:
1380: UTL_FILE.put_line(l_file_pointer,
1381: p_business_group_id||fnd_global.local_chr(400)||
1382: p_person_id||fnd_global.local_chr(400)||
1383: p_legislation_code||fnd_global.local_chr(400)||
1384: p_employee_number||fnd_global.local_chr(400)||
1385: p_applicant_number||fnd_global.local_chr(400)||

Line 1382: p_person_id||fnd_global.local_chr(400)||

1378:
1379:
1380: UTL_FILE.put_line(l_file_pointer,
1381: p_business_group_id||fnd_global.local_chr(400)||
1382: p_person_id||fnd_global.local_chr(400)||
1383: p_legislation_code||fnd_global.local_chr(400)||
1384: p_employee_number||fnd_global.local_chr(400)||
1385: p_applicant_number||fnd_global.local_chr(400)||
1386: p_npw_number||fnd_global.local_chr(400)||

Line 1383: p_legislation_code||fnd_global.local_chr(400)||

1379:
1380: UTL_FILE.put_line(l_file_pointer,
1381: p_business_group_id||fnd_global.local_chr(400)||
1382: p_person_id||fnd_global.local_chr(400)||
1383: p_legislation_code||fnd_global.local_chr(400)||
1384: p_employee_number||fnd_global.local_chr(400)||
1385: p_applicant_number||fnd_global.local_chr(400)||
1386: p_npw_number||fnd_global.local_chr(400)||
1387: p_person_type_id||fnd_global.local_chr(400)||

Line 1384: p_employee_number||fnd_global.local_chr(400)||

1380: UTL_FILE.put_line(l_file_pointer,
1381: p_business_group_id||fnd_global.local_chr(400)||
1382: p_person_id||fnd_global.local_chr(400)||
1383: p_legislation_code||fnd_global.local_chr(400)||
1384: p_employee_number||fnd_global.local_chr(400)||
1385: p_applicant_number||fnd_global.local_chr(400)||
1386: p_npw_number||fnd_global.local_chr(400)||
1387: p_person_type_id||fnd_global.local_chr(400)||
1388: p_date_of_birth||fnd_global.local_chr(400)||

Line 1385: p_applicant_number||fnd_global.local_chr(400)||

1381: p_business_group_id||fnd_global.local_chr(400)||
1382: p_person_id||fnd_global.local_chr(400)||
1383: p_legislation_code||fnd_global.local_chr(400)||
1384: p_employee_number||fnd_global.local_chr(400)||
1385: p_applicant_number||fnd_global.local_chr(400)||
1386: p_npw_number||fnd_global.local_chr(400)||
1387: p_person_type_id||fnd_global.local_chr(400)||
1388: p_date_of_birth||fnd_global.local_chr(400)||
1389: p_town_of_birth||fnd_global.local_chr(400)||

Line 1386: p_npw_number||fnd_global.local_chr(400)||

1382: p_person_id||fnd_global.local_chr(400)||
1383: p_legislation_code||fnd_global.local_chr(400)||
1384: p_employee_number||fnd_global.local_chr(400)||
1385: p_applicant_number||fnd_global.local_chr(400)||
1386: p_npw_number||fnd_global.local_chr(400)||
1387: p_person_type_id||fnd_global.local_chr(400)||
1388: p_date_of_birth||fnd_global.local_chr(400)||
1389: p_town_of_birth||fnd_global.local_chr(400)||
1390: p_cntry_of_birth||fnd_global.local_chr(400)||

Line 1387: p_person_type_id||fnd_global.local_chr(400)||

1383: p_legislation_code||fnd_global.local_chr(400)||
1384: p_employee_number||fnd_global.local_chr(400)||
1385: p_applicant_number||fnd_global.local_chr(400)||
1386: p_npw_number||fnd_global.local_chr(400)||
1387: p_person_type_id||fnd_global.local_chr(400)||
1388: p_date_of_birth||fnd_global.local_chr(400)||
1389: p_town_of_birth||fnd_global.local_chr(400)||
1390: p_cntry_of_birth||fnd_global.local_chr(400)||
1391: p_date_of_death||fnd_global.local_chr(400)||

Line 1388: p_date_of_birth||fnd_global.local_chr(400)||

1384: p_employee_number||fnd_global.local_chr(400)||
1385: p_applicant_number||fnd_global.local_chr(400)||
1386: p_npw_number||fnd_global.local_chr(400)||
1387: p_person_type_id||fnd_global.local_chr(400)||
1388: p_date_of_birth||fnd_global.local_chr(400)||
1389: p_town_of_birth||fnd_global.local_chr(400)||
1390: p_cntry_of_birth||fnd_global.local_chr(400)||
1391: p_date_of_death||fnd_global.local_chr(400)||
1392: p_orig_dt_of_hire||fnd_global.local_chr(400)||

Line 1389: p_town_of_birth||fnd_global.local_chr(400)||

1385: p_applicant_number||fnd_global.local_chr(400)||
1386: p_npw_number||fnd_global.local_chr(400)||
1387: p_person_type_id||fnd_global.local_chr(400)||
1388: p_date_of_birth||fnd_global.local_chr(400)||
1389: p_town_of_birth||fnd_global.local_chr(400)||
1390: p_cntry_of_birth||fnd_global.local_chr(400)||
1391: p_date_of_death||fnd_global.local_chr(400)||
1392: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1393: p_eff_start_date||fnd_global.local_chr(400)||

Line 1390: p_cntry_of_birth||fnd_global.local_chr(400)||

1386: p_npw_number||fnd_global.local_chr(400)||
1387: p_person_type_id||fnd_global.local_chr(400)||
1388: p_date_of_birth||fnd_global.local_chr(400)||
1389: p_town_of_birth||fnd_global.local_chr(400)||
1390: p_cntry_of_birth||fnd_global.local_chr(400)||
1391: p_date_of_death||fnd_global.local_chr(400)||
1392: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1393: p_eff_start_date||fnd_global.local_chr(400)||
1394: p_eff_end_date||fnd_global.local_chr(400)||

Line 1391: p_date_of_death||fnd_global.local_chr(400)||

1387: p_person_type_id||fnd_global.local_chr(400)||
1388: p_date_of_birth||fnd_global.local_chr(400)||
1389: p_town_of_birth||fnd_global.local_chr(400)||
1390: p_cntry_of_birth||fnd_global.local_chr(400)||
1391: p_date_of_death||fnd_global.local_chr(400)||
1392: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1393: p_eff_start_date||fnd_global.local_chr(400)||
1394: p_eff_end_date||fnd_global.local_chr(400)||
1395: p_sex||fnd_global.local_chr(400)||

Line 1392: p_orig_dt_of_hire||fnd_global.local_chr(400)||

1388: p_date_of_birth||fnd_global.local_chr(400)||
1389: p_town_of_birth||fnd_global.local_chr(400)||
1390: p_cntry_of_birth||fnd_global.local_chr(400)||
1391: p_date_of_death||fnd_global.local_chr(400)||
1392: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1393: p_eff_start_date||fnd_global.local_chr(400)||
1394: p_eff_end_date||fnd_global.local_chr(400)||
1395: p_sex||fnd_global.local_chr(400)||
1396: p_full_name||fnd_global.local_chr(400)||

Line 1393: p_eff_start_date||fnd_global.local_chr(400)||

1389: p_town_of_birth||fnd_global.local_chr(400)||
1390: p_cntry_of_birth||fnd_global.local_chr(400)||
1391: p_date_of_death||fnd_global.local_chr(400)||
1392: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1393: p_eff_start_date||fnd_global.local_chr(400)||
1394: p_eff_end_date||fnd_global.local_chr(400)||
1395: p_sex||fnd_global.local_chr(400)||
1396: p_full_name||fnd_global.local_chr(400)||
1397: p_suffix||fnd_global.local_chr(400)||

Line 1394: p_eff_end_date||fnd_global.local_chr(400)||

1390: p_cntry_of_birth||fnd_global.local_chr(400)||
1391: p_date_of_death||fnd_global.local_chr(400)||
1392: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1393: p_eff_start_date||fnd_global.local_chr(400)||
1394: p_eff_end_date||fnd_global.local_chr(400)||
1395: p_sex||fnd_global.local_chr(400)||
1396: p_full_name||fnd_global.local_chr(400)||
1397: p_suffix||fnd_global.local_chr(400)||
1398: p_title||fnd_global.local_chr(400)||

Line 1395: p_sex||fnd_global.local_chr(400)||

1391: p_date_of_death||fnd_global.local_chr(400)||
1392: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1393: p_eff_start_date||fnd_global.local_chr(400)||
1394: p_eff_end_date||fnd_global.local_chr(400)||
1395: p_sex||fnd_global.local_chr(400)||
1396: p_full_name||fnd_global.local_chr(400)||
1397: p_suffix||fnd_global.local_chr(400)||
1398: p_title||fnd_global.local_chr(400)||
1399: p_last_name||fnd_global.local_chr(400)||

Line 1396: p_full_name||fnd_global.local_chr(400)||

1392: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1393: p_eff_start_date||fnd_global.local_chr(400)||
1394: p_eff_end_date||fnd_global.local_chr(400)||
1395: p_sex||fnd_global.local_chr(400)||
1396: p_full_name||fnd_global.local_chr(400)||
1397: p_suffix||fnd_global.local_chr(400)||
1398: p_title||fnd_global.local_chr(400)||
1399: p_last_name||fnd_global.local_chr(400)||
1400: p_first_name||fnd_global.local_chr(400)||

Line 1397: p_suffix||fnd_global.local_chr(400)||

1393: p_eff_start_date||fnd_global.local_chr(400)||
1394: p_eff_end_date||fnd_global.local_chr(400)||
1395: p_sex||fnd_global.local_chr(400)||
1396: p_full_name||fnd_global.local_chr(400)||
1397: p_suffix||fnd_global.local_chr(400)||
1398: p_title||fnd_global.local_chr(400)||
1399: p_last_name||fnd_global.local_chr(400)||
1400: p_first_name||fnd_global.local_chr(400)||
1401: p_middle_names||fnd_global.local_chr(400)||

Line 1398: p_title||fnd_global.local_chr(400)||

1394: p_eff_end_date||fnd_global.local_chr(400)||
1395: p_sex||fnd_global.local_chr(400)||
1396: p_full_name||fnd_global.local_chr(400)||
1397: p_suffix||fnd_global.local_chr(400)||
1398: p_title||fnd_global.local_chr(400)||
1399: p_last_name||fnd_global.local_chr(400)||
1400: p_first_name||fnd_global.local_chr(400)||
1401: p_middle_names||fnd_global.local_chr(400)||
1402: p_nationality||fnd_global.local_chr(400)||

Line 1399: p_last_name||fnd_global.local_chr(400)||

1395: p_sex||fnd_global.local_chr(400)||
1396: p_full_name||fnd_global.local_chr(400)||
1397: p_suffix||fnd_global.local_chr(400)||
1398: p_title||fnd_global.local_chr(400)||
1399: p_last_name||fnd_global.local_chr(400)||
1400: p_first_name||fnd_global.local_chr(400)||
1401: p_middle_names||fnd_global.local_chr(400)||
1402: p_nationality||fnd_global.local_chr(400)||
1403: p_national_identifier||fnd_global.local_chr(400)||

Line 1400: p_first_name||fnd_global.local_chr(400)||

1396: p_full_name||fnd_global.local_chr(400)||
1397: p_suffix||fnd_global.local_chr(400)||
1398: p_title||fnd_global.local_chr(400)||
1399: p_last_name||fnd_global.local_chr(400)||
1400: p_first_name||fnd_global.local_chr(400)||
1401: p_middle_names||fnd_global.local_chr(400)||
1402: p_nationality||fnd_global.local_chr(400)||
1403: p_national_identifier||fnd_global.local_chr(400)||
1404: p_email_address||fnd_global.local_chr(400)||

Line 1401: p_middle_names||fnd_global.local_chr(400)||

1397: p_suffix||fnd_global.local_chr(400)||
1398: p_title||fnd_global.local_chr(400)||
1399: p_last_name||fnd_global.local_chr(400)||
1400: p_first_name||fnd_global.local_chr(400)||
1401: p_middle_names||fnd_global.local_chr(400)||
1402: p_nationality||fnd_global.local_chr(400)||
1403: p_national_identifier||fnd_global.local_chr(400)||
1404: p_email_address||fnd_global.local_chr(400)||
1405: fnd_global.local_chr(400)||

Line 1402: p_nationality||fnd_global.local_chr(400)||

1398: p_title||fnd_global.local_chr(400)||
1399: p_last_name||fnd_global.local_chr(400)||
1400: p_first_name||fnd_global.local_chr(400)||
1401: p_middle_names||fnd_global.local_chr(400)||
1402: p_nationality||fnd_global.local_chr(400)||
1403: p_national_identifier||fnd_global.local_chr(400)||
1404: p_email_address||fnd_global.local_chr(400)||
1405: fnd_global.local_chr(400)||
1406: fnd_global.local_chr(400)||

Line 1403: p_national_identifier||fnd_global.local_chr(400)||

1399: p_last_name||fnd_global.local_chr(400)||
1400: p_first_name||fnd_global.local_chr(400)||
1401: p_middle_names||fnd_global.local_chr(400)||
1402: p_nationality||fnd_global.local_chr(400)||
1403: p_national_identifier||fnd_global.local_chr(400)||
1404: p_email_address||fnd_global.local_chr(400)||
1405: fnd_global.local_chr(400)||
1406: fnd_global.local_chr(400)||
1407: fnd_global.local_chr(400)||

Line 1404: p_email_address||fnd_global.local_chr(400)||

1400: p_first_name||fnd_global.local_chr(400)||
1401: p_middle_names||fnd_global.local_chr(400)||
1402: p_nationality||fnd_global.local_chr(400)||
1403: p_national_identifier||fnd_global.local_chr(400)||
1404: p_email_address||fnd_global.local_chr(400)||
1405: fnd_global.local_chr(400)||
1406: fnd_global.local_chr(400)||
1407: fnd_global.local_chr(400)||
1408: fnd_global.local_chr(400)||

Line 1405: fnd_global.local_chr(400)||

1401: p_middle_names||fnd_global.local_chr(400)||
1402: p_nationality||fnd_global.local_chr(400)||
1403: p_national_identifier||fnd_global.local_chr(400)||
1404: p_email_address||fnd_global.local_chr(400)||
1405: fnd_global.local_chr(400)||
1406: fnd_global.local_chr(400)||
1407: fnd_global.local_chr(400)||
1408: fnd_global.local_chr(400)||
1409: fnd_global.local_chr(400)||

Line 1406: fnd_global.local_chr(400)||

1402: p_nationality||fnd_global.local_chr(400)||
1403: p_national_identifier||fnd_global.local_chr(400)||
1404: p_email_address||fnd_global.local_chr(400)||
1405: fnd_global.local_chr(400)||
1406: fnd_global.local_chr(400)||
1407: fnd_global.local_chr(400)||
1408: fnd_global.local_chr(400)||
1409: fnd_global.local_chr(400)||
1410: fnd_global.local_chr(400)||

Line 1407: fnd_global.local_chr(400)||

1403: p_national_identifier||fnd_global.local_chr(400)||
1404: p_email_address||fnd_global.local_chr(400)||
1405: fnd_global.local_chr(400)||
1406: fnd_global.local_chr(400)||
1407: fnd_global.local_chr(400)||
1408: fnd_global.local_chr(400)||
1409: fnd_global.local_chr(400)||
1410: fnd_global.local_chr(400)||
1411: fnd_global.local_chr(400)||

Line 1408: fnd_global.local_chr(400)||

1404: p_email_address||fnd_global.local_chr(400)||
1405: fnd_global.local_chr(400)||
1406: fnd_global.local_chr(400)||
1407: fnd_global.local_chr(400)||
1408: fnd_global.local_chr(400)||
1409: fnd_global.local_chr(400)||
1410: fnd_global.local_chr(400)||
1411: fnd_global.local_chr(400)||
1412: fnd_global.local_chr(400)||

Line 1409: fnd_global.local_chr(400)||

1405: fnd_global.local_chr(400)||
1406: fnd_global.local_chr(400)||
1407: fnd_global.local_chr(400)||
1408: fnd_global.local_chr(400)||
1409: fnd_global.local_chr(400)||
1410: fnd_global.local_chr(400)||
1411: fnd_global.local_chr(400)||
1412: fnd_global.local_chr(400)||
1413: fnd_global.local_chr(400)||

Line 1410: fnd_global.local_chr(400)||

1406: fnd_global.local_chr(400)||
1407: fnd_global.local_chr(400)||
1408: fnd_global.local_chr(400)||
1409: fnd_global.local_chr(400)||
1410: fnd_global.local_chr(400)||
1411: fnd_global.local_chr(400)||
1412: fnd_global.local_chr(400)||
1413: fnd_global.local_chr(400)||
1414: fnd_global.local_chr(400)||

Line 1411: fnd_global.local_chr(400)||

1407: fnd_global.local_chr(400)||
1408: fnd_global.local_chr(400)||
1409: fnd_global.local_chr(400)||
1410: fnd_global.local_chr(400)||
1411: fnd_global.local_chr(400)||
1412: fnd_global.local_chr(400)||
1413: fnd_global.local_chr(400)||
1414: fnd_global.local_chr(400)||
1415: fnd_global.local_chr(400)||

Line 1412: fnd_global.local_chr(400)||

1408: fnd_global.local_chr(400)||
1409: fnd_global.local_chr(400)||
1410: fnd_global.local_chr(400)||
1411: fnd_global.local_chr(400)||
1412: fnd_global.local_chr(400)||
1413: fnd_global.local_chr(400)||
1414: fnd_global.local_chr(400)||
1415: fnd_global.local_chr(400)||
1416: fnd_global.local_chr(400)||

Line 1413: fnd_global.local_chr(400)||

1409: fnd_global.local_chr(400)||
1410: fnd_global.local_chr(400)||
1411: fnd_global.local_chr(400)||
1412: fnd_global.local_chr(400)||
1413: fnd_global.local_chr(400)||
1414: fnd_global.local_chr(400)||
1415: fnd_global.local_chr(400)||
1416: fnd_global.local_chr(400)||
1417: fnd_global.local_chr(400)||

Line 1414: fnd_global.local_chr(400)||

1410: fnd_global.local_chr(400)||
1411: fnd_global.local_chr(400)||
1412: fnd_global.local_chr(400)||
1413: fnd_global.local_chr(400)||
1414: fnd_global.local_chr(400)||
1415: fnd_global.local_chr(400)||
1416: fnd_global.local_chr(400)||
1417: fnd_global.local_chr(400)||
1418: fnd_global.local_chr(400)||

Line 1415: fnd_global.local_chr(400)||

1411: fnd_global.local_chr(400)||
1412: fnd_global.local_chr(400)||
1413: fnd_global.local_chr(400)||
1414: fnd_global.local_chr(400)||
1415: fnd_global.local_chr(400)||
1416: fnd_global.local_chr(400)||
1417: fnd_global.local_chr(400)||
1418: fnd_global.local_chr(400)||
1419: fnd_global.local_chr(400)||

Line 1416: fnd_global.local_chr(400)||

1412: fnd_global.local_chr(400)||
1413: fnd_global.local_chr(400)||
1414: fnd_global.local_chr(400)||
1415: fnd_global.local_chr(400)||
1416: fnd_global.local_chr(400)||
1417: fnd_global.local_chr(400)||
1418: fnd_global.local_chr(400)||
1419: fnd_global.local_chr(400)||
1420: fnd_global.local_chr(400)||

Line 1417: fnd_global.local_chr(400)||

1413: fnd_global.local_chr(400)||
1414: fnd_global.local_chr(400)||
1415: fnd_global.local_chr(400)||
1416: fnd_global.local_chr(400)||
1417: fnd_global.local_chr(400)||
1418: fnd_global.local_chr(400)||
1419: fnd_global.local_chr(400)||
1420: fnd_global.local_chr(400)||
1421: fnd_global.local_chr(400)||

Line 1418: fnd_global.local_chr(400)||

1414: fnd_global.local_chr(400)||
1415: fnd_global.local_chr(400)||
1416: fnd_global.local_chr(400)||
1417: fnd_global.local_chr(400)||
1418: fnd_global.local_chr(400)||
1419: fnd_global.local_chr(400)||
1420: fnd_global.local_chr(400)||
1421: fnd_global.local_chr(400)||
1422: fnd_global.local_chr(400)||

Line 1419: fnd_global.local_chr(400)||

1415: fnd_global.local_chr(400)||
1416: fnd_global.local_chr(400)||
1417: fnd_global.local_chr(400)||
1418: fnd_global.local_chr(400)||
1419: fnd_global.local_chr(400)||
1420: fnd_global.local_chr(400)||
1421: fnd_global.local_chr(400)||
1422: fnd_global.local_chr(400)||
1423: p_national_id_label||fnd_global.local_chr(400)||

Line 1420: fnd_global.local_chr(400)||

1416: fnd_global.local_chr(400)||
1417: fnd_global.local_chr(400)||
1418: fnd_global.local_chr(400)||
1419: fnd_global.local_chr(400)||
1420: fnd_global.local_chr(400)||
1421: fnd_global.local_chr(400)||
1422: fnd_global.local_chr(400)||
1423: p_national_id_label||fnd_global.local_chr(400)||
1424: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

Line 1421: fnd_global.local_chr(400)||

1417: fnd_global.local_chr(400)||
1418: fnd_global.local_chr(400)||
1419: fnd_global.local_chr(400)||
1420: fnd_global.local_chr(400)||
1421: fnd_global.local_chr(400)||
1422: fnd_global.local_chr(400)||
1423: p_national_id_label||fnd_global.local_chr(400)||
1424: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1425: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

Line 1422: fnd_global.local_chr(400)||

1418: fnd_global.local_chr(400)||
1419: fnd_global.local_chr(400)||
1420: fnd_global.local_chr(400)||
1421: fnd_global.local_chr(400)||
1422: fnd_global.local_chr(400)||
1423: p_national_id_label||fnd_global.local_chr(400)||
1424: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1425: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1426: fnd_global.local_chr(10)||fnd_global.local_chr(13));

Line 1423: p_national_id_label||fnd_global.local_chr(400)||

1419: fnd_global.local_chr(400)||
1420: fnd_global.local_chr(400)||
1421: fnd_global.local_chr(400)||
1422: fnd_global.local_chr(400)||
1423: p_national_id_label||fnd_global.local_chr(400)||
1424: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1425: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1426: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1427:

Line 1424: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

1420: fnd_global.local_chr(400)||
1421: fnd_global.local_chr(400)||
1422: fnd_global.local_chr(400)||
1423: p_national_id_label||fnd_global.local_chr(400)||
1424: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1425: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1426: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1427:
1428:

Line 1426: fnd_global.local_chr(10)||fnd_global.local_chr(13));

1422: fnd_global.local_chr(400)||
1423: p_national_id_label||fnd_global.local_chr(400)||
1424: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1425: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1426: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1427:
1428:
1429: end if;
1430: /*Fix for bug 7650158 ends here*/