DBA Data[Home] [Help]

APPS.PAY_SBC_BUS dependencies on PAY_SBC_SHD

Line 14: (p_rec in pay_sbc_shd.g_rec_type

10: -- ----------------------------------------------------------------------------
11: -- |-----------------------< chk_non_updateable_args >------------------------|
12: -- ----------------------------------------------------------------------------
13: Procedure chk_non_updateable_args
14: (p_rec in pay_sbc_shd.g_rec_type
15: ) is
16: --
17: -- Cursor to disallow update if a core balance classification has been
18: -- generated from this shadow balance classification.

Line 35: l_api_updating := pay_sbc_shd.api_updating

31: l_disallow varchar2(1);
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: l_api_updating := pay_sbc_shd.api_updating
36: (p_balance_classification_id => p_rec.balance_classification_id
37: ,p_object_version_number => p_rec.object_version_number
38: );
39: if not l_api_updating then

Line 63: nvl(pay_sbc_shd.g_old_rec.balance_type_id, hr_api.g_number)

59: --
60: -- p_balance_type_id
61: --
62: if nvl(p_rec.balance_type_id, hr_api.g_number) <>
63: nvl(pay_sbc_shd.g_old_rec.balance_type_id, hr_api.g_number)
64: then
65: hr_utility.set_location(l_proc, 20);
66: l_argument := 'p_balance_type_id';
67: raise l_error;

Line 107: l_api_updating := pay_sbc_shd.api_updating

103: l_valid varchar2(1);
104: --
105: Begin
106: hr_utility.set_location('Entering:'||l_proc, 5);
107: l_api_updating := pay_sbc_shd.api_updating
108: (p_balance_classification_id => p_balance_classification_id
109: ,p_object_version_number => p_object_version_number
110: );
111: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

Line 112: nvl(pay_sbc_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

108: (p_balance_classification_id => p_balance_classification_id
109: ,p_object_version_number => p_object_version_number
110: );
111: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
112: nvl(pay_sbc_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
113: not l_api_updating
114: then
115: if p_exclusion_rule_id is not null then
116: open csr_exclusion_rule_id_valid;

Line 195: l_api_updating := pay_sbc_shd.api_updating

191: l_exists varchar2(1);
192: --
193: Begin
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: l_api_updating := pay_sbc_shd.api_updating
196: (p_balance_classification_id => p_balance_classification_id
197: ,p_object_version_number => p_object_version_number
198: );
199: if (l_api_updating and nvl(p_element_classification, hr_api.g_varchar2)

Line 200: <> nvl(pay_sbc_shd.g_old_rec.element_classification, hr_api.g_varchar2))

196: (p_balance_classification_id => p_balance_classification_id
197: ,p_object_version_number => p_object_version_number
198: );
199: if (l_api_updating and nvl(p_element_classification, hr_api.g_varchar2)
200: <> nvl(pay_sbc_shd.g_old_rec.element_classification, hr_api.g_varchar2))
201: or not l_api_updating
202: then
203: --
204: -- Check that the element classification is not null.

Line 278: l_api_updating := pay_sbc_shd.api_updating

274: l_api_updating boolean;
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: l_api_updating := pay_sbc_shd.api_updating
279: (p_balance_classification_id => p_balance_classification_id
280: ,p_object_version_number => p_object_version_number
281: );
282: if (l_api_updating and nvl(p_scale, hr_api.g_number) <>

Line 283: nvl(pay_sbc_shd.g_old_rec.scale, hr_api.g_number)) or

279: (p_balance_classification_id => p_balance_classification_id
280: ,p_object_version_number => p_object_version_number
281: );
282: if (l_api_updating and nvl(p_scale, hr_api.g_number) <>
283: nvl(pay_sbc_shd.g_old_rec.scale, hr_api.g_number)) or
284: not l_api_updating
285: then
286: --
287: -- Check that scale is not null.

Line 310: Procedure insert_validate(p_rec in pay_sbc_shd.g_rec_type) is

306: End chk_scale;
307: -- ----------------------------------------------------------------------------
308: -- |---------------------------< insert_validate >----------------------------|
309: -- ----------------------------------------------------------------------------
310: Procedure insert_validate(p_rec in pay_sbc_shd.g_rec_type) is
311: --
312: l_proc varchar2(72) := g_package||'insert_validate';
313: l_template_id number;
314: --

Line 347: Procedure update_validate(p_rec in pay_sbc_shd.g_rec_type) is

343: --
344: -- ----------------------------------------------------------------------------
345: -- |---------------------------< update_validate >----------------------------|
346: -- ----------------------------------------------------------------------------
347: Procedure update_validate(p_rec in pay_sbc_shd.g_rec_type) is
348: --
349: l_proc varchar2(72) := g_package||'update_validate';
350: --
351: Begin

Line 383: Procedure delete_validate(p_rec in pay_sbc_shd.g_rec_type) is

379: --
380: -- ----------------------------------------------------------------------------
381: -- |---------------------------< delete_validate >----------------------------|
382: -- ----------------------------------------------------------------------------
383: Procedure delete_validate(p_rec in pay_sbc_shd.g_rec_type) is
384: --
385: l_proc varchar2(72) := g_package||'delete_validate';
386: --
387: Begin