APPS.PAY_SGB_BUS dependencies on PAY_SGB_SHD

Line 39: (p_rec in pay_sgb_shd.g_rec_type

35: --
36: -- {End Of Comments}
37: -- ----------------------------------------------------------------------------
38: Procedure chk_non_updateable_args
39: (p_rec in pay_sgb_shd.g_rec_type
40: ) IS
41: --
42: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
43: l_error EXCEPTION;

Line 51: IF NOT pay_sgb_shd.api_updating

47: --
48: -- Only proceed with the validation if a row exists for the current
49: -- record in the HR Schema.
50: --
51: IF NOT pay_sgb_shd.api_updating
52: (p_grossup_balances_id => p_rec.grossup_balances_id
53: ,p_object_version_number => p_rec.object_version_number
54: ) THEN
55: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 64: nvl(pay_sgb_shd.g_old_rec.source_id, hr_api.g_number)

60: --
61: -- p_source_id
62: --
63: if nvl(p_rec.source_id, hr_api.g_number) <>
64: nvl(pay_sgb_shd.g_old_rec.source_id, hr_api.g_number)
65: then
66: l_argument := 'p_source_id';
67: raise l_error;
68: end if;

Line 192: l_api_updating := pay_sgb_shd.api_updating

188: l_valid varchar2(1);
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: l_api_updating := pay_sgb_shd.api_updating
193: (p_grossup_balances_id => p_grossup_balances_id
194: ,p_object_version_number => p_object_version_number
195: );
196: if p_balance_type_name is null then

Line 208: nvl(pay_sgb_shd.g_old_rec.balance_type_id, hr_api.g_number)) or

204: );
205: end if;
206: --
207: if (l_api_updating and nvl(p_balance_type_id, hr_api.g_number) <>
208: nvl(pay_sgb_shd.g_old_rec.balance_type_id, hr_api.g_number)) or
209: not l_api_updating
210: then
211: if p_balance_type_id is not null then
212: open c_bal_type_id_valid;

Line 251: l_api_updating := pay_sgb_shd.api_updating

247: l_valid varchar2(1);
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);
251: l_api_updating := pay_sgb_shd.api_updating
252: (p_grossup_balances_id => p_grossup_balances_id
253: ,p_object_version_number => p_object_version_number
254: );
255: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

Line 256: nvl(pay_sgb_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

252: (p_grossup_balances_id => p_grossup_balances_id
253: ,p_object_version_number => p_object_version_number
254: );
255: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
256: nvl(pay_sgb_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
257: not l_api_updating
258: then
259: if p_exclusion_rule_id is not null then
260: open c_exclusion_rule_id_valid;

Line 317: ,p_rec in pay_sgb_shd.g_rec_type

313: -- |---------------------------< insert_validate >----------------------------|
314: -- ----------------------------------------------------------------------------
315: Procedure insert_validate
316: (p_effective_date in date
317: ,p_rec in pay_sgb_shd.g_rec_type
318: ) is
319: --
320: l_proc varchar2(72) := g_package||'insert_validate';
321: --

Line 360: ,p_rec in pay_sgb_shd.g_rec_type

356: -- |---------------------------< update_validate >----------------------------|
357: -- ----------------------------------------------------------------------------
358: Procedure update_validate
359: (p_effective_date in date
360: ,p_rec in pay_sgb_shd.g_rec_type
361: ) is
362: --
363: l_proc varchar2(72) := g_package||'update_validate';
364: --

Line 402: (p_rec in pay_sgb_shd.g_rec_type

398: -- ----------------------------------------------------------------------------
399: -- |---------------------------< delete_validate >----------------------------|
400: -- ----------------------------------------------------------------------------
401: Procedure delete_validate
402: (p_rec in pay_sgb_shd.g_rec_type
403: ) is
404: --
405: l_proc varchar2(72) := g_package||'delete_validate';
406: --