[Home] [Help]
PACKAGE BODY: APPS.BEN_VRBL_RATE_PROFILE_API
Source
1 Package Body ben_vrbl_rate_profile_api as
2 /* $Header: bevpfapi.pkb 115.15 2003/08/19 15:46:19 mmudigon ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_vrbl_rate_profile_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_vrbl_rate_profile >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_vrbl_rate_profile
13 (p_validate in boolean default false
14 ,p_vrbl_rt_prfl_id out nocopy number
15 ,p_effective_start_date out nocopy date
16 ,p_effective_end_date out nocopy date
17 ,p_pl_typ_opt_typ_id in number default null
18 ,p_pl_id in number default null
19 ,p_oipl_id in number default null
20 ,p_comp_lvl_fctr_id in number default null
21 ,p_business_group_id in number default null
22 ,p_acty_typ_cd in varchar2 default null
23 ,p_rt_typ_cd in varchar2 default null
24 ,p_bnft_rt_typ_cd in varchar2 default null
25 ,p_tx_typ_cd in varchar2 default null
26 ,p_vrbl_rt_trtmt_cd in varchar2 default null
27 ,p_acty_ref_perd_cd in varchar2 default null
28 ,p_mlt_cd in varchar2 default null
29 ,p_incrmnt_elcn_val in number default null
30 ,p_dflt_elcn_val in number default null
31 ,p_mx_elcn_val in number default null
32 ,p_mn_elcn_val in number default null
33 ,p_lwr_lmt_val in number default null
34 ,p_lwr_lmt_calc_rl in number default null
35 ,p_upr_lmt_val in number default null
36 ,p_upr_lmt_calc_rl in number default null
37 ,p_ultmt_upr_lmt in number default null
38 ,p_ultmt_lwr_lmt in number default null
39 ,p_ultmt_upr_lmt_calc_rl in number default null
40 ,p_ultmt_lwr_lmt_calc_rl in number default null
41 ,p_ann_mn_elcn_val in number default null
42 ,p_ann_mx_elcn_val in number default null
43 ,p_val in number default null
44 ,p_name in varchar2 default null
45 ,p_no_mn_elcn_val_dfnd_flag in varchar2 default 'N'
46 ,p_no_mx_elcn_val_dfnd_flag in varchar2 default 'N'
47 ,p_alwys_sum_all_cvg_flag in varchar2 default 'N'
48 ,p_alwys_cnt_all_prtts_flag in varchar2 default 'N'
49 ,p_val_calc_rl in number default null
50 ,p_vrbl_rt_prfl_stat_cd in varchar2 default null
51 ,p_vrbl_usg_cd in varchar2 default null
52 ,p_asmt_to_use_cd in varchar2 default null
53 ,p_rndg_cd in varchar2 default null
54 ,p_rndg_rl in number default null
55 ,p_rt_hrly_slrd_flag in varchar2 default 'N'
56 ,p_rt_pstl_cd_flag in varchar2 default 'N'
57 ,p_rt_lbr_mmbr_flag in varchar2 default 'N'
58 ,p_rt_lgl_enty_flag in varchar2 default 'N'
59 ,p_rt_benfts_grp_flag in varchar2 default 'N'
60 ,p_rt_wk_loc_flag in varchar2 default 'N'
61 ,p_rt_brgng_unit_flag in varchar2 default 'N'
62 ,p_rt_age_flag in varchar2 default 'N'
63 ,p_rt_los_flag in varchar2 default 'N'
64 ,p_rt_per_typ_flag in varchar2 default 'N'
65 ,p_rt_fl_tm_pt_tm_flag in varchar2 default 'N'
66 ,p_rt_ee_stat_flag in varchar2 default 'N'
67 ,p_rt_grd_flag in varchar2 default 'N'
68 ,p_rt_pct_fl_tm_flag in varchar2 default 'N'
69 ,p_rt_asnt_set_flag in varchar2 default 'N'
70 ,p_rt_hrs_wkd_flag in varchar2 default 'N'
71 ,p_rt_comp_lvl_flag in varchar2 default 'N'
72 ,p_rt_org_unit_flag in varchar2 default 'N'
73 ,p_rt_loa_rsn_flag in varchar2 default 'N'
74 ,p_rt_pyrl_flag in varchar2 default 'N'
75 ,p_rt_schedd_hrs_flag in varchar2 default 'N'
76 ,p_rt_py_bss_flag in varchar2 default 'N'
77 ,p_rt_prfl_rl_flag in varchar2 default 'N'
78 ,p_rt_cmbn_age_los_flag in varchar2 default 'N'
79 ,p_rt_prtt_pl_flag in varchar2 default 'N'
80 ,p_rt_svc_area_flag in varchar2 default 'N'
81 ,p_rt_ppl_grp_flag in varchar2 default 'N'
82 ,p_rt_dsbld_flag in varchar2 default 'N'
83 ,p_rt_hlth_cvg_flag in varchar2 default 'N'
84 ,p_rt_poe_flag in varchar2 default 'N'
85 ,p_rt_ttl_cvg_vol_flag in varchar2 default 'N'
86 ,p_rt_ttl_prtt_flag in varchar2 default 'N'
87 ,p_rt_gndr_flag in varchar2 default 'N'
88 ,p_rt_tbco_use_flag in varchar2 default 'N'
89 ,p_vpf_attribute_category in varchar2 default null
90 ,p_vpf_attribute1 in varchar2 default null
91 ,p_vpf_attribute2 in varchar2 default null
92 ,p_vpf_attribute3 in varchar2 default null
93 ,p_vpf_attribute4 in varchar2 default null
94 ,p_vpf_attribute5 in varchar2 default null
95 ,p_vpf_attribute6 in varchar2 default null
96 ,p_vpf_attribute7 in varchar2 default null
97 ,p_vpf_attribute8 in varchar2 default null
98 ,p_vpf_attribute9 in varchar2 default null
99 ,p_vpf_attribute10 in varchar2 default null
100 ,p_vpf_attribute11 in varchar2 default null
101 ,p_vpf_attribute12 in varchar2 default null
102 ,p_vpf_attribute13 in varchar2 default null
103 ,p_vpf_attribute14 in varchar2 default null
104 ,p_vpf_attribute15 in varchar2 default null
105 ,p_vpf_attribute16 in varchar2 default null
106 ,p_vpf_attribute17 in varchar2 default null
107 ,p_vpf_attribute18 in varchar2 default null
108 ,p_vpf_attribute19 in varchar2 default null
109 ,p_vpf_attribute20 in varchar2 default null
110 ,p_vpf_attribute21 in varchar2 default null
111 ,p_vpf_attribute22 in varchar2 default null
112 ,p_vpf_attribute23 in varchar2 default null
113 ,p_vpf_attribute24 in varchar2 default null
114 ,p_vpf_attribute25 in varchar2 default null
115 ,p_vpf_attribute26 in varchar2 default null
116 ,p_vpf_attribute27 in varchar2 default null
117 ,p_vpf_attribute28 in varchar2 default null
118 ,p_vpf_attribute29 in varchar2 default null
119 ,p_vpf_attribute30 in varchar2 default null
120 ,p_object_version_number out nocopy number
121 ,p_effective_date in date
122 ,p_rt_cntng_prtn_prfl_flag in varchar2 default null
123 ,p_rt_cbr_quald_bnf_flag in varchar2 default null
124 ,p_rt_optd_mdcr_flag in varchar2 default null
125 ,p_rt_lvg_rsn_flag in varchar2 default null
126 ,p_rt_pstn_flag in varchar2 default null
127 ,p_rt_comptncy_flag in varchar2 default null
128 ,p_rt_job_flag in varchar2 default null
129 ,p_rt_qual_titl_flag in varchar2 default null
130 ,p_rt_dpnt_cvrd_pl_flag in varchar2 default null
131 ,p_rt_dpnt_cvrd_plip_flag in varchar2 default null
132 ,p_rt_dpnt_cvrd_ptip_flag in varchar2 default null
133 ,p_rt_dpnt_cvrd_pgm_flag in varchar2 default null
134 ,p_rt_enrld_oipl_flag in varchar2 default null
135 ,p_rt_enrld_pl_flag in varchar2 default null
136 ,p_rt_enrld_plip_flag in varchar2 default null
137 ,p_rt_enrld_ptip_flag in varchar2 default null
138 ,p_rt_enrld_pgm_flag in varchar2 default null
139 ,p_rt_prtt_anthr_pl_flag in varchar2 default null
140 ,p_rt_othr_ptip_flag in varchar2 default null
141 ,p_rt_no_othr_cvg_flag in varchar2 default null
142 ,p_rt_dpnt_othr_ptip_flag in varchar2 default null
143 ,p_rt_qua_in_gr_flag in varchar2 default null
144 ,p_rt_perf_rtng_flag in varchar2 default null
145 ,p_rt_elig_prfl_flag in varchar2 default null
146 ) is
147 --
148 -- Declare cursors and local variables
149 --
150 l_vrbl_rt_prfl_id ben_vrbl_rt_prfl_f.vrbl_rt_prfl_id%TYPE;
151 l_effective_start_date ben_vrbl_rt_prfl_f.effective_start_date%TYPE;
152 l_effective_end_date ben_vrbl_rt_prfl_f.effective_end_date%TYPE;
153 l_proc varchar2(72) := g_package||'create_vrbl_rate_profile';
154 l_object_version_number ben_vrbl_rt_prfl_f.object_version_number%TYPE;
155 --
156 begin
157 --
158 hr_utility.set_location('Entering:'|| l_proc, 10);
159
160 hr_utility.set_location(' ins upr limit api ' || p_ultmt_upr_lmt,393);
161 hr_utility.set_location(' ins lwr limit api ' || p_ultmt_lwr_lmt,393);
162
163 --
164 -- Issue a savepoint if operating in validation only mode
165 --
166 savepoint create_vrbl_rate_profile;
167 --
168 hr_utility.set_location(l_proc, 20);
169 --
170 -- Process Logic
171 --
172 begin
173 --
174 -- Start of API User Hook for the before hook of create_vrbl_rate_profile
175 --
176 ben_vrbl_rate_profile_bk1.create_vrbl_rate_profile_b
177 (p_pl_typ_opt_typ_id => p_pl_typ_opt_typ_id
178 ,p_pl_id => p_pl_id
179 ,p_oipl_id => p_oipl_id
180 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
181 ,p_business_group_id => p_business_group_id
182 ,p_acty_typ_cd => p_acty_typ_cd
183 ,p_rt_typ_cd => p_rt_typ_cd
184 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
185 ,p_tx_typ_cd => p_tx_typ_cd
186 ,p_vrbl_rt_trtmt_cd => p_vrbl_rt_trtmt_cd
187 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
188 ,p_mlt_cd => p_mlt_cd
189 ,p_incrmnt_elcn_val => p_incrmnt_elcn_val
190 ,p_dflt_elcn_val => p_dflt_elcn_val
191 ,p_mx_elcn_val => p_mx_elcn_val
192 ,p_mn_elcn_val => p_mn_elcn_val
193 ,p_lwr_lmt_val => p_lwr_lmt_val
194 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
195 ,p_upr_lmt_val => p_upr_lmt_val
196 ,p_ultmt_upr_lmt => p_ultmt_upr_lmt
197 ,p_ultmt_lwr_lmt => p_ultmt_lwr_lmt
198 ,p_ultmt_upr_lmt_calc_rl => p_ultmt_upr_lmt_calc_rl
199 ,p_ultmt_lwr_lmt_calc_rl => p_ultmt_lwr_lmt_calc_rl
200 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
201 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
202 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
203 ,p_val => p_val
204 ,p_name => p_name
205 ,p_no_mn_elcn_val_dfnd_flag => p_no_mn_elcn_val_dfnd_flag
206 ,p_no_mx_elcn_val_dfnd_flag => p_no_mx_elcn_val_dfnd_flag
207 ,p_alwys_sum_all_cvg_flag => p_alwys_sum_all_cvg_flag
208 ,p_alwys_cnt_all_prtts_flag => p_alwys_cnt_all_prtts_flag
209 ,p_val_calc_rl => p_val_calc_rl
210 ,p_vrbl_rt_prfl_stat_cd => p_vrbl_rt_prfl_stat_cd
211 ,p_vrbl_usg_cd => p_vrbl_usg_cd
212 ,p_asmt_to_use_cd => p_asmt_to_use_cd
213 ,p_rndg_cd => p_rndg_cd
214 ,p_rndg_rl => p_rndg_rl
215 ,p_rt_hrly_slrd_flag => p_rt_hrly_slrd_flag
216 ,p_rt_pstl_cd_flag => p_rt_pstl_cd_flag
217 ,p_rt_lbr_mmbr_flag => p_rt_lbr_mmbr_flag
218 ,p_rt_lgl_enty_flag => p_rt_lgl_enty_flag
219 ,p_rt_benfts_grp_flag => p_rt_benfts_grp_flag
220 ,p_rt_wk_loc_flag => p_rt_wk_loc_flag
221 ,p_rt_brgng_unit_flag => p_rt_brgng_unit_flag
222 ,p_rt_age_flag => p_rt_age_flag
223 ,p_rt_los_flag => p_rt_los_flag
224 ,p_rt_per_typ_flag => p_rt_per_typ_flag
225 ,p_rt_fl_tm_pt_tm_flag => p_rt_fl_tm_pt_tm_flag
226 ,p_rt_ee_stat_flag => p_rt_ee_stat_flag
227 ,p_rt_grd_flag => p_rt_grd_flag
228 ,p_rt_pct_fl_tm_flag => p_rt_pct_fl_tm_flag
229 ,p_rt_asnt_set_flag => p_rt_asnt_set_flag
230 ,p_rt_hrs_wkd_flag => p_rt_hrs_wkd_flag
231 ,p_rt_comp_lvl_flag => p_rt_comp_lvl_flag
232 ,p_rt_org_unit_flag => p_rt_org_unit_flag
233 ,p_rt_loa_rsn_flag => p_rt_loa_rsn_flag
234 ,p_rt_pyrl_flag => p_rt_pyrl_flag
235 ,p_rt_schedd_hrs_flag => p_rt_schedd_hrs_flag
236 ,p_rt_py_bss_flag => p_rt_py_bss_flag
237 ,p_rt_prfl_rl_flag => p_rt_prfl_rl_flag
238 ,p_rt_cmbn_age_los_flag => p_rt_cmbn_age_los_flag
239 ,p_rt_prtt_pl_flag => p_rt_prtt_pl_flag
240 ,p_rt_svc_area_flag => p_rt_svc_area_flag
241 ,p_rt_ppl_grp_flag => p_rt_ppl_grp_flag
242 ,p_rt_dsbld_flag => p_rt_dsbld_flag
243 ,p_rt_hlth_cvg_flag => p_rt_hlth_cvg_flag
244 ,p_rt_poe_flag => p_rt_poe_flag
245 ,p_rt_ttl_cvg_vol_flag => p_rt_ttl_cvg_vol_flag
246 ,p_rt_ttl_prtt_flag => p_rt_ttl_prtt_flag
247 ,p_rt_gndr_flag => p_rt_gndr_flag
248 ,p_rt_tbco_use_flag => p_rt_tbco_use_flag
249 ,p_vpf_attribute_category => p_vpf_attribute_category
250 ,p_vpf_attribute1 => p_vpf_attribute1
251 ,p_vpf_attribute2 => p_vpf_attribute2
252 ,p_vpf_attribute3 => p_vpf_attribute3
253 ,p_vpf_attribute4 => p_vpf_attribute4
254 ,p_vpf_attribute5 => p_vpf_attribute5
255 ,p_vpf_attribute6 => p_vpf_attribute6
256 ,p_vpf_attribute7 => p_vpf_attribute7
257 ,p_vpf_attribute8 => p_vpf_attribute8
258 ,p_vpf_attribute9 => p_vpf_attribute9
259 ,p_vpf_attribute10 => p_vpf_attribute10
260 ,p_vpf_attribute11 => p_vpf_attribute11
261 ,p_vpf_attribute12 => p_vpf_attribute12
262 ,p_vpf_attribute13 => p_vpf_attribute13
263 ,p_vpf_attribute14 => p_vpf_attribute14
264 ,p_vpf_attribute15 => p_vpf_attribute15
265 ,p_vpf_attribute16 => p_vpf_attribute16
266 ,p_vpf_attribute17 => p_vpf_attribute17
267 ,p_vpf_attribute18 => p_vpf_attribute18
268 ,p_vpf_attribute19 => p_vpf_attribute19
269 ,p_vpf_attribute20 => p_vpf_attribute20
270 ,p_vpf_attribute21 => p_vpf_attribute21
271 ,p_vpf_attribute22 => p_vpf_attribute22
272 ,p_vpf_attribute23 => p_vpf_attribute23
273 ,p_vpf_attribute24 => p_vpf_attribute24
274 ,p_vpf_attribute25 => p_vpf_attribute25
275 ,p_vpf_attribute26 => p_vpf_attribute26
276 ,p_vpf_attribute27 => p_vpf_attribute27
277 ,p_vpf_attribute28 => p_vpf_attribute28
278 ,p_vpf_attribute29 => p_vpf_attribute29
279 ,p_vpf_attribute30 => p_vpf_attribute30
280 ,p_effective_date => trunc(p_effective_date)
281 ,p_rt_cntng_prtn_prfl_flag => p_rt_cntng_prtn_prfl_flag
282 ,p_rt_cbr_quald_bnf_flag => p_rt_cbr_quald_bnf_flag
283 ,p_rt_optd_mdcr_flag => p_rt_optd_mdcr_flag
284 ,p_rt_lvg_rsn_flag => p_rt_lvg_rsn_flag
285 ,p_rt_pstn_flag => p_rt_pstn_flag
286 ,p_rt_comptncy_flag => p_rt_comptncy_flag
287 ,p_rt_job_flag => p_rt_job_flag
288 ,p_rt_qual_titl_flag => p_rt_qual_titl_flag
289 ,p_rt_dpnt_cvrd_pl_flag => p_rt_dpnt_cvrd_pl_flag
290 ,p_rt_dpnt_cvrd_plip_flag => p_rt_dpnt_cvrd_plip_flag
291 ,p_rt_dpnt_cvrd_ptip_flag => p_rt_dpnt_cvrd_ptip_flag
292 ,p_rt_dpnt_cvrd_pgm_flag => p_rt_dpnt_cvrd_pgm_flag
293 ,p_rt_enrld_oipl_flag => p_rt_enrld_oipl_flag
294 ,p_rt_enrld_pl_flag => p_rt_enrld_pl_flag
295 ,p_rt_enrld_plip_flag => p_rt_enrld_plip_flag
296 ,p_rt_enrld_ptip_flag => p_rt_enrld_ptip_flag
297 ,p_rt_enrld_pgm_flag => p_rt_enrld_pgm_flag
298 ,p_rt_prtt_anthr_pl_flag => p_rt_prtt_anthr_pl_flag
299 ,p_rt_othr_ptip_flag => p_rt_othr_ptip_flag
300 ,p_rt_no_othr_cvg_flag => p_rt_no_othr_cvg_flag
301 ,p_rt_dpnt_othr_ptip_flag => p_rt_dpnt_othr_ptip_flag
302 ,p_rt_qua_in_gr_flag => p_rt_qua_in_gr_flag
303 ,p_rt_perf_rtng_flag => p_rt_perf_rtng_flag
304 ,p_rt_elig_prfl_flag => p_rt_elig_prfl_flag);
305 --
306 exception
307 --
308 when hr_api.cannot_find_prog_unit then
309 hr_api.cannot_find_prog_unit_error
310 (p_module_name => 'CREATE_vrbl_rate_profile'
311 ,p_hook_type => 'BP');
312 --
313 -- End of API User Hook for the before hook of create_vrbl_rate_profile
314 --
315 end;
316 --
317 ben_vpf_ins.ins
318 (p_vrbl_rt_prfl_id => l_vrbl_rt_prfl_id
319 ,p_effective_start_date => l_effective_start_date
320 ,p_effective_end_date => l_effective_end_date
321 ,p_pl_typ_opt_typ_id => p_pl_typ_opt_typ_id
322 ,p_pl_id => p_pl_id
323 ,p_oipl_id => p_oipl_id
324 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
325 ,p_business_group_id => p_business_group_id
326 ,p_acty_typ_cd => p_acty_typ_cd
327 ,p_rt_typ_cd => p_rt_typ_cd
328 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
329 ,p_tx_typ_cd => p_tx_typ_cd
330 ,p_vrbl_rt_trtmt_cd => p_vrbl_rt_trtmt_cd
331 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
332 ,p_mlt_cd => p_mlt_cd
333 ,p_incrmnt_elcn_val => p_incrmnt_elcn_val
334 ,p_dflt_elcn_val => p_dflt_elcn_val
335 ,p_mx_elcn_val => p_mx_elcn_val
336 ,p_mn_elcn_val => p_mn_elcn_val
337 ,p_lwr_lmt_val => p_lwr_lmt_val
338 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
339 ,p_upr_lmt_val => p_upr_lmt_val
340 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
341 ,p_ultmt_upr_lmt => p_ultmt_upr_lmt
342 ,p_ultmt_lwr_lmt => p_ultmt_lwr_lmt
343 ,p_ultmt_upr_lmt_calc_rl => p_ultmt_upr_lmt_calc_rl
344 ,p_ultmt_lwr_lmt_calc_rl => p_ultmt_lwr_lmt_calc_rl
345 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
346 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
347 ,p_val => p_val
348 ,p_name => p_name
349 ,p_no_mn_elcn_val_dfnd_flag => p_no_mn_elcn_val_dfnd_flag
350 ,p_no_mx_elcn_val_dfnd_flag => p_no_mx_elcn_val_dfnd_flag
351 ,p_alwys_sum_all_cvg_flag => p_alwys_sum_all_cvg_flag
352 ,p_alwys_cnt_all_prtts_flag => p_alwys_cnt_all_prtts_flag
353 ,p_val_calc_rl => p_val_calc_rl
354 ,p_vrbl_rt_prfl_stat_cd => p_vrbl_rt_prfl_stat_cd
355 ,p_vrbl_usg_cd => p_vrbl_usg_cd
356 ,p_asmt_to_use_cd => p_asmt_to_use_cd
357 ,p_rndg_cd => p_rndg_cd
358 ,p_rndg_rl => p_rndg_rl
359 ,p_rt_hrly_slrd_flag => p_rt_hrly_slrd_flag
360 ,p_rt_pstl_cd_flag => p_rt_pstl_cd_flag
361 ,p_rt_lbr_mmbr_flag => p_rt_lbr_mmbr_flag
362 ,p_rt_lgl_enty_flag => p_rt_lgl_enty_flag
363 ,p_rt_benfts_grp_flag => p_rt_benfts_grp_flag
364 ,p_rt_wk_loc_flag => p_rt_wk_loc_flag
365 ,p_rt_brgng_unit_flag => p_rt_brgng_unit_flag
366 ,p_rt_age_flag => p_rt_age_flag
367 ,p_rt_los_flag => p_rt_los_flag
368 ,p_rt_per_typ_flag => p_rt_per_typ_flag
369 ,p_rt_fl_tm_pt_tm_flag => p_rt_fl_tm_pt_tm_flag
370 ,p_rt_ee_stat_flag => p_rt_ee_stat_flag
371 ,p_rt_grd_flag => p_rt_grd_flag
372 ,p_rt_pct_fl_tm_flag => p_rt_pct_fl_tm_flag
373 ,p_rt_asnt_set_flag => p_rt_asnt_set_flag
374 ,p_rt_hrs_wkd_flag => p_rt_hrs_wkd_flag
375 ,p_rt_comp_lvl_flag => p_rt_comp_lvl_flag
376 ,p_rt_org_unit_flag => p_rt_org_unit_flag
377 ,p_rt_loa_rsn_flag => p_rt_loa_rsn_flag
378 ,p_rt_pyrl_flag => p_rt_pyrl_flag
379 ,p_rt_schedd_hrs_flag => p_rt_schedd_hrs_flag
380 ,p_rt_py_bss_flag => p_rt_py_bss_flag
381 ,p_rt_prfl_rl_flag => p_rt_prfl_rl_flag
382 ,p_rt_cmbn_age_los_flag => p_rt_cmbn_age_los_flag
383 ,p_rt_prtt_pl_flag => p_rt_prtt_pl_flag
384 ,p_rt_svc_area_flag => p_rt_svc_area_flag
385 ,p_rt_ppl_grp_flag => p_rt_ppl_grp_flag
386 ,p_rt_dsbld_flag => p_rt_dsbld_flag
387 ,p_rt_hlth_cvg_flag => p_rt_hlth_cvg_flag
388 ,p_rt_poe_flag => p_rt_poe_flag
389 ,p_rt_ttl_cvg_vol_flag => p_rt_ttl_cvg_vol_flag
390 ,p_rt_ttl_prtt_flag => p_rt_ttl_prtt_flag
391 ,p_rt_gndr_flag => p_rt_gndr_flag
392 ,p_rt_tbco_use_flag => p_rt_tbco_use_flag
393 ,p_vpf_attribute_category => p_vpf_attribute_category
394 ,p_vpf_attribute1 => p_vpf_attribute1
395 ,p_vpf_attribute2 => p_vpf_attribute2
396 ,p_vpf_attribute3 => p_vpf_attribute3
397 ,p_vpf_attribute4 => p_vpf_attribute4
398 ,p_vpf_attribute5 => p_vpf_attribute5
399 ,p_vpf_attribute6 => p_vpf_attribute6
400 ,p_vpf_attribute7 => p_vpf_attribute7
401 ,p_vpf_attribute8 => p_vpf_attribute8
402 ,p_vpf_attribute9 => p_vpf_attribute9
403 ,p_vpf_attribute10 => p_vpf_attribute10
404 ,p_vpf_attribute11 => p_vpf_attribute11
405 ,p_vpf_attribute12 => p_vpf_attribute12
406 ,p_vpf_attribute13 => p_vpf_attribute13
407 ,p_vpf_attribute14 => p_vpf_attribute14
408 ,p_vpf_attribute15 => p_vpf_attribute15
409 ,p_vpf_attribute16 => p_vpf_attribute16
410 ,p_vpf_attribute17 => p_vpf_attribute17
411 ,p_vpf_attribute18 => p_vpf_attribute18
412 ,p_vpf_attribute19 => p_vpf_attribute19
413 ,p_vpf_attribute20 => p_vpf_attribute20
414 ,p_vpf_attribute21 => p_vpf_attribute21
415 ,p_vpf_attribute22 => p_vpf_attribute22
416 ,p_vpf_attribute23 => p_vpf_attribute23
417 ,p_vpf_attribute24 => p_vpf_attribute24
418 ,p_vpf_attribute25 => p_vpf_attribute25
419 ,p_vpf_attribute26 => p_vpf_attribute26
420 ,p_vpf_attribute27 => p_vpf_attribute27
421 ,p_vpf_attribute28 => p_vpf_attribute28
422 ,p_vpf_attribute29 => p_vpf_attribute29
423 ,p_vpf_attribute30 => p_vpf_attribute30
424 ,p_object_version_number => l_object_version_number
425 ,p_effective_date => trunc(p_effective_date)
426 ,p_rt_cntng_prtn_prfl_flag => p_rt_cntng_prtn_prfl_flag
427 ,p_rt_cbr_quald_bnf_flag => p_rt_cbr_quald_bnf_flag
428 ,p_rt_optd_mdcr_flag => p_rt_optd_mdcr_flag
429 ,p_rt_lvg_rsn_flag => p_rt_lvg_rsn_flag
430 ,p_rt_pstn_flag => p_rt_pstn_flag
431 ,p_rt_comptncy_flag => p_rt_comptncy_flag
432 ,p_rt_job_flag => p_rt_job_flag
433 ,p_rt_qual_titl_flag => p_rt_qual_titl_flag
434 ,p_rt_dpnt_cvrd_pl_flag => p_rt_dpnt_cvrd_pl_flag
435 ,p_rt_dpnt_cvrd_plip_flag => p_rt_dpnt_cvrd_plip_flag
436 ,p_rt_dpnt_cvrd_ptip_flag => p_rt_dpnt_cvrd_ptip_flag
437 ,p_rt_dpnt_cvrd_pgm_flag => p_rt_dpnt_cvrd_pgm_flag
438 ,p_rt_enrld_oipl_flag => p_rt_enrld_oipl_flag
439 ,p_rt_enrld_pl_flag => p_rt_enrld_pl_flag
440 ,p_rt_enrld_plip_flag => p_rt_enrld_plip_flag
441 ,p_rt_enrld_ptip_flag => p_rt_enrld_ptip_flag
442 ,p_rt_enrld_pgm_flag => p_rt_enrld_pgm_flag
443 ,p_rt_prtt_anthr_pl_flag => p_rt_prtt_anthr_pl_flag
444 ,p_rt_othr_ptip_flag => p_rt_othr_ptip_flag
445 ,p_rt_no_othr_cvg_flag => p_rt_no_othr_cvg_flag
446 ,p_rt_dpnt_othr_ptip_flag => p_rt_dpnt_othr_ptip_flag
447 ,p_rt_qua_in_gr_flag => p_rt_qua_in_gr_flag
448 ,p_rt_perf_rtng_flag => p_rt_perf_rtng_flag
449 ,p_rt_elig_prfl_flag => p_rt_elig_prfl_flag);
450 --
451 begin
452 --
453 -- Start of API User Hook for the after hook of create_vrbl_rate_profile
454 --
455 ben_vrbl_rate_profile_bk1.create_vrbl_rate_profile_a
456 (p_vrbl_rt_prfl_id => l_vrbl_rt_prfl_id
457 ,p_effective_start_date => l_effective_start_date
458 ,p_effective_end_date => l_effective_end_date
459 ,p_pl_typ_opt_typ_id => p_pl_typ_opt_typ_id
460 ,p_pl_id => p_pl_id
461 ,p_oipl_id => p_oipl_id
462 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
463 ,p_business_group_id => p_business_group_id
464 ,p_acty_typ_cd => p_acty_typ_cd
465 ,p_rt_typ_cd => p_rt_typ_cd
466 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
467 ,p_tx_typ_cd => p_tx_typ_cd
468 ,p_vrbl_rt_trtmt_cd => p_vrbl_rt_trtmt_cd
469 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
470 ,p_mlt_cd => p_mlt_cd
471 ,p_incrmnt_elcn_val => p_incrmnt_elcn_val
472 ,p_dflt_elcn_val => p_dflt_elcn_val
473 ,p_mx_elcn_val => p_mx_elcn_val
474 ,p_mn_elcn_val => p_mn_elcn_val
475 ,p_lwr_lmt_val => p_lwr_lmt_val
476 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
477 ,p_upr_lmt_val => p_upr_lmt_val
478 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
479 ,p_ultmt_upr_lmt => p_ultmt_upr_lmt
480 ,p_ultmt_lwr_lmt => p_ultmt_lwr_lmt
481 ,p_ultmt_upr_lmt_calc_rl => p_ultmt_upr_lmt_calc_rl
482 ,p_ultmt_lwr_lmt_calc_rl => p_ultmt_lwr_lmt_calc_rl
483 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
484 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
485 ,p_val => p_val
486 ,p_name => p_name
487 ,p_no_mn_elcn_val_dfnd_flag => p_no_mn_elcn_val_dfnd_flag
488 ,p_no_mx_elcn_val_dfnd_flag => p_no_mx_elcn_val_dfnd_flag
489 ,p_alwys_sum_all_cvg_flag => p_alwys_sum_all_cvg_flag
490 ,p_alwys_cnt_all_prtts_flag => p_alwys_cnt_all_prtts_flag
491 ,p_val_calc_rl => p_val_calc_rl
492 ,p_vrbl_rt_prfl_stat_cd => p_vrbl_rt_prfl_stat_cd
493 ,p_vrbl_usg_cd => p_vrbl_usg_cd
494 ,p_asmt_to_use_cd => p_asmt_to_use_cd
495 ,p_rndg_cd => p_rndg_cd
496 ,p_rndg_rl => p_rndg_rl
497 ,p_rt_hrly_slrd_flag => p_rt_hrly_slrd_flag
498 ,p_rt_pstl_cd_flag => p_rt_pstl_cd_flag
499 ,p_rt_lbr_mmbr_flag => p_rt_lbr_mmbr_flag
500 ,p_rt_lgl_enty_flag => p_rt_lgl_enty_flag
501 ,p_rt_benfts_grp_flag => p_rt_benfts_grp_flag
502 ,p_rt_wk_loc_flag => p_rt_wk_loc_flag
503 ,p_rt_brgng_unit_flag => p_rt_brgng_unit_flag
504 ,p_rt_age_flag => p_rt_age_flag
505 ,p_rt_los_flag => p_rt_los_flag
506 ,p_rt_per_typ_flag => p_rt_per_typ_flag
507 ,p_rt_fl_tm_pt_tm_flag => p_rt_fl_tm_pt_tm_flag
508 ,p_rt_ee_stat_flag => p_rt_ee_stat_flag
509 ,p_rt_grd_flag => p_rt_grd_flag
510 ,p_rt_pct_fl_tm_flag => p_rt_pct_fl_tm_flag
511 ,p_rt_asnt_set_flag => p_rt_asnt_set_flag
512 ,p_rt_hrs_wkd_flag => p_rt_hrs_wkd_flag
513 ,p_rt_comp_lvl_flag => p_rt_comp_lvl_flag
514 ,p_rt_org_unit_flag => p_rt_org_unit_flag
515 ,p_rt_loa_rsn_flag => p_rt_loa_rsn_flag
516 ,p_rt_pyrl_flag => p_rt_pyrl_flag
517 ,p_rt_schedd_hrs_flag => p_rt_schedd_hrs_flag
518 ,p_rt_py_bss_flag => p_rt_py_bss_flag
519 ,p_rt_prfl_rl_flag => p_rt_prfl_rl_flag
520 ,p_rt_cmbn_age_los_flag => p_rt_cmbn_age_los_flag
521 ,p_rt_prtt_pl_flag => p_rt_prtt_pl_flag
522 ,p_rt_svc_area_flag => p_rt_svc_area_flag
523 ,p_rt_ppl_grp_flag => p_rt_ppl_grp_flag
524 ,p_rt_dsbld_flag => p_rt_dsbld_flag
525 ,p_rt_hlth_cvg_flag => p_rt_hlth_cvg_flag
526 ,p_rt_poe_flag => p_rt_poe_flag
527 ,p_rt_ttl_cvg_vol_flag => p_rt_ttl_cvg_vol_flag
528 ,p_rt_ttl_prtt_flag => p_rt_ttl_prtt_flag
529 ,p_rt_gndr_flag => p_rt_gndr_flag
530 ,p_rt_tbco_use_flag => p_rt_tbco_use_flag
531 ,p_vpf_attribute_category => p_vpf_attribute_category
532 ,p_vpf_attribute1 => p_vpf_attribute1
533 ,p_vpf_attribute2 => p_vpf_attribute2
534 ,p_vpf_attribute3 => p_vpf_attribute3
535 ,p_vpf_attribute4 => p_vpf_attribute4
536 ,p_vpf_attribute5 => p_vpf_attribute5
537 ,p_vpf_attribute6 => p_vpf_attribute6
538 ,p_vpf_attribute7 => p_vpf_attribute7
539 ,p_vpf_attribute8 => p_vpf_attribute8
540 ,p_vpf_attribute9 => p_vpf_attribute9
541 ,p_vpf_attribute10 => p_vpf_attribute10
542 ,p_vpf_attribute11 => p_vpf_attribute11
543 ,p_vpf_attribute12 => p_vpf_attribute12
544 ,p_vpf_attribute13 => p_vpf_attribute13
545 ,p_vpf_attribute14 => p_vpf_attribute14
546 ,p_vpf_attribute15 => p_vpf_attribute15
547 ,p_vpf_attribute16 => p_vpf_attribute16
548 ,p_vpf_attribute17 => p_vpf_attribute17
549 ,p_vpf_attribute18 => p_vpf_attribute18
550 ,p_vpf_attribute19 => p_vpf_attribute19
551 ,p_vpf_attribute20 => p_vpf_attribute20
552 ,p_vpf_attribute21 => p_vpf_attribute21
553 ,p_vpf_attribute22 => p_vpf_attribute22
554 ,p_vpf_attribute23 => p_vpf_attribute23
555 ,p_vpf_attribute24 => p_vpf_attribute24
556 ,p_vpf_attribute25 => p_vpf_attribute25
557 ,p_vpf_attribute26 => p_vpf_attribute26
558 ,p_vpf_attribute27 => p_vpf_attribute27
559 ,p_vpf_attribute28 => p_vpf_attribute28
560 ,p_vpf_attribute29 => p_vpf_attribute29
561 ,p_vpf_attribute30 => p_vpf_attribute30
562 ,p_object_version_number => l_object_version_number
563 ,p_effective_date => trunc(p_effective_date)
564 ,p_rt_cntng_prtn_prfl_flag => p_rt_cntng_prtn_prfl_flag
565 ,p_rt_cbr_quald_bnf_flag => p_rt_cbr_quald_bnf_flag
566 ,p_rt_optd_mdcr_flag => p_rt_optd_mdcr_flag
567 ,p_rt_lvg_rsn_flag => p_rt_lvg_rsn_flag
568 ,p_rt_pstn_flag => p_rt_pstn_flag
569 ,p_rt_comptncy_flag => p_rt_comptncy_flag
570 ,p_rt_job_flag => p_rt_job_flag
571 ,p_rt_qual_titl_flag => p_rt_qual_titl_flag
572 ,p_rt_dpnt_cvrd_pl_flag => p_rt_dpnt_cvrd_pl_flag
573 ,p_rt_dpnt_cvrd_plip_flag => p_rt_dpnt_cvrd_plip_flag
574 ,p_rt_dpnt_cvrd_ptip_flag => p_rt_dpnt_cvrd_ptip_flag
575 ,p_rt_dpnt_cvrd_pgm_flag => p_rt_dpnt_cvrd_pgm_flag
576 ,p_rt_enrld_oipl_flag => p_rt_enrld_oipl_flag
577 ,p_rt_enrld_pl_flag => p_rt_enrld_pl_flag
578 ,p_rt_enrld_plip_flag => p_rt_enrld_plip_flag
579 ,p_rt_enrld_ptip_flag => p_rt_enrld_ptip_flag
580 ,p_rt_enrld_pgm_flag => p_rt_enrld_pgm_flag
581 ,p_rt_prtt_anthr_pl_flag => p_rt_prtt_anthr_pl_flag
582 ,p_rt_othr_ptip_flag => p_rt_othr_ptip_flag
583 ,p_rt_no_othr_cvg_flag => p_rt_no_othr_cvg_flag
584 ,p_rt_dpnt_othr_ptip_flag => p_rt_dpnt_othr_ptip_flag
585 ,p_rt_qua_in_gr_flag => p_rt_qua_in_gr_flag
586 ,p_rt_perf_rtng_flag => p_rt_perf_rtng_flag
587 ,p_rt_elig_prfl_flag => p_rt_elig_prfl_flag);
588 --
589 exception
590 --
591 when hr_api.cannot_find_prog_unit then
592 hr_api.cannot_find_prog_unit_error
593 (p_module_name => 'CREATE_vrbl_rate_profile'
594 ,p_hook_type => 'AP');
595 --
596 -- End of API User Hook for the after hook of create_vrbl_rate_profile
597 --
598 end;
599 --
600 hr_utility.set_location(l_proc, 60);
601 --
602 -- When in validation only mode raise the Validate_Enabled exception
603 --
604 if p_validate then
605 raise hr_api.validate_enabled;
606 end if;
607 --
608 -- Set all output arguments
609 --
610 p_vrbl_rt_prfl_id := l_vrbl_rt_prfl_id;
611 p_effective_start_date := l_effective_start_date;
612 p_effective_end_date := l_effective_end_date;
613 p_object_version_number := l_object_version_number;
614 --
615 hr_utility.set_location(' Leaving:'||l_proc, 70);
616 --
617 exception
618 --
619 when hr_api.validate_enabled then
620 --
621 -- As the Validate_Enabled exception has been raised
622 -- we must rollback to the savepoint
623 --
624 ROLLBACK TO create_vrbl_rate_profile;
625 --
626 -- Only set output warning arguments
627 -- (Any key or derived arguments must be set to null
628 -- when validation only mode is being used.)
629 --
630 p_vrbl_rt_prfl_id := null;
631 p_effective_start_date := null;
632 p_effective_end_date := null;
633 p_object_version_number := null;
634 hr_utility.set_location(' Leaving:'||l_proc, 80);
635 --
636 when others then
637 --
638 -- A validation or unexpected error has occured
639 --
640 ROLLBACK TO create_vrbl_rate_profile;
641 raise;
642 --
643 end create_vrbl_rate_profile;
644 -- ----------------------------------------------------------------------------
645 -- |------------------------< update_vrbl_rate_profile >----------------------|
646 -- ----------------------------------------------------------------------------
647 --
648 procedure update_vrbl_rate_profile
649 (p_validate in boolean default false
650 ,p_vrbl_rt_prfl_id in number
651 ,p_effective_start_date out nocopy date
652 ,p_effective_end_date out nocopy date
653 ,p_pl_typ_opt_typ_id in number default hr_api.g_number
654 ,p_pl_id in number default hr_api.g_number
655 ,p_oipl_id in number default hr_api.g_number
656 ,p_comp_lvl_fctr_id in number default hr_api.g_number
657 ,p_business_group_id in number default hr_api.g_number
658 ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
659 ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
660 ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
661 ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
662 ,p_vrbl_rt_trtmt_cd in varchar2 default hr_api.g_varchar2
663 ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
664 ,p_mlt_cd in varchar2 default hr_api.g_varchar2
665 ,p_incrmnt_elcn_val in number default hr_api.g_number
666 ,p_dflt_elcn_val in number default hr_api.g_number
667 ,p_mx_elcn_val in number default hr_api.g_number
668 ,p_mn_elcn_val in number default hr_api.g_number
669 ,p_lwr_lmt_val in number default hr_api.g_number
670 ,p_lwr_lmt_calc_rl in number default hr_api.g_number
671 ,p_upr_lmt_val in number default hr_api.g_number
672 ,p_upr_lmt_calc_rl in number default hr_api.g_number
673 ,p_ultmt_upr_lmt in number default hr_api.g_number
674 ,p_ultmt_lwr_lmt in number default hr_api.g_number
675 ,p_ultmt_upr_lmt_calc_rl in number default hr_api.g_number
676 ,p_ultmt_lwr_lmt_calc_rl in number default hr_api.g_number
677 ,p_ann_mn_elcn_val in number default hr_api.g_number
678 ,p_ann_mx_elcn_val in number default hr_api.g_number
679 ,p_val in number default hr_api.g_number
680 ,p_name in varchar2 default hr_api.g_varchar2
681 ,p_no_mn_elcn_val_dfnd_flag in varchar2 default hr_api.g_varchar2
682 ,p_no_mx_elcn_val_dfnd_flag in varchar2 default hr_api.g_varchar2
683 ,p_alwys_sum_all_cvg_flag in varchar2 default hr_api.g_varchar2
684 ,p_alwys_cnt_all_prtts_flag in varchar2 default hr_api.g_varchar2
685 ,p_val_calc_rl in number default hr_api.g_number
686 ,p_vrbl_rt_prfl_stat_cd in varchar2 default hr_api.g_varchar2
687 ,p_vrbl_usg_cd in varchar2 default hr_api.g_varchar2
688 ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
689 ,p_rndg_cd in varchar2 default hr_api.g_varchar2
690 ,p_rndg_rl in number default hr_api.g_number
691 ,p_rt_hrly_slrd_flag in varchar2 default hr_api.g_varchar2
692 ,p_rt_pstl_cd_flag in varchar2 default hr_api.g_varchar2
693 ,p_rt_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2
694 ,p_rt_lgl_enty_flag in varchar2 default hr_api.g_varchar2
695 ,p_rt_benfts_grp_flag in varchar2 default hr_api.g_varchar2
696 ,p_rt_wk_loc_flag in varchar2 default hr_api.g_varchar2
697 ,p_rt_brgng_unit_flag in varchar2 default hr_api.g_varchar2
698 ,p_rt_age_flag in varchar2 default hr_api.g_varchar2
699 ,p_rt_los_flag in varchar2 default hr_api.g_varchar2
700 ,p_rt_per_typ_flag in varchar2 default hr_api.g_varchar2
701 ,p_rt_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2
702 ,p_rt_ee_stat_flag in varchar2 default hr_api.g_varchar2
703 ,p_rt_grd_flag in varchar2 default hr_api.g_varchar2
704 ,p_rt_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
705 ,p_rt_asnt_set_flag in varchar2 default hr_api.g_varchar2
706 ,p_rt_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
707 ,p_rt_comp_lvl_flag in varchar2 default hr_api.g_varchar2
708 ,p_rt_org_unit_flag in varchar2 default hr_api.g_varchar2
709 ,p_rt_loa_rsn_flag in varchar2 default hr_api.g_varchar2
710 ,p_rt_pyrl_flag in varchar2 default hr_api.g_varchar2
711 ,p_rt_schedd_hrs_flag in varchar2 default hr_api.g_varchar2
712 ,p_rt_py_bss_flag in varchar2 default hr_api.g_varchar2
713 ,p_rt_prfl_rl_flag in varchar2 default hr_api.g_varchar2
714 ,p_rt_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2
715 ,p_rt_prtt_pl_flag in varchar2 default hr_api.g_varchar2
716 ,p_rt_svc_area_flag in varchar2 default hr_api.g_varchar2
717 ,p_rt_ppl_grp_flag in varchar2 default hr_api.g_varchar2
718 ,p_rt_dsbld_flag in varchar2 default hr_api.g_varchar2
719 ,p_rt_hlth_cvg_flag in varchar2 default hr_api.g_varchar2
720 ,p_rt_poe_flag in varchar2 default hr_api.g_varchar2
721 ,p_rt_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2
722 ,p_rt_ttl_prtt_flag in varchar2 default hr_api.g_varchar2
723 ,p_rt_gndr_flag in varchar2 default hr_api.g_varchar2
724 ,p_rt_tbco_use_flag in varchar2 default hr_api.g_varchar2
725 ,p_vpf_attribute_category in varchar2 default hr_api.g_varchar2
726 ,p_vpf_attribute1 in varchar2 default hr_api.g_varchar2
727 ,p_vpf_attribute2 in varchar2 default hr_api.g_varchar2
728 ,p_vpf_attribute3 in varchar2 default hr_api.g_varchar2
729 ,p_vpf_attribute4 in varchar2 default hr_api.g_varchar2
730 ,p_vpf_attribute5 in varchar2 default hr_api.g_varchar2
731 ,p_vpf_attribute6 in varchar2 default hr_api.g_varchar2
732 ,p_vpf_attribute7 in varchar2 default hr_api.g_varchar2
733 ,p_vpf_attribute8 in varchar2 default hr_api.g_varchar2
734 ,p_vpf_attribute9 in varchar2 default hr_api.g_varchar2
735 ,p_vpf_attribute10 in varchar2 default hr_api.g_varchar2
736 ,p_vpf_attribute11 in varchar2 default hr_api.g_varchar2
737 ,p_vpf_attribute12 in varchar2 default hr_api.g_varchar2
738 ,p_vpf_attribute13 in varchar2 default hr_api.g_varchar2
739 ,p_vpf_attribute14 in varchar2 default hr_api.g_varchar2
740 ,p_vpf_attribute15 in varchar2 default hr_api.g_varchar2
741 ,p_vpf_attribute16 in varchar2 default hr_api.g_varchar2
742 ,p_vpf_attribute17 in varchar2 default hr_api.g_varchar2
743 ,p_vpf_attribute18 in varchar2 default hr_api.g_varchar2
744 ,p_vpf_attribute19 in varchar2 default hr_api.g_varchar2
745 ,p_vpf_attribute20 in varchar2 default hr_api.g_varchar2
746 ,p_vpf_attribute21 in varchar2 default hr_api.g_varchar2
747 ,p_vpf_attribute22 in varchar2 default hr_api.g_varchar2
748 ,p_vpf_attribute23 in varchar2 default hr_api.g_varchar2
749 ,p_vpf_attribute24 in varchar2 default hr_api.g_varchar2
750 ,p_vpf_attribute25 in varchar2 default hr_api.g_varchar2
751 ,p_vpf_attribute26 in varchar2 default hr_api.g_varchar2
752 ,p_vpf_attribute27 in varchar2 default hr_api.g_varchar2
753 ,p_vpf_attribute28 in varchar2 default hr_api.g_varchar2
754 ,p_vpf_attribute29 in varchar2 default hr_api.g_varchar2
755 ,p_vpf_attribute30 in varchar2 default hr_api.g_varchar2
756 ,p_object_version_number in out nocopy number
757 ,p_effective_date in date
758 ,p_datetrack_mode in varchar2
759 ,p_rt_cntng_prtn_prfl_flag in varchar2 default hr_api.g_varchar2
760 ,p_rt_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2
761 ,p_rt_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
762 ,p_rt_lvg_rsn_flag in varchar2 default hr_api.g_varchar2
763 ,p_rt_pstn_flag in varchar2 default hr_api.g_varchar2
764 ,p_rt_comptncy_flag in varchar2 default hr_api.g_varchar2
765 ,p_rt_job_flag in varchar2 default hr_api.g_varchar2
766 ,p_rt_qual_titl_flag in varchar2 default hr_api.g_varchar2
767 ,p_rt_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2
768 ,p_rt_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2
769 ,p_rt_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2
770 ,p_rt_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2
771 ,p_rt_enrld_oipl_flag in varchar2 default hr_api.g_varchar2
772 ,p_rt_enrld_pl_flag in varchar2 default hr_api.g_varchar2
773 ,p_rt_enrld_plip_flag in varchar2 default hr_api.g_varchar2
774 ,p_rt_enrld_ptip_flag in varchar2 default hr_api.g_varchar2
775 ,p_rt_enrld_pgm_flag in varchar2 default hr_api.g_varchar2
776 ,p_rt_prtt_anthr_pl_flag in varchar2 default hr_api.g_varchar2
777 ,p_rt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
778 ,p_rt_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2
779 ,p_rt_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
780 ,p_rt_qua_in_gr_flag in varchar2 default hr_api.g_varchar2
781 ,p_rt_perf_rtng_flag in varchar2 default hr_api.g_varchar2
782 ,p_rt_elig_prfl_flag in varchar2 default hr_api.g_varchar2
783 ) is
784 --
785 -- Declare cursors and local variables
786 --
787 l_proc varchar2(72) := g_package||'update_vrbl_rate_profile';
788 l_object_version_number ben_vrbl_rt_prfl_f.object_version_number%TYPE;
789 l_effective_start_date ben_vrbl_rt_prfl_f.effective_start_date%TYPE;
790 l_effective_end_date ben_vrbl_rt_prfl_f.effective_end_date%TYPE;
791 --
792 begin
793 --
794 hr_utility.set_location('Entering:'|| l_proc, 10);
795
796
797 hr_utility.set_location(' upd upr limit api ' || p_ultmt_upr_lmt_calc_rl,393);
798 hr_utility.set_location(' upd lwr limit api ' || p_ultmt_lwr_lmt_calc_rl,393);
799 --
800 -- Issue a savepoint if operating in validation only mode
801 --
802 savepoint update_vrbl_rate_profile;
803 --
804 hr_utility.set_location(l_proc, 20);
805 --
806 -- Process Logic
807 --
808 l_object_version_number := p_object_version_number;
809 --
810 begin
811 --
812 -- Start of API User Hook for the before hook of update_vrbl_rate_profile
813 --
814 ben_vrbl_rate_profile_bk2.update_vrbl_rate_profile_b
815 (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
816 ,p_pl_typ_opt_typ_id => p_pl_typ_opt_typ_id
817 ,p_pl_id => p_pl_id
818 ,p_oipl_id => p_oipl_id
819 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
820 ,p_business_group_id => p_business_group_id
821 ,p_acty_typ_cd => p_acty_typ_cd
822 ,p_rt_typ_cd => p_rt_typ_cd
823 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
824 ,p_tx_typ_cd => p_tx_typ_cd
825 ,p_vrbl_rt_trtmt_cd => p_vrbl_rt_trtmt_cd
826 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
827 ,p_mlt_cd => p_mlt_cd
828 ,p_incrmnt_elcn_val => p_incrmnt_elcn_val
829 ,p_dflt_elcn_val => p_dflt_elcn_val
830 ,p_mx_elcn_val => p_mx_elcn_val
831 ,p_mn_elcn_val => p_mn_elcn_val
832 ,p_lwr_lmt_val => p_lwr_lmt_val
833 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
834 ,p_upr_lmt_val => p_upr_lmt_val
835 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
836 ,p_ultmt_upr_lmt => p_ultmt_upr_lmt
837 ,p_ultmt_lwr_lmt => p_ultmt_lwr_lmt
838 ,p_ultmt_upr_lmt_calc_rl => p_ultmt_upr_lmt_calc_rl
839 ,p_ultmt_lwr_lmt_calc_rl => p_ultmt_lwr_lmt_calc_rl
840 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
841 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
842 ,p_val => p_val
843 ,p_name => p_name
844 ,p_no_mn_elcn_val_dfnd_flag => p_no_mn_elcn_val_dfnd_flag
845 ,p_no_mx_elcn_val_dfnd_flag => p_no_mx_elcn_val_dfnd_flag
846 ,p_alwys_sum_all_cvg_flag => p_alwys_sum_all_cvg_flag
847 ,p_alwys_cnt_all_prtts_flag => p_alwys_cnt_all_prtts_flag
848 ,p_val_calc_rl => p_val_calc_rl
849 ,p_vrbl_rt_prfl_stat_cd => p_vrbl_rt_prfl_stat_cd
850 ,p_vrbl_usg_cd => p_vrbl_usg_cd
851 ,p_asmt_to_use_cd => p_asmt_to_use_cd
852 ,p_rndg_cd => p_rndg_cd
853 ,p_rndg_rl => p_rndg_rl
854 ,p_rt_hrly_slrd_flag => p_rt_hrly_slrd_flag
855 ,p_rt_pstl_cd_flag => p_rt_pstl_cd_flag
856 ,p_rt_lbr_mmbr_flag => p_rt_lbr_mmbr_flag
857 ,p_rt_lgl_enty_flag => p_rt_lgl_enty_flag
858 ,p_rt_benfts_grp_flag => p_rt_benfts_grp_flag
859 ,p_rt_wk_loc_flag => p_rt_wk_loc_flag
860 ,p_rt_brgng_unit_flag => p_rt_brgng_unit_flag
861 ,p_rt_age_flag => p_rt_age_flag
862 ,p_rt_los_flag => p_rt_los_flag
863 ,p_rt_per_typ_flag => p_rt_per_typ_flag
864 ,p_rt_fl_tm_pt_tm_flag => p_rt_fl_tm_pt_tm_flag
865 ,p_rt_ee_stat_flag => p_rt_ee_stat_flag
866 ,p_rt_grd_flag => p_rt_grd_flag
867 ,p_rt_pct_fl_tm_flag => p_rt_pct_fl_tm_flag
868 ,p_rt_asnt_set_flag => p_rt_asnt_set_flag
869 ,p_rt_hrs_wkd_flag => p_rt_hrs_wkd_flag
870 ,p_rt_comp_lvl_flag => p_rt_comp_lvl_flag
871 ,p_rt_org_unit_flag => p_rt_org_unit_flag
872 ,p_rt_loa_rsn_flag => p_rt_loa_rsn_flag
873 ,p_rt_pyrl_flag => p_rt_pyrl_flag
874 ,p_rt_schedd_hrs_flag => p_rt_schedd_hrs_flag
875 ,p_rt_py_bss_flag => p_rt_py_bss_flag
876 ,p_rt_prfl_rl_flag => p_rt_prfl_rl_flag
877 ,p_rt_cmbn_age_los_flag => p_rt_cmbn_age_los_flag
878 ,p_rt_prtt_pl_flag => p_rt_prtt_pl_flag
879 ,p_rt_svc_area_flag => p_rt_svc_area_flag
880 ,p_rt_ppl_grp_flag => p_rt_ppl_grp_flag
881 ,p_rt_dsbld_flag => p_rt_dsbld_flag
882 ,p_rt_hlth_cvg_flag => p_rt_hlth_cvg_flag
883 ,p_rt_poe_flag => p_rt_poe_flag
884 ,p_rt_ttl_cvg_vol_flag => p_rt_ttl_cvg_vol_flag
885 ,p_rt_ttl_prtt_flag => p_rt_ttl_prtt_flag
886 ,p_rt_gndr_flag => p_rt_gndr_flag
887 ,p_rt_tbco_use_flag => p_rt_tbco_use_flag
888 ,p_vpf_attribute_category => p_vpf_attribute_category
889 ,p_vpf_attribute1 => p_vpf_attribute1
890 ,p_vpf_attribute2 => p_vpf_attribute2
891 ,p_vpf_attribute3 => p_vpf_attribute3
892 ,p_vpf_attribute4 => p_vpf_attribute4
893 ,p_vpf_attribute5 => p_vpf_attribute5
894 ,p_vpf_attribute6 => p_vpf_attribute6
895 ,p_vpf_attribute7 => p_vpf_attribute7
896 ,p_vpf_attribute8 => p_vpf_attribute8
897 ,p_vpf_attribute9 => p_vpf_attribute9
898 ,p_vpf_attribute10 => p_vpf_attribute10
899 ,p_vpf_attribute11 => p_vpf_attribute11
900 ,p_vpf_attribute12 => p_vpf_attribute12
901 ,p_vpf_attribute13 => p_vpf_attribute13
902 ,p_vpf_attribute14 => p_vpf_attribute14
903 ,p_vpf_attribute15 => p_vpf_attribute15
904 ,p_vpf_attribute16 => p_vpf_attribute16
905 ,p_vpf_attribute17 => p_vpf_attribute17
906 ,p_vpf_attribute18 => p_vpf_attribute18
907 ,p_vpf_attribute19 => p_vpf_attribute19
908 ,p_vpf_attribute20 => p_vpf_attribute20
909 ,p_vpf_attribute21 => p_vpf_attribute21
910 ,p_vpf_attribute22 => p_vpf_attribute22
911 ,p_vpf_attribute23 => p_vpf_attribute23
912 ,p_vpf_attribute24 => p_vpf_attribute24
913 ,p_vpf_attribute25 => p_vpf_attribute25
914 ,p_vpf_attribute26 => p_vpf_attribute26
915 ,p_vpf_attribute27 => p_vpf_attribute27
916 ,p_vpf_attribute28 => p_vpf_attribute28
917 ,p_vpf_attribute29 => p_vpf_attribute29
918 ,p_vpf_attribute30 => p_vpf_attribute30
919 ,p_object_version_number => p_object_version_number
920 ,p_effective_date => trunc(p_effective_date)
921 ,p_datetrack_mode => p_datetrack_mode
922 ,p_rt_cntng_prtn_prfl_flag => p_rt_cntng_prtn_prfl_flag
923 ,p_rt_cbr_quald_bnf_flag => p_rt_cbr_quald_bnf_flag
924 ,p_rt_optd_mdcr_flag => p_rt_optd_mdcr_flag
925 ,p_rt_lvg_rsn_flag => p_rt_lvg_rsn_flag
926 ,p_rt_pstn_flag => p_rt_pstn_flag
927 ,p_rt_comptncy_flag => p_rt_comptncy_flag
928 ,p_rt_job_flag => p_rt_job_flag
929 ,p_rt_qual_titl_flag => p_rt_qual_titl_flag
930 ,p_rt_dpnt_cvrd_pl_flag => p_rt_dpnt_cvrd_pl_flag
931 ,p_rt_dpnt_cvrd_plip_flag => p_rt_dpnt_cvrd_plip_flag
932 ,p_rt_dpnt_cvrd_ptip_flag => p_rt_dpnt_cvrd_ptip_flag
933 ,p_rt_dpnt_cvrd_pgm_flag => p_rt_dpnt_cvrd_pgm_flag
934 ,p_rt_enrld_oipl_flag => p_rt_enrld_oipl_flag
935 ,p_rt_enrld_pl_flag => p_rt_enrld_pl_flag
936 ,p_rt_enrld_plip_flag => p_rt_enrld_plip_flag
937 ,p_rt_enrld_ptip_flag => p_rt_enrld_ptip_flag
938 ,p_rt_enrld_pgm_flag => p_rt_enrld_pgm_flag
939 ,p_rt_prtt_anthr_pl_flag => p_rt_prtt_anthr_pl_flag
940 ,p_rt_othr_ptip_flag => p_rt_othr_ptip_flag
941 ,p_rt_no_othr_cvg_flag => p_rt_no_othr_cvg_flag
942 ,p_rt_dpnt_othr_ptip_flag => p_rt_dpnt_othr_ptip_flag
943 ,p_rt_qua_in_gr_flag => p_rt_qua_in_gr_flag
944 ,p_rt_perf_rtng_flag => p_rt_perf_rtng_flag
945 ,p_rt_elig_prfl_flag => p_rt_elig_prfl_flag
946 );
947 --
948 exception
949 --
950 when hr_api.cannot_find_prog_unit then
951 hr_api.cannot_find_prog_unit_error
952 (p_module_name => 'UPDATE_vrbl_rate_profile'
953 ,p_hook_type => 'BP');
954 --
955 -- End of API User Hook for the before hook of update_vrbl_rate_profile
956 --
957 end;
958 --
959 ben_vpf_upd.upd
960 (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
961 ,p_effective_start_date => l_effective_start_date
962 ,p_effective_end_date => l_effective_end_date
963 ,p_pl_typ_opt_typ_id => p_pl_typ_opt_typ_id
964 ,p_pl_id => p_pl_id
965 ,p_oipl_id => p_oipl_id
966 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
967 ,p_business_group_id => p_business_group_id
968 ,p_acty_typ_cd => p_acty_typ_cd
969 ,p_rt_typ_cd => p_rt_typ_cd
970 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
971 ,p_tx_typ_cd => p_tx_typ_cd
972 ,p_vrbl_rt_trtmt_cd => p_vrbl_rt_trtmt_cd
973 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
974 ,p_mlt_cd => p_mlt_cd
975 ,p_incrmnt_elcn_val => p_incrmnt_elcn_val
976 ,p_dflt_elcn_val => p_dflt_elcn_val
977 ,p_mx_elcn_val => p_mx_elcn_val
978 ,p_mn_elcn_val => p_mn_elcn_val
979 ,p_lwr_lmt_val => p_lwr_lmt_val
980 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
981 ,p_upr_lmt_val => p_upr_lmt_val
982 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
983 ,p_ultmt_upr_lmt => p_ultmt_upr_lmt
984 ,p_ultmt_lwr_lmt => p_ultmt_lwr_lmt
985 ,p_ultmt_upr_lmt_calc_rl => p_ultmt_upr_lmt_calc_rl
986 ,p_ultmt_lwr_lmt_calc_rl => p_ultmt_lwr_lmt_calc_rl
987 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
988 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
989 ,p_val => p_val
990 ,p_name => p_name
991 ,p_no_mn_elcn_val_dfnd_flag => p_no_mn_elcn_val_dfnd_flag
992 ,p_no_mx_elcn_val_dfnd_flag => p_no_mx_elcn_val_dfnd_flag
993 ,p_alwys_sum_all_cvg_flag => p_alwys_sum_all_cvg_flag
994 ,p_alwys_cnt_all_prtts_flag => p_alwys_cnt_all_prtts_flag
995 ,p_val_calc_rl => p_val_calc_rl
996 ,p_vrbl_rt_prfl_stat_cd => p_vrbl_rt_prfl_stat_cd
997 ,p_vrbl_usg_cd => p_vrbl_usg_cd
998 ,p_asmt_to_use_cd => p_asmt_to_use_cd
999 ,p_rndg_cd => p_rndg_cd
1000 ,p_rndg_rl => p_rndg_rl
1001 ,p_rt_hrly_slrd_flag => p_rt_hrly_slrd_flag
1002 ,p_rt_pstl_cd_flag => p_rt_pstl_cd_flag
1003 ,p_rt_lbr_mmbr_flag => p_rt_lbr_mmbr_flag
1004 ,p_rt_lgl_enty_flag => p_rt_lgl_enty_flag
1005 ,p_rt_benfts_grp_flag => p_rt_benfts_grp_flag
1006 ,p_rt_wk_loc_flag => p_rt_wk_loc_flag
1007 ,p_rt_brgng_unit_flag => p_rt_brgng_unit_flag
1008 ,p_rt_age_flag => p_rt_age_flag
1009 ,p_rt_los_flag => p_rt_los_flag
1010 ,p_rt_per_typ_flag => p_rt_per_typ_flag
1011 ,p_rt_fl_tm_pt_tm_flag => p_rt_fl_tm_pt_tm_flag
1012 ,p_rt_ee_stat_flag => p_rt_ee_stat_flag
1013 ,p_rt_grd_flag => p_rt_grd_flag
1014 ,p_rt_pct_fl_tm_flag => p_rt_pct_fl_tm_flag
1015 ,p_rt_asnt_set_flag => p_rt_asnt_set_flag
1016 ,p_rt_hrs_wkd_flag => p_rt_hrs_wkd_flag
1017 ,p_rt_comp_lvl_flag => p_rt_comp_lvl_flag
1018 ,p_rt_org_unit_flag => p_rt_org_unit_flag
1019 ,p_rt_loa_rsn_flag => p_rt_loa_rsn_flag
1020 ,p_rt_pyrl_flag => p_rt_pyrl_flag
1021 ,p_rt_schedd_hrs_flag => p_rt_schedd_hrs_flag
1022 ,p_rt_py_bss_flag => p_rt_py_bss_flag
1023 ,p_rt_prfl_rl_flag => p_rt_prfl_rl_flag
1024 ,p_rt_cmbn_age_los_flag => p_rt_cmbn_age_los_flag
1025 ,p_rt_prtt_pl_flag => p_rt_prtt_pl_flag
1026 ,p_rt_svc_area_flag => p_rt_svc_area_flag
1027 ,p_rt_ppl_grp_flag => p_rt_ppl_grp_flag
1028 ,p_rt_dsbld_flag => p_rt_dsbld_flag
1029 ,p_rt_hlth_cvg_flag => p_rt_hlth_cvg_flag
1030 ,p_rt_poe_flag => p_rt_poe_flag
1031 ,p_rt_ttl_cvg_vol_flag => p_rt_ttl_cvg_vol_flag
1032 ,p_rt_ttl_prtt_flag => p_rt_ttl_prtt_flag
1033 ,p_rt_gndr_flag => p_rt_gndr_flag
1034 ,p_rt_tbco_use_flag => p_rt_tbco_use_flag
1035 ,p_vpf_attribute_category => p_vpf_attribute_category
1036 ,p_vpf_attribute1 => p_vpf_attribute1
1037 ,p_vpf_attribute2 => p_vpf_attribute2
1038 ,p_vpf_attribute3 => p_vpf_attribute3
1039 ,p_vpf_attribute4 => p_vpf_attribute4
1040 ,p_vpf_attribute5 => p_vpf_attribute5
1041 ,p_vpf_attribute6 => p_vpf_attribute6
1042 ,p_vpf_attribute7 => p_vpf_attribute7
1043 ,p_vpf_attribute8 => p_vpf_attribute8
1044 ,p_vpf_attribute9 => p_vpf_attribute9
1045 ,p_vpf_attribute10 => p_vpf_attribute10
1046 ,p_vpf_attribute11 => p_vpf_attribute11
1047 ,p_vpf_attribute12 => p_vpf_attribute12
1048 ,p_vpf_attribute13 => p_vpf_attribute13
1049 ,p_vpf_attribute14 => p_vpf_attribute14
1050 ,p_vpf_attribute15 => p_vpf_attribute15
1051 ,p_vpf_attribute16 => p_vpf_attribute16
1052 ,p_vpf_attribute17 => p_vpf_attribute17
1053 ,p_vpf_attribute18 => p_vpf_attribute18
1054 ,p_vpf_attribute19 => p_vpf_attribute19
1055 ,p_vpf_attribute20 => p_vpf_attribute20
1056 ,p_vpf_attribute21 => p_vpf_attribute21
1057 ,p_vpf_attribute22 => p_vpf_attribute22
1058 ,p_vpf_attribute23 => p_vpf_attribute23
1059 ,p_vpf_attribute24 => p_vpf_attribute24
1060 ,p_vpf_attribute25 => p_vpf_attribute25
1061 ,p_vpf_attribute26 => p_vpf_attribute26
1062 ,p_vpf_attribute27 => p_vpf_attribute27
1063 ,p_vpf_attribute28 => p_vpf_attribute28
1064 ,p_vpf_attribute29 => p_vpf_attribute29
1065 ,p_vpf_attribute30 => p_vpf_attribute30
1066 ,p_object_version_number => l_object_version_number
1067 ,p_effective_date => trunc(p_effective_date)
1068 ,p_datetrack_mode => p_datetrack_mode
1069 ,p_rt_cntng_prtn_prfl_flag => p_rt_cntng_prtn_prfl_flag
1070 ,p_rt_cbr_quald_bnf_flag => p_rt_cbr_quald_bnf_flag
1071 ,p_rt_optd_mdcr_flag => p_rt_optd_mdcr_flag
1072 ,p_rt_lvg_rsn_flag => p_rt_lvg_rsn_flag
1073 ,p_rt_pstn_flag => p_rt_pstn_flag
1074 ,p_rt_comptncy_flag => p_rt_comptncy_flag
1075 ,p_rt_job_flag => p_rt_job_flag
1076 ,p_rt_qual_titl_flag => p_rt_qual_titl_flag
1077 ,p_rt_dpnt_cvrd_pl_flag => p_rt_dpnt_cvrd_pl_flag
1078 ,p_rt_dpnt_cvrd_plip_flag => p_rt_dpnt_cvrd_plip_flag
1079 ,p_rt_dpnt_cvrd_ptip_flag => p_rt_dpnt_cvrd_ptip_flag
1080 ,p_rt_dpnt_cvrd_pgm_flag => p_rt_dpnt_cvrd_pgm_flag
1081 ,p_rt_enrld_oipl_flag => p_rt_enrld_oipl_flag
1082 ,p_rt_enrld_pl_flag => p_rt_enrld_pl_flag
1083 ,p_rt_enrld_plip_flag => p_rt_enrld_plip_flag
1084 ,p_rt_enrld_ptip_flag => p_rt_enrld_ptip_flag
1085 ,p_rt_enrld_pgm_flag => p_rt_enrld_pgm_flag
1086 ,p_rt_prtt_anthr_pl_flag => p_rt_prtt_anthr_pl_flag
1087 ,p_rt_othr_ptip_flag => p_rt_othr_ptip_flag
1088 ,p_rt_no_othr_cvg_flag => p_rt_no_othr_cvg_flag
1089 ,p_rt_dpnt_othr_ptip_flag => p_rt_dpnt_othr_ptip_flag
1090 ,p_rt_qua_in_gr_flag => p_rt_qua_in_gr_flag
1091 ,p_rt_perf_rtng_flag => p_rt_perf_rtng_flag
1092 ,p_rt_elig_prfl_flag => p_rt_elig_prfl_flag);
1093 --
1094 begin
1095 --
1096 -- Start of API User Hook for the after hook of update_vrbl_rate_profile
1097 --
1098 ben_vrbl_rate_profile_bk2.update_vrbl_rate_profile_a
1099 (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1100 ,p_effective_start_date => l_effective_start_date
1101 ,p_effective_end_date => l_effective_end_date
1102 ,p_pl_typ_opt_typ_id => p_pl_typ_opt_typ_id
1103 ,p_pl_id => p_pl_id
1104 ,p_oipl_id => p_oipl_id
1105 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
1106 ,p_business_group_id => p_business_group_id
1107 ,p_acty_typ_cd => p_acty_typ_cd
1108 ,p_rt_typ_cd => p_rt_typ_cd
1109 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
1110 ,p_tx_typ_cd => p_tx_typ_cd
1111 ,p_vrbl_rt_trtmt_cd => p_vrbl_rt_trtmt_cd
1112 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
1113 ,p_mlt_cd => p_mlt_cd
1114 ,p_incrmnt_elcn_val => p_incrmnt_elcn_val
1115 ,p_dflt_elcn_val => p_dflt_elcn_val
1116 ,p_mx_elcn_val => p_mx_elcn_val
1117 ,p_mn_elcn_val => p_mn_elcn_val
1118 ,p_lwr_lmt_val => p_lwr_lmt_val
1119 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
1120 ,p_upr_lmt_val => p_upr_lmt_val
1121 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
1122 ,p_ultmt_upr_lmt => p_ultmt_upr_lmt
1123 ,p_ultmt_lwr_lmt => p_ultmt_lwr_lmt
1124 ,p_ultmt_upr_lmt_calc_rl => p_ultmt_upr_lmt_calc_rl
1125 ,p_ultmt_lwr_lmt_calc_rl => p_ultmt_lwr_lmt_calc_rl
1126 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
1127 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
1128 ,p_val => p_val
1129 ,p_name => p_name
1130 ,p_no_mn_elcn_val_dfnd_flag => p_no_mn_elcn_val_dfnd_flag
1131 ,p_no_mx_elcn_val_dfnd_flag => p_no_mx_elcn_val_dfnd_flag
1132 ,p_alwys_sum_all_cvg_flag => p_alwys_sum_all_cvg_flag
1133 ,p_alwys_cnt_all_prtts_flag => p_alwys_cnt_all_prtts_flag
1134 ,p_val_calc_rl => p_val_calc_rl
1135 ,p_vrbl_rt_prfl_stat_cd => p_vrbl_rt_prfl_stat_cd
1136 ,p_vrbl_usg_cd => p_vrbl_usg_cd
1137 ,p_asmt_to_use_cd => p_asmt_to_use_cd
1138 ,p_rndg_cd => p_rndg_cd
1139 ,p_rndg_rl => p_rndg_rl
1140 ,p_rt_hrly_slrd_flag => p_rt_hrly_slrd_flag
1141 ,p_rt_pstl_cd_flag => p_rt_pstl_cd_flag
1142 ,p_rt_lbr_mmbr_flag => p_rt_lbr_mmbr_flag
1143 ,p_rt_lgl_enty_flag => p_rt_lgl_enty_flag
1144 ,p_rt_benfts_grp_flag => p_rt_benfts_grp_flag
1145 ,p_rt_wk_loc_flag => p_rt_wk_loc_flag
1146 ,p_rt_brgng_unit_flag => p_rt_brgng_unit_flag
1147 ,p_rt_age_flag => p_rt_age_flag
1148 ,p_rt_los_flag => p_rt_los_flag
1149 ,p_rt_per_typ_flag => p_rt_per_typ_flag
1150 ,p_rt_fl_tm_pt_tm_flag => p_rt_fl_tm_pt_tm_flag
1151 ,p_rt_ee_stat_flag => p_rt_ee_stat_flag
1152 ,p_rt_grd_flag => p_rt_grd_flag
1153 ,p_rt_pct_fl_tm_flag => p_rt_pct_fl_tm_flag
1154 ,p_rt_asnt_set_flag => p_rt_asnt_set_flag
1155 ,p_rt_hrs_wkd_flag => p_rt_hrs_wkd_flag
1156 ,p_rt_comp_lvl_flag => p_rt_comp_lvl_flag
1157 ,p_rt_org_unit_flag => p_rt_org_unit_flag
1158 ,p_rt_loa_rsn_flag => p_rt_loa_rsn_flag
1159 ,p_rt_pyrl_flag => p_rt_pyrl_flag
1160 ,p_rt_schedd_hrs_flag => p_rt_schedd_hrs_flag
1161 ,p_rt_py_bss_flag => p_rt_py_bss_flag
1162 ,p_rt_prfl_rl_flag => p_rt_prfl_rl_flag
1163 ,p_rt_cmbn_age_los_flag => p_rt_cmbn_age_los_flag
1164 ,p_rt_prtt_pl_flag => p_rt_prtt_pl_flag
1165 ,p_rt_svc_area_flag => p_rt_svc_area_flag
1166 ,p_rt_ppl_grp_flag => p_rt_ppl_grp_flag
1167 ,p_rt_dsbld_flag => p_rt_dsbld_flag
1168 ,p_rt_hlth_cvg_flag => p_rt_hlth_cvg_flag
1169 ,p_rt_poe_flag => p_rt_poe_flag
1170 ,p_rt_ttl_cvg_vol_flag => p_rt_ttl_cvg_vol_flag
1171 ,p_rt_ttl_prtt_flag => p_rt_ttl_prtt_flag
1172 ,p_rt_gndr_flag => p_rt_gndr_flag
1173 ,p_rt_tbco_use_flag => p_rt_tbco_use_flag
1174 ,p_vpf_attribute_category => p_vpf_attribute_category
1175 ,p_vpf_attribute1 => p_vpf_attribute1
1176 ,p_vpf_attribute2 => p_vpf_attribute2
1177 ,p_vpf_attribute3 => p_vpf_attribute3
1178 ,p_vpf_attribute4 => p_vpf_attribute4
1179 ,p_vpf_attribute5 => p_vpf_attribute5
1180 ,p_vpf_attribute6 => p_vpf_attribute6
1181 ,p_vpf_attribute7 => p_vpf_attribute7
1182 ,p_vpf_attribute8 => p_vpf_attribute8
1183 ,p_vpf_attribute9 => p_vpf_attribute9
1184 ,p_vpf_attribute10 => p_vpf_attribute10
1185 ,p_vpf_attribute11 => p_vpf_attribute11
1186 ,p_vpf_attribute12 => p_vpf_attribute12
1187 ,p_vpf_attribute13 => p_vpf_attribute13
1188 ,p_vpf_attribute14 => p_vpf_attribute14
1189 ,p_vpf_attribute15 => p_vpf_attribute15
1190 ,p_vpf_attribute16 => p_vpf_attribute16
1191 ,p_vpf_attribute17 => p_vpf_attribute17
1192 ,p_vpf_attribute18 => p_vpf_attribute18
1193 ,p_vpf_attribute19 => p_vpf_attribute19
1194 ,p_vpf_attribute20 => p_vpf_attribute20
1195 ,p_vpf_attribute21 => p_vpf_attribute21
1196 ,p_vpf_attribute22 => p_vpf_attribute22
1197 ,p_vpf_attribute23 => p_vpf_attribute23
1198 ,p_vpf_attribute24 => p_vpf_attribute24
1199 ,p_vpf_attribute25 => p_vpf_attribute25
1200 ,p_vpf_attribute26 => p_vpf_attribute26
1201 ,p_vpf_attribute27 => p_vpf_attribute27
1202 ,p_vpf_attribute28 => p_vpf_attribute28
1203 ,p_vpf_attribute29 => p_vpf_attribute29
1204 ,p_vpf_attribute30 => p_vpf_attribute30
1205 ,p_object_version_number => l_object_version_number
1206 ,p_effective_date => trunc(p_effective_date)
1207 ,p_datetrack_mode => p_datetrack_mode
1208 ,p_rt_cntng_prtn_prfl_flag => p_rt_cntng_prtn_prfl_flag
1209 ,p_rt_cbr_quald_bnf_flag => p_rt_cbr_quald_bnf_flag
1210 ,p_rt_optd_mdcr_flag => p_rt_optd_mdcr_flag
1211 ,p_rt_lvg_rsn_flag => p_rt_lvg_rsn_flag
1212 ,p_rt_pstn_flag => p_rt_pstn_flag
1213 ,p_rt_comptncy_flag => p_rt_comptncy_flag
1214 ,p_rt_job_flag => p_rt_job_flag
1215 ,p_rt_qual_titl_flag => p_rt_qual_titl_flag
1216 ,p_rt_dpnt_cvrd_pl_flag => p_rt_dpnt_cvrd_pl_flag
1217 ,p_rt_dpnt_cvrd_plip_flag => p_rt_dpnt_cvrd_plip_flag
1218 ,p_rt_dpnt_cvrd_ptip_flag => p_rt_dpnt_cvrd_ptip_flag
1219 ,p_rt_dpnt_cvrd_pgm_flag => p_rt_dpnt_cvrd_pgm_flag
1220 ,p_rt_enrld_oipl_flag => p_rt_enrld_oipl_flag
1221 ,p_rt_enrld_pl_flag => p_rt_enrld_pl_flag
1222 ,p_rt_enrld_plip_flag => p_rt_enrld_plip_flag
1223 ,p_rt_enrld_ptip_flag => p_rt_enrld_ptip_flag
1224 ,p_rt_enrld_pgm_flag => p_rt_enrld_pgm_flag
1225 ,p_rt_prtt_anthr_pl_flag => p_rt_prtt_anthr_pl_flag
1226 ,p_rt_othr_ptip_flag => p_rt_othr_ptip_flag
1227 ,p_rt_no_othr_cvg_flag => p_rt_no_othr_cvg_flag
1228 ,p_rt_dpnt_othr_ptip_flag => p_rt_dpnt_othr_ptip_flag
1229 ,p_rt_qua_in_gr_flag => p_rt_qua_in_gr_flag
1230 ,p_rt_perf_rtng_flag => p_rt_perf_rtng_flag
1231 ,p_rt_elig_prfl_flag => p_rt_elig_prfl_flag);
1232 --
1233 exception
1234 --
1235 when hr_api.cannot_find_prog_unit then
1236 hr_api.cannot_find_prog_unit_error
1237 (p_module_name => 'UPDATE_vrbl_rate_profile'
1238 ,p_hook_type => 'AP');
1239 --
1240 -- End of API User Hook for the after hook of update_vrbl_rate_profile
1241 --
1242 end;
1243 --
1244 hr_utility.set_location(l_proc, 60);
1245 --
1246 -- When in validation only mode raise the Validate_Enabled exception
1247 --
1248 if p_validate then
1249 raise hr_api.validate_enabled;
1250 end if;
1251 --
1252 -- Set all output arguments
1253 --
1254 p_object_version_number := l_object_version_number;
1255 p_effective_start_date := l_effective_start_date;
1256 p_effective_end_date := l_effective_end_date;
1257 --
1258 hr_utility.set_location(' Leaving:'||l_proc, 70);
1259 --
1260 exception
1261 --
1262 when hr_api.validate_enabled then
1263 --
1264 -- As the Validate_Enabled exception has been raised
1265 -- we must rollback to the savepoint
1266 --
1267 ROLLBACK TO update_vrbl_rate_profile;
1268 --
1269 -- Only set output warning arguments
1270 -- (Any key or derived arguments must be set to null
1271 -- when validation only mode is being used.)
1272 --
1273 hr_utility.set_location(' Leaving:'||l_proc, 80);
1274 --
1275 when others then
1276 --
1277 -- A validation or unexpected error has occured
1278 --
1279 ROLLBACK TO update_vrbl_rate_profile;
1280 p_object_version_number := l_object_version_number;
1281 p_effective_start_date := null;
1282 p_effective_end_date := null;
1283 raise;
1284 --
1285 end update_vrbl_rate_profile;
1286 -- ----------------------------------------------------------------------------
1287 -- |------------------------< delete_vrbl_rate_profile >----------------------|
1288 -- ----------------------------------------------------------------------------
1289 --
1290 procedure delete_vrbl_rate_profile
1291 (p_validate in boolean default false
1292 ,p_vrbl_rt_prfl_id in number
1293 ,p_effective_start_date out nocopy date
1294 ,p_effective_end_date out nocopy date
1295 ,p_object_version_number in out nocopy number
1296 ,p_effective_date in date
1297 ,p_datetrack_mode in varchar2) is
1298 --
1299 -- Declare cursors and local variables
1300 --
1301 l_proc varchar2(72) := g_package||'update_vrbl_rate_profile';
1302 l_object_version_number ben_vrbl_rt_prfl_f.object_version_number%TYPE;
1303 l_effective_start_date ben_vrbl_rt_prfl_f.effective_start_date%TYPE;
1304 l_effective_end_date ben_vrbl_rt_prfl_f.effective_end_date%TYPE;
1305 --
1306 begin
1307 --
1308 hr_utility.set_location('Entering:'|| l_proc, 10);
1309 --
1310 -- Issue a savepoint if operating in validation only mode
1311 --
1312 savepoint delete_vrbl_rate_profile;
1313 --
1314 hr_utility.set_location(l_proc, 20);
1315 --
1316 -- Process Logic
1317 --
1318 l_object_version_number := p_object_version_number;
1319 --
1320 --
1321 begin
1322 --
1323 -- Start of API User Hook for the before hook of delete_vrbl_rate_profile
1324 --
1325 ben_vrbl_rate_profile_bk3.delete_vrbl_rate_profile_b
1326 (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1327 ,p_object_version_number => p_object_version_number
1328 ,p_effective_date => trunc(p_effective_date)
1329 ,p_datetrack_mode => p_datetrack_mode);
1330 --
1331 exception
1332 --
1333 when hr_api.cannot_find_prog_unit then
1334 hr_api.cannot_find_prog_unit_error
1335 (p_module_name => 'DELETE_vrbl_rate_profile'
1336 ,p_hook_type => 'BP');
1337 --
1338 -- End of API User Hook for the before hook of delete_vrbl_rate_profile
1339 --
1340 end;
1341 --
1342 ben_vpf_del.del
1343 (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1344 ,p_effective_start_date => l_effective_start_date
1345 ,p_effective_end_date => l_effective_end_date
1346 ,p_object_version_number => l_object_version_number
1347 ,p_effective_date => p_effective_date
1348 ,p_datetrack_mode => p_datetrack_mode);
1349 --
1350 begin
1351 --
1352 -- Start of API User Hook for the after hook of delete_vrbl_rate_profile
1353 --
1354 ben_vrbl_rate_profile_bk3.delete_vrbl_rate_profile_a
1355 (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1356 ,p_effective_start_date => l_effective_start_date
1357 ,p_effective_end_date => l_effective_end_date
1358 ,p_object_version_number => l_object_version_number
1359 ,p_effective_date => trunc(p_effective_date)
1360 ,p_datetrack_mode => p_datetrack_mode);
1361 --
1362 exception
1363 --
1364 when hr_api.cannot_find_prog_unit then
1365 hr_api.cannot_find_prog_unit_error
1366 (p_module_name => 'DELETE_vrbl_rate_profile'
1367 ,p_hook_type => 'AP');
1368 --
1369 -- End of API User Hook for the after hook of delete_vrbl_rate_profile
1370 --
1371 end;
1372 --
1373 hr_utility.set_location(l_proc, 60);
1374 --
1375 -- When in validation only mode raise the Validate_Enabled exception
1376 --
1377 if p_validate then
1378 raise hr_api.validate_enabled;
1379 end if;
1380 --
1381 hr_utility.set_location(' Leaving:'||l_proc, 70);
1382 --
1383 exception
1384 --
1385 when hr_api.validate_enabled then
1386 --
1387 -- As the Validate_Enabled exception has been raised
1388 -- we must rollback to the savepoint
1389 --
1390 ROLLBACK TO delete_vrbl_rate_profile;
1391 --
1392 -- Only set output warning arguments
1393 -- (Any key or derived arguments must be set to null
1394 -- when validation only mode is being used.)
1395 --
1396 p_effective_start_date := null;
1397 p_effective_end_date := null;
1398 --
1399 when others then
1400 --
1401 -- A validation or unexpected error has occured
1402 --
1403 ROLLBACK TO delete_vrbl_rate_profile;
1404 p_object_version_number := l_object_version_number;
1405 p_effective_start_date := null;
1406 p_effective_end_date := null;
1407 raise;
1408 --
1409 end delete_vrbl_rate_profile;
1410 --
1411 -- ----------------------------------------------------------------------------
1412 -- |-------------------------------< lck >------------------------------------|
1413 -- ----------------------------------------------------------------------------
1414 --
1415 procedure lck
1416 (p_vrbl_rt_prfl_id in number
1417 ,p_object_version_number in number
1418 ,p_effective_date in date
1419 ,p_datetrack_mode in varchar2
1420 ,p_validation_start_date out nocopy date
1421 ,p_validation_end_date out nocopy date) is
1422 --
1423 --
1424 -- Declare cursors and local variables
1425 --
1426 l_proc varchar2(72) := g_package||'lck';
1427 l_validation_start_date date;
1428 l_validation_end_date date;
1429 --
1430 begin
1431 --
1432 hr_utility.set_location('Entering:'|| l_proc, 10);
1433 --
1434 ben_vpf_shd.lck
1435 ( p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1436 ,p_validation_start_date => l_validation_start_date
1437 ,p_validation_end_date => l_validation_end_date
1438 ,p_object_version_number => p_object_version_number
1439 ,p_effective_date => p_effective_date
1440 ,p_datetrack_mode => p_datetrack_mode);
1441 --
1442 hr_utility.set_location(' Leaving:'||l_proc, 70);
1443 --
1444 end lck;
1445 --
1446 end ben_vrbl_rate_profile_api;