4 -- ----------------------------------------------------------------------------
1 Package ben_Plan_in_Program_api AUTHID CURRENT_USER as
2 /* $Header: becppapi.pkh 120.0.12020000.2 2012/07/03 12:03:54 amnaraya ship $ */
3 --
5 -- |------------------------< create_Plan_in_Program >------------------------|
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_dflt_flag Yes varchar2
18 -- p_plip_stat_cd Yes varchar2
19 -- p_dflt_enrt_cd No varchar2
20 -- p_dflt_enrt_det_rl No number
21 -- p_ordr_num No number
22 -- p_ivr_ident No varchar2
23 -- p_enrt_cd No varchar2
24 -- p_enrt_mthd_cd No varchar2
25 -- p_auto_enrt_mthd_rl No number
26 -- p_enrt_rl No number
27 -- p_alws_unrstrctd_enrt_flag Yes varchar2
28 -- p_enrt_cvg_strt_dt_cd No varchar2
29 -- p_enrt_cvg_strt_dt_rl No number
30 -- p_enrt_cvg_end_dt_cd No varchar2
31 -- p_enrt_cvg_end_dt_rl No number
32 -- p_rt_strt_dt_cd No varchar2
33 -- p_rt_strt_dt_rl No number
34 -- p_rt_end_dt_cd No varchar2
35 -- p_rt_end_dt_rl No number
36 -- p_drvbl_fctr_apls_rts_flag Yes varchar2
37 -- p_drvbl_fctr_prtn_elig_flag Yes varchar2
38 -- p_elig_apls_flag Yes varchar2
39 -- p_prtn_elig_ovrid_alwd_flag Yes varchar2
40 -- p_trk_inelig_per_flag Yes varchar2
41 -- p_postelcn_edit_rl No number
42 -- p_pgm_id Yes number
43 -- p_pl_id Yes number
44 -- p_cmbn_plip_id No number
45 -- p_business_group_id Yes number Business Group of Record
46 -- p_per_cvrd_cd No varchar2
47 -- p_short_name No varchar2
48 -- p_short_code No varchar2
49 -- p_legislation_code No varchar2
50 -- p_legislation_subgroup No varchar2
51 -- P_vrfy_fmly_mmbr_rl No number
52 -- P_vrfy_fmly_mmbr_cd No varchar2
53 -- P_use_csd_rsd_prccng_cd No varchar2
54 -- p_cpp_attribute_category No varchar2 Descriptive Flexfield
55 -- p_cpp_attribute1 No varchar2 Descriptive Flexfield
56 -- p_cpp_attribute2 No varchar2 Descriptive Flexfield
57 -- p_cpp_attribute3 No varchar2 Descriptive Flexfield
58 -- p_cpp_attribute4 No varchar2 Descriptive Flexfield
59 -- p_cpp_attribute5 No varchar2 Descriptive Flexfield
60 -- p_cpp_attribute6 No varchar2 Descriptive Flexfield
61 -- p_cpp_attribute7 No varchar2 Descriptive Flexfield
62 -- p_cpp_attribute8 No varchar2 Descriptive Flexfield
63 -- p_cpp_attribute9 No varchar2 Descriptive Flexfield
64 -- p_cpp_attribute10 No varchar2 Descriptive Flexfield
65 -- p_cpp_attribute11 No varchar2 Descriptive Flexfield
66 -- p_cpp_attribute12 No varchar2 Descriptive Flexfield
67 -- p_cpp_attribute13 No varchar2 Descriptive Flexfield
68 -- p_cpp_attribute14 No varchar2 Descriptive Flexfield
69 -- p_cpp_attribute15 No varchar2 Descriptive Flexfield
70 -- p_cpp_attribute16 No varchar2 Descriptive Flexfield
71 -- p_cpp_attribute17 No varchar2 Descriptive Flexfield
72 -- p_cpp_attribute18 No varchar2 Descriptive Flexfield
73 -- p_cpp_attribute19 No varchar2 Descriptive Flexfield
77 -- p_cpp_attribute23 No varchar2 Descriptive Flexfield
74 -- p_cpp_attribute20 No varchar2 Descriptive Flexfield
75 -- p_cpp_attribute21 No varchar2 Descriptive Flexfield
76 -- p_cpp_attribute22 No varchar2 Descriptive Flexfield
78 -- p_cpp_attribute24 No varchar2 Descriptive Flexfield
79 -- p_cpp_attribute25 No varchar2 Descriptive Flexfield
80 -- p_cpp_attribute26 No varchar2 Descriptive Flexfield
81 -- p_cpp_attribute27 No varchar2 Descriptive Flexfield
82 -- p_cpp_attribute28 No varchar2 Descriptive Flexfield
83 -- p_cpp_attribute29 No varchar2 Descriptive Flexfield
84 -- p_cpp_attribute30 No varchar2 Descriptive Flexfield
85 -- p_url_ref_name No varchar2
86 -- p_dflt_to_asn_pndg_ctfn_cd No varchar2
87 -- p_dflt_to_asn_pndg_ctfn_rl No number
88 -- p_mn_cvg_amt No number
89 -- p_mn_cvg_rl No number
90 -- p_mx_cvg_alwd_amt No number
91 -- p_mx_cvg_incr_alwd_amt No number
92 -- p_mx_cvg_incr_wcf_alwd_amt No number
93 -- p_mx_cvg_mlt_incr_num No number
94 -- p_mx_cvg_mlt_incr_wcf_num No number
95 -- p_mx_cvg_rl No number
96 -- p_mx_cvg_wcfn_amt No number
97 -- p_mx_cvg_wcfn_mlt_num No number
98 -- p_no_mn_cvg_amt_apls_flag Yes varchar2
99 -- p_no_mn_cvg_incr_apls_flag Yes varchar2
100 -- p_no_mx_cvg_amt_apls_flag Yes varchar2
101 -- p_no_mx_cvg_incr_apls_flag Yes varchar2
102 -- p_unsspnd_enrt_cd No varchar2
103 -- p_prort_prtl_yr_cvg_rstrn_cd No varchar2
104 -- p_prort_prtl_yr_cvg_rstrn_rl No number
105 -- p_cvg_incr_r_decr_only_cd No varchar2
106 -- p_bnft_or_option_rstrctn_cd No varchar2
107 -- p_effective_date Yes date Session Date.
108 --
109 -- Post Success:
110 --
111 -- Out Parameters:
112 -- Name Type Description
113 -- p_plip_id Yes number PK of record
114 -- p_effective_start_date Yes date Effective Start Date of Record
115 -- p_effective_end_date Yes date Effective End Date of Record
116 -- p_object_version_number No number OVN of record
117 --
118 -- Post Failure:
119 --
120 -- Access Status:
121 -- Public.
122 --
123 -- {End Of Comments}
124 --
125 procedure create_Plan_in_Program
126 (
127 p_validate in boolean default false
128 ,p_plip_id out nocopy number
129 ,p_effective_start_date out nocopy date
130 ,p_effective_end_date out nocopy date
131 ,p_dflt_flag in varchar2 default null
132 ,p_plip_stat_cd in varchar2 default null
133 ,p_dflt_enrt_cd in varchar2 default null
134 ,p_dflt_enrt_det_rl in number default null
135 ,p_ordr_num in number default null
136 ,p_ivr_ident in varchar2 default null
137 ,p_enrt_cd in varchar2 default null
138 ,p_enrt_mthd_cd in varchar2 default null
139 ,p_auto_enrt_mthd_rl in number default null
140 ,p_enrt_rl in number default null
141 ,p_alws_unrstrctd_enrt_flag in varchar2 default 'N'
142 ,p_enrt_cvg_strt_dt_cd in varchar2 default null
143 ,p_enrt_cvg_strt_dt_rl in number default null
144 ,p_enrt_cvg_end_dt_cd in varchar2 default null
145 ,p_enrt_cvg_end_dt_rl in number default null
146 ,p_rt_strt_dt_cd in varchar2 default null
147 ,p_rt_strt_dt_rl in number default null
148 ,p_rt_end_dt_cd in varchar2 default null
149 ,p_rt_end_dt_rl in number default null
150 ,p_drvbl_fctr_apls_rts_flag in varchar2 default 'N'
151 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default 'N'
152 ,p_elig_apls_flag in varchar2 default 'N'
153 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default 'N'
154 ,p_trk_inelig_per_flag in varchar2 default 'N'
155 ,p_postelcn_edit_rl in number default null
156 ,p_pgm_id in number default null
157 ,p_pl_id in number default null
158 ,p_cmbn_plip_id in number default null
159 ,p_business_group_id in number default null
160 ,p_per_cvrd_cd in varchar2 default null
161 ,p_short_name in varchar2 default null
162 ,p_short_code in varchar2 default null
163 ,p_legislation_code in varchar2 default null
164 ,p_legislation_subgroup in varchar2 default null
165 ,P_vrfy_fmly_mmbr_rl in number default null
166 ,P_vrfy_fmly_mmbr_cd in varchar2 default null
167 ,P_use_csd_rsd_prccng_cd in varchar2 default null
168 ,p_cpp_attribute_category in varchar2 default null
169 ,p_cpp_attribute1 in varchar2 default null
170 ,p_cpp_attribute2 in varchar2 default null
171 ,p_cpp_attribute3 in varchar2 default null
172 ,p_cpp_attribute4 in varchar2 default null
173 ,p_cpp_attribute5 in varchar2 default null
174 ,p_cpp_attribute6 in varchar2 default null
175 ,p_cpp_attribute7 in varchar2 default null
176 ,p_cpp_attribute8 in varchar2 default null
177 ,p_cpp_attribute9 in varchar2 default null
178 ,p_cpp_attribute10 in varchar2 default null
182 ,p_cpp_attribute14 in varchar2 default null
179 ,p_cpp_attribute11 in varchar2 default null
180 ,p_cpp_attribute12 in varchar2 default null
181 ,p_cpp_attribute13 in varchar2 default null
183 ,p_cpp_attribute15 in varchar2 default null
184 ,p_cpp_attribute16 in varchar2 default null
185 ,p_cpp_attribute17 in varchar2 default null
186 ,p_cpp_attribute18 in varchar2 default null
187 ,p_cpp_attribute19 in varchar2 default null
188 ,p_cpp_attribute20 in varchar2 default null
189 ,p_cpp_attribute21 in varchar2 default null
190 ,p_cpp_attribute22 in varchar2 default null
191 ,p_cpp_attribute23 in varchar2 default null
192 ,p_cpp_attribute24 in varchar2 default null
193 ,p_cpp_attribute25 in varchar2 default null
194 ,p_cpp_attribute26 in varchar2 default null
195 ,p_cpp_attribute27 in varchar2 default null
196 ,p_cpp_attribute28 in varchar2 default null
197 ,p_cpp_attribute29 in varchar2 default null
198 ,p_cpp_attribute30 in varchar2 default null
199 ,p_object_version_number out nocopy number
200 ,p_url_ref_name in varchar2 default null
201 ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default null
202 ,p_dflt_to_asn_pndg_ctfn_rl in number default null
203 ,p_mn_cvg_amt in number default null
204 ,p_mn_cvg_rl in number default null
205 ,p_mx_cvg_alwd_amt in number default null
206 ,p_mx_cvg_incr_alwd_amt in number default null
207 ,p_mx_cvg_incr_wcf_alwd_amt in number default null
208 ,p_mx_cvg_mlt_incr_num in number default null
209 ,p_mx_cvg_mlt_incr_wcf_num in number default null
210 ,p_mx_cvg_rl in number default null
211 ,p_mx_cvg_wcfn_amt in number default null
212 ,p_mx_cvg_wcfn_mlt_num in number default null
213 ,p_no_mn_cvg_amt_apls_flag in varchar2 default 'N'
214 ,p_no_mn_cvg_incr_apls_flag in varchar2 default 'N'
215 ,p_no_mx_cvg_amt_apls_flag in varchar2 default 'N'
216 ,p_no_mx_cvg_incr_apls_flag in varchar2 default 'N'
217 ,p_unsspnd_enrt_cd in varchar2 default null
218 ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default null
219 ,p_prort_prtl_yr_cvg_rstrn_rl in number default null
220 ,p_cvg_incr_r_decr_only_cd in varchar2 default null
221 ,p_bnft_or_option_rstrctn_cd in varchar2 default null
222 ,p_all_inelig in varchar2 default 'N'
223 ,p_effective_date in date
224 );
225 -- ----------------------------------------------------------------------------
226 -- |------------------------< update_Plan_in_Program >------------------------|
227 -- ----------------------------------------------------------------------------
228 -- {Start Of Comments}
229 --
230 -- Description:
231 --
232 -- Prerequisites:
233 --
234 --
235 -- In Parameters:
236 -- Name Reqd Type Description
237 -- p_validate Yes boolean Commit or Rollback.
238 -- p_plip_id Yes number PK of record
239 -- p_dflt_flag Yes varchar2
240 -- p_plip_stat_cd Yes varchar2
241 -- p_dflt_enrt_cd No varchar2
242 -- p_dflt_enrt_det_rl No number
243 -- p_ordr_num No number
244 -- p_ivr_ident No varchar2
245 -- p_enrt_cd No varchar2
246 -- p_enrt_mthd_cd No varchar2
247 -- p_auto_enrt_mthd_rl No number
248 -- p_enrt_rl No number
249 -- p_alws_unrstrctd_enrt_flag Yes varchar2
250 -- p_enrt_cvg_strt_dt_cd No varchar2
251 -- p_enrt_cvg_strt_dt_rl No number
252 -- p_enrt_cvg_end_dt_cd No varchar2
253 -- p_enrt_cvg_end_dt_rl No number
254 -- p_rt_strt_dt_cd No varchar2
255 -- p_rt_strt_dt_rl No number
256 -- p_rt_end_dt_cd No varchar2
257 -- p_rt_end_dt_rl No number
258 -- p_drvbl_fctr_apls_rts_flag Yes varchar2
259 -- p_drvbl_fctr_prtn_elig_flag Yes varchar2
260 -- p_elig_apls_flag Yes varchar2
261 -- p_prtn_elig_ovrid_alwd_flag Yes varchar2
262 -- p_trk_inelig_per_flag Yes varchar2
263 -- p_postelcn_edit_rl No number
264 -- p_pgm_id Yes number
265 -- p_pl_id Yes number
266 -- p_cmbn_plip_id No number
267 -- p_business_group_id Yes number Business Group of Record
268 -- p_per_cvrd_cd No varchar2
269 -- p_short_name No varchar2
270 -- p_short_code No varchar2
271 -- p_legislation_code No varchar2
272 -- p_legislation_subgroup No varchar2
273 -- P_vrfy_fmly_mmbr_rl No number
274 -- P_vrfy_fmly_mmbr_cd No varchar2
275 -- P_use_csd_rsd_prccng_cd No varchar2
276 -- p_cpp_attribute_category No varchar2 Descriptive Flexfield
277 -- p_cpp_attribute1 No varchar2 Descriptive Flexfield
278 -- p_cpp_attribute2 No varchar2 Descriptive Flexfield
279 -- p_cpp_attribute3 No varchar2 Descriptive Flexfield
280 -- p_cpp_attribute4 No varchar2 Descriptive Flexfield
281 -- p_cpp_attribute5 No varchar2 Descriptive Flexfield
282 -- p_cpp_attribute6 No varchar2 Descriptive Flexfield
286 -- p_cpp_attribute10 No varchar2 Descriptive Flexfield
283 -- p_cpp_attribute7 No varchar2 Descriptive Flexfield
284 -- p_cpp_attribute8 No varchar2 Descriptive Flexfield
285 -- p_cpp_attribute9 No varchar2 Descriptive Flexfield
287 -- p_cpp_attribute11 No varchar2 Descriptive Flexfield
288 -- p_cpp_attribute12 No varchar2 Descriptive Flexfield
289 -- p_cpp_attribute13 No varchar2 Descriptive Flexfield
290 -- p_cpp_attribute14 No varchar2 Descriptive Flexfield
291 -- p_cpp_attribute15 No varchar2 Descriptive Flexfield
292 -- p_cpp_attribute16 No varchar2 Descriptive Flexfield
293 -- p_cpp_attribute17 No varchar2 Descriptive Flexfield
294 -- p_cpp_attribute18 No varchar2 Descriptive Flexfield
295 -- p_cpp_attribute19 No varchar2 Descriptive Flexfield
296 -- p_cpp_attribute20 No varchar2 Descriptive Flexfield
297 -- p_cpp_attribute21 No varchar2 Descriptive Flexfield
298 -- p_cpp_attribute22 No varchar2 Descriptive Flexfield
299 -- p_cpp_attribute23 No varchar2 Descriptive Flexfield
300 -- p_cpp_attribute24 No varchar2 Descriptive Flexfield
301 -- p_cpp_attribute25 No varchar2 Descriptive Flexfield
302 -- p_cpp_attribute26 No varchar2 Descriptive Flexfield
303 -- p_cpp_attribute27 No varchar2 Descriptive Flexfield
304 -- p_cpp_attribute28 No varchar2 Descriptive Flexfield
305 -- p_cpp_attribute29 No varchar2 Descriptive Flexfield
306 -- p_cpp_attribute30 No varchar2 Descriptive Flexfield
307 -- p_url_ref_name No varchar2
308 -- p_dflt_to_asn_pndg_ctfn_cd No varchar2
309 -- p_dflt_to_asn_pndg_ctfn_rl No number
310 -- p_mn_cvg_amt No number
311 -- p_mn_cvg_rl No number
312 -- p_mx_cvg_alwd_amt No number
313 -- p_mx_cvg_incr_alwd_amt No number
314 -- p_mx_cvg_incr_wcf_alwd_amt No number
315 -- p_mx_cvg_mlt_incr_num No number
316 -- p_mx_cvg_mlt_incr_wcf_num No number
317 -- p_mx_cvg_rl No number
318 -- p_mx_cvg_wcfn_amt No number
319 -- p_mx_cvg_wcfn_mlt_num No number
320 -- p_no_mn_cvg_amt_apls_flag Yes varchar2
321 -- p_no_mn_cvg_incr_apls_flag Yes varchar2
322 -- p_no_mx_cvg_amt_apls_flag Yes varchar2
323 -- p_no_mx_cvg_incr_apls_flag Yes varchar2
324 -- p_unsspnd_enrt_cd No varchar2
325 -- p_prort_prtl_yr_cvg_rstrn_cd No varchar2
326 -- p_prort_prtl_yr_cvg_rstrn_rl No number
327 -- p_cvg_incr_r_decr_only_cd No varchar2
328 -- p_bnft_or_option_rstrctn_cd No varchar2
329 -- p_effective_date Yes date Session Date.
330 -- p_datetrack_mode Yes varchar2 Datetrack mode.
331 --
332 -- Post Success:
333 --
334 -- Name Type Description
335 -- p_effective_start_date Yes date Effective Start Date of Record
336 -- p_effective_end_date Yes date Effective End Date of Record
337 -- p_object_version_number No number OVN of record
338 --
339 -- Post Failure:
340 --
341 -- Access Status:
342 -- Public.
343 --
344 -- {End Of Comments}
345 --
346 procedure update_Plan_in_Program
347 (
348 p_validate in boolean default false
349 ,p_plip_id in number
350 ,p_effective_start_date out nocopy date
351 ,p_effective_end_date out nocopy date
352 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
353 ,p_plip_stat_cd in varchar2 default hr_api.g_varchar2
354 ,p_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
355 ,p_dflt_enrt_det_rl in number default hr_api.g_number
356 ,p_ordr_num in number default hr_api.g_number
357 ,p_ivr_ident in varchar2 default hr_api.g_varchar2
358 ,p_enrt_cd in varchar2 default hr_api.g_varchar2
359 ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
360 ,p_auto_enrt_mthd_rl in number default hr_api.g_number
361 ,p_enrt_rl in number default hr_api.g_number
362 ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
363 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
364 ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
365 ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
366 ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
367 ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
368 ,p_rt_strt_dt_rl in number default hr_api.g_number
369 ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
370 ,p_rt_end_dt_rl in number default hr_api.g_number
371 ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
372 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
373 ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
374 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
375 ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
376 ,p_postelcn_edit_rl in number default hr_api.g_number
377 ,p_pgm_id in number default hr_api.g_number
378 ,p_pl_id in number default hr_api.g_number
379 ,p_cmbn_plip_id in number default hr_api.g_number
380 ,p_business_group_id in number default hr_api.g_number
384 ,p_legislation_code in varchar2 default hr_api.g_varchar2
381 ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
382 ,p_short_name in varchar2 default hr_api.g_varchar2
383 ,p_short_code in varchar2 default hr_api.g_varchar2
385 ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
386 ,P_vrfy_fmly_mmbr_rl in number default hr_api.g_number
387 ,P_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
388 ,P_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
389 ,p_cpp_attribute_category in varchar2 default hr_api.g_varchar2
390 ,p_cpp_attribute1 in varchar2 default hr_api.g_varchar2
391 ,p_cpp_attribute2 in varchar2 default hr_api.g_varchar2
392 ,p_cpp_attribute3 in varchar2 default hr_api.g_varchar2
393 ,p_cpp_attribute4 in varchar2 default hr_api.g_varchar2
394 ,p_cpp_attribute5 in varchar2 default hr_api.g_varchar2
395 ,p_cpp_attribute6 in varchar2 default hr_api.g_varchar2
396 ,p_cpp_attribute7 in varchar2 default hr_api.g_varchar2
397 ,p_cpp_attribute8 in varchar2 default hr_api.g_varchar2
398 ,p_cpp_attribute9 in varchar2 default hr_api.g_varchar2
399 ,p_cpp_attribute10 in varchar2 default hr_api.g_varchar2
400 ,p_cpp_attribute11 in varchar2 default hr_api.g_varchar2
401 ,p_cpp_attribute12 in varchar2 default hr_api.g_varchar2
402 ,p_cpp_attribute13 in varchar2 default hr_api.g_varchar2
403 ,p_cpp_attribute14 in varchar2 default hr_api.g_varchar2
404 ,p_cpp_attribute15 in varchar2 default hr_api.g_varchar2
405 ,p_cpp_attribute16 in varchar2 default hr_api.g_varchar2
406 ,p_cpp_attribute17 in varchar2 default hr_api.g_varchar2
407 ,p_cpp_attribute18 in varchar2 default hr_api.g_varchar2
408 ,p_cpp_attribute19 in varchar2 default hr_api.g_varchar2
409 ,p_cpp_attribute20 in varchar2 default hr_api.g_varchar2
410 ,p_cpp_attribute21 in varchar2 default hr_api.g_varchar2
411 ,p_cpp_attribute22 in varchar2 default hr_api.g_varchar2
412 ,p_cpp_attribute23 in varchar2 default hr_api.g_varchar2
413 ,p_cpp_attribute24 in varchar2 default hr_api.g_varchar2
414 ,p_cpp_attribute25 in varchar2 default hr_api.g_varchar2
415 ,p_cpp_attribute26 in varchar2 default hr_api.g_varchar2
416 ,p_cpp_attribute27 in varchar2 default hr_api.g_varchar2
417 ,p_cpp_attribute28 in varchar2 default hr_api.g_varchar2
418 ,p_cpp_attribute29 in varchar2 default hr_api.g_varchar2
419 ,p_cpp_attribute30 in varchar2 default hr_api.g_varchar2
420 ,p_object_version_number in out nocopy number
421 ,p_url_ref_name in varchar2 default hr_api.g_varchar2
422 ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
423 ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
424 ,p_mn_cvg_amt in number default hr_api.g_number
425 ,p_mn_cvg_rl in number default hr_api.g_number
426 ,p_mx_cvg_alwd_amt in number default hr_api.g_number
427 ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
428 ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
429 ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
430 ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
431 ,p_mx_cvg_rl in number default hr_api.g_number
432 ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
433 ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
434 ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
435 ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
436 ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
437 ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
438 ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
439 ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default hr_api.g_varchar2
440 ,p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number
441 ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
442 ,p_bnft_or_option_rstrctn_cd in varchar2 default hr_api.g_varchar2
443 ,p_all_inelig in varchar2 default hr_api.g_varchar2
444 ,p_effective_date in date
445 ,p_datetrack_mode in varchar2
446 );
447 --
448 -- ----------------------------------------------------------------------------
449 -- |------------------------< delete_Plan_in_Program >------------------------|
450 -- ----------------------------------------------------------------------------
451 -- {Start Of Comments}
452 --
453 -- Description:
454 --
455 -- Prerequisites:
456 --
457 --
458 -- In Parameters:
459 -- Name Reqd Type Description
460 -- p_validate Yes boolean Commit or Rollback.
461 -- p_plip_id Yes number PK of record
462 -- p_effective_date Yes date Session Date.
463 -- p_datetrack_mode Yes varchar2 Datetrack mode.
464 --
465 -- Post Success:
466 --
467 -- Name Type Description
468 -- p_effective_start_date Yes date Effective Start Date of Record
469 -- p_effective_end_date Yes date Effective End Date of Record
470 -- p_object_version_number No number OVN of record
471 --
472 -- Post Failure:
473 --
474 -- Access Status:
475 -- Public.
476 --
477 -- {End Of Comments}
478 --
479 procedure delete_Plan_in_Program
480 (
481 p_validate in boolean default false
482 ,p_plip_id in number
483 ,p_effective_start_date out nocopy date
484 ,p_effective_end_date out nocopy date
485 ,p_object_version_number in out nocopy number
486 ,p_effective_date in date
487 ,p_datetrack_mode in varchar2
488 );
489 --
490 -- ----------------------------------------------------------------------------
491 -- |----------------------------------< lck >---------------------------------|
492 -- ----------------------------------------------------------------------------
493 -- {Start Of Comments}
494 --
495 -- Description:
496 --
497 -- Prerequisites:
498 --
499 --
500 -- In Parameters:
501 -- Name Reqd Type Description
502 -- p_plip_id Yes number PK of record
503 -- p_object_version_number Yes number OVN of record
504 -- p_effective_date Yes date Session Date.
505 -- p_datetrack_mode Yes varchar2 Datetrack mode.
506 --
507 -- Post Success:
508 --
509 -- Name Type Description
510 -- p_validation_start_date Yes Derived Effective Start Date.
511 -- p_validation_end_date Yes Derived Effective End Date.
512 --
513 -- Post Failure:
514 --
515 -- Access Status:
516 -- Public.
517 --
518 -- {End Of Comments}
519 --
520 procedure lck
521 (
522 p_plip_id in number
523 ,p_object_version_number in number
524 ,p_effective_date in date
525 ,p_datetrack_mode in varchar2
526 ,p_validation_start_date out nocopy date
527 ,p_validation_end_date out nocopy date
528 );
529 --
530 end ben_Plan_in_Program_api;
[Home] [Help]