APPS.IRC_ISS_SHD dependencies on IRC_SAVED_SEARCH_CRITERIA

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'IRC_SAVED_SEARCH_CRITERIA_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 52: from irc_saved_search_criteria

48: select
49: saved_search_criteria_id
50: ,vacancy_id
51: ,object_version_number
52: from irc_saved_search_criteria
53: where saved_search_criteria_id = p_saved_search_criteria_id;
54: --
55: l_fct_ret boolean;
56: --

Line 120: from irc_saved_search_criteria

116: select
117: saved_search_criteria_id
118: ,vacancy_id
119: ,object_version_number
120: from irc_saved_search_criteria
121: where saved_search_criteria_id = p_saved_search_criteria_id
122: for update nowait;
123: --
124: l_proc varchar2(72) := g_package||'lck';

Line 169: fnd_message.set_token('TABLE_NAME', 'irc_saved_search_criteria');

165: -- The object is locked therefore we need to supply a meaningful
166: -- error message.
167: --
168: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
169: fnd_message.set_token('TABLE_NAME', 'irc_saved_search_criteria');
170: fnd_message.raise_error;
171: End lck;
172: --
173: -- ----------------------------------------------------------------------------