APPS.HXC_HPH_INS dependencies on HXC_PREF_HIERARCHIES

Line 69: -- Insert the row into: hxc_pref_hierarchies

65: p_rec.object_version_number := 1; -- Initialise the object version
66: --
67: --
68: --
69: -- Insert the row into: hxc_pref_hierarchies
70: --
71: insert into hxc_pref_hierarchies
72: (pref_hierarchy_id
73: ,type

Line 71: insert into hxc_pref_hierarchies

67: --
68: --
69: -- Insert the row into: hxc_pref_hierarchies
70: --
71: insert into hxc_pref_hierarchies
72: (pref_hierarchy_id
73: ,type
74: ,name
75: ,business_group_id

Line 245: Cursor C_Sel1 is select hxc_pref_hierarchies_s.nextval from sys.dual;

241: ) is
242: --
243: l_proc varchar2(72);
244: --
245: Cursor C_Sel1 is select hxc_pref_hierarchies_s.nextval from sys.dual;
246: cursor c_top_level_node(p_pref_hierarchy_id number)
247: is
248: select pref_hierarchy_id
249: from hxc_pref_hierarchies

Line 249: from hxc_pref_hierarchies

245: Cursor C_Sel1 is select hxc_pref_hierarchies_s.nextval from sys.dual;
246: cursor c_top_level_node(p_pref_hierarchy_id number)
247: is
248: select pref_hierarchy_id
249: from hxc_pref_hierarchies
250: where parent_pref_hierarchy_id is null
251: connect by prior parent_pref_hierarchy_id = pref_hierarchy_id
252: start with pref_hierarchy_id = p_pref_hierarchy_id;
253:

Line 442: (p_module_name => 'HXC_PREF_HIERARCHIES'

438: --
439: when hr_api.cannot_find_prog_unit then
440: --
441: hr_api.cannot_find_prog_unit_error
442: (p_module_name => 'HXC_PREF_HIERARCHIES'
443: ,p_hook_type => 'AI');
444: --
445: end;
446: --