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