APPS.IRC_IAS_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: irc_ias_shd.g_api_dml := false; -- Unset the dml status
88: --
89: irc_ias_shd.constraint_error

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

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

Line 91: When hr_api.parent_integrity_violated Then

87: irc_ias_shd.g_api_dml := false; -- Unset the dml status
88: --
89: irc_ias_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: irc_ias_shd.g_api_dml := false; -- Unset the dml status
94: --
95: irc_ias_shd.constraint_error

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

92: -- Parent integrity has been violated
93: irc_ias_shd.g_api_dml := false; -- Unset the dml status
94: --
95: irc_ias_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: irc_ias_shd.g_api_dml := false; -- Unset the dml status
100: --

Line 97: When hr_api.unique_integrity_violated Then

93: irc_ias_shd.g_api_dml := false; -- Unset the dml status
94: --
95: irc_ias_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: irc_ias_shd.g_api_dml := false; -- Unset the dml status
100: --
101: irc_ias_shd.constraint_error

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

98: -- Unique integrity has been violated
99: irc_ias_shd.g_api_dml := false; -- Unset the dml status
100: --
101: irc_ias_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: irc_ias_shd.g_api_dml := false; -- Unset the dml status
105: --
106: Raise;

Line 222: when hr_api.cannot_find_prog_unit then

218: );
219: --
220: exception
221: --
222: when hr_api.cannot_find_prog_unit then
223: --
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'IRC_ASSIGNMENT_STATUSES'
226: ,p_hook_type => 'AU');

Line 224: hr_api.cannot_find_prog_unit_error

220: exception
221: --
222: when hr_api.cannot_find_prog_unit then
223: --
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'IRC_ASSIGNMENT_STATUSES'
226: ,p_hook_type => 'AU');
227: --
228: end;

Line 287: If (p_rec.assignment_id = hr_api.g_number) then

283: -- p_rec plsql record structure
284: -- to see if a system default is being used. If a system default
285: -- is being used then we must set to the 'current' argument value.
286: --
287: If (p_rec.assignment_id = hr_api.g_number) then
288: p_rec.assignment_id :=
289: irc_ias_shd.g_old_rec.assignment_id;
290: End If;
291: If (p_rec.status_change_reason = hr_api.g_varchar2) then

Line 291: If (p_rec.status_change_reason = hr_api.g_varchar2) then

287: If (p_rec.assignment_id = hr_api.g_number) then
288: p_rec.assignment_id :=
289: irc_ias_shd.g_old_rec.assignment_id;
290: End If;
291: If (p_rec.status_change_reason = hr_api.g_varchar2) then
292: p_rec.status_change_reason :=
293: irc_ias_shd.g_old_rec.status_change_reason;
294: End If;
295: If (p_rec.assignment_status_type_id = hr_api.g_number) then

Line 295: If (p_rec.assignment_status_type_id = hr_api.g_number) then

291: If (p_rec.status_change_reason = hr_api.g_varchar2) then
292: p_rec.status_change_reason :=
293: irc_ias_shd.g_old_rec.status_change_reason;
294: End If;
295: If (p_rec.assignment_status_type_id = hr_api.g_number) then
296: p_rec.assignment_status_type_id :=
297: irc_ias_shd.g_old_rec.assignment_status_type_id;
298: End If;
299: If (p_rec.status_change_date = hr_api.g_date) then

Line 299: If (p_rec.status_change_date = hr_api.g_date) then

295: If (p_rec.assignment_status_type_id = hr_api.g_number) then
296: p_rec.assignment_status_type_id :=
297: irc_ias_shd.g_old_rec.assignment_status_type_id;
298: End If;
299: If (p_rec.status_change_date = hr_api.g_date) then
300: p_rec.status_change_date :=
301: irc_ias_shd.g_old_rec.status_change_date;
302: End If;
303: --

Line 361: ,p_assignment_id in number default hr_api.g_number

357: -- ----------------------------------------------------------------------------
358: Procedure upd
359: (p_assignment_status_id in number
360: ,p_object_version_number in out nocopy number
361: ,p_assignment_id in number default hr_api.g_number
362: ,p_assignment_status_type_id in number default hr_api.g_number
363: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
364: ,p_status_change_date in date
365: ) is

Line 362: ,p_assignment_status_type_id in number default hr_api.g_number

358: Procedure upd
359: (p_assignment_status_id in number
360: ,p_object_version_number in out nocopy number
361: ,p_assignment_id in number default hr_api.g_number
362: ,p_assignment_status_type_id in number default hr_api.g_number
363: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
364: ,p_status_change_date in date
365: ) is
366: --

Line 363: ,p_status_change_reason in varchar2 default hr_api.g_varchar2

359: (p_assignment_status_id in number
360: ,p_object_version_number in out nocopy number
361: ,p_assignment_id in number default hr_api.g_number
362: ,p_assignment_status_type_id in number default hr_api.g_number
363: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
364: ,p_status_change_date in date
365: ) is
366: --
367: l_rec irc_ias_shd.g_rec_type;