DBA Data[Home] [Help]

APPS.BEN_BNR_BUS dependencies on BEN_BNR_SHD

Line 106: l_api_updating := ben_bnr_shd.api_updating

102: Begin
103: --
104: hr_utility.set_location('Entering:'||l_proc, 5);
105: --
106: l_api_updating := ben_bnr_shd.api_updating
107: (p_rptg_grp_id => p_rptg_grp_id,
108: p_object_version_number => p_object_version_number);
109: --
110: if (l_api_updating

Line 112: <> ben_bnr_shd.g_old_rec.rptg_grp_id) then

108: p_object_version_number => p_object_version_number);
109: --
110: if (l_api_updating
111: and nvl(p_rptg_grp_id,hr_api.g_number)
112: <> ben_bnr_shd.g_old_rec.rptg_grp_id) then
113: --
114: -- raise error as PK has changed
115: --
116: ben_bnr_shd.constraint_error('BEN_RPTG_GRP_PK');

Line 116: ben_bnr_shd.constraint_error('BEN_RPTG_GRP_PK');

112: <> ben_bnr_shd.g_old_rec.rptg_grp_id) then
113: --
114: -- raise error as PK has changed
115: --
116: ben_bnr_shd.constraint_error('BEN_RPTG_GRP_PK');
117: --
118: elsif not l_api_updating then
119: --
120: -- check if PK is null

Line 126: ben_bnr_shd.constraint_error('BEN_RPTG_GRP_PK');

122: if p_rptg_grp_id is not null then
123: --
124: -- raise error as PK is not null
125: --
126: ben_bnr_shd.constraint_error('BEN_RPTG_GRP_PK');
127: --
128: end if;
129: --
130: end if;

Line 174: l_api_updating := ben_bnr_shd.api_updating

170: Begin
171: --
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --
174: l_api_updating := ben_bnr_shd.api_updating
175: (p_rptg_grp_id => p_rptg_grp_id,
176: p_object_version_number => p_object_version_number);
177: --
178: if (l_api_updating

Line 180: <> nvl(ben_bnr_shd.g_old_rec.rptg_prps_cd,hr_api.g_varchar2)

176: p_object_version_number => p_object_version_number);
177: --
178: if (l_api_updating
179: and p_rptg_prps_cd
180: <> nvl(ben_bnr_shd.g_old_rec.rptg_prps_cd,hr_api.g_varchar2)
181: or not l_api_updating)
182: and p_rptg_prps_cd is not null then
183: --
184: -- check if value of lookup falls within lookup type.

Line 269: l_api_updating := ben_bnr_shd.api_updating

265: Begin
266: --
267: hr_utility.set_location('Entering:'||l_proc, 5);
268: --
269: l_api_updating := ben_bnr_shd.api_updating
270: (p_rptg_grp_id => p_rptg_grp_id,
271: p_object_version_number => p_object_version_number);
272: --
273: if (l_api_updating

Line 275: <> nvl(ben_bnr_shd.g_old_rec.rptg_prps_cd,hr_api.g_varchar2))

271: p_object_version_number => p_object_version_number);
272: --
273: if (l_api_updating
274: and p_rptg_prps_cd
275: <> nvl(ben_bnr_shd.g_old_rec.rptg_prps_cd,hr_api.g_varchar2))
276: and p_rptg_prps_cd is not null then
277: --
278: if p_rptg_prps_cd = 'IREC' then
279: --

Line 384: l_api_updating := ben_bnr_shd.api_updating

380: --
381: hr_utility.set_location('Entering:'||l_proc, 5);
382: hr_utility.set_location('business:'||p_business_group_id, 5);
383: --
384: l_api_updating := ben_bnr_shd.api_updating
385: (p_rptg_grp_id => p_rptg_grp_id,
386: -- p_effective_date => p_effective_date,
387: p_object_version_number => p_object_version_number);
388: --

Line 398: <> ben_bnr_shd.g_old_rec.name

394: --
395:
396: if ((l_api_updating
397: and nvl(p_name,hr_api.g_varchar2)
398: <> ben_bnr_shd.g_old_rec.name
399: or not l_api_updating)
400: OR
401: (l_api_updating
402: and nvl(p_business_group_id,hr_api.g_number)

Line 403: <> ben_bnr_shd.g_old_rec.business_group_id

399: or not l_api_updating)
400: OR
401: (l_api_updating
402: and nvl(p_business_group_id,hr_api.g_number)
403: <> ben_bnr_shd.g_old_rec.business_group_id
404: or not l_api_updating)
405: )
406: and p_name is not null then
407: --

Line 664: Procedure insert_validate(p_rec in ben_bnr_shd.g_rec_type

660: --
661: -- ----------------------------------------------------------------------------
662: -- |---------------------------< insert_validate >----------------------------|
663: -- ----------------------------------------------------------------------------
664: Procedure insert_validate(p_rec in ben_bnr_shd.g_rec_type
665: ,p_effective_date in date) is
666: --
667: l_proc varchar2(72) := g_package||'insert_validate';
668: --

Line 711: Procedure update_validate(p_rec in ben_bnr_shd.g_rec_type

707: --
708: -- ----------------------------------------------------------------------------
709: -- |---------------------------< update_validate >----------------------------|
710: -- ----------------------------------------------------------------------------
711: Procedure update_validate(p_rec in ben_bnr_shd.g_rec_type
712: ,p_effective_date in date) is
713: --
714: l_proc varchar2(72) := g_package||'update_validate';
715: --

Line 768: Procedure delete_validate(p_rec in ben_bnr_shd.g_rec_type

764: --
765: -- ----------------------------------------------------------------------------
766: -- |---------------------------< delete_validate >----------------------------|
767: -- ----------------------------------------------------------------------------
768: Procedure delete_validate(p_rec in ben_bnr_shd.g_rec_type
769: ,p_effective_date in date) is
770: --
771: l_proc varchar2(72) := g_package||'delete_validate';
772: --