APPS.PAY_SFR_BUS dependencies on PAY_SFR_SHD

Line 14: (p_rec in pay_sfr_shd.g_rec_type

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

Line 35: l_api_updating := pay_sfr_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_sfr_shd.api_updating
36: (p_formula_result_rule_id => p_rec.formula_result_rule_id
37: ,p_object_version_number => p_rec.object_version_number
38: );
39: if not l_api_updating then

Line 63: nvl(pay_sfr_shd.g_old_rec.shadow_element_type_id, hr_api.g_number)

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

Line 136: l_api_updating := pay_sfr_shd.api_updating

132: l_api_updating boolean;
133: --
134: Begin
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: l_api_updating := pay_sfr_shd.api_updating
137: (p_formula_result_rule_id => p_formula_result_rule_id
138: ,p_object_version_number => p_object_version_number
139: );
140: if (l_api_updating and

Line 142: nvl(pay_sfr_shd.g_old_rec.result_rule_type, hr_api.g_varchar2))

138: ,p_object_version_number => p_object_version_number
139: );
140: if (l_api_updating and
141: nvl(p_result_rule_type, hr_api.g_varchar2) <>
142: nvl(pay_sfr_shd.g_old_rec.result_rule_type, hr_api.g_varchar2))
143: or not l_api_updating
144: then
145: --
146: -- Result rule type is mandatory.

Line 200: l_api_updating := pay_sfr_shd.api_updating

196: l_api_updating boolean;
197: --
198: Begin
199: hr_utility.set_location('Entering:'||l_proc, 5);
200: l_api_updating := pay_sfr_shd.api_updating
201: (p_formula_result_rule_id => p_formula_result_rule_id
202: ,p_object_version_number => p_object_version_number
203: );
204: if (l_api_updating and nvl(p_element_type_id, hr_api.g_number) <>

Line 205: nvl(pay_sfr_shd.g_old_rec.element_type_id, hr_api.g_number)) or

201: (p_formula_result_rule_id => p_formula_result_rule_id
202: ,p_object_version_number => p_object_version_number
203: );
204: if (l_api_updating and nvl(p_element_type_id, hr_api.g_number) <>
205: nvl(pay_sfr_shd.g_old_rec.element_type_id, hr_api.g_number)) or
206: not l_api_updating
207: then
208: if p_element_type_id is not null then
209: --

Line 264: l_api_updating := pay_sfr_shd.api_updating

260: l_api_updating boolean;
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: l_api_updating := pay_sfr_shd.api_updating
265: (p_formula_result_rule_id => p_formula_result_rule_id
266: ,p_object_version_number => p_object_version_number
267: );
268: if (l_api_updating and nvl(p_input_value_id, hr_api.g_number) <>

Line 269: nvl(pay_sfr_shd.g_old_rec.input_value_id, hr_api.g_number)) or

265: (p_formula_result_rule_id => p_formula_result_rule_id
266: ,p_object_version_number => p_object_version_number
267: );
268: if (l_api_updating and nvl(p_input_value_id, hr_api.g_number) <>
269: nvl(pay_sfr_shd.g_old_rec.input_value_id, hr_api.g_number)) or
270: not l_api_updating
271: then
272: if p_input_value_id is not null then
273: --

Line 308: l_api_updating := pay_sfr_shd.api_updating

304: l_api_updating boolean;
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: l_api_updating := pay_sfr_shd.api_updating
309: (p_formula_result_rule_id => p_formula_result_rule_id
310: ,p_object_version_number => p_object_version_number
311: );
312: if (l_api_updating and nvl(p_result_name, hr_api.g_varchar2) <>

Line 313: nvl(pay_sfr_shd.g_old_rec.result_name, hr_api.g_varchar2)) or

309: (p_formula_result_rule_id => p_formula_result_rule_id
310: ,p_object_version_number => p_object_version_number
311: );
312: if (l_api_updating and nvl(p_result_name, hr_api.g_varchar2) <>
313: nvl(pay_sfr_shd.g_old_rec.result_name, hr_api.g_varchar2)) or
314: not l_api_updating
315: then
316: --
317: -- Check that the name format is correct (not null database item name).

Line 350: l_api_updating := pay_sfr_shd.api_updating

346: l_result_rule_changed boolean;
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: l_api_updating := pay_sfr_shd.api_updating
351: (p_formula_result_rule_id => p_formula_result_rule_id
352: ,p_object_version_number => p_object_version_number
353: );
354: l_result_rule_changed :=

Line 356: nvl(pay_sfr_shd.g_old_rec.result_rule_type, hr_api.g_varchar2);

352: ,p_object_version_number => p_object_version_number
353: );
354: l_result_rule_changed :=
355: l_api_updating and nvl(p_result_rule_type, hr_api.g_varchar2) <>
356: nvl(pay_sfr_shd.g_old_rec.result_rule_type, hr_api.g_varchar2);
357: --
358: if (l_api_updating and
359: nvl(p_severity_level, hr_api.g_varchar2) <>
360: nvl(pay_sfr_shd.g_old_rec.severity_level, hr_api.g_varchar2))

Line 360: nvl(pay_sfr_shd.g_old_rec.severity_level, hr_api.g_varchar2))

356: nvl(pay_sfr_shd.g_old_rec.result_rule_type, hr_api.g_varchar2);
357: --
358: if (l_api_updating and
359: nvl(p_severity_level, hr_api.g_varchar2) <>
360: nvl(pay_sfr_shd.g_old_rec.severity_level, hr_api.g_varchar2))
361: or not l_api_updating or l_result_rule_changed
362: then
363: --
364: -- Severity level is mandatory if result rule type is 'M'.

Line 425: l_api_updating := pay_sfr_shd.api_updating

421: l_valid varchar2(1);
422: --
423: Begin
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: l_api_updating := pay_sfr_shd.api_updating
426: (p_formula_result_rule_id => p_formula_result_rule_id
427: ,p_object_version_number => p_object_version_number
428: );
429: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

Line 430: nvl(pay_sfr_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

426: (p_formula_result_rule_id => p_formula_result_rule_id
427: ,p_object_version_number => p_object_version_number
428: );
429: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
430: nvl(pay_sfr_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
431: not l_api_updating
432: then
433: if p_exclusion_rule_id is not null then
434: open csr_exclusion_rule_id_valid;

Line 491: ,p_rec in pay_sfr_shd.g_rec_type

487: -- |---------------------------< insert_validate >----------------------------|
488: -- ----------------------------------------------------------------------------
489: Procedure insert_validate
490: (p_effective_date in date
491: ,p_rec in pay_sfr_shd.g_rec_type
492: ) is
493: --
494: l_proc varchar2(72) := g_package||'insert_validate';
495: --

Line 555: ,p_rec in pay_sfr_shd.g_rec_type

551: -- |---------------------------< update_validate >----------------------------|
552: -- ----------------------------------------------------------------------------
553: Procedure update_validate
554: (p_effective_date in date
555: ,p_rec in pay_sfr_shd.g_rec_type
556: ) is
557: --
558: l_proc varchar2(72) := g_package||'update_validate';
559: --

Line 618: Procedure delete_validate(p_rec in pay_sfr_shd.g_rec_type) is

614: --
615: -- ----------------------------------------------------------------------------
616: -- |---------------------------< delete_validate >----------------------------|
617: -- ----------------------------------------------------------------------------
618: Procedure delete_validate(p_rec in pay_sfr_shd.g_rec_type) is
619: --
620: l_proc varchar2(72) := g_package||'delete_validate';
621: --
622: Begin