eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ECR_BUS dependencies on BEN_ECR_SHD

Line 45: l_api_updating := ben_ecr_shd.api_updating

41: Begin
42: --
43: hr_utility.set_location('Entering:'||l_proc, 5);
44: --
45: l_api_updating := ben_ecr_shd.api_updating
46: (p_enrt_rt_id => p_enrt_rt_id,
47: p_object_version_number => p_object_version_number);
48: --
49: if (l_api_updating

Line 51: <> ben_ecr_shd.g_old_rec.enrt_rt_id) then

47: p_object_version_number => p_object_version_number);
48: --
49: if (l_api_updating
50: and nvl(p_enrt_rt_id,hr_api.g_number)
51: <> ben_ecr_shd.g_old_rec.enrt_rt_id) then
52: --
53: -- raise error as PK has changed
54: --
55: ben_ecr_shd.constraint_error('BEN_ENRT_RT_PK');

Line 55: ben_ecr_shd.constraint_error('BEN_ENRT_RT_PK');

51: <> ben_ecr_shd.g_old_rec.enrt_rt_id) then
52: --
53: -- raise error as PK has changed
54: --
55: ben_ecr_shd.constraint_error('BEN_ENRT_RT_PK');
56: --
57: elsif not l_api_updating then
58: --
59: -- check if PK is null

Line 65: ben_ecr_shd.constraint_error('BEN_ENRT_RT_PK');

61: if p_enrt_rt_id is not null then
62: --
63: -- raise error as PK is not null
64: --
65: ben_ecr_shd.constraint_error('BEN_ENRT_RT_PK');
66: --
67: end if;
68: --
69: end if;

Line 117: l_api_updating := ben_ecr_shd.api_updating

113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc,5);
116: --
117: l_api_updating := ben_ecr_shd.api_updating
118: (p_enrt_rt_id => p_enrt_rt_id,
119: p_object_version_number => p_object_version_number);
120: --
121: if (l_api_updating

Line 123: <> nvl(ben_ecr_shd.g_old_rec.elig_per_elctbl_chc_id,hr_api.g_number)

119: p_object_version_number => p_object_version_number);
120: --
121: if (l_api_updating
122: and nvl(p_elig_per_elctbl_chc_id,hr_api.g_number)
123: <> nvl(ben_ecr_shd.g_old_rec.elig_per_elctbl_chc_id,hr_api.g_number)
124: or not l_api_updating) and p_elig_per_elctbl_chc_id is not null then
125: --
126: -- check if elig_per_elctbl_chc_id value exists in
127: -- ben_elig_per_elctbl_chc table

Line 139: ben_ecr_shd.constraint_error('BEN_ENRT_RT_FK2');

135: --
136: -- raise error as FK does not relate to PK in ben_elig_per_elctbl_chc
137: -- table.
138: --
139: ben_ecr_shd.constraint_error('BEN_ENRT_RT_FK2');
140: --
141: end if;
142: --
143: close c1;

Line 193: l_api_updating := ben_ecr_shd.api_updating

189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := ben_ecr_shd.api_updating
194: (p_enrt_rt_id => p_enrt_rt_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating

Line 199: <> nvl(ben_ecr_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)

195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_enrt_bnft_id,hr_api.g_number)
199: <> nvl(ben_ecr_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)
200: or not l_api_updating) and p_enrt_bnft_id is not null then
201: --
202: -- check if enrt_bnft_id value exists in
203: -- ben_enrt_bnft table

Line 215: ben_ecr_shd.constraint_error('BEN_ENRT_RT_FK3');

211: --
212: -- raise error as FK does not relate to PK in ben_enrt_bnft
213: -- table.
214: --
215: ben_ecr_shd.constraint_error('BEN_ENRT_RT_FK3');
216: --
217: end if;
218: --
219: close c1;

Line 266: l_api_updating := ben_ecr_shd.api_updating

262: Begin
263: --
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: l_api_updating := ben_ecr_shd.api_updating
267: (p_enrt_rt_id => p_enrt_rt_id,
268: p_object_version_number => p_object_version_number);
269: --
270: if (l_api_updating

Line 272: <> ben_ecr_shd.g_old_rec.rt_strt_dt_rl

268: p_object_version_number => p_object_version_number);
269: --
270: if (l_api_updating
271: and nvl(p_rt_strt_dt_rl,hr_api.g_number)
272: <> ben_ecr_shd.g_old_rec.rt_strt_dt_rl
273: or not l_api_updating)
274: and p_rt_strt_dt_rl is not null then
275: --
276: -- check if value of formula rule is valid.

Line 353: l_api_updating := ben_ecr_shd.api_updating

349: Begin
350: --
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: l_api_updating := ben_ecr_shd.api_updating
354: (p_enrt_rt_id => p_enrt_rt_id,
355: p_object_version_number => p_object_version_number);
356: --
357: if (l_api_updating

Line 359: <> nvl(ben_ecr_shd.g_old_rec.entr_ann_val_flag,hr_api.g_varchar2)

355: p_object_version_number => p_object_version_number);
356: --
357: if (l_api_updating
358: and p_entr_ann_val_flag
359: <> nvl(ben_ecr_shd.g_old_rec.entr_ann_val_flag,hr_api.g_varchar2)
360: or not l_api_updating) then
361: --
362: -- check if value of lookup falls within lookup type.
363: --

Line 383: <> nvl(ben_ecr_shd.g_old_rec.ctfn_rqd_flag,hr_api.g_varchar2)

379: end if;
380: --
381: if (l_api_updating
382: and p_ctfn_rqd_flag
383: <> nvl(ben_ecr_shd.g_old_rec.ctfn_rqd_flag,hr_api.g_varchar2)
384: or not l_api_updating) then
385: --
386: -- check if value of lookup falls within lookup type.
387: --

Line 407: <> nvl(ben_ecr_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

403: end if;
404: --
405: if (l_api_updating
406: and p_dflt_flag
407: <> nvl(ben_ecr_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
408: or not l_api_updating) then
409: --
410: -- check if value of lookup falls within lookup type.
411: --

Line 431: <> nvl(ben_ecr_shd.g_old_rec.dflt_pndg_ctfn_flag,hr_api.g_varchar2)

427: end if;
428: --
429: if (l_api_updating
430: and p_dflt_pndg_ctfn_flag
431: <> nvl(ben_ecr_shd.g_old_rec.dflt_pndg_ctfn_flag,hr_api.g_varchar2)
432: or not l_api_updating) then
433: --
434: -- check if value of lookup falls within lookup type.
435: --

Line 455: <> nvl(ben_ecr_shd.g_old_rec.dsply_on_enrt_flag,hr_api.g_varchar2)

451: end if;
452: --
453: if (l_api_updating
454: and p_dsply_on_enrt_flag
455: <> nvl(ben_ecr_shd.g_old_rec.dsply_on_enrt_flag,hr_api.g_varchar2)
456: or not l_api_updating) then
457: --
458: -- check if value of lookup falls within lookup type.
459: --

Line 479: <> nvl(ben_ecr_shd.g_old_rec.use_to_calc_net_flx_cr_flag,hr_api.g_varchar2)

475: end if;
476: --
477: if (l_api_updating
478: and p_use_to_calc_net_flx_cr_flag
479: <> nvl(ben_ecr_shd.g_old_rec.use_to_calc_net_flx_cr_flag,hr_api.g_varchar2)
480: or not l_api_updating) then
481: --
482: -- check if value of lookup falls within lookup type.
483: --

Line 503: <> nvl(ben_ecr_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)

499: end if;
500: --
501: if (l_api_updating
502: and p_entr_val_at_enrt_flag
503: <> nvl(ben_ecr_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)
504: or not l_api_updating) then
505: --
506: -- check if value of lookup falls within lookup type.
507: --

Line 527: <> nvl(ben_ecr_shd.g_old_rec.asn_on_enrt_flag,hr_api.g_varchar2)

523: end if;
524: --
525: if (l_api_updating
526: and p_asn_on_enrt_flag
527: <> nvl(ben_ecr_shd.g_old_rec.asn_on_enrt_flag,hr_api.g_varchar2)
528: or not l_api_updating) then
529: --
530: -- check if value of lookup falls within lookup type.
531: --

Line 551: <> nvl(ben_ecr_shd.g_old_rec.rl_crs_only_flag,hr_api.g_varchar2)

547: end if;
548: --
549: if (l_api_updating
550: and p_rl_crs_only_flag
551: <> nvl(ben_ecr_shd.g_old_rec.rl_crs_only_flag,hr_api.g_varchar2)
552: or not l_api_updating) then
553: --
554: -- check if value of lookup falls within lookup type.
555: --

Line 621: l_api_updating := ben_ecr_shd.api_updating

617: Begin
618: --
619: hr_utility.set_location('Entering:'||l_proc, 5);
620: --
621: l_api_updating := ben_ecr_shd.api_updating
622: (p_enrt_rt_id => p_enrt_rt_id,
623: p_object_version_number => p_object_version_number);
624: --
625: if (l_api_updating

Line 627: <> nvl(ben_ecr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)

623: p_object_version_number => p_object_version_number);
624: --
625: if (l_api_updating
626: and p_acty_typ_cd
627: <> nvl(ben_ecr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)
628: or not l_api_updating) then
629: --
630: -- check if value of lookup falls within lookup type.
631: --

Line 650: <> nvl(ben_ecr_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)

646: end if;
647: --
648: if (l_api_updating
649: and p_tx_typ_cd
650: <> nvl(ben_ecr_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)
651: or not l_api_updating) then
652: --
653: -- check if value of lookup falls within lookup type.
654: --

Line 673: <> nvl(ben_ecr_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)

669: end if;
670: --
671: if (l_api_updating
672: and p_nnmntry_uom
673: <> nvl(ben_ecr_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)
674: or not l_api_updating)
675: and p_nnmntry_uom is not null then
676: --
677: -- check if value of lookup falls within lookup type.

Line 697: <> nvl(ben_ecr_shd.g_old_rec.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)

693: end if;
694: --
695: if (l_api_updating
696: and p_cmcd_acty_ref_perd_cd
697: <> nvl(ben_ecr_shd.g_old_rec.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)
698: or not l_api_updating)
699: and p_cmcd_acty_ref_perd_cd is not null then
700: --
701: -- check if value of lookup falls within lookup type.

Line 726: Procedure insert_validate(p_rec in ben_ecr_shd.g_rec_type,

722:
723: -- ----------------------------------------------------------------------------
724: -- |---------------------------< insert_validate >----------------------------|
725: -- ----------------------------------------------------------------------------
726: Procedure insert_validate(p_rec in ben_ecr_shd.g_rec_type,
727: p_effective_date in date) is
728: --
729: l_proc varchar2(72) := g_package||'insert_validate';
730: --

Line 799: Procedure update_validate(p_rec in ben_ecr_shd.g_rec_type,

795: --
796: -- ----------------------------------------------------------------------------
797: -- |---------------------------< update_validate >----------------------------|
798: -- ----------------------------------------------------------------------------
799: Procedure update_validate(p_rec in ben_ecr_shd.g_rec_type,
800: p_effective_date in date) is
801: --
802: l_proc varchar2(72) := g_package||'update_validate';
803: --

Line 872: Procedure delete_validate(p_rec in ben_ecr_shd.g_rec_type,

868: --
869: -- ----------------------------------------------------------------------------
870: -- |---------------------------< delete_validate >----------------------------|
871: -- ----------------------------------------------------------------------------
872: Procedure delete_validate(p_rec in ben_ecr_shd.g_rec_type,
873: p_effective_date in date) is
874: --
875: l_proc varchar2(72) := g_package||'delete_validate';
876: --