DBA Data[Home] [Help]

APPS.BEN_PTR_BUS dependencies on BEN_PTR_SHD

Line 48: l_api_updating := ben_ptr_shd.api_updating

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

Line 55: <> ben_ptr_shd.g_old_rec.per_typ_rt_id) then

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

Line 59: ben_ptr_shd.constraint_error('BEN_PER_TYP_RTS_F_PK');

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

Line 69: ben_ptr_shd.constraint_error('BEN_PER_TYP_RTS_F_PK');

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

Line 143: l_api_updating := ben_ptr_shd.api_updating

139: Begin
140: --
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: l_api_updating := ben_ptr_shd.api_updating
144: (p_per_typ_rt_id => p_per_typ_rt_id,
145: p_effective_date => p_effective_date,
146: p_object_version_number => p_object_version_number);
147: --

Line 153: <> nvl(ben_ptr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

149: -- person types.
150: --
151: /* if (l_api_updating
152: and p_per_typ_cd
153: <> nvl(ben_ptr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
154: or not l_api_updating) then */
155: if (l_api_updating
156: and p_person_type_id
157: <> nvl(ben_ptr_shd.g_old_rec.person_type_id,hr_api.g_number)

Line 157: <> nvl(ben_ptr_shd.g_old_rec.person_type_id,hr_api.g_number)

153: <> nvl(ben_ptr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
154: or not l_api_updating) then */
155: if (l_api_updating
156: and p_person_type_id
157: <> nvl(ben_ptr_shd.g_old_rec.person_type_id,hr_api.g_number)
158: or not l_api_updating) then
159: --
160: -- check if value of lookup falls within lookup type.
161: -- As part of Bug 1631182 decided not to support per_typ_cd

Line 301: l_api_updating := ben_ptr_shd.api_updating

297: Begin
298: --
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: l_api_updating := ben_ptr_shd.api_updating
302: (p_per_typ_rt_id => p_per_typ_rt_id,
303: p_effective_date => p_effective_date,
304: p_object_version_number => p_object_version_number);
305: --

Line 308: <> nvl(ben_ptr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

304: p_object_version_number => p_object_version_number);
305: --
306: if (l_api_updating
307: and p_excld_flag
308: <> nvl(ben_ptr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
309: or not l_api_updating) then
310: --
311: -- check if value of lookup falls within lookup type.
312: --

Line 539: (p_rec in ben_ptr_shd.g_rec_type,

535: -- ----------------------------------------------------------------------------
536: -- |---------------------------< insert_validate >----------------------------|
537: -- ----------------------------------------------------------------------------
538: Procedure insert_validate
539: (p_rec in ben_ptr_shd.g_rec_type,
540: p_effective_date in date,
541: p_datetrack_mode in varchar2,
542: p_validation_start_date in date,
543: p_validation_end_date in date) is

Line 591: (p_rec in ben_ptr_shd.g_rec_type,

587: -- ----------------------------------------------------------------------------
588: -- |---------------------------< update_validate >----------------------------|
589: -- ----------------------------------------------------------------------------
590: Procedure update_validate
591: (p_rec in ben_ptr_shd.g_rec_type,
592: p_effective_date in date,
593: p_datetrack_mode in varchar2,
594: p_validation_start_date in date,
595: p_validation_end_date in date) is

Line 651: (p_rec in ben_ptr_shd.g_rec_type,

647: -- ----------------------------------------------------------------------------
648: -- |---------------------------< delete_validate >----------------------------|
649: -- ----------------------------------------------------------------------------
650: Procedure delete_validate
651: (p_rec in ben_ptr_shd.g_rec_type,
652: p_effective_date in date,
653: p_datetrack_mode in varchar2,
654: p_validation_start_date in date,
655: p_validation_end_date in date) is