eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_KI_HIERARCHIES_API dependencies on HR_API

Line 2: /* $Header: hrhrcapi.pkb 115.0 2004/01/09 01:13:25 vkarandi noship $ */

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: --
6: g_package varchar2(33) := 'HR_KI_HIERARCHIES_API';

Line 14: ,p_language_code in varchar2 default hr_api.userenv_lang

10: -- ----------------------------------------------------------------------------
11: --
12: procedure create_hierarchy_node
13: (p_validate in boolean default false
14: ,p_language_code in varchar2 default hr_api.userenv_lang
15: ,p_hierarchy_key in varchar2
16: ,p_parent_hierarchy_id in number
17: ,p_name in varchar2
18: ,p_description in varchar2 default hr_api.g_varchar2

Line 18: ,p_description in varchar2 default hr_api.g_varchar2

14: ,p_language_code in varchar2 default hr_api.userenv_lang
15: ,p_hierarchy_key in varchar2
16: ,p_parent_hierarchy_id in number
17: ,p_name in varchar2
18: ,p_description in varchar2 default hr_api.g_varchar2
19: ,p_hierarchy_id out nocopy number
20: ,p_object_version_number out nocopy number
21: ) is
22: --

Line 42: hr_api.validate_language_code(p_language_code => l_language_code);

38: --
39: --l_in_out_parameter := p_in_out_parameter;
40: l_language_code:=p_language_code;
41:
42: hr_api.validate_language_code(p_language_code => l_language_code);
43:
44: --
45: -- Call Before Process User Hook
46: --

Line 57: when hr_api.cannot_find_prog_unit then

53: ,p_name => p_name
54: ,p_description => p_description
55: );
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (p_module_name => 'create_hierarchy_node'
60: ,p_hook_type => 'BP'
61: );

Line 58: hr_api.cannot_find_prog_unit_error

54: ,p_description => p_description
55: );
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (p_module_name => 'create_hierarchy_node'
60: ,p_hook_type => 'BP'
61: );
62: end;

Line 98: when hr_api.cannot_find_prog_unit then

94: ,p_hierarchy_id => l_hierarchy_id
95: ,p_object_version_number => l_object_version_number
96: );
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'create_hierarchy_node'
101: ,p_hook_type => 'AP'
102: );

Line 99: hr_api.cannot_find_prog_unit_error

95: ,p_object_version_number => l_object_version_number
96: );
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'create_hierarchy_node'
101: ,p_hook_type => 'AP'
102: );
103: end;

Line 108: raise hr_api.validate_enabled;

104: --
105: -- When in validation only mode raise the Validate_Enabled exception
106: --
107: if p_validate then
108: raise hr_api.validate_enabled;
109: end if;
110: --
111: -- Set all IN OUT and OUT parameters with out values
112: --

Line 119: when hr_api.validate_enabled then

115:
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 70);
118: exception
119: when hr_api.validate_enabled then
120: --
121: -- As the Validate_Enabled exception has been raised
122: -- we must rollback to the savepoint
123: --

Line 159: ,p_language_code in varchar2 default hr_api.userenv_lang

155: -- ----------------------------------------------------------------------------
156: --
157: procedure update_hierarchy_node
158: (p_validate in boolean default false
159: ,p_language_code in varchar2 default hr_api.userenv_lang
160: ,p_parent_hierarchy_id in number default hr_api.g_number
161: ,p_name in varchar2 default hr_api.g_varchar2
162: ,p_description in varchar2 default hr_api.g_varchar2
163: ,p_hierarchy_id in number

Line 160: ,p_parent_hierarchy_id in number default hr_api.g_number

156: --
157: procedure update_hierarchy_node
158: (p_validate in boolean default false
159: ,p_language_code in varchar2 default hr_api.userenv_lang
160: ,p_parent_hierarchy_id in number default hr_api.g_number
161: ,p_name in varchar2 default hr_api.g_varchar2
162: ,p_description in varchar2 default hr_api.g_varchar2
163: ,p_hierarchy_id in number
164: ,p_object_version_number in out nocopy number

Line 161: ,p_name in varchar2 default hr_api.g_varchar2

157: procedure update_hierarchy_node
158: (p_validate in boolean default false
159: ,p_language_code in varchar2 default hr_api.userenv_lang
160: ,p_parent_hierarchy_id in number default hr_api.g_number
161: ,p_name in varchar2 default hr_api.g_varchar2
162: ,p_description in varchar2 default hr_api.g_varchar2
163: ,p_hierarchy_id in number
164: ,p_object_version_number in out nocopy number
165: ) is

Line 162: ,p_description in varchar2 default hr_api.g_varchar2

158: (p_validate in boolean default false
159: ,p_language_code in varchar2 default hr_api.userenv_lang
160: ,p_parent_hierarchy_id in number default hr_api.g_number
161: ,p_name in varchar2 default hr_api.g_varchar2
162: ,p_description in varchar2 default hr_api.g_varchar2
163: ,p_hierarchy_id in number
164: ,p_object_version_number in out nocopy number
165: ) is
166: --

Line 185: hr_api.validate_language_code(p_language_code => l_language_code);

181: --
182: --l_in_out_parameter := p_in_out_parameter;
183: l_language_code:=p_language_code;
184:
185: hr_api.validate_language_code(p_language_code => l_language_code);
186:
187: --
188: -- Call Before Process User Hook
189: --

Line 201: when hr_api.cannot_find_prog_unit then

197: ,p_hierarchy_id => p_hierarchy_id
198: ,p_object_version_number => p_object_version_number
199: );
200: exception
201: when hr_api.cannot_find_prog_unit then
202: hr_api.cannot_find_prog_unit_error
203: (p_module_name => 'update_hierarchy_node'
204: ,p_hook_type => 'BP'
205: );

Line 202: hr_api.cannot_find_prog_unit_error

198: ,p_object_version_number => p_object_version_number
199: );
200: exception
201: when hr_api.cannot_find_prog_unit then
202: hr_api.cannot_find_prog_unit_error
203: (p_module_name => 'update_hierarchy_node'
204: ,p_hook_type => 'BP'
205: );
206: end;

Line 240: when hr_api.cannot_find_prog_unit then

236: ,p_hierarchy_id => p_hierarchy_id
237: ,p_object_version_number => p_object_version_number
238: );
239: exception
240: when hr_api.cannot_find_prog_unit then
241: hr_api.cannot_find_prog_unit_error
242: (p_module_name => 'update_hierarchy_node'
243: ,p_hook_type => 'AP'
244: );

Line 241: hr_api.cannot_find_prog_unit_error

237: ,p_object_version_number => p_object_version_number
238: );
239: exception
240: when hr_api.cannot_find_prog_unit then
241: hr_api.cannot_find_prog_unit_error
242: (p_module_name => 'update_hierarchy_node'
243: ,p_hook_type => 'AP'
244: );
245: end;

Line 250: raise hr_api.validate_enabled;

246: --
247: -- When in validation only mode raise the Validate_Enabled exception
248: --
249: if p_validate then
250: raise hr_api.validate_enabled;
251: end if;
252: --
253: -- Set all IN OUT and OUT parameters with out values
254: --

Line 261: when hr_api.validate_enabled then

257:
258: --
259: hr_utility.set_location(' Leaving:'||l_proc, 70);
260: exception
261: when hr_api.validate_enabled then
262: --
263: -- As the Validate_Enabled exception has been raised
264: -- we must rollback to the savepoint
265: --

Line 349: when hr_api.cannot_find_prog_unit then

345: ,p_object_version_number => p_object_version_number
346:
347: );
348: exception
349: when hr_api.cannot_find_prog_unit then
350: hr_api.cannot_find_prog_unit_error
351: (p_module_name => 'delete_hierarchy_node'
352: ,p_hook_type => 'BP'
353: );

Line 350: hr_api.cannot_find_prog_unit_error

346:
347: );
348: exception
349: when hr_api.cannot_find_prog_unit then
350: hr_api.cannot_find_prog_unit_error
351: (p_module_name => 'delete_hierarchy_node'
352: ,p_hook_type => 'BP'
353: );
354: end;

Line 363: hr_api.mandatory_arg_error

359:
360:
361: --throw error for invalid object_version_number
362: -- and invalid hierarchy_id
363: hr_api.mandatory_arg_error
364: (p_api_name => l_proc
365: ,p_argument => 'HIERARCHY_ID'
366: ,p_argument_value => p_hierarchy_id
367: );

Line 369: hr_api.mandatory_arg_error

365: ,p_argument => 'HIERARCHY_ID'
366: ,p_argument_value => p_hierarchy_id
367: );
368: hr_utility.set_location(l_proc,6);
369: hr_api.mandatory_arg_error
370: (p_api_name => l_proc
371: ,p_argument => 'OBJECT_VERSION_NUMBER'
372: ,p_argument_value => p_object_version_number
373: );

Line 437: when hr_api.cannot_find_prog_unit then

433: p_hierarchy_id => p_hierarchy_id
434: ,p_object_version_number => p_object_version_number
435: );
436: exception
437: when hr_api.cannot_find_prog_unit then
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'delete_hierarchy_node'
440: ,p_hook_type => 'AP'
441: );

Line 438: hr_api.cannot_find_prog_unit_error

434: ,p_object_version_number => p_object_version_number
435: );
436: exception
437: when hr_api.cannot_find_prog_unit then
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'delete_hierarchy_node'
440: ,p_hook_type => 'AP'
441: );
442: end;

Line 447: raise hr_api.validate_enabled;

443: --
444: -- When in validation only mode raise the Validate_Enabled exception
445: --
446: if p_validate then
447: raise hr_api.validate_enabled;
448: end if;
449: --
450: -- Set all IN OUT and OUT parameters with out values
451: --

Line 456: when hr_api.validate_enabled then

452:
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 70);
455: exception
456: when hr_api.validate_enabled then
457: --
458: -- As the Validate_Enabled exception has been raised
459: -- we must rollback to the savepoint
460: --

Line 521: when hr_api.cannot_find_prog_unit then

517: p_hierarchy_id => p_hierarchy_id
518: ,p_topic_id => p_topic_id
519: );
520: exception
521: when hr_api.cannot_find_prog_unit then
522: hr_api.cannot_find_prog_unit_error
523: (p_module_name => 'create_topic_hierarchy_map'
524: ,p_hook_type => 'BP'
525: );

Line 522: hr_api.cannot_find_prog_unit_error

518: ,p_topic_id => p_topic_id
519: );
520: exception
521: when hr_api.cannot_find_prog_unit then
522: hr_api.cannot_find_prog_unit_error
523: (p_module_name => 'create_topic_hierarchy_map'
524: ,p_hook_type => 'BP'
525: );
526: end;

Line 551: when hr_api.cannot_find_prog_unit then

547: ,p_hierarchy_node_map_id => p_hierarchy_node_map_id
548: ,p_object_version_number => p_object_version_number
549: );
550: exception
551: when hr_api.cannot_find_prog_unit then
552: hr_api.cannot_find_prog_unit_error
553: (p_module_name => 'create_topic_hierarchy_map'
554: ,p_hook_type => 'AP'
555: );

Line 552: hr_api.cannot_find_prog_unit_error

548: ,p_object_version_number => p_object_version_number
549: );
550: exception
551: when hr_api.cannot_find_prog_unit then
552: hr_api.cannot_find_prog_unit_error
553: (p_module_name => 'create_topic_hierarchy_map'
554: ,p_hook_type => 'AP'
555: );
556: end;

Line 561: raise hr_api.validate_enabled;

557: --
558: -- When in validation only mode raise the Validate_Enabled exception
559: --
560: if p_validate then
561: raise hr_api.validate_enabled;
562: end if;
563: --
564: -- Set all IN OUT and OUT parameters with out values
565: --

Line 572: when hr_api.validate_enabled then

568:
569: --
570: hr_utility.set_location(' Leaving:'||l_proc, 70);
571: exception
572: when hr_api.validate_enabled then
573: --
574: -- As the Validate_Enabled exception has been raised
575: -- we must rollback to the savepoint
576: --

Line 643: when hr_api.cannot_find_prog_unit then

639: p_hierarchy_id => p_hierarchy_id
640: ,p_user_interface_id => p_user_interface_id
641: );
642: exception
643: when hr_api.cannot_find_prog_unit then
644: hr_api.cannot_find_prog_unit_error
645: (p_module_name => 'create_ui_hierarchy_map'
646: ,p_hook_type => 'BP'
647: );

Line 644: hr_api.cannot_find_prog_unit_error

640: ,p_user_interface_id => p_user_interface_id
641: );
642: exception
643: when hr_api.cannot_find_prog_unit then
644: hr_api.cannot_find_prog_unit_error
645: (p_module_name => 'create_ui_hierarchy_map'
646: ,p_hook_type => 'BP'
647: );
648: end;

Line 673: when hr_api.cannot_find_prog_unit then

669: ,p_hierarchy_node_map_id => l_hierarchy_node_map_id
670: ,p_object_version_number => l_object_version_number
671: );
672: exception
673: when hr_api.cannot_find_prog_unit then
674: hr_api.cannot_find_prog_unit_error
675: (p_module_name => 'create_ui_hierarchy_map'
676: ,p_hook_type => 'AP'
677: );

Line 674: hr_api.cannot_find_prog_unit_error

670: ,p_object_version_number => l_object_version_number
671: );
672: exception
673: when hr_api.cannot_find_prog_unit then
674: hr_api.cannot_find_prog_unit_error
675: (p_module_name => 'create_ui_hierarchy_map'
676: ,p_hook_type => 'AP'
677: );
678: end;

Line 683: raise hr_api.validate_enabled;

679: --
680: -- When in validation only mode raise the Validate_Enabled exception
681: --
682: if p_validate then
683: raise hr_api.validate_enabled;
684: end if;
685: --
686: -- Set all IN OUT and OUT parameters with out values
687: --

Line 694: when hr_api.validate_enabled then

690:
691: --
692: hr_utility.set_location(' Leaving:'||l_proc, 70);
693: exception
694: when hr_api.validate_enabled then
695: --
696: -- As the Validate_Enabled exception has been raised
697: -- we must rollback to the savepoint
698: --

Line 765: when hr_api.cannot_find_prog_unit then

761: p_topic_id => p_topic_id
762: ,p_user_interface_id => p_user_interface_id
763: );
764: exception
765: when hr_api.cannot_find_prog_unit then
766: hr_api.cannot_find_prog_unit_error
767: (p_module_name => 'create_topic_ui_map'
768: ,p_hook_type => 'BP'
769: );

Line 766: hr_api.cannot_find_prog_unit_error

762: ,p_user_interface_id => p_user_interface_id
763: );
764: exception
765: when hr_api.cannot_find_prog_unit then
766: hr_api.cannot_find_prog_unit_error
767: (p_module_name => 'create_topic_ui_map'
768: ,p_hook_type => 'BP'
769: );
770: end;

Line 795: when hr_api.cannot_find_prog_unit then

791: ,p_hierarchy_node_map_id => l_hierarchy_node_map_id
792: ,p_object_version_number => l_object_version_number
793: );
794: exception
795: when hr_api.cannot_find_prog_unit then
796: hr_api.cannot_find_prog_unit_error
797: (p_module_name => 'create_topic_ui_map'
798: ,p_hook_type => 'AP'
799: );

Line 796: hr_api.cannot_find_prog_unit_error

792: ,p_object_version_number => l_object_version_number
793: );
794: exception
795: when hr_api.cannot_find_prog_unit then
796: hr_api.cannot_find_prog_unit_error
797: (p_module_name => 'create_topic_ui_map'
798: ,p_hook_type => 'AP'
799: );
800: end;

Line 805: raise hr_api.validate_enabled;

801: --
802: -- When in validation only mode raise the Validate_Enabled exception
803: --
804: if p_validate then
805: raise hr_api.validate_enabled;
806: end if;
807: --
808: -- Set all IN OUT and OUT parameters with out values
809: --

Line 816: when hr_api.validate_enabled then

812:
813: --
814: hr_utility.set_location(' Leaving:'||l_proc, 70);
815: exception
816: when hr_api.validate_enabled then
817: --
818: -- As the Validate_Enabled exception has been raised
819: -- we must rollback to the savepoint
820: --

Line 856: ,p_hierarchy_id in number default hr_api.g_number

852: -- ----------------------------------------------------------------------------
853: --
854: procedure update_hierarchy_node_map
855: (p_validate in boolean default false
856: ,p_hierarchy_id in number default hr_api.g_number
857: ,p_topic_id in number default hr_api.g_number
858: ,p_user_interface_id in number default hr_api.g_number
859: ,p_hierarchy_node_map_id in number
860: ,p_object_version_number in out nocopy number

Line 857: ,p_topic_id in number default hr_api.g_number

853: --
854: procedure update_hierarchy_node_map
855: (p_validate in boolean default false
856: ,p_hierarchy_id in number default hr_api.g_number
857: ,p_topic_id in number default hr_api.g_number
858: ,p_user_interface_id in number default hr_api.g_number
859: ,p_hierarchy_node_map_id in number
860: ,p_object_version_number in out nocopy number
861: ) is

Line 858: ,p_user_interface_id in number default hr_api.g_number

854: procedure update_hierarchy_node_map
855: (p_validate in boolean default false
856: ,p_hierarchy_id in number default hr_api.g_number
857: ,p_topic_id in number default hr_api.g_number
858: ,p_user_interface_id in number default hr_api.g_number
859: ,p_hierarchy_node_map_id in number
860: ,p_object_version_number in out nocopy number
861: ) is
862: --

Line 891: when hr_api.cannot_find_prog_unit then

887: ,p_hierarchy_node_map_id => p_hierarchy_node_map_id
888: ,p_object_version_number => p_object_version_number
889: );
890: exception
891: when hr_api.cannot_find_prog_unit then
892: hr_api.cannot_find_prog_unit_error
893: (p_module_name => 'update_hierarchy_node_map'
894: ,p_hook_type => 'BP'
895: );

Line 892: hr_api.cannot_find_prog_unit_error

888: ,p_object_version_number => p_object_version_number
889: );
890: exception
891: when hr_api.cannot_find_prog_unit then
892: hr_api.cannot_find_prog_unit_error
893: (p_module_name => 'update_hierarchy_node_map'
894: ,p_hook_type => 'BP'
895: );
896: end;

Line 923: when hr_api.cannot_find_prog_unit then

919: ,p_hierarchy_node_map_id => p_hierarchy_node_map_id
920: ,p_object_version_number => p_object_version_number
921: );
922: exception
923: when hr_api.cannot_find_prog_unit then
924: hr_api.cannot_find_prog_unit_error
925: (p_module_name => 'update_hierarchy_node_map'
926: ,p_hook_type => 'AP'
927: );

Line 924: hr_api.cannot_find_prog_unit_error

920: ,p_object_version_number => p_object_version_number
921: );
922: exception
923: when hr_api.cannot_find_prog_unit then
924: hr_api.cannot_find_prog_unit_error
925: (p_module_name => 'update_hierarchy_node_map'
926: ,p_hook_type => 'AP'
927: );
928: end;

Line 933: raise hr_api.validate_enabled;

929: --
930: -- When in validation only mode raise the Validate_Enabled exception
931: --
932: if p_validate then
933: raise hr_api.validate_enabled;
934: end if;
935: --
936: -- Set all IN OUT and OUT parameters with out values
937: --

Line 944: when hr_api.validate_enabled then

940:
941: --
942: hr_utility.set_location(' Leaving:'||l_proc, 70);
943: exception
944: when hr_api.validate_enabled then
945: --
946: -- As the Validate_Enabled exception has been raised
947: -- we must rollback to the savepoint
948: --

Line 1011: when hr_api.cannot_find_prog_unit then

1007: ,p_object_version_number => p_object_version_number
1008:
1009: );
1010: exception
1011: when hr_api.cannot_find_prog_unit then
1012: hr_api.cannot_find_prog_unit_error
1013: (p_module_name => 'delete_hierarchy_node_map'
1014: ,p_hook_type => 'BP'
1015: );

Line 1012: hr_api.cannot_find_prog_unit_error

1008:
1009: );
1010: exception
1011: when hr_api.cannot_find_prog_unit then
1012: hr_api.cannot_find_prog_unit_error
1013: (p_module_name => 'delete_hierarchy_node_map'
1014: ,p_hook_type => 'BP'
1015: );
1016: end;

Line 1039: when hr_api.cannot_find_prog_unit then

1035: p_hierarchy_node_map_id => p_hierarchy_node_map_id
1036: ,p_object_version_number => p_object_version_number
1037: );
1038: exception
1039: when hr_api.cannot_find_prog_unit then
1040: hr_api.cannot_find_prog_unit_error
1041: (p_module_name => 'delete_hierarchy_node_map'
1042: ,p_hook_type => 'AP'
1043: );

Line 1040: hr_api.cannot_find_prog_unit_error

1036: ,p_object_version_number => p_object_version_number
1037: );
1038: exception
1039: when hr_api.cannot_find_prog_unit then
1040: hr_api.cannot_find_prog_unit_error
1041: (p_module_name => 'delete_hierarchy_node_map'
1042: ,p_hook_type => 'AP'
1043: );
1044: end;

Line 1049: raise hr_api.validate_enabled;

1045: --
1046: -- When in validation only mode raise the Validate_Enabled exception
1047: --
1048: if p_validate then
1049: raise hr_api.validate_enabled;
1050: end if;
1051: --
1052: -- Set all IN OUT and OUT parameters with out values
1053: --

Line 1058: when hr_api.validate_enabled then

1054:
1055: --
1056: hr_utility.set_location(' Leaving:'||l_proc, 70);
1057: exception
1058: when hr_api.validate_enabled then
1059: --
1060: -- As the Validate_Enabled exception has been raised
1061: -- we must rollback to the savepoint
1062: --