DBA Data[Home] [Help]

APPS.PAY_SIR_BUS dependencies on PAY_SIR_SHD

Line 39: (p_rec in pay_sir_shd.g_rec_type

35: --
36: -- {End Of Comments}
37: -- ----------------------------------------------------------------------------
38: Procedure chk_non_updateable_args
39: (p_rec in pay_sir_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_sir_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_sir_shd.api_updating
52: (p_iterative_rule_id => p_rec.iterative_rule_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_sir_shd.g_old_rec.element_type_id, hr_api.g_number)

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

Line 138: l_api_updating := pay_sir_shd.api_updating

134: l_api_updating boolean;
135: --
136: Begin
137: hr_utility.set_location('Entering:'||l_proc, 5);
138: l_api_updating := pay_sir_shd.api_updating
139: (p_iterative_rule_id => p_iterative_rule_id
140: ,p_object_version_number => p_object_version_number
141: );
142: if (l_api_updating and nvl(p_result_name, hr_api.g_varchar2) <>

Line 143: nvl(pay_sir_shd.g_old_rec.result_name, hr_api.g_varchar2)) or

139: (p_iterative_rule_id => p_iterative_rule_id
140: ,p_object_version_number => p_object_version_number
141: );
142: if (l_api_updating and nvl(p_result_name, hr_api.g_varchar2) <>
143: nvl(pay_sir_shd.g_old_rec.result_name, hr_api.g_varchar2)) or
144: not l_api_updating
145: then
146: --
147: -- Check that the name format is correct (not null database item name).

Line 193: l_api_updating := pay_sir_shd.api_updating

189: l_api_updating boolean;
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: l_api_updating := pay_sir_shd.api_updating
194: (p_iterative_rule_id => p_iterative_rule_id
195: ,p_object_version_number => p_object_version_number
196: );
197: if (l_api_updating and nvl(p_input_value_id, hr_api.g_number) <>

Line 198: nvl(pay_sir_shd.g_old_rec.input_value_id, hr_api.g_number)) or

194: (p_iterative_rule_id => p_iterative_rule_id
195: ,p_object_version_number => p_object_version_number
196: );
197: if (l_api_updating and nvl(p_input_value_id, hr_api.g_number) <>
198: nvl(pay_sir_shd.g_old_rec.input_value_id, hr_api.g_number)) or
199: not l_api_updating
200: then
201: if p_input_value_id is not null then
202: --

Line 233: l_api_updating := pay_sir_shd.api_updating

229: l_api_updating boolean;
230: --
231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: l_api_updating := pay_sir_shd.api_updating
234: (p_iterative_rule_id => p_iterative_rule_id
235: ,p_object_version_number => p_object_version_number
236: );
237: if (l_api_updating and nvl(p_iterative_rule_type, hr_api.g_varchar2) <>

Line 238: nvl(pay_sir_shd.g_old_rec.iterative_rule_type, hr_api.g_varchar2)) or

234: (p_iterative_rule_id => p_iterative_rule_id
235: ,p_object_version_number => p_object_version_number
236: );
237: if (l_api_updating and nvl(p_iterative_rule_type, hr_api.g_varchar2) <>
238: nvl(pay_sir_shd.g_old_rec.iterative_rule_type, hr_api.g_varchar2)) or
239: not l_api_updating
240: then
241: --
242: -- Iterative rule type is mandatory.

Line 282: l_api_updating := pay_sir_shd.api_updating

278: l_api_updating boolean;
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: l_api_updating := pay_sir_shd.api_updating
283: (p_iterative_rule_id => p_iterative_rule_id
284: ,p_object_version_number => p_object_version_number
285: );
286: --

Line 288: nvl(pay_sir_shd.g_old_rec.severity_level, hr_api.g_varchar2)) or

284: ,p_object_version_number => p_object_version_number
285: );
286: --
287: if (l_api_updating and nvl(p_severity_level, hr_api.g_varchar2) <>
288: nvl(pay_sir_shd.g_old_rec.severity_level, hr_api.g_varchar2)) or
289: not l_api_updating
290: then
291: if p_severity_level is not null then
292: --

Line 337: l_api_updating := pay_sir_shd.api_updating

333: l_valid varchar2(1);
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: l_api_updating := pay_sir_shd.api_updating
338: (p_iterative_rule_id => p_iterative_rule_id
339: ,p_object_version_number => p_object_version_number
340: );
341: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

Line 342: nvl(pay_sir_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

338: (p_iterative_rule_id => p_iterative_rule_id
339: ,p_object_version_number => p_object_version_number
340: );
341: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
342: nvl(pay_sir_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
343: not l_api_updating
344: then
345: if p_exclusion_rule_id is not null then
346: open c_exclusion_rule_is_valid;

Line 403: ,p_rec in pay_sir_shd.g_rec_type

399: -- |---------------------------< insert_validate >----------------------------|
400: -- ----------------------------------------------------------------------------
401: Procedure insert_validate
402: (p_effective_date in date
403: ,p_rec in pay_sir_shd.g_rec_type
404: ) is
405: --
406: l_proc varchar2(72) := g_package||'insert_validate';
407: --

Line 457: ,p_rec in pay_sir_shd.g_rec_type

453: -- |---------------------------< update_validate >----------------------------|
454: -- ----------------------------------------------------------------------------
455: Procedure update_validate
456: (p_effective_date in date
457: ,p_rec in pay_sir_shd.g_rec_type
458: ) is
459: --
460: l_proc varchar2(72) := g_package||'update_validate';
461: --

Line 510: (p_rec in pay_sir_shd.g_rec_type) is

506: -- ----------------------------------------------------------------------------
507: -- |---------------------------< delete_validate >----------------------------|
508: -- ----------------------------------------------------------------------------
509: Procedure delete_validate
510: (p_rec in pay_sir_shd.g_rec_type) is
511: --
512: l_proc varchar2(72) := g_package||'delete_validate';
513: --
514: Begin