[Home] [Help]
PACKAGE BODY: APPS.BEN_ACTY_BASE_RATE_API
Source
1 Package Body ben_acty_base_rate_api as
2 /* $Header: beabrapi.pkb 120.3 2006/01/19 08:04:50 swjain noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_acty_base_rate_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_acty_base_rate >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_acty_base_rate
13 (p_validate in boolean default false
14 ,p_acty_base_rt_id out nocopy number
15 ,p_effective_start_date out nocopy date
16 ,p_effective_end_date out nocopy date
17 ,p_ordr_num in number default null
18 ,p_acty_typ_cd in varchar2 default null
19 ,p_sub_acty_typ_cd in varchar2 default null
20 ,p_name in varchar2 default null
21 ,p_rt_typ_cd in varchar2 default null
22 ,p_bnft_rt_typ_cd in varchar2 default null
23 ,p_tx_typ_cd in varchar2 default null
24 ,p_use_to_calc_net_flx_cr_flag in varchar2 default 'N'
25 ,p_asn_on_enrt_flag in varchar2 default 'N'
26 ,p_abv_mx_elcn_val_alwd_flag in varchar2 default 'N'
27 ,p_blw_mn_elcn_alwd_flag in varchar2 default 'N'
28 ,p_dsply_on_enrt_flag in varchar2 default 'N'
29 ,p_parnt_chld_cd in varchar2 default null
30 ,p_use_calc_acty_bs_rt_flag in varchar2 default 'Y'
31 ,p_uses_ded_sched_flag in varchar2 default 'N'
32 ,p_uses_varbl_rt_flag in varchar2 default 'N'
33 ,p_vstg_sched_apls_flag in varchar2 default 'N'
34 ,p_rt_mlt_cd in varchar2 default null
35 ,p_proc_each_pp_dflt_flag in varchar2 default 'N'
36 ,p_prdct_flx_cr_when_elig_flag in varchar2 default 'N'
37 ,p_no_std_rt_used_flag in varchar2 default 'N'
38 ,p_rcrrg_cd in varchar2 default null
39 ,p_mn_elcn_val in number default null
40 ,p_mx_elcn_val in number default null
41 ,p_lwr_lmt_val in number default null
42 ,p_lwr_lmt_calc_rl in number default null
43 ,p_upr_lmt_val in number default null
44 ,p_upr_lmt_calc_rl in number default null
45 ,p_ptd_comp_lvl_fctr_id in number default null
46 ,p_clm_comp_lvl_fctr_id in number default null
47 ,p_entr_ann_val_flag in varchar2 default 'N'
48 ,p_ann_mn_elcn_val in number default null
49 ,p_ann_mx_elcn_val in number default null
50 ,p_wsh_rl_dy_mo_num in number default null
51 ,p_uses_pymt_sched_flag in varchar2 default 'N'
52 ,p_nnmntry_uom in varchar2 default null
53 ,p_val in number default null
54 ,p_incrmt_elcn_val in number default null
55 ,p_rndg_cd in varchar2 default null
56 ,p_val_ovrid_alwd_flag in varchar2 default 'N'
57 ,p_prtl_mo_det_mthd_cd in varchar2 default null
58 ,p_acty_base_rt_stat_cd in varchar2 default null
59 ,p_procg_src_cd in varchar2 default null
60 ,p_dflt_val in number default null
61 ,p_dflt_flag in varchar2 default 'N'
62 ,p_frgn_erg_ded_typ_cd in varchar2 default null
63 ,p_frgn_erg_ded_name in varchar2 default null
64 ,p_frgn_erg_ded_ident in varchar2 default null
65 ,p_no_mx_elcn_val_dfnd_flag in varchar2 default 'N'
66 ,p_prtl_mo_det_mthd_rl in number default null
67 ,p_entr_val_at_enrt_flag in varchar2 default 'N'
68 ,p_prtl_mo_eff_dt_det_rl in number default null
69 ,p_rndg_rl in number default null
70 ,p_val_calc_rl in number default null
71 ,p_no_mn_elcn_val_dfnd_flag in varchar2 default 'N'
72 ,p_prtl_mo_eff_dt_det_cd in varchar2 default null
73 ,p_only_one_bal_typ_alwd_flag in varchar2 default 'N'
74 ,p_rt_usg_cd in varchar2 default null
75 ,p_prort_mn_ann_elcn_val_cd in varchar2 default null
76 ,p_prort_mn_ann_elcn_val_rl in number default null
77 ,p_prort_mx_ann_elcn_val_cd in varchar2 default null
78 ,p_prort_mx_ann_elcn_val_rl in number default null
79 ,p_one_ann_pymt_cd in varchar2 default null
80 ,p_det_pl_ytd_cntrs_cd in varchar2 default null
81 ,p_asmt_to_use_cd in varchar2 default null
82 ,p_ele_rqd_flag in varchar2 default 'Y'
83 ,p_subj_to_imptd_incm_flag in varchar2 default 'N'
84 ,p_element_type_id in number default null
85 ,p_input_value_id in number default null
86 ,p_input_va_calc_rl in number default null
87 ,p_comp_lvl_fctr_id in number default null
88 ,p_parnt_acty_base_rt_id in number default null
89 ,p_pgm_id in number default null
90 ,p_pl_id in number default null
91 ,p_oipl_id in number default null
92 ,p_opt_id in number default null
93 ,p_oiplip_id in number default null
94 ,p_plip_id in number default null
95 ,p_ptip_id in number default null
96 ,p_cmbn_plip_id in number default null
97 ,p_cmbn_ptip_id in number default null
98 ,p_cmbn_ptip_opt_id in number default null
99 ,p_vstg_for_acty_rt_id in number default null
100 ,p_actl_prem_id in number default null
101 ,p_TTL_COMP_LVL_FCTR_ID in number default null
102 ,p_COST_ALLOCATION_KEYFLEX_ID in number default null
103 ,p_ALWS_CHG_CD in varchar2 default null
104 ,p_ele_entry_val_cd in varchar2 default null
105 ,p_pay_rate_grade_rule_id in number default null
106 ,p_rate_periodization_cd in varchar2 default null
107 ,p_rate_periodization_rl in number default null
108 ,p_mn_mx_elcn_rl in number default null
109 ,p_mapping_table_name in varchar2 default null
110 ,p_mapping_table_pk_id in number default null
111 ,p_business_group_id in number default null
112 ,p_context_pgm_id in number default null
113 ,p_context_pl_id in number default null
114 ,p_context_opt_id in number default null
115 ,p_element_det_rl in number default null
116 ,p_currency_det_cd in varchar2 default null
117 ,p_abr_attribute_category in varchar2 default null
118 ,p_abr_attribute1 in varchar2 default null
119 ,p_abr_attribute2 in varchar2 default null
120 ,p_abr_attribute3 in varchar2 default null
121 ,p_abr_attribute4 in varchar2 default null
122 ,p_abr_attribute5 in varchar2 default null
123 ,p_abr_attribute6 in varchar2 default null
124 ,p_abr_attribute7 in varchar2 default null
125 ,p_abr_attribute8 in varchar2 default null
126 ,p_abr_attribute9 in varchar2 default null
127 ,p_abr_attribute10 in varchar2 default null
128 ,p_abr_attribute11 in varchar2 default null
129 ,p_abr_attribute12 in varchar2 default null
130 ,p_abr_attribute13 in varchar2 default null
131 ,p_abr_attribute14 in varchar2 default null
132 ,p_abr_attribute15 in varchar2 default null
133 ,p_abr_attribute16 in varchar2 default null
134 ,p_abr_attribute17 in varchar2 default null
135 ,p_abr_attribute18 in varchar2 default null
136 ,p_abr_attribute19 in varchar2 default null
137 ,p_abr_attribute20 in varchar2 default null
138 ,p_abr_attribute21 in varchar2 default null
139 ,p_abr_attribute22 in varchar2 default null
140 ,p_abr_attribute23 in varchar2 default null
141 ,p_abr_attribute24 in varchar2 default null
142 ,p_abr_attribute25 in varchar2 default null
143 ,p_abr_attribute26 in varchar2 default null
144 ,p_abr_attribute27 in varchar2 default null
145 ,p_abr_attribute28 in varchar2 default null
146 ,p_abr_attribute29 in varchar2 default null
147 ,p_abr_attribute30 in varchar2 default null
148 ,p_abr_seq_num in number default null
149 ,p_object_version_number out nocopy number
150 ,p_effective_date in date
151 ) is
152 --
153 -- Declare cursors and local variables
154 --
155 l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%TYPE;
156 l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
157 l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
158 l_proc varchar2(72) := g_package||'create_acty_base_rate';
159 l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
160 --
161
162 l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
163 l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;
164 l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;
165 l_prdct_flx_cr_when_elig_flag ben_acty_base_rt_f.prdct_flx_cr_when_elig_flag%TYPE := p_prdct_flx_cr_when_elig_flag;
166
167 --
168 begin
169 --
170 hr_utility.set_location('Entering:'|| l_proc, 10);
171 --
172 -- Issue a savepoint if operating in validation only mode
173 --
174 savepoint create_acty_base_rate;
175 --
176 hr_utility.set_location(l_proc, 20);
177 --
178 -- Process Logic
179 --
180 begin
181 --
182 -- Start of API User Hook for the before hook of create_acty_base_rate
183 --
184 ben_acty_base_rate_bk1.create_acty_base_rate_b
185 (
186 p_ordr_num => p_ordr_num
187 ,p_acty_typ_cd => p_acty_typ_cd
188 ,p_sub_acty_typ_cd => p_sub_acty_typ_cd
189 ,p_name => p_name
190 ,p_rt_typ_cd => p_rt_typ_cd
191 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
192 ,p_tx_typ_cd => p_tx_typ_cd
193 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
194 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
195 ,p_abv_mx_elcn_val_alwd_flag => p_abv_mx_elcn_val_alwd_flag
196 ,p_blw_mn_elcn_alwd_flag => p_blw_mn_elcn_alwd_flag
197 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
198 ,p_parnt_chld_cd => p_parnt_chld_cd
199 ,p_use_calc_acty_bs_rt_flag => p_use_calc_acty_bs_rt_flag
200 ,p_uses_ded_sched_flag => p_uses_ded_sched_flag
201 ,p_uses_varbl_rt_flag => p_uses_varbl_rt_flag
202 ,p_vstg_sched_apls_flag => p_vstg_sched_apls_flag
203 ,p_rt_mlt_cd => p_rt_mlt_cd
204 ,p_proc_each_pp_dflt_flag => p_proc_each_pp_dflt_flag
205 ,p_prdct_flx_cr_when_elig_flag => p_prdct_flx_cr_when_elig_flag
206 ,p_no_std_rt_used_flag => p_no_std_rt_used_flag
207 ,p_rcrrg_cd => p_rcrrg_cd
208 ,p_mn_elcn_val => p_mn_elcn_val
209 ,p_mx_elcn_val => p_mx_elcn_val
210 ,p_lwr_lmt_val => p_lwr_lmt_val
211 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
212 ,p_upr_lmt_val => p_upr_lmt_val
213 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
214 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
215 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
216 ,p_entr_ann_val_flag => p_entr_ann_val_flag
217 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
218 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
219 ,p_wsh_rl_dy_mo_num => p_wsh_rl_dy_mo_num
220 ,p_uses_pymt_sched_flag => p_uses_pymt_sched_flag
221 ,p_nnmntry_uom => p_nnmntry_uom
222 ,p_val => p_val
223 ,p_incrmt_elcn_val => p_incrmt_elcn_val
224 ,p_rndg_cd => p_rndg_cd
225 ,p_val_ovrid_alwd_flag => p_val_ovrid_alwd_flag
226 ,p_prtl_mo_det_mthd_cd => p_prtl_mo_det_mthd_cd
227 ,p_acty_base_rt_stat_cd => p_acty_base_rt_stat_cd
228 ,p_procg_src_cd => p_procg_src_cd
229 ,p_dflt_val => p_dflt_val
230 ,p_dflt_flag => p_dflt_flag
231 ,p_frgn_erg_ded_typ_cd => p_frgn_erg_ded_typ_cd
232 ,p_frgn_erg_ded_name => p_frgn_erg_ded_name
233 ,p_frgn_erg_ded_ident => p_frgn_erg_ded_ident
234 ,p_no_mx_elcn_val_dfnd_flag => p_no_mx_elcn_val_dfnd_flag
235 ,p_prtl_mo_det_mthd_rl => p_prtl_mo_det_mthd_rl
236 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
237 ,p_prtl_mo_eff_dt_det_rl => p_prtl_mo_eff_dt_det_rl
238 ,p_rndg_rl => p_rndg_rl
239 ,p_val_calc_rl => p_val_calc_rl
240 ,p_no_mn_elcn_val_dfnd_flag => p_no_mn_elcn_val_dfnd_flag
241 ,p_prtl_mo_eff_dt_det_cd => p_prtl_mo_eff_dt_det_cd
242 ,p_only_one_bal_typ_alwd_flag => p_only_one_bal_typ_alwd_flag
243 ,p_rt_usg_cd => p_rt_usg_cd
244 ,p_prort_mn_ann_elcn_val_cd => p_prort_mn_ann_elcn_val_cd
245 ,p_prort_mn_ann_elcn_val_rl => p_prort_mn_ann_elcn_val_rl
246 ,p_prort_mx_ann_elcn_val_cd => p_prort_mx_ann_elcn_val_cd
247 ,p_prort_mx_ann_elcn_val_rl => p_prort_mx_ann_elcn_val_rl
248 ,p_one_ann_pymt_cd => p_one_ann_pymt_cd
249 ,p_det_pl_ytd_cntrs_cd => p_det_pl_ytd_cntrs_cd
250 ,p_asmt_to_use_cd => p_asmt_to_use_cd
251 ,p_ele_rqd_flag => p_ele_rqd_flag
252 ,p_subj_to_imptd_incm_flag => p_subj_to_imptd_incm_flag
253 ,p_element_type_id => p_element_type_id
254 ,p_input_value_id => p_input_value_id
255 ,p_input_va_calc_rl => p_input_va_calc_rl
256 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
257 ,p_parnt_acty_base_rt_id => p_parnt_acty_base_rt_id
258 ,p_pgm_id => p_pgm_id
259 ,p_pl_id => p_pl_id
260 ,p_oipl_id => p_oipl_id
261 ,p_opt_id => p_opt_id
262 ,p_oiplip_id => p_oiplip_id
263 ,p_plip_id => p_plip_id
264 ,p_ptip_id => p_ptip_id
265 ,p_cmbn_plip_id => p_cmbn_plip_id
266 ,p_cmbn_ptip_id => p_cmbn_ptip_id
267 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
268 ,p_vstg_for_acty_rt_id => p_vstg_for_acty_rt_id
269 ,p_actl_prem_id => p_actl_prem_id
270 ,p_TTL_COMP_LVL_FCTR_ID => p_TTL_COMP_LVL_FCTR_ID
271 ,p_COST_ALLOCATION_KEYFLEX_ID => p_COST_ALLOCATION_KEYFLEX_ID
272 ,p_ALWS_CHG_CD => p_ALWS_CHG_CD
273 ,p_ele_entry_val_cd => p_ele_entry_val_cd
274 ,p_pay_rate_grade_rule_id => p_pay_rate_grade_rule_id
275 ,p_rate_periodization_cd => p_rate_periodization_cd
276 ,p_rate_periodization_rl => p_rate_periodization_rl
277 ,p_mn_mx_elcn_rl => p_mn_mx_elcn_rl
278 ,p_mapping_table_name => p_mapping_table_name
279 ,p_mapping_table_pk_id => p_mapping_table_pk_id
280 ,p_business_group_id => p_business_group_id
281 ,p_context_pgm_id => p_context_pgm_id
282 ,p_context_pl_id => p_context_pl_id
283 ,p_context_opt_id => p_context_opt_id
284 ,p_element_det_rl => p_element_det_rl
285 ,p_currency_det_cd => p_currency_det_cd
286 ,p_abr_attribute_category => p_abr_attribute_category
287 ,p_abr_attribute1 => p_abr_attribute1
288 ,p_abr_attribute2 => p_abr_attribute2
289 ,p_abr_attribute3 => p_abr_attribute3
290 ,p_abr_attribute4 => p_abr_attribute4
291 ,p_abr_attribute5 => p_abr_attribute5
292 ,p_abr_attribute6 => p_abr_attribute6
293 ,p_abr_attribute7 => p_abr_attribute7
294 ,p_abr_attribute8 => p_abr_attribute8
295 ,p_abr_attribute9 => p_abr_attribute9
296 ,p_abr_attribute10 => p_abr_attribute10
297 ,p_abr_attribute11 => p_abr_attribute11
298 ,p_abr_attribute12 => p_abr_attribute12
299 ,p_abr_attribute13 => p_abr_attribute13
300 ,p_abr_attribute14 => p_abr_attribute14
301 ,p_abr_attribute15 => p_abr_attribute15
302 ,p_abr_attribute16 => p_abr_attribute16
303 ,p_abr_attribute17 => p_abr_attribute17
304 ,p_abr_attribute18 => p_abr_attribute18
305 ,p_abr_attribute19 => p_abr_attribute19
306 ,p_abr_attribute20 => p_abr_attribute20
307 ,p_abr_attribute21 => p_abr_attribute21
308 ,p_abr_attribute22 => p_abr_attribute22
309 ,p_abr_attribute23 => p_abr_attribute23
310 ,p_abr_attribute24 => p_abr_attribute24
311 ,p_abr_attribute25 => p_abr_attribute25
312 ,p_abr_attribute26 => p_abr_attribute26
313 ,p_abr_attribute27 => p_abr_attribute27
314 ,p_abr_attribute28 => p_abr_attribute28
315 ,p_abr_attribute29 => p_abr_attribute29
316 ,p_abr_attribute30 => p_abr_attribute30
317 ,p_abr_seq_num => p_abr_seq_num
318 ,p_effective_date => p_effective_date
319 );
320 exception
321 when hr_api.cannot_find_prog_unit then
322 hr_api.cannot_find_prog_unit_error
323 (
324 p_module_name => 'CREATE_acty_base_rate'
325 ,p_hook_type => 'BP'
326 );
327 --
328 -- End of API User Hook for the before hook of create_acty_base_rate
329 --
330 end;
331 --
332
333 -- check the usage code if it is FLXCR then variable are changed
334 If P_rt_usg_cd = 'FLXCR' then
335 l_use_to_calc_net_flx_cr_flag := 'Y' ;
336 l_asn_on_enrt_flag := 'Y' ;
337 l_entr_val_at_enrt_flag := 'N' ;
338 l_prdct_flx_cr_when_elig_flag := 'Y' ;
339 end if ;
340
341
342 ---
343 ben_abr_ins.ins
344 (
345 p_acty_base_rt_id => l_acty_base_rt_id
346 ,p_effective_start_date => l_effective_start_date
347 ,p_effective_end_date => l_effective_end_date
348 ,p_ordr_num => p_ordr_num
349 ,p_acty_typ_cd => p_acty_typ_cd
350 ,p_sub_acty_typ_cd => p_sub_acty_typ_cd
351 ,p_name => p_name
352 ,p_rt_typ_cd => p_rt_typ_cd
353 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
354 ,p_tx_typ_cd => p_tx_typ_cd
355 ,p_use_to_calc_net_flx_cr_flag => l_use_to_calc_net_flx_cr_flag
356 ,p_asn_on_enrt_flag => l_asn_on_enrt_flag
357 ,p_abv_mx_elcn_val_alwd_flag => p_abv_mx_elcn_val_alwd_flag
358 ,p_blw_mn_elcn_alwd_flag => p_blw_mn_elcn_alwd_flag
359 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
360 ,p_parnt_chld_cd => p_parnt_chld_cd
361 ,p_use_calc_acty_bs_rt_flag => p_use_calc_acty_bs_rt_flag
362 ,p_uses_ded_sched_flag => p_uses_ded_sched_flag
363 ,p_uses_varbl_rt_flag => p_uses_varbl_rt_flag
364 ,p_vstg_sched_apls_flag => p_vstg_sched_apls_flag
365 ,p_rt_mlt_cd => p_rt_mlt_cd
366 ,p_proc_each_pp_dflt_flag => p_proc_each_pp_dflt_flag
367 ,p_prdct_flx_cr_when_elig_flag => l_prdct_flx_cr_when_elig_flag
368 ,p_no_std_rt_used_flag => p_no_std_rt_used_flag
369 ,p_rcrrg_cd => p_rcrrg_cd
370 ,p_mn_elcn_val => p_mn_elcn_val
371 ,p_mx_elcn_val => p_mx_elcn_val
372 ,p_lwr_lmt_val => p_lwr_lmt_val
373 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
374 ,p_upr_lmt_val => p_upr_lmt_val
375 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
376 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
377 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
378 ,p_entr_ann_val_flag => p_entr_ann_val_flag
379 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
380 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
381 ,p_wsh_rl_dy_mo_num => p_wsh_rl_dy_mo_num
382 ,p_uses_pymt_sched_flag => p_uses_pymt_sched_flag
383 ,p_nnmntry_uom => p_nnmntry_uom
384 ,p_val => p_val
385 ,p_incrmt_elcn_val => p_incrmt_elcn_val
386 ,p_rndg_cd => p_rndg_cd
387 ,p_val_ovrid_alwd_flag => p_val_ovrid_alwd_flag
388 ,p_prtl_mo_det_mthd_cd => p_prtl_mo_det_mthd_cd
389 ,p_acty_base_rt_stat_cd => p_acty_base_rt_stat_cd
390 ,p_procg_src_cd => p_procg_src_cd
391 ,p_dflt_val => p_dflt_val
392 ,p_dflt_flag => p_dflt_flag
393 ,p_frgn_erg_ded_typ_cd => p_frgn_erg_ded_typ_cd
394 ,p_frgn_erg_ded_name => p_frgn_erg_ded_name
395 ,p_frgn_erg_ded_ident => p_frgn_erg_ded_ident
396 ,p_no_mx_elcn_val_dfnd_flag => p_no_mx_elcn_val_dfnd_flag
397 ,p_prtl_mo_det_mthd_rl => p_prtl_mo_det_mthd_rl
398 ,p_entr_val_at_enrt_flag => l_entr_val_at_enrt_flag
399 ,p_prtl_mo_eff_dt_det_rl => p_prtl_mo_eff_dt_det_rl
400 ,p_rndg_rl => p_rndg_rl
401 ,p_val_calc_rl => p_val_calc_rl
402 ,p_no_mn_elcn_val_dfnd_flag => p_no_mn_elcn_val_dfnd_flag
403 ,p_prtl_mo_eff_dt_det_cd => p_prtl_mo_eff_dt_det_cd
404 ,p_only_one_bal_typ_alwd_flag => p_only_one_bal_typ_alwd_flag
405 ,p_rt_usg_cd => p_rt_usg_cd
406 ,p_prort_mn_ann_elcn_val_cd => p_prort_mn_ann_elcn_val_cd
407 ,p_prort_mn_ann_elcn_val_rl => p_prort_mn_ann_elcn_val_rl
408 ,p_prort_mx_ann_elcn_val_cd => p_prort_mx_ann_elcn_val_cd
409 ,p_prort_mx_ann_elcn_val_rl => p_prort_mx_ann_elcn_val_rl
410 ,p_one_ann_pymt_cd => p_one_ann_pymt_cd
411 ,p_det_pl_ytd_cntrs_cd => p_det_pl_ytd_cntrs_cd
412 ,p_asmt_to_use_cd => p_asmt_to_use_cd
413 ,p_ele_rqd_flag => p_ele_rqd_flag
414 ,p_subj_to_imptd_incm_flag => p_subj_to_imptd_incm_flag
415 ,p_element_type_id => p_element_type_id
416 ,p_input_value_id => p_input_value_id
417 ,p_input_va_calc_rl => p_input_va_calc_rl
418 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
419 ,p_parnt_acty_base_rt_id => p_parnt_acty_base_rt_id
420 ,p_pgm_id => p_pgm_id
421 ,p_pl_id => p_pl_id
422 ,p_oipl_id => p_oipl_id
423 ,p_opt_id => p_opt_id
424 ,p_oiplip_id => p_oiplip_id
425 ,p_plip_id => p_plip_id
426 ,p_ptip_id => p_ptip_id
427 ,p_cmbn_plip_id => p_cmbn_plip_id
428 ,p_cmbn_ptip_id => p_cmbn_ptip_id
429 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
430 ,p_vstg_for_acty_rt_id => p_vstg_for_acty_rt_id
431 ,p_actl_prem_id => p_actl_prem_id
432 ,p_TTL_COMP_LVL_FCTR_ID => p_TTL_COMP_LVL_FCTR_ID
433 ,p_COST_ALLOCATION_KEYFLEX_ID => p_COST_ALLOCATION_KEYFLEX_ID
434 ,p_ALWS_CHG_CD => p_ALWS_CHG_CD
435 ,p_ele_entry_val_cd => p_ele_entry_val_cd
436 ,p_pay_rate_grade_rule_id => p_pay_rate_grade_rule_id
437 ,p_rate_periodization_cd => p_rate_periodization_cd
438 ,p_rate_periodization_rl => p_rate_periodization_rl
439 ,p_mn_mx_elcn_rl => p_mn_mx_elcn_rl
440 ,p_mapping_table_name => p_mapping_table_name
441 ,p_mapping_table_pk_id => p_mapping_table_pk_id
442 ,p_business_group_id => p_business_group_id
443 ,p_context_pgm_id => p_context_pgm_id
444 ,p_context_pl_id => p_context_pl_id
445 ,p_context_opt_id => p_context_opt_id
446 ,p_element_det_rl => p_element_det_rl
447 ,p_currency_det_cd => p_currency_det_cd
448 ,p_abr_attribute_category => p_abr_attribute_category
449 ,p_abr_attribute1 => p_abr_attribute1
450 ,p_abr_attribute2 => p_abr_attribute2
451 ,p_abr_attribute3 => p_abr_attribute3
452 ,p_abr_attribute4 => p_abr_attribute4
453 ,p_abr_attribute5 => p_abr_attribute5
454 ,p_abr_attribute6 => p_abr_attribute6
455 ,p_abr_attribute7 => p_abr_attribute7
456 ,p_abr_attribute8 => p_abr_attribute8
457 ,p_abr_attribute9 => p_abr_attribute9
458 ,p_abr_attribute10 => p_abr_attribute10
459 ,p_abr_attribute11 => p_abr_attribute11
460 ,p_abr_attribute12 => p_abr_attribute12
461 ,p_abr_attribute13 => p_abr_attribute13
462 ,p_abr_attribute14 => p_abr_attribute14
463 ,p_abr_attribute15 => p_abr_attribute15
464 ,p_abr_attribute16 => p_abr_attribute16
465 ,p_abr_attribute17 => p_abr_attribute17
466 ,p_abr_attribute18 => p_abr_attribute18
467 ,p_abr_attribute19 => p_abr_attribute19
468 ,p_abr_attribute20 => p_abr_attribute20
469 ,p_abr_attribute21 => p_abr_attribute21
470 ,p_abr_attribute22 => p_abr_attribute22
471 ,p_abr_attribute23 => p_abr_attribute23
472 ,p_abr_attribute24 => p_abr_attribute24
473 ,p_abr_attribute25 => p_abr_attribute25
474 ,p_abr_attribute26 => p_abr_attribute26
475 ,p_abr_attribute27 => p_abr_attribute27
476 ,p_abr_attribute28 => p_abr_attribute28
477 ,p_abr_attribute29 => p_abr_attribute29
478 ,p_abr_attribute30 => p_abr_attribute30
479 ,p_abr_seq_num => p_abr_seq_num
480 ,p_object_version_number => l_object_version_number
481 ,p_effective_date => p_effective_date
482 );
483 --
484 begin
485 --
486 -- Start of API User Hook for the after hook of create_acty_base_rate
487 --
488 ben_acty_base_rate_bk1.create_acty_base_rate_a
489 (
490 p_acty_base_rt_id => l_acty_base_rt_id
491 ,p_effective_start_date => l_effective_start_date
492 ,p_effective_end_date => l_effective_end_date
493 ,p_ordr_num => p_ordr_num
494 ,p_acty_typ_cd => p_acty_typ_cd
495 ,p_sub_acty_typ_cd => p_sub_acty_typ_cd
496 ,p_name => p_name
497 ,p_rt_typ_cd => p_rt_typ_cd
498 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
499 ,p_tx_typ_cd => p_tx_typ_cd
500 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
501 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
502 ,p_abv_mx_elcn_val_alwd_flag => p_abv_mx_elcn_val_alwd_flag
503 ,p_blw_mn_elcn_alwd_flag => p_blw_mn_elcn_alwd_flag
504 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
505 ,p_parnt_chld_cd => p_parnt_chld_cd
506 ,p_use_calc_acty_bs_rt_flag => p_use_calc_acty_bs_rt_flag
507 ,p_uses_ded_sched_flag => p_uses_ded_sched_flag
508 ,p_uses_varbl_rt_flag => p_uses_varbl_rt_flag
509 ,p_vstg_sched_apls_flag => p_vstg_sched_apls_flag
510 ,p_rt_mlt_cd => p_rt_mlt_cd
511 ,p_proc_each_pp_dflt_flag => p_proc_each_pp_dflt_flag
512 ,p_prdct_flx_cr_when_elig_flag => p_prdct_flx_cr_when_elig_flag
513 ,p_no_std_rt_used_flag => p_no_std_rt_used_flag
514 ,p_rcrrg_cd => p_rcrrg_cd
515 ,p_mn_elcn_val => p_mn_elcn_val
516 ,p_mx_elcn_val => p_mx_elcn_val
517 ,p_lwr_lmt_val => p_lwr_lmt_val
518 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
519 ,p_upr_lmt_val => p_upr_lmt_val
520 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
521 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
522 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
523 ,p_entr_ann_val_flag => p_entr_ann_val_flag
524 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
525 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
526 ,p_wsh_rl_dy_mo_num => p_wsh_rl_dy_mo_num
527 ,p_uses_pymt_sched_flag => p_uses_pymt_sched_flag
528 ,p_nnmntry_uom => p_nnmntry_uom
529 ,p_val => p_val
530 ,p_incrmt_elcn_val => p_incrmt_elcn_val
531 ,p_rndg_cd => p_rndg_cd
532 ,p_val_ovrid_alwd_flag => p_val_ovrid_alwd_flag
533 ,p_prtl_mo_det_mthd_cd => p_prtl_mo_det_mthd_cd
534 ,p_acty_base_rt_stat_cd => p_acty_base_rt_stat_cd
535 ,p_procg_src_cd => p_procg_src_cd
536 ,p_dflt_val => p_dflt_val
537 ,p_dflt_flag => p_dflt_flag
538 ,p_frgn_erg_ded_typ_cd => p_frgn_erg_ded_typ_cd
539 ,p_frgn_erg_ded_name => p_frgn_erg_ded_name
540 ,p_frgn_erg_ded_ident => p_frgn_erg_ded_ident
541 ,p_no_mx_elcn_val_dfnd_flag => p_no_mx_elcn_val_dfnd_flag
542 ,p_prtl_mo_det_mthd_rl => p_prtl_mo_det_mthd_rl
543 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
544 ,p_prtl_mo_eff_dt_det_rl => p_prtl_mo_eff_dt_det_rl
545 ,p_rndg_rl => p_rndg_rl
546 ,p_val_calc_rl => p_val_calc_rl
547 ,p_no_mn_elcn_val_dfnd_flag => p_no_mn_elcn_val_dfnd_flag
548 ,p_prtl_mo_eff_dt_det_cd => p_prtl_mo_eff_dt_det_cd
549 ,p_only_one_bal_typ_alwd_flag => p_only_one_bal_typ_alwd_flag
550 ,p_rt_usg_cd => p_rt_usg_cd
551 ,p_prort_mn_ann_elcn_val_cd => p_prort_mn_ann_elcn_val_cd
552 ,p_prort_mn_ann_elcn_val_rl => p_prort_mn_ann_elcn_val_rl
553 ,p_prort_mx_ann_elcn_val_cd => p_prort_mx_ann_elcn_val_cd
554 ,p_prort_mx_ann_elcn_val_rl => p_prort_mx_ann_elcn_val_rl
555 ,p_one_ann_pymt_cd => p_one_ann_pymt_cd
556 ,p_det_pl_ytd_cntrs_cd => p_det_pl_ytd_cntrs_cd
557 ,p_asmt_to_use_cd => p_asmt_to_use_cd
558 ,p_ele_rqd_flag => p_ele_rqd_flag
559 ,p_subj_to_imptd_incm_flag => p_subj_to_imptd_incm_flag
560 ,p_element_type_id => p_element_type_id
561 ,p_input_value_id => p_input_value_id
562 ,p_input_va_calc_rl => p_input_va_calc_rl
563 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
564 ,p_parnt_acty_base_rt_id => p_parnt_acty_base_rt_id
565 ,p_pgm_id => p_pgm_id
566 ,p_pl_id => p_pl_id
567 ,p_oipl_id => p_oipl_id
568 ,p_opt_id => p_opt_id
569 ,p_oiplip_id => p_oiplip_id
570 ,p_plip_id => p_plip_id
571 ,p_ptip_id => p_ptip_id
572 ,p_cmbn_plip_id => p_cmbn_plip_id
573 ,p_cmbn_ptip_id => p_cmbn_ptip_id
574 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
575 ,p_vstg_for_acty_rt_id => p_vstg_for_acty_rt_id
576 ,p_actl_prem_id => p_actl_prem_id
577 ,p_TTL_COMP_LVL_FCTR_ID => p_TTL_COMP_LVL_FCTR_ID
578 ,p_COST_ALLOCATION_KEYFLEX_ID => p_COST_ALLOCATION_KEYFLEX_ID
579 ,p_ALWS_CHG_CD => p_ALWS_CHG_CD
580 ,p_ele_entry_val_cd => p_ele_entry_val_cd
581 ,p_pay_rate_grade_rule_id => p_pay_rate_grade_rule_id
582 ,p_rate_periodization_cd => p_rate_periodization_cd
583 ,p_rate_periodization_rl => p_rate_periodization_rl
584 ,p_mn_mx_elcn_rl => p_mn_mx_elcn_rl
585 ,p_mapping_table_name => p_mapping_table_name
586 ,p_mapping_table_pk_id => p_mapping_table_pk_id
587 ,p_business_group_id => p_business_group_id
588 ,p_context_pgm_id => p_context_pgm_id
589 ,p_context_pl_id => p_context_pl_id
590 ,p_context_opt_id => p_context_opt_id
591 ,p_element_det_rl => p_element_det_rl
592 ,p_currency_det_cd => p_currency_det_cd
593 ,p_abr_attribute_category => p_abr_attribute_category
594 ,p_abr_attribute1 => p_abr_attribute1
595 ,p_abr_attribute2 => p_abr_attribute2
596 ,p_abr_attribute3 => p_abr_attribute3
597 ,p_abr_attribute4 => p_abr_attribute4
598 ,p_abr_attribute5 => p_abr_attribute5
599 ,p_abr_attribute6 => p_abr_attribute6
600 ,p_abr_attribute7 => p_abr_attribute7
601 ,p_abr_attribute8 => p_abr_attribute8
602 ,p_abr_attribute9 => p_abr_attribute9
603 ,p_abr_attribute10 => p_abr_attribute10
604 ,p_abr_attribute11 => p_abr_attribute11
605 ,p_abr_attribute12 => p_abr_attribute12
606 ,p_abr_attribute13 => p_abr_attribute13
607 ,p_abr_attribute14 => p_abr_attribute14
608 ,p_abr_attribute15 => p_abr_attribute15
609 ,p_abr_attribute16 => p_abr_attribute16
610 ,p_abr_attribute17 => p_abr_attribute17
611 ,p_abr_attribute18 => p_abr_attribute18
612 ,p_abr_attribute19 => p_abr_attribute19
613 ,p_abr_attribute20 => p_abr_attribute20
614 ,p_abr_attribute21 => p_abr_attribute21
615 ,p_abr_attribute22 => p_abr_attribute22
616 ,p_abr_attribute23 => p_abr_attribute23
617 ,p_abr_attribute24 => p_abr_attribute24
618 ,p_abr_attribute25 => p_abr_attribute25
619 ,p_abr_attribute26 => p_abr_attribute26
620 ,p_abr_attribute27 => p_abr_attribute27
621 ,p_abr_attribute28 => p_abr_attribute28
622 ,p_abr_attribute29 => p_abr_attribute29
623 ,p_abr_attribute30 => p_abr_attribute30
624 ,p_abr_seq_num => p_abr_seq_num
625 ,p_object_version_number => l_object_version_number
626 ,p_effective_date => p_effective_date
627 );
628 exception
629 when hr_api.cannot_find_prog_unit then
630 hr_api.cannot_find_prog_unit_error
631 (p_module_name => 'CREATE_acty_base_rate'
632 ,p_hook_type => 'AP'
633 );
634 --
635 -- End of API User Hook for the after hook of create_acty_base_rate
636 --
637 end;
638 --
639 hr_utility.set_location(l_proc, 60);
640 --
641 -- When in validation only mode raise the Validate_Enabled exception
642 --
643 if p_validate then
644 raise hr_api.validate_enabled;
645 end if;
646 --
647 -- Set all output arguments
648 --
649 p_acty_base_rt_id := l_acty_base_rt_id;
650 p_effective_start_date := l_effective_start_date;
651 p_effective_end_date := l_effective_end_date;
652 p_object_version_number := l_object_version_number;
653 --
654 hr_utility.set_location(' Leaving:'||l_proc, 70);
655 --
656 exception
657 --
658 when hr_api.validate_enabled then
659 --
660 -- As the Validate_Enabled exception has been raised
661 -- we must rollback to the savepoint
662 --
663 ROLLBACK TO create_acty_base_rate;
664 --
665 -- Only set output warning arguments
666 -- (Any key or derived arguments must be set to null
667 -- when validation only mode is being used.)
668 --
669 p_acty_base_rt_id := null;
670 p_effective_start_date := null;
671 p_effective_end_date := null;
672 p_object_version_number := null;
673 hr_utility.set_location(' Leaving:'||l_proc, 80);
674 --
675 when others then
676 --
677 -- A validation or unexpected error has occured
678 --
679 p_acty_base_rt_id := null;
680 p_effective_start_date := null;
681 p_effective_end_date := null;
682 p_object_version_number := null;
683 --
684 ROLLBACK TO create_acty_base_rate;
685 raise;
686 --
687 end create_acty_base_rate;
688 -- ----------------------------------------------------------------------------
689 -- |------------------------< update_acty_base_rate >--- ------------------|
690 -- ----------------------------------------------------------------------------
691 --
692 procedure update_acty_base_rate
693 (p_validate in boolean default false
694 ,p_acty_base_rt_id in number
695 ,p_effective_start_date out nocopy date
696 ,p_effective_end_date out nocopy date
697 ,p_ordr_num in number default hr_api.g_number
698 ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
699 ,p_sub_acty_typ_cd in varchar2 default hr_api.g_varchar2
700 ,p_name in varchar2 default hr_api.g_varchar2
701 ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
702 ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
703 ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
704 ,p_use_to_calc_net_flx_cr_flag in varchar2 default hr_api.g_varchar2
705 ,p_asn_on_enrt_flag in varchar2 default hr_api.g_varchar2
706 ,p_abv_mx_elcn_val_alwd_flag in varchar2 default hr_api.g_varchar2
707 ,p_blw_mn_elcn_alwd_flag in varchar2 default hr_api.g_varchar2
708 ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
709 ,p_parnt_chld_cd in varchar2 default hr_api.g_varchar2
710 ,p_use_calc_acty_bs_rt_flag in varchar2 default hr_api.g_varchar2
711 ,p_uses_ded_sched_flag in varchar2 default hr_api.g_varchar2
712 ,p_uses_varbl_rt_flag in varchar2 default hr_api.g_varchar2
713 ,p_vstg_sched_apls_flag in varchar2 default hr_api.g_varchar2
714 ,p_rt_mlt_cd in varchar2 default hr_api.g_varchar2
715 ,p_proc_each_pp_dflt_flag in varchar2 default hr_api.g_varchar2
716 ,p_prdct_flx_cr_when_elig_flag in varchar2 default hr_api.g_varchar2
717 ,p_no_std_rt_used_flag in varchar2 default hr_api.g_varchar2
718 ,p_rcrrg_cd in varchar2 default hr_api.g_varchar2
719 ,p_mn_elcn_val in number default hr_api.g_number
720 ,p_mx_elcn_val in number default hr_api.g_number
721 ,p_lwr_lmt_val in number default hr_api.g_number
722 ,p_lwr_lmt_calc_rl in number default hr_api.g_number
723 ,p_upr_lmt_val in number default hr_api.g_number
724 ,p_upr_lmt_calc_rl in number default hr_api.g_number
725 ,p_ptd_comp_lvl_fctr_id in number default hr_api.g_number
726 ,p_clm_comp_lvl_fctr_id in number default hr_api.g_number
727 ,p_entr_ann_val_flag in varchar2 default hr_api.g_varchar2
728 ,p_ann_mn_elcn_val in number default hr_api.g_number
729 ,p_ann_mx_elcn_val in number default hr_api.g_number
730 ,p_wsh_rl_dy_mo_num in number default hr_api.g_number
731 ,p_uses_pymt_sched_flag in varchar2 default hr_api.g_varchar2
732 ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
733 ,p_val in number default hr_api.g_number
734 ,p_incrmt_elcn_val in number default hr_api.g_number
735 ,p_rndg_cd in varchar2 default hr_api.g_varchar2
736 ,p_val_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
737 ,p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2
738 ,p_acty_base_rt_stat_cd in varchar2 default hr_api.g_varchar2
739 ,p_procg_src_cd in varchar2 default hr_api.g_varchar2
740 ,p_dflt_val in number default hr_api.g_number
741 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
742 ,p_frgn_erg_ded_typ_cd in varchar2 default hr_api.g_varchar2
743 ,p_frgn_erg_ded_name in varchar2 default hr_api.g_varchar2
744 ,p_frgn_erg_ded_ident in varchar2 default hr_api.g_varchar2
745 ,p_no_mx_elcn_val_dfnd_flag in varchar2 default hr_api.g_varchar2
746 ,p_prtl_mo_det_mthd_rl in number default hr_api.g_number
747 ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
748 ,p_prtl_mo_eff_dt_det_rl in number default hr_api.g_number
749 ,p_rndg_rl in number default hr_api.g_number
750 ,p_val_calc_rl in number default hr_api.g_number
751 ,p_no_mn_elcn_val_dfnd_flag in varchar2 default hr_api.g_varchar2
752 ,p_prtl_mo_eff_dt_det_cd in varchar2 default hr_api.g_varchar2
753 ,p_only_one_bal_typ_alwd_flag in varchar2 default hr_api.g_varchar2
754 ,p_rt_usg_cd in varchar2 default hr_api.g_varchar2
755 ,p_prort_mn_ann_elcn_val_cd in varchar2 default hr_api.g_varchar2
756 ,p_prort_mn_ann_elcn_val_rl in number default hr_api.g_number
757 ,p_prort_mx_ann_elcn_val_cd in varchar2 default hr_api.g_varchar2
758 ,p_prort_mx_ann_elcn_val_rl in number default hr_api.g_number
759 ,p_one_ann_pymt_cd in varchar2 default hr_api.g_varchar2
760 ,p_det_pl_ytd_cntrs_cd in varchar2 default hr_api.g_varchar2
761 ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
762 ,p_ele_rqd_flag in varchar2 default hr_api.g_varchar2
763 ,p_subj_to_imptd_incm_flag in varchar2 default hr_api.g_varchar2
764 ,p_element_type_id in number default hr_api.g_number
765 ,p_input_value_id in number default hr_api.g_number
766 ,p_input_va_calc_rl in number default hr_api.g_number
767 ,p_comp_lvl_fctr_id in number default hr_api.g_number
768 ,p_parnt_acty_base_rt_id in number default hr_api.g_number
769 ,p_pgm_id in number default hr_api.g_number
770 ,p_pl_id in number default hr_api.g_number
771 ,p_oipl_id in number default hr_api.g_number
772 ,p_opt_id in number default hr_api.g_number
773 ,p_oiplip_id in number default hr_api.g_number
774 ,p_plip_id in number default hr_api.g_number
775 ,p_ptip_id in number default hr_api.g_number
776 ,p_cmbn_plip_id in number default hr_api.g_number
777 ,p_cmbn_ptip_id in number default hr_api.g_number
778 ,p_cmbn_ptip_opt_id in number default hr_api.g_number
779 ,p_vstg_for_acty_rt_id in number default hr_api.g_number
780 ,p_actl_prem_id in number default hr_api.g_number
781 ,p_TTL_COMP_LVL_FCTR_ID in number default hr_api.g_number
782 ,p_COST_ALLOCATION_KEYFLEX_ID in number default hr_api.g_number
783 ,p_ALWS_CHG_CD in varchar2 default hr_api.g_varchar2
784 ,p_ele_entry_val_cd in varchar2 default hr_api.g_varchar2
785 ,p_pay_rate_grade_rule_id in number default hr_api.g_number
786 ,p_rate_periodization_cd in varchar2 default hr_api.g_varchar2
787 ,p_rate_periodization_rl in number default hr_api.g_number
788 ,p_mn_mx_elcn_rl in number default hr_api.g_number
789 ,p_mapping_table_name in varchar2 default hr_api.g_varchar2
790 ,p_mapping_table_pk_id in number default hr_api.g_number
791 ,p_business_group_id in number default hr_api.g_number
792 ,p_context_pgm_id in number default hr_api.g_number
793 ,p_context_pl_id in number default hr_api.g_number
794 ,p_context_opt_id in number default hr_api.g_number
795 ,p_element_det_rl in number default hr_api.g_number
796 ,p_currency_det_cd in varchar2 default hr_api.g_varchar2
797 ,p_abr_attribute_category in varchar2 default hr_api.g_varchar2
798 ,p_abr_attribute1 in varchar2 default hr_api.g_varchar2
799 ,p_abr_attribute2 in varchar2 default hr_api.g_varchar2
800 ,p_abr_attribute3 in varchar2 default hr_api.g_varchar2
801 ,p_abr_attribute4 in varchar2 default hr_api.g_varchar2
802 ,p_abr_attribute5 in varchar2 default hr_api.g_varchar2
803 ,p_abr_attribute6 in varchar2 default hr_api.g_varchar2
804 ,p_abr_attribute7 in varchar2 default hr_api.g_varchar2
805 ,p_abr_attribute8 in varchar2 default hr_api.g_varchar2
806 ,p_abr_attribute9 in varchar2 default hr_api.g_varchar2
807 ,p_abr_attribute10 in varchar2 default hr_api.g_varchar2
808 ,p_abr_attribute11 in varchar2 default hr_api.g_varchar2
809 ,p_abr_attribute12 in varchar2 default hr_api.g_varchar2
810 ,p_abr_attribute13 in varchar2 default hr_api.g_varchar2
811 ,p_abr_attribute14 in varchar2 default hr_api.g_varchar2
812 ,p_abr_attribute15 in varchar2 default hr_api.g_varchar2
813 ,p_abr_attribute16 in varchar2 default hr_api.g_varchar2
814 ,p_abr_attribute17 in varchar2 default hr_api.g_varchar2
815 ,p_abr_attribute18 in varchar2 default hr_api.g_varchar2
816 ,p_abr_attribute19 in varchar2 default hr_api.g_varchar2
817 ,p_abr_attribute20 in varchar2 default hr_api.g_varchar2
818 ,p_abr_attribute21 in varchar2 default hr_api.g_varchar2
819 ,p_abr_attribute22 in varchar2 default hr_api.g_varchar2
820 ,p_abr_attribute23 in varchar2 default hr_api.g_varchar2
821 ,p_abr_attribute24 in varchar2 default hr_api.g_varchar2
822 ,p_abr_attribute25 in varchar2 default hr_api.g_varchar2
823 ,p_abr_attribute26 in varchar2 default hr_api.g_varchar2
824 ,p_abr_attribute27 in varchar2 default hr_api.g_varchar2
825 ,p_abr_attribute28 in varchar2 default hr_api.g_varchar2
826 ,p_abr_attribute29 in varchar2 default hr_api.g_varchar2
827 ,p_abr_attribute30 in varchar2 default hr_api.g_varchar2
828 ,p_abr_seq_num in number default hr_api.g_number
829 ,p_object_version_number in out nocopy number
830 ,p_effective_date in date
831 ,p_datetrack_mode in varchar2
832 ) is
833 --
834 -- Declare cursors and local variables
835 --
836 l_proc varchar2(72) := g_package||'update_acty_base_rate';
837 l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
838 l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
839 l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
840 --
841 l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
842 l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;
843 l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;
844 l_prdct_flx_cr_when_elig_flag ben_acty_base_rt_f.prdct_flx_cr_when_elig_flag%TYPE := p_prdct_flx_cr_when_elig_flag;
845 ---
846 begin
847 --
848 hr_utility.set_location('Entering:'|| l_proc, 10);
849 --
850 -- Issue a savepoint if operating in validation only mode
851 --
852 savepoint update_acty_base_rate;
853 --
854 hr_utility.set_location(l_proc, 20);
855 --
856 -- Process Logic
857 --
858 l_object_version_number := p_object_version_number;
859 --
860 begin
861 --
862 -- Start of API User Hook for the before hook of update_acty_base_rate
863 --
864 ben_acty_base_rate_bk2.update_acty_base_rate_b
865 (
866 p_acty_base_rt_id => p_acty_base_rt_id
867 ,p_ordr_num => p_ordr_num
868 ,p_acty_typ_cd => p_acty_typ_cd
869 ,p_sub_acty_typ_cd => p_sub_acty_typ_cd
870 ,p_name => p_name
871 ,p_rt_typ_cd => p_rt_typ_cd
872 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
873 ,p_tx_typ_cd => p_tx_typ_cd
874 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
875 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
876 ,p_abv_mx_elcn_val_alwd_flag => p_abv_mx_elcn_val_alwd_flag
877 ,p_blw_mn_elcn_alwd_flag => p_blw_mn_elcn_alwd_flag
878 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
879 ,p_parnt_chld_cd => p_parnt_chld_cd
880 ,p_use_calc_acty_bs_rt_flag => p_use_calc_acty_bs_rt_flag
881 ,p_uses_ded_sched_flag => p_uses_ded_sched_flag
882 ,p_uses_varbl_rt_flag => p_uses_varbl_rt_flag
883 ,p_vstg_sched_apls_flag => p_vstg_sched_apls_flag
884 ,p_rt_mlt_cd => p_rt_mlt_cd
885 ,p_proc_each_pp_dflt_flag => p_proc_each_pp_dflt_flag
886 ,p_prdct_flx_cr_when_elig_flag => p_prdct_flx_cr_when_elig_flag
887 ,p_no_std_rt_used_flag => p_no_std_rt_used_flag
888 ,p_rcrrg_cd => p_rcrrg_cd
889 ,p_mn_elcn_val => p_mn_elcn_val
890 ,p_mx_elcn_val => p_mx_elcn_val
891 ,p_lwr_lmt_val => p_lwr_lmt_val
892 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
893 ,p_upr_lmt_val => p_upr_lmt_val
894 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
895 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
896 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
897 ,p_entr_ann_val_flag => p_entr_ann_val_flag
898 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
899 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
900 ,p_wsh_rl_dy_mo_num => p_wsh_rl_dy_mo_num
901 ,p_uses_pymt_sched_flag => p_uses_pymt_sched_flag
902 ,p_nnmntry_uom => p_nnmntry_uom
903 ,p_val => p_val
904 ,p_incrmt_elcn_val => p_incrmt_elcn_val
905 ,p_rndg_cd => p_rndg_cd
906 ,p_val_ovrid_alwd_flag => p_val_ovrid_alwd_flag
907 ,p_prtl_mo_det_mthd_cd => p_prtl_mo_det_mthd_cd
908 ,p_acty_base_rt_stat_cd => p_acty_base_rt_stat_cd
909 ,p_procg_src_cd => p_procg_src_cd
910 ,p_dflt_val => p_dflt_val
911 ,p_dflt_flag => p_dflt_flag
912 ,p_frgn_erg_ded_typ_cd => p_frgn_erg_ded_typ_cd
913 ,p_frgn_erg_ded_name => p_frgn_erg_ded_name
914 ,p_frgn_erg_ded_ident => p_frgn_erg_ded_ident
915 ,p_no_mx_elcn_val_dfnd_flag => p_no_mx_elcn_val_dfnd_flag
916 ,p_prtl_mo_det_mthd_rl => p_prtl_mo_det_mthd_rl
917 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
918 ,p_prtl_mo_eff_dt_det_rl => p_prtl_mo_eff_dt_det_rl
919 ,p_rndg_rl => p_rndg_rl
920 ,p_val_calc_rl => p_val_calc_rl
921 ,p_no_mn_elcn_val_dfnd_flag => p_no_mn_elcn_val_dfnd_flag
922 ,p_prtl_mo_eff_dt_det_cd => p_prtl_mo_eff_dt_det_cd
923 ,p_only_one_bal_typ_alwd_flag => p_only_one_bal_typ_alwd_flag
924 ,p_rt_usg_cd => p_rt_usg_cd
925 ,p_prort_mn_ann_elcn_val_cd => p_prort_mn_ann_elcn_val_cd
926 ,p_prort_mn_ann_elcn_val_rl => p_prort_mn_ann_elcn_val_rl
927 ,p_prort_mx_ann_elcn_val_cd => p_prort_mx_ann_elcn_val_cd
928 ,p_prort_mx_ann_elcn_val_rl => p_prort_mx_ann_elcn_val_rl
929 ,p_one_ann_pymt_cd => p_one_ann_pymt_cd
930 ,p_det_pl_ytd_cntrs_cd => p_det_pl_ytd_cntrs_cd
931 ,p_asmt_to_use_cd => p_asmt_to_use_cd
932 ,p_ele_rqd_flag => p_ele_rqd_flag
933 ,p_subj_to_imptd_incm_flag => p_subj_to_imptd_incm_flag
934 ,p_element_type_id => p_element_type_id
935 ,p_input_value_id => p_input_value_id
936 ,p_input_va_calc_rl => p_input_va_calc_rl
937 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
938 ,p_parnt_acty_base_rt_id => p_parnt_acty_base_rt_id
939 ,p_pgm_id => p_pgm_id
940 ,p_pl_id => p_pl_id
941 ,p_oipl_id => p_oipl_id
942 ,p_opt_id => p_opt_id
943 ,p_oiplip_id => p_oiplip_id
944 ,p_plip_id => p_plip_id
945 ,p_ptip_id => p_ptip_id
946 ,p_cmbn_plip_id => p_cmbn_plip_id
947 ,p_cmbn_ptip_id => p_cmbn_ptip_id
948 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
949 ,p_vstg_for_acty_rt_id => p_vstg_for_acty_rt_id
950 ,p_actl_prem_id => p_actl_prem_id
951 ,p_TTL_COMP_LVL_FCTR_ID => p_TTL_COMP_LVL_FCTR_ID
952 ,p_COST_ALLOCATION_KEYFLEX_ID => p_COST_ALLOCATION_KEYFLEX_ID
953 ,p_ALWS_CHG_CD => p_ALWS_CHG_CD
954 ,p_ele_entry_val_cd => p_ele_entry_val_cd
955 ,p_pay_rate_grade_rule_id => p_pay_rate_grade_rule_id
956 ,p_rate_periodization_cd => p_rate_periodization_cd
957 ,p_rate_periodization_rl => p_rate_periodization_rl
958 ,p_mn_mx_elcn_rl => p_mn_mx_elcn_rl
959 ,p_mapping_table_name => p_mapping_table_name
960 ,p_mapping_table_pk_id => p_mapping_table_pk_id
961 ,p_business_group_id => p_business_group_id
962 ,p_context_pgm_id => p_context_pgm_id
963 ,p_context_pl_id => p_context_pl_id
964 ,p_context_opt_id => p_context_opt_id
965 ,p_element_det_rl => p_element_det_rl
966 ,p_currency_det_cd => p_currency_det_cd
967 ,p_abr_attribute_category => p_abr_attribute_category
968 ,p_abr_attribute1 => p_abr_attribute1
969 ,p_abr_attribute2 => p_abr_attribute2
970 ,p_abr_attribute3 => p_abr_attribute3
971 ,p_abr_attribute4 => p_abr_attribute4
972 ,p_abr_attribute5 => p_abr_attribute5
973 ,p_abr_attribute6 => p_abr_attribute6
974 ,p_abr_attribute7 => p_abr_attribute7
975 ,p_abr_attribute8 => p_abr_attribute8
976 ,p_abr_attribute9 => p_abr_attribute9
977 ,p_abr_attribute10 => p_abr_attribute10
978 ,p_abr_attribute11 => p_abr_attribute11
979 ,p_abr_attribute12 => p_abr_attribute12
980 ,p_abr_attribute13 => p_abr_attribute13
981 ,p_abr_attribute14 => p_abr_attribute14
982 ,p_abr_attribute15 => p_abr_attribute15
983 ,p_abr_attribute16 => p_abr_attribute16
984 ,p_abr_attribute17 => p_abr_attribute17
985 ,p_abr_attribute18 => p_abr_attribute18
986 ,p_abr_attribute19 => p_abr_attribute19
987 ,p_abr_attribute20 => p_abr_attribute20
988 ,p_abr_attribute21 => p_abr_attribute21
989 ,p_abr_attribute22 => p_abr_attribute22
990 ,p_abr_attribute23 => p_abr_attribute23
991 ,p_abr_attribute24 => p_abr_attribute24
992 ,p_abr_attribute25 => p_abr_attribute25
993 ,p_abr_attribute26 => p_abr_attribute26
994 ,p_abr_attribute27 => p_abr_attribute27
995 ,p_abr_attribute28 => p_abr_attribute28
996 ,p_abr_attribute29 => p_abr_attribute29
997 ,p_abr_attribute30 => p_abr_attribute30
998 ,p_abr_seq_num => p_abr_seq_num
999 ,p_object_version_number => p_object_version_number
1000 ,p_effective_date => p_effective_date
1001 ,p_datetrack_mode => p_datetrack_mode
1002 );
1003 exception
1004 when hr_api.cannot_find_prog_unit then
1005 hr_api.cannot_find_prog_unit_error
1006 (p_module_name => 'UPDATE_acty_base_rate'
1007 ,p_hook_type => 'BP'
1008 );
1009 --
1010 -- End of API User Hook for the before hook of update_acty_base_rate
1011 --
1012 end;
1013 -- check the usage code if it is FLXCR then variable are changed
1014 If P_rt_usg_cd = 'FLXCR' then
1015 l_use_to_calc_net_flx_cr_flag := 'Y' ;
1016 l_asn_on_enrt_flag := 'Y' ;
1017 l_entr_val_at_enrt_flag := 'N' ;
1018 l_prdct_flx_cr_when_elig_flag := 'Y' ;
1019 end if ;
1020 ---
1021 ben_abr_upd.upd
1022 (
1023 p_acty_base_rt_id => p_acty_base_rt_id
1024 ,p_effective_start_date => l_effective_start_date
1025 ,p_effective_end_date => l_effective_end_date
1026 ,p_ordr_num => p_ordr_num
1027 ,p_acty_typ_cd => p_acty_typ_cd
1028 ,p_sub_acty_typ_cd => p_sub_acty_typ_cd
1029 ,p_name => p_name
1030 ,p_rt_typ_cd => p_rt_typ_cd
1031 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
1032 ,p_tx_typ_cd => p_tx_typ_cd
1033 ,p_use_to_calc_net_flx_cr_flag => l_use_to_calc_net_flx_cr_flag
1034 ,p_asn_on_enrt_flag => l_asn_on_enrt_flag
1035 ,p_abv_mx_elcn_val_alwd_flag => p_abv_mx_elcn_val_alwd_flag
1036 ,p_blw_mn_elcn_alwd_flag => p_blw_mn_elcn_alwd_flag
1037 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
1038 ,p_parnt_chld_cd => p_parnt_chld_cd
1039 ,p_use_calc_acty_bs_rt_flag => p_use_calc_acty_bs_rt_flag
1040 ,p_uses_ded_sched_flag => p_uses_ded_sched_flag
1041 ,p_uses_varbl_rt_flag => p_uses_varbl_rt_flag
1042 ,p_vstg_sched_apls_flag => p_vstg_sched_apls_flag
1043 ,p_rt_mlt_cd => p_rt_mlt_cd
1044 ,p_proc_each_pp_dflt_flag => p_proc_each_pp_dflt_flag
1045 ,p_prdct_flx_cr_when_elig_flag => l_prdct_flx_cr_when_elig_flag
1046 ,p_no_std_rt_used_flag => p_no_std_rt_used_flag
1047 ,p_rcrrg_cd => p_rcrrg_cd
1048 ,p_mn_elcn_val => p_mn_elcn_val
1049 ,p_mx_elcn_val => p_mx_elcn_val
1050 ,p_lwr_lmt_val => p_lwr_lmt_val
1051 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
1052 ,p_upr_lmt_val => p_upr_lmt_val
1053 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
1054 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
1055 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
1056 ,p_entr_ann_val_flag => p_entr_ann_val_flag
1057 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
1058 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
1059 ,p_wsh_rl_dy_mo_num => p_wsh_rl_dy_mo_num
1060 ,p_uses_pymt_sched_flag => p_uses_pymt_sched_flag
1061 ,p_nnmntry_uom => p_nnmntry_uom
1062 ,p_val => p_val
1063 ,p_incrmt_elcn_val => p_incrmt_elcn_val
1064 ,p_rndg_cd => p_rndg_cd
1065 ,p_val_ovrid_alwd_flag => p_val_ovrid_alwd_flag
1066 ,p_prtl_mo_det_mthd_cd => p_prtl_mo_det_mthd_cd
1067 ,p_acty_base_rt_stat_cd => p_acty_base_rt_stat_cd
1068 ,p_procg_src_cd => p_procg_src_cd
1069 ,p_dflt_val => p_dflt_val
1070 ,p_dflt_flag => p_dflt_flag
1071 ,p_frgn_erg_ded_typ_cd => p_frgn_erg_ded_typ_cd
1072 ,p_frgn_erg_ded_name => p_frgn_erg_ded_name
1073 ,p_frgn_erg_ded_ident => p_frgn_erg_ded_ident
1074 ,p_no_mx_elcn_val_dfnd_flag => p_no_mx_elcn_val_dfnd_flag
1075 ,p_prtl_mo_det_mthd_rl => p_prtl_mo_det_mthd_rl
1076 ,p_entr_val_at_enrt_flag => l_entr_val_at_enrt_flag
1077 ,p_prtl_mo_eff_dt_det_rl => p_prtl_mo_eff_dt_det_rl
1078 ,p_rndg_rl => p_rndg_rl
1079 ,p_val_calc_rl => p_val_calc_rl
1080 ,p_no_mn_elcn_val_dfnd_flag => p_no_mn_elcn_val_dfnd_flag
1081 ,p_prtl_mo_eff_dt_det_cd => p_prtl_mo_eff_dt_det_cd
1082 ,p_only_one_bal_typ_alwd_flag => p_only_one_bal_typ_alwd_flag
1083 ,p_rt_usg_cd => p_rt_usg_cd
1084 ,p_prort_mn_ann_elcn_val_cd => p_prort_mn_ann_elcn_val_cd
1085 ,p_prort_mn_ann_elcn_val_rl => p_prort_mn_ann_elcn_val_rl
1086 ,p_prort_mx_ann_elcn_val_cd => p_prort_mx_ann_elcn_val_cd
1087 ,p_prort_mx_ann_elcn_val_rl => p_prort_mx_ann_elcn_val_rl
1088 ,p_one_ann_pymt_cd => p_one_ann_pymt_cd
1089 ,p_det_pl_ytd_cntrs_cd => p_det_pl_ytd_cntrs_cd
1090 ,p_asmt_to_use_cd => p_asmt_to_use_cd
1091 ,p_ele_rqd_flag => p_ele_rqd_flag
1092 ,p_subj_to_imptd_incm_flag => p_subj_to_imptd_incm_flag
1093 ,p_element_type_id => p_element_type_id
1094 ,p_input_value_id => p_input_value_id
1095 ,p_input_va_calc_rl => p_input_va_calc_rl
1096 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
1097 ,p_parnt_acty_base_rt_id => p_parnt_acty_base_rt_id
1098 ,p_pgm_id => p_pgm_id
1099 ,p_pl_id => p_pl_id
1100 ,p_oipl_id => p_oipl_id
1101 ,p_opt_id => p_opt_id
1102 ,p_oiplip_id => p_oiplip_id
1103 ,p_plip_id => p_plip_id
1104 ,p_ptip_id => p_ptip_id
1105 ,p_cmbn_plip_id => p_cmbn_plip_id
1106 ,p_cmbn_ptip_id => p_cmbn_ptip_id
1107 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
1108 ,p_vstg_for_acty_rt_id => p_vstg_for_acty_rt_id
1109 ,p_actl_prem_id => p_actl_prem_id
1110 ,p_TTL_COMP_LVL_FCTR_ID => p_TTL_COMP_LVL_FCTR_ID
1111 ,p_COST_ALLOCATION_KEYFLEX_ID => p_COST_ALLOCATION_KEYFLEX_ID
1112 ,p_ALWS_CHG_CD => p_ALWS_CHG_CD
1113 ,p_ele_entry_val_cd => p_ele_entry_val_cd
1114 ,p_pay_rate_grade_rule_id => p_pay_rate_grade_rule_id
1115 ,p_rate_periodization_cd => p_rate_periodization_cd
1116 ,p_rate_periodization_rl => p_rate_periodization_rl
1117 ,p_mn_mx_elcn_rl => p_mn_mx_elcn_rl
1118 ,p_mapping_table_name => p_mapping_table_name
1119 ,p_mapping_table_pk_id => p_mapping_table_pk_id
1120 ,p_business_group_id => p_business_group_id
1121 ,p_context_pgm_id => p_context_pgm_id
1122 ,p_context_pl_id => p_context_pl_id
1123 ,p_context_opt_id => p_context_opt_id
1124 ,p_element_det_rl => p_element_det_rl
1125 ,p_currency_det_cd => p_currency_det_cd
1126 ,p_abr_attribute_category => p_abr_attribute_category
1127 ,p_abr_attribute1 => p_abr_attribute1
1128 ,p_abr_attribute2 => p_abr_attribute2
1129 ,p_abr_attribute3 => p_abr_attribute3
1130 ,p_abr_attribute4 => p_abr_attribute4
1131 ,p_abr_attribute5 => p_abr_attribute5
1132 ,p_abr_attribute6 => p_abr_attribute6
1133 ,p_abr_attribute7 => p_abr_attribute7
1134 ,p_abr_attribute8 => p_abr_attribute8
1135 ,p_abr_attribute9 => p_abr_attribute9
1136 ,p_abr_attribute10 => p_abr_attribute10
1137 ,p_abr_attribute11 => p_abr_attribute11
1138 ,p_abr_attribute12 => p_abr_attribute12
1139 ,p_abr_attribute13 => p_abr_attribute13
1140 ,p_abr_attribute14 => p_abr_attribute14
1141 ,p_abr_attribute15 => p_abr_attribute15
1142 ,p_abr_attribute16 => p_abr_attribute16
1143 ,p_abr_attribute17 => p_abr_attribute17
1144 ,p_abr_attribute18 => p_abr_attribute18
1145 ,p_abr_attribute19 => p_abr_attribute19
1146 ,p_abr_attribute20 => p_abr_attribute20
1147 ,p_abr_attribute21 => p_abr_attribute21
1148 ,p_abr_attribute22 => p_abr_attribute22
1149 ,p_abr_attribute23 => p_abr_attribute23
1150 ,p_abr_attribute24 => p_abr_attribute24
1151 ,p_abr_attribute25 => p_abr_attribute25
1152 ,p_abr_attribute26 => p_abr_attribute26
1153 ,p_abr_attribute27 => p_abr_attribute27
1154 ,p_abr_attribute28 => p_abr_attribute28
1155 ,p_abr_attribute29 => p_abr_attribute29
1156 ,p_abr_attribute30 => p_abr_attribute30
1157 ,p_abr_seq_num => p_abr_seq_num
1158 ,p_object_version_number => l_object_version_number
1159 ,p_effective_date => p_effective_date
1160 ,p_datetrack_mode => p_datetrack_mode
1161 );
1162 --
1163 begin
1164 --
1165 -- Start of API User Hook for the after hook of update_acty_base_rate
1166 --
1167 ben_acty_base_rate_bk2.update_acty_base_rate_a
1168 (
1169 p_acty_base_rt_id => p_acty_base_rt_id
1170 ,p_effective_start_date => l_effective_start_date
1171 ,p_effective_end_date => l_effective_end_date
1172 ,p_ordr_num => p_ordr_num
1173 ,p_acty_typ_cd => p_acty_typ_cd
1174 ,p_sub_acty_typ_cd => p_sub_acty_typ_cd
1175 ,p_name => p_name
1176 ,p_rt_typ_cd => p_rt_typ_cd
1177 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
1178 ,p_tx_typ_cd => p_tx_typ_cd
1179 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
1180 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
1181 ,p_abv_mx_elcn_val_alwd_flag => p_abv_mx_elcn_val_alwd_flag
1182 ,p_blw_mn_elcn_alwd_flag => p_blw_mn_elcn_alwd_flag
1183 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
1184 ,p_parnt_chld_cd => p_parnt_chld_cd
1185 ,p_use_calc_acty_bs_rt_flag => p_use_calc_acty_bs_rt_flag
1186 ,p_uses_ded_sched_flag => p_uses_ded_sched_flag
1187 ,p_uses_varbl_rt_flag => p_uses_varbl_rt_flag
1188 ,p_vstg_sched_apls_flag => p_vstg_sched_apls_flag
1189 ,p_rt_mlt_cd => p_rt_mlt_cd
1190 ,p_proc_each_pp_dflt_flag => p_proc_each_pp_dflt_flag
1191 ,p_prdct_flx_cr_when_elig_flag => p_prdct_flx_cr_when_elig_flag
1192 ,p_no_std_rt_used_flag => p_no_std_rt_used_flag
1193 ,p_rcrrg_cd => p_rcrrg_cd
1194 ,p_mn_elcn_val => p_mn_elcn_val
1195 ,p_mx_elcn_val => p_mx_elcn_val
1196 ,p_lwr_lmt_val => p_lwr_lmt_val
1197 ,p_lwr_lmt_calc_rl => p_lwr_lmt_calc_rl
1198 ,p_upr_lmt_val => p_upr_lmt_val
1199 ,p_upr_lmt_calc_rl => p_upr_lmt_calc_rl
1200 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
1201 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
1202 ,p_entr_ann_val_flag => p_entr_ann_val_flag
1203 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
1204 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
1205 ,p_wsh_rl_dy_mo_num => p_wsh_rl_dy_mo_num
1206 ,p_uses_pymt_sched_flag => p_uses_pymt_sched_flag
1207 ,p_nnmntry_uom => p_nnmntry_uom
1208 ,p_val => p_val
1209 ,p_incrmt_elcn_val => p_incrmt_elcn_val
1210 ,p_rndg_cd => p_rndg_cd
1211 ,p_val_ovrid_alwd_flag => p_val_ovrid_alwd_flag
1212 ,p_prtl_mo_det_mthd_cd => p_prtl_mo_det_mthd_cd
1213 ,p_acty_base_rt_stat_cd => p_acty_base_rt_stat_cd
1214 ,p_procg_src_cd => p_procg_src_cd
1215 ,p_dflt_val => p_dflt_val
1216 ,p_dflt_flag => p_dflt_flag
1217 ,p_frgn_erg_ded_typ_cd => p_frgn_erg_ded_typ_cd
1218 ,p_frgn_erg_ded_name => p_frgn_erg_ded_name
1219 ,p_frgn_erg_ded_ident => p_frgn_erg_ded_ident
1220 ,p_no_mx_elcn_val_dfnd_flag => p_no_mx_elcn_val_dfnd_flag
1221 ,p_prtl_mo_det_mthd_rl => p_prtl_mo_det_mthd_rl
1222 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
1223 ,p_prtl_mo_eff_dt_det_rl => p_prtl_mo_eff_dt_det_rl
1224 ,p_rndg_rl => p_rndg_rl
1225 ,p_val_calc_rl => p_val_calc_rl
1226 ,p_no_mn_elcn_val_dfnd_flag => p_no_mn_elcn_val_dfnd_flag
1227 ,p_prtl_mo_eff_dt_det_cd => p_prtl_mo_eff_dt_det_cd
1228 ,p_only_one_bal_typ_alwd_flag => p_only_one_bal_typ_alwd_flag
1229 ,p_rt_usg_cd => p_rt_usg_cd
1230 ,p_prort_mn_ann_elcn_val_cd => p_prort_mn_ann_elcn_val_cd
1231 ,p_prort_mn_ann_elcn_val_rl => p_prort_mn_ann_elcn_val_rl
1232 ,p_prort_mx_ann_elcn_val_cd => p_prort_mx_ann_elcn_val_cd
1233 ,p_prort_mx_ann_elcn_val_rl => p_prort_mx_ann_elcn_val_rl
1234 ,p_one_ann_pymt_cd => p_one_ann_pymt_cd
1235 ,p_det_pl_ytd_cntrs_cd => p_det_pl_ytd_cntrs_cd
1236 ,p_asmt_to_use_cd => p_asmt_to_use_cd
1237 ,p_ele_rqd_flag => p_ele_rqd_flag
1238 ,p_subj_to_imptd_incm_flag => p_subj_to_imptd_incm_flag
1239 ,p_element_type_id => p_element_type_id
1240 ,p_input_value_id => p_input_value_id
1241 ,p_input_va_calc_rl => p_input_va_calc_rl
1242 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
1243 ,p_parnt_acty_base_rt_id => p_parnt_acty_base_rt_id
1244 ,p_pgm_id => p_pgm_id
1245 ,p_pl_id => p_pl_id
1246 ,p_oipl_id => p_oipl_id
1247 ,p_opt_id => p_opt_id
1248 ,p_oiplip_id => p_oiplip_id
1249 ,p_plip_id => p_plip_id
1250 ,p_ptip_id => p_ptip_id
1251 ,p_cmbn_plip_id => p_cmbn_plip_id
1252 ,p_cmbn_ptip_id => p_cmbn_ptip_id
1253 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
1254 ,p_vstg_for_acty_rt_id => p_vstg_for_acty_rt_id
1255 ,p_actl_prem_id => p_actl_prem_id
1256 ,p_TTL_COMP_LVL_FCTR_ID => p_TTL_COMP_LVL_FCTR_ID
1257 ,p_COST_ALLOCATION_KEYFLEX_ID => p_COST_ALLOCATION_KEYFLEX_ID
1258 ,p_ALWS_CHG_CD => p_ALWS_CHG_CD
1259 ,p_ele_entry_val_cd => p_ele_entry_val_cd
1260 ,p_pay_rate_grade_rule_id => p_pay_rate_grade_rule_id
1261 ,p_rate_periodization_cd => p_rate_periodization_cd
1262 ,p_rate_periodization_rl => p_rate_periodization_rl
1263 ,p_mn_mx_elcn_rl => p_mn_mx_elcn_rl
1264 ,p_mapping_table_name => p_mapping_table_pk_id
1265 ,p_mapping_table_pk_id => p_mapping_table_pk_id
1266 ,p_business_group_id => p_business_group_id
1267 ,p_context_pgm_id => p_context_pgm_id
1268 ,p_context_pl_id => p_context_pl_id
1269 ,p_context_opt_id => p_context_opt_id
1270 ,p_element_det_rl => p_element_det_rl
1271 ,p_currency_det_cd => p_currency_det_cd
1272 ,p_abr_attribute_category => p_abr_attribute_category
1273 ,p_abr_attribute1 => p_abr_attribute1
1274 ,p_abr_attribute2 => p_abr_attribute2
1275 ,p_abr_attribute3 => p_abr_attribute3
1276 ,p_abr_attribute4 => p_abr_attribute4
1277 ,p_abr_attribute5 => p_abr_attribute5
1278 ,p_abr_attribute6 => p_abr_attribute6
1279 ,p_abr_attribute7 => p_abr_attribute7
1280 ,p_abr_attribute8 => p_abr_attribute8
1281 ,p_abr_attribute9 => p_abr_attribute9
1282 ,p_abr_attribute10 => p_abr_attribute10
1283 ,p_abr_attribute11 => p_abr_attribute11
1284 ,p_abr_attribute12 => p_abr_attribute12
1285 ,p_abr_attribute13 => p_abr_attribute13
1286 ,p_abr_attribute14 => p_abr_attribute14
1287 ,p_abr_attribute15 => p_abr_attribute15
1288 ,p_abr_attribute16 => p_abr_attribute16
1289 ,p_abr_attribute17 => p_abr_attribute17
1290 ,p_abr_attribute18 => p_abr_attribute18
1291 ,p_abr_attribute19 => p_abr_attribute19
1292 ,p_abr_attribute20 => p_abr_attribute20
1293 ,p_abr_attribute21 => p_abr_attribute21
1294 ,p_abr_attribute22 => p_abr_attribute22
1295 ,p_abr_attribute23 => p_abr_attribute23
1296 ,p_abr_attribute24 => p_abr_attribute24
1297 ,p_abr_attribute25 => p_abr_attribute25
1298 ,p_abr_attribute26 => p_abr_attribute26
1299 ,p_abr_attribute27 => p_abr_attribute27
1300 ,p_abr_attribute28 => p_abr_attribute28
1301 ,p_abr_attribute29 => p_abr_attribute29
1302 ,p_abr_attribute30 => p_abr_attribute30
1303 ,p_abr_seq_num => p_abr_seq_num
1304 ,p_object_version_number => l_object_version_number
1305 ,p_effective_date => p_effective_date
1306 ,p_datetrack_mode => p_datetrack_mode
1307 );
1308 exception
1309 when hr_api.cannot_find_prog_unit then
1310 hr_api.cannot_find_prog_unit_error
1311 (p_module_name => 'UPDATE_acty_base_rate'
1312 ,p_hook_type => 'AP'
1313 );
1314 --
1315 -- End of API User Hook for the after hook of update_acty_base_rate
1316 --
1317 end;
1318 --
1319 hr_utility.set_location(l_proc, 60);
1320 --
1321 -- When in validation only mode raise the Validate_Enabled exception
1322 --
1323 if p_validate then
1324 raise hr_api.validate_enabled;
1325 end if;
1326 --
1327 -- Set all output arguments
1328 --
1329 p_object_version_number := l_object_version_number;
1330 p_effective_start_date := l_effective_start_date;
1331 p_effective_end_date := l_effective_end_date;
1332 --
1333 hr_utility.set_location(' Leaving:'||l_proc, 70);
1334 --
1335 exception
1336 --
1337 when hr_api.validate_enabled then
1338 --
1339 -- As the Validate_Enabled exception has been raised
1340 -- we must rollback to the savepoint
1341 --
1342 ROLLBACK TO update_acty_base_rate;
1343 --
1344 -- Only set output warning arguments
1345 -- (Any key or derived arguments must be set to null
1346 -- when validation only mode is being used.)
1347 --
1348 hr_utility.set_location(' Leaving:'||l_proc, 80);
1349 --
1350 when others then
1351 --
1352 -- A validation or unexpected error has occured
1353 --
1354 p_effective_start_date := null;
1355 p_effective_end_date := null;
1356 p_object_version_number := l_object_version_number;
1357
1358 ROLLBACK TO update_acty_base_rate;
1359 raise;
1360 --
1361 end update_acty_base_rate;
1362 -- ----------------------------------------------------------------------------
1363 -- |------------------------< delete_acty_base_rate >----------------------|
1364 -- ----------------------------------------------------------------------------
1365 --
1366 procedure delete_acty_base_rate
1367 (p_validate in boolean default false
1368 ,p_acty_base_rt_id in number
1369 ,p_effective_start_date out nocopy date
1370 ,p_effective_end_date out nocopy date
1371 ,p_object_version_number in out nocopy number
1372 ,p_effective_date in date
1373 ,p_datetrack_mode in varchar2
1374 ) is
1375 --
1376 -- Declare cursors and local variables
1377 --
1378 l_proc varchar2(72) := g_package||'update_acty_base_rate';
1379 l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
1380 l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
1381 l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
1382 l_dummy varchar2(1);
1383 l_error boolean;
1384 --
1385 cursor c_chk_ecr is
1386 select 'x'
1387 from ben_enrt_rt ecr,
1388 ben_elig_per_elctbl_chc epe,
1389 ben_per_in_ler pil
1390 where ecr.acty_base_rt_id = p_acty_base_rt_id
1391 and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
1392 and pil.per_in_ler_id = epe.per_in_ler_id
1393 and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1394 union
1395 select 'x'
1396 from ben_enrt_rt ecr,
1397 ben_enrt_bnft enb,
1398 ben_elig_per_elctbl_chc epe,
1399 ben_per_in_ler pil
1400 where ecr.acty_base_rt_id = p_acty_base_rt_id
1401 and enb.enrt_bnft_id = ecr.enrt_bnft_id
1402 and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
1403 and pil.per_in_ler_id = epe.per_in_ler_id
1404 and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
1405
1406 cursor c_chk_prv is
1407 select 'x'
1408 from ben_prtt_rt_val
1409 where acty_base_rt_id = p_acty_base_rt_id
1410 and prtt_rt_val_stat_cd is null;
1411
1412 begin
1413 --
1414 hr_utility.set_location('Entering:'|| l_proc, 10);
1415 --
1416 -- Issue a savepoint if operating in validation only mode
1417 --
1418 savepoint delete_acty_base_rate;
1419 --
1420 hr_utility.set_location(l_proc, 20);
1421 --
1422 -- Bug 3636162, Following If condition added so as to avoid the check for records
1423 -- in ben_prtt_rt, ben_enrt_rt tables for delete modes FUTURE_CHANGE, DELETE_NEXT_CHANGE.
1424 --
1425 if p_datetrack_mode not in ('DELETE_NEXT_CHANGE','FUTURE_CHANGE') then
1426 open c_chk_ecr;
1427 fetch c_chk_ecr into l_dummy;
1428 l_error := c_chk_ecr%found;
1429 close c_chk_ecr;
1430 --
1431 if not l_error then
1432 open c_chk_prv;
1433 fetch c_chk_prv into l_dummy;
1434 l_error := c_chk_prv%found;
1435 close c_chk_prv;
1436 end if;
1437 --
1438 if l_error then
1439 fnd_message.set_name('BEN','BEN_93678_CANNOT_DEL_ABR');
1440 fnd_message.raise_error;
1441 end if;
1442 --
1443 End If;
1444 -- Process Logic
1445 --
1446 l_object_version_number := p_object_version_number;
1447 --
1448 --
1449 begin
1450 --
1451 -- Start of API User Hook for the before hook of delete_acty_base_rate
1452 --
1453 ben_acty_base_rate_bk3.delete_acty_base_rate_b
1454 (
1455 p_acty_base_rt_id => p_acty_base_rt_id
1456 ,p_object_version_number => p_object_version_number
1457 ,p_effective_date => p_effective_date
1458 ,p_datetrack_mode => p_datetrack_mode
1459 );
1460 exception
1461 when hr_api.cannot_find_prog_unit then
1462 hr_api.cannot_find_prog_unit_error
1463 (p_module_name => 'DELETE_acty_base_rate'
1464 ,p_hook_type => 'BP'
1465 );
1466 --
1467 -- End of API User Hook for the before hook of delete_acty_base_rate
1468 --
1469 end;
1470 --
1471 ben_abr_del.del
1472 (
1473 p_acty_base_rt_id => p_acty_base_rt_id
1474 ,p_effective_start_date => l_effective_start_date
1475 ,p_effective_end_date => l_effective_end_date
1476 ,p_object_version_number => l_object_version_number
1477 ,p_effective_date => p_effective_date
1478 ,p_datetrack_mode => p_datetrack_mode
1479 );
1480 --
1481 begin
1482 --
1483 -- Start of API User Hook for the after hook of delete_acty_base_rate
1484 --
1485 ben_acty_base_rate_bk3.delete_acty_base_rate_a
1486 (
1487 p_acty_base_rt_id => p_acty_base_rt_id
1488 ,p_effective_start_date => l_effective_start_date
1489 ,p_effective_end_date => l_effective_end_date
1490 ,p_object_version_number => l_object_version_number
1491 ,p_effective_date => p_effective_date
1492 ,p_datetrack_mode => p_datetrack_mode
1493 );
1494 exception
1495 when hr_api.cannot_find_prog_unit then
1496 hr_api.cannot_find_prog_unit_error
1497 (p_module_name => 'DELETE_acty_base_rate'
1498 ,p_hook_type => 'AP'
1499 );
1500 --
1501 -- End of API User Hook for the after hook of delete_acty_base_rate
1502 --
1503 end;
1504 --
1505 hr_utility.set_location(l_proc, 60);
1506 --
1507 -- When in validation only mode raise the Validate_Enabled exception
1508 --
1509 if p_validate then
1510 raise hr_api.validate_enabled;
1511 end if;
1512 --
1513 hr_utility.set_location(' Leaving:'||l_proc, 70);
1514 --
1515 exception
1516 --
1517 when hr_api.validate_enabled then
1518 --
1519 -- As the Validate_Enabled exception has been raised
1520 -- we must rollback to the savepoint
1521 --
1522 ROLLBACK TO delete_acty_base_rate;
1523 --
1524 -- Only set output warning arguments
1525 -- (Any key or derived arguments must be set to null
1526 -- when validation only mode is being used.)
1527 --
1528 -- uncommented for the nocopy
1529 --
1530 p_effective_start_date := null;
1531 p_effective_end_date := null;
1532 --
1533 when others then
1534 --
1535 -- A validation or unexpected error has occured
1536 --
1537 p_effective_start_date := null;
1538 p_effective_end_date := null;
1539 p_object_version_number := l_object_version_number;
1540 --
1541 ROLLBACK TO delete_acty_base_rate;
1542 raise;
1543 --
1544 end delete_acty_base_rate;
1545 --
1546 -- ----------------------------------------------------------------------------
1547 -- |-------------------------------< lck >------------------------------------|
1548 -- ----------------------------------------------------------------------------
1549 --
1550 procedure lck
1551 (
1552 p_acty_base_rt_id in number
1553 ,p_object_version_number in number
1554 ,p_effective_date in date
1555 ,p_datetrack_mode in varchar2
1556 ,p_validation_start_date out nocopy date
1557 ,p_validation_end_date out nocopy date
1558 ) is
1559 --
1560 --
1561 -- Declare cursors and local variables
1562 --
1563 l_proc varchar2(72) := g_package||'lck';
1564 l_validation_start_date date;
1565 l_validation_end_date date;
1566 --
1567 begin
1568 --
1569 hr_utility.set_location('Entering:'|| l_proc, 10);
1570 --
1571 ben_abr_shd.lck
1572 (
1573 p_acty_base_rt_id => p_acty_base_rt_id
1574 ,p_validation_start_date => l_validation_start_date
1575 ,p_validation_end_date => l_validation_end_date
1576 ,p_object_version_number => p_object_version_number
1577 ,p_effective_date => p_effective_date
1578 ,p_datetrack_mode => p_datetrack_mode
1579 );
1580 --
1581 hr_utility.set_location(' Leaving:'||l_proc, 70);
1582 --
1583 end lck;
1584 --
1585 end ben_acty_base_rate_api;