APPS.HXC_ULQ_SHD dependencies on HXC_LAYOUT_COMP_QUALIFIERS

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

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

86: ,qualifier_attribute28
87: ,qualifier_attribute29
88: ,qualifier_attribute30
89: ,object_version_number
90: from hxc_layout_comp_qualifiers
91: where layout_comp_qualifier_id = p_layout_comp_qualifier_id;
92: --
93: l_fct_ret boolean;
94: --

Line 190: from hxc_layout_comp_qualifiers

186: ,qualifier_attribute28
187: ,qualifier_attribute29
188: ,qualifier_attribute30
189: ,object_version_number
190: from hxc_layout_comp_qualifiers
191: where layout_comp_qualifier_id = p_layout_comp_qualifier_id
192: for update nowait;
193: --
194: l_proc varchar2(72) ;

Line 239: fnd_message.set_token('TABLE_NAME', 'hxc_layout_comp_qualifiers');

235: -- The object is locked therefore we need to supply a meaningful
236: -- error message.
237: --
238: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
239: fnd_message.set_token('TABLE_NAME', 'hxc_layout_comp_qualifiers');
240: fnd_message.raise_error;
241: End lck;
242: --
243: -- ----------------------------------------------------------------------------