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_EPR_BUS dependencies on BEN_EPR_SHD

Line 46: l_api_updating := ben_epr_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_epr_shd.api_updating
47: (p_enrt_prem_id => p_enrt_prem_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_epr_shd.g_old_rec.enrt_prem_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_enrt_prem_id,hr_api.g_number)
52: <> ben_epr_shd.g_old_rec.enrt_prem_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_epr_shd.constraint_error('BEN_ENRT_PREM_PK');

Line 56: ben_epr_shd.constraint_error('BEN_ENRT_PREM_PK');

52: <> ben_epr_shd.g_old_rec.enrt_prem_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_epr_shd.constraint_error('BEN_ENRT_PREM_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_epr_shd.constraint_error('BEN_ENRT_PREM_PK');

62: if p_enrt_prem_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_epr_shd.constraint_error('BEN_ENRT_PREM_PK');
67: --
68: end if;
69: --
70: end if;

Line 123: l_api_updating := ben_epr_shd.api_updating

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

Line 129: <> nvl(ben_epr_shd.g_old_rec.actl_prem_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_actl_prem_id,hr_api.g_number)
129: <> nvl(ben_epr_shd.g_old_rec.actl_prem_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if actl_prem_id value exists in ben_actl_prem_f table
133: --

Line 144: ben_epr_shd.constraint_error('BEN_ENRT_PREM_DT1');

140: --
141: -- raise error as FK does not relate to PK in ben_actl_prem_f
142: -- table.
143: --
144: ben_epr_shd.constraint_error('BEN_ENRT_PREM_DT1');
145: --
146: end if;
147: --
148: close c1;

Line 198: l_api_updating := ben_epr_shd.api_updating

194: Begin
195: --
196: hr_utility.set_location('Entering:'||l_proc,5);
197: --
198: l_api_updating := ben_epr_shd.api_updating
199: (p_enrt_prem_id => p_enrt_prem_id,
200: p_object_version_number => p_object_version_number);
201: --
202: if (l_api_updating

Line 204: <> nvl(ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id,hr_api.g_number)

200: p_object_version_number => p_object_version_number);
201: --
202: if (l_api_updating
203: and nvl(p_elig_per_elctbl_chc_id,hr_api.g_number)
204: <> nvl(ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id,hr_api.g_number)
205: or not l_api_updating) and
206: p_elig_per_elctbl_chc_id is not null then
207: --
208: -- check if elig_per_elctbl_chc_id value exists in ben_elig_per_elctbl_chc table

Line 220: ben_epr_shd.constraint_error('BEN_ENRT_PREM_FK2');

216: --
217: -- raise error as FK does not relate to PK in ben_elig_per_elctbl_chc
218: -- table.
219: --
220: ben_epr_shd.constraint_error('BEN_ENRT_PREM_FK2');
221: --
222: end if;
223: --
224: close c1;

Line 274: l_api_updating := ben_epr_shd.api_updating

270: Begin
271: --
272: hr_utility.set_location('Entering:'||l_proc,5);
273: --
274: l_api_updating := ben_epr_shd.api_updating
275: (p_enrt_prem_id => p_enrt_prem_id,
276: p_object_version_number => p_object_version_number);
277: --
278: if (l_api_updating

Line 280: <> nvl(ben_epr_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)

276: p_object_version_number => p_object_version_number);
277: --
278: if (l_api_updating
279: and nvl(p_enrt_bnft_id,hr_api.g_number)
280: <> nvl(ben_epr_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)
281: or not l_api_updating) and
282: p_enrt_bnft_id is not null then
283: --
284: -- check if enrt_bnft_id value exists in ben_enrt_bnft table

Line 296: ben_epr_shd.constraint_error('BEN_ENRT_PREM_FK1');

292: --
293: -- raise error as FK does not relate to PK in ben_enrt_bnft
294: -- table.
295: --
296: ben_epr_shd.constraint_error('BEN_ENRT_PREM_FK1');
297: --
298: end if;
299: --
300: close c1;

Line 311: Procedure insert_validate(p_rec in ben_epr_shd.g_rec_type) is

307: --
308: -- ----------------------------------------------------------------------------
309: -- |---------------------------< insert_validate >----------------------------|
310: -- ----------------------------------------------------------------------------
311: Procedure insert_validate(p_rec in ben_epr_shd.g_rec_type) is
312: --
313: l_proc varchar2(72) := g_package||'insert_validate';
314: --
315: Begin

Line 343: Procedure update_validate(p_rec in ben_epr_shd.g_rec_type) is

339: --
340: -- ----------------------------------------------------------------------------
341: -- |---------------------------< update_validate >----------------------------|
342: -- ----------------------------------------------------------------------------
343: Procedure update_validate(p_rec in ben_epr_shd.g_rec_type) is
344: --
345: l_proc varchar2(72) := g_package||'update_validate';
346: --
347: Begin

Line 375: Procedure delete_validate(p_rec in ben_epr_shd.g_rec_type) is

371: --
372: -- ----------------------------------------------------------------------------
373: -- |---------------------------< delete_validate >----------------------------|
374: -- ----------------------------------------------------------------------------
375: Procedure delete_validate(p_rec in ben_epr_shd.g_rec_type) is
376: --
377: l_proc varchar2(72) := g_package||'delete_validate';
378: --
379: Begin