APPS.BEN_PZR_BUS dependencies on BEN_PZR_SHD

Line 48: l_api_updating := ben_pzr_shd.api_updating

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

Line 55: <> ben_pzr_shd.g_old_rec.pstl_zip_rt_id) then

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

Line 59: ben_pzr_shd.constraint_error('BEN_PSTL_ZIP_RATE_PK');

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

Line 69: ben_pzr_shd.constraint_error('BEN_PSTL_ZIP_RATE_PK');

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

Line 148: l_api_updating := ben_pzr_shd.api_updating

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

Line 155: <> nvl(ben_pzr_shd.g_old_rec.pstl_zip_rng_id,hr_api.g_number)

151: p_object_version_number => p_object_version_number);
152: --
153: if (l_api_updating
154: and nvl(p_pstl_zip_rng_id,hr_api.g_number)
155: <> nvl(ben_pzr_shd.g_old_rec.pstl_zip_rng_id,hr_api.g_number)
156: or not l_api_updating) then
157: --
158: -- check if pstl_zip_rng_id value exists in ben_pstl_zip_rng_f table
159: --

Line 170: ben_pzr_shd.constraint_error('BEN_PSTL_ZIP_RATE_PK');

166: --
167: -- raise error as FK does not relate to PK in ben_pstl_zip_rng_f
168: -- table.
169: --
170: ben_pzr_shd.constraint_error('BEN_PSTL_ZIP_RATE_PK');
171: --
172: end if;
173: --
174: close c1;

Line 297: l_api_updating := ben_pzr_shd.api_updating

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

Line 304: <> nvl(ben_pzr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 547: (p_rec in ben_pzr_shd.g_rec_type,

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

Line 598: (p_rec in ben_pzr_shd.g_rec_type,

594: -- ----------------------------------------------------------------------------
595: -- |---------------------------< update_validate >----------------------------|
596: -- ----------------------------------------------------------------------------
597: Procedure update_validate
598: (p_rec in ben_pzr_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 658: (p_rec in ben_pzr_shd.g_rec_type,

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