APPS.HXC_PREF_HIERARCHIES_API dependencies on HXC_PREF_HIERARCHIES

Line 1: Package Body hxc_pref_hierarchies_api as

1: Package Body hxc_pref_hierarchies_api as
2: /* $Header: hxchphapi.pkb 120.2 2005/09/23 10:42:34 sechandr noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' hxc_pref_hierarchies_api.';

2: /* $Header: hxchphapi.pkb 120.2 2005/09/23 10:42:34 sechandr noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_pref_hierarchies_api.';
7: g_debug boolean :=hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |-----------------------------< get_node_data >----------------------------|

Line 62: FROM hxc_pref_hierarchies

58: l_mode varchar2(50) := null;
59:
60: cursor c_top_node(l_name varchar2) is
61: SELECT pref_hierarchy_id,object_version_number
62: FROM hxc_pref_hierarchies
63: WHERE parent_pref_hierarchy_id is null
64: AND name = l_name;
65:
66: cursor c_child_nodes(l_parent_pref_hierarchy_id number,l_name varchar2) is

Line 68: FROM hxc_pref_hierarchies

64: AND name = l_name;
65:
66: cursor c_child_nodes(l_parent_pref_hierarchy_id number,l_name varchar2) is
67: SELECT pref_hierarchy_id,object_version_number
68: FROM hxc_pref_hierarchies
69: WHERE parent_pref_hierarchy_id = l_parent_pref_hierarchy_id
70: AND name = l_name;
71:
72: --

Line 236: l_object_version_number hxc_pref_hierarchies.object_version_number%TYPE;

232: -- Declare cursors and local variables
233: --
234:
235: l_proc varchar2(72);
236: l_object_version_number hxc_pref_hierarchies.object_version_number%TYPE;
237: l_pref_hierarchy_id hxc_pref_hierarchies.pref_hierarchy_id%TYPE;
238: begin
239: g_debug:=hr_utility.debug_enabled;
240: if g_debug then

Line 237: l_pref_hierarchy_id hxc_pref_hierarchies.pref_hierarchy_id%TYPE;

233: --
234:
235: l_proc varchar2(72);
236: l_object_version_number hxc_pref_hierarchies.object_version_number%TYPE;
237: l_pref_hierarchy_id hxc_pref_hierarchies.pref_hierarchy_id%TYPE;
238: begin
239: g_debug:=hr_utility.debug_enabled;
240: if g_debug then
241: l_proc := g_package||'create_pref_hierarchies';

Line 261: hxc_pref_hierarchies_bk_1.create_pref_hierarchies_b

257: --
258: -- Call Before Process User Hook
259: --
260: begin
261: hxc_pref_hierarchies_bk_1.create_pref_hierarchies_b
262: (p_pref_hierarchy_id => p_pref_hierarchy_id
263: ,p_object_version_number => p_object_version_number
264: ,p_type => p_type
265: ,p_name => p_name

Line 392: hxc_pref_hierarchies_bk_1.create_pref_hierarchies_a

388: --
389: -- Call After Process User Hook
390: --
391: begin
392: hxc_pref_hierarchies_bk_1.create_pref_hierarchies_a
393: (p_pref_hierarchy_id => p_pref_hierarchy_id
394: ,p_object_version_number => p_object_version_number
395: ,p_type => p_type
396: ,p_name => p_name

Line 558: l_object_version_number hxc_pref_hierarchies.object_version_number%TYPE := p_object_version_number;

554: --
555: -- Declare cursors and local variables
556: --
557: l_proc varchar2(72);
558: l_object_version_number hxc_pref_hierarchies.object_version_number%TYPE := p_object_version_number;
559: --
560: Begin
561: --
562: g_debug:=hr_utility.debug_enabled;

Line 579: hxc_pref_hierarchies_bk_1.update_pref_hierarchies_b

575: --
576: -- Call Before Process User Hook
577: --
578: begin
579: hxc_pref_hierarchies_bk_1.update_pref_hierarchies_b
580: (p_pref_hierarchy_id => p_pref_hierarchy_id
581: ,p_object_version_number => p_object_version_number
582: ,p_type => p_type
583: ,p_name => p_name

Line 708: hxc_pref_hierarchies_bk_1.update_pref_hierarchies_a

704: --
705: -- Call After Process User Hook
706: --
707: begin
708: hxc_pref_hierarchies_bk_1.update_pref_hierarchies_a
709: (p_pref_hierarchy_id => p_pref_hierarchy_id
710: ,p_object_version_number => p_object_version_number
711: ,p_type => p_type
712: ,p_name => p_name

Line 861: hxc_pref_hierarchies_bk_1.delete_pref_hierarchies_b

857: -- Call Before Process User Hook
858: --
859: begin
860: --
861: hxc_pref_hierarchies_bk_1.delete_pref_hierarchies_b
862: (p_pref_hierarchy_id => p_pref_hierarchy_id
863: ,p_object_version_number => p_object_version_number
864: );
865: exception

Line 893: hxc_pref_hierarchies_bk_1.delete_pref_hierarchies_a

889: -- Call After Process User Hook
890: --
891: begin
892: --
893: hxc_pref_hierarchies_bk_1.delete_pref_hierarchies_a
894: (p_pref_hierarchy_id => p_pref_hierarchy_id
895: ,p_object_version_number => p_object_version_number
896: );
897: exception

Line 933: end hxc_pref_hierarchies_api;

929: raise;
930: --
931: end delete_pref_hierarchies;
932: --
933: end hxc_pref_hierarchies_api;