[Home] [Help]
PACKAGE BODY: APPS.BEN_PYMT_SCHED_PY_FREQ_API
Source
1 Package Body ben_pymt_sched_py_freq_api as
2 /* $Header: bepsqapi.pkb 120.0 2005/05/28 11:19:44 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_pymt_sched_py_freq_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_pymt_sched_py_freq >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_pymt_sched_py_freq
13 (p_validate in boolean default false
14 ,p_pymt_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_business_group_id in number default null
18 ,p_acty_rt_pymt_sched_id in number default null
19 ,p_psq_attribute_category in varchar2 default null
20 ,p_psq_attribute1 in varchar2 default null
21 ,p_psq_attribute2 in varchar2 default null
22 ,p_psq_attribute3 in varchar2 default null
23 ,p_psq_attribute4 in varchar2 default null
24 ,p_psq_attribute5 in varchar2 default null
25 ,p_psq_attribute6 in varchar2 default null
26 ,p_psq_attribute7 in varchar2 default null
27 ,p_psq_attribute8 in varchar2 default null
28 ,p_psq_attribute9 in varchar2 default null
29 ,p_psq_attribute10 in varchar2 default null
30 ,p_psq_attribute11 in varchar2 default null
31 ,p_psq_attribute12 in varchar2 default null
32 ,p_psq_attribute13 in varchar2 default null
33 ,p_psq_attribute14 in varchar2 default null
34 ,p_psq_attribute15 in varchar2 default null
35 ,p_psq_attribute16 in varchar2 default null
36 ,p_psq_attribute17 in varchar2 default null
37 ,p_psq_attribute18 in varchar2 default null
38 ,p_psq_attribute19 in varchar2 default null
39 ,p_psq_attribute20 in varchar2 default null
40 ,p_psq_attribute21 in varchar2 default null
41 ,p_psq_attribute22 in varchar2 default null
42 ,p_psq_attribute23 in varchar2 default null
43 ,p_psq_attribute24 in varchar2 default null
44 ,p_psq_attribute25 in varchar2 default null
45 ,p_psq_attribute26 in varchar2 default null
46 ,p_psq_attribute27 in varchar2 default null
47 ,p_psq_attribute28 in varchar2 default null
48 ,p_psq_attribute29 in varchar2 default null
49 ,p_psq_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_pymt_sched_py_freq_id ben_pymt_sched_py_freq.pymt_sched_py_freq_id%TYPE;
57 l_proc varchar2(72) := g_package||'create_pymt_sched_py_freq';
58 l_object_version_number ben_pymt_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_pymt_sched_py_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_pymt_sched_py_freq
75 --
76 ben_pymt_sched_py_freq_bk1.create_pymt_sched_py_freq_b
77 (
78 p_py_freq_cd => p_py_freq_cd
79 ,p_dflt_flag => p_dflt_flag
80 ,p_business_group_id => p_business_group_id
81 ,p_acty_rt_pymt_sched_id => p_acty_rt_pymt_sched_id
82 ,p_psq_attribute_category => p_psq_attribute_category
83 ,p_psq_attribute1 => p_psq_attribute1
84 ,p_psq_attribute2 => p_psq_attribute2
85 ,p_psq_attribute3 => p_psq_attribute3
86 ,p_psq_attribute4 => p_psq_attribute4
87 ,p_psq_attribute5 => p_psq_attribute5
88 ,p_psq_attribute6 => p_psq_attribute6
89 ,p_psq_attribute7 => p_psq_attribute7
90 ,p_psq_attribute8 => p_psq_attribute8
91 ,p_psq_attribute9 => p_psq_attribute9
92 ,p_psq_attribute10 => p_psq_attribute10
93 ,p_psq_attribute11 => p_psq_attribute11
94 ,p_psq_attribute12 => p_psq_attribute12
95 ,p_psq_attribute13 => p_psq_attribute13
96 ,p_psq_attribute14 => p_psq_attribute14
97 ,p_psq_attribute15 => p_psq_attribute15
98 ,p_psq_attribute16 => p_psq_attribute16
99 ,p_psq_attribute17 => p_psq_attribute17
100 ,p_psq_attribute18 => p_psq_attribute18
101 ,p_psq_attribute19 => p_psq_attribute19
102 ,p_psq_attribute20 => p_psq_attribute20
103 ,p_psq_attribute21 => p_psq_attribute21
104 ,p_psq_attribute22 => p_psq_attribute22
105 ,p_psq_attribute23 => p_psq_attribute23
106 ,p_psq_attribute24 => p_psq_attribute24
107 ,p_psq_attribute25 => p_psq_attribute25
108 ,p_psq_attribute26 => p_psq_attribute26
109 ,p_psq_attribute27 => p_psq_attribute27
110 ,p_psq_attribute28 => p_psq_attribute28
111 ,p_psq_attribute29 => p_psq_attribute29
112 ,p_psq_attribute30 => p_psq_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_pymt_sched_py_freq'
120 ,p_hook_type => 'BP'
121 );
122 --
123 -- End of API User Hook for the before hook of create_pymt_sched_py_freq
124 --
125 end;
126 --
127 ben_psq_ins.ins
128 (
129 p_pymt_sched_py_freq_id => l_pymt_sched_py_freq_id
130 ,p_py_freq_cd => p_py_freq_cd
131 ,p_dflt_flag => p_dflt_flag
132 ,p_business_group_id => p_business_group_id
133 ,p_acty_rt_pymt_sched_id => p_acty_rt_pymt_sched_id
134 ,p_psq_attribute_category => p_psq_attribute_category
135 ,p_psq_attribute1 => p_psq_attribute1
136 ,p_psq_attribute2 => p_psq_attribute2
137 ,p_psq_attribute3 => p_psq_attribute3
138 ,p_psq_attribute4 => p_psq_attribute4
139 ,p_psq_attribute5 => p_psq_attribute5
140 ,p_psq_attribute6 => p_psq_attribute6
141 ,p_psq_attribute7 => p_psq_attribute7
142 ,p_psq_attribute8 => p_psq_attribute8
143 ,p_psq_attribute9 => p_psq_attribute9
144 ,p_psq_attribute10 => p_psq_attribute10
145 ,p_psq_attribute11 => p_psq_attribute11
146 ,p_psq_attribute12 => p_psq_attribute12
147 ,p_psq_attribute13 => p_psq_attribute13
148 ,p_psq_attribute14 => p_psq_attribute14
149 ,p_psq_attribute15 => p_psq_attribute15
150 ,p_psq_attribute16 => p_psq_attribute16
151 ,p_psq_attribute17 => p_psq_attribute17
152 ,p_psq_attribute18 => p_psq_attribute18
153 ,p_psq_attribute19 => p_psq_attribute19
154 ,p_psq_attribute20 => p_psq_attribute20
155 ,p_psq_attribute21 => p_psq_attribute21
156 ,p_psq_attribute22 => p_psq_attribute22
157 ,p_psq_attribute23 => p_psq_attribute23
158 ,p_psq_attribute24 => p_psq_attribute24
159 ,p_psq_attribute25 => p_psq_attribute25
160 ,p_psq_attribute26 => p_psq_attribute26
161 ,p_psq_attribute27 => p_psq_attribute27
162 ,p_psq_attribute28 => p_psq_attribute28
163 ,p_psq_attribute29 => p_psq_attribute29
164 ,p_psq_attribute30 => p_psq_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_pymt_sched_py_freq
172 --
173 ben_pymt_sched_py_freq_bk1.create_pymt_sched_py_freq_a
174 (
175 p_pymt_sched_py_freq_id => l_pymt_sched_py_freq_id
176 ,p_py_freq_cd => p_py_freq_cd
177 ,p_dflt_flag => p_dflt_flag
178 ,p_business_group_id => p_business_group_id
179 ,p_acty_rt_pymt_sched_id => p_acty_rt_pymt_sched_id
180 ,p_psq_attribute_category => p_psq_attribute_category
181 ,p_psq_attribute1 => p_psq_attribute1
182 ,p_psq_attribute2 => p_psq_attribute2
183 ,p_psq_attribute3 => p_psq_attribute3
184 ,p_psq_attribute4 => p_psq_attribute4
185 ,p_psq_attribute5 => p_psq_attribute5
186 ,p_psq_attribute6 => p_psq_attribute6
187 ,p_psq_attribute7 => p_psq_attribute7
188 ,p_psq_attribute8 => p_psq_attribute8
189 ,p_psq_attribute9 => p_psq_attribute9
190 ,p_psq_attribute10 => p_psq_attribute10
191 ,p_psq_attribute11 => p_psq_attribute11
192 ,p_psq_attribute12 => p_psq_attribute12
193 ,p_psq_attribute13 => p_psq_attribute13
194 ,p_psq_attribute14 => p_psq_attribute14
195 ,p_psq_attribute15 => p_psq_attribute15
196 ,p_psq_attribute16 => p_psq_attribute16
197 ,p_psq_attribute17 => p_psq_attribute17
198 ,p_psq_attribute18 => p_psq_attribute18
199 ,p_psq_attribute19 => p_psq_attribute19
200 ,p_psq_attribute20 => p_psq_attribute20
201 ,p_psq_attribute21 => p_psq_attribute21
202 ,p_psq_attribute22 => p_psq_attribute22
203 ,p_psq_attribute23 => p_psq_attribute23
204 ,p_psq_attribute24 => p_psq_attribute24
205 ,p_psq_attribute25 => p_psq_attribute25
206 ,p_psq_attribute26 => p_psq_attribute26
207 ,p_psq_attribute27 => p_psq_attribute27
208 ,p_psq_attribute28 => p_psq_attribute28
209 ,p_psq_attribute29 => p_psq_attribute29
210 ,p_psq_attribute30 => p_psq_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_pymt_sched_py_freq'
218 ,p_hook_type => 'AP'
219 );
220 --
221 -- End of API User Hook for the after hook of create_pymt_sched_py_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_pymt_sched_py_freq_id := l_pymt_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_pymt_sched_py_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_pymt_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 -- Initialize OUT Variables for NOCOPY
261 p_pymt_sched_py_freq_id :=null;
262 p_object_version_number :=null ;
263
264 ROLLBACK TO create_pymt_sched_py_freq;
265 raise;
266 --
267 end create_pymt_sched_py_freq;
268 -- ----------------------------------------------------------------------------
269 -- |------------------------< update_pymt_sched_py_freq >--- ------------------|
270 -- ----------------------------------------------------------------------------
271 --
272 procedure update_pymt_sched_py_freq
273 (p_validate in boolean default false
274 ,p_pymt_sched_py_freq_id in number
275 ,p_py_freq_cd in varchar2 default hr_api.g_varchar2
276 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
277 ,p_business_group_id in number default hr_api.g_number
278 ,p_acty_rt_pymt_sched_id in number default hr_api.g_number
279 ,p_psq_attribute_category in varchar2 default hr_api.g_varchar2
280 ,p_psq_attribute1 in varchar2 default hr_api.g_varchar2
281 ,p_psq_attribute2 in varchar2 default hr_api.g_varchar2
282 ,p_psq_attribute3 in varchar2 default hr_api.g_varchar2
283 ,p_psq_attribute4 in varchar2 default hr_api.g_varchar2
284 ,p_psq_attribute5 in varchar2 default hr_api.g_varchar2
285 ,p_psq_attribute6 in varchar2 default hr_api.g_varchar2
286 ,p_psq_attribute7 in varchar2 default hr_api.g_varchar2
287 ,p_psq_attribute8 in varchar2 default hr_api.g_varchar2
288 ,p_psq_attribute9 in varchar2 default hr_api.g_varchar2
289 ,p_psq_attribute10 in varchar2 default hr_api.g_varchar2
290 ,p_psq_attribute11 in varchar2 default hr_api.g_varchar2
291 ,p_psq_attribute12 in varchar2 default hr_api.g_varchar2
292 ,p_psq_attribute13 in varchar2 default hr_api.g_varchar2
293 ,p_psq_attribute14 in varchar2 default hr_api.g_varchar2
294 ,p_psq_attribute15 in varchar2 default hr_api.g_varchar2
295 ,p_psq_attribute16 in varchar2 default hr_api.g_varchar2
296 ,p_psq_attribute17 in varchar2 default hr_api.g_varchar2
297 ,p_psq_attribute18 in varchar2 default hr_api.g_varchar2
298 ,p_psq_attribute19 in varchar2 default hr_api.g_varchar2
299 ,p_psq_attribute20 in varchar2 default hr_api.g_varchar2
300 ,p_psq_attribute21 in varchar2 default hr_api.g_varchar2
301 ,p_psq_attribute22 in varchar2 default hr_api.g_varchar2
302 ,p_psq_attribute23 in varchar2 default hr_api.g_varchar2
303 ,p_psq_attribute24 in varchar2 default hr_api.g_varchar2
304 ,p_psq_attribute25 in varchar2 default hr_api.g_varchar2
305 ,p_psq_attribute26 in varchar2 default hr_api.g_varchar2
306 ,p_psq_attribute27 in varchar2 default hr_api.g_varchar2
307 ,p_psq_attribute28 in varchar2 default hr_api.g_varchar2
308 ,p_psq_attribute29 in varchar2 default hr_api.g_varchar2
309 ,p_psq_attribute30 in varchar2 default hr_api.g_varchar2
310 ,p_object_version_number in out nocopy number
311 ,p_effective_date in date
312 ) is
313 --
314 -- Declare cursors and local variables
315 --
316 l_proc varchar2(72) := g_package||'update_pymt_sched_py_freq';
317 l_object_version_number ben_pymt_sched_py_freq.object_version_number%TYPE;
318 --
319 begin
320 --
321 hr_utility.set_location('Entering:'|| l_proc, 10);
322 --
323 -- Issue a savepoint if operating in validation only mode
324 --
325 savepoint update_pymt_sched_py_freq;
326 --
327 hr_utility.set_location(l_proc, 20);
328 --
329 -- Process Logic
330 --
331 l_object_version_number := p_object_version_number;
332 --
333 begin
334 --
335 -- Start of API User Hook for the before hook of update_pymt_sched_py_freq
336 --
337 ben_pymt_sched_py_freq_bk2.update_pymt_sched_py_freq_b
338 (
339 p_pymt_sched_py_freq_id => p_pymt_sched_py_freq_id
340 ,p_py_freq_cd => p_py_freq_cd
341 ,p_dflt_flag => p_dflt_flag
342 ,p_business_group_id => p_business_group_id
343 ,p_acty_rt_pymt_sched_id => p_acty_rt_pymt_sched_id
344 ,p_psq_attribute_category => p_psq_attribute_category
345 ,p_psq_attribute1 => p_psq_attribute1
346 ,p_psq_attribute2 => p_psq_attribute2
347 ,p_psq_attribute3 => p_psq_attribute3
348 ,p_psq_attribute4 => p_psq_attribute4
349 ,p_psq_attribute5 => p_psq_attribute5
350 ,p_psq_attribute6 => p_psq_attribute6
351 ,p_psq_attribute7 => p_psq_attribute7
352 ,p_psq_attribute8 => p_psq_attribute8
353 ,p_psq_attribute9 => p_psq_attribute9
354 ,p_psq_attribute10 => p_psq_attribute10
355 ,p_psq_attribute11 => p_psq_attribute11
356 ,p_psq_attribute12 => p_psq_attribute12
357 ,p_psq_attribute13 => p_psq_attribute13
358 ,p_psq_attribute14 => p_psq_attribute14
359 ,p_psq_attribute15 => p_psq_attribute15
360 ,p_psq_attribute16 => p_psq_attribute16
361 ,p_psq_attribute17 => p_psq_attribute17
362 ,p_psq_attribute18 => p_psq_attribute18
363 ,p_psq_attribute19 => p_psq_attribute19
364 ,p_psq_attribute20 => p_psq_attribute20
365 ,p_psq_attribute21 => p_psq_attribute21
366 ,p_psq_attribute22 => p_psq_attribute22
367 ,p_psq_attribute23 => p_psq_attribute23
368 ,p_psq_attribute24 => p_psq_attribute24
369 ,p_psq_attribute25 => p_psq_attribute25
370 ,p_psq_attribute26 => p_psq_attribute26
371 ,p_psq_attribute27 => p_psq_attribute27
372 ,p_psq_attribute28 => p_psq_attribute28
373 ,p_psq_attribute29 => p_psq_attribute29
374 ,p_psq_attribute30 => p_psq_attribute30
375 ,p_object_version_number => p_object_version_number
376 ,p_effective_date => trunc(p_effective_date)
377 );
378 exception
379 when hr_api.cannot_find_prog_unit then
380 hr_api.cannot_find_prog_unit_error
381 (p_module_name => 'UPDATE_pymt_sched_py_freq'
382 ,p_hook_type => 'BP'
383 );
384 --
385 -- End of API User Hook for the before hook of update_pymt_sched_py_freq
386 --
387 end;
388 --
389 ben_psq_upd.upd
390 (
391 p_pymt_sched_py_freq_id => p_pymt_sched_py_freq_id
392 ,p_py_freq_cd => p_py_freq_cd
393 ,p_dflt_flag => p_dflt_flag
394 ,p_business_group_id => p_business_group_id
395 ,p_acty_rt_pymt_sched_id => p_acty_rt_pymt_sched_id
396 ,p_psq_attribute_category => p_psq_attribute_category
397 ,p_psq_attribute1 => p_psq_attribute1
398 ,p_psq_attribute2 => p_psq_attribute2
399 ,p_psq_attribute3 => p_psq_attribute3
400 ,p_psq_attribute4 => p_psq_attribute4
401 ,p_psq_attribute5 => p_psq_attribute5
402 ,p_psq_attribute6 => p_psq_attribute6
403 ,p_psq_attribute7 => p_psq_attribute7
404 ,p_psq_attribute8 => p_psq_attribute8
405 ,p_psq_attribute9 => p_psq_attribute9
406 ,p_psq_attribute10 => p_psq_attribute10
407 ,p_psq_attribute11 => p_psq_attribute11
408 ,p_psq_attribute12 => p_psq_attribute12
409 ,p_psq_attribute13 => p_psq_attribute13
410 ,p_psq_attribute14 => p_psq_attribute14
411 ,p_psq_attribute15 => p_psq_attribute15
412 ,p_psq_attribute16 => p_psq_attribute16
413 ,p_psq_attribute17 => p_psq_attribute17
414 ,p_psq_attribute18 => p_psq_attribute18
415 ,p_psq_attribute19 => p_psq_attribute19
416 ,p_psq_attribute20 => p_psq_attribute20
417 ,p_psq_attribute21 => p_psq_attribute21
418 ,p_psq_attribute22 => p_psq_attribute22
419 ,p_psq_attribute23 => p_psq_attribute23
420 ,p_psq_attribute24 => p_psq_attribute24
421 ,p_psq_attribute25 => p_psq_attribute25
422 ,p_psq_attribute26 => p_psq_attribute26
423 ,p_psq_attribute27 => p_psq_attribute27
424 ,p_psq_attribute28 => p_psq_attribute28
425 ,p_psq_attribute29 => p_psq_attribute29
426 ,p_psq_attribute30 => p_psq_attribute30
427 ,p_object_version_number => l_object_version_number
428 ,p_effective_date => trunc(p_effective_date)
429 );
430 --
431 begin
432 --
433 -- Start of API User Hook for the after hook of update_pymt_sched_py_freq
434 --
435 ben_pymt_sched_py_freq_bk2.update_pymt_sched_py_freq_a
436 (
437 p_pymt_sched_py_freq_id => p_pymt_sched_py_freq_id
438 ,p_py_freq_cd => p_py_freq_cd
439 ,p_dflt_flag => p_dflt_flag
440 ,p_business_group_id => p_business_group_id
441 ,p_acty_rt_pymt_sched_id => p_acty_rt_pymt_sched_id
442 ,p_psq_attribute_category => p_psq_attribute_category
443 ,p_psq_attribute1 => p_psq_attribute1
444 ,p_psq_attribute2 => p_psq_attribute2
445 ,p_psq_attribute3 => p_psq_attribute3
446 ,p_psq_attribute4 => p_psq_attribute4
447 ,p_psq_attribute5 => p_psq_attribute5
448 ,p_psq_attribute6 => p_psq_attribute6
449 ,p_psq_attribute7 => p_psq_attribute7
450 ,p_psq_attribute8 => p_psq_attribute8
451 ,p_psq_attribute9 => p_psq_attribute9
452 ,p_psq_attribute10 => p_psq_attribute10
453 ,p_psq_attribute11 => p_psq_attribute11
454 ,p_psq_attribute12 => p_psq_attribute12
455 ,p_psq_attribute13 => p_psq_attribute13
456 ,p_psq_attribute14 => p_psq_attribute14
457 ,p_psq_attribute15 => p_psq_attribute15
458 ,p_psq_attribute16 => p_psq_attribute16
459 ,p_psq_attribute17 => p_psq_attribute17
460 ,p_psq_attribute18 => p_psq_attribute18
461 ,p_psq_attribute19 => p_psq_attribute19
462 ,p_psq_attribute20 => p_psq_attribute20
463 ,p_psq_attribute21 => p_psq_attribute21
464 ,p_psq_attribute22 => p_psq_attribute22
465 ,p_psq_attribute23 => p_psq_attribute23
466 ,p_psq_attribute24 => p_psq_attribute24
467 ,p_psq_attribute25 => p_psq_attribute25
468 ,p_psq_attribute26 => p_psq_attribute26
469 ,p_psq_attribute27 => p_psq_attribute27
470 ,p_psq_attribute28 => p_psq_attribute28
471 ,p_psq_attribute29 => p_psq_attribute29
472 ,p_psq_attribute30 => p_psq_attribute30
473 ,p_object_version_number => l_object_version_number
474 ,p_effective_date => trunc(p_effective_date)
475 );
476 exception
477 when hr_api.cannot_find_prog_unit then
478 hr_api.cannot_find_prog_unit_error
479 (p_module_name => 'UPDATE_pymt_sched_py_freq'
480 ,p_hook_type => 'AP'
481 );
482 --
483 -- End of API User Hook for the after hook of update_pymt_sched_py_freq
484 --
485 end;
486 --
487 hr_utility.set_location(l_proc, 60);
488 --
489 -- When in validation only mode raise the Validate_Enabled exception
490 --
491 if p_validate then
492 raise hr_api.validate_enabled;
493 end if;
494 --
495 -- Set all output arguments
496 --
497 p_object_version_number := l_object_version_number;
498 --
499 hr_utility.set_location(' Leaving:'||l_proc, 70);
500 --
501 exception
502 --
503 when hr_api.validate_enabled then
504 --
505 -- As the Validate_Enabled exception has been raised
506 -- we must rollback to the savepoint
507 --
508 ROLLBACK TO update_pymt_sched_py_freq;
509 --
510 -- Only set output warning arguments
511 -- (Any key or derived arguments must be set to null
512 -- when validation only mode is being used.)
513 --
514 hr_utility.set_location(' Leaving:'||l_proc, 80);
515 --
516 when others then
517 --
518 -- A validation or unexpected error has occured
519 -- Initialize IN/OUT Variables for NOCOPY
520 p_object_version_number := l_object_version_number ;
521
522 ROLLBACK TO update_pymt_sched_py_freq;
523 raise;
524 --
525 end update_pymt_sched_py_freq;
526 -- ----------------------------------------------------------------------------
527 -- |------------------------< delete_pymt_sched_py_freq >----------------------|
528 -- ----------------------------------------------------------------------------
529 --
530 procedure delete_pymt_sched_py_freq
531 (p_validate in boolean default false
532 ,p_pymt_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_pymt_sched_py_freq';
540 l_object_version_number ben_pymt_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_pymt_sched_py_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 --
559 -- Start of API User Hook for the before hook of delete_pymt_sched_py_freq
560 --
561 ben_pymt_sched_py_freq_bk3.delete_pymt_sched_py_freq_b
562 (
563 p_pymt_sched_py_freq_id => p_pymt_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_pymt_sched_py_freq'
571 ,p_hook_type => 'BP'
572 );
573 --
574 -- End of API User Hook for the before hook of delete_pymt_sched_py_freq
575 --
576 end;
577 --
578 ben_psq_del.del
579 (
580 p_pymt_sched_py_freq_id => p_pymt_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_pymt_sched_py_freq
588 --
589 ben_pymt_sched_py_freq_bk3.delete_pymt_sched_py_freq_a
590 (
591 p_pymt_sched_py_freq_id => p_pymt_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_pymt_sched_py_freq'
599 ,p_hook_type => 'AP'
600 );
601 --
602 -- End of API User Hook for the after hook of delete_pymt_sched_py_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_pymt_sched_py_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 --
635
636 -- Initialize IN/OUT Variables for NOCOPY
637 p_object_version_number := l_object_version_number;
638
639
640 ROLLBACK TO delete_pymt_sched_py_freq;
641 raise;
642 --
643 end delete_pymt_sched_py_freq;
644 --
645 -- ----------------------------------------------------------------------------
646 -- |-------------------------------< lck >------------------------------------|
647 -- ----------------------------------------------------------------------------
648 --
649 procedure lck
650 (
651 p_pymt_sched_py_freq_id in number
652 ,p_object_version_number in number
653 ) is
654 --
655 --
656 -- Declare cursors and local variables
657 --
658 l_proc varchar2(72) := g_package||'lck';
659 --
660 begin
661 --
662 hr_utility.set_location('Entering:'|| l_proc, 10);
663 --
664 ben_psq_shd.lck
665 (
666 p_pymt_sched_py_freq_id => p_pymt_sched_py_freq_id
667 ,p_object_version_number => p_object_version_number
668 );
669 --
670 hr_utility.set_location(' Leaving:'||l_proc, 70);
671 --
672 end lck;
673 --
674 end ben_pymt_sched_py_freq_api;