DBA Data[Home] [Help]

APPS.PAY_TFU_BUS dependencies on HR_API

Line 70: if nvl(p_rec.template_id, hr_api.g_number) <>

66: END IF;
67: --
68: -- p_template_id
69: --
70: if nvl(p_rec.template_id, hr_api.g_number) <>
71: nvl(pay_tfu_shd.g_old_rec.template_id, hr_api.g_number)
72: then
73: l_argument := 'p_template_id';
74: raise l_error;

Line 71: nvl(pay_tfu_shd.g_old_rec.template_id, hr_api.g_number)

67: --
68: -- p_template_id
69: --
70: if nvl(p_rec.template_id, hr_api.g_number) <>
71: nvl(pay_tfu_shd.g_old_rec.template_id, hr_api.g_number)
72: then
73: l_argument := 'p_template_id';
74: raise l_error;
75: end if;

Line 80: hr_api.argument_changed_error

76: --
77: exception
78: when l_error then
79: hr_utility.set_location('Leaving:'||l_proc, 30);
80: hr_api.argument_changed_error
81: (p_api_name => l_proc
82: ,p_argument => l_argument);
83: when others then
84: raise;

Line 124: nvl(p_object_id, hr_api.g_number) <>

120: ,p_object_version_number => p_object_version_number
121: );
122: if l_api_updating and
123: (
124: nvl(p_object_id, hr_api.g_number) <>
125: nvl(pay_tfu_shd.g_old_rec.object_id, hr_api.g_number) or
126: nvl(p_formula_id, hr_api.g_number) <>
127: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)
128: ) or

Line 125: nvl(pay_tfu_shd.g_old_rec.object_id, hr_api.g_number) or

121: );
122: if l_api_updating and
123: (
124: nvl(p_object_id, hr_api.g_number) <>
125: nvl(pay_tfu_shd.g_old_rec.object_id, hr_api.g_number) or
126: nvl(p_formula_id, hr_api.g_number) <>
127: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)
128: ) or
129: not l_api_updating then

Line 126: nvl(p_formula_id, hr_api.g_number) <>

122: if l_api_updating and
123: (
124: nvl(p_object_id, hr_api.g_number) <>
125: nvl(pay_tfu_shd.g_old_rec.object_id, hr_api.g_number) or
126: nvl(p_formula_id, hr_api.g_number) <>
127: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)
128: ) or
129: not l_api_updating then
130: open csr_uniqueness_chk

Line 127: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)

123: (
124: nvl(p_object_id, hr_api.g_number) <>
125: nvl(pay_tfu_shd.g_old_rec.object_id, hr_api.g_number) or
126: nvl(p_formula_id, hr_api.g_number) <>
127: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)
128: ) or
129: not l_api_updating then
130: open csr_uniqueness_chk
131: (p_template_ff_usage_id => nvl(p_template_ff_usage_id, hr_api.g_number)

Line 131: (p_template_ff_usage_id => nvl(p_template_ff_usage_id, hr_api.g_number)

127: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)
128: ) or
129: not l_api_updating then
130: open csr_uniqueness_chk
131: (p_template_ff_usage_id => nvl(p_template_ff_usage_id, hr_api.g_number)
132: ,p_template_id => p_template_id
133: ,p_object_id => p_object_id
134: ,p_formula_id => p_formula_id
135: );

Line 206: hr_api.mandatory_arg_error

202: Begin
203: --
204: -- Check that template_id is not null.
205: --
206: hr_api.mandatory_arg_error
207: (p_api_name => l_proc
208: ,p_argument => 'p_object_id'
209: ,p_argument_value => p_object_id
210: );

Line 249: hr_api.mandatory_arg_error

245: Begin
246: --
247: -- Check that exclusion_id is not null.
248: --
249: hr_api.mandatory_arg_error
250: (p_api_name => l_proc
251: ,p_argument => 'exclusion_rule_id'
252: ,p_argument_value => p_exclusion_rule_id
253: );

Line 259: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

255: l_api_updating := pay_tfu_shd.api_updating
256: (p_template_ff_usage_id => p_template_ff_usage_id
257: ,p_object_version_number => p_object_version_number
258: );
259: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
260: nvl(pay_tfu_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
261: not l_api_updating
262: then
263: if p_exclusion_rule_id is not null then

Line 260: nvl(pay_tfu_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

256: (p_template_ff_usage_id => p_template_ff_usage_id
257: ,p_object_version_number => p_object_version_number
258: );
259: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
260: nvl(pay_tfu_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
261: not l_api_updating
262: then
263: if p_exclusion_rule_id is not null then
264: open csr_exclusion_rule_id_valid;

Line 317: if (l_api_updating and nvl(p_formula_id, hr_api.g_number) <>

313: l_api_updating := pay_tfu_shd.api_updating
314: (p_template_ff_usage_id => p_template_ff_usage_id
315: ,p_object_version_number => p_object_version_number
316: );
317: if (l_api_updating and nvl(p_formula_id, hr_api.g_number) <>
318: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)) or
319: not l_api_updating
320: then
321: if p_formula_id is not null then

Line 318: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)) or

314: (p_template_ff_usage_id => p_template_ff_usage_id
315: ,p_object_version_number => p_object_version_number
316: );
317: if (l_api_updating and nvl(p_formula_id, hr_api.g_number) <>
318: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)) or
319: not l_api_updating
320: then
321: if p_formula_id is not null then
322: open csr_formula_valid;