APPS.BEN_EES_BUS dependencies on BEN_EES_SHD

Line 48: l_api_updating := ben_ees_shd.api_updating

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

Line 55: <> ben_ees_shd.g_old_rec.elig_ee_stat_prte_id) then

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

Line 59: ben_ees_shd.constraint_error('BEN_ELIG_EE_STAT_PK');

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

Line 69: ben_ees_shd.constraint_error('BEN_ELIG_EE_STAT_PK');

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

Line 182: l_api_updating := ben_ees_shd.api_updating

178: Begin
179: --
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: l_api_updating := ben_ees_shd.api_updating
183: (p_elig_ee_stat_prte_id => p_elig_ee_stat_prte_id,
184: p_effective_date => p_effective_date,
185: p_object_version_number => p_object_version_number);
186: --

Line 189: <> nvl(ben_ees_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)

185: p_object_version_number => p_object_version_number);
186: --
187: if (l_api_updating
188: and p_assignment_status_type_id
189: <> nvl(ben_ees_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
190: or not l_api_updating) then
191: --
192: -- check if assignment_status_type_id value exists in per_assignment_status_types table
193: --

Line 204: ben_ees_shd.constraint_error('BEN_ELIG_EE_STAT_FK2');

200: --
201: -- raise error as FK does not relate to PK in per_assignment_status_types
202: -- table.
203: --
204: ben_ees_shd.constraint_error('BEN_ELIG_EE_STAT_FK2');
205: --
206: end if;
207: --
208: close c1;

Line 286: l_api_updating := ben_ees_shd.api_updating

282: Begin
283: --
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: l_api_updating := ben_ees_shd.api_updating
287: (p_elig_ee_stat_prte_id => p_elig_ee_stat_prte_id,
288: p_effective_date => p_effective_date,
289: p_object_version_number => p_object_version_number);
290: --

Line 293: <> nvl(ben_ees_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

289: p_object_version_number => p_object_version_number);
290: --
291: if (l_api_updating
292: and p_excld_flag
293: <> nvl(ben_ees_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
294: or not l_api_updating) then
295: --
296: -- check if value of lookup falls within lookup type.
297: --

Line 581: (p_rec in ben_ees_shd.g_rec_type,

577: -- ----------------------------------------------------------------------------
578: -- |---------------------------< insert_validate >----------------------------|
579: -- ----------------------------------------------------------------------------
580: Procedure insert_validate
581: (p_rec in ben_ees_shd.g_rec_type,
582: p_effective_date in date,
583: p_datetrack_mode in varchar2,
584: p_validation_start_date in date,
585: p_validation_end_date in date) is

Line 632: (p_rec in ben_ees_shd.g_rec_type,

628: -- ----------------------------------------------------------------------------
629: -- |---------------------------< update_validate >----------------------------|
630: -- ----------------------------------------------------------------------------
631: Procedure update_validate
632: (p_rec in ben_ees_shd.g_rec_type,
633: p_effective_date in date,
634: p_datetrack_mode in varchar2,
635: p_validation_start_date in date,
636: p_validation_end_date in date) is

Line 691: (p_rec in ben_ees_shd.g_rec_type,

687: -- ----------------------------------------------------------------------------
688: -- |---------------------------< delete_validate >----------------------------|
689: -- ----------------------------------------------------------------------------
690: Procedure delete_validate
691: (p_rec in ben_ees_shd.g_rec_type,
692: p_effective_date in date,
693: p_datetrack_mode in varchar2,
694: p_validation_start_date in date,
695: p_validation_end_date in date) is