APPS.PAY_SBF_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_sbf_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_sbf_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_sbf_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_sbf_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_sbf_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_sbf_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_sbf_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_sbf_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_sbf_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_sbf_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.balance_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.balance_type_id = hr_api.g_number) then
234: p_rec.balance_type_id :=
235: pay_sbf_shd.g_old_rec.balance_type_id;
236: End If;
237: If (p_rec.input_value_id = hr_api.g_number) then

Line 237: If (p_rec.input_value_id = hr_api.g_number) then

233: If (p_rec.balance_type_id = hr_api.g_number) then
234: p_rec.balance_type_id :=
235: pay_sbf_shd.g_old_rec.balance_type_id;
236: End If;
237: If (p_rec.input_value_id = hr_api.g_number) then
238: p_rec.input_value_id :=
239: pay_sbf_shd.g_old_rec.input_value_id;
240: End If;
241: If (p_rec.scale = hr_api.g_number) then

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

237: If (p_rec.input_value_id = hr_api.g_number) then
238: p_rec.input_value_id :=
239: pay_sbf_shd.g_old_rec.input_value_id;
240: End If;
241: If (p_rec.scale = hr_api.g_number) then
242: p_rec.scale :=
243: pay_sbf_shd.g_old_rec.scale;
244: End If;
245: If (p_rec.exclusion_rule_id = hr_api.g_number) then

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

241: If (p_rec.scale = hr_api.g_number) then
242: p_rec.scale :=
243: pay_sbf_shd.g_old_rec.scale;
244: End If;
245: If (p_rec.exclusion_rule_id = hr_api.g_number) then
246: p_rec.exclusion_rule_id :=
247: pay_sbf_shd.g_old_rec.exclusion_rule_id;
248: End If;
249: If (p_rec.balance_name = hr_api.g_varchar2) then

Line 249: If (p_rec.balance_name = hr_api.g_varchar2) then

245: If (p_rec.exclusion_rule_id = hr_api.g_number) then
246: p_rec.exclusion_rule_id :=
247: pay_sbf_shd.g_old_rec.exclusion_rule_id;
248: End If;
249: If (p_rec.balance_name = hr_api.g_varchar2) then
250: p_rec.balance_name :=
251: pay_sbf_shd.g_old_rec.balance_name;
252: End If;
253:

Line 310: p_scale in number default hr_api.g_number,

306: Procedure upd
307: (
308: p_effective_date in date,
309: p_balance_feed_id in number,
310: p_scale in number default hr_api.g_number,
311: p_exclusion_rule_id in number default hr_api.g_number,
312: p_object_version_number in out nocopy number
313: ) is
314: --

Line 311: p_exclusion_rule_id in number default hr_api.g_number,

307: (
308: p_effective_date in date,
309: p_balance_feed_id in number,
310: p_scale in number default hr_api.g_number,
311: p_exclusion_rule_id in number default hr_api.g_number,
312: p_object_version_number in out nocopy number
313: ) is
314: --
315: l_rec pay_sbf_shd.g_rec_type;

Line 328: hr_api.g_number,

324: l_rec :=
325: pay_sbf_shd.convert_args
326: (
327: p_balance_feed_id,
328: hr_api.g_number,
329: hr_api.g_number,
330: p_scale,
331: hr_api.g_varchar2,
332: p_exclusion_rule_id,

Line 329: hr_api.g_number,

325: pay_sbf_shd.convert_args
326: (
327: p_balance_feed_id,
328: hr_api.g_number,
329: hr_api.g_number,
330: p_scale,
331: hr_api.g_varchar2,
332: p_exclusion_rule_id,
333: p_object_version_number

Line 331: hr_api.g_varchar2,

327: p_balance_feed_id,
328: hr_api.g_number,
329: hr_api.g_number,
330: p_scale,
331: hr_api.g_varchar2,
332: p_exclusion_rule_id,
333: p_object_version_number
334: );
335: --