APPS.IRC_INP_SHD dependencies on IRC_NOTIFICATION_PREFERENCES

Line 107: from irc_notification_preferences

103: ,attribute30
104: ,object_version_number
105: ,agency_id
106: ,attempt_id
107: from irc_notification_preferences
108: where notification_preference_id = p_notification_preference_id;
109: --
110: l_fct_ret boolean;
111: --

Line 213: from irc_notification_preferences

209: ,attribute30
210: ,object_version_number
211: ,agency_id
212: ,attempt_id
213: from irc_notification_preferences
214: where notification_preference_id = p_notification_preference_id
215: for update nowait;
216: --
217: l_proc varchar2(72) := g_package||'lck';

Line 262: fnd_message.set_token('TABLE_NAME', 'irc_notification_preferences');

258: -- The object is locked therefore we need to supply a meaningful
259: -- error message.
260: --
261: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
262: fnd_message.set_token('TABLE_NAME', 'irc_notification_preferences');
263: fnd_message.raise_error;
264: End lck;
265: --
266: -- ----------------------------------------------------------------------------