APPS.HR_HRHD_INITIAL_LOAD dependencies on FND_GLOBAL

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

123: exit when CSR_LOC_INITIAL_LOAD%NOTFOUND;
124:
125:
126: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||
127: fnd_global.local_chr(400)||p_active_date||
128: fnd_global.local_chr(400)||p_effecive_status||
129: fnd_global.local_chr(400)||p_loc_id||
130: fnd_global.local_chr(400)||p_lang_code||
131: fnd_global.local_chr(400)||p_loc_desc||

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

124:
125:
126: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||
127: fnd_global.local_chr(400)||p_active_date||
128: fnd_global.local_chr(400)||p_effecive_status||
129: fnd_global.local_chr(400)||p_loc_id||
130: fnd_global.local_chr(400)||p_lang_code||
131: fnd_global.local_chr(400)||p_loc_desc||
132: fnd_global.local_chr(400)||p_loc_style ||

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

125:
126: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||
127: fnd_global.local_chr(400)||p_active_date||
128: fnd_global.local_chr(400)||p_effecive_status||
129: fnd_global.local_chr(400)||p_loc_id||
130: fnd_global.local_chr(400)||p_lang_code||
131: fnd_global.local_chr(400)||p_loc_desc||
132: fnd_global.local_chr(400)||p_loc_style ||
133: fnd_global.local_chr(400)|| p_add_line_1||

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

126: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||
127: fnd_global.local_chr(400)||p_active_date||
128: fnd_global.local_chr(400)||p_effecive_status||
129: fnd_global.local_chr(400)||p_loc_id||
130: fnd_global.local_chr(400)||p_lang_code||
131: fnd_global.local_chr(400)||p_loc_desc||
132: fnd_global.local_chr(400)||p_loc_style ||
133: fnd_global.local_chr(400)|| p_add_line_1||
134: fnd_global.local_chr(400)||p_add_line_2||

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

127: fnd_global.local_chr(400)||p_active_date||
128: fnd_global.local_chr(400)||p_effecive_status||
129: fnd_global.local_chr(400)||p_loc_id||
130: fnd_global.local_chr(400)||p_lang_code||
131: fnd_global.local_chr(400)||p_loc_desc||
132: fnd_global.local_chr(400)||p_loc_style ||
133: fnd_global.local_chr(400)|| p_add_line_1||
134: fnd_global.local_chr(400)||p_add_line_2||
135: fnd_global.local_chr(400)|| p_add_line_3||

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

128: fnd_global.local_chr(400)||p_effecive_status||
129: fnd_global.local_chr(400)||p_loc_id||
130: fnd_global.local_chr(400)||p_lang_code||
131: fnd_global.local_chr(400)||p_loc_desc||
132: fnd_global.local_chr(400)||p_loc_style ||
133: fnd_global.local_chr(400)|| p_add_line_1||
134: fnd_global.local_chr(400)||p_add_line_2||
135: fnd_global.local_chr(400)|| p_add_line_3||
136: fnd_global.local_chr(400)||p_town_or_city||

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

129: fnd_global.local_chr(400)||p_loc_id||
130: fnd_global.local_chr(400)||p_lang_code||
131: fnd_global.local_chr(400)||p_loc_desc||
132: fnd_global.local_chr(400)||p_loc_style ||
133: fnd_global.local_chr(400)|| p_add_line_1||
134: fnd_global.local_chr(400)||p_add_line_2||
135: fnd_global.local_chr(400)|| p_add_line_3||
136: fnd_global.local_chr(400)||p_town_or_city||
137: fnd_global.local_chr(400)||p_country||

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

130: fnd_global.local_chr(400)||p_lang_code||
131: fnd_global.local_chr(400)||p_loc_desc||
132: fnd_global.local_chr(400)||p_loc_style ||
133: fnd_global.local_chr(400)|| p_add_line_1||
134: fnd_global.local_chr(400)||p_add_line_2||
135: fnd_global.local_chr(400)|| p_add_line_3||
136: fnd_global.local_chr(400)||p_town_or_city||
137: fnd_global.local_chr(400)||p_country||
138: fnd_global.local_chr(400)||p_postal_code||

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

131: fnd_global.local_chr(400)||p_loc_desc||
132: fnd_global.local_chr(400)||p_loc_style ||
133: fnd_global.local_chr(400)|| p_add_line_1||
134: fnd_global.local_chr(400)||p_add_line_2||
135: fnd_global.local_chr(400)|| p_add_line_3||
136: fnd_global.local_chr(400)||p_town_or_city||
137: fnd_global.local_chr(400)||p_country||
138: fnd_global.local_chr(400)||p_postal_code||
139: fnd_global.local_chr(400)||p_region_1||

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

132: fnd_global.local_chr(400)||p_loc_style ||
133: fnd_global.local_chr(400)|| p_add_line_1||
134: fnd_global.local_chr(400)||p_add_line_2||
135: fnd_global.local_chr(400)|| p_add_line_3||
136: fnd_global.local_chr(400)||p_town_or_city||
137: fnd_global.local_chr(400)||p_country||
138: fnd_global.local_chr(400)||p_postal_code||
139: fnd_global.local_chr(400)||p_region_1||
140: fnd_global.local_chr(400)||p_region_2||

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

133: fnd_global.local_chr(400)|| p_add_line_1||
134: fnd_global.local_chr(400)||p_add_line_2||
135: fnd_global.local_chr(400)|| p_add_line_3||
136: fnd_global.local_chr(400)||p_town_or_city||
137: fnd_global.local_chr(400)||p_country||
138: fnd_global.local_chr(400)||p_postal_code||
139: fnd_global.local_chr(400)||p_region_1||
140: fnd_global.local_chr(400)||p_region_2||
141: fnd_global.local_chr(400)||p_region_3||

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

134: fnd_global.local_chr(400)||p_add_line_2||
135: fnd_global.local_chr(400)|| p_add_line_3||
136: fnd_global.local_chr(400)||p_town_or_city||
137: fnd_global.local_chr(400)||p_country||
138: fnd_global.local_chr(400)||p_postal_code||
139: fnd_global.local_chr(400)||p_region_1||
140: fnd_global.local_chr(400)||p_region_2||
141: fnd_global.local_chr(400)||p_region_3||
142: fnd_global.local_chr(400)||p_tel_no_1||

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

135: fnd_global.local_chr(400)|| p_add_line_3||
136: fnd_global.local_chr(400)||p_town_or_city||
137: fnd_global.local_chr(400)||p_country||
138: fnd_global.local_chr(400)||p_postal_code||
139: fnd_global.local_chr(400)||p_region_1||
140: fnd_global.local_chr(400)||p_region_2||
141: fnd_global.local_chr(400)||p_region_3||
142: fnd_global.local_chr(400)||p_tel_no_1||
143: fnd_global.local_chr(400)||p_tel_no_2 ||

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

136: fnd_global.local_chr(400)||p_town_or_city||
137: fnd_global.local_chr(400)||p_country||
138: fnd_global.local_chr(400)||p_postal_code||
139: fnd_global.local_chr(400)||p_region_1||
140: fnd_global.local_chr(400)||p_region_2||
141: fnd_global.local_chr(400)||p_region_3||
142: fnd_global.local_chr(400)||p_tel_no_1||
143: fnd_global.local_chr(400)||p_tel_no_2 ||
144: fnd_global.local_chr(400)||p_tel_no_3||

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

137: fnd_global.local_chr(400)||p_country||
138: fnd_global.local_chr(400)||p_postal_code||
139: fnd_global.local_chr(400)||p_region_1||
140: fnd_global.local_chr(400)||p_region_2||
141: fnd_global.local_chr(400)||p_region_3||
142: fnd_global.local_chr(400)||p_tel_no_1||
143: fnd_global.local_chr(400)||p_tel_no_2 ||
144: fnd_global.local_chr(400)||p_tel_no_3||
145: fnd_global.local_chr(400)||p_loc_info_13||

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

138: fnd_global.local_chr(400)||p_postal_code||
139: fnd_global.local_chr(400)||p_region_1||
140: fnd_global.local_chr(400)||p_region_2||
141: fnd_global.local_chr(400)||p_region_3||
142: fnd_global.local_chr(400)||p_tel_no_1||
143: fnd_global.local_chr(400)||p_tel_no_2 ||
144: fnd_global.local_chr(400)||p_tel_no_3||
145: fnd_global.local_chr(400)||p_loc_info_13||
146: fnd_global.local_chr(400)||p_loc_info_14||

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

139: fnd_global.local_chr(400)||p_region_1||
140: fnd_global.local_chr(400)||p_region_2||
141: fnd_global.local_chr(400)||p_region_3||
142: fnd_global.local_chr(400)||p_tel_no_1||
143: fnd_global.local_chr(400)||p_tel_no_2 ||
144: fnd_global.local_chr(400)||p_tel_no_3||
145: fnd_global.local_chr(400)||p_loc_info_13||
146: fnd_global.local_chr(400)||p_loc_info_14||
147: fnd_global.local_chr(400)||p_loc_info_15||

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

140: fnd_global.local_chr(400)||p_region_2||
141: fnd_global.local_chr(400)||p_region_3||
142: fnd_global.local_chr(400)||p_tel_no_1||
143: fnd_global.local_chr(400)||p_tel_no_2 ||
144: fnd_global.local_chr(400)||p_tel_no_3||
145: fnd_global.local_chr(400)||p_loc_info_13||
146: fnd_global.local_chr(400)||p_loc_info_14||
147: fnd_global.local_chr(400)||p_loc_info_15||
148: fnd_global.local_chr(400)||p_loc_info_16||

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

141: fnd_global.local_chr(400)||p_region_3||
142: fnd_global.local_chr(400)||p_tel_no_1||
143: fnd_global.local_chr(400)||p_tel_no_2 ||
144: fnd_global.local_chr(400)||p_tel_no_3||
145: fnd_global.local_chr(400)||p_loc_info_13||
146: fnd_global.local_chr(400)||p_loc_info_14||
147: fnd_global.local_chr(400)||p_loc_info_15||
148: fnd_global.local_chr(400)||p_loc_info_16||
149: fnd_global.local_chr(400)||p_loc_info_17||

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

142: fnd_global.local_chr(400)||p_tel_no_1||
143: fnd_global.local_chr(400)||p_tel_no_2 ||
144: fnd_global.local_chr(400)||p_tel_no_3||
145: fnd_global.local_chr(400)||p_loc_info_13||
146: fnd_global.local_chr(400)||p_loc_info_14||
147: fnd_global.local_chr(400)||p_loc_info_15||
148: fnd_global.local_chr(400)||p_loc_info_16||
149: fnd_global.local_chr(400)||p_loc_info_17||
150: fnd_global.local_chr(400)||p_loc_info_18||

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

143: fnd_global.local_chr(400)||p_tel_no_2 ||
144: fnd_global.local_chr(400)||p_tel_no_3||
145: fnd_global.local_chr(400)||p_loc_info_13||
146: fnd_global.local_chr(400)||p_loc_info_14||
147: fnd_global.local_chr(400)||p_loc_info_15||
148: fnd_global.local_chr(400)||p_loc_info_16||
149: fnd_global.local_chr(400)||p_loc_info_17||
150: fnd_global.local_chr(400)||p_loc_info_18||
151: fnd_global.local_chr(400)||p_loc_info_19||

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

144: fnd_global.local_chr(400)||p_tel_no_3||
145: fnd_global.local_chr(400)||p_loc_info_13||
146: fnd_global.local_chr(400)||p_loc_info_14||
147: fnd_global.local_chr(400)||p_loc_info_15||
148: fnd_global.local_chr(400)||p_loc_info_16||
149: fnd_global.local_chr(400)||p_loc_info_17||
150: fnd_global.local_chr(400)||p_loc_info_18||
151: fnd_global.local_chr(400)||p_loc_info_19||
152: fnd_global.local_chr(400)||p_loc_info_20||

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

145: fnd_global.local_chr(400)||p_loc_info_13||
146: fnd_global.local_chr(400)||p_loc_info_14||
147: fnd_global.local_chr(400)||p_loc_info_15||
148: fnd_global.local_chr(400)||p_loc_info_16||
149: fnd_global.local_chr(400)||p_loc_info_17||
150: fnd_global.local_chr(400)||p_loc_info_18||
151: fnd_global.local_chr(400)||p_loc_info_19||
152: fnd_global.local_chr(400)||p_loc_info_20||
153: fnd_global.local_chr(10)||fnd_global.local_chr(13));

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

146: fnd_global.local_chr(400)||p_loc_info_14||
147: fnd_global.local_chr(400)||p_loc_info_15||
148: fnd_global.local_chr(400)||p_loc_info_16||
149: fnd_global.local_chr(400)||p_loc_info_17||
150: fnd_global.local_chr(400)||p_loc_info_18||
151: fnd_global.local_chr(400)||p_loc_info_19||
152: fnd_global.local_chr(400)||p_loc_info_20||
153: fnd_global.local_chr(10)||fnd_global.local_chr(13));
154:

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

147: fnd_global.local_chr(400)||p_loc_info_15||
148: fnd_global.local_chr(400)||p_loc_info_16||
149: fnd_global.local_chr(400)||p_loc_info_17||
150: fnd_global.local_chr(400)||p_loc_info_18||
151: fnd_global.local_chr(400)||p_loc_info_19||
152: fnd_global.local_chr(400)||p_loc_info_20||
153: fnd_global.local_chr(10)||fnd_global.local_chr(13));
154:
155:

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

148: fnd_global.local_chr(400)||p_loc_info_16||
149: fnd_global.local_chr(400)||p_loc_info_17||
150: fnd_global.local_chr(400)||p_loc_info_18||
151: fnd_global.local_chr(400)||p_loc_info_19||
152: fnd_global.local_chr(400)||p_loc_info_20||
153: fnd_global.local_chr(10)||fnd_global.local_chr(13));
154:
155:
156:

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

149: fnd_global.local_chr(400)||p_loc_info_17||
150: fnd_global.local_chr(400)||p_loc_info_18||
151: fnd_global.local_chr(400)||p_loc_info_19||
152: fnd_global.local_chr(400)||p_loc_info_20||
153: fnd_global.local_chr(10)||fnd_global.local_chr(13));
154:
155:
156:
157: end loop;

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

230: EXIT WHEN csr_job_initial_load%NOTFOUND;
231:
232:
233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
234: p_business_grp_id||fnd_global.local_chr(400)||
235: p_job_id||fnd_global.local_chr(400)||
236: p_eff_date||fnd_global.local_chr(400)||
237: p_eff_status||fnd_global.local_chr(400)||
238: p_lang_code||fnd_global.local_chr(400)||

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

231:
232:
233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
234: p_business_grp_id||fnd_global.local_chr(400)||
235: p_job_id||fnd_global.local_chr(400)||
236: p_eff_date||fnd_global.local_chr(400)||
237: p_eff_status||fnd_global.local_chr(400)||
238: p_lang_code||fnd_global.local_chr(400)||
239: p_job_descr||

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

232:
233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
234: p_business_grp_id||fnd_global.local_chr(400)||
235: p_job_id||fnd_global.local_chr(400)||
236: p_eff_date||fnd_global.local_chr(400)||
237: p_eff_status||fnd_global.local_chr(400)||
238: p_lang_code||fnd_global.local_chr(400)||
239: p_job_descr||
240: fnd_global.local_chr(10)||fnd_global.local_chr(13));

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

233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
234: p_business_grp_id||fnd_global.local_chr(400)||
235: p_job_id||fnd_global.local_chr(400)||
236: p_eff_date||fnd_global.local_chr(400)||
237: p_eff_status||fnd_global.local_chr(400)||
238: p_lang_code||fnd_global.local_chr(400)||
239: p_job_descr||
240: fnd_global.local_chr(10)||fnd_global.local_chr(13));
241:

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

234: p_business_grp_id||fnd_global.local_chr(400)||
235: p_job_id||fnd_global.local_chr(400)||
236: p_eff_date||fnd_global.local_chr(400)||
237: p_eff_status||fnd_global.local_chr(400)||
238: p_lang_code||fnd_global.local_chr(400)||
239: p_job_descr||
240: fnd_global.local_chr(10)||fnd_global.local_chr(13));
241:
242: END Loop;

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

236: p_eff_date||fnd_global.local_chr(400)||
237: p_eff_status||fnd_global.local_chr(400)||
238: p_lang_code||fnd_global.local_chr(400)||
239: p_job_descr||
240: fnd_global.local_chr(10)||fnd_global.local_chr(13));
241:
242: END Loop;
243: CLOSE csr_job_initial_load;
244:

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

354: EXIT WHEN csr_org_initial_load%NOTFOUND;
355:
356:
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
358: p_bg_id||fnd_global.local_chr(400)||
359: p_org_id||fnd_global.local_chr(400)||
360: p_eff_date||fnd_global.local_chr(400)||
361: p_eff_status||fnd_global.local_chr(400)||
362: p_lang_code||fnd_global.local_chr(400)||

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

355:
356:
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
358: p_bg_id||fnd_global.local_chr(400)||
359: p_org_id||fnd_global.local_chr(400)||
360: p_eff_date||fnd_global.local_chr(400)||
361: p_eff_status||fnd_global.local_chr(400)||
362: p_lang_code||fnd_global.local_chr(400)||
363: p_bg_name||fnd_global.local_chr(400)||

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

356:
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
358: p_bg_id||fnd_global.local_chr(400)||
359: p_org_id||fnd_global.local_chr(400)||
360: p_eff_date||fnd_global.local_chr(400)||
361: p_eff_status||fnd_global.local_chr(400)||
362: p_lang_code||fnd_global.local_chr(400)||
363: p_bg_name||fnd_global.local_chr(400)||
364: p_loc_id||fnd_global.local_chr(400)||

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

357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
358: p_bg_id||fnd_global.local_chr(400)||
359: p_org_id||fnd_global.local_chr(400)||
360: p_eff_date||fnd_global.local_chr(400)||
361: p_eff_status||fnd_global.local_chr(400)||
362: p_lang_code||fnd_global.local_chr(400)||
363: p_bg_name||fnd_global.local_chr(400)||
364: p_loc_id||fnd_global.local_chr(400)||
365: p_person_id||

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

358: p_bg_id||fnd_global.local_chr(400)||
359: p_org_id||fnd_global.local_chr(400)||
360: p_eff_date||fnd_global.local_chr(400)||
361: p_eff_status||fnd_global.local_chr(400)||
362: p_lang_code||fnd_global.local_chr(400)||
363: p_bg_name||fnd_global.local_chr(400)||
364: p_loc_id||fnd_global.local_chr(400)||
365: p_person_id||
366: fnd_global.local_chr(10)||fnd_global.local_chr(13));

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

359: p_org_id||fnd_global.local_chr(400)||
360: p_eff_date||fnd_global.local_chr(400)||
361: p_eff_status||fnd_global.local_chr(400)||
362: p_lang_code||fnd_global.local_chr(400)||
363: p_bg_name||fnd_global.local_chr(400)||
364: p_loc_id||fnd_global.local_chr(400)||
365: p_person_id||
366: fnd_global.local_chr(10)||fnd_global.local_chr(13));
367:

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

360: p_eff_date||fnd_global.local_chr(400)||
361: p_eff_status||fnd_global.local_chr(400)||
362: p_lang_code||fnd_global.local_chr(400)||
363: p_bg_name||fnd_global.local_chr(400)||
364: p_loc_id||fnd_global.local_chr(400)||
365: p_person_id||
366: fnd_global.local_chr(10)||fnd_global.local_chr(13));
367:
368: END Loop;

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

362: p_lang_code||fnd_global.local_chr(400)||
363: p_bg_name||fnd_global.local_chr(400)||
364: p_loc_id||fnd_global.local_chr(400)||
365: p_person_id||
366: fnd_global.local_chr(10)||fnd_global.local_chr(13));
367:
368: END Loop;
369: CLOSE csr_org_initial_load;
370:

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

473: EXIT WHEN csr_wkfrc_initial_load%NOTFOUND;
474:
475:
476: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
477: p_business_group_id||fnd_global.local_chr(400)||
478: p_person_id||fnd_global.local_chr(400)||
479: p_assignment_id||fnd_global.local_chr(400)||
480: p_assignment_number||fnd_global.local_chr(400)||
481: p_effective_start_date||fnd_global.local_chr(400)||

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

474:
475:
476: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
477: p_business_group_id||fnd_global.local_chr(400)||
478: p_person_id||fnd_global.local_chr(400)||
479: p_assignment_id||fnd_global.local_chr(400)||
480: p_assignment_number||fnd_global.local_chr(400)||
481: p_effective_start_date||fnd_global.local_chr(400)||
482: p_effective_end_date||fnd_global.local_chr(400)||

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

475:
476: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
477: p_business_group_id||fnd_global.local_chr(400)||
478: p_person_id||fnd_global.local_chr(400)||
479: p_assignment_id||fnd_global.local_chr(400)||
480: p_assignment_number||fnd_global.local_chr(400)||
481: p_effective_start_date||fnd_global.local_chr(400)||
482: p_effective_end_date||fnd_global.local_chr(400)||
483: p_organization_id||fnd_global.local_chr(400)||

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

476: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
477: p_business_group_id||fnd_global.local_chr(400)||
478: p_person_id||fnd_global.local_chr(400)||
479: p_assignment_id||fnd_global.local_chr(400)||
480: p_assignment_number||fnd_global.local_chr(400)||
481: p_effective_start_date||fnd_global.local_chr(400)||
482: p_effective_end_date||fnd_global.local_chr(400)||
483: p_organization_id||fnd_global.local_chr(400)||
484: p_probation_period||fnd_global.local_chr(400)||

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

477: p_business_group_id||fnd_global.local_chr(400)||
478: p_person_id||fnd_global.local_chr(400)||
479: p_assignment_id||fnd_global.local_chr(400)||
480: p_assignment_number||fnd_global.local_chr(400)||
481: p_effective_start_date||fnd_global.local_chr(400)||
482: p_effective_end_date||fnd_global.local_chr(400)||
483: p_organization_id||fnd_global.local_chr(400)||
484: p_probation_period||fnd_global.local_chr(400)||
485: p_probation_units||fnd_global.local_chr(400)||

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

478: p_person_id||fnd_global.local_chr(400)||
479: p_assignment_id||fnd_global.local_chr(400)||
480: p_assignment_number||fnd_global.local_chr(400)||
481: p_effective_start_date||fnd_global.local_chr(400)||
482: p_effective_end_date||fnd_global.local_chr(400)||
483: p_organization_id||fnd_global.local_chr(400)||
484: p_probation_period||fnd_global.local_chr(400)||
485: p_probation_units||fnd_global.local_chr(400)||
486: p_job_id||fnd_global.local_chr(400)||

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

479: p_assignment_id||fnd_global.local_chr(400)||
480: p_assignment_number||fnd_global.local_chr(400)||
481: p_effective_start_date||fnd_global.local_chr(400)||
482: p_effective_end_date||fnd_global.local_chr(400)||
483: p_organization_id||fnd_global.local_chr(400)||
484: p_probation_period||fnd_global.local_chr(400)||
485: p_probation_units||fnd_global.local_chr(400)||
486: p_job_id||fnd_global.local_chr(400)||
487: p_assignment_status_type_id||fnd_global.local_chr(400)||

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

480: p_assignment_number||fnd_global.local_chr(400)||
481: p_effective_start_date||fnd_global.local_chr(400)||
482: p_effective_end_date||fnd_global.local_chr(400)||
483: p_organization_id||fnd_global.local_chr(400)||
484: p_probation_period||fnd_global.local_chr(400)||
485: p_probation_units||fnd_global.local_chr(400)||
486: p_job_id||fnd_global.local_chr(400)||
487: p_assignment_status_type_id||fnd_global.local_chr(400)||
488: p_location_id||fnd_global.local_chr(400)||

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

481: p_effective_start_date||fnd_global.local_chr(400)||
482: p_effective_end_date||fnd_global.local_chr(400)||
483: p_organization_id||fnd_global.local_chr(400)||
484: p_probation_period||fnd_global.local_chr(400)||
485: p_probation_units||fnd_global.local_chr(400)||
486: p_job_id||fnd_global.local_chr(400)||
487: p_assignment_status_type_id||fnd_global.local_chr(400)||
488: p_location_id||fnd_global.local_chr(400)||
489: p_employment_category||fnd_global.local_chr(400)||

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

482: p_effective_end_date||fnd_global.local_chr(400)||
483: p_organization_id||fnd_global.local_chr(400)||
484: p_probation_period||fnd_global.local_chr(400)||
485: p_probation_units||fnd_global.local_chr(400)||
486: p_job_id||fnd_global.local_chr(400)||
487: p_assignment_status_type_id||fnd_global.local_chr(400)||
488: p_location_id||fnd_global.local_chr(400)||
489: p_employment_category||fnd_global.local_chr(400)||
490: p_normal_hours||fnd_global.local_chr(400)||

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

483: p_organization_id||fnd_global.local_chr(400)||
484: p_probation_period||fnd_global.local_chr(400)||
485: p_probation_units||fnd_global.local_chr(400)||
486: p_job_id||fnd_global.local_chr(400)||
487: p_assignment_status_type_id||fnd_global.local_chr(400)||
488: p_location_id||fnd_global.local_chr(400)||
489: p_employment_category||fnd_global.local_chr(400)||
490: p_normal_hours||fnd_global.local_chr(400)||
491: p_frequency||fnd_global.local_chr(400)||

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

484: p_probation_period||fnd_global.local_chr(400)||
485: p_probation_units||fnd_global.local_chr(400)||
486: p_job_id||fnd_global.local_chr(400)||
487: p_assignment_status_type_id||fnd_global.local_chr(400)||
488: p_location_id||fnd_global.local_chr(400)||
489: p_employment_category||fnd_global.local_chr(400)||
490: p_normal_hours||fnd_global.local_chr(400)||
491: p_frequency||fnd_global.local_chr(400)||
492: p_grade_id||fnd_global.local_chr(400)||

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

485: p_probation_units||fnd_global.local_chr(400)||
486: p_job_id||fnd_global.local_chr(400)||
487: p_assignment_status_type_id||fnd_global.local_chr(400)||
488: p_location_id||fnd_global.local_chr(400)||
489: p_employment_category||fnd_global.local_chr(400)||
490: p_normal_hours||fnd_global.local_chr(400)||
491: p_frequency||fnd_global.local_chr(400)||
492: p_grade_id||fnd_global.local_chr(400)||
493: p_position_id||fnd_global.local_chr(400)||

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

486: p_job_id||fnd_global.local_chr(400)||
487: p_assignment_status_type_id||fnd_global.local_chr(400)||
488: p_location_id||fnd_global.local_chr(400)||
489: p_employment_category||fnd_global.local_chr(400)||
490: p_normal_hours||fnd_global.local_chr(400)||
491: p_frequency||fnd_global.local_chr(400)||
492: p_grade_id||fnd_global.local_chr(400)||
493: p_position_id||fnd_global.local_chr(400)||
494: p_supervisor_id||fnd_global.local_chr(400)||

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

487: p_assignment_status_type_id||fnd_global.local_chr(400)||
488: p_location_id||fnd_global.local_chr(400)||
489: p_employment_category||fnd_global.local_chr(400)||
490: p_normal_hours||fnd_global.local_chr(400)||
491: p_frequency||fnd_global.local_chr(400)||
492: p_grade_id||fnd_global.local_chr(400)||
493: p_position_id||fnd_global.local_chr(400)||
494: p_supervisor_id||fnd_global.local_chr(400)||
495: p_act_termn_date||fnd_global.local_chr(400)||

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

488: p_location_id||fnd_global.local_chr(400)||
489: p_employment_category||fnd_global.local_chr(400)||
490: p_normal_hours||fnd_global.local_chr(400)||
491: p_frequency||fnd_global.local_chr(400)||
492: p_grade_id||fnd_global.local_chr(400)||
493: p_position_id||fnd_global.local_chr(400)||
494: p_supervisor_id||fnd_global.local_chr(400)||
495: p_act_termn_date||fnd_global.local_chr(400)||
496: p_final_prcs_date||

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

489: p_employment_category||fnd_global.local_chr(400)||
490: p_normal_hours||fnd_global.local_chr(400)||
491: p_frequency||fnd_global.local_chr(400)||
492: p_grade_id||fnd_global.local_chr(400)||
493: p_position_id||fnd_global.local_chr(400)||
494: p_supervisor_id||fnd_global.local_chr(400)||
495: p_act_termn_date||fnd_global.local_chr(400)||
496: p_final_prcs_date||
497: fnd_global.local_chr(10)||fnd_global.local_chr(13));

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

490: p_normal_hours||fnd_global.local_chr(400)||
491: p_frequency||fnd_global.local_chr(400)||
492: p_grade_id||fnd_global.local_chr(400)||
493: p_position_id||fnd_global.local_chr(400)||
494: p_supervisor_id||fnd_global.local_chr(400)||
495: p_act_termn_date||fnd_global.local_chr(400)||
496: p_final_prcs_date||
497: fnd_global.local_chr(10)||fnd_global.local_chr(13));
498:

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

491: p_frequency||fnd_global.local_chr(400)||
492: p_grade_id||fnd_global.local_chr(400)||
493: p_position_id||fnd_global.local_chr(400)||
494: p_supervisor_id||fnd_global.local_chr(400)||
495: p_act_termn_date||fnd_global.local_chr(400)||
496: p_final_prcs_date||
497: fnd_global.local_chr(10)||fnd_global.local_chr(13));
498:
499: END Loop;

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

493: p_position_id||fnd_global.local_chr(400)||
494: p_supervisor_id||fnd_global.local_chr(400)||
495: p_act_termn_date||fnd_global.local_chr(400)||
496: p_final_prcs_date||
497: fnd_global.local_chr(10)||fnd_global.local_chr(13));
498:
499: END Loop;
500: CLOSE csr_wkfrc_initial_load;
501:

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

683: if k <= p_phn_type.count
684: then
685:
686: FND_FILE.put_line(FND_FILE.OUTPUT,
687: p_business_group_id||fnd_global.local_chr(400)||
688: p_person_id||fnd_global.local_chr(400)||
689: p_legislation_code||fnd_global.local_chr(400)||
690: p_employee_number||fnd_global.local_chr(400)||
691: p_applicant_number||fnd_global.local_chr(400)||

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

684: then
685:
686: FND_FILE.put_line(FND_FILE.OUTPUT,
687: p_business_group_id||fnd_global.local_chr(400)||
688: p_person_id||fnd_global.local_chr(400)||
689: p_legislation_code||fnd_global.local_chr(400)||
690: p_employee_number||fnd_global.local_chr(400)||
691: p_applicant_number||fnd_global.local_chr(400)||
692: p_npw_number||fnd_global.local_chr(400)||

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

685:
686: FND_FILE.put_line(FND_FILE.OUTPUT,
687: p_business_group_id||fnd_global.local_chr(400)||
688: p_person_id||fnd_global.local_chr(400)||
689: p_legislation_code||fnd_global.local_chr(400)||
690: p_employee_number||fnd_global.local_chr(400)||
691: p_applicant_number||fnd_global.local_chr(400)||
692: p_npw_number||fnd_global.local_chr(400)||
693: p_person_type_id||fnd_global.local_chr(400)||

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

686: FND_FILE.put_line(FND_FILE.OUTPUT,
687: p_business_group_id||fnd_global.local_chr(400)||
688: p_person_id||fnd_global.local_chr(400)||
689: p_legislation_code||fnd_global.local_chr(400)||
690: p_employee_number||fnd_global.local_chr(400)||
691: p_applicant_number||fnd_global.local_chr(400)||
692: p_npw_number||fnd_global.local_chr(400)||
693: p_person_type_id||fnd_global.local_chr(400)||
694: p_date_of_birth||fnd_global.local_chr(400)||

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

687: p_business_group_id||fnd_global.local_chr(400)||
688: p_person_id||fnd_global.local_chr(400)||
689: p_legislation_code||fnd_global.local_chr(400)||
690: p_employee_number||fnd_global.local_chr(400)||
691: p_applicant_number||fnd_global.local_chr(400)||
692: p_npw_number||fnd_global.local_chr(400)||
693: p_person_type_id||fnd_global.local_chr(400)||
694: p_date_of_birth||fnd_global.local_chr(400)||
695: p_town_of_birth||fnd_global.local_chr(400)||

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

688: p_person_id||fnd_global.local_chr(400)||
689: p_legislation_code||fnd_global.local_chr(400)||
690: p_employee_number||fnd_global.local_chr(400)||
691: p_applicant_number||fnd_global.local_chr(400)||
692: p_npw_number||fnd_global.local_chr(400)||
693: p_person_type_id||fnd_global.local_chr(400)||
694: p_date_of_birth||fnd_global.local_chr(400)||
695: p_town_of_birth||fnd_global.local_chr(400)||
696: p_cntry_of_birth||fnd_global.local_chr(400)||

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

689: p_legislation_code||fnd_global.local_chr(400)||
690: p_employee_number||fnd_global.local_chr(400)||
691: p_applicant_number||fnd_global.local_chr(400)||
692: p_npw_number||fnd_global.local_chr(400)||
693: p_person_type_id||fnd_global.local_chr(400)||
694: p_date_of_birth||fnd_global.local_chr(400)||
695: p_town_of_birth||fnd_global.local_chr(400)||
696: p_cntry_of_birth||fnd_global.local_chr(400)||
697: p_date_of_death||fnd_global.local_chr(400)||

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

690: p_employee_number||fnd_global.local_chr(400)||
691: p_applicant_number||fnd_global.local_chr(400)||
692: p_npw_number||fnd_global.local_chr(400)||
693: p_person_type_id||fnd_global.local_chr(400)||
694: p_date_of_birth||fnd_global.local_chr(400)||
695: p_town_of_birth||fnd_global.local_chr(400)||
696: p_cntry_of_birth||fnd_global.local_chr(400)||
697: p_date_of_death||fnd_global.local_chr(400)||
698: p_orig_dt_of_hire||fnd_global.local_chr(400)||

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

691: p_applicant_number||fnd_global.local_chr(400)||
692: p_npw_number||fnd_global.local_chr(400)||
693: p_person_type_id||fnd_global.local_chr(400)||
694: p_date_of_birth||fnd_global.local_chr(400)||
695: p_town_of_birth||fnd_global.local_chr(400)||
696: p_cntry_of_birth||fnd_global.local_chr(400)||
697: p_date_of_death||fnd_global.local_chr(400)||
698: p_orig_dt_of_hire||fnd_global.local_chr(400)||
699: p_eff_start_date||fnd_global.local_chr(400)||

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

692: p_npw_number||fnd_global.local_chr(400)||
693: p_person_type_id||fnd_global.local_chr(400)||
694: p_date_of_birth||fnd_global.local_chr(400)||
695: p_town_of_birth||fnd_global.local_chr(400)||
696: p_cntry_of_birth||fnd_global.local_chr(400)||
697: p_date_of_death||fnd_global.local_chr(400)||
698: p_orig_dt_of_hire||fnd_global.local_chr(400)||
699: p_eff_start_date||fnd_global.local_chr(400)||
700: p_eff_end_date||fnd_global.local_chr(400)||

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

693: p_person_type_id||fnd_global.local_chr(400)||
694: p_date_of_birth||fnd_global.local_chr(400)||
695: p_town_of_birth||fnd_global.local_chr(400)||
696: p_cntry_of_birth||fnd_global.local_chr(400)||
697: p_date_of_death||fnd_global.local_chr(400)||
698: p_orig_dt_of_hire||fnd_global.local_chr(400)||
699: p_eff_start_date||fnd_global.local_chr(400)||
700: p_eff_end_date||fnd_global.local_chr(400)||
701: p_sex||fnd_global.local_chr(400)||

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

694: p_date_of_birth||fnd_global.local_chr(400)||
695: p_town_of_birth||fnd_global.local_chr(400)||
696: p_cntry_of_birth||fnd_global.local_chr(400)||
697: p_date_of_death||fnd_global.local_chr(400)||
698: p_orig_dt_of_hire||fnd_global.local_chr(400)||
699: p_eff_start_date||fnd_global.local_chr(400)||
700: p_eff_end_date||fnd_global.local_chr(400)||
701: p_sex||fnd_global.local_chr(400)||
702: p_full_name||fnd_global.local_chr(400)||

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

695: p_town_of_birth||fnd_global.local_chr(400)||
696: p_cntry_of_birth||fnd_global.local_chr(400)||
697: p_date_of_death||fnd_global.local_chr(400)||
698: p_orig_dt_of_hire||fnd_global.local_chr(400)||
699: p_eff_start_date||fnd_global.local_chr(400)||
700: p_eff_end_date||fnd_global.local_chr(400)||
701: p_sex||fnd_global.local_chr(400)||
702: p_full_name||fnd_global.local_chr(400)||
703: p_suffix||fnd_global.local_chr(400)||

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

696: p_cntry_of_birth||fnd_global.local_chr(400)||
697: p_date_of_death||fnd_global.local_chr(400)||
698: p_orig_dt_of_hire||fnd_global.local_chr(400)||
699: p_eff_start_date||fnd_global.local_chr(400)||
700: p_eff_end_date||fnd_global.local_chr(400)||
701: p_sex||fnd_global.local_chr(400)||
702: p_full_name||fnd_global.local_chr(400)||
703: p_suffix||fnd_global.local_chr(400)||
704: p_title||fnd_global.local_chr(400)||

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

697: p_date_of_death||fnd_global.local_chr(400)||
698: p_orig_dt_of_hire||fnd_global.local_chr(400)||
699: p_eff_start_date||fnd_global.local_chr(400)||
700: p_eff_end_date||fnd_global.local_chr(400)||
701: p_sex||fnd_global.local_chr(400)||
702: p_full_name||fnd_global.local_chr(400)||
703: p_suffix||fnd_global.local_chr(400)||
704: p_title||fnd_global.local_chr(400)||
705: p_last_name||fnd_global.local_chr(400)||

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

698: p_orig_dt_of_hire||fnd_global.local_chr(400)||
699: p_eff_start_date||fnd_global.local_chr(400)||
700: p_eff_end_date||fnd_global.local_chr(400)||
701: p_sex||fnd_global.local_chr(400)||
702: p_full_name||fnd_global.local_chr(400)||
703: p_suffix||fnd_global.local_chr(400)||
704: p_title||fnd_global.local_chr(400)||
705: p_last_name||fnd_global.local_chr(400)||
706: p_first_name||fnd_global.local_chr(400)||

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

699: p_eff_start_date||fnd_global.local_chr(400)||
700: p_eff_end_date||fnd_global.local_chr(400)||
701: p_sex||fnd_global.local_chr(400)||
702: p_full_name||fnd_global.local_chr(400)||
703: p_suffix||fnd_global.local_chr(400)||
704: p_title||fnd_global.local_chr(400)||
705: p_last_name||fnd_global.local_chr(400)||
706: p_first_name||fnd_global.local_chr(400)||
707: p_middle_names||fnd_global.local_chr(400)||

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

700: p_eff_end_date||fnd_global.local_chr(400)||
701: p_sex||fnd_global.local_chr(400)||
702: p_full_name||fnd_global.local_chr(400)||
703: p_suffix||fnd_global.local_chr(400)||
704: p_title||fnd_global.local_chr(400)||
705: p_last_name||fnd_global.local_chr(400)||
706: p_first_name||fnd_global.local_chr(400)||
707: p_middle_names||fnd_global.local_chr(400)||
708: p_nationality||fnd_global.local_chr(400)||

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

701: p_sex||fnd_global.local_chr(400)||
702: p_full_name||fnd_global.local_chr(400)||
703: p_suffix||fnd_global.local_chr(400)||
704: p_title||fnd_global.local_chr(400)||
705: p_last_name||fnd_global.local_chr(400)||
706: p_first_name||fnd_global.local_chr(400)||
707: p_middle_names||fnd_global.local_chr(400)||
708: p_nationality||fnd_global.local_chr(400)||
709: p_national_identifier||fnd_global.local_chr(400)||

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

702: p_full_name||fnd_global.local_chr(400)||
703: p_suffix||fnd_global.local_chr(400)||
704: p_title||fnd_global.local_chr(400)||
705: p_last_name||fnd_global.local_chr(400)||
706: p_first_name||fnd_global.local_chr(400)||
707: p_middle_names||fnd_global.local_chr(400)||
708: p_nationality||fnd_global.local_chr(400)||
709: p_national_identifier||fnd_global.local_chr(400)||
710: p_email_address||fnd_global.local_chr(400)||

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

703: p_suffix||fnd_global.local_chr(400)||
704: p_title||fnd_global.local_chr(400)||
705: p_last_name||fnd_global.local_chr(400)||
706: p_first_name||fnd_global.local_chr(400)||
707: p_middle_names||fnd_global.local_chr(400)||
708: p_nationality||fnd_global.local_chr(400)||
709: p_national_identifier||fnd_global.local_chr(400)||
710: p_email_address||fnd_global.local_chr(400)||
711: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||

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

704: p_title||fnd_global.local_chr(400)||
705: p_last_name||fnd_global.local_chr(400)||
706: p_first_name||fnd_global.local_chr(400)||
707: p_middle_names||fnd_global.local_chr(400)||
708: p_nationality||fnd_global.local_chr(400)||
709: p_national_identifier||fnd_global.local_chr(400)||
710: p_email_address||fnd_global.local_chr(400)||
711: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
712: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||

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

705: p_last_name||fnd_global.local_chr(400)||
706: p_first_name||fnd_global.local_chr(400)||
707: p_middle_names||fnd_global.local_chr(400)||
708: p_nationality||fnd_global.local_chr(400)||
709: p_national_identifier||fnd_global.local_chr(400)||
710: p_email_address||fnd_global.local_chr(400)||
711: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
712: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
713: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||

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

706: p_first_name||fnd_global.local_chr(400)||
707: p_middle_names||fnd_global.local_chr(400)||
708: p_nationality||fnd_global.local_chr(400)||
709: p_national_identifier||fnd_global.local_chr(400)||
710: p_email_address||fnd_global.local_chr(400)||
711: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
712: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
713: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
714: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||

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

707: p_middle_names||fnd_global.local_chr(400)||
708: p_nationality||fnd_global.local_chr(400)||
709: p_national_identifier||fnd_global.local_chr(400)||
710: p_email_address||fnd_global.local_chr(400)||
711: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
712: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
713: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
714: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
715: p_addr_type(k).p_country||fnd_global.local_chr(400)||

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

708: p_nationality||fnd_global.local_chr(400)||
709: p_national_identifier||fnd_global.local_chr(400)||
710: p_email_address||fnd_global.local_chr(400)||
711: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
712: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
713: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
714: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
715: p_addr_type(k).p_country||fnd_global.local_chr(400)||
716: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||

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

709: p_national_identifier||fnd_global.local_chr(400)||
710: p_email_address||fnd_global.local_chr(400)||
711: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
712: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
713: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
714: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
715: p_addr_type(k).p_country||fnd_global.local_chr(400)||
716: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
717: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||

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

710: p_email_address||fnd_global.local_chr(400)||
711: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
712: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
713: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
714: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
715: p_addr_type(k).p_country||fnd_global.local_chr(400)||
716: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
717: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
718: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||

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

711: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
712: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
713: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
714: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
715: p_addr_type(k).p_country||fnd_global.local_chr(400)||
716: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
717: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
718: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
719: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||

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

712: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
713: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
714: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
715: p_addr_type(k).p_country||fnd_global.local_chr(400)||
716: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
717: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
718: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
719: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
720: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||

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

713: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
714: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
715: p_addr_type(k).p_country||fnd_global.local_chr(400)||
716: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
717: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
718: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
719: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
720: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
721: p_addr_type(k).p_region1||fnd_global.local_chr(400)||

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

714: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
715: p_addr_type(k).p_country||fnd_global.local_chr(400)||
716: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
717: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
718: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
719: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
720: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
721: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
722: p_addr_type(k).p_region2||fnd_global.local_chr(400)||

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

715: p_addr_type(k).p_country||fnd_global.local_chr(400)||
716: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
717: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
718: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
719: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
720: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
721: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
722: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
723: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||

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

716: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
717: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
718: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
719: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
720: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
721: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
722: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
723: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
724: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||

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

717: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
718: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
719: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
720: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
721: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
722: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
723: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
724: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
725: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||

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

718: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
719: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
720: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
721: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
722: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
723: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
724: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
725: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
726: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||

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

719: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
720: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
721: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
722: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
723: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
724: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
725: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
726: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
727: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||

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

720: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
721: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
722: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
723: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
724: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
725: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
726: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
727: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
728: p_national_id_label||fnd_global.local_chr(400)||

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

721: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
722: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
723: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
724: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
725: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
726: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
727: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
728: p_national_id_label||fnd_global.local_chr(400)||
729: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

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

722: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
723: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
724: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
725: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
726: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
727: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
728: p_national_id_label||fnd_global.local_chr(400)||
729: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
730: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

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

723: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
724: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
725: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
726: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
727: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
728: p_national_id_label||fnd_global.local_chr(400)||
729: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
730: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
731: fnd_global.local_chr(10)||fnd_global.local_chr(13));

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

724: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
725: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
726: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
727: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
728: p_national_id_label||fnd_global.local_chr(400)||
729: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
730: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
731: fnd_global.local_chr(10)||fnd_global.local_chr(13));
732:

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

725: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
726: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
727: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
728: p_national_id_label||fnd_global.local_chr(400)||
729: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
730: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
731: fnd_global.local_chr(10)||fnd_global.local_chr(13));
732:
733:

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

727: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
728: p_national_id_label||fnd_global.local_chr(400)||
729: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
730: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
731: fnd_global.local_chr(10)||fnd_global.local_chr(13));
732:
733:
734: else
735:

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

733:
734: else
735:
736: FND_FILE.put_line(FND_FILE.OUTPUT,
737: p_business_group_id||fnd_global.local_chr(400)||
738: p_person_id||fnd_global.local_chr(400)||
739: p_legislation_code||fnd_global.local_chr(400)||
740: p_employee_number||fnd_global.local_chr(400)||
741: p_applicant_number||fnd_global.local_chr(400)||

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

734: else
735:
736: FND_FILE.put_line(FND_FILE.OUTPUT,
737: p_business_group_id||fnd_global.local_chr(400)||
738: p_person_id||fnd_global.local_chr(400)||
739: p_legislation_code||fnd_global.local_chr(400)||
740: p_employee_number||fnd_global.local_chr(400)||
741: p_applicant_number||fnd_global.local_chr(400)||
742: p_npw_number||fnd_global.local_chr(400)||

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

735:
736: FND_FILE.put_line(FND_FILE.OUTPUT,
737: p_business_group_id||fnd_global.local_chr(400)||
738: p_person_id||fnd_global.local_chr(400)||
739: p_legislation_code||fnd_global.local_chr(400)||
740: p_employee_number||fnd_global.local_chr(400)||
741: p_applicant_number||fnd_global.local_chr(400)||
742: p_npw_number||fnd_global.local_chr(400)||
743: p_person_type_id||fnd_global.local_chr(400)||

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

736: FND_FILE.put_line(FND_FILE.OUTPUT,
737: p_business_group_id||fnd_global.local_chr(400)||
738: p_person_id||fnd_global.local_chr(400)||
739: p_legislation_code||fnd_global.local_chr(400)||
740: p_employee_number||fnd_global.local_chr(400)||
741: p_applicant_number||fnd_global.local_chr(400)||
742: p_npw_number||fnd_global.local_chr(400)||
743: p_person_type_id||fnd_global.local_chr(400)||
744: p_date_of_birth||fnd_global.local_chr(400)||

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

737: p_business_group_id||fnd_global.local_chr(400)||
738: p_person_id||fnd_global.local_chr(400)||
739: p_legislation_code||fnd_global.local_chr(400)||
740: p_employee_number||fnd_global.local_chr(400)||
741: p_applicant_number||fnd_global.local_chr(400)||
742: p_npw_number||fnd_global.local_chr(400)||
743: p_person_type_id||fnd_global.local_chr(400)||
744: p_date_of_birth||fnd_global.local_chr(400)||
745: p_town_of_birth||fnd_global.local_chr(400)||

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

738: p_person_id||fnd_global.local_chr(400)||
739: p_legislation_code||fnd_global.local_chr(400)||
740: p_employee_number||fnd_global.local_chr(400)||
741: p_applicant_number||fnd_global.local_chr(400)||
742: p_npw_number||fnd_global.local_chr(400)||
743: p_person_type_id||fnd_global.local_chr(400)||
744: p_date_of_birth||fnd_global.local_chr(400)||
745: p_town_of_birth||fnd_global.local_chr(400)||
746: p_cntry_of_birth||fnd_global.local_chr(400)||

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

739: p_legislation_code||fnd_global.local_chr(400)||
740: p_employee_number||fnd_global.local_chr(400)||
741: p_applicant_number||fnd_global.local_chr(400)||
742: p_npw_number||fnd_global.local_chr(400)||
743: p_person_type_id||fnd_global.local_chr(400)||
744: p_date_of_birth||fnd_global.local_chr(400)||
745: p_town_of_birth||fnd_global.local_chr(400)||
746: p_cntry_of_birth||fnd_global.local_chr(400)||
747: p_date_of_death||fnd_global.local_chr(400)||

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

740: p_employee_number||fnd_global.local_chr(400)||
741: p_applicant_number||fnd_global.local_chr(400)||
742: p_npw_number||fnd_global.local_chr(400)||
743: p_person_type_id||fnd_global.local_chr(400)||
744: p_date_of_birth||fnd_global.local_chr(400)||
745: p_town_of_birth||fnd_global.local_chr(400)||
746: p_cntry_of_birth||fnd_global.local_chr(400)||
747: p_date_of_death||fnd_global.local_chr(400)||
748: p_orig_dt_of_hire||fnd_global.local_chr(400)||

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

741: p_applicant_number||fnd_global.local_chr(400)||
742: p_npw_number||fnd_global.local_chr(400)||
743: p_person_type_id||fnd_global.local_chr(400)||
744: p_date_of_birth||fnd_global.local_chr(400)||
745: p_town_of_birth||fnd_global.local_chr(400)||
746: p_cntry_of_birth||fnd_global.local_chr(400)||
747: p_date_of_death||fnd_global.local_chr(400)||
748: p_orig_dt_of_hire||fnd_global.local_chr(400)||
749: p_eff_start_date||fnd_global.local_chr(400)||

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

742: p_npw_number||fnd_global.local_chr(400)||
743: p_person_type_id||fnd_global.local_chr(400)||
744: p_date_of_birth||fnd_global.local_chr(400)||
745: p_town_of_birth||fnd_global.local_chr(400)||
746: p_cntry_of_birth||fnd_global.local_chr(400)||
747: p_date_of_death||fnd_global.local_chr(400)||
748: p_orig_dt_of_hire||fnd_global.local_chr(400)||
749: p_eff_start_date||fnd_global.local_chr(400)||
750: p_eff_end_date||fnd_global.local_chr(400)||

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

743: p_person_type_id||fnd_global.local_chr(400)||
744: p_date_of_birth||fnd_global.local_chr(400)||
745: p_town_of_birth||fnd_global.local_chr(400)||
746: p_cntry_of_birth||fnd_global.local_chr(400)||
747: p_date_of_death||fnd_global.local_chr(400)||
748: p_orig_dt_of_hire||fnd_global.local_chr(400)||
749: p_eff_start_date||fnd_global.local_chr(400)||
750: p_eff_end_date||fnd_global.local_chr(400)||
751: p_sex||fnd_global.local_chr(400)||

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

744: p_date_of_birth||fnd_global.local_chr(400)||
745: p_town_of_birth||fnd_global.local_chr(400)||
746: p_cntry_of_birth||fnd_global.local_chr(400)||
747: p_date_of_death||fnd_global.local_chr(400)||
748: p_orig_dt_of_hire||fnd_global.local_chr(400)||
749: p_eff_start_date||fnd_global.local_chr(400)||
750: p_eff_end_date||fnd_global.local_chr(400)||
751: p_sex||fnd_global.local_chr(400)||
752: p_full_name||fnd_global.local_chr(400)||

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

745: p_town_of_birth||fnd_global.local_chr(400)||
746: p_cntry_of_birth||fnd_global.local_chr(400)||
747: p_date_of_death||fnd_global.local_chr(400)||
748: p_orig_dt_of_hire||fnd_global.local_chr(400)||
749: p_eff_start_date||fnd_global.local_chr(400)||
750: p_eff_end_date||fnd_global.local_chr(400)||
751: p_sex||fnd_global.local_chr(400)||
752: p_full_name||fnd_global.local_chr(400)||
753: p_suffix||fnd_global.local_chr(400)||

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

746: p_cntry_of_birth||fnd_global.local_chr(400)||
747: p_date_of_death||fnd_global.local_chr(400)||
748: p_orig_dt_of_hire||fnd_global.local_chr(400)||
749: p_eff_start_date||fnd_global.local_chr(400)||
750: p_eff_end_date||fnd_global.local_chr(400)||
751: p_sex||fnd_global.local_chr(400)||
752: p_full_name||fnd_global.local_chr(400)||
753: p_suffix||fnd_global.local_chr(400)||
754: p_title||fnd_global.local_chr(400)||

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

747: p_date_of_death||fnd_global.local_chr(400)||
748: p_orig_dt_of_hire||fnd_global.local_chr(400)||
749: p_eff_start_date||fnd_global.local_chr(400)||
750: p_eff_end_date||fnd_global.local_chr(400)||
751: p_sex||fnd_global.local_chr(400)||
752: p_full_name||fnd_global.local_chr(400)||
753: p_suffix||fnd_global.local_chr(400)||
754: p_title||fnd_global.local_chr(400)||
755: p_last_name||fnd_global.local_chr(400)||

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

748: p_orig_dt_of_hire||fnd_global.local_chr(400)||
749: p_eff_start_date||fnd_global.local_chr(400)||
750: p_eff_end_date||fnd_global.local_chr(400)||
751: p_sex||fnd_global.local_chr(400)||
752: p_full_name||fnd_global.local_chr(400)||
753: p_suffix||fnd_global.local_chr(400)||
754: p_title||fnd_global.local_chr(400)||
755: p_last_name||fnd_global.local_chr(400)||
756: p_first_name||fnd_global.local_chr(400)||

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

749: p_eff_start_date||fnd_global.local_chr(400)||
750: p_eff_end_date||fnd_global.local_chr(400)||
751: p_sex||fnd_global.local_chr(400)||
752: p_full_name||fnd_global.local_chr(400)||
753: p_suffix||fnd_global.local_chr(400)||
754: p_title||fnd_global.local_chr(400)||
755: p_last_name||fnd_global.local_chr(400)||
756: p_first_name||fnd_global.local_chr(400)||
757: p_middle_names||fnd_global.local_chr(400)||

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

750: p_eff_end_date||fnd_global.local_chr(400)||
751: p_sex||fnd_global.local_chr(400)||
752: p_full_name||fnd_global.local_chr(400)||
753: p_suffix||fnd_global.local_chr(400)||
754: p_title||fnd_global.local_chr(400)||
755: p_last_name||fnd_global.local_chr(400)||
756: p_first_name||fnd_global.local_chr(400)||
757: p_middle_names||fnd_global.local_chr(400)||
758: p_nationality||fnd_global.local_chr(400)||

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

751: p_sex||fnd_global.local_chr(400)||
752: p_full_name||fnd_global.local_chr(400)||
753: p_suffix||fnd_global.local_chr(400)||
754: p_title||fnd_global.local_chr(400)||
755: p_last_name||fnd_global.local_chr(400)||
756: p_first_name||fnd_global.local_chr(400)||
757: p_middle_names||fnd_global.local_chr(400)||
758: p_nationality||fnd_global.local_chr(400)||
759: p_national_identifier||fnd_global.local_chr(400)||

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

752: p_full_name||fnd_global.local_chr(400)||
753: p_suffix||fnd_global.local_chr(400)||
754: p_title||fnd_global.local_chr(400)||
755: p_last_name||fnd_global.local_chr(400)||
756: p_first_name||fnd_global.local_chr(400)||
757: p_middle_names||fnd_global.local_chr(400)||
758: p_nationality||fnd_global.local_chr(400)||
759: p_national_identifier||fnd_global.local_chr(400)||
760: p_email_address||fnd_global.local_chr(400)||

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

753: p_suffix||fnd_global.local_chr(400)||
754: p_title||fnd_global.local_chr(400)||
755: p_last_name||fnd_global.local_chr(400)||
756: p_first_name||fnd_global.local_chr(400)||
757: p_middle_names||fnd_global.local_chr(400)||
758: p_nationality||fnd_global.local_chr(400)||
759: p_national_identifier||fnd_global.local_chr(400)||
760: p_email_address||fnd_global.local_chr(400)||
761: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||

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

754: p_title||fnd_global.local_chr(400)||
755: p_last_name||fnd_global.local_chr(400)||
756: p_first_name||fnd_global.local_chr(400)||
757: p_middle_names||fnd_global.local_chr(400)||
758: p_nationality||fnd_global.local_chr(400)||
759: p_national_identifier||fnd_global.local_chr(400)||
760: p_email_address||fnd_global.local_chr(400)||
761: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
762: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||

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

755: p_last_name||fnd_global.local_chr(400)||
756: p_first_name||fnd_global.local_chr(400)||
757: p_middle_names||fnd_global.local_chr(400)||
758: p_nationality||fnd_global.local_chr(400)||
759: p_national_identifier||fnd_global.local_chr(400)||
760: p_email_address||fnd_global.local_chr(400)||
761: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
762: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
763: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||

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

756: p_first_name||fnd_global.local_chr(400)||
757: p_middle_names||fnd_global.local_chr(400)||
758: p_nationality||fnd_global.local_chr(400)||
759: p_national_identifier||fnd_global.local_chr(400)||
760: p_email_address||fnd_global.local_chr(400)||
761: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
762: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
763: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
764: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||

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

757: p_middle_names||fnd_global.local_chr(400)||
758: p_nationality||fnd_global.local_chr(400)||
759: p_national_identifier||fnd_global.local_chr(400)||
760: p_email_address||fnd_global.local_chr(400)||
761: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
762: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
763: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
764: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
765: p_addr_type(k).p_country||fnd_global.local_chr(400)||

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

758: p_nationality||fnd_global.local_chr(400)||
759: p_national_identifier||fnd_global.local_chr(400)||
760: p_email_address||fnd_global.local_chr(400)||
761: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
762: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
763: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
764: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
765: p_addr_type(k).p_country||fnd_global.local_chr(400)||
766: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||

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

759: p_national_identifier||fnd_global.local_chr(400)||
760: p_email_address||fnd_global.local_chr(400)||
761: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
762: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
763: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
764: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
765: p_addr_type(k).p_country||fnd_global.local_chr(400)||
766: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
767: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||

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

760: p_email_address||fnd_global.local_chr(400)||
761: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
762: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
763: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
764: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
765: p_addr_type(k).p_country||fnd_global.local_chr(400)||
766: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
767: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
768: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||

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

761: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
762: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
763: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
764: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
765: p_addr_type(k).p_country||fnd_global.local_chr(400)||
766: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
767: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
768: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
769: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||

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

762: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
763: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
764: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
765: p_addr_type(k).p_country||fnd_global.local_chr(400)||
766: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
767: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
768: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
769: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
770: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||

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

763: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
764: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
765: p_addr_type(k).p_country||fnd_global.local_chr(400)||
766: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
767: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
768: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
769: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
770: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
771: p_addr_type(k).p_region1||fnd_global.local_chr(400)||

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

764: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
765: p_addr_type(k).p_country||fnd_global.local_chr(400)||
766: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
767: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
768: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
769: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
770: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
771: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
772: p_addr_type(k).p_region2||fnd_global.local_chr(400)||

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

765: p_addr_type(k).p_country||fnd_global.local_chr(400)||
766: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
767: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
768: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
769: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
770: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
771: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
772: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
773: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||

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

766: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
767: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
768: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
769: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
770: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
771: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
772: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
773: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
774: fnd_global.local_chr(400)||

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

767: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
768: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
769: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
770: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
771: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
772: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
773: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
774: fnd_global.local_chr(400)||
775: fnd_global.local_chr(400)||

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

768: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
769: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
770: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
771: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
772: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
773: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
774: fnd_global.local_chr(400)||
775: fnd_global.local_chr(400)||
776: fnd_global.local_chr(400)||

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

769: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
770: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
771: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
772: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
773: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
774: fnd_global.local_chr(400)||
775: fnd_global.local_chr(400)||
776: fnd_global.local_chr(400)||
777: fnd_global.local_chr(400)||

Line 774: fnd_global.local_chr(400)||

770: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
771: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
772: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
773: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
774: fnd_global.local_chr(400)||
775: fnd_global.local_chr(400)||
776: fnd_global.local_chr(400)||
777: fnd_global.local_chr(400)||
778: p_national_id_label||fnd_global.local_chr(400)||

Line 775: fnd_global.local_chr(400)||

771: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
772: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
773: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
774: fnd_global.local_chr(400)||
775: fnd_global.local_chr(400)||
776: fnd_global.local_chr(400)||
777: fnd_global.local_chr(400)||
778: p_national_id_label||fnd_global.local_chr(400)||
779: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

Line 776: fnd_global.local_chr(400)||

772: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
773: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
774: fnd_global.local_chr(400)||
775: fnd_global.local_chr(400)||
776: fnd_global.local_chr(400)||
777: fnd_global.local_chr(400)||
778: p_national_id_label||fnd_global.local_chr(400)||
779: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
780: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

Line 777: fnd_global.local_chr(400)||

773: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
774: fnd_global.local_chr(400)||
775: fnd_global.local_chr(400)||
776: fnd_global.local_chr(400)||
777: fnd_global.local_chr(400)||
778: p_national_id_label||fnd_global.local_chr(400)||
779: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
780: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
781: fnd_global.local_chr(10)||fnd_global.local_chr(13));

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

774: fnd_global.local_chr(400)||
775: fnd_global.local_chr(400)||
776: fnd_global.local_chr(400)||
777: fnd_global.local_chr(400)||
778: p_national_id_label||fnd_global.local_chr(400)||
779: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
780: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
781: fnd_global.local_chr(10)||fnd_global.local_chr(13));
782:

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

775: fnd_global.local_chr(400)||
776: fnd_global.local_chr(400)||
777: fnd_global.local_chr(400)||
778: p_national_id_label||fnd_global.local_chr(400)||
779: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
780: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
781: fnd_global.local_chr(10)||fnd_global.local_chr(13));
782:
783:

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

777: fnd_global.local_chr(400)||
778: p_national_id_label||fnd_global.local_chr(400)||
779: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
780: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
781: fnd_global.local_chr(10)||fnd_global.local_chr(13));
782:
783:
784: end if;
785: end loop;

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

793: if k <= p_addr_type.count
794: then
795:
796: FND_FILE.put_line(FND_FILE.OUTPUT,
797: p_business_group_id||fnd_global.local_chr(400)||
798: p_person_id||fnd_global.local_chr(400)||
799: p_legislation_code||fnd_global.local_chr(400)||
800: p_employee_number||fnd_global.local_chr(400)||
801: p_applicant_number||fnd_global.local_chr(400)||

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

794: then
795:
796: FND_FILE.put_line(FND_FILE.OUTPUT,
797: p_business_group_id||fnd_global.local_chr(400)||
798: p_person_id||fnd_global.local_chr(400)||
799: p_legislation_code||fnd_global.local_chr(400)||
800: p_employee_number||fnd_global.local_chr(400)||
801: p_applicant_number||fnd_global.local_chr(400)||
802: p_npw_number||fnd_global.local_chr(400)||

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

795:
796: FND_FILE.put_line(FND_FILE.OUTPUT,
797: p_business_group_id||fnd_global.local_chr(400)||
798: p_person_id||fnd_global.local_chr(400)||
799: p_legislation_code||fnd_global.local_chr(400)||
800: p_employee_number||fnd_global.local_chr(400)||
801: p_applicant_number||fnd_global.local_chr(400)||
802: p_npw_number||fnd_global.local_chr(400)||
803: p_person_type_id||fnd_global.local_chr(400)||

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

796: FND_FILE.put_line(FND_FILE.OUTPUT,
797: p_business_group_id||fnd_global.local_chr(400)||
798: p_person_id||fnd_global.local_chr(400)||
799: p_legislation_code||fnd_global.local_chr(400)||
800: p_employee_number||fnd_global.local_chr(400)||
801: p_applicant_number||fnd_global.local_chr(400)||
802: p_npw_number||fnd_global.local_chr(400)||
803: p_person_type_id||fnd_global.local_chr(400)||
804: p_date_of_birth||fnd_global.local_chr(400)||

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

797: p_business_group_id||fnd_global.local_chr(400)||
798: p_person_id||fnd_global.local_chr(400)||
799: p_legislation_code||fnd_global.local_chr(400)||
800: p_employee_number||fnd_global.local_chr(400)||
801: p_applicant_number||fnd_global.local_chr(400)||
802: p_npw_number||fnd_global.local_chr(400)||
803: p_person_type_id||fnd_global.local_chr(400)||
804: p_date_of_birth||fnd_global.local_chr(400)||
805: p_town_of_birth||fnd_global.local_chr(400)||

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

798: p_person_id||fnd_global.local_chr(400)||
799: p_legislation_code||fnd_global.local_chr(400)||
800: p_employee_number||fnd_global.local_chr(400)||
801: p_applicant_number||fnd_global.local_chr(400)||
802: p_npw_number||fnd_global.local_chr(400)||
803: p_person_type_id||fnd_global.local_chr(400)||
804: p_date_of_birth||fnd_global.local_chr(400)||
805: p_town_of_birth||fnd_global.local_chr(400)||
806: p_cntry_of_birth||fnd_global.local_chr(400)||

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

799: p_legislation_code||fnd_global.local_chr(400)||
800: p_employee_number||fnd_global.local_chr(400)||
801: p_applicant_number||fnd_global.local_chr(400)||
802: p_npw_number||fnd_global.local_chr(400)||
803: p_person_type_id||fnd_global.local_chr(400)||
804: p_date_of_birth||fnd_global.local_chr(400)||
805: p_town_of_birth||fnd_global.local_chr(400)||
806: p_cntry_of_birth||fnd_global.local_chr(400)||
807: p_date_of_death||fnd_global.local_chr(400)||

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

800: p_employee_number||fnd_global.local_chr(400)||
801: p_applicant_number||fnd_global.local_chr(400)||
802: p_npw_number||fnd_global.local_chr(400)||
803: p_person_type_id||fnd_global.local_chr(400)||
804: p_date_of_birth||fnd_global.local_chr(400)||
805: p_town_of_birth||fnd_global.local_chr(400)||
806: p_cntry_of_birth||fnd_global.local_chr(400)||
807: p_date_of_death||fnd_global.local_chr(400)||
808: p_orig_dt_of_hire||fnd_global.local_chr(400)||

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

801: p_applicant_number||fnd_global.local_chr(400)||
802: p_npw_number||fnd_global.local_chr(400)||
803: p_person_type_id||fnd_global.local_chr(400)||
804: p_date_of_birth||fnd_global.local_chr(400)||
805: p_town_of_birth||fnd_global.local_chr(400)||
806: p_cntry_of_birth||fnd_global.local_chr(400)||
807: p_date_of_death||fnd_global.local_chr(400)||
808: p_orig_dt_of_hire||fnd_global.local_chr(400)||
809: p_eff_start_date||fnd_global.local_chr(400)||

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

802: p_npw_number||fnd_global.local_chr(400)||
803: p_person_type_id||fnd_global.local_chr(400)||
804: p_date_of_birth||fnd_global.local_chr(400)||
805: p_town_of_birth||fnd_global.local_chr(400)||
806: p_cntry_of_birth||fnd_global.local_chr(400)||
807: p_date_of_death||fnd_global.local_chr(400)||
808: p_orig_dt_of_hire||fnd_global.local_chr(400)||
809: p_eff_start_date||fnd_global.local_chr(400)||
810: p_eff_end_date||fnd_global.local_chr(400)||

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

803: p_person_type_id||fnd_global.local_chr(400)||
804: p_date_of_birth||fnd_global.local_chr(400)||
805: p_town_of_birth||fnd_global.local_chr(400)||
806: p_cntry_of_birth||fnd_global.local_chr(400)||
807: p_date_of_death||fnd_global.local_chr(400)||
808: p_orig_dt_of_hire||fnd_global.local_chr(400)||
809: p_eff_start_date||fnd_global.local_chr(400)||
810: p_eff_end_date||fnd_global.local_chr(400)||
811: p_sex||fnd_global.local_chr(400)||

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

804: p_date_of_birth||fnd_global.local_chr(400)||
805: p_town_of_birth||fnd_global.local_chr(400)||
806: p_cntry_of_birth||fnd_global.local_chr(400)||
807: p_date_of_death||fnd_global.local_chr(400)||
808: p_orig_dt_of_hire||fnd_global.local_chr(400)||
809: p_eff_start_date||fnd_global.local_chr(400)||
810: p_eff_end_date||fnd_global.local_chr(400)||
811: p_sex||fnd_global.local_chr(400)||
812: p_full_name||fnd_global.local_chr(400)||

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

805: p_town_of_birth||fnd_global.local_chr(400)||
806: p_cntry_of_birth||fnd_global.local_chr(400)||
807: p_date_of_death||fnd_global.local_chr(400)||
808: p_orig_dt_of_hire||fnd_global.local_chr(400)||
809: p_eff_start_date||fnd_global.local_chr(400)||
810: p_eff_end_date||fnd_global.local_chr(400)||
811: p_sex||fnd_global.local_chr(400)||
812: p_full_name||fnd_global.local_chr(400)||
813: p_suffix||fnd_global.local_chr(400)||

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

806: p_cntry_of_birth||fnd_global.local_chr(400)||
807: p_date_of_death||fnd_global.local_chr(400)||
808: p_orig_dt_of_hire||fnd_global.local_chr(400)||
809: p_eff_start_date||fnd_global.local_chr(400)||
810: p_eff_end_date||fnd_global.local_chr(400)||
811: p_sex||fnd_global.local_chr(400)||
812: p_full_name||fnd_global.local_chr(400)||
813: p_suffix||fnd_global.local_chr(400)||
814: p_title||fnd_global.local_chr(400)||

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

807: p_date_of_death||fnd_global.local_chr(400)||
808: p_orig_dt_of_hire||fnd_global.local_chr(400)||
809: p_eff_start_date||fnd_global.local_chr(400)||
810: p_eff_end_date||fnd_global.local_chr(400)||
811: p_sex||fnd_global.local_chr(400)||
812: p_full_name||fnd_global.local_chr(400)||
813: p_suffix||fnd_global.local_chr(400)||
814: p_title||fnd_global.local_chr(400)||
815: p_last_name||fnd_global.local_chr(400)||

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

808: p_orig_dt_of_hire||fnd_global.local_chr(400)||
809: p_eff_start_date||fnd_global.local_chr(400)||
810: p_eff_end_date||fnd_global.local_chr(400)||
811: p_sex||fnd_global.local_chr(400)||
812: p_full_name||fnd_global.local_chr(400)||
813: p_suffix||fnd_global.local_chr(400)||
814: p_title||fnd_global.local_chr(400)||
815: p_last_name||fnd_global.local_chr(400)||
816: p_first_name||fnd_global.local_chr(400)||

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

809: p_eff_start_date||fnd_global.local_chr(400)||
810: p_eff_end_date||fnd_global.local_chr(400)||
811: p_sex||fnd_global.local_chr(400)||
812: p_full_name||fnd_global.local_chr(400)||
813: p_suffix||fnd_global.local_chr(400)||
814: p_title||fnd_global.local_chr(400)||
815: p_last_name||fnd_global.local_chr(400)||
816: p_first_name||fnd_global.local_chr(400)||
817: p_middle_names||fnd_global.local_chr(400)||

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

810: p_eff_end_date||fnd_global.local_chr(400)||
811: p_sex||fnd_global.local_chr(400)||
812: p_full_name||fnd_global.local_chr(400)||
813: p_suffix||fnd_global.local_chr(400)||
814: p_title||fnd_global.local_chr(400)||
815: p_last_name||fnd_global.local_chr(400)||
816: p_first_name||fnd_global.local_chr(400)||
817: p_middle_names||fnd_global.local_chr(400)||
818: p_nationality||fnd_global.local_chr(400)||

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

811: p_sex||fnd_global.local_chr(400)||
812: p_full_name||fnd_global.local_chr(400)||
813: p_suffix||fnd_global.local_chr(400)||
814: p_title||fnd_global.local_chr(400)||
815: p_last_name||fnd_global.local_chr(400)||
816: p_first_name||fnd_global.local_chr(400)||
817: p_middle_names||fnd_global.local_chr(400)||
818: p_nationality||fnd_global.local_chr(400)||
819: p_national_identifier||fnd_global.local_chr(400)||

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

812: p_full_name||fnd_global.local_chr(400)||
813: p_suffix||fnd_global.local_chr(400)||
814: p_title||fnd_global.local_chr(400)||
815: p_last_name||fnd_global.local_chr(400)||
816: p_first_name||fnd_global.local_chr(400)||
817: p_middle_names||fnd_global.local_chr(400)||
818: p_nationality||fnd_global.local_chr(400)||
819: p_national_identifier||fnd_global.local_chr(400)||
820: p_email_address||fnd_global.local_chr(400)||

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

813: p_suffix||fnd_global.local_chr(400)||
814: p_title||fnd_global.local_chr(400)||
815: p_last_name||fnd_global.local_chr(400)||
816: p_first_name||fnd_global.local_chr(400)||
817: p_middle_names||fnd_global.local_chr(400)||
818: p_nationality||fnd_global.local_chr(400)||
819: p_national_identifier||fnd_global.local_chr(400)||
820: p_email_address||fnd_global.local_chr(400)||
821: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||

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

814: p_title||fnd_global.local_chr(400)||
815: p_last_name||fnd_global.local_chr(400)||
816: p_first_name||fnd_global.local_chr(400)||
817: p_middle_names||fnd_global.local_chr(400)||
818: p_nationality||fnd_global.local_chr(400)||
819: p_national_identifier||fnd_global.local_chr(400)||
820: p_email_address||fnd_global.local_chr(400)||
821: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
822: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||

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

815: p_last_name||fnd_global.local_chr(400)||
816: p_first_name||fnd_global.local_chr(400)||
817: p_middle_names||fnd_global.local_chr(400)||
818: p_nationality||fnd_global.local_chr(400)||
819: p_national_identifier||fnd_global.local_chr(400)||
820: p_email_address||fnd_global.local_chr(400)||
821: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
822: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
823: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||

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

816: p_first_name||fnd_global.local_chr(400)||
817: p_middle_names||fnd_global.local_chr(400)||
818: p_nationality||fnd_global.local_chr(400)||
819: p_national_identifier||fnd_global.local_chr(400)||
820: p_email_address||fnd_global.local_chr(400)||
821: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
822: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
823: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
824: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||

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

817: p_middle_names||fnd_global.local_chr(400)||
818: p_nationality||fnd_global.local_chr(400)||
819: p_national_identifier||fnd_global.local_chr(400)||
820: p_email_address||fnd_global.local_chr(400)||
821: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
822: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
823: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
824: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
825: p_addr_type(k).p_country||fnd_global.local_chr(400)||

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

818: p_nationality||fnd_global.local_chr(400)||
819: p_national_identifier||fnd_global.local_chr(400)||
820: p_email_address||fnd_global.local_chr(400)||
821: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
822: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
823: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
824: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
825: p_addr_type(k).p_country||fnd_global.local_chr(400)||
826: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||

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

819: p_national_identifier||fnd_global.local_chr(400)||
820: p_email_address||fnd_global.local_chr(400)||
821: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
822: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
823: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
824: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
825: p_addr_type(k).p_country||fnd_global.local_chr(400)||
826: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
827: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||

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

820: p_email_address||fnd_global.local_chr(400)||
821: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
822: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
823: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
824: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
825: p_addr_type(k).p_country||fnd_global.local_chr(400)||
826: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
827: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
828: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||

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

821: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
822: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
823: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
824: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
825: p_addr_type(k).p_country||fnd_global.local_chr(400)||
826: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
827: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
828: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
829: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||

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

822: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
823: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
824: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
825: p_addr_type(k).p_country||fnd_global.local_chr(400)||
826: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
827: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
828: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
829: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
830: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||

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

823: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
824: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
825: p_addr_type(k).p_country||fnd_global.local_chr(400)||
826: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
827: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
828: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
829: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
830: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
831: p_addr_type(k).p_region1||fnd_global.local_chr(400)||

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

824: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
825: p_addr_type(k).p_country||fnd_global.local_chr(400)||
826: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
827: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
828: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
829: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
830: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
831: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
832: p_addr_type(k).p_region2||fnd_global.local_chr(400)||

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

825: p_addr_type(k).p_country||fnd_global.local_chr(400)||
826: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
827: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
828: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
829: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
830: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
831: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
832: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
833: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||

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

826: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
827: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
828: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
829: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
830: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
831: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
832: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
833: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
834: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||

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

827: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
828: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
829: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
830: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
831: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
832: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
833: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
834: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
835: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||

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

828: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
829: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
830: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
831: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
832: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
833: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
834: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
835: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
836: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||

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

829: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
830: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
831: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
832: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
833: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
834: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
835: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
836: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
837: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||

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

830: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
831: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
832: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
833: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
834: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
835: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
836: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
837: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
838: p_national_id_label||fnd_global.local_chr(400)||

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

831: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
832: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
833: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
834: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
835: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
836: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
837: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
838: p_national_id_label||fnd_global.local_chr(400)||
839: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

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

832: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
833: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
834: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
835: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
836: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
837: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
838: p_national_id_label||fnd_global.local_chr(400)||
839: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
840: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

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

833: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
834: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
835: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
836: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
837: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
838: p_national_id_label||fnd_global.local_chr(400)||
839: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
840: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
841: fnd_global.local_chr(10)||fnd_global.local_chr(13));

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

834: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
835: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
836: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
837: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
838: p_national_id_label||fnd_global.local_chr(400)||
839: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
840: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
841: fnd_global.local_chr(10)||fnd_global.local_chr(13));
842:

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

835: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
836: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
837: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
838: p_national_id_label||fnd_global.local_chr(400)||
839: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
840: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
841: fnd_global.local_chr(10)||fnd_global.local_chr(13));
842:
843: else

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

837: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
838: p_national_id_label||fnd_global.local_chr(400)||
839: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
840: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
841: fnd_global.local_chr(10)||fnd_global.local_chr(13));
842:
843: else
844:
845: FND_FILE.put_line(FND_FILE.OUTPUT,

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

842:
843: else
844:
845: FND_FILE.put_line(FND_FILE.OUTPUT,
846: p_business_group_id||fnd_global.local_chr(400)||
847: p_person_id||fnd_global.local_chr(400)||
848: p_legislation_code||fnd_global.local_chr(400)||
849: p_employee_number||fnd_global.local_chr(400)||
850: p_applicant_number||fnd_global.local_chr(400)||

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

843: else
844:
845: FND_FILE.put_line(FND_FILE.OUTPUT,
846: p_business_group_id||fnd_global.local_chr(400)||
847: p_person_id||fnd_global.local_chr(400)||
848: p_legislation_code||fnd_global.local_chr(400)||
849: p_employee_number||fnd_global.local_chr(400)||
850: p_applicant_number||fnd_global.local_chr(400)||
851: p_npw_number||fnd_global.local_chr(400)||

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

844:
845: FND_FILE.put_line(FND_FILE.OUTPUT,
846: p_business_group_id||fnd_global.local_chr(400)||
847: p_person_id||fnd_global.local_chr(400)||
848: p_legislation_code||fnd_global.local_chr(400)||
849: p_employee_number||fnd_global.local_chr(400)||
850: p_applicant_number||fnd_global.local_chr(400)||
851: p_npw_number||fnd_global.local_chr(400)||
852: p_person_type_id||fnd_global.local_chr(400)||

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

845: FND_FILE.put_line(FND_FILE.OUTPUT,
846: p_business_group_id||fnd_global.local_chr(400)||
847: p_person_id||fnd_global.local_chr(400)||
848: p_legislation_code||fnd_global.local_chr(400)||
849: p_employee_number||fnd_global.local_chr(400)||
850: p_applicant_number||fnd_global.local_chr(400)||
851: p_npw_number||fnd_global.local_chr(400)||
852: p_person_type_id||fnd_global.local_chr(400)||
853: p_date_of_birth||fnd_global.local_chr(400)||

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

846: p_business_group_id||fnd_global.local_chr(400)||
847: p_person_id||fnd_global.local_chr(400)||
848: p_legislation_code||fnd_global.local_chr(400)||
849: p_employee_number||fnd_global.local_chr(400)||
850: p_applicant_number||fnd_global.local_chr(400)||
851: p_npw_number||fnd_global.local_chr(400)||
852: p_person_type_id||fnd_global.local_chr(400)||
853: p_date_of_birth||fnd_global.local_chr(400)||
854: p_town_of_birth||fnd_global.local_chr(400)||

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

847: p_person_id||fnd_global.local_chr(400)||
848: p_legislation_code||fnd_global.local_chr(400)||
849: p_employee_number||fnd_global.local_chr(400)||
850: p_applicant_number||fnd_global.local_chr(400)||
851: p_npw_number||fnd_global.local_chr(400)||
852: p_person_type_id||fnd_global.local_chr(400)||
853: p_date_of_birth||fnd_global.local_chr(400)||
854: p_town_of_birth||fnd_global.local_chr(400)||
855: p_cntry_of_birth||fnd_global.local_chr(400)||

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

848: p_legislation_code||fnd_global.local_chr(400)||
849: p_employee_number||fnd_global.local_chr(400)||
850: p_applicant_number||fnd_global.local_chr(400)||
851: p_npw_number||fnd_global.local_chr(400)||
852: p_person_type_id||fnd_global.local_chr(400)||
853: p_date_of_birth||fnd_global.local_chr(400)||
854: p_town_of_birth||fnd_global.local_chr(400)||
855: p_cntry_of_birth||fnd_global.local_chr(400)||
856: p_date_of_death||fnd_global.local_chr(400)||

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

849: p_employee_number||fnd_global.local_chr(400)||
850: p_applicant_number||fnd_global.local_chr(400)||
851: p_npw_number||fnd_global.local_chr(400)||
852: p_person_type_id||fnd_global.local_chr(400)||
853: p_date_of_birth||fnd_global.local_chr(400)||
854: p_town_of_birth||fnd_global.local_chr(400)||
855: p_cntry_of_birth||fnd_global.local_chr(400)||
856: p_date_of_death||fnd_global.local_chr(400)||
857: p_orig_dt_of_hire||fnd_global.local_chr(400)||

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

850: p_applicant_number||fnd_global.local_chr(400)||
851: p_npw_number||fnd_global.local_chr(400)||
852: p_person_type_id||fnd_global.local_chr(400)||
853: p_date_of_birth||fnd_global.local_chr(400)||
854: p_town_of_birth||fnd_global.local_chr(400)||
855: p_cntry_of_birth||fnd_global.local_chr(400)||
856: p_date_of_death||fnd_global.local_chr(400)||
857: p_orig_dt_of_hire||fnd_global.local_chr(400)||
858: p_eff_start_date||fnd_global.local_chr(400)||

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

851: p_npw_number||fnd_global.local_chr(400)||
852: p_person_type_id||fnd_global.local_chr(400)||
853: p_date_of_birth||fnd_global.local_chr(400)||
854: p_town_of_birth||fnd_global.local_chr(400)||
855: p_cntry_of_birth||fnd_global.local_chr(400)||
856: p_date_of_death||fnd_global.local_chr(400)||
857: p_orig_dt_of_hire||fnd_global.local_chr(400)||
858: p_eff_start_date||fnd_global.local_chr(400)||
859: p_eff_end_date||fnd_global.local_chr(400)||

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

852: p_person_type_id||fnd_global.local_chr(400)||
853: p_date_of_birth||fnd_global.local_chr(400)||
854: p_town_of_birth||fnd_global.local_chr(400)||
855: p_cntry_of_birth||fnd_global.local_chr(400)||
856: p_date_of_death||fnd_global.local_chr(400)||
857: p_orig_dt_of_hire||fnd_global.local_chr(400)||
858: p_eff_start_date||fnd_global.local_chr(400)||
859: p_eff_end_date||fnd_global.local_chr(400)||
860: p_sex||fnd_global.local_chr(400)||

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

853: p_date_of_birth||fnd_global.local_chr(400)||
854: p_town_of_birth||fnd_global.local_chr(400)||
855: p_cntry_of_birth||fnd_global.local_chr(400)||
856: p_date_of_death||fnd_global.local_chr(400)||
857: p_orig_dt_of_hire||fnd_global.local_chr(400)||
858: p_eff_start_date||fnd_global.local_chr(400)||
859: p_eff_end_date||fnd_global.local_chr(400)||
860: p_sex||fnd_global.local_chr(400)||
861: p_full_name||fnd_global.local_chr(400)||

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

854: p_town_of_birth||fnd_global.local_chr(400)||
855: p_cntry_of_birth||fnd_global.local_chr(400)||
856: p_date_of_death||fnd_global.local_chr(400)||
857: p_orig_dt_of_hire||fnd_global.local_chr(400)||
858: p_eff_start_date||fnd_global.local_chr(400)||
859: p_eff_end_date||fnd_global.local_chr(400)||
860: p_sex||fnd_global.local_chr(400)||
861: p_full_name||fnd_global.local_chr(400)||
862: p_suffix||fnd_global.local_chr(400)||

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

855: p_cntry_of_birth||fnd_global.local_chr(400)||
856: p_date_of_death||fnd_global.local_chr(400)||
857: p_orig_dt_of_hire||fnd_global.local_chr(400)||
858: p_eff_start_date||fnd_global.local_chr(400)||
859: p_eff_end_date||fnd_global.local_chr(400)||
860: p_sex||fnd_global.local_chr(400)||
861: p_full_name||fnd_global.local_chr(400)||
862: p_suffix||fnd_global.local_chr(400)||
863: p_title||fnd_global.local_chr(400)||

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

856: p_date_of_death||fnd_global.local_chr(400)||
857: p_orig_dt_of_hire||fnd_global.local_chr(400)||
858: p_eff_start_date||fnd_global.local_chr(400)||
859: p_eff_end_date||fnd_global.local_chr(400)||
860: p_sex||fnd_global.local_chr(400)||
861: p_full_name||fnd_global.local_chr(400)||
862: p_suffix||fnd_global.local_chr(400)||
863: p_title||fnd_global.local_chr(400)||
864: p_last_name||fnd_global.local_chr(400)||

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

857: p_orig_dt_of_hire||fnd_global.local_chr(400)||
858: p_eff_start_date||fnd_global.local_chr(400)||
859: p_eff_end_date||fnd_global.local_chr(400)||
860: p_sex||fnd_global.local_chr(400)||
861: p_full_name||fnd_global.local_chr(400)||
862: p_suffix||fnd_global.local_chr(400)||
863: p_title||fnd_global.local_chr(400)||
864: p_last_name||fnd_global.local_chr(400)||
865: p_first_name||fnd_global.local_chr(400)||

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

858: p_eff_start_date||fnd_global.local_chr(400)||
859: p_eff_end_date||fnd_global.local_chr(400)||
860: p_sex||fnd_global.local_chr(400)||
861: p_full_name||fnd_global.local_chr(400)||
862: p_suffix||fnd_global.local_chr(400)||
863: p_title||fnd_global.local_chr(400)||
864: p_last_name||fnd_global.local_chr(400)||
865: p_first_name||fnd_global.local_chr(400)||
866: p_middle_names||fnd_global.local_chr(400)||

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

859: p_eff_end_date||fnd_global.local_chr(400)||
860: p_sex||fnd_global.local_chr(400)||
861: p_full_name||fnd_global.local_chr(400)||
862: p_suffix||fnd_global.local_chr(400)||
863: p_title||fnd_global.local_chr(400)||
864: p_last_name||fnd_global.local_chr(400)||
865: p_first_name||fnd_global.local_chr(400)||
866: p_middle_names||fnd_global.local_chr(400)||
867: p_nationality||fnd_global.local_chr(400)||

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

860: p_sex||fnd_global.local_chr(400)||
861: p_full_name||fnd_global.local_chr(400)||
862: p_suffix||fnd_global.local_chr(400)||
863: p_title||fnd_global.local_chr(400)||
864: p_last_name||fnd_global.local_chr(400)||
865: p_first_name||fnd_global.local_chr(400)||
866: p_middle_names||fnd_global.local_chr(400)||
867: p_nationality||fnd_global.local_chr(400)||
868: p_national_identifier||fnd_global.local_chr(400)||

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

861: p_full_name||fnd_global.local_chr(400)||
862: p_suffix||fnd_global.local_chr(400)||
863: p_title||fnd_global.local_chr(400)||
864: p_last_name||fnd_global.local_chr(400)||
865: p_first_name||fnd_global.local_chr(400)||
866: p_middle_names||fnd_global.local_chr(400)||
867: p_nationality||fnd_global.local_chr(400)||
868: p_national_identifier||fnd_global.local_chr(400)||
869: p_email_address||fnd_global.local_chr(400)||

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

862: p_suffix||fnd_global.local_chr(400)||
863: p_title||fnd_global.local_chr(400)||
864: p_last_name||fnd_global.local_chr(400)||
865: p_first_name||fnd_global.local_chr(400)||
866: p_middle_names||fnd_global.local_chr(400)||
867: p_nationality||fnd_global.local_chr(400)||
868: p_national_identifier||fnd_global.local_chr(400)||
869: p_email_address||fnd_global.local_chr(400)||
870: fnd_global.local_chr(400)||

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

863: p_title||fnd_global.local_chr(400)||
864: p_last_name||fnd_global.local_chr(400)||
865: p_first_name||fnd_global.local_chr(400)||
866: p_middle_names||fnd_global.local_chr(400)||
867: p_nationality||fnd_global.local_chr(400)||
868: p_national_identifier||fnd_global.local_chr(400)||
869: p_email_address||fnd_global.local_chr(400)||
870: fnd_global.local_chr(400)||
871: fnd_global.local_chr(400)||

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

864: p_last_name||fnd_global.local_chr(400)||
865: p_first_name||fnd_global.local_chr(400)||
866: p_middle_names||fnd_global.local_chr(400)||
867: p_nationality||fnd_global.local_chr(400)||
868: p_national_identifier||fnd_global.local_chr(400)||
869: p_email_address||fnd_global.local_chr(400)||
870: fnd_global.local_chr(400)||
871: fnd_global.local_chr(400)||
872: fnd_global.local_chr(400)||

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

865: p_first_name||fnd_global.local_chr(400)||
866: p_middle_names||fnd_global.local_chr(400)||
867: p_nationality||fnd_global.local_chr(400)||
868: p_national_identifier||fnd_global.local_chr(400)||
869: p_email_address||fnd_global.local_chr(400)||
870: fnd_global.local_chr(400)||
871: fnd_global.local_chr(400)||
872: fnd_global.local_chr(400)||
873: fnd_global.local_chr(400)||

Line 870: fnd_global.local_chr(400)||

866: p_middle_names||fnd_global.local_chr(400)||
867: p_nationality||fnd_global.local_chr(400)||
868: p_national_identifier||fnd_global.local_chr(400)||
869: p_email_address||fnd_global.local_chr(400)||
870: fnd_global.local_chr(400)||
871: fnd_global.local_chr(400)||
872: fnd_global.local_chr(400)||
873: fnd_global.local_chr(400)||
874: fnd_global.local_chr(400)||

Line 871: fnd_global.local_chr(400)||

867: p_nationality||fnd_global.local_chr(400)||
868: p_national_identifier||fnd_global.local_chr(400)||
869: p_email_address||fnd_global.local_chr(400)||
870: fnd_global.local_chr(400)||
871: fnd_global.local_chr(400)||
872: fnd_global.local_chr(400)||
873: fnd_global.local_chr(400)||
874: fnd_global.local_chr(400)||
875: fnd_global.local_chr(400)||

Line 872: fnd_global.local_chr(400)||

868: p_national_identifier||fnd_global.local_chr(400)||
869: p_email_address||fnd_global.local_chr(400)||
870: fnd_global.local_chr(400)||
871: fnd_global.local_chr(400)||
872: fnd_global.local_chr(400)||
873: fnd_global.local_chr(400)||
874: fnd_global.local_chr(400)||
875: fnd_global.local_chr(400)||
876: fnd_global.local_chr(400)||

Line 873: fnd_global.local_chr(400)||

869: p_email_address||fnd_global.local_chr(400)||
870: fnd_global.local_chr(400)||
871: fnd_global.local_chr(400)||
872: fnd_global.local_chr(400)||
873: fnd_global.local_chr(400)||
874: fnd_global.local_chr(400)||
875: fnd_global.local_chr(400)||
876: fnd_global.local_chr(400)||
877: fnd_global.local_chr(400)||

Line 874: fnd_global.local_chr(400)||

870: fnd_global.local_chr(400)||
871: fnd_global.local_chr(400)||
872: fnd_global.local_chr(400)||
873: fnd_global.local_chr(400)||
874: fnd_global.local_chr(400)||
875: fnd_global.local_chr(400)||
876: fnd_global.local_chr(400)||
877: fnd_global.local_chr(400)||
878: fnd_global.local_chr(400)||

Line 875: fnd_global.local_chr(400)||

871: fnd_global.local_chr(400)||
872: fnd_global.local_chr(400)||
873: fnd_global.local_chr(400)||
874: fnd_global.local_chr(400)||
875: fnd_global.local_chr(400)||
876: fnd_global.local_chr(400)||
877: fnd_global.local_chr(400)||
878: fnd_global.local_chr(400)||
879: fnd_global.local_chr(400)||

Line 876: fnd_global.local_chr(400)||

872: fnd_global.local_chr(400)||
873: fnd_global.local_chr(400)||
874: fnd_global.local_chr(400)||
875: fnd_global.local_chr(400)||
876: fnd_global.local_chr(400)||
877: fnd_global.local_chr(400)||
878: fnd_global.local_chr(400)||
879: fnd_global.local_chr(400)||
880: fnd_global.local_chr(400)||

Line 877: fnd_global.local_chr(400)||

873: fnd_global.local_chr(400)||
874: fnd_global.local_chr(400)||
875: fnd_global.local_chr(400)||
876: fnd_global.local_chr(400)||
877: fnd_global.local_chr(400)||
878: fnd_global.local_chr(400)||
879: fnd_global.local_chr(400)||
880: fnd_global.local_chr(400)||
881: fnd_global.local_chr(400)||

Line 878: fnd_global.local_chr(400)||

874: fnd_global.local_chr(400)||
875: fnd_global.local_chr(400)||
876: fnd_global.local_chr(400)||
877: fnd_global.local_chr(400)||
878: fnd_global.local_chr(400)||
879: fnd_global.local_chr(400)||
880: fnd_global.local_chr(400)||
881: fnd_global.local_chr(400)||
882: fnd_global.local_chr(400)||

Line 879: fnd_global.local_chr(400)||

875: fnd_global.local_chr(400)||
876: fnd_global.local_chr(400)||
877: fnd_global.local_chr(400)||
878: fnd_global.local_chr(400)||
879: fnd_global.local_chr(400)||
880: fnd_global.local_chr(400)||
881: fnd_global.local_chr(400)||
882: fnd_global.local_chr(400)||
883: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||

Line 880: fnd_global.local_chr(400)||

876: fnd_global.local_chr(400)||
877: fnd_global.local_chr(400)||
878: fnd_global.local_chr(400)||
879: fnd_global.local_chr(400)||
880: fnd_global.local_chr(400)||
881: fnd_global.local_chr(400)||
882: fnd_global.local_chr(400)||
883: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
884: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||

Line 881: fnd_global.local_chr(400)||

877: fnd_global.local_chr(400)||
878: fnd_global.local_chr(400)||
879: fnd_global.local_chr(400)||
880: fnd_global.local_chr(400)||
881: fnd_global.local_chr(400)||
882: fnd_global.local_chr(400)||
883: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
884: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
885: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||

Line 882: fnd_global.local_chr(400)||

878: fnd_global.local_chr(400)||
879: fnd_global.local_chr(400)||
880: fnd_global.local_chr(400)||
881: fnd_global.local_chr(400)||
882: fnd_global.local_chr(400)||
883: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
884: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
885: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
886: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||

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

879: fnd_global.local_chr(400)||
880: fnd_global.local_chr(400)||
881: fnd_global.local_chr(400)||
882: fnd_global.local_chr(400)||
883: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
884: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
885: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
886: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
887: p_national_id_label||fnd_global.local_chr(400)||

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

880: fnd_global.local_chr(400)||
881: fnd_global.local_chr(400)||
882: fnd_global.local_chr(400)||
883: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
884: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
885: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
886: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
887: p_national_id_label||fnd_global.local_chr(400)||
888: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

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

881: fnd_global.local_chr(400)||
882: fnd_global.local_chr(400)||
883: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
884: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
885: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
886: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
887: p_national_id_label||fnd_global.local_chr(400)||
888: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
889: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

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

882: fnd_global.local_chr(400)||
883: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
884: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
885: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
886: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
887: p_national_id_label||fnd_global.local_chr(400)||
888: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
889: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
890: fnd_global.local_chr(10)||fnd_global.local_chr(13));

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

883: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
884: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
885: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
886: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
887: p_national_id_label||fnd_global.local_chr(400)||
888: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
889: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
890: fnd_global.local_chr(10)||fnd_global.local_chr(13));
891: end if;

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

884: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
885: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
886: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
887: p_national_id_label||fnd_global.local_chr(400)||
888: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
889: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
890: fnd_global.local_chr(10)||fnd_global.local_chr(13));
891: end if;
892: end loop;

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

886: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
887: p_national_id_label||fnd_global.local_chr(400)||
888: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
889: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
890: fnd_global.local_chr(10)||fnd_global.local_chr(13));
891: end if;
892: end loop;
893: end if;
894:

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

897: for k in p_phn_type.first .. p_phn_type.last
898: loop
899:
900: FND_FILE.put_line(FND_FILE.OUTPUT,
901: p_business_group_id||fnd_global.local_chr(400)||
902: p_person_id||fnd_global.local_chr(400)||
903: p_legislation_code||fnd_global.local_chr(400)||
904: p_employee_number||fnd_global.local_chr(400)||
905: p_applicant_number||fnd_global.local_chr(400)||

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

898: loop
899:
900: FND_FILE.put_line(FND_FILE.OUTPUT,
901: p_business_group_id||fnd_global.local_chr(400)||
902: p_person_id||fnd_global.local_chr(400)||
903: p_legislation_code||fnd_global.local_chr(400)||
904: p_employee_number||fnd_global.local_chr(400)||
905: p_applicant_number||fnd_global.local_chr(400)||
906: p_npw_number||fnd_global.local_chr(400)||

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

899:
900: FND_FILE.put_line(FND_FILE.OUTPUT,
901: p_business_group_id||fnd_global.local_chr(400)||
902: p_person_id||fnd_global.local_chr(400)||
903: p_legislation_code||fnd_global.local_chr(400)||
904: p_employee_number||fnd_global.local_chr(400)||
905: p_applicant_number||fnd_global.local_chr(400)||
906: p_npw_number||fnd_global.local_chr(400)||
907: p_person_type_id||fnd_global.local_chr(400)||

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

900: FND_FILE.put_line(FND_FILE.OUTPUT,
901: p_business_group_id||fnd_global.local_chr(400)||
902: p_person_id||fnd_global.local_chr(400)||
903: p_legislation_code||fnd_global.local_chr(400)||
904: p_employee_number||fnd_global.local_chr(400)||
905: p_applicant_number||fnd_global.local_chr(400)||
906: p_npw_number||fnd_global.local_chr(400)||
907: p_person_type_id||fnd_global.local_chr(400)||
908: p_date_of_birth||fnd_global.local_chr(400)||

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

901: p_business_group_id||fnd_global.local_chr(400)||
902: p_person_id||fnd_global.local_chr(400)||
903: p_legislation_code||fnd_global.local_chr(400)||
904: p_employee_number||fnd_global.local_chr(400)||
905: p_applicant_number||fnd_global.local_chr(400)||
906: p_npw_number||fnd_global.local_chr(400)||
907: p_person_type_id||fnd_global.local_chr(400)||
908: p_date_of_birth||fnd_global.local_chr(400)||
909: p_town_of_birth||fnd_global.local_chr(400)||

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

902: p_person_id||fnd_global.local_chr(400)||
903: p_legislation_code||fnd_global.local_chr(400)||
904: p_employee_number||fnd_global.local_chr(400)||
905: p_applicant_number||fnd_global.local_chr(400)||
906: p_npw_number||fnd_global.local_chr(400)||
907: p_person_type_id||fnd_global.local_chr(400)||
908: p_date_of_birth||fnd_global.local_chr(400)||
909: p_town_of_birth||fnd_global.local_chr(400)||
910: p_cntry_of_birth||fnd_global.local_chr(400)||

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

903: p_legislation_code||fnd_global.local_chr(400)||
904: p_employee_number||fnd_global.local_chr(400)||
905: p_applicant_number||fnd_global.local_chr(400)||
906: p_npw_number||fnd_global.local_chr(400)||
907: p_person_type_id||fnd_global.local_chr(400)||
908: p_date_of_birth||fnd_global.local_chr(400)||
909: p_town_of_birth||fnd_global.local_chr(400)||
910: p_cntry_of_birth||fnd_global.local_chr(400)||
911: p_date_of_death||fnd_global.local_chr(400)||

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

904: p_employee_number||fnd_global.local_chr(400)||
905: p_applicant_number||fnd_global.local_chr(400)||
906: p_npw_number||fnd_global.local_chr(400)||
907: p_person_type_id||fnd_global.local_chr(400)||
908: p_date_of_birth||fnd_global.local_chr(400)||
909: p_town_of_birth||fnd_global.local_chr(400)||
910: p_cntry_of_birth||fnd_global.local_chr(400)||
911: p_date_of_death||fnd_global.local_chr(400)||
912: p_orig_dt_of_hire||fnd_global.local_chr(400)||

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

905: p_applicant_number||fnd_global.local_chr(400)||
906: p_npw_number||fnd_global.local_chr(400)||
907: p_person_type_id||fnd_global.local_chr(400)||
908: p_date_of_birth||fnd_global.local_chr(400)||
909: p_town_of_birth||fnd_global.local_chr(400)||
910: p_cntry_of_birth||fnd_global.local_chr(400)||
911: p_date_of_death||fnd_global.local_chr(400)||
912: p_orig_dt_of_hire||fnd_global.local_chr(400)||
913: p_eff_start_date||fnd_global.local_chr(400)||

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

906: p_npw_number||fnd_global.local_chr(400)||
907: p_person_type_id||fnd_global.local_chr(400)||
908: p_date_of_birth||fnd_global.local_chr(400)||
909: p_town_of_birth||fnd_global.local_chr(400)||
910: p_cntry_of_birth||fnd_global.local_chr(400)||
911: p_date_of_death||fnd_global.local_chr(400)||
912: p_orig_dt_of_hire||fnd_global.local_chr(400)||
913: p_eff_start_date||fnd_global.local_chr(400)||
914: p_eff_end_date||fnd_global.local_chr(400)||

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

907: p_person_type_id||fnd_global.local_chr(400)||
908: p_date_of_birth||fnd_global.local_chr(400)||
909: p_town_of_birth||fnd_global.local_chr(400)||
910: p_cntry_of_birth||fnd_global.local_chr(400)||
911: p_date_of_death||fnd_global.local_chr(400)||
912: p_orig_dt_of_hire||fnd_global.local_chr(400)||
913: p_eff_start_date||fnd_global.local_chr(400)||
914: p_eff_end_date||fnd_global.local_chr(400)||
915: p_sex||fnd_global.local_chr(400)||

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

908: p_date_of_birth||fnd_global.local_chr(400)||
909: p_town_of_birth||fnd_global.local_chr(400)||
910: p_cntry_of_birth||fnd_global.local_chr(400)||
911: p_date_of_death||fnd_global.local_chr(400)||
912: p_orig_dt_of_hire||fnd_global.local_chr(400)||
913: p_eff_start_date||fnd_global.local_chr(400)||
914: p_eff_end_date||fnd_global.local_chr(400)||
915: p_sex||fnd_global.local_chr(400)||
916: p_full_name||fnd_global.local_chr(400)||

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

909: p_town_of_birth||fnd_global.local_chr(400)||
910: p_cntry_of_birth||fnd_global.local_chr(400)||
911: p_date_of_death||fnd_global.local_chr(400)||
912: p_orig_dt_of_hire||fnd_global.local_chr(400)||
913: p_eff_start_date||fnd_global.local_chr(400)||
914: p_eff_end_date||fnd_global.local_chr(400)||
915: p_sex||fnd_global.local_chr(400)||
916: p_full_name||fnd_global.local_chr(400)||
917: p_suffix||fnd_global.local_chr(400)||

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

910: p_cntry_of_birth||fnd_global.local_chr(400)||
911: p_date_of_death||fnd_global.local_chr(400)||
912: p_orig_dt_of_hire||fnd_global.local_chr(400)||
913: p_eff_start_date||fnd_global.local_chr(400)||
914: p_eff_end_date||fnd_global.local_chr(400)||
915: p_sex||fnd_global.local_chr(400)||
916: p_full_name||fnd_global.local_chr(400)||
917: p_suffix||fnd_global.local_chr(400)||
918: p_title||fnd_global.local_chr(400)||

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

911: p_date_of_death||fnd_global.local_chr(400)||
912: p_orig_dt_of_hire||fnd_global.local_chr(400)||
913: p_eff_start_date||fnd_global.local_chr(400)||
914: p_eff_end_date||fnd_global.local_chr(400)||
915: p_sex||fnd_global.local_chr(400)||
916: p_full_name||fnd_global.local_chr(400)||
917: p_suffix||fnd_global.local_chr(400)||
918: p_title||fnd_global.local_chr(400)||
919: p_last_name||fnd_global.local_chr(400)||

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

912: p_orig_dt_of_hire||fnd_global.local_chr(400)||
913: p_eff_start_date||fnd_global.local_chr(400)||
914: p_eff_end_date||fnd_global.local_chr(400)||
915: p_sex||fnd_global.local_chr(400)||
916: p_full_name||fnd_global.local_chr(400)||
917: p_suffix||fnd_global.local_chr(400)||
918: p_title||fnd_global.local_chr(400)||
919: p_last_name||fnd_global.local_chr(400)||
920: p_first_name||fnd_global.local_chr(400)||

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

913: p_eff_start_date||fnd_global.local_chr(400)||
914: p_eff_end_date||fnd_global.local_chr(400)||
915: p_sex||fnd_global.local_chr(400)||
916: p_full_name||fnd_global.local_chr(400)||
917: p_suffix||fnd_global.local_chr(400)||
918: p_title||fnd_global.local_chr(400)||
919: p_last_name||fnd_global.local_chr(400)||
920: p_first_name||fnd_global.local_chr(400)||
921: p_middle_names||fnd_global.local_chr(400)||

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

914: p_eff_end_date||fnd_global.local_chr(400)||
915: p_sex||fnd_global.local_chr(400)||
916: p_full_name||fnd_global.local_chr(400)||
917: p_suffix||fnd_global.local_chr(400)||
918: p_title||fnd_global.local_chr(400)||
919: p_last_name||fnd_global.local_chr(400)||
920: p_first_name||fnd_global.local_chr(400)||
921: p_middle_names||fnd_global.local_chr(400)||
922: p_nationality||fnd_global.local_chr(400)||

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

915: p_sex||fnd_global.local_chr(400)||
916: p_full_name||fnd_global.local_chr(400)||
917: p_suffix||fnd_global.local_chr(400)||
918: p_title||fnd_global.local_chr(400)||
919: p_last_name||fnd_global.local_chr(400)||
920: p_first_name||fnd_global.local_chr(400)||
921: p_middle_names||fnd_global.local_chr(400)||
922: p_nationality||fnd_global.local_chr(400)||
923: p_national_identifier||fnd_global.local_chr(400)||

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

916: p_full_name||fnd_global.local_chr(400)||
917: p_suffix||fnd_global.local_chr(400)||
918: p_title||fnd_global.local_chr(400)||
919: p_last_name||fnd_global.local_chr(400)||
920: p_first_name||fnd_global.local_chr(400)||
921: p_middle_names||fnd_global.local_chr(400)||
922: p_nationality||fnd_global.local_chr(400)||
923: p_national_identifier||fnd_global.local_chr(400)||
924: p_email_address||fnd_global.local_chr(400)||

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

917: p_suffix||fnd_global.local_chr(400)||
918: p_title||fnd_global.local_chr(400)||
919: p_last_name||fnd_global.local_chr(400)||
920: p_first_name||fnd_global.local_chr(400)||
921: p_middle_names||fnd_global.local_chr(400)||
922: p_nationality||fnd_global.local_chr(400)||
923: p_national_identifier||fnd_global.local_chr(400)||
924: p_email_address||fnd_global.local_chr(400)||
925: fnd_global.local_chr(400)||

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

918: p_title||fnd_global.local_chr(400)||
919: p_last_name||fnd_global.local_chr(400)||
920: p_first_name||fnd_global.local_chr(400)||
921: p_middle_names||fnd_global.local_chr(400)||
922: p_nationality||fnd_global.local_chr(400)||
923: p_national_identifier||fnd_global.local_chr(400)||
924: p_email_address||fnd_global.local_chr(400)||
925: fnd_global.local_chr(400)||
926: fnd_global.local_chr(400)||

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

919: p_last_name||fnd_global.local_chr(400)||
920: p_first_name||fnd_global.local_chr(400)||
921: p_middle_names||fnd_global.local_chr(400)||
922: p_nationality||fnd_global.local_chr(400)||
923: p_national_identifier||fnd_global.local_chr(400)||
924: p_email_address||fnd_global.local_chr(400)||
925: fnd_global.local_chr(400)||
926: fnd_global.local_chr(400)||
927: fnd_global.local_chr(400)||

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

920: p_first_name||fnd_global.local_chr(400)||
921: p_middle_names||fnd_global.local_chr(400)||
922: p_nationality||fnd_global.local_chr(400)||
923: p_national_identifier||fnd_global.local_chr(400)||
924: p_email_address||fnd_global.local_chr(400)||
925: fnd_global.local_chr(400)||
926: fnd_global.local_chr(400)||
927: fnd_global.local_chr(400)||
928: fnd_global.local_chr(400)||

Line 925: fnd_global.local_chr(400)||

921: p_middle_names||fnd_global.local_chr(400)||
922: p_nationality||fnd_global.local_chr(400)||
923: p_national_identifier||fnd_global.local_chr(400)||
924: p_email_address||fnd_global.local_chr(400)||
925: fnd_global.local_chr(400)||
926: fnd_global.local_chr(400)||
927: fnd_global.local_chr(400)||
928: fnd_global.local_chr(400)||
929: fnd_global.local_chr(400)||

Line 926: fnd_global.local_chr(400)||

922: p_nationality||fnd_global.local_chr(400)||
923: p_national_identifier||fnd_global.local_chr(400)||
924: p_email_address||fnd_global.local_chr(400)||
925: fnd_global.local_chr(400)||
926: fnd_global.local_chr(400)||
927: fnd_global.local_chr(400)||
928: fnd_global.local_chr(400)||
929: fnd_global.local_chr(400)||
930: fnd_global.local_chr(400)||

Line 927: fnd_global.local_chr(400)||

923: p_national_identifier||fnd_global.local_chr(400)||
924: p_email_address||fnd_global.local_chr(400)||
925: fnd_global.local_chr(400)||
926: fnd_global.local_chr(400)||
927: fnd_global.local_chr(400)||
928: fnd_global.local_chr(400)||
929: fnd_global.local_chr(400)||
930: fnd_global.local_chr(400)||
931: fnd_global.local_chr(400)||

Line 928: fnd_global.local_chr(400)||

924: p_email_address||fnd_global.local_chr(400)||
925: fnd_global.local_chr(400)||
926: fnd_global.local_chr(400)||
927: fnd_global.local_chr(400)||
928: fnd_global.local_chr(400)||
929: fnd_global.local_chr(400)||
930: fnd_global.local_chr(400)||
931: fnd_global.local_chr(400)||
932: fnd_global.local_chr(400)||

Line 929: fnd_global.local_chr(400)||

925: fnd_global.local_chr(400)||
926: fnd_global.local_chr(400)||
927: fnd_global.local_chr(400)||
928: fnd_global.local_chr(400)||
929: fnd_global.local_chr(400)||
930: fnd_global.local_chr(400)||
931: fnd_global.local_chr(400)||
932: fnd_global.local_chr(400)||
933: fnd_global.local_chr(400)||

Line 930: fnd_global.local_chr(400)||

926: fnd_global.local_chr(400)||
927: fnd_global.local_chr(400)||
928: fnd_global.local_chr(400)||
929: fnd_global.local_chr(400)||
930: fnd_global.local_chr(400)||
931: fnd_global.local_chr(400)||
932: fnd_global.local_chr(400)||
933: fnd_global.local_chr(400)||
934: fnd_global.local_chr(400)||

Line 931: fnd_global.local_chr(400)||

927: fnd_global.local_chr(400)||
928: fnd_global.local_chr(400)||
929: fnd_global.local_chr(400)||
930: fnd_global.local_chr(400)||
931: fnd_global.local_chr(400)||
932: fnd_global.local_chr(400)||
933: fnd_global.local_chr(400)||
934: fnd_global.local_chr(400)||
935: fnd_global.local_chr(400)||

Line 932: fnd_global.local_chr(400)||

928: fnd_global.local_chr(400)||
929: fnd_global.local_chr(400)||
930: fnd_global.local_chr(400)||
931: fnd_global.local_chr(400)||
932: fnd_global.local_chr(400)||
933: fnd_global.local_chr(400)||
934: fnd_global.local_chr(400)||
935: fnd_global.local_chr(400)||
936: fnd_global.local_chr(400)||

Line 933: fnd_global.local_chr(400)||

929: fnd_global.local_chr(400)||
930: fnd_global.local_chr(400)||
931: fnd_global.local_chr(400)||
932: fnd_global.local_chr(400)||
933: fnd_global.local_chr(400)||
934: fnd_global.local_chr(400)||
935: fnd_global.local_chr(400)||
936: fnd_global.local_chr(400)||
937: fnd_global.local_chr(400)||

Line 934: fnd_global.local_chr(400)||

930: fnd_global.local_chr(400)||
931: fnd_global.local_chr(400)||
932: fnd_global.local_chr(400)||
933: fnd_global.local_chr(400)||
934: fnd_global.local_chr(400)||
935: fnd_global.local_chr(400)||
936: fnd_global.local_chr(400)||
937: fnd_global.local_chr(400)||
938: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||

Line 935: fnd_global.local_chr(400)||

931: fnd_global.local_chr(400)||
932: fnd_global.local_chr(400)||
933: fnd_global.local_chr(400)||
934: fnd_global.local_chr(400)||
935: fnd_global.local_chr(400)||
936: fnd_global.local_chr(400)||
937: fnd_global.local_chr(400)||
938: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
939: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||

Line 936: fnd_global.local_chr(400)||

932: fnd_global.local_chr(400)||
933: fnd_global.local_chr(400)||
934: fnd_global.local_chr(400)||
935: fnd_global.local_chr(400)||
936: fnd_global.local_chr(400)||
937: fnd_global.local_chr(400)||
938: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
939: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
940: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||

Line 937: fnd_global.local_chr(400)||

933: fnd_global.local_chr(400)||
934: fnd_global.local_chr(400)||
935: fnd_global.local_chr(400)||
936: fnd_global.local_chr(400)||
937: fnd_global.local_chr(400)||
938: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
939: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
940: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
941: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||

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

934: fnd_global.local_chr(400)||
935: fnd_global.local_chr(400)||
936: fnd_global.local_chr(400)||
937: fnd_global.local_chr(400)||
938: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
939: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
940: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
941: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
942: p_national_id_label||fnd_global.local_chr(400)||

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

935: fnd_global.local_chr(400)||
936: fnd_global.local_chr(400)||
937: fnd_global.local_chr(400)||
938: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
939: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
940: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
941: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
942: p_national_id_label||fnd_global.local_chr(400)||
943: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

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

936: fnd_global.local_chr(400)||
937: fnd_global.local_chr(400)||
938: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
939: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
940: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
941: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
942: p_national_id_label||fnd_global.local_chr(400)||
943: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
944: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

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

937: fnd_global.local_chr(400)||
938: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
939: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
940: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
941: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
942: p_national_id_label||fnd_global.local_chr(400)||
943: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
944: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
945: fnd_global.local_chr(10)||fnd_global.local_chr(13));

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

938: p_phn_type(k).p_phn_date_from||fnd_global.local_chr(400)||
939: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
940: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
941: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
942: p_national_id_label||fnd_global.local_chr(400)||
943: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
944: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
945: fnd_global.local_chr(10)||fnd_global.local_chr(13));
946:

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

939: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
940: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
941: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
942: p_national_id_label||fnd_global.local_chr(400)||
943: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
944: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
945: fnd_global.local_chr(10)||fnd_global.local_chr(13));
946:
947: end loop;

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

941: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
942: p_national_id_label||fnd_global.local_chr(400)||
943: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
944: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
945: fnd_global.local_chr(10)||fnd_global.local_chr(13));
946:
947: end loop;
948: end if;
949:

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

952: for k in p_addr_type.first .. p_addr_type.last
953: loop
954:
955: FND_FILE.put_line(FND_FILE.OUTPUT,
956: p_business_group_id||fnd_global.local_chr(400)||
957: p_person_id||fnd_global.local_chr(400)||
958: p_legislation_code||fnd_global.local_chr(400)||
959: p_employee_number||fnd_global.local_chr(400)||
960: p_applicant_number||fnd_global.local_chr(400)||

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

953: loop
954:
955: FND_FILE.put_line(FND_FILE.OUTPUT,
956: p_business_group_id||fnd_global.local_chr(400)||
957: p_person_id||fnd_global.local_chr(400)||
958: p_legislation_code||fnd_global.local_chr(400)||
959: p_employee_number||fnd_global.local_chr(400)||
960: p_applicant_number||fnd_global.local_chr(400)||
961: p_npw_number||fnd_global.local_chr(400)||

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

954:
955: FND_FILE.put_line(FND_FILE.OUTPUT,
956: p_business_group_id||fnd_global.local_chr(400)||
957: p_person_id||fnd_global.local_chr(400)||
958: p_legislation_code||fnd_global.local_chr(400)||
959: p_employee_number||fnd_global.local_chr(400)||
960: p_applicant_number||fnd_global.local_chr(400)||
961: p_npw_number||fnd_global.local_chr(400)||
962: p_person_type_id||fnd_global.local_chr(400)||

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

955: FND_FILE.put_line(FND_FILE.OUTPUT,
956: p_business_group_id||fnd_global.local_chr(400)||
957: p_person_id||fnd_global.local_chr(400)||
958: p_legislation_code||fnd_global.local_chr(400)||
959: p_employee_number||fnd_global.local_chr(400)||
960: p_applicant_number||fnd_global.local_chr(400)||
961: p_npw_number||fnd_global.local_chr(400)||
962: p_person_type_id||fnd_global.local_chr(400)||
963: p_date_of_birth||fnd_global.local_chr(400)||

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

956: p_business_group_id||fnd_global.local_chr(400)||
957: p_person_id||fnd_global.local_chr(400)||
958: p_legislation_code||fnd_global.local_chr(400)||
959: p_employee_number||fnd_global.local_chr(400)||
960: p_applicant_number||fnd_global.local_chr(400)||
961: p_npw_number||fnd_global.local_chr(400)||
962: p_person_type_id||fnd_global.local_chr(400)||
963: p_date_of_birth||fnd_global.local_chr(400)||
964: p_town_of_birth||fnd_global.local_chr(400)||

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

957: p_person_id||fnd_global.local_chr(400)||
958: p_legislation_code||fnd_global.local_chr(400)||
959: p_employee_number||fnd_global.local_chr(400)||
960: p_applicant_number||fnd_global.local_chr(400)||
961: p_npw_number||fnd_global.local_chr(400)||
962: p_person_type_id||fnd_global.local_chr(400)||
963: p_date_of_birth||fnd_global.local_chr(400)||
964: p_town_of_birth||fnd_global.local_chr(400)||
965: p_cntry_of_birth||fnd_global.local_chr(400)||

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

958: p_legislation_code||fnd_global.local_chr(400)||
959: p_employee_number||fnd_global.local_chr(400)||
960: p_applicant_number||fnd_global.local_chr(400)||
961: p_npw_number||fnd_global.local_chr(400)||
962: p_person_type_id||fnd_global.local_chr(400)||
963: p_date_of_birth||fnd_global.local_chr(400)||
964: p_town_of_birth||fnd_global.local_chr(400)||
965: p_cntry_of_birth||fnd_global.local_chr(400)||
966: p_date_of_death||fnd_global.local_chr(400)||

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

959: p_employee_number||fnd_global.local_chr(400)||
960: p_applicant_number||fnd_global.local_chr(400)||
961: p_npw_number||fnd_global.local_chr(400)||
962: p_person_type_id||fnd_global.local_chr(400)||
963: p_date_of_birth||fnd_global.local_chr(400)||
964: p_town_of_birth||fnd_global.local_chr(400)||
965: p_cntry_of_birth||fnd_global.local_chr(400)||
966: p_date_of_death||fnd_global.local_chr(400)||
967: p_orig_dt_of_hire||fnd_global.local_chr(400)||

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

960: p_applicant_number||fnd_global.local_chr(400)||
961: p_npw_number||fnd_global.local_chr(400)||
962: p_person_type_id||fnd_global.local_chr(400)||
963: p_date_of_birth||fnd_global.local_chr(400)||
964: p_town_of_birth||fnd_global.local_chr(400)||
965: p_cntry_of_birth||fnd_global.local_chr(400)||
966: p_date_of_death||fnd_global.local_chr(400)||
967: p_orig_dt_of_hire||fnd_global.local_chr(400)||
968: p_eff_start_date||fnd_global.local_chr(400)||

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

961: p_npw_number||fnd_global.local_chr(400)||
962: p_person_type_id||fnd_global.local_chr(400)||
963: p_date_of_birth||fnd_global.local_chr(400)||
964: p_town_of_birth||fnd_global.local_chr(400)||
965: p_cntry_of_birth||fnd_global.local_chr(400)||
966: p_date_of_death||fnd_global.local_chr(400)||
967: p_orig_dt_of_hire||fnd_global.local_chr(400)||
968: p_eff_start_date||fnd_global.local_chr(400)||
969: p_eff_end_date||fnd_global.local_chr(400)||

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

962: p_person_type_id||fnd_global.local_chr(400)||
963: p_date_of_birth||fnd_global.local_chr(400)||
964: p_town_of_birth||fnd_global.local_chr(400)||
965: p_cntry_of_birth||fnd_global.local_chr(400)||
966: p_date_of_death||fnd_global.local_chr(400)||
967: p_orig_dt_of_hire||fnd_global.local_chr(400)||
968: p_eff_start_date||fnd_global.local_chr(400)||
969: p_eff_end_date||fnd_global.local_chr(400)||
970: p_sex||fnd_global.local_chr(400)||

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

963: p_date_of_birth||fnd_global.local_chr(400)||
964: p_town_of_birth||fnd_global.local_chr(400)||
965: p_cntry_of_birth||fnd_global.local_chr(400)||
966: p_date_of_death||fnd_global.local_chr(400)||
967: p_orig_dt_of_hire||fnd_global.local_chr(400)||
968: p_eff_start_date||fnd_global.local_chr(400)||
969: p_eff_end_date||fnd_global.local_chr(400)||
970: p_sex||fnd_global.local_chr(400)||
971: p_full_name||fnd_global.local_chr(400)||

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

964: p_town_of_birth||fnd_global.local_chr(400)||
965: p_cntry_of_birth||fnd_global.local_chr(400)||
966: p_date_of_death||fnd_global.local_chr(400)||
967: p_orig_dt_of_hire||fnd_global.local_chr(400)||
968: p_eff_start_date||fnd_global.local_chr(400)||
969: p_eff_end_date||fnd_global.local_chr(400)||
970: p_sex||fnd_global.local_chr(400)||
971: p_full_name||fnd_global.local_chr(400)||
972: p_suffix||fnd_global.local_chr(400)||

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

965: p_cntry_of_birth||fnd_global.local_chr(400)||
966: p_date_of_death||fnd_global.local_chr(400)||
967: p_orig_dt_of_hire||fnd_global.local_chr(400)||
968: p_eff_start_date||fnd_global.local_chr(400)||
969: p_eff_end_date||fnd_global.local_chr(400)||
970: p_sex||fnd_global.local_chr(400)||
971: p_full_name||fnd_global.local_chr(400)||
972: p_suffix||fnd_global.local_chr(400)||
973: p_title||fnd_global.local_chr(400)||

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

966: p_date_of_death||fnd_global.local_chr(400)||
967: p_orig_dt_of_hire||fnd_global.local_chr(400)||
968: p_eff_start_date||fnd_global.local_chr(400)||
969: p_eff_end_date||fnd_global.local_chr(400)||
970: p_sex||fnd_global.local_chr(400)||
971: p_full_name||fnd_global.local_chr(400)||
972: p_suffix||fnd_global.local_chr(400)||
973: p_title||fnd_global.local_chr(400)||
974: p_last_name||fnd_global.local_chr(400)||

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

967: p_orig_dt_of_hire||fnd_global.local_chr(400)||
968: p_eff_start_date||fnd_global.local_chr(400)||
969: p_eff_end_date||fnd_global.local_chr(400)||
970: p_sex||fnd_global.local_chr(400)||
971: p_full_name||fnd_global.local_chr(400)||
972: p_suffix||fnd_global.local_chr(400)||
973: p_title||fnd_global.local_chr(400)||
974: p_last_name||fnd_global.local_chr(400)||
975: p_first_name||fnd_global.local_chr(400)||

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

968: p_eff_start_date||fnd_global.local_chr(400)||
969: p_eff_end_date||fnd_global.local_chr(400)||
970: p_sex||fnd_global.local_chr(400)||
971: p_full_name||fnd_global.local_chr(400)||
972: p_suffix||fnd_global.local_chr(400)||
973: p_title||fnd_global.local_chr(400)||
974: p_last_name||fnd_global.local_chr(400)||
975: p_first_name||fnd_global.local_chr(400)||
976: p_middle_names||fnd_global.local_chr(400)||

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

969: p_eff_end_date||fnd_global.local_chr(400)||
970: p_sex||fnd_global.local_chr(400)||
971: p_full_name||fnd_global.local_chr(400)||
972: p_suffix||fnd_global.local_chr(400)||
973: p_title||fnd_global.local_chr(400)||
974: p_last_name||fnd_global.local_chr(400)||
975: p_first_name||fnd_global.local_chr(400)||
976: p_middle_names||fnd_global.local_chr(400)||
977: p_nationality||fnd_global.local_chr(400)||

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

970: p_sex||fnd_global.local_chr(400)||
971: p_full_name||fnd_global.local_chr(400)||
972: p_suffix||fnd_global.local_chr(400)||
973: p_title||fnd_global.local_chr(400)||
974: p_last_name||fnd_global.local_chr(400)||
975: p_first_name||fnd_global.local_chr(400)||
976: p_middle_names||fnd_global.local_chr(400)||
977: p_nationality||fnd_global.local_chr(400)||
978: p_national_identifier||fnd_global.local_chr(400)||

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

971: p_full_name||fnd_global.local_chr(400)||
972: p_suffix||fnd_global.local_chr(400)||
973: p_title||fnd_global.local_chr(400)||
974: p_last_name||fnd_global.local_chr(400)||
975: p_first_name||fnd_global.local_chr(400)||
976: p_middle_names||fnd_global.local_chr(400)||
977: p_nationality||fnd_global.local_chr(400)||
978: p_national_identifier||fnd_global.local_chr(400)||
979: p_email_address||fnd_global.local_chr(400)||

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

972: p_suffix||fnd_global.local_chr(400)||
973: p_title||fnd_global.local_chr(400)||
974: p_last_name||fnd_global.local_chr(400)||
975: p_first_name||fnd_global.local_chr(400)||
976: p_middle_names||fnd_global.local_chr(400)||
977: p_nationality||fnd_global.local_chr(400)||
978: p_national_identifier||fnd_global.local_chr(400)||
979: p_email_address||fnd_global.local_chr(400)||
980: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||

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

973: p_title||fnd_global.local_chr(400)||
974: p_last_name||fnd_global.local_chr(400)||
975: p_first_name||fnd_global.local_chr(400)||
976: p_middle_names||fnd_global.local_chr(400)||
977: p_nationality||fnd_global.local_chr(400)||
978: p_national_identifier||fnd_global.local_chr(400)||
979: p_email_address||fnd_global.local_chr(400)||
980: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
981: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||

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

974: p_last_name||fnd_global.local_chr(400)||
975: p_first_name||fnd_global.local_chr(400)||
976: p_middle_names||fnd_global.local_chr(400)||
977: p_nationality||fnd_global.local_chr(400)||
978: p_national_identifier||fnd_global.local_chr(400)||
979: p_email_address||fnd_global.local_chr(400)||
980: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
981: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
982: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||

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

975: p_first_name||fnd_global.local_chr(400)||
976: p_middle_names||fnd_global.local_chr(400)||
977: p_nationality||fnd_global.local_chr(400)||
978: p_national_identifier||fnd_global.local_chr(400)||
979: p_email_address||fnd_global.local_chr(400)||
980: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
981: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
982: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
983: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||

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

976: p_middle_names||fnd_global.local_chr(400)||
977: p_nationality||fnd_global.local_chr(400)||
978: p_national_identifier||fnd_global.local_chr(400)||
979: p_email_address||fnd_global.local_chr(400)||
980: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
981: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
982: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
983: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
984: p_addr_type(k).p_country||fnd_global.local_chr(400)||

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

977: p_nationality||fnd_global.local_chr(400)||
978: p_national_identifier||fnd_global.local_chr(400)||
979: p_email_address||fnd_global.local_chr(400)||
980: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
981: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
982: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
983: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
984: p_addr_type(k).p_country||fnd_global.local_chr(400)||
985: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||

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

978: p_national_identifier||fnd_global.local_chr(400)||
979: p_email_address||fnd_global.local_chr(400)||
980: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
981: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
982: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
983: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
984: p_addr_type(k).p_country||fnd_global.local_chr(400)||
985: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
986: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||

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

979: p_email_address||fnd_global.local_chr(400)||
980: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
981: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
982: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
983: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
984: p_addr_type(k).p_country||fnd_global.local_chr(400)||
985: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
986: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
987: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||

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

980: p_addr_type(k).p_address_type||fnd_global.local_chr(400)||
981: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
982: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
983: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
984: p_addr_type(k).p_country||fnd_global.local_chr(400)||
985: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
986: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
987: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
988: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||

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

981: p_addr_type(k).p_adr_date_from||fnd_global.local_chr(400)||
982: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
983: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
984: p_addr_type(k).p_country||fnd_global.local_chr(400)||
985: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
986: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
987: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
988: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
989: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||

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

982: p_addr_type(k).p_adr_date_to||fnd_global.local_chr(400)||
983: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
984: p_addr_type(k).p_country||fnd_global.local_chr(400)||
985: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
986: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
987: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
988: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
989: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
990: p_addr_type(k).p_region1||fnd_global.local_chr(400)||

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

983: p_addr_type(k).p_address_style||fnd_global.local_chr(400)||
984: p_addr_type(k).p_country||fnd_global.local_chr(400)||
985: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
986: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
987: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
988: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
989: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
990: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
991: p_addr_type(k).p_region2||fnd_global.local_chr(400)||

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

984: p_addr_type(k).p_country||fnd_global.local_chr(400)||
985: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
986: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
987: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
988: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
989: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
990: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
991: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
992: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||

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

985: p_addr_type(k).p_addr_line1||fnd_global.local_chr(400)||
986: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
987: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
988: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
989: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
990: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
991: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
992: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
993: fnd_global.local_chr(400)||

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

986: p_addr_type(k).p_addr_line2||fnd_global.local_chr(400)||
987: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
988: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
989: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
990: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
991: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
992: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
993: fnd_global.local_chr(400)||
994: fnd_global.local_chr(400)||

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

987: p_addr_type(k).p_addr_line3||fnd_global.local_chr(400)||
988: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
989: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
990: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
991: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
992: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
993: fnd_global.local_chr(400)||
994: fnd_global.local_chr(400)||
995: fnd_global.local_chr(400)||

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

988: p_addr_type(k).p_twn_or_city||fnd_global.local_chr(400)||
989: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
990: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
991: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
992: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
993: fnd_global.local_chr(400)||
994: fnd_global.local_chr(400)||
995: fnd_global.local_chr(400)||
996: fnd_global.local_chr(400)||

Line 993: fnd_global.local_chr(400)||

989: p_addr_type(k).p_tel_number1||fnd_global.local_chr(400)||
990: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
991: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
992: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
993: fnd_global.local_chr(400)||
994: fnd_global.local_chr(400)||
995: fnd_global.local_chr(400)||
996: fnd_global.local_chr(400)||
997: p_national_id_label||fnd_global.local_chr(400)||

Line 994: fnd_global.local_chr(400)||

990: p_addr_type(k).p_region1||fnd_global.local_chr(400)||
991: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
992: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
993: fnd_global.local_chr(400)||
994: fnd_global.local_chr(400)||
995: fnd_global.local_chr(400)||
996: fnd_global.local_chr(400)||
997: p_national_id_label||fnd_global.local_chr(400)||
998: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

Line 995: fnd_global.local_chr(400)||

991: p_addr_type(k).p_region2||fnd_global.local_chr(400)||
992: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
993: fnd_global.local_chr(400)||
994: fnd_global.local_chr(400)||
995: fnd_global.local_chr(400)||
996: fnd_global.local_chr(400)||
997: p_national_id_label||fnd_global.local_chr(400)||
998: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
999: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

Line 996: fnd_global.local_chr(400)||

992: p_addr_type(k).p_postal_code ||fnd_global.local_chr(400)||
993: fnd_global.local_chr(400)||
994: fnd_global.local_chr(400)||
995: fnd_global.local_chr(400)||
996: fnd_global.local_chr(400)||
997: p_national_id_label||fnd_global.local_chr(400)||
998: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
999: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1000: fnd_global.local_chr(10)||fnd_global.local_chr(13));

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

993: fnd_global.local_chr(400)||
994: fnd_global.local_chr(400)||
995: fnd_global.local_chr(400)||
996: fnd_global.local_chr(400)||
997: p_national_id_label||fnd_global.local_chr(400)||
998: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
999: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1000: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1001:

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

994: fnd_global.local_chr(400)||
995: fnd_global.local_chr(400)||
996: fnd_global.local_chr(400)||
997: p_national_id_label||fnd_global.local_chr(400)||
998: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
999: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1000: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1001:
1002: end loop;

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

996: fnd_global.local_chr(400)||
997: p_national_id_label||fnd_global.local_chr(400)||
998: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
999: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1000: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1001:
1002: end loop;
1003: end if;
1004:

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

1007: then
1008:
1009:
1010: FND_FILE.put_line(FND_FILE.OUTPUT,
1011: p_business_group_id||fnd_global.local_chr(400)||
1012: p_person_id||fnd_global.local_chr(400)||
1013: p_legislation_code||fnd_global.local_chr(400)||
1014: p_employee_number||fnd_global.local_chr(400)||
1015: p_applicant_number||fnd_global.local_chr(400)||

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

1008:
1009:
1010: FND_FILE.put_line(FND_FILE.OUTPUT,
1011: p_business_group_id||fnd_global.local_chr(400)||
1012: p_person_id||fnd_global.local_chr(400)||
1013: p_legislation_code||fnd_global.local_chr(400)||
1014: p_employee_number||fnd_global.local_chr(400)||
1015: p_applicant_number||fnd_global.local_chr(400)||
1016: p_npw_number||fnd_global.local_chr(400)||

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

1009:
1010: FND_FILE.put_line(FND_FILE.OUTPUT,
1011: p_business_group_id||fnd_global.local_chr(400)||
1012: p_person_id||fnd_global.local_chr(400)||
1013: p_legislation_code||fnd_global.local_chr(400)||
1014: p_employee_number||fnd_global.local_chr(400)||
1015: p_applicant_number||fnd_global.local_chr(400)||
1016: p_npw_number||fnd_global.local_chr(400)||
1017: p_person_type_id||fnd_global.local_chr(400)||

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

1010: FND_FILE.put_line(FND_FILE.OUTPUT,
1011: p_business_group_id||fnd_global.local_chr(400)||
1012: p_person_id||fnd_global.local_chr(400)||
1013: p_legislation_code||fnd_global.local_chr(400)||
1014: p_employee_number||fnd_global.local_chr(400)||
1015: p_applicant_number||fnd_global.local_chr(400)||
1016: p_npw_number||fnd_global.local_chr(400)||
1017: p_person_type_id||fnd_global.local_chr(400)||
1018: p_date_of_birth||fnd_global.local_chr(400)||

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

1011: p_business_group_id||fnd_global.local_chr(400)||
1012: p_person_id||fnd_global.local_chr(400)||
1013: p_legislation_code||fnd_global.local_chr(400)||
1014: p_employee_number||fnd_global.local_chr(400)||
1015: p_applicant_number||fnd_global.local_chr(400)||
1016: p_npw_number||fnd_global.local_chr(400)||
1017: p_person_type_id||fnd_global.local_chr(400)||
1018: p_date_of_birth||fnd_global.local_chr(400)||
1019: p_town_of_birth||fnd_global.local_chr(400)||

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

1012: p_person_id||fnd_global.local_chr(400)||
1013: p_legislation_code||fnd_global.local_chr(400)||
1014: p_employee_number||fnd_global.local_chr(400)||
1015: p_applicant_number||fnd_global.local_chr(400)||
1016: p_npw_number||fnd_global.local_chr(400)||
1017: p_person_type_id||fnd_global.local_chr(400)||
1018: p_date_of_birth||fnd_global.local_chr(400)||
1019: p_town_of_birth||fnd_global.local_chr(400)||
1020: p_cntry_of_birth||fnd_global.local_chr(400)||

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

1013: p_legislation_code||fnd_global.local_chr(400)||
1014: p_employee_number||fnd_global.local_chr(400)||
1015: p_applicant_number||fnd_global.local_chr(400)||
1016: p_npw_number||fnd_global.local_chr(400)||
1017: p_person_type_id||fnd_global.local_chr(400)||
1018: p_date_of_birth||fnd_global.local_chr(400)||
1019: p_town_of_birth||fnd_global.local_chr(400)||
1020: p_cntry_of_birth||fnd_global.local_chr(400)||
1021: p_date_of_death||fnd_global.local_chr(400)||

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

1014: p_employee_number||fnd_global.local_chr(400)||
1015: p_applicant_number||fnd_global.local_chr(400)||
1016: p_npw_number||fnd_global.local_chr(400)||
1017: p_person_type_id||fnd_global.local_chr(400)||
1018: p_date_of_birth||fnd_global.local_chr(400)||
1019: p_town_of_birth||fnd_global.local_chr(400)||
1020: p_cntry_of_birth||fnd_global.local_chr(400)||
1021: p_date_of_death||fnd_global.local_chr(400)||
1022: p_orig_dt_of_hire||fnd_global.local_chr(400)||

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

1015: p_applicant_number||fnd_global.local_chr(400)||
1016: p_npw_number||fnd_global.local_chr(400)||
1017: p_person_type_id||fnd_global.local_chr(400)||
1018: p_date_of_birth||fnd_global.local_chr(400)||
1019: p_town_of_birth||fnd_global.local_chr(400)||
1020: p_cntry_of_birth||fnd_global.local_chr(400)||
1021: p_date_of_death||fnd_global.local_chr(400)||
1022: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1023: p_eff_start_date||fnd_global.local_chr(400)||

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

1016: p_npw_number||fnd_global.local_chr(400)||
1017: p_person_type_id||fnd_global.local_chr(400)||
1018: p_date_of_birth||fnd_global.local_chr(400)||
1019: p_town_of_birth||fnd_global.local_chr(400)||
1020: p_cntry_of_birth||fnd_global.local_chr(400)||
1021: p_date_of_death||fnd_global.local_chr(400)||
1022: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1023: p_eff_start_date||fnd_global.local_chr(400)||
1024: p_eff_end_date||fnd_global.local_chr(400)||

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

1017: p_person_type_id||fnd_global.local_chr(400)||
1018: p_date_of_birth||fnd_global.local_chr(400)||
1019: p_town_of_birth||fnd_global.local_chr(400)||
1020: p_cntry_of_birth||fnd_global.local_chr(400)||
1021: p_date_of_death||fnd_global.local_chr(400)||
1022: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1023: p_eff_start_date||fnd_global.local_chr(400)||
1024: p_eff_end_date||fnd_global.local_chr(400)||
1025: p_sex||fnd_global.local_chr(400)||

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

1018: p_date_of_birth||fnd_global.local_chr(400)||
1019: p_town_of_birth||fnd_global.local_chr(400)||
1020: p_cntry_of_birth||fnd_global.local_chr(400)||
1021: p_date_of_death||fnd_global.local_chr(400)||
1022: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1023: p_eff_start_date||fnd_global.local_chr(400)||
1024: p_eff_end_date||fnd_global.local_chr(400)||
1025: p_sex||fnd_global.local_chr(400)||
1026: p_full_name||fnd_global.local_chr(400)||

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

1019: p_town_of_birth||fnd_global.local_chr(400)||
1020: p_cntry_of_birth||fnd_global.local_chr(400)||
1021: p_date_of_death||fnd_global.local_chr(400)||
1022: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1023: p_eff_start_date||fnd_global.local_chr(400)||
1024: p_eff_end_date||fnd_global.local_chr(400)||
1025: p_sex||fnd_global.local_chr(400)||
1026: p_full_name||fnd_global.local_chr(400)||
1027: p_suffix||fnd_global.local_chr(400)||

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

1020: p_cntry_of_birth||fnd_global.local_chr(400)||
1021: p_date_of_death||fnd_global.local_chr(400)||
1022: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1023: p_eff_start_date||fnd_global.local_chr(400)||
1024: p_eff_end_date||fnd_global.local_chr(400)||
1025: p_sex||fnd_global.local_chr(400)||
1026: p_full_name||fnd_global.local_chr(400)||
1027: p_suffix||fnd_global.local_chr(400)||
1028: p_title||fnd_global.local_chr(400)||

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

1021: p_date_of_death||fnd_global.local_chr(400)||
1022: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1023: p_eff_start_date||fnd_global.local_chr(400)||
1024: p_eff_end_date||fnd_global.local_chr(400)||
1025: p_sex||fnd_global.local_chr(400)||
1026: p_full_name||fnd_global.local_chr(400)||
1027: p_suffix||fnd_global.local_chr(400)||
1028: p_title||fnd_global.local_chr(400)||
1029: p_last_name||fnd_global.local_chr(400)||

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

1022: p_orig_dt_of_hire||fnd_global.local_chr(400)||
1023: p_eff_start_date||fnd_global.local_chr(400)||
1024: p_eff_end_date||fnd_global.local_chr(400)||
1025: p_sex||fnd_global.local_chr(400)||
1026: p_full_name||fnd_global.local_chr(400)||
1027: p_suffix||fnd_global.local_chr(400)||
1028: p_title||fnd_global.local_chr(400)||
1029: p_last_name||fnd_global.local_chr(400)||
1030: p_first_name||fnd_global.local_chr(400)||

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

1023: p_eff_start_date||fnd_global.local_chr(400)||
1024: p_eff_end_date||fnd_global.local_chr(400)||
1025: p_sex||fnd_global.local_chr(400)||
1026: p_full_name||fnd_global.local_chr(400)||
1027: p_suffix||fnd_global.local_chr(400)||
1028: p_title||fnd_global.local_chr(400)||
1029: p_last_name||fnd_global.local_chr(400)||
1030: p_first_name||fnd_global.local_chr(400)||
1031: p_middle_names||fnd_global.local_chr(400)||

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

1024: p_eff_end_date||fnd_global.local_chr(400)||
1025: p_sex||fnd_global.local_chr(400)||
1026: p_full_name||fnd_global.local_chr(400)||
1027: p_suffix||fnd_global.local_chr(400)||
1028: p_title||fnd_global.local_chr(400)||
1029: p_last_name||fnd_global.local_chr(400)||
1030: p_first_name||fnd_global.local_chr(400)||
1031: p_middle_names||fnd_global.local_chr(400)||
1032: p_nationality||fnd_global.local_chr(400)||

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

1025: p_sex||fnd_global.local_chr(400)||
1026: p_full_name||fnd_global.local_chr(400)||
1027: p_suffix||fnd_global.local_chr(400)||
1028: p_title||fnd_global.local_chr(400)||
1029: p_last_name||fnd_global.local_chr(400)||
1030: p_first_name||fnd_global.local_chr(400)||
1031: p_middle_names||fnd_global.local_chr(400)||
1032: p_nationality||fnd_global.local_chr(400)||
1033: p_national_identifier||fnd_global.local_chr(400)||

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

1026: p_full_name||fnd_global.local_chr(400)||
1027: p_suffix||fnd_global.local_chr(400)||
1028: p_title||fnd_global.local_chr(400)||
1029: p_last_name||fnd_global.local_chr(400)||
1030: p_first_name||fnd_global.local_chr(400)||
1031: p_middle_names||fnd_global.local_chr(400)||
1032: p_nationality||fnd_global.local_chr(400)||
1033: p_national_identifier||fnd_global.local_chr(400)||
1034: p_email_address||fnd_global.local_chr(400)||

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

1027: p_suffix||fnd_global.local_chr(400)||
1028: p_title||fnd_global.local_chr(400)||
1029: p_last_name||fnd_global.local_chr(400)||
1030: p_first_name||fnd_global.local_chr(400)||
1031: p_middle_names||fnd_global.local_chr(400)||
1032: p_nationality||fnd_global.local_chr(400)||
1033: p_national_identifier||fnd_global.local_chr(400)||
1034: p_email_address||fnd_global.local_chr(400)||
1035: fnd_global.local_chr(400)||

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

1028: p_title||fnd_global.local_chr(400)||
1029: p_last_name||fnd_global.local_chr(400)||
1030: p_first_name||fnd_global.local_chr(400)||
1031: p_middle_names||fnd_global.local_chr(400)||
1032: p_nationality||fnd_global.local_chr(400)||
1033: p_national_identifier||fnd_global.local_chr(400)||
1034: p_email_address||fnd_global.local_chr(400)||
1035: fnd_global.local_chr(400)||
1036: fnd_global.local_chr(400)||

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

1029: p_last_name||fnd_global.local_chr(400)||
1030: p_first_name||fnd_global.local_chr(400)||
1031: p_middle_names||fnd_global.local_chr(400)||
1032: p_nationality||fnd_global.local_chr(400)||
1033: p_national_identifier||fnd_global.local_chr(400)||
1034: p_email_address||fnd_global.local_chr(400)||
1035: fnd_global.local_chr(400)||
1036: fnd_global.local_chr(400)||
1037: fnd_global.local_chr(400)||

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

1030: p_first_name||fnd_global.local_chr(400)||
1031: p_middle_names||fnd_global.local_chr(400)||
1032: p_nationality||fnd_global.local_chr(400)||
1033: p_national_identifier||fnd_global.local_chr(400)||
1034: p_email_address||fnd_global.local_chr(400)||
1035: fnd_global.local_chr(400)||
1036: fnd_global.local_chr(400)||
1037: fnd_global.local_chr(400)||
1038: fnd_global.local_chr(400)||

Line 1035: fnd_global.local_chr(400)||

1031: p_middle_names||fnd_global.local_chr(400)||
1032: p_nationality||fnd_global.local_chr(400)||
1033: p_national_identifier||fnd_global.local_chr(400)||
1034: p_email_address||fnd_global.local_chr(400)||
1035: fnd_global.local_chr(400)||
1036: fnd_global.local_chr(400)||
1037: fnd_global.local_chr(400)||
1038: fnd_global.local_chr(400)||
1039: fnd_global.local_chr(400)||

Line 1036: fnd_global.local_chr(400)||

1032: p_nationality||fnd_global.local_chr(400)||
1033: p_national_identifier||fnd_global.local_chr(400)||
1034: p_email_address||fnd_global.local_chr(400)||
1035: fnd_global.local_chr(400)||
1036: fnd_global.local_chr(400)||
1037: fnd_global.local_chr(400)||
1038: fnd_global.local_chr(400)||
1039: fnd_global.local_chr(400)||
1040: fnd_global.local_chr(400)||

Line 1037: fnd_global.local_chr(400)||

1033: p_national_identifier||fnd_global.local_chr(400)||
1034: p_email_address||fnd_global.local_chr(400)||
1035: fnd_global.local_chr(400)||
1036: fnd_global.local_chr(400)||
1037: fnd_global.local_chr(400)||
1038: fnd_global.local_chr(400)||
1039: fnd_global.local_chr(400)||
1040: fnd_global.local_chr(400)||
1041: fnd_global.local_chr(400)||

Line 1038: fnd_global.local_chr(400)||

1034: p_email_address||fnd_global.local_chr(400)||
1035: fnd_global.local_chr(400)||
1036: fnd_global.local_chr(400)||
1037: fnd_global.local_chr(400)||
1038: fnd_global.local_chr(400)||
1039: fnd_global.local_chr(400)||
1040: fnd_global.local_chr(400)||
1041: fnd_global.local_chr(400)||
1042: fnd_global.local_chr(400)||

Line 1039: fnd_global.local_chr(400)||

1035: fnd_global.local_chr(400)||
1036: fnd_global.local_chr(400)||
1037: fnd_global.local_chr(400)||
1038: fnd_global.local_chr(400)||
1039: fnd_global.local_chr(400)||
1040: fnd_global.local_chr(400)||
1041: fnd_global.local_chr(400)||
1042: fnd_global.local_chr(400)||
1043: fnd_global.local_chr(400)||

Line 1040: fnd_global.local_chr(400)||

1036: fnd_global.local_chr(400)||
1037: fnd_global.local_chr(400)||
1038: fnd_global.local_chr(400)||
1039: fnd_global.local_chr(400)||
1040: fnd_global.local_chr(400)||
1041: fnd_global.local_chr(400)||
1042: fnd_global.local_chr(400)||
1043: fnd_global.local_chr(400)||
1044: fnd_global.local_chr(400)||

Line 1041: fnd_global.local_chr(400)||

1037: fnd_global.local_chr(400)||
1038: fnd_global.local_chr(400)||
1039: fnd_global.local_chr(400)||
1040: fnd_global.local_chr(400)||
1041: fnd_global.local_chr(400)||
1042: fnd_global.local_chr(400)||
1043: fnd_global.local_chr(400)||
1044: fnd_global.local_chr(400)||
1045: fnd_global.local_chr(400)||

Line 1042: fnd_global.local_chr(400)||

1038: fnd_global.local_chr(400)||
1039: fnd_global.local_chr(400)||
1040: fnd_global.local_chr(400)||
1041: fnd_global.local_chr(400)||
1042: fnd_global.local_chr(400)||
1043: fnd_global.local_chr(400)||
1044: fnd_global.local_chr(400)||
1045: fnd_global.local_chr(400)||
1046: fnd_global.local_chr(400)||

Line 1043: fnd_global.local_chr(400)||

1039: fnd_global.local_chr(400)||
1040: fnd_global.local_chr(400)||
1041: fnd_global.local_chr(400)||
1042: fnd_global.local_chr(400)||
1043: fnd_global.local_chr(400)||
1044: fnd_global.local_chr(400)||
1045: fnd_global.local_chr(400)||
1046: fnd_global.local_chr(400)||
1047: fnd_global.local_chr(400)||

Line 1044: fnd_global.local_chr(400)||

1040: fnd_global.local_chr(400)||
1041: fnd_global.local_chr(400)||
1042: fnd_global.local_chr(400)||
1043: fnd_global.local_chr(400)||
1044: fnd_global.local_chr(400)||
1045: fnd_global.local_chr(400)||
1046: fnd_global.local_chr(400)||
1047: fnd_global.local_chr(400)||
1048: fnd_global.local_chr(400)||

Line 1045: fnd_global.local_chr(400)||

1041: fnd_global.local_chr(400)||
1042: fnd_global.local_chr(400)||
1043: fnd_global.local_chr(400)||
1044: fnd_global.local_chr(400)||
1045: fnd_global.local_chr(400)||
1046: fnd_global.local_chr(400)||
1047: fnd_global.local_chr(400)||
1048: fnd_global.local_chr(400)||
1049: fnd_global.local_chr(400)||

Line 1046: fnd_global.local_chr(400)||

1042: fnd_global.local_chr(400)||
1043: fnd_global.local_chr(400)||
1044: fnd_global.local_chr(400)||
1045: fnd_global.local_chr(400)||
1046: fnd_global.local_chr(400)||
1047: fnd_global.local_chr(400)||
1048: fnd_global.local_chr(400)||
1049: fnd_global.local_chr(400)||
1050: fnd_global.local_chr(400)||

Line 1047: fnd_global.local_chr(400)||

1043: fnd_global.local_chr(400)||
1044: fnd_global.local_chr(400)||
1045: fnd_global.local_chr(400)||
1046: fnd_global.local_chr(400)||
1047: fnd_global.local_chr(400)||
1048: fnd_global.local_chr(400)||
1049: fnd_global.local_chr(400)||
1050: fnd_global.local_chr(400)||
1051: fnd_global.local_chr(400)||

Line 1048: fnd_global.local_chr(400)||

1044: fnd_global.local_chr(400)||
1045: fnd_global.local_chr(400)||
1046: fnd_global.local_chr(400)||
1047: fnd_global.local_chr(400)||
1048: fnd_global.local_chr(400)||
1049: fnd_global.local_chr(400)||
1050: fnd_global.local_chr(400)||
1051: fnd_global.local_chr(400)||
1052: p_national_id_label||fnd_global.local_chr(400)||

Line 1049: fnd_global.local_chr(400)||

1045: fnd_global.local_chr(400)||
1046: fnd_global.local_chr(400)||
1047: fnd_global.local_chr(400)||
1048: fnd_global.local_chr(400)||
1049: fnd_global.local_chr(400)||
1050: fnd_global.local_chr(400)||
1051: fnd_global.local_chr(400)||
1052: p_national_id_label||fnd_global.local_chr(400)||
1053: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

Line 1050: fnd_global.local_chr(400)||

1046: fnd_global.local_chr(400)||
1047: fnd_global.local_chr(400)||
1048: fnd_global.local_chr(400)||
1049: fnd_global.local_chr(400)||
1050: fnd_global.local_chr(400)||
1051: fnd_global.local_chr(400)||
1052: p_national_id_label||fnd_global.local_chr(400)||
1053: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1054: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

Line 1051: fnd_global.local_chr(400)||

1047: fnd_global.local_chr(400)||
1048: fnd_global.local_chr(400)||
1049: fnd_global.local_chr(400)||
1050: fnd_global.local_chr(400)||
1051: fnd_global.local_chr(400)||
1052: p_national_id_label||fnd_global.local_chr(400)||
1053: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1054: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1055: fnd_global.local_chr(10)||fnd_global.local_chr(13));

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

1048: fnd_global.local_chr(400)||
1049: fnd_global.local_chr(400)||
1050: fnd_global.local_chr(400)||
1051: fnd_global.local_chr(400)||
1052: p_national_id_label||fnd_global.local_chr(400)||
1053: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1054: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1055: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1056:

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

1049: fnd_global.local_chr(400)||
1050: fnd_global.local_chr(400)||
1051: fnd_global.local_chr(400)||
1052: p_national_id_label||fnd_global.local_chr(400)||
1053: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1054: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1055: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1056:
1057:

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

1051: fnd_global.local_chr(400)||
1052: p_national_id_label||fnd_global.local_chr(400)||
1053: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1054: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1055: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1056:
1057:
1058: end if;
1059: /*Fix for bug 7650158 ends here*/