APPS.HXC_ULA_SHD dependencies on HXC_LAYOUTS

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

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

59: ,modifier_level
60: ,modifier_value
61: ,top_level_region_code
62: ,object_version_number
63: from hxc_layouts
64: where layout_id = p_layout_id;
65: --
66: l_fct_ret boolean;
67: --

Line 136: from hxc_layouts

132: ,modifier_level
133: ,modifier_value
134: ,top_level_region_code
135: ,object_version_number
136: from hxc_layouts
137: where layout_id = p_layout_id
138: for update nowait;
139: --
140: l_proc varchar2(72) ;

Line 185: fnd_message.set_token('TABLE_NAME', 'hxc_layouts');

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