DBA Data[Home] [Help]

APPS.BEN_ECR_UPD dependencies on BEN_ECR_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ben_ecr_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_ecr_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ben_ecr_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_ecr_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_enrt_rt Row
68: --
69: update ben_enrt_rt

Line 169: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status

165: program_update_date = p_rec.program_update_date,
166: object_version_number = p_rec.object_version_number
167: where enrt_rt_id = p_rec.enrt_rt_id;
168: --
169: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
170: --
171: hr_utility.set_location(' Leaving:'||l_proc, 10);
172: --
173: Exception

Line 176: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status

172: --
173: Exception
174: When hr_api.check_integrity_violated Then
175: -- A check constraint has been violated
176: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
177: ben_ecr_shd.constraint_error
178: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
179: When hr_api.parent_integrity_violated Then
180: -- Parent integrity has been violated

Line 177: ben_ecr_shd.constraint_error

173: Exception
174: When hr_api.check_integrity_violated Then
175: -- A check constraint has been violated
176: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
177: ben_ecr_shd.constraint_error
178: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
179: When hr_api.parent_integrity_violated Then
180: -- Parent integrity has been violated
181: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status

Line 181: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status

177: ben_ecr_shd.constraint_error
178: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
179: When hr_api.parent_integrity_violated Then
180: -- Parent integrity has been violated
181: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
182: ben_ecr_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.unique_integrity_violated Then
185: -- Unique integrity has been violated

Line 182: ben_ecr_shd.constraint_error

178: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
179: When hr_api.parent_integrity_violated Then
180: -- Parent integrity has been violated
181: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
182: ben_ecr_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.unique_integrity_violated Then
185: -- Unique integrity has been violated
186: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status

Line 186: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status

182: ben_ecr_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.unique_integrity_violated Then
185: -- Unique integrity has been violated
186: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
187: ben_ecr_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When Others Then
190: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status

Line 187: ben_ecr_shd.constraint_error

183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.unique_integrity_violated Then
185: -- Unique integrity has been violated
186: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
187: ben_ecr_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When Others Then
190: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
191: Raise;

Line 190: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status

186: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
187: ben_ecr_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When Others Then
190: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
191: Raise;
192: End update_dml;
193: --
194: -- ----------------------------------------------------------------------------

Line 226: Procedure pre_update(p_rec in ben_ecr_shd.g_rec_type) is

222: -- Internal Row Handler Use Only.
223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure pre_update(p_rec in ben_ecr_shd.g_rec_type) is
227: --
228: l_proc varchar2(72) := g_package||'pre_update';
229: --
230: Begin

Line 268: Procedure post_update(p_rec in ben_ecr_shd.g_rec_type,

264: -- Internal Row Handler Use Only.
265: --
266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure post_update(p_rec in ben_ecr_shd.g_rec_type,
269: p_effective_date in date) is
270: --
271: l_proc varchar2(72) := g_package||'post_update';
272: --

Line 323: Procedure convert_defs(p_rec in out nocopy ben_ecr_shd.g_rec_type) is

319: -- Internal Row Handler Use Only.
320: --
321: -- {End Of Comments}
322: -- ----------------------------------------------------------------------------
323: Procedure convert_defs(p_rec in out nocopy ben_ecr_shd.g_rec_type) is
324: --
325: l_proc varchar2(72) := g_package||'convert_defs';
326: --
327: Begin

Line 342: ben_ecr_shd.g_old_rec.acty_typ_cd;

338: ben_abr_shd.g_old_rec.ordr_num;
339: End If;
340: If (p_rec.acty_typ_cd = hr_api.g_varchar2) then
341: p_rec.acty_typ_cd :=
342: ben_ecr_shd.g_old_rec.acty_typ_cd;
343: End If;
344: If (p_rec.tx_typ_cd = hr_api.g_varchar2) then
345: p_rec.tx_typ_cd :=
346: ben_ecr_shd.g_old_rec.tx_typ_cd;

Line 346: ben_ecr_shd.g_old_rec.tx_typ_cd;

342: ben_ecr_shd.g_old_rec.acty_typ_cd;
343: End If;
344: If (p_rec.tx_typ_cd = hr_api.g_varchar2) then
345: p_rec.tx_typ_cd :=
346: ben_ecr_shd.g_old_rec.tx_typ_cd;
347: End If;
348: If (p_rec.ctfn_rqd_flag = hr_api.g_varchar2) then
349: p_rec.ctfn_rqd_flag :=
350: ben_ecr_shd.g_old_rec.ctfn_rqd_flag;

Line 350: ben_ecr_shd.g_old_rec.ctfn_rqd_flag;

346: ben_ecr_shd.g_old_rec.tx_typ_cd;
347: End If;
348: If (p_rec.ctfn_rqd_flag = hr_api.g_varchar2) then
349: p_rec.ctfn_rqd_flag :=
350: ben_ecr_shd.g_old_rec.ctfn_rqd_flag;
351: End If;
352: If (p_rec.dflt_flag = hr_api.g_varchar2) then
353: p_rec.dflt_flag :=
354: ben_ecr_shd.g_old_rec.dflt_flag;

Line 354: ben_ecr_shd.g_old_rec.dflt_flag;

350: ben_ecr_shd.g_old_rec.ctfn_rqd_flag;
351: End If;
352: If (p_rec.dflt_flag = hr_api.g_varchar2) then
353: p_rec.dflt_flag :=
354: ben_ecr_shd.g_old_rec.dflt_flag;
355: End If;
356: If (p_rec.dflt_pndg_ctfn_flag = hr_api.g_varchar2) then
357: p_rec.dflt_pndg_ctfn_flag :=
358: ben_ecr_shd.g_old_rec.dflt_pndg_ctfn_flag;

Line 358: ben_ecr_shd.g_old_rec.dflt_pndg_ctfn_flag;

354: ben_ecr_shd.g_old_rec.dflt_flag;
355: End If;
356: If (p_rec.dflt_pndg_ctfn_flag = hr_api.g_varchar2) then
357: p_rec.dflt_pndg_ctfn_flag :=
358: ben_ecr_shd.g_old_rec.dflt_pndg_ctfn_flag;
359: End If;
360: If (p_rec.dsply_on_enrt_flag = hr_api.g_varchar2) then
361: p_rec.dsply_on_enrt_flag :=
362: ben_ecr_shd.g_old_rec.dsply_on_enrt_flag;

Line 362: ben_ecr_shd.g_old_rec.dsply_on_enrt_flag;

358: ben_ecr_shd.g_old_rec.dflt_pndg_ctfn_flag;
359: End If;
360: If (p_rec.dsply_on_enrt_flag = hr_api.g_varchar2) then
361: p_rec.dsply_on_enrt_flag :=
362: ben_ecr_shd.g_old_rec.dsply_on_enrt_flag;
363: End If;
364: If (p_rec.use_to_calc_net_flx_cr_flag = hr_api.g_varchar2) then
365: p_rec.use_to_calc_net_flx_cr_flag :=
366: ben_ecr_shd.g_old_rec.use_to_calc_net_flx_cr_flag;

Line 366: ben_ecr_shd.g_old_rec.use_to_calc_net_flx_cr_flag;

362: ben_ecr_shd.g_old_rec.dsply_on_enrt_flag;
363: End If;
364: If (p_rec.use_to_calc_net_flx_cr_flag = hr_api.g_varchar2) then
365: p_rec.use_to_calc_net_flx_cr_flag :=
366: ben_ecr_shd.g_old_rec.use_to_calc_net_flx_cr_flag;
367: End If;
368: If (p_rec.entr_val_at_enrt_flag = hr_api.g_varchar2) then
369: p_rec.entr_val_at_enrt_flag :=
370: ben_ecr_shd.g_old_rec.entr_val_at_enrt_flag;

Line 370: ben_ecr_shd.g_old_rec.entr_val_at_enrt_flag;

366: ben_ecr_shd.g_old_rec.use_to_calc_net_flx_cr_flag;
367: End If;
368: If (p_rec.entr_val_at_enrt_flag = hr_api.g_varchar2) then
369: p_rec.entr_val_at_enrt_flag :=
370: ben_ecr_shd.g_old_rec.entr_val_at_enrt_flag;
371: End If;
372: If (p_rec.asn_on_enrt_flag = hr_api.g_varchar2) then
373: p_rec.asn_on_enrt_flag :=
374: ben_ecr_shd.g_old_rec.asn_on_enrt_flag;

Line 374: ben_ecr_shd.g_old_rec.asn_on_enrt_flag;

370: ben_ecr_shd.g_old_rec.entr_val_at_enrt_flag;
371: End If;
372: If (p_rec.asn_on_enrt_flag = hr_api.g_varchar2) then
373: p_rec.asn_on_enrt_flag :=
374: ben_ecr_shd.g_old_rec.asn_on_enrt_flag;
375: End If;
376: If (p_rec.rl_crs_only_flag = hr_api.g_varchar2) then
377: p_rec.rl_crs_only_flag :=
378: ben_ecr_shd.g_old_rec.rl_crs_only_flag;

Line 378: ben_ecr_shd.g_old_rec.rl_crs_only_flag;

374: ben_ecr_shd.g_old_rec.asn_on_enrt_flag;
375: End If;
376: If (p_rec.rl_crs_only_flag = hr_api.g_varchar2) then
377: p_rec.rl_crs_only_flag :=
378: ben_ecr_shd.g_old_rec.rl_crs_only_flag;
379: End If;
380: If (p_rec.dflt_val = hr_api.g_number) then
381: p_rec.dflt_val :=
382: ben_ecr_shd.g_old_rec.dflt_val;

Line 382: ben_ecr_shd.g_old_rec.dflt_val;

378: ben_ecr_shd.g_old_rec.rl_crs_only_flag;
379: End If;
380: If (p_rec.dflt_val = hr_api.g_number) then
381: p_rec.dflt_val :=
382: ben_ecr_shd.g_old_rec.dflt_val;
383: End If;
384: If (p_rec.ann_val = hr_api.g_number) then
385: p_rec.ann_val :=
386: ben_ecr_shd.g_old_rec.ann_val;

Line 386: ben_ecr_shd.g_old_rec.ann_val;

382: ben_ecr_shd.g_old_rec.dflt_val;
383: End If;
384: If (p_rec.ann_val = hr_api.g_number) then
385: p_rec.ann_val :=
386: ben_ecr_shd.g_old_rec.ann_val;
387: End If;
388: If (p_rec.ann_mn_elcn_val = hr_api.g_number) then
389: p_rec.ann_mn_elcn_val :=
390: ben_ecr_shd.g_old_rec.ann_mn_elcn_val;

Line 390: ben_ecr_shd.g_old_rec.ann_mn_elcn_val;

386: ben_ecr_shd.g_old_rec.ann_val;
387: End If;
388: If (p_rec.ann_mn_elcn_val = hr_api.g_number) then
389: p_rec.ann_mn_elcn_val :=
390: ben_ecr_shd.g_old_rec.ann_mn_elcn_val;
391: End If;
392: If (p_rec.ann_mx_elcn_val = hr_api.g_number) then
393: p_rec.ann_mx_elcn_val :=
394: ben_ecr_shd.g_old_rec.ann_mx_elcn_val;

Line 394: ben_ecr_shd.g_old_rec.ann_mx_elcn_val;

390: ben_ecr_shd.g_old_rec.ann_mn_elcn_val;
391: End If;
392: If (p_rec.ann_mx_elcn_val = hr_api.g_number) then
393: p_rec.ann_mx_elcn_val :=
394: ben_ecr_shd.g_old_rec.ann_mx_elcn_val;
395: End If;
396: If (p_rec.val = hr_api.g_number) then
397: p_rec.val :=
398: ben_ecr_shd.g_old_rec.val;

Line 398: ben_ecr_shd.g_old_rec.val;

394: ben_ecr_shd.g_old_rec.ann_mx_elcn_val;
395: End If;
396: If (p_rec.val = hr_api.g_number) then
397: p_rec.val :=
398: ben_ecr_shd.g_old_rec.val;
399: End If;
400: If (p_rec.nnmntry_uom = hr_api.g_varchar2) then
401: p_rec.nnmntry_uom :=
402: ben_ecr_shd.g_old_rec.nnmntry_uom;

Line 402: ben_ecr_shd.g_old_rec.nnmntry_uom;

398: ben_ecr_shd.g_old_rec.val;
399: End If;
400: If (p_rec.nnmntry_uom = hr_api.g_varchar2) then
401: p_rec.nnmntry_uom :=
402: ben_ecr_shd.g_old_rec.nnmntry_uom;
403: End If;
404: If (p_rec.mx_elcn_val = hr_api.g_number) then
405: p_rec.mx_elcn_val :=
406: ben_ecr_shd.g_old_rec.mx_elcn_val;

Line 406: ben_ecr_shd.g_old_rec.mx_elcn_val;

402: ben_ecr_shd.g_old_rec.nnmntry_uom;
403: End If;
404: If (p_rec.mx_elcn_val = hr_api.g_number) then
405: p_rec.mx_elcn_val :=
406: ben_ecr_shd.g_old_rec.mx_elcn_val;
407: End If;
408: If (p_rec.mn_elcn_val = hr_api.g_number) then
409: p_rec.mn_elcn_val :=
410: ben_ecr_shd.g_old_rec.mn_elcn_val;

Line 410: ben_ecr_shd.g_old_rec.mn_elcn_val;

406: ben_ecr_shd.g_old_rec.mx_elcn_val;
407: End If;
408: If (p_rec.mn_elcn_val = hr_api.g_number) then
409: p_rec.mn_elcn_val :=
410: ben_ecr_shd.g_old_rec.mn_elcn_val;
411: End If;
412: If (p_rec.incrmt_elcn_val = hr_api.g_number) then
413: p_rec.incrmt_elcn_val :=
414: ben_ecr_shd.g_old_rec.incrmt_elcn_val;

Line 414: ben_ecr_shd.g_old_rec.incrmt_elcn_val;

410: ben_ecr_shd.g_old_rec.mn_elcn_val;
411: End If;
412: If (p_rec.incrmt_elcn_val = hr_api.g_number) then
413: p_rec.incrmt_elcn_val :=
414: ben_ecr_shd.g_old_rec.incrmt_elcn_val;
415: End If;
416: If (p_rec.cmcd_acty_ref_perd_cd = hr_api.g_varchar2) then
417: p_rec.cmcd_acty_ref_perd_cd :=
418: ben_ecr_shd.g_old_rec.cmcd_acty_ref_perd_cd;

Line 418: ben_ecr_shd.g_old_rec.cmcd_acty_ref_perd_cd;

414: ben_ecr_shd.g_old_rec.incrmt_elcn_val;
415: End If;
416: If (p_rec.cmcd_acty_ref_perd_cd = hr_api.g_varchar2) then
417: p_rec.cmcd_acty_ref_perd_cd :=
418: ben_ecr_shd.g_old_rec.cmcd_acty_ref_perd_cd;
419: End If;
420: If (p_rec.cmcd_mn_elcn_val = hr_api.g_number) then
421: p_rec.cmcd_mn_elcn_val :=
422: ben_ecr_shd.g_old_rec.cmcd_mn_elcn_val;

Line 422: ben_ecr_shd.g_old_rec.cmcd_mn_elcn_val;

418: ben_ecr_shd.g_old_rec.cmcd_acty_ref_perd_cd;
419: End If;
420: If (p_rec.cmcd_mn_elcn_val = hr_api.g_number) then
421: p_rec.cmcd_mn_elcn_val :=
422: ben_ecr_shd.g_old_rec.cmcd_mn_elcn_val;
423: End If;
424: If (p_rec.cmcd_mx_elcn_val = hr_api.g_number) then
425: p_rec.cmcd_mx_elcn_val :=
426: ben_ecr_shd.g_old_rec.cmcd_mx_elcn_val;

Line 426: ben_ecr_shd.g_old_rec.cmcd_mx_elcn_val;

422: ben_ecr_shd.g_old_rec.cmcd_mn_elcn_val;
423: End If;
424: If (p_rec.cmcd_mx_elcn_val = hr_api.g_number) then
425: p_rec.cmcd_mx_elcn_val :=
426: ben_ecr_shd.g_old_rec.cmcd_mx_elcn_val;
427: End If;
428: If (p_rec.cmcd_val = hr_api.g_number) then
429: p_rec.cmcd_val :=
430: ben_ecr_shd.g_old_rec.cmcd_val;

Line 430: ben_ecr_shd.g_old_rec.cmcd_val;

426: ben_ecr_shd.g_old_rec.cmcd_mx_elcn_val;
427: End If;
428: If (p_rec.cmcd_val = hr_api.g_number) then
429: p_rec.cmcd_val :=
430: ben_ecr_shd.g_old_rec.cmcd_val;
431: End If;
432: If (p_rec.cmcd_dflt_val = hr_api.g_number) then
433: p_rec.cmcd_dflt_val :=
434: ben_ecr_shd.g_old_rec.cmcd_dflt_val;

Line 434: ben_ecr_shd.g_old_rec.cmcd_dflt_val;

430: ben_ecr_shd.g_old_rec.cmcd_val;
431: End If;
432: If (p_rec.cmcd_dflt_val = hr_api.g_number) then
433: p_rec.cmcd_dflt_val :=
434: ben_ecr_shd.g_old_rec.cmcd_dflt_val;
435: End If;
436: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then
437: p_rec.elig_per_elctbl_chc_id :=
438: ben_ecr_shd.g_old_rec.elig_per_elctbl_chc_id;

Line 438: ben_ecr_shd.g_old_rec.elig_per_elctbl_chc_id;

434: ben_ecr_shd.g_old_rec.cmcd_dflt_val;
435: End If;
436: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then
437: p_rec.elig_per_elctbl_chc_id :=
438: ben_ecr_shd.g_old_rec.elig_per_elctbl_chc_id;
439: End If;
440: If (p_rec.acty_base_rt_id = hr_api.g_number) then
441: p_rec.acty_base_rt_id :=
442: ben_ecr_shd.g_old_rec.acty_base_rt_id;

Line 442: ben_ecr_shd.g_old_rec.acty_base_rt_id;

438: ben_ecr_shd.g_old_rec.elig_per_elctbl_chc_id;
439: End If;
440: If (p_rec.acty_base_rt_id = hr_api.g_number) then
441: p_rec.acty_base_rt_id :=
442: ben_ecr_shd.g_old_rec.acty_base_rt_id;
443: End If;
444: If (p_rec.spcl_rt_enrt_rt_id = hr_api.g_number) then
445: p_rec.spcl_rt_enrt_rt_id :=
446: ben_ecr_shd.g_old_rec.spcl_rt_enrt_rt_id;

Line 446: ben_ecr_shd.g_old_rec.spcl_rt_enrt_rt_id;

442: ben_ecr_shd.g_old_rec.acty_base_rt_id;
443: End If;
444: If (p_rec.spcl_rt_enrt_rt_id = hr_api.g_number) then
445: p_rec.spcl_rt_enrt_rt_id :=
446: ben_ecr_shd.g_old_rec.spcl_rt_enrt_rt_id;
447: End If;
448: If (p_rec.enrt_bnft_id = hr_api.g_number) then
449: p_rec.enrt_bnft_id :=
450: ben_ecr_shd.g_old_rec.enrt_bnft_id;

Line 450: ben_ecr_shd.g_old_rec.enrt_bnft_id;

446: ben_ecr_shd.g_old_rec.spcl_rt_enrt_rt_id;
447: End If;
448: If (p_rec.enrt_bnft_id = hr_api.g_number) then
449: p_rec.enrt_bnft_id :=
450: ben_ecr_shd.g_old_rec.enrt_bnft_id;
451: End If;
452: If (p_rec.business_group_id = hr_api.g_number) then
453: p_rec.business_group_id :=
454: ben_ecr_shd.g_old_rec.business_group_id;

Line 454: ben_ecr_shd.g_old_rec.business_group_id;

450: ben_ecr_shd.g_old_rec.enrt_bnft_id;
451: End If;
452: If (p_rec.business_group_id = hr_api.g_number) then
453: p_rec.business_group_id :=
454: ben_ecr_shd.g_old_rec.business_group_id;
455: End If;
456: --cwb
457: If (p_rec.iss_val = hr_api.g_number) then
458: p_rec.iss_val :=

Line 459: ben_ecr_shd.g_old_rec.iss_val;

455: End If;
456: --cwb
457: If (p_rec.iss_val = hr_api.g_number) then
458: p_rec.iss_val :=
459: ben_ecr_shd.g_old_rec.iss_val;
460: End If;
461: If (p_rec.val_last_upd_person_id = hr_api.g_number) then
462: p_rec.val_last_upd_person_id :=
463: ben_ecr_shd.g_old_rec.val_last_upd_person_id;

Line 463: ben_ecr_shd.g_old_rec.val_last_upd_person_id;

459: ben_ecr_shd.g_old_rec.iss_val;
460: End If;
461: If (p_rec.val_last_upd_person_id = hr_api.g_number) then
462: p_rec.val_last_upd_person_id :=
463: ben_ecr_shd.g_old_rec.val_last_upd_person_id;
464: End If;
465: If (p_rec.val_last_upd_date = hr_api.g_date) then
466: p_rec.val_last_upd_date :=
467: ben_ecr_shd.g_old_rec.val_last_upd_date;

Line 467: ben_ecr_shd.g_old_rec.val_last_upd_date;

463: ben_ecr_shd.g_old_rec.val_last_upd_person_id;
464: End If;
465: If (p_rec.val_last_upd_date = hr_api.g_date) then
466: p_rec.val_last_upd_date :=
467: ben_ecr_shd.g_old_rec.val_last_upd_date;
468: End If;
469: --cwb
470: If (p_rec.pp_in_yr_used_num = hr_api.g_number) then
471: p_rec.pp_in_yr_used_num :=

Line 472: ben_ecr_shd.g_old_rec.pp_in_yr_used_num;

468: End If;
469: --cwb
470: If (p_rec.pp_in_yr_used_num = hr_api.g_number) then
471: p_rec.pp_in_yr_used_num :=
472: ben_ecr_shd.g_old_rec.pp_in_yr_used_num;
473: End If;
474: If (p_rec.ecr_attribute_category = hr_api.g_varchar2) then
475: p_rec.ecr_attribute_category :=
476: ben_ecr_shd.g_old_rec.ecr_attribute_category;

Line 476: ben_ecr_shd.g_old_rec.ecr_attribute_category;

472: ben_ecr_shd.g_old_rec.pp_in_yr_used_num;
473: End If;
474: If (p_rec.ecr_attribute_category = hr_api.g_varchar2) then
475: p_rec.ecr_attribute_category :=
476: ben_ecr_shd.g_old_rec.ecr_attribute_category;
477: End If;
478: If (p_rec.ecr_attribute1 = hr_api.g_varchar2) then
479: p_rec.ecr_attribute1 :=
480: ben_ecr_shd.g_old_rec.ecr_attribute1;

Line 480: ben_ecr_shd.g_old_rec.ecr_attribute1;

476: ben_ecr_shd.g_old_rec.ecr_attribute_category;
477: End If;
478: If (p_rec.ecr_attribute1 = hr_api.g_varchar2) then
479: p_rec.ecr_attribute1 :=
480: ben_ecr_shd.g_old_rec.ecr_attribute1;
481: End If;
482: If (p_rec.ecr_attribute2 = hr_api.g_varchar2) then
483: p_rec.ecr_attribute2 :=
484: ben_ecr_shd.g_old_rec.ecr_attribute2;

Line 484: ben_ecr_shd.g_old_rec.ecr_attribute2;

480: ben_ecr_shd.g_old_rec.ecr_attribute1;
481: End If;
482: If (p_rec.ecr_attribute2 = hr_api.g_varchar2) then
483: p_rec.ecr_attribute2 :=
484: ben_ecr_shd.g_old_rec.ecr_attribute2;
485: End If;
486: If (p_rec.ecr_attribute3 = hr_api.g_varchar2) then
487: p_rec.ecr_attribute3 :=
488: ben_ecr_shd.g_old_rec.ecr_attribute3;

Line 488: ben_ecr_shd.g_old_rec.ecr_attribute3;

484: ben_ecr_shd.g_old_rec.ecr_attribute2;
485: End If;
486: If (p_rec.ecr_attribute3 = hr_api.g_varchar2) then
487: p_rec.ecr_attribute3 :=
488: ben_ecr_shd.g_old_rec.ecr_attribute3;
489: End If;
490: If (p_rec.ecr_attribute4 = hr_api.g_varchar2) then
491: p_rec.ecr_attribute4 :=
492: ben_ecr_shd.g_old_rec.ecr_attribute4;

Line 492: ben_ecr_shd.g_old_rec.ecr_attribute4;

488: ben_ecr_shd.g_old_rec.ecr_attribute3;
489: End If;
490: If (p_rec.ecr_attribute4 = hr_api.g_varchar2) then
491: p_rec.ecr_attribute4 :=
492: ben_ecr_shd.g_old_rec.ecr_attribute4;
493: End If;
494: If (p_rec.ecr_attribute5 = hr_api.g_varchar2) then
495: p_rec.ecr_attribute5 :=
496: ben_ecr_shd.g_old_rec.ecr_attribute5;

Line 496: ben_ecr_shd.g_old_rec.ecr_attribute5;

492: ben_ecr_shd.g_old_rec.ecr_attribute4;
493: End If;
494: If (p_rec.ecr_attribute5 = hr_api.g_varchar2) then
495: p_rec.ecr_attribute5 :=
496: ben_ecr_shd.g_old_rec.ecr_attribute5;
497: End If;
498: If (p_rec.ecr_attribute6 = hr_api.g_varchar2) then
499: p_rec.ecr_attribute6 :=
500: ben_ecr_shd.g_old_rec.ecr_attribute6;

Line 500: ben_ecr_shd.g_old_rec.ecr_attribute6;

496: ben_ecr_shd.g_old_rec.ecr_attribute5;
497: End If;
498: If (p_rec.ecr_attribute6 = hr_api.g_varchar2) then
499: p_rec.ecr_attribute6 :=
500: ben_ecr_shd.g_old_rec.ecr_attribute6;
501: End If;
502: If (p_rec.ecr_attribute7 = hr_api.g_varchar2) then
503: p_rec.ecr_attribute7 :=
504: ben_ecr_shd.g_old_rec.ecr_attribute7;

Line 504: ben_ecr_shd.g_old_rec.ecr_attribute7;

500: ben_ecr_shd.g_old_rec.ecr_attribute6;
501: End If;
502: If (p_rec.ecr_attribute7 = hr_api.g_varchar2) then
503: p_rec.ecr_attribute7 :=
504: ben_ecr_shd.g_old_rec.ecr_attribute7;
505: End If;
506: If (p_rec.ecr_attribute8 = hr_api.g_varchar2) then
507: p_rec.ecr_attribute8 :=
508: ben_ecr_shd.g_old_rec.ecr_attribute8;

Line 508: ben_ecr_shd.g_old_rec.ecr_attribute8;

504: ben_ecr_shd.g_old_rec.ecr_attribute7;
505: End If;
506: If (p_rec.ecr_attribute8 = hr_api.g_varchar2) then
507: p_rec.ecr_attribute8 :=
508: ben_ecr_shd.g_old_rec.ecr_attribute8;
509: End If;
510: If (p_rec.ecr_attribute9 = hr_api.g_varchar2) then
511: p_rec.ecr_attribute9 :=
512: ben_ecr_shd.g_old_rec.ecr_attribute9;

Line 512: ben_ecr_shd.g_old_rec.ecr_attribute9;

508: ben_ecr_shd.g_old_rec.ecr_attribute8;
509: End If;
510: If (p_rec.ecr_attribute9 = hr_api.g_varchar2) then
511: p_rec.ecr_attribute9 :=
512: ben_ecr_shd.g_old_rec.ecr_attribute9;
513: End If;
514: If (p_rec.ecr_attribute10 = hr_api.g_varchar2) then
515: p_rec.ecr_attribute10 :=
516: ben_ecr_shd.g_old_rec.ecr_attribute10;

Line 516: ben_ecr_shd.g_old_rec.ecr_attribute10;

512: ben_ecr_shd.g_old_rec.ecr_attribute9;
513: End If;
514: If (p_rec.ecr_attribute10 = hr_api.g_varchar2) then
515: p_rec.ecr_attribute10 :=
516: ben_ecr_shd.g_old_rec.ecr_attribute10;
517: End If;
518: If (p_rec.ecr_attribute11 = hr_api.g_varchar2) then
519: p_rec.ecr_attribute11 :=
520: ben_ecr_shd.g_old_rec.ecr_attribute11;

Line 520: ben_ecr_shd.g_old_rec.ecr_attribute11;

516: ben_ecr_shd.g_old_rec.ecr_attribute10;
517: End If;
518: If (p_rec.ecr_attribute11 = hr_api.g_varchar2) then
519: p_rec.ecr_attribute11 :=
520: ben_ecr_shd.g_old_rec.ecr_attribute11;
521: End If;
522: If (p_rec.ecr_attribute12 = hr_api.g_varchar2) then
523: p_rec.ecr_attribute12 :=
524: ben_ecr_shd.g_old_rec.ecr_attribute12;

Line 524: ben_ecr_shd.g_old_rec.ecr_attribute12;

520: ben_ecr_shd.g_old_rec.ecr_attribute11;
521: End If;
522: If (p_rec.ecr_attribute12 = hr_api.g_varchar2) then
523: p_rec.ecr_attribute12 :=
524: ben_ecr_shd.g_old_rec.ecr_attribute12;
525: End If;
526: If (p_rec.ecr_attribute13 = hr_api.g_varchar2) then
527: p_rec.ecr_attribute13 :=
528: ben_ecr_shd.g_old_rec.ecr_attribute13;

Line 528: ben_ecr_shd.g_old_rec.ecr_attribute13;

524: ben_ecr_shd.g_old_rec.ecr_attribute12;
525: End If;
526: If (p_rec.ecr_attribute13 = hr_api.g_varchar2) then
527: p_rec.ecr_attribute13 :=
528: ben_ecr_shd.g_old_rec.ecr_attribute13;
529: End If;
530: If (p_rec.ecr_attribute14 = hr_api.g_varchar2) then
531: p_rec.ecr_attribute14 :=
532: ben_ecr_shd.g_old_rec.ecr_attribute14;

Line 532: ben_ecr_shd.g_old_rec.ecr_attribute14;

528: ben_ecr_shd.g_old_rec.ecr_attribute13;
529: End If;
530: If (p_rec.ecr_attribute14 = hr_api.g_varchar2) then
531: p_rec.ecr_attribute14 :=
532: ben_ecr_shd.g_old_rec.ecr_attribute14;
533: End If;
534: If (p_rec.ecr_attribute15 = hr_api.g_varchar2) then
535: p_rec.ecr_attribute15 :=
536: ben_ecr_shd.g_old_rec.ecr_attribute15;

Line 536: ben_ecr_shd.g_old_rec.ecr_attribute15;

532: ben_ecr_shd.g_old_rec.ecr_attribute14;
533: End If;
534: If (p_rec.ecr_attribute15 = hr_api.g_varchar2) then
535: p_rec.ecr_attribute15 :=
536: ben_ecr_shd.g_old_rec.ecr_attribute15;
537: End If;
538: If (p_rec.ecr_attribute16 = hr_api.g_varchar2) then
539: p_rec.ecr_attribute16 :=
540: ben_ecr_shd.g_old_rec.ecr_attribute16;

Line 540: ben_ecr_shd.g_old_rec.ecr_attribute16;

536: ben_ecr_shd.g_old_rec.ecr_attribute15;
537: End If;
538: If (p_rec.ecr_attribute16 = hr_api.g_varchar2) then
539: p_rec.ecr_attribute16 :=
540: ben_ecr_shd.g_old_rec.ecr_attribute16;
541: End If;
542: If (p_rec.ecr_attribute17 = hr_api.g_varchar2) then
543: p_rec.ecr_attribute17 :=
544: ben_ecr_shd.g_old_rec.ecr_attribute17;

Line 544: ben_ecr_shd.g_old_rec.ecr_attribute17;

540: ben_ecr_shd.g_old_rec.ecr_attribute16;
541: End If;
542: If (p_rec.ecr_attribute17 = hr_api.g_varchar2) then
543: p_rec.ecr_attribute17 :=
544: ben_ecr_shd.g_old_rec.ecr_attribute17;
545: End If;
546: If (p_rec.ecr_attribute18 = hr_api.g_varchar2) then
547: p_rec.ecr_attribute18 :=
548: ben_ecr_shd.g_old_rec.ecr_attribute18;

Line 548: ben_ecr_shd.g_old_rec.ecr_attribute18;

544: ben_ecr_shd.g_old_rec.ecr_attribute17;
545: End If;
546: If (p_rec.ecr_attribute18 = hr_api.g_varchar2) then
547: p_rec.ecr_attribute18 :=
548: ben_ecr_shd.g_old_rec.ecr_attribute18;
549: End If;
550: If (p_rec.ecr_attribute19 = hr_api.g_varchar2) then
551: p_rec.ecr_attribute19 :=
552: ben_ecr_shd.g_old_rec.ecr_attribute19;

Line 552: ben_ecr_shd.g_old_rec.ecr_attribute19;

548: ben_ecr_shd.g_old_rec.ecr_attribute18;
549: End If;
550: If (p_rec.ecr_attribute19 = hr_api.g_varchar2) then
551: p_rec.ecr_attribute19 :=
552: ben_ecr_shd.g_old_rec.ecr_attribute19;
553: End If;
554: If (p_rec.ecr_attribute20 = hr_api.g_varchar2) then
555: p_rec.ecr_attribute20 :=
556: ben_ecr_shd.g_old_rec.ecr_attribute20;

Line 556: ben_ecr_shd.g_old_rec.ecr_attribute20;

552: ben_ecr_shd.g_old_rec.ecr_attribute19;
553: End If;
554: If (p_rec.ecr_attribute20 = hr_api.g_varchar2) then
555: p_rec.ecr_attribute20 :=
556: ben_ecr_shd.g_old_rec.ecr_attribute20;
557: End If;
558: If (p_rec.ecr_attribute21 = hr_api.g_varchar2) then
559: p_rec.ecr_attribute21 :=
560: ben_ecr_shd.g_old_rec.ecr_attribute21;

Line 560: ben_ecr_shd.g_old_rec.ecr_attribute21;

556: ben_ecr_shd.g_old_rec.ecr_attribute20;
557: End If;
558: If (p_rec.ecr_attribute21 = hr_api.g_varchar2) then
559: p_rec.ecr_attribute21 :=
560: ben_ecr_shd.g_old_rec.ecr_attribute21;
561: End If;
562: If (p_rec.ecr_attribute22 = hr_api.g_varchar2) then
563: p_rec.ecr_attribute22 :=
564: ben_ecr_shd.g_old_rec.ecr_attribute22;

Line 564: ben_ecr_shd.g_old_rec.ecr_attribute22;

560: ben_ecr_shd.g_old_rec.ecr_attribute21;
561: End If;
562: If (p_rec.ecr_attribute22 = hr_api.g_varchar2) then
563: p_rec.ecr_attribute22 :=
564: ben_ecr_shd.g_old_rec.ecr_attribute22;
565: End If;
566: If (p_rec.ecr_attribute23 = hr_api.g_varchar2) then
567: p_rec.ecr_attribute23 :=
568: ben_ecr_shd.g_old_rec.ecr_attribute23;

Line 568: ben_ecr_shd.g_old_rec.ecr_attribute23;

564: ben_ecr_shd.g_old_rec.ecr_attribute22;
565: End If;
566: If (p_rec.ecr_attribute23 = hr_api.g_varchar2) then
567: p_rec.ecr_attribute23 :=
568: ben_ecr_shd.g_old_rec.ecr_attribute23;
569: End If;
570: If (p_rec.ecr_attribute24 = hr_api.g_varchar2) then
571: p_rec.ecr_attribute24 :=
572: ben_ecr_shd.g_old_rec.ecr_attribute24;

Line 572: ben_ecr_shd.g_old_rec.ecr_attribute24;

568: ben_ecr_shd.g_old_rec.ecr_attribute23;
569: End If;
570: If (p_rec.ecr_attribute24 = hr_api.g_varchar2) then
571: p_rec.ecr_attribute24 :=
572: ben_ecr_shd.g_old_rec.ecr_attribute24;
573: End If;
574: If (p_rec.ecr_attribute25 = hr_api.g_varchar2) then
575: p_rec.ecr_attribute25 :=
576: ben_ecr_shd.g_old_rec.ecr_attribute25;

Line 576: ben_ecr_shd.g_old_rec.ecr_attribute25;

572: ben_ecr_shd.g_old_rec.ecr_attribute24;
573: End If;
574: If (p_rec.ecr_attribute25 = hr_api.g_varchar2) then
575: p_rec.ecr_attribute25 :=
576: ben_ecr_shd.g_old_rec.ecr_attribute25;
577: End If;
578: If (p_rec.ecr_attribute26 = hr_api.g_varchar2) then
579: p_rec.ecr_attribute26 :=
580: ben_ecr_shd.g_old_rec.ecr_attribute26;

Line 580: ben_ecr_shd.g_old_rec.ecr_attribute26;

576: ben_ecr_shd.g_old_rec.ecr_attribute25;
577: End If;
578: If (p_rec.ecr_attribute26 = hr_api.g_varchar2) then
579: p_rec.ecr_attribute26 :=
580: ben_ecr_shd.g_old_rec.ecr_attribute26;
581: End If;
582: If (p_rec.ecr_attribute27 = hr_api.g_varchar2) then
583: p_rec.ecr_attribute27 :=
584: ben_ecr_shd.g_old_rec.ecr_attribute27;

Line 584: ben_ecr_shd.g_old_rec.ecr_attribute27;

580: ben_ecr_shd.g_old_rec.ecr_attribute26;
581: End If;
582: If (p_rec.ecr_attribute27 = hr_api.g_varchar2) then
583: p_rec.ecr_attribute27 :=
584: ben_ecr_shd.g_old_rec.ecr_attribute27;
585: End If;
586: If (p_rec.ecr_attribute28 = hr_api.g_varchar2) then
587: p_rec.ecr_attribute28 :=
588: ben_ecr_shd.g_old_rec.ecr_attribute28;

Line 588: ben_ecr_shd.g_old_rec.ecr_attribute28;

584: ben_ecr_shd.g_old_rec.ecr_attribute27;
585: End If;
586: If (p_rec.ecr_attribute28 = hr_api.g_varchar2) then
587: p_rec.ecr_attribute28 :=
588: ben_ecr_shd.g_old_rec.ecr_attribute28;
589: End If;
590: If (p_rec.ecr_attribute29 = hr_api.g_varchar2) then
591: p_rec.ecr_attribute29 :=
592: ben_ecr_shd.g_old_rec.ecr_attribute29;

Line 592: ben_ecr_shd.g_old_rec.ecr_attribute29;

588: ben_ecr_shd.g_old_rec.ecr_attribute28;
589: End If;
590: If (p_rec.ecr_attribute29 = hr_api.g_varchar2) then
591: p_rec.ecr_attribute29 :=
592: ben_ecr_shd.g_old_rec.ecr_attribute29;
593: End If;
594: If (p_rec.ecr_attribute30 = hr_api.g_varchar2) then
595: p_rec.ecr_attribute30 :=
596: ben_ecr_shd.g_old_rec.ecr_attribute30;

Line 596: ben_ecr_shd.g_old_rec.ecr_attribute30;

592: ben_ecr_shd.g_old_rec.ecr_attribute29;
593: End If;
594: If (p_rec.ecr_attribute30 = hr_api.g_varchar2) then
595: p_rec.ecr_attribute30 :=
596: ben_ecr_shd.g_old_rec.ecr_attribute30;
597: End If;
598: If (p_rec.request_id = hr_api.g_number) then
599: p_rec.request_id :=
600: ben_ecr_shd.g_old_rec.request_id;

Line 600: ben_ecr_shd.g_old_rec.request_id;

596: ben_ecr_shd.g_old_rec.ecr_attribute30;
597: End If;
598: If (p_rec.request_id = hr_api.g_number) then
599: p_rec.request_id :=
600: ben_ecr_shd.g_old_rec.request_id;
601: End If;
602: If (p_rec.program_application_id = hr_api.g_number) then
603: p_rec.program_application_id :=
604: ben_ecr_shd.g_old_rec.program_application_id;

Line 604: ben_ecr_shd.g_old_rec.program_application_id;

600: ben_ecr_shd.g_old_rec.request_id;
601: End If;
602: If (p_rec.program_application_id = hr_api.g_number) then
603: p_rec.program_application_id :=
604: ben_ecr_shd.g_old_rec.program_application_id;
605: End If;
606: If (p_rec.program_id = hr_api.g_number) then
607: p_rec.program_id :=
608: ben_ecr_shd.g_old_rec.program_id;

Line 608: ben_ecr_shd.g_old_rec.program_id;

604: ben_ecr_shd.g_old_rec.program_application_id;
605: End If;
606: If (p_rec.program_id = hr_api.g_number) then
607: p_rec.program_id :=
608: ben_ecr_shd.g_old_rec.program_id;
609: End If;
610: If (p_rec.program_update_date = hr_api.g_date) then
611: p_rec.program_update_date :=
612: ben_ecr_shd.g_old_rec.program_update_date;

Line 612: ben_ecr_shd.g_old_rec.program_update_date;

608: ben_ecr_shd.g_old_rec.program_id;
609: End If;
610: If (p_rec.program_update_date = hr_api.g_date) then
611: p_rec.program_update_date :=
612: ben_ecr_shd.g_old_rec.program_update_date;
613: End If;
614: If (p_rec.prtt_rt_val_id = hr_api.g_number) then
615: p_rec.prtt_rt_val_id :=
616: ben_ecr_shd.g_old_rec.prtt_rt_val_id;

Line 616: ben_ecr_shd.g_old_rec.prtt_rt_val_id;

612: ben_ecr_shd.g_old_rec.program_update_date;
613: End If;
614: If (p_rec.prtt_rt_val_id = hr_api.g_number) then
615: p_rec.prtt_rt_val_id :=
616: ben_ecr_shd.g_old_rec.prtt_rt_val_id;
617: End If;
618: If (p_rec.rt_usg_cd = hr_api.g_varchar2) then
619: p_rec.rt_usg_cd :=
620: ben_ecr_shd.g_old_rec.rt_usg_cd;

Line 620: ben_ecr_shd.g_old_rec.rt_usg_cd;

616: ben_ecr_shd.g_old_rec.prtt_rt_val_id;
617: End If;
618: If (p_rec.rt_usg_cd = hr_api.g_varchar2) then
619: p_rec.rt_usg_cd :=
620: ben_ecr_shd.g_old_rec.rt_usg_cd;
621: End If;
622: If (p_rec.decr_bnft_prvdr_pool_id = hr_api.g_number) then
623: p_rec.decr_bnft_prvdr_pool_id :=
624: ben_ecr_shd.g_old_rec.decr_bnft_prvdr_pool_id;

Line 624: ben_ecr_shd.g_old_rec.decr_bnft_prvdr_pool_id;

620: ben_ecr_shd.g_old_rec.rt_usg_cd;
621: End If;
622: If (p_rec.decr_bnft_prvdr_pool_id = hr_api.g_number) then
623: p_rec.decr_bnft_prvdr_pool_id :=
624: ben_ecr_shd.g_old_rec.decr_bnft_prvdr_pool_id;
625: End If;
626: If (p_rec.ann_dflt_val = hr_api.g_number) then
627: p_rec.ann_dflt_val :=
628: ben_ecr_shd.g_old_rec.ann_dflt_val;

Line 628: ben_ecr_shd.g_old_rec.ann_dflt_val;

624: ben_ecr_shd.g_old_rec.decr_bnft_prvdr_pool_id;
625: End If;
626: If (p_rec.ann_dflt_val = hr_api.g_number) then
627: p_rec.ann_dflt_val :=
628: ben_ecr_shd.g_old_rec.ann_dflt_val;
629: End If;
630: If (p_rec.bnft_rt_typ_cd = hr_api.g_varchar2) then
631: p_rec.bnft_rt_typ_cd :=
632: ben_ecr_shd.g_old_rec.bnft_rt_typ_cd;

Line 632: ben_ecr_shd.g_old_rec.bnft_rt_typ_cd;

628: ben_ecr_shd.g_old_rec.ann_dflt_val;
629: End If;
630: If (p_rec.bnft_rt_typ_cd = hr_api.g_varchar2) then
631: p_rec.bnft_rt_typ_cd :=
632: ben_ecr_shd.g_old_rec.bnft_rt_typ_cd;
633: End If;
634: If (p_rec.rt_mlt_cd = hr_api.g_varchar2) then
635: p_rec.rt_mlt_cd :=
636: ben_ecr_shd.g_old_rec.rt_mlt_cd;

Line 636: ben_ecr_shd.g_old_rec.rt_mlt_cd;

632: ben_ecr_shd.g_old_rec.bnft_rt_typ_cd;
633: End If;
634: If (p_rec.rt_mlt_cd = hr_api.g_varchar2) then
635: p_rec.rt_mlt_cd :=
636: ben_ecr_shd.g_old_rec.rt_mlt_cd;
637: End If;
638: If (p_rec.dsply_mn_elcn_val = hr_api.g_number) then
639: p_rec.dsply_mn_elcn_val :=
640: ben_ecr_shd.g_old_rec.dsply_mn_elcn_val;

Line 640: ben_ecr_shd.g_old_rec.dsply_mn_elcn_val;

636: ben_ecr_shd.g_old_rec.rt_mlt_cd;
637: End If;
638: If (p_rec.dsply_mn_elcn_val = hr_api.g_number) then
639: p_rec.dsply_mn_elcn_val :=
640: ben_ecr_shd.g_old_rec.dsply_mn_elcn_val;
641: End If;
642: If (p_rec.dsply_mx_elcn_val = hr_api.g_number) then
643: p_rec.dsply_mx_elcn_val :=
644: ben_ecr_shd.g_old_rec.dsply_mx_elcn_val;

Line 644: ben_ecr_shd.g_old_rec.dsply_mx_elcn_val;

640: ben_ecr_shd.g_old_rec.dsply_mn_elcn_val;
641: End If;
642: If (p_rec.dsply_mx_elcn_val = hr_api.g_number) then
643: p_rec.dsply_mx_elcn_val :=
644: ben_ecr_shd.g_old_rec.dsply_mx_elcn_val;
645: End If;
646: If (p_rec.entr_ann_val_flag = hr_api.g_varchar2) then
647: p_rec.entr_ann_val_flag :=
648: ben_ecr_shd.g_old_rec.entr_ann_val_flag;

Line 648: ben_ecr_shd.g_old_rec.entr_ann_val_flag;

644: ben_ecr_shd.g_old_rec.dsply_mx_elcn_val;
645: End If;
646: If (p_rec.entr_ann_val_flag = hr_api.g_varchar2) then
647: p_rec.entr_ann_val_flag :=
648: ben_ecr_shd.g_old_rec.entr_ann_val_flag;
649: End If;
650: If (p_rec.rt_strt_dt = hr_api.g_date) then
651: p_rec.rt_strt_dt :=
652: ben_ecr_shd.g_old_rec.rt_strt_dt;

Line 652: ben_ecr_shd.g_old_rec.rt_strt_dt;

648: ben_ecr_shd.g_old_rec.entr_ann_val_flag;
649: End If;
650: If (p_rec.rt_strt_dt = hr_api.g_date) then
651: p_rec.rt_strt_dt :=
652: ben_ecr_shd.g_old_rec.rt_strt_dt;
653: End If;
654: If (p_rec.rt_strt_dt_cd = hr_api.g_varchar2) then
655: p_rec.rt_strt_dt_cd :=
656: ben_ecr_shd.g_old_rec.rt_strt_dt_cd;

Line 656: ben_ecr_shd.g_old_rec.rt_strt_dt_cd;

652: ben_ecr_shd.g_old_rec.rt_strt_dt;
653: End If;
654: If (p_rec.rt_strt_dt_cd = hr_api.g_varchar2) then
655: p_rec.rt_strt_dt_cd :=
656: ben_ecr_shd.g_old_rec.rt_strt_dt_cd;
657: End If;
658: If (p_rec.rt_strt_dt_rl = hr_api.g_number) then
659: p_rec.rt_strt_dt_rl :=
660: ben_ecr_shd.g_old_rec.rt_strt_dt_rl;

Line 660: ben_ecr_shd.g_old_rec.rt_strt_dt_rl;

656: ben_ecr_shd.g_old_rec.rt_strt_dt_cd;
657: End If;
658: If (p_rec.rt_strt_dt_rl = hr_api.g_number) then
659: p_rec.rt_strt_dt_rl :=
660: ben_ecr_shd.g_old_rec.rt_strt_dt_rl;
661: End If;
662: If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
663: p_rec.rt_typ_cd :=
664: ben_ecr_shd.g_old_rec.rt_typ_cd;

Line 664: ben_ecr_shd.g_old_rec.rt_typ_cd;

660: ben_ecr_shd.g_old_rec.rt_strt_dt_rl;
661: End If;
662: If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
663: p_rec.rt_typ_cd :=
664: ben_ecr_shd.g_old_rec.rt_typ_cd;
665: End If;
666: If (p_rec.cvg_amt_calc_mthd_id = hr_api.g_number) then
667: p_rec.cvg_amt_calc_mthd_id :=
668: ben_ecr_shd.g_old_rec.cvg_amt_calc_mthd_id;

Line 668: ben_ecr_shd.g_old_rec.cvg_amt_calc_mthd_id;

664: ben_ecr_shd.g_old_rec.rt_typ_cd;
665: End If;
666: If (p_rec.cvg_amt_calc_mthd_id = hr_api.g_number) then
667: p_rec.cvg_amt_calc_mthd_id :=
668: ben_ecr_shd.g_old_rec.cvg_amt_calc_mthd_id;
669: End If;
670: If (p_rec.actl_prem_id = hr_api.g_number) then
671: p_rec.actl_prem_id :=
672: ben_ecr_shd.g_old_rec.actl_prem_id;

Line 672: ben_ecr_shd.g_old_rec.actl_prem_id;

668: ben_ecr_shd.g_old_rec.cvg_amt_calc_mthd_id;
669: End If;
670: If (p_rec.actl_prem_id = hr_api.g_number) then
671: p_rec.actl_prem_id :=
672: ben_ecr_shd.g_old_rec.actl_prem_id;
673: End If;
674: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
675: p_rec.comp_lvl_fctr_id :=
676: ben_ecr_shd.g_old_rec.comp_lvl_fctr_id;

Line 676: ben_ecr_shd.g_old_rec.comp_lvl_fctr_id;

672: ben_ecr_shd.g_old_rec.actl_prem_id;
673: End If;
674: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
675: p_rec.comp_lvl_fctr_id :=
676: ben_ecr_shd.g_old_rec.comp_lvl_fctr_id;
677: End If;
678: If (p_rec.ptd_comp_lvl_fctr_id = hr_api.g_number) then
679: p_rec.ptd_comp_lvl_fctr_id :=
680: ben_ecr_shd.g_old_rec.ptd_comp_lvl_fctr_id;

Line 680: ben_ecr_shd.g_old_rec.ptd_comp_lvl_fctr_id;

676: ben_ecr_shd.g_old_rec.comp_lvl_fctr_id;
677: End If;
678: If (p_rec.ptd_comp_lvl_fctr_id = hr_api.g_number) then
679: p_rec.ptd_comp_lvl_fctr_id :=
680: ben_ecr_shd.g_old_rec.ptd_comp_lvl_fctr_id;
681: End If;
682: If (p_rec.clm_comp_lvl_fctr_id = hr_api.g_number) then
683: p_rec.clm_comp_lvl_fctr_id :=
684: ben_ecr_shd.g_old_rec.clm_comp_lvl_fctr_id;

Line 684: ben_ecr_shd.g_old_rec.clm_comp_lvl_fctr_id;

680: ben_ecr_shd.g_old_rec.ptd_comp_lvl_fctr_id;
681: End If;
682: If (p_rec.clm_comp_lvl_fctr_id = hr_api.g_number) then
683: p_rec.clm_comp_lvl_fctr_id :=
684: ben_ecr_shd.g_old_rec.clm_comp_lvl_fctr_id;
685: End If;
686: --
687: hr_utility.set_location(' Leaving:'||l_proc, 10);
688: --

Line 695: (p_rec in out nocopy ben_ecr_shd.g_rec_type,

691: -- ----------------------------------------------------------------------------
692: -- |---------------------------------< upd >----------------------------------|
693: -- ----------------------------------------------------------------------------
694: Procedure upd
695: (p_rec in out nocopy ben_ecr_shd.g_rec_type,
696: p_effective_date in date) is
697: --
698: l_proc varchar2(72) := g_package||'upd';
699: --

Line 705: ben_ecr_shd.lck

701: hr_utility.set_location('Entering:'||l_proc, 5);
702: --
703: -- We must lock the row which we need to update.
704: --
705: ben_ecr_shd.lck
706: (p_rec.enrt_rt_id,
707: p_rec.object_version_number);
708: --
709: -- 1. During an update system defaults are used to determine if

Line 835: l_rec ben_ecr_shd.g_rec_type;

831: p_program_update_date in DATE DEFAULT hr_api.g_date,
832: p_object_version_number in out nocopy NUMBER
833: ) is
834: --
835: l_rec ben_ecr_shd.g_rec_type;
836: l_proc varchar2(72) := g_package||'upd';
837: --
838: Begin
839: hr_utility.set_location('Entering:'||l_proc, 5);

Line 845: ben_ecr_shd.convert_args

841: -- Call conversion function to turn arguments into the
842: -- l_rec structure.
843: --
844: l_rec :=
845: ben_ecr_shd.convert_args
846: (
847: p_enrt_rt_id,
848: p_ordr_num,
849: p_acty_typ_cd,