[Home] [Help]
PACKAGE BODY: APPS.BEN_HRS_WKD_IN_PERD_FCTR_API
Source
1 Package Body ben_hrs_wkd_in_perd_fctr_api as
2 /* $Header: behwfapi.pkb 120.0 2005/05/28 03:11:51 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_hrs_wkd_in_perd_fctr_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_hrs_wkd_in_perd_fctr >-------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_hrs_wkd_in_perd_fctr
13 (p_validate in boolean default false
14 ,p_hrs_wkd_in_perd_fctr_id out nocopy number
15 ,p_name in varchar2 default null
16 ,p_business_group_id in number default null
17 ,p_hrs_src_cd in varchar2 default null
18 ,p_rndg_cd in varchar2 default null
19 ,p_rndg_rl in number default null
20 ,p_hrs_wkd_det_cd in varchar2 default null
21 ,p_hrs_wkd_det_rl in number default null
22 ,p_no_mn_hrs_wkd_flag in varchar2 default null
23 ,p_mx_hrs_num in number default null
24 ,p_no_mx_hrs_wkd_flag in varchar2 default null
25 ,p_once_r_cntug_cd in varchar2 default null
26 ,p_mn_hrs_num in number default null
27 ,p_hrs_alt_val_to_use_cd in varchar2 default null
28 ,p_pyrl_freq_cd in varchar2 default null
29 ,p_hrs_wkd_calc_rl in number default null
30 ,p_defined_balance_id in number default null
31 ,p_bnfts_bal_id in number default null
32 ,p_hwf_attribute_category in varchar2 default null
33 ,p_hwf_attribute1 in varchar2 default null
34 ,p_hwf_attribute2 in varchar2 default null
35 ,p_hwf_attribute3 in varchar2 default null
36 ,p_hwf_attribute4 in varchar2 default null
37 ,p_hwf_attribute5 in varchar2 default null
38 ,p_hwf_attribute6 in varchar2 default null
39 ,p_hwf_attribute7 in varchar2 default null
40 ,p_hwf_attribute8 in varchar2 default null
41 ,p_hwf_attribute9 in varchar2 default null
42 ,p_hwf_attribute10 in varchar2 default null
43 ,p_hwf_attribute11 in varchar2 default null
44 ,p_hwf_attribute12 in varchar2 default null
45 ,p_hwf_attribute13 in varchar2 default null
46 ,p_hwf_attribute14 in varchar2 default null
47 ,p_hwf_attribute15 in varchar2 default null
48 ,p_hwf_attribute16 in varchar2 default null
49 ,p_hwf_attribute17 in varchar2 default null
50 ,p_hwf_attribute18 in varchar2 default null
51 ,p_hwf_attribute19 in varchar2 default null
52 ,p_hwf_attribute20 in varchar2 default null
53 ,p_hwf_attribute21 in varchar2 default null
54 ,p_hwf_attribute22 in varchar2 default null
55 ,p_hwf_attribute23 in varchar2 default null
56 ,p_hwf_attribute24 in varchar2 default null
57 ,p_hwf_attribute25 in varchar2 default null
58 ,p_hwf_attribute26 in varchar2 default null
59 ,p_hwf_attribute27 in varchar2 default null
60 ,p_hwf_attribute28 in varchar2 default null
61 ,p_hwf_attribute29 in varchar2 default null
62 ,p_hwf_attribute30 in varchar2 default null
63 ,p_object_version_number out nocopy number
64 ,p_effective_date in date
65 ) is
66 --
67 -- Declare cursors and local variables
68 --
69 l_hrs_wkd_in_perd_fctr_id ben_hrs_wkd_in_perd_fctr.hrs_wkd_in_perd_fctr_id%TYPE;
70 l_proc varchar2(72) := g_package||'create_hrs_wkd_in_perd_fctr';
71 l_object_version_number ben_hrs_wkd_in_perd_fctr.object_version_number%TYPE;
72 --
73 begin
74 --
75 hr_utility.set_location('Entering:'|| l_proc, 10);
76 --
77 -- Issue a savepoint if operating in validation only mode
78 --
79 savepoint create_hrs_wkd_in_perd_fctr;
80 --
81 hr_utility.set_location(l_proc, 20);
82 --
83 -- Process Logic
84 --
85 begin
86 --
87 -- Start of API User Hook for the before hook of create_hrs_wkd_in_perd_fctr
88 --
89 ben_hrs_wkd_in_perd_fctr_bk1.create_hrs_wkd_in_perd_fctr_b
90 (
91 p_name => p_name
92 ,p_business_group_id => p_business_group_id
93 ,p_hrs_src_cd => p_hrs_src_cd
94 ,p_rndg_cd => p_rndg_cd
95 ,p_rndg_rl => p_rndg_rl
96 ,p_hrs_wkd_det_cd => p_hrs_wkd_det_cd
97 ,p_hrs_wkd_det_rl => p_hrs_wkd_det_rl
98 ,p_no_mn_hrs_wkd_flag => p_no_mn_hrs_wkd_flag
99 ,p_mx_hrs_num => p_mx_hrs_num
100 ,p_no_mx_hrs_wkd_flag => p_no_mx_hrs_wkd_flag
101 ,p_once_r_cntug_cd => p_once_r_cntug_cd
102 ,p_mn_hrs_num => p_mn_hrs_num
103 ,p_hrs_alt_val_to_use_cd => p_hrs_alt_val_to_use_cd
104 ,p_pyrl_freq_cd => p_pyrl_freq_cd
105 ,p_hrs_wkd_calc_rl => p_hrs_wkd_calc_rl
106 ,p_defined_balance_id => p_defined_balance_id
107 ,p_bnfts_bal_id => p_bnfts_bal_id
108 ,p_hwf_attribute_category => p_hwf_attribute_category
109 ,p_hwf_attribute1 => p_hwf_attribute1
110 ,p_hwf_attribute2 => p_hwf_attribute2
111 ,p_hwf_attribute3 => p_hwf_attribute3
112 ,p_hwf_attribute4 => p_hwf_attribute4
113 ,p_hwf_attribute5 => p_hwf_attribute5
114 ,p_hwf_attribute6 => p_hwf_attribute6
115 ,p_hwf_attribute7 => p_hwf_attribute7
116 ,p_hwf_attribute8 => p_hwf_attribute8
117 ,p_hwf_attribute9 => p_hwf_attribute9
118 ,p_hwf_attribute10 => p_hwf_attribute10
119 ,p_hwf_attribute11 => p_hwf_attribute11
120 ,p_hwf_attribute12 => p_hwf_attribute12
121 ,p_hwf_attribute13 => p_hwf_attribute13
122 ,p_hwf_attribute14 => p_hwf_attribute14
123 ,p_hwf_attribute15 => p_hwf_attribute15
124 ,p_hwf_attribute16 => p_hwf_attribute16
125 ,p_hwf_attribute17 => p_hwf_attribute17
126 ,p_hwf_attribute18 => p_hwf_attribute18
127 ,p_hwf_attribute19 => p_hwf_attribute19
128 ,p_hwf_attribute20 => p_hwf_attribute20
129 ,p_hwf_attribute21 => p_hwf_attribute21
130 ,p_hwf_attribute22 => p_hwf_attribute22
131 ,p_hwf_attribute23 => p_hwf_attribute23
132 ,p_hwf_attribute24 => p_hwf_attribute24
133 ,p_hwf_attribute25 => p_hwf_attribute25
134 ,p_hwf_attribute26 => p_hwf_attribute26
135 ,p_hwf_attribute27 => p_hwf_attribute27
136 ,p_hwf_attribute28 => p_hwf_attribute28
137 ,p_hwf_attribute29 => p_hwf_attribute29
138 ,p_hwf_attribute30 => p_hwf_attribute30
139 ,p_effective_date => trunc(p_effective_date)
140 );
141 exception
142 when hr_api.cannot_find_prog_unit then
143 hr_api.cannot_find_prog_unit_error
144 (
145 p_module_name => 'CREATE_hrs_wkd_in_perd_fctr'
146 ,p_hook_type => 'BP'
147 );
148 --
149 -- End of API User Hook for the before hook of create_hrs_wkd_in_perd_fctr
150 --
151 end;
152 --
153 ben_hwf_ins.ins
154 (
155 p_hrs_wkd_in_perd_fctr_id => l_hrs_wkd_in_perd_fctr_id
156 ,p_name => p_name
157 ,p_business_group_id => p_business_group_id
158 ,p_hrs_src_cd => p_hrs_src_cd
159 ,p_rndg_cd => p_rndg_cd
160 ,p_rndg_rl => p_rndg_rl
161 ,p_hrs_wkd_det_cd => p_hrs_wkd_det_cd
162 ,p_hrs_wkd_det_rl => p_hrs_wkd_det_rl
163 ,p_no_mn_hrs_wkd_flag => p_no_mn_hrs_wkd_flag
164 ,p_mx_hrs_num => p_mx_hrs_num
165 ,p_no_mx_hrs_wkd_flag => p_no_mx_hrs_wkd_flag
166 ,p_once_r_cntug_cd => p_once_r_cntug_cd
167 ,p_mn_hrs_num => p_mn_hrs_num
168 ,p_hrs_alt_val_to_use_cd => p_hrs_alt_val_to_use_cd
169 ,p_pyrl_freq_cd => p_pyrl_freq_cd
170 ,p_hrs_wkd_calc_rl => p_hrs_wkd_calc_rl
171 ,p_defined_balance_id => p_defined_balance_id
172 ,p_bnfts_bal_id => p_bnfts_bal_id
173 ,p_hwf_attribute_category => p_hwf_attribute_category
174 ,p_hwf_attribute1 => p_hwf_attribute1
175 ,p_hwf_attribute2 => p_hwf_attribute2
176 ,p_hwf_attribute3 => p_hwf_attribute3
177 ,p_hwf_attribute4 => p_hwf_attribute4
178 ,p_hwf_attribute5 => p_hwf_attribute5
179 ,p_hwf_attribute6 => p_hwf_attribute6
180 ,p_hwf_attribute7 => p_hwf_attribute7
181 ,p_hwf_attribute8 => p_hwf_attribute8
182 ,p_hwf_attribute9 => p_hwf_attribute9
183 ,p_hwf_attribute10 => p_hwf_attribute10
184 ,p_hwf_attribute11 => p_hwf_attribute11
185 ,p_hwf_attribute12 => p_hwf_attribute12
186 ,p_hwf_attribute13 => p_hwf_attribute13
187 ,p_hwf_attribute14 => p_hwf_attribute14
188 ,p_hwf_attribute15 => p_hwf_attribute15
189 ,p_hwf_attribute16 => p_hwf_attribute16
190 ,p_hwf_attribute17 => p_hwf_attribute17
191 ,p_hwf_attribute18 => p_hwf_attribute18
192 ,p_hwf_attribute19 => p_hwf_attribute19
193 ,p_hwf_attribute20 => p_hwf_attribute20
194 ,p_hwf_attribute21 => p_hwf_attribute21
195 ,p_hwf_attribute22 => p_hwf_attribute22
196 ,p_hwf_attribute23 => p_hwf_attribute23
197 ,p_hwf_attribute24 => p_hwf_attribute24
198 ,p_hwf_attribute25 => p_hwf_attribute25
199 ,p_hwf_attribute26 => p_hwf_attribute26
200 ,p_hwf_attribute27 => p_hwf_attribute27
201 ,p_hwf_attribute28 => p_hwf_attribute28
202 ,p_hwf_attribute29 => p_hwf_attribute29
203 ,p_hwf_attribute30 => p_hwf_attribute30
204 ,p_object_version_number => l_object_version_number
205 ,p_effective_date => trunc(p_effective_date)
206 );
207 --
208 begin
209 --
210 -- Start of API User Hook for the after hook of create_hrs_wkd_in_perd_fctr
211 --
212 ben_hrs_wkd_in_perd_fctr_bk1.create_hrs_wkd_in_perd_fctr_a
213 (
214 p_hrs_wkd_in_perd_fctr_id => l_hrs_wkd_in_perd_fctr_id
215 ,p_name => p_name
216 ,p_business_group_id => p_business_group_id
217 ,p_hrs_src_cd => p_hrs_src_cd
218 ,p_rndg_cd => p_rndg_cd
219 ,p_rndg_rl => p_rndg_rl
220 ,p_hrs_wkd_det_cd => p_hrs_wkd_det_cd
221 ,p_hrs_wkd_det_rl => p_hrs_wkd_det_rl
222 ,p_no_mn_hrs_wkd_flag => p_no_mn_hrs_wkd_flag
223 ,p_mx_hrs_num => p_mx_hrs_num
224 ,p_no_mx_hrs_wkd_flag => p_no_mx_hrs_wkd_flag
225 ,p_once_r_cntug_cd => p_once_r_cntug_cd
226 ,p_mn_hrs_num => p_mn_hrs_num
227 ,p_hrs_alt_val_to_use_cd => p_hrs_alt_val_to_use_cd
228 ,p_pyrl_freq_cd => p_pyrl_freq_cd
229 ,p_hrs_wkd_calc_rl => p_hrs_wkd_calc_rl
230 ,p_defined_balance_id => p_defined_balance_id
231 ,p_bnfts_bal_id => p_bnfts_bal_id
232 ,p_hwf_attribute_category => p_hwf_attribute_category
233 ,p_hwf_attribute1 => p_hwf_attribute1
234 ,p_hwf_attribute2 => p_hwf_attribute2
235 ,p_hwf_attribute3 => p_hwf_attribute3
236 ,p_hwf_attribute4 => p_hwf_attribute4
237 ,p_hwf_attribute5 => p_hwf_attribute5
238 ,p_hwf_attribute6 => p_hwf_attribute6
239 ,p_hwf_attribute7 => p_hwf_attribute7
240 ,p_hwf_attribute8 => p_hwf_attribute8
241 ,p_hwf_attribute9 => p_hwf_attribute9
242 ,p_hwf_attribute10 => p_hwf_attribute10
243 ,p_hwf_attribute11 => p_hwf_attribute11
244 ,p_hwf_attribute12 => p_hwf_attribute12
245 ,p_hwf_attribute13 => p_hwf_attribute13
246 ,p_hwf_attribute14 => p_hwf_attribute14
247 ,p_hwf_attribute15 => p_hwf_attribute15
248 ,p_hwf_attribute16 => p_hwf_attribute16
249 ,p_hwf_attribute17 => p_hwf_attribute17
250 ,p_hwf_attribute18 => p_hwf_attribute18
251 ,p_hwf_attribute19 => p_hwf_attribute19
252 ,p_hwf_attribute20 => p_hwf_attribute20
253 ,p_hwf_attribute21 => p_hwf_attribute21
254 ,p_hwf_attribute22 => p_hwf_attribute22
255 ,p_hwf_attribute23 => p_hwf_attribute23
256 ,p_hwf_attribute24 => p_hwf_attribute24
257 ,p_hwf_attribute25 => p_hwf_attribute25
258 ,p_hwf_attribute26 => p_hwf_attribute26
259 ,p_hwf_attribute27 => p_hwf_attribute27
260 ,p_hwf_attribute28 => p_hwf_attribute28
261 ,p_hwf_attribute29 => p_hwf_attribute29
262 ,p_hwf_attribute30 => p_hwf_attribute30
263 ,p_object_version_number => l_object_version_number
264 ,p_effective_date => trunc(p_effective_date)
265 );
266 exception
267 when hr_api.cannot_find_prog_unit then
268 hr_api.cannot_find_prog_unit_error
269 (p_module_name => 'CREATE_hrs_wkd_in_perd_fctr'
270 ,p_hook_type => 'AP'
271 );
272 --
273 -- End of API User Hook for the after hook of create_hrs_wkd_in_perd_fctr
274 --
275 end;
276 --
277 hr_utility.set_location(l_proc, 60);
278 --
279 -- When in validation only mode raise the Validate_Enabled exception
280 --
281 if p_validate then
282 raise hr_api.validate_enabled;
283 end if;
284 --
285 -- Set all output arguments
286 --
287 p_hrs_wkd_in_perd_fctr_id := l_hrs_wkd_in_perd_fctr_id;
288 p_object_version_number := l_object_version_number;
289 --
290 hr_utility.set_location(' Leaving:'||l_proc, 70);
291 --
292 exception
293 --
294 when hr_api.validate_enabled then
295 --
296 -- As the Validate_Enabled exception has been raised
297 -- we must rollback to the savepoint
298 --
299 ROLLBACK TO create_hrs_wkd_in_perd_fctr;
300 --
301 -- Only set output warning arguments
302 -- (Any key or derived arguments must be set to null
303 -- when validation only mode is being used.)
304 --
305 p_hrs_wkd_in_perd_fctr_id := null;
306 p_object_version_number := null;
307 hr_utility.set_location(' Leaving:'||l_proc, 80);
308 --
309 when others then
310 --
311 -- A validation or unexpected error has occured
312 --
313 ROLLBACK TO create_hrs_wkd_in_perd_fctr;
314 p_hrs_wkd_in_perd_fctr_id := null;
315 p_object_version_number := null;
316
317 raise;
318 --
319 end create_hrs_wkd_in_perd_fctr;
323 --
320 -- ----------------------------------------------------------------------------
321 -- |------------------------< update_hrs_wkd_in_perd_fctr >-------------------|
322 -- ----------------------------------------------------------------------------
324 procedure update_hrs_wkd_in_perd_fctr
325 (p_validate in boolean default false
326 ,p_hrs_wkd_in_perd_fctr_id in number
327 ,p_name in varchar2 default hr_api.g_varchar2
328 ,p_business_group_id in number default hr_api.g_number
329 ,p_hrs_src_cd in varchar2 default hr_api.g_varchar2
330 ,p_rndg_cd in varchar2 default hr_api.g_varchar2
331 ,p_rndg_rl in number default hr_api.g_number
332 ,p_hrs_wkd_det_cd in varchar2 default hr_api.g_varchar2
333 ,p_hrs_wkd_det_rl in number default hr_api.g_number
334 ,p_no_mn_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
335 ,p_mx_hrs_num in number default hr_api.g_number
336 ,p_no_mx_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
337 ,p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2
338 ,p_mn_hrs_num in number default hr_api.g_number
339 ,p_hrs_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2
340 ,p_pyrl_freq_cd in varchar2 default hr_api.g_varchar2
341 ,p_hrs_wkd_calc_rl in number default hr_api.g_number
342 ,p_defined_balance_id in number default hr_api.g_number
343 ,p_bnfts_bal_id in number default hr_api.g_number
344 ,p_hwf_attribute_category in varchar2 default hr_api.g_varchar2
345 ,p_hwf_attribute1 in varchar2 default hr_api.g_varchar2
346 ,p_hwf_attribute2 in varchar2 default hr_api.g_varchar2
347 ,p_hwf_attribute3 in varchar2 default hr_api.g_varchar2
348 ,p_hwf_attribute4 in varchar2 default hr_api.g_varchar2
349 ,p_hwf_attribute5 in varchar2 default hr_api.g_varchar2
350 ,p_hwf_attribute6 in varchar2 default hr_api.g_varchar2
351 ,p_hwf_attribute7 in varchar2 default hr_api.g_varchar2
352 ,p_hwf_attribute8 in varchar2 default hr_api.g_varchar2
353 ,p_hwf_attribute9 in varchar2 default hr_api.g_varchar2
354 ,p_hwf_attribute10 in varchar2 default hr_api.g_varchar2
355 ,p_hwf_attribute11 in varchar2 default hr_api.g_varchar2
356 ,p_hwf_attribute12 in varchar2 default hr_api.g_varchar2
357 ,p_hwf_attribute13 in varchar2 default hr_api.g_varchar2
358 ,p_hwf_attribute14 in varchar2 default hr_api.g_varchar2
359 ,p_hwf_attribute15 in varchar2 default hr_api.g_varchar2
360 ,p_hwf_attribute16 in varchar2 default hr_api.g_varchar2
361 ,p_hwf_attribute17 in varchar2 default hr_api.g_varchar2
362 ,p_hwf_attribute18 in varchar2 default hr_api.g_varchar2
363 ,p_hwf_attribute19 in varchar2 default hr_api.g_varchar2
364 ,p_hwf_attribute20 in varchar2 default hr_api.g_varchar2
365 ,p_hwf_attribute21 in varchar2 default hr_api.g_varchar2
366 ,p_hwf_attribute22 in varchar2 default hr_api.g_varchar2
367 ,p_hwf_attribute23 in varchar2 default hr_api.g_varchar2
368 ,p_hwf_attribute24 in varchar2 default hr_api.g_varchar2
369 ,p_hwf_attribute25 in varchar2 default hr_api.g_varchar2
370 ,p_hwf_attribute26 in varchar2 default hr_api.g_varchar2
371 ,p_hwf_attribute27 in varchar2 default hr_api.g_varchar2
372 ,p_hwf_attribute28 in varchar2 default hr_api.g_varchar2
373 ,p_hwf_attribute29 in varchar2 default hr_api.g_varchar2
374 ,p_hwf_attribute30 in varchar2 default hr_api.g_varchar2
375 ,p_object_version_number in out nocopy number
376 ,p_effective_date in date
377 ) is
378 --
379 -- Declare cursors and local variables
380 --
381 l_proc varchar2(72) := g_package||'update_hrs_wkd_in_perd_fctr';
382 l_object_version_number ben_hrs_wkd_in_perd_fctr.object_version_number%TYPE;
383 --
384 begin
385 --
386 hr_utility.set_location('Entering:'|| l_proc, 10);
387 --
388 -- Issue a savepoint if operating in validation only mode
389 --
390 savepoint update_hrs_wkd_in_perd_fctr;
391 --
392 hr_utility.set_location(l_proc, 20);
393 --
394 -- Process Logic
395 --
396 l_object_version_number := p_object_version_number;
397 --
398 begin
399 --
400 -- Start of API User Hook for the before hook of update_hrs_wkd_in_perd_fctr
401 --
402 ben_hrs_wkd_in_perd_fctr_bk2.update_hrs_wkd_in_perd_fctr_b
403 (
404 p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id
405 ,p_name => p_name
406 ,p_business_group_id => p_business_group_id
407 ,p_hrs_src_cd => p_hrs_src_cd
408 ,p_rndg_cd => p_rndg_cd
409 ,p_rndg_rl => p_rndg_rl
410 ,p_hrs_wkd_det_cd => p_hrs_wkd_det_cd
411 ,p_hrs_wkd_det_rl => p_hrs_wkd_det_rl
412 ,p_no_mn_hrs_wkd_flag => p_no_mn_hrs_wkd_flag
416 ,p_mn_hrs_num => p_mn_hrs_num
413 ,p_mx_hrs_num => p_mx_hrs_num
414 ,p_no_mx_hrs_wkd_flag => p_no_mx_hrs_wkd_flag
415 ,p_once_r_cntug_cd => p_once_r_cntug_cd
417 ,p_hrs_alt_val_to_use_cd => p_hrs_alt_val_to_use_cd
418 ,p_pyrl_freq_cd => p_pyrl_freq_cd
419 ,p_hrs_wkd_calc_rl => p_hrs_wkd_calc_rl
420 ,p_defined_balance_id => p_defined_balance_id
421 ,p_bnfts_bal_id => p_bnfts_bal_id
422 ,p_hwf_attribute_category => p_hwf_attribute_category
423 ,p_hwf_attribute1 => p_hwf_attribute1
424 ,p_hwf_attribute2 => p_hwf_attribute2
425 ,p_hwf_attribute3 => p_hwf_attribute3
426 ,p_hwf_attribute4 => p_hwf_attribute4
427 ,p_hwf_attribute5 => p_hwf_attribute5
428 ,p_hwf_attribute6 => p_hwf_attribute6
429 ,p_hwf_attribute7 => p_hwf_attribute7
430 ,p_hwf_attribute8 => p_hwf_attribute8
431 ,p_hwf_attribute9 => p_hwf_attribute9
432 ,p_hwf_attribute10 => p_hwf_attribute10
433 ,p_hwf_attribute11 => p_hwf_attribute11
434 ,p_hwf_attribute12 => p_hwf_attribute12
435 ,p_hwf_attribute13 => p_hwf_attribute13
436 ,p_hwf_attribute14 => p_hwf_attribute14
437 ,p_hwf_attribute15 => p_hwf_attribute15
438 ,p_hwf_attribute16 => p_hwf_attribute16
439 ,p_hwf_attribute17 => p_hwf_attribute17
440 ,p_hwf_attribute18 => p_hwf_attribute18
441 ,p_hwf_attribute19 => p_hwf_attribute19
442 ,p_hwf_attribute20 => p_hwf_attribute20
443 ,p_hwf_attribute21 => p_hwf_attribute21
444 ,p_hwf_attribute22 => p_hwf_attribute22
445 ,p_hwf_attribute23 => p_hwf_attribute23
446 ,p_hwf_attribute24 => p_hwf_attribute24
447 ,p_hwf_attribute25 => p_hwf_attribute25
448 ,p_hwf_attribute26 => p_hwf_attribute26
449 ,p_hwf_attribute27 => p_hwf_attribute27
450 ,p_hwf_attribute28 => p_hwf_attribute28
451 ,p_hwf_attribute29 => p_hwf_attribute29
452 ,p_hwf_attribute30 => p_hwf_attribute30
453 ,p_object_version_number => p_object_version_number
454 ,p_effective_date => trunc(p_effective_date)
455 );
456 exception
457 when hr_api.cannot_find_prog_unit then
458 hr_api.cannot_find_prog_unit_error
459 (p_module_name => 'UPDATE_hrs_wkd_in_perd_fctr'
460 ,p_hook_type => 'BP'
461 );
462 --
463 -- End of API User Hook for the before hook of update_hrs_wkd_in_perd_fctr
464 --
465 end;
466 --
467 ben_hwf_upd.upd
468 (
469 p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id
470 ,p_name => p_name
471 ,p_business_group_id => p_business_group_id
472 ,p_hrs_src_cd => p_hrs_src_cd
473 ,p_rndg_cd => p_rndg_cd
474 ,p_rndg_rl => p_rndg_rl
475 ,p_hrs_wkd_det_cd => p_hrs_wkd_det_cd
476 ,p_hrs_wkd_det_rl => p_hrs_wkd_det_rl
477 ,p_no_mn_hrs_wkd_flag => p_no_mn_hrs_wkd_flag
478 ,p_mx_hrs_num => p_mx_hrs_num
479 ,p_no_mx_hrs_wkd_flag => p_no_mx_hrs_wkd_flag
480 ,p_once_r_cntug_cd => p_once_r_cntug_cd
481 ,p_mn_hrs_num => p_mn_hrs_num
482 ,p_hrs_alt_val_to_use_cd => p_hrs_alt_val_to_use_cd
483 ,p_pyrl_freq_cd => p_pyrl_freq_cd
484 ,p_hrs_wkd_calc_rl => p_hrs_wkd_calc_rl
485 ,p_defined_balance_id => p_defined_balance_id
486 ,p_bnfts_bal_id => p_bnfts_bal_id
487 ,p_hwf_attribute_category => p_hwf_attribute_category
488 ,p_hwf_attribute1 => p_hwf_attribute1
489 ,p_hwf_attribute2 => p_hwf_attribute2
490 ,p_hwf_attribute3 => p_hwf_attribute3
491 ,p_hwf_attribute4 => p_hwf_attribute4
492 ,p_hwf_attribute5 => p_hwf_attribute5
493 ,p_hwf_attribute6 => p_hwf_attribute6
494 ,p_hwf_attribute7 => p_hwf_attribute7
495 ,p_hwf_attribute8 => p_hwf_attribute8
496 ,p_hwf_attribute9 => p_hwf_attribute9
497 ,p_hwf_attribute10 => p_hwf_attribute10
498 ,p_hwf_attribute11 => p_hwf_attribute11
499 ,p_hwf_attribute12 => p_hwf_attribute12
500 ,p_hwf_attribute13 => p_hwf_attribute13
501 ,p_hwf_attribute14 => p_hwf_attribute14
502 ,p_hwf_attribute15 => p_hwf_attribute15
503 ,p_hwf_attribute16 => p_hwf_attribute16
504 ,p_hwf_attribute17 => p_hwf_attribute17
505 ,p_hwf_attribute18 => p_hwf_attribute18
506 ,p_hwf_attribute19 => p_hwf_attribute19
507 ,p_hwf_attribute20 => p_hwf_attribute20
508 ,p_hwf_attribute21 => p_hwf_attribute21
509 ,p_hwf_attribute22 => p_hwf_attribute22
510 ,p_hwf_attribute23 => p_hwf_attribute23
514 ,p_hwf_attribute27 => p_hwf_attribute27
511 ,p_hwf_attribute24 => p_hwf_attribute24
512 ,p_hwf_attribute25 => p_hwf_attribute25
513 ,p_hwf_attribute26 => p_hwf_attribute26
515 ,p_hwf_attribute28 => p_hwf_attribute28
516 ,p_hwf_attribute29 => p_hwf_attribute29
517 ,p_hwf_attribute30 => p_hwf_attribute30
518 ,p_object_version_number => l_object_version_number
519 ,p_effective_date => trunc(p_effective_date)
520 );
521 --
522 begin
523 --
524 -- Start of API User Hook for the after hook of update_hrs_wkd_in_perd_fctr
525 --
526 ben_hrs_wkd_in_perd_fctr_bk2.update_hrs_wkd_in_perd_fctr_a
527 (
528 p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id
529 ,p_name => p_name
530 ,p_business_group_id => p_business_group_id
531 ,p_hrs_src_cd => p_hrs_src_cd
532 ,p_rndg_cd => p_rndg_cd
533 ,p_rndg_rl => p_rndg_rl
534 ,p_hrs_wkd_det_cd => p_hrs_wkd_det_cd
535 ,p_hrs_wkd_det_rl => p_hrs_wkd_det_rl
536 ,p_no_mn_hrs_wkd_flag => p_no_mn_hrs_wkd_flag
537 ,p_mx_hrs_num => p_mx_hrs_num
538 ,p_no_mx_hrs_wkd_flag => p_no_mx_hrs_wkd_flag
539 ,p_once_r_cntug_cd => p_once_r_cntug_cd
540 ,p_mn_hrs_num => p_mn_hrs_num
541 ,p_hrs_alt_val_to_use_cd => p_hrs_alt_val_to_use_cd
542 ,p_pyrl_freq_cd => p_pyrl_freq_cd
543 ,p_hrs_wkd_calc_rl => p_hrs_wkd_calc_rl
544 ,p_defined_balance_id => p_defined_balance_id
545 ,p_bnfts_bal_id => p_bnfts_bal_id
546 ,p_hwf_attribute_category => p_hwf_attribute_category
547 ,p_hwf_attribute1 => p_hwf_attribute1
548 ,p_hwf_attribute2 => p_hwf_attribute2
549 ,p_hwf_attribute3 => p_hwf_attribute3
550 ,p_hwf_attribute4 => p_hwf_attribute4
551 ,p_hwf_attribute5 => p_hwf_attribute5
552 ,p_hwf_attribute6 => p_hwf_attribute6
553 ,p_hwf_attribute7 => p_hwf_attribute7
554 ,p_hwf_attribute8 => p_hwf_attribute8
555 ,p_hwf_attribute9 => p_hwf_attribute9
556 ,p_hwf_attribute10 => p_hwf_attribute10
557 ,p_hwf_attribute11 => p_hwf_attribute11
558 ,p_hwf_attribute12 => p_hwf_attribute12
559 ,p_hwf_attribute13 => p_hwf_attribute13
560 ,p_hwf_attribute14 => p_hwf_attribute14
561 ,p_hwf_attribute15 => p_hwf_attribute15
562 ,p_hwf_attribute16 => p_hwf_attribute16
563 ,p_hwf_attribute17 => p_hwf_attribute17
564 ,p_hwf_attribute18 => p_hwf_attribute18
565 ,p_hwf_attribute19 => p_hwf_attribute19
566 ,p_hwf_attribute20 => p_hwf_attribute20
567 ,p_hwf_attribute21 => p_hwf_attribute21
568 ,p_hwf_attribute22 => p_hwf_attribute22
569 ,p_hwf_attribute23 => p_hwf_attribute23
570 ,p_hwf_attribute24 => p_hwf_attribute24
571 ,p_hwf_attribute25 => p_hwf_attribute25
572 ,p_hwf_attribute26 => p_hwf_attribute26
573 ,p_hwf_attribute27 => p_hwf_attribute27
574 ,p_hwf_attribute28 => p_hwf_attribute28
575 ,p_hwf_attribute29 => p_hwf_attribute29
576 ,p_hwf_attribute30 => p_hwf_attribute30
577 ,p_object_version_number => l_object_version_number
578 ,p_effective_date => trunc(p_effective_date)
579 );
580 exception
581 when hr_api.cannot_find_prog_unit then
582 hr_api.cannot_find_prog_unit_error
583 (p_module_name => 'UPDATE_hrs_wkd_in_perd_fctr'
584 ,p_hook_type => 'AP'
585 );
586 --
587 -- End of API User Hook for the after hook of update_hrs_wkd_in_perd_fctr
588 --
589 end;
590 --
591 hr_utility.set_location(l_proc, 60);
592 --
593 -- When in validation only mode raise the Validate_Enabled exception
594 --
595 if p_validate then
596 raise hr_api.validate_enabled;
597 end if;
598 --
599 -- Set all output arguments
600 --
601 p_object_version_number := l_object_version_number;
602 --
603 hr_utility.set_location(' Leaving:'||l_proc, 70);
604 --
605 exception
606 --
607 when hr_api.validate_enabled then
608 --
609 -- As the Validate_Enabled exception has been raised
610 -- we must rollback to the savepoint
611 --
612 ROLLBACK TO update_hrs_wkd_in_perd_fctr;
613 --
614 -- Only set output warning arguments
615 -- (Any key or derived arguments must be set to null
616 -- when validation only mode is being used.)
617 --
618 hr_utility.set_location(' Leaving:'||l_proc, 80);
619 --
620 when others then
621 --
622 -- A validation or unexpected error has occured
623 --
624 ROLLBACK TO update_hrs_wkd_in_perd_fctr;
625 p_object_version_number := l_object_version_number;
626 raise;
627 --
628 end update_hrs_wkd_in_perd_fctr;
629 -- ----------------------------------------------------------------------------
630 -- |---------------------< delete_hrs_wkd_in_perd_fctr >----------------------|
631 -- ----------------------------------------------------------------------------
632 --
633 procedure delete_hrs_wkd_in_perd_fctr
634 (p_validate in boolean default false
635 ,p_hrs_wkd_in_perd_fctr_id in number
636 ,p_object_version_number in out nocopy number
637 ,p_effective_date in date
638 ) is
639 --
640 -- Declare cursors and local variables
641 --
642 l_proc varchar2(72) := g_package||'update_hrs_wkd_in_perd_fctr';
643 l_object_version_number ben_hrs_wkd_in_perd_fctr.object_version_number%TYPE;
644 --
645 begin
646 --
647 hr_utility.set_location('Entering:'|| l_proc, 10);
648 --
649 -- Issue a savepoint if operating in validation only mode
650 --
651 savepoint delete_hrs_wkd_in_perd_fctr;
652 --
653 hr_utility.set_location(l_proc, 20);
654 --
655 -- Process Logic
656 --
657 l_object_version_number := p_object_version_number;
658 --
659 --
660 begin
661 --
662 -- Start of API User Hook for the before hook of delete_hrs_wkd_in_perd_fctr
663 --
664 ben_hrs_wkd_in_perd_fctr_bk3.delete_hrs_wkd_in_perd_fctr_b
665 (
666 p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id
667 ,p_object_version_number => p_object_version_number
668 ,p_effective_date => trunc(p_effective_date)
669 );
670 exception
671 when hr_api.cannot_find_prog_unit then
672 hr_api.cannot_find_prog_unit_error
673 (p_module_name => 'DELETE_hrs_wkd_in_perd_fctr'
674 ,p_hook_type => 'BP'
675 );
676 --
677 -- End of API User Hook for the before hook of delete_hrs_wkd_in_perd_fctr
678 --
679 end;
680 --
681 ben_hwf_del.del
682 (
683 p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id
684 ,p_object_version_number => l_object_version_number
685 ,p_effective_date => p_effective_date
686 );
687 --
688 begin
689 --
690 -- Start of API User Hook for the after hook of delete_hrs_wkd_in_perd_fctr
691 --
692 ben_hrs_wkd_in_perd_fctr_bk3.delete_hrs_wkd_in_perd_fctr_a
693 (
694 p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id
695 ,p_object_version_number => l_object_version_number
696 ,p_effective_date => trunc(p_effective_date)
697 );
698 exception
699 when hr_api.cannot_find_prog_unit then
700 hr_api.cannot_find_prog_unit_error
701 (p_module_name => 'DELETE_hrs_wkd_in_perd_fctr'
702 ,p_hook_type => 'AP'
703 );
704 --
705 -- End of API User Hook for the after hook of delete_hrs_wkd_in_perd_fctr
706 --
707 end;
708 --
709 hr_utility.set_location(l_proc, 60);
710 --
711 -- When in validation only mode raise the Validate_Enabled exception
712 --
713 if p_validate then
714 raise hr_api.validate_enabled;
715 end if;
716 --
717 hr_utility.set_location(' Leaving:'||l_proc, 70);
718 --
719 exception
720 --
721 when hr_api.validate_enabled then
722 --
723 -- As the Validate_Enabled exception has been raised
724 -- we must rollback to the savepoint
725 --
726 ROLLBACK TO delete_hrs_wkd_in_perd_fctr;
727 --
728 -- Only set output warning arguments
729 -- (Any key or derived arguments must be set to null
730 -- when validation only mode is being used.)
731 --
732 --
733 when others then
734 --
735 -- A validation or unexpected error has occured
736 --
737 ROLLBACK TO delete_hrs_wkd_in_perd_fctr;
738 p_object_version_number := l_object_version_number;
739 raise;
740 --
741 end delete_hrs_wkd_in_perd_fctr;
742 --
743 -- ----------------------------------------------------------------------------
744 -- |-------------------------------< lck >------------------------------------|
745 -- ----------------------------------------------------------------------------
746 --
747 procedure lck
748 (
749 p_hrs_wkd_in_perd_fctr_id in number
750 ,p_object_version_number in number
751 ) is
752 --
753 --
754 -- Declare cursors and local variables
755 --
756 l_proc varchar2(72) := g_package||'lck';
757 --
758 begin
759 --
760 hr_utility.set_location('Entering:'|| l_proc, 10);
761 --
762 ben_hwf_shd.lck
763 (
764 p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id
765 ,p_object_version_number => p_object_version_number
766 );
767 --
768 hr_utility.set_location(' Leaving:'||l_proc, 70);
769 --
770 end lck;
771 --
772 end ben_hrs_wkd_in_perd_fctr_api;