APPS.PAY_TER_UPD dependencies on HR_API

Line 72: When hr_api.check_integrity_violated Then

68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception
72: When hr_api.check_integrity_violated Then
73: -- A check constraint has been violated
74: pay_ter_shd.constraint_error
75: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
76: When hr_api.parent_integrity_violated Then

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

71: Exception
72: When hr_api.check_integrity_violated Then
73: -- A check constraint has been violated
74: pay_ter_shd.constraint_error
75: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
76: When hr_api.parent_integrity_violated Then
77: -- Parent integrity has been violated
78: pay_ter_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 76: When hr_api.parent_integrity_violated Then

72: When hr_api.check_integrity_violated Then
73: -- A check constraint has been violated
74: pay_ter_shd.constraint_error
75: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
76: When hr_api.parent_integrity_violated Then
77: -- Parent integrity has been violated
78: pay_ter_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When hr_api.unique_integrity_violated Then

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

75: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
76: When hr_api.parent_integrity_violated Then
77: -- Parent integrity has been violated
78: pay_ter_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When hr_api.unique_integrity_violated Then
81: -- Unique integrity has been violated
82: pay_ter_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 80: When hr_api.unique_integrity_violated Then

76: When hr_api.parent_integrity_violated Then
77: -- Parent integrity has been violated
78: pay_ter_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When hr_api.unique_integrity_violated Then
81: -- Unique integrity has been violated
82: pay_ter_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When Others 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.unique_integrity_violated Then
81: -- Unique integrity has been violated
82: pay_ter_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When Others Then
85: Raise;
86: End update_dml;
87: --

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

225: -- p_rec plsql record structure
226: -- to see if a system default is being used. If a system default
227: -- is being used then we must set to the 'current' argument value.
228: --
229: If (p_rec.template_id = hr_api.g_number) then
230: p_rec.template_id :=
231: pay_ter_shd.g_old_rec.template_id;
232: End If;
233: If (p_rec.flexfield_column = hr_api.g_varchar2) then

Line 233: If (p_rec.flexfield_column = hr_api.g_varchar2) then

229: If (p_rec.template_id = hr_api.g_number) then
230: p_rec.template_id :=
231: pay_ter_shd.g_old_rec.template_id;
232: End If;
233: If (p_rec.flexfield_column = hr_api.g_varchar2) then
234: p_rec.flexfield_column :=
235: pay_ter_shd.g_old_rec.flexfield_column;
236: End If;
237: If (p_rec.exclusion_value = hr_api.g_varchar2) then

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

233: If (p_rec.flexfield_column = hr_api.g_varchar2) then
234: p_rec.flexfield_column :=
235: pay_ter_shd.g_old_rec.flexfield_column;
236: End If;
237: If (p_rec.exclusion_value = hr_api.g_varchar2) then
238: p_rec.exclusion_value :=
239: pay_ter_shd.g_old_rec.exclusion_value;
240: End If;
241: If (p_rec.description = hr_api.g_varchar2) then

Line 241: If (p_rec.description = hr_api.g_varchar2) then

237: If (p_rec.exclusion_value = hr_api.g_varchar2) then
238: p_rec.exclusion_value :=
239: pay_ter_shd.g_old_rec.exclusion_value;
240: End If;
241: If (p_rec.description = hr_api.g_varchar2) then
242: p_rec.description :=
243: pay_ter_shd.g_old_rec.description;
244: End If;
245:

Line 300: p_flexfield_column in varchar2 default hr_api.g_varchar2,

296: -- ----------------------------------------------------------------------------
297: Procedure upd
298: (
299: p_exclusion_rule_id in number,
300: p_flexfield_column in varchar2 default hr_api.g_varchar2,
301: p_exclusion_value in varchar2 default hr_api.g_varchar2,
302: p_description in varchar2 default hr_api.g_varchar2,
303: p_object_version_number in out nocopy number
304: ) is

Line 301: p_exclusion_value in varchar2 default hr_api.g_varchar2,

297: Procedure upd
298: (
299: p_exclusion_rule_id in number,
300: p_flexfield_column in varchar2 default hr_api.g_varchar2,
301: p_exclusion_value in varchar2 default hr_api.g_varchar2,
302: p_description in varchar2 default hr_api.g_varchar2,
303: p_object_version_number in out nocopy number
304: ) is
305: --

Line 302: p_description in varchar2 default hr_api.g_varchar2,

298: (
299: p_exclusion_rule_id in number,
300: p_flexfield_column in varchar2 default hr_api.g_varchar2,
301: p_exclusion_value in varchar2 default hr_api.g_varchar2,
302: p_description in varchar2 default hr_api.g_varchar2,
303: p_object_version_number in out nocopy number
304: ) is
305: --
306: l_rec pay_ter_shd.g_rec_type;

Line 319: hr_api.g_number,

315: l_rec :=
316: pay_ter_shd.convert_args
317: (
318: p_exclusion_rule_id,
319: hr_api.g_number,
320: p_flexfield_column,
321: p_exclusion_value,
322: p_description,
323: p_object_version_number