1 Package ben_acty_base_rate_api as
2 /* $Header: beabrapi.pkh 120.3 2006/01/19 07:56:21 swjain noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_acty_base_rate >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_ordr_num Yes number
18 -- p_acty_typ_cd No varchar2
19 -- p_sub_acty_typ_cd No varchar2
20 -- p_name No varchar2
21 -- p_rt_typ_cd No varchar2
22 -- p_bnft_rt_typ_cd No varchar2
23 -- p_tx_typ_cd No varchar2
24 -- p_use_to_calc_net_flx_cr_flag Yes varchar2
25 -- p_asn_on_enrt_flag Yes varchar2
26 -- p_abv_mx_elcn_val_alwd_flag Yes varchar2
27 -- p_blw_mn_elcn_alwd_flag Yes varchar2
28 -- p_dsply_on_enrt_flag Yes varchar2
29 -- p_parnt_chld_cd No varchar2
30 -- p_use_calc_acty_bs_rt_flag Yes varchar2
31 -- p_uses_ded_sched_flag Yes varchar2
32 -- p_uses_varbl_rt_flag Yes varchar2
33 -- p_vstg_sched_apls_flag Yes varchar2
34 -- p_rt_mlt_cd No varchar2
35 -- p_proc_each_pp_dflt_flag Yes varchar2
36 -- p_prdct_flx_cr_when_elig_flag Yes varchar2
37 -- p_no_std_rt_used_flag Yes varchar2
38 -- p_rcrrg_cd No varchar2
39 -- p_mn_elcn_val No number
40 -- p_mx_elcn_val No number
41 -- p_lwr_lmt_val No number
42 -- p_lwr_lmt_calc_rl No number
43 -- p_upr_lmt_val No number
44 -- p_upr_lmt_calc_rl No number
45 -- p_ptd_comp_lvl_fctr_id No number
46 -- p_clm_comp_lvl_fctr_id No number
47 -- p_entr_ann_val_flag No varchar2
48 -- p_ann_mn_elcn_val No number
49 -- p_ann_mx_elcn_val No number
50 -- p_wsh_rl_dy_mo_num No number
51 -- p_uses_pymt_sched_flag Yes varchar2
52 -- p_nnmntry_uom No varchar2
53 -- p_val No number
54 -- p_incrmt_elcn_val No number
55 -- p_rndg_cd No varchar2
56 -- p_val_ovrid_alwd_flag Yes varchar2
57 -- p_prtl_mo_det_mthd_cd No varchar2
58 -- p_acty_base_rt_stat_cd No varchar2
59 -- p_procg_src_cd No varchar2
60 -- p_dflt_val No number
61 -- p_dflt_flag Yes varchar2
62 -- p_frgn_erg_ded_typ_cd No varchar2
63 -- p_frgn_erg_ded_name No varchar2
64 -- p_frgn_erg_ded_ident No varchar2
65 -- p_no_mx_elcn_val_dfnd_flag Yes varchar2
66 -- p_prtl_mo_det_mthd_rl No number
67 -- p_entr_val_at_enrt_flag Yes varchar2
68 -- p_prtl_mo_eff_dt_det_rl No number
69 -- p_rndg_rl No number
70 -- p_val_calc_rl No number
71 -- p_no_mn_elcn_val_dfnd_flag Yes varchar2
72 -- p_prtl_mo_eff_dt_det_cd No varchar2
73 -- p_only_one_bal_typ_alwd_flag Yes varchar2
74 -- p_rt_usg_cd No varchar2
75 -- p_prort_mn_ann_elcn_val_cd No varchar2
76 -- p_prort_mn_ann_elcn_val_rl No number
77 -- p_prort_mx_ann_elcn_val_cd No varchar2
78 -- p_prort_mx_ann_elcn_val_rl No number
79 -- p_one_ann_pymt_cd No varchar2
80 -- p_det_pl_ytd_cntrs_cd No varchar2
81 -- p_asmt_to_use_cd No varchar2
82 -- p_ele_rqd_flag Yes varchar2
83 -- p_subj_to_imptd_incm_flag Yes varchar2
84 -- p_element_type_id No number
85 -- p_input_value_id No number
86 -- p_input_va_calc_rl No number
87 -- p_comp_lvl_fctr_id No number
88 -- p_parnt_acty_base_rt_id No number
89 -- p_pgm_id No number
90 -- p_pl_id No number
91 -- p_oipl_id No number
92 -- p_oiplip_id No number
93 -- p_plip_id No number
94 -- p_ptip_id No number
95 -- p_cmbn_plip_id No number
96 -- p_cmbn_ptip_id No number
97 -- p_cmbn_ptip_opt_id No number
98 -- p_vstg_for_acty_rt_id No number
99 -- p_actl_prem_id No number
100 -- p_pay_rate_grade_rule_id No number
101 -- p_mn_mx_elcn_rl No number --3981982
102 -- p_business_group_id Yes number Business Group of Record
103 -- p_abr_attribute_category No varchar2 Descriptive Flexfield
104 -- p_abr_attribute1 No varchar2 Descriptive Flexfield
105 -- p_abr_attribute2 No varchar2 Descriptive Flexfield
106 -- p_abr_attribute3 No varchar2 Descriptive Flexfield
107 -- p_abr_attribute4 No varchar2 Descriptive Flexfield
108 -- p_abr_attribute5 No varchar2 Descriptive Flexfield
109 -- p_abr_attribute6 No varchar2 Descriptive Flexfield
110 -- p_abr_attribute7 No varchar2 Descriptive Flexfield
111 -- p_abr_attribute8 No varchar2 Descriptive Flexfield
112 -- p_abr_attribute9 No varchar2 Descriptive Flexfield
113 -- p_abr_attribute10 No varchar2 Descriptive Flexfield
114 -- p_abr_attribute11 No varchar2 Descriptive Flexfield
115 -- p_abr_attribute12 No varchar2 Descriptive Flexfield
116 -- p_abr_attribute13 No varchar2 Descriptive Flexfield
117 -- p_abr_attribute14 No varchar2 Descriptive Flexfield
118 -- p_abr_attribute15 No varchar2 Descriptive Flexfield
119 -- p_abr_attribute16 No varchar2 Descriptive Flexfield
120 -- p_abr_attribute17 No varchar2 Descriptive Flexfield
121 -- p_abr_attribute18 No varchar2 Descriptive Flexfield
122 -- p_abr_attribute19 No varchar2 Descriptive Flexfield
123 -- p_abr_attribute20 No varchar2 Descriptive Flexfield
124 -- p_abr_attribute21 No varchar2 Descriptive Flexfield
125 -- p_abr_attribute22 No varchar2 Descriptive Flexfield
126 -- p_abr_attribute23 No varchar2 Descriptive Flexfield
127 -- p_abr_attribute24 No varchar2 Descriptive Flexfield
128 -- p_abr_attribute25 No varchar2 Descriptive Flexfield
129 -- p_abr_attribute26 No varchar2 Descriptive Flexfield
130 -- p_abr_attribute27 No varchar2 Descriptive Flexfield
131 -- p_abr_attribute28 No varchar2 Descriptive Flexfield
132 -- p_abr_attribute29 No varchar2 Descriptive Flexfield
133 -- p_abr_attribute30 No varchar2 Descriptive Flexfield
134 -- p_effective_date Yes date Session Date.
135 --
136 -- Post Success:
137 --
138 -- Out Parameters:
139 -- Name Type Description
140 -- p_acty_base_rt_id Yes number PK of record
141 -- p_effective_start_date Yes date Effective Start Date of Record
142 -- p_effective_end_date Yes date Effective End Date of Record
143 -- p_object_version_number No number OVN of record
144 --
145 -- Post Failure:
146 --
147 -- Access Status:
148 -- Public.
149 --
150 -- {End Of Comments}
151 --
152 procedure create_acty_base_rate
153 (
154 p_validate in boolean default false
155 ,p_acty_base_rt_id out nocopy number
156 ,p_effective_start_date out nocopy date
157 ,p_effective_end_date out nocopy date
158 ,p_ordr_num in number default null
159 ,p_acty_typ_cd in varchar2 default null
160 ,p_sub_acty_typ_cd in varchar2 default null
161 ,p_name in varchar2 default null
162 ,p_rt_typ_cd in varchar2 default null
163 ,p_bnft_rt_typ_cd in varchar2 default null
164 ,p_tx_typ_cd in varchar2 default null
165 ,p_use_to_calc_net_flx_cr_flag in varchar2 default 'N'
166 ,p_asn_on_enrt_flag in varchar2 default 'N'
167 ,p_abv_mx_elcn_val_alwd_flag in varchar2 default 'N'
168 ,p_blw_mn_elcn_alwd_flag in varchar2 default 'N'
169 ,p_dsply_on_enrt_flag in varchar2 default 'N'
170 ,p_parnt_chld_cd in varchar2 default null
171 ,p_use_calc_acty_bs_rt_flag in varchar2 default 'Y'
172 ,p_uses_ded_sched_flag in varchar2 default 'N'
173 ,p_uses_varbl_rt_flag in varchar2 default 'N'
174 ,p_vstg_sched_apls_flag in varchar2 default 'N'
175 ,p_rt_mlt_cd in varchar2 default null
176 ,p_proc_each_pp_dflt_flag in varchar2 default 'N'
177 ,p_prdct_flx_cr_when_elig_flag in varchar2 default 'N'
178 ,p_no_std_rt_used_flag in varchar2 default 'N'
179 ,p_rcrrg_cd in varchar2 default null
180 ,p_mn_elcn_val in number default null
181 ,p_mx_elcn_val in number default null
182 ,p_lwr_lmt_val in number default null
183 ,p_lwr_lmt_calc_rl in number default null
184 ,p_upr_lmt_val in number default null
185 ,p_upr_lmt_calc_rl in number default null
186 ,p_ptd_comp_lvl_fctr_id in number default null
187 ,p_clm_comp_lvl_fctr_id in number default null
188 ,p_entr_ann_val_flag in varchar2 default 'N'
189 ,p_ann_mn_elcn_val in number default null
190 ,p_ann_mx_elcn_val in number default null
191 ,p_wsh_rl_dy_mo_num in number default null
192 ,p_uses_pymt_sched_flag in varchar2 default 'N'
193 ,p_nnmntry_uom in varchar2 default null
194 ,p_val in number default null
195 ,p_incrmt_elcn_val in number default null
196 ,p_rndg_cd in varchar2 default null
197 ,p_val_ovrid_alwd_flag in varchar2 default 'N'
198 ,p_prtl_mo_det_mthd_cd in varchar2 default null
199 ,p_acty_base_rt_stat_cd in varchar2 default null
200 ,p_procg_src_cd in varchar2 default null
201 ,p_dflt_val in number default null
202 ,p_dflt_flag in varchar2 default 'N'
203 ,p_frgn_erg_ded_typ_cd in varchar2 default null
204 ,p_frgn_erg_ded_name in varchar2 default null
205 ,p_frgn_erg_ded_ident in varchar2 default null
206 ,p_no_mx_elcn_val_dfnd_flag in varchar2 default 'N'
207 ,p_prtl_mo_det_mthd_rl in number default null
208 ,p_entr_val_at_enrt_flag in varchar2 default 'N'
209 ,p_prtl_mo_eff_dt_det_rl in number default null
210 ,p_rndg_rl in number default null
211 ,p_val_calc_rl in number default null
212 ,p_no_mn_elcn_val_dfnd_flag in varchar2 default 'N'
213 ,p_prtl_mo_eff_dt_det_cd in varchar2 default null
214 ,p_only_one_bal_typ_alwd_flag in varchar2 default 'N'
215 ,p_rt_usg_cd in varchar2 default null
216 ,p_prort_mn_ann_elcn_val_cd in varchar2 default null
217 ,p_prort_mn_ann_elcn_val_rl in number default null
218 ,p_prort_mx_ann_elcn_val_cd in varchar2 default null
219 ,p_prort_mx_ann_elcn_val_rl in number default null
220 ,p_one_ann_pymt_cd in varchar2 default null
221 ,p_det_pl_ytd_cntrs_cd in varchar2 default null
222 ,p_asmt_to_use_cd in varchar2 default null
223 ,p_ele_rqd_flag in varchar2 default 'Y'
224 ,p_subj_to_imptd_incm_flag in varchar2 default 'N'
225 ,p_element_type_id in number default null
226 ,p_input_value_id in number default null
227 ,p_input_va_calc_rl in number default null
228 ,p_comp_lvl_fctr_id in number default null
229 ,p_parnt_acty_base_rt_id in number default null
230 ,p_pgm_id in number default null
231 ,p_pl_id in number default null
232 ,p_oipl_id in number default null
233 ,p_opt_id in number default null
234 ,p_oiplip_id in number default null
235 ,p_plip_id in number default null
236 ,p_ptip_id in number default null
237 ,p_cmbn_plip_id in number default null
238 ,p_cmbn_ptip_id in number default null
239 ,p_cmbn_ptip_opt_id in number default null
240 ,p_vstg_for_acty_rt_id in number default null
241 ,p_actl_prem_id in number default null
242 ,p_TTL_COMP_LVL_FCTR_ID in number default null
243 ,p_COST_ALLOCATION_KEYFLEX_ID in number default null
244 ,p_ALWS_CHG_CD in varchar2 default null
245 ,p_ele_entry_val_cd in varchar2 default null
246 ,p_pay_rate_grade_rule_id in number default null
247 ,p_rate_periodization_cd in varchar2 default null
248 ,p_rate_periodization_rl in number default null
249 ,p_mn_mx_elcn_rl in number default null
250 ,p_mapping_table_name in varchar2 default null
251 ,p_mapping_table_pk_id in number default null
252 ,p_business_group_id in number default null
253 ,p_context_pgm_id in number default null
254 ,p_context_pl_id in number default null
255 ,p_context_opt_id in number default null
256 ,p_element_det_rl in number default null
257 ,p_currency_det_cd in varchar2 default null
258 ,p_abr_attribute_category in varchar2 default null
259 ,p_abr_attribute1 in varchar2 default null
260 ,p_abr_attribute2 in varchar2 default null
261 ,p_abr_attribute3 in varchar2 default null
262 ,p_abr_attribute4 in varchar2 default null
263 ,p_abr_attribute5 in varchar2 default null
264 ,p_abr_attribute6 in varchar2 default null
265 ,p_abr_attribute7 in varchar2 default null
266 ,p_abr_attribute8 in varchar2 default null
267 ,p_abr_attribute9 in varchar2 default null
268 ,p_abr_attribute10 in varchar2 default null
269 ,p_abr_attribute11 in varchar2 default null
270 ,p_abr_attribute12 in varchar2 default null
271 ,p_abr_attribute13 in varchar2 default null
272 ,p_abr_attribute14 in varchar2 default null
273 ,p_abr_attribute15 in varchar2 default null
274 ,p_abr_attribute16 in varchar2 default null
275 ,p_abr_attribute17 in varchar2 default null
276 ,p_abr_attribute18 in varchar2 default null
277 ,p_abr_attribute19 in varchar2 default null
278 ,p_abr_attribute20 in varchar2 default null
279 ,p_abr_attribute21 in varchar2 default null
280 ,p_abr_attribute22 in varchar2 default null
281 ,p_abr_attribute23 in varchar2 default null
282 ,p_abr_attribute24 in varchar2 default null
283 ,p_abr_attribute25 in varchar2 default null
284 ,p_abr_attribute26 in varchar2 default null
285 ,p_abr_attribute27 in varchar2 default null
286 ,p_abr_attribute28 in varchar2 default null
287 ,p_abr_attribute29 in varchar2 default null
288 ,p_abr_attribute30 in varchar2 default null
289 ,p_abr_seq_num in number default null
290 ,p_object_version_number out nocopy number
291 ,p_effective_date in date
292 );
293 -- ----------------------------------------------------------------------------
297 --
294 -- |------------------------< update_acty_base_rate >------------------------|
295 -- ----------------------------------------------------------------------------
296 -- {Start Of Comments}
298 -- Description:
299 --
300 -- Prerequisites:
301 --
302 --
303 -- In Parameters:
304 -- Name Reqd Type Description
305 -- p_validate Yes boolean Commit or Rollback.
306 -- p_acty_base_rt_id Yes number PK of record
307 -- p_ordr_num Yes number
308 -- p_acty_typ_cd No varchar2
309 -- p_name No varchar2
310 -- p_rt_typ_cd No varchar2
311 -- p_bnft_rt_typ_cd No varchar2
312 -- p_tx_typ_cd No varchar2
313 -- p_use_to_calc_net_flx_cr_flag Yes varchar2
314 -- p_asn_on_enrt_flag Yes varchar2
315 -- p_abv_mx_elcn_val_alwd_flag Yes varchar2
316 -- p_blw_mn_elcn_alwd_flag Yes varchar2
317 -- p_dsply_on_enrt_flag Yes varchar2
318 -- p_parnt_chld_cd No varchar2
319 -- p_use_calc_acty_bs_rt_flag Yes varchar2
320 -- p_uses_ded_sched_flag Yes varchar2
321 -- p_uses_varbl_rt_flag Yes varchar2
322 -- p_vstg_sched_apls_flag Yes varchar2
323 -- p_rt_mlt_cd No varchar2
324 -- p_proc_each_pp_dflt_flag Yes varchar2
325 -- p_prdct_flx_cr_when_elig_flag Yes varchar2
326 -- p_no_std_rt_used_flag Yes varchar2
327 -- p_rcrrg_cd No varchar2
328 -- p_mn_elcn_val No number
329 -- p_mx_elcn_val No number
330 -- p_lwr_lmt_val No number
331 -- p_lwr_lmt_calc_rl No number
332 -- p_upr_lmt_val No number
333 -- p_upr_lmt_calc_rl No number
334 -- p_ptd_comp_lvl_fctr_id No number
335 -- p_clm_comp_lvl_fctr_id No number
336 -- p_entr_ann_val_flag No varchar2
337 -- p_ann_mn_elcn_val No number
338 -- p_ann_mx_elcn_val No number
339 -- p_wsh_rl_dy_mo_num No number
340 -- p_uses_pymt_sched_flag Yes varchar2
341 -- p_nnmntry_uom No varchar2
342 -- p_val No number
343 -- p_incrmt_elcn_val No number
344 -- p_rndg_cd No varchar2
345 -- p_val_ovrid_alwd_flag Yes varchar2
346 -- p_prtl_mo_det_mthd_cd No varchar2
347 -- p_acty_base_rt_stat_cd No varchar2
348 -- p_procg_src_cd No varchar2
349 -- p_dflt_val No number
350 -- p_dflt_flag Yes varchar2
351 -- p_frgn_erg_ded_typ_cd No varchar2
352 -- p_frgn_erg_ded_name No varchar2
353 -- p_frgn_erg_ded_ident No varchar2
354 -- p_no_mx_elcn_val_dfnd_flag Yes varchar2
355 -- p_prtl_mo_det_mthd_rl No number
356 -- p_entr_val_at_enrt_flag Yes varchar2
357 -- p_prtl_mo_eff_dt_det_rl No number
358 -- p_rndg_rl No number
359 -- p_val_calc_rl No number
360 -- p_no_mn_elcn_val_dfnd_flag Yes varchar2
361 -- p_prtl_mo_eff_dt_det_cd No varchar2
362 -- p_only_one_bal_typ_alwd_flag Yes varchar2
363 -- p_rt_usg_cd No varchar2
364 -- p_prort_mn_ann_elcn_val_cd No varchar2
365 -- p_prort_mn_ann_elcn_val_rl No number
366 -- p_prort_mx_ann_elcn_val_cd No varchar2
367 -- p_prort_mx_ann_elcn_val_rl No number
368 -- p_one_ann_pymt_cd No varchar2
369 -- p_det_pl_ytd_cntrs_cd No varchar2
370 -- p_asmt_to_use_cd No varchar2
371 -- p_ele_rqd_flag Yes varchar2
372 -- p_subj_to_imptd_incm_flag Yes varchar2
373 -- p_element_type_id No number
374 -- p_input_value_id No number
375 -- p_input_va_calc_rl No number
376 -- p_comp_lvl_fctr_id No number
377 -- p_parnt_acty_base_rt_id No number
378 -- p_pgm_id No number
379 -- p_pl_id No number
380 -- p_oipl_id No number
381 -- p_oiplip_id No number
382 -- p_plip_id No number
383 -- p_ptip_id No number
384 -- p_cmbn_plip_id No number
385 -- p_cmbn_ptip_id No number
386 -- p_cmbn_ptip_opt_id No number
387 -- p_vstg_for_acty_rt_id No number
388 -- p_actl_prem_id No number
389 -- p_mn_mx_n_rl No number
390 -- p_business_group_id Yes number Business Group of Record
391 -- p_abr_attribute_category No varchar2 Descriptive Flexfield
392 -- p_abr_attribute1 No varchar2 Descriptive Flexfield
393 -- p_abr_attribute2 No varchar2 Descriptive Flexfield
394 -- p_abr_attribute3 No varchar2 Descriptive Flexfield
395 -- p_abr_attribute4 No varchar2 Descriptive Flexfield
396 -- p_abr_attribute5 No varchar2 Descriptive Flexfield
397 -- p_abr_attribute6 No varchar2 Descriptive Flexfield
398 -- p_abr_attribute7 No varchar2 Descriptive Flexfield
399 -- p_abr_attribute8 No varchar2 Descriptive Flexfield
403 -- p_abr_attribute12 No varchar2 Descriptive Flexfield
400 -- p_abr_attribute9 No varchar2 Descriptive Flexfield
401 -- p_abr_attribute10 No varchar2 Descriptive Flexfield
402 -- p_abr_attribute11 No varchar2 Descriptive Flexfield
404 -- p_abr_attribute13 No varchar2 Descriptive Flexfield
405 -- p_abr_attribute14 No varchar2 Descriptive Flexfield
406 -- p_abr_attribute15 No varchar2 Descriptive Flexfield
407 -- p_abr_attribute16 No varchar2 Descriptive Flexfield
408 -- p_abr_attribute17 No varchar2 Descriptive Flexfield
409 -- p_abr_attribute18 No varchar2 Descriptive Flexfield
410 -- p_abr_attribute19 No varchar2 Descriptive Flexfield
411 -- p_abr_attribute20 No varchar2 Descriptive Flexfield
412 -- p_abr_attribute21 No varchar2 Descriptive Flexfield
413 -- p_abr_attribute22 No varchar2 Descriptive Flexfield
414 -- p_abr_attribute23 No varchar2 Descriptive Flexfield
415 -- p_abr_attribute24 No varchar2 Descriptive Flexfield
416 -- p_abr_attribute25 No varchar2 Descriptive Flexfield
417 -- p_abr_attribute26 No varchar2 Descriptive Flexfield
418 -- p_abr_attribute27 No varchar2 Descriptive Flexfield
419 -- p_abr_attribute28 No varchar2 Descriptive Flexfield
420 -- p_abr_attribute29 No varchar2 Descriptive Flexfield
421 -- p_abr_attribute30 No varchar2 Descriptive Flexfield
422 -- p_effective_date Yes date Session Date.
423 -- p_datetrack_mode Yes varchar2 Datetrack mode.
424 --
425 -- Post Success:
426 --
427 -- Name Type Description
428 -- p_effective_start_date Yes date Effective Start Date of Record
429 -- p_effective_end_date Yes date Effective End Date of Record
430 -- p_object_version_number No number OVN of record
431 --
432 -- Post Failure:
433 --
434 -- Access Status:
435 -- Public.
436 --
437 -- {End Of Comments}
438 --
439 procedure update_acty_base_rate
440 (
441 p_validate in boolean default false
442 ,p_acty_base_rt_id in number
443 ,p_effective_start_date out nocopy date
444 ,p_effective_end_date out nocopy date
445 ,p_ordr_num in number default hr_api.g_number
446 ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
447 ,p_sub_acty_typ_cd in varchar2 default hr_api.g_varchar2
448 ,p_name in varchar2 default hr_api.g_varchar2
449 ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
450 ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
451 ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
452 ,p_use_to_calc_net_flx_cr_flag in varchar2 default hr_api.g_varchar2
453 ,p_asn_on_enrt_flag in varchar2 default hr_api.g_varchar2
454 ,p_abv_mx_elcn_val_alwd_flag in varchar2 default hr_api.g_varchar2
455 ,p_blw_mn_elcn_alwd_flag in varchar2 default hr_api.g_varchar2
456 ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
457 ,p_parnt_chld_cd in varchar2 default hr_api.g_varchar2
458 ,p_use_calc_acty_bs_rt_flag in varchar2 default hr_api.g_varchar2
459 ,p_uses_ded_sched_flag in varchar2 default hr_api.g_varchar2
460 ,p_uses_varbl_rt_flag in varchar2 default hr_api.g_varchar2
461 ,p_vstg_sched_apls_flag in varchar2 default hr_api.g_varchar2
462 ,p_rt_mlt_cd in varchar2 default hr_api.g_varchar2
463 ,p_proc_each_pp_dflt_flag in varchar2 default hr_api.g_varchar2
464 ,p_prdct_flx_cr_when_elig_flag in varchar2 default hr_api.g_varchar2
465 ,p_no_std_rt_used_flag in varchar2 default hr_api.g_varchar2
466 ,p_rcrrg_cd in varchar2 default hr_api.g_varchar2
467 ,p_mn_elcn_val in number default hr_api.g_number
468 ,p_mx_elcn_val in number default hr_api.g_number
469 ,p_lwr_lmt_val in number default hr_api.g_number
470 ,p_lwr_lmt_calc_rl in number default hr_api.g_number
471 ,p_upr_lmt_val in number default hr_api.g_number
472 ,p_upr_lmt_calc_rl in number default hr_api.g_number
473 ,p_ptd_comp_lvl_fctr_id in number default hr_api.g_number
474 ,p_clm_comp_lvl_fctr_id in number default hr_api.g_number
475 ,p_entr_ann_val_flag in varchar2 default hr_api.g_varchar2
476 ,p_ann_mn_elcn_val in number default hr_api.g_number
477 ,p_ann_mx_elcn_val in number default hr_api.g_number
478 ,p_wsh_rl_dy_mo_num in number default hr_api.g_number
479 ,p_uses_pymt_sched_flag in varchar2 default hr_api.g_varchar2
480 ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
481 ,p_val in number default hr_api.g_number
482 ,p_incrmt_elcn_val in number default hr_api.g_number
483 ,p_rndg_cd in varchar2 default hr_api.g_varchar2
484 ,p_val_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
485 ,p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2
486 ,p_acty_base_rt_stat_cd in varchar2 default hr_api.g_varchar2
490 ,p_frgn_erg_ded_typ_cd in varchar2 default hr_api.g_varchar2
487 ,p_procg_src_cd in varchar2 default hr_api.g_varchar2
488 ,p_dflt_val in number default hr_api.g_number
489 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
491 ,p_frgn_erg_ded_name in varchar2 default hr_api.g_varchar2
492 ,p_frgn_erg_ded_ident in varchar2 default hr_api.g_varchar2
493 ,p_no_mx_elcn_val_dfnd_flag in varchar2 default hr_api.g_varchar2
494 ,p_prtl_mo_det_mthd_rl in number default hr_api.g_number
495 ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
496 ,p_prtl_mo_eff_dt_det_rl in number default hr_api.g_number
497 ,p_rndg_rl in number default hr_api.g_number
498 ,p_val_calc_rl in number default hr_api.g_number
499 ,p_no_mn_elcn_val_dfnd_flag in varchar2 default hr_api.g_varchar2
500 ,p_prtl_mo_eff_dt_det_cd in varchar2 default hr_api.g_varchar2
501 ,p_only_one_bal_typ_alwd_flag in varchar2 default hr_api.g_varchar2
502 ,p_rt_usg_cd in varchar2 default hr_api.g_varchar2
503 ,p_prort_mn_ann_elcn_val_cd in varchar2 default hr_api.g_varchar2
504 ,p_prort_mn_ann_elcn_val_rl in number default hr_api.g_number
505 ,p_prort_mx_ann_elcn_val_cd in varchar2 default hr_api.g_varchar2
506 ,p_prort_mx_ann_elcn_val_rl in number default hr_api.g_number
507 ,p_one_ann_pymt_cd in varchar2 default hr_api.g_varchar2
508 ,p_det_pl_ytd_cntrs_cd in varchar2 default hr_api.g_varchar2
509 ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
510 ,p_ele_rqd_flag in varchar2 default hr_api.g_varchar2
511 ,p_subj_to_imptd_incm_flag in varchar2 default hr_api.g_varchar2
512 ,p_element_type_id in number default hr_api.g_number
513 ,p_input_value_id in number default hr_api.g_number
514 ,p_input_va_calc_rl in number default hr_api.g_number
515 ,p_comp_lvl_fctr_id in number default hr_api.g_number
516 ,p_parnt_acty_base_rt_id in number default hr_api.g_number
517 ,p_pgm_id in number default hr_api.g_number
518 ,p_pl_id in number default hr_api.g_number
519 ,p_oipl_id in number default hr_api.g_number
520 ,p_opt_id in number default hr_api.g_number
521 ,p_oiplip_id in number default hr_api.g_number
522 ,p_plip_id in number default hr_api.g_number
523 ,p_ptip_id in number default hr_api.g_number
524 ,p_cmbn_plip_id in number default hr_api.g_number
525 ,p_cmbn_ptip_id in number default hr_api.g_number
526 ,p_cmbn_ptip_opt_id in number default hr_api.g_number
527 ,p_vstg_for_acty_rt_id in number default hr_api.g_number
528 ,p_actl_prem_id in number default hr_api.g_number
529 ,p_TTL_COMP_LVL_FCTR_ID in number default hr_api.g_number
530 ,p_COST_ALLOCATION_KEYFLEX_ID in number default hr_api.g_number
531 ,p_ALWS_CHG_CD in varchar2 default hr_api.g_varchar2
532 ,p_ele_entry_val_cd in varchar2 default hr_api.g_varchar2
533 ,p_pay_rate_grade_rule_id in number default hr_api.g_number
534 ,p_rate_periodization_cd in varchar2 default hr_api.g_varchar2
535 ,p_rate_periodization_rl in number default hr_api.g_number
536 ,p_mn_mx_elcn_rl in number default hr_api.g_number
537 ,p_mapping_table_name in varchar2 default hr_api.g_varchar2
538 ,p_mapping_table_pk_id in number default hr_api.g_number
539 ,p_business_group_id in number default hr_api.g_number
540 ,p_context_pgm_id in number default hr_api.g_number
541 ,p_context_pl_id in number default hr_api.g_number
542 ,p_context_opt_id in number default hr_api.g_number
543 ,p_element_det_rl in number default hr_api.g_number
544 ,p_currency_det_cd in varchar2 default hr_api.g_varchar2
545 ,p_abr_attribute_category in varchar2 default hr_api.g_varchar2
546 ,p_abr_attribute1 in varchar2 default hr_api.g_varchar2
547 ,p_abr_attribute2 in varchar2 default hr_api.g_varchar2
548 ,p_abr_attribute3 in varchar2 default hr_api.g_varchar2
549 ,p_abr_attribute4 in varchar2 default hr_api.g_varchar2
550 ,p_abr_attribute5 in varchar2 default hr_api.g_varchar2
551 ,p_abr_attribute6 in varchar2 default hr_api.g_varchar2
552 ,p_abr_attribute7 in varchar2 default hr_api.g_varchar2
553 ,p_abr_attribute8 in varchar2 default hr_api.g_varchar2
554 ,p_abr_attribute9 in varchar2 default hr_api.g_varchar2
555 ,p_abr_attribute10 in varchar2 default hr_api.g_varchar2
556 ,p_abr_attribute11 in varchar2 default hr_api.g_varchar2
557 ,p_abr_attribute12 in varchar2 default hr_api.g_varchar2
558 ,p_abr_attribute13 in varchar2 default hr_api.g_varchar2
559 ,p_abr_attribute14 in varchar2 default hr_api.g_varchar2
560 ,p_abr_attribute15 in varchar2 default hr_api.g_varchar2
561 ,p_abr_attribute16 in varchar2 default hr_api.g_varchar2
562 ,p_abr_attribute17 in varchar2 default hr_api.g_varchar2
563 ,p_abr_attribute18 in varchar2 default hr_api.g_varchar2
564 ,p_abr_attribute19 in varchar2 default hr_api.g_varchar2
565 ,p_abr_attribute20 in varchar2 default hr_api.g_varchar2
566 ,p_abr_attribute21 in varchar2 default hr_api.g_varchar2
567 ,p_abr_attribute22 in varchar2 default hr_api.g_varchar2
568 ,p_abr_attribute23 in varchar2 default hr_api.g_varchar2
569 ,p_abr_attribute24 in varchar2 default hr_api.g_varchar2
570 ,p_abr_attribute25 in varchar2 default hr_api.g_varchar2
571 ,p_abr_attribute26 in varchar2 default hr_api.g_varchar2
572 ,p_abr_attribute27 in varchar2 default hr_api.g_varchar2
573 ,p_abr_attribute28 in varchar2 default hr_api.g_varchar2
574 ,p_abr_attribute29 in varchar2 default hr_api.g_varchar2
575 ,p_abr_attribute30 in varchar2 default hr_api.g_varchar2
576 ,p_abr_seq_num in number default hr_api.g_number
577 ,p_object_version_number in out nocopy number
578 ,p_effective_date in date
579 ,p_datetrack_mode in varchar2
580 );
581 --
582 -- ----------------------------------------------------------------------------
583 -- |------------------------< delete_acty_base_rate >------------------------|
584 -- ----------------------------------------------------------------------------
585 -- {Start Of Comments}
586 --
587 -- Description:
588 --
589 -- Prerequisites:
590 --
591 --
592 -- In Parameters:
593 -- Name Reqd Type Description
594 -- p_validate Yes boolean Commit or Rollback.
595 -- p_acty_base_rt_id Yes number PK of record
596 -- p_effective_date Yes date Session Date.
597 -- p_datetrack_mode Yes varchar2 Datetrack mode.
598 --
599 -- Post Success:
600 --
601 -- Name Type Description
602 -- p_effective_start_date Yes date Effective Start Date of Record
603 -- p_effective_end_date Yes date Effective End Date of Record
604 -- p_object_version_number No number OVN of record
605 --
606 -- Post Failure:
607 --
608 -- Access Status:
609 -- Public.
610 --
611 -- {End Of Comments}
612 --
613 procedure delete_acty_base_rate
614 (
615 p_validate in boolean default false
616 ,p_acty_base_rt_id in number
617 ,p_effective_start_date out nocopy date
618 ,p_effective_end_date out nocopy date
619 ,p_object_version_number in out nocopy number
620 ,p_effective_date in date
621 ,p_datetrack_mode in varchar2
622 );
623 --
624 -- ----------------------------------------------------------------------------
625 -- |----------------------------------< lck >---------------------------------|
626 -- ----------------------------------------------------------------------------
627 -- {Start Of Comments}
628 --
629 -- Description:
630 --
631 -- Prerequisites:
632 --
633 --
634 -- In Parameters:
635 -- Name Reqd Type Description
636 -- p_acty_base_rt_id Yes number PK of record
637 -- p_object_version_number Yes number OVN of record
638 -- p_effective_date Yes date Session Date.
639 -- p_datetrack_mode Yes varchar2 Datetrack mode.
640 --
641 -- Post Success:
642 --
643 -- Name Type Description
644 -- p_validation_start_date Yes Derived Effective Start Date.
645 -- p_validation_end_date Yes Derived Effective End Date.
646 --
647 -- Post Failure:
648 --
649 -- Access Status:
650 -- Public.
651 --
652 -- {End Of Comments}
653 --
654 procedure lck
655 (
656 p_acty_base_rt_id in number
657 ,p_object_version_number in number
658 ,p_effective_date in date
659 ,p_datetrack_mode in varchar2
660 ,p_validation_start_date out nocopy date
661 ,p_validation_end_date out nocopy date
662 );
663 --
664 end ben_acty_base_rate_api;
[Home] [Help]