APPS.BEN_EIV_SHD dependencies on BEN_EXTRA_INPUT_VALUES

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

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

95: ,eiv_attribute28
96: ,eiv_attribute29
97: ,eiv_attribute30
98: ,object_version_number
99: from ben_extra_input_values
100: where extra_input_value_id = p_extra_input_value_id;
101: --
102: l_fct_ret boolean;
103: --

Line 203: from ben_extra_input_values

199: ,eiv_attribute28
200: ,eiv_attribute29
201: ,eiv_attribute30
202: ,object_version_number
203: from ben_extra_input_values
204: where extra_input_value_id = p_extra_input_value_id
205: for update nowait;
206: --
207: l_proc varchar2(72) := g_package||'lck';

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

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', 'ben_extra_input_values');
253: fnd_message.raise_error;
254: End lck;
255: --
256: -- ----------------------------------------------------------------------------