APPS.IRC_VCE_SHD dependencies on IRC_VARIABLE_COMP_ELEMENTS

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

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

60: select
61: vacancy_id
62: ,variable_comp_lookup
63: ,object_version_number
64: from irc_variable_comp_elements
65: where vacancy_id = p_vacancy_id
66: and variable_comp_lookup = p_variable_comp_lookup;
67: --
68: l_fct_ret boolean;

Line 135: from irc_variable_comp_elements

131: select
132: vacancy_id
133: ,variable_comp_lookup
134: ,object_version_number
135: from irc_variable_comp_elements
136: where vacancy_id = p_vacancy_id
137: and variable_comp_lookup = p_variable_comp_lookup
138: for update nowait;
139: --

Line 191: fnd_message.set_token('TABLE_NAME', 'irc_variable_comp_elements');

187: -- The object is locked therefore we need to supply a meaningful
188: -- error message.
189: --
190: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
191: fnd_message.set_token('TABLE_NAME', 'irc_variable_comp_elements');
192: fnd_message.raise_error;
193: End lck;
194: --
195: -- ----------------------------------------------------------------------------