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_EST_BUS dependencies on BEN_EST_SHD

Line 49: l_api_updating := ben_est_shd.api_updating

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

Line 56: <> ben_est_shd.g_old_rec.elig_suppl_role_prte_id) then

52: p_object_version_number => p_object_version_number);
53: --
54: if (l_api_updating
55: and nvl(p_elig_suppl_role_prte_id,hr_api.g_number)
56: <> ben_est_shd.g_old_rec.elig_suppl_role_prte_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_PK');

Line 60: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_PK');

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

Line 70: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_PK');

66: if p_elig_suppl_role_prte_id is not null then
67: --
68: -- raise error as PK is not null
69: --
70: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_PK');
71: --
72: end if;
73: --
74: end if;

Line 118: l_api_updating := ben_est_shd.api_updating

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

Line 125: <> nvl(ben_est_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and p_excld_flag
125: <> nvl(ben_est_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
126: or not l_api_updating) then
127: --
128: -- check if value of lookup falls within lookup type.
129: --

Line 196: l_api_updating := ben_est_shd.api_updating

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

Line 203: <> nvl(ben_est_shd.g_old_rec.job_group_id,hr_api.g_number)

199: p_object_version_number => p_object_version_number);
200: --
201: if (l_api_updating
202: and nvl(p_job_group_id,hr_api.g_number)
203: <> nvl(ben_est_shd.g_old_rec.job_group_id,hr_api.g_number)
204: or not l_api_updating)
205: and p_job_group_id is not null then
206: --
207: -- check if job_group_id value exists in

Line 220: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_FK2');

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

Line 279: l_api_updating := ben_est_shd.api_updating

275: Begin
276: --
277: hr_utility.set_location('Entering:'||l_proc,5);
278: --
279: l_api_updating := ben_est_shd.api_updating
280: (p_elig_suppl_role_prte_id => p_elig_suppl_role_prte_id,
281: p_effective_date => p_effective_date,
282: p_object_version_number => p_object_version_number);
283: --

Line 286: <> nvl(ben_est_shd.g_old_rec.job_id,hr_api.g_number)

282: p_object_version_number => p_object_version_number);
283: --
284: if (l_api_updating
285: and nvl(p_job_id,hr_api.g_number)
286: <> nvl(ben_est_shd.g_old_rec.job_id,hr_api.g_number)
287: or not l_api_updating)
288: and p_job_id is not null then
289: --
290: -- check if job_id value exists in

Line 303: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_FK3');

299: --
300: -- raise error as FK does not relate to PK in
301: -- per_abs_attendance_reasons table.
302: --
303: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_FK3');
304: --
305: end if;
306: --
307: close c1;

Line 598: (p_rec in ben_est_shd.g_rec_type,

594: -- ----------------------------------------------------------------------------
595: -- |---------------------------< insert_validate >----------------------------|
596: -- ----------------------------------------------------------------------------
597: Procedure insert_validate
598: (p_rec in ben_est_shd.g_rec_type,
599: p_effective_date in date,
600: p_datetrack_mode in varchar2,
601: p_validation_start_date in date,
602: p_validation_end_date in date) is

Line 656: (p_rec in ben_est_shd.g_rec_type,

652: -- ----------------------------------------------------------------------------
653: -- |---------------------------< update_validate >----------------------------|
654: -- ----------------------------------------------------------------------------
655: Procedure update_validate
656: (p_rec in ben_est_shd.g_rec_type,
657: p_effective_date in date,
658: p_datetrack_mode in varchar2,
659: p_validation_start_date in date,
660: p_validation_end_date in date) is

Line 721: (p_rec in ben_est_shd.g_rec_type,

717: -- ----------------------------------------------------------------------------
718: -- |---------------------------< delete_validate >----------------------------|
719: -- ----------------------------------------------------------------------------
720: Procedure delete_validate
721: (p_rec in ben_est_shd.g_rec_type,
722: p_effective_date in date,
723: p_datetrack_mode in varchar2,
724: p_validation_start_date in date,
725: p_validation_end_date in date) is