DBA Data[Home] [Help]

APPS.PAY_SBF_BUS dependencies on PAY_SBF_SHD

Line 45: (p_rec in pay_sbf_shd.g_rec_type

41: -- ----------------------------------------------------------------------------
42: -- |-----------------------< chk_non_updateable_args >------------------------|
43: -- ----------------------------------------------------------------------------
44: Procedure chk_non_updateable_args
45: (p_rec in pay_sbf_shd.g_rec_type
46: ) is
47: --
48: -- Cursor to disallow update if a core balance classification has been
49: -- generated from this shadow balance classification.

Line 66: l_api_updating := pay_sbf_shd.api_updating

62: l_disallow varchar2(1);
63: --
64: Begin
65: hr_utility.set_location('Entering:'||l_proc, 5);
66: l_api_updating := pay_sbf_shd.api_updating
67: (p_balance_feed_id => p_rec.balance_feed_id
68: ,p_object_version_number => p_rec.object_version_number
69: );
70: if not l_api_updating then

Line 94: nvl(pay_sbf_shd.g_old_rec.input_value_id, hr_api.g_number)

90: --
91: -- p_input_value_id
92: --
93: if nvl(p_rec.input_value_id, hr_api.g_number) <>
94: nvl(pay_sbf_shd.g_old_rec.input_value_id, hr_api.g_number)
95: then
96: hr_utility.set_location(l_proc, 25);
97: l_argument := 'p_input_value_id';
98: raise l_error;

Line 191: l_api_updating := pay_sbf_shd.api_updating

187: l_api_updating boolean;
188: --
189: Begin
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: l_api_updating := pay_sbf_shd.api_updating
192: (p_balance_feed_id => p_balance_feed_id
193: ,p_object_version_number => p_object_version_number
194: );
195: if (l_api_updating and nvl(p_balance_type_id, hr_api.g_number) <>

Line 196: nvl(pay_sbf_shd.g_old_rec.balance_type_id, hr_api.g_number)) or

192: (p_balance_feed_id => p_balance_feed_id
193: ,p_object_version_number => p_object_version_number
194: );
195: if (l_api_updating and nvl(p_balance_type_id, hr_api.g_number) <>
196: nvl(pay_sbf_shd.g_old_rec.balance_type_id, hr_api.g_number)) or
197: not l_api_updating
198: then
199: --
200: -- If the balance name is null then balance_type_id is mandatory.

Line 275: l_api_updating := pay_sbf_shd.api_updating

271: l_api_updating boolean;
272: --
273: Begin
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: l_api_updating := pay_sbf_shd.api_updating
276: (p_balance_feed_id => p_balance_feed_id
277: ,p_object_version_number => p_object_version_number
278: );
279: if (l_api_updating and nvl(p_balance_name, hr_api.g_varchar2) <>

Line 280: nvl(pay_sbf_shd.g_old_rec.balance_name, hr_api.g_varchar2)) or

276: (p_balance_feed_id => p_balance_feed_id
277: ,p_object_version_number => p_object_version_number
278: );
279: if (l_api_updating and nvl(p_balance_name, hr_api.g_varchar2) <>
280: nvl(pay_sbf_shd.g_old_rec.balance_name, hr_api.g_varchar2)) or
281: not l_api_updating
282: then
283: --
284: -- The balance name is mandatory if balance_type_id is null.

Line 325: l_api_updating := pay_sbf_shd.api_updating

321: l_api_updating boolean;
322: --
323: Begin
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: l_api_updating := pay_sbf_shd.api_updating
326: (p_balance_feed_id => p_balance_feed_id
327: ,p_object_version_number => p_object_version_number
328: );
329: if (l_api_updating and nvl(p_scale, hr_api.g_number) <>

Line 378: l_api_updating := pay_sbf_shd.api_updating

374: l_valid varchar2(1);
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: l_api_updating := pay_sbf_shd.api_updating
379: (p_balance_feed_id => p_balance_feed_id
380: ,p_object_version_number => p_object_version_number
381: );
382: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

Line 383: nvl(pay_sbf_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

379: (p_balance_feed_id => p_balance_feed_id
380: ,p_object_version_number => p_object_version_number
381: );
382: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
383: nvl(pay_sbf_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
384: not l_api_updating
385: then
386: if p_exclusion_rule_id is not null then
387: open csr_exclusion_rule_id_valid;

Line 442: Procedure insert_validate(p_rec in pay_sbf_shd.g_rec_type) is

438: End chk_delete;
439: -- ----------------------------------------------------------------------------
440: -- |---------------------------< insert_validate >----------------------------|
441: -- ----------------------------------------------------------------------------
442: Procedure insert_validate(p_rec in pay_sbf_shd.g_rec_type) is
443: --
444: l_proc varchar2(72) := g_package||'insert_validate';
445: l_template_id number;
446: --

Line 495: Procedure update_validate(p_rec in pay_sbf_shd.g_rec_type) is

491: --
492: -- ----------------------------------------------------------------------------
493: -- |---------------------------< update_validate >----------------------------|
494: -- ----------------------------------------------------------------------------
495: Procedure update_validate(p_rec in pay_sbf_shd.g_rec_type) is
496: --
497: l_proc varchar2(72) := g_package||'update_validate';
498: l_template_id number;
499: --

Line 548: Procedure delete_validate(p_rec in pay_sbf_shd.g_rec_type) is

544: --
545: -- ----------------------------------------------------------------------------
546: -- |---------------------------< delete_validate >----------------------------|
547: -- ----------------------------------------------------------------------------
548: Procedure delete_validate(p_rec in pay_sbf_shd.g_rec_type) is
549: --
550: l_proc varchar2(72) := g_package||'delete_validate';
551: --
552: Begin