DBA Data[Home] [Help]

PACKAGE: APPS.PER_HIERARCHY_SWI

Source


1 Package per_hierarchy_swi AUTHID CURRENT_USER As
2 /* $Header: pepghswi.pkh 115.0 2003/09/25 03:56 krmahade noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |---------------------------< create_hierarchy >---------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 --  This procedure is the self-service wrapper procedure to the following
10 --  API: per_hierarchy_api.create_hierarchy
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
27   (p_validate                     in     number    default hr_api.g_false_num
28   ,p_hierarchy_id                    out nocopy number
29   ,p_business_group_id            in     number    default null
30   ,p_name                         in     varchar2  default null
31   ,p_type                         in     varchar2  default null
32   ,p_request_id                   in     number    default null
33   ,p_program_application_id       in     number    default null
34   ,p_program_id                   in     number    default null
35   ,p_program_update_date          in     date      default null
36   ,p_object_version_number        in out nocopy number
37   ,p_attribute_category           in     varchar2  default null
38   ,p_attribute1                   in     varchar2  default null
39   ,p_attribute2                   in     varchar2  default null
40   ,p_attribute3                   in     varchar2  default null
41   ,p_attribute4                   in     varchar2  default null
42   ,p_attribute5                   in     varchar2  default null
43   ,p_attribute6                   in     varchar2  default null
44   ,p_attribute7                   in     varchar2  default null
45   ,p_attribute8                   in     varchar2  default null
46   ,p_attribute9                   in     varchar2  default null
47   ,p_attribute10                  in     varchar2  default null
48   ,p_attribute11                  in     varchar2  default null
49   ,p_attribute12                  in     varchar2  default null
50   ,p_attribute13                  in     varchar2  default null
51   ,p_attribute14                  in     varchar2  default null
55   ,p_attribute18                  in     varchar2  default null
52   ,p_attribute15                  in     varchar2  default null
53   ,p_attribute16                  in     varchar2  default null
54   ,p_attribute17                  in     varchar2  default null
56   ,p_attribute19                  in     varchar2  default null
57   ,p_attribute20                  in     varchar2  default null
58   ,p_attribute21                  in     varchar2  default null
59   ,p_attribute22                  in     varchar2  default null
60   ,p_attribute23                  in     varchar2  default null
61   ,p_attribute24                  in     varchar2  default null
62   ,p_attribute25                  in     varchar2  default null
63   ,p_attribute26                  in     varchar2  default null
64   ,p_attribute27                  in     varchar2  default null
65   ,p_attribute28                  in     varchar2  default null
66   ,p_attribute29                  in     varchar2  default null
67   ,p_attribute30                  in     varchar2  default null
68   ,p_information_category         in     varchar2  default null
69   ,p_information1                 in     varchar2  default null
70   ,p_information2                 in     varchar2  default null
71   ,p_information3                 in     varchar2  default null
72   ,p_information4                 in     varchar2  default null
73   ,p_information5                 in     varchar2  default null
74   ,p_information6                 in     varchar2  default null
75   ,p_information7                 in     varchar2  default null
76   ,p_information8                 in     varchar2  default null
77   ,p_information9                 in     varchar2  default null
78   ,p_information10                in     varchar2  default null
79   ,p_information11                in     varchar2  default null
80   ,p_information12                in     varchar2  default null
81   ,p_information13                in     varchar2  default null
82   ,p_information14                in     varchar2  default null
83   ,p_information15                in     varchar2  default null
84   ,p_information16                in     varchar2  default null
85   ,p_information17                in     varchar2  default null
86   ,p_information18                in     varchar2  default null
87   ,p_information19                in     varchar2  default null
88   ,p_information20                in     varchar2  default null
89   ,p_information21                in     varchar2  default null
90   ,p_information22                in     varchar2  default null
91   ,p_information23                in     varchar2  default null
92   ,p_information24                in     varchar2  default null
93   ,p_information25                in     varchar2  default null
94   ,p_information26                in     varchar2  default null
95   ,p_information27                in     varchar2  default null
96   ,p_information28                in     varchar2  default null
97   ,p_information29                in     varchar2  default null
98   ,p_information30                in     varchar2  default null
99   ,p_effective_date               in     date
100   ,p_return_status                   out nocopy varchar2
101   );
102 -- ----------------------------------------------------------------------------
103 -- |---------------------------< delete_hierarchy >---------------------------|
104 -- ----------------------------------------------------------------------------
105 -- {Start of comments}
106 --
107 -- Description:
108 --  This procedure is the self-service wrapper procedure to the following
109 --  API: per_hierarchy_api.delete_hierarchy
110 --
111 -- Pre-requisites
112 --  All 'IN' parameters to this procedure have been appropriately derived.
113 --
114 -- Post Success:
115 --  p_return_status will return value indicating success.
116 --
117 -- Post Failure:
118 --  p_return_status will return value indication failure.
119 --
120 -- Access Status:
121 --  Internal Development use only.
122 --
123 -- {End of comments}
124 -- ----------------------------------------------------------------------------
125 PROCEDURE delete_hierarchy
126   (p_validate                     in     number    default hr_api.g_false_num
127   ,p_hierarchy_id                 in     number
128   ,p_object_version_number        in out nocopy number
129   ,p_return_status                   out nocopy varchar2
130   );
131 -- ----------------------------------------------------------------------------
132 -- |----------------------------------< lck >---------------------------------|
133 -- ----------------------------------------------------------------------------
134 -- {Start of comments}
135 --
136 -- Description:
137 --  This procedure is the self-service wrapper procedure to the following
138 --  API: per_hierarchy_api.lck
139 --
140 -- Pre-requisites
141 --  All 'IN' parameters to this procedure have been appropriately derived.
142 --
143 -- Post Success:
144 --  p_return_status will return value indicating success.
145 --
146 -- Post Failure:
147 --  p_return_status will return value indication failure.
148 --
149 -- Access Status:
150 --  Internal Development use only.
151 --
152 -- {End of comments}
153 -- ----------------------------------------------------------------------------
154 PROCEDURE lck
155   (p_hierarchy_id                 in     number
156   ,p_object_version_number        in     number
157   ,p_return_status                   out nocopy varchar2
158   );
159 -- ----------------------------------------------------------------------------
160 -- |---------------------------< update_hierarchy >---------------------------|
161 -- ----------------------------------------------------------------------------
162 -- {Start of comments}
163 --
164 -- Description:
168 -- Pre-requisites
165 --  This procedure is the self-service wrapper procedure to the following
166 --  API: per_hierarchy_api.update_hierarchy
167 --
169 --  All 'IN' parameters to this procedure have been appropriately derived.
170 --
171 -- Post Success:
172 --  p_return_status will return value indicating success.
173 --
174 -- Post Failure:
175 --  p_return_status will return value indication failure.
176 --
177 -- Access Status:
178 --  Internal Development use only.
179 --
180 -- {End of comments}
181 -- ----------------------------------------------------------------------------
182 PROCEDURE update_hierarchy
183   (p_validate                     in     number    default hr_api.g_false_num
184   ,p_hierarchy_id                 in     number
185   ,p_name                         in     varchar2  default hr_api.g_varchar2
186   ,p_request_id                   in     number    default hr_api.g_number
187   ,p_program_application_id       in     number    default hr_api.g_number
188   ,p_program_id                   in     number    default hr_api.g_number
189   ,p_program_update_date          in     date      default hr_api.g_date
190   ,p_object_version_number        in out nocopy number
191   ,p_attribute_category           in     varchar2  default hr_api.g_varchar2
192   ,p_attribute1                   in     varchar2  default hr_api.g_varchar2
193   ,p_attribute2                   in     varchar2  default hr_api.g_varchar2
194   ,p_attribute3                   in     varchar2  default hr_api.g_varchar2
195   ,p_attribute4                   in     varchar2  default hr_api.g_varchar2
196   ,p_attribute5                   in     varchar2  default hr_api.g_varchar2
197   ,p_attribute6                   in     varchar2  default hr_api.g_varchar2
198   ,p_attribute7                   in     varchar2  default hr_api.g_varchar2
199   ,p_attribute8                   in     varchar2  default hr_api.g_varchar2
200   ,p_attribute9                   in     varchar2  default hr_api.g_varchar2
201   ,p_attribute10                  in     varchar2  default hr_api.g_varchar2
202   ,p_attribute11                  in     varchar2  default hr_api.g_varchar2
203   ,p_attribute12                  in     varchar2  default hr_api.g_varchar2
204   ,p_attribute13                  in     varchar2  default hr_api.g_varchar2
205   ,p_attribute14                  in     varchar2  default hr_api.g_varchar2
206   ,p_attribute15                  in     varchar2  default hr_api.g_varchar2
207   ,p_attribute16                  in     varchar2  default hr_api.g_varchar2
208   ,p_attribute17                  in     varchar2  default hr_api.g_varchar2
209   ,p_attribute18                  in     varchar2  default hr_api.g_varchar2
210   ,p_attribute19                  in     varchar2  default hr_api.g_varchar2
211   ,p_attribute20                  in     varchar2  default hr_api.g_varchar2
212   ,p_attribute21                  in     varchar2  default hr_api.g_varchar2
213   ,p_attribute22                  in     varchar2  default hr_api.g_varchar2
214   ,p_attribute23                  in     varchar2  default hr_api.g_varchar2
215   ,p_attribute24                  in     varchar2  default hr_api.g_varchar2
216   ,p_attribute25                  in     varchar2  default hr_api.g_varchar2
217   ,p_attribute26                  in     varchar2  default hr_api.g_varchar2
218   ,p_attribute27                  in     varchar2  default hr_api.g_varchar2
219   ,p_attribute28                  in     varchar2  default hr_api.g_varchar2
220   ,p_attribute29                  in     varchar2  default hr_api.g_varchar2
221   ,p_attribute30                  in     varchar2  default hr_api.g_varchar2
222   ,p_information_category         in     varchar2  default hr_api.g_varchar2
223   ,p_information1                 in     varchar2  default hr_api.g_varchar2
224   ,p_information2                 in     varchar2  default hr_api.g_varchar2
225   ,p_information3                 in     varchar2  default hr_api.g_varchar2
226   ,p_information4                 in     varchar2  default hr_api.g_varchar2
227   ,p_information5                 in     varchar2  default hr_api.g_varchar2
228   ,p_information6                 in     varchar2  default hr_api.g_varchar2
229   ,p_information7                 in     varchar2  default hr_api.g_varchar2
230   ,p_information8                 in     varchar2  default hr_api.g_varchar2
231   ,p_information9                 in     varchar2  default hr_api.g_varchar2
232   ,p_information10                in     varchar2  default hr_api.g_varchar2
233   ,p_information11                in     varchar2  default hr_api.g_varchar2
234   ,p_information12                in     varchar2  default hr_api.g_varchar2
235   ,p_information13                in     varchar2  default hr_api.g_varchar2
236   ,p_information14                in     varchar2  default hr_api.g_varchar2
237   ,p_information15                in     varchar2  default hr_api.g_varchar2
238   ,p_information16                in     varchar2  default hr_api.g_varchar2
239   ,p_information17                in     varchar2  default hr_api.g_varchar2
240   ,p_information18                in     varchar2  default hr_api.g_varchar2
241   ,p_information19                in     varchar2  default hr_api.g_varchar2
242   ,p_information20                in     varchar2  default hr_api.g_varchar2
243   ,p_information21                in     varchar2  default hr_api.g_varchar2
244   ,p_information22                in     varchar2  default hr_api.g_varchar2
245   ,p_information23                in     varchar2  default hr_api.g_varchar2
246   ,p_information24                in     varchar2  default hr_api.g_varchar2
247   ,p_information25                in     varchar2  default hr_api.g_varchar2
248   ,p_information26                in     varchar2  default hr_api.g_varchar2
249   ,p_information27                in     varchar2  default hr_api.g_varchar2
250   ,p_information28                in     varchar2  default hr_api.g_varchar2
251   ,p_information29                in     varchar2  default hr_api.g_varchar2
252   ,p_information30                in     varchar2  default hr_api.g_varchar2
253   ,p_effective_date               in     date
254   ,p_return_status                   out nocopy varchar2
255   );
256 end per_hierarchy_swi;