DBA Data[Home] [Help]

APPS.PAY_SSR_UPD dependencies on HR_API

Line 76: When hr_api.check_integrity_violated Then

72: --
73: hr_utility.set_location(' Leaving:'||l_proc, 10);
74: --
75: Exception
76: When hr_api.check_integrity_violated Then
77: -- A check constraint has been violated
78: pay_ssr_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When hr_api.parent_integrity_violated Then

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

75: Exception
76: When hr_api.check_integrity_violated Then
77: -- A check constraint has been violated
78: pay_ssr_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When hr_api.parent_integrity_violated Then
81: -- Parent integrity has been violated
82: pay_ssr_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 80: When hr_api.parent_integrity_violated Then

76: When hr_api.check_integrity_violated Then
77: -- A check constraint has been violated
78: pay_ssr_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When hr_api.parent_integrity_violated Then
81: -- Parent integrity has been violated
82: pay_ssr_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When hr_api.unique_integrity_violated Then

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

79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When hr_api.parent_integrity_violated Then
81: -- Parent integrity has been violated
82: pay_ssr_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When hr_api.unique_integrity_violated Then
85: -- Unique integrity has been violated
86: pay_ssr_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 84: When hr_api.unique_integrity_violated Then

80: When hr_api.parent_integrity_violated Then
81: -- Parent integrity has been violated
82: pay_ssr_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When hr_api.unique_integrity_violated Then
85: -- Unique integrity has been violated
86: pay_ssr_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then

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

83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When hr_api.unique_integrity_violated Then
85: -- Unique integrity has been violated
86: pay_ssr_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: Raise;
90: End update_dml;
91: --

Line 233: If (p_rec.element_type_id = hr_api.g_number) then

229: -- p_rec plsql record structure
230: -- to see if a system default is being used. If a system default
231: -- is being used then we must set to the 'current' argument value.
232: --
233: If (p_rec.element_type_id = hr_api.g_number) then
234: p_rec.element_type_id :=
235: pay_ssr_shd.g_old_rec.element_type_id;
236: End If;
237: If (p_rec.element_classification = hr_api.g_varchar2) then

Line 237: If (p_rec.element_classification = hr_api.g_varchar2) then

233: If (p_rec.element_type_id = hr_api.g_number) then
234: p_rec.element_type_id :=
235: pay_ssr_shd.g_old_rec.element_type_id;
236: End If;
237: If (p_rec.element_classification = hr_api.g_varchar2) then
238: p_rec.element_classification :=
239: pay_ssr_shd.g_old_rec.element_classification;
240: End If;
241: If (p_rec.exclusion_rule_id = hr_api.g_number) then

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

237: If (p_rec.element_classification = hr_api.g_varchar2) then
238: p_rec.element_classification :=
239: pay_ssr_shd.g_old_rec.element_classification;
240: End If;
241: If (p_rec.exclusion_rule_id = hr_api.g_number) then
242: p_rec.exclusion_rule_id :=
243: pay_ssr_shd.g_old_rec.exclusion_rule_id;
244: End If;
245: --

Line 301: p_element_classification in varchar2 default hr_api.g_varchar2,

297: Procedure upd
298: (
299: p_effective_date in date,
300: p_sub_classification_rule_id in number,
301: p_element_classification in varchar2 default hr_api.g_varchar2,
302: p_object_version_number in out nocopy number
303: ,p_exclusion_rule_id in number default hr_api.g_number
304: ) is
305: --

Line 303: ,p_exclusion_rule_id in number default hr_api.g_number

299: p_effective_date in date,
300: p_sub_classification_rule_id in number,
301: p_element_classification in varchar2 default hr_api.g_varchar2,
302: p_object_version_number in out nocopy number
303: ,p_exclusion_rule_id in number default hr_api.g_number
304: ) is
305: --
306: l_rec pay_ssr_shd.g_rec_type;
307: l_proc varchar2(72) := g_package||'upd';

Line 319: hr_api.g_number,

315: l_rec :=
316: pay_ssr_shd.convert_args
317: (
318: p_sub_classification_rule_id,
319: hr_api.g_number,
320: p_element_classification,
321: p_object_version_number
322: ,p_exclusion_rule_id
323: );