APPS.HXC_HAD_SHD dependencies on HXC_ALIAS_DEFINITIONS

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

18: l_proc varchar2(72) := g_package||'constraint_error';
19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_ALIAS_DEFINITIONS_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;

Line 27: ElsIf (p_constraint_name = 'HXC_ALIAS_DEFINITIONS_UK2') 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_DEFINITIONS_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;

Line 64: from hxc_alias_definitions

60: ,legislation_code
61: ,timecard_field
62: ,object_version_number
63: ,alias_type_id
64: from hxc_alias_definitions
65: where alias_definition_id = p_alias_definition_id;
66: --
67: l_fct_ret boolean;
68: --

Line 138: from hxc_alias_definitions

134: ,legislation_code
135: ,timecard_field
136: ,object_version_number
137: ,alias_type_id
138: from hxc_alias_definitions
139: where alias_definition_id = p_alias_definition_id
140: for update nowait;
141: --
142: l_proc varchar2(72);

Line 187: fnd_message.set_token('TABLE_NAME', 'hxc_alias_definitions');

183: -- The object is locked therefore we need to supply a meaningful
184: -- error message.
185: --
186: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
187: fnd_message.set_token('TABLE_NAME', 'hxc_alias_definitions');
188: fnd_message.raise_error;
189: End lck;
190: --
191: -- ----------------------------------------------------------------------------