APPS.IRC_CMP_SHD dependencies on IRC_COMM_PROPERTIES

Line 21: If (p_constraint_name = 'IRC_COMM_PROPERTIES_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'IRC_COMM_PROPERTIES_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 80: from irc_comm_properties

76: ,information8
77: ,information9
78: ,information10
79: ,object_version_number
80: from irc_comm_properties
81: where communication_property_id = p_communication_property_id;
82: --
83: l_fct_ret boolean;
84: --

Line 176: from irc_comm_properties

172: ,information8
173: ,information9
174: ,information10
175: ,object_version_number
176: from irc_comm_properties
177: where communication_property_id = p_communication_property_id
178: for update nowait;
179: --
180: l_proc varchar2(72) := g_package||'lck';

Line 225: fnd_message.set_token('TABLE_NAME', 'irc_comm_properties');

221: -- The object is locked therefore we need to supply a meaningful
222: -- error message.
223: --
224: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
225: fnd_message.set_token('TABLE_NAME', 'irc_comm_properties');
226: fnd_message.raise_error;
227: End lck;
228: --
229: -- ----------------------------------------------------------------------------