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