[Home] [Help]
PACKAGE BODY: APPS.HR_APPLICANT_BE1
Source
1 package body hr_applicant_be1 as
2 --Code generated on 30/03/2009 04:46:17
3 /* $Header: hrapiwfe.pkb 120.4.12010000.2 2008/09/29 12:54:07 srgnanas ship $*/
4 procedure create_applicant_a (
5 p_date_received date,
6 p_business_group_id number,
7 p_last_name varchar2,
8 p_person_type_id number,
9 p_applicant_number varchar2,
10 p_per_comments varchar2,
11 p_date_employee_data_verified date,
12 p_date_of_birth date,
13 p_email_address varchar2,
14 p_expense_check_send_to_addres varchar2,
15 p_first_name varchar2,
16 p_known_as varchar2,
17 p_marital_status varchar2,
18 p_middle_names varchar2,
19 p_nationality varchar2,
20 p_national_identifier varchar2,
21 p_previous_last_name varchar2,
22 p_registered_disabled_flag varchar2,
23 p_sex varchar2,
24 p_title varchar2,
25 p_work_telephone varchar2,
26 p_attribute_category varchar2,
27 p_attribute1 varchar2,
28 p_attribute2 varchar2,
29 p_attribute3 varchar2,
30 p_attribute4 varchar2,
31 p_attribute5 varchar2,
32 p_attribute6 varchar2,
33 p_attribute7 varchar2,
34 p_attribute8 varchar2,
35 p_attribute9 varchar2,
36 p_attribute10 varchar2,
37 p_attribute11 varchar2,
38 p_attribute12 varchar2,
39 p_attribute13 varchar2,
40 p_attribute14 varchar2,
41 p_attribute15 varchar2,
42 p_attribute16 varchar2,
43 p_attribute17 varchar2,
44 p_attribute18 varchar2,
45 p_attribute19 varchar2,
46 p_attribute20 varchar2,
47 p_attribute21 varchar2,
48 p_attribute22 varchar2,
49 p_attribute23 varchar2,
50 p_attribute24 varchar2,
51 p_attribute25 varchar2,
52 p_attribute26 varchar2,
53 p_attribute27 varchar2,
54 p_attribute28 varchar2,
55 p_attribute29 varchar2,
56 p_attribute30 varchar2,
57 p_per_information_category varchar2,
58 p_per_information1 varchar2,
59 p_per_information2 varchar2,
60 p_per_information3 varchar2,
61 p_per_information4 varchar2,
62 p_per_information5 varchar2,
63 p_per_information6 varchar2,
64 p_per_information7 varchar2,
65 p_per_information8 varchar2,
66 p_per_information9 varchar2,
67 p_per_information10 varchar2,
68 p_per_information11 varchar2,
69 p_per_information12 varchar2,
70 p_per_information13 varchar2,
71 p_per_information14 varchar2,
72 p_per_information15 varchar2,
73 p_per_information16 varchar2,
74 p_per_information17 varchar2,
75 p_per_information18 varchar2,
76 p_per_information19 varchar2,
77 p_per_information20 varchar2,
78 p_per_information21 varchar2,
79 p_per_information22 varchar2,
80 p_per_information23 varchar2,
81 p_per_information24 varchar2,
82 p_per_information25 varchar2,
83 p_per_information26 varchar2,
84 p_per_information27 varchar2,
85 p_per_information28 varchar2,
86 p_per_information29 varchar2,
87 p_per_information30 varchar2,
88 p_background_check_status varchar2,
89 p_background_date_check date,
90 p_correspondence_language varchar2,
91 p_fte_capacity number,
92 p_hold_applicant_date_until date,
93 p_honors varchar2,
94 p_mailstop varchar2,
95 p_office_number varchar2,
96 p_on_military_service varchar2,
97 p_pre_name_adjunct varchar2,
98 p_projected_start_date date,
99 p_resume_exists varchar2,
100 p_resume_last_updated date,
101 p_student_status varchar2,
102 p_work_schedule varchar2,
103 p_suffix varchar2,
104 p_date_of_death date,
105 p_benefit_group_id number,
106 p_receipt_of_death_cert_date date,
107 p_coord_ben_med_pln_no varchar2,
108 p_coord_ben_no_cvg_flag varchar2,
109 p_uses_tobacco_flag varchar2,
110 p_dpdnt_adoption_date date,
111 p_dpdnt_vlntry_svce_flag varchar2,
112 p_original_date_of_hire date,
113 p_person_id number,
114 p_assignment_id number,
115 p_application_id number,
116 p_per_object_version_number number,
117 p_asg_object_version_number number,
118 p_apl_object_version_number number,
119 p_per_effective_start_date date,
120 p_per_effective_end_date date,
121 p_full_name varchar2,
122 p_per_comment_id number,
123 p_assignment_sequence number,
124 p_name_combination_warning boolean,
125 p_orig_hire_warning boolean,
126 p_town_of_birth varchar2,
127 p_region_of_birth varchar2,
128 p_country_of_birth varchar2,
129 p_global_person_id varchar2,
130 p_party_id varchar2,
131 p_vacancy_id number) is
132 l_event_key number;
133 l_event_data clob;
134 l_event_name varchar2(250);
135 l_text varchar2(2000);
136 l_message varchar2(10);
137 --
138 cursor get_seq is
139 select per_wf_events_s.nextval from dual;
140 --
141 l_proc varchar2(72):=' hr_applicant_be1.create_applicant_a';
142 begin
143 hr_utility.set_location('Entering: '||l_proc,10);
144 -- check the status of the business event
145 l_event_name:='oracle.apps.per.api.applicant.create_applicant';
146 l_message:=wf_event.test(l_event_name);
147 --
148 if (l_message='MESSAGE') then
149 hr_utility.set_location(l_proc,20);
150 --
151 -- get a key for the event
152 --
153 open get_seq;
154 fetch get_seq into l_event_key;
155 close get_seq;
156 --
157 -- build the xml data for the event
158 --
159 dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
160 l_text:='<?xml version =''1.0'' encoding =''ASCII''?>';
161 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
162 l_text:='<applicant>';
163 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
164 --
165 l_text:='<date_received>';
166 l_text:=l_text||fnd_date.date_to_canonical(p_date_received);
167 l_text:=l_text||'</date_received>';
168 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
169 l_text:='<business_group_id>';
170 l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
171 l_text:=l_text||'</business_group_id>';
172 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
173 l_text:='<last_name>';
174 l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);
175 l_text:=l_text||'</last_name>';
176 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
177 l_text:='<person_type_id>';
178 l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);
179 l_text:=l_text||'</person_type_id>';
180 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
181 l_text:='<applicant_number>';
182 l_text:=l_text||irc_utilities_pkg.removeTags(p_applicant_number);
183 l_text:=l_text||'</applicant_number>';
184 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
185 l_text:='<per_comments>';
186 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_comments);
187 l_text:=l_text||'</per_comments>';
188 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
189 l_text:='<date_employee_data_verified>';
190 l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);
191 l_text:=l_text||'</date_employee_data_verified>';
192 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
193 l_text:='<date_of_birth>';
194 l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);
195 l_text:=l_text||'</date_of_birth>';
196 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
197 l_text:='<email_address>';
198 l_text:=l_text||irc_utilities_pkg.removeTags(p_email_address);
199 l_text:=l_text||'</email_address>';
200 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
201 l_text:='<expense_check_send_to_addres>';
202 l_text:=l_text||irc_utilities_pkg.removeTags(p_expense_check_send_to_addres);
203 l_text:=l_text||'</expense_check_send_to_addres>';
204 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
205 l_text:='<first_name>';
206 l_text:=l_text||irc_utilities_pkg.removeTags(p_first_name);
207 l_text:=l_text||'</first_name>';
208 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
209 l_text:='<known_as>';
210 l_text:=l_text||irc_utilities_pkg.removeTags(p_known_as);
211 l_text:=l_text||'</known_as>';
212 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
213 l_text:='<marital_status>';
214 l_text:=l_text||irc_utilities_pkg.removeTags(p_marital_status);
215 l_text:=l_text||'</marital_status>';
216 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
217 l_text:='<middle_names>';
218 l_text:=l_text||irc_utilities_pkg.removeTags(p_middle_names);
219 l_text:=l_text||'</middle_names>';
220 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
221 l_text:='<nationality>';
222 l_text:=l_text||irc_utilities_pkg.removeTags(p_nationality);
223 l_text:=l_text||'</nationality>';
224 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
225 l_text:='<national_identifier>';
226 l_text:=l_text||irc_utilities_pkg.removeTags(p_national_identifier);
227 l_text:=l_text||'</national_identifier>';
228 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
229 l_text:='<previous_last_name>';
230 l_text:=l_text||irc_utilities_pkg.removeTags(p_previous_last_name);
231 l_text:=l_text||'</previous_last_name>';
232 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
233 l_text:='<registered_disabled_flag>';
234 l_text:=l_text||irc_utilities_pkg.removeTags(p_registered_disabled_flag);
235 l_text:=l_text||'</registered_disabled_flag>';
236 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
237 l_text:='<sex>';
238 l_text:=l_text||irc_utilities_pkg.removeTags(p_sex);
239 l_text:=l_text||'</sex>';
240 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
241 l_text:='<title>';
242 l_text:=l_text||irc_utilities_pkg.removeTags(p_title);
243 l_text:=l_text||'</title>';
244 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
245 l_text:='<work_telephone>';
246 l_text:=l_text||irc_utilities_pkg.removeTags(p_work_telephone);
247 l_text:=l_text||'</work_telephone>';
248 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
249 l_text:='<attribute_category>';
250 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);
251 l_text:=l_text||'</attribute_category>';
252 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
253 l_text:='<attribute1>';
254 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute1);
255 l_text:=l_text||'</attribute1>';
256 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
257 l_text:='<attribute2>';
258 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute2);
259 l_text:=l_text||'</attribute2>';
260 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
261 l_text:='<attribute3>';
262 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute3);
263 l_text:=l_text||'</attribute3>';
264 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
265 l_text:='<attribute4>';
266 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute4);
267 l_text:=l_text||'</attribute4>';
268 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
269 l_text:='<attribute5>';
270 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute5);
271 l_text:=l_text||'</attribute5>';
272 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
273 l_text:='<attribute6>';
274 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute6);
275 l_text:=l_text||'</attribute6>';
276 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
277 l_text:='<attribute7>';
278 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute7);
279 l_text:=l_text||'</attribute7>';
280 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
281 l_text:='<attribute8>';
282 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute8);
283 l_text:=l_text||'</attribute8>';
287 l_text:=l_text||'</attribute9>';
284 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
285 l_text:='<attribute9>';
286 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute9);
288 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
289 l_text:='<attribute10>';
290 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute10);
291 l_text:=l_text||'</attribute10>';
292 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
293 l_text:='<attribute11>';
294 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute11);
295 l_text:=l_text||'</attribute11>';
296 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
297 l_text:='<attribute12>';
298 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute12);
299 l_text:=l_text||'</attribute12>';
300 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
301 l_text:='<attribute13>';
302 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute13);
303 l_text:=l_text||'</attribute13>';
304 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
305 l_text:='<attribute14>';
306 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute14);
307 l_text:=l_text||'</attribute14>';
308 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
309 l_text:='<attribute15>';
310 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute15);
311 l_text:=l_text||'</attribute15>';
312 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
313 l_text:='<attribute16>';
314 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute16);
315 l_text:=l_text||'</attribute16>';
316 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
317 l_text:='<attribute17>';
318 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute17);
319 l_text:=l_text||'</attribute17>';
320 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
321 l_text:='<attribute18>';
322 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute18);
323 l_text:=l_text||'</attribute18>';
324 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
325 l_text:='<attribute19>';
326 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute19);
327 l_text:=l_text||'</attribute19>';
328 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
329 l_text:='<attribute20>';
330 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);
331 l_text:=l_text||'</attribute20>';
332 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
333 l_text:='<attribute21>';
334 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute21);
335 l_text:=l_text||'</attribute21>';
336 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
337 l_text:='<attribute22>';
338 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute22);
339 l_text:=l_text||'</attribute22>';
340 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
341 l_text:='<attribute23>';
342 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute23);
343 l_text:=l_text||'</attribute23>';
344 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
345 l_text:='<attribute24>';
346 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute24);
347 l_text:=l_text||'</attribute24>';
348 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
349 l_text:='<attribute25>';
350 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute25);
351 l_text:=l_text||'</attribute25>';
352 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
353 l_text:='<attribute26>';
354 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute26);
355 l_text:=l_text||'</attribute26>';
356 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
357 l_text:='<attribute27>';
358 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute27);
359 l_text:=l_text||'</attribute27>';
360 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
361 l_text:='<attribute28>';
362 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute28);
363 l_text:=l_text||'</attribute28>';
364 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
365 l_text:='<attribute29>';
366 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute29);
367 l_text:=l_text||'</attribute29>';
368 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
369 l_text:='<attribute30>';
370 l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute30);
371 l_text:=l_text||'</attribute30>';
372 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
373 l_text:='<per_information_category>';
374 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information_category);
375 l_text:=l_text||'</per_information_category>';
376 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
377 l_text:='<per_information1>';
378 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information1);
379 l_text:=l_text||'</per_information1>';
380 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
381 l_text:='<per_information2>';
382 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information2);
383 l_text:=l_text||'</per_information2>';
384 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
385 l_text:='<per_information3>';
386 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information3);
387 l_text:=l_text||'</per_information3>';
388 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
389 l_text:='<per_information4>';
390 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information4);
391 l_text:=l_text||'</per_information4>';
392 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
393 l_text:='<per_information5>';
394 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information5);
395 l_text:=l_text||'</per_information5>';
399 l_text:=l_text||'</per_information6>';
396 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
397 l_text:='<per_information6>';
398 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information6);
400 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
401 l_text:='<per_information7>';
402 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information7);
403 l_text:=l_text||'</per_information7>';
404 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
405 l_text:='<per_information8>';
406 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information8);
407 l_text:=l_text||'</per_information8>';
408 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
409 l_text:='<per_information9>';
410 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information9);
411 l_text:=l_text||'</per_information9>';
412 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
413 l_text:='<per_information10>';
414 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information10);
415 l_text:=l_text||'</per_information10>';
416 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
417 l_text:='<per_information11>';
418 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information11);
419 l_text:=l_text||'</per_information11>';
420 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
421 l_text:='<per_information12>';
422 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information12);
423 l_text:=l_text||'</per_information12>';
424 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
425 l_text:='<per_information13>';
426 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information13);
427 l_text:=l_text||'</per_information13>';
428 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
429 l_text:='<per_information14>';
430 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information14);
431 l_text:=l_text||'</per_information14>';
432 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
433 l_text:='<per_information15>';
434 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information15);
435 l_text:=l_text||'</per_information15>';
436 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
437 l_text:='<per_information16>';
438 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information16);
439 l_text:=l_text||'</per_information16>';
440 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
441 l_text:='<per_information17>';
442 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information17);
443 l_text:=l_text||'</per_information17>';
444 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
445 l_text:='<per_information18>';
446 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information18);
447 l_text:=l_text||'</per_information18>';
448 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
449 l_text:='<per_information19>';
450 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information19);
451 l_text:=l_text||'</per_information19>';
452 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
453 l_text:='<per_information20>';
454 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information20);
455 l_text:=l_text||'</per_information20>';
456 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
457 l_text:='<per_information21>';
458 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information21);
459 l_text:=l_text||'</per_information21>';
460 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
461 l_text:='<per_information22>';
462 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information22);
463 l_text:=l_text||'</per_information22>';
464 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
465 l_text:='<per_information23>';
466 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information23);
467 l_text:=l_text||'</per_information23>';
468 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
469 l_text:='<per_information24>';
470 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information24);
471 l_text:=l_text||'</per_information24>';
472 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
473 l_text:='<per_information25>';
474 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information25);
475 l_text:=l_text||'</per_information25>';
476 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
477 l_text:='<per_information26>';
478 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information26);
479 l_text:=l_text||'</per_information26>';
480 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
481 l_text:='<per_information27>';
482 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information27);
483 l_text:=l_text||'</per_information27>';
484 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
485 l_text:='<per_information28>';
486 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information28);
487 l_text:=l_text||'</per_information28>';
488 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
489 l_text:='<per_information29>';
490 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information29);
491 l_text:=l_text||'</per_information29>';
492 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
493 l_text:='<per_information30>';
494 l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information30);
495 l_text:=l_text||'</per_information30>';
496 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
497 l_text:='<background_check_status>';
498 l_text:=l_text||irc_utilities_pkg.removeTags(p_background_check_status);
499 l_text:=l_text||'</background_check_status>';
500 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
501 l_text:='<background_date_check>';
505 l_text:='<correspondence_language>';
502 l_text:=l_text||fnd_date.date_to_canonical(p_background_date_check);
503 l_text:=l_text||'</background_date_check>';
504 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
506 l_text:=l_text||irc_utilities_pkg.removeTags(p_correspondence_language);
507 l_text:=l_text||'</correspondence_language>';
508 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
509 l_text:='<fte_capacity>';
510 l_text:=l_text||fnd_number.number_to_canonical(p_fte_capacity);
511 l_text:=l_text||'</fte_capacity>';
512 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
513 l_text:='<hold_applicant_date_until>';
514 l_text:=l_text||fnd_date.date_to_canonical(p_hold_applicant_date_until);
515 l_text:=l_text||'</hold_applicant_date_until>';
516 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
517 l_text:='<honors>';
518 l_text:=l_text||irc_utilities_pkg.removeTags(p_honors);
519 l_text:=l_text||'</honors>';
520 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
521 l_text:='<mailstop>';
522 l_text:=l_text||irc_utilities_pkg.removeTags(p_mailstop);
523 l_text:=l_text||'</mailstop>';
524 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
525 l_text:='<office_number>';
526 l_text:=l_text||irc_utilities_pkg.removeTags(p_office_number);
527 l_text:=l_text||'</office_number>';
528 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
529 l_text:='<on_military_service>';
530 l_text:=l_text||irc_utilities_pkg.removeTags(p_on_military_service);
531 l_text:=l_text||'</on_military_service>';
532 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
533 l_text:='<pre_name_adjunct>';
534 l_text:=l_text||irc_utilities_pkg.removeTags(p_pre_name_adjunct);
535 l_text:=l_text||'</pre_name_adjunct>';
536 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
537 l_text:='<projected_start_date>';
538 l_text:=l_text||fnd_date.date_to_canonical(p_projected_start_date);
539 l_text:=l_text||'</projected_start_date>';
540 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
541 l_text:='<resume_exists>';
542 l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_exists);
543 l_text:=l_text||'</resume_exists>';
544 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
545 l_text:='<resume_last_updated>';
546 l_text:=l_text||fnd_date.date_to_canonical(p_resume_last_updated);
547 l_text:=l_text||'</resume_last_updated>';
548 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
549 l_text:='<student_status>';
550 l_text:=l_text||irc_utilities_pkg.removeTags(p_student_status);
551 l_text:=l_text||'</student_status>';
552 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
553 l_text:='<work_schedule>';
554 l_text:=l_text||irc_utilities_pkg.removeTags(p_work_schedule);
555 l_text:=l_text||'</work_schedule>';
556 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
557 l_text:='<suffix>';
558 l_text:=l_text||irc_utilities_pkg.removeTags(p_suffix);
559 l_text:=l_text||'</suffix>';
560 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
561 l_text:='<date_of_death>';
562 l_text:=l_text||fnd_date.date_to_canonical(p_date_of_death);
563 l_text:=l_text||'</date_of_death>';
564 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
565 l_text:='<benefit_group_id>';
566 l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);
567 l_text:=l_text||'</benefit_group_id>';
568 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
569 l_text:='<receipt_of_death_cert_date>';
570 l_text:=l_text||fnd_date.date_to_canonical(p_receipt_of_death_cert_date);
571 l_text:=l_text||'</receipt_of_death_cert_date>';
572 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
573 l_text:='<coord_ben_med_pln_no>';
574 l_text:=l_text||irc_utilities_pkg.removeTags(p_coord_ben_med_pln_no);
575 l_text:=l_text||'</coord_ben_med_pln_no>';
576 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
577 l_text:='<coord_ben_no_cvg_flag>';
578 l_text:=l_text||irc_utilities_pkg.removeTags(p_coord_ben_no_cvg_flag);
579 l_text:=l_text||'</coord_ben_no_cvg_flag>';
580 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
581 l_text:='<uses_tobacco_flag>';
582 l_text:=l_text||irc_utilities_pkg.removeTags(p_uses_tobacco_flag);
583 l_text:=l_text||'</uses_tobacco_flag>';
584 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
585 l_text:='<dpdnt_adoption_date>';
586 l_text:=l_text||fnd_date.date_to_canonical(p_dpdnt_adoption_date);
587 l_text:=l_text||'</dpdnt_adoption_date>';
588 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
589 l_text:='<dpdnt_vlntry_svce_flag>';
590 l_text:=l_text||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);
591 l_text:=l_text||'</dpdnt_vlntry_svce_flag>';
592 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
593 l_text:='<original_date_of_hire>';
594 l_text:=l_text||fnd_date.date_to_canonical(p_original_date_of_hire);
595 l_text:=l_text||'</original_date_of_hire>';
596 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
597 l_text:='<person_id>';
598 l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
599 l_text:=l_text||'</person_id>';
600 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
601 l_text:='<assignment_id>';
602 l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
603 l_text:=l_text||'</assignment_id>';
604 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
605 l_text:='<application_id>';
606 l_text:=l_text||fnd_number.number_to_canonical(p_application_id);
607 l_text:=l_text||'</application_id>';
608 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
609 l_text:='<per_object_version_number>';
613 l_text:='<asg_object_version_number>';
610 l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);
611 l_text:=l_text||'</per_object_version_number>';
612 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
614 l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
615 l_text:=l_text||'</asg_object_version_number>';
616 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
617 l_text:='<apl_object_version_number>';
618 l_text:=l_text||fnd_number.number_to_canonical(p_apl_object_version_number);
619 l_text:=l_text||'</apl_object_version_number>';
620 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
621 l_text:='<per_effective_start_date>';
622 l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);
623 l_text:=l_text||'</per_effective_start_date>';
624 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
625 l_text:='<per_effective_end_date>';
626 l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);
627 l_text:=l_text||'</per_effective_end_date>';
628 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
629 l_text:='<full_name>';
630 l_text:=l_text||irc_utilities_pkg.removeTags(p_full_name);
631 l_text:=l_text||'</full_name>';
632 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
633 l_text:='<per_comment_id>';
634 l_text:=l_text||fnd_number.number_to_canonical(p_per_comment_id);
635 l_text:=l_text||'</per_comment_id>';
636 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
637 l_text:='<assignment_sequence>';
638 l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
639 l_text:=l_text||'</assignment_sequence>';
640 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
641 l_text:='<name_combination_warning>';
642 if(P_NAME_COMBINATION_WARNING) then
643 l_text:=l_text||'TRUE';
644 else
645 l_text:=l_text||'FALSE';
646 end if;
647 l_text:=l_text||'</name_combination_warning>';
648 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
649 l_text:='<orig_hire_warning>';
650 if(P_ORIG_HIRE_WARNING) then
651 l_text:=l_text||'TRUE';
652 else
653 l_text:=l_text||'FALSE';
654 end if;
655 l_text:=l_text||'</orig_hire_warning>';
656 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
657 l_text:='<town_of_birth>';
658 l_text:=l_text||irc_utilities_pkg.removeTags(p_town_of_birth);
659 l_text:=l_text||'</town_of_birth>';
660 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
661 l_text:='<region_of_birth>';
662 l_text:=l_text||irc_utilities_pkg.removeTags(p_region_of_birth);
663 l_text:=l_text||'</region_of_birth>';
664 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
665 l_text:='<country_of_birth>';
666 l_text:=l_text||irc_utilities_pkg.removeTags(p_country_of_birth);
667 l_text:=l_text||'</country_of_birth>';
668 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
669 l_text:='<global_person_id>';
670 l_text:=l_text||irc_utilities_pkg.removeTags(p_global_person_id);
671 l_text:=l_text||'</global_person_id>';
672 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
673 l_text:='<party_id>';
674 l_text:=l_text||irc_utilities_pkg.removeTags(p_party_id);
675 l_text:=l_text||'</party_id>';
676 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
677 l_text:='<vacancy_id>';
678 l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
679 l_text:=l_text||'</vacancy_id>';
680 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
681 l_text:='</applicant>';
682 --
683 dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
684 --
685 if p_per_effective_start_date is not NULL and
686 p_per_effective_start_date > trunc(SYSDATE) and
687 fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
688 -- raise the event with the event data, with send date set to effective date
689 wf_event.raise(p_event_name=>l_event_name
690 ,p_event_key=>l_event_key
691 ,p_event_data=>l_event_data
692 ,p_send_date => p_per_effective_start_date);
693 --
694 else
695 -- raise the event with the event data
696 wf_event.raise(p_event_name=>l_event_name
697 ,p_event_key=>l_event_key
698 ,p_event_data=>l_event_data);
699 end if;
700 elsif (l_message='KEY') then
701 hr_utility.set_location(l_proc,30);
702 -- get a key for the event
703 open get_seq;
704 fetch get_seq into l_event_key;
705 close get_seq;
706 if p_per_effective_start_date is not NULL and
707 p_per_effective_start_date > trunc(SYSDATE) and
708 fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
709 -- this is a key event, so just raise the event
710 -- without the event data, with send date set to effective date
711 wf_event.raise(p_event_name=>l_event_name
712 ,p_event_key=>l_event_key
713 ,p_send_date => p_per_effective_start_date);
714 --
715 else
716 -- this is a key event, so just raise the event
717 -- without the event data
718 wf_event.raise(p_event_name=>l_event_name
719 ,p_event_key=>l_event_key);
720 end if;
721 elsif (l_message='NONE') then
722 hr_utility.set_location(l_proc,40);
723 -- no event is required, so do nothing
724 null;
725 end if;
726 hr_utility.set_location('Leaving: '||l_proc,50);
727 end create_applicant_a;
728 end hr_applicant_be1;