APPS.IRC_INO_INS dependencies on IRC_NOTES

Line 88: -- Insert the row into: irc_notes

84: p_rec.object_version_number := 1; -- Initialise the object version
85: --
86: irc_ino_shd.g_api_dml := true; -- Set the api dml status
87: --
88: -- Insert the row into: irc_notes
89: --
90: insert into irc_notes
91: (note_id
92: ,offer_status_history_id

Line 90: insert into irc_notes

86: irc_ino_shd.g_api_dml := true; -- Set the api dml status
87: --
88: -- Insert the row into: irc_notes
89: --
90: insert into irc_notes
91: (note_id
92: ,offer_status_history_id
93: ,note_text
94: ,object_version_number

Line 176: Cursor C_Sel1 is select irc_notes_s.nextval from sys.dual;

172: Procedure pre_insert
173: (p_rec in out nocopy irc_ino_shd.g_rec_type
174: ) is
175: --
176: Cursor C_Sel1 is select irc_notes_s.nextval from sys.dual;
177: --
178: Cursor C_Sel2 is
179: Select null
180: from irc_notes

Line 180: from irc_notes

176: Cursor C_Sel1 is select irc_notes_s.nextval from sys.dual;
177: --
178: Cursor C_Sel2 is
179: Select null
180: from irc_notes
181: where note_id =
182: irc_ino_ins.g_note_id_i;
183: --
184: l_proc varchar2(72) := g_package||'pre_insert';

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

198: --
199: -- The primary key values are already in use.
200: --
201: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
202: fnd_message.set_token('TABLE_NAME','irc_notes');
203: fnd_message.raise_error;
204: End If;
205: Close C_Sel2;
206: --

Line 285: (p_module_name => 'IRC_NOTES'

281: --
282: when hr_api.cannot_find_prog_unit then
283: --
284: hr_api.cannot_find_prog_unit_error
285: (p_module_name => 'IRC_NOTES'
286: ,p_hook_type => 'AI');
287: --
288: end;
289: --