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_EGD_BUS dependencies on BEN_EGD_SHD

Line 46: l_api_updating := ben_egd_shd.api_updating

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

Line 52: <> ben_egd_shd.g_old_rec.elig_dpnt_id) then

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

Line 56: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_PK');

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

Line 66: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_PK');

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

Line 123: l_api_updating := ben_egd_shd.api_updating

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

Line 129: <> nvl(ben_egd_shd.g_old_rec.elig_per_opt_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_elig_per_opt_id,hr_api.g_number)
129: <> nvl(ben_egd_shd.g_old_rec.elig_per_opt_id,hr_api.g_number)
130: or not l_api_updating)
131: and p_elig_per_opt_id is not null then
132: --
133: -- check if elig_per_opt_id value exists in ben_elig_per_opt_f table

Line 145: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT1');

141: --
142: -- raise error as FK does not relate to PK in ben_elig_per_opt_f
143: -- table.
144: --
145: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT1');
146: --
147: end if;
148: --
149: close c1;

Line 204: l_api_updating := ben_egd_shd.api_updating

200: Begin
201: --
202: hr_utility.set_location('Entering:'||l_proc,5);
203: --
204: l_api_updating := ben_egd_shd.api_updating
205: (p_elig_dpnt_id => p_elig_dpnt_id,
206: p_object_version_number => p_object_version_number);
207: --
208: if (l_api_updating

Line 210: <> nvl(ben_egd_shd.g_old_rec.elig_per_id,hr_api.g_number)

206: p_object_version_number => p_object_version_number);
207: --
208: if (l_api_updating
209: and nvl(p_elig_per_id,hr_api.g_number)
210: <> nvl(ben_egd_shd.g_old_rec.elig_per_id,hr_api.g_number)
211: or not l_api_updating)
212: and p_elig_per_id is not null then
213: --
214: -- check if elig_per_id value exists in ben_elig_per_f table

Line 226: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT2');

222: --
223: -- raise error as FK does not relate to PK in ben_elig_per_f
224: -- table.
225: --
226: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT2');
227: --
228: end if;
229: --
230: close c1;

Line 285: l_api_updating := ben_egd_shd.api_updating

281: Begin
282: --
283: hr_utility.set_location('Entering:'||l_proc,5);
284: --
285: l_api_updating := ben_egd_shd.api_updating
286: (p_elig_dpnt_id => p_elig_dpnt_id,
287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating

Line 291: <> nvl(ben_egd_shd.g_old_rec.dpnt_person_id,hr_api.g_number)

287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and nvl(p_dpnt_person_id,hr_api.g_number)
291: <> nvl(ben_egd_shd.g_old_rec.dpnt_person_id,hr_api.g_number)
292: or not l_api_updating) then
293: --
294: -- check if person_id value exists in per_all_people_f table
295: --

Line 306: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT4');

302: --
303: -- raise error as FK does not relate to PK in per_all_people_f
304: -- table.
305: --
306: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT4');
307: --
308: end if;
309: --
310: close c1;

Line 368: l_api_updating := ben_egd_shd.api_updating

364: Begin
365: --
366: hr_utility.set_location('Entering:'||l_proc,5);
367: --
368: l_api_updating := ben_egd_shd.api_updating
369: (p_elig_dpnt_id => p_elig_dpnt_id,
370: p_object_version_number => p_object_version_number);
371: --
372: if (l_api_updating

Line 374: <> nvl(ben_egd_shd.g_old_rec.per_in_ler_id,hr_api.g_number)

370: p_object_version_number => p_object_version_number);
371: --
372: if (l_api_updating
373: and nvl(p_per_in_ler_id,hr_api.g_number)
374: <> nvl(ben_egd_shd.g_old_rec.per_in_ler_id,hr_api.g_number)
375: or not l_api_updating) and
376: p_per_in_ler_id is not null then
377: --
378: -- check if per_in_ler_id value exists in ben_per_in_ler table

Line 390: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_FK2');

386: --
387: -- raise error as FK does not relate to PK in ben_per_in_ler
388: -- table.
389: --
390: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_FK2');
391: --
392: end if;
393: --
394: close c1;

Line 440: l_api_updating := ben_egd_shd.api_updating

436: Begin
437: --
438: hr_utility.set_location('Entering:'||l_proc, 5);
439: --
440: l_api_updating := ben_egd_shd.api_updating
441: (p_elig_dpnt_id => p_elig_dpnt_id,
442: p_object_version_number => p_object_version_number);
443: --
444: if (l_api_updating

Line 446: <> nvl(ben_egd_shd.g_old_rec.dpnt_inelig_flag,hr_api.g_varchar2)

442: p_object_version_number => p_object_version_number);
443: --
444: if (l_api_updating
445: and p_dpnt_inelig_flag
446: <> nvl(ben_egd_shd.g_old_rec.dpnt_inelig_flag,hr_api.g_varchar2)
447: or not l_api_updating) then
448: --
449: -- check if value of lookup falls within lookup type.
450: --

Line 510: l_api_updating := ben_egd_shd.api_updating

506: Begin
507: --
508: hr_utility.set_location('Entering:'||l_proc, 5);
509: --
510: l_api_updating := ben_egd_shd.api_updating
511: (p_elig_dpnt_id => p_elig_dpnt_id,
512: p_object_version_number => p_object_version_number);
513: --
514: if (l_api_updating

Line 516: <> nvl(ben_egd_shd.g_old_rec.inelg_rsn_cd,hr_api.g_varchar2)

512: p_object_version_number => p_object_version_number);
513: --
514: if (l_api_updating
515: and p_inelg_rsn_cd
516: <> nvl(ben_egd_shd.g_old_rec.inelg_rsn_cd,hr_api.g_varchar2)
517: or not l_api_updating)
518: and p_inelg_rsn_cd is not null then
519: --
520: -- check if value of lookup falls within lookup type.

Line 580: l_api_updating := ben_egd_shd.api_updating

576: Begin
577: --
578: hr_utility.set_location('Entering:'||l_proc, 5);
579: --
580: l_api_updating := ben_egd_shd.api_updating
581: (p_elig_dpnt_id => p_elig_dpnt_id,
582: p_object_version_number => p_object_version_number);
583: --
584: if (l_api_updating

Line 586: <> nvl(ben_egd_shd.g_old_rec.ovrdn_flag,hr_api.g_varchar2)

582: p_object_version_number => p_object_version_number);
583: --
584: if (l_api_updating
585: and p_ovrdn_flag
586: <> nvl(ben_egd_shd.g_old_rec.ovrdn_flag,hr_api.g_varchar2)
587: or not l_api_updating) then
588: --
589: -- check if value of lookup falls within lookup type.
590: --

Line 615: Procedure insert_validate(p_rec in ben_egd_shd.g_rec_type

611: --
612: -- ----------------------------------------------------------------------------
613: -- |---------------------------< insert_validate >----------------------------|
614: -- ----------------------------------------------------------------------------
615: Procedure insert_validate(p_rec in ben_egd_shd.g_rec_type
616: ,p_effective_date in date) is
617: --
618: l_proc varchar2(72) := g_package||'insert_validate';
619: --

Line 680: Procedure update_validate(p_rec in ben_egd_shd.g_rec_type

676: --
677: -- ----------------------------------------------------------------------------
678: -- |---------------------------< update_validate >----------------------------|
679: -- ----------------------------------------------------------------------------
680: Procedure update_validate(p_rec in ben_egd_shd.g_rec_type
681: ,p_effective_date in date) is
682: --
683: l_proc varchar2(72) := g_package||'update_validate';
684: --

Line 745: Procedure delete_validate(p_rec in ben_egd_shd.g_rec_type

741: --
742: -- ----------------------------------------------------------------------------
743: -- |---------------------------< delete_validate >----------------------------|
744: -- ----------------------------------------------------------------------------
745: Procedure delete_validate(p_rec in ben_egd_shd.g_rec_type
746: ,p_effective_date in date) is
747: --
748: l_proc varchar2(72) := g_package||'delete_validate';
749: --