APPS.BEN_SAR_BUS dependencies on BEN_SAR_SHD

Line 48: l_api_updating := ben_sar_shd.api_updating

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

Line 55: <> ben_sar_shd.g_old_rec.svc_area_rt_id) then

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

Line 59: ben_sar_shd.constraint_error('BEN_SVC_AREA_RT_PK');

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

Line 69: ben_sar_shd.constraint_error('BEN_SVC_AREA_RT_PK');

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

Line 147: l_api_updating := ben_sar_shd.api_updating

143: Begin
144: --
145: hr_utility.set_location('Entering:'||l_proc,5);
146: --
147: l_api_updating := ben_sar_shd.api_updating
148: (p_svc_area_rt_id => p_svc_area_rt_id,
149: p_effective_date => p_effective_date,
150: p_object_version_number => p_object_version_number);
151: --

Line 154: <> nvl(ben_sar_shd.g_old_rec.svc_area_id,hr_api.g_number)

150: p_object_version_number => p_object_version_number);
151: --
152: if (l_api_updating
153: and nvl(p_svc_area_id,hr_api.g_number)
154: <> nvl(ben_sar_shd.g_old_rec.svc_area_id,hr_api.g_number)
155: or not l_api_updating) then
156: --
157: -- check if p_svc_area_id value exists in ben_svc_area_f table
158: --

Line 296: l_api_updating := ben_sar_shd.api_updating

292: Begin
293: --
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: l_api_updating := ben_sar_shd.api_updating
297: (p_svc_area_rt_id => p_svc_area_rt_id,
298: p_effective_date => p_effective_date,
299: p_object_version_number => p_object_version_number);
300: --

Line 303: <> nvl(ben_sar_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

299: p_object_version_number => p_object_version_number);
300: --
301: if (l_api_updating
302: and p_excld_flag
303: <> nvl(ben_sar_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
304: or not l_api_updating) then
305: --
306: -- check if value of lookup falls within lookup type.
307: --

Line 546: (p_rec in ben_sar_shd.g_rec_type,

542: -- ----------------------------------------------------------------------------
543: -- |---------------------------< insert_validate >----------------------------|
544: -- ----------------------------------------------------------------------------
545: Procedure insert_validate
546: (p_rec in ben_sar_shd.g_rec_type,
547: p_effective_date in date,
548: p_datetrack_mode in varchar2,
549: p_validation_start_date in date,
550: p_validation_end_date in date) is

Line 597: (p_rec in ben_sar_shd.g_rec_type,

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

Line 657: (p_rec in ben_sar_shd.g_rec_type,

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