[Home] [Help]
PACKAGE BODY: APPS.BEN_PLAN_TYPE_IN_PROGRAM_API
Source
1 Package Body ben_Plan_Type_In_Program_api as
2 /* $Header: bectpapi.pkb 120.0 2005/05/28 01:25:46 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_Plan_Type_In_Program_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |---------------------< create_Plan_Type_In_Program >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_Plan_Type_In_Program
13 (p_validate in boolean default false
14 ,p_ptip_id out nocopy number
15 ,p_effective_start_date out nocopy date
16 ,p_effective_end_date out nocopy date
17 ,p_coord_cvg_for_all_pls_flag in varchar2 default 'N'
18 ,p_dpnt_dsgn_cd in varchar2 default null
19 ,p_dpnt_cvg_no_ctfn_rqd_flag in varchar2 default 'N'
20 ,p_dpnt_cvg_strt_dt_cd in varchar2 default null
21 ,p_rt_end_dt_cd in varchar2 default null
22 ,p_rt_strt_dt_cd in varchar2 default null
23 ,p_enrt_cvg_end_dt_cd in varchar2 default null
24 ,p_enrt_cvg_strt_dt_cd in varchar2 default null
25 ,p_dpnt_cvg_strt_dt_rl in number default null
26 ,p_dpnt_cvg_end_dt_cd in varchar2 default null
27 ,p_dpnt_cvg_end_dt_rl in number default null
28 ,p_dpnt_adrs_rqd_flag in varchar2 default 'N'
29 ,p_dpnt_legv_id_rqd_flag in varchar2 default 'N'
30 ,p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 default null
31 ,p_susp_if_dpnt_dob_nt_prv_cd in varchar2 default null
32 ,p_susp_if_dpnt_adr_nt_prv_cd in varchar2 default null
33 ,p_susp_if_ctfn_not_dpnt_flag in varchar2 default 'Y'
34 ,p_dpnt_ctfn_determine_cd in varchar2 default null
35 ,p_postelcn_edit_rl in number default null
36 ,p_rt_end_dt_rl in number default null
37 ,p_rt_strt_dt_rl in number default null
38 ,p_enrt_cvg_end_dt_rl in number default null
39 ,p_enrt_cvg_strt_dt_rl in number default null
40 ,p_rqd_perd_enrt_nenrt_rl in number default null
41 ,p_auto_enrt_mthd_rl in number default null
42 ,p_enrt_mthd_cd in varchar2 default null
43 ,p_enrt_cd in varchar2 default null
44 ,p_enrt_rl in number default null
45 ,p_dflt_enrt_cd in varchar2 default null
46 ,p_dflt_enrt_det_rl in number default null
47 ,p_drvbl_fctr_apls_rts_flag in varchar2 default 'N'
48 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default 'N'
49 ,p_elig_apls_flag in varchar2 default 'N'
50 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default 'N'
51 ,p_trk_inelig_per_flag in varchar2 default 'N'
52 ,p_dpnt_dob_rqd_flag in varchar2 default 'N'
53 ,p_crs_this_pl_typ_only_flag in varchar2 default 'N'
54 ,p_ptip_stat_cd in varchar2 default null
55 ,p_mx_cvg_alwd_amt in number default null
56 ,p_mx_enrd_alwd_ovrid_num in number default null
57 ,p_mn_enrd_rqd_ovrid_num in number default null
58 ,p_no_mx_pl_typ_ovrid_flag in varchar2 default 'N'
59 ,p_ordr_num in number default null
60 ,p_prvds_cr_flag in varchar2 default 'N'
61 ,p_rqd_perd_enrt_nenrt_val in number default null
62 ,p_rqd_perd_enrt_nenrt_tm_uom in varchar2 default null
63 ,p_wvbl_flag in varchar2 default 'N'
64 ,p_drvd_fctr_dpnt_cvg_flag in varchar2 default 'N'
65 ,p_no_mn_pl_typ_overid_flag in varchar2 default 'N'
66 ,p_sbj_to_sps_lf_ins_mx_flag in varchar2 default 'N'
67 ,p_sbj_to_dpnt_lf_ins_mx_flag in varchar2 default 'N'
68 ,p_use_to_sum_ee_lf_ins_flag in varchar2 default 'N'
69 ,p_per_cvrd_cd in varchar2 default null
70 ,p_short_name in varchar2 default null
71 ,p_short_code in varchar2 default null
72 ,p_legislation_code in varchar2 default null
73 ,p_legislation_subgroup in varchar2 default null
74 ,p_vrfy_fmly_mmbr_cd in varchar2 default null
75 ,p_vrfy_fmly_mmbr_rl in number default null
76 ,p_ivr_ident in varchar2 default null
77 ,p_url_ref_name in varchar2 default null
78 ,p_rqd_enrt_perd_tco_cd in varchar2 default null
79 ,p_pgm_id in number default null
80 ,p_pl_typ_id in number default null
81 ,p_cmbn_ptip_id in number default null
82 ,p_cmbn_ptip_opt_id in number default null
83 ,p_acrs_ptip_cvg_id in number default null
84 ,p_business_group_id in number default null
85 ,p_ctp_attribute_category in varchar2 default null
86 ,p_ctp_attribute1 in varchar2 default null
87 ,p_ctp_attribute2 in varchar2 default null
88 ,p_ctp_attribute3 in varchar2 default null
89 ,p_ctp_attribute4 in varchar2 default null
90 ,p_ctp_attribute5 in varchar2 default null
91 ,p_ctp_attribute6 in varchar2 default null
92 ,p_ctp_attribute7 in varchar2 default null
93 ,p_ctp_attribute8 in varchar2 default null
94 ,p_ctp_attribute9 in varchar2 default null
95 ,p_ctp_attribute10 in varchar2 default null
96 ,p_ctp_attribute11 in varchar2 default null
97 ,p_ctp_attribute12 in varchar2 default null
98 ,p_ctp_attribute13 in varchar2 default null
99 ,p_ctp_attribute14 in varchar2 default null
100 ,p_ctp_attribute15 in varchar2 default null
101 ,p_ctp_attribute16 in varchar2 default null
102 ,p_ctp_attribute17 in varchar2 default null
103 ,p_ctp_attribute18 in varchar2 default null
104 ,p_ctp_attribute19 in varchar2 default null
105 ,p_ctp_attribute20 in varchar2 default null
106 ,p_ctp_attribute21 in varchar2 default null
107 ,p_ctp_attribute22 in varchar2 default null
108 ,p_ctp_attribute23 in varchar2 default null
109 ,p_ctp_attribute24 in varchar2 default null
110 ,p_ctp_attribute25 in varchar2 default null
111 ,p_ctp_attribute26 in varchar2 default null
112 ,p_ctp_attribute27 in varchar2 default null
113 ,p_ctp_attribute28 in varchar2 default null
114 ,p_ctp_attribute29 in varchar2 default null
115 ,p_ctp_attribute30 in varchar2 default null
116 ,p_object_version_number out nocopy number
117 ,p_effective_date in date
118 ) is
119 --
120 -- Declare cursors and local variables
121 --
122 cursor c_otp (p_otp_ptip_id number ) is
123 select
124 plip.pgm_id,
125 pl.pl_typ_id,
126 ptip.ptip_id,
127 oipl.opt_id
128 from
129 ben_oipl_f oipl,
130 ben_ptip_f ptip,
131 ben_plip_f plip,
132 ben_pl_f pl
133 where
134 ptip.ptip_id = p_otp_ptip_id
135 and ptip.pgm_id = plip.pgm_id
136 and ptip.pgm_id = p_pgm_id
137 and pl.business_group_id = p_business_group_id
138 and plip.business_group_id = p_business_group_id
139 and oipl.business_group_id = p_business_group_id
140 and ptip.business_group_id = p_business_group_id
141 and plip.pl_id = pl.pl_id
142 and pl.pl_typ_id = ptip.pl_typ_id
143 and pl.pl_id = oipl.pl_id
144 and p_effective_date between plip.effective_start_date and plip.effective_end_date
145 and p_effective_date between pl.effective_start_date and pl.effective_end_date
146 and p_effective_date between ptip.effective_start_date and ptip.effective_end_date
147 and p_effective_date between oipl.effective_start_date and oipl.effective_end_date ;
148
149 l_ptip_id ben_ptip_f.ptip_id%TYPE;
150 l_effective_start_date ben_ptip_f.effective_start_date%TYPE;
151 l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
152 l_proc varchar2(72) := g_package||'create_Plan_Type_In_Program';
153 l_object_version_number ben_ptip_f.object_version_number%TYPE;
154 --
155 -- ben_optip_f
156 l_optip_id ben_optip_f.optip_id%type;
157 l_otp_effective_start_date ben_optip_f.effective_start_date%type;
158 l_otp_effective_end_date ben_optip_f.effective_end_date%type;
159 l_otp_object_version_number ben_optip_f.object_version_number%type;
160
161 begin
162 --
163 hr_utility.set_location('Entering:'|| l_proc, 10);
164 --
165 -- Issue a savepoint if operating in validation only mode
166 --
167 savepoint create_Plan_Type_In_Program;
168 --
169 hr_utility.set_location(l_proc, 20);
170 --
171 -- Process Logic
172 --
173 begin
174 --
175 -- Start of API User Hook for the before hook of create_Plan_Type_In_Program
176 --
177 ben_Plan_Type_In_Program_bk1.create_Plan_Type_In_Program_b
178 (
179 p_coord_cvg_for_all_pls_flag => p_coord_cvg_for_all_pls_flag
180 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
181 ,p_dpnt_cvg_no_ctfn_rqd_flag => p_dpnt_cvg_no_ctfn_rqd_flag
182 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
183 ,p_rt_end_dt_cd => p_rt_end_dt_cd
184 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
185 ,p_enrt_cvg_end_dt_cd => p_enrt_cvg_end_dt_cd
186 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
187 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
188 ,p_dpnt_cvg_end_dt_cd => p_dpnt_cvg_end_dt_cd
189 ,p_dpnt_cvg_end_dt_rl => p_dpnt_cvg_end_dt_rl
190 ,p_dpnt_adrs_rqd_flag => p_dpnt_adrs_rqd_flag
191 ,p_dpnt_legv_id_rqd_flag => p_dpnt_legv_id_rqd_flag
192 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_susp_if_dpnt_ssn_nt_prv_cd
193 ,p_susp_if_dpnt_dob_nt_prv_cd => p_susp_if_dpnt_dob_nt_prv_cd
194 ,p_susp_if_dpnt_adr_nt_prv_cd => p_susp_if_dpnt_adr_nt_prv_cd
195 ,p_susp_if_ctfn_not_dpnt_flag => p_susp_if_ctfn_not_dpnt_flag
196 ,p_dpnt_ctfn_determine_cd => p_dpnt_ctfn_determine_cd
197 ,p_postelcn_edit_rl => p_postelcn_edit_rl
198 ,p_rt_end_dt_rl => p_rt_end_dt_rl
199 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
200 ,p_enrt_cvg_end_dt_rl => p_enrt_cvg_end_dt_rl
201 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
202 ,p_rqd_perd_enrt_nenrt_rl => p_rqd_perd_enrt_nenrt_rl
203 ,p_auto_enrt_mthd_rl => p_auto_enrt_mthd_rl
204 ,p_enrt_mthd_cd => p_enrt_mthd_cd
205 ,p_enrt_cd => p_enrt_cd
206 ,p_enrt_rl => p_enrt_rl
207 ,p_dflt_enrt_cd => p_dflt_enrt_cd
208 ,p_dflt_enrt_det_rl => p_dflt_enrt_det_rl
209 ,p_drvbl_fctr_apls_rts_flag => p_drvbl_fctr_apls_rts_flag
210 ,p_drvbl_fctr_prtn_elig_flag => p_drvbl_fctr_prtn_elig_flag
211 ,p_elig_apls_flag => p_elig_apls_flag
212 ,p_prtn_elig_ovrid_alwd_flag => p_prtn_elig_ovrid_alwd_flag
213 ,p_trk_inelig_per_flag => p_trk_inelig_per_flag
214 ,p_dpnt_dob_rqd_flag => p_dpnt_dob_rqd_flag
215 ,p_crs_this_pl_typ_only_flag => p_crs_this_pl_typ_only_flag
216 ,p_ptip_stat_cd => p_ptip_stat_cd
217 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
218 ,p_mx_enrd_alwd_ovrid_num => p_mx_enrd_alwd_ovrid_num
219 ,p_mn_enrd_rqd_ovrid_num => p_mn_enrd_rqd_ovrid_num
220 ,p_no_mx_pl_typ_ovrid_flag => p_no_mx_pl_typ_ovrid_flag
221 ,p_ordr_num => p_ordr_num
222 ,p_prvds_cr_flag => p_prvds_cr_flag
223 ,p_rqd_perd_enrt_nenrt_val => p_rqd_perd_enrt_nenrt_val
224 ,p_rqd_perd_enrt_nenrt_tm_uom => p_rqd_perd_enrt_nenrt_tm_uom
225 ,p_wvbl_flag => p_wvbl_flag
226 ,p_drvd_fctr_dpnt_cvg_flag => p_drvd_fctr_dpnt_cvg_flag
227 ,p_no_mn_pl_typ_overid_flag => p_no_mn_pl_typ_overid_flag
228 ,p_sbj_to_sps_lf_ins_mx_flag => p_sbj_to_sps_lf_ins_mx_flag
229 ,p_sbj_to_dpnt_lf_ins_mx_flag => p_sbj_to_dpnt_lf_ins_mx_flag
230 ,p_use_to_sum_ee_lf_ins_flag => p_use_to_sum_ee_lf_ins_flag
231 ,p_per_cvrd_cd => p_per_cvrd_cd
232 ,p_short_name => p_short_name
233 ,p_short_code => p_short_code
234 ,p_legislation_code => p_legislation_code
235 ,p_legislation_subgroup => p_legislation_subgroup
236 ,p_vrfy_fmly_mmbr_cd => p_vrfy_fmly_mmbr_cd
237 ,p_vrfy_fmly_mmbr_rl => p_vrfy_fmly_mmbr_rl
238 ,p_ivr_ident => p_ivr_ident
239 ,p_url_ref_name => p_url_ref_name
240 ,p_rqd_enrt_perd_tco_cd => p_rqd_enrt_perd_tco_cd
241 ,p_pgm_id => p_pgm_id
242 ,p_pl_typ_id => p_pl_typ_id
243 ,p_cmbn_ptip_id => p_cmbn_ptip_id
244 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
245 ,p_acrs_ptip_cvg_id => p_acrs_ptip_cvg_id
246 ,p_business_group_id => p_business_group_id
247 ,p_ctp_attribute_category => p_ctp_attribute_category
248 ,p_ctp_attribute1 => p_ctp_attribute1
249 ,p_ctp_attribute2 => p_ctp_attribute2
250 ,p_ctp_attribute3 => p_ctp_attribute3
251 ,p_ctp_attribute4 => p_ctp_attribute4
252 ,p_ctp_attribute5 => p_ctp_attribute5
253 ,p_ctp_attribute6 => p_ctp_attribute6
254 ,p_ctp_attribute7 => p_ctp_attribute7
255 ,p_ctp_attribute8 => p_ctp_attribute8
256 ,p_ctp_attribute9 => p_ctp_attribute9
257 ,p_ctp_attribute10 => p_ctp_attribute10
258 ,p_ctp_attribute11 => p_ctp_attribute11
259 ,p_ctp_attribute12 => p_ctp_attribute12
260 ,p_ctp_attribute13 => p_ctp_attribute13
261 ,p_ctp_attribute14 => p_ctp_attribute14
262 ,p_ctp_attribute15 => p_ctp_attribute15
263 ,p_ctp_attribute16 => p_ctp_attribute16
264 ,p_ctp_attribute17 => p_ctp_attribute17
265 ,p_ctp_attribute18 => p_ctp_attribute18
266 ,p_ctp_attribute19 => p_ctp_attribute19
267 ,p_ctp_attribute20 => p_ctp_attribute20
268 ,p_ctp_attribute21 => p_ctp_attribute21
269 ,p_ctp_attribute22 => p_ctp_attribute22
270 ,p_ctp_attribute23 => p_ctp_attribute23
271 ,p_ctp_attribute24 => p_ctp_attribute24
272 ,p_ctp_attribute25 => p_ctp_attribute25
273 ,p_ctp_attribute26 => p_ctp_attribute26
274 ,p_ctp_attribute27 => p_ctp_attribute27
275 ,p_ctp_attribute28 => p_ctp_attribute28
276 ,p_ctp_attribute29 => p_ctp_attribute29
277 ,p_ctp_attribute30 => p_ctp_attribute30
278 ,p_effective_date => trunc(p_effective_date)
279 );
280 exception
281 when hr_api.cannot_find_prog_unit then
282 hr_api.cannot_find_prog_unit_error
283 (
284 p_module_name => 'CREATE_Plan_Type_In_Program'
285 ,p_hook_type => 'BP'
286 );
287 --
288 -- End of API User Hook for the before hook of create_Plan_Type_In_Program
289 --
290 end;
291 --
292 ben_ctp_ins.ins
293 (
294 p_ptip_id => l_ptip_id
295 ,p_effective_start_date => l_effective_start_date
296 ,p_effective_end_date => l_effective_end_date
297 ,p_coord_cvg_for_all_pls_flag => p_coord_cvg_for_all_pls_flag
298 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
299 ,p_dpnt_cvg_no_ctfn_rqd_flag => p_dpnt_cvg_no_ctfn_rqd_flag
300 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
301 ,p_rt_end_dt_cd => p_rt_end_dt_cd
302 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
303 ,p_enrt_cvg_end_dt_cd => p_enrt_cvg_end_dt_cd
304 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
305 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
306 ,p_dpnt_cvg_end_dt_cd => p_dpnt_cvg_end_dt_cd
307 ,p_dpnt_cvg_end_dt_rl => p_dpnt_cvg_end_dt_rl
308 ,p_dpnt_adrs_rqd_flag => p_dpnt_adrs_rqd_flag
309 ,p_dpnt_legv_id_rqd_flag => p_dpnt_legv_id_rqd_flag
310 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_susp_if_dpnt_ssn_nt_prv_cd
311 ,p_susp_if_dpnt_dob_nt_prv_cd => p_susp_if_dpnt_dob_nt_prv_cd
312 ,p_susp_if_dpnt_adr_nt_prv_cd => p_susp_if_dpnt_adr_nt_prv_cd
313 ,p_susp_if_ctfn_not_dpnt_flag => p_susp_if_ctfn_not_dpnt_flag
314 ,p_dpnt_ctfn_determine_cd => p_dpnt_ctfn_determine_cd
315 ,p_postelcn_edit_rl => p_postelcn_edit_rl
316 ,p_rt_end_dt_rl => p_rt_end_dt_rl
317 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
318 ,p_enrt_cvg_end_dt_rl => p_enrt_cvg_end_dt_rl
319 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
320 ,p_rqd_perd_enrt_nenrt_rl => p_rqd_perd_enrt_nenrt_rl
321 ,p_auto_enrt_mthd_rl => p_auto_enrt_mthd_rl
322 ,p_enrt_mthd_cd => p_enrt_mthd_cd
323 ,p_enrt_cd => p_enrt_cd
324 ,p_enrt_rl => p_enrt_rl
325 ,p_dflt_enrt_cd => p_dflt_enrt_cd
326 ,p_dflt_enrt_det_rl => p_dflt_enrt_det_rl
327 ,p_drvbl_fctr_apls_rts_flag => p_drvbl_fctr_apls_rts_flag
328 ,p_drvbl_fctr_prtn_elig_flag => p_drvbl_fctr_prtn_elig_flag
329 ,p_elig_apls_flag => p_elig_apls_flag
330 ,p_prtn_elig_ovrid_alwd_flag => p_prtn_elig_ovrid_alwd_flag
331 ,p_trk_inelig_per_flag => p_trk_inelig_per_flag
332 ,p_dpnt_dob_rqd_flag => p_dpnt_dob_rqd_flag
333 ,p_crs_this_pl_typ_only_flag => p_crs_this_pl_typ_only_flag
334 ,p_ptip_stat_cd => p_ptip_stat_cd
335 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
336 ,p_mx_enrd_alwd_ovrid_num => p_mx_enrd_alwd_ovrid_num
337 ,p_mn_enrd_rqd_ovrid_num => p_mn_enrd_rqd_ovrid_num
338 ,p_no_mx_pl_typ_ovrid_flag => p_no_mx_pl_typ_ovrid_flag
339 ,p_ordr_num => p_ordr_num
340 ,p_prvds_cr_flag => p_prvds_cr_flag
341 ,p_rqd_perd_enrt_nenrt_val => p_rqd_perd_enrt_nenrt_val
342 ,p_rqd_perd_enrt_nenrt_tm_uom => p_rqd_perd_enrt_nenrt_tm_uom
343 ,p_wvbl_flag => p_wvbl_flag
344 ,p_drvd_fctr_dpnt_cvg_flag => p_drvd_fctr_dpnt_cvg_flag
345 ,p_no_mn_pl_typ_overid_flag => p_no_mn_pl_typ_overid_flag
346 ,p_sbj_to_sps_lf_ins_mx_flag => p_sbj_to_sps_lf_ins_mx_flag
347 ,p_sbj_to_dpnt_lf_ins_mx_flag => p_sbj_to_dpnt_lf_ins_mx_flag
348 ,p_use_to_sum_ee_lf_ins_flag => p_use_to_sum_ee_lf_ins_flag
349 ,p_per_cvrd_cd => p_per_cvrd_cd
350 ,p_short_name => p_short_name
351 ,p_short_code => p_short_code
352 ,p_legislation_code => p_legislation_code
353 ,p_legislation_subgroup => p_legislation_subgroup
354 ,p_vrfy_fmly_mmbr_cd => p_vrfy_fmly_mmbr_cd
355 ,p_vrfy_fmly_mmbr_rl => p_vrfy_fmly_mmbr_rl
356 ,p_ivr_ident => p_ivr_ident
357 ,p_url_ref_name => p_url_ref_name
358 ,p_rqd_enrt_perd_tco_cd => p_rqd_enrt_perd_tco_cd
359 ,p_pgm_id => p_pgm_id
360 ,p_pl_typ_id => p_pl_typ_id
361 ,p_cmbn_ptip_id => p_cmbn_ptip_id
362 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
363 ,p_acrs_ptip_cvg_id => p_acrs_ptip_cvg_id
364 ,p_business_group_id => p_business_group_id
365 ,p_ctp_attribute_category => p_ctp_attribute_category
366 ,p_ctp_attribute1 => p_ctp_attribute1
367 ,p_ctp_attribute2 => p_ctp_attribute2
368 ,p_ctp_attribute3 => p_ctp_attribute3
369 ,p_ctp_attribute4 => p_ctp_attribute4
370 ,p_ctp_attribute5 => p_ctp_attribute5
371 ,p_ctp_attribute6 => p_ctp_attribute6
372 ,p_ctp_attribute7 => p_ctp_attribute7
373 ,p_ctp_attribute8 => p_ctp_attribute8
374 ,p_ctp_attribute9 => p_ctp_attribute9
375 ,p_ctp_attribute10 => p_ctp_attribute10
376 ,p_ctp_attribute11 => p_ctp_attribute11
377 ,p_ctp_attribute12 => p_ctp_attribute12
378 ,p_ctp_attribute13 => p_ctp_attribute13
379 ,p_ctp_attribute14 => p_ctp_attribute14
380 ,p_ctp_attribute15 => p_ctp_attribute15
381 ,p_ctp_attribute16 => p_ctp_attribute16
382 ,p_ctp_attribute17 => p_ctp_attribute17
383 ,p_ctp_attribute18 => p_ctp_attribute18
384 ,p_ctp_attribute19 => p_ctp_attribute19
385 ,p_ctp_attribute20 => p_ctp_attribute20
386 ,p_ctp_attribute21 => p_ctp_attribute21
387 ,p_ctp_attribute22 => p_ctp_attribute22
388 ,p_ctp_attribute23 => p_ctp_attribute23
389 ,p_ctp_attribute24 => p_ctp_attribute24
390 ,p_ctp_attribute25 => p_ctp_attribute25
391 ,p_ctp_attribute26 => p_ctp_attribute26
392 ,p_ctp_attribute27 => p_ctp_attribute27
393 ,p_ctp_attribute28 => p_ctp_attribute28
394 ,p_ctp_attribute29 => p_ctp_attribute29
395 ,p_ctp_attribute30 => p_ctp_attribute30
396 ,p_object_version_number => l_object_version_number
397 ,p_effective_date => trunc(p_effective_date)
398 );
399 --
400 begin
401 --
402 -- Start of API User Hook for the after hook of create_Plan_Type_In_Program
403 --
404 ben_Plan_Type_In_Program_bk1.create_Plan_Type_In_Program_a
405 (
406 p_ptip_id => l_ptip_id
407 ,p_effective_start_date => l_effective_start_date
408 ,p_effective_end_date => l_effective_end_date
409 ,p_coord_cvg_for_all_pls_flag => p_coord_cvg_for_all_pls_flag
410 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
411 ,p_dpnt_cvg_no_ctfn_rqd_flag => p_dpnt_cvg_no_ctfn_rqd_flag
412 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
413 ,p_rt_end_dt_cd => p_rt_end_dt_cd
414 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
415 ,p_enrt_cvg_end_dt_cd => p_enrt_cvg_end_dt_cd
416 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
417 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
418 ,p_dpnt_cvg_end_dt_cd => p_dpnt_cvg_end_dt_cd
419 ,p_dpnt_cvg_end_dt_rl => p_dpnt_cvg_end_dt_rl
420 ,p_dpnt_adrs_rqd_flag => p_dpnt_adrs_rqd_flag
421 ,p_dpnt_legv_id_rqd_flag => p_dpnt_legv_id_rqd_flag
422 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_susp_if_dpnt_ssn_nt_prv_cd
423 ,p_susp_if_dpnt_dob_nt_prv_cd => p_susp_if_dpnt_dob_nt_prv_cd
424 ,p_susp_if_dpnt_adr_nt_prv_cd => p_susp_if_dpnt_adr_nt_prv_cd
425 ,p_susp_if_ctfn_not_dpnt_flag => p_susp_if_ctfn_not_dpnt_flag
426 ,p_dpnt_ctfn_determine_cd => p_dpnt_ctfn_determine_cd
427 ,p_postelcn_edit_rl => p_postelcn_edit_rl
428 ,p_rt_end_dt_rl => p_rt_end_dt_rl
429 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
430 ,p_enrt_cvg_end_dt_rl => p_enrt_cvg_end_dt_rl
431 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
432 ,p_rqd_perd_enrt_nenrt_rl => p_rqd_perd_enrt_nenrt_rl
433 ,p_auto_enrt_mthd_rl => p_auto_enrt_mthd_rl
434 ,p_enrt_mthd_cd => p_enrt_mthd_cd
435 ,p_enrt_cd => p_enrt_cd
436 ,p_enrt_rl => p_enrt_rl
437 ,p_dflt_enrt_cd => p_dflt_enrt_cd
438 ,p_dflt_enrt_det_rl => p_dflt_enrt_det_rl
439 ,p_drvbl_fctr_apls_rts_flag => p_drvbl_fctr_apls_rts_flag
440 ,p_drvbl_fctr_prtn_elig_flag => p_drvbl_fctr_prtn_elig_flag
441 ,p_elig_apls_flag => p_elig_apls_flag
442 ,p_prtn_elig_ovrid_alwd_flag => p_prtn_elig_ovrid_alwd_flag
443 ,p_trk_inelig_per_flag => p_trk_inelig_per_flag
444 ,p_dpnt_dob_rqd_flag => p_dpnt_dob_rqd_flag
445 ,p_crs_this_pl_typ_only_flag => p_crs_this_pl_typ_only_flag
446 ,p_ptip_stat_cd => p_ptip_stat_cd
447 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
448 ,p_mx_enrd_alwd_ovrid_num => p_mx_enrd_alwd_ovrid_num
449 ,p_mn_enrd_rqd_ovrid_num => p_mn_enrd_rqd_ovrid_num
450 ,p_no_mx_pl_typ_ovrid_flag => p_no_mx_pl_typ_ovrid_flag
451 ,p_ordr_num => p_ordr_num
452 ,p_prvds_cr_flag => p_prvds_cr_flag
453 ,p_rqd_perd_enrt_nenrt_val => p_rqd_perd_enrt_nenrt_val
454 ,p_rqd_perd_enrt_nenrt_tm_uom => p_rqd_perd_enrt_nenrt_tm_uom
455 ,p_wvbl_flag => p_wvbl_flag
456 ,p_drvd_fctr_dpnt_cvg_flag => p_drvd_fctr_dpnt_cvg_flag
457 ,p_no_mn_pl_typ_overid_flag => p_no_mn_pl_typ_overid_flag
458 ,p_sbj_to_sps_lf_ins_mx_flag => p_sbj_to_sps_lf_ins_mx_flag
459 ,p_sbj_to_dpnt_lf_ins_mx_flag => p_sbj_to_dpnt_lf_ins_mx_flag
460 ,p_use_to_sum_ee_lf_ins_flag => p_use_to_sum_ee_lf_ins_flag
461 ,p_per_cvrd_cd => p_per_cvrd_cd
462 ,p_short_name => p_short_name
463 ,p_short_code => p_short_code
464 ,p_legislation_code => p_legislation_code
465 ,p_legislation_subgroup => p_legislation_subgroup
466 ,p_vrfy_fmly_mmbr_cd => p_vrfy_fmly_mmbr_cd
467 ,p_vrfy_fmly_mmbr_rl => p_vrfy_fmly_mmbr_rl
468 ,p_ivr_ident => p_ivr_ident
469 ,p_url_ref_name => p_url_ref_name
470 ,p_rqd_enrt_perd_tco_cd => p_rqd_enrt_perd_tco_cd
471 ,p_pgm_id => p_pgm_id
472 ,p_pl_typ_id => p_pl_typ_id
473 ,p_cmbn_ptip_id => p_cmbn_ptip_id
474 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
475 ,p_acrs_ptip_cvg_id => p_acrs_ptip_cvg_id
476 ,p_business_group_id => p_business_group_id
477 ,p_ctp_attribute_category => p_ctp_attribute_category
478 ,p_ctp_attribute1 => p_ctp_attribute1
479 ,p_ctp_attribute2 => p_ctp_attribute2
480 ,p_ctp_attribute3 => p_ctp_attribute3
481 ,p_ctp_attribute4 => p_ctp_attribute4
482 ,p_ctp_attribute5 => p_ctp_attribute5
483 ,p_ctp_attribute6 => p_ctp_attribute6
484 ,p_ctp_attribute7 => p_ctp_attribute7
485 ,p_ctp_attribute8 => p_ctp_attribute8
486 ,p_ctp_attribute9 => p_ctp_attribute9
487 ,p_ctp_attribute10 => p_ctp_attribute10
488 ,p_ctp_attribute11 => p_ctp_attribute11
489 ,p_ctp_attribute12 => p_ctp_attribute12
490 ,p_ctp_attribute13 => p_ctp_attribute13
491 ,p_ctp_attribute14 => p_ctp_attribute14
492 ,p_ctp_attribute15 => p_ctp_attribute15
493 ,p_ctp_attribute16 => p_ctp_attribute16
494 ,p_ctp_attribute17 => p_ctp_attribute17
495 ,p_ctp_attribute18 => p_ctp_attribute18
496 ,p_ctp_attribute19 => p_ctp_attribute19
497 ,p_ctp_attribute20 => p_ctp_attribute20
498 ,p_ctp_attribute21 => p_ctp_attribute21
499 ,p_ctp_attribute22 => p_ctp_attribute22
500 ,p_ctp_attribute23 => p_ctp_attribute23
501 ,p_ctp_attribute24 => p_ctp_attribute24
502 ,p_ctp_attribute25 => p_ctp_attribute25
503 ,p_ctp_attribute26 => p_ctp_attribute26
504 ,p_ctp_attribute27 => p_ctp_attribute27
505 ,p_ctp_attribute28 => p_ctp_attribute28
506 ,p_ctp_attribute29 => p_ctp_attribute29
507 ,p_ctp_attribute30 => p_ctp_attribute30
508 ,p_object_version_number => l_object_version_number
509 ,p_effective_date => trunc(p_effective_date)
510 );
511 exception
512 when hr_api.cannot_find_prog_unit then
513 hr_api.cannot_find_prog_unit_error
514 (p_module_name => 'CREATE_Plan_Type_In_Program'
515 ,p_hook_type => 'AP'
516 );
517 --
518 -- End of API User Hook for the after hook of create_Plan_Type_In_Program
519 --
520 end;
521 --
522 -- bug 1285336
523 hr_utility.set_location(l_proc, 60);
524 --
525 hr_utility.set_location('p_pgm_id '||p_pgm_id , 65.1);
526 hr_utility.set_location('l_ptip_id'||l_ptip_id,65.2);
527
528 FOR l_otp IN c_otp( l_ptip_id ) LOOP
529 --
530 hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
531 hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
532 hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
533 hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
534 --
535 ben_opt_pltyp_in_pgm_api.create_opt_pltyp_in_pgm
536 (p_validate => false
537 ,p_optip_id =>l_optip_id
538 ,p_effective_start_date =>l_otp_effective_start_date
539 ,p_effective_end_date =>l_otp_effective_end_date
540 ,p_business_group_id =>p_business_group_id
541 ,p_pgm_id =>p_pgm_id
542 ,p_ptip_id =>l_ptip_id
543 ,p_pl_typ_id =>l_otp.pl_typ_id
544 ,p_opt_id =>l_otp.opt_id
545 -- ,p_cmbn_ptip_opt_id =>p_cmbn_ptip_opt_id
546 ,p_object_version_number =>l_otp_object_version_number
547 ,p_effective_date =>p_effective_date
548 );
549 hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 66);
550 END LOOP ;
551
552
553 -- When in validation only mode raise the Validate_Enabled exception
554 --
555 if p_validate then
556 raise hr_api.validate_enabled;
557 end if;
558 --
559 -- Set all output arguments
560 --
561 p_ptip_id := l_ptip_id;
562 p_effective_start_date := l_effective_start_date;
563 p_effective_end_date := l_effective_end_date;
564 p_object_version_number := l_object_version_number;
565 --
566 hr_utility.set_location(' Leaving:'||l_proc, 70);
567 --
568 exception
569 --
570 when hr_api.validate_enabled then
571 --
572 -- As the Validate_Enabled exception has been raised
573 -- we must rollback to the savepoint
574 --
575 ROLLBACK TO create_Plan_Type_In_Program;
576 --
577 -- Only set output warning arguments
578 -- (Any key or derived arguments must be set to null
579 -- when validation only mode is being used.)
580 --
581 p_ptip_id := null;
582 p_effective_start_date := null;
583 p_effective_end_date := null;
584 p_object_version_number := null;
585 hr_utility.set_location(' Leaving:'||l_proc, 80);
586 --
587 when others then
588 --
589 -- A validation or unexpected error has occured
590 --
591 ROLLBACK TO create_Plan_Type_In_Program;
592 p_ptip_id := null;
593 p_effective_start_date := null;
594 p_effective_end_date := null;
595 p_object_version_number := null;
596 raise;
597 --
598 end create_Plan_Type_In_Program;
599 -- ----------------------------------------------------------------------------
600 -- |------------------------< update_Plan_Type_In_Program >--- ------------------|
601 -- ----------------------------------------------------------------------------
602 --
603 procedure update_Plan_Type_In_Program
604 (p_validate in boolean default false
605 ,p_ptip_id in number
606 ,p_effective_start_date out nocopy date
607 ,p_effective_end_date out nocopy date
608 ,p_coord_cvg_for_all_pls_flag in varchar2 default hr_api.g_varchar2
609 ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
610 ,p_dpnt_cvg_no_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
611 ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
612 ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
613 ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
614 ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
615 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
616 ,p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number
617 ,p_dpnt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
618 ,p_dpnt_cvg_end_dt_rl in number default hr_api.g_number
619 ,p_dpnt_adrs_rqd_flag in varchar2 default hr_api.g_varchar2
620 ,p_dpnt_legv_id_rqd_flag in varchar2 default hr_api.g_varchar2
621 ,p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 default hr_api.g_varchar2
622 ,p_susp_if_dpnt_dob_nt_prv_cd in varchar2 default hr_api.g_varchar2
623 ,p_susp_if_dpnt_adr_nt_prv_cd in varchar2 default hr_api.g_varchar2
624 ,p_susp_if_ctfn_not_dpnt_flag in varchar2 default hr_api.g_varchar2
625 ,p_dpnt_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
626 ,p_postelcn_edit_rl in number default hr_api.g_number
627 ,p_rt_end_dt_rl in number default hr_api.g_number
628 ,p_rt_strt_dt_rl in number default hr_api.g_number
629 ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
630 ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
631 ,p_rqd_perd_enrt_nenrt_rl in number default hr_api.g_number
632 ,p_auto_enrt_mthd_rl in number default hr_api.g_number
633 ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
634 ,p_enrt_cd in varchar2 default hr_api.g_varchar2
635 ,p_enrt_rl in number default hr_api.g_number
636 ,p_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
637 ,p_dflt_enrt_det_rl in number default hr_api.g_number
638 ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
639 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
640 ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
641 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
642 ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
643 ,p_dpnt_dob_rqd_flag in varchar2 default hr_api.g_varchar2
644 ,p_crs_this_pl_typ_only_flag in varchar2 default hr_api.g_varchar2
645 ,p_ptip_stat_cd in varchar2 default hr_api.g_varchar2
646 ,p_mx_cvg_alwd_amt in number default hr_api.g_number
647 ,p_mx_enrd_alwd_ovrid_num in number default hr_api.g_number
648 ,p_mn_enrd_rqd_ovrid_num in number default hr_api.g_number
649 ,p_no_mx_pl_typ_ovrid_flag in varchar2 default hr_api.g_varchar2
650 ,p_ordr_num in number default hr_api.g_number
651 ,p_prvds_cr_flag in varchar2 default hr_api.g_varchar2
652 ,p_rqd_perd_enrt_nenrt_val in number default hr_api.g_number
653 ,p_rqd_perd_enrt_nenrt_tm_uom in varchar2 default hr_api.g_varchar2
654 ,p_wvbl_flag in varchar2 default hr_api.g_varchar2
655 ,p_drvd_fctr_dpnt_cvg_flag in varchar2 default hr_api.g_varchar2
656 ,p_no_mn_pl_typ_overid_flag in varchar2 default hr_api.g_varchar2
657 ,p_sbj_to_sps_lf_ins_mx_flag in varchar2 default hr_api.g_varchar2
658 ,p_sbj_to_dpnt_lf_ins_mx_flag in varchar2 default hr_api.g_varchar2
659 ,p_use_to_sum_ee_lf_ins_flag in varchar2 default hr_api.g_varchar2
660 ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
661 ,p_short_name in varchar2 default hr_api.g_varchar2
662 ,p_short_code in varchar2 default hr_api.g_varchar2
663 ,p_legislation_code in varchar2 default hr_api.g_varchar2
664 ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
665 ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
666 ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
667 ,p_ivr_ident in varchar2 default hr_api.g_varchar2
668 ,p_url_ref_name in varchar2 default hr_api.g_varchar2
669 ,p_rqd_enrt_perd_tco_cd in varchar2 default hr_api.g_varchar2
670 ,p_pgm_id in number default hr_api.g_number
671 ,p_pl_typ_id in number default hr_api.g_number
672 ,p_cmbn_ptip_id in number default hr_api.g_number
673 ,p_cmbn_ptip_opt_id in number default hr_api.g_number
674 ,p_acrs_ptip_cvg_id in number default hr_api.g_number
675 ,p_business_group_id in number default hr_api.g_number
676 ,p_ctp_attribute_category in varchar2 default hr_api.g_varchar2
677 ,p_ctp_attribute1 in varchar2 default hr_api.g_varchar2
678 ,p_ctp_attribute2 in varchar2 default hr_api.g_varchar2
679 ,p_ctp_attribute3 in varchar2 default hr_api.g_varchar2
680 ,p_ctp_attribute4 in varchar2 default hr_api.g_varchar2
681 ,p_ctp_attribute5 in varchar2 default hr_api.g_varchar2
682 ,p_ctp_attribute6 in varchar2 default hr_api.g_varchar2
683 ,p_ctp_attribute7 in varchar2 default hr_api.g_varchar2
684 ,p_ctp_attribute8 in varchar2 default hr_api.g_varchar2
685 ,p_ctp_attribute9 in varchar2 default hr_api.g_varchar2
686 ,p_ctp_attribute10 in varchar2 default hr_api.g_varchar2
687 ,p_ctp_attribute11 in varchar2 default hr_api.g_varchar2
688 ,p_ctp_attribute12 in varchar2 default hr_api.g_varchar2
689 ,p_ctp_attribute13 in varchar2 default hr_api.g_varchar2
690 ,p_ctp_attribute14 in varchar2 default hr_api.g_varchar2
691 ,p_ctp_attribute15 in varchar2 default hr_api.g_varchar2
692 ,p_ctp_attribute16 in varchar2 default hr_api.g_varchar2
693 ,p_ctp_attribute17 in varchar2 default hr_api.g_varchar2
694 ,p_ctp_attribute18 in varchar2 default hr_api.g_varchar2
695 ,p_ctp_attribute19 in varchar2 default hr_api.g_varchar2
696 ,p_ctp_attribute20 in varchar2 default hr_api.g_varchar2
697 ,p_ctp_attribute21 in varchar2 default hr_api.g_varchar2
698 ,p_ctp_attribute22 in varchar2 default hr_api.g_varchar2
699 ,p_ctp_attribute23 in varchar2 default hr_api.g_varchar2
700 ,p_ctp_attribute24 in varchar2 default hr_api.g_varchar2
701 ,p_ctp_attribute25 in varchar2 default hr_api.g_varchar2
702 ,p_ctp_attribute26 in varchar2 default hr_api.g_varchar2
703 ,p_ctp_attribute27 in varchar2 default hr_api.g_varchar2
704 ,p_ctp_attribute28 in varchar2 default hr_api.g_varchar2
705 ,p_ctp_attribute29 in varchar2 default hr_api.g_varchar2
706 ,p_ctp_attribute30 in varchar2 default hr_api.g_varchar2
707 ,p_object_version_number in out nocopy number
708 ,p_effective_date in date
709 ,p_datetrack_mode in varchar2
710 ) is
711 --
712 -- Declare cursors and local variables
713 --
714 l_proc varchar2(72) := g_package||'update_Plan_Type_In_Program';
715 l_object_version_number ben_ptip_f.object_version_number%TYPE;
716 l_effective_start_date ben_ptip_f.effective_start_date%TYPE;
717 l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
718 --
719 begin
720 --
721 hr_utility.set_location('Entering:'|| l_proc, 10);
722 --
723 -- Issue a savepoint if operating in validation only mode
724 --
725 savepoint update_Plan_Type_In_Program;
726 --
727 hr_utility.set_location(l_proc, 20);
728 --
729 -- Process Logic
730 --
731 l_object_version_number := p_object_version_number;
732 --
733 begin
734 --
735 -- Start of API User Hook for the before hook of update_Plan_Type_In_Program
736 --
737 ben_Plan_Type_In_Program_bk2.update_Plan_Type_In_Program_b
738 (
739 p_ptip_id => p_ptip_id
740 ,p_coord_cvg_for_all_pls_flag => p_coord_cvg_for_all_pls_flag
741 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
742 ,p_dpnt_cvg_no_ctfn_rqd_flag => p_dpnt_cvg_no_ctfn_rqd_flag
743 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
744 ,p_rt_end_dt_cd => p_rt_end_dt_cd
745 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
746 ,p_enrt_cvg_end_dt_cd => p_enrt_cvg_end_dt_cd
747 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
748 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
749 ,p_dpnt_cvg_end_dt_cd => p_dpnt_cvg_end_dt_cd
750 ,p_dpnt_cvg_end_dt_rl => p_dpnt_cvg_end_dt_rl
751 ,p_dpnt_adrs_rqd_flag => p_dpnt_adrs_rqd_flag
752 ,p_dpnt_legv_id_rqd_flag => p_dpnt_legv_id_rqd_flag
753 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_susp_if_dpnt_ssn_nt_prv_cd
754 ,p_susp_if_dpnt_dob_nt_prv_cd => p_susp_if_dpnt_dob_nt_prv_cd
755 ,p_susp_if_dpnt_adr_nt_prv_cd => p_susp_if_dpnt_adr_nt_prv_cd
756 ,p_susp_if_ctfn_not_dpnt_flag => p_susp_if_ctfn_not_dpnt_flag
757 ,p_dpnt_ctfn_determine_cd => p_dpnt_ctfn_determine_cd
758 ,p_postelcn_edit_rl => p_postelcn_edit_rl
759 ,p_rt_end_dt_rl => p_rt_end_dt_rl
760 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
761 ,p_enrt_cvg_end_dt_rl => p_enrt_cvg_end_dt_rl
762 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
763 ,p_rqd_perd_enrt_nenrt_rl => p_rqd_perd_enrt_nenrt_rl
764 ,p_auto_enrt_mthd_rl => p_auto_enrt_mthd_rl
765 ,p_enrt_mthd_cd => p_enrt_mthd_cd
766 ,p_enrt_cd => p_enrt_cd
767 ,p_enrt_rl => p_enrt_rl
768 ,p_dflt_enrt_cd => p_dflt_enrt_cd
769 ,p_dflt_enrt_det_rl => p_dflt_enrt_det_rl
770 ,p_drvbl_fctr_apls_rts_flag => p_drvbl_fctr_apls_rts_flag
771 ,p_drvbl_fctr_prtn_elig_flag => p_drvbl_fctr_prtn_elig_flag
772 ,p_elig_apls_flag => p_elig_apls_flag
773 ,p_prtn_elig_ovrid_alwd_flag => p_prtn_elig_ovrid_alwd_flag
774 ,p_trk_inelig_per_flag => p_trk_inelig_per_flag
775 ,p_dpnt_dob_rqd_flag => p_dpnt_dob_rqd_flag
776 ,p_crs_this_pl_typ_only_flag => p_crs_this_pl_typ_only_flag
777 ,p_ptip_stat_cd => p_ptip_stat_cd
778 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
779 ,p_mx_enrd_alwd_ovrid_num => p_mx_enrd_alwd_ovrid_num
780 ,p_mn_enrd_rqd_ovrid_num => p_mn_enrd_rqd_ovrid_num
781 ,p_no_mx_pl_typ_ovrid_flag => p_no_mx_pl_typ_ovrid_flag
782 ,p_ordr_num => p_ordr_num
783 ,p_prvds_cr_flag => p_prvds_cr_flag
784 ,p_rqd_perd_enrt_nenrt_val => p_rqd_perd_enrt_nenrt_val
785 ,p_rqd_perd_enrt_nenrt_tm_uom => p_rqd_perd_enrt_nenrt_tm_uom
786 ,p_wvbl_flag => p_wvbl_flag
787 ,p_drvd_fctr_dpnt_cvg_flag => p_drvd_fctr_dpnt_cvg_flag
788 ,p_no_mn_pl_typ_overid_flag => p_no_mn_pl_typ_overid_flag
789 ,p_sbj_to_sps_lf_ins_mx_flag => p_sbj_to_sps_lf_ins_mx_flag
790 ,p_sbj_to_dpnt_lf_ins_mx_flag => p_sbj_to_dpnt_lf_ins_mx_flag
791 ,p_use_to_sum_ee_lf_ins_flag => p_use_to_sum_ee_lf_ins_flag
792 ,p_per_cvrd_cd => p_per_cvrd_cd
793 ,p_short_name => p_short_name
794 ,p_short_code => p_short_code
795 ,p_legislation_code => p_legislation_code
796 ,p_legislation_subgroup => p_legislation_subgroup
797 ,p_vrfy_fmly_mmbr_cd => p_vrfy_fmly_mmbr_cd
798 ,p_vrfy_fmly_mmbr_rl => p_vrfy_fmly_mmbr_rl
799 ,p_ivr_ident => p_ivr_ident
800 ,p_url_ref_name => p_url_ref_name
801 ,p_rqd_enrt_perd_tco_cd => p_rqd_enrt_perd_tco_cd
802 ,p_pgm_id => p_pgm_id
803 ,p_pl_typ_id => p_pl_typ_id
804 ,p_cmbn_ptip_id => p_cmbn_ptip_id
805 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
806 ,p_acrs_ptip_cvg_id => p_acrs_ptip_cvg_id
807 ,p_business_group_id => p_business_group_id
808 ,p_ctp_attribute_category => p_ctp_attribute_category
809 ,p_ctp_attribute1 => p_ctp_attribute1
810 ,p_ctp_attribute2 => p_ctp_attribute2
811 ,p_ctp_attribute3 => p_ctp_attribute3
812 ,p_ctp_attribute4 => p_ctp_attribute4
813 ,p_ctp_attribute5 => p_ctp_attribute5
814 ,p_ctp_attribute6 => p_ctp_attribute6
815 ,p_ctp_attribute7 => p_ctp_attribute7
816 ,p_ctp_attribute8 => p_ctp_attribute8
817 ,p_ctp_attribute9 => p_ctp_attribute9
818 ,p_ctp_attribute10 => p_ctp_attribute10
819 ,p_ctp_attribute11 => p_ctp_attribute11
820 ,p_ctp_attribute12 => p_ctp_attribute12
821 ,p_ctp_attribute13 => p_ctp_attribute13
822 ,p_ctp_attribute14 => p_ctp_attribute14
823 ,p_ctp_attribute15 => p_ctp_attribute15
824 ,p_ctp_attribute16 => p_ctp_attribute16
825 ,p_ctp_attribute17 => p_ctp_attribute17
826 ,p_ctp_attribute18 => p_ctp_attribute18
827 ,p_ctp_attribute19 => p_ctp_attribute19
828 ,p_ctp_attribute20 => p_ctp_attribute20
829 ,p_ctp_attribute21 => p_ctp_attribute21
830 ,p_ctp_attribute22 => p_ctp_attribute22
831 ,p_ctp_attribute23 => p_ctp_attribute23
832 ,p_ctp_attribute24 => p_ctp_attribute24
833 ,p_ctp_attribute25 => p_ctp_attribute25
834 ,p_ctp_attribute26 => p_ctp_attribute26
835 ,p_ctp_attribute27 => p_ctp_attribute27
836 ,p_ctp_attribute28 => p_ctp_attribute28
837 ,p_ctp_attribute29 => p_ctp_attribute29
838 ,p_ctp_attribute30 => p_ctp_attribute30
839 ,p_object_version_number => p_object_version_number
840 ,p_effective_date => trunc(p_effective_date)
841 ,p_datetrack_mode => p_datetrack_mode
842 );
843 exception
844 when hr_api.cannot_find_prog_unit then
845 hr_api.cannot_find_prog_unit_error
846 (p_module_name => 'UPDATE_Plan_Type_In_Program'
847 ,p_hook_type => 'BP'
848 );
849 --
850 -- End of API User Hook for the before hook of update_Plan_Type_In_Program
851 --
852 end;
853 --
854 ben_ctp_upd.upd
855 (
856 p_ptip_id => p_ptip_id
857 ,p_effective_start_date => l_effective_start_date
858 ,p_effective_end_date => l_effective_end_date
859 ,p_coord_cvg_for_all_pls_flag => p_coord_cvg_for_all_pls_flag
860 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
861 ,p_dpnt_cvg_no_ctfn_rqd_flag => p_dpnt_cvg_no_ctfn_rqd_flag
862 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
863 ,p_rt_end_dt_cd => p_rt_end_dt_cd
864 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
865 ,p_enrt_cvg_end_dt_cd => p_enrt_cvg_end_dt_cd
866 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
867 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
868 ,p_dpnt_cvg_end_dt_cd => p_dpnt_cvg_end_dt_cd
869 ,p_dpnt_cvg_end_dt_rl => p_dpnt_cvg_end_dt_rl
870 ,p_dpnt_adrs_rqd_flag => p_dpnt_adrs_rqd_flag
871 ,p_dpnt_legv_id_rqd_flag => p_dpnt_legv_id_rqd_flag
872 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_susp_if_dpnt_ssn_nt_prv_cd
873 ,p_susp_if_dpnt_dob_nt_prv_cd => p_susp_if_dpnt_dob_nt_prv_cd
874 ,p_susp_if_dpnt_adr_nt_prv_cd => p_susp_if_dpnt_adr_nt_prv_cd
875 ,p_susp_if_ctfn_not_dpnt_flag => p_susp_if_ctfn_not_dpnt_flag
876 ,p_dpnt_ctfn_determine_cd => p_dpnt_ctfn_determine_cd
877 ,p_postelcn_edit_rl => p_postelcn_edit_rl
878 ,p_rt_end_dt_rl => p_rt_end_dt_rl
879 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
880 ,p_enrt_cvg_end_dt_rl => p_enrt_cvg_end_dt_rl
881 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
882 ,p_rqd_perd_enrt_nenrt_rl => p_rqd_perd_enrt_nenrt_rl
883 ,p_auto_enrt_mthd_rl => p_auto_enrt_mthd_rl
884 ,p_enrt_mthd_cd => p_enrt_mthd_cd
885 ,p_enrt_cd => p_enrt_cd
886 ,p_enrt_rl => p_enrt_rl
887 ,p_dflt_enrt_cd => p_dflt_enrt_cd
888 ,p_dflt_enrt_det_rl => p_dflt_enrt_det_rl
889 ,p_drvbl_fctr_apls_rts_flag => p_drvbl_fctr_apls_rts_flag
890 ,p_drvbl_fctr_prtn_elig_flag => p_drvbl_fctr_prtn_elig_flag
891 ,p_elig_apls_flag => p_elig_apls_flag
892 ,p_prtn_elig_ovrid_alwd_flag => p_prtn_elig_ovrid_alwd_flag
893 ,p_trk_inelig_per_flag => p_trk_inelig_per_flag
894 ,p_dpnt_dob_rqd_flag => p_dpnt_dob_rqd_flag
895 ,p_crs_this_pl_typ_only_flag => p_crs_this_pl_typ_only_flag
896 ,p_ptip_stat_cd => p_ptip_stat_cd
897 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
898 ,p_mx_enrd_alwd_ovrid_num => p_mx_enrd_alwd_ovrid_num
899 ,p_mn_enrd_rqd_ovrid_num => p_mn_enrd_rqd_ovrid_num
900 ,p_no_mx_pl_typ_ovrid_flag => p_no_mx_pl_typ_ovrid_flag
901 ,p_ordr_num => p_ordr_num
902 ,p_prvds_cr_flag => p_prvds_cr_flag
903 ,p_rqd_perd_enrt_nenrt_val => p_rqd_perd_enrt_nenrt_val
904 ,p_rqd_perd_enrt_nenrt_tm_uom => p_rqd_perd_enrt_nenrt_tm_uom
905 ,p_wvbl_flag => p_wvbl_flag
906 ,p_drvd_fctr_dpnt_cvg_flag => p_drvd_fctr_dpnt_cvg_flag
907 ,p_no_mn_pl_typ_overid_flag => p_no_mn_pl_typ_overid_flag
908 ,p_sbj_to_sps_lf_ins_mx_flag => p_sbj_to_sps_lf_ins_mx_flag
909 ,p_sbj_to_dpnt_lf_ins_mx_flag => p_sbj_to_dpnt_lf_ins_mx_flag
910 ,p_use_to_sum_ee_lf_ins_flag => p_use_to_sum_ee_lf_ins_flag
911 ,p_per_cvrd_cd => p_per_cvrd_cd
912 ,p_short_name => p_short_name
913 ,p_short_code => p_short_code
914 ,p_legislation_code => p_legislation_code
915 ,p_legislation_subgroup => p_legislation_subgroup
916 ,p_vrfy_fmly_mmbr_cd => p_vrfy_fmly_mmbr_cd
917 ,p_vrfy_fmly_mmbr_rl => p_vrfy_fmly_mmbr_rl
918 ,p_ivr_ident => p_ivr_ident
919 ,p_url_ref_name => p_url_ref_name
920 ,p_rqd_enrt_perd_tco_cd => p_rqd_enrt_perd_tco_cd
921 ,p_pgm_id => p_pgm_id
922 ,p_pl_typ_id => p_pl_typ_id
923 ,p_cmbn_ptip_id => p_cmbn_ptip_id
924 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
925 ,p_acrs_ptip_cvg_id => p_acrs_ptip_cvg_id
926 ,p_business_group_id => p_business_group_id
927 ,p_ctp_attribute_category => p_ctp_attribute_category
928 ,p_ctp_attribute1 => p_ctp_attribute1
929 ,p_ctp_attribute2 => p_ctp_attribute2
930 ,p_ctp_attribute3 => p_ctp_attribute3
931 ,p_ctp_attribute4 => p_ctp_attribute4
932 ,p_ctp_attribute5 => p_ctp_attribute5
933 ,p_ctp_attribute6 => p_ctp_attribute6
934 ,p_ctp_attribute7 => p_ctp_attribute7
935 ,p_ctp_attribute8 => p_ctp_attribute8
936 ,p_ctp_attribute9 => p_ctp_attribute9
937 ,p_ctp_attribute10 => p_ctp_attribute10
938 ,p_ctp_attribute11 => p_ctp_attribute11
939 ,p_ctp_attribute12 => p_ctp_attribute12
940 ,p_ctp_attribute13 => p_ctp_attribute13
941 ,p_ctp_attribute14 => p_ctp_attribute14
942 ,p_ctp_attribute15 => p_ctp_attribute15
943 ,p_ctp_attribute16 => p_ctp_attribute16
944 ,p_ctp_attribute17 => p_ctp_attribute17
945 ,p_ctp_attribute18 => p_ctp_attribute18
946 ,p_ctp_attribute19 => p_ctp_attribute19
947 ,p_ctp_attribute20 => p_ctp_attribute20
948 ,p_ctp_attribute21 => p_ctp_attribute21
949 ,p_ctp_attribute22 => p_ctp_attribute22
950 ,p_ctp_attribute23 => p_ctp_attribute23
951 ,p_ctp_attribute24 => p_ctp_attribute24
952 ,p_ctp_attribute25 => p_ctp_attribute25
953 ,p_ctp_attribute26 => p_ctp_attribute26
954 ,p_ctp_attribute27 => p_ctp_attribute27
955 ,p_ctp_attribute28 => p_ctp_attribute28
956 ,p_ctp_attribute29 => p_ctp_attribute29
957 ,p_ctp_attribute30 => p_ctp_attribute30
958 ,p_object_version_number => l_object_version_number
959 ,p_effective_date => trunc(p_effective_date)
960 ,p_datetrack_mode => p_datetrack_mode
961 );
962 --
963 begin
964 --
965 -- Start of API User Hook for the after hook of update_Plan_Type_In_Program
966 --
967 ben_Plan_Type_In_Program_bk2.update_Plan_Type_In_Program_a
968 (
969 p_ptip_id => p_ptip_id
970 ,p_effective_start_date => l_effective_start_date
971 ,p_effective_end_date => l_effective_end_date
972 ,p_coord_cvg_for_all_pls_flag => p_coord_cvg_for_all_pls_flag
973 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
974 ,p_dpnt_cvg_no_ctfn_rqd_flag => p_dpnt_cvg_no_ctfn_rqd_flag
975 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
976 ,p_rt_end_dt_cd => p_rt_end_dt_cd
977 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
978 ,p_enrt_cvg_end_dt_cd => p_enrt_cvg_end_dt_cd
979 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
980 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
981 ,p_dpnt_cvg_end_dt_cd => p_dpnt_cvg_end_dt_cd
982 ,p_dpnt_cvg_end_dt_rl => p_dpnt_cvg_end_dt_rl
983 ,p_dpnt_adrs_rqd_flag => p_dpnt_adrs_rqd_flag
984 ,p_dpnt_legv_id_rqd_flag => p_dpnt_legv_id_rqd_flag
985 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_susp_if_dpnt_ssn_nt_prv_cd
986 ,p_susp_if_dpnt_dob_nt_prv_cd => p_susp_if_dpnt_dob_nt_prv_cd
987 ,p_susp_if_dpnt_adr_nt_prv_cd => p_susp_if_dpnt_adr_nt_prv_cd
988 ,p_susp_if_ctfn_not_dpnt_flag => p_susp_if_ctfn_not_dpnt_flag
989 ,p_dpnt_ctfn_determine_cd => p_dpnt_ctfn_determine_cd
990 ,p_postelcn_edit_rl => p_postelcn_edit_rl
991 ,p_rt_end_dt_rl => p_rt_end_dt_rl
992 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
993 ,p_enrt_cvg_end_dt_rl => p_enrt_cvg_end_dt_rl
994 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
995 ,p_rqd_perd_enrt_nenrt_rl => p_rqd_perd_enrt_nenrt_rl
996 ,p_auto_enrt_mthd_rl => p_auto_enrt_mthd_rl
997 ,p_enrt_mthd_cd => p_enrt_mthd_cd
998 ,p_enrt_cd => p_enrt_cd
999 ,p_enrt_rl => p_enrt_rl
1000 ,p_dflt_enrt_cd => p_dflt_enrt_cd
1001 ,p_dflt_enrt_det_rl => p_dflt_enrt_det_rl
1002 ,p_drvbl_fctr_apls_rts_flag => p_drvbl_fctr_apls_rts_flag
1003 ,p_drvbl_fctr_prtn_elig_flag => p_drvbl_fctr_prtn_elig_flag
1004 ,p_elig_apls_flag => p_elig_apls_flag
1005 ,p_prtn_elig_ovrid_alwd_flag => p_prtn_elig_ovrid_alwd_flag
1006 ,p_trk_inelig_per_flag => p_trk_inelig_per_flag
1007 ,p_dpnt_dob_rqd_flag => p_dpnt_dob_rqd_flag
1008 ,p_crs_this_pl_typ_only_flag => p_crs_this_pl_typ_only_flag
1009 ,p_ptip_stat_cd => p_ptip_stat_cd
1010 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
1011 ,p_mx_enrd_alwd_ovrid_num => p_mx_enrd_alwd_ovrid_num
1012 ,p_mn_enrd_rqd_ovrid_num => p_mn_enrd_rqd_ovrid_num
1013 ,p_no_mx_pl_typ_ovrid_flag => p_no_mx_pl_typ_ovrid_flag
1014 ,p_ordr_num => p_ordr_num
1015 ,p_prvds_cr_flag => p_prvds_cr_flag
1016 ,p_rqd_perd_enrt_nenrt_val => p_rqd_perd_enrt_nenrt_val
1017 ,p_rqd_perd_enrt_nenrt_tm_uom => p_rqd_perd_enrt_nenrt_tm_uom
1018 ,p_wvbl_flag => p_wvbl_flag
1019 ,p_drvd_fctr_dpnt_cvg_flag => p_drvd_fctr_dpnt_cvg_flag
1020 ,p_no_mn_pl_typ_overid_flag => p_no_mn_pl_typ_overid_flag
1021 ,p_sbj_to_sps_lf_ins_mx_flag => p_sbj_to_sps_lf_ins_mx_flag
1022 ,p_sbj_to_dpnt_lf_ins_mx_flag => p_sbj_to_dpnt_lf_ins_mx_flag
1023 ,p_use_to_sum_ee_lf_ins_flag => p_use_to_sum_ee_lf_ins_flag
1024 ,p_per_cvrd_cd => p_per_cvrd_cd
1025 ,p_short_name => p_short_name
1026 ,p_short_code => p_short_code
1027 ,p_legislation_code => p_legislation_code
1028 ,p_legislation_subgroup => p_legislation_subgroup
1029 ,p_vrfy_fmly_mmbr_cd => p_vrfy_fmly_mmbr_cd
1030 ,p_vrfy_fmly_mmbr_rl => p_vrfy_fmly_mmbr_rl
1031 ,p_ivr_ident => p_ivr_ident
1032 ,p_url_ref_name => p_url_ref_name
1033 ,p_rqd_enrt_perd_tco_cd => p_rqd_enrt_perd_tco_cd
1034 ,p_pgm_id => p_pgm_id
1035 ,p_pl_typ_id => p_pl_typ_id
1036 ,p_cmbn_ptip_id => p_cmbn_ptip_id
1037 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
1038 ,p_acrs_ptip_cvg_id => p_acrs_ptip_cvg_id
1039 ,p_business_group_id => p_business_group_id
1040 ,p_ctp_attribute_category => p_ctp_attribute_category
1041 ,p_ctp_attribute1 => p_ctp_attribute1
1042 ,p_ctp_attribute2 => p_ctp_attribute2
1043 ,p_ctp_attribute3 => p_ctp_attribute3
1044 ,p_ctp_attribute4 => p_ctp_attribute4
1045 ,p_ctp_attribute5 => p_ctp_attribute5
1046 ,p_ctp_attribute6 => p_ctp_attribute6
1047 ,p_ctp_attribute7 => p_ctp_attribute7
1048 ,p_ctp_attribute8 => p_ctp_attribute8
1049 ,p_ctp_attribute9 => p_ctp_attribute9
1050 ,p_ctp_attribute10 => p_ctp_attribute10
1051 ,p_ctp_attribute11 => p_ctp_attribute11
1052 ,p_ctp_attribute12 => p_ctp_attribute12
1053 ,p_ctp_attribute13 => p_ctp_attribute13
1054 ,p_ctp_attribute14 => p_ctp_attribute14
1055 ,p_ctp_attribute15 => p_ctp_attribute15
1056 ,p_ctp_attribute16 => p_ctp_attribute16
1057 ,p_ctp_attribute17 => p_ctp_attribute17
1058 ,p_ctp_attribute18 => p_ctp_attribute18
1059 ,p_ctp_attribute19 => p_ctp_attribute19
1060 ,p_ctp_attribute20 => p_ctp_attribute20
1061 ,p_ctp_attribute21 => p_ctp_attribute21
1062 ,p_ctp_attribute22 => p_ctp_attribute22
1063 ,p_ctp_attribute23 => p_ctp_attribute23
1064 ,p_ctp_attribute24 => p_ctp_attribute24
1065 ,p_ctp_attribute25 => p_ctp_attribute25
1066 ,p_ctp_attribute26 => p_ctp_attribute26
1067 ,p_ctp_attribute27 => p_ctp_attribute27
1068 ,p_ctp_attribute28 => p_ctp_attribute28
1069 ,p_ctp_attribute29 => p_ctp_attribute29
1070 ,p_ctp_attribute30 => p_ctp_attribute30
1071 ,p_object_version_number => l_object_version_number
1072 ,p_effective_date => trunc(p_effective_date)
1073 ,p_datetrack_mode => p_datetrack_mode
1074 );
1075 exception
1076 when hr_api.cannot_find_prog_unit then
1077 hr_api.cannot_find_prog_unit_error
1078 (p_module_name => 'UPDATE_Plan_Type_In_Program'
1079 ,p_hook_type => 'AP'
1080 );
1081 --
1082 -- End of API User Hook for the after hook of update_Plan_Type_In_Program
1083 --
1084 end;
1085 --
1086 hr_utility.set_location(l_proc, 60);
1087 --
1088 -- When in validation only mode raise the Validate_Enabled exception
1089 --
1090 if p_validate then
1091 raise hr_api.validate_enabled;
1092 end if;
1093 --
1094 -- Set all output arguments
1095 --
1096 p_object_version_number := l_object_version_number;
1097 p_effective_start_date := l_effective_start_date;
1098 p_effective_end_date := l_effective_end_date;
1099 --
1100 hr_utility.set_location(' Leaving:'||l_proc, 70);
1101 --
1102 exception
1103 --
1104 when hr_api.validate_enabled then
1105 --
1106 -- As the Validate_Enabled exception has been raised
1107 -- we must rollback to the savepoint
1108 --
1109 ROLLBACK TO update_Plan_Type_In_Program;
1110 --
1111 -- Only set output warning arguments
1112 -- (Any key or derived arguments must be set to null
1113 -- when validation only mode is being used.)
1114 --
1115 p_effective_start_date := null;
1116 p_effective_end_date := null;
1117 hr_utility.set_location(' Leaving:'||l_proc, 80);
1118 --
1119 when others then
1120 --
1121 -- A validation or unexpected error has occured
1122 --
1123 ROLLBACK TO update_Plan_Type_In_Program;
1124 p_effective_start_date := null;
1125 p_effective_end_date := null;
1126 raise;
1127 --
1128 end update_Plan_Type_In_Program;
1129 -- ----------------------------------------------------------------------------
1130 -- |------------------------< delete_Plan_Type_In_Program >----------------------|
1131 -- ----------------------------------------------------------------------------
1132 --
1133 procedure delete_Plan_Type_In_Program
1134 (p_validate in boolean default false
1135 ,p_ptip_id in number
1136 ,p_effective_start_date out nocopy date
1137 ,p_effective_end_date out nocopy date
1138 ,p_object_version_number in out nocopy number
1139 ,p_effective_date in date
1140 ,p_datetrack_mode in varchar2
1141 ) is
1142 --
1143 -- Declare cursors and local variables
1144 --
1145 l_proc varchar2(72) := g_package||'update_Plan_Type_In_Program';
1146 l_object_version_number ben_ptip_f.object_version_number%TYPE;
1147 l_effective_start_date ben_ptip_f.effective_start_date%TYPE;
1148 l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
1149 --
1150 begin
1151 --
1152 hr_utility.set_location('Entering:'|| l_proc, 10);
1153 --
1154 -- Issue a savepoint if operating in validation only mode
1155 --
1156 savepoint delete_Plan_Type_In_Program;
1157 --
1158 hr_utility.set_location(l_proc, 20);
1159 --
1160 -- Process Logic
1161 --
1162 l_object_version_number := p_object_version_number;
1163 --
1164 --
1165 begin
1166 --
1167 -- Start of API User Hook for the before hook of delete_Plan_Type_In_Program
1168 --
1169 ben_Plan_Type_In_Program_bk3.delete_Plan_Type_In_Program_b
1170 (
1171 p_ptip_id => p_ptip_id
1172 ,p_object_version_number => p_object_version_number
1173 ,p_effective_date => trunc(p_effective_date)
1174 ,p_datetrack_mode => p_datetrack_mode
1175 );
1176 exception
1177 when hr_api.cannot_find_prog_unit then
1178 hr_api.cannot_find_prog_unit_error
1179 (p_module_name => 'DELETE_Plan_Type_In_Program'
1180 ,p_hook_type => 'BP'
1181 );
1182 --
1183 -- End of API User Hook for the before hook of delete_Plan_Type_In_Program
1184 --
1185 end;
1186 --
1187 ben_ctp_del.del
1188 (
1189 p_ptip_id => p_ptip_id
1190 ,p_effective_start_date => l_effective_start_date
1191 ,p_effective_end_date => l_effective_end_date
1192 ,p_object_version_number => l_object_version_number
1193 ,p_effective_date => p_effective_date
1194 ,p_datetrack_mode => p_datetrack_mode
1195 );
1196 --
1197 begin
1198 --
1199 -- Start of API User Hook for the after hook of delete_Plan_Type_In_Program
1200 --
1201 ben_Plan_Type_In_Program_bk3.delete_Plan_Type_In_Program_a
1202 (
1203 p_ptip_id => p_ptip_id
1204 ,p_effective_start_date => l_effective_start_date
1205 ,p_effective_end_date => l_effective_end_date
1206 ,p_object_version_number => l_object_version_number
1207 ,p_effective_date => trunc(p_effective_date)
1208 ,p_datetrack_mode => p_datetrack_mode
1209 );
1210 exception
1211 when hr_api.cannot_find_prog_unit then
1212 hr_api.cannot_find_prog_unit_error
1213 (p_module_name => 'DELETE_Plan_Type_In_Program'
1214 ,p_hook_type => 'AP'
1215 );
1216 --
1217 -- End of API User Hook for the after hook of delete_Plan_Type_In_Program
1218 --
1219 end;
1220 --
1221 hr_utility.set_location(l_proc, 60);
1222 --
1223 -- When in validation only mode raise the Validate_Enabled exception
1224 --
1225 if p_validate then
1226 raise hr_api.validate_enabled;
1227 end if;
1228 --
1229 hr_utility.set_location(' Leaving:'||l_proc, 70);
1230 --
1231 exception
1232 --
1233 when hr_api.validate_enabled then
1234 --
1235 -- As the Validate_Enabled exception has been raised
1236 -- we must rollback to the savepoint
1237 --
1238 ROLLBACK TO delete_Plan_Type_In_Program;
1239 --
1240 -- Only set output warning arguments
1241 -- (Any key or derived arguments must be set to null
1242 -- when validation only mode is being used.)
1243 --
1244 p_effective_start_date := null;
1245 p_effective_end_date := null;
1246 --
1247 when others then
1248 --
1249 -- A validation or unexpected error has occured
1250 --
1251 ROLLBACK TO delete_Plan_Type_In_Program;
1252 p_effective_start_date := null;
1253 p_effective_end_date := null;
1254 raise;
1255 --
1256 end delete_Plan_Type_In_Program;
1257 --
1258 -- ----------------------------------------------------------------------------
1259 -- |-------------------------------< lck >------------------------------------|
1260 -- ----------------------------------------------------------------------------
1261 --
1262 procedure lck
1263 (
1264 p_ptip_id in number
1265 ,p_object_version_number in number
1266 ,p_effective_date in date
1267 ,p_datetrack_mode in varchar2
1268 ,p_validation_start_date out nocopy date
1269 ,p_validation_end_date out nocopy date
1270 ) is
1271 --
1272 --
1273 -- Declare cursors and local variables
1274 --
1275 l_proc varchar2(72) := g_package||'lck';
1276 l_validation_start_date date;
1277 l_validation_end_date date;
1278 --
1279 begin
1280 --
1281 hr_utility.set_location('Entering:'|| l_proc, 10);
1282 --
1283 ben_ctp_shd.lck
1284 (
1285 p_ptip_id => p_ptip_id
1286 ,p_validation_start_date => l_validation_start_date
1287 ,p_validation_end_date => l_validation_end_date
1288 ,p_object_version_number => p_object_version_number
1289 ,p_effective_date => p_effective_date
1290 ,p_datetrack_mode => p_datetrack_mode
1291 );
1292 --
1293 hr_utility.set_location(' Leaving:'||l_proc, 70);
1294 --
1295 end lck;
1296 --
1297 end ben_Plan_Type_In_Program_api;