1 Package hr_hierarchy_element_swi AUTHID CURRENT_USER As
2 /* $Header: hroseswi.pkh 115.1 2002/12/03 00:35:32 ndorai noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-----------------------< create_hierarchy_element >-----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: hr_hierarchy_element_api.create_hierarchy_element
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_hierarchy_element
27 (p_validate in number default hr_api.g_false_num
28 ,p_organization_id_parent in number
29 ,p_org_structure_version_id in number
30 ,p_organization_id_child in number
31 ,p_business_group_id in number default null
32 ,p_effective_date in date
33 ,p_date_from in date
34 ,p_security_profile_id in number
35 ,p_view_all_orgs in varchar2
36 ,p_end_of_time in date
37 ,p_hr_installed in varchar2
38 ,p_pa_installed in varchar2
39 ,p_pos_control_enabled_flag in varchar2
40 ,p_warning_raised in out nocopy varchar2
41 ,p_org_structure_element_id out nocopy number
42 ,p_object_version_number out nocopy number
43 ,p_return_status out nocopy varchar2
44 );
45 -- ----------------------------------------------------------------------------
46 -- |-----------------------< delete_hierarchy_element >-----------------------|
47 -- ----------------------------------------------------------------------------
48 -- {Start of comments}
49 --
50 -- Description:
51 -- This procedure is the self-service wrapper procedure to the following
52 -- API: hr_hierarchy_element_api.delete_hierarchy_element
53 --
54 -- Pre-requisites
55 -- All 'IN' parameters to this procedure have been appropriately derived.
56 --
57 -- Post Success:
58 -- p_return_status will return value indicating success.
59 --
60 -- Post Failure:
61 -- p_return_status will return value indication failure.
62 --
63 -- Access Status:
64 -- Internal Development use only.
65 --
66 -- {End of comments}
67 -- ----------------------------------------------------------------------------
68 PROCEDURE delete_hierarchy_element
69 (p_validate in number default hr_api.g_false_num
70 ,p_org_structure_element_id in number
71 ,p_object_version_number in number
72 ,p_hr_installed in varchar2
73 ,p_pa_installed in varchar2
74 ,p_exists_in_hierarchy in out nocopy varchar2
75 ,p_return_status out nocopy varchar2
76 );
77 -- ----------------------------------------------------------------------------
78 -- |-----------------------< update_hierarchy_element >-----------------------|
79 -- ----------------------------------------------------------------------------
80 -- {Start of comments}
81 --
82 -- Description:
83 -- This procedure is the self-service wrapper procedure to the following
84 -- API: hr_hierarchy_element_api.update_hierarchy_element
85 --
86 -- Pre-requisites
87 -- All 'IN' parameters to this procedure have been appropriately derived.
88 --
89 -- Post Success:
90 -- p_return_status will return value indicating success.
91 --
92 -- Post Failure:
93 -- p_return_status will return value indication failure.
94 --
95 -- Access Status:
96 -- Internal Development use only.
97 --
98 -- {End of comments}
99 -- ----------------------------------------------------------------------------
100 PROCEDURE update_hierarchy_element
101 (p_validate in number default hr_api.g_false_num
102 ,p_effective_date in date
103 ,p_org_structure_element_id in number
104 ,p_organization_id_parent in number default hr_api.g_number
105 ,p_organization_id_child in number default hr_api.g_number
106 ,p_pos_control_enabled_flag in varchar2 default hr_api.g_varchar2
107 ,p_object_version_number in out nocopy number
108 ,p_return_status out nocopy varchar2
109 );
110 end hr_hierarchy_element_swi;