DBA Data[Home] [Help]

APPS.BEN_YRP_BUS dependencies on BEN_YRP_SHD

Line 46: l_api_updating := ben_yrp_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_yrp_shd.api_updating
47: (p_yr_perd_id => p_yr_perd_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_yrp_shd.g_old_rec.yr_perd_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_yr_perd_id,hr_api.g_number)
52: <> ben_yrp_shd.g_old_rec.yr_perd_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_yrp_shd.constraint_error('BEN_YR_PERDS_PK');

Line 56: ben_yrp_shd.constraint_error('BEN_YR_PERDS_PK');

52: <> ben_yrp_shd.g_old_rec.yr_perd_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_yrp_shd.constraint_error('BEN_YR_PERDS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_yrp_shd.constraint_error('BEN_YR_PERDS_PK');

62: if p_yr_perd_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_yrp_shd.constraint_error('BEN_YR_PERDS_PK');
67: --
68: end if;
69: --
70: end if;

Line 115: l_api_updating := ben_yrp_shd.api_updating

111: Begin
112: --
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: --
115: l_api_updating := ben_yrp_shd.api_updating
116: (p_yr_perd_id => p_yr_perd_id,
117: p_object_version_number => p_object_version_number);
118: --
119: if (l_api_updating

Line 121: <> nvl(ben_yrp_shd.g_old_rec.perd_typ_cd,hr_api.g_varchar2)

117: p_object_version_number => p_object_version_number);
118: --
119: if (l_api_updating
120: and p_perd_typ_cd
121: <> nvl(ben_yrp_shd.g_old_rec.perd_typ_cd,hr_api.g_varchar2)
122: or not l_api_updating)
123: and p_perd_typ_cd is not null then
124: --
125: -- check if value of lookup falls within lookup type.

Line 185: l_api_updating := ben_yrp_shd.api_updating

181: Begin
182: --
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: l_api_updating := ben_yrp_shd.api_updating
186: (p_yr_perd_id => p_yr_perd_id,
187: p_object_version_number => p_object_version_number);
188: --
189: if (l_api_updating

Line 191: <> nvl(ben_yrp_shd.g_old_rec.perd_tm_uom_cd,hr_api.g_varchar2)

187: p_object_version_number => p_object_version_number);
188: --
189: if (l_api_updating
190: and p_perd_tm_uom_cd
191: <> nvl(ben_yrp_shd.g_old_rec.perd_tm_uom_cd,hr_api.g_varchar2)
192: or not l_api_updating)
193: and p_perd_tm_uom_cd is not null then
194: --
195: -- check if value of lookup falls within lookup type.

Line 438: Procedure insert_validate(p_rec in ben_yrp_shd.g_rec_type

434: --
435: -- ----------------------------------------------------------------------------
436: -- |---------------------------< insert_validate >----------------------------|
437: -- ----------------------------------------------------------------------------
438: Procedure insert_validate(p_rec in ben_yrp_shd.g_rec_type
439: ,p_effective_date in date) is
440: --
441: l_proc varchar2(72) := g_package||'insert_validate';
442: --

Line 494: Procedure update_validate(p_rec in ben_yrp_shd.g_rec_type

490: --
491: -- ----------------------------------------------------------------------------
492: -- |---------------------------< update_validate >----------------------------|
493: -- ----------------------------------------------------------------------------
494: Procedure update_validate(p_rec in ben_yrp_shd.g_rec_type
495: ,p_effective_date in date) is
496: --
497: l_proc varchar2(72) := g_package||'update_validate';
498: --

Line 547: Procedure delete_validate(p_rec in ben_yrp_shd.g_rec_type

543: --
544: -- ----------------------------------------------------------------------------
545: -- |---------------------------< delete_validate >----------------------------|
546: -- ----------------------------------------------------------------------------
547: Procedure delete_validate(p_rec in ben_yrp_shd.g_rec_type
548: ,p_effective_date in date) is
549: --
550: l_proc varchar2(72) := g_package||'delete_validate';
551: --