APPS.PAY_SBA_UPD dependencies on HR_API

Line 84: When hr_api.check_integrity_violated Then

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

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

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

Line 89: When hr_api.parent_integrity_violated Then

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

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

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

Line 94: When hr_api.unique_integrity_violated Then

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

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

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

Line 246: If (p_rec.attribute_name = hr_api.g_varchar2) then

242: -- p_rec plsql record structure
243: -- to see if a system default is being used. If a system default
244: -- is being used then we must set to the 'current' argument value.
245: --
246: If (p_rec.attribute_name = hr_api.g_varchar2) then
247: p_rec.attribute_name :=
248: pay_sba_shd.g_old_rec.attribute_name;
249: End If;
250: If (p_rec.defined_balance_id = hr_api.g_number) then

Line 250: If (p_rec.defined_balance_id = hr_api.g_number) then

246: If (p_rec.attribute_name = hr_api.g_varchar2) then
247: p_rec.attribute_name :=
248: pay_sba_shd.g_old_rec.attribute_name;
249: End If;
250: If (p_rec.defined_balance_id = hr_api.g_number) then
251: p_rec.defined_balance_id :=
252: pay_sba_shd.g_old_rec.defined_balance_id;
253: End If;
254: If (p_rec.exclusion_rule_id = hr_api.g_number) then

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

250: If (p_rec.defined_balance_id = hr_api.g_number) then
251: p_rec.defined_balance_id :=
252: pay_sba_shd.g_old_rec.defined_balance_id;
253: End If;
254: If (p_rec.exclusion_rule_id = hr_api.g_number) then
255: p_rec.exclusion_rule_id :=
256: pay_sba_shd.g_old_rec.exclusion_rule_id;
257: End If;
258: --

Line 318: ,p_attribute_name in varchar2 default hr_api.g_varchar2

314: -- ----------------------------------------------------------------------------
315: Procedure upd
316: (p_balance_attribute_id in number
317: ,p_object_version_number in out nocopy number
318: ,p_attribute_name in varchar2 default hr_api.g_varchar2
319: ,p_defined_balance_id in number default hr_api.g_number
320: ,p_exclusion_rule_id in number default hr_api.g_number
321: ) is
322: --

Line 319: ,p_defined_balance_id in number default hr_api.g_number

315: Procedure upd
316: (p_balance_attribute_id in number
317: ,p_object_version_number in out nocopy number
318: ,p_attribute_name in varchar2 default hr_api.g_varchar2
319: ,p_defined_balance_id in number default hr_api.g_number
320: ,p_exclusion_rule_id in number default hr_api.g_number
321: ) is
322: --
323: l_rec pay_sba_shd.g_rec_type;

Line 320: ,p_exclusion_rule_id in number default hr_api.g_number

316: (p_balance_attribute_id in number
317: ,p_object_version_number in out nocopy number
318: ,p_attribute_name in varchar2 default hr_api.g_varchar2
319: ,p_defined_balance_id in number default hr_api.g_number
320: ,p_exclusion_rule_id in number default hr_api.g_number
321: ) is
322: --
323: l_rec pay_sba_shd.g_rec_type;
324: l_proc varchar2(72) := g_package||'upd';