APPS.HXC_HPH_UPD dependencies on HXC_PREF_HIERARCHIES

Line 72: -- Update the hxc_pref_hierarchies Row

68: p_rec.object_version_number := p_rec.object_version_number + 1;
69: --
70: --
71: --
72: -- Update the hxc_pref_hierarchies Row
73: --
74: update hxc_pref_hierarchies
75: set
76: pref_hierarchy_id = p_rec.pref_hierarchy_id

Line 74: update hxc_pref_hierarchies

70: --
71: --
72: -- Update the hxc_pref_hierarchies Row
73: --
74: update hxc_pref_hierarchies
75: set
76: pref_hierarchy_id = p_rec.pref_hierarchy_id
77: ,type = p_rec.type
78: ,name = p_rec.name

Line 195: from hxc_pref_hierarchies

191: --Performance Fix
192: cursor c_top_level_node(p_pref_hierarchy_id number)
193: is
194: select pref_hierarchy_id
195: from hxc_pref_hierarchies
196: where parent_pref_hierarchy_id is null
197: connect by prior parent_pref_hierarchy_id = pref_hierarchy_id
198: start with pref_hierarchy_id = p_pref_hierarchy_id;
199:

Line 474: (p_module_name => 'HXC_PREF_HIERARCHIES'

470: --
471: when hr_api.cannot_find_prog_unit then
472: --
473: hr_api.cannot_find_prog_unit_error
474: (p_module_name => 'HXC_PREF_HIERARCHIES'
475: ,p_hook_type => 'AU');
476: --
477: end;
478: --