1 Package per_hierarchy_nodes_api as
2 /* $Header: pepgnapi.pkh 120.2 2005/10/22 01:24:34 aroussel noship $ */
3 /*#
4 * This package contains APIs which maintain node data (value or leave) records
5 * within a generic hierarchy structure.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Generic Hierarchy Node
9 */
10 G_MODE VARCHAR2(10);
11 --
12 -- ----------------------------------------------------------------------------
13 -- |--------------------------< create_hierarchy_nodes >----------------------|
14 -- ----------------------------------------------------------------------------
15 --
16 -- {Start Of Comments}
17 /*#
18 * This API creates a generic hierarchy node.
19 *
20 * A generic hierarchy data structure consists of individual data values called
21 * nodes which are arranged in parent-child relationships to create a hierarchy
22 * or tree of data. The top node is known as the root node, under which there
23 * can be many child and grandchild nodes. The value for each node is drawn
24 * from the value set that has been identified as providing data for that
25 * particular level of the structure. Each node, with the exception of the root
26 * node, will be linked to a parent node. In this way a hierarchy of data
27 * values is constructed.
28 *
29 * <p><b>Licensing</b><br>
30 * This API is licensed for use with Human Resources.
31 *
32 * <p><b>Prerequisites</b><br>
33 * The generic hierarchy structure version under which the node will be created
34 * must exist.
35 *
36 * <p><b>Post Success</b><br>
37 * The API creates the hierarchy node.
38 *
39 * <p><b>Post Failure</b><br>
40 * The API does not create the hierarchy node and an error is raised.
41 * @param p_validate If true, then validation alone will be performed and the
42 * database will remain unchanged. If false and all validation checks pass,
43 * then the database will be modified.
44 * @param p_hierarchy_node_id If p_validate is false then uniquely identifies
45 * the generic hierarchy node created. If p_validate is true then set to null.
46 * @param p_business_group_id The business group under which this generic
47 * hierarchy node is created.
48 * @param p_entity_id Provides the value of the node. This is the value set
49 * value drawn from the value set held by the child node type specified in the
50 * node_type parameter.
51 * @param p_hierarchy_version_id Uniquely identifies the generic hierarchy
52 * structure version that the node is part of.
53 * @param p_node_type The child node type which is providing the value set
54 * source of values for this node.
55 * @param p_seq The sequence of the node relative to the other nodes that may
56 * exist at this level (under this parent).
57 * @param p_parent_hierarchy_node_id Uniquely identifies the parent generic
58 * hierarchy node under which this node exists.
59 * @param p_request_id When the API is executed from a concurrent program set
60 * to the concurrent request identifier.
61 * @param p_program_application_id When the API is executed from a concurrent
62 * program set to the program's Application.
63 * @param p_program_id When the API is executed from a concurrent program set
64 * to the program's identifier.
65 * @param p_program_update_date When the API is executed from a concurrent
66 * program set to when the program was ran.
67 * @param p_object_version_number If p_validate is false, then set to the
68 * version number of the created generic hierarchy node. If p_validate is true,
69 * then the value will be null.
70 * @param p_attribute_category This context value determines which flexfield
71 * structure to use with the descriptive flexfield segments.
72 * @param p_attribute1 Descriptive flexfield segment.
73 * @param p_attribute2 Descriptive flexfield segment.
74 * @param p_attribute3 Descriptive flexfield segment.
75 * @param p_attribute4 Descriptive flexfield segment.
76 * @param p_attribute5 Descriptive flexfield segment.
77 * @param p_attribute6 Descriptive flexfield segment.
78 * @param p_attribute7 Descriptive flexfield segment.
79 * @param p_attribute8 Descriptive flexfield segment.
80 * @param p_attribute9 Descriptive flexfield segment.
81 * @param p_attribute10 Descriptive flexfield segment.
82 * @param p_attribute11 Descriptive flexfield segment.
83 * @param p_attribute12 Descriptive flexfield segment.
84 * @param p_attribute13 Descriptive flexfield segment.
85 * @param p_attribute14 Descriptive flexfield segment.
86 * @param p_attribute15 Descriptive flexfield segment.
87 * @param p_attribute16 Descriptive flexfield segment.
88 * @param p_attribute17 Descriptive flexfield segment.
89 * @param p_attribute18 Descriptive flexfield segment.
90 * @param p_attribute19 Descriptive flexfield segment.
91 * @param p_attribute20 Descriptive flexfield segment.
92 * @param p_attribute21 Descriptive flexfield segment.
93 * @param p_attribute22 Descriptive flexfield segment.
94 * @param p_attribute23 Descriptive flexfield segment.
95 * @param p_attribute24 Descriptive flexfield segment.
96 * @param p_attribute25 Descriptive flexfield segment.
97 * @param p_attribute26 Descriptive flexfield segment.
98 * @param p_attribute27 Descriptive flexfield segment.
99 * @param p_attribute28 Descriptive flexfield segment.
100 * @param p_attribute29 Descriptive flexfield segment.
101 * @param p_attribute30 Descriptive flexfield segment.
102 * @param p_information_category This context value determines which flexfield
103 * structure to use with the developer descriptive flexfield segments.
104 * @param p_information1 Developer descriptive flexfield segment.
105 * @param p_information2 Developer descriptive flexfield segment.
106 * @param p_information3 Developer descriptive flexfield segment.
107 * @param p_information4 Developer descriptive flexfield segment.
108 * @param p_information5 Developer descriptive flexfield segment.
109 * @param p_information6 Developer descriptive flexfield segment.
110 * @param p_information7 Developer descriptive flexfield segment.
111 * @param p_information8 Developer descriptive flexfield segment.
112 * @param p_information9 Developer descriptive flexfield segment.
113 * @param p_information10 Developer descriptive flexfield segment.
114 * @param p_information11 Developer descriptive flexfield segment.
115 * @param p_information12 Developer descriptive flexfield segment.
116 * @param p_information13 Developer descriptive flexfield segment.
117 * @param p_information14 Developer descriptive flexfield segment.
118 * @param p_information15 Developer descriptive flexfield segment.
119 * @param p_information16 Developer descriptive flexfield segment.
120 * @param p_information17 Developer descriptive flexfield segment.
121 * @param p_information18 Developer descriptive flexfield segment.
122 * @param p_information19 Developer descriptive flexfield segment.
123 * @param p_information20 Developer descriptive flexfield segment.
124 * @param p_information21 Developer descriptive flexfield segment.
125 * @param p_information22 Developer descriptive flexfield segment.
126 * @param p_information23 Developer descriptive flexfield segment.
127 * @param p_information24 Developer descriptive flexfield segment.
128 * @param p_information25 Developer descriptive flexfield segment.
129 * @param p_information26 Developer descriptive flexfield segment.
130 * @param p_information27 Developer descriptive flexfield segment.
131 * @param p_information28 Developer descriptive flexfield segment.
132 * @param p_information29 Developer descriptive flexfield segment.
133 * @param p_information30 Developer descriptive flexfield segment.
134 * @param p_effective_date Reference date for validating lookup values are
135 * applicable during the start to end active date range. This date does not
136 * determine when the changes take effect.
137 * @rep:displayname Create Generic Hierarchy Node
138 * @rep:category BUSINESS_ENTITY PER_GENERIC_HIERARCHY
139 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
140 * @rep:scope public
141 * @rep:lifecycle active
142 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
143 */
144 --
145 -- {End Of Comments}
146 --
147 procedure create_hierarchy_nodes
148 (
149 p_validate in boolean default false
150 ,p_hierarchy_node_id out nocopy number
151 ,p_business_group_id in number default null
152 ,p_entity_id in varchar2 default null
153 ,p_hierarchy_version_id in number default null
154 ,p_node_type in varchar2 default null
155 ,p_seq in number default null
156 ,p_parent_hierarchy_node_id in number default null
157 ,p_request_id in number default null
158 ,p_program_application_id in number default null
159 ,p_program_id in number default null
160 ,p_program_update_date in date default null
161 ,p_object_version_number out nocopy number
162 ,p_attribute_category in varchar2 default null
163 ,p_attribute1 in varchar2 default null
164 ,p_attribute2 in varchar2 default null
165 ,p_attribute3 in varchar2 default null
166 ,p_attribute4 in varchar2 default null
167 ,p_attribute5 in varchar2 default null
168 ,p_attribute6 in varchar2 default null
169 ,p_attribute7 in varchar2 default null
170 ,p_attribute8 in varchar2 default null
171 ,p_attribute9 in varchar2 default null
172 ,p_attribute10 in varchar2 default null
173 ,p_attribute11 in varchar2 default null
174 ,p_attribute12 in varchar2 default null
175 ,p_attribute13 in varchar2 default null
176 ,p_attribute14 in varchar2 default null
177 ,p_attribute15 in varchar2 default null
178 ,p_attribute16 in varchar2 default null
179 ,p_attribute17 in varchar2 default null
180 ,p_attribute18 in varchar2 default null
181 ,p_attribute19 in varchar2 default null
182 ,p_attribute20 in varchar2 default null
183 ,p_attribute21 in varchar2 default null
184 ,p_attribute22 in varchar2 default null
185 ,p_attribute23 in varchar2 default null
186 ,p_attribute24 in varchar2 default null
187 ,p_attribute25 in varchar2 default null
188 ,p_attribute26 in varchar2 default null
189 ,p_attribute27 in varchar2 default null
190 ,p_attribute28 in varchar2 default null
191 ,p_attribute29 in varchar2 default null
192 ,p_attribute30 in varchar2 default null
193 ,p_information_category in varchar2 default null
194 ,p_information1 in varchar2 default null
195 ,p_information2 in varchar2 default null
196 ,p_information3 in varchar2 default null
197 ,p_information4 in varchar2 default null
198 ,p_information5 in varchar2 default null
199 ,p_information6 in varchar2 default null
200 ,p_information7 in varchar2 default null
201 ,p_information8 in varchar2 default null
202 ,p_information9 in varchar2 default null
203 ,p_information10 in varchar2 default null
204 ,p_information11 in varchar2 default null
205 ,p_information12 in varchar2 default null
206 ,p_information13 in varchar2 default null
207 ,p_information14 in varchar2 default null
208 ,p_information15 in varchar2 default null
209 ,p_information16 in varchar2 default null
210 ,p_information17 in varchar2 default null
211 ,p_information18 in varchar2 default null
212 ,p_information19 in varchar2 default null
213 ,p_information20 in varchar2 default null
214 ,p_information21 in varchar2 default null
215 ,p_information22 in varchar2 default null
216 ,p_information23 in varchar2 default null
217 ,p_information24 in varchar2 default null
218 ,p_information25 in varchar2 default null
219 ,p_information26 in varchar2 default null
220 ,p_information27 in varchar2 default null
221 ,p_information28 in varchar2 default null
222 ,p_information29 in varchar2 default null
223 ,p_information30 in varchar2 default null
224 ,p_effective_date in date
225 );
226 --
227 -- ----------------------------------------------------------------------------
228 -- |--------------------------< update_hierarchy_nodes >----------------------|
229 -- ----------------------------------------------------------------------------
230 --
231 -- {Start Of Comments}
232 /*#
233 * This API updates a generic hierarchy node.
234 *
235 * A generic hierarchy data structure consists of individual data values called
236 * nodes which are arranged in parent-child relationships to create a hierarchy
237 * or tree of data. The top node is known as the root node, under which there
238 * can be many child and grandchild nodes, etc. The value for each node is
239 * drawn from the value set that has been identified as providing data for that
240 * particular level of the structure. Each node, with the exception of the root
241 * node, will be linked to a parent node. In this way a hierarchy of data
242 * values is constructed.
243 *
244 * <p><b>Licensing</b><br>
245 * This API is licensed for use with Human Resources.
246 *
247 * <p><b>Prerequisites</b><br>
248 * The node type to be updated must exist.
249 *
250 * <p><b>Post Success</b><br>
251 * The API updates the node type.
252 *
253 * <p><b>Post Failure</b><br>
254 * The API does not update the node type and an error is raised.
255 * @param p_validate If true, then validation alone will be performed and the
256 * database will remain unchanged. If false and all validation checks pass,
257 * then the database will be modified.
258 * @param p_hierarchy_node_id Uniquely identifies the node type to be updated.
259 * @param p_entity_id Provides the value of the node. This is the value set
260 * value drawn from the value set held by the child node type specified in the
261 * node_type parameter.
262 * @param p_node_type The child node type which is providing the value set
263 * source of values for this node.
264 * @param p_seq The sequence of the node relative to the other nodes that may
265 * exist at this level (under this parent).
266 * @param p_parent_hierarchy_node_id Uniquely identifies the parent generic
267 * hierarchy node under which this node exists.
268 * @param p_request_id When the API is executed from a concurrent program set
269 * to the concurrent request identifier.
270 * @param p_program_application_id When the API is executed from a concurrent
271 * program set to the program's Application.
272 * @param p_program_id When the API is executed from a concurrent program set
273 * to the program's identifier.
274 * @param p_program_update_date When the API is executed from a concurrent
275 * program set to when the program was ran.
276 * @param p_object_version_number Pass in the current version number of the
277 * generic hierarchy node to be updated. When the API completes if p_validate
278 * is false, will be set to the new version number of the updated generic
279 * hierarchy node. If p_validate is true will be set to the same value which
280 * was passed in.
281 * @param p_attribute_category This context value determines which flexfield
282 * structure to use with the descriptive flexfield segments.
283 * @param p_attribute1 Descriptive flexfield segment.
284 * @param p_attribute2 Descriptive flexfield segment.
285 * @param p_attribute3 Descriptive flexfield segment.
286 * @param p_attribute4 Descriptive flexfield segment.
287 * @param p_attribute5 Descriptive flexfield segment.
288 * @param p_attribute6 Descriptive flexfield segment.
289 * @param p_attribute7 Descriptive flexfield segment.
290 * @param p_attribute8 Descriptive flexfield segment.
291 * @param p_attribute9 Descriptive flexfield segment.
292 * @param p_attribute10 Descriptive flexfield segment.
293 * @param p_attribute11 Descriptive flexfield segment.
294 * @param p_attribute12 Descriptive flexfield segment.
295 * @param p_attribute13 Descriptive flexfield segment.
299 * @param p_attribute17 Descriptive flexfield segment.
296 * @param p_attribute14 Descriptive flexfield segment.
297 * @param p_attribute15 Descriptive flexfield segment.
298 * @param p_attribute16 Descriptive flexfield segment.
300 * @param p_attribute18 Descriptive flexfield segment.
301 * @param p_attribute19 Descriptive flexfield segment.
302 * @param p_attribute20 Descriptive flexfield segment.
303 * @param p_attribute21 Descriptive flexfield segment.
304 * @param p_attribute22 Descriptive flexfield segment.
305 * @param p_attribute23 Descriptive flexfield segment.
306 * @param p_attribute24 Descriptive flexfield segment.
307 * @param p_attribute25 Descriptive flexfield segment.
308 * @param p_attribute26 Descriptive flexfield segment.
309 * @param p_attribute27 Descriptive flexfield segment.
310 * @param p_attribute28 Descriptive flexfield segment.
311 * @param p_attribute29 Descriptive flexfield segment.
312 * @param p_attribute30 Descriptive flexfield segment.
313 * @param p_information_category This context value determines which flexfield
314 * structure to use with the developer descriptive flexfield segments.
315 * @param p_information1 Developer descriptive flexfield segment.
316 * @param p_information2 Developer descriptive flexfield segment.
317 * @param p_information3 Developer descriptive flexfield segment.
318 * @param p_information4 Developer descriptive flexfield segment.
319 * @param p_information5 Developer descriptive flexfield segment.
320 * @param p_information6 Developer descriptive flexfield segment.
321 * @param p_information7 Developer descriptive flexfield segment.
322 * @param p_information8 Developer descriptive flexfield segment.
323 * @param p_information9 Developer descriptive flexfield segment.
324 * @param p_information10 Developer descriptive flexfield segment.
325 * @param p_information11 Developer descriptive flexfield segment.
326 * @param p_information12 Developer descriptive flexfield segment.
327 * @param p_information13 Developer descriptive flexfield segment.
328 * @param p_information14 Developer descriptive flexfield segment.
329 * @param p_information15 Developer descriptive flexfield segment.
330 * @param p_information16 Developer descriptive flexfield segment.
331 * @param p_information17 Developer descriptive flexfield segment.
332 * @param p_information18 Developer descriptive flexfield segment.
333 * @param p_information19 Developer descriptive flexfield segment.
334 * @param p_information20 Developer descriptive flexfield segment.
335 * @param p_information21 Developer descriptive flexfield segment.
336 * @param p_information22 Developer descriptive flexfield segment.
337 * @param p_information23 Developer descriptive flexfield segment.
338 * @param p_information24 Developer descriptive flexfield segment.
339 * @param p_information25 Developer descriptive flexfield segment.
340 * @param p_information26 Developer descriptive flexfield segment.
341 * @param p_information27 Developer descriptive flexfield segment.
342 * @param p_information28 Developer descriptive flexfield segment.
343 * @param p_information29 Developer descriptive flexfield segment.
344 * @param p_information30 Developer descriptive flexfield segment.
345 * @param p_effective_date Reference date for validating lookup values are
346 * applicable during the start to end active date range. This date does not
347 * determine when the changes take effect
348 * @rep:displayname Update Generic Hierarchy Node
349 * @rep:category BUSINESS_ENTITY PER_GENERIC_HIERARCHY
350 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
351 * @rep:scope public
352 * @rep:lifecycle active
353 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
354 */
355 --
356 -- {End Of Comments}
357 --
358 procedure update_hierarchy_nodes
359 (
360 p_validate in boolean default false
361 ,p_hierarchy_node_id in number
362 ,p_entity_id in varchar2 default hr_api.g_varchar2
363 ,p_node_type in varchar2 default hr_api.g_varchar2
364 ,p_seq in number default hr_api.g_number
365 ,p_parent_hierarchy_node_id in number default hr_api.g_number
366 ,p_request_id in number default hr_api.g_number
367 ,p_program_application_id in number default hr_api.g_number
368 ,p_program_id in number default hr_api.g_number
369 ,p_program_update_date in date default hr_api.g_date
370 ,p_object_version_number in out nocopy number
371 ,p_attribute_category in varchar2 default hr_api.g_varchar2
372 ,p_attribute1 in varchar2 default hr_api.g_varchar2
373 ,p_attribute2 in varchar2 default hr_api.g_varchar2
374 ,p_attribute3 in varchar2 default hr_api.g_varchar2
375 ,p_attribute4 in varchar2 default hr_api.g_varchar2
376 ,p_attribute5 in varchar2 default hr_api.g_varchar2
377 ,p_attribute6 in varchar2 default hr_api.g_varchar2
378 ,p_attribute7 in varchar2 default hr_api.g_varchar2
379 ,p_attribute8 in varchar2 default hr_api.g_varchar2
380 ,p_attribute9 in varchar2 default hr_api.g_varchar2
381 ,p_attribute10 in varchar2 default hr_api.g_varchar2
382 ,p_attribute11 in varchar2 default hr_api.g_varchar2
383 ,p_attribute12 in varchar2 default hr_api.g_varchar2
384 ,p_attribute13 in varchar2 default hr_api.g_varchar2
385 ,p_attribute14 in varchar2 default hr_api.g_varchar2
386 ,p_attribute15 in varchar2 default hr_api.g_varchar2
390 ,p_attribute19 in varchar2 default hr_api.g_varchar2
387 ,p_attribute16 in varchar2 default hr_api.g_varchar2
388 ,p_attribute17 in varchar2 default hr_api.g_varchar2
389 ,p_attribute18 in varchar2 default hr_api.g_varchar2
391 ,p_attribute20 in varchar2 default hr_api.g_varchar2
392 ,p_attribute21 in varchar2 default hr_api.g_varchar2
393 ,p_attribute22 in varchar2 default hr_api.g_varchar2
394 ,p_attribute23 in varchar2 default hr_api.g_varchar2
395 ,p_attribute24 in varchar2 default hr_api.g_varchar2
396 ,p_attribute25 in varchar2 default hr_api.g_varchar2
397 ,p_attribute26 in varchar2 default hr_api.g_varchar2
398 ,p_attribute27 in varchar2 default hr_api.g_varchar2
399 ,p_attribute28 in varchar2 default hr_api.g_varchar2
400 ,p_attribute29 in varchar2 default hr_api.g_varchar2
401 ,p_attribute30 in varchar2 default hr_api.g_varchar2
402 ,p_information_category in varchar2 default hr_api.g_varchar2
403 ,p_information1 in varchar2 default hr_api.g_varchar2
404 ,p_information2 in varchar2 default hr_api.g_varchar2
405 ,p_information3 in varchar2 default hr_api.g_varchar2
406 ,p_information4 in varchar2 default hr_api.g_varchar2
407 ,p_information5 in varchar2 default hr_api.g_varchar2
408 ,p_information6 in varchar2 default hr_api.g_varchar2
409 ,p_information7 in varchar2 default hr_api.g_varchar2
410 ,p_information8 in varchar2 default hr_api.g_varchar2
411 ,p_information9 in varchar2 default hr_api.g_varchar2
412 ,p_information10 in varchar2 default hr_api.g_varchar2
413 ,p_information11 in varchar2 default hr_api.g_varchar2
414 ,p_information12 in varchar2 default hr_api.g_varchar2
415 ,p_information13 in varchar2 default hr_api.g_varchar2
416 ,p_information14 in varchar2 default hr_api.g_varchar2
417 ,p_information15 in varchar2 default hr_api.g_varchar2
418 ,p_information16 in varchar2 default hr_api.g_varchar2
419 ,p_information17 in varchar2 default hr_api.g_varchar2
420 ,p_information18 in varchar2 default hr_api.g_varchar2
421 ,p_information19 in varchar2 default hr_api.g_varchar2
422 ,p_information20 in varchar2 default hr_api.g_varchar2
423 ,p_information21 in varchar2 default hr_api.g_varchar2
424 ,p_information22 in varchar2 default hr_api.g_varchar2
425 ,p_information23 in varchar2 default hr_api.g_varchar2
426 ,p_information24 in varchar2 default hr_api.g_varchar2
427 ,p_information25 in varchar2 default hr_api.g_varchar2
428 ,p_information26 in varchar2 default hr_api.g_varchar2
429 ,p_information27 in varchar2 default hr_api.g_varchar2
430 ,p_information28 in varchar2 default hr_api.g_varchar2
431 ,p_information29 in varchar2 default hr_api.g_varchar2
432 ,p_information30 in varchar2 default hr_api.g_varchar2
433 ,p_effective_date in date
434 );
435 --
436 -- ----------------------------------------------------------------------------
437 -- |--------------------------< delete_hierarchy_nodes >----------------------|
438 -- ----------------------------------------------------------------------------
439 --
440 -- {Start Of Comments}
441 /*#
442 * This API deletes a generic hierarchy node.
443 *
444 * A generic hierarchy data structure consists of individual data values called
445 * nodes which are arranged in parent-child relationships to create a hierarchy
446 * or tree of data. The top node is known as the root node, under which there
447 * can be many child and grandchild nodes, etc. The value for each node is
448 * drawn from the value set that has been identified as providing data for that
449 * particular level of the structure. Each node, with the exception of the root
450 * node, will be linked to a parent node. In this way a hierarchy of data
451 * values is constructed.
452 *
453 * <p><b>Licensing</b><br>
454 * This API is licensed for use with Human Resources.
455 *
456 * <p><b>Prerequisites</b><br>
457 * The generic hierarchy node must exist and must not have any child generic
458 * hierarchy nodes referencing it.
459 *
460 * <p><b>Post Success</b><br>
461 * The hierarchy node is deleted.
462 *
463 * <p><b>Post Failure</b><br>
464 * The API does not delete the hierarchy node and an error is raised.
465 * @param p_validate If true, then validation alone will be performed and the
466 * database will remain unchanged. If false and all validation checks pass,
467 * then the database will be modified.
468 * @param p_hierarchy_node_id Uniquely identifies the generic hierarchy node to
469 * be deleted.
470 * @param p_object_version_number Current version number of the generic
471 * hierarchy node to be deleted.
472 * @rep:displayname Delete Generic Hierarchy Node
473 * @rep:category BUSINESS_ENTITY PER_GENERIC_HIERARCHY
474 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
475 * @rep:scope public
476 * @rep:lifecycle active
477 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
478 */
479 --
480 -- {End Of Comments}
481 --
482 procedure delete_hierarchy_nodes
483 (
484 p_validate in boolean default false
485 ,p_hierarchy_node_id in number
486 ,p_object_version_number in out nocopy number
487 );
488 --
489 -- ----------------------------------------------------------------------------
490 -- |----------------------------------< lck >---------------------------------|
491 -- ----------------------------------------------------------------------------
492 -- {Start Of Comments}
493 --
494 -- Description:
495 --
496 -- Prerequisites:
497 --
498 --
499 -- In Parameters:
500 -- Name Reqd Type Description
501 -- p_hierarchy_node_id Yes number PK of record
502 -- p_object_version_number Yes number OVN of record
503 --
504 -- Post Success:
505 --
506 -- Name Type Description
507 --
508 -- Post Failure:
509 --
510 -- Access Status:
511 -- Public.
512 --
513 -- {End Of Comments}
514 --
515 procedure lck
516 (
520 --
517 p_hierarchy_node_id in number
518 ,p_object_version_number in number
519 );
521 end per_hierarchy_nodes_api;