APPS.IRC_INO_SHD dependencies on IRC_NOTES

Line 32: If (p_constraint_name = 'IRC_NOTES_PK') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'IRC_NOTES_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;

Line 65: from irc_notes

61: ,offer_status_history_id
62: ,note_text
63: ,''
64: ,object_version_number
65: from irc_notes
66: where note_id = p_note_id;
67: --
68: l_fct_ret boolean;
69: --

Line 139: from irc_notes

135: ,offer_status_history_id
136: ,note_text
137: ,''
138: ,object_version_number
139: from irc_notes
140: where note_id = p_note_id
141: for update nowait;
142: --
143: l_proc varchar2(72) := g_package||'lck';

Line 192: fnd_message.set_token('TABLE_NAME', 'irc_notes');

188: -- The object is locked therefore we need to supply a meaningful
189: -- error message.
190: --
191: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
192: fnd_message.set_token('TABLE_NAME', 'irc_notes');
193: fnd_message.raise_error;
194: End lck;
195: --
196: -- ----------------------------------------------------------------------------