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_ESC_BUS dependencies on BEN_ESC_SHD

Line 48: l_api_updating := ben_esc_shd.api_updating

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

Line 55: <> ben_esc_shd.g_old_rec.elig_stdnt_stat_cvg_id) then

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

Line 59: ben_esc_shd.constraint_error('BEN_ELG_STDNT_CVG_PK');

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

Line 69: ben_esc_shd.constraint_error('BEN_ELG_STDNT_CVG_PK');

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

Line 117: l_api_updating := ben_esc_shd.api_updating

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

Line 124: <> nvl(ben_esc_shd.g_old_rec.stdnt_stat_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_stdnt_stat_cd
124: <> nvl(ben_esc_shd.g_old_rec.stdnt_stat_cd,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 195: l_api_updating := ben_esc_shd.api_updating

191: Begin
192: --
193: hr_utility.set_location('Entering:'||l_proc, 5);
194: --
195: l_api_updating := ben_esc_shd.api_updating
196: (p_elig_stdnt_stat_cvg_id => p_elig_stdnt_stat_cvg_id,
197: p_effective_date => p_effective_date,
198: p_object_version_number => p_object_version_number);
199: --

Line 202: <> ben_esc_shd.g_old_rec.cvg_thru_rl

198: p_object_version_number => p_object_version_number);
199: --
200: if (l_api_updating
201: and nvl(p_cvg_thru_rl,hr_api.g_number)
202: <> ben_esc_shd.g_old_rec.cvg_thru_rl
203: or not l_api_updating)
204: and p_cvg_thru_rl is not null then
205: --
206: -- check if value of formula rule is valid.

Line 271: l_api_updating := ben_esc_shd.api_updating

267: Begin
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: l_api_updating := ben_esc_shd.api_updating
272: (p_elig_stdnt_stat_cvg_id => p_elig_stdnt_stat_cvg_id,
273: p_effective_date => p_effective_date,
274: p_object_version_number => p_object_version_number);
275: --

Line 278: <> nvl(ben_esc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2)

274: p_object_version_number => p_object_version_number);
275: --
276: if (l_api_updating
277: and p_cvg_thru_cd
278: <> nvl(ben_esc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2)
279: or not l_api_updating)
280: and p_cvg_thru_cd is not null then
281: --
282: -- check if value of lookup falls within lookup type.

Line 349: l_api_updating := ben_esc_shd.api_updating

345: Begin
346: --
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: l_api_updating := ben_esc_shd.api_updating
350: (p_elig_stdnt_stat_cvg_id => p_elig_stdnt_stat_cvg_id,
351: p_effective_date => p_effective_date,
352: p_object_version_number => p_object_version_number);
353: --

Line 356: <> ben_esc_shd.g_old_rec.cvg_strt_rl

352: p_object_version_number => p_object_version_number);
353: --
354: if (l_api_updating
355: and nvl(p_cvg_strt_rl,hr_api.g_number)
356: <> ben_esc_shd.g_old_rec.cvg_strt_rl
357: or not l_api_updating)
358: and p_cvg_strt_rl is not null then
359: --
360: -- check if value of formula rule is valid.

Line 425: l_api_updating := ben_esc_shd.api_updating

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

Line 432: <> nvl(ben_esc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2)

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

Line 499: l_api_updating := ben_esc_shd.api_updating

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

Line 506: nvl(ben_esc_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_esc_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_esc_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
509: or not l_api_updating) then
510: --

Line 508: nvl(ben_esc_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_esc_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_esc_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_esc_shd.api_updating

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

Line 582: nvl(ben_esc_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_esc_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_esc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
585: or not l_api_updating) then
586:

Line 584: nvl(ben_esc_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_esc_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_esc_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 879: (p_rec in ben_esc_shd.g_rec_type,

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

Line 959: (p_rec in ben_esc_shd.g_rec_type,

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

Line 1046: (p_rec in ben_esc_shd.g_rec_type,

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