DBA Data[Home] [Help]

APPS.PAY_SSR_BUS dependencies on PAY_SSR_SHD

Line 37: l_api_updating := pay_ssr_shd.api_updating

33: l_valid varchar2(1);
34: --
35: Begin
36: hr_utility.set_location('Entering:'||l_proc, 5);
37: l_api_updating := pay_ssr_shd.api_updating
38: (p_sub_classification_rule_id => p_sub_classification_rule_id
39: ,p_object_version_number => p_object_version_number
40: );
41: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

Line 42: nvl(pay_ssr_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

38: (p_sub_classification_rule_id => p_sub_classification_rule_id
39: ,p_object_version_number => p_object_version_number
40: );
41: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
42: nvl(pay_ssr_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
43: not l_api_updating
44: then
45: if p_exclusion_rule_id is not null then
46: open csr_exclusion_rule_id_valid;

Line 102: (p_rec in pay_ssr_shd.g_rec_type

98: -- ----------------------------------------------------------------------------
99: -- |-----------------------< chk_non_updateable_args >------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure chk_non_updateable_args
102: (p_rec in pay_ssr_shd.g_rec_type
103: ) is
104: --
105: -- Cursor to disallow update if a core balance classification has been
106: -- generated from this shadow balance classification.

Line 123: l_api_updating := pay_ssr_shd.api_updating

119: l_disallow varchar2(1);
120: --
121: Begin
122: hr_utility.set_location('Entering:'||l_proc, 5);
123: l_api_updating := pay_ssr_shd.api_updating
124: (p_sub_classification_rule_id => p_rec.sub_classification_rule_id
125: ,p_object_version_number => p_rec.object_version_number
126: );
127: if not l_api_updating then

Line 151: nvl(pay_ssr_shd.g_old_rec.element_type_id, hr_api.g_number)

147: --
148: -- p_element_type_id
149: --
150: if nvl(p_rec.element_type_id, hr_api.g_number) <>
151: nvl(pay_ssr_shd.g_old_rec.element_type_id, hr_api.g_number)
152: then
153: hr_utility.set_location(l_proc, 20);
154: l_argument := 'p_element_type_id';
155: raise l_error;

Line 234: l_api_updating := pay_ssr_shd.api_updating

230: l_exists varchar2(1);
231: --
232: Begin
233: hr_utility.set_location('Entering:'||l_proc, 5);
234: l_api_updating := pay_ssr_shd.api_updating
235: (p_sub_classification_rule_id => p_sub_classification_rule_id
236: ,p_object_version_number => p_object_version_number
237: );
238: if (l_api_updating and nvl(p_element_classification, hr_api.g_varchar2)

Line 239: <> nvl(pay_ssr_shd.g_old_rec.element_classification, hr_api.g_varchar2))

235: (p_sub_classification_rule_id => p_sub_classification_rule_id
236: ,p_object_version_number => p_object_version_number
237: );
238: if (l_api_updating and nvl(p_element_classification, hr_api.g_varchar2)
239: <> nvl(pay_ssr_shd.g_old_rec.element_classification, hr_api.g_varchar2))
240: or not l_api_updating
241: then
242: --
243: -- Check that the element classification is not null.

Line 268: Procedure insert_validate(p_rec in pay_ssr_shd.g_rec_type) is

264: End chk_ele_classification;
265: -- ----------------------------------------------------------------------------
266: -- |---------------------------< insert_validate >----------------------------|
267: -- ----------------------------------------------------------------------------
268: Procedure insert_validate(p_rec in pay_ssr_shd.g_rec_type) is
269: --
270: l_proc varchar2(72) := g_package||'insert_validate';
271: --
272: Begin

Line 299: Procedure update_validate(p_rec in pay_ssr_shd.g_rec_type) is

295: --
296: -- ----------------------------------------------------------------------------
297: -- |---------------------------< update_validate >----------------------------|
298: -- ----------------------------------------------------------------------------
299: Procedure update_validate(p_rec in pay_ssr_shd.g_rec_type) is
300: --
301: l_proc varchar2(72) := g_package||'update_validate';
302: --
303: Begin

Line 330: Procedure delete_validate(p_rec in pay_ssr_shd.g_rec_type) is

326: --
327: -- ----------------------------------------------------------------------------
328: -- |---------------------------< delete_validate >----------------------------|
329: -- ----------------------------------------------------------------------------
330: Procedure delete_validate(p_rec in pay_ssr_shd.g_rec_type) is
331: --
332: l_proc varchar2(72) := g_package||'delete_validate';
333: --
334: Begin