DBA Data[Home] [Help]

APPS.PAY_SBA_BUS dependencies on PAY_SBA_SHD

Line 41: (p_rec in pay_sba_shd.g_rec_type

37: --
38: -- {End Of Comments}
39: -- ----------------------------------------------------------------------------
40: Procedure chk_non_updateable_args
41: (p_rec in pay_sba_shd.g_rec_type
42: ) is
43: --
44: -- Cursor to disallow update if a core defined balance has been
45: -- generated from this shadow defined balance.

Line 61: l_api_updating := pay_sba_shd.api_updating

57: l_disallow varchar2(1);
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: l_api_updating := pay_sba_shd.api_updating
62: (p_balance_attribute_id => p_rec.balance_attribute_id
63: ,p_object_version_number => p_rec.object_version_number
64: );
65: if not l_api_updating then

Line 120: l_api_updating := pay_sba_shd.api_updating

116: l_valid varchar2(1);
117: --
118: Begin
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: l_api_updating := pay_sba_shd.api_updating
121: (p_balance_attribute_id => p_balance_attribute_id
122: ,p_object_version_number => p_object_version_number
123: );
124: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

Line 125: nvl(pay_sba_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

121: (p_balance_attribute_id => p_balance_attribute_id
122: ,p_object_version_number => p_object_version_number
123: );
124: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
125: nvl(pay_sba_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
126: not l_api_updating
127: then
128: if p_exclusion_rule_id is not null then
129: open csr_exclusion_rule_id_valid;

Line 208: l_api_updating := pay_sba_shd.api_updating

204: l_exists varchar2(1);
205: --
206: Begin
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: l_api_updating := pay_sba_shd.api_updating
209: (p_balance_attribute_id => p_balance_attribute_id
210: ,p_object_version_number => p_object_version_number
211: );
212: if (l_api_updating and nvl(p_attribute_name, hr_api.g_varchar2)

Line 213: <> nvl(pay_sba_shd.g_old_rec.attribute_name, hr_api.g_varchar2))

209: (p_balance_attribute_id => p_balance_attribute_id
210: ,p_object_version_number => p_object_version_number
211: );
212: if (l_api_updating and nvl(p_attribute_name, hr_api.g_varchar2)
213: <> nvl(pay_sba_shd.g_old_rec.attribute_name, hr_api.g_varchar2))
214: or not l_api_updating
215: then
216: --
217: -- Check that the attribute name is not null.

Line 283: (p_rec in pay_sba_shd.g_rec_type

279: -- ----------------------------------------------------------------------------
280: -- |---------------------------< insert_validate >----------------------------|
281: -- ----------------------------------------------------------------------------
282: Procedure insert_validate
283: (p_rec in pay_sba_shd.g_rec_type
284: ) is
285: --
286: l_proc varchar2(72) := g_package||'insert_validate';
287: --

Line 320: (p_rec in pay_sba_shd.g_rec_type

316: -- ----------------------------------------------------------------------------
317: -- |---------------------------< update_validate >----------------------------|
318: -- ----------------------------------------------------------------------------
319: Procedure update_validate
320: (p_rec in pay_sba_shd.g_rec_type
321: ) is
322: --
323: l_proc varchar2(72) := g_package||'update_validate';
324: --

Line 359: (p_rec in pay_sba_shd.g_rec_type

355: -- ----------------------------------------------------------------------------
356: -- |---------------------------< delete_validate >----------------------------|
357: -- ----------------------------------------------------------------------------
358: Procedure delete_validate
359: (p_rec in pay_sba_shd.g_rec_type
360: ) is
361: --
362: l_proc varchar2(72) := g_package||'delete_validate';
363: --