[Home] [Help]
PACKAGE BODY: APPS.BEN_CWB_WKSHT_GRP_API
Source
1 Package Body ben_cwb_wksht_grp_api as
2 /* $Header: becwgapi.pkb 120.0 2005/05/28 01:29:32 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_cwb_wksht_grp_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_cwb_wksht_grp >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_cwb_wksht_grp
13 (
14 p_validate in boolean default false
15 ,p_business_group_id in number
16 ,p_pl_id in number
17 ,p_ordr_num in number
18 ,p_wksht_grp_cd in varchar2
19 ,p_label in varchar2
20 ,p_cwg_attribute_category in varchar2 default null
21 ,p_cwg_attribute1 in varchar2 default null
22 ,p_cwg_attribute2 in varchar2 default null
23 ,p_cwg_attribute3 in varchar2 default null
24 ,p_cwg_attribute4 in varchar2 default null
25 ,p_cwg_attribute5 in varchar2 default null
26 ,p_cwg_attribute6 in varchar2 default null
27 ,p_cwg_attribute7 in varchar2 default null
28 ,p_cwg_attribute8 in varchar2 default null
29 ,p_cwg_attribute9 in varchar2 default null
30 ,p_cwg_attribute10 in varchar2 default null
31 ,p_cwg_attribute11 in varchar2 default null
32 ,p_cwg_attribute12 in varchar2 default null
33 ,p_cwg_attribute13 in varchar2 default null
34 ,p_cwg_attribute14 in varchar2 default null
35 ,p_cwg_attribute15 in varchar2 default null
36 ,p_cwg_attribute16 in varchar2 default null
37 ,p_cwg_attribute17 in varchar2 default null
38 ,p_cwg_attribute18 in varchar2 default null
39 ,p_cwg_attribute19 in varchar2 default null
40 ,p_cwg_attribute20 in varchar2 default null
41 ,p_cwg_attribute21 in varchar2 default null
42 ,p_cwg_attribute22 in varchar2 default null
43 ,p_cwg_attribute23 in varchar2 default null
44 ,p_cwg_attribute24 in varchar2 default null
45 ,p_cwg_attribute25 in varchar2 default null
46 ,p_cwg_attribute26 in varchar2 default null
47 ,p_cwg_attribute27 in varchar2 default null
48 ,p_cwg_attribute28 in varchar2 default null
49 ,p_cwg_attribute29 in varchar2 default null
50 ,p_cwg_attribute30 in varchar2 default null
51 ,p_status_cd in varchar2 default null
52 ,p_hidden_cd in varchar2 default null
53 ,p_effective_date in date
54 ,p_cwb_wksht_grp_id out nocopy number
55 ,p_object_version_number out nocopy number
56 ) is
57 --
58 -- Declare cursors and local variables
59 --
60 l_cwb_wksht_grp_id number;
61 l_proc varchar2(72) := g_package||'create_cwb_wksht_grp';
62 l_object_version_number number;
63 --
64
65 begin
66 --
67 hr_utility.set_location('Entering:'|| l_proc, 10);
68 --
69 -- Issue a savepoint if operating in validation only mode
70 --
71 savepoint create_cwb_wksht_grp;
72 --
73 hr_utility.set_location(l_proc, 20);
74 --
75 -- Process Logic
76 --
77 begin
78 --
79 -- Start of API User Hook for the before hook of create_cwb_wksht_grp
80 --
81 ben_cwb_wksht_grp_bk1.create_cwb_wksht_grp_b
82 (
83 p_cwb_wksht_grp_id => p_cwb_wksht_grp_id
84 ,p_business_group_id => p_business_group_id
85 ,p_pl_id => p_pl_id
86 ,p_ordr_num => p_ordr_num
87 ,p_wksht_grp_cd => p_wksht_grp_cd
88 ,p_label => p_label
89 ,p_cwg_attribute_category => p_cwg_attribute_category
90 ,p_cwg_attribute1 => p_cwg_attribute1
91 ,p_cwg_attribute2 => p_cwg_attribute2
92 ,p_cwg_attribute3 => p_cwg_attribute3
93 ,p_cwg_attribute4 => p_cwg_attribute4
94 ,p_cwg_attribute5 => p_cwg_attribute5
95 ,p_cwg_attribute6 => p_cwg_attribute6
96 ,p_cwg_attribute7 => p_cwg_attribute7
97 ,p_cwg_attribute8 => p_cwg_attribute8
98 ,p_cwg_attribute9 => p_cwg_attribute9
99 ,p_cwg_attribute10 => p_cwg_attribute10
100 ,p_cwg_attribute11 => p_cwg_attribute11
101 ,p_cwg_attribute12 => p_cwg_attribute12
102 ,p_cwg_attribute13 => p_cwg_attribute13
103 ,p_cwg_attribute14 => p_cwg_attribute14
104 ,p_cwg_attribute15 => p_cwg_attribute15
105 ,p_cwg_attribute16 => p_cwg_attribute16
106 ,p_cwg_attribute17 => p_cwg_attribute17
107 ,p_cwg_attribute18 => p_cwg_attribute18
108 ,p_cwg_attribute19 => p_cwg_attribute19
109 ,p_cwg_attribute20 => p_cwg_attribute20
110 ,p_cwg_attribute21 => p_cwg_attribute21
111 ,p_cwg_attribute22 => p_cwg_attribute22
112 ,p_cwg_attribute23 => p_cwg_attribute23
113 ,p_cwg_attribute24 => p_cwg_attribute24
114 ,p_cwg_attribute25 => p_cwg_attribute25
115 ,p_cwg_attribute26 => p_cwg_attribute26
116 ,p_cwg_attribute27 => p_cwg_attribute27
117 ,p_cwg_attribute28 => p_cwg_attribute28
118 ,p_cwg_attribute29 => p_cwg_attribute29
119 ,p_cwg_attribute30 => p_cwg_attribute30
120 ,p_status_cd => p_status_cd
121 ,p_hidden_cd => p_hidden_cd
122 ,p_object_version_number => p_object_version_number
123 ,p_effective_date => p_effective_date
124 );
125 exception
126 when hr_api.cannot_find_prog_unit then
127 hr_api.cannot_find_prog_unit_error
128 (
129 p_module_name => 'CREATE_cwb_wksht_grp'
130 ,p_hook_type => 'BP'
131 );
132 --
133 -- End of API User Hook for the before hook of create_cwb_wksht_grp
134 --
135 end;
136 --
137 hr_utility.set_location('hiden flag ' || p_hidden_cd , 99 );
138 ---
139 ben_cwg_ins.ins
140 (
141 p_effective_date => p_effective_date
142 ,p_business_group_id => p_business_group_id
143 ,p_pl_id => p_pl_id
144 ,p_ordr_num => p_ordr_num
145 ,p_wksht_grp_cd => p_wksht_grp_cd
146 ,p_label => p_label
147 ,p_cwg_attribute_category => p_cwg_attribute_category
148 ,p_cwg_attribute1 => p_cwg_attribute1
149 ,p_cwg_attribute2 => p_cwg_attribute2
150 ,p_cwg_attribute3 => p_cwg_attribute3
151 ,p_cwg_attribute4 => p_cwg_attribute4
152 ,p_cwg_attribute5 => p_cwg_attribute5
153 ,p_cwg_attribute6 => p_cwg_attribute6
154 ,p_cwg_attribute7 => p_cwg_attribute7
155 ,p_cwg_attribute8 => p_cwg_attribute8
156 ,p_cwg_attribute9 => p_cwg_attribute9
157 ,p_cwg_attribute10 => p_cwg_attribute10
158 ,p_cwg_attribute11 => p_cwg_attribute11
159 ,p_cwg_attribute12 => p_cwg_attribute12
160 ,p_cwg_attribute13 => p_cwg_attribute13
161 ,p_cwg_attribute14 => p_cwg_attribute14
162 ,p_cwg_attribute15 => p_cwg_attribute15
163 ,p_cwg_attribute16 => p_cwg_attribute16
164 ,p_cwg_attribute17 => p_cwg_attribute17
165 ,p_cwg_attribute18 => p_cwg_attribute18
166 ,p_cwg_attribute19 => p_cwg_attribute19
167 ,p_cwg_attribute20 => p_cwg_attribute20
168 ,p_cwg_attribute21 => p_cwg_attribute21
169 ,p_cwg_attribute22 => p_cwg_attribute22
170 ,p_cwg_attribute23 => p_cwg_attribute23
171 ,p_cwg_attribute24 => p_cwg_attribute24
172 ,p_cwg_attribute25 => p_cwg_attribute25
173 ,p_cwg_attribute26 => p_cwg_attribute26
174 ,p_cwg_attribute27 => p_cwg_attribute27
175 ,p_cwg_attribute28 => p_cwg_attribute28
176 ,p_cwg_attribute29 => p_cwg_attribute29
177 ,p_cwg_attribute30 => p_cwg_attribute30
178 ,p_status_cd => p_status_cd
179 ,p_hidden_cd => p_hidden_cd
180 ,p_cwb_wksht_grp_id => l_cwb_wksht_grp_id
181 ,p_object_version_number => l_object_version_number
182 );
183 --
184 begin
185 --
186 -- Start of API User Hook for the after hook of create_cwb_wksht_grp
187 --
188 ben_cwb_wksht_grp_bk1.create_cwb_wksht_grp_a
189 (
190 p_cwb_wksht_grp_id => p_cwb_wksht_grp_id
191 ,p_business_group_id => p_business_group_id
192 ,p_pl_id => p_pl_id
193 ,p_ordr_num => p_ordr_num
194 ,p_wksht_grp_cd => p_wksht_grp_cd
195 ,p_label => p_label
196 ,p_cwg_attribute_category => p_cwg_attribute_category
197 ,p_cwg_attribute1 => p_cwg_attribute1
198 ,p_cwg_attribute2 => p_cwg_attribute2
199 ,p_cwg_attribute3 => p_cwg_attribute3
200 ,p_cwg_attribute4 => p_cwg_attribute4
201 ,p_cwg_attribute5 => p_cwg_attribute5
202 ,p_cwg_attribute6 => p_cwg_attribute6
203 ,p_cwg_attribute7 => p_cwg_attribute7
204 ,p_cwg_attribute8 => p_cwg_attribute8
205 ,p_cwg_attribute9 => p_cwg_attribute9
206 ,p_cwg_attribute10 => p_cwg_attribute10
207 ,p_cwg_attribute11 => p_cwg_attribute11
208 ,p_cwg_attribute12 => p_cwg_attribute12
209 ,p_cwg_attribute13 => p_cwg_attribute13
210 ,p_cwg_attribute14 => p_cwg_attribute14
211 ,p_cwg_attribute15 => p_cwg_attribute15
212 ,p_cwg_attribute16 => p_cwg_attribute16
213 ,p_cwg_attribute17 => p_cwg_attribute17
214 ,p_cwg_attribute18 => p_cwg_attribute18
215 ,p_cwg_attribute19 => p_cwg_attribute19
216 ,p_cwg_attribute20 => p_cwg_attribute20
217 ,p_cwg_attribute21 => p_cwg_attribute21
218 ,p_cwg_attribute22 => p_cwg_attribute22
219 ,p_cwg_attribute23 => p_cwg_attribute23
220 ,p_cwg_attribute24 => p_cwg_attribute24
221 ,p_cwg_attribute25 => p_cwg_attribute25
222 ,p_cwg_attribute26 => p_cwg_attribute26
223 ,p_cwg_attribute27 => p_cwg_attribute27
224 ,p_cwg_attribute28 => p_cwg_attribute28
225 ,p_cwg_attribute29 => p_cwg_attribute29
226 ,p_cwg_attribute30 => p_cwg_attribute30
227 ,p_status_cd => p_status_cd
228 ,p_hidden_cd => p_hidden_cd
229 ,p_object_version_number => p_object_version_number
230 ,p_effective_date => p_effective_date
231 );
232 exception
233 when hr_api.cannot_find_prog_unit then
234 hr_api.cannot_find_prog_unit_error
235 (p_module_name => 'CREATE_cwb_wksht_grp'
236 ,p_hook_type => 'AP'
237 );
238 --
239 -- End of API User Hook for the after hook of create_cwb_wksht_grp
240 --
241 end;
242 --
243 hr_utility.set_location(l_proc, 60);
244 --
245 -- When in validation only mode raise the Validate_Enabled exception
246 --
247 if p_validate then
248 raise hr_api.validate_enabled;
249 end if;
250 --
251 -- Set all output arguments
252 --
253 p_cwb_wksht_grp_id := l_cwb_wksht_grp_id;
254 p_object_version_number := l_object_version_number;
255 --
256 hr_utility.set_location(' Leaving:'||l_proc, 70);
257 --
258 exception
259 --
260 when hr_api.validate_enabled then
261 --
262 -- As the Validate_Enabled exception has been raised
263 -- we must rollback to the savepoint
264 --
265 ROLLBACK TO create_cwb_wksht_grp;
266 --
267 -- Only set output warning arguments
268 -- (Any key or derived arguments must be set to null
269 -- when validation only mode is being used.)
270 --
271 p_cwb_wksht_grp_id := null;
272 p_object_version_number := null;
273 hr_utility.set_location(' Leaving:'||l_proc, 80);
274 --
275 when others then
276 --
277 -- A validation or unexpected error has occured
278 --
279 ROLLBACK TO create_cwb_wksht_grp;
280 raise;
281 --
282 end create_cwb_wksht_grp;
283 -- ----------------------------------------------------------------------------
284 -- |------------------------< update_cwb_wksht_grp >--- ------------------|
285 -- ----------------------------------------------------------------------------
286 --
287 procedure update_cwb_wksht_grp
288 (
289 p_validate in boolean default false
290 ,p_business_group_id in number
291 ,p_cwb_wksht_grp_id in number
292 ,p_pl_id in number default hr_api.g_number
293 ,p_ordr_num in number default hr_api.g_number
294 ,p_wksht_grp_cd in varchar2 default hr_api.g_varchar2
295 ,p_label in varchar2 default hr_api.g_varchar2
296 ,p_cwg_attribute_category in varchar2 default hr_api.g_varchar2
297 ,p_cwg_attribute1 in varchar2 default hr_api.g_varchar2
298 ,p_cwg_attribute2 in varchar2 default hr_api.g_varchar2
299 ,p_cwg_attribute3 in varchar2 default hr_api.g_varchar2
300 ,p_cwg_attribute4 in varchar2 default hr_api.g_varchar2
301 ,p_cwg_attribute5 in varchar2 default hr_api.g_varchar2
302 ,p_cwg_attribute6 in varchar2 default hr_api.g_varchar2
303 ,p_cwg_attribute7 in varchar2 default hr_api.g_varchar2
304 ,p_cwg_attribute8 in varchar2 default hr_api.g_varchar2
305 ,p_cwg_attribute9 in varchar2 default hr_api.g_varchar2
306 ,p_cwg_attribute10 in varchar2 default hr_api.g_varchar2
307 ,p_cwg_attribute11 in varchar2 default hr_api.g_varchar2
308 ,p_cwg_attribute12 in varchar2 default hr_api.g_varchar2
309 ,p_cwg_attribute13 in varchar2 default hr_api.g_varchar2
310 ,p_cwg_attribute14 in varchar2 default hr_api.g_varchar2
311 ,p_cwg_attribute15 in varchar2 default hr_api.g_varchar2
312 ,p_cwg_attribute16 in varchar2 default hr_api.g_varchar2
313 ,p_cwg_attribute17 in varchar2 default hr_api.g_varchar2
314 ,p_cwg_attribute18 in varchar2 default hr_api.g_varchar2
315 ,p_cwg_attribute19 in varchar2 default hr_api.g_varchar2
316 ,p_cwg_attribute20 in varchar2 default hr_api.g_varchar2
317 ,p_cwg_attribute21 in varchar2 default hr_api.g_varchar2
318 ,p_cwg_attribute22 in varchar2 default hr_api.g_varchar2
319 ,p_cwg_attribute23 in varchar2 default hr_api.g_varchar2
320 ,p_cwg_attribute24 in varchar2 default hr_api.g_varchar2
321 ,p_cwg_attribute25 in varchar2 default hr_api.g_varchar2
322 ,p_cwg_attribute26 in varchar2 default hr_api.g_varchar2
323 ,p_cwg_attribute27 in varchar2 default hr_api.g_varchar2
324 ,p_cwg_attribute28 in varchar2 default hr_api.g_varchar2
325 ,p_cwg_attribute29 in varchar2 default hr_api.g_varchar2
326 ,p_cwg_attribute30 in varchar2 default hr_api.g_varchar2
330 ,p_effective_date in date
327 ,p_status_cd in varchar2 default hr_api.g_varchar2
328 ,p_hidden_cd in varchar2 default hr_api.g_varchar2
329 ,p_object_version_number in out nocopy number
331 ) is
332 --
333 -- Declare cursors and local variables
334 --
335 l_cwb_wksht_grp_id number;
336 l_proc varchar2(72) := g_package||'update_cwb_wksht_grp';
337 l_object_version_number ben_cwb_wksht_grp.object_version_number%TYPE;
338 --
339 begin
340 --
341 hr_utility.set_location('Entering:'|| l_proc, 10);
342 --
343 -- Issue a savepoint if operating in validation only mode
344 --
345 savepoint update_cwb_wksht_grp;
346 --
347 hr_utility.set_location(l_proc, 20);
348 --
349 -- Process Logic
350 --
351 l_cwb_wksht_grp_id := p_cwb_wksht_grp_id;
352 l_object_version_number := p_object_version_number;
353 --
354 begin
355 --
356 -- Start of API User Hook for the before hook of update_cwb_wksht_grp
357 --
358 ben_cwb_wksht_grp_bk2.update_cwb_wksht_grp_b
359 (
360 p_cwb_wksht_grp_id => p_cwb_wksht_grp_id
361 ,p_business_group_id => p_business_group_id
362 ,p_pl_id => p_pl_id
363 ,p_ordr_num => p_ordr_num
364 ,p_wksht_grp_cd => p_wksht_grp_cd
365 ,p_label => p_label
366 ,p_cwg_attribute_category => p_cwg_attribute_category
367 ,p_cwg_attribute1 => p_cwg_attribute1
368 ,p_cwg_attribute2 => p_cwg_attribute2
369 ,p_cwg_attribute3 => p_cwg_attribute3
370 ,p_cwg_attribute4 => p_cwg_attribute4
371 ,p_cwg_attribute5 => p_cwg_attribute5
372 ,p_cwg_attribute6 => p_cwg_attribute6
373 ,p_cwg_attribute7 => p_cwg_attribute7
374 ,p_cwg_attribute8 => p_cwg_attribute8
375 ,p_cwg_attribute9 => p_cwg_attribute9
376 ,p_cwg_attribute10 => p_cwg_attribute10
377 ,p_cwg_attribute11 => p_cwg_attribute11
378 ,p_cwg_attribute12 => p_cwg_attribute12
379 ,p_cwg_attribute13 => p_cwg_attribute13
380 ,p_cwg_attribute14 => p_cwg_attribute14
381 ,p_cwg_attribute15 => p_cwg_attribute15
382 ,p_cwg_attribute16 => p_cwg_attribute16
383 ,p_cwg_attribute17 => p_cwg_attribute17
384 ,p_cwg_attribute18 => p_cwg_attribute18
385 ,p_cwg_attribute19 => p_cwg_attribute19
386 ,p_cwg_attribute20 => p_cwg_attribute20
387 ,p_cwg_attribute21 => p_cwg_attribute21
388 ,p_cwg_attribute22 => p_cwg_attribute22
389 ,p_cwg_attribute23 => p_cwg_attribute23
390 ,p_cwg_attribute24 => p_cwg_attribute24
391 ,p_cwg_attribute25 => p_cwg_attribute25
392 ,p_cwg_attribute26 => p_cwg_attribute26
393 ,p_cwg_attribute27 => p_cwg_attribute27
394 ,p_cwg_attribute28 => p_cwg_attribute28
395 ,p_cwg_attribute29 => p_cwg_attribute29
396 ,p_cwg_attribute30 => p_cwg_attribute30
397 ,p_status_cd => p_status_cd
398 ,p_hidden_cd => p_hidden_cd
399 ,p_object_version_number => p_object_version_number
400 ,p_effective_date => p_effective_date
401 );
402 exception
403 when hr_api.cannot_find_prog_unit then
404 hr_api.cannot_find_prog_unit_error
405 (p_module_name => 'UPDATE_cwb_wksht_grp'
406 ,p_hook_type => 'BP'
407 );
408 --
409 -- End of API User Hook for the before hook of update_cwb_wksht_grp
410 --
411 end;
412 ---
413 ben_cwg_upd.upd
414 (
415 p_effective_date => p_effective_date
416 ,p_ordr_num => p_ordr_num
417 ,p_wksht_grp_cd => p_wksht_grp_cd
418 ,p_label => p_label
419 ,p_cwb_wksht_grp_id => l_cwb_wksht_grp_id
420 ,p_cwg_attribute_category => p_cwg_attribute_category
421 ,p_cwg_attribute1 => p_cwg_attribute1
422 ,p_cwg_attribute2 => p_cwg_attribute2
423 ,p_cwg_attribute3 => p_cwg_attribute3
424 ,p_cwg_attribute4 => p_cwg_attribute4
425 ,p_cwg_attribute5 => p_cwg_attribute5
426 ,p_cwg_attribute6 => p_cwg_attribute6
427 ,p_cwg_attribute7 => p_cwg_attribute7
428 ,p_cwg_attribute8 => p_cwg_attribute8
429 ,p_cwg_attribute9 => p_cwg_attribute9
430 ,p_cwg_attribute10 => p_cwg_attribute10
431 ,p_cwg_attribute11 => p_cwg_attribute11
432 ,p_cwg_attribute12 => p_cwg_attribute12
433 ,p_cwg_attribute13 => p_cwg_attribute13
434 ,p_cwg_attribute14 => p_cwg_attribute14
435 ,p_cwg_attribute15 => p_cwg_attribute15
436 ,p_cwg_attribute16 => p_cwg_attribute16
437 ,p_cwg_attribute17 => p_cwg_attribute17
438 ,p_cwg_attribute18 => p_cwg_attribute18
439 ,p_cwg_attribute19 => p_cwg_attribute19
440 ,p_cwg_attribute20 => p_cwg_attribute20
441 ,p_cwg_attribute21 => p_cwg_attribute21
442 ,p_cwg_attribute22 => p_cwg_attribute22
446 ,p_cwg_attribute26 => p_cwg_attribute26
443 ,p_cwg_attribute23 => p_cwg_attribute23
444 ,p_cwg_attribute24 => p_cwg_attribute24
445 ,p_cwg_attribute25 => p_cwg_attribute25
447 ,p_cwg_attribute27 => p_cwg_attribute27
448 ,p_cwg_attribute28 => p_cwg_attribute28
449 ,p_cwg_attribute29 => p_cwg_attribute29
450 ,p_cwg_attribute30 => p_cwg_attribute30
451 ,p_status_cd => p_status_cd
452 ,p_hidden_cd => p_hidden_cd
453 ,p_object_version_number => l_object_version_number
454 );
455 --
456 begin
457 --
458 -- Start of API User Hook for the after hook of update_cwb_wksht_grp
459 --
460 ben_cwb_wksht_grp_bk2.update_cwb_wksht_grp_a
461 (
462 p_cwb_wksht_grp_id => p_cwb_wksht_grp_id
463 ,p_business_group_id => p_business_group_id
464 ,p_pl_id => p_pl_id
465 ,p_ordr_num => p_ordr_num
466 ,p_wksht_grp_cd => p_wksht_grp_cd
467 ,p_label => p_label
468 ,p_cwg_attribute_category => p_cwg_attribute_category
469 ,p_cwg_attribute1 => p_cwg_attribute1
470 ,p_cwg_attribute2 => p_cwg_attribute2
471 ,p_cwg_attribute3 => p_cwg_attribute3
472 ,p_cwg_attribute4 => p_cwg_attribute4
473 ,p_cwg_attribute5 => p_cwg_attribute5
474 ,p_cwg_attribute6 => p_cwg_attribute6
475 ,p_cwg_attribute7 => p_cwg_attribute7
476 ,p_cwg_attribute8 => p_cwg_attribute8
477 ,p_cwg_attribute9 => p_cwg_attribute9
478 ,p_cwg_attribute10 => p_cwg_attribute10
479 ,p_cwg_attribute11 => p_cwg_attribute11
480 ,p_cwg_attribute12 => p_cwg_attribute12
481 ,p_cwg_attribute13 => p_cwg_attribute13
482 ,p_cwg_attribute14 => p_cwg_attribute14
483 ,p_cwg_attribute15 => p_cwg_attribute15
484 ,p_cwg_attribute16 => p_cwg_attribute16
485 ,p_cwg_attribute17 => p_cwg_attribute17
486 ,p_cwg_attribute18 => p_cwg_attribute18
487 ,p_cwg_attribute19 => p_cwg_attribute19
488 ,p_cwg_attribute20 => p_cwg_attribute20
489 ,p_cwg_attribute21 => p_cwg_attribute21
490 ,p_cwg_attribute22 => p_cwg_attribute22
491 ,p_cwg_attribute23 => p_cwg_attribute23
492 ,p_cwg_attribute24 => p_cwg_attribute24
493 ,p_cwg_attribute25 => p_cwg_attribute25
494 ,p_cwg_attribute26 => p_cwg_attribute26
495 ,p_cwg_attribute27 => p_cwg_attribute27
496 ,p_cwg_attribute28 => p_cwg_attribute28
497 ,p_cwg_attribute29 => p_cwg_attribute29
498 ,p_cwg_attribute30 => p_cwg_attribute30
499 ,p_status_cd => p_status_cd
500 ,p_hidden_cd => p_hidden_cd
501 ,p_object_version_number => p_object_version_number
502 ,p_effective_date => p_effective_date
503 );
504 exception
505 when hr_api.cannot_find_prog_unit then
506 hr_api.cannot_find_prog_unit_error
507 (p_module_name => 'UPDATE_cwb_wksht_grp'
508 ,p_hook_type => 'AP'
509 );
510 --
511 -- End of API User Hook for the after hook of update_cwb_wksht_grp
512 --
513 end;
514 --
515 hr_utility.set_location(l_proc, 60);
516 --
517 -- When in validation only mode raise the Validate_Enabled exception
518 --
519 if p_validate then
520 raise hr_api.validate_enabled;
521 end if;
522 --
523 -- Set all output arguments
524 --
525 p_object_version_number := l_object_version_number;
526 --
527 hr_utility.set_location(' Leaving:'||l_proc, 70);
528 --
529 exception
530 --
531 when hr_api.validate_enabled then
532 --
533 -- As the Validate_Enabled exception has been raised
534 -- we must rollback to the savepoint
535 --
536 ROLLBACK TO update_cwb_wksht_grp;
537 --
538 -- Only set output warning arguments
539 -- (Any key or derived arguments must be set to null
540 -- when validation only mode is being used.)
541 --
542 hr_utility.set_location(' Leaving:'||l_proc, 80);
543 --
544 when others then
545 --
546 -- A validation or unexpected error has occured
547 --
548 ROLLBACK TO update_cwb_wksht_grp;
549 p_object_version_number := l_object_version_number;
550 raise;
551 --
552 end update_cwb_wksht_grp;
553 -- ----------------------------------------------------------------------------
554 -- |------------------------< delete_cwb_wksht_grp >----------------------|
555 -- ----------------------------------------------------------------------------
556 --
557 procedure delete_cwb_wksht_grp
558 (p_validate in boolean default false
559 ,p_cwb_wksht_grp_id in number
560 ,p_object_version_number in out nocopy number
561 ,p_effective_date in date
562 ) is
563 --
564 -- Declare cursors and local variables
565 --
566 l_proc varchar2(72) := g_package||'delete_cwb_wksht_grp';
567 l_object_version_number ben_cwb_wksht_grp.object_version_number%TYPE;
571 hr_utility.set_location('Entering:'|| l_proc, 10);
568 --
569 begin
570 --
572 --
573 -- Issue a savepoint if operating in validation only mode
574 --
575 savepoint delete_cwb_wksht_grp;
576 --
577 hr_utility.set_location(l_proc, 20);
578 --
579 -- Process Logic
580 --
581 l_object_version_number := p_object_version_number;
582 --
583 --
584 begin
585 --
586 -- Start of API User Hook for the before hook of delete_cwb_wksht_grp
587 --
588 ben_cwb_wksht_grp_bk3.delete_cwb_wksht_grp_b
589 (
590 p_cwb_wksht_grp_id => p_cwb_wksht_grp_id
591 ,p_object_version_number => p_object_version_number
592 );
593 exception
594 when hr_api.cannot_find_prog_unit then
595 hr_api.cannot_find_prog_unit_error
596 (p_module_name => 'DELETE_cwb_wksht_grp'
597 ,p_hook_type => 'BP'
598 );
599 --
600 -- End of API User Hook for the before hook of delete_cwb_wksht_grp
601 --
602 end;
603 --
604 ben_cwg_del.del
605 (
606 p_cwb_wksht_grp_id => p_cwb_wksht_grp_id
607 ,p_object_version_number => l_object_version_number
608 );
609 --
610 begin
611 --
612 -- Start of API User Hook for the after hook of delete_cwb_wksht_grp
613 --
614 ben_cwb_wksht_grp_bk3.delete_cwb_wksht_grp_a
615 (
616 p_cwb_wksht_grp_id => p_cwb_wksht_grp_id
617 ,p_object_version_number => l_object_version_number
618 );
619 exception
620 when hr_api.cannot_find_prog_unit then
621 hr_api.cannot_find_prog_unit_error
622 (p_module_name => 'DELETE_cwb_wksht_grp'
623 ,p_hook_type => 'AP'
624 );
625 --
626 -- End of API User Hook for the after hook of delete_cwb_wksht_grp
627 --
628 end;
629 --
630 hr_utility.set_location(l_proc, 60);
631 --
632 -- When in validation only mode raise the Validate_Enabled exception
633 --
634 if p_validate then
635 raise hr_api.validate_enabled;
636 end if;
637 --
638 hr_utility.set_location(' Leaving:'||l_proc, 70);
639 --
640 exception
641 --
642 when hr_api.validate_enabled then
643 --
644 -- As the Validate_Enabled exception has been raised
645 -- we must rollback to the savepoint
646 --
647 ROLLBACK TO delete_cwb_wksht_grp;
648 --
649 -- Only set output warning arguments
650 -- (Any key or derived arguments must be set to null
651 -- when validation only mode is being used.)
652 --
653 --
654 when others then
655 --
656 -- A validation or unexpected error has occured
657 --
658 ROLLBACK TO delete_cwb_wksht_grp;
659 p_object_version_number := l_object_version_number;
660 raise;
661 --
662 end delete_cwb_wksht_grp;
663 --
664 -- ----------------------------------------------------------------------------
665 -- |-------------------------------< lck >------------------------------------|
666 -- ----------------------------------------------------------------------------
667 --
668 procedure lck
669 (
670 p_cwb_wksht_grp_id in number
671 ,p_object_version_number in number
672 ) is
673 --
674 --
675 -- Declare cursors and local variables
676 --
677 l_proc varchar2(72) := g_package||'lck';
678 --
679 begin
680 --
681 hr_utility.set_location('Entering:'|| l_proc, 10);
682 --
683 ben_cwg_shd.lck
684 (
685 p_cwb_wksht_grp_id => p_cwb_wksht_grp_id
686 ,p_object_version_number => p_object_version_number
687 );
688 --
689 hr_utility.set_location(' Leaving:'||l_proc, 70);
690 --
691 end lck;
692 --
693 end ben_cwb_wksht_grp_api;