1 Package ben_vrbl_rate_profile_api as
2 /* $Header: bevpfapi.pkh 120.0 2005/05/28 12:08:01 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_vrbl_rate_profile >----------------------|
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_pl_typ_opt_typ_id No number
18 -- p_pl_id No number
19 -- p_oipl_id No number
20 -- p_comp_lvl_fctr_id No number
21 -- p_business_group_id Yes number Business Group of Record
22 -- p_acty_typ_cd Yes varchar2
23 -- p_rt_typ_cd No varchar2
24 -- p_bnft_rt_typ_cd No varchar2
25 -- p_tx_typ_cd Yes varchar2
26 -- p_vrbl_rt_trtmt_cd Yes varchar2
27 -- p_acty_ref_perd_cd Yes varchar2
28 -- p_mlt_cd Yes varchar2
29 -- p_incrmnt_elcn_val No number
30 -- p_dflt_elcn_val No number
31 -- p_mx_elcn_val No number
32 -- p_mn_elcn_val No number
33 -- p_lwr_lmt_val No number
34 -- p_lwr_lmt_calc_rl No number
35 -- p_upr_lmt_val No number
36 -- p_upr_lmt_calc_rl No number
37 -- p_ultmt_upr_lmt No number
38 -- p_ultmt_lwr_lmt No number
39 -- p_ultmt_upr_lmt_calc_rl No number
40 -- p_ultmt_lwr_lmt_calc_rl No number
41 -- p_ann_mn_elcn_val No number
42 -- p_ann_mx_elcn_val No number
43 -- p_val No number
44 -- p_name Yes varchar2
45 -- p_no_mn_elcn_val_dfnd_flag Yes varchar2
46 -- p_no_mx_elcn_val_dfnd_flag Yes varchar2
47 -- p_alwys_sum_all_cvg_flag Yes varchar2
48 -- p_alwys_cnt_all_prtts_flag Yes varchar2
49 -- p_val_calc_rl No number
50 -- p_vrbl_rt_prfl_stat_cd No varchar2
51 -- p_vrbl_usg_cd No varchar2
52 -- p_asmt_to_use_cd No varchar2
53 -- p_rndg_cd No varchar2
54 -- p_rndg_rl No number
55 -- p_vpf_attribute_category No varchar2 Descriptive Flexfield
56 -- p_vpf_attribute1 No varchar2 Descriptive Flexfield
57 -- p_vpf_attribute2 No varchar2 Descriptive Flexfield
58 -- p_vpf_attribute3 No varchar2 Descriptive Flexfield
59 -- p_vpf_attribute4 No varchar2 Descriptive Flexfield
60 -- p_vpf_attribute5 No varchar2 Descriptive Flexfield
61 -- p_vpf_attribute6 No varchar2 Descriptive Flexfield
62 -- p_vpf_attribute7 No varchar2 Descriptive Flexfield
63 -- p_vpf_attribute8 No varchar2 Descriptive Flexfield
64 -- p_vpf_attribute9 No varchar2 Descriptive Flexfield
65 -- p_vpf_attribute10 No varchar2 Descriptive Flexfield
66 -- p_vpf_attribute11 No varchar2 Descriptive Flexfield
67 -- p_vpf_attribute12 No varchar2 Descriptive Flexfield
68 -- p_vpf_attribute13 No varchar2 Descriptive Flexfield
69 -- p_vpf_attribute14 No varchar2 Descriptive Flexfield
70 -- p_vpf_attribute15 No varchar2 Descriptive Flexfield
71 -- p_vpf_attribute16 No varchar2 Descriptive Flexfield
72 -- p_vpf_attribute17 No varchar2 Descriptive Flexfield
73 -- p_vpf_attribute18 No varchar2 Descriptive Flexfield
74 -- p_vpf_attribute19 No varchar2 Descriptive Flexfield
75 -- p_vpf_attribute20 No varchar2 Descriptive Flexfield
76 -- p_vpf_attribute21 No varchar2 Descriptive Flexfield
77 -- p_vpf_attribute22 No varchar2 Descriptive Flexfield
78 -- p_vpf_attribute23 No varchar2 Descriptive Flexfield
79 -- p_vpf_attribute24 No varchar2 Descriptive Flexfield
80 -- p_vpf_attribute25 No varchar2 Descriptive Flexfield
81 -- p_vpf_attribute26 No varchar2 Descriptive Flexfield
82 -- p_vpf_attribute27 No varchar2 Descriptive Flexfield
83 -- p_vpf_attribute28 No varchar2 Descriptive Flexfield
84 -- p_vpf_attribute29 No varchar2 Descriptive Flexfield
85 -- p_vpf_attribute30 No varchar2 Descriptive Flexfield
86 -- p_effective_date Yes date Session Date.
87 --
88 -- Post Success:
89 --
90 -- Out Parameters:
91 -- Name Type Description
92 -- p_vrbl_rt_prfl_id Yes number PK of record
93 -- p_effective_start_date Yes date Effective Start Date of Record
94 -- p_effective_end_date Yes date Effective End Date of Record
95 -- p_object_version_number No number OVN of record
96 --
97 -- Post Failure:
98 --
99 -- Access Status:
100 -- Public.
101 --
102 -- {End Of Comments}
103 --
104 procedure create_vrbl_rate_profile
105 ( p_validate in boolean default false
106 ,p_vrbl_rt_prfl_id out nocopy number
107 ,p_effective_start_date out nocopy date
108 ,p_effective_end_date out nocopy date
109 ,p_pl_typ_opt_typ_id in number default null
110 ,p_pl_id in number default null
111 ,p_oipl_id in number default null
112 ,p_comp_lvl_fctr_id in number default null
113 ,p_business_group_id in number default null
114 ,p_acty_typ_cd in varchar2 default null
115 ,p_rt_typ_cd in varchar2 default null
116 ,p_bnft_rt_typ_cd in varchar2 default null
117 ,p_tx_typ_cd in varchar2 default null
118 ,p_vrbl_rt_trtmt_cd in varchar2 default null
119 ,p_acty_ref_perd_cd in varchar2 default null
120 ,p_mlt_cd in varchar2 default null
121 ,p_incrmnt_elcn_val in number default null
122 ,p_dflt_elcn_val in number default null
123 ,p_mx_elcn_val in number default null
124 ,p_mn_elcn_val in number default null
125 ,p_lwr_lmt_val in number default null
126 ,p_lwr_lmt_calc_rl in number default null
127 ,p_upr_lmt_val in number default null
128 ,p_upr_lmt_calc_rl in number default null
129 ,p_ultmt_upr_lmt in number default null
130 ,p_ultmt_lwr_lmt in number default null
131 ,p_ultmt_upr_lmt_calc_rl in number default null
132 ,p_ultmt_lwr_lmt_calc_rl in number default null
133 ,p_ann_mn_elcn_val in number default null
134 ,p_ann_mx_elcn_val in number default null
135 ,p_val in number default null
136 ,p_name in varchar2 default null
137 ,p_no_mn_elcn_val_dfnd_flag in varchar2 default 'N'
138 ,p_no_mx_elcn_val_dfnd_flag in varchar2 default 'N'
139 ,p_alwys_sum_all_cvg_flag in varchar2 default 'N'
140 ,p_alwys_cnt_all_prtts_flag in varchar2 default 'N'
141 ,p_val_calc_rl in number default null
142 ,p_vrbl_rt_prfl_stat_cd in varchar2 default null
143 ,p_vrbl_usg_cd in varchar2 default null
144 ,p_asmt_to_use_cd in varchar2 default null
145 ,p_rndg_cd in varchar2 default null
146 ,p_rndg_rl in number default null
147 ,p_rt_hrly_slrd_flag in varchar2 default 'N'
148 ,p_rt_pstl_cd_flag in varchar2 default 'N'
149 ,p_rt_lbr_mmbr_flag in varchar2 default 'N'
150 ,p_rt_lgl_enty_flag in varchar2 default 'N'
151 ,p_rt_benfts_grp_flag in varchar2 default 'N'
152 ,p_rt_wk_loc_flag in varchar2 default 'N'
153 ,p_rt_brgng_unit_flag in varchar2 default 'N'
154 ,p_rt_age_flag in varchar2 default 'N'
155 ,p_rt_los_flag in varchar2 default 'N'
156 ,p_rt_per_typ_flag in varchar2 default 'N'
157 ,p_rt_fl_tm_pt_tm_flag in varchar2 default 'N'
158 ,p_rt_ee_stat_flag in varchar2 default 'N'
159 ,p_rt_grd_flag in varchar2 default 'N'
160 ,p_rt_pct_fl_tm_flag in varchar2 default 'N'
161 ,p_rt_asnt_set_flag in varchar2 default 'N'
162 ,p_rt_hrs_wkd_flag in varchar2 default 'N'
163 ,p_rt_comp_lvl_flag in varchar2 default 'N'
164 ,p_rt_org_unit_flag in varchar2 default 'N'
165 ,p_rt_loa_rsn_flag in varchar2 default 'N'
166 ,p_rt_pyrl_flag in varchar2 default 'N'
167 ,p_rt_schedd_hrs_flag in varchar2 default 'N'
168 ,p_rt_py_bss_flag in varchar2 default 'N'
169 ,p_rt_prfl_rl_flag in varchar2 default 'N'
170 ,p_rt_cmbn_age_los_flag in varchar2 default 'N'
171 ,p_rt_prtt_pl_flag in varchar2 default 'N'
172 ,p_rt_svc_area_flag in varchar2 default 'N'
173 ,p_rt_ppl_grp_flag in varchar2 default 'N'
174 ,p_rt_dsbld_flag in varchar2 default 'N'
175 ,p_rt_hlth_cvg_flag in varchar2 default 'N'
176 ,p_rt_poe_flag in varchar2 default 'N'
177 ,p_rt_ttl_cvg_vol_flag in varchar2 default 'N'
178 ,p_rt_ttl_prtt_flag in varchar2 default 'N'
179 ,p_rt_gndr_flag in varchar2 default 'N'
180 ,p_rt_tbco_use_flag in varchar2 default 'N'
181 ,p_vpf_attribute_category in varchar2 default null
182 ,p_vpf_attribute1 in varchar2 default null
183 ,p_vpf_attribute2 in varchar2 default null
184 ,p_vpf_attribute3 in varchar2 default null
185 ,p_vpf_attribute4 in varchar2 default null
186 ,p_vpf_attribute5 in varchar2 default null
187 ,p_vpf_attribute6 in varchar2 default null
188 ,p_vpf_attribute7 in varchar2 default null
189 ,p_vpf_attribute8 in varchar2 default null
190 ,p_vpf_attribute9 in varchar2 default null
191 ,p_vpf_attribute10 in varchar2 default null
192 ,p_vpf_attribute11 in varchar2 default null
193 ,p_vpf_attribute12 in varchar2 default null
194 ,p_vpf_attribute13 in varchar2 default null
195 ,p_vpf_attribute14 in varchar2 default null
196 ,p_vpf_attribute15 in varchar2 default null
197 ,p_vpf_attribute16 in varchar2 default null
198 ,p_vpf_attribute17 in varchar2 default null
199 ,p_vpf_attribute18 in varchar2 default null
200 ,p_vpf_attribute19 in varchar2 default null
201 ,p_vpf_attribute20 in varchar2 default null
202 ,p_vpf_attribute21 in varchar2 default null
203 ,p_vpf_attribute22 in varchar2 default null
204 ,p_vpf_attribute23 in varchar2 default null
205 ,p_vpf_attribute24 in varchar2 default null
206 ,p_vpf_attribute25 in varchar2 default null
207 ,p_vpf_attribute26 in varchar2 default null
208 ,p_vpf_attribute27 in varchar2 default null
209 ,p_vpf_attribute28 in varchar2 default null
210 ,p_vpf_attribute29 in varchar2 default null
211 ,p_vpf_attribute30 in varchar2 default null
212 ,p_object_version_number out nocopy number
213 ,p_effective_date in date
214 ,p_rt_cntng_prtn_prfl_flag in varchar2 default null
215 ,p_rt_cbr_quald_bnf_flag in varchar2 default null
216 ,p_rt_optd_mdcr_flag in varchar2 default null
217 ,p_rt_lvg_rsn_flag in varchar2 default null
218 ,p_rt_pstn_flag in varchar2 default null
219 ,p_rt_comptncy_flag in varchar2 default null
220 ,p_rt_job_flag in varchar2 default null
221 ,p_rt_qual_titl_flag in varchar2 default null
222 ,p_rt_dpnt_cvrd_pl_flag in varchar2 default null
223 ,p_rt_dpnt_cvrd_plip_flag in varchar2 default null
224 ,p_rt_dpnt_cvrd_ptip_flag in varchar2 default null
225 ,p_rt_dpnt_cvrd_pgm_flag in varchar2 default null
226 ,p_rt_enrld_oipl_flag in varchar2 default null
227 ,p_rt_enrld_pl_flag in varchar2 default null
228 ,p_rt_enrld_plip_flag in varchar2 default null
229 ,p_rt_enrld_ptip_flag in varchar2 default null
230 ,p_rt_enrld_pgm_flag in varchar2 default null
231 ,p_rt_prtt_anthr_pl_flag in varchar2 default null
232 ,p_rt_othr_ptip_flag in varchar2 default null
233 ,p_rt_no_othr_cvg_flag in varchar2 default null
234 ,p_rt_dpnt_othr_ptip_flag in varchar2 default null
235 ,p_rt_qua_in_gr_flag in varchar2 default null
236 ,p_rt_perf_rtng_flag in varchar2 default null
237 ,p_rt_elig_prfl_flag in varchar2 default null
238 );
239 -- ----------------------------------------------------------------------------
240 -- |------------------------< update_vrbl_rate_profile >----------------------|
241 -- ----------------------------------------------------------------------------
242 -- {Start Of Comments}
243 --
244 -- Description:
245 --
246 -- Prerequisites:
247 --
248 --
249 -- In Parameters:
250 -- Name Reqd Type Description
251 -- p_validate Yes boolean Commit or Rollback.
252 -- p_vrbl_rt_prfl_id Yes number PK of record
253 -- p_pl_typ_opt_typ_id No number
254 -- p_pl_id No number
255 -- p_oipl_id No number
256 -- p_comp_lvl_fctr_id No number
257 -- p_business_group_id Yes number Business Group of Record
258 -- p_acty_typ_cd Yes varchar2
259 -- p_rt_typ_cd No varchar2
260 -- p_bnft_rt_typ_cd No varchar2
261 -- p_tx_typ_cd Yes varchar2
262 -- p_vrbl_rt_trtmt_cd Yes varchar2
263 -- p_acty_ref_perd_cd Yes varchar2
264 -- p_mlt_cd Yes varchar2
265 -- p_incrmnt_elcn_val No number
266 -- p_dflt_elcn_val No number
267 -- p_mx_elcn_val No number
271 -- p_upr_lmt_val No number
268 -- p_mn_elcn_val No number
269 -- p_lwr_lmt_val No number
270 -- p_lwr_lmt_calc_rl No number
272 -- p_upr_lmt_calc_rl No number
273 -- p_ultmt_upr_lmt No number
274 -- p_ultmt_lwr_lmt No number
275 -- p_ultmt_upr_lmt_calc_rl No number
276 -- p_ultmt_lwr_lmt_calc_rl No number
277 -- p_ann_mn_elcn_val No number
278 -- p_ann_mx_elcn_val No number
279 -- p_val No number
280 -- p_name Yes varchar2
281 -- p_no_mn_elcn_val_dfnd_flag Yes varchar2
282 -- p_no_mx_elcn_val_dfnd_flag Yes varchar2
283 -- p_alwys_sum_all_cvg_flag Yes varchar2
284 -- p_alwys_cnt_all_prtts_flag Yes varchar2
285 -- p_val_calc_rl No number
286 -- p_vrbl_rt_prfl_stat_cd No varchar2
287 -- p_vrbl_usg_cd No varchar2
288 -- p_asmt_to_use_cd No varchar2
289 -- p_rndg_cd No varchar2
290 -- p_rndg_rl No number
291 -- p_vpf_attribute_category No varchar2 Descriptive Flexfield
292 -- p_vpf_attribute1 No varchar2 Descriptive Flexfield
293 -- p_vpf_attribute2 No varchar2 Descriptive Flexfield
294 -- p_vpf_attribute3 No varchar2 Descriptive Flexfield
295 -- p_vpf_attribute4 No varchar2 Descriptive Flexfield
296 -- p_vpf_attribute5 No varchar2 Descriptive Flexfield
297 -- p_vpf_attribute6 No varchar2 Descriptive Flexfield
298 -- p_vpf_attribute7 No varchar2 Descriptive Flexfield
299 -- p_vpf_attribute8 No varchar2 Descriptive Flexfield
300 -- p_vpf_attribute9 No varchar2 Descriptive Flexfield
301 -- p_vpf_attribute10 No varchar2 Descriptive Flexfield
302 -- p_vpf_attribute11 No varchar2 Descriptive Flexfield
303 -- p_vpf_attribute12 No varchar2 Descriptive Flexfield
304 -- p_vpf_attribute13 No varchar2 Descriptive Flexfield
305 -- p_vpf_attribute14 No varchar2 Descriptive Flexfield
306 -- p_vpf_attribute15 No varchar2 Descriptive Flexfield
307 -- p_vpf_attribute16 No varchar2 Descriptive Flexfield
308 -- p_vpf_attribute17 No varchar2 Descriptive Flexfield
309 -- p_vpf_attribute18 No varchar2 Descriptive Flexfield
310 -- p_vpf_attribute19 No varchar2 Descriptive Flexfield
311 -- p_vpf_attribute20 No varchar2 Descriptive Flexfield
312 -- p_vpf_attribute21 No varchar2 Descriptive Flexfield
313 -- p_vpf_attribute22 No varchar2 Descriptive Flexfield
314 -- p_vpf_attribute23 No varchar2 Descriptive Flexfield
315 -- p_vpf_attribute24 No varchar2 Descriptive Flexfield
316 -- p_vpf_attribute25 No varchar2 Descriptive Flexfield
317 -- p_vpf_attribute26 No varchar2 Descriptive Flexfield
318 -- p_vpf_attribute27 No varchar2 Descriptive Flexfield
319 -- p_vpf_attribute28 No varchar2 Descriptive Flexfield
320 -- p_vpf_attribute29 No varchar2 Descriptive Flexfield
321 -- p_vpf_attribute30 No varchar2 Descriptive Flexfield
322 -- p_effective_date Yes date Session Date.
323 -- p_datetrack_mode Yes varchar2 Datetrack mode.
324 --
325 -- Post Success:
326 --
327 -- Name Type Description
328 -- p_effective_start_date Yes date Effective Start Date of Record
329 -- p_effective_end_date Yes date Effective End Date of Record
330 -- p_object_version_number No number OVN of record
331 --
332 -- Post Failure:
333 --
334 -- Access Status:
335 -- Public.
336 --
337 -- {End Of Comments}
338 --
339 procedure update_vrbl_rate_profile
340 (p_validate in boolean default false
341 ,p_vrbl_rt_prfl_id in number
342 ,p_effective_start_date out nocopy date
343 ,p_effective_end_date out nocopy date
344 ,p_pl_typ_opt_typ_id in number default hr_api.g_number
345 ,p_pl_id in number default hr_api.g_number
346 ,p_oipl_id in number default hr_api.g_number
347 ,p_comp_lvl_fctr_id in number default hr_api.g_number
348 ,p_business_group_id in number default hr_api.g_number
349 ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
350 ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
351 ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
352 ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
353 ,p_vrbl_rt_trtmt_cd in varchar2 default hr_api.g_varchar2
354 ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
355 ,p_mlt_cd in varchar2 default hr_api.g_varchar2
356 ,p_incrmnt_elcn_val in number default hr_api.g_number
357 ,p_dflt_elcn_val in number default hr_api.g_number
358 ,p_mx_elcn_val in number default hr_api.g_number
359 ,p_mn_elcn_val in number default hr_api.g_number
360 ,p_lwr_lmt_val in number default hr_api.g_number
364 ,p_ultmt_upr_lmt in number default hr_api.g_number
361 ,p_lwr_lmt_calc_rl in number default hr_api.g_number
362 ,p_upr_lmt_val in number default hr_api.g_number
363 ,p_upr_lmt_calc_rl in number default hr_api.g_number
365 ,p_ultmt_lwr_lmt in number default hr_api.g_number
366 ,p_ultmt_upr_lmt_calc_rl in number default hr_api.g_number
367 ,p_ultmt_lwr_lmt_calc_rl in number default hr_api.g_number
368 ,p_ann_mn_elcn_val in number default hr_api.g_number
369 ,p_ann_mx_elcn_val in number default hr_api.g_number
370 ,p_val in number default hr_api.g_number
371 ,p_name in varchar2 default hr_api.g_varchar2
372 ,p_no_mn_elcn_val_dfnd_flag in varchar2 default hr_api.g_varchar2
373 ,p_no_mx_elcn_val_dfnd_flag in varchar2 default hr_api.g_varchar2
374 ,p_alwys_sum_all_cvg_flag in varchar2 default hr_api.g_varchar2
375 ,p_alwys_cnt_all_prtts_flag in varchar2 default hr_api.g_varchar2
376 ,p_val_calc_rl in number default hr_api.g_number
377 ,p_vrbl_rt_prfl_stat_cd in varchar2 default hr_api.g_varchar2
378 ,p_vrbl_usg_cd in varchar2 default hr_api.g_varchar2
379 ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
380 ,p_rndg_cd in varchar2 default hr_api.g_varchar2
381 ,p_rndg_rl in number default hr_api.g_number
382 ,p_rt_hrly_slrd_flag in varchar2 default hr_api.g_varchar2
383 ,p_rt_pstl_cd_flag in varchar2 default hr_api.g_varchar2
384 ,p_rt_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2
385 ,p_rt_lgl_enty_flag in varchar2 default hr_api.g_varchar2
386 ,p_rt_benfts_grp_flag in varchar2 default hr_api.g_varchar2
387 ,p_rt_wk_loc_flag in varchar2 default hr_api.g_varchar2
388 ,p_rt_brgng_unit_flag in varchar2 default hr_api.g_varchar2
389 ,p_rt_age_flag in varchar2 default hr_api.g_varchar2
390 ,p_rt_los_flag in varchar2 default hr_api.g_varchar2
391 ,p_rt_per_typ_flag in varchar2 default hr_api.g_varchar2
392 ,p_rt_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2
393 ,p_rt_ee_stat_flag in varchar2 default hr_api.g_varchar2
394 ,p_rt_grd_flag in varchar2 default hr_api.g_varchar2
395 ,p_rt_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
396 ,p_rt_asnt_set_flag in varchar2 default hr_api.g_varchar2
397 ,p_rt_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
398 ,p_rt_comp_lvl_flag in varchar2 default hr_api.g_varchar2
399 ,p_rt_org_unit_flag in varchar2 default hr_api.g_varchar2
400 ,p_rt_loa_rsn_flag in varchar2 default hr_api.g_varchar2
401 ,p_rt_pyrl_flag in varchar2 default hr_api.g_varchar2
402 ,p_rt_schedd_hrs_flag in varchar2 default hr_api.g_varchar2
403 ,p_rt_py_bss_flag in varchar2 default hr_api.g_varchar2
404 ,p_rt_prfl_rl_flag in varchar2 default hr_api.g_varchar2
405 ,p_rt_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2
406 ,p_rt_prtt_pl_flag in varchar2 default hr_api.g_varchar2
407 ,p_rt_svc_area_flag in varchar2 default hr_api.g_varchar2
408 ,p_rt_ppl_grp_flag in varchar2 default hr_api.g_varchar2
409 ,p_rt_dsbld_flag in varchar2 default hr_api.g_varchar2
410 ,p_rt_hlth_cvg_flag in varchar2 default hr_api.g_varchar2
411 ,p_rt_poe_flag in varchar2 default hr_api.g_varchar2
412 ,p_rt_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2
413 ,p_rt_ttl_prtt_flag in varchar2 default hr_api.g_varchar2
414 ,p_rt_gndr_flag in varchar2 default hr_api.g_varchar2
415 ,p_rt_tbco_use_flag in varchar2 default hr_api.g_varchar2
416 ,p_vpf_attribute_category in varchar2 default hr_api.g_varchar2
417 ,p_vpf_attribute1 in varchar2 default hr_api.g_varchar2
418 ,p_vpf_attribute2 in varchar2 default hr_api.g_varchar2
419 ,p_vpf_attribute3 in varchar2 default hr_api.g_varchar2
420 ,p_vpf_attribute4 in varchar2 default hr_api.g_varchar2
421 ,p_vpf_attribute5 in varchar2 default hr_api.g_varchar2
422 ,p_vpf_attribute6 in varchar2 default hr_api.g_varchar2
423 ,p_vpf_attribute7 in varchar2 default hr_api.g_varchar2
424 ,p_vpf_attribute8 in varchar2 default hr_api.g_varchar2
425 ,p_vpf_attribute9 in varchar2 default hr_api.g_varchar2
426 ,p_vpf_attribute10 in varchar2 default hr_api.g_varchar2
427 ,p_vpf_attribute11 in varchar2 default hr_api.g_varchar2
428 ,p_vpf_attribute12 in varchar2 default hr_api.g_varchar2
429 ,p_vpf_attribute13 in varchar2 default hr_api.g_varchar2
430 ,p_vpf_attribute14 in varchar2 default hr_api.g_varchar2
431 ,p_vpf_attribute15 in varchar2 default hr_api.g_varchar2
432 ,p_vpf_attribute16 in varchar2 default hr_api.g_varchar2
433 ,p_vpf_attribute17 in varchar2 default hr_api.g_varchar2
434 ,p_vpf_attribute18 in varchar2 default hr_api.g_varchar2
435 ,p_vpf_attribute19 in varchar2 default hr_api.g_varchar2
436 ,p_vpf_attribute20 in varchar2 default hr_api.g_varchar2
440 ,p_vpf_attribute24 in varchar2 default hr_api.g_varchar2
437 ,p_vpf_attribute21 in varchar2 default hr_api.g_varchar2
438 ,p_vpf_attribute22 in varchar2 default hr_api.g_varchar2
439 ,p_vpf_attribute23 in varchar2 default hr_api.g_varchar2
441 ,p_vpf_attribute25 in varchar2 default hr_api.g_varchar2
442 ,p_vpf_attribute26 in varchar2 default hr_api.g_varchar2
443 ,p_vpf_attribute27 in varchar2 default hr_api.g_varchar2
444 ,p_vpf_attribute28 in varchar2 default hr_api.g_varchar2
445 ,p_vpf_attribute29 in varchar2 default hr_api.g_varchar2
446 ,p_vpf_attribute30 in varchar2 default hr_api.g_varchar2
447 ,p_object_version_number in out nocopy number
448 ,p_effective_date in date
449 ,p_datetrack_mode in varchar2
450 ,p_rt_cntng_prtn_prfl_flag in varchar2 default hr_api.g_varchar2
451 ,p_rt_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2
452 ,p_rt_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
453 ,p_rt_lvg_rsn_flag in varchar2 default hr_api.g_varchar2
454 ,p_rt_pstn_flag in varchar2 default hr_api.g_varchar2
455 ,p_rt_comptncy_flag in varchar2 default hr_api.g_varchar2
456 ,p_rt_job_flag in varchar2 default hr_api.g_varchar2
457 ,p_rt_qual_titl_flag in varchar2 default hr_api.g_varchar2
458 ,p_rt_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2
459 ,p_rt_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2
460 ,p_rt_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2
461 ,p_rt_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2
462 ,p_rt_enrld_oipl_flag in varchar2 default hr_api.g_varchar2
463 ,p_rt_enrld_pl_flag in varchar2 default hr_api.g_varchar2
464 ,p_rt_enrld_plip_flag in varchar2 default hr_api.g_varchar2
465 ,p_rt_enrld_ptip_flag in varchar2 default hr_api.g_varchar2
466 ,p_rt_enrld_pgm_flag in varchar2 default hr_api.g_varchar2
467 ,p_rt_prtt_anthr_pl_flag in varchar2 default hr_api.g_varchar2
468 ,p_rt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
469 ,p_rt_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2
470 ,p_rt_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
471 ,p_rt_qua_in_gr_flag in varchar2 default hr_api.g_varchar2
472 ,p_rt_perf_rtng_flag in varchar2 default hr_api.g_varchar2
473 ,p_rt_elig_prfl_flag in varchar2 default hr_api.g_varchar2);
474 --
475 -- ----------------------------------------------------------------------------
476 -- |------------------------< delete_vrbl_rate_profile >----------------------|
477 -- ----------------------------------------------------------------------------
478 -- {Start Of Comments}
479 --
480 -- Description:
481 --
482 -- Prerequisites:
483 --
484 --
485 -- In Parameters:
486 -- Name Reqd Type Description
487 -- p_validate Yes boolean Commit or Rollback.
488 -- p_vrbl_rt_prfl_id Yes number PK of record
489 -- p_effective_date Yes date Session Date.
490 -- p_datetrack_mode Yes varchar2 Datetrack mode.
491 --
492 -- Post Success:
493 --
494 -- Name Type Description
495 -- p_effective_start_date Yes date Effective Start Date of Record
496 -- p_effective_end_date Yes date Effective End Date of Record
497 -- p_object_version_number No number OVN of record
498 --
499 -- Post Failure:
500 --
501 -- Access Status:
502 -- Public.
503 --
504 -- {End Of Comments}
505 --
506 procedure delete_vrbl_rate_profile
507 (p_validate in boolean default false
508 ,p_vrbl_rt_prfl_id in number
509 ,p_effective_start_date out nocopy date
510 ,p_effective_end_date out nocopy date
511 ,p_object_version_number in out nocopy number
512 ,p_effective_date in date
513 ,p_datetrack_mode in varchar2);
514 --
515 -- ----------------------------------------------------------------------------
516 -- |----------------------------------< lck >---------------------------------|
517 -- ----------------------------------------------------------------------------
518 -- {Start Of Comments}
519 --
520 -- Description:
521 --
522 -- Prerequisites:
523 --
524 --
525 -- In Parameters:
526 -- Name Reqd Type Description
527 -- p_vrbl_rt_prfl_id Yes number PK of record
528 -- p_object_version_number Yes number OVN of record
529 -- p_effective_date Yes date Session Date.
530 -- p_datetrack_mode Yes varchar2 Datetrack mode.
531 --
532 -- Post Success:
533 --
534 -- Name Type Description
535 -- p_validation_start_date Yes Derived Effective Start Date.
536 -- p_validation_end_date Yes Derived Effective End Date.
537 --
538 -- Post Failure:
539 --
540 -- Access Status:
541 -- Public.
542 --
543 -- {End Of Comments}
544 --
545 procedure lck
546 ( p_vrbl_rt_prfl_id in number
547 ,p_object_version_number in number
548 ,p_effective_date in date
549 ,p_datetrack_mode in varchar2
550 ,p_validation_start_date out nocopy date
551 ,p_validation_end_date out nocopy date);
552 --
553 end ben_vrbl_rate_profile_api;
[Home] [Help]