[Home] [Help]
PACKAGE BODY: APPS.OTA_ACTIVITY_VERSION_API
Source
1 PACKAGE BODY ota_activity_version_api as
2 /* $Header: ottavapi.pkb 120.0 2005/05/29 07:35:01 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' OTA_ACTIVITY_VERSION_API.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |-------------------------< CREATE_ACTIVITY_VERSION >------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_activity_version
13 (
14 p_effective_date in date,
15 p_validate in boolean default false ,
16 p_activity_id in number,
17 p_superseded_by_act_version_id in number ,
18 p_developer_organization_id in number,
19 p_controlling_person_id in number ,
20 p_version_name in varchar2,
21 p_comments in varchar2 ,
22 p_description in varchar2 ,
23 p_duration in number ,
24 p_duration_units in varchar2 ,
25 p_end_date in date ,
26 p_intended_audience in varchar2 ,
27 p_language_id in number ,
28 p_maximum_attendees in number ,
29 p_minimum_attendees in number ,
30 p_objectives in varchar2 ,
31 p_start_date in date ,
32 p_success_criteria in varchar2 ,
33 p_user_status in varchar2 ,
34 p_vendor_id in number ,
35 p_actual_cost in number ,
36 p_budget_cost in number ,
37 p_budget_currency_code in varchar2 ,
38 p_expenses_allowed in varchar2 ,
39 p_professional_credit_type in varchar2 ,
40 p_professional_credits in number ,
41 p_maximum_internal_attendees in number ,
42 p_tav_information_category in varchar2 ,
43 p_tav_information1 in varchar2 ,
44 p_tav_information2 in varchar2 ,
45 p_tav_information3 in varchar2 ,
46 p_tav_information4 in varchar2 ,
47 p_tav_information5 in varchar2 ,
48 p_tav_information6 in varchar2 ,
49 p_tav_information7 in varchar2 ,
50 p_tav_information8 in varchar2 ,
51 p_tav_information9 in varchar2 ,
52 p_tav_information10 in varchar2 ,
53 p_tav_information11 in varchar2 ,
54 p_tav_information12 in varchar2 ,
55 p_tav_information13 in varchar2 ,
56 p_tav_information14 in varchar2 ,
57 p_tav_information15 in varchar2 ,
58 p_tav_information16 in varchar2 ,
59 p_tav_information17 in varchar2 ,
60 p_tav_information18 in varchar2 ,
61 p_tav_information19 in varchar2 ,
62 p_tav_information20 in varchar2 ,
63 p_inventory_item_id in number ,
64 p_organization_id in number ,
65 p_rco_id in number ,
66 p_version_code in varchar2 ,
67 p_keywords in varchar2 ,
68 p_business_group_id in number ,
69 p_activity_version_id out nocopy number ,
70 p_object_version_number out nocopy number,
71 p_data_source in varchar2
72 ,p_competency_update_level in varchar2
73
74 ) is
75 --
76 -- Declare cursors and local variables
77 --
78 l_proc varchar2(72) := g_package||' Create Activity Version';
79 l_activity_version_id number;
80 l_object_version_number number;
81 l_effective_date date;
82 l_version_name ota_activity_versions_tl.version_name%type;
83 begin
84 hr_utility.set_location('Entering:'|| l_proc, 10);
85 --
86 -- Issue a savepoint
87 --
88 savepoint CREATE_ACTIVITY_VERSION;
89 l_effective_date := trunc(p_effective_date);
90 l_version_name := rtrim(p_version_name);
91 --
92 begin
93 ota_activity_version_bk1.create_activity_version_b
94 (
95 p_effective_date => l_effective_date ,
96 p_activity_id => p_activity_id ,
97 p_superseded_by_act_version_id => p_superseded_by_act_version_id ,
98 p_developer_organization_id => p_developer_organization_id ,
99 p_controlling_person_id => p_controlling_person_id ,
100 p_version_name => l_version_name ,
101 p_comments => p_comments ,
102 p_description => p_description ,
103 p_duration => p_duration ,
104 p_duration_units => p_duration_units ,
105 p_end_date => p_end_date ,
106 p_intended_audience => p_intended_audience ,
107 p_language_id => p_language_id ,
108 p_maximum_attendees => p_maximum_attendees ,
109 p_minimum_attendees => p_minimum_attendees ,
110 p_objectives => p_objectives ,
111 p_start_date => p_start_date ,
112 p_success_criteria => p_success_criteria ,
113 p_user_status => p_user_status ,
114 p_vendor_id => p_vendor_id ,
115 p_actual_cost => p_actual_cost ,
116 p_budget_cost => p_budget_cost ,
117 p_budget_currency_code => p_budget_currency_code ,
118 p_expenses_allowed => p_expenses_allowed ,
119 p_professional_credit_type => p_professional_credit_type ,
120 p_professional_credits => p_professional_credits ,
121 p_maximum_internal_attendees => p_maximum_internal_attendees ,
122 p_tav_information_category => p_tav_information_category ,
123 p_tav_information1 => p_tav_information1 ,
124 p_tav_information2 => p_tav_information2 ,
125 p_tav_information3 => p_tav_information3 ,
126 p_tav_information4 => p_tav_information4 ,
127 p_tav_information5 => p_tav_information5 ,
128 p_tav_information6 => p_tav_information6 ,
129 p_tav_information7 => p_tav_information7 ,
130 p_tav_information8 => p_tav_information8 ,
131 p_tav_information9 => p_tav_information9 ,
132 p_tav_information10 => p_tav_information10 ,
133 p_tav_information11 => p_tav_information11 ,
134 p_tav_information12 => p_tav_information12 ,
135 p_tav_information13 => p_tav_information13 ,
136 p_tav_information14 => p_tav_information14 ,
137 p_tav_information15 => p_tav_information15 ,
138 p_tav_information16 => p_tav_information16 ,
139 p_tav_information17 => p_tav_information17 ,
140 p_tav_information18 => p_tav_information18 ,
141 p_tav_information19 => p_tav_information19 ,
142 p_tav_information20 => p_tav_information20 ,
143 p_inventory_item_id => p_inventory_item_id ,
144 p_organization_id => p_organization_id ,
145 p_rco_id => p_rco_id ,
146 p_version_code => p_version_code ,
147 p_business_group_id => p_business_group_id ,
148 p_object_version_number => l_object_version_number ,
149 p_data_source => p_data_source
150 ,p_competency_update_level => p_competency_update_level
151
152 );
153 exception
154 when hr_api.cannot_find_prog_unit then
155 hr_api.cannot_find_prog_unit_error
156 (p_module_name => 'CREATE_ACTIVITY_VERSION'
157 ,p_hook_type => 'BP'
158 );
159 end;
160
161 --
162 -- Process Logic
163 --
164 ota_tav_ins.ins
165 (
166 p_validate => p_validate ,
167 p_activity_id => p_activity_id ,
168 p_superseded_by_act_version_id => p_superseded_by_act_version_id ,
169 p_developer_organization_id => p_developer_organization_id ,
170 p_controlling_person_id => p_controlling_person_id ,
171 p_version_name => l_version_name ,
172 p_comments => p_comments ,
173 p_description => p_description ,
174 p_duration => p_duration ,
175 p_duration_units => p_duration_units ,
176 p_end_date => p_end_date ,
177 p_intended_audience => p_intended_audience ,
178 p_language_id => p_language_id ,
179 p_maximum_attendees => p_maximum_attendees ,
180 p_minimum_attendees => p_minimum_attendees ,
181 p_objectives => p_objectives ,
182 p_start_date => p_start_date ,
183 p_success_criteria => p_success_criteria ,
184 p_user_status => p_user_status ,
185 p_vendor_id => p_vendor_id ,
186 p_actual_cost => p_actual_cost ,
187 p_budget_cost => p_budget_cost ,
188 p_budget_currency_code => p_budget_currency_code ,
189 p_expenses_allowed => p_expenses_allowed ,
190 p_professional_credit_type => p_professional_credit_type ,
191 p_professional_credits => p_professional_credits ,
195 p_tav_information2 => p_tav_information2 ,
192 p_maximum_internal_attendees => p_maximum_internal_attendees ,
193 p_tav_information_category => p_tav_information_category ,
194 p_tav_information1 => p_tav_information1 ,
196 p_tav_information3 => p_tav_information3 ,
197 p_tav_information4 => p_tav_information4 ,
198 p_tav_information5 => p_tav_information5 ,
199 p_tav_information6 => p_tav_information6 ,
200 p_tav_information7 => p_tav_information7 ,
201 p_tav_information8 => p_tav_information8 ,
202 p_tav_information9 => p_tav_information9 ,
203 p_tav_information10 => p_tav_information10 ,
204 p_tav_information11 => p_tav_information11 ,
205 p_tav_information12 => p_tav_information12 ,
206 p_tav_information13 => p_tav_information13 ,
207 p_tav_information14 => p_tav_information14 ,
208 p_tav_information15 => p_tav_information15 ,
209 p_tav_information16 => p_tav_information16 ,
210 p_tav_information17 => p_tav_information17 ,
211 p_tav_information18 => p_tav_information18 ,
212 p_tav_information19 => p_tav_information19 ,
213 p_tav_information20 => p_tav_information20 ,
214 p_inventory_item_id => p_inventory_item_id ,
215 p_organization_id => p_organization_id ,
216 p_rco_id => p_rco_id ,
217 p_version_code => p_version_code ,
218 p_business_group_id => p_business_group_id ,
219 p_activity_version_id => l_activity_version_id ,
220 p_object_version_number => l_object_version_number ,
221 p_data_source => p_data_source
222 ,p_competency_update_level => p_competency_update_level
223
224 );
225 --
226 -- Set all output arguments
227 --
228 p_activity_version_id := l_activity_version_id;
229 p_object_version_number := l_object_version_number;
230 ota_avt_ins.ins_tl
231 (p_effective_date => l_effective_date
232 ,p_language_code => USERENV('LANG')
233 ,p_activity_version_id => p_activity_version_id
234 ,p_version_name => l_version_name
235 ,p_description => p_description
236 ,p_intended_audience => p_intended_audience
237 ,p_objectives => p_objectives
238 ,p_keywords => p_keywords
239 );
240
241
242
243 --
244 --
245 begin
246 ota_activity_version_bk1.create_activity_version_a
247 (
248 p_effective_date => l_effective_date ,
249 p_activity_id => p_activity_id ,
250 p_superseded_by_act_version_id => p_superseded_by_act_version_id ,
254 p_comments => p_comments ,
251 p_developer_organization_id => p_developer_organization_id ,
252 p_controlling_person_id => p_controlling_person_id ,
253 p_version_name => l_version_name ,
255 p_description => p_description ,
256 p_duration => p_duration ,
257 p_duration_units => p_duration_units ,
258 p_end_date => p_end_date ,
259 p_intended_audience => p_intended_audience ,
260 p_language_id => p_language_id ,
261 p_maximum_attendees => p_maximum_attendees ,
262 p_minimum_attendees => p_minimum_attendees ,
263 p_objectives => p_objectives ,
264 p_start_date => p_start_date ,
265 p_success_criteria => p_success_criteria ,
266 p_user_status => p_user_status ,
267 p_vendor_id => p_vendor_id ,
268 p_actual_cost => p_actual_cost ,
269 p_budget_cost => p_budget_cost ,
270 p_budget_currency_code => p_budget_currency_code ,
271 p_expenses_allowed => p_expenses_allowed ,
272 p_professional_credit_type => p_professional_credit_type ,
273 p_professional_credits => p_professional_credits ,
274 p_maximum_internal_attendees => p_maximum_internal_attendees ,
275 p_tav_information_category => p_tav_information_category ,
276 p_tav_information1 => p_tav_information1 ,
277 p_tav_information2 => p_tav_information2 ,
278 p_tav_information3 => p_tav_information3 ,
279 p_tav_information4 => p_tav_information4 ,
280 p_tav_information5 => p_tav_information5 ,
281 p_tav_information6 => p_tav_information6 ,
282 p_tav_information7 => p_tav_information7 ,
283 p_tav_information8 => p_tav_information8 ,
284 p_tav_information9 => p_tav_information9 ,
285 p_tav_information10 => p_tav_information10 ,
286 p_tav_information11 => p_tav_information11 ,
287 p_tav_information12 => p_tav_information12 ,
288 p_tav_information13 => p_tav_information13 ,
289 p_tav_information14 => p_tav_information14 ,
290 p_tav_information15 => p_tav_information15 ,
291 p_tav_information16 => p_tav_information16 ,
292 p_tav_information17 => p_tav_information17 ,
293 p_tav_information18 => p_tav_information18 ,
297 p_organization_id => p_organization_id ,
294 p_tav_information19 => p_tav_information19 ,
295 p_tav_information20 => p_tav_information20 ,
296 p_inventory_item_id => p_inventory_item_id ,
298 p_rco_id => p_rco_id ,
299 p_version_code => p_version_code ,
300 p_business_group_id => p_business_group_id ,
301 p_object_version_number => l_object_version_number ,
302 p_activity_version_id => l_activity_version_id,
303 p_data_source => p_data_source
304 ,p_competency_update_level => p_competency_update_level
305
306 );
307 exception
308 when hr_api.cannot_find_prog_unit then
309 hr_api.cannot_find_prog_unit_error
310 (p_module_name => 'CREATE_ACTIVITY_VERSION'
311 ,p_hook_type => 'AP'
312 );
313 end;
314
315 --
316 -- When in validation only mode raise the Validate_Enabled exception
317 --
318 if p_validate then
319 raise hr_api.validate_enabled;
320 end if;
321
322 hr_utility.set_location(' Leaving:'||l_proc, 70);
323 exception
324 when hr_api.validate_enabled then
325 --
326 -- As the Validate_Enabled exception has been raised
327 -- we must rollback to the savepoint
328 --
329 rollback to CREATE_ACTIVITY_VERSION;
330 --
331 -- Only set output warning arguments
332 -- (Any key or derived arguments must be set to null
333 -- when validation only mode is being used.)
334 --
335 p_activity_version_id := null;
336 p_object_version_number := null;
337 hr_utility.set_location(' Leaving:'||l_proc, 80);
338 when others then
339 --
340 -- A validation or unexpected error has occured
341 --
342 rollback to CREATE_ACTIVITY_VERSION;
343 p_activity_version_id := null;
344 p_object_version_number := null;
345 hr_utility.set_location(' Leaving:'||l_proc, 90);
346 raise;
347 end create_activity_version;
348 -- ----------------------------------------------------------------------------
349 -- |-------------------------< UPDATE_ACTIVITY_VERSION >-------------------------|
350 -- ----------------------------------------------------------------------------
351 --
352 procedure update_activity_version
353 (
354 p_effective_date in date ,
355 p_activity_version_id in number,
356 p_activity_id in number ,
357 p_superseded_by_act_version_id in number ,
358 p_developer_organization_id in number ,
359 p_controlling_person_id in number ,
360 p_object_version_number in out nocopy number,
361 p_version_name in varchar2 ,
362 p_comments in varchar2 ,
363 p_description in varchar2 ,
364 p_duration in number ,
365 p_duration_units in varchar2 ,
366 p_end_date in date ,
367 p_intended_audience in varchar2 ,
368 p_language_id in number ,
369 p_maximum_attendees in number ,
370 p_minimum_attendees in number ,
371 p_objectives in varchar2 ,
372 p_start_date in date ,
373 p_success_criteria in varchar2 ,
374 p_user_status in varchar2 ,
375 p_vendor_id in number ,
376 p_actual_cost in number ,
377 p_budget_cost in number ,
378 p_budget_currency_code in varchar2 ,
379 p_expenses_allowed in varchar2 ,
380 p_professional_credit_type in varchar2 ,
381 p_professional_credits in number ,
382 p_maximum_internal_attendees in number ,
383 p_tav_information_category in varchar2 ,
384 p_tav_information1 in varchar2 ,
385 p_tav_information2 in varchar2 ,
386 p_tav_information3 in varchar2 ,
387 p_tav_information4 in varchar2 ,
388 p_tav_information5 in varchar2 ,
389 p_tav_information6 in varchar2 ,
390 p_tav_information7 in varchar2 ,
391 p_tav_information8 in varchar2 ,
392 p_tav_information9 in varchar2 ,
393 p_tav_information10 in varchar2 ,
394 p_tav_information11 in varchar2 ,
395 p_tav_information12 in varchar2 ,
396 p_tav_information13 in varchar2 ,
397 p_tav_information14 in varchar2 ,
398 p_tav_information15 in varchar2 ,
399 p_tav_information16 in varchar2 ,
400 p_tav_information17 in varchar2 ,
401 p_tav_information18 in varchar2 ,
402 p_tav_information19 in varchar2 ,
403 p_tav_information20 in varchar2 ,
404 p_inventory_item_id in number ,
405 p_organization_id in number ,
406 p_rco_id in number ,
407 p_version_code in varchar2 ,
408 p_keywords in varchar2 ,
409 p_business_group_id in number ,
413 ) is
410 p_validate in boolean ,
411 p_data_source in varchar2
412 ,p_competency_update_level in varchar2
414 --
415 -- Declare cursors and local variables
416 --
417 l_proc varchar2(72) := g_package||' Update Activity Version';
418 l_object_version_number number := p_object_version_number;
419 l_effective_date date;
420 l_version_name ota_activity_versions_tl.version_name%type;
421 begin
422 hr_utility.set_location('Entering:'|| l_proc, 10);
423 --
424 -- Issue a savepoint
425 --
426 savepoint UPDATE_ACTIVITY_VERSION;
427 l_effective_date := trunc(p_effective_date);
428 l_version_name := rtrim(p_version_name);
429 --
430 --
431 begin
432 ota_activity_version_bk2.update_activity_version_b
433 (
434 p_effective_date => l_effective_date ,
435 p_activity_id => p_activity_id ,
436 p_superseded_by_act_version_id => p_superseded_by_act_version_id ,
437 p_developer_organization_id => p_developer_organization_id ,
438 p_controlling_person_id => p_controlling_person_id ,
439 p_version_name => l_version_name ,
440 p_comments => p_comments ,
441 p_description => p_description ,
442 p_duration => p_duration ,
443 p_duration_units => p_duration_units ,
444 p_end_date => p_end_date ,
445 p_intended_audience => p_intended_audience ,
446 p_language_id => p_language_id ,
447 p_maximum_attendees => p_maximum_attendees ,
448 p_minimum_attendees => p_minimum_attendees ,
449 p_objectives => p_objectives ,
450 p_start_date => p_start_date ,
451 p_success_criteria => p_success_criteria ,
452 p_user_status => p_user_status ,
453 p_vendor_id => p_vendor_id ,
454 p_actual_cost => p_actual_cost ,
455 p_budget_cost => p_budget_cost ,
456 p_budget_currency_code => p_budget_currency_code ,
457 p_expenses_allowed => p_expenses_allowed ,
458 p_professional_credit_type => p_professional_credit_type ,
459 p_professional_credits => p_professional_credits ,
460 p_maximum_internal_attendees => p_maximum_internal_attendees ,
461 p_tav_information_category => p_tav_information_category ,
462 p_tav_information1 => p_tav_information1 ,
463 p_tav_information2 => p_tav_information2 ,
464 p_tav_information3 => p_tav_information3 ,
465 p_tav_information4 => p_tav_information4 ,
466 p_tav_information5 => p_tav_information5 ,
467 p_tav_information6 => p_tav_information6 ,
468 p_tav_information7 => p_tav_information7 ,
469 p_tav_information8 => p_tav_information8 ,
470 p_tav_information9 => p_tav_information9 ,
471 p_tav_information10 => p_tav_information10 ,
472 p_tav_information11 => p_tav_information11 ,
473 p_tav_information12 => p_tav_information12 ,
474 p_tav_information13 => p_tav_information13 ,
475 p_tav_information14 => p_tav_information14 ,
476 p_tav_information15 => p_tav_information15 ,
477 p_tav_information16 => p_tav_information16 ,
478 p_tav_information17 => p_tav_information17 ,
479 p_tav_information18 => p_tav_information18 ,
480 p_tav_information19 => p_tav_information19 ,
481 p_tav_information20 => p_tav_information20 ,
482 p_inventory_item_id => p_inventory_item_id ,
483 p_organization_id => p_organization_id ,
484 p_rco_id => p_rco_id ,
485 p_version_code => p_version_code ,
486 p_business_group_id => p_business_group_id ,
487 p_object_version_number => l_object_version_number ,
488 p_activity_version_id => p_activity_version_id,
489 p_data_source => p_data_source
490 ,p_competency_update_level => p_competency_update_level
491
492 );
493 exception
494 when hr_api.cannot_find_prog_unit then
495 hr_api.cannot_find_prog_unit_error
496 (p_module_name => 'UPDATE_ACTIVITY_VERSION'
497 ,p_hook_type => 'BP'
498 );
499 end;
500
501 --
502 -- Process Logic
503 --
504 ota_tav_upd.upd
505 (
506 p_activity_version_id => p_activity_version_id ,
507 p_activity_id => p_activity_id ,
508 p_superseded_by_act_version_id => p_superseded_by_act_version_id ,
512 p_version_name => l_version_name ,
509 p_developer_organization_id => p_developer_organization_id ,
510 p_controlling_person_id => p_controlling_person_id ,
511 p_object_version_number => p_object_version_number ,
513 p_comments => p_comments ,
514 p_description => p_description ,
515 p_duration => p_duration ,
516 p_duration_units => p_duration_units ,
517 p_end_date => p_end_date ,
518 p_intended_audience => p_intended_audience ,
519 p_language_id => p_language_id ,
520 p_maximum_attendees => p_maximum_attendees ,
521 p_minimum_attendees => p_minimum_attendees ,
522 p_objectives => p_objectives ,
523 p_start_date => p_start_date ,
524 p_success_criteria => p_success_criteria ,
525 p_user_status => p_user_status ,
526 p_vendor_id => p_vendor_id ,
527 p_actual_cost => p_actual_cost ,
528 p_budget_cost => p_budget_cost ,
529 p_budget_currency_code => p_budget_currency_code ,
530 p_expenses_allowed => p_expenses_allowed ,
531 p_professional_credit_type => p_professional_credit_type ,
532 p_professional_credits => p_professional_credits ,
533 p_maximum_internal_attendees => p_maximum_internal_attendees ,
534 p_tav_information_category => p_tav_information_category ,
535 p_tav_information1 => p_tav_information1 ,
536 p_tav_information2 => p_tav_information2 ,
537 p_tav_information3 => p_tav_information3 ,
538 p_tav_information4 => p_tav_information4 ,
539 p_tav_information5 => p_tav_information5 ,
540 p_tav_information6 => p_tav_information6 ,
541 p_tav_information7 => p_tav_information7 ,
542 p_tav_information8 => p_tav_information8 ,
543 p_tav_information9 => p_tav_information9 ,
544 p_tav_information10 => p_tav_information10 ,
545 p_tav_information11 => p_tav_information11 ,
546 p_tav_information12 => p_tav_information12 ,
547 p_tav_information13 => p_tav_information13 ,
548 p_tav_information14 => p_tav_information14 ,
549 p_tav_information15 => p_tav_information15 ,
550 p_tav_information16 => p_tav_information16 ,
551 p_tav_information17 => p_tav_information17 ,
552 p_tav_information18 => p_tav_information18 ,
553 p_tav_information19 => p_tav_information19 ,
554 p_tav_information20 => p_tav_information20 ,
555 p_inventory_item_id => p_inventory_item_id ,
556 p_organization_id => p_organization_id ,
557 p_rco_id => p_rco_id ,
558 p_version_code => p_version_code ,
559 p_business_group_id => p_business_group_id ,
560 p_validate => p_validate ,
561 p_data_source => p_data_source
562 ,p_competency_update_level => p_competency_update_level
563
564 );
565 ota_avt_upd.upd_tl
566 (p_effective_date => l_effective_date
567 ,p_language_code => USERENV('LANG')
568 ,p_activity_version_id => p_activity_version_id
569 ,p_version_name => l_version_name
570 ,p_description => p_description
571 ,p_intended_audience => p_intended_audience
572 ,p_objectives => p_objectives
573 ,p_keywords => p_keywords
574 );
575
576 --
577 --
578 begin
579 ota_activity_version_bk2.update_activity_version_a
580 (
581 p_effective_date => l_effective_date ,
582 p_activity_id => p_activity_id ,
583 p_superseded_by_act_version_id => p_superseded_by_act_version_id ,
584 p_developer_organization_id => p_developer_organization_id ,
585 p_controlling_person_id => p_controlling_person_id ,
586 p_version_name => l_version_name ,
587 p_comments => p_comments ,
588 p_description => p_description ,
589 p_duration => p_duration ,
590 p_duration_units => p_duration_units ,
591 p_end_date => p_end_date ,
592 p_intended_audience => p_intended_audience ,
593 p_language_id => p_language_id ,
594 p_maximum_attendees => p_maximum_attendees ,
595 p_minimum_attendees => p_minimum_attendees ,
596 p_objectives => p_objectives ,
597 p_start_date => p_start_date ,
598 p_success_criteria => p_success_criteria ,
599 p_user_status => p_user_status ,
600 p_vendor_id => p_vendor_id ,
601 p_actual_cost => p_actual_cost ,
605 p_professional_credit_type => p_professional_credit_type ,
602 p_budget_cost => p_budget_cost ,
603 p_budget_currency_code => p_budget_currency_code ,
604 p_expenses_allowed => p_expenses_allowed ,
606 p_professional_credits => p_professional_credits ,
607 p_maximum_internal_attendees => p_maximum_internal_attendees ,
608 p_tav_information_category => p_tav_information_category ,
609 p_tav_information1 => p_tav_information1 ,
610 p_tav_information2 => p_tav_information2 ,
611 p_tav_information3 => p_tav_information3 ,
612 p_tav_information4 => p_tav_information4 ,
613 p_tav_information5 => p_tav_information5 ,
614 p_tav_information6 => p_tav_information6 ,
615 p_tav_information7 => p_tav_information7 ,
616 p_tav_information8 => p_tav_information8 ,
617 p_tav_information9 => p_tav_information9 ,
618 p_tav_information10 => p_tav_information10 ,
619 p_tav_information11 => p_tav_information11 ,
620 p_tav_information12 => p_tav_information12 ,
621 p_tav_information13 => p_tav_information13 ,
622 p_tav_information14 => p_tav_information14 ,
623 p_tav_information15 => p_tav_information15 ,
624 p_tav_information16 => p_tav_information16 ,
625 p_tav_information17 => p_tav_information17 ,
626 p_tav_information18 => p_tav_information18 ,
627 p_tav_information19 => p_tav_information19 ,
628 p_tav_information20 => p_tav_information20 ,
629 p_inventory_item_id => p_inventory_item_id ,
630 p_organization_id => p_organization_id ,
631 p_rco_id => p_rco_id ,
632 p_version_code => p_version_code ,
633 p_business_group_id => p_business_group_id ,
634 p_object_version_number => l_object_version_number ,
635 p_activity_version_id => p_activity_version_id,
636 p_data_source => p_data_source
637 ,p_competency_update_level => p_competency_update_level
638
639
640 );
641 exception
642 when hr_api.cannot_find_prog_unit then
643 hr_api.cannot_find_prog_unit_error
644 (p_module_name => 'UPDATE_ACTIVITY_VERSION'
645 ,p_hook_type => 'AP'
646 );
647 end;
648
649 --
650 --
651 -- When in validation only mode raise the Validate_Enabled exception
652 --
653 if p_validate then
654 raise hr_api.validate_enabled;
655 end if;
656 --
657 -- Set all output arguments
658 --
659 hr_utility.set_location(' Leaving:'||l_proc, 70);
660 exception
661 when hr_api.validate_enabled then
662 --
663 -- As the Validate_Enabled exception has been raised
664 -- we must rollback to the savepoint
665 --
666 rollback to UPDATE_ACTIVITY_VERSION;
667 --
668 -- Only set output warning arguments
669 -- (Any key or derived arguments must be set to null
670 -- when validation only mode is being used.)
671 --
672 p_object_version_number := null;
673 hr_utility.set_location(' Leaving:'||l_proc, 80);
674 when others then
675 --
676 -- A validation or unexpected error has occured
677 --
678 rollback to UPDATE_ACTIVITY_VERSION;
679 p_object_version_number := l_object_version_number;
680 hr_utility.set_location(' Leaving:'||l_proc, 90);
681 raise;
682 end update_activity_version;
683 --
684 -- ----------------------------------------------------------------------------
685 -- |-------------------------< DELETE_ACTIVITY_VERSION >-------------------|
686 -- ----------------------------------------------------------------------------
687 --
688 procedure delete_activity_version
689 (
690 p_activity_version_id in number,
691 p_object_version_number in number,
692 p_validate in boolean
693 ) is
694 --
695 -- Declare cursors and local variables
696 --
697
698 CURSOR cur_act_cat is
699 select
700 aci.category_usage_id,
701 aci.primary_flag,
702 aci.activity_category,
703 aci.object_version_number
704 From
705 ota_act_cat_inclusions aci
706 where
707 aci.activity_version_id = p_activity_version_id;
708 CURSOR c_prereq_courses is
709 select
710 cpr.activity_version_id,
711 cpr.prerequisite_course_id,
712 cpr.object_version_number
713 From
714 ota_course_prerequisites cpr
715 where
716 cpr.activity_version_id = p_activity_version_id
717 or cpr.prerequisite_course_id = p_activity_version_id;
718 --
719
720 --
721 l_proc varchar2(72) := g_package||' Delete Activity Version';
722 l_tmp_ovn ota_act_cat_inclusions.object_version_number%type;
723 --
724 --
725 begin
726 hr_utility.set_location('Entering:'|| l_proc, 10);
727 --
728 -- Issue a savepoint
732 -- Truncate the time portion from all IN date parameters
729 --
730 savepoint DELETE_ACTIVITY_VERSION;
731 --
733 --
734 begin
735 ota_activity_version_bk3.delete_activity_version_b
736 (p_activity_version_id => p_activity_version_id
737 ,p_object_version_number => p_object_version_number
738 );
739 exception
740 when hr_api.cannot_find_prog_unit then
741 hr_api.cannot_find_prog_unit_error
742 (p_module_name => 'DELETE_ACTIVITY_VERSION'
743 ,p_hook_type => 'BP'
744 );
745 end ;
746 --
747 -- Process Logic
748 --
749 ota_tav_shd.lck
750 (p_activity_version_id => p_activity_version_id
751 ,p_object_version_number => p_object_version_number
752 );
753
754 --OPEN cur_act_cat;
755 FOR act_cat in cur_act_cat
756 LOOP
757 l_tmp_ovn := act_cat.object_version_number;
758
759 IF act_cat.primary_flag = 'Y' THEN
760 ota_activity_category_api.update_act_cat_inclusion
761 (p_validate => false
762 ,p_effective_date => sysdate
763 ,p_category_usage_id => act_cat.category_usage_id
764 ,p_activity_version_id => p_activity_version_id
765 ,p_primary_flag => 'N'
766 ,p_activity_category => act_cat.activity_category
767 ,p_object_version_number => l_tmp_ovn
768 );
769 END IF;
770 ota_activity_category_api.delete_act_cat_inclusion
771 (p_category_usage_id => act_cat.category_usage_id
772 ,p_activity_version_id => p_activity_version_id
773 ,p_object_version_number => l_tmp_ovn
774 );
775
776 END LOOP;
777
778 --Delete the prereq courses
779 FOR prereq_courses in c_prereq_courses
780 LOOP
781 ota_course_prerequisite_api.delete_course_prerequisite
782 (p_activity_version_id => prereq_courses.activity_version_id
783 ,p_prerequisite_course_id => prereq_courses.prerequisite_course_id
784 ,p_object_version_number => prereq_courses.object_version_number);
785 END LOOP;
786
787 ota_avt_del.del_tl
788 (p_activity_version_id => p_activity_version_id
789 );
790 ota_tav_del.del
791 (
792 p_activity_version_id => p_activity_version_id ,
793 p_object_version_number => p_object_version_number ,
794 p_validate => p_validate
795 );
796
797 --
798 -- When in validation only mode raise the Validate_Enabled exception
799 --
800
801 begin
802 ota_activity_version_bk3.delete_activity_version_a
803 (p_activity_version_id => p_activity_version_id ,
804 p_object_version_number => p_object_version_number
805 );
806 exception
807 when hr_api.cannot_find_prog_unit then
808 hr_api.cannot_find_prog_unit_error
809 (p_module_name => 'DELETE_ACTIVITY_VERSION'
810 ,p_hook_type => 'AP'
811 );
812 end;
813 --
814 --
815 if p_validate then
816 raise hr_api.validate_enabled;
817 end if;
818 --
819 -- Set all output arguments
820 --
821 --
822 hr_utility.set_location(' Leaving:'||l_proc, 170);
823 exception
824 when hr_api.validate_enabled then
825 --
826 -- As the Validate_Enabled exception has been raised
827 -- we must rollback to the savepoint
828 --
829 rollback to DELETE_ACTIVITY_VERSION;
830 --
831 -- Only set output warning arguments
832 -- (Any key or derived arguments must be set to null
833 -- when validation only mode is being used.)
834 --
835 hr_utility.set_location(' Leaving:'||l_proc, 180);
836 when others then
837 --
838 -- A validation or unexpected error has occured
839 --
840 rollback to DELETE_ACTIVITY_VERSION;
841 hr_utility.set_location(' Leaving:'||l_proc, 190);
842 raise;
843 end delete_activity_version;
844 --
845 end ota_activity_version_api;
846