APPS.IRC_IDO_INS dependencies on IRC_DOCUMENTS

Line 88: -- Insert the row into: irc_documents

84: --
85: irc_ido_shd.g_api_dml := true; -- Set the api dml status
86: --
87: --
88: -- Insert the row into: irc_documents
89: --
90: insert into irc_documents
91: (document_id
92: ,party_id

Line 90: insert into irc_documents

86: --
87: --
88: -- Insert the row into: irc_documents
89: --
90: insert into irc_documents
91: (document_id
92: ,party_id
93: ,person_id
94: ,assignment_id

Line 193: Cursor C_Sel1 is select irc_documents_s.nextval from sys.dual;

189: Procedure pre_insert
190: (p_rec in out nocopy irc_ido_shd.g_rec_type
191: ) is
192: --
193: Cursor C_Sel1 is select irc_documents_s.nextval from sys.dual;
194: --
195: Cursor C_Sel2 is
196: Select null
197: from irc_documents

Line 197: from irc_documents

193: Cursor C_Sel1 is select irc_documents_s.nextval from sys.dual;
194: --
195: Cursor C_Sel2 is
196: Select null
197: from irc_documents
198: where document_id =
199: irc_ido_ins.g_document_id_i;
200: --
201: l_proc varchar2(72) := g_package||'pre_insert';

Line 219: fnd_message.set_token('TABLE_NAME','irc_documents');

215: --
216: -- The primary key values are already in use.
217: --
218: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
219: fnd_message.set_token('TABLE_NAME','irc_documents');
220: fnd_message.raise_error;
221: End If;
222: Close C_Sel2;
223: --

Line 326: (p_module_name => 'IRC_DOCUMENTS'

322: --
323: when hr_api.cannot_find_prog_unit then
324: --
325: hr_api.cannot_find_prog_unit_error
326: (p_module_name => 'IRC_DOCUMENTS'
327: ,p_hook_type => 'AI');
328: --
329: end;
330: --