[Home] [Help]
PACKAGE: APPS.BEN_PLAN_TYPE_IN_PROGRAM_API
Source
1 Package ben_Plan_Type_In_Program_api as
2 /* $Header: bectpapi.pkh 120.0 2005/05/28 01:25:54 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_Plan_Type_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_coord_cvg_for_all_pls_flag Yes varchar2
18 -- p_dpnt_dsgn_cd No varchar2
19 -- p_dpnt_cvg_no_ctfn_rqd_flag Yes varchar2
20 -- p_dpnt_cvg_strt_dt_cd No varchar2
21 -- p_rt_end_dt_cd No varchar2
22 -- p_rt_strt_dt_cd No varchar2
23 -- p_enrt_cvg_end_dt_cd No varchar2
24 -- p_enrt_cvg_strt_dt_cd No varchar2
25 -- p_dpnt_cvg_strt_dt_rl No number
26 -- p_dpnt_cvg_end_dt_cd No varchar2
27 -- p_dpnt_cvg_end_dt_rl No number
28 -- p_dpnt_adrs_rqd_flag Yes varchar2
29 -- p_dpnt_legv_id_rqd_flag Yes varchar2
30 -- p_susp_if_dpnt_ssn_nt_prv_cd No varchar2
31 -- p_susp_if_dpnt_dob_nt_prv_cd No varchar2
32 -- p_susp_if_dpnt_adr_nt_prv_cd No varchar2
33 -- p_susp_if_ctfn_not_dpnt_flag No varchar2
34 -- p_dpnt_ctfn_determine_cd No varchar2
35 -- p_postelcn_edit_rl No number
36 -- p_rt_end_dt_rl No number
37 -- p_rt_strt_dt_rl No number
38 -- p_enrt_cvg_end_dt_rl No number
39 -- p_enrt_cvg_strt_dt_rl No number
40 -- p_rqd_perd_enrt_nenrt_rl No number
41 -- p_auto_enrt_mthd_rl No number
42 -- p_enrt_mthd_cd No varchar2
43 -- p_enrt_cd No varchar2
44 -- p_enrt_rl No number
45 -- p_dflt_enrt_cd No varchar2
46 -- p_dflt_enrt_det_rl No number
47 -- p_drvbl_fctr_apls_rts_flag Yes varchar2
48 -- p_drvbl_fctr_prtn_elig_flag Yes varchar2
49 -- p_elig_apls_flag Yes varchar2
50 -- p_prtn_elig_ovrid_alwd_flag Yes varchar2
51 -- p_trk_inelig_per_flag Yes varchar2
52 -- p_dpnt_dob_rqd_flag Yes varchar2
53 -- p_crs_this_pl_typ_only_flag Yes varchar2
54 -- p_ptip_stat_cd Yes varchar2
55 -- p_mx_cvg_alwd_amt No number
56 -- p_mx_enrd_alwd_ovrid_num No number
57 -- p_mn_enrd_rqd_ovrid_num No number
58 -- p_no_mx_pl_typ_ovrid_flag Yes varchar2
59 -- p_ordr_num No number
60 -- p_prvds_cr_flag Yes varchar2
61 -- p_rqd_perd_enrt_nenrt_val No number
62 -- p_rqd_perd_enrt_nenrt_tm_uom No varchar2
63 -- p_wvbl_flag Yes varchar2
64 -- p_drvd_fctr_dpnt_cvg_flag Yes varchar2
65 -- p_no_mn_pl_typ_overid_flag Yes varchar2
66 -- p_sbj_to_sps_lf_ins_mx_flag Yes varchar2
67 -- p_sbj_to_dpnt_lf_ins_mx_flag Yes varchar2
68 -- p_use_to_sum_ee_lf_ins_flag Yes varchar2
69 -- p_per_cvrd_cd No varchar2
70 -- p_short_name No varchar2
71 -- p_short_code No varchar2
72 -- p_legislation_code No varchar2
73 -- p_legislation_subgroup No varchar2
74 -- p_vrfy_fmly_mmbr_cd No varchar2
75 -- p_vrfy_fmly_mmbr_rl No number
76 -- p_ivr_ident No varchar2
77 -- p_url_ref_name No varchar2
78 -- p_rqd_enrt_perd_tco_cd No varchar2
79 -- p_pgm_id Yes number
80 -- p_pl_typ_id Yes number
81 -- p_cmbn_ptip_id No number
82 -- p_cmbn_ptip_opt_id No number
83 -- p_acrs_ptip_cvg_id No number
84 -- p_business_group_id Yes number Business Group of Record
85 -- p_ctp_attribute_category No varchar2 Descriptive Flexfield
86 -- p_ctp_attribute1 No varchar2 Descriptive Flexfield
87 -- p_ctp_attribute2 No varchar2 Descriptive Flexfield
88 -- p_ctp_attribute3 No varchar2 Descriptive Flexfield
89 -- p_ctp_attribute4 No varchar2 Descriptive Flexfield
90 -- p_ctp_attribute5 No varchar2 Descriptive Flexfield
91 -- p_ctp_attribute6 No varchar2 Descriptive Flexfield
92 -- p_ctp_attribute7 No varchar2 Descriptive Flexfield
93 -- p_ctp_attribute8 No varchar2 Descriptive Flexfield
94 -- p_ctp_attribute9 No varchar2 Descriptive Flexfield
95 -- p_ctp_attribute10 No varchar2 Descriptive Flexfield
96 -- p_ctp_attribute11 No varchar2 Descriptive Flexfield
97 -- p_ctp_attribute12 No varchar2 Descriptive Flexfield
98 -- p_ctp_attribute13 No varchar2 Descriptive Flexfield
99 -- p_ctp_attribute14 No varchar2 Descriptive Flexfield
100 -- p_ctp_attribute15 No varchar2 Descriptive Flexfield
101 -- p_ctp_attribute16 No varchar2 Descriptive Flexfield
102 -- p_ctp_attribute17 No varchar2 Descriptive Flexfield
103 -- p_ctp_attribute18 No varchar2 Descriptive Flexfield
104 -- p_ctp_attribute19 No varchar2 Descriptive Flexfield
105 -- p_ctp_attribute20 No varchar2 Descriptive Flexfield
106 -- p_ctp_attribute21 No varchar2 Descriptive Flexfield
107 -- p_ctp_attribute22 No varchar2 Descriptive Flexfield
108 -- p_ctp_attribute23 No varchar2 Descriptive Flexfield
109 -- p_ctp_attribute24 No varchar2 Descriptive Flexfield
110 -- p_ctp_attribute25 No varchar2 Descriptive Flexfield
111 -- p_ctp_attribute26 No varchar2 Descriptive Flexfield
112 -- p_ctp_attribute27 No varchar2 Descriptive Flexfield
113 -- p_ctp_attribute28 No varchar2 Descriptive Flexfield
114 -- p_ctp_attribute29 No varchar2 Descriptive Flexfield
115 -- p_ctp_attribute30 No varchar2 Descriptive Flexfield
116 -- p_effective_date Yes date Session Date.
117 --
118 -- Post Success:
119 --
120 -- Out Parameters:
121 -- Name Type Description
122 -- p_ptip_id Yes number PK of record
123 -- p_effective_start_date Yes date Effective Start Date of Record
124 -- p_effective_end_date Yes date Effective End Date of Record
125 -- p_object_version_number No number OVN of record
126 --
127 -- Post Failure:
128 --
129 -- Access Status:
130 -- Public.
131 --
132 -- {End Of Comments}
133 --
134 procedure create_Plan_Type_In_Program
135 (
136 p_validate in boolean default false
137 ,p_ptip_id out nocopy number
138 ,p_effective_start_date out nocopy date
139 ,p_effective_end_date out nocopy date
140 ,p_coord_cvg_for_all_pls_flag in varchar2 default 'N'
141 ,p_dpnt_dsgn_cd in varchar2 default null
142 ,p_dpnt_cvg_no_ctfn_rqd_flag in varchar2 default 'N'
143 ,p_dpnt_cvg_strt_dt_cd in varchar2 default null
144 ,p_rt_end_dt_cd in varchar2 default null
145 ,p_rt_strt_dt_cd in varchar2 default null
146 ,p_enrt_cvg_end_dt_cd in varchar2 default null
147 ,p_enrt_cvg_strt_dt_cd in varchar2 default null
148 ,p_dpnt_cvg_strt_dt_rl in number default null
149 ,p_dpnt_cvg_end_dt_cd in varchar2 default null
150 ,p_dpnt_cvg_end_dt_rl in number default null
151 ,p_dpnt_adrs_rqd_flag in varchar2 default 'N'
152 ,p_dpnt_legv_id_rqd_flag in varchar2 default 'N'
153 ,p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 default null
154 ,p_susp_if_dpnt_dob_nt_prv_cd in varchar2 default null
155 ,p_susp_if_dpnt_adr_nt_prv_cd in varchar2 default null
156 ,p_susp_if_ctfn_not_dpnt_flag in varchar2 default 'Y'
157 ,p_dpnt_ctfn_determine_cd in varchar2 default null
158 ,p_postelcn_edit_rl in number default null
159 ,p_rt_end_dt_rl in number default null
160 ,p_rt_strt_dt_rl in number default null
161 ,p_enrt_cvg_end_dt_rl in number default null
162 ,p_enrt_cvg_strt_dt_rl in number default null
163 ,p_rqd_perd_enrt_nenrt_rl in number default null
164 ,p_auto_enrt_mthd_rl in number default null
165 ,p_enrt_mthd_cd in varchar2 default null
166 ,p_enrt_cd in varchar2 default null
167 ,p_enrt_rl in number default null
168 ,p_dflt_enrt_cd in varchar2 default null
169 ,p_dflt_enrt_det_rl in number default null
170 ,p_drvbl_fctr_apls_rts_flag in varchar2 default 'N'
171 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default 'N'
172 ,p_elig_apls_flag in varchar2 default 'N'
173 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default 'N'
174 ,p_trk_inelig_per_flag in varchar2 default 'N'
175 ,p_dpnt_dob_rqd_flag in varchar2 default 'N'
176 ,p_crs_this_pl_typ_only_flag in varchar2 default 'N'
177 ,p_ptip_stat_cd in varchar2 default null
178 ,p_mx_cvg_alwd_amt in number default null
179 ,p_mx_enrd_alwd_ovrid_num in number default null
180 ,p_mn_enrd_rqd_ovrid_num in number default null
181 ,p_no_mx_pl_typ_ovrid_flag in varchar2 default 'N'
182 ,p_ordr_num in number default null
183 ,p_prvds_cr_flag in varchar2 default 'N'
184 ,p_rqd_perd_enrt_nenrt_val in number default null
185 ,p_rqd_perd_enrt_nenrt_tm_uom in varchar2 default null
186 ,p_wvbl_flag in varchar2 default 'N'
187 ,p_drvd_fctr_dpnt_cvg_flag in varchar2 default 'N'
188 ,p_no_mn_pl_typ_overid_flag in varchar2 default 'N'
189 ,p_sbj_to_sps_lf_ins_mx_flag in varchar2 default 'N'
190 ,p_sbj_to_dpnt_lf_ins_mx_flag in varchar2 default 'N'
191 ,p_use_to_sum_ee_lf_ins_flag in varchar2 default 'N'
192 ,p_per_cvrd_cd in varchar2 default null
193 ,p_short_name in varchar2 default null
194 ,p_short_code in varchar2 default null
195 ,p_legislation_code in varchar2 default null
196 ,p_legislation_subgroup in varchar2 default null
197 ,p_vrfy_fmly_mmbr_cd in varchar2 default null
198 ,p_vrfy_fmly_mmbr_rl in number default null
199 ,p_ivr_ident in varchar2 default null
200 ,p_url_ref_name in varchar2 default null
201 ,p_rqd_enrt_perd_tco_cd in varchar2 default null
202 ,p_pgm_id in number default null
203 ,p_pl_typ_id in number default null
204 ,p_cmbn_ptip_id in number default null
205 ,p_cmbn_ptip_opt_id in number default null
206 ,p_acrs_ptip_cvg_id in number default null
207 ,p_business_group_id in number default null
208 ,p_ctp_attribute_category in varchar2 default null
209 ,p_ctp_attribute1 in varchar2 default null
210 ,p_ctp_attribute2 in varchar2 default null
211 ,p_ctp_attribute3 in varchar2 default null
212 ,p_ctp_attribute4 in varchar2 default null
213 ,p_ctp_attribute5 in varchar2 default null
214 ,p_ctp_attribute6 in varchar2 default null
215 ,p_ctp_attribute7 in varchar2 default null
216 ,p_ctp_attribute8 in varchar2 default null
217 ,p_ctp_attribute9 in varchar2 default null
218 ,p_ctp_attribute10 in varchar2 default null
219 ,p_ctp_attribute11 in varchar2 default null
220 ,p_ctp_attribute12 in varchar2 default null
221 ,p_ctp_attribute13 in varchar2 default null
222 ,p_ctp_attribute14 in varchar2 default null
223 ,p_ctp_attribute15 in varchar2 default null
224 ,p_ctp_attribute16 in varchar2 default null
225 ,p_ctp_attribute17 in varchar2 default null
226 ,p_ctp_attribute18 in varchar2 default null
227 ,p_ctp_attribute19 in varchar2 default null
228 ,p_ctp_attribute20 in varchar2 default null
229 ,p_ctp_attribute21 in varchar2 default null
230 ,p_ctp_attribute22 in varchar2 default null
231 ,p_ctp_attribute23 in varchar2 default null
232 ,p_ctp_attribute24 in varchar2 default null
233 ,p_ctp_attribute25 in varchar2 default null
234 ,p_ctp_attribute26 in varchar2 default null
235 ,p_ctp_attribute27 in varchar2 default null
236 ,p_ctp_attribute28 in varchar2 default null
237 ,p_ctp_attribute29 in varchar2 default null
238 ,p_ctp_attribute30 in varchar2 default null
239 ,p_object_version_number out nocopy number
240 ,p_effective_date in date
241 );
242 -- ----------------------------------------------------------------------------
243 -- |------------------------< update_Plan_Type_In_Program >------------------------|
244 -- ----------------------------------------------------------------------------
245 -- {Start Of Comments}
246 --
247 -- Description:
248 --
249 -- Prerequisites:
250 --
251 --
252 -- In Parameters:
253 -- Name Reqd Type Description
254 -- p_validate Yes boolean Commit or Rollback.
255 -- p_ptip_id Yes number PK of record
256 -- p_coord_cvg_for_all_pls_flag Yes varchar2
257 -- p_dpnt_dsgn_cd No varchar2
258 -- p_dpnt_cvg_no_ctfn_rqd_flag Yes varchar2
259 -- p_dpnt_cvg_strt_dt_cd No varchar2
260 -- p_rt_end_dt_cd No varchar2
261 -- p_rt_strt_dt_cd No varchar2
262 -- p_enrt_cvg_end_dt_cd No varchar2
263 -- p_enrt_cvg_strt_dt_cd No varchar2
264 -- p_dpnt_cvg_strt_dt_rl No number
265 -- p_dpnt_cvg_end_dt_cd No varchar2
266 -- p_dpnt_cvg_end_dt_rl No number
267 -- p_dpnt_adrs_rqd_flag Yes varchar2
268 -- p_dpnt_legv_id_rqd_flag Yes varchar2
269 -- p_susp_if_dpnt_ssn_nt_prv_cd No varchar2
270 -- p_susp_if_dpnt_dob_nt_prv_cd No varchar2
271 -- p_susp_if_dpnt_adr_nt_prv_cd No varchar2
272 -- p_susp_if_ctfn_not_dpnt_flag No varchar2
273 -- p_dpnt_ctfn_determine_cd No varchar2
274 -- p_postelcn_edit_rl No number
275 -- p_rt_end_dt_rl No number
276 -- p_rt_strt_dt_rl No number
277 -- p_enrt_cvg_end_dt_rl No number
278 -- p_enrt_cvg_strt_dt_rl No number
279 -- p_rqd_perd_enrt_nenrt_rl No number
280 -- p_auto_enrt_mthd_rl No number
281 -- p_enrt_mthd_cd No varchar2
282 -- p_enrt_cd No varchar2
283 -- p_enrt_rl No number
284 -- p_dflt_enrt_cd No varchar2
285 -- p_dflt_enrt_det_rl No number
286 -- p_drvbl_fctr_apls_rts_flag Yes varchar2
287 -- p_drvbl_fctr_prtn_elig_flag Yes varchar2
288 -- p_elig_apls_flag Yes varchar2
289 -- p_prtn_elig_ovrid_alwd_flag Yes varchar2
290 -- p_trk_inelig_per_flag Yes varchar2
291 -- p_dpnt_dob_rqd_flag Yes varchar2
292 -- p_crs_this_pl_typ_only_flag Yes varchar2
293 -- p_ptip_stat_cd Yes varchar2
294 -- p_mx_cvg_alwd_amt No number
295 -- p_mx_enrd_alwd_ovrid_num No number
296 -- p_mn_enrd_rqd_ovrid_num No number
297 -- p_no_mx_pl_typ_ovrid_flag Yes varchar2
298 -- p_ordr_num No number
299 -- p_prvds_cr_flag Yes varchar2
300 -- p_rqd_perd_enrt_nenrt_val No number
301 -- p_rqd_perd_enrt_nenrt_tm_uom No varchar2
302 -- p_wvbl_flag Yes varchar2
306 -- p_sbj_to_dpnt_lf_ins_mx_flag Yes varchar2
303 -- p_drvd_fctr_dpnt_cvg_flag Yes varchar2
304 -- p_no_mn_pl_typ_overid_flag Yes varchar2
305 -- p_sbj_to_sps_lf_ins_mx_flag Yes varchar2
307 -- p_use_to_sum_ee_lf_ins_flag Yes varchar2
308 -- p_per_cvrd_cd No varchar2
309 -- p_short_name No varchar2
310 -- p_short_code No varchar2
311 -- p_legislation_code No varchar2
312 -- p_legislation_subgroup No varchar2
313 -- p_vrfy_fmly_mmbr_cd No varchar2
314 -- p_vrfy_fmly_mmbr_rl No number
315 -- p_ivr_ident No varchar2
316 -- p_url_ref_name No varchar2
317 -- p_rqd_enrt_perd_tco_cd No varchar2
318 -- p_pgm_id Yes number
319 -- p_pl_typ_id Yes number
320 -- p_cmbn_ptip_id No number
321 -- p_cmbn_ptip_opt_id No number
322 -- p_acrs_ptip_cvg_id No number
323 -- p_business_group_id Yes number Business Group of Record
324 -- p_ctp_attribute_category No varchar2 Descriptive Flexfield
325 -- p_ctp_attribute1 No varchar2 Descriptive Flexfield
326 -- p_ctp_attribute2 No varchar2 Descriptive Flexfield
327 -- p_ctp_attribute3 No varchar2 Descriptive Flexfield
328 -- p_ctp_attribute4 No varchar2 Descriptive Flexfield
329 -- p_ctp_attribute5 No varchar2 Descriptive Flexfield
330 -- p_ctp_attribute6 No varchar2 Descriptive Flexfield
331 -- p_ctp_attribute7 No varchar2 Descriptive Flexfield
332 -- p_ctp_attribute8 No varchar2 Descriptive Flexfield
333 -- p_ctp_attribute9 No varchar2 Descriptive Flexfield
334 -- p_ctp_attribute10 No varchar2 Descriptive Flexfield
335 -- p_ctp_attribute11 No varchar2 Descriptive Flexfield
336 -- p_ctp_attribute12 No varchar2 Descriptive Flexfield
337 -- p_ctp_attribute13 No varchar2 Descriptive Flexfield
338 -- p_ctp_attribute14 No varchar2 Descriptive Flexfield
339 -- p_ctp_attribute15 No varchar2 Descriptive Flexfield
340 -- p_ctp_attribute16 No varchar2 Descriptive Flexfield
341 -- p_ctp_attribute17 No varchar2 Descriptive Flexfield
342 -- p_ctp_attribute18 No varchar2 Descriptive Flexfield
343 -- p_ctp_attribute19 No varchar2 Descriptive Flexfield
344 -- p_ctp_attribute20 No varchar2 Descriptive Flexfield
345 -- p_ctp_attribute21 No varchar2 Descriptive Flexfield
346 -- p_ctp_attribute22 No varchar2 Descriptive Flexfield
347 -- p_ctp_attribute23 No varchar2 Descriptive Flexfield
348 -- p_ctp_attribute24 No varchar2 Descriptive Flexfield
349 -- p_ctp_attribute25 No varchar2 Descriptive Flexfield
350 -- p_ctp_attribute26 No varchar2 Descriptive Flexfield
351 -- p_ctp_attribute27 No varchar2 Descriptive Flexfield
352 -- p_ctp_attribute28 No varchar2 Descriptive Flexfield
353 -- p_ctp_attribute29 No varchar2 Descriptive Flexfield
354 -- p_ctp_attribute30 No varchar2 Descriptive Flexfield
355 -- p_effective_date Yes date Session Date.
356 -- p_datetrack_mode Yes varchar2 Datetrack mode.
357 --
358 -- Post Success:
359 --
360 -- Name Type Description
361 -- p_effective_start_date Yes date Effective Start Date of Record
362 -- p_effective_end_date Yes date Effective End Date of Record
363 -- p_object_version_number No number OVN of record
364 --
365 -- Post Failure:
366 --
367 -- Access Status:
368 -- Public.
369 --
370 -- {End Of Comments}
371 --
372 procedure update_Plan_Type_In_Program
373 (
374 p_validate in boolean default false
375 ,p_ptip_id in number
376 ,p_effective_start_date out nocopy date
377 ,p_effective_end_date out nocopy date
378 ,p_coord_cvg_for_all_pls_flag in varchar2 default hr_api.g_varchar2
379 ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
380 ,p_dpnt_cvg_no_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
381 ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
382 ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
383 ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
384 ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
385 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
386 ,p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number
387 ,p_dpnt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
388 ,p_dpnt_cvg_end_dt_rl in number default hr_api.g_number
389 ,p_dpnt_adrs_rqd_flag in varchar2 default hr_api.g_varchar2
390 ,p_dpnt_legv_id_rqd_flag in varchar2 default hr_api.g_varchar2
391 ,p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 default hr_api.g_varchar2
392 ,p_susp_if_dpnt_dob_nt_prv_cd in varchar2 default hr_api.g_varchar2
393 ,p_susp_if_dpnt_adr_nt_prv_cd in varchar2 default hr_api.g_varchar2
394 ,p_susp_if_ctfn_not_dpnt_flag in varchar2 default hr_api.g_varchar2
395 ,p_dpnt_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
399 ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
396 ,p_postelcn_edit_rl in number default hr_api.g_number
397 ,p_rt_end_dt_rl in number default hr_api.g_number
398 ,p_rt_strt_dt_rl in number default hr_api.g_number
400 ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
401 ,p_rqd_perd_enrt_nenrt_rl in number default hr_api.g_number
402 ,p_auto_enrt_mthd_rl in number default hr_api.g_number
403 ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
404 ,p_enrt_cd in varchar2 default hr_api.g_varchar2
405 ,p_enrt_rl in number default hr_api.g_number
406 ,p_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
407 ,p_dflt_enrt_det_rl in number default hr_api.g_number
408 ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
409 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
410 ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
411 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
412 ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
413 ,p_dpnt_dob_rqd_flag in varchar2 default hr_api.g_varchar2
414 ,p_crs_this_pl_typ_only_flag in varchar2 default hr_api.g_varchar2
415 ,p_ptip_stat_cd in varchar2 default hr_api.g_varchar2
416 ,p_mx_cvg_alwd_amt in number default hr_api.g_number
417 ,p_mx_enrd_alwd_ovrid_num in number default hr_api.g_number
418 ,p_mn_enrd_rqd_ovrid_num in number default hr_api.g_number
419 ,p_no_mx_pl_typ_ovrid_flag in varchar2 default hr_api.g_varchar2
420 ,p_ordr_num in number default hr_api.g_number
421 ,p_prvds_cr_flag in varchar2 default hr_api.g_varchar2
422 ,p_rqd_perd_enrt_nenrt_val in number default hr_api.g_number
423 ,p_rqd_perd_enrt_nenrt_tm_uom in varchar2 default hr_api.g_varchar2
424 ,p_wvbl_flag in varchar2 default hr_api.g_varchar2
425 ,p_drvd_fctr_dpnt_cvg_flag in varchar2 default hr_api.g_varchar2
426 ,p_no_mn_pl_typ_overid_flag in varchar2 default hr_api.g_varchar2
427 ,p_sbj_to_sps_lf_ins_mx_flag in varchar2 default hr_api.g_varchar2
428 ,p_sbj_to_dpnt_lf_ins_mx_flag in varchar2 default hr_api.g_varchar2
429 ,p_use_to_sum_ee_lf_ins_flag in varchar2 default hr_api.g_varchar2
430 ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
431 ,p_short_name in varchar2 default hr_api.g_varchar2
432 ,p_short_code in varchar2 default hr_api.g_varchar2
433 ,p_legislation_code in varchar2 default hr_api.g_varchar2
434 ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
435 ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
436 ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
437 ,p_ivr_ident in varchar2 default hr_api.g_varchar2
438 ,p_url_ref_name in varchar2 default hr_api.g_varchar2
439 ,p_rqd_enrt_perd_tco_cd in varchar2 default hr_api.g_varchar2
440 ,p_pgm_id in number default hr_api.g_number
441 ,p_pl_typ_id in number default hr_api.g_number
442 ,p_cmbn_ptip_id in number default hr_api.g_number
443 ,p_cmbn_ptip_opt_id in number default hr_api.g_number
444 ,p_acrs_ptip_cvg_id in number default hr_api.g_number
445 ,p_business_group_id in number default hr_api.g_number
446 ,p_ctp_attribute_category in varchar2 default hr_api.g_varchar2
447 ,p_ctp_attribute1 in varchar2 default hr_api.g_varchar2
448 ,p_ctp_attribute2 in varchar2 default hr_api.g_varchar2
449 ,p_ctp_attribute3 in varchar2 default hr_api.g_varchar2
450 ,p_ctp_attribute4 in varchar2 default hr_api.g_varchar2
451 ,p_ctp_attribute5 in varchar2 default hr_api.g_varchar2
452 ,p_ctp_attribute6 in varchar2 default hr_api.g_varchar2
453 ,p_ctp_attribute7 in varchar2 default hr_api.g_varchar2
454 ,p_ctp_attribute8 in varchar2 default hr_api.g_varchar2
455 ,p_ctp_attribute9 in varchar2 default hr_api.g_varchar2
456 ,p_ctp_attribute10 in varchar2 default hr_api.g_varchar2
457 ,p_ctp_attribute11 in varchar2 default hr_api.g_varchar2
458 ,p_ctp_attribute12 in varchar2 default hr_api.g_varchar2
459 ,p_ctp_attribute13 in varchar2 default hr_api.g_varchar2
460 ,p_ctp_attribute14 in varchar2 default hr_api.g_varchar2
461 ,p_ctp_attribute15 in varchar2 default hr_api.g_varchar2
462 ,p_ctp_attribute16 in varchar2 default hr_api.g_varchar2
463 ,p_ctp_attribute17 in varchar2 default hr_api.g_varchar2
464 ,p_ctp_attribute18 in varchar2 default hr_api.g_varchar2
465 ,p_ctp_attribute19 in varchar2 default hr_api.g_varchar2
466 ,p_ctp_attribute20 in varchar2 default hr_api.g_varchar2
467 ,p_ctp_attribute21 in varchar2 default hr_api.g_varchar2
468 ,p_ctp_attribute22 in varchar2 default hr_api.g_varchar2
469 ,p_ctp_attribute23 in varchar2 default hr_api.g_varchar2
470 ,p_ctp_attribute24 in varchar2 default hr_api.g_varchar2
474 ,p_ctp_attribute28 in varchar2 default hr_api.g_varchar2
471 ,p_ctp_attribute25 in varchar2 default hr_api.g_varchar2
472 ,p_ctp_attribute26 in varchar2 default hr_api.g_varchar2
473 ,p_ctp_attribute27 in varchar2 default hr_api.g_varchar2
475 ,p_ctp_attribute29 in varchar2 default hr_api.g_varchar2
476 ,p_ctp_attribute30 in varchar2 default hr_api.g_varchar2
477 ,p_object_version_number in out nocopy number
478 ,p_effective_date in date
479 ,p_datetrack_mode in varchar2
480 );
481 --
482 -- ----------------------------------------------------------------------------
483 -- |------------------------< delete_Plan_Type_In_Program >------------------------|
484 -- ----------------------------------------------------------------------------
485 -- {Start Of Comments}
486 --
487 -- Description:
488 --
489 -- Prerequisites:
490 --
491 --
492 -- In Parameters:
493 -- Name Reqd Type Description
494 -- p_validate Yes boolean Commit or Rollback.
495 -- p_ptip_id Yes number PK of record
496 -- p_effective_date Yes date Session Date.
497 -- p_datetrack_mode Yes varchar2 Datetrack mode.
498 --
499 -- Post Success:
500 --
501 -- Name Type Description
502 -- p_effective_start_date Yes date Effective Start Date of Record
503 -- p_effective_end_date Yes date Effective End Date of Record
504 -- p_object_version_number No number OVN of record
505 --
506 -- Post Failure:
507 --
508 -- Access Status:
509 -- Public.
510 --
511 -- {End Of Comments}
512 --
513 procedure delete_Plan_Type_In_Program
514 (
515 p_validate in boolean default false
516 ,p_ptip_id in number
517 ,p_effective_start_date out nocopy date
518 ,p_effective_end_date out nocopy date
519 ,p_object_version_number in out nocopy number
520 ,p_effective_date in date
521 ,p_datetrack_mode in varchar2
522 );
523 --
524 -- ----------------------------------------------------------------------------
525 -- |----------------------------------< lck >---------------------------------|
526 -- ----------------------------------------------------------------------------
527 -- {Start Of Comments}
528 --
529 -- Description:
530 --
531 -- Prerequisites:
532 --
533 --
534 -- In Parameters:
535 -- Name Reqd Type Description
536 -- p_ptip_id Yes number PK of record
537 -- p_object_version_number Yes number OVN of record
538 -- p_effective_date Yes date Session Date.
539 -- p_datetrack_mode Yes varchar2 Datetrack mode.
540 --
541 -- Post Success:
542 --
543 -- Name Type Description
544 -- p_validation_start_date Yes Derived Effective Start Date.
545 -- p_validation_end_date Yes Derived Effective End Date.
546 --
547 -- Post Failure:
548 --
549 -- Access Status:
550 -- Public.
551 --
552 -- {End Of Comments}
553 --
554 procedure lck
555 (
556 p_ptip_id in number
557 ,p_object_version_number in number
558 ,p_effective_date in date
559 ,p_datetrack_mode in varchar2
560 ,p_validation_start_date out nocopy date
561 ,p_validation_end_date out nocopy date
562 );
563 --
564 end ben_Plan_Type_In_Program_api;