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_EEG_BUS dependencies on BEN_EEG_SHD

Line 48: l_api_updating := ben_eeg_shd.api_updating

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

Line 55: <> ben_eeg_shd.g_old_rec.elig_enrld_anthr_pgm_id) then

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

Line 59: ben_eeg_shd.constraint_error('BEN_ELIG_ENRLD_ANTHR_PGM_F_PK');

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

Line 69: ben_eeg_shd.constraint_error('BEN_ELIG_ENRLD_ANTHR_PGM_F_PK');

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

Line 142: l_api_updating := ben_eeg_shd.api_updating

138: Begin
139: --
140: hr_utility.set_location('Entering:'||l_proc,5);
141: --
142: l_api_updating := ben_eeg_shd.api_updating
143: (p_elig_enrld_anthr_pgm_id => p_elig_enrld_anthr_pgm_id,
144: p_effective_date => p_effective_date,
145: p_object_version_number => p_object_version_number);
146: --

Line 149: <> nvl(ben_eeg_shd.g_old_rec.pgm_id,hr_api.g_number)

145: p_object_version_number => p_object_version_number);
146: --
147: if (l_api_updating
148: and nvl(p_pgm_id,hr_api.g_number)
149: <> nvl(ben_eeg_shd.g_old_rec.pgm_id,hr_api.g_number)
150: or not l_api_updating) then
151: --
152: -- check if pgm_id value exists in the program table
153: open c1;

Line 163: ben_eeg_shd.constraint_error('BEN_ELIG_ENRLD_ANTHR_PGM_DT2');

159: --
160: -- raise error as FK does not relate to PK in the program
161: -- table.
162: --
163: ben_eeg_shd.constraint_error('BEN_ELIG_ENRLD_ANTHR_PGM_DT2');
164: --
165: end if;
166: --
167: close c1;

Line 227: l_api_updating := ben_eeg_shd.api_updating

223: Begin
224: --
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: --
227: l_api_updating := ben_eeg_shd.api_updating
228: (p_elig_enrld_anthr_pgm_id => p_elig_enrld_anthr_pgm_id,
229: p_effective_date => p_effective_date,
230: p_object_version_number => p_object_version_number);
231: --

Line 234: <> nvl(ben_eeg_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

230: p_object_version_number => p_object_version_number);
231: --
232: if (l_api_updating
233: and p_enrl_det_dt_cd
234: <> nvl(ben_eeg_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)
235: or not l_api_updating)
236: and p_enrl_det_dt_cd is not null then
237: --
238: -- check if value of lookup falls within lookup type.

Line 298: l_api_updating := ben_eeg_shd.api_updating

294: Begin
295: --
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: l_api_updating := ben_eeg_shd.api_updating
299: (p_elig_enrld_anthr_pgm_id => p_elig_enrld_anthr_pgm_id,
300: p_effective_date => p_effective_date,
301: p_object_version_number => p_object_version_number);
302: --

Line 305: <> nvl(ben_eeg_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

301: p_object_version_number => p_object_version_number);
302: --
303: if (l_api_updating
304: and p_excld_flag
305: <> nvl(ben_eeg_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
306: or not l_api_updating) then
307: --
308: -- check if value of lookup falls within lookup type.
309: --

Line 606: (p_rec in ben_eeg_shd.g_rec_type,

602: -- ----------------------------------------------------------------------------
603: -- |---------------------------< insert_validate >----------------------------|
604: -- ----------------------------------------------------------------------------
605: Procedure insert_validate
606: (p_rec in ben_eeg_shd.g_rec_type,
607: p_effective_date in date,
608: p_datetrack_mode in varchar2,
609: p_validation_start_date in date,
610: p_validation_end_date in date) is

Line 662: (p_rec in ben_eeg_shd.g_rec_type,

658: -- ----------------------------------------------------------------------------
659: -- |---------------------------< update_validate >----------------------------|
660: -- ----------------------------------------------------------------------------
661: Procedure update_validate
662: (p_rec in ben_eeg_shd.g_rec_type,
663: p_effective_date in date,
664: p_datetrack_mode in varchar2,
665: p_validation_start_date in date,
666: p_validation_end_date in date) is

Line 727: (p_rec in ben_eeg_shd.g_rec_type,

723: -- ----------------------------------------------------------------------------
724: -- |---------------------------< delete_validate >----------------------------|
725: -- ----------------------------------------------------------------------------
726: Procedure delete_validate
727: (p_rec in ben_eeg_shd.g_rec_type,
728: p_effective_date in date,
729: p_datetrack_mode in varchar2,
730: p_validation_start_date in date,
731: p_validation_end_date in date) is