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_EAC_BUS dependencies on BEN_EAC_SHD

Line 48: l_api_updating := ben_eac_shd.api_updating

44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_eac_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_age_cvg_id => p_elig_age_cvg_id,
51: p_object_version_number => p_object_version_number);
52: --

Line 55: <> ben_eac_shd.g_old_rec.elig_age_cvg_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_elig_age_cvg_id,hr_api.g_number)
55: <> ben_eac_shd.g_old_rec.elig_age_cvg_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_eac_shd.constraint_error('BEN_ELIG_AGE_CVG_PK');

Line 59: ben_eac_shd.constraint_error('BEN_ELIG_AGE_CVG_PK');

55: <> ben_eac_shd.g_old_rec.elig_age_cvg_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_eac_shd.constraint_error('BEN_ELIG_AGE_CVG_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_eac_shd.constraint_error('BEN_ELIG_AGE_CVG_PK');

65: if p_elig_age_cvg_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_eac_shd.constraint_error('BEN_ELIG_AGE_CVG_PK');
70: --
71: end if;
72: --
73: end if;

Line 123: l_api_updating := ben_eac_shd.api_updating

119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_eac_shd.api_updating
124: (p_elig_age_cvg_id => p_elig_age_cvg_id,
125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --

Line 130: <> nvl(ben_eac_shd.g_old_rec.age_fctr_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_age_fctr_id,hr_api.g_number)
130: <> nvl(ben_eac_shd.g_old_rec.age_fctr_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_age_fctr_id is not null then
133: --
134: -- check if age_fctr_id value exists in ben_age_fctr table

Line 146: ben_eac_shd.constraint_error('BEN_ELIG_AGE_CVG_FK2');

142: --
143: -- raise error as FK does not relate to PK in ben_age_fctr
144: -- table.
145: --
146: ben_eac_shd.constraint_error('BEN_ELIG_AGE_CVG_FK2');
147: --
148: end if;
149: --
150: close c1;

Line 205: l_api_updating := ben_eac_shd.api_updating

201: Begin
202: --
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: --
205: l_api_updating := ben_eac_shd.api_updating
206: (p_elig_age_cvg_id => p_elig_age_cvg_id,
207: p_effective_date => p_effective_date,
208: p_object_version_number => p_object_version_number);
209: --

Line 212: <> ben_eac_shd.g_old_rec.cvg_thru_rl

208: p_object_version_number => p_object_version_number);
209: --
210: if (l_api_updating
211: and nvl(p_cvg_thru_rl,hr_api.g_number)
212: <> ben_eac_shd.g_old_rec.cvg_thru_rl
213: or not l_api_updating)
214: and p_cvg_thru_rl is not null then
215: --
216: -- check if value of formula rule is valid.

Line 281: l_api_updating := ben_eac_shd.api_updating

277: Begin
278: --
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: l_api_updating := ben_eac_shd.api_updating
282: (p_elig_age_cvg_id => p_elig_age_cvg_id,
283: p_effective_date => p_effective_date,
284: p_object_version_number => p_object_version_number);
285: --

Line 288: <> nvl(ben_eac_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2)

284: p_object_version_number => p_object_version_number);
285: --
286: if (l_api_updating
287: and p_cvg_thru_cd
288: <> nvl(ben_eac_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2)
289: or not l_api_updating)
290: and p_cvg_thru_cd is not null then
291: --
292: -- check if value of lookup falls within lookup type.

Line 359: l_api_updating := ben_eac_shd.api_updating

355: Begin
356: --
357: hr_utility.set_location('Entering:'||l_proc, 5);
358: --
359: l_api_updating := ben_eac_shd.api_updating
360: (p_elig_age_cvg_id => p_elig_age_cvg_id,
361: p_effective_date => p_effective_date,
362: p_object_version_number => p_object_version_number);
363: --

Line 366: <> ben_eac_shd.g_old_rec.cvg_strt_rl

362: p_object_version_number => p_object_version_number);
363: --
364: if (l_api_updating
365: and nvl(p_cvg_strt_rl,hr_api.g_number)
366: <> ben_eac_shd.g_old_rec.cvg_strt_rl
367: or not l_api_updating)
368: and p_cvg_strt_rl is not null then
369: --
370: -- check if value of formula rule is valid.

Line 435: l_api_updating := ben_eac_shd.api_updating

431: Begin
432: --
433: hr_utility.set_location('Entering:'||l_proc, 5);
434: --
435: l_api_updating := ben_eac_shd.api_updating
436: (p_elig_age_cvg_id => p_elig_age_cvg_id,
437: p_effective_date => p_effective_date,
438: p_object_version_number => p_object_version_number);
439: --

Line 442: <> nvl(ben_eac_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2)

438: p_object_version_number => p_object_version_number);
439: --
440: if (l_api_updating
441: and p_cvg_strt_cd
442: <> nvl(ben_eac_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2)
443: or not l_api_updating)
444: and p_cvg_strt_cd is not null then
445: --
446: -- check if value of lookup falls within lookup type.

Line 509: l_api_updating := ben_eac_shd.api_updating

505: Begin
506: --
507: hr_utility.set_location('Entering:'||l_proc, 5);
508: --
509: l_api_updating := ben_eac_shd.api_updating
510: (p_elig_age_cvg_id => p_elig_age_cvg_id,
511: p_effective_date => p_effective_date,
512: p_object_version_number => p_object_version_number);
513: --

Line 516: nvl(ben_eac_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or

512: p_object_version_number => p_object_version_number);
513: --
514: if (l_api_updating
515: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
516: nvl(ben_eac_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
517: nvl(p_cvg_strt_rl, hr_api.g_number) <>
518: nvl(ben_eac_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
519: or not l_api_updating) then
520: --

Line 518: nvl(ben_eac_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))

514: if (l_api_updating
515: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
516: nvl(ben_eac_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
517: nvl(p_cvg_strt_rl, hr_api.g_number) <>
518: nvl(ben_eac_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
519: or not l_api_updating) then
520: --
521: -- check dependency of Code and Rule.
522: --

Line 585: l_api_updating := ben_eac_shd.api_updating

581: Begin
582: --
583: hr_utility.set_location('Entering:'||l_proc, 5);
584: --
585: l_api_updating := ben_eac_shd.api_updating
586: (p_elig_age_cvg_id => p_elig_age_cvg_id,
587: p_effective_date => p_effective_date,
588: p_object_version_number => p_object_version_number);
589: --

Line 592: nvl(ben_eac_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or

588: p_object_version_number => p_object_version_number);
589: --
590: if (l_api_updating
591: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
592: nvl(ben_eac_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
593: nvl(p_cvg_thru_rl, hr_api.g_number) <>
594: nvl(ben_eac_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
595: or not l_api_updating) then
596:

Line 594: nvl(ben_eac_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))

590: if (l_api_updating
591: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
592: nvl(ben_eac_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
593: nvl(p_cvg_thru_rl, hr_api.g_number) <>
594: nvl(ben_eac_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
595: or not l_api_updating) then
596:
597: --
598: -- check dependency of Code and Rule.

Line 890: (p_rec in ben_eac_shd.g_rec_type,

886: -- ----------------------------------------------------------------------------
887: -- |---------------------------< insert_validate >----------------------------|
888: -- ----------------------------------------------------------------------------
889: Procedure insert_validate
890: (p_rec in ben_eac_shd.g_rec_type,
891: p_effective_date in date,
892: p_datetrack_mode in varchar2,
893: p_validation_start_date in date,
894: p_validation_end_date in date) is

Line 970: (p_rec in ben_eac_shd.g_rec_type,

966: -- ----------------------------------------------------------------------------
967: -- |---------------------------< update_validate >----------------------------|
968: -- ----------------------------------------------------------------------------
969: Procedure update_validate
970: (p_rec in ben_eac_shd.g_rec_type,
971: p_effective_date in date,
972: p_datetrack_mode in varchar2,
973: p_validation_start_date in date,
974: p_validation_end_date in date) is

Line 1057: (p_rec in ben_eac_shd.g_rec_type,

1053: -- ----------------------------------------------------------------------------
1054: -- |---------------------------< delete_validate >----------------------------|
1055: -- ----------------------------------------------------------------------------
1056: Procedure delete_validate
1057: (p_rec in ben_eac_shd.g_rec_type,
1058: p_effective_date in date,
1059: p_datetrack_mode in varchar2,
1060: p_validation_start_date in date,
1061: p_validation_end_date in date) is