APPS.HXC_HPH_SHD dependencies on HXC_PREF_HIERARCHIES

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

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

101: ,orig_pref_hierarchy_id
102: ,orig_parent_hierarchy_id -- Added the columns
103: ,top_level_parent_id -- Preformance Fix
104: ,code
105: from hxc_pref_hierarchies
106: where pref_hierarchy_id = p_pref_hierarchy_id;
107: --
108: l_fct_ret boolean;
109: --

Line 215: from hxc_pref_hierarchies

211: ,orig_pref_hierarchy_id
212: ,orig_parent_hierarchy_id
213: ,top_level_parent_id --Performance Fix
214: ,code
215: from hxc_pref_hierarchies
216: where pref_hierarchy_id = p_pref_hierarchy_id
217: for update nowait;
218: --
219: l_proc varchar2(72);

Line 264: fnd_message.set_token('TABLE_NAME', 'hxc_pref_hierarchies');

260: -- The object is locked therefore we need to supply a meaningful
261: -- error message.
262: --
263: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
264: fnd_message.set_token('TABLE_NAME', 'hxc_pref_hierarchies');
265: fnd_message.raise_error;
266: End lck;
267: --
268: -- ----------------------------------------------------------------------------