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_EHC_BUS dependencies on BEN_EHC_SHD

Line 48: l_api_updating := ben_ehc_shd.api_updating

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

Line 55: <> ben_ehc_shd.g_old_rec.ELIG_HLTH_CVG_PRTE_id) then

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

Line 59: ben_ehc_shd.constraint_error('BEN_ELIG_HLTH_CVG_PRTE_PK');

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

Line 69: ben_ehc_shd.constraint_error('BEN_ELIG_HLTH_CVG_PRTE_PK');

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

Line 131: l_api_updating := ben_ehc_shd.api_updating

127: hr_api.mandatory_arg_error(p_api_name => l_proc,
128: p_argument => 'pl_typ_opt_typ_id',
129: p_argument_value => p_pl_typ_opt_typ_id);
130:
131: l_api_updating := ben_ehc_shd.api_updating
132: (p_ELIG_HLTH_CVG_PRTE_id => p_ELIG_HLTH_CVG_PRTE_id,
133: p_effective_date => p_effective_date,
134: p_object_version_number => p_object_version_number);
135: --

Line 138: <> nvl(ben_ehc_shd.g_old_rec.pl_typ_opt_typ_id,hr_api.g_number)

134: p_object_version_number => p_object_version_number);
135: --
136: if (l_api_updating
137: and nvl(p_pl_typ_opt_typ_id,hr_api.g_number)
138: <> nvl(ben_ehc_shd.g_old_rec.pl_typ_opt_typ_id,hr_api.g_number)
139: or not l_api_updating)
140: and p_pl_typ_opt_typ_id is not null then
141: --
142: -- check if pl_typ_opt_typ_id value exists in

Line 155: ben_ehc_shd.constraint_error('BEN_ELIG_HLTH_CVG_PRTE_F_FK1');

151: --
152: -- raise error as FK does not relate to PK in
153: -- ben_pl_typ_opt_typ_f table.
154: --
155: ben_ehc_shd.constraint_error('BEN_ELIG_HLTH_CVG_PRTE_F_FK1');
156: --
157: end if;
158: --
159: close c1;

Line 219: l_api_updating := ben_ehc_shd.api_updating

215: hr_api.mandatory_arg_error(p_api_name => l_proc,
216: p_argument => 'oipl_id',
217: p_argument_value => p_oipl_id);
218:
219: l_api_updating := ben_ehc_shd.api_updating
220: (p_ELIG_HLTH_CVG_PRTE_id => p_ELIG_HLTH_CVG_PRTE_id,
221: p_effective_date => p_effective_date,
222: p_object_version_number => p_object_version_number);
223: --

Line 226: <> nvl(ben_ehc_shd.g_old_rec.oipl_id,hr_api.g_number)

222: p_object_version_number => p_object_version_number);
223: --
224: if (l_api_updating
225: and nvl(p_oipl_id,hr_api.g_number)
226: <> nvl(ben_ehc_shd.g_old_rec.oipl_id,hr_api.g_number)
227: or not l_api_updating)
228: and p_oipl_id is not null then
229: --
230: -- check if oipl_id value exists in

Line 243: ben_ehc_shd.constraint_error('BEN_ELIG_HLTH_CVG_PRTE_F_FK2');

239: --
240: -- raise error as FK does not relate to PK in
241: -- ben_oipl_f table.
242: --
243: ben_ehc_shd.constraint_error('BEN_ELIG_HLTH_CVG_PRTE_F_FK2');
244: --
245: end if;
246: --
247: close c1;

Line 293: l_api_updating := ben_ehc_shd.api_updating

289: Begin
290: --
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: l_api_updating := ben_ehc_shd.api_updating
294: (p_ELIG_HLTH_CVG_PRTE_id => p_ELIG_HLTH_CVG_PRTE_id,
295: p_effective_date => p_effective_date,
296: p_object_version_number => p_object_version_number);
297: --

Line 300: <> nvl(ben_ehc_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

296: p_object_version_number => p_object_version_number);
297: --
298: if (l_api_updating
299: and p_excld_flag
300: <> nvl(ben_ehc_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
301: or not l_api_updating) then
302: --
303: -- check if value of lookup falls within lookup type.
304: --

Line 587: (p_rec in ben_ehc_shd.g_rec_type,

583: -- ----------------------------------------------------------------------------
584: -- |---------------------------< insert_validate >----------------------------|
585: -- ----------------------------------------------------------------------------
586: Procedure insert_validate
587: (p_rec in ben_ehc_shd.g_rec_type,
588: p_effective_date in date,
589: p_datetrack_mode in varchar2,
590: p_validation_start_date in date,
591: p_validation_end_date in date) is

Line 640: (p_rec in ben_ehc_shd.g_rec_type,

636: -- ----------------------------------------------------------------------------
637: -- |---------------------------< update_validate >----------------------------|
638: -- ----------------------------------------------------------------------------
639: Procedure update_validate
640: (p_rec in ben_ehc_shd.g_rec_type,
641: p_effective_date in date,
642: p_datetrack_mode in varchar2,
643: p_validation_start_date in date,
644: p_validation_end_date in date) is

Line 702: (p_rec in ben_ehc_shd.g_rec_type,

698: -- ----------------------------------------------------------------------------
699: -- |---------------------------< delete_validate >----------------------------|
700: -- ----------------------------------------------------------------------------
701: Procedure delete_validate
702: (p_rec in ben_ehc_shd.g_rec_type,
703: p_effective_date in date,
704: p_datetrack_mode in varchar2,
705: p_validation_start_date in date,
706: p_validation_end_date in date) is