APPS.IRC_ILP_SHD dependencies on IRC_LOCATION_PREFERENCES

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

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

95: ,attribute28
96: ,attribute29
97: ,attribute30
98: ,object_version_number
99: from irc_location_preferences
100: where location_pref_id = p_location_pref_id;
101: --
102: l_fct_ret boolean;
103: --

Line 203: from irc_location_preferences

199: ,attribute28
200: ,attribute29
201: ,attribute30
202: ,object_version_number
203: from irc_location_preferences
204: where location_pref_id = p_location_pref_id
205: for update nowait;
206: --
207: l_proc varchar2(72) := g_package||'lck';

Line 252: fnd_message.set_token('TABLE_NAME', 'irc_location_preferences');

248: -- The object is locked therefore we need to supply a meaningful
249: -- error message.
250: --
251: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
252: fnd_message.set_token('TABLE_NAME', 'irc_location_preferences');
253: fnd_message.raise_error;
254: End lck;
255: --
256: -- ----------------------------------------------------------------------------