[Home] [Help]
PACKAGE BODY: APPS.BEN_PLN_UPD
Source
1 Package Body ben_pln_upd as
2 /* $Header: beplnrhi.pkb 120.8.12010000.2 2008/08/18 09:47:19 ubhat ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ben_pln_upd.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------------< dt_update_dml >-----------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the execution of dml from the datetrack mode
17 -- of CORRECTION only. It is important to note that the object version
18 -- number is only increment by 1 because the datetrack correction is
19 -- soley for one datetracked row.
20 -- This procedure controls the actual dml update logic. The functions of this
21 -- procedure are as follows:
22 -- 1) Get the next object_version_number.
23 -- 2) To set and unset the g_api_dml status as required (as we are about to
24 -- perform dml).
25 -- 3) To update the specified row in the schema using the primary key in
26 -- the predicates.
27 -- 4) To trap any constraint violations that may have occurred.
28 -- 5) To raise any other errors.
29 --
30 -- Prerequisites:
31 -- This is an internal private procedure which must be called from the
32 -- update_dml procedure.
33 --
34 -- In Parameters:
35 -- A Pl/Sql record structre.
36 --
37 -- Post Success:
38 -- The specified row will be updated in the schema.
39 --
40 -- Post Failure:
41 -- On the update dml failure it is important to note that we always reset the
42 -- g_api_dml status to false.
43 -- If a check or unique integrity constraint violation is raised the
44 -- constraint_error procedure will be called.
45 -- If any other error is reported, the error will be raised after the
46 -- g_api_dml status is reset.
47 --
48 -- Developer Implementation Notes:
49 -- The update 'set' arguments list should be modified if any of your
50 -- attributes are not updateable.
51 --
52 -- Access Status:
53 -- Internal Row Handler Use Only.
54 --
55 -- {End Of Comments}
56 -- ----------------------------------------------------------------------------
57 Procedure dt_update_dml
58 (p_rec in out nocopy ben_pln_shd.g_rec_type,
59 p_effective_date in date,
60 p_datetrack_mode in varchar2,
61 p_validation_start_date in date,
62 p_validation_end_date in date) is
63 --
64 l_proc varchar2(72) := g_package||'dt_update_dml';
65 --
66 Begin
67 hr_utility.set_location('Entering:'||l_proc, 5);
68 --
69 If (p_datetrack_mode = 'CORRECTION') then
70 hr_utility.set_location(l_proc, 10);
71 --
72 -- Because we are updating a row we must get the next object
73 -- version number.
74 --
75 p_rec.object_version_number :=
76 dt_api.get_object_version_number
77 (p_base_table_name => 'ben_pl_f',
78 p_base_key_column => 'pl_id',
79 p_base_key_value => p_rec.pl_id);
80 --
81 ben_pln_shd.g_api_dml := true; -- Set the api dml status
82 --
83 -- Update the ben_pl_f Row
84 --
85 update ben_pl_f
86 set
87 NAME = p_rec.NAME
88 ,ALWS_QDRO_FLAG = p_rec.ALWS_QDRO_FLAG
89 ,ALWS_QMCSO_FLAG = p_rec.ALWS_QMCSO_FLAG
90 ,ALWS_REIMBMTS_FLAG = p_rec.ALWS_REIMBMTS_FLAG
91 ,BNF_ADDL_INSTN_TXT_ALWD_FLAG = p_rec.BNF_ADDL_INSTN_TXT_ALWD_FLAG
92 ,BNF_ADRS_RQD_FLAG = p_rec.BNF_ADRS_RQD_FLAG
93 ,BNF_CNTNGT_BNFS_ALWD_FLAG = p_rec.BNF_CNTNGT_BNFS_ALWD_FLAG
94 ,BNF_CTFN_RQD_FLAG = p_rec.BNF_CTFN_RQD_FLAG
95 ,BNF_DOB_RQD_FLAG = p_rec.BNF_DOB_RQD_FLAG
96 ,BNF_DSGE_MNR_TTEE_RQD_FLAG = p_rec.BNF_DSGE_MNR_TTEE_RQD_FLAG
97 ,BNF_INCRMT_AMT = p_rec.BNF_INCRMT_AMT
98 ,BNF_DFLT_BNF_CD = p_rec.BNF_DFLT_BNF_CD
99 ,BNF_LEGV_ID_RQD_FLAG = p_rec.BNF_LEGV_ID_RQD_FLAG
100 ,BNF_MAY_DSGT_ORG_FLAG = p_rec.BNF_MAY_DSGT_ORG_FLAG
101 ,BNF_MN_DSGNTBL_AMT = p_rec.BNF_MN_DSGNTBL_AMT
102 ,BNF_MN_DSGNTBL_PCT_VAL = p_rec.BNF_MN_DSGNTBL_PCT_VAL
103 ,rqd_perd_enrt_nenrt_val = p_rec.rqd_perd_enrt_nenrt_val
104 ,ordr_num = p_rec.ordr_num
105 ,BNF_PCT_INCRMT_VAL = p_rec.BNF_PCT_INCRMT_VAL
106 ,BNF_PCT_AMT_ALWD_CD = p_rec.BNF_PCT_AMT_ALWD_CD
107 ,BNF_QDRO_RL_APLS_FLAG = p_rec.BNF_QDRO_RL_APLS_FLAG
108 ,DFLT_TO_ASN_PNDG_CTFN_CD = p_rec.DFLT_TO_ASN_PNDG_CTFN_CD
109 ,DFLT_TO_ASN_PNDG_CTFN_RL = p_rec.DFLT_TO_ASN_PNDG_CTFN_RL
110 ,DRVBL_FCTR_APLS_RTS_FLAG = p_rec.DRVBL_FCTR_APLS_RTS_FLAG
111 ,DRVBL_FCTR_PRTN_ELIG_FLAG = p_rec.DRVBL_FCTR_PRTN_ELIG_FLAG
112 ,DPNT_DSGN_CD = p_rec.DPNT_DSGN_CD
113 ,ELIG_APLS_FLAG = p_rec.ELIG_APLS_FLAG
114 ,INVK_DCLN_PRTN_PL_FLAG = p_rec.INVK_DCLN_PRTN_PL_FLAG
115 ,INVK_FLX_CR_PL_FLAG = p_rec.INVK_FLX_CR_PL_FLAG
116 ,IMPTD_INCM_CALC_CD = p_rec.IMPTD_INCM_CALC_CD
117 ,DRVBL_DPNT_ELIG_FLAG = p_rec.DRVBL_DPNT_ELIG_FLAG
118 ,TRK_INELIG_PER_FLAG = p_rec.TRK_INELIG_PER_FLAG
119 ,PL_CD = p_rec.PL_CD
120 ,AUTO_ENRT_MTHD_RL = p_rec.AUTO_ENRT_MTHD_RL
121 ,IVR_IDENT = p_rec.IVR_IDENT
122 ,URL_REF_NAME = p_rec.URL_REF_NAME
123 ,CMPR_CLMS_TO_CVG_OR_BAL_CD = p_rec.CMPR_CLMS_TO_CVG_OR_BAL_CD
124 ,COBRA_PYMT_DUE_DY_NUM = p_rec.COBRA_PYMT_DUE_DY_NUM
125 ,DPNT_CVD_BY_OTHR_APLS_FLAG = p_rec.DPNT_CVD_BY_OTHR_APLS_FLAG
126 ,ENRT_MTHD_CD = p_rec.ENRT_MTHD_CD
127 ,ENRT_CD = p_rec.ENRT_CD
128 ,ENRT_CVG_STRT_DT_CD = p_rec.ENRT_CVG_STRT_DT_CD
129 ,ENRT_CVG_END_DT_CD = p_rec.ENRT_CVG_END_DT_CD
130 ,FRFS_APLY_FLAG = p_rec.FRFS_APLY_FLAG
131 ,HC_PL_SUBJ_HCFA_APRVL_FLAG = p_rec.HC_PL_SUBJ_HCFA_APRVL_FLAG
132 ,HGHLY_CMPD_RL_APLS_FLAG = p_rec.HGHLY_CMPD_RL_APLS_FLAG
133 ,INCPTN_DT = p_rec.INCPTN_DT
134 ,MN_CVG_RL = p_rec.MN_CVG_RL
135 ,MN_CVG_RQD_AMT = p_rec.MN_CVG_RQD_AMT
136 ,MN_OPTS_RQD_NUM = p_rec.MN_OPTS_RQD_NUM
137 ,MX_CVG_ALWD_AMT = p_rec.MX_CVG_ALWD_AMT
138 ,MX_CVG_RL = p_rec.MX_CVG_RL
139 ,MX_OPTS_ALWD_NUM = p_rec.MX_OPTS_ALWD_NUM
140 ,MX_CVG_WCFN_MLT_NUM = p_rec.MX_CVG_WCFN_MLT_NUM
141 ,MX_CVG_WCFN_AMT = p_rec.MX_CVG_WCFN_AMT
142 ,MX_CVG_INCR_ALWD_AMT = p_rec.MX_CVG_INCR_ALWD_AMT
143 ,MX_CVG_INCR_WCF_ALWD_AMT = p_rec.MX_CVG_INCR_WCF_ALWD_AMT
144 ,MX_CVG_MLT_INCR_NUM = p_rec.MX_CVG_MLT_INCR_NUM
145 ,MX_CVG_MLT_INCR_WCF_NUM = p_rec.MX_CVG_MLT_INCR_WCF_NUM
146 ,MX_WTG_DT_TO_USE_CD = p_rec.MX_WTG_DT_TO_USE_CD
147 ,MX_WTG_DT_TO_USE_RL = p_rec.MX_WTG_DT_TO_USE_RL
148 ,MX_WTG_PERD_PRTE_UOM = p_rec.MX_WTG_PERD_PRTE_UOM
149 ,MX_WTG_PERD_PRTE_VAL = p_rec.MX_WTG_PERD_PRTE_VAL
150 ,MX_WTG_PERD_RL = p_rec.MX_WTG_PERD_RL
151 ,NIP_DFLT_ENRT_CD = p_rec.NIP_DFLT_ENRT_CD
152 ,NIP_DFLT_ENRT_DET_RL = p_rec.NIP_DFLT_ENRT_DET_RL
153 ,DPNT_ADRS_RQD_FLAG = p_rec.DPNT_ADRS_RQD_FLAG
154 ,DPNT_CVG_END_DT_CD = p_rec.DPNT_CVG_END_DT_CD
155 ,DPNT_CVG_END_DT_RL = p_rec.DPNT_CVG_END_DT_RL
156 ,DPNT_CVG_STRT_DT_CD = p_rec.DPNT_CVG_STRT_DT_CD
157 ,DPNT_CVG_STRT_DT_RL = p_rec.DPNT_CVG_STRT_DT_RL
158 ,DPNT_DOB_RQD_FLAG = p_rec.DPNT_DOB_RQD_FLAG
159 ,DPNT_LEG_ID_RQD_FLAG = p_rec.DPNT_LEG_ID_RQD_FLAG
160 ,DPNT_NO_CTFN_RQD_FLAG = p_rec.DPNT_NO_CTFN_RQD_FLAG
161 ,NO_MN_CVG_AMT_APLS_FLAG = p_rec.NO_MN_CVG_AMT_APLS_FLAG
162 ,NO_MN_CVG_INCR_APLS_FLAG = p_rec.NO_MN_CVG_INCR_APLS_FLAG
163 ,NO_MN_OPTS_NUM_APLS_FLAG = p_rec.NO_MN_OPTS_NUM_APLS_FLAG
164 ,NO_MX_CVG_AMT_APLS_FLAG = p_rec.NO_MX_CVG_AMT_APLS_FLAG
165 ,NO_MX_CVG_INCR_APLS_FLAG = p_rec.NO_MX_CVG_INCR_APLS_FLAG
166 ,NO_MX_OPTS_NUM_APLS_FLAG = p_rec.NO_MX_OPTS_NUM_APLS_FLAG
167 ,NIP_PL_UOM = p_rec.NIP_PL_UOM
168 ,rqd_perd_enrt_nenrt_uom = p_rec.rqd_perd_enrt_nenrt_uom
169 ,NIP_ACTY_REF_PERD_CD = p_rec.NIP_ACTY_REF_PERD_CD
170 ,NIP_ENRT_INFO_RT_FREQ_CD = p_rec.NIP_ENRT_INFO_RT_FREQ_CD
171 ,PER_CVRD_CD = p_rec.PER_CVRD_CD
172 ,ENRT_CVG_END_DT_RL = p_rec.ENRT_CVG_END_DT_RL
173 ,POSTELCN_EDIT_RL = p_rec.POSTELCN_EDIT_RL
174 ,ENRT_CVG_STRT_DT_RL = p_rec.ENRT_CVG_STRT_DT_RL
175 ,PRORT_PRTL_YR_CVG_RSTRN_CD = p_rec.PRORT_PRTL_YR_CVG_RSTRN_CD
176 ,PRORT_PRTL_YR_CVG_RSTRN_RL = p_rec.PRORT_PRTL_YR_CVG_RSTRN_RL
177 ,PRTN_ELIG_OVRID_ALWD_FLAG = p_rec.PRTN_ELIG_OVRID_ALWD_FLAG
178 ,SVGS_PL_FLAG = p_rec.SVGS_PL_FLAG
179 ,SUBJ_TO_IMPTD_INCM_TYP_CD = p_rec.SUBJ_TO_IMPTD_INCM_TYP_CD
180 ,USE_ALL_ASNTS_ELIG_FLAG = p_rec.USE_ALL_ASNTS_ELIG_FLAG
181 ,USE_ALL_ASNTS_FOR_RT_FLAG = p_rec.USE_ALL_ASNTS_FOR_RT_FLAG
182 ,VSTG_APLS_FLAG = p_rec.VSTG_APLS_FLAG
183 ,WVBL_FLAG = p_rec.WVBL_FLAG
184 ,HC_SVC_TYP_CD = p_rec.HC_SVC_TYP_CD
185 ,PL_STAT_CD = p_rec.PL_STAT_CD
186 ,PRMRY_FNDG_MTHD_CD = p_rec.PRMRY_FNDG_MTHD_CD
187 ,RT_END_DT_CD = p_rec.RT_END_DT_CD
188 ,RT_END_DT_RL = p_rec.RT_END_DT_RL
189 ,RT_STRT_DT_RL = p_rec.RT_STRT_DT_RL
190 ,RT_STRT_DT_CD = p_rec.RT_STRT_DT_CD
191 ,BNF_DSGN_CD = p_rec.BNF_DSGN_CD
192 ,PL_TYP_ID = p_rec.PL_TYP_ID
193 ,BUSINESS_GROUP_ID = p_rec.BUSINESS_GROUP_ID
194 ,ENRT_PL_OPT_FLAG = p_rec.ENRT_PL_OPT_FLAG
195 ,BNFT_PRVDR_POOL_ID = p_rec.BNFT_PRVDR_POOL_ID
196 ,MAY_ENRL_PL_N_OIPL_FLAG = p_rec.MAY_ENRL_PL_N_OIPL_FLAG
197 ,ENRT_RL = p_rec.ENRT_RL
198 ,rqd_perd_enrt_nenrt_rl = p_rec.rqd_perd_enrt_nENRT_RL
199 ,ALWS_UNRSTRCTD_ENRT_FLAG = p_rec.ALWS_UNRSTRCTD_ENRT_FLAG
200 ,BNFT_OR_OPTION_RSTRCTN_CD = p_rec.BNFT_OR_OPTION_RSTRCTN_CD
201 ,CVG_INCR_R_DECR_ONLY_CD = p_rec.CVG_INCR_R_DECR_ONLY_CD
202 ,unsspnd_enrt_cd = p_rec.unsspnd_enrt_cd
203 ,PLN_ATTRIBUTE_CATEGORY = p_rec.PLN_ATTRIBUTE_CATEGORY
204 ,PLN_ATTRIBUTE1 = p_rec.PLN_ATTRIBUTE1
205 ,PLN_ATTRIBUTE2 = p_rec.PLN_ATTRIBUTE2
206 ,PLN_ATTRIBUTE3 = p_rec.PLN_ATTRIBUTE3
207 ,PLN_ATTRIBUTE4 = p_rec.PLN_ATTRIBUTE4
208 ,PLN_ATTRIBUTE5 = p_rec.PLN_ATTRIBUTE5
209 ,PLN_ATTRIBUTE6 = p_rec.PLN_ATTRIBUTE6
210 ,PLN_ATTRIBUTE7 = p_rec.PLN_ATTRIBUTE7
211 ,PLN_ATTRIBUTE8 = p_rec.PLN_ATTRIBUTE8
212 ,PLN_ATTRIBUTE9 = p_rec.PLN_ATTRIBUTE9
213 ,PLN_ATTRIBUTE10 = p_rec.PLN_ATTRIBUTE10
214 ,PLN_ATTRIBUTE11 = p_rec.PLN_ATTRIBUTE11
215 ,PLN_ATTRIBUTE12 = p_rec.PLN_ATTRIBUTE12
216 ,PLN_ATTRIBUTE13 = p_rec.PLN_ATTRIBUTE13
217 ,PLN_ATTRIBUTE14 = p_rec.PLN_ATTRIBUTE14
218 ,PLN_ATTRIBUTE15 = p_rec.PLN_ATTRIBUTE15
219 ,PLN_ATTRIBUTE16 = p_rec.PLN_ATTRIBUTE16
220 ,PLN_ATTRIBUTE17 = p_rec.PLN_ATTRIBUTE17
221 ,PLN_ATTRIBUTE18 = p_rec.PLN_ATTRIBUTE18
222 ,PLN_ATTRIBUTE19 = p_rec.PLN_ATTRIBUTE19
223 ,PLN_ATTRIBUTE20 = p_rec.PLN_ATTRIBUTE20
224 ,PLN_ATTRIBUTE21 = p_rec.PLN_ATTRIBUTE21
225 ,PLN_ATTRIBUTE22 = p_rec.PLN_ATTRIBUTE22
226 ,PLN_ATTRIBUTE23 = p_rec.PLN_ATTRIBUTE23
227 ,PLN_ATTRIBUTE24 = p_rec.PLN_ATTRIBUTE24
228 ,PLN_ATTRIBUTE25 = p_rec.PLN_ATTRIBUTE25
229 ,PLN_ATTRIBUTE26 = p_rec.PLN_ATTRIBUTE26
230 ,PLN_ATTRIBUTE27 = p_rec.PLN_ATTRIBUTE27
231 ,PLN_ATTRIBUTE28 = p_rec.PLN_ATTRIBUTE28
232 ,PLN_ATTRIBUTE29 = p_rec.PLN_ATTRIBUTE29
233 ,PLN_ATTRIBUTE30 = p_rec.PLN_ATTRIBUTE30
234 ,susp_if_ctfn_not_prvd_flag = p_rec.susp_if_ctfn_not_prvd_flag
235 ,ctfn_determine_cd = p_rec.ctfn_determine_cd
236 ,susp_if_dpnt_ssn_nt_prv_cd = p_rec.susp_if_dpnt_ssn_nt_prv_cd
237 ,susp_if_dpnt_dob_nt_prv_cd = p_rec.susp_if_dpnt_dob_nt_prv_cd
238 ,susp_if_dpnt_adr_nt_prv_cd = p_rec.susp_if_dpnt_adr_nt_prv_cd
239 ,susp_if_ctfn_not_dpnt_flag = p_rec.susp_if_ctfn_not_dpnt_flag
240 ,susp_if_bnf_ssn_nt_prv_cd = p_rec.susp_if_bnf_ssn_nt_prv_cd
241 ,susp_if_bnf_dob_nt_prv_cd = p_rec.susp_if_bnf_dob_nt_prv_cd
242 ,susp_if_bnf_adr_nt_prv_cd = p_rec.susp_if_bnf_adr_nt_prv_cd
243 ,susp_if_ctfn_not_bnf_flag = p_rec.susp_if_ctfn_not_bnf_flag
244 ,dpnt_ctfn_determine_cd = p_rec.dpnt_ctfn_determine_cd
245 ,bnf_ctfn_determine_cd = p_rec.bnf_ctfn_determine_cd
246 -- ,LAST_UPDATE_DATE = p_rec.LAST_UPDATE_DATE
247 -- ,LAST_UPDATED_BY = p_rec.LAST_UPDATED_BY
248 -- ,LAST_UPDATE_LOGIN = p_rec.LAST_UPDATE_LOGIN
249 -- ,CREATED_BY = p_rec.CREATED_BY
250 -- ,CREATION_DATE = p_rec.CREATION_DATE
251 ,OBJECT_VERSION_NUMBER = p_rec.OBJECT_VERSION_NUMBER
252 ,ACTL_PREM_ID = p_rec.ACTL_PREM_ID
253 ,VRFY_FMLY_MMBR_CD = p_rec.VRFY_FMLY_MMBR_CD
254 ,VRFY_FMLY_MMBR_RL = p_rec.VRFY_FMLY_MMBR_RL
255 ,ALWS_TMPRY_ID_CRD_FLAG = p_rec.ALWS_TMPRY_ID_CRD_FLAG
256 ,NIP_DFLT_FLAG = p_rec.NIP_DFLT_FLAG
257 ,frfs_distr_mthd_cd = p_rec.frfs_distr_mthd_cd
258 ,frfs_distr_mthd_rl = p_rec.frfs_distr_mthd_rl
259 ,frfs_cntr_det_cd = p_rec.frfs_cntr_det_cd
260 ,frfs_distr_det_cd = p_rec.frfs_distr_det_cd
261 ,cost_alloc_keyflex_1_id = p_rec.cost_alloc_keyflex_1_id
262 ,cost_alloc_keyflex_2_id = p_rec.cost_alloc_keyflex_2_id
263 ,post_to_gl_flag = p_rec.post_to_gl_flag
264 ,frfs_val_det_cd = p_rec.frfs_val_det_cd
265 ,frfs_mx_cryfwd_val = p_rec.frfs_mx_cryfwd_val
266 ,frfs_portion_det_cd = p_rec.frfs_portion_det_cd
267 ,bndry_perd_cd = p_rec.bndry_perd_cd
268 ,short_name = p_rec.short_name
269 ,short_code = p_rec.short_code
270 ,legislation_code = p_rec.legislation_code
271 ,legislation_subgroup = p_rec.legislation_subgroup
272 ,group_pl_id = p_rec.group_pl_id
273 ,mapping_table_name = p_rec.mapping_table_name
274 ,mapping_table_pk_id = p_rec.mapping_table_pk_id
275 ,function_code = p_rec.function_code
276 ,pl_yr_not_applcbl_flag = p_rec.pl_yr_not_applcbl_flag
277 ,use_csd_rsd_prccng_cd = p_rec.use_csd_rsd_prccng_cd
278 where pl_id = p_rec.pl_id
279 and effective_start_date = p_validation_start_date
280 and effective_end_date = p_validation_end_date;
281 --
282 ben_pln_shd.g_api_dml := false; -- Unset the api dml status
283 --
284 -- Set the effective start and end dates
285 --
286 p_rec.effective_start_date := p_validation_start_date;
287 p_rec.effective_end_date := p_validation_end_date;
288 End If;
289 --
290 hr_utility.set_location(' Leaving:'||l_proc, 15);
291 Exception
292 When hr_api.check_integrity_violated Then
293 -- A check constraint has been violated
294 ben_pln_shd.g_api_dml := false; -- Unset the api dml status
295 ben_pln_shd.constraint_error
296 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
297 When hr_api.unique_integrity_violated Then
298 -- Unique integrity has been violated
299 ben_pln_shd.g_api_dml := false; -- Unset the api dml status
300 ben_pln_shd.constraint_error
301 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
302 When Others Then
303 ben_pln_shd.g_api_dml := false; -- Unset the api dml status
304 Raise;
305 End dt_update_dml;
306 --
307 -- ----------------------------------------------------------------------------
308 -- |------------------------------< update_dml >------------------------------|
309 -- ----------------------------------------------------------------------------
310 -- {Start Of Comments}
311 --
312 -- Description:
313 -- This procedure calls the dt_update_dml control logic which handles
314 -- the actual datetrack dml.
315 --
316 -- Prerequisites:
317 -- This is an internal private procedure which must be called from the upd
318 -- procedure.
319 --
320 -- In Parameters:
321 -- A Pl/Sql record structre.
322 --
323 -- Post Success:
324 -- Processing contines.
325 --
326 -- Post Failure:
327 -- No specific error handling is required within this procedure.
328 --
329 -- Developer Implementation Notes:
330 -- The update 'set' arguments list should be modified if any of your
331 -- attributes are not updateable.
332 --
333 -- Access Status:
334 -- Internal Row Handler Use Only.
335 --
336 -- {End Of Comments}
337 -- ----------------------------------------------------------------------------
338 Procedure update_dml
339 (p_rec in out nocopy ben_pln_shd.g_rec_type,
340 p_effective_date in date,
341 p_datetrack_mode in varchar2,
342 p_validation_start_date in date,
343 p_validation_end_date in date) is
344 --
345 l_proc varchar2(72) := g_package||'update_dml';
346 --
347 Begin
348 hr_utility.set_location('Entering:'||l_proc, 5);
349 --
350 dt_update_dml(p_rec => p_rec,
351 p_effective_date => p_effective_date,
352 p_datetrack_mode => p_datetrack_mode,
353 p_validation_start_date => p_validation_start_date,
354 p_validation_end_date => p_validation_end_date);
355 --
356 hr_utility.set_location(' Leaving:'||l_proc, 10);
357 End update_dml;
358 --
359 -- ----------------------------------------------------------------------------
360 -- |----------------------------< dt_pre_update >-----------------------------|
361 -- ----------------------------------------------------------------------------
362 -- {Start Of Comments}
363 --
364 -- Description:
365 -- The dt_pre_update procedure controls the execution
366 -- of dml for the datetrack modes of: UPDATE, UPDATE_OVERRIDE
367 -- and UPDATE_CHANGE_INSERT only. The execution required is as
368 -- follows:
369 --
370 -- 1) Providing the datetrack update mode is not 'CORRECTION'
371 -- then set the effective end date of the current row (this
372 -- will be the validation_start_date - 1).
373 -- 2) If the datetrack mode is 'UPDATE_OVERRIDE' then call the
374 -- corresponding delete_dml process to delete any future rows
375 -- where the effective_start_date is greater than or equal to
376 -- the validation_start_date.
377 -- 3) Call the insert_dml process to insert the new updated row
378 -- details..
379 --
380 -- Prerequisites:
381 -- This is an internal procedure which is called from the
382 -- pre_update procedure.
383 --
384 -- In Parameters:
385 --
386 -- Post Success:
387 -- Processing continues.
388 --
389 -- Post Failure:
390 -- If an error has occurred, an error message and exception will be raised
391 -- but not handled.
392 --
393 -- Developer Implementation Notes:
394 -- This is an internal procedure which is required by Datetrack. Don't
395 -- remove or modify.
396 --
397 -- Access Status:
398 -- Internal Row Handler Use Only.
399 --
400 -- {End Of Comments}
401 -- ----------------------------------------------------------------------------
402 Procedure dt_pre_update
403 (p_rec in out nocopy ben_pln_shd.g_rec_type,
404 p_effective_date in date,
405 p_datetrack_mode in varchar2,
406 p_validation_start_date in date,
407 p_validation_end_date in date) is
408 --
409 l_proc varchar2(72) := g_package||'dt_pre_update';
410 l_dummy_version_number number;
411 --
412 Begin
413 hr_utility.set_location('Entering:'||l_proc, 5);
414 If (p_datetrack_mode <> 'CORRECTION') then
415 hr_utility.set_location(l_proc, 10);
416 --
417 -- Update the current effective end date
418 --
419 ben_pln_shd.upd_effective_end_date
420 (p_effective_date => p_effective_date,
421 p_base_key_value => p_rec.pl_id,
422 p_new_effective_end_date => (p_validation_start_date - 1),
423 p_validation_start_date => p_validation_start_date,
424 p_validation_end_date => p_validation_end_date,
425 p_object_version_number => l_dummy_version_number);
426 --
427 If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
428 hr_utility.set_location(l_proc, 15);
429 --
430 -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
431 -- delete any future rows
432 --
433 ben_pln_del.delete_dml
434 (p_rec => p_rec,
435 p_effective_date => p_effective_date,
436 p_datetrack_mode => p_datetrack_mode,
437 p_validation_start_date => p_validation_start_date,
438 p_validation_end_date => p_validation_end_date);
439 End If;
440 hr_utility.set_location(l_proc, 20);
441 --
442 -- We must now insert the updated row
443 --
444 ben_pln_ins.insert_dml
445 (p_rec => p_rec,
446 p_effective_date => p_effective_date,
447 p_datetrack_mode => p_datetrack_mode,
448 p_validation_start_date => p_validation_start_date,
449 p_validation_end_date => p_validation_end_date);
450 End If;
451 hr_utility.set_location(' Leaving:'||l_proc, 20);
452 End dt_pre_update;
453 --
454 -- ----------------------------------------------------------------------------
455 -- |------------------------------< pre_update >------------------------------|
456 -- ----------------------------------------------------------------------------
457 -- {Start Of Comments}
458 --
459 -- Description:
460 -- This private procedure contains any processing which is required before
461 -- the update dml.
462 --
463 -- Prerequisites:
464 -- This is an internal procedure which is called from the upd procedure.
465 --
466 -- In Parameters:
467 -- A Pl/Sql record structre.
468 --
469 -- Post Success:
470 -- Processing continues.
471 --
472 -- Post Failure:
473 -- If an error has occurred, an error message and exception will be raised
474 -- but not handled.
475 --
476 -- Developer Implementation Notes:
477 -- Any pre-processing required before the update dml is issued should be
478 -- coded within this procedure. It is important to note that any 3rd party
479 -- maintenance should be reviewed before placing in this procedure. The call
480 -- to the dt_update_dml procedure should NOT be removed.
481 --
482 -- Access Status:
483 -- Internal Row Handler Use Only.
484 --
485 -- {End Of Comments}
486 -- ----------------------------------------------------------------------------
487 Procedure pre_update
488 (p_rec in out nocopy ben_pln_shd.g_rec_type,
489 p_effective_date in date,
490 p_datetrack_mode in varchar2,
491 p_validation_start_date in date,
492 p_validation_end_date in date) is
493 --
494 l_proc varchar2(72) := g_package||'pre_update';
495 --
496 Begin
497 hr_utility.set_location('Entering:'||l_proc, 5);
498 --
499 --
500 --
501 dt_pre_update
502 (p_rec => p_rec,
503 p_effective_date => p_effective_date,
504 p_datetrack_mode => p_datetrack_mode,
505 p_validation_start_date => p_validation_start_date,
506 p_validation_end_date => p_validation_end_date);
507 --
508 --Bug : 3460429
509 ben_pln_bus.chk_pl_group_id(p_pl_id => p_rec.pl_id,
510 p_group_pl_id => p_rec.group_pl_id,
511 p_pl_typ_id => p_rec.pl_typ_id,
512 p_effective_date => p_effective_date,
513 p_name => p_rec.name
514 ) ;
515 --Bug : 3460429
516
517 hr_utility.set_location(' Leaving:'||l_proc, 10);
518 End pre_update;
519 --
520 -- ----------------------------------------------------------------------------
521 -- |-----------------------------< post_update >------------------------------|
522 -- ----------------------------------------------------------------------------
523 -- {Start Of Comments}
524 --
525 -- Description:
526 -- This private procedure contains any processing which is required after the
527 -- update dml.
528 --
529 -- Prerequisites:
530 -- This is an internal procedure which is called from the upd procedure.
531 --
532 -- In Parameters:
533 -- A Pl/Sql record structre.
534 --
535 -- Post Success:
536 -- Processing continues.
537 --
538 -- Post Failure:
539 -- If an error has occurred, an error message and exception will be raised
540 -- but not handled.
541 --
542 -- Developer Implementation Notes:
543 -- Any post-processing required after the update dml is issued should be
544 -- coded within this procedure. It is important to note that any 3rd party
545 -- maintenance should be reviewed before placing in this procedure.
546 --
547 -- Access Status:
548 -- Internal Row Handler Use Only.
549 --
550 -- {End Of Comments}
551 -- ----------------------------------------------------------------------------
552 Procedure post_update
553 (p_rec in ben_pln_shd.g_rec_type,
554 p_effective_date in date,
555 p_datetrack_mode in varchar2,
556 p_validation_start_date in date,
557 p_validation_end_date in date) is
558 --
559 l_proc varchar2(72) := g_package||'post_update';
560 --
561 Begin
562 hr_utility.set_location('Entering:'||l_proc, 5);
563 --
564 --
565 -- Start of API User Hook for post_update.
566 -- Added for GSP validations
567 pqh_gsp_ben_validations.pl_validations
568 ( p_pl_id => p_rec.pl_id
569 , p_effective_date => p_effective_date
570 , p_business_group_id => p_rec.business_group_id
571 , p_dml_operation => 'U'
572 , p_pl_Typ_Id => p_rec.pl_Typ_Id
573 , p_Mapping_Table_PK_ID => p_rec.Mapping_Table_PK_ID
574 , p_pl_stat_cd => p_rec.pl_stat_cd
575 );
576
577 --
578
579 begin
580 --
581 --
582 ben_pln_rku.after_update
583 (
584 p_pl_id => p_rec.pl_id
585 ,p_effective_start_date => p_rec.effective_start_date
586 ,p_effective_end_date => p_rec.effective_end_date
587 ,p_name => p_rec.name
588 ,p_alws_qdro_flag => p_rec.alws_qdro_flag
589 ,p_alws_qmcso_flag => p_rec.alws_qmcso_flag
590 ,p_alws_reimbmts_flag => p_rec.alws_reimbmts_flag
591 ,p_bnf_addl_instn_txt_alwd_flag => p_rec.bnf_addl_instn_txt_alwd_flag
592 ,p_bnf_adrs_rqd_flag => p_rec.bnf_adrs_rqd_flag
593 ,p_bnf_cntngt_bnfs_alwd_flag => p_rec.bnf_cntngt_bnfs_alwd_flag
594 ,p_bnf_ctfn_rqd_flag => p_rec.bnf_ctfn_rqd_flag
595 ,p_bnf_dob_rqd_flag => p_rec.bnf_dob_rqd_flag
596 ,p_bnf_dsge_mnr_ttee_rqd_flag => p_rec.bnf_dsge_mnr_ttee_rqd_flag
597 ,p_bnf_incrmt_amt => p_rec.bnf_incrmt_amt
598 ,p_bnf_dflt_bnf_cd => p_rec.bnf_dflt_bnf_cd
599 ,p_bnf_legv_id_rqd_flag => p_rec.bnf_legv_id_rqd_flag
600 ,p_bnf_may_dsgt_org_flag => p_rec.bnf_may_dsgt_org_flag
601 ,p_bnf_mn_dsgntbl_amt => p_rec.bnf_mn_dsgntbl_amt
602 ,p_bnf_mn_dsgntbl_pct_val => p_rec.bnf_mn_dsgntbl_pct_val
603 ,p_rqd_perd_enrt_nenrt_val => p_rec.rqd_perd_enrt_nenrt_val
604 ,p_ordr_num => p_rec.ordr_num
605 ,p_bnf_pct_incrmt_val => p_rec.bnf_pct_incrmt_val
606 ,p_bnf_pct_amt_alwd_cd => p_rec.bnf_pct_amt_alwd_cd
607 ,p_bnf_qdro_rl_apls_flag => p_rec.bnf_qdro_rl_apls_flag
608 ,p_dflt_to_asn_pndg_ctfn_cd => p_rec.dflt_to_asn_pndg_ctfn_cd
609 ,p_dflt_to_asn_pndg_ctfn_rl => p_rec.dflt_to_asn_pndg_ctfn_rl
610 ,p_drvbl_fctr_apls_rts_flag => p_rec.drvbl_fctr_apls_rts_flag
611 ,p_drvbl_fctr_prtn_elig_flag => p_rec.drvbl_fctr_prtn_elig_flag
612 ,p_dpnt_dsgn_cd => p_rec.dpnt_dsgn_cd
613 ,p_elig_apls_flag => p_rec.elig_apls_flag
614 ,p_invk_dcln_prtn_pl_flag => p_rec.invk_dcln_prtn_pl_flag
615 ,p_invk_flx_cr_pl_flag => p_rec.invk_flx_cr_pl_flag
616 ,p_imptd_incm_calc_cd => p_rec.imptd_incm_calc_cd
617 ,p_drvbl_dpnt_elig_flag => p_rec.drvbl_dpnt_elig_flag
618 ,p_trk_inelig_per_flag => p_rec.trk_inelig_per_flag
619 ,p_pl_cd => p_rec.pl_cd
620 ,p_auto_enrt_mthd_rl => p_rec.auto_enrt_mthd_rl
621 ,p_ivr_ident => p_rec.ivr_ident
622 ,p_url_ref_name => p_rec.url_ref_name
623 ,p_cmpr_clms_to_cvg_or_bal_cd => p_rec.cmpr_clms_to_cvg_or_bal_cd
624 ,p_cobra_pymt_due_dy_num => p_rec.cobra_pymt_due_dy_num
625 ,p_dpnt_cvd_by_othr_apls_flag => p_rec.dpnt_cvd_by_othr_apls_flag
626 ,p_enrt_mthd_cd => p_rec.enrt_mthd_cd
627 ,p_enrt_cd => p_rec.enrt_cd
628 ,p_enrt_cvg_strt_dt_cd => p_rec.enrt_cvg_strt_dt_cd
629 ,p_enrt_cvg_end_dt_cd => p_rec.enrt_cvg_end_dt_cd
630 ,p_frfs_aply_flag => p_rec.frfs_aply_flag
631 ,p_hc_pl_subj_hcfa_aprvl_flag => p_rec.hc_pl_subj_hcfa_aprvl_flag
632 ,p_hghly_cmpd_rl_apls_flag => p_rec.hghly_cmpd_rl_apls_flag
633 ,p_incptn_dt => p_rec.incptn_dt
634 ,p_mn_cvg_rl => p_rec.mn_cvg_rl
635 ,p_mn_cvg_rqd_amt => p_rec.mn_cvg_rqd_amt
636 ,p_mn_opts_rqd_num => p_rec.mn_opts_rqd_num
637 ,p_mx_cvg_alwd_amt => p_rec.mx_cvg_alwd_amt
638 ,p_mx_cvg_rl => p_rec.mx_cvg_rl
639 ,p_mx_opts_alwd_num => p_rec.mx_opts_alwd_num
640 ,p_mx_cvg_wcfn_mlt_num => p_rec.mx_cvg_wcfn_mlt_num
641 ,p_mx_cvg_wcfn_amt => p_rec.mx_cvg_wcfn_amt
642 ,p_mx_cvg_incr_alwd_amt => p_rec.mx_cvg_incr_alwd_amt
643 ,p_mx_cvg_incr_wcf_alwd_amt => p_rec.mx_cvg_incr_wcf_alwd_amt
644 ,p_mx_cvg_mlt_incr_num => p_rec.mx_cvg_mlt_incr_num
645 ,p_mx_cvg_mlt_incr_wcf_num => p_rec.mx_cvg_mlt_incr_wcf_num
646 ,p_mx_wtg_dt_to_use_cd => p_rec.mx_wtg_dt_to_use_cd
647 ,p_mx_wtg_dt_to_use_rl => p_rec.mx_wtg_dt_to_use_rl
648 ,p_mx_wtg_perd_prte_uom => p_rec.mx_wtg_perd_prte_uom
649 ,p_mx_wtg_perd_prte_val => p_rec.mx_wtg_perd_prte_val
650 ,p_mx_wtg_perd_rl => p_rec.mx_wtg_perd_rl
651 ,p_nip_dflt_enrt_cd => p_rec.nip_dflt_enrt_cd
652 ,p_nip_dflt_enrt_det_rl => p_rec.nip_dflt_enrt_det_rl
653 ,p_dpnt_adrs_rqd_flag => p_rec.dpnt_adrs_rqd_flag
654 ,p_dpnt_cvg_end_dt_cd => p_rec.dpnt_cvg_end_dt_cd
655 ,p_dpnt_cvg_end_dt_rl => p_rec.dpnt_cvg_end_dt_rl
656 ,p_dpnt_cvg_strt_dt_cd => p_rec.dpnt_cvg_strt_dt_cd
657 ,p_dpnt_cvg_strt_dt_rl => p_rec.dpnt_cvg_strt_dt_rl
658 ,p_dpnt_dob_rqd_flag => p_rec.dpnt_dob_rqd_flag
659 ,p_dpnt_leg_id_rqd_flag => p_rec.dpnt_leg_id_rqd_flag
660 ,p_dpnt_no_ctfn_rqd_flag => p_rec.dpnt_no_ctfn_rqd_flag
661 ,p_no_mn_cvg_amt_apls_flag => p_rec.no_mn_cvg_amt_apls_flag
662 ,p_no_mn_cvg_incr_apls_flag => p_rec.no_mn_cvg_incr_apls_flag
663 ,p_no_mn_opts_num_apls_flag => p_rec.no_mn_opts_num_apls_flag
664 ,p_no_mx_cvg_amt_apls_flag => p_rec.no_mx_cvg_amt_apls_flag
665 ,p_no_mx_cvg_incr_apls_flag => p_rec.no_mx_cvg_incr_apls_flag
666 ,p_no_mx_opts_num_apls_flag => p_rec.no_mx_opts_num_apls_flag
667 ,p_nip_pl_uom => p_rec.nip_pl_uom
668 ,p_rqd_perd_enrt_nenrt_uom => p_rec.rqd_perd_enrt_nenrt_uom
669 ,p_nip_acty_ref_perd_cd => p_rec.nip_acty_ref_perd_cd
670 ,p_nip_enrt_info_rt_freq_cd => p_rec.nip_enrt_info_rt_freq_cd
671 ,p_per_cvrd_cd => p_rec.per_cvrd_cd
672 ,p_enrt_cvg_end_dt_rl => p_rec.enrt_cvg_end_dt_rl
673 ,p_postelcn_edit_rl => p_rec.postelcn_edit_rl
674 ,p_enrt_cvg_strt_dt_rl => p_rec.enrt_cvg_strt_dt_rl
675 ,p_prort_prtl_yr_cvg_rstrn_cd => p_rec.prort_prtl_yr_cvg_rstrn_cd
676 ,p_prort_prtl_yr_cvg_rstrn_rl => p_rec.prort_prtl_yr_cvg_rstrn_rl
677 ,p_prtn_elig_ovrid_alwd_flag => p_rec.prtn_elig_ovrid_alwd_flag
678 ,p_svgs_pl_flag => p_rec.svgs_pl_flag
679 ,p_subj_to_imptd_incm_typ_cd => p_rec.subj_to_imptd_incm_typ_cd
680 ,p_use_all_asnts_elig_flag => p_rec.use_all_asnts_elig_flag
681 ,p_use_all_asnts_for_rt_flag => p_rec.use_all_asnts_for_rt_flag
682 ,p_vstg_apls_flag => p_rec.vstg_apls_flag
683 ,p_wvbl_flag => p_rec.wvbl_flag
684 ,p_hc_svc_typ_cd => p_rec.hc_svc_typ_cd
685 ,p_pl_stat_cd => p_rec.pl_stat_cd
686 ,p_prmry_fndg_mthd_cd => p_rec.prmry_fndg_mthd_cd
687 ,p_rt_end_dt_cd => p_rec.rt_end_dt_cd
688 ,p_rt_end_dt_rl => p_rec.rt_end_dt_rl
689 ,p_rt_strt_dt_rl => p_rec.rt_strt_dt_rl
690 ,p_rt_strt_dt_cd => p_rec.rt_strt_dt_cd
691 ,p_bnf_dsgn_cd => p_rec.bnf_dsgn_cd
692 ,p_pl_typ_id => p_rec.pl_typ_id
693 ,p_business_group_id => p_rec.business_group_id
694 ,p_enrt_pl_opt_flag => p_rec.enrt_pl_opt_flag
695 ,p_bnft_prvdr_pool_id => p_rec.bnft_prvdr_pool_id
696 ,p_MAY_ENRL_PL_N_OIPL_FLAG => p_rec.MAY_ENRL_PL_N_OIPL_FLAG
697 ,p_enrt_RL => p_rec.enrt_RL
698 ,p_rqd_perd_enrt_nenrt_rl => p_rec.rqd_perd_enrt_nenrt_RL
699 ,p_alws_UNRSTRCTD_ENRT_FLAG => p_rec.alws_UNRSTRCTD_ENRT_FLAG
700 ,p_BNFT_OR_OPTION_RSTRCTN_CD => p_rec.BNFT_OR_OPTION_RSTRCTN_CD
701 ,p_CVG_INCR_R_DECR_ONLY_CD => p_rec.CVG_INCR_R_DECR_ONLY_CD
702 ,p_unsspnd_enrt_cd => p_rec.unsspnd_enrt_cd
703 ,p_pln_attribute_category => p_rec.pln_attribute_category
704 ,p_pln_attribute1 => p_rec.pln_attribute1
705 ,p_pln_attribute2 => p_rec.pln_attribute2
706 ,p_pln_attribute3 => p_rec.pln_attribute3
707 ,p_pln_attribute4 => p_rec.pln_attribute4
708 ,p_pln_attribute5 => p_rec.pln_attribute5
709 ,p_pln_attribute6 => p_rec.pln_attribute6
710 ,p_pln_attribute7 => p_rec.pln_attribute7
711 ,p_pln_attribute8 => p_rec.pln_attribute8
712 ,p_pln_attribute9 => p_rec.pln_attribute9
713 ,p_pln_attribute10 => p_rec.pln_attribute10
714 ,p_pln_attribute11 => p_rec.pln_attribute11
715 ,p_pln_attribute12 => p_rec.pln_attribute12
716 ,p_pln_attribute13 => p_rec.pln_attribute13
717 ,p_pln_attribute14 => p_rec.pln_attribute14
718 ,p_pln_attribute15 => p_rec.pln_attribute15
719 ,p_pln_attribute16 => p_rec.pln_attribute16
720 ,p_pln_attribute17 => p_rec.pln_attribute17
721 ,p_pln_attribute18 => p_rec.pln_attribute18
722 ,p_pln_attribute19 => p_rec.pln_attribute19
723 ,p_pln_attribute20 => p_rec.pln_attribute20
724 ,p_pln_attribute21 => p_rec.pln_attribute21
725 ,p_pln_attribute22 => p_rec.pln_attribute22
726 ,p_pln_attribute23 => p_rec.pln_attribute23
727 ,p_pln_attribute24 => p_rec.pln_attribute24
728 ,p_pln_attribute25 => p_rec.pln_attribute25
729 ,p_pln_attribute26 => p_rec.pln_attribute26
730 ,p_pln_attribute27 => p_rec.pln_attribute27
731 ,p_pln_attribute28 => p_rec.pln_attribute28
732 ,p_pln_attribute29 => p_rec.pln_attribute29
733 ,p_pln_attribute30 => p_rec.pln_attribute30
734 ,p_susp_if_ctfn_not_prvd_flag => p_rec.susp_if_ctfn_not_prvd_flag
735 ,p_ctfn_determine_cd => p_rec.ctfn_determine_cd
736 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_rec.susp_if_dpnt_ssn_nt_prv_cd
737 ,p_susp_if_dpnt_dob_nt_prv_cd => p_rec.susp_if_dpnt_dob_nt_prv_cd
738 ,p_susp_if_dpnt_adr_nt_prv_cd => p_rec.susp_if_dpnt_adr_nt_prv_cd
739 ,p_susp_if_ctfn_not_dpnt_flag => p_rec.susp_if_ctfn_not_dpnt_flag
740 ,p_susp_if_bnf_ssn_nt_prv_cd => p_rec.susp_if_bnf_ssn_nt_prv_cd
741 ,p_susp_if_bnf_dob_nt_prv_cd => p_rec.susp_if_bnf_dob_nt_prv_cd
742 ,p_susp_if_bnf_adr_nt_prv_cd => p_rec.susp_if_bnf_adr_nt_prv_cd
743 ,p_susp_if_ctfn_not_bnf_flag => p_rec.susp_if_ctfn_not_bnf_flag
744 ,p_dpnt_ctfn_determine_cd => p_rec.dpnt_ctfn_determine_cd
745 ,p_bnf_ctfn_determine_cd => p_rec.bnf_ctfn_determine_cd
746 ,p_object_version_number => p_rec.object_version_number
747 ,p_effective_date => p_effective_date
748 ,p_datetrack_mode => p_datetrack_mode
749 ,p_validation_start_date => p_validation_start_date
750 ,p_validation_end_date => p_validation_end_date
751 ,p_alws_TMPRY_ID_CRD_FLAG => p_rec.alws_TMPRY_ID_CRD_FLAG
752 ,p_actl_prem_id => p_rec.actl_prem_id
753 ,p_vrfy_fmly_mmbr_cd => p_rec.vrfy_fmly_mmbr_cd
754 ,p_vrfy_fmly_mmbr_rl => p_rec.vrfy_fmly_mmbr_rl
755 ,p_nip_dflt_flag => p_rec.nip_dflt_flag
756 ,p_frfs_distr_mthd_cd => p_rec.frfs_distr_mthd_cd
757 ,p_frfs_distr_mthd_rl => p_rec.frfs_distr_mthd_rl
758 ,p_frfs_cntr_det_cd => p_rec.frfs_cntr_det_cd
759 ,p_frfs_distr_det_cd => p_rec.frfs_distr_det_cd
760 ,p_cost_alloc_keyflex_1_id => p_rec.cost_alloc_keyflex_1_id
761 ,p_cost_alloc_keyflex_2_id => p_rec.cost_alloc_keyflex_2_id
762 ,p_post_to_gl_flag => p_rec.post_to_gl_flag
763 ,p_frfs_val_det_cd => p_rec.frfs_val_det_cd
764 ,p_frfs_mx_cryfwd_val => p_rec.frfs_mx_cryfwd_val
765 ,p_frfs_portion_det_cd => p_rec.frfs_portion_det_cd
766 ,p_bndry_perd_cd => p_rec.bndry_perd_cd
767 ,p_short_name => p_rec.short_name
768 ,p_short_code => p_rec.short_code
769 ,p_legislation_code => p_rec.legislation_code
770 ,p_legislation_subgroup => p_rec.legislation_subgroup
771 ,p_group_pl_id => p_rec.group_pl_id
772 ,p_mapping_table_name => p_rec.mapping_table_name
773 ,p_mapping_table_pk_id => p_rec.mapping_table_pk_id
774 ,p_function_code => p_rec.function_code
775 ,p_pl_yr_not_applcbl_flag => p_rec.pl_yr_not_applcbl_flag
776 ,p_use_csd_rsd_prccng_cd => p_rec.use_csd_rsd_prccng_cd
777 ,p_effective_start_date_o => ben_pln_shd.g_old_rec.effective_start_date
778 ,p_effective_end_date_o => ben_pln_shd.g_old_rec.effective_end_date
779 ,p_name_o => ben_pln_shd.g_old_rec.name
780 ,p_alws_qdro_flag_o => ben_pln_shd.g_old_rec.alws_qdro_flag
781 ,p_alws_qmcso_flag_o => ben_pln_shd.g_old_rec.alws_qmcso_flag
782 ,p_alws_reimbmts_flag_o => ben_pln_shd.g_old_rec.alws_reimbmts_flag
783 ,p_bnf_addl_instn_txt_alwd_fl_o => ben_pln_shd.g_old_rec.bnf_addl_instn_txt_alwd_flag
784 ,p_bnf_adrs_rqd_flag_o => ben_pln_shd.g_old_rec.bnf_adrs_rqd_flag
785 ,p_bnf_cntngt_bnfs_alwd_flag_o => ben_pln_shd.g_old_rec.bnf_cntngt_bnfs_alwd_flag
786 ,p_bnf_ctfn_rqd_flag_o => ben_pln_shd.g_old_rec.bnf_ctfn_rqd_flag
787 ,p_bnf_dob_rqd_flag_o => ben_pln_shd.g_old_rec.bnf_dob_rqd_flag
788 ,p_bnf_dsge_mnr_ttee_rqd_flag_o => ben_pln_shd.g_old_rec.bnf_dsge_mnr_ttee_rqd_flag
789 ,p_bnf_incrmt_amt_o => ben_pln_shd.g_old_rec.bnf_incrmt_amt
790 ,p_bnf_dflt_bnf_cd_o => ben_pln_shd.g_old_rec.bnf_dflt_bnf_cd
791 ,p_bnf_legv_id_rqd_flag_o => ben_pln_shd.g_old_rec.bnf_legv_id_rqd_flag
792 ,p_bnf_may_dsgt_org_flag_o => ben_pln_shd.g_old_rec.bnf_may_dsgt_org_flag
793 ,p_bnf_mn_dsgntbl_amt_o => ben_pln_shd.g_old_rec.bnf_mn_dsgntbl_amt
794 ,p_bnf_mn_dsgntbl_pct_val_o => ben_pln_shd.g_old_rec.bnf_mn_dsgntbl_pct_val
795 ,p_rqd_perd_enrt_nenrt_val_o => ben_pln_shd.g_old_rec.rqd_perd_enrt_nenrt_val
796 ,p_ordr_num_o => ben_pln_shd.g_old_rec.ordr_num
797 ,p_bnf_pct_incrmt_val_o => ben_pln_shd.g_old_rec.bnf_pct_incrmt_val
798 ,p_bnf_pct_amt_alwd_cd_o => ben_pln_shd.g_old_rec.bnf_pct_amt_alwd_cd
799 ,p_bnf_qdro_rl_apls_flag_o => ben_pln_shd.g_old_rec.bnf_qdro_rl_apls_flag
800 ,p_dflt_to_asn_pndg_ctfn_cd_o => ben_pln_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd
801 ,p_dflt_to_asn_pndg_ctfn_rl_o => ben_pln_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
802 ,p_drvbl_fctr_apls_rts_flag_o => ben_pln_shd.g_old_rec.drvbl_fctr_apls_rts_flag
803 ,p_drvbl_fctr_prtn_elig_flag_o => ben_pln_shd.g_old_rec.drvbl_fctr_prtn_elig_flag
804 ,p_dpnt_dsgn_cd_o => ben_pln_shd.g_old_rec.dpnt_dsgn_cd
805 ,p_elig_apls_flag_o => ben_pln_shd.g_old_rec.elig_apls_flag
806 ,p_invk_dcln_prtn_pl_flag_o => ben_pln_shd.g_old_rec.invk_dcln_prtn_pl_flag
807 ,p_invk_flx_cr_pl_flag_o => ben_pln_shd.g_old_rec.invk_flx_cr_pl_flag
808 ,p_imptd_incm_calc_cd_o => ben_pln_shd.g_old_rec.imptd_incm_calc_cd
809 ,p_drvbl_dpnt_elig_flag_o => ben_pln_shd.g_old_rec.drvbl_dpnt_elig_flag
810 ,p_trk_inelig_per_flag_o => ben_pln_shd.g_old_rec.trk_inelig_per_flag
811 ,p_pl_cd_o => ben_pln_shd.g_old_rec.pl_cd
812 ,p_auto_enrt_mthd_rl_o => ben_pln_shd.g_old_rec.auto_enrt_mthd_rl
813 ,p_ivr_ident_o => ben_pln_shd.g_old_rec.ivr_ident
814 ,p_url_ref_name_o => ben_pln_shd.g_old_rec.url_ref_name
815 ,p_cmpr_clms_to_cvg_or_bal_cd_o => ben_pln_shd.g_old_rec.cmpr_clms_to_cvg_or_bal_cd
816 ,p_cobra_pymt_due_dy_num_o => ben_pln_shd.g_old_rec.cobra_pymt_due_dy_num
817 ,p_dpnt_cvd_by_othr_apls_flag_o => ben_pln_shd.g_old_rec.dpnt_cvd_by_othr_apls_flag
818 ,p_enrt_mthd_cd_o => ben_pln_shd.g_old_rec.enrt_mthd_cd
819 ,p_enrt_cd_o => ben_pln_shd.g_old_rec.enrt_cd
820 ,p_enrt_cvg_strt_dt_cd_o => ben_pln_shd.g_old_rec.enrt_cvg_strt_dt_cd
821 ,p_enrt_cvg_end_dt_cd_o => ben_pln_shd.g_old_rec.enrt_cvg_end_dt_cd
822 ,p_frfs_aply_flag_o => ben_pln_shd.g_old_rec.frfs_aply_flag
823 ,p_hc_pl_subj_hcfa_aprvl_flag_o => ben_pln_shd.g_old_rec.hc_pl_subj_hcfa_aprvl_flag
824 ,p_hghly_cmpd_rl_apls_flag_o => ben_pln_shd.g_old_rec.hghly_cmpd_rl_apls_flag
825 ,p_incptn_dt_o => ben_pln_shd.g_old_rec.incptn_dt
826 ,p_mn_cvg_rl_o => ben_pln_shd.g_old_rec.mn_cvg_rl
827 ,p_mn_cvg_rqd_amt_o => ben_pln_shd.g_old_rec.mn_cvg_rqd_amt
828 ,p_mn_opts_rqd_num_o => ben_pln_shd.g_old_rec.mn_opts_rqd_num
829 ,p_mx_cvg_alwd_amt_o => ben_pln_shd.g_old_rec.mx_cvg_alwd_amt
830 ,p_mx_cvg_rl_o => ben_pln_shd.g_old_rec.mx_cvg_rl
831 ,p_mx_opts_alwd_num_o => ben_pln_shd.g_old_rec.mx_opts_alwd_num
832 ,p_mx_cvg_wcfn_mlt_num_o => ben_pln_shd.g_old_rec.mx_cvg_wcfn_mlt_num
833 ,p_mx_cvg_wcfn_amt_o => ben_pln_shd.g_old_rec.mx_cvg_wcfn_amt
834 ,p_mx_cvg_incr_alwd_amt_o => ben_pln_shd.g_old_rec.mx_cvg_incr_alwd_amt
835 ,p_mx_cvg_incr_wcf_alwd_amt_o => ben_pln_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt
836 ,p_mx_cvg_mlt_incr_num_o => ben_pln_shd.g_old_rec.mx_cvg_mlt_incr_num
837 ,p_mx_cvg_mlt_incr_wcf_num_o => ben_pln_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num
838 ,p_mx_wtg_dt_to_use_cd_o => ben_pln_shd.g_old_rec.mx_wtg_dt_to_use_cd
839 ,p_mx_wtg_dt_to_use_rl_o => ben_pln_shd.g_old_rec.mx_wtg_dt_to_use_rl
840 ,p_mx_wtg_perd_prte_uom_o => ben_pln_shd.g_old_rec.mx_wtg_perd_prte_uom
841 ,p_mx_wtg_perd_prte_val_o => ben_pln_shd.g_old_rec.mx_wtg_perd_prte_val
842 ,p_mx_wtg_perd_rl_o => ben_pln_shd.g_old_rec.mx_wtg_perd_rl
843 ,p_nip_dflt_enrt_cd_o => ben_pln_shd.g_old_rec.nip_dflt_enrt_cd
844 ,p_nip_dflt_enrt_det_rl_o => ben_pln_shd.g_old_rec.nip_dflt_enrt_det_rl
845 ,p_dpnt_adrs_rqd_flag_o => ben_pln_shd.g_old_rec.dpnt_adrs_rqd_flag
846 ,p_dpnt_cvg_end_dt_cd_o => ben_pln_shd.g_old_rec.dpnt_cvg_end_dt_cd
847 ,p_dpnt_cvg_end_dt_rl_o => ben_pln_shd.g_old_rec.dpnt_cvg_end_dt_rl
848 ,p_dpnt_cvg_strt_dt_cd_o => ben_pln_shd.g_old_rec.dpnt_cvg_strt_dt_cd
849 ,p_dpnt_cvg_strt_dt_rl_o => ben_pln_shd.g_old_rec.dpnt_cvg_strt_dt_rl
850 ,p_dpnt_dob_rqd_flag_o => ben_pln_shd.g_old_rec.dpnt_dob_rqd_flag
851 ,p_dpnt_leg_id_rqd_flag_o => ben_pln_shd.g_old_rec.dpnt_leg_id_rqd_flag
852 ,p_dpnt_no_ctfn_rqd_flag_o => ben_pln_shd.g_old_rec.dpnt_no_ctfn_rqd_flag
853 ,p_no_mn_cvg_amt_apls_flag_o => ben_pln_shd.g_old_rec.no_mn_cvg_amt_apls_flag
854 ,p_no_mn_cvg_incr_apls_flag_o => ben_pln_shd.g_old_rec.no_mn_cvg_incr_apls_flag
855 ,p_no_mn_opts_num_apls_flag_o => ben_pln_shd.g_old_rec.no_mn_opts_num_apls_flag
856 ,p_no_mx_cvg_amt_apls_flag_o => ben_pln_shd.g_old_rec.no_mx_cvg_amt_apls_flag
857 ,p_no_mx_cvg_incr_apls_flag_o => ben_pln_shd.g_old_rec.no_mx_cvg_incr_apls_flag
858 ,p_no_mx_opts_num_apls_flag_o => ben_pln_shd.g_old_rec.no_mx_opts_num_apls_flag
859 ,p_nip_pl_uom_o => ben_pln_shd.g_old_rec.nip_pl_uom
860 ,p_rqd_perd_enrt_nenrt_uom_o => ben_pln_shd.g_old_rec.rqd_perd_enrt_nenrt_uom
861 ,p_nip_acty_ref_perd_cd_o => ben_pln_shd.g_old_rec.nip_acty_ref_perd_cd
862 ,p_nip_enrt_info_rt_freq_cd_o => ben_pln_shd.g_old_rec.nip_enrt_info_rt_freq_cd
863 ,p_per_cvrd_cd_o => ben_pln_shd.g_old_rec.per_cvrd_cd
864 ,p_enrt_cvg_end_dt_rl_o => ben_pln_shd.g_old_rec.enrt_cvg_end_dt_rl
865 ,p_postelcn_edit_rl_o => ben_pln_shd.g_old_rec.postelcn_edit_rl
866 ,p_enrt_cvg_strt_dt_rl_o => ben_pln_shd.g_old_rec.enrt_cvg_strt_dt_rl
867 ,p_prort_prtl_yr_cvg_rstrn_cd_o => ben_pln_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_cd
868 ,p_prort_prtl_yr_cvg_rstrn_rl_o => ben_pln_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_rl
869 ,p_prtn_elig_ovrid_alwd_flag_o => ben_pln_shd.g_old_rec.prtn_elig_ovrid_alwd_flag
870 ,p_svgs_pl_flag_o => ben_pln_shd.g_old_rec.svgs_pl_flag
871 ,p_subj_to_imptd_incm_typ_cd_o => ben_pln_shd.g_old_rec.subj_to_imptd_incm_typ_cd
872 ,p_use_all_asnts_elig_flag_o => ben_pln_shd.g_old_rec.use_all_asnts_elig_flag
873 ,p_use_all_asnts_for_rt_flag_o => ben_pln_shd.g_old_rec.use_all_asnts_for_rt_flag
874 ,p_vstg_apls_flag_o => ben_pln_shd.g_old_rec.vstg_apls_flag
875 ,p_wvbl_flag_o => ben_pln_shd.g_old_rec.wvbl_flag
876 ,p_hc_svc_typ_cd_o => ben_pln_shd.g_old_rec.hc_svc_typ_cd
877 ,p_pl_stat_cd_o => ben_pln_shd.g_old_rec.pl_stat_cd
878 ,p_prmry_fndg_mthd_cd_o => ben_pln_shd.g_old_rec.prmry_fndg_mthd_cd
879 ,p_rt_end_dt_cd_o => ben_pln_shd.g_old_rec.rt_end_dt_cd
880 ,p_rt_end_dt_rl_o => ben_pln_shd.g_old_rec.rt_end_dt_rl
881 ,p_rt_strt_dt_rl_o => ben_pln_shd.g_old_rec.rt_strt_dt_rl
882 ,p_rt_strt_dt_cd_o => ben_pln_shd.g_old_rec.rt_strt_dt_cd
883 ,p_bnf_dsgn_cd_o => ben_pln_shd.g_old_rec.bnf_dsgn_cd
884 ,p_pl_typ_id_o => ben_pln_shd.g_old_rec.pl_typ_id
885 ,p_business_group_id_o => ben_pln_shd.g_old_rec.business_group_id
886 ,p_enrt_pl_opt_flag_o => ben_pln_shd.g_old_rec.enrt_pl_opt_flag
887 ,p_bnft_prvdr_pool_id_o => ben_pln_shd.g_old_rec.bnft_prvdr_pool_id
888 ,p_MAY_ENRL_PL_N_OIPL_FLAG_o => ben_pln_shd.g_old_rec.MAY_ENRL_PL_N_OIPL_FLAG
889 ,p_ENRT_RL_o => ben_pln_shd.g_old_rec.enrt_rl
890 ,p_rqd_perd_enrt_nenrt_rl_o => ben_pln_shd.g_old_rec.rqd_perd_enrt_nenrt_rl
891 ,p_ALWS_UNRSTRCTD_ENRT_FLAG_o => ben_pln_shd.g_old_rec.ALWS_UNRSTRCTD_ENRT_FLAG
892 ,p_BNFT_OR_OPTION_RSTRCTN_CD_o => ben_pln_shd.g_old_rec.BNFT_OR_OPTION_RSTRCTN_CD
893 ,p_CVG_INCR_R_DECR_ONLY_CD_o => ben_pln_shd.g_old_rec.CVG_INCR_R_DECR_ONLY_CD
894 ,p_unsspnd_enrt_cd_o => ben_pln_shd.g_old_rec.unsspnd_enrt_cd
895 ,p_pln_attribute_category_o => ben_pln_shd.g_old_rec.pln_attribute_category
896 ,p_pln_attribute1_o => ben_pln_shd.g_old_rec.pln_attribute1
897 ,p_pln_attribute2_o => ben_pln_shd.g_old_rec.pln_attribute2
898 ,p_pln_attribute3_o => ben_pln_shd.g_old_rec.pln_attribute3
899 ,p_pln_attribute4_o => ben_pln_shd.g_old_rec.pln_attribute4
900 ,p_pln_attribute5_o => ben_pln_shd.g_old_rec.pln_attribute5
901 ,p_pln_attribute6_o => ben_pln_shd.g_old_rec.pln_attribute6
902 ,p_pln_attribute7_o => ben_pln_shd.g_old_rec.pln_attribute7
903 ,p_pln_attribute8_o => ben_pln_shd.g_old_rec.pln_attribute8
904 ,p_pln_attribute9_o => ben_pln_shd.g_old_rec.pln_attribute9
905 ,p_pln_attribute10_o => ben_pln_shd.g_old_rec.pln_attribute10
906 ,p_pln_attribute11_o => ben_pln_shd.g_old_rec.pln_attribute11
907 ,p_pln_attribute12_o => ben_pln_shd.g_old_rec.pln_attribute12
908 ,p_pln_attribute13_o => ben_pln_shd.g_old_rec.pln_attribute13
909 ,p_pln_attribute14_o => ben_pln_shd.g_old_rec.pln_attribute14
910 ,p_pln_attribute15_o => ben_pln_shd.g_old_rec.pln_attribute15
911 ,p_pln_attribute16_o => ben_pln_shd.g_old_rec.pln_attribute16
912 ,p_pln_attribute17_o => ben_pln_shd.g_old_rec.pln_attribute17
913 ,p_pln_attribute18_o => ben_pln_shd.g_old_rec.pln_attribute18
914 ,p_pln_attribute19_o => ben_pln_shd.g_old_rec.pln_attribute19
915 ,p_pln_attribute20_o => ben_pln_shd.g_old_rec.pln_attribute20
916 ,p_pln_attribute21_o => ben_pln_shd.g_old_rec.pln_attribute21
917 ,p_pln_attribute22_o => ben_pln_shd.g_old_rec.pln_attribute22
918 ,p_pln_attribute23_o => ben_pln_shd.g_old_rec.pln_attribute23
919 ,p_pln_attribute24_o => ben_pln_shd.g_old_rec.pln_attribute24
920 ,p_pln_attribute25_o => ben_pln_shd.g_old_rec.pln_attribute25
921 ,p_pln_attribute26_o => ben_pln_shd.g_old_rec.pln_attribute26
922 ,p_pln_attribute27_o => ben_pln_shd.g_old_rec.pln_attribute27
923 ,p_pln_attribute28_o => ben_pln_shd.g_old_rec.pln_attribute28
924 ,p_pln_attribute29_o => ben_pln_shd.g_old_rec.pln_attribute29
925 ,p_pln_attribute30_o => ben_pln_shd.g_old_rec.pln_attribute30
926 ,p_susp_if_ctfn_not_prvd_flag_o => ben_pln_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
927 ,p_ctfn_determine_cd_o => ben_pln_shd.g_old_rec.ctfn_determine_cd
928 ,p_susp_if_dpnt_ssn_nt_prv_cd_o => ben_pln_shd.g_old_rec.susp_if_dpnt_ssn_nt_prv_cd
929 ,p_susp_if_dpnt_dob_nt_prv_cd_o => ben_pln_shd.g_old_rec.susp_if_dpnt_dob_nt_prv_cd
930 ,p_susp_if_dpnt_adr_nt_prv_cd_o => ben_pln_shd.g_old_rec.susp_if_dpnt_adr_nt_prv_cd
931 ,p_susp_if_ctfn_not_dpnt_flag_o => ben_pln_shd.g_old_rec.susp_if_ctfn_not_dpnt_flag
932 ,p_susp_if_bnf_ssn_nt_prv_cd_o => ben_pln_shd.g_old_rec.susp_if_bnf_ssn_nt_prv_cd
933 ,p_susp_if_bnf_dob_nt_prv_cd_o => ben_pln_shd.g_old_rec.susp_if_bnf_dob_nt_prv_cd
934 ,p_susp_if_bnf_adr_nt_prv_cd_o => ben_pln_shd.g_old_rec.susp_if_bnf_adr_nt_prv_cd
935 ,p_susp_if_ctfn_not_bnf_flag_o => ben_pln_shd.g_old_rec.susp_if_ctfn_not_bnf_flag
936 ,p_dpnt_ctfn_determine_cd_o => ben_pln_shd.g_old_rec.dpnt_ctfn_determine_cd
937 ,p_bnf_ctfn_determine_cd_o => ben_pln_shd.g_old_rec.bnf_ctfn_determine_cd
938 ,p_object_version_number_o => ben_pln_shd.g_old_rec.object_version_number
939 ,p_actl_prem_id_o => ben_pln_shd.g_old_rec.actl_prem_id
940 ,p_vrfy_fmly_mmbr_cd_o => ben_pln_shd.g_old_rec.vrfy_fmly_mmbr_cd
941 ,p_vrfy_fmly_mmbr_rl_o => ben_pln_shd.g_old_rec.vrfy_fmly_mmbr_rl
942 ,p_alws_tmpry_id_crd_flag_o => ben_pln_shd.g_old_rec.alws_tmpry_id_crd_flag
943 ,p_nip_dflt_flag_o => ben_pln_shd.g_old_rec.nip_dflt_flag
944 ,p_frfs_distr_mthd_cd_o => ben_pln_shd.g_old_rec.frfs_distr_mthd_cd
945 ,p_frfs_distr_mthd_rl_o => ben_pln_shd.g_old_rec.frfs_distr_mthd_rl
946 ,p_frfs_cntr_det_cd_o => ben_pln_shd.g_old_rec.frfs_cntr_det_cd
947 ,p_frfs_distr_det_cd_o => ben_pln_shd.g_old_rec.frfs_distr_det_cd
948 ,p_cost_alloc_keyflex_1_id_o => ben_pln_shd.g_old_rec.cost_alloc_keyflex_1_id
949 ,p_cost_alloc_keyflex_2_id_o => ben_pln_shd.g_old_rec.cost_alloc_keyflex_2_id
950 ,p_post_to_gl_flag_o => ben_pln_shd.g_old_rec.post_to_gl_flag
951 ,p_frfs_val_det_cd_o => ben_pln_shd.g_old_rec.frfs_val_det_cd
952 ,p_frfs_mx_cryfwd_val_o => ben_pln_shd.g_old_rec.frfs_mx_cryfwd_val
953 ,p_frfs_portion_det_cd_o => ben_pln_shd.g_old_rec.frfs_portion_det_cd
954 ,p_bndry_perd_cd_o => ben_pln_shd.g_old_rec.bndry_perd_cd
955 ,p_short_name_o => ben_pln_shd.g_old_rec.short_name
956 ,p_short_code_o => ben_pln_shd.g_old_rec.short_code
957 ,p_legislation_code_o => ben_pln_shd.g_old_rec.legislation_code
958 ,p_legislation_subgroup_o => ben_pln_shd.g_old_rec.legislation_subgroup
959 ,p_group_pl_id_o => ben_pln_shd.g_old_rec.group_pl_id
960 ,p_mapping_table_name_o => ben_pln_shd.g_old_rec.mapping_table_name
961 ,p_mapping_table_pk_id_o => ben_pln_shd.g_old_rec.mapping_table_pk_id
962 ,p_function_code_o => ben_pln_shd.g_old_rec.function_code
963 ,p_pl_yr_not_applcbl_flag_o => ben_pln_shd.g_old_rec.pl_yr_not_applcbl_flag
964 ,p_use_csd_rsd_prccng_cd_o => ben_pln_shd.g_old_rec.use_csd_rsd_prccng_cd
965 );
966 --
967 exception
968 --
969 when hr_api.cannot_find_prog_unit then
970 --
971 hr_api.cannot_find_prog_unit_error
972 (p_module_name => 'ben_pl_f'
973 ,p_hook_type => 'AU');
974 --
975 end;
976 --
977 -- End of API User Hook for post_update.
978 --
979 hr_utility.set_location(' Leaving:'||l_proc, 10);
980 End post_update;
981 --
982 --
983 -- ----------------------------------------------------------------------------
984 -- |---------------------------------< upd >----------------------------------|
985 -- ----------------------------------------------------------------------------
986 Procedure upd
987 (
988 p_rec in out nocopy ben_pln_shd.g_rec_type,
989 p_effective_date in date,
990 p_datetrack_mode in varchar2
991 ) is
992 --
993 l_proc varchar2(72) := g_package||'upd';
994 l_validation_start_date date;
995 l_validation_end_date date;
996 --
997 Begin
998 hr_utility.set_location('Entering:'||l_proc, 5);
999 --
1000 -- Ensure that the DateTrack update mode is valid
1001 --
1002 dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1003 --
1004 -- We must lock the row which we need to update.
1005 --
1006 ben_pln_shd.lck
1007 (p_effective_date => p_effective_date,
1008 p_datetrack_mode => p_datetrack_mode,
1009 p_pl_id => p_rec.pl_id,
1010 p_object_version_number => p_rec.object_version_number,
1011 p_validation_start_date => l_validation_start_date,
1012 p_validation_end_date => l_validation_end_date);
1013 --
1014 -- 1. During an update system defaults are used to determine if
1015 -- arguments have been defaulted or not. We must therefore
1016 -- derive the full record structure values to be updated.
1017 --
1018 -- 2. Call the supporting update validate operations.
1019 --
1020 ben_pln_upd2.convert_defs(p_rec);
1021 hr_utility.set_location('xxxxx l_validation_start_date '||l_validation_start_date, 100);
1022 hr_utility.set_location('xxxx l_validation_end_date '||l_validation_end_date, 100);
1023 ben_pln_bus.update_validate
1024 (p_rec => p_rec,
1025 p_effective_date => p_effective_date,
1026 p_datetrack_mode => p_datetrack_mode,
1027 p_validation_start_date => l_validation_start_date,
1028 p_validation_end_date => l_validation_end_date);
1029 --
1030 -- Call the supporting pre-update operation
1031 --
1032 pre_update
1033 (p_rec => p_rec,
1034 p_effective_date => p_effective_date,
1035 p_datetrack_mode => p_datetrack_mode,
1036 p_validation_start_date => l_validation_start_date,
1037 p_validation_end_date => l_validation_end_date);
1038 --
1039 -- Update the row.
1040 --
1041 update_dml
1042 (p_rec => p_rec,
1043 p_effective_date => p_effective_date,
1044 p_datetrack_mode => p_datetrack_mode,
1045 p_validation_start_date => l_validation_start_date,
1046 p_validation_end_date => l_validation_end_date);
1047 --
1048 -- Call the supporting post-update operation
1049 --
1050 post_update
1051 (p_rec => p_rec,
1052 p_effective_date => p_effective_date,
1053 p_datetrack_mode => p_datetrack_mode,
1054 p_validation_start_date => l_validation_start_date,
1055 p_validation_end_date => l_validation_end_date);
1056 End upd;
1057 --
1058 -- ----------------------------------------------------------------------------
1059 -- |---------------------------------< upd >----------------------------------|
1060 -- ----------------------------------------------------------------------------
1061 Procedure upd
1062 (
1063 p_pl_id in number,
1064 p_effective_start_date out nocopy date,
1065 p_effective_end_date out nocopy date,
1066 p_name in varchar2 ,
1067 p_alws_qdro_flag in varchar2 ,
1068 p_alws_qmcso_flag in varchar2 ,
1069 p_alws_reimbmts_flag in varchar2 ,
1070 p_bnf_addl_instn_txt_alwd_flag in varchar2 ,
1071 p_bnf_adrs_rqd_flag in varchar2 ,
1072 p_bnf_cntngt_bnfs_alwd_flag in varchar2 ,
1073 p_bnf_ctfn_rqd_flag in varchar2 ,
1074 p_bnf_dob_rqd_flag in varchar2 ,
1075 p_bnf_dsge_mnr_ttee_rqd_flag in varchar2 ,
1076 p_bnf_incrmt_amt in number ,
1077 p_bnf_dflt_bnf_cd in varchar2 ,
1078 p_bnf_legv_id_rqd_flag in varchar2 ,
1079 p_bnf_may_dsgt_org_flag in varchar2 ,
1080 p_bnf_mn_dsgntbl_amt in number ,
1081 p_bnf_mn_dsgntbl_pct_val in number ,
1082 p_rqd_perd_enrt_nenrt_val in number ,
1083 p_ordr_num in number ,
1084 p_bnf_pct_incrmt_val in number ,
1085 p_bnf_pct_amt_alwd_cd in varchar2 ,
1086 p_bnf_qdro_rl_apls_flag in varchar2 ,
1087 p_dflt_to_asn_pndg_ctfn_cd in varchar2 ,
1088 p_dflt_to_asn_pndg_ctfn_rl in number ,
1089 p_drvbl_fctr_apls_rts_flag in varchar2 ,
1090 p_drvbl_fctr_prtn_elig_flag in varchar2 ,
1091 p_dpnt_dsgn_cd in varchar2 ,
1092 p_elig_apls_flag in varchar2 ,
1093 p_invk_dcln_prtn_pl_flag in varchar2 ,
1094 p_invk_flx_cr_pl_flag in varchar2 ,
1095 p_imptd_incm_calc_cd in varchar2 ,
1096 p_drvbl_dpnt_elig_flag in varchar2 ,
1097 p_trk_inelig_per_flag in varchar2 ,
1098 p_pl_cd in varchar2 ,
1099 p_auto_enrt_mthd_rl in number ,
1100 p_ivr_ident in varchar2 ,
1101 p_url_ref_name in varchar2 ,
1102 p_cmpr_clms_to_cvg_or_bal_cd in varchar2 ,
1103 p_cobra_pymt_due_dy_num in number ,
1104 p_dpnt_cvd_by_othr_apls_flag in varchar2 ,
1105 p_enrt_mthd_cd in varchar2 ,
1106 p_enrt_cd in varchar2 ,
1107 p_enrt_cvg_strt_dt_cd in varchar2 ,
1108 p_enrt_cvg_end_dt_cd in varchar2 ,
1109 p_frfs_aply_flag in varchar2 ,
1110 p_hc_pl_subj_hcfa_aprvl_flag in varchar2 ,
1111 p_hghly_cmpd_rl_apls_flag in varchar2 ,
1112 p_incptn_dt in date ,
1113 p_mn_cvg_rl in number ,
1114 p_mn_cvg_rqd_amt in number ,
1115 p_mn_opts_rqd_num in number ,
1116 p_mx_cvg_alwd_amt in number ,
1117 p_mx_cvg_rl in number ,
1118 p_mx_opts_alwd_num in number ,
1119 p_mx_cvg_wcfn_mlt_num in number ,
1120 p_mx_cvg_wcfn_amt in number ,
1121 p_mx_cvg_incr_alwd_amt in number ,
1122 p_mx_cvg_incr_wcf_alwd_amt in number ,
1123 p_mx_cvg_mlt_incr_num in number ,
1124 p_mx_cvg_mlt_incr_wcf_num in number ,
1125 p_mx_wtg_dt_to_use_cd in varchar2 ,
1126 p_mx_wtg_dt_to_use_rl in number ,
1127 p_mx_wtg_perd_prte_uom in varchar2 ,
1128 p_mx_wtg_perd_prte_val in number ,
1129 p_mx_wtg_perd_rl in number ,
1130 p_nip_dflt_enrt_cd in varchar2 ,
1131 p_nip_dflt_enrt_det_rl in number ,
1132 p_dpnt_adrs_rqd_flag in varchar2 ,
1133 p_dpnt_cvg_end_dt_cd in varchar2 ,
1134 p_dpnt_cvg_end_dt_rl in number ,
1135 p_dpnt_cvg_strt_dt_cd in varchar2 ,
1136 p_dpnt_cvg_strt_dt_rl in number ,
1137 p_dpnt_dob_rqd_flag in varchar2 ,
1138 p_dpnt_leg_id_rqd_flag in varchar2 ,
1139 p_dpnt_no_ctfn_rqd_flag in varchar2 ,
1140 p_no_mn_cvg_amt_apls_flag in varchar2 ,
1141 p_no_mn_cvg_incr_apls_flag in varchar2 ,
1142 p_no_mn_opts_num_apls_flag in varchar2 ,
1143 p_no_mx_cvg_amt_apls_flag in varchar2 ,
1144 p_no_mx_cvg_incr_apls_flag in varchar2 ,
1145 p_no_mx_opts_num_apls_flag in varchar2 ,
1146 p_nip_pl_uom in varchar2 ,
1147 p_rqd_perd_enrt_nenrt_uom in varchar2 ,
1148 p_nip_acty_ref_perd_cd in varchar2 ,
1149 p_nip_enrt_info_rt_freq_cd in varchar2 ,
1150 p_per_cvrd_cd in varchar2 ,
1151 p_enrt_cvg_end_dt_rl in number ,
1152 p_postelcn_edit_rl in number ,
1153 p_enrt_cvg_strt_dt_rl in number ,
1154 p_prort_prtl_yr_cvg_rstrn_cd in varchar2 ,
1155 p_prort_prtl_yr_cvg_rstrn_rl in number ,
1156 p_prtn_elig_ovrid_alwd_flag in varchar2 ,
1157 p_svgs_pl_flag in varchar2 ,
1158 p_subj_to_imptd_incm_typ_cd in varchar2 ,
1159 p_use_all_asnts_elig_flag in varchar2 ,
1160 p_use_all_asnts_for_rt_flag in varchar2 ,
1161 p_vstg_apls_flag in varchar2 ,
1162 p_wvbl_flag in varchar2 ,
1163 p_hc_svc_typ_cd in varchar2 ,
1164 p_pl_stat_cd in varchar2 ,
1165 p_prmry_fndg_mthd_cd in varchar2 ,
1166 p_rt_end_dt_cd in varchar2 ,
1167 p_rt_end_dt_rl in number ,
1168 p_rt_strt_dt_rl in number ,
1169 p_rt_strt_dt_cd in varchar2 ,
1170 p_bnf_dsgn_cd in varchar2 ,
1171 p_pl_typ_id in number ,
1172 p_business_group_id in number ,
1173 p_enrt_pl_opt_flag in varchar2 ,
1174 p_bnft_prvdr_pool_id in number ,
1175 p_MAY_ENRL_PL_N_OIPL_FLAG in VARCHAR2 ,
1176 p_ENRT_RL in NUMBER ,
1177 p_rqd_perd_enrt_nenrt_rl in NUMBER ,
1178 p_ALWS_UNRSTRCTD_ENRT_FLAG in VARCHAR2 ,
1179 p_BNFT_OR_OPTION_RSTRCTN_CD in VARCHAR2 ,
1180 p_CVG_INCR_R_DECR_ONLY_CD in VARCHAR2 ,
1181 p_unsspnd_enrt_cd in varchar2 ,
1182 p_pln_attribute_category in varchar2 ,
1183 p_pln_attribute1 in varchar2 ,
1184 p_pln_attribute2 in varchar2 ,
1185 p_pln_attribute3 in varchar2 ,
1186 p_pln_attribute4 in varchar2 ,
1187 p_pln_attribute5 in varchar2 ,
1188 p_pln_attribute6 in varchar2 ,
1189 p_pln_attribute7 in varchar2 ,
1190 p_pln_attribute8 in varchar2 ,
1191 p_pln_attribute9 in varchar2 ,
1192 p_pln_attribute10 in varchar2 ,
1193 p_pln_attribute11 in varchar2 ,
1194 p_pln_attribute12 in varchar2 ,
1195 p_pln_attribute13 in varchar2 ,
1196 p_pln_attribute14 in varchar2 ,
1197 p_pln_attribute15 in varchar2 ,
1198 p_pln_attribute16 in varchar2 ,
1199 p_pln_attribute17 in varchar2 ,
1200 p_pln_attribute18 in varchar2 ,
1201 p_pln_attribute19 in varchar2 ,
1202 p_pln_attribute20 in varchar2 ,
1203 p_pln_attribute21 in varchar2 ,
1204 p_pln_attribute22 in varchar2 ,
1205 p_pln_attribute23 in varchar2 ,
1206 p_pln_attribute24 in varchar2 ,
1207 p_pln_attribute25 in varchar2 ,
1208 p_pln_attribute26 in varchar2 ,
1209 p_pln_attribute27 in varchar2 ,
1210 p_pln_attribute28 in varchar2 ,
1211 p_pln_attribute29 in varchar2 ,
1212 p_pln_attribute30 in varchar2 ,
1213 p_susp_if_ctfn_not_prvd_flag in varchar2 ,
1214 p_ctfn_determine_cd in varchar2 ,
1215 p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 ,
1216 p_susp_if_dpnt_dob_nt_prv_cd in varchar2 ,
1217 p_susp_if_dpnt_adr_nt_prv_cd in varchar2 ,
1218 p_susp_if_ctfn_not_dpnt_flag in varchar2 ,
1219 p_susp_if_bnf_ssn_nt_prv_cd in varchar2 ,
1220 p_susp_if_bnf_dob_nt_prv_cd in varchar2 ,
1221 p_susp_if_bnf_adr_nt_prv_cd in varchar2 ,
1222 p_susp_if_ctfn_not_bnf_flag in varchar2 ,
1223 p_dpnt_ctfn_determine_cd in varchar2 ,
1224 p_bnf_ctfn_determine_cd in varchar2 ,
1225 p_object_version_number in out nocopy number,
1226 p_actl_prem_id in number ,
1227 p_effective_date in date,
1228 p_datetrack_mode in varchar2,
1229 p_vrfy_fmly_mmbr_cd in varchar2 ,
1230 p_vrfy_fmly_mmbr_rl in number ,
1231 p_alws_tmpry_id_crd_flag in varchar2 ,
1232 p_nip_dflt_flag in varchar2 ,
1233 p_frfs_distr_mthd_cd in varchar2 ,
1234 p_frfs_distr_mthd_rl in number ,
1235 p_frfs_cntr_det_cd in varchar2 ,
1236 p_frfs_distr_det_cd in varchar2 ,
1237 p_cost_alloc_keyflex_1_id in number ,
1238 p_cost_alloc_keyflex_2_id in number ,
1239 p_post_to_gl_flag in varchar2 ,
1240 p_frfs_val_det_cd in varchar2 ,
1241 p_frfs_mx_cryfwd_val in number ,
1242 p_frfs_portion_det_cd in varchar2 ,
1243 p_bndry_perd_cd in varchar2 ,
1244 p_short_name in varchar2 ,
1245 p_short_code in varchar2 ,
1246 p_legislation_code in varchar2 ,
1247 p_legislation_subgroup in varchar2 ,
1248 p_group_pl_id in number ,
1249 p_mapping_table_name in varchar2 ,
1250 p_mapping_table_pk_id in number ,
1251 p_function_code in varchar2 ,
1252 p_pl_yr_not_applcbl_flag in varchar2 ,
1253 p_use_csd_rsd_prccng_cd in varchar2
1254 ) is
1255 --
1256 l_rec ben_pln_shd.g_rec_type;
1257 l_proc varchar2(72) := g_package||'upd';
1258 --
1259 Begin
1260 hr_utility.set_location('Entering:'||l_proc, 5);
1261 --
1262 -- Call conversion function to turn arguments into the
1263 -- l_rec structure.
1264 --
1265 l_rec :=
1266 ben_pln_shd.convert_args
1267 (
1268 p_pl_id
1269 ,null
1270 ,null
1271 ,p_name
1272 ,p_alws_qdro_flag
1273 ,p_alws_qmcso_flag
1274 ,p_alws_reimbmts_flag
1275 ,p_bnf_addl_instn_txt_alwd_flag
1276 ,p_bnf_adrs_rqd_flag
1277 ,p_bnf_cntngt_bnfs_alwd_flag
1278 ,p_bnf_ctfn_rqd_flag
1279 ,p_bnf_dob_rqd_flag
1280 ,p_bnf_dsge_mnr_ttee_rqd_flag
1281 ,p_bnf_incrmt_amt
1282 ,p_bnf_dflt_bnf_cd
1283 ,p_bnf_legv_id_rqd_flag
1284 ,p_bnf_may_dsgt_org_flag
1285 ,p_bnf_mn_dsgntbl_amt
1286 ,p_bnf_mn_dsgntbl_pct_val
1287 ,p_rqd_perd_enrt_nenrt_val
1288 ,p_ordr_num
1289 ,p_bnf_pct_incrmt_val
1290 ,p_bnf_pct_amt_alwd_cd
1291 ,p_bnf_qdro_rl_apls_flag
1292 ,p_dflt_to_asn_pndg_ctfn_cd
1293 ,p_dflt_to_asn_pndg_ctfn_rl
1294 ,p_drvbl_fctr_apls_rts_flag
1295 ,p_drvbl_fctr_prtn_elig_flag
1296 ,p_dpnt_dsgn_cd
1297 ,p_elig_apls_flag
1298 ,p_invk_dcln_prtn_pl_flag
1299 ,p_invk_flx_cr_pl_flag
1300 ,p_imptd_incm_calc_cd
1301 ,p_drvbl_dpnt_elig_flag
1302 ,p_trk_inelig_per_flag
1303 ,p_pl_cd
1304 ,p_auto_enrt_mthd_rl
1305 ,p_ivr_ident
1306 ,p_url_ref_name
1307 ,p_cmpr_clms_to_cvg_or_bal_cd
1308 ,p_cobra_pymt_due_dy_num
1309 ,p_dpnt_cvd_by_othr_apls_flag
1310 ,p_enrt_mthd_cd
1311 ,p_enrt_cd
1312 ,p_enrt_cvg_strt_dt_cd
1313 ,p_enrt_cvg_end_dt_cd
1314 ,p_frfs_aply_flag
1315 ,p_hc_pl_subj_hcfa_aprvl_flag
1316 ,p_hghly_cmpd_rl_apls_flag
1317 ,p_incptn_dt
1318 ,p_mn_cvg_rl
1319 ,p_mn_cvg_rqd_amt
1320 ,p_mn_opts_rqd_num
1321 ,p_mx_cvg_alwd_amt
1322 ,p_mx_cvg_rl
1323 ,p_mx_opts_alwd_num
1324 ,p_mx_cvg_wcfn_mlt_num
1325 ,p_mx_cvg_wcfn_amt
1326 ,p_mx_cvg_incr_alwd_amt
1327 ,p_mx_cvg_incr_wcf_alwd_amt
1328 ,p_mx_cvg_mlt_incr_num
1329 ,p_mx_cvg_mlt_incr_wcf_num
1330 ,p_mx_wtg_dt_to_use_cd
1331 ,p_mx_wtg_dt_to_use_rl
1332 ,p_mx_wtg_perd_prte_uom
1333 ,p_mx_wtg_perd_prte_val
1334 ,p_mx_wtg_perd_rl
1335 ,p_nip_dflt_enrt_cd
1336 ,p_nip_dflt_enrt_det_rl
1337 ,p_dpnt_adrs_rqd_flag
1338 ,p_dpnt_cvg_end_dt_cd
1339 ,p_dpnt_cvg_end_dt_rl
1340 ,p_dpnt_cvg_strt_dt_cd
1341 ,p_dpnt_cvg_strt_dt_rl
1342 ,p_dpnt_dob_rqd_flag
1343 ,p_dpnt_leg_id_rqd_flag
1344 ,p_dpnt_no_ctfn_rqd_flag
1345 ,p_no_mn_cvg_amt_apls_flag
1346 ,p_no_mn_cvg_incr_apls_flag
1347 ,p_no_mn_opts_num_apls_flag
1348 ,p_no_mx_cvg_amt_apls_flag
1349 ,p_no_mx_cvg_incr_apls_flag
1350 ,p_no_mx_opts_num_apls_flag
1351 ,p_nip_pl_uom
1352 ,p_rqd_perd_enrt_nenrt_uom
1353 ,p_nip_acty_ref_perd_cd
1354 ,p_nip_enrt_info_rt_freq_cd
1355 ,p_per_cvrd_cd
1356 ,p_enrt_cvg_end_dt_rl
1357 ,p_postelcn_edit_rl
1358 ,p_enrt_cvg_strt_dt_rl
1359 ,p_prort_prtl_yr_cvg_rstrn_cd
1360 ,p_prort_prtl_yr_cvg_rstrn_rl
1361 ,p_prtn_elig_ovrid_alwd_flag
1362 ,p_svgs_pl_flag
1363 ,p_subj_to_imptd_incm_typ_cd
1364 ,p_use_all_asnts_elig_flag
1365 ,p_use_all_asnts_for_rt_flag
1366 ,p_vstg_apls_flag
1367 ,p_wvbl_flag
1368 ,p_hc_svc_typ_cd
1369 ,p_pl_stat_cd
1370 ,p_prmry_fndg_mthd_cd
1371 ,p_rt_end_dt_cd
1372 ,p_rt_end_dt_rl
1373 ,p_rt_strt_dt_rl
1374 ,p_rt_strt_dt_cd
1375 ,p_bnf_dsgn_cd
1376 ,p_pl_typ_id
1377 ,p_business_group_id
1378 ,p_enrt_pl_opt_flag
1379 ,p_bnft_prvdr_pool_id
1380 ,p_MAY_ENRL_PL_N_OIPL_FLAG
1381 ,p_ENRT_RL
1382 ,p_rqd_perd_enrt_nenrt_rl
1383 ,p_ALWS_UNRSTRCTD_ENRT_FLAG
1384 ,p_BNFT_OR_OPTION_RSTRCTN_CD
1385 ,p_CVG_INCR_R_DECR_ONLY_CD
1386 ,p_unsspnd_enrt_cd
1387 ,p_pln_attribute_category
1388 ,p_pln_attribute1
1389 ,p_pln_attribute2
1390 ,p_pln_attribute3
1391 ,p_pln_attribute4
1392 ,p_pln_attribute5
1393 ,p_pln_attribute6
1394 ,p_pln_attribute7
1395 ,p_pln_attribute8
1396 ,p_pln_attribute9
1397 ,p_pln_attribute10
1398 ,p_pln_attribute11
1399 ,p_pln_attribute12
1400 ,p_pln_attribute13
1401 ,p_pln_attribute14
1402 ,p_pln_attribute15
1403 ,p_pln_attribute16
1404 ,p_pln_attribute17
1405 ,p_pln_attribute18
1406 ,p_pln_attribute19
1407 ,p_pln_attribute20
1408 ,p_pln_attribute21
1409 ,p_pln_attribute22
1410 ,p_pln_attribute23
1411 ,p_pln_attribute24
1412 ,p_pln_attribute25
1413 ,p_pln_attribute26
1414 ,p_pln_attribute27
1415 ,p_pln_attribute28
1416 ,p_pln_attribute29
1417 ,p_pln_attribute30
1418 ,p_susp_if_ctfn_not_prvd_flag
1419 ,p_ctfn_determine_cd
1420 ,p_susp_if_dpnt_ssn_nt_prv_cd
1421 ,p_susp_if_dpnt_dob_nt_prv_cd
1422 ,p_susp_if_dpnt_adr_nt_prv_cd
1423 ,p_susp_if_ctfn_not_dpnt_flag
1424 ,p_susp_if_bnf_ssn_nt_prv_cd
1425 ,p_susp_if_bnf_dob_nt_prv_cd
1426 ,p_susp_if_bnf_adr_nt_prv_cd
1427 ,p_susp_if_ctfn_not_bnf_flag
1428 ,p_dpnt_ctfn_determine_cd
1429 ,p_bnf_ctfn_determine_cd
1430 ,p_object_version_number
1431 ,p_actl_prem_id
1432 ,p_vrfy_fmly_mmbr_cd
1433 ,p_vrfy_fmly_mmbr_rl
1434 ,p_alws_tmpry_id_crd_flag
1435 ,p_nip_dflt_flag
1436 ,p_frfs_distr_mthd_cd
1437 ,p_frfs_distr_mthd_rl
1438 ,p_frfs_cntr_det_cd
1439 ,p_frfs_distr_det_cd
1440 ,p_cost_alloc_keyflex_1_id
1441 ,p_cost_alloc_keyflex_2_id
1442 ,p_post_to_gl_flag
1443 ,p_frfs_val_det_cd
1444 ,p_frfs_mx_cryfwd_val
1445 ,p_frfs_portion_det_cd
1446 ,p_bndry_perd_cd
1447 ,p_short_name
1448 ,p_short_code
1449 ,p_legislation_code
1450 ,p_legislation_subgroup
1451 ,p_group_pl_id
1452 ,p_mapping_table_name
1453 ,p_mapping_table_pk_id
1454 ,p_function_code
1455 ,p_pl_yr_not_applcbl_flag
1456 ,p_use_csd_rsd_prccng_cd
1457 );
1458 --
1459 -- Having converted the arguments into the
1460 -- plsql record structure we call the corresponding record
1461 -- business process.
1462 --
1463 upd(l_rec, p_effective_date, p_datetrack_mode);
1464 p_object_version_number := l_rec.object_version_number;
1465 p_effective_start_date := l_rec.effective_start_date;
1466 p_effective_end_date := l_rec.effective_end_date;
1467 --
1468 --
1469 hr_utility.set_location(' Leaving:'||l_proc, 10);
1470 End upd;
1471 --
1472 end ben_pln_upd;