DBA Data[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;