APPS.HXC_HAV_SHD dependencies on HXC_ALIAS_VALUES

Line 22: If (p_constraint_name = 'HXC_ALIAS_VALUES_FK1') Then

18: l_proc varchar2(72) := g_package||'constraint_error';
19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_ALIAS_VALUES_FK1') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;

Line 27: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_PK') Then

23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_PK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;

Line 32: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_UK2') Then

28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_UK2') 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','15');
36: fnd_message.raise_error;

Line 98: from hxc_alias_values hav,

94: ,attribute28
95: ,attribute29
96: ,attribute30
97: ,object_version_number
98: from hxc_alias_values hav,
99: hxc_alias_values_tl havt
100: where hav.alias_value_id = p_alias_value_id
101: and havt.language = USERENV('LANG')
102: and havt.alias_value_id = hav.alias_value_id;

Line 99: hxc_alias_values_tl havt

95: ,attribute29
96: ,attribute30
97: ,object_version_number
98: from hxc_alias_values hav,
99: hxc_alias_values_tl havt
100: where hav.alias_value_id = p_alias_value_id
101: and havt.language = USERENV('LANG')
102: and havt.alias_value_id = hav.alias_value_id;
103: --

Line 204: from hxc_alias_values hav,

200: ,attribute28
201: ,attribute29
202: ,attribute30
203: ,object_version_number
204: from hxc_alias_values hav,
205: hxc_alias_values_tl havt
206: where hav.alias_value_id = p_alias_value_id
207: and havt.language = USERENV('LANG')
208: and havt.alias_value_id = hav.alias_value_id

Line 205: hxc_alias_values_tl havt

201: ,attribute29
202: ,attribute30
203: ,object_version_number
204: from hxc_alias_values hav,
205: hxc_alias_values_tl havt
206: where hav.alias_value_id = p_alias_value_id
207: and havt.language = USERENV('LANG')
208: and havt.alias_value_id = hav.alias_value_id
209: for update nowait;

Line 256: fnd_message.set_token('TABLE_NAME', 'hxc_alias_values');

252: -- The object is locked therefore we need to supply a meaningful
253: -- error message.
254: --
255: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
256: fnd_message.set_token('TABLE_NAME', 'hxc_alias_values');
257: fnd_message.raise_error;
258: End lck;
259: --
260: -- ----------------------------------------------------------------------------