APPS.HXC_ULC_SHD dependencies on HXC_LAYOUT_COMPONENTS

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

18: l_proc varchar2(72) := g_package||'constraint_error';
19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_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_LAYOUT_COMPONENTS_FK2') 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_COMPONENTS_FK2') 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_LAYOUT_COMPONENTS_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;
32: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_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','15');
36: fnd_message.raise_error;

Line 37: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_UK1') 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;
37: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_UK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;

Line 85: from hxc_layout_components

81: ,attribute2
82: ,attribute3
83: ,attribute4
84: ,attribute5
85: from hxc_layout_components
86: where layout_component_id = p_layout_component_id;
87: --
88: l_fct_ret boolean;
89: --

Line 170: from hxc_layout_components

166: ,attribute2
167: ,attribute3
168: ,attribute4
169: ,attribute5
170: from hxc_layout_components
171: where layout_component_id = p_layout_component_id
172: for update nowait;
173: --
174: l_proc varchar2(72) ;

Line 219: fnd_message.set_token('TABLE_NAME', 'hxc_layout_components');

215: -- The object is locked therefore we need to supply a meaningful
216: -- error message.
217: --
218: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
219: fnd_message.set_token('TABLE_NAME', 'hxc_layout_components');
220: fnd_message.raise_error;
221: End lck;
222: --
223: -- ----------------------------------------------------------------------------