DBA Data[Home] [Help]

APPS.PAY_TFU_UPD dependencies on HR_API

Line 85: When hr_api.check_integrity_violated Then

81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: --
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: pay_tfu_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: pay_tfu_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: pay_tfu_shd.constraint_error

Line 90: When hr_api.parent_integrity_violated Then

86: -- A check constraint has been violated
87: --
88: pay_tfu_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: pay_tfu_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: pay_tfu_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: pay_tfu_shd.constraint_error

Line 95: When hr_api.unique_integrity_violated Then

91: -- Parent integrity has been violated
92: --
93: pay_tfu_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: pay_tfu_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: pay_tfu_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: --
102: Raise;
103: End update_dml;

Line 248: If (p_rec.template_id = hr_api.g_number) then

244: -- p_rec plsql record structure
245: -- to see if a system default is being used. If a system default
246: -- is being used then we must set to the 'current' argument value.
247: --
248: If (p_rec.template_id = hr_api.g_number) then
249: p_rec.template_id :=
250: pay_tfu_shd.g_old_rec.template_id;
251: End If;
252: If (p_rec.formula_id = hr_api.g_number) then

Line 252: If (p_rec.formula_id = hr_api.g_number) then

248: If (p_rec.template_id = hr_api.g_number) then
249: p_rec.template_id :=
250: pay_tfu_shd.g_old_rec.template_id;
251: End If;
252: If (p_rec.formula_id = hr_api.g_number) then
253: p_rec.formula_id :=
254: pay_tfu_shd.g_old_rec.formula_id;
255: End If;
256: If (p_rec.object_id = hr_api.g_number) then

Line 256: If (p_rec.object_id = hr_api.g_number) then

252: If (p_rec.formula_id = hr_api.g_number) then
253: p_rec.formula_id :=
254: pay_tfu_shd.g_old_rec.formula_id;
255: End If;
256: If (p_rec.object_id = hr_api.g_number) then
257: p_rec.object_id :=
258: pay_tfu_shd.g_old_rec.object_id;
259: End If;
260: If (p_rec.exclusion_rule_id = hr_api.g_number) then

Line 260: If (p_rec.exclusion_rule_id = hr_api.g_number) then

256: If (p_rec.object_id = hr_api.g_number) then
257: p_rec.object_id :=
258: pay_tfu_shd.g_old_rec.object_id;
259: End If;
260: If (p_rec.exclusion_rule_id = hr_api.g_number) then
261: p_rec.exclusion_rule_id :=
262: pay_tfu_shd.g_old_rec.exclusion_rule_id;
263: End If;
264: --

Line 328: ,p_formula_id in number default hr_api.g_number

324: Procedure upd
325: (p_effective_date in date
326: ,p_template_ff_usage_id in number
327: ,p_object_version_number in out nocopy number
328: ,p_formula_id in number default hr_api.g_number
329: ,p_object_id in number default hr_api.g_number
330: ,p_exclusion_rule_id in number default hr_api.g_number
331: ) is
332: --

Line 329: ,p_object_id in number default hr_api.g_number

325: (p_effective_date in date
326: ,p_template_ff_usage_id in number
327: ,p_object_version_number in out nocopy number
328: ,p_formula_id in number default hr_api.g_number
329: ,p_object_id in number default hr_api.g_number
330: ,p_exclusion_rule_id in number default hr_api.g_number
331: ) is
332: --
333: l_rec pay_tfu_shd.g_rec_type;

Line 330: ,p_exclusion_rule_id in number default hr_api.g_number

326: ,p_template_ff_usage_id in number
327: ,p_object_version_number in out nocopy number
328: ,p_formula_id in number default hr_api.g_number
329: ,p_object_id in number default hr_api.g_number
330: ,p_exclusion_rule_id in number default hr_api.g_number
331: ) is
332: --
333: l_rec pay_tfu_shd.g_rec_type;
334: l_proc varchar2(72) := g_package||'upd';

Line 345: ,hr_api.g_number

341: --
342: l_rec :=
343: pay_tfu_shd.convert_args
344: (p_template_ff_usage_id
345: ,hr_api.g_number
346: ,p_formula_id
347: ,p_object_id
348: ,p_object_version_number
349: ,p_exclusion_rule_id