1 Package ben_Plan_in_Program_api as
2 /* $Header: becppapi.pkh 120.0 2005/05/28 01:16:34 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
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
74 -- p_cpp_attribute20 No varchar2 Descriptive Flexfield
75 -- p_cpp_attribute21 No varchar2 Descriptive Flexfield
76 -- p_cpp_attribute22 No varchar2 Descriptive Flexfield
77 -- p_cpp_attribute23 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
179 ,p_cpp_attribute11 in varchar2 default null
180 ,p_cpp_attribute12 in varchar2 default null
181 ,p_cpp_attribute13 in varchar2 default null
182 ,p_cpp_attribute14 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_effective_date in date
223 );
224 -- ----------------------------------------------------------------------------
225 -- |------------------------< update_Plan_in_Program >------------------------|
226 -- ----------------------------------------------------------------------------
227 -- {Start Of Comments}
228 --
229 -- Description:
230 --
231 -- Prerequisites:
232 --
233 --
234 -- In Parameters:
235 -- Name Reqd Type Description
236 -- p_validate Yes boolean Commit or Rollback.
237 -- p_plip_id Yes number PK of record
238 -- p_dflt_flag Yes varchar2
239 -- p_plip_stat_cd Yes varchar2
240 -- p_dflt_enrt_cd No varchar2
241 -- p_dflt_enrt_det_rl No number
242 -- p_ordr_num No number
243 -- p_ivr_ident No varchar2
244 -- p_enrt_cd No varchar2
245 -- p_enrt_mthd_cd No varchar2
246 -- p_auto_enrt_mthd_rl No number
247 -- p_enrt_rl No number
248 -- p_alws_unrstrctd_enrt_flag Yes varchar2
249 -- p_enrt_cvg_strt_dt_cd No varchar2
250 -- p_enrt_cvg_strt_dt_rl No number
251 -- p_enrt_cvg_end_dt_cd No varchar2
252 -- p_enrt_cvg_end_dt_rl No number
253 -- p_rt_strt_dt_cd No varchar2
254 -- p_rt_strt_dt_rl No number
255 -- p_rt_end_dt_cd No varchar2
256 -- p_rt_end_dt_rl No number
257 -- p_drvbl_fctr_apls_rts_flag Yes varchar2
258 -- p_drvbl_fctr_prtn_elig_flag Yes varchar2
259 -- p_elig_apls_flag Yes varchar2
260 -- p_prtn_elig_ovrid_alwd_flag Yes varchar2
261 -- p_trk_inelig_per_flag Yes varchar2
262 -- p_postelcn_edit_rl No number
263 -- p_pgm_id Yes number
264 -- p_pl_id Yes number
265 -- p_cmbn_plip_id No number
266 -- p_business_group_id Yes number Business Group of Record
267 -- p_per_cvrd_cd No varchar2
268 -- p_short_name No varchar2
269 -- p_short_code No varchar2
270 -- p_legislation_code No varchar2
271 -- p_legislation_subgroup No varchar2
272 -- P_vrfy_fmly_mmbr_rl No number
273 -- P_vrfy_fmly_mmbr_cd No varchar2
274 -- P_use_csd_rsd_prccng_cd No varchar2
275 -- p_cpp_attribute_category No varchar2 Descriptive Flexfield
276 -- p_cpp_attribute1 No varchar2 Descriptive Flexfield
277 -- p_cpp_attribute2 No varchar2 Descriptive Flexfield
278 -- p_cpp_attribute3 No varchar2 Descriptive Flexfield
279 -- p_cpp_attribute4 No varchar2 Descriptive Flexfield
280 -- p_cpp_attribute5 No varchar2 Descriptive Flexfield
281 -- p_cpp_attribute6 No varchar2 Descriptive Flexfield
282 -- p_cpp_attribute7 No varchar2 Descriptive Flexfield
283 -- p_cpp_attribute8 No varchar2 Descriptive Flexfield
284 -- p_cpp_attribute9 No varchar2 Descriptive Flexfield
285 -- p_cpp_attribute10 No varchar2 Descriptive Flexfield
286 -- p_cpp_attribute11 No varchar2 Descriptive Flexfield
287 -- p_cpp_attribute12 No varchar2 Descriptive Flexfield
288 -- p_cpp_attribute13 No varchar2 Descriptive Flexfield
289 -- p_cpp_attribute14 No varchar2 Descriptive Flexfield
290 -- p_cpp_attribute15 No varchar2 Descriptive Flexfield
291 -- p_cpp_attribute16 No varchar2 Descriptive Flexfield
292 -- p_cpp_attribute17 No varchar2 Descriptive Flexfield
293 -- p_cpp_attribute18 No varchar2 Descriptive Flexfield
294 -- p_cpp_attribute19 No varchar2 Descriptive Flexfield
295 -- p_cpp_attribute20 No varchar2 Descriptive Flexfield
299 -- p_cpp_attribute24 No varchar2 Descriptive Flexfield
296 -- p_cpp_attribute21 No varchar2 Descriptive Flexfield
297 -- p_cpp_attribute22 No varchar2 Descriptive Flexfield
298 -- p_cpp_attribute23 No varchar2 Descriptive Flexfield
300 -- p_cpp_attribute25 No varchar2 Descriptive Flexfield
301 -- p_cpp_attribute26 No varchar2 Descriptive Flexfield
302 -- p_cpp_attribute27 No varchar2 Descriptive Flexfield
303 -- p_cpp_attribute28 No varchar2 Descriptive Flexfield
304 -- p_cpp_attribute29 No varchar2 Descriptive Flexfield
305 -- p_cpp_attribute30 No varchar2 Descriptive Flexfield
306 -- p_url_ref_name No varchar2
307 -- p_dflt_to_asn_pndg_ctfn_cd No varchar2
308 -- p_dflt_to_asn_pndg_ctfn_rl No number
309 -- p_mn_cvg_amt No number
310 -- p_mn_cvg_rl No number
311 -- p_mx_cvg_alwd_amt No number
312 -- p_mx_cvg_incr_alwd_amt No number
313 -- p_mx_cvg_incr_wcf_alwd_amt No number
314 -- p_mx_cvg_mlt_incr_num No number
315 -- p_mx_cvg_mlt_incr_wcf_num No number
316 -- p_mx_cvg_rl No number
317 -- p_mx_cvg_wcfn_amt No number
318 -- p_mx_cvg_wcfn_mlt_num No number
319 -- p_no_mn_cvg_amt_apls_flag Yes varchar2
320 -- p_no_mn_cvg_incr_apls_flag Yes varchar2
321 -- p_no_mx_cvg_amt_apls_flag Yes varchar2
322 -- p_no_mx_cvg_incr_apls_flag Yes varchar2
323 -- p_unsspnd_enrt_cd No varchar2
324 -- p_prort_prtl_yr_cvg_rstrn_cd No varchar2
325 -- p_prort_prtl_yr_cvg_rstrn_rl No number
326 -- p_cvg_incr_r_decr_only_cd No varchar2
327 -- p_bnft_or_option_rstrctn_cd No varchar2
328 -- p_effective_date Yes date Session Date.
329 -- p_datetrack_mode Yes varchar2 Datetrack mode.
330 --
331 -- Post Success:
332 --
333 -- Name Type Description
334 -- p_effective_start_date Yes date Effective Start Date of Record
335 -- p_effective_end_date Yes date Effective End Date of Record
336 -- p_object_version_number No number OVN of record
337 --
338 -- Post Failure:
339 --
340 -- Access Status:
341 -- Public.
342 --
343 -- {End Of Comments}
344 --
345 procedure update_Plan_in_Program
346 (
347 p_validate in boolean default false
348 ,p_plip_id in number
349 ,p_effective_start_date out nocopy date
350 ,p_effective_end_date out nocopy date
351 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
352 ,p_plip_stat_cd in varchar2 default hr_api.g_varchar2
353 ,p_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
354 ,p_dflt_enrt_det_rl in number default hr_api.g_number
355 ,p_ordr_num in number default hr_api.g_number
356 ,p_ivr_ident in varchar2 default hr_api.g_varchar2
357 ,p_enrt_cd in varchar2 default hr_api.g_varchar2
358 ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
359 ,p_auto_enrt_mthd_rl in number default hr_api.g_number
360 ,p_enrt_rl in number default hr_api.g_number
361 ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
362 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
363 ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
364 ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
365 ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
366 ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
367 ,p_rt_strt_dt_rl in number default hr_api.g_number
368 ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
369 ,p_rt_end_dt_rl in number default hr_api.g_number
370 ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
371 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
372 ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
373 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
374 ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
375 ,p_postelcn_edit_rl in number default hr_api.g_number
376 ,p_pgm_id in number default hr_api.g_number
377 ,p_pl_id in number default hr_api.g_number
378 ,p_cmbn_plip_id in number default hr_api.g_number
379 ,p_business_group_id in number default hr_api.g_number
380 ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
381 ,p_short_name in varchar2 default hr_api.g_varchar2
382 ,p_short_code in varchar2 default hr_api.g_varchar2
383 ,p_legislation_code in varchar2 default hr_api.g_varchar2
384 ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
385 ,P_vrfy_fmly_mmbr_rl in number default hr_api.g_number
386 ,P_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
387 ,P_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
388 ,p_cpp_attribute_category in varchar2 default hr_api.g_varchar2
392 ,p_cpp_attribute4 in varchar2 default hr_api.g_varchar2
389 ,p_cpp_attribute1 in varchar2 default hr_api.g_varchar2
390 ,p_cpp_attribute2 in varchar2 default hr_api.g_varchar2
391 ,p_cpp_attribute3 in varchar2 default hr_api.g_varchar2
393 ,p_cpp_attribute5 in varchar2 default hr_api.g_varchar2
394 ,p_cpp_attribute6 in varchar2 default hr_api.g_varchar2
395 ,p_cpp_attribute7 in varchar2 default hr_api.g_varchar2
396 ,p_cpp_attribute8 in varchar2 default hr_api.g_varchar2
397 ,p_cpp_attribute9 in varchar2 default hr_api.g_varchar2
398 ,p_cpp_attribute10 in varchar2 default hr_api.g_varchar2
399 ,p_cpp_attribute11 in varchar2 default hr_api.g_varchar2
400 ,p_cpp_attribute12 in varchar2 default hr_api.g_varchar2
401 ,p_cpp_attribute13 in varchar2 default hr_api.g_varchar2
402 ,p_cpp_attribute14 in varchar2 default hr_api.g_varchar2
403 ,p_cpp_attribute15 in varchar2 default hr_api.g_varchar2
404 ,p_cpp_attribute16 in varchar2 default hr_api.g_varchar2
405 ,p_cpp_attribute17 in varchar2 default hr_api.g_varchar2
406 ,p_cpp_attribute18 in varchar2 default hr_api.g_varchar2
407 ,p_cpp_attribute19 in varchar2 default hr_api.g_varchar2
408 ,p_cpp_attribute20 in varchar2 default hr_api.g_varchar2
409 ,p_cpp_attribute21 in varchar2 default hr_api.g_varchar2
410 ,p_cpp_attribute22 in varchar2 default hr_api.g_varchar2
411 ,p_cpp_attribute23 in varchar2 default hr_api.g_varchar2
412 ,p_cpp_attribute24 in varchar2 default hr_api.g_varchar2
413 ,p_cpp_attribute25 in varchar2 default hr_api.g_varchar2
414 ,p_cpp_attribute26 in varchar2 default hr_api.g_varchar2
415 ,p_cpp_attribute27 in varchar2 default hr_api.g_varchar2
416 ,p_cpp_attribute28 in varchar2 default hr_api.g_varchar2
417 ,p_cpp_attribute29 in varchar2 default hr_api.g_varchar2
418 ,p_cpp_attribute30 in varchar2 default hr_api.g_varchar2
419 ,p_object_version_number in out nocopy number
420 ,p_url_ref_name in varchar2 default hr_api.g_varchar2
421 ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
422 ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
423 ,p_mn_cvg_amt in number default hr_api.g_number
424 ,p_mn_cvg_rl in number default hr_api.g_number
425 ,p_mx_cvg_alwd_amt in number default hr_api.g_number
426 ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
427 ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
428 ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
429 ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
430 ,p_mx_cvg_rl in number default hr_api.g_number
431 ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
432 ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
433 ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
434 ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
435 ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
436 ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
437 ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
438 ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default hr_api.g_varchar2
439 ,p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number
440 ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
441 ,p_bnft_or_option_rstrctn_cd in varchar2 default hr_api.g_varchar2
442 ,p_effective_date in date
443 ,p_datetrack_mode in varchar2
444 );
445 --
446 -- ----------------------------------------------------------------------------
447 -- |------------------------< delete_Plan_in_Program >------------------------|
448 -- ----------------------------------------------------------------------------
449 -- {Start Of Comments}
450 --
451 -- Description:
452 --
453 -- Prerequisites:
454 --
455 --
456 -- In Parameters:
457 -- Name Reqd Type Description
458 -- p_validate Yes boolean Commit or Rollback.
459 -- p_plip_id Yes number PK of record
460 -- p_effective_date Yes date Session Date.
461 -- p_datetrack_mode Yes varchar2 Datetrack mode.
462 --
463 -- Post Success:
464 --
465 -- Name Type Description
466 -- p_effective_start_date Yes date Effective Start Date of Record
467 -- p_effective_end_date Yes date Effective End Date of Record
468 -- p_object_version_number No number OVN of record
469 --
470 -- Post Failure:
471 --
472 -- Access Status:
473 -- Public.
474 --
475 -- {End Of Comments}
476 --
477 procedure delete_Plan_in_Program
478 (
479 p_validate in boolean default false
480 ,p_plip_id in number
481 ,p_effective_start_date out nocopy date
482 ,p_effective_end_date out nocopy date
483 ,p_object_version_number in out nocopy number
484 ,p_effective_date in date
485 ,p_datetrack_mode in varchar2
486 );
487 --
488 -- ----------------------------------------------------------------------------
489 -- |----------------------------------< lck >---------------------------------|
490 -- ----------------------------------------------------------------------------
491 -- {Start Of Comments}
492 --
493 -- Description:
494 --
495 -- Prerequisites:
496 --
497 --
498 -- In Parameters:
499 -- Name Reqd Type Description
500 -- p_plip_id Yes number PK of record
501 -- p_object_version_number Yes number OVN of record
502 -- p_effective_date Yes date Session Date.
503 -- p_datetrack_mode Yes varchar2 Datetrack mode.
504 --
505 -- Post Success:
506 --
507 -- Name Type Description
508 -- p_validation_start_date Yes Derived Effective Start Date.
509 -- p_validation_end_date Yes Derived Effective End Date.
510 --
511 -- Post Failure:
512 --
513 -- Access Status:
514 -- Public.
515 --
516 -- {End Of Comments}
517 --
518 procedure lck
519 (
520 p_plip_id in number
521 ,p_object_version_number in number
522 ,p_effective_date in date
523 ,p_datetrack_mode in varchar2
524 ,p_validation_start_date out nocopy date
525 ,p_validation_end_date out nocopy date
526 );
527 --
528 end ben_Plan_in_Program_api;