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_EMS_BUS dependencies on BEN_EMS_SHD

Line 48: l_api_updating := ben_ems_shd.api_updating

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

Line 55: <> ben_ems_shd.g_old_rec.elig_mrtl_stat_cvg_id) then

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

Line 59: ben_ems_shd.constraint_error('BEN_ELG_MRTL_CVG_PK');

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

Line 69: ben_ems_shd.constraint_error('BEN_ELG_MRTL_CVG_PK');

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

Line 126: l_api_updating := ben_ems_shd.api_updating

122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --
126: l_api_updating := ben_ems_shd.api_updating
127: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
128: p_effective_date => p_effective_date,
129: p_object_version_number => p_object_version_number);
130: --

Line 133: <> ben_ems_shd.g_old_rec.cvg_thru_rl

129: p_object_version_number => p_object_version_number);
130: --
131: if (l_api_updating
132: and nvl(p_cvg_thru_rl,hr_api.g_number)
133: <> ben_ems_shd.g_old_rec.cvg_thru_rl
134: or not l_api_updating)
135: and p_cvg_thru_rl is not null then
136: --
137: -- check if value of formula rule is valid.

Line 202: l_api_updating := ben_ems_shd.api_updating

198: Begin
199: --
200: hr_utility.set_location('Entering:'||l_proc, 5);
201: --
202: l_api_updating := ben_ems_shd.api_updating
203: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
204: p_effective_date => p_effective_date,
205: p_object_version_number => p_object_version_number);
206: --

Line 209: <> nvl(ben_ems_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2)

205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and p_cvg_thru_cd
209: <> nvl(ben_ems_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2)
210: or not l_api_updating)
211: and p_cvg_thru_cd is not null then
212: --
213: -- check if value of lookup falls within lookup type.

Line 280: l_api_updating := ben_ems_shd.api_updating

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

Line 287: <> ben_ems_shd.g_old_rec.cvg_strt_rl

283: p_object_version_number => p_object_version_number);
284: --
285: if (l_api_updating
286: and nvl(p_cvg_strt_rl,hr_api.g_number)
287: <> ben_ems_shd.g_old_rec.cvg_strt_rl
288: or not l_api_updating)
289: and p_cvg_strt_rl is not null then
290: --
291: -- check if value of formula rule is valid.

Line 356: l_api_updating := ben_ems_shd.api_updating

352: Begin
353: --
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: l_api_updating := ben_ems_shd.api_updating
357: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
358: p_effective_date => p_effective_date,
359: p_object_version_number => p_object_version_number);
360: --

Line 363: <> nvl(ben_ems_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2)

359: p_object_version_number => p_object_version_number);
360: --
361: if (l_api_updating
362: and p_cvg_strt_cd
363: <> nvl(ben_ems_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2)
364: or not l_api_updating)
365: and p_cvg_strt_cd is not null then
366: --
367: -- check if value of lookup falls within lookup type.

Line 425: l_api_updating := ben_ems_shd.api_updating

421: Begin
422: --
423: hr_utility.set_location('Entering:'||l_proc, 5);
424: --
425: l_api_updating := ben_ems_shd.api_updating
426: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
427: p_effective_date => p_effective_date,
428: p_object_version_number => p_object_version_number);
429: --

Line 432: <> nvl(ben_ems_shd.g_old_rec.mrtl_stat_cd,hr_api.g_varchar2)

428: p_object_version_number => p_object_version_number);
429: --
430: if (l_api_updating
431: and p_mrtl_stat_cd
432: <> nvl(ben_ems_shd.g_old_rec.mrtl_stat_cd,hr_api.g_varchar2)
433: or not l_api_updating) then
434: --
435: -- check if value of lookup falls within lookup type.
436: --

Line 499: l_api_updating := ben_ems_shd.api_updating

495: Begin
496: --
497: hr_utility.set_location('Entering:'||l_proc, 5);
498: --
499: l_api_updating := ben_ems_shd.api_updating
500: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
501: p_effective_date => p_effective_date,
502: p_object_version_number => p_object_version_number);
503: --

Line 506: nvl(ben_ems_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or

502: p_object_version_number => p_object_version_number);
503: --
504: if (l_api_updating
505: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
506: nvl(ben_ems_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
507: nvl(p_cvg_strt_rl, hr_api.g_number) <>
508: nvl(ben_ems_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
509: or not l_api_updating) then
510: --

Line 508: nvl(ben_ems_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))

504: if (l_api_updating
505: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
506: nvl(ben_ems_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
507: nvl(p_cvg_strt_rl, hr_api.g_number) <>
508: nvl(ben_ems_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
509: or not l_api_updating) then
510: --
511: -- check dependency of Code and Rule.
512: --

Line 575: l_api_updating := ben_ems_shd.api_updating

571: Begin
572: --
573: hr_utility.set_location('Entering:'||l_proc, 5);
574: --
575: l_api_updating := ben_ems_shd.api_updating
576: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
577: p_effective_date => p_effective_date,
578: p_object_version_number => p_object_version_number);
579: --

Line 582: nvl(ben_ems_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or

578: p_object_version_number => p_object_version_number);
579: --
580: if (l_api_updating
581: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
582: nvl(ben_ems_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
583: nvl(p_cvg_thru_rl, hr_api.g_number) <>
584: nvl(ben_ems_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
585: or not l_api_updating) then
586:

Line 584: nvl(ben_ems_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))

580: if (l_api_updating
581: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
582: nvl(ben_ems_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
583: nvl(p_cvg_thru_rl, hr_api.g_number) <>
584: nvl(ben_ems_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
585: or not l_api_updating) then
586:
587: --
588: -- check dependency of Code and Rule.

Line 878: (p_rec in ben_ems_shd.g_rec_type,

874: -- ----------------------------------------------------------------------------
875: -- |---------------------------< insert_validate >----------------------------|
876: -- ----------------------------------------------------------------------------
877: Procedure insert_validate
878: (p_rec in ben_ems_shd.g_rec_type,
879: p_effective_date in date,
880: p_datetrack_mode in varchar2,
881: p_validation_start_date in date,
882: p_validation_end_date in date) is

Line 958: (p_rec in ben_ems_shd.g_rec_type,

954: -- ----------------------------------------------------------------------------
955: -- |---------------------------< update_validate >----------------------------|
956: -- ----------------------------------------------------------------------------
957: Procedure update_validate
958: (p_rec in ben_ems_shd.g_rec_type,
959: p_effective_date in date,
960: p_datetrack_mode in varchar2,
961: p_validation_start_date in date,
962: p_validation_end_date in date) is

Line 1045: (p_rec in ben_ems_shd.g_rec_type,

1041: -- ----------------------------------------------------------------------------
1042: -- |---------------------------< delete_validate >----------------------------|
1043: -- ----------------------------------------------------------------------------
1044: Procedure delete_validate
1045: (p_rec in ben_ems_shd.g_rec_type,
1046: p_effective_date in date,
1047: p_datetrack_mode in varchar2,
1048: p_validation_start_date in date,
1049: p_validation_end_date in date) is