APPS.IRC_IDO_SHD dependencies on IRC_DOCUMENTS

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

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'IRC_DOCUMENTS_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 71: from irc_documents

67: ,description
68: ,type
69: ,object_version_number
70: ,end_date
71: from irc_documents
72: where document_id = p_document_id;
73: --
74: l_fct_ret boolean;
75: --

Line 147: from irc_documents

143: ,description
144: ,type
145: ,object_version_number
146: ,end_date
147: from irc_documents
148: where document_id = p_document_id
149: for update nowait;
150: --
151: l_proc varchar2(72) := g_package||'lck';

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

192: -- The object is locked therefore we need to supply a meaningful
193: -- error message.
194: --
195: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
196: fnd_message.set_token('TABLE_NAME', 'irc_documents');
197: fnd_message.raise_error;
198: End lck;
199: --
200: -- ----------------------------------------------------------------------------