[Home] [Help]
PACKAGE BODY: APPS.BEN_ACTUAL_PREMIUM_API
Source
4 -- Package Variables
1 Package Body ben_actual_premium_api as
2 /* $Header: beaprapi.pkb 120.0 2005/05/28 00:26:27 appldev noship $ */
3 --
5 --
6 g_package varchar2(33) := ' ben_actual_premium_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_actual_premium >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_actual_premium
13 (p_validate in boolean default false
14 ,p_actl_prem_id out nocopy number
15 ,p_effective_start_date out nocopy date
16 ,p_effective_end_date out nocopy date
17 ,p_name in varchar2 default null
18 ,p_acty_ref_perd_cd in varchar2 default null
19 ,p_uom in varchar2 default null
20 ,p_rt_typ_cd in varchar2 default null
21 ,p_bnft_rt_typ_cd in varchar2 default null
22 ,p_val in number default null
23 ,p_mlt_cd in varchar2 default null
24 ,p_prdct_cd in varchar2 default null
25 ,p_rndg_cd in varchar2 default null
26 ,p_rndg_rl in number default null
27 ,p_val_calc_rl in number default null
28 ,p_prem_asnmt_cd in varchar2 default null
29 ,p_prem_asnmt_lvl_cd in varchar2 default null
30 ,p_actl_prem_typ_cd in varchar2 default null
31 ,p_prem_pyr_cd in varchar2 default null
32 ,p_cr_lkbk_val in number default null
33 ,p_cr_lkbk_uom in varchar2 default null
34 ,p_cr_lkbk_crnt_py_only_flag in varchar2 default null
35 ,p_prsptv_r_rtsptv_cd in varchar2 default null
36 ,p_upr_lmt_val in number default null
37 ,p_upr_lmt_calc_rl in number default null
38 ,p_lwr_lmt_val in number default null
39 ,p_lwr_lmt_calc_rl in number default null
40 ,p_cost_allocation_keyflex_id in number default null
41 ,p_organization_id in number default null
42 ,p_oipl_id in number default null
43 ,p_pl_id in number default null
44 ,p_comp_lvl_fctr_id in number default null
45 ,p_business_group_id in number default null
46 ,p_apr_attribute_category in varchar2 default null
47 ,p_apr_attribute1 in varchar2 default null
51 ,p_apr_attribute5 in varchar2 default null
48 ,p_apr_attribute2 in varchar2 default null
49 ,p_apr_attribute3 in varchar2 default null
50 ,p_apr_attribute4 in varchar2 default null
52 ,p_apr_attribute6 in varchar2 default null
53 ,p_apr_attribute7 in varchar2 default null
54 ,p_apr_attribute8 in varchar2 default null
55 ,p_apr_attribute9 in varchar2 default null
56 ,p_apr_attribute10 in varchar2 default null
57 ,p_apr_attribute11 in varchar2 default null
58 ,p_apr_attribute12 in varchar2 default null
59 ,p_apr_attribute13 in varchar2 default null
60 ,p_apr_attribute14 in varchar2 default null
61 ,p_apr_attribute15 in varchar2 default null
62 ,p_apr_attribute16 in varchar2 default null
63 ,p_apr_attribute17 in varchar2 default null
64 ,p_apr_attribute18 in varchar2 default null
65 ,p_apr_attribute19 in varchar2 default null
66 ,p_apr_attribute20 in varchar2 default null
67 ,p_apr_attribute21 in varchar2 default null
68 ,p_apr_attribute22 in varchar2 default null
69 ,p_apr_attribute23 in varchar2 default null
70 ,p_apr_attribute24 in varchar2 default null
71 ,p_apr_attribute25 in varchar2 default null
72 ,p_apr_attribute26 in varchar2 default null
73 ,p_apr_attribute27 in varchar2 default null
74 ,p_apr_attribute28 in varchar2 default null
75 ,p_apr_attribute29 in varchar2 default null
76 ,p_apr_attribute30 in varchar2 default null
77 ,p_object_version_number out nocopy number
78 ,p_prtl_mo_det_mthd_cd in varchar2 default null
79 ,p_prtl_mo_det_mthd_rl in number default null
80 ,p_wsh_rl_dy_mo_num in number default null
81 ,p_vrbl_rt_add_on_calc_rl in number default null
82 ,p_effective_date in date
83 ) is
84 --
85 -- Declare cursors and local variables
86 --
87 l_actl_prem_id ben_actl_prem_f.actl_prem_id%TYPE;
88 l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
89 l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
90 l_proc varchar2(72) := g_package||'create_actual_premium';
91 l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
92 --
93 begin
94 --
95 hr_utility.set_location('Entering:'|| l_proc, 10);
96 --
97 -- Issue a savepoint if operating in validation only mode
98 --
99 savepoint create_actual_premium;
100 --
101 hr_utility.set_location(l_proc, 20);
102 --
103 -- Process Logic
104 --
105 begin
106 --
107 -- Start of API User Hook for the before hook of create_actual_premium
108 --
109 ben_actual_premium_bk1.create_actual_premium_b
110 (
111 p_name => p_name
112 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
113 ,p_uom => p_uom
114 ,p_rt_typ_cd => p_rt_typ_cd
115 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
116 ,p_val => p_val
117 ,p_mlt_cd => p_mlt_cd
118 ,p_prdct_cd => p_prdct_cd
119 ,p_rndg_cd => p_rndg_cd
120 ,p_rndg_rl => p_rndg_rl
121 ,p_val_calc_rl => p_val_calc_rl
122 ,p_prem_asnmt_cd => p_prem_asnmt_cd
123 ,p_prem_asnmt_lvl_cd => p_prem_asnmt_lvl_cd
124 ,p_actl_prem_typ_cd => p_actl_prem_typ_cd
125 ,p_prem_pyr_cd => p_prem_pyr_cd
126 ,p_cr_lkbk_val => p_cr_lkbk_val
127 ,p_cr_lkbk_uom => p_cr_lkbk_uom
128 ,p_cr_lkbk_crnt_py_only_flag => p_cr_lkbk_crnt_py_only_flag
129 ,p_prsptv_r_rtsptv_cd => p_prsptv_r_rtsptv_cd
130 ,p_upr_lmt_val => p_upr_lmt_val
131 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
132 ,p_lwr_lmt_val => p_lwr_lmt_val
133 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
134 ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
135 ,p_organization_id => p_organization_id
136 ,p_oipl_id => p_oipl_id
137 ,p_pl_id => p_pl_id
138 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
139 ,p_business_group_id => p_business_group_id
140 ,p_apr_attribute_category => p_apr_attribute_category
141 ,p_apr_attribute1 => p_apr_attribute1
142 ,p_apr_attribute2 => p_apr_attribute2
143 ,p_apr_attribute3 => p_apr_attribute3
144 ,p_apr_attribute4 => p_apr_attribute4
145 ,p_apr_attribute5 => p_apr_attribute5
146 ,p_apr_attribute6 => p_apr_attribute6
147 ,p_apr_attribute7 => p_apr_attribute7
148 ,p_apr_attribute8 => p_apr_attribute8
149 ,p_apr_attribute9 => p_apr_attribute9
150 ,p_apr_attribute10 => p_apr_attribute10
151 ,p_apr_attribute11 => p_apr_attribute11
152 ,p_apr_attribute12 => p_apr_attribute12
153 ,p_apr_attribute13 => p_apr_attribute13
154 ,p_apr_attribute14 => p_apr_attribute14
158 ,p_apr_attribute18 => p_apr_attribute18
155 ,p_apr_attribute15 => p_apr_attribute15
156 ,p_apr_attribute16 => p_apr_attribute16
157 ,p_apr_attribute17 => p_apr_attribute17
159 ,p_apr_attribute19 => p_apr_attribute19
160 ,p_apr_attribute20 => p_apr_attribute20
161 ,p_apr_attribute21 => p_apr_attribute21
162 ,p_apr_attribute22 => p_apr_attribute22
163 ,p_apr_attribute23 => p_apr_attribute23
164 ,p_apr_attribute24 => p_apr_attribute24
165 ,p_apr_attribute25 => p_apr_attribute25
166 ,p_apr_attribute26 => p_apr_attribute26
167 ,p_apr_attribute27 => p_apr_attribute27
168 ,p_apr_attribute28 => p_apr_attribute28
169 ,p_apr_attribute29 => p_apr_attribute29
170 ,p_apr_attribute30 => p_apr_attribute30
171 ,p_prtl_mo_det_mthd_cd => p_prtl_mo_det_mthd_cd
172 ,p_prtl_mo_det_mthd_rl => p_prtl_mo_det_mthd_rl
173 ,p_wsh_rl_dy_mo_num => p_wsh_rl_dy_mo_num
174 ,p_vrbl_rt_add_on_calc_rl => p_vrbl_rt_add_on_calc_rl
175 ,p_effective_date => trunc(p_effective_date)
176 );
177 exception
178 when hr_api.cannot_find_prog_unit then
179 hr_api.cannot_find_prog_unit_error
180 (
181 p_module_name => 'CREATE_actual_premium'
182 ,p_hook_type => 'BP'
183 );
184 --
185 -- End of API User Hook for the before hook of create_actual_premium
186 --
187 end;
188 --
189 ben_apr_ins.ins
190 (
191 p_actl_prem_id => l_actl_prem_id
192 ,p_effective_start_date => l_effective_start_date
193 ,p_effective_end_date => l_effective_end_date
194 ,p_name => p_name
195 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
196 ,p_uom => p_uom
197 ,p_rt_typ_cd => p_rt_typ_cd
198 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
199 ,p_val => p_val
200 ,p_mlt_cd => p_mlt_cd
201 ,p_prdct_cd => p_prdct_cd
202 ,p_rndg_cd => p_rndg_cd
203 ,p_rndg_rl => p_rndg_rl
204 ,p_val_calc_rl => p_val_calc_rl
205 ,p_prem_asnmt_cd => p_prem_asnmt_cd
206 ,p_prem_asnmt_lvl_cd => p_prem_asnmt_lvl_cd
207 ,p_actl_prem_typ_cd => p_actl_prem_typ_cd
208 ,p_prem_pyr_cd => p_prem_pyr_cd
209 ,p_cr_lkbk_val => p_cr_lkbk_val
210 ,p_cr_lkbk_uom => p_cr_lkbk_uom
211 ,p_cr_lkbk_crnt_py_only_flag => p_cr_lkbk_crnt_py_only_flag
212 ,p_prsptv_r_rtsptv_cd => p_prsptv_r_rtsptv_cd
213 ,p_upr_lmt_val => p_upr_lmt_val
214 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
215 ,p_lwr_lmt_val => p_lwr_lmt_val
216 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
217 ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
218 ,p_organization_id => p_organization_id
219 ,p_oipl_id => p_oipl_id
220 ,p_pl_id => p_pl_id
221 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
222 ,p_business_group_id => p_business_group_id
223 ,p_apr_attribute_category => p_apr_attribute_category
224 ,p_apr_attribute1 => p_apr_attribute1
225 ,p_apr_attribute2 => p_apr_attribute2
226 ,p_apr_attribute3 => p_apr_attribute3
227 ,p_apr_attribute4 => p_apr_attribute4
228 ,p_apr_attribute5 => p_apr_attribute5
229 ,p_apr_attribute6 => p_apr_attribute6
230 ,p_apr_attribute7 => p_apr_attribute7
231 ,p_apr_attribute8 => p_apr_attribute8
232 ,p_apr_attribute9 => p_apr_attribute9
233 ,p_apr_attribute10 => p_apr_attribute10
234 ,p_apr_attribute11 => p_apr_attribute11
235 ,p_apr_attribute12 => p_apr_attribute12
236 ,p_apr_attribute13 => p_apr_attribute13
237 ,p_apr_attribute14 => p_apr_attribute14
238 ,p_apr_attribute15 => p_apr_attribute15
239 ,p_apr_attribute16 => p_apr_attribute16
240 ,p_apr_attribute17 => p_apr_attribute17
241 ,p_apr_attribute18 => p_apr_attribute18
242 ,p_apr_attribute19 => p_apr_attribute19
243 ,p_apr_attribute20 => p_apr_attribute20
244 ,p_apr_attribute21 => p_apr_attribute21
245 ,p_apr_attribute22 => p_apr_attribute22
246 ,p_apr_attribute23 => p_apr_attribute23
247 ,p_apr_attribute24 => p_apr_attribute24
248 ,p_apr_attribute25 => p_apr_attribute25
249 ,p_apr_attribute26 => p_apr_attribute26
250 ,p_apr_attribute27 => p_apr_attribute27
251 ,p_apr_attribute28 => p_apr_attribute28
252 ,p_apr_attribute29 => p_apr_attribute29
253 ,p_apr_attribute30 => p_apr_attribute30
254 ,p_object_version_number => l_object_version_number
255 ,p_prtl_mo_det_mthd_cd => p_prtl_mo_det_mthd_cd
256 ,p_prtl_mo_det_mthd_rl => p_prtl_mo_det_mthd_rl
257 ,p_wsh_rl_dy_mo_num => p_wsh_rl_dy_mo_num
258 ,p_vrbl_rt_add_on_calc_rl => p_vrbl_rt_add_on_calc_rl
259 ,p_effective_date => trunc(p_effective_date)
260 );
261 --
262 begin
263 --
267 (
264 -- Start of API User Hook for the after hook of create_actual_premium
265 --
266 ben_actual_premium_bk1.create_actual_premium_a
268 p_actl_prem_id => l_actl_prem_id
269 ,p_effective_start_date => l_effective_start_date
270 ,p_effective_end_date => l_effective_end_date
271 ,p_name => p_name
272 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
273 ,p_uom => p_uom
274 ,p_rt_typ_cd => p_rt_typ_cd
275 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
276 ,p_val => p_val
277 ,p_mlt_cd => p_mlt_cd
278 ,p_prdct_cd => p_prdct_cd
279 ,p_rndg_cd => p_rndg_cd
280 ,p_rndg_rl => p_rndg_rl
281 ,p_val_calc_rl => p_val_calc_rl
282 ,p_prem_asnmt_cd => p_prem_asnmt_cd
283 ,p_prem_asnmt_lvl_cd => p_prem_asnmt_lvl_cd
284 ,p_actl_prem_typ_cd => p_actl_prem_typ_cd
285 ,p_prem_pyr_cd => p_prem_pyr_cd
286 ,p_cr_lkbk_val => p_cr_lkbk_val
287 ,p_cr_lkbk_uom => p_cr_lkbk_uom
288 ,p_cr_lkbk_crnt_py_only_flag => p_cr_lkbk_crnt_py_only_flag
289 ,p_prsptv_r_rtsptv_cd => p_prsptv_r_rtsptv_cd
290 ,p_upr_lmt_val => p_upr_lmt_val
291 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
292 ,p_lwr_lmt_val => p_lwr_lmt_val
293 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
294 ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
295 ,p_organization_id => p_organization_id
296 ,p_oipl_id => p_oipl_id
297 ,p_pl_id => p_pl_id
298 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
299 ,p_business_group_id => p_business_group_id
300 ,p_apr_attribute_category => p_apr_attribute_category
301 ,p_apr_attribute1 => p_apr_attribute1
302 ,p_apr_attribute2 => p_apr_attribute2
303 ,p_apr_attribute3 => p_apr_attribute3
304 ,p_apr_attribute4 => p_apr_attribute4
305 ,p_apr_attribute5 => p_apr_attribute5
306 ,p_apr_attribute6 => p_apr_attribute6
307 ,p_apr_attribute7 => p_apr_attribute7
308 ,p_apr_attribute8 => p_apr_attribute8
309 ,p_apr_attribute9 => p_apr_attribute9
310 ,p_apr_attribute10 => p_apr_attribute10
311 ,p_apr_attribute11 => p_apr_attribute11
312 ,p_apr_attribute12 => p_apr_attribute12
313 ,p_apr_attribute13 => p_apr_attribute13
314 ,p_apr_attribute14 => p_apr_attribute14
315 ,p_apr_attribute15 => p_apr_attribute15
316 ,p_apr_attribute16 => p_apr_attribute16
317 ,p_apr_attribute17 => p_apr_attribute17
318 ,p_apr_attribute18 => p_apr_attribute18
319 ,p_apr_attribute19 => p_apr_attribute19
320 ,p_apr_attribute20 => p_apr_attribute20
321 ,p_apr_attribute21 => p_apr_attribute21
322 ,p_apr_attribute22 => p_apr_attribute22
323 ,p_apr_attribute23 => p_apr_attribute23
324 ,p_apr_attribute24 => p_apr_attribute24
325 ,p_apr_attribute25 => p_apr_attribute25
326 ,p_apr_attribute26 => p_apr_attribute26
327 ,p_apr_attribute27 => p_apr_attribute27
328 ,p_apr_attribute28 => p_apr_attribute28
329 ,p_apr_attribute29 => p_apr_attribute29
330 ,p_apr_attribute30 => p_apr_attribute30
331 ,p_object_version_number => l_object_version_number
332 ,p_prtl_mo_det_mthd_cd => p_prtl_mo_det_mthd_cd
333 ,p_prtl_mo_det_mthd_rl => p_prtl_mo_det_mthd_rl
334 ,p_wsh_rl_dy_mo_num => p_wsh_rl_dy_mo_num
335 ,p_vrbl_rt_add_on_calc_rl => p_vrbl_rt_add_on_calc_rl
336 ,p_effective_date => trunc(p_effective_date)
337 );
338 exception
339 when hr_api.cannot_find_prog_unit then
340 hr_api.cannot_find_prog_unit_error
341 (p_module_name => 'CREATE_actual_premium'
342 ,p_hook_type => 'AP'
343 );
344 --
345 -- End of API User Hook for the after hook of create_actual_premium
346 --
347 end;
348 --
349 hr_utility.set_location(l_proc, 60);
350 --
351 -- When in validation only mode raise the Validate_Enabled exception
352 --
353 if p_validate then
354 raise hr_api.validate_enabled;
355 end if;
356 --
357 -- Set all output arguments
358 --
359 p_actl_prem_id := l_actl_prem_id;
360 p_effective_start_date := l_effective_start_date;
361 p_effective_end_date := l_effective_end_date;
362 p_object_version_number := l_object_version_number;
363 --
364 hr_utility.set_location(' Leaving:'||l_proc, 70);
365 --
366 exception
367 --
368 when hr_api.validate_enabled then
369 --
370 -- As the Validate_Enabled exception has been raised
371 -- we must rollback to the savepoint
372 --
373 ROLLBACK TO create_actual_premium;
374 --
375 -- Only set output warning arguments
376 -- (Any key or derived arguments must be set to null
377 -- when validation only mode is being used.)
378 --
382 p_object_version_number := null;
379 p_actl_prem_id := null;
380 p_effective_start_date := null;
381 p_effective_end_date := null;
383 hr_utility.set_location(' Leaving:'||l_proc, 80);
384 --
385 when others then
386 --
387 -- A validation or unexpected error has occured
388 --
389 ROLLBACK TO create_actual_premium;
390 /* Inserted for nocopy changes */
391 p_effective_start_date := null;
392 p_effective_end_date := null;
393 p_object_version_number := l_object_version_number;
394 raise;
395 --
396 end create_actual_premium;
397 -- ----------------------------------------------------------------------------
398 -- |------------------------< update_actual_premium >--- ------------------|
399 -- ----------------------------------------------------------------------------
400 --
401 procedure update_actual_premium
402 (p_validate in boolean default false
403 ,p_actl_prem_id in number
404 ,p_effective_start_date out nocopy date
405 ,p_effective_end_date out nocopy date
406 ,p_name in varchar2 default hr_api.g_varchar2
407 ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
408 ,p_uom in varchar2 default hr_api.g_varchar2
409 ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
410 ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
411 ,p_val in number default hr_api.g_number
412 ,p_mlt_cd in varchar2 default hr_api.g_varchar2
413 ,p_prdct_cd in varchar2 default hr_api.g_varchar2
414 ,p_rndg_cd in varchar2 default hr_api.g_varchar2
415 ,p_rndg_rl in number default hr_api.g_number
416 ,p_val_calc_rl in number default hr_api.g_number
417 ,p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2
418 ,p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2
419 ,p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2
420 ,p_prem_pyr_cd in varchar2 default hr_api.g_varchar2
421 ,p_cr_lkbk_val in number default hr_api.g_number
422 ,p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2
423 ,p_cr_lkbk_crnt_py_only_flag in varchar2 default hr_api.g_varchar2
424 ,p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2
425 ,p_upr_lmt_val in number default hr_api.g_number
426 ,p_upr_lmt_calc_rl in number default hr_api.g_number
427 ,p_lwr_lmt_val in number default hr_api.g_number
428 ,p_lwr_lmt_calc_rl in number default hr_api.g_number
429 ,p_cost_allocation_keyflex_id in number default hr_api.g_number
430 ,p_organization_id in number default hr_api.g_number
431 ,p_oipl_id in number default hr_api.g_number
432 ,p_pl_id in number default hr_api.g_number
433 ,p_comp_lvl_fctr_id in number default hr_api.g_number
434 ,p_business_group_id in number default hr_api.g_number
435 ,p_apr_attribute_category in varchar2 default hr_api.g_varchar2
436 ,p_apr_attribute1 in varchar2 default hr_api.g_varchar2
437 ,p_apr_attribute2 in varchar2 default hr_api.g_varchar2
438 ,p_apr_attribute3 in varchar2 default hr_api.g_varchar2
439 ,p_apr_attribute4 in varchar2 default hr_api.g_varchar2
440 ,p_apr_attribute5 in varchar2 default hr_api.g_varchar2
441 ,p_apr_attribute6 in varchar2 default hr_api.g_varchar2
442 ,p_apr_attribute7 in varchar2 default hr_api.g_varchar2
443 ,p_apr_attribute8 in varchar2 default hr_api.g_varchar2
444 ,p_apr_attribute9 in varchar2 default hr_api.g_varchar2
445 ,p_apr_attribute10 in varchar2 default hr_api.g_varchar2
446 ,p_apr_attribute11 in varchar2 default hr_api.g_varchar2
447 ,p_apr_attribute12 in varchar2 default hr_api.g_varchar2
448 ,p_apr_attribute13 in varchar2 default hr_api.g_varchar2
449 ,p_apr_attribute14 in varchar2 default hr_api.g_varchar2
450 ,p_apr_attribute15 in varchar2 default hr_api.g_varchar2
451 ,p_apr_attribute16 in varchar2 default hr_api.g_varchar2
452 ,p_apr_attribute17 in varchar2 default hr_api.g_varchar2
453 ,p_apr_attribute18 in varchar2 default hr_api.g_varchar2
454 ,p_apr_attribute19 in varchar2 default hr_api.g_varchar2
455 ,p_apr_attribute20 in varchar2 default hr_api.g_varchar2
456 ,p_apr_attribute21 in varchar2 default hr_api.g_varchar2
457 ,p_apr_attribute22 in varchar2 default hr_api.g_varchar2
458 ,p_apr_attribute23 in varchar2 default hr_api.g_varchar2
459 ,p_apr_attribute24 in varchar2 default hr_api.g_varchar2
460 ,p_apr_attribute25 in varchar2 default hr_api.g_varchar2
461 ,p_apr_attribute26 in varchar2 default hr_api.g_varchar2
462 ,p_apr_attribute27 in varchar2 default hr_api.g_varchar2
463 ,p_apr_attribute28 in varchar2 default hr_api.g_varchar2
464 ,p_apr_attribute29 in varchar2 default hr_api.g_varchar2
465 ,p_apr_attribute30 in varchar2 default hr_api.g_varchar2
466 ,p_object_version_number in out nocopy number
467 ,p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2
468 ,p_prtl_mo_det_mthd_rl in number default hr_api.g_number
469 ,p_wsh_rl_dy_mo_num in number default hr_api.g_number
473 ) is
470 ,p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number
471 ,p_effective_date in date
472 ,p_datetrack_mode in varchar2
474 --
475 -- Declare cursors and local variables
476 --
477 l_proc varchar2(72) := g_package||'update_actual_premium';
478 l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
479 l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
480 l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
481 l_in_object_version_number number := p_object_version_number ;
482
483 --
484 begin
485 --
486 hr_utility.set_location('Entering:'|| l_proc, 10);
487 --
488 -- Issue a savepoint if operating in validation only mode
489 --
490 savepoint update_actual_premium;
491 --
492 hr_utility.set_location(l_proc, 20);
493 --
494 -- Process Logic
495 --
496 l_object_version_number := p_object_version_number;
497 --
498 begin
499 --
500 -- Start of API User Hook for the before hook of update_actual_premium
501 --
502 ben_actual_premium_bk2.update_actual_premium_b
503 (
504 p_actl_prem_id => p_actl_prem_id
505 ,p_name => p_name
506 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
507 ,p_uom => p_uom
508 ,p_rt_typ_cd => p_rt_typ_cd
509 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
510 ,p_val => p_val
511 ,p_mlt_cd => p_mlt_cd
512 ,p_prdct_cd => p_prdct_cd
513 ,p_rndg_cd => p_rndg_cd
514 ,p_rndg_rl => p_rndg_rl
515 ,p_val_calc_rl => p_val_calc_rl
516 ,p_prem_asnmt_cd => p_prem_asnmt_cd
517 ,p_prem_asnmt_lvl_cd => p_prem_asnmt_lvl_cd
518 ,p_actl_prem_typ_cd => p_actl_prem_typ_cd
519 ,p_prem_pyr_cd => p_prem_pyr_cd
520 ,p_cr_lkbk_val => p_cr_lkbk_val
521 ,p_cr_lkbk_uom => p_cr_lkbk_uom
522 ,p_cr_lkbk_crnt_py_only_flag => p_cr_lkbk_crnt_py_only_flag
523 ,p_prsptv_r_rtsptv_cd => p_prsptv_r_rtsptv_cd
524 ,p_upr_lmt_val => p_upr_lmt_val
525 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
526 ,p_lwr_lmt_val => p_lwr_lmt_val
527 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
528 ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
529 ,p_organization_id => p_organization_id
530 ,p_oipl_id => p_oipl_id
531 ,p_pl_id => p_pl_id
532 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
533 ,p_business_group_id => p_business_group_id
534 ,p_apr_attribute_category => p_apr_attribute_category
535 ,p_apr_attribute1 => p_apr_attribute1
536 ,p_apr_attribute2 => p_apr_attribute2
537 ,p_apr_attribute3 => p_apr_attribute3
538 ,p_apr_attribute4 => p_apr_attribute4
539 ,p_apr_attribute5 => p_apr_attribute5
540 ,p_apr_attribute6 => p_apr_attribute6
541 ,p_apr_attribute7 => p_apr_attribute7
542 ,p_apr_attribute8 => p_apr_attribute8
543 ,p_apr_attribute9 => p_apr_attribute9
544 ,p_apr_attribute10 => p_apr_attribute10
545 ,p_apr_attribute11 => p_apr_attribute11
546 ,p_apr_attribute12 => p_apr_attribute12
547 ,p_apr_attribute13 => p_apr_attribute13
548 ,p_apr_attribute14 => p_apr_attribute14
549 ,p_apr_attribute15 => p_apr_attribute15
550 ,p_apr_attribute16 => p_apr_attribute16
551 ,p_apr_attribute17 => p_apr_attribute17
552 ,p_apr_attribute18 => p_apr_attribute18
553 ,p_apr_attribute19 => p_apr_attribute19
554 ,p_apr_attribute20 => p_apr_attribute20
555 ,p_apr_attribute21 => p_apr_attribute21
556 ,p_apr_attribute22 => p_apr_attribute22
557 ,p_apr_attribute23 => p_apr_attribute23
558 ,p_apr_attribute24 => p_apr_attribute24
559 ,p_apr_attribute25 => p_apr_attribute25
560 ,p_apr_attribute26 => p_apr_attribute26
561 ,p_apr_attribute27 => p_apr_attribute27
562 ,p_apr_attribute28 => p_apr_attribute28
563 ,p_apr_attribute29 => p_apr_attribute29
564 ,p_apr_attribute30 => p_apr_attribute30
565 ,p_object_version_number => p_object_version_number
566 ,p_prtl_mo_det_mthd_cd => p_prtl_mo_det_mthd_cd
567 ,p_prtl_mo_det_mthd_rl => p_prtl_mo_det_mthd_rl
568 ,p_wsh_rl_dy_mo_num => p_wsh_rl_dy_mo_num
569 ,p_vrbl_rt_add_on_calc_rl => p_vrbl_rt_add_on_calc_rl
570 ,p_effective_date => trunc(p_effective_date)
571 ,p_datetrack_mode => p_datetrack_mode
572 );
573 exception
574 when hr_api.cannot_find_prog_unit then
575 hr_api.cannot_find_prog_unit_error
576 (p_module_name => 'UPDATE_actual_premium'
577 ,p_hook_type => 'BP'
578 );
579 --
580 -- End of API User Hook for the before hook of update_actual_premium
581 --
582 end;
583 --
587 ,p_effective_start_date => l_effective_start_date
584 ben_apr_upd.upd
585 (
586 p_actl_prem_id => p_actl_prem_id
588 ,p_effective_end_date => l_effective_end_date
589 ,p_name => p_name
590 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
591 ,p_uom => p_uom
592 ,p_rt_typ_cd => p_rt_typ_cd
593 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
594 ,p_val => p_val
595 ,p_mlt_cd => p_mlt_cd
596 ,p_prdct_cd => p_prdct_cd
597 ,p_rndg_cd => p_rndg_cd
598 ,p_rndg_rl => p_rndg_rl
599 ,p_val_calc_rl => p_val_calc_rl
600 ,p_prem_asnmt_cd => p_prem_asnmt_cd
601 ,p_prem_asnmt_lvl_cd => p_prem_asnmt_lvl_cd
602 ,p_actl_prem_typ_cd => p_actl_prem_typ_cd
603 ,p_prem_pyr_cd => p_prem_pyr_cd
604 ,p_cr_lkbk_val => p_cr_lkbk_val
605 ,p_cr_lkbk_uom => p_cr_lkbk_uom
606 ,p_cr_lkbk_crnt_py_only_flag => p_cr_lkbk_crnt_py_only_flag
607 ,p_prsptv_r_rtsptv_cd => p_prsptv_r_rtsptv_cd
608 ,p_upr_lmt_val => p_upr_lmt_val
609 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
610 ,p_lwr_lmt_val => p_lwr_lmt_val
611 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
612 ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
613 ,p_organization_id => p_organization_id
614 ,p_oipl_id => p_oipl_id
615 ,p_pl_id => p_pl_id
616 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
617 ,p_business_group_id => p_business_group_id
618 ,p_apr_attribute_category => p_apr_attribute_category
619 ,p_apr_attribute1 => p_apr_attribute1
620 ,p_apr_attribute2 => p_apr_attribute2
621 ,p_apr_attribute3 => p_apr_attribute3
622 ,p_apr_attribute4 => p_apr_attribute4
623 ,p_apr_attribute5 => p_apr_attribute5
624 ,p_apr_attribute6 => p_apr_attribute6
625 ,p_apr_attribute7 => p_apr_attribute7
626 ,p_apr_attribute8 => p_apr_attribute8
627 ,p_apr_attribute9 => p_apr_attribute9
628 ,p_apr_attribute10 => p_apr_attribute10
629 ,p_apr_attribute11 => p_apr_attribute11
630 ,p_apr_attribute12 => p_apr_attribute12
631 ,p_apr_attribute13 => p_apr_attribute13
632 ,p_apr_attribute14 => p_apr_attribute14
633 ,p_apr_attribute15 => p_apr_attribute15
634 ,p_apr_attribute16 => p_apr_attribute16
635 ,p_apr_attribute17 => p_apr_attribute17
636 ,p_apr_attribute18 => p_apr_attribute18
637 ,p_apr_attribute19 => p_apr_attribute19
638 ,p_apr_attribute20 => p_apr_attribute20
639 ,p_apr_attribute21 => p_apr_attribute21
640 ,p_apr_attribute22 => p_apr_attribute22
641 ,p_apr_attribute23 => p_apr_attribute23
642 ,p_apr_attribute24 => p_apr_attribute24
643 ,p_apr_attribute25 => p_apr_attribute25
644 ,p_apr_attribute26 => p_apr_attribute26
645 ,p_apr_attribute27 => p_apr_attribute27
646 ,p_apr_attribute28 => p_apr_attribute28
647 ,p_apr_attribute29 => p_apr_attribute29
648 ,p_apr_attribute30 => p_apr_attribute30
649 ,p_object_version_number => l_object_version_number
650 ,p_prtl_mo_det_mthd_cd => p_prtl_mo_det_mthd_cd
651 ,p_prtl_mo_det_mthd_rl => p_prtl_mo_det_mthd_rl
652 ,p_wsh_rl_dy_mo_num => p_wsh_rl_dy_mo_num
653 ,p_vrbl_rt_add_on_calc_rl => p_vrbl_rt_add_on_calc_rl
654 ,p_effective_date => trunc(p_effective_date)
655 ,p_datetrack_mode => p_datetrack_mode
656 );
657 --
658 begin
659 --
660 -- Start of API User Hook for the after hook of update_actual_premium
661 --
662 ben_actual_premium_bk2.update_actual_premium_a
663 (
664 p_actl_prem_id => p_actl_prem_id
665 ,p_effective_start_date => l_effective_start_date
666 ,p_effective_end_date => l_effective_end_date
667 ,p_name => p_name
668 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
669 ,p_uom => p_uom
670 ,p_rt_typ_cd => p_rt_typ_cd
671 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
672 ,p_val => p_val
673 ,p_mlt_cd => p_mlt_cd
674 ,p_prdct_cd => p_prdct_cd
675 ,p_rndg_cd => p_rndg_cd
676 ,p_rndg_rl => p_rndg_rl
677 ,p_val_calc_rl => p_val_calc_rl
678 ,p_prem_asnmt_cd => p_prem_asnmt_cd
679 ,p_prem_asnmt_lvl_cd => p_prem_asnmt_lvl_cd
680 ,p_actl_prem_typ_cd => p_actl_prem_typ_cd
681 ,p_prem_pyr_cd => p_prem_pyr_cd
682 ,p_cr_lkbk_val => p_cr_lkbk_val
683 ,p_cr_lkbk_uom => p_cr_lkbk_uom
684 ,p_cr_lkbk_crnt_py_only_flag => p_cr_lkbk_crnt_py_only_flag
685 ,p_prsptv_r_rtsptv_cd => p_prsptv_r_rtsptv_cd
686 ,p_upr_lmt_val => p_upr_lmt_val
687 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
688 ,p_lwr_lmt_val => p_lwr_lmt_val
692 ,p_oipl_id => p_oipl_id
689 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
690 ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
691 ,p_organization_id => p_organization_id
693 ,p_pl_id => p_pl_id
694 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
695 ,p_business_group_id => p_business_group_id
696 ,p_apr_attribute_category => p_apr_attribute_category
697 ,p_apr_attribute1 => p_apr_attribute1
698 ,p_apr_attribute2 => p_apr_attribute2
699 ,p_apr_attribute3 => p_apr_attribute3
700 ,p_apr_attribute4 => p_apr_attribute4
701 ,p_apr_attribute5 => p_apr_attribute5
702 ,p_apr_attribute6 => p_apr_attribute6
703 ,p_apr_attribute7 => p_apr_attribute7
704 ,p_apr_attribute8 => p_apr_attribute8
705 ,p_apr_attribute9 => p_apr_attribute9
706 ,p_apr_attribute10 => p_apr_attribute10
707 ,p_apr_attribute11 => p_apr_attribute11
708 ,p_apr_attribute12 => p_apr_attribute12
709 ,p_apr_attribute13 => p_apr_attribute13
710 ,p_apr_attribute14 => p_apr_attribute14
711 ,p_apr_attribute15 => p_apr_attribute15
712 ,p_apr_attribute16 => p_apr_attribute16
713 ,p_apr_attribute17 => p_apr_attribute17
714 ,p_apr_attribute18 => p_apr_attribute18
715 ,p_apr_attribute19 => p_apr_attribute19
716 ,p_apr_attribute20 => p_apr_attribute20
717 ,p_apr_attribute21 => p_apr_attribute21
718 ,p_apr_attribute22 => p_apr_attribute22
719 ,p_apr_attribute23 => p_apr_attribute23
720 ,p_apr_attribute24 => p_apr_attribute24
721 ,p_apr_attribute25 => p_apr_attribute25
722 ,p_apr_attribute26 => p_apr_attribute26
723 ,p_apr_attribute27 => p_apr_attribute27
724 ,p_apr_attribute28 => p_apr_attribute28
725 ,p_apr_attribute29 => p_apr_attribute29
726 ,p_apr_attribute30 => p_apr_attribute30
727 ,p_object_version_number => l_object_version_number
728 ,p_prtl_mo_det_mthd_cd => p_prtl_mo_det_mthd_cd
729 ,p_prtl_mo_det_mthd_rl => p_prtl_mo_det_mthd_rl
730 ,p_wsh_rl_dy_mo_num => p_wsh_rl_dy_mo_num
731 ,p_vrbl_rt_add_on_calc_rl => p_vrbl_rt_add_on_calc_rl
732 ,p_effective_date => trunc(p_effective_date)
733 ,p_datetrack_mode => p_datetrack_mode
734 );
735 exception
736 when hr_api.cannot_find_prog_unit then
737 hr_api.cannot_find_prog_unit_error
738 (p_module_name => 'UPDATE_actual_premium'
739 ,p_hook_type => 'AP'
740 );
741 --
742 -- End of API User Hook for the after hook of update_actual_premium
743 --
744 end;
745 --
746 hr_utility.set_location(l_proc, 60);
747 --
748 -- When in validation only mode raise the Validate_Enabled exception
749 --
750 if p_validate then
751 raise hr_api.validate_enabled;
752 end if;
753 --
754 -- Set all output arguments
755 --
756 p_object_version_number := l_object_version_number;
757 p_effective_start_date := l_effective_start_date;
758 p_effective_end_date := l_effective_end_date;
759 --
760 hr_utility.set_location(' Leaving:'||l_proc, 70);
761 --
762 exception
763 --
764 when hr_api.validate_enabled then
765 --
766 -- As the Validate_Enabled exception has been raised
767 -- we must rollback to the savepoint
768 --
769 ROLLBACK TO update_actual_premium;
770 --
771 -- Only set output warning arguments
772 -- (Any key or derived arguments must be set to null
773 -- when validation only mode is being used.)
774 --
775 hr_utility.set_location(' Leaving:'||l_proc, 80);
776 --
777 when others then
778 --
779 -- A validation or unexpected error has occured
780 --
781 p_object_version_number := l_in_object_version_number ;
782 ROLLBACK TO update_actual_premium;
783 /* Inserted for nocopy changes */
784 p_effective_start_date := null;
785 p_effective_end_date := null;
786 raise;
787 --
788 end update_actual_premium;
789 -- ----------------------------------------------------------------------------
790 -- |------------------------< delete_actual_premium >----------------------|
791 -- ----------------------------------------------------------------------------
792 --
793 procedure delete_actual_premium
794 (p_validate in boolean default false
795 ,p_actl_prem_id in number
796 ,p_effective_start_date out nocopy date
797 ,p_effective_end_date out nocopy date
798 ,p_object_version_number in out nocopy number
799 ,p_effective_date in date
800 ,p_datetrack_mode in varchar2
801 ) is
802 --
803 -- Declare cursors and local variables
804 --
805 l_proc varchar2(72) := g_package||'update_actual_premium';
806 l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
807 l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
808 l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
809 --
810 l_in_object_version_number number := p_object_version_number ;
811 begin
812 --
816 --
813 hr_utility.set_location('Entering:'|| l_proc, 10);
814 --
815 -- Issue a savepoint if operating in validation only mode
817 savepoint delete_actual_premium;
818 --
819 hr_utility.set_location(l_proc, 20);
820 --
821 -- Process Logic
822 --
823 l_object_version_number := p_object_version_number;
824 --
825 --
826 begin
827 --
828 -- Start of API User Hook for the before hook of delete_actual_premium
829 --
830 ben_actual_premium_bk3.delete_actual_premium_b
831 (
832 p_actl_prem_id => p_actl_prem_id
833 ,p_object_version_number => p_object_version_number
834 ,p_effective_date => trunc(p_effective_date)
835 ,p_datetrack_mode => p_datetrack_mode
836 );
837 exception
838 when hr_api.cannot_find_prog_unit then
839 hr_api.cannot_find_prog_unit_error
840 (p_module_name => 'DELETE_actual_premium'
841 ,p_hook_type => 'BP'
842 );
843 --
844 -- End of API User Hook for the before hook of delete_actual_premium
845 --
846 end;
847 --
848 ben_apr_del.del
849 (
850 p_actl_prem_id => p_actl_prem_id
851 ,p_effective_start_date => l_effective_start_date
852 ,p_effective_end_date => l_effective_end_date
853 ,p_object_version_number => l_object_version_number
854 ,p_effective_date => p_effective_date
855 ,p_datetrack_mode => p_datetrack_mode
856 );
857 --
858 begin
859 --
860 -- Start of API User Hook for the after hook of delete_actual_premium
861 --
862 ben_actual_premium_bk3.delete_actual_premium_a
863 (
864 p_actl_prem_id => p_actl_prem_id
865 ,p_effective_start_date => l_effective_start_date
866 ,p_effective_end_date => l_effective_end_date
867 ,p_object_version_number => l_object_version_number
868 ,p_effective_date => trunc(p_effective_date)
869 ,p_datetrack_mode => p_datetrack_mode
870 );
871 exception
872 when hr_api.cannot_find_prog_unit then
873 hr_api.cannot_find_prog_unit_error
874 (p_module_name => 'DELETE_actual_premium'
875 ,p_hook_type => 'AP'
876 );
877 --
878 -- End of API User Hook for the after hook of delete_actual_premium
879 --
880 end;
881 --
882 hr_utility.set_location(l_proc, 60);
883 --
884 -- When in validation only mode raise the Validate_Enabled exception
885 --
886 if p_validate then
887 raise hr_api.validate_enabled;
888 end if;
889 --
890 hr_utility.set_location(' Leaving:'||l_proc, 70);
891 --
892 exception
893 --
894 when hr_api.validate_enabled then
895 --
896 -- As the Validate_Enabled exception has been raised
897 -- we must rollback to the savepoint
898 --
899 ROLLBACK TO delete_actual_premium;
900 --
901 -- Only set output warning arguments
902 -- (Any key or derived arguments must be set to null
903 -- when validation only mode is being used.)
904 --
905 p_effective_start_date := null;
906 p_effective_end_date := null;
907 --
908 when others then
909 --
910 -- A validation or unexpected error has occured
911 p_object_version_number := l_in_object_version_number ;
912 --
913 ROLLBACK TO delete_actual_premium;
914 /* Inserted for nocopy changes */
915 p_effective_start_date := null;
916 p_effective_end_date := null;
917 raise;
918 --
919 end delete_actual_premium;
920 --
921 -- ----------------------------------------------------------------------------
922 -- |-------------------------------< lck >------------------------------------|
923 -- ----------------------------------------------------------------------------
924 --
925 procedure lck
926 (
927 p_actl_prem_id in number
928 ,p_object_version_number in number
929 ,p_effective_date in date
930 ,p_datetrack_mode in varchar2
931 ,p_validation_start_date out nocopy date
932 ,p_validation_end_date out nocopy date
933 ) is
934 --
935 --
936 -- Declare cursors and local variables
937 --
938 l_proc varchar2(72) := g_package||'lck';
939 l_validation_start_date date;
940 l_validation_end_date date;
941 --
942 begin
943 --
944 hr_utility.set_location('Entering:'|| l_proc, 10);
945 --
946 ben_apr_shd.lck
947 (
948 p_actl_prem_id => p_actl_prem_id
949 ,p_validation_start_date => l_validation_start_date
950 ,p_validation_end_date => l_validation_end_date
951 ,p_object_version_number => p_object_version_number
952 ,p_effective_date => p_effective_date
953 ,p_datetrack_mode => p_datetrack_mode
954 );
955 --
956 hr_utility.set_location(' Leaving:'||l_proc, 70);
957 --
958 end lck;
959 --
960 end ben_actual_premium_api;