[Home] [Help]
PACKAGE BODY: APPS.HR_APPRAISAL_TEMPLATES_SWI
Source
1 Package Body hr_appraisal_templates_swi As
2 /* $Header: peaptswi.pkb 120.6.12020000.1 2012/06/29 00:44:03 appldev ship $ */
3 --
4 -- Package variables
5 --
6 g_package varchar2(33) := 'hr_appraisal_templates_swi.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |-----------------------< create_appraisal_template >----------------------|
10 -- ----------------------------------------------------------------------------
11 PROCEDURE create_appraisal_template
12 (p_validate in number default hr_api.g_false_num
13 ,p_effective_date in date
14 ,p_business_group_id in number
15 ,p_appraisal_template_id in number
16 ,p_name in varchar2
17 ,p_description in varchar2 default null
18 ,p_instructions in varchar2 default null
19 ,p_date_from in date default null
20 ,p_date_to in date default null
21 ,p_assessment_type_id in number default null
22 ,p_rating_scale_id in number default null
23 ,p_questionnaire_template_id in number default null
24 ,p_attribute_category in varchar2 default null
25 ,p_attribute1 in varchar2 default null
26 ,p_attribute2 in varchar2 default null
27 ,p_attribute3 in varchar2 default null
28 ,p_attribute4 in varchar2 default null
29 ,p_attribute5 in varchar2 default null
30 ,p_attribute6 in varchar2 default null
31 ,p_attribute7 in varchar2 default null
32 ,p_attribute8 in varchar2 default null
33 ,p_attribute9 in varchar2 default null
34 ,p_attribute10 in varchar2 default null
35 ,p_attribute11 in varchar2 default null
36 ,p_attribute12 in varchar2 default null
37 ,p_attribute13 in varchar2 default null
38 ,p_attribute14 in varchar2 default null
39 ,p_attribute15 in varchar2 default null
40 ,p_attribute16 in varchar2 default null
41 ,p_attribute17 in varchar2 default null
42 ,p_attribute18 in varchar2 default null
43 ,p_attribute19 in varchar2 default null
44 ,p_attribute20 in varchar2 default null
45 ,p_objective_asmnt_type_id in number default null
46 ,p_ma_quest_template_id in number default null
47 ,p_link_appr_to_learning_path in varchar2 default null
48 ,p_final_score_formula_id in number default null
49 ,p_update_personal_comp_profile in varchar2 default null
50 ,p_comp_profile_source_type in varchar2 default null
51 ,p_show_competency_ratings in varchar2 default null
52 ,p_show_objective_ratings in varchar2 default null
53 ,p_show_overall_ratings in varchar2 default null
54 ,p_show_overall_comments in varchar2 default null
55 ,p_provide_overall_feedback in varchar2 default null
56 ,p_show_participant_details in varchar2 default null
57 ,p_allow_add_participant in varchar2 default null
58 ,p_show_additional_details in varchar2 default null
59 ,p_show_participant_names in varchar2 default null
60 ,p_show_participant_ratings in varchar2 default null
61 ,p_available_flag in varchar2 default null
62 ,p_show_questionnaire_info in varchar2 default null
63 ,p_ma_off_template_code in varchar2 default null
64 ,p_appraisee_off_template_code in varchar2 default null
65 ,p_other_part_off_template_code in varchar2 default null
66 ,p_part_app_off_template_code in varchar2 default null
67 ,p_part_rev_off_template_code in varchar2 default null
68 ,p_object_version_number out nocopy number
69 ,p_return_status out nocopy varchar2
70 ,p_show_participant_comments in varchar2 default null -- 8651478 bug fix
71
72 ,p_show_term_employee in varchar2 default null -- 6181267 bug fix
73 ,p_show_term_contigent in varchar2 default null -- 6181267 bug fix
74 ,p_disp_term_emp_period_from in number default null -- 6181267 bug fix
75 ,p_SHOW_FUTURE_TERM_EMPLOYEE in varchar2 default null -- 6181267 bug fix
76
77 ) is
78 --
79 -- Variables for API Boolean parameters
80 l_validate boolean;
81 --
82 -- Variables for IN/OUT parameters
83 --
84 -- Other variables
85 l_proc varchar2(72) := g_package ||'create_appraisal_template';
86 l_assessment_type_id per_assessment_types.assessment_type_id%Type;
87 Begin
88 hr_utility.set_location(' Entering:' || l_proc,10);
89 --
90 -- Issue a savepoint
91 --
92 savepoint create_appraisal_template_swi;
93 --
94 -- Initialise Multiple Message Detection
95 --
96 hr_multi_message.enable_message_list;
97 --
98 -- Remember IN OUT parameter IN values
99 --
100 --
101 -- Convert constant values to their corresponding boolean value
102 --
103 l_validate :=
104 hr_api.constant_to_boolean
105 (p_constant_value => p_validate);
106 --
107 -- Register Surrogate ID or user key values
108 per_apt_ins.set_base_key_value(
109 p_appraisal_template_id => p_appraisal_template_id );
110 --
111 -- Call API
112 --
113 hr_appraisal_templates_api.create_appraisal_template
114 (p_validate => l_validate
115 ,p_effective_date => p_effective_date
116 ,p_business_group_id => p_business_group_id
117 ,p_name => p_name
118 ,p_description => p_description
119 ,p_instructions => p_instructions
120 ,p_date_from => p_date_from
121 ,p_date_to => p_date_to
122 ,p_assessment_type_id => p_assessment_type_id
123 ,p_rating_scale_id => p_rating_scale_id
124 ,p_questionnaire_template_id => p_questionnaire_template_id
125 ,p_attribute_category => p_attribute_category
126 ,p_attribute1 => p_attribute1
127 ,p_attribute2 => p_attribute2
128 ,p_attribute3 => p_attribute3
129 ,p_attribute4 => p_attribute4
130 ,p_attribute5 => p_attribute5
131 ,p_attribute6 => p_attribute6
132 ,p_attribute7 => p_attribute7
133 ,p_attribute8 => p_attribute8
134 ,p_attribute9 => p_attribute9
135 ,p_attribute10 => p_attribute10
136 ,p_attribute11 => p_attribute11
137 ,p_attribute12 => p_attribute12
138 ,p_attribute13 => p_attribute13
139 ,p_attribute14 => p_attribute14
140 ,p_attribute15 => p_attribute15
141 ,p_attribute16 => p_attribute16
142 ,p_attribute17 => p_attribute17
143 ,p_attribute18 => p_attribute18
144 ,p_attribute19 => p_attribute19
145 ,p_attribute20 => p_attribute20
146 ,p_objective_asmnt_type_id => p_objective_asmnt_type_id
147 ,p_ma_quest_template_id => p_ma_quest_template_id
148 ,p_link_appr_to_learning_path => p_link_appr_to_learning_path
149 ,p_final_score_formula_id => p_final_score_formula_id
150 ,p_update_personal_comp_profile => p_update_personal_comp_profile
151 ,p_comp_profile_source_type => p_comp_profile_source_type
152 ,p_show_competency_ratings => p_show_competency_ratings
153 ,p_show_objective_ratings => p_show_objective_ratings
154 ,p_show_overall_ratings => p_show_overall_ratings
155 ,p_show_overall_comments => p_show_overall_comments
156 ,p_provide_overall_feedback => p_provide_overall_feedback
157 ,p_show_participant_details => p_show_participant_details
158 ,p_allow_add_participant => p_allow_add_participant
159 ,p_show_additional_details => p_show_additional_details
160 ,p_show_participant_names => p_show_participant_names
161 ,p_show_participant_ratings => p_show_participant_ratings
162 ,p_available_flag => p_available_flag
163 ,p_show_questionnaire_info => p_show_questionnaire_info
164 ,p_ma_off_template_code => p_ma_off_template_code
165 ,p_appraisee_off_template_code => p_appraisee_off_template_code
166 ,p_other_part_off_template_code => p_other_part_off_template_code
167 ,p_part_app_off_template_code => p_part_app_off_template_code
168 ,p_part_rev_off_template_code => p_part_rev_off_template_code
169 ,p_appraisal_template_id => l_assessment_type_id
170 ,p_object_version_number => p_object_version_number
171 ,p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
172 ,p_show_term_employee => p_show_term_employee -- 6181267 bug fix
173 ,p_show_term_contigent => p_show_term_contigent -- 6181267 bug fix
174 ,p_disp_term_emp_period_from => p_disp_term_emp_period_from -- 6181267 bug fix
175 ,p_SHOW_FUTURE_TERM_EMPLOYEE => p_SHOW_FUTURE_TERM_EMPLOYEE -- 6181267 bug fix
176 );
177 --
178 -- Convert API warning boolean parameter values to specific
179 -- messages and add them to Multiple Message List
180 --
181 --
182 -- Convert API non-warning boolean parameter values
183 --
184 --
185 -- Derive the API return status value based on whether
186 -- messages of any type exist in the Multiple Message List.
187 -- Also disable Multiple Message Detection.
188 --
189 p_return_status := hr_multi_message.get_return_status_disable;
190 hr_utility.set_location(' Leaving:' || l_proc,20);
191 --
192 exception
193 when hr_multi_message.error_message_exist then
194 --
195 -- Catch the Multiple Message List exception which
196 -- indicates API processing has been aborted because
197 -- at least one message exists in the list.
198 --
199 rollback to create_appraisal_template_swi;
200 --
201 -- Reset IN OUT parameters and set OUT parameters
202 --
203 p_object_version_number := null;
204 p_return_status := hr_multi_message.get_return_status_disable;
205 hr_utility.set_location(' Leaving:' || l_proc, 30);
206 when others then
207 --
208 -- When Multiple Message Detection is enabled catch
209 -- any Application specific or other unexpected
210 -- exceptions. Adding appropriate details to the
211 -- Multiple Message List. Otherwise re-raise the
212 -- error.
213 --
214 rollback to create_appraisal_template_swi;
215 if hr_multi_message.unexpected_error_add(l_proc) then
216 hr_utility.set_location(' Leaving:' || l_proc,40);
217 raise;
218 end if;
219 --
220 -- Reset IN OUT and set OUT parameters
221 --
222 p_object_version_number := null;
223 p_return_status := hr_multi_message.get_return_status_disable;
224 hr_utility.set_location(' Leaving:' || l_proc,50);
225 end create_appraisal_template;
226 -- ----------------------------------------------------------------------------
227 -- |-----------------------< delete_appraisal_template >----------------------|
228 -- ----------------------------------------------------------------------------
229 PROCEDURE delete_appraisal_template
230 (p_validate in number default hr_api.g_false_num
231 ,p_appraisal_template_id in number
232 ,p_object_version_number in number
233 ,p_return_status out nocopy varchar2
234 ) is
235 --
236 -- Variables for API Boolean parameters
237 l_validate boolean;
238 --
239 -- Variables for IN/OUT parameters
240 --
241 -- Other variables
242 l_proc varchar2(72) := g_package ||'delete_appraisal_template';
243 Begin
244 hr_utility.set_location(' Entering:' || l_proc,10);
245 --
246 -- Issue a savepoint
247 --
248 savepoint delete_appraisal_template_swi;
249 --
250 -- Initialise Multiple Message Detection
251 --
252 hr_multi_message.enable_message_list;
253 --
254 -- Remember IN OUT parameter IN values
255 --
256 --
257 -- Convert constant values to their corresponding boolean value
258 --
259 l_validate :=
260 hr_api.constant_to_boolean
261 (p_constant_value => p_validate);
262 --
263 -- Register Surrogate ID or user key values
264 --
265 --
266 -- Call API
267 --
268 hr_appraisal_templates_api.delete_appraisal_template
269 (p_validate => l_validate
270 ,p_appraisal_template_id => p_appraisal_template_id
271 ,p_object_version_number => p_object_version_number
272 );
273 --
274 -- Convert API warning boolean parameter values to specific
275 -- messages and add them to Multiple Message List
276 --
277 --
278 -- Convert API non-warning boolean parameter values
279 --
280 --
281 -- Derive the API return status value based on whether
282 -- messages of any type exist in the Multiple Message List.
283 -- Also disable Multiple Message Detection.
284 --
285 p_return_status := hr_multi_message.get_return_status_disable;
286 hr_utility.set_location(' Leaving:' || l_proc,20);
287 --
288 exception
289 when hr_multi_message.error_message_exist then
290 --
291 -- Catch the Multiple Message List exception which
292 -- indicates API processing has been aborted because
293 -- at least one message exists in the list.
294 --
295 rollback to delete_appraisal_template_swi;
296 --
297 -- Reset IN OUT parameters and set OUT parameters
298 --
299 p_return_status := hr_multi_message.get_return_status_disable;
300 hr_utility.set_location(' Leaving:' || l_proc, 30);
301 when others then
302 --
303 -- When Multiple Message Detection is enabled catch
304 -- any Application specific or other unexpected
305 -- exceptions. Adding appropriate details to the
306 -- Multiple Message List. Otherwise re-raise the
307 -- error.
308 --
309 rollback to delete_appraisal_template_swi;
310 if hr_multi_message.unexpected_error_add(l_proc) then
311 hr_utility.set_location(' Leaving:' || l_proc,40);
312 raise;
313 end if;
314 --
315 -- Reset IN OUT and set OUT parameters
316 --
317 p_return_status := hr_multi_message.get_return_status_disable;
318 hr_utility.set_location(' Leaving:' || l_proc,50);
319 end delete_appraisal_template;
320 -- ----------------------------------------------------------------------------
321 -- |-----------------------< update_appraisal_template >----------------------|
322 -- ----------------------------------------------------------------------------
323 PROCEDURE update_appraisal_template
324 (p_validate in number default hr_api.g_false_num
325 ,p_effective_date in date
326 ,p_appraisal_template_id in number
327 ,p_object_version_number in out nocopy number
328 ,p_name in varchar2 default hr_api.g_varchar2
329 ,p_description in varchar2 default hr_api.g_varchar2
330 ,p_instructions in varchar2 default hr_api.g_varchar2
331 ,p_date_from in date default hr_api.g_date
332 ,p_date_to in date default hr_api.g_date
333 ,p_assessment_type_id in number default hr_api.g_number
334 ,p_rating_scale_id in number default hr_api.g_number
335 ,p_questionnaire_template_id in number default hr_api.g_number
336 ,p_attribute_category in varchar2 default hr_api.g_varchar2
337 ,p_attribute1 in varchar2 default hr_api.g_varchar2
338 ,p_attribute2 in varchar2 default hr_api.g_varchar2
339 ,p_attribute3 in varchar2 default hr_api.g_varchar2
340 ,p_attribute4 in varchar2 default hr_api.g_varchar2
341 ,p_attribute5 in varchar2 default hr_api.g_varchar2
342 ,p_attribute6 in varchar2 default hr_api.g_varchar2
343 ,p_attribute7 in varchar2 default hr_api.g_varchar2
344 ,p_attribute8 in varchar2 default hr_api.g_varchar2
345 ,p_attribute9 in varchar2 default hr_api.g_varchar2
346 ,p_attribute10 in varchar2 default hr_api.g_varchar2
347 ,p_attribute11 in varchar2 default hr_api.g_varchar2
348 ,p_attribute12 in varchar2 default hr_api.g_varchar2
349 ,p_attribute13 in varchar2 default hr_api.g_varchar2
350 ,p_attribute14 in varchar2 default hr_api.g_varchar2
351 ,p_attribute15 in varchar2 default hr_api.g_varchar2
352 ,p_attribute16 in varchar2 default hr_api.g_varchar2
353 ,p_attribute17 in varchar2 default hr_api.g_varchar2
354 ,p_attribute18 in varchar2 default hr_api.g_varchar2
355 ,p_attribute19 in varchar2 default hr_api.g_varchar2
356 ,p_attribute20 in varchar2 default hr_api.g_varchar2
357 ,p_objective_asmnt_type_id in number default hr_api.g_number
358 ,p_ma_quest_template_id in number default hr_api.g_number
359 ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
360 ,p_final_score_formula_id in number default hr_api.g_number
361 ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
362 ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
363 ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
364 ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
365 ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
366 ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
367 ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
368 ,p_show_participant_details in varchar2 default hr_api.g_varchar2
369 ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
370 ,p_show_additional_details in varchar2 default hr_api.g_varchar2
371 ,p_show_participant_names in varchar2 default hr_api.g_varchar2
372 ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
373 ,p_available_flag in varchar2 default hr_api.g_varchar2
374 ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
375 ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
376 ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
377 ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
378 ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
379 ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
380 ,p_return_status out nocopy varchar2
381 , p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
382 ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
383 ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
384 ,p_disp_term_emp_period_from in number default hr_api.g_number -- 6181267 bug fix
385 ,p_SHOW_FUTURE_TERM_EMPLOYEE in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
386 ) is
387 --
388 -- Variables for API Boolean parameters
389 l_validate boolean;
390 --
391 -- Variables for IN/OUT parameters
392 l_object_version_number number;
393 --
394 -- Other variables
395 l_proc varchar2(72) := g_package ||'update_appraisal_template';
396 Begin
397
398
399 hr_utility.set_location(' Entering:' || l_proc,10);
400 --
401 -- Issue a savepoint
402 --
403 savepoint update_appraisal_template_swi;
404 --
405 -- Initialise Multiple Message Detection
406 --
407 hr_multi_message.enable_message_list;
408 --
409 -- Remember IN OUT parameter IN values
410 --
411 l_object_version_number := p_object_version_number;
412 --
413 -- Convert constant values to their corresponding boolean value
414 --
415 l_validate :=
416 hr_api.constant_to_boolean
417 (p_constant_value => p_validate);
418 --
419 -- Register Surrogate ID or user key values
420 --
421 --
422 -- Call API
423 --
424 hr_appraisal_templates_api.update_appraisal_template
425 (p_validate => l_validate
426 ,p_effective_date => p_effective_date
427 ,p_appraisal_template_id => p_appraisal_template_id
428 ,p_object_version_number => p_object_version_number
429 ,p_name => p_name
430 ,p_description => p_description
431 ,p_instructions => p_instructions
432 ,p_date_from => p_date_from
433 ,p_date_to => p_date_to
434 ,p_assessment_type_id => p_assessment_type_id
435 ,p_rating_scale_id => p_rating_scale_id
436 ,p_questionnaire_template_id => p_questionnaire_template_id
437 ,p_attribute_category => p_attribute_category
438 ,p_attribute1 => p_attribute1
439 ,p_attribute2 => p_attribute2
440 ,p_attribute3 => p_attribute3
441 ,p_attribute4 => p_attribute4
442 ,p_attribute5 => p_attribute5
443 ,p_attribute6 => p_attribute6
444 ,p_attribute7 => p_attribute7
445 ,p_attribute8 => p_attribute8
446 ,p_attribute9 => p_attribute9
447 ,p_attribute10 => p_attribute10
448 ,p_attribute11 => p_attribute11
449 ,p_attribute12 => p_attribute12
450 ,p_attribute13 => p_attribute13
451 ,p_attribute14 => p_attribute14
452 ,p_attribute15 => p_attribute15
453 ,p_attribute16 => p_attribute16
454 ,p_attribute17 => p_attribute17
455 ,p_attribute18 => p_attribute18
456 ,p_attribute19 => p_attribute19
457 ,p_attribute20 => p_attribute20
458 ,p_objective_asmnt_type_id => p_objective_asmnt_type_id
459 ,p_ma_quest_template_id => p_ma_quest_template_id
460 ,p_link_appr_to_learning_path => p_link_appr_to_learning_path
461 ,p_final_score_formula_id => p_final_score_formula_id
462 ,p_update_personal_comp_profile => p_update_personal_comp_profile
463 ,p_comp_profile_source_type => p_comp_profile_source_type
464 ,p_show_competency_ratings => p_show_competency_ratings
465 ,p_show_objective_ratings => p_show_objective_ratings
466 ,p_show_overall_ratings => p_show_overall_ratings
467 ,p_show_overall_comments => p_show_overall_comments
468 ,p_provide_overall_feedback => p_provide_overall_feedback
469 ,p_show_participant_details => p_show_participant_details
470 ,p_allow_add_participant => p_allow_add_participant
471 ,p_show_additional_details => p_show_additional_details
472 ,p_show_participant_names => p_show_participant_names
473 ,p_show_participant_ratings => p_show_participant_ratings
474 ,p_available_flag => p_available_flag
475 ,p_show_questionnaire_info => p_show_questionnaire_info
476 ,p_ma_off_template_code => p_ma_off_template_code
477 ,p_appraisee_off_template_code => p_appraisee_off_template_code
478 ,p_other_part_off_template_code => p_other_part_off_template_code
479 ,p_part_app_off_template_code => p_part_app_off_template_code
480 ,p_part_rev_off_template_code => p_part_rev_off_template_code
481 ,p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
482 ,p_show_term_employee => p_show_term_employee -- 6181267 bug fix
483 ,p_show_term_contigent => p_show_term_contigent -- 6181267 bug fix
484 ,p_disp_term_emp_period_from => p_disp_term_emp_period_from -- 6181267 bug fix
485 ,p_SHOW_FUTURE_TERM_EMPLOYEE => p_SHOW_FUTURE_TERM_EMPLOYEE -- 6181267 bug fix
486
487 );
488 --
489 -- Convert API warning boolean parameter values to specific
490 -- messages and add them to Multiple Message List
491 --
492 --
493 -- Convert API non-warning boolean parameter values
494 --
495 --
496 -- Derive the API return status value based on whether
497 -- messages of any type exist in the Multiple Message List.
498 -- Also disable Multiple Message Detection.
499 --
500 p_return_status := hr_multi_message.get_return_status_disable;
501 hr_utility.set_location(' Leaving:' || l_proc,20);
502
503
504 --
505 exception
506 when hr_multi_message.error_message_exist then
507 --
508 -- Catch the Multiple Message List exception which
509 -- indicates API processing has been aborted because
510 -- at least one message exists in the list.
511 --
512 rollback to update_appraisal_template_swi;
513 --
514 -- Reset IN OUT parameters and set OUT parameters
515 --
516 p_object_version_number := l_object_version_number;
517 p_return_status := hr_multi_message.get_return_status_disable;
518 hr_utility.set_location(' Leaving:' || l_proc, 30);
519
520 when others then
521 --
522 -- When Multiple Message Detection is enabled catch
523 -- any Application specific or other unexpected
524 -- exceptions. Adding appropriate details to the
525 -- Multiple Message List. Otherwise re-raise the
526 -- error.
527 --
528 rollback to update_appraisal_template_swi;
529 if hr_multi_message.unexpected_error_add(l_proc) then
530 hr_utility.set_location(' Leaving:' || l_proc,40);
531 raise;
532 end if;
533 --
534 -- Reset IN OUT and set OUT parameters
535 --
536 p_object_version_number := l_object_version_number;
537 p_return_status := hr_multi_message.get_return_status_disable;
538 hr_utility.set_location(' Leaving:' || l_proc,50);
539
540 end update_appraisal_template;
541 end hr_appraisal_templates_swi;