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_EDC_BUS dependencies on BEN_EDC_SHD

Line 48: l_api_updating := ben_edc_shd.api_updating

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

Line 55: <> ben_edc_shd.g_old_rec.elig_dsbld_stat_cvg_id) then

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

Line 59: ben_edc_shd.constraint_error('BEN_DSBL_STAT_CVG_PK');

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

Line 69: ben_edc_shd.constraint_error('BEN_DSBL_STAT_CVG_PK');

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

Line 117: l_api_updating := ben_edc_shd.api_updating

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

Line 124: <> nvl(ben_edc_shd.g_old_rec.dsbld_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_dsbld_cd
124: <> nvl(ben_edc_shd.g_old_rec.dsbld_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_edc_shd.api_updating

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

Line 202: <> ben_edc_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_edc_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_edc_shd.api_updating

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

Line 278: <> nvl(ben_edc_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_edc_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_edc_shd.api_updating

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

Line 356: <> ben_edc_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_edc_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_edc_shd.api_updating

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

Line 432: <> nvl(ben_edc_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_edc_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 500: l_api_updating := ben_edc_shd.api_updating

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

Line 508: nvl(ben_edc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or

504: --
505:
506: if (l_api_updating
507: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
508: nvl(ben_edc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
509: nvl(p_cvg_strt_rl, hr_api.g_number) <>
510: nvl(ben_edc_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
511: or not l_api_updating) then
512:

Line 510: nvl(ben_edc_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))

506: if (l_api_updating
507: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
508: nvl(ben_edc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
509: nvl(p_cvg_strt_rl, hr_api.g_number) <>
510: nvl(ben_edc_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
511: or not l_api_updating) then
512:
513: --
514: -- check dependency of Code and Rule.

Line 579: l_api_updating := ben_edc_shd.api_updating

575: Begin
576: --
577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: l_api_updating := ben_edc_shd.api_updating
580: (p_elig_dsbld_stat_cvg_id => p_elig_dsbld_stat_cvg_id,
581: p_effective_date => p_effective_date,
582: p_object_version_number => p_object_version_number);
583: --

Line 587: nvl(ben_edc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or

583: --
584:
585: if (l_api_updating
586: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
587: nvl(ben_edc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
588: nvl(p_cvg_thru_rl, hr_api.g_number) <>
589: nvl(ben_edc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
590: or not l_api_updating) then
591:

Line 589: nvl(ben_edc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))

585: if (l_api_updating
586: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
587: nvl(ben_edc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
588: nvl(p_cvg_thru_rl, hr_api.g_number) <>
589: nvl(ben_edc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
590: or not l_api_updating) then
591:
592: --
593: -- check dependency of Code and Rule.

Line 884: (p_rec in ben_edc_shd.g_rec_type,

880: -- ----------------------------------------------------------------------------
881: -- |---------------------------< insert_validate >----------------------------|
882: -- ----------------------------------------------------------------------------
883: Procedure insert_validate
884: (p_rec in ben_edc_shd.g_rec_type,
885: p_effective_date in date,
886: p_datetrack_mode in varchar2,
887: p_validation_start_date in date,
888: p_validation_end_date in date) is

Line 964: (p_rec in ben_edc_shd.g_rec_type,

960: -- ----------------------------------------------------------------------------
961: -- |---------------------------< update_validate >----------------------------|
962: -- ----------------------------------------------------------------------------
963: Procedure update_validate
964: (p_rec in ben_edc_shd.g_rec_type,
965: p_effective_date in date,
966: p_datetrack_mode in varchar2,
967: p_validation_start_date in date,
968: p_validation_end_date in date) is

Line 1051: (p_rec in ben_edc_shd.g_rec_type,

1047: -- ----------------------------------------------------------------------------
1048: -- |---------------------------< delete_validate >----------------------------|
1049: -- ----------------------------------------------------------------------------
1050: Procedure delete_validate
1051: (p_rec in ben_edc_shd.g_rec_type,
1052: p_effective_date in date,
1053: p_datetrack_mode in varchar2,
1054: p_validation_start_date in date,
1055: p_validation_end_date in date) is