[Home] [Help]
PACKAGE: APPS.BEN_ELIGY_PROFILE_API
Source
1 Package ben_ELIGY_PROFILE_api AUTHID CURRENT_USER as
2 /* $Header: beelpapi.pkh 120.0 2005/05/28 02:19:53 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_ELIGY_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_name Yes varchar2
18 -- p_description No varchar2
19 -- p_stat_cd Yes varchar2
20 -- p_business_group_id Yes number Business Group of Record
21 -- p_elp_attribute_category No varchar2 Descriptive Flexfield
22 -- p_elp_attribute1 No varchar2 Descriptive Flexfield
23 -- p_elp_attribute2 No varchar2 Descriptive Flexfield
24 -- p_elp_attribute3 No varchar2 Descriptive Flexfield
25 -- p_elp_attribute4 No varchar2 Descriptive Flexfield
26 -- p_elp_attribute5 No varchar2 Descriptive Flexfield
27 -- p_elp_attribute6 No varchar2 Descriptive Flexfield
28 -- p_elp_attribute7 No varchar2 Descriptive Flexfield
29 -- p_elp_attribute8 No varchar2 Descriptive Flexfield
30 -- p_elp_attribute9 No varchar2 Descriptive Flexfield
31 -- p_elp_attribute10 No varchar2 Descriptive Flexfield
32 -- p_elp_attribute11 No varchar2 Descriptive Flexfield
33 -- p_elp_attribute12 No varchar2 Descriptive Flexfield
34 -- p_elp_attribute13 No varchar2 Descriptive Flexfield
35 -- p_elp_attribute14 No varchar2 Descriptive Flexfield
36 -- p_elp_attribute15 No varchar2 Descriptive Flexfield
37 -- p_elp_attribute16 No varchar2 Descriptive Flexfield
38 -- p_elp_attribute17 No varchar2 Descriptive Flexfield
39 -- p_elp_attribute18 No varchar2 Descriptive Flexfield
40 -- p_elp_attribute19 No varchar2 Descriptive Flexfield
41 -- p_elp_attribute20 No varchar2 Descriptive Flexfield
42 -- p_elp_attribute21 No varchar2 Descriptive Flexfield
43 -- p_elp_attribute22 No varchar2 Descriptive Flexfield
44 -- p_elp_attribute23 No varchar2 Descriptive Flexfield
45 -- p_elp_attribute24 No varchar2 Descriptive Flexfield
46 -- p_elp_attribute25 No varchar2 Descriptive Flexfield
47 -- p_elp_attribute26 No varchar2 Descriptive Flexfield
48 -- p_elp_attribute27 No varchar2 Descriptive Flexfield
49 -- p_elp_attribute28 No varchar2 Descriptive Flexfield
50 -- p_elp_attribute29 No varchar2 Descriptive Flexfield
51 -- p_elp_attribute30 No varchar2 Descriptive Flexfield
52 -- p_elig_mrtl_sts_flag yes varchar2
53 -- p_elig_gndr_flag yes varchar2
54 -- p_elig_dsblty_ctg_flag yes varchar2
55 -- p_elig_dsblty_rsn_flag yes varchar2
56 -- p_elig_dsblty_dgr_flag yes varchar2
57 -- p_elig_suppl_role_flag yes varchar2
58 -- p_elig_qual_titl_flag yes varchar2
59 -- p_elig_pstn_flag yes varchar2
60 -- p_elig_prbtn_perd_flag yes varchar2
61 -- p_elig_sp_clng_prg_pt_flag yes varchar2
62 -- p_bnft_cagr_prtn_cd yes varchar2
63 -- p_elig_dsbld_flag yes varchar2
64 -- p_elig_ttl_cvg_vol_flag yes varchar2
65 -- p_elig_ttl_prtt_flag yes varchar2
66 -- p_elig_comptncy_flag yes varchar2
67 -- p_elig_hlth_cvg_flag yes varchar2
68 -- p_elig_anthr_pl_flag yes varchar2
69 -- p_elig_qua_in_gr_flag yes varchar2
70 -- p_elig_perf_rtng_flag yes varchar2
71 -- p_elig_crit_values_flag yes varchar2 /* RBC */
72 -- p_effective_date Yes date Session Date.
73 --
74 -- Post Success:
75 --
76 -- Out Parameters:
77 -- Name Type Description
78 -- p_eligy_prfl_id Yes number PK of record
79 -- p_effective_start_date Yes date Effective Start Date of Record
80 -- p_effective_end_date Yes date Effective End Date of Record
81 -- p_object_version_number No number OVN of record
82 --
83 -- Post Failure:
84 --
85 -- Access Status:
86 -- Public.
87 --
88 -- {End Of Comments}
89 --
90 procedure create_ELIGY_PROFILE
91 (p_validate in boolean default false
92 ,p_eligy_prfl_id out nocopy number
93 ,p_effective_start_date out nocopy date
94 ,p_effective_end_date out nocopy date
95 ,p_name in varchar2 default null
96 ,p_description in varchar2 default null
97 ,p_stat_cd in varchar2 default null
98 ,p_asmt_to_use_cd in varchar2 default null
99 ,p_elig_enrld_plip_flag in varchar2 default 'N'
100 ,p_elig_cbr_quald_bnf_flag in varchar2 default 'N'
101 ,p_elig_enrld_ptip_flag in varchar2 default 'N'
102 ,p_elig_dpnt_cvrd_plip_flag in varchar2 default 'N'
103 ,p_elig_dpnt_cvrd_ptip_flag in varchar2 default 'N'
104 ,p_elig_dpnt_cvrd_pgm_flag in varchar2 default 'N'
105 ,p_elig_job_flag in varchar2 default 'N'
106 ,p_elig_hrly_slrd_flag in varchar2 default 'N'
107 ,p_elig_pstl_cd_flag in varchar2 default 'N'
108 ,p_elig_lbr_mmbr_flag in varchar2 default 'N'
109 ,p_elig_lgl_enty_flag in varchar2 default 'N'
110 ,p_elig_benfts_grp_flag in varchar2 default 'N'
111 ,p_elig_wk_loc_flag in varchar2 default 'N'
112 ,p_elig_brgng_unit_flag in varchar2 default 'N'
113 ,p_elig_age_flag in varchar2 default 'N'
114 ,p_elig_los_flag in varchar2 default 'N'
115 ,p_elig_per_typ_flag in varchar2 default 'N'
116 ,p_elig_fl_tm_pt_tm_flag in varchar2 default 'N'
117 ,p_elig_ee_stat_flag in varchar2 default 'N'
118 ,p_elig_grd_flag in varchar2 default 'N'
119 ,p_elig_pct_fl_tm_flag in varchar2 default 'N'
120 ,p_elig_asnt_set_flag in varchar2 default 'N'
121 ,p_elig_hrs_wkd_flag in varchar2 default 'N'
122 ,p_elig_comp_lvl_flag in varchar2 default 'N'
123 ,p_elig_org_unit_flag in varchar2 default 'N'
124 ,p_elig_loa_rsn_flag in varchar2 default 'N'
125 ,p_elig_pyrl_flag in varchar2 default 'N'
126 ,p_elig_schedd_hrs_flag in varchar2 default 'N'
127 ,p_elig_py_bss_flag in varchar2 default 'N'
128 ,p_eligy_prfl_rl_flag in varchar2 default 'N'
129 ,p_elig_cmbn_age_los_flag in varchar2 default 'N'
130 ,p_cntng_prtn_elig_prfl_flag in varchar2 default 'N'
131 ,p_elig_prtt_pl_flag in varchar2 default 'N'
132 ,p_elig_ppl_grp_flag in varchar2 default 'N'
133 ,p_elig_svc_area_flag in varchar2 default 'N'
134 ,p_elig_ptip_prte_flag in varchar2 default 'N'
135 ,p_elig_no_othr_cvg_flag in varchar2 default 'N'
136 ,p_elig_enrld_pl_flag in varchar2 default 'N'
137 ,p_elig_enrld_oipl_flag in varchar2 default 'N'
138 ,p_elig_enrld_pgm_flag in varchar2 default 'N'
139 ,p_elig_dpnt_cvrd_pl_flag in varchar2 default 'N'
140 ,p_elig_lvg_rsn_flag in varchar2 default 'N'
141 ,p_elig_optd_mdcr_flag in varchar2 default 'N'
142 ,p_elig_tbco_use_flag in varchar2 default 'N'
143 ,p_elig_dpnt_othr_ptip_flag in varchar2 default 'N'
144 ,p_business_group_id in number default null
145 ,p_elp_attribute_category in varchar2 default null
146 ,p_elp_attribute1 in varchar2 default null
147 ,p_elp_attribute2 in varchar2 default null
148 ,p_elp_attribute3 in varchar2 default null
149 ,p_elp_attribute4 in varchar2 default null
150 ,p_elp_attribute5 in varchar2 default null
151 ,p_elp_attribute6 in varchar2 default null
152 ,p_elp_attribute7 in varchar2 default null
153 ,p_elp_attribute8 in varchar2 default null
154 ,p_elp_attribute9 in varchar2 default null
155 ,p_elp_attribute10 in varchar2 default null
156 ,p_elp_attribute11 in varchar2 default null
157 ,p_elp_attribute12 in varchar2 default null
158 ,p_elp_attribute13 in varchar2 default null
159 ,p_elp_attribute14 in varchar2 default null
160 ,p_elp_attribute15 in varchar2 default null
161 ,p_elp_attribute16 in varchar2 default null
162 ,p_elp_attribute17 in varchar2 default null
163 ,p_elp_attribute18 in varchar2 default null
164 ,p_elp_attribute19 in varchar2 default null
165 ,p_elp_attribute20 in varchar2 default null
166 ,p_elp_attribute21 in varchar2 default null
167 ,p_elp_attribute22 in varchar2 default null
168 ,p_elp_attribute23 in varchar2 default null
169 ,p_elp_attribute24 in varchar2 default null
170 ,p_elp_attribute25 in varchar2 default null
171 ,p_elp_attribute26 in varchar2 default null
172 ,p_elp_attribute27 in varchar2 default null
176 ,p_elig_mrtl_sts_flag in varchar2 default 'N'
173 ,p_elp_attribute28 in varchar2 default null
174 ,p_elp_attribute29 in varchar2 default null
175 ,p_elp_attribute30 in varchar2 default null
177 ,p_elig_gndr_flag in varchar2 default 'N'
178 ,p_elig_dsblty_ctg_flag in varchar2 default 'N'
179 ,p_elig_dsblty_rsn_flag in varchar2 default 'N'
180 ,p_elig_dsblty_dgr_flag in varchar2 default 'N'
181 ,p_elig_suppl_role_flag in varchar2 default 'N'
182 ,p_elig_qual_titl_flag in varchar2 default 'N'
183 ,p_elig_pstn_flag in varchar2 default 'N'
184 ,p_elig_prbtn_perd_flag in varchar2 default 'N'
185 ,p_elig_sp_clng_prg_pt_flag in varchar2 default 'N'
186 ,p_bnft_cagr_prtn_cd in varchar2 default null
187 ,p_elig_dsbld_flag in varchar2 default 'N'
188 ,p_elig_ttl_cvg_vol_flag in varchar2 default 'N'
189 ,p_elig_ttl_prtt_flag in varchar2 default 'N'
190 ,p_elig_comptncy_flag in varchar2 default 'N'
191 ,p_elig_hlth_cvg_flag in varchar2 default 'N'
192 ,p_elig_anthr_pl_flag in varchar2 default 'N'
193 ,p_elig_qua_in_gr_flag in varchar2 default 'N'
194 ,p_elig_perf_rtng_flag in varchar2 default 'N'
195 ,p_elig_crit_values_flag in varchar2 default 'N' /* RBC */
196 ,p_object_version_number out nocopy number
197 ,p_effective_date in date);
198 -- ----------------------------------------------------------------------------
199 -- |------------------------< update_ELIGY_PROFILE >--------------------------|
200 -- ----------------------------------------------------------------------------
201 -- {Start Of Comments}
202 --
203 -- Description:
204 --
205 -- Prerequisites:
206 --
207 --
208 -- In Parameters:
209 -- Name Reqd Type Description
210 -- p_validate Yes boolean Commit or Rollback.
211 -- p_eligy_prfl_id Yes number PK of record
212 -- p_name Yes varchar2
213 -- p_description No varchar2
214 -- p_stat_cd Yes varchar2
215 -- p_business_group_id Yes number Business Group of Record
216 -- p_elp_attribute_category No varchar2 Descriptive Flexfield
217 -- p_elp_attribute1 No varchar2 Descriptive Flexfield
218 -- p_elp_attribute2 No varchar2 Descriptive Flexfield
219 -- p_elp_attribute3 No varchar2 Descriptive Flexfield
220 -- p_elp_attribute4 No varchar2 Descriptive Flexfield
221 -- p_elp_attribute5 No varchar2 Descriptive Flexfield
222 -- p_elp_attribute6 No varchar2 Descriptive Flexfield
223 -- p_elp_attribute7 No varchar2 Descriptive Flexfield
224 -- p_elp_attribute8 No varchar2 Descriptive Flexfield
225 -- p_elp_attribute9 No varchar2 Descriptive Flexfield
226 -- p_elp_attribute10 No varchar2 Descriptive Flexfield
227 -- p_elp_attribute11 No varchar2 Descriptive Flexfield
228 -- p_elp_attribute12 No varchar2 Descriptive Flexfield
229 -- p_elp_attribute13 No varchar2 Descriptive Flexfield
230 -- p_elp_attribute14 No varchar2 Descriptive Flexfield
231 -- p_elp_attribute15 No varchar2 Descriptive Flexfield
232 -- p_elp_attribute16 No varchar2 Descriptive Flexfield
233 -- p_elp_attribute17 No varchar2 Descriptive Flexfield
234 -- p_elp_attribute18 No varchar2 Descriptive Flexfield
235 -- p_elp_attribute19 No varchar2 Descriptive Flexfield
236 -- p_elp_attribute20 No varchar2 Descriptive Flexfield
237 -- p_elp_attribute21 No varchar2 Descriptive Flexfield
238 -- p_elp_attribute22 No varchar2 Descriptive Flexfield
239 -- p_elp_attribute23 No varchar2 Descriptive Flexfield
240 -- p_elp_attribute24 No varchar2 Descriptive Flexfield
241 -- p_elp_attribute25 No varchar2 Descriptive Flexfield
242 -- p_elp_attribute26 No varchar2 Descriptive Flexfield
243 -- p_elp_attribute27 No varchar2 Descriptive Flexfield
244 -- p_elp_attribute28 No varchar2 Descriptive Flexfield
245 -- p_elp_attribute29 No varchar2 Descriptive Flexfield
246 -- p_elp_attribute30 No varchar2 Descriptive Flexfield
247 -- p_effective_date Yes date Session Date.
248 -- p_datetrack_mode Yes varchar2 Datetrack mode.
249 -- p_elig_dsbld_flag yes varchar2
250 -- p_elig_ttl_cvg_vol_flag yes varchar2
251 -- p_elig_ttl_prtt_flag yes varchar2
252 -- p_elig_comptncy_flag yes varchar2
253 -- p_elig_hlth_cvg_flag yes varchar2
254 -- p_elig_anthr_pl_flag yes varchar2
255 -- p_elig_qua_in_gr_flag yes varchar2
256 -- p_elig_perf_rtng_flag yes varchar2
257 -- p_elig_crit_values_flag yes varchar2 /* RBC */
258 --
259 -- Post Success:
260 --
261 -- Name Type Description
262 -- p_effective_start_date Yes date Effective Start Date of Record
263 -- p_effective_end_date Yes date Effective End Date of Record
264 -- p_object_version_number No number OVN of record
265 --
266 -- Post Failure:
267 --
268 -- Access Status:
269 -- Public.
270 --
271 -- {End Of Comments}
272 --
273 procedure update_ELIGY_PROFILE
274 (p_validate in boolean default false
275 ,p_eligy_prfl_id in number
276 ,p_effective_start_date out nocopy date
280 ,p_stat_cd in varchar2 default hr_api.g_varchar2
277 ,p_effective_end_date out nocopy date
278 ,p_name in varchar2 default hr_api.g_varchar2
279 ,p_description in varchar2 default hr_api.g_varchar2
281 ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
282 ,p_elig_enrld_plip_flag in varchar2 default hr_api.g_varchar2
283 ,p_elig_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2
284 ,p_elig_enrld_ptip_flag in varchar2 default hr_api.g_varchar2
285 ,p_elig_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2
286 ,p_elig_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2
287 ,p_elig_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2
288 ,p_elig_job_flag in varchar2 default hr_api.g_varchar2
289 ,p_elig_hrly_slrd_flag in varchar2 default hr_api.g_varchar2
290 ,p_elig_pstl_cd_flag in varchar2 default hr_api.g_varchar2
291 ,p_elig_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2
292 ,p_elig_lgl_enty_flag in varchar2 default hr_api.g_varchar2
293 ,p_elig_benfts_grp_flag in varchar2 default hr_api.g_varchar2
294 ,p_elig_wk_loc_flag in varchar2 default hr_api.g_varchar2
295 ,p_elig_brgng_unit_flag in varchar2 default hr_api.g_varchar2
296 ,p_elig_age_flag in varchar2 default hr_api.g_varchar2
297 ,p_elig_los_flag in varchar2 default hr_api.g_varchar2
298 ,p_elig_per_typ_flag in varchar2 default hr_api.g_varchar2
299 ,p_elig_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2
300 ,p_elig_ee_stat_flag in varchar2 default hr_api.g_varchar2
301 ,p_elig_grd_flag in varchar2 default hr_api.g_varchar2
302 ,p_elig_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
303 ,p_elig_asnt_set_flag in varchar2 default hr_api.g_varchar2
304 ,p_elig_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
305 ,p_elig_comp_lvl_flag in varchar2 default hr_api.g_varchar2
306 ,p_elig_org_unit_flag in varchar2 default hr_api.g_varchar2
307 ,p_elig_loa_rsn_flag in varchar2 default hr_api.g_varchar2
308 ,p_elig_pyrl_flag in varchar2 default hr_api.g_varchar2
309 ,p_elig_schedd_hrs_flag in varchar2 default hr_api.g_varchar2
310 ,p_elig_py_bss_flag in varchar2 default hr_api.g_varchar2
311 ,p_eligy_prfl_rl_flag in varchar2 default hr_api.g_varchar2
312 ,p_elig_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2
313 ,p_cntng_prtn_elig_prfl_flag in varchar2 default hr_api.g_varchar2
314 ,p_elig_prtt_pl_flag in varchar2 default hr_api.g_varchar2
315 ,p_elig_ppl_grp_flag in varchar2 default hr_api.g_varchar2
316 ,p_elig_svc_area_flag in varchar2 default hr_api.g_varchar2
317 ,p_elig_ptip_prte_flag in varchar2 default hr_api.g_varchar2
318 ,p_elig_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2
319 ,p_elig_enrld_pl_flag in varchar2 default hr_api.g_varchar2
320 ,p_elig_enrld_oipl_flag in varchar2 default hr_api.g_varchar2
321 ,p_elig_enrld_pgm_flag in varchar2 default hr_api.g_varchar2
322 ,p_elig_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2
323 ,p_elig_lvg_rsn_flag in varchar2 default hr_api.g_varchar2
324 ,p_elig_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
325 ,p_elig_tbco_use_flag in varchar2 default hr_api.g_varchar2
326 ,p_elig_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
327 ,p_business_group_id in number default hr_api.g_number
328 ,p_elp_attribute_category in varchar2 default hr_api.g_varchar2
329 ,p_elp_attribute1 in varchar2 default hr_api.g_varchar2
330 ,p_elp_attribute2 in varchar2 default hr_api.g_varchar2
331 ,p_elp_attribute3 in varchar2 default hr_api.g_varchar2
332 ,p_elp_attribute4 in varchar2 default hr_api.g_varchar2
333 ,p_elp_attribute5 in varchar2 default hr_api.g_varchar2
334 ,p_elp_attribute6 in varchar2 default hr_api.g_varchar2
335 ,p_elp_attribute7 in varchar2 default hr_api.g_varchar2
336 ,p_elp_attribute8 in varchar2 default hr_api.g_varchar2
337 ,p_elp_attribute9 in varchar2 default hr_api.g_varchar2
338 ,p_elp_attribute10 in varchar2 default hr_api.g_varchar2
339 ,p_elp_attribute11 in varchar2 default hr_api.g_varchar2
340 ,p_elp_attribute12 in varchar2 default hr_api.g_varchar2
341 ,p_elp_attribute13 in varchar2 default hr_api.g_varchar2
342 ,p_elp_attribute14 in varchar2 default hr_api.g_varchar2
343 ,p_elp_attribute15 in varchar2 default hr_api.g_varchar2
344 ,p_elp_attribute16 in varchar2 default hr_api.g_varchar2
345 ,p_elp_attribute17 in varchar2 default hr_api.g_varchar2
346 ,p_elp_attribute18 in varchar2 default hr_api.g_varchar2
347 ,p_elp_attribute19 in varchar2 default hr_api.g_varchar2
348 ,p_elp_attribute20 in varchar2 default hr_api.g_varchar2
349 ,p_elp_attribute21 in varchar2 default hr_api.g_varchar2
350 ,p_elp_attribute22 in varchar2 default hr_api.g_varchar2
351 ,p_elp_attribute23 in varchar2 default hr_api.g_varchar2
352 ,p_elp_attribute24 in varchar2 default hr_api.g_varchar2
353 ,p_elp_attribute25 in varchar2 default hr_api.g_varchar2
354 ,p_elp_attribute26 in varchar2 default hr_api.g_varchar2
355 ,p_elp_attribute27 in varchar2 default hr_api.g_varchar2
356 ,p_elp_attribute28 in varchar2 default hr_api.g_varchar2
357 ,p_elp_attribute29 in varchar2 default hr_api.g_varchar2
358 ,p_elp_attribute30 in varchar2 default hr_api.g_varchar2
359 ,p_elig_mrtl_sts_flag in varchar2 default hr_api.g_varchar2
360 ,p_elig_gndr_flag in varchar2 default hr_api.g_varchar2
361 ,p_elig_dsblty_ctg_flag in varchar2 default hr_api.g_varchar2
362 ,p_elig_dsblty_rsn_flag in varchar2 default hr_api.g_varchar2
363 ,p_elig_dsblty_dgr_flag in varchar2 default hr_api.g_varchar2
364 ,p_elig_suppl_role_flag in varchar2 default hr_api.g_varchar2
365 ,p_elig_qual_titl_flag in varchar2 default hr_api.g_varchar2
366 ,p_elig_pstn_flag in varchar2 default hr_api.g_varchar2
367 ,p_elig_prbtn_perd_flag in varchar2 default hr_api.g_varchar2
368 ,p_elig_sp_clng_prg_pt_flag in varchar2 default hr_api.g_varchar2
369 ,p_bnft_cagr_prtn_cd in varchar2 default hr_api.g_varchar2
370 ,p_elig_dsbld_flag in varchar2 default hr_api.g_varchar2
371 ,p_elig_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2
372 ,p_elig_ttl_prtt_flag in varchar2 default hr_api.g_varchar2
373 ,p_elig_comptncy_flag in varchar2 default hr_api.g_varchar2
374 ,p_elig_hlth_cvg_flag in varchar2 default hr_api.g_varchar2
375 ,p_elig_anthr_pl_flag in varchar2 default hr_api.g_varchar2
376 ,p_elig_qua_in_gr_flag in varchar2 default hr_api.g_varchar2
377 ,p_elig_perf_rtng_flag in varchar2 default hr_api.g_varchar2
378 ,p_elig_crit_values_flag in varchar2 default hr_api.g_varchar2 /* RBC */
379 ,p_object_version_number in out nocopy number
380 ,p_effective_date in date
381 ,p_datetrack_mode in varchar2);
382 --
383 -- ----------------------------------------------------------------------------
384 -- |------------------------< delete_ELIGY_PROFILE >--------------------------|
385 -- ----------------------------------------------------------------------------
386 -- {Start Of Comments}
387 --
388 -- Description:
389 --
390 -- Prerequisites:
391 --
392 --
393 -- In Parameters:
394 -- Name Reqd Type Description
395 -- p_validate Yes boolean Commit or Rollback.
396 -- p_eligy_prfl_id Yes number PK of record
397 -- p_effective_date Yes date Session Date.
398 -- p_datetrack_mode Yes varchar2 Datetrack mode.
399 --
400 -- Post Success:
401 --
402 -- Name Type Description
403 -- p_effective_start_date Yes date Effective Start Date of Record
404 -- p_effective_end_date Yes date Effective End Date of Record
405 -- p_object_version_number No number OVN of record
406 --
407 -- Post Failure:
408 --
409 -- Access Status:
410 -- Public.
411 --
412 -- {End Of Comments}
413 --
414 procedure delete_ELIGY_PROFILE
415 (p_validate in boolean default false
416 ,p_eligy_prfl_id in number
417 ,p_effective_start_date out nocopy date
418 ,p_effective_end_date out nocopy date
419 ,p_object_version_number in out nocopy number
420 ,p_effective_date in date
421 ,p_datetrack_mode in varchar2);
422 --
423 -- ----------------------------------------------------------------------------
424 -- |----------------------------------< lck >---------------------------------|
425 -- ----------------------------------------------------------------------------
426 -- {Start Of Comments}
427 --
428 -- Description:
429 --
430 -- Prerequisites:
431 --
432 --
433 -- In Parameters:
434 -- Name Reqd Type Description
435 -- p_eligy_prfl_id Yes number PK of record
436 -- p_object_version_number Yes number OVN of record
437 -- p_effective_date Yes date Session Date.
438 -- p_datetrack_mode Yes varchar2 Datetrack mode.
439 --
440 -- Post Success:
441 --
442 -- Name Type Description
443 -- p_validation_start_date Yes Derived Effective Start Date.
444 -- p_validation_end_date Yes Derived Effective End Date.
445 --
446 -- Post Failure:
447 --
448 -- Access Status:
449 -- Public.
450 --
451 -- {End Of Comments}
452 --
453 procedure lck
454 (p_eligy_prfl_id in number
455 ,p_object_version_number in number
456 ,p_effective_date in date
457 ,p_datetrack_mode in varchar2
458 ,p_validation_start_date out nocopy date
459 ,p_validation_end_date out nocopy date);
460 --
461 end ben_ELIGY_PROFILE_api;