DBA Data[Home] [Help]

APPS.HR_KI_HIERARCHIES_API dependencies on HR_KI_HIERARCHIES

Line 1: Package Body HR_KI_HIERARCHIES_API as

1: Package Body HR_KI_HIERARCHIES_API as
2: /* $Header: hrhrcapi.pkb 115.0 2004/01/09 01:13:25 vkarandi noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := 'HR_KI_HIERARCHIES_API';

2: /* $Header: hrhrcapi.pkb 115.0 2004/01/09 01:13:25 vkarandi noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'HR_KI_HIERARCHIES_API';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_hierarchy_node >-----------------------|
10: -- ----------------------------------------------------------------------------

Line 48: hr_ki_hierarchies_bk1.create_hierarchy_node_b

44: --
45: -- Call Before Process User Hook
46: --
47: begin
48: hr_ki_hierarchies_bk1.create_hierarchy_node_b
49: (
50: p_language_code => p_language_code
51: ,p_hierarchy_key => p_hierarchy_key
52: ,p_parent_hierarchy_id => p_parent_hierarchy_id

Line 87: hr_ki_hierarchies_bk1.create_hierarchy_node_a

83: --
84: -- Call After Process User Hook
85: --
86: begin
87: hr_ki_hierarchies_bk1.create_hierarchy_node_a
88: (
89: p_language_code => l_language_code
90: ,p_hierarchy_key => p_hierarchy_key
91: ,p_parent_hierarchy_id => p_parent_hierarchy_id

Line 191: hr_ki_hierarchies_bk2.update_hierarchy_node_b

187: --
188: -- Call Before Process User Hook
189: --
190: begin
191: hr_ki_hierarchies_bk2.update_hierarchy_node_b
192: (
193: p_language_code => l_language_code
194: ,p_parent_hierarchy_id => p_parent_hierarchy_id
195: ,p_name => p_name

Line 230: hr_ki_hierarchies_bk2.update_hierarchy_node_a

226: --
227: -- Call After Process User Hook
228: --
229: begin
230: hr_ki_hierarchies_bk2.update_hierarchy_node_a
231: (
232: p_language_code => l_language_code
233: ,p_parent_hierarchy_id => p_parent_hierarchy_id
234: ,p_name => p_name

Line 309: select hierarchy_id,object_version_number from hr_ki_hierarchies

305: --
306:
307: cursor get_child_ids
308: is
309: select hierarchy_id,object_version_number from hr_ki_hierarchies
310: connect by prior
311: hierarchy_id=parent_hierarchy_id
312: start with hierarchy_id=p_hierarchy_id order by level desc;
313:

Line 321: from hr_ki_hierarchies

317: where hierarchy_id =cur_id;
318:
319: Cursor C_Sel1 is
320: select object_version_number
321: from hr_ki_hierarchies
322: where hierarchy_id = p_hierarchy_id;
323:
324: l_proc varchar2(72) := g_package||'delete_hierarchy_node';
325: l_found number(15);

Line 342: hr_ki_hierarchies_bk3.delete_hierarchy_node_b

338:
339: -- Call Before Process User Hook
340: --
341: begin
342: hr_ki_hierarchies_bk3.delete_hierarchy_node_b
343: (
344: p_hierarchy_id => p_hierarchy_id
345: ,p_object_version_number => p_object_version_number
346:

Line 431: hr_ki_hierarchies_bk3.delete_hierarchy_node_a

427: --
428: -- Call After Process User Hook
429: --
430: begin
431: hr_ki_hierarchies_bk3.delete_hierarchy_node_a
432: (
433: p_hierarchy_id => p_hierarchy_id
434: ,p_object_version_number => p_object_version_number
435: );

Line 515: hr_ki_hierarchies_bk4.create_topic_hierarchy_map_b

511:
512: -- Call Before Process User Hook
513: --
514: begin
515: hr_ki_hierarchies_bk4.create_topic_hierarchy_map_b
516: (
517: p_hierarchy_id => p_hierarchy_id
518: ,p_topic_id => p_topic_id
519: );

Line 543: hr_ki_hierarchies_bk4.create_topic_hierarchy_map_a

539: --
540: -- Call After Process User Hook
541: --
542: begin
543: hr_ki_hierarchies_bk4.create_topic_hierarchy_map_a
544: (
545: p_hierarchy_id => p_hierarchy_id
546: ,p_topic_id => p_topic_id
547: ,p_hierarchy_node_map_id => p_hierarchy_node_map_id

Line 637: hr_ki_hierarchies_bk5.create_ui_hierarchy_map_b

633:
634: -- Call Before Process User Hook
635: --
636: begin
637: hr_ki_hierarchies_bk5.create_ui_hierarchy_map_b
638: (
639: p_hierarchy_id => p_hierarchy_id
640: ,p_user_interface_id => p_user_interface_id
641: );

Line 665: hr_ki_hierarchies_bk5.create_ui_hierarchy_map_a

661: --
662: -- Call After Process User Hook
663: --
664: begin
665: hr_ki_hierarchies_bk5.create_ui_hierarchy_map_a
666: (
667: p_user_interface_id => p_user_interface_id
668: ,p_hierarchy_id => p_hierarchy_id
669: ,p_hierarchy_node_map_id => l_hierarchy_node_map_id

Line 759: hr_ki_hierarchies_bk6.create_topic_ui_map_b

755:
756: -- Call Before Process User Hook
757: --
758: begin
759: hr_ki_hierarchies_bk6.create_topic_ui_map_b
760: (
761: p_topic_id => p_topic_id
762: ,p_user_interface_id => p_user_interface_id
763: );

Line 787: hr_ki_hierarchies_bk6.create_topic_ui_map_a

783: --
784: -- Call After Process User Hook
785: --
786: begin
787: hr_ki_hierarchies_bk6.create_topic_ui_map_a
788: (
789: p_user_interface_id => p_user_interface_id
790: ,p_topic_id => p_topic_id
791: ,p_hierarchy_node_map_id => l_hierarchy_node_map_id

Line 882: hr_ki_hierarchies_bk7.update_hierarchy_node_map_b

878: --
879: -- Call Before Process User Hook
880: --
881: begin
882: hr_ki_hierarchies_bk7.update_hierarchy_node_map_b
883: (
884: p_topic_id => p_topic_id
885: ,p_hierarchy_id => p_hierarchy_id
886: ,p_user_interface_id => p_user_interface_id

Line 914: hr_ki_hierarchies_bk7.update_hierarchy_node_map_a

910: --
911: -- Call After Process User Hook
912: --
913: begin
914: hr_ki_hierarchies_bk7.update_hierarchy_node_map_a
915: (
916: p_topic_id => p_topic_id
917: ,p_hierarchy_id => p_hierarchy_id
918: ,p_user_interface_id => p_user_interface_id

Line 1004: hr_ki_hierarchies_bk8.delete_hierarchy_node_map_b

1000:
1001: -- Call Before Process User Hook
1002: --
1003: begin
1004: hr_ki_hierarchies_bk8.delete_hierarchy_node_map_b
1005: (
1006: p_hierarchy_node_map_id => p_hierarchy_node_map_id
1007: ,p_object_version_number => p_object_version_number
1008:

Line 1033: hr_ki_hierarchies_bk8.delete_hierarchy_node_map_a

1029: --
1030: -- Call After Process User Hook
1031: --
1032: begin
1033: hr_ki_hierarchies_bk8.delete_hierarchy_node_map_a
1034: (
1035: p_hierarchy_node_map_id => p_hierarchy_node_map_id
1036: ,p_object_version_number => p_object_version_number
1037: );

Line 1085: end HR_KI_HIERARCHIES_API;

1081: raise;
1082: end delete_hierarchy_node_map;
1083:
1084:
1085: end HR_KI_HIERARCHIES_API;