eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_IDO_UPD dependencies on HR_API

Line 91: When hr_api.check_integrity_violated Then

87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: --
90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: irc_ido_shd.g_api_dml := false; -- Unset the dml status
94: --
95: irc_ido_shd.constraint_error

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

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

Line 97: When hr_api.parent_integrity_violated Then

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

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

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

Line 103: When hr_api.unique_integrity_violated Then

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

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

104: -- Unique integrity has been violated
105: irc_ido_shd.g_api_dml := false; -- Unset the dml status
106: --
107: irc_ido_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: irc_ido_shd.g_api_dml := false; -- Unset the dml status
111: --
112: Raise;

Line 258: when hr_api.cannot_find_prog_unit then

254: );
255: --
256: exception
257: --
258: when hr_api.cannot_find_prog_unit then
259: --
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'IRC_DOCUMENTS'
262: ,p_hook_type => 'AU');

Line 260: hr_api.cannot_find_prog_unit_error

256: exception
257: --
258: when hr_api.cannot_find_prog_unit then
259: --
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'IRC_DOCUMENTS'
262: ,p_hook_type => 'AU');
263: --
264: end;

Line 323: If (p_rec.party_id = hr_api.g_number) then

319: -- p_rec plsql record structure
320: -- to see if a system default is being used. If a system default
321: -- is being used then we must set to the 'current' argument value.
322: --
323: If (p_rec.party_id = hr_api.g_number) then
324: p_rec.party_id :=
325: irc_ido_shd.g_old_rec.party_id;
326: End If;
327: If (p_rec.person_id = hr_api.g_number) then

Line 327: If (p_rec.person_id = hr_api.g_number) then

323: If (p_rec.party_id = hr_api.g_number) then
324: p_rec.party_id :=
325: irc_ido_shd.g_old_rec.party_id;
326: End If;
327: If (p_rec.person_id = hr_api.g_number) then
328: p_rec.person_id := irc_ido_shd.g_old_rec.person_id;
329: End If;
330: If (p_rec.assignment_id = hr_api.g_number) then
331: p_rec.assignment_id :=

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

326: End If;
327: If (p_rec.person_id = hr_api.g_number) then
328: p_rec.person_id := irc_ido_shd.g_old_rec.person_id;
329: End If;
330: If (p_rec.assignment_id = hr_api.g_number) then
331: p_rec.assignment_id :=
332: irc_ido_shd.g_old_rec.assignment_id;
333: End If;
334: If (p_rec.file_name = hr_api.g_varchar2) then

Line 334: If (p_rec.file_name = hr_api.g_varchar2) then

330: If (p_rec.assignment_id = hr_api.g_number) then
331: p_rec.assignment_id :=
332: irc_ido_shd.g_old_rec.assignment_id;
333: End If;
334: If (p_rec.file_name = hr_api.g_varchar2) then
335: p_rec.file_name :=
336: irc_ido_shd.g_old_rec.file_name;
337: End If;
338: If (p_rec.file_format = hr_api.g_varchar2) then

Line 338: If (p_rec.file_format = hr_api.g_varchar2) then

334: If (p_rec.file_name = hr_api.g_varchar2) then
335: p_rec.file_name :=
336: irc_ido_shd.g_old_rec.file_name;
337: End If;
338: If (p_rec.file_format = hr_api.g_varchar2) then
339: p_rec.file_format :=
340: irc_ido_shd.g_old_rec.file_format;
341: End If;
342: If (p_rec.mime_type = hr_api.g_varchar2) then

Line 342: If (p_rec.mime_type = hr_api.g_varchar2) then

338: If (p_rec.file_format = hr_api.g_varchar2) then
339: p_rec.file_format :=
340: irc_ido_shd.g_old_rec.file_format;
341: End If;
342: If (p_rec.mime_type = hr_api.g_varchar2) then
343: p_rec.mime_type :=
344: irc_ido_shd.g_old_rec.mime_type;
345: End If;
346: If (p_rec.description = hr_api.g_varchar2) then

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

342: If (p_rec.mime_type = hr_api.g_varchar2) then
343: p_rec.mime_type :=
344: irc_ido_shd.g_old_rec.mime_type;
345: End If;
346: If (p_rec.description = hr_api.g_varchar2) then
347: p_rec.description :=
348: irc_ido_shd.g_old_rec.description;
349: End If;
350: If (p_rec.type = hr_api.g_varchar2) then

Line 350: If (p_rec.type = hr_api.g_varchar2) then

346: If (p_rec.description = hr_api.g_varchar2) then
347: p_rec.description :=
348: irc_ido_shd.g_old_rec.description;
349: End If;
350: If (p_rec.type = hr_api.g_varchar2) then
351: p_rec.type :=
352: irc_ido_shd.g_old_rec.type;
353: End If;
354: If (p_rec.end_date = hr_api.g_date) then

Line 354: If (p_rec.end_date = hr_api.g_date) then

350: If (p_rec.type = hr_api.g_varchar2) then
351: p_rec.type :=
352: irc_ido_shd.g_old_rec.type;
353: End If;
354: If (p_rec.end_date = hr_api.g_date) then
355: p_rec.end_date :=
356: irc_ido_shd.g_old_rec.end_date;
357: End If;
358: --

Line 427: ,p_mime_type in varchar2 default hr_api.g_varchar2

423: Procedure upd
424: (p_effective_date in date
425: ,p_document_id in number
426: ,p_object_version_number in out nocopy number
427: ,p_mime_type in varchar2 default hr_api.g_varchar2
428: ,p_type in varchar2 default hr_api.g_varchar2
429: ,p_file_name in varchar2 default hr_api.g_varchar2
430: ,p_description in varchar2 default hr_api.g_varchar2
431: ,p_end_date in date default hr_api.g_date

Line 428: ,p_type in varchar2 default hr_api.g_varchar2

424: (p_effective_date in date
425: ,p_document_id in number
426: ,p_object_version_number in out nocopy number
427: ,p_mime_type in varchar2 default hr_api.g_varchar2
428: ,p_type in varchar2 default hr_api.g_varchar2
429: ,p_file_name in varchar2 default hr_api.g_varchar2
430: ,p_description in varchar2 default hr_api.g_varchar2
431: ,p_end_date in date default hr_api.g_date
432: ) is

Line 429: ,p_file_name in varchar2 default hr_api.g_varchar2

425: ,p_document_id in number
426: ,p_object_version_number in out nocopy number
427: ,p_mime_type in varchar2 default hr_api.g_varchar2
428: ,p_type in varchar2 default hr_api.g_varchar2
429: ,p_file_name in varchar2 default hr_api.g_varchar2
430: ,p_description in varchar2 default hr_api.g_varchar2
431: ,p_end_date in date default hr_api.g_date
432: ) is
433: --

Line 430: ,p_description in varchar2 default hr_api.g_varchar2

426: ,p_object_version_number in out nocopy number
427: ,p_mime_type in varchar2 default hr_api.g_varchar2
428: ,p_type in varchar2 default hr_api.g_varchar2
429: ,p_file_name in varchar2 default hr_api.g_varchar2
430: ,p_description in varchar2 default hr_api.g_varchar2
431: ,p_end_date in date default hr_api.g_date
432: ) is
433: --
434: l_rec irc_ido_shd.g_rec_type;

Line 431: ,p_end_date in date default hr_api.g_date

427: ,p_mime_type in varchar2 default hr_api.g_varchar2
428: ,p_type in varchar2 default hr_api.g_varchar2
429: ,p_file_name in varchar2 default hr_api.g_varchar2
430: ,p_description in varchar2 default hr_api.g_varchar2
431: ,p_end_date in date default hr_api.g_date
432: ) is
433: --
434: l_rec irc_ido_shd.g_rec_type;
435: l_proc varchar2(72) := g_package||'upd';