APPS.IRC_IAS_UPD dependencies on HR_API

Line 87: When hr_api.check_integrity_violated Then

83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: --
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: irc_ias_shd.g_api_dml := false; -- Unset the dml status
90: --
91: irc_ias_shd.constraint_error

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

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

Line 93: When hr_api.parent_integrity_violated Then

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

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

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

Line 99: When hr_api.unique_integrity_violated Then

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

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

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

Line 232: when hr_api.cannot_find_prog_unit then

228: );
229: --
230: exception
231: --
232: when hr_api.cannot_find_prog_unit then
233: --
234: hr_api.cannot_find_prog_unit_error
235: (p_module_name => 'IRC_ASSIGNMENT_STATUSES'
236: ,p_hook_type => 'AU');

Line 234: hr_api.cannot_find_prog_unit_error

230: exception
231: --
232: when hr_api.cannot_find_prog_unit then
233: --
234: hr_api.cannot_find_prog_unit_error
235: (p_module_name => 'IRC_ASSIGNMENT_STATUSES'
236: ,p_hook_type => 'AU');
237: --
238: end;

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

293: -- p_rec plsql record structure
294: -- to see if a system default is being used. If a system default
295: -- is being used then we must set to the 'current' argument value.
296: --
297: If (p_rec.assignment_id = hr_api.g_number) then
298: p_rec.assignment_id :=
299: irc_ias_shd.g_old_rec.assignment_id;
300: End If;
301: If (p_rec.status_change_reason = hr_api.g_varchar2) then

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

297: If (p_rec.assignment_id = hr_api.g_number) then
298: p_rec.assignment_id :=
299: irc_ias_shd.g_old_rec.assignment_id;
300: End If;
301: If (p_rec.status_change_reason = hr_api.g_varchar2) then
302: p_rec.status_change_reason :=
303: irc_ias_shd.g_old_rec.status_change_reason;
304: End If;
305: If (p_rec.assignment_status_type_id = hr_api.g_number) then

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

301: If (p_rec.status_change_reason = hr_api.g_varchar2) then
302: p_rec.status_change_reason :=
303: irc_ias_shd.g_old_rec.status_change_reason;
304: End If;
305: If (p_rec.assignment_status_type_id = hr_api.g_number) then
306: p_rec.assignment_status_type_id :=
307: irc_ias_shd.g_old_rec.assignment_status_type_id;
308: End If;
309: If (p_rec.status_change_date = hr_api.g_date) then

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

305: If (p_rec.assignment_status_type_id = hr_api.g_number) then
306: p_rec.assignment_status_type_id :=
307: irc_ias_shd.g_old_rec.assignment_status_type_id;
308: End If;
309: If (p_rec.status_change_date = hr_api.g_date) then
310: p_rec.status_change_date :=
311: irc_ias_shd.g_old_rec.status_change_date;
312: End If;
313: If (p_rec.status_change_comments = hr_api.g_varchar2) then

Line 313: If (p_rec.status_change_comments = hr_api.g_varchar2) then

309: If (p_rec.status_change_date = hr_api.g_date) then
310: p_rec.status_change_date :=
311: irc_ias_shd.g_old_rec.status_change_date;
312: End If;
313: If (p_rec.status_change_comments = hr_api.g_varchar2) then
314: p_rec.status_change_comments :=
315: irc_ias_shd.g_old_rec.status_change_comments;
316: End If;
317: If (p_rec.status_change_by = hr_api.g_varchar2) then

Line 317: If (p_rec.status_change_by = hr_api.g_varchar2) then

313: If (p_rec.status_change_comments = hr_api.g_varchar2) then
314: p_rec.status_change_comments :=
315: irc_ias_shd.g_old_rec.status_change_comments;
316: End If;
317: If (p_rec.status_change_by = hr_api.g_varchar2) then
318: p_rec.status_change_by :=
319: irc_ias_shd.g_old_rec.status_change_by;
320: End If;
321:

Line 380: ,p_assignment_id in number default hr_api.g_number

376: -- ----------------------------------------------------------------------------
377: Procedure upd
378: (p_assignment_status_id in number
379: ,p_object_version_number in out nocopy number
380: ,p_assignment_id in number default hr_api.g_number
381: ,p_assignment_status_type_id in number default hr_api.g_number
382: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
383: ,p_status_change_date in date
384: ,p_status_change_comments in varchar2 default hr_api.g_varchar2

Line 381: ,p_assignment_status_type_id in number default hr_api.g_number

377: Procedure upd
378: (p_assignment_status_id in number
379: ,p_object_version_number in out nocopy number
380: ,p_assignment_id in number default hr_api.g_number
381: ,p_assignment_status_type_id in number default hr_api.g_number
382: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
383: ,p_status_change_date in date
384: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
385: ,p_status_change_by in varchar2 default hr_api.g_varchar2

Line 382: ,p_status_change_reason in varchar2 default hr_api.g_varchar2

378: (p_assignment_status_id in number
379: ,p_object_version_number in out nocopy number
380: ,p_assignment_id in number default hr_api.g_number
381: ,p_assignment_status_type_id in number default hr_api.g_number
382: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
383: ,p_status_change_date in date
384: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
385: ,p_status_change_by in varchar2 default hr_api.g_varchar2
386: ) is

Line 384: ,p_status_change_comments in varchar2 default hr_api.g_varchar2

380: ,p_assignment_id in number default hr_api.g_number
381: ,p_assignment_status_type_id in number default hr_api.g_number
382: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
383: ,p_status_change_date in date
384: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
385: ,p_status_change_by in varchar2 default hr_api.g_varchar2
386: ) is
387: --
388: l_rec irc_ias_shd.g_rec_type;

Line 385: ,p_status_change_by in varchar2 default hr_api.g_varchar2

381: ,p_assignment_status_type_id in number default hr_api.g_number
382: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
383: ,p_status_change_date in date
384: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
385: ,p_status_change_by in varchar2 default hr_api.g_varchar2
386: ) is
387: --
388: l_rec irc_ias_shd.g_rec_type;
389: l_proc varchar2(72) := g_package||'upd';