[Home] [Help]
PACKAGE BODY: APPS.IRC_PENDING_DATA_SWI
Source
1 Package Body irc_pending_data_swi As
2 /* $Header: iripdswi.pkb 120.0 2005/07/26 15:09:58 mbocutt noship $ */
3 --
4 -- Package variables
5 --
6 g_package varchar2(33) := 'irc_pending_data_swi.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |--------------------------< create_pending_data >-------------------------|
10 -- ----------------------------------------------------------------------------
11 PROCEDURE create_pending_data
12 (p_validate in number default hr_api.g_false_num
13 ,p_email_address in varchar2
14 ,p_last_name in varchar2
15 ,p_vacancy_id in number default null
16 ,p_first_name in varchar2 default null
17 ,p_user_password in varchar2 default null
18 ,p_resume_file_name in varchar2 default null
19 ,p_resume_description in varchar2 default null
20 ,p_resume_mime_type in varchar2 default null
21 ,p_source_type in varchar2 default null
22 ,p_job_post_source_name in varchar2 default null
23 ,p_posting_content_id in number default null
24 ,p_person_id in number default null
25 ,p_processed in varchar2 default null
26 ,p_sex in varchar2 default null
27 ,p_date_of_birth in date default null
28 ,p_per_information_category in varchar2 default null
29 ,p_per_information1 in varchar2 default null
30 ,p_per_information2 in varchar2 default null
31 ,p_per_information3 in varchar2 default null
32 ,p_per_information4 in varchar2 default null
33 ,p_per_information5 in varchar2 default null
34 ,p_per_information6 in varchar2 default null
35 ,p_per_information7 in varchar2 default null
36 ,p_per_information8 in varchar2 default null
37 ,p_per_information9 in varchar2 default null
38 ,p_per_information10 in varchar2 default null
39 ,p_per_information11 in varchar2 default null
40 ,p_per_information12 in varchar2 default null
41 ,p_per_information13 in varchar2 default null
42 ,p_per_information14 in varchar2 default null
43 ,p_per_information15 in varchar2 default null
44 ,p_per_information16 in varchar2 default null
45 ,p_per_information17 in varchar2 default null
46 ,p_per_information18 in varchar2 default null
47 ,p_per_information19 in varchar2 default null
48 ,p_per_information20 in varchar2 default null
49 ,p_per_information21 in varchar2 default null
50 ,p_per_information22 in varchar2 default null
51 ,p_per_information23 in varchar2 default null
52 ,p_per_information24 in varchar2 default null
53 ,p_per_information25 in varchar2 default null
54 ,p_per_information26 in varchar2 default null
55 ,p_per_information27 in varchar2 default null
56 ,p_per_information28 in varchar2 default null
57 ,p_per_information29 in varchar2 default null
58 ,p_per_information30 in varchar2 default null
59 ,p_error_message in varchar2 default null
60 ,p_creation_date in date
61 ,p_last_update_date in date
62 ,p_pending_data_id in number
63 ,p_allow_access in varchar2 default null
64 ,p_user_guid in raw default null
65 ,p_visitor_resp_key in varchar2 default null
66 ,p_visitor_resp_appl_id in number default null
67 ,p_security_group_key in varchar2 default null
68 ,p_return_status out nocopy varchar2
69 ) is
70 --
71 -- Variables for API Boolean parameters
72 l_validate boolean;
73 --
74 -- Variables for IN/OUT parameters
75 --
76 -- Other variables
77 l_pending_data_id number;
78 l_proc varchar2(72) := g_package ||'create_pending_data';
79 Begin
80 hr_utility.set_location(' Entering:' || l_proc,10);
81 --
82 -- Issue a savepoint
83 --
84 savepoint create_pending_data_swi;
85 --
86 -- Initialise Multiple Message Detection
87 --
88 hr_multi_message.enable_message_list;
89 --
90 --
91 -- Convert constant values to their corresponding boolean value
92 --
93 l_validate :=
94 hr_api.constant_to_boolean
95 (p_constant_value => p_validate);
96 --
97 -- Register Surrogate ID or user key values
98 --
99 irc_ipd_ins.set_base_key_value
100 (p_pending_data_id => p_pending_data_id
101 );
102 --
103 -- Call API
104 --
105 irc_pending_data_api.create_pending_data
106 (p_validate => l_validate
107 ,p_email_address => p_email_address
108 ,p_last_name => p_last_name
109 ,p_vacancy_id => p_vacancy_id
110 ,p_first_name => p_first_name
111 ,p_user_password => p_user_password
112 ,p_resume_file_name => p_resume_file_name
113 ,p_resume_description => p_resume_description
114 ,p_resume_mime_type => p_resume_mime_type
115 ,p_source_type => p_source_type
116 ,p_job_post_source_name => p_job_post_source_name
117 ,p_posting_content_id => p_posting_content_id
118 ,p_person_id => p_person_id
119 ,p_processed => p_processed
120 ,p_sex => p_sex
121 ,p_date_of_birth => p_date_of_birth
122 ,p_per_information_category => p_per_information_category
123 ,p_per_information1 => p_per_information1
124 ,p_per_information2 => p_per_information2
125 ,p_per_information3 => p_per_information3
126 ,p_per_information4 => p_per_information4
127 ,p_per_information5 => p_per_information5
128 ,p_per_information6 => p_per_information6
129 ,p_per_information7 => p_per_information7
130 ,p_per_information8 => p_per_information8
131 ,p_per_information9 => p_per_information9
132 ,p_per_information10 => p_per_information10
133 ,p_per_information11 => p_per_information11
134 ,p_per_information12 => p_per_information12
135 ,p_per_information13 => p_per_information13
136 ,p_per_information14 => p_per_information14
137 ,p_per_information15 => p_per_information15
138 ,p_per_information16 => p_per_information16
139 ,p_per_information17 => p_per_information17
140 ,p_per_information18 => p_per_information18
141 ,p_per_information19 => p_per_information19
142 ,p_per_information20 => p_per_information20
143 ,p_per_information21 => p_per_information21
144 ,p_per_information22 => p_per_information22
145 ,p_per_information23 => p_per_information23
146 ,p_per_information24 => p_per_information24
147 ,p_per_information25 => p_per_information25
148 ,p_per_information26 => p_per_information26
149 ,p_per_information27 => p_per_information27
150 ,p_per_information28 => p_per_information28
151 ,p_per_information29 => p_per_information29
152 ,p_per_information30 => p_per_information30
153 ,p_error_message => p_error_message
154 ,p_creation_date => p_creation_date
155 ,p_last_update_date => p_last_update_date
156 ,p_pending_data_id => l_pending_data_id
157 ,p_allow_access => p_allow_access
158 ,p_user_guid => p_user_guid
159 ,p_visitor_resp_key => p_visitor_resp_key
160 ,p_visitor_resp_appl_id => p_visitor_resp_appl_id
161 ,p_security_group_key => p_security_group_key
162 );
163 --
164 -- Convert API warning boolean parameter values to specific
165 -- messages and add them to Multiple Message List
166 --
167 --
168 -- Convert API non-warning boolean parameter values
169 --
170 --
171 -- Derive the API return status value based on whether
172 -- messages of any type exist in the Multiple Message List.
173 -- Also disable Multiple Message Detection.
174 --
175 p_return_status := hr_multi_message.get_return_status_disable;
176 hr_utility.set_location(' Leaving:' || l_proc,20);
177 --
178 exception
179 when hr_multi_message.error_message_exist then
180 --
181 -- Catch the Multiple Message List exception which
182 -- indicates API processing has been aborted because
183 -- at least one message exists in the list.
184 --
185 rollback to create_pending_data_swi;
186 --
187 -- Reset IN OUT parameters and set OUT parameters
188 --
189 p_return_status := hr_multi_message.get_return_status_disable;
190 hr_utility.set_location(' Leaving:' || l_proc, 30);
191 when others then
192 --
193 -- When Multiple Message Detection is enabled catch
194 -- any Application specific or other unexpected
195 -- exceptions. Adding appropriate details to the
196 -- Multiple Message List. Otherwise re-raise the
197 -- error.
198 --
199 rollback to create_pending_data_swi;
200 if hr_multi_message.unexpected_error_add(l_proc) then
201 hr_utility.set_location(' Leaving:' || l_proc,40);
202 raise;
203 end if;
204 --
205 -- Reset IN OUT and set OUT parameters
206 --
207 p_return_status := hr_multi_message.get_return_status_disable;
208 hr_utility.set_location(' Leaving:' || l_proc,50);
209 end create_pending_data;
210 -- ----------------------------------------------------------------------------
211 -- |--------------------------< update_pending_data >-------------------------|
212 -- ----------------------------------------------------------------------------
213 PROCEDURE update_pending_data
214 (p_validate in number default hr_api.g_false_num
215 ,p_pending_data_id in number
216 ,p_email_address in varchar2 default hr_api.g_varchar2
217 ,p_last_name in varchar2 default hr_api.g_varchar2
218 ,p_vacancy_id in number default hr_api.g_number
219 ,p_first_name in varchar2 default hr_api.g_varchar2
220 ,p_user_password in varchar2 default hr_api.g_varchar2
221 ,p_resume_file_name in varchar2 default hr_api.g_varchar2
222 ,p_resume_description in varchar2 default hr_api.g_varchar2
223 ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
224 ,p_source_type in varchar2 default hr_api.g_varchar2
225 ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
226 ,p_posting_content_id in number default hr_api.g_number
227 ,p_person_id in number default hr_api.g_number
228 ,p_processed in varchar2 default hr_api.g_varchar2
229 ,p_sex in varchar2 default hr_api.g_varchar2
230 ,p_date_of_birth in date default hr_api.g_date
231 ,p_per_information_category in varchar2 default hr_api.g_varchar2
232 ,p_per_information1 in varchar2 default hr_api.g_varchar2
233 ,p_per_information2 in varchar2 default hr_api.g_varchar2
234 ,p_per_information3 in varchar2 default hr_api.g_varchar2
235 ,p_per_information4 in varchar2 default hr_api.g_varchar2
236 ,p_per_information5 in varchar2 default hr_api.g_varchar2
237 ,p_per_information6 in varchar2 default hr_api.g_varchar2
238 ,p_per_information7 in varchar2 default hr_api.g_varchar2
239 ,p_per_information8 in varchar2 default hr_api.g_varchar2
240 ,p_per_information9 in varchar2 default hr_api.g_varchar2
241 ,p_per_information10 in varchar2 default hr_api.g_varchar2
242 ,p_per_information11 in varchar2 default hr_api.g_varchar2
243 ,p_per_information12 in varchar2 default hr_api.g_varchar2
244 ,p_per_information13 in varchar2 default hr_api.g_varchar2
245 ,p_per_information14 in varchar2 default hr_api.g_varchar2
246 ,p_per_information15 in varchar2 default hr_api.g_varchar2
247 ,p_per_information16 in varchar2 default hr_api.g_varchar2
248 ,p_per_information17 in varchar2 default hr_api.g_varchar2
249 ,p_per_information18 in varchar2 default hr_api.g_varchar2
250 ,p_per_information19 in varchar2 default hr_api.g_varchar2
251 ,p_per_information20 in varchar2 default hr_api.g_varchar2
252 ,p_per_information21 in varchar2 default hr_api.g_varchar2
253 ,p_per_information22 in varchar2 default hr_api.g_varchar2
254 ,p_per_information23 in varchar2 default hr_api.g_varchar2
255 ,p_per_information24 in varchar2 default hr_api.g_varchar2
256 ,p_per_information25 in varchar2 default hr_api.g_varchar2
257 ,p_per_information26 in varchar2 default hr_api.g_varchar2
258 ,p_per_information27 in varchar2 default hr_api.g_varchar2
259 ,p_per_information28 in varchar2 default hr_api.g_varchar2
260 ,p_per_information29 in varchar2 default hr_api.g_varchar2
261 ,p_per_information30 in varchar2 default hr_api.g_varchar2
262 ,p_error_message in varchar2 default hr_api.g_varchar2
263 ,p_creation_date in date default hr_api.g_date
264 ,p_last_update_date in date default hr_api.g_date
265 ,p_allow_access in varchar2 default hr_api.g_varchar2
266 ,p_user_guid in raw default null
267 ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
268 ,p_visitor_resp_appl_id in number default hr_api.g_number
269 ,p_security_group_key in varchar2 default hr_api.g_varchar2
270 ,p_return_status out nocopy varchar2
271 ) is
272 --
273 -- Variables for API Boolean parameters
274 l_validate boolean;
275 --
276 -- Variables for IN/OUT parameters
277 --
278 -- Other variables
279 l_proc varchar2(72) := g_package ||'update_pending_data';
280 Begin
281 hr_utility.set_location(' Entering:' || l_proc,10);
282 --
283 -- Issue a savepoint
284 --
285 savepoint update_pending_data_swi;
286 --
287 -- Initialise Multiple Message Detection
288 --
289 hr_multi_message.enable_message_list;
290 --
291 -- Convert constant values to their corresponding boolean value
292 --
293 l_validate :=
294 hr_api.constant_to_boolean
295 (p_constant_value => p_validate);
296 --
297 -- Call API
298 --
299 irc_pending_data_api.update_pending_data
300 (p_validate => l_validate
301 ,p_pending_data_id => p_pending_data_id
302 ,p_email_address => p_email_address
303 ,p_last_name => p_last_name
304 ,p_vacancy_id => p_vacancy_id
305 ,p_first_name => p_first_name
306 ,p_user_password => p_user_password
307 ,p_resume_file_name => p_resume_file_name
308 ,p_resume_description => p_resume_description
309 ,p_resume_mime_type => p_resume_mime_type
310 ,p_source_type => p_source_type
311 ,p_job_post_source_name => p_job_post_source_name
312 ,p_posting_content_id => p_posting_content_id
313 ,p_person_id => p_person_id
314 ,p_processed => p_processed
315 ,p_sex => p_sex
316 ,p_date_of_birth => p_date_of_birth
317 ,p_per_information_category => p_per_information_category
318 ,p_per_information1 => p_per_information1
319 ,p_per_information2 => p_per_information2
320 ,p_per_information3 => p_per_information3
321 ,p_per_information4 => p_per_information4
322 ,p_per_information5 => p_per_information5
323 ,p_per_information6 => p_per_information6
324 ,p_per_information7 => p_per_information7
325 ,p_per_information8 => p_per_information8
326 ,p_per_information9 => p_per_information9
327 ,p_per_information10 => p_per_information10
328 ,p_per_information11 => p_per_information11
329 ,p_per_information12 => p_per_information12
330 ,p_per_information13 => p_per_information13
331 ,p_per_information14 => p_per_information14
332 ,p_per_information15 => p_per_information15
333 ,p_per_information16 => p_per_information16
334 ,p_per_information17 => p_per_information17
335 ,p_per_information18 => p_per_information18
336 ,p_per_information19 => p_per_information19
337 ,p_per_information20 => p_per_information20
338 ,p_per_information21 => p_per_information21
339 ,p_per_information22 => p_per_information22
340 ,p_per_information23 => p_per_information23
341 ,p_per_information24 => p_per_information24
342 ,p_per_information25 => p_per_information25
343 ,p_per_information26 => p_per_information26
344 ,p_per_information27 => p_per_information27
345 ,p_per_information28 => p_per_information28
346 ,p_per_information29 => p_per_information29
347 ,p_per_information30 => p_per_information30
348 ,p_error_message => p_error_message
349 ,p_creation_date => p_creation_date
350 ,p_last_update_date => p_last_update_date
351 ,p_allow_access => p_allow_access
352 ,p_user_guid => p_user_guid
353 ,p_visitor_resp_key => p_visitor_resp_key
354 ,p_visitor_resp_appl_id => p_visitor_resp_appl_id
355 ,p_security_group_key => p_security_group_key
356 );
357 --
358 -- Convert API warning boolean parameter values to specific
359 -- messages and add them to Multiple Message List
360 --
361 --
362 -- Convert API non-warning boolean parameter values
363 --
364 --
365 -- Derive the API return status value based on whether
366 -- messages of any type exist in the Multiple Message List.
367 -- Also disable Multiple Message Detection.
368 --
369 p_return_status := hr_multi_message.get_return_status_disable;
370 hr_utility.set_location(' Leaving:' || l_proc,20);
371 --
372 exception
373 when hr_multi_message.error_message_exist then
374 --
375 -- Catch the Multiple Message List exception which
376 -- indicates API processing has been aborted because
377 -- at least one message exists in the list.
378 --
379 rollback to update_pending_data_swi;
380 --
381 -- Reset IN OUT parameters and set OUT parameters
382 --
383 p_return_status := hr_multi_message.get_return_status_disable;
384 hr_utility.set_location(' Leaving:' || l_proc, 30);
385 when others then
386 --
387 -- When Multiple Message Detection is enabled catch
388 -- any Application specific or other unexpected
389 -- exceptions. Adding appropriate details to the
390 -- Multiple Message List. Otherwise re-raise the
391 -- error.
392 --
393 rollback to update_pending_data_swi;
394 if hr_multi_message.unexpected_error_add(l_proc) then
395 hr_utility.set_location(' Leaving:' || l_proc,40);
396 raise;
397 end if;
398 --
399 -- Reset IN OUT and set OUT parameters
400 --
401 p_return_status := hr_multi_message.get_return_status_disable;
402 hr_utility.set_location(' Leaving:' || l_proc,50);
403 end update_pending_data;
404 -- ----------------------------------------------------------------------------
405 -- |--------------------------< delete_pending_data >-------------------------|
406 -- ----------------------------------------------------------------------------
407 PROCEDURE delete_pending_data
408 (p_validate in number default hr_api.g_false_num
409 ,p_pending_data_id in number
410 ,p_return_status out nocopy varchar2
411 ) is
412 --
413 -- Variables for API Boolean parameters
414 l_validate boolean;
415 --
416 -- Variables for IN/OUT parameters
417 --
418 -- Other variables
419 l_proc varchar2(72) := g_package ||'delete_pending_data';
420 Begin
421 hr_utility.set_location(' Entering:' || l_proc,10);
422 --
423 -- Issue a savepoint
424 --
425 savepoint delete_pending_data_swi;
426 --
427 -- Initialise Multiple Message Detection
428 --
429 hr_multi_message.enable_message_list;
430 --
431 -- Convert constant values to their corresponding boolean value
432 --
433 l_validate :=
434 hr_api.constant_to_boolean
435 (p_constant_value => p_validate);
436 --
437 -- Call API
438 --
439 irc_pending_data_api.delete_pending_data
440 (p_validate => l_validate
441 ,p_pending_data_id => p_pending_data_id
442 );
443 --
444 -- Convert API warning boolean parameter values to specific
445 -- messages and add them to Multiple Message List
446 --
447 --
448 -- Convert API non-warning boolean parameter values
449 --
450 --
451 -- Derive the API return status value based on whether
452 -- messages of any type exist in the Multiple Message List.
453 -- Also disable Multiple Message Detection.
454 --
455 p_return_status := hr_multi_message.get_return_status_disable;
456 hr_utility.set_location(' Leaving:' || l_proc,20);
457 --
458 exception
459 when hr_multi_message.error_message_exist then
460 --
461 -- Catch the Multiple Message List exception which
462 -- indicates API processing has been aborted because
463 -- at least one message exists in the list.
464 --
465 rollback to delete_pending_data_swi;
466 --
467 -- Reset IN OUT parameters and set OUT parameters
468 --
469 p_return_status := hr_multi_message.get_return_status_disable;
470 hr_utility.set_location(' Leaving:' || l_proc, 30);
471 when others then
472 --
473 -- When Multiple Message Detection is enabled catch
474 -- any Application specific or other unexpected
475 -- exceptions. Adding appropriate details to the
476 -- Multiple Message List. Otherwise re-raise the
477 -- error.
478 --
479 rollback to delete_pending_data_swi;
480 if hr_multi_message.unexpected_error_add(l_proc) then
481 hr_utility.set_location(' Leaving:' || l_proc,40);
482 raise;
483 end if;
484 --
485 -- Reset IN OUT and set OUT parameters
486 --
487 p_return_status := hr_multi_message.get_return_status_disable;
488 hr_utility.set_location(' Leaving:' || l_proc,50);
489 end delete_pending_data;
490 end irc_pending_data_swi;