1 PACKAGE AMW_ORG_HIERARCHY_PKG as
2 /*$Header: amwoghrs.pls 120.7.12000000.1 2007/01/16 20:39:40 appldev ship $*/
3
4
5 TYPE t_Org_Ids IS TABLE OF amw_audit_units_v.organization_id%type;
6 TYPE t_number IS TABLE OF number;
7
8 Org_Ids t_Org_Ids;
9
10 procedure sync_people_revoke_grant( p_org_id in number,
11 p_process_id in number,
12 p_org_menu_name in varchar2,
13 p_rl_menu_name in varchar2 );
14
15 procedure sync_people_add_grant( p_org_id in number,
16 p_process_id in number,
17 p_org_menu_name in varchar2,
18 p_rl_menu_name in varchar2 );
19
20
21 PROCEDURE push_proc_org_no_count(
22 errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY VARCHAR2,
24 p_process_id IN number,
25 p_org_name IN varchar2,
26 p_org_range_from IN varchar2,
27 p_org_range_to IN varchar2,
28 p_synchronize IN varchar2,
29 p_apply_rcm IN varchar2
30 );
31
32 PROCEDURE sync_proc_org_srs(
33 errbuf OUT NOCOPY VARCHAR2,
34 retcode OUT NOCOPY VARCHAR2,
35 p_process_id IN number,
36 p_org_name IN varchar2,
37 p_org_range_from IN varchar2,
38 p_org_range_to IN varchar2,
39 p_sync_mode in varchar2,
40 p_sync_hierarchy in varchar2,
41 p_sync_attributes in varchar2,
42 p_sync_rcm in varchar2,
43 p_sync_people in varchar2,
44 p_sync_approve in varchar2
45 );
46
47 PROCEDURE push_proc_org_srs(
48 errbuf OUT NOCOPY VARCHAR2,
49 retcode OUT NOCOPY VARCHAR2,
50 p_process_id IN number,
51 p_org_name IN varchar2,
52 -- p_range_char_count IN NUMBER := NULL,
53 p_org_range_from IN VARCHAR2 := NULL,
54 p_org_range_to IN VARCHAR2 := NULL,
55 p_synchronize IN varchar2,
56 p_apply_rcm IN varchar2);
57
58 PROCEDURE push_proc_org_conc_request(
59 errbuf OUT NOCOPY VARCHAR2,
60 retcode OUT NOCOPY VARCHAR2,
61 p_parent_orgprocess_id IN varchar2,
62 p_process_id IN varchar2,
63 p_mode IN varchar2,
64 p_apply_rcm IN varchar2,
65 p_synchronize IN varchar2,
66 p_org_id_count IN varchar2,
67 p_org_id_string1 IN varchar2 := NULL,
68 p_org_id_string2 IN varchar2 := NULL,
69 p_org_id_string3 IN varchar2 := NULL,
70 p_org_id_string4 IN varchar2 := NULL,
71 p_org_id_string5 IN varchar2 := NULL,
72 p_org_id_string6 IN varchar2 := NULL,
73 p_org_id_string7 IN varchar2 := NULL,
74 p_org_id_string8 IN varchar2 := NULL,
75 p_org_id_string9 IN varchar2 := NULL,
76 p_org_id_string10 IN varchar2 := NULL,
77 p_org_id_string11 IN varchar2 := NULL,
78 p_org_id_string12 IN varchar2 := NULL,
79 p_org_id_string13 IN varchar2 := NULL,
80 p_org_id_string14 IN varchar2 := NULL,
81 p_org_id_string15 IN varchar2 := NULL,
82 p_org_id_string16 IN varchar2 := NULL,
83 p_org_id_string17 IN varchar2 := NULL,
84 p_org_id_string18 IN varchar2 := NULL,
85 p_org_id_string19 IN varchar2 := NULL,
86 p_org_id_string20 IN varchar2 := NULL,
87 p_org_id_string21 IN varchar2 := NULL,
88 p_org_id_string22 IN varchar2 := NULL,
89 p_org_id_string23 IN varchar2 := NULL,
90 p_org_id_string24 IN varchar2 := NULL,
91 p_org_id_string25 IN varchar2 := NULL,
92 p_org_id_string26 IN varchar2 := NULL,
93 p_org_id_string27 IN varchar2 := NULL,
94 p_org_id_string28 IN varchar2 := NULL,
95 p_org_id_string29 IN varchar2 := NULL,
96 p_org_id_string30 IN varchar2 := NULL,
97 p_org_id_string31 IN varchar2 := NULL,
98 p_org_id_string32 IN varchar2 := NULL,
99 p_org_id_string33 IN varchar2 := NULL,
100 p_org_id_string34 IN varchar2 := NULL,
101 p_org_id_string35 IN varchar2 := NULL,
102 p_org_id_string36 IN varchar2 := NULL,
103 p_org_id_string37 IN varchar2 := NULL,
104 p_org_id_string38 IN varchar2 := NULL,
105 p_org_id_string39 IN varchar2 := NULL,
106 p_org_id_string40 IN varchar2 := NULL,
107 p_org_id_string41 IN varchar2 := NULL,
108 p_org_id_string42 IN varchar2 := NULL,
109 p_org_id_string43 IN varchar2 := NULL,
110 p_org_id_string44 IN varchar2 := NULL,
111 p_org_id_string45 IN varchar2 := NULL,
112 p_org_id_string46 IN varchar2 := NULL,
113 p_org_id_string47 IN varchar2 := NULL,
114 p_org_id_string48 IN varchar2 := NULL,
115 p_org_id_string49 IN varchar2 := NULL,
116 p_org_id_string50 IN varchar2 := NULL,
117 p_org_id_string51 IN varchar2 := NULL,
118 p_org_id_string52 IN varchar2 := NULL,
119 p_org_id_string53 IN varchar2 := NULL,
120 p_org_id_string54 IN varchar2 := NULL,
121 p_org_id_string55 IN varchar2 := NULL,
122 p_org_id_string56 IN varchar2 := NULL,
123 p_org_id_string57 IN varchar2 := NULL,
124 p_org_id_string58 IN varchar2 := NULL,
125 p_org_id_string59 IN varchar2 := NULL,
126 p_org_id_string60 IN varchar2 := NULL,
127 p_org_id_string61 IN varchar2 := NULL,
128 p_org_id_string62 IN varchar2 := NULL,
129 p_org_id_string63 IN varchar2 := NULL,
130 p_org_id_string64 IN varchar2 := NULL,
131 p_org_id_string65 IN varchar2 := NULL,
132 p_org_id_string66 IN varchar2 := NULL,
133 p_org_id_string67 IN varchar2 := NULL,
134 p_org_id_string68 IN varchar2 := NULL,
135 p_org_id_string69 IN varchar2 := NULL,
136 p_org_id_string70 IN varchar2 := NULL,
137 p_org_id_string71 IN varchar2 := NULL,
138 p_org_id_string72 IN varchar2 := NULL,
139 p_org_id_string73 IN varchar2 := NULL,
140 p_org_id_string74 IN varchar2 := NULL,
141 p_org_id_string75 IN varchar2 := NULL,
142 p_org_id_string76 IN varchar2 := NULL,
143 p_org_id_string77 IN varchar2 := NULL,
144 p_org_id_string78 IN varchar2 := NULL,
145 p_org_id_string79 IN varchar2 := NULL,
146 p_org_id_string80 IN varchar2 := NULL,
147 p_org_id_string81 IN varchar2 := NULL,
148 p_org_id_string82 IN varchar2 := NULL,
149 p_org_id_string83 IN varchar2 := NULL,
150 p_org_id_string84 IN varchar2 := NULL,
151 p_org_id_string85 IN varchar2 := NULL,
152 p_org_id_string86 IN varchar2 := NULL,
153 p_org_id_string87 IN varchar2 := NULL,
154 p_org_id_string88 IN varchar2 := NULL,
155 p_org_id_string89 IN varchar2 := NULL,
156 p_org_id_string90 IN varchar2 := NULL,
157 p_org_id_string91 IN varchar2 := NULL,
158 p_org_id_string92 IN varchar2 := NULL);
159
160 procedure push_proc_org(
161 p_parent_orgprocess_id in number,
162 p_process_id in number,
163 p_org_id_string in varchar2,
164 p_mode in varchar2,
165 p_apply_rcm in varchar2,
166 p_synchronize in varchar2,
167 p_update_count in varchar2 := FND_API.G_TRUE,
168 p_commit in varchar2 := FND_API.G_FALSE,
169 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
170 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171 x_return_status out nocopy varchar2,
172 x_msg_count out nocopy number,
173 x_msg_data out nocopy varchar2 );
174
175 procedure push_proc_per_org(
176 p_parent_orgprocess_id in number,
177 p_process_id in number,
178 p_org_id in number,
179 p_mode in varchar2,
180 p_apply_rcm in varchar2,
181 p_synchronize in varchar2,
182 p_update_count in varchar2 := FND_API.G_TRUE,
183 p_commit in varchar2 := FND_API.G_FALSE,
184 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186 x_return_status out nocopy varchar2,
187 x_msg_count out nocopy number,
188 x_msg_data out nocopy varchar2 );
189
190
191 -- it's enough if we check just the latest hierarchy that the child being added
192 -- exists as a parent
193 function is_child_an_ancestor(p_org_id in number,
194 p_parent_process_id in number,
195 p_child_process_id in number) return boolean;
196
197
198 -- The parent process and the child process both exist as ICM processes
199 -- Make a new link or delete an exisitng link. Revise parent if necessary
200 /*procedure add_delete_ex_child (
201 p_org_id in number,
202 p_parent_process_id in number,
203 p_child_process_id in number,
204 p_action in varchar2,
205 x_return_status out nocopy varchar2,
206 x_msg_count out nocopy number,
207 x_msg_data out nocopy varchar2);*/
208 procedure add_delete_ex_child (
209 p_org_id in number,
210 p_parent_process_id in number,
211 p_child_process_id in number,
212 p_action in varchar2);
213
214
215 -- check if a process exists in an org.
216 -- If it does not exist, return NOEXIST
217 -- If it exists but is "deleted", return DEL
218 -- If it exists but in no hierarchy, but exists in the org, return NOHIER
219 -- If it exists in latest hierarchy only, return LATEST
220 -- If it exists in approved hierarchy only, return APPROV
221 -- If it exists in both approved 1 hierarchy only, return BOTH
222 function ex_proc_in_which_hier (
223 p_org_id in number,
224 p_process_id in number) return varchar2;
225
226 -- you can delete a process, i.e. set the deletion_date only when all occurrances of the
227 -- process is removed from the latest hierarchy
228 procedure delete_process (
229 p_org_id in number,
230 p_process_id in number);
231
232 -- if process is approved, revise it and create a draft.
233 -- if process is draft, move on
234 procedure revise_process_if_necessary (
235 p_org_id in number,
236 p_process_id in number);
237
238
239 -- if parent is draft, just add child,
240 -- else revise parent. This involves creation
241 -- of a new org-process
242 procedure import_rlproc_as_child_of_ex (
243 p_org_id in number,
244 p_parent_process_id in number,
245 p_child_process_id in number,
246 apply_rcm in varchar2);
247
248
249
250 -- make the attributes and RCM of a target process in org the same as those of
251 -- template process in rl. If the target is in draft, just update, else revise and update
252 procedure synch_process_att_rcm(
253 p_org_id in number,
254 p_process_id in number,
255 apply_rcm in varchar2);
256
257
258 -- import key accounts
259 procedure import_process_attributes(p_child_process_id in number,
260 p_org_id in number);
261
262
263 procedure import_rcm_for_new_orgprocess(p_child_process_id in number,
264 p_org_id in number);
265
266
267 procedure delete_existing_rcm(p_process_id in number,
268 p_org_id in number);
269
270
271 -- delete existing denorm rows for this org and re-create them
272 -- procedure update_denorm (p_org_id in number);
273 -- call amw_rl_hierarchy_pkg.update_denorm(p_org_id) to refresh denorm for an org
274
275
276 procedure synchronize_hierarchy (
277 p_org_id in number,
278 p_parent_process_id in number,
279 p_sync_attributes in varchar2,
280 p_sync_rcm in varchar2,
281 p_sync_people in varchar2
282 );
283
284
285 procedure associate_process_to_org (
286 p_org_id in number,
287 p_parent_process_id in number,
288 p_associated_proc_id in number,
289 p_revise_existing in varchar2,
290 p_apply_rcm in varchar2);
291
292 procedure find_rl_app_hier_children(p_process_id in number);
293
294 procedure undelete (
295 p_process_id in number,
296 p_org_id in number);
297
298 function process_pending_approval(p_process_id in number, p_org_id in number) return boolean;
299
300 procedure associate_hierarchy (
301 p_parent_process_id in number,
302 p_org_id in number,
303 p_revise_existing in varchar2,
304 p_apply_rcm in varchar2);
305
306 function does_process_exist_in_org(p_process_id in number, p_org_id in number) return varchar2;
307
308
309 procedure disassociate_process_org (
310 p_org_id in number,
311 p_process_id in number);
312
313
314 procedure disassociate_process_org_hier (
315 p_org_id in number,
316 p_process_id in number);
317
318
319 function process_locked(p_process_id in number, p_org_id in number) return boolean;
320
321 procedure upd_ltst_risk_count(p_org_id in number, p_process_id in number);
322
323 procedure upd_ltst_control_count(p_org_id in number, p_process_id in number);
324
325 procedure upd_appr_risk_count(p_org_id in number, p_process_id in number);
326
327 procedure upd_appr_control_count(p_org_id in number, p_process_id in number);
328
329 procedure produce_err_if_circular(
330 p_org_id in number,
331 p_parent_process_id in number,
332 p_child_process_id in number);
333
334 procedure produce_err_if_pa_or_locked(
335 p_org_id in number,
336 p_process_id in number);
337
338 /*kosriniv..... Procedure to add a process in the organization under a parent process.. */
339 PROCEDURE add_organization_child
340 ( p_organization_id IN NUMBER,
341 p_child_id IN NUMBER,
342 P_parent_id IN NUMBER,
343 P_add_from IN VARCHAR2,
344 p_revise_existing IN VARCHAR2,
345 P_apply_rcm IN VARCHAR2,
346 p_commit IN VARCHAR2 := FND_API.G_FALSE,
347 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349 x_return_status OUT NOCOPY VARCHAR2,
350 x_msg_count OUT NOCOPY VARCHAR2,
351 x_msg_data OUT NOCOPY VARCHAR2);
352
353
354 /*kosriniv..... Procedure to delete a process in the organizationfrom a parent process.. */
355 PROCEDURE delete_organization_child
356 ( p_organization_id IN NUMBER,
357 p_child_id IN NUMBER,
358 P_parent_id IN NUMBER,
359 p_commit IN VARCHAR2 := FND_API.G_FALSE,
360 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
361 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362 x_return_status OUT NOCOPY VARCHAR2,
363 x_msg_count OUT NOCOPY VARCHAR2,
364 x_msg_data OUT NOCOPY VARCHAR2);
365
366 /*kosriniv..... Procedure to disassociate a process in the organization */
367 PROCEDURE disassociate_org_process
371 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
368 ( p_organization_id IN NUMBER,
369 P_process_id IN NUMBER,
370 p_commit IN VARCHAR2 := FND_API.G_FALSE,
372 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373 x_return_status OUT NOCOPY VARCHAR2,
374 x_msg_count OUT NOCOPY VARCHAR2,
375 x_msg_data OUT NOCOPY VARCHAR2);
376
377 /*kosriniv..... Procedure to Synchronize a process in the organization */
378 PROCEDURE synchronize_org_process
379 ( p_org_id in number,
380 p_process_id in number,
381 p_sync_mode in varchar2,
382 p_sync_hierarchy in varchar2,
383 p_sync_attributes in varchar2,
384 p_sync_rcm in varchar2,
385 p_sync_people in varchar2,
386 p_commit IN VARCHAR2 := FND_API.G_FALSE,
387 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
388 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389 x_return_status OUT NOCOPY VARCHAR2,
390 x_msg_count OUT NOCOPY VARCHAR2,
391 x_msg_data OUT NOCOPY VARCHAR2);
392
393 /* kosriniv ..Procedure to Set the Approved Risk and Control counts */
394 PROCEDURE update_approved_rc_counts
395 ( p_organization_id IN NUMBER,
396 P_process_id IN NUMBER,
397 p_commit IN VARCHAR2 := FND_API.G_FALSE,
398 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400 x_return_status OUT NOCOPY VARCHAR2,
401 x_msg_count OUT NOCOPY VARCHAR2,
402 x_msg_data OUT NOCOPY VARCHAR2);
403
404 /* kosriniv ..Procedure to Set the latestRisk and Control counts */
405 PROCEDURE update_latest_rc_counts
406 ( p_organization_id IN NUMBER,
407 P_process_id IN NUMBER,
408 p_commit IN VARCHAR2 := FND_API.G_FALSE,
409 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
410 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411 x_return_status OUT NOCOPY VARCHAR2,
412 x_msg_count OUT NOCOPY VARCHAR2,
413 x_msg_data OUT NOCOPY VARCHAR2);
414
415 /* kosriniv insert the exceptions justification ..*/
416 PROCEDURE insert_exception_justification
417 (p_exception_Id IN Number,
418 p_justification IN Varchar2,
419 p_commit in varchar2 := FND_API.G_FALSE,
420 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
421 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
422 x_return_status out nocopy varchar2,
423 x_msg_count out nocopy number,
424 x_msg_data out nocopy varchar2);
425
426
427 function areChildListSame(p_organization_id IN NUMBER,p_process_id in number) return varchar;
428
429 function does_apprvd_ver_exst(p_organization_id IN NUMBER,p_process_id in number) return varchar;
430
431 procedure isProcessUndoAble (p_organization_id IN NUMBER,
432 p_process_id in number,
433 ret_value out nocopy varchar2,
434 x_return_status out nocopy varchar2,
435 x_msg_count out nocopy number,
436 x_msg_data out nocopy varchar2);
437
438 procedure delete_draft (p_organization_id IN NUMBER,
439 p_process_id in number,
440 x_return_status out nocopy varchar2,
441 x_msg_count out nocopy number,
442 x_msg_data out nocopy varchar2);
443
444 -- procedure to bring up the audit procedures associated to the controls in risk library to the organizations..
445 -- Called when controls are associated to the risks in Process Organization.
446 procedure UPDATE_ORG_PROC_AP(p_organization_id IN NUMBER,
447 p_process_id in number,
448 p_date in DATE,
449 x_return_status out nocopy varchar2,
450 x_msg_count out nocopy number,
451 x_msg_data out nocopy varchar2);
452
453 -- procedure to bring up the audit procedures associated to the controls in risk library to the organization entity controls..
454 -- Called when controls are associated to the Entity risks in Organization.
455 procedure UPDATE_ENTITY_AP(p_organization_id IN NUMBER,
456 p_date in DATE,
457 x_return_status out nocopy varchar2,
458 x_msg_count out nocopy number,
459 x_msg_data out nocopy varchar2);
460
461 /*
462 Synchornization Parameters
463 ==========================
464
465 1. p_org_id - Organization Id
466
467 2. p_process_id - Process Id
468
469 3. p_sync_mode
470 'PSUBP' - Current Process and its Sub Processes
471 'PONLY' - Current Process Only.
472
473 4. p_sync_hierarchy
474 'NO' - Retain Definition In the Organization.. Do not change the hierarchy
475 'YES' - Synchronize with the library definition..Hierarchy Made equivalent to the Risk Library
476
477 5 p_sync_attributes
478 'YES' - Synchronize the process attributes..(attributes, keyaccounts, attachments)
479 'NO' - Do not change...
480
481 6. p_sync_rcm
482 'RDEF' - Retain Definition in the organization.. Do not make any changes to Risks, controls and Audit Procedures.
486 7. p_sync_people
483 'SLIB' - Synchronize with the library definition .. Risks, Controls and Audit Procedures list equal to the RL
484 'ARCM' - Add Risks and Controls and Audit Procedures that exists in RL but not in Org.
485
487 'RDEF' - Retain Definition In the Organization.. Do no make any changes to People list
488 'SLIB' - Synchronize with the library definition...Make Equal to the RL list
489 'APPL' - Add Process People.
490 */
491 procedure Synchronize_process(
492 p_org_id in number,
493 p_process_id in number,
494 p_sync_mode in varchar2,
495 p_sync_hierarchy in varchar2,
496 p_sync_attributes in varchar2,
497 p_sync_rcm in varchar2,
498 p_sync_people in varchar2
499 );
500
501 procedure sync_proc_organizations(
502 p_process_id in number,
503 p_org_id_string in varchar2,
504 p_sync_mode in varchar2,
505 p_sync_hierarchy in varchar2,
506 p_sync_attributes in varchar2,
507 p_sync_rcm in varchar2,
508 p_sync_people in varchar2,
509 p_commit in varchar2 := FND_API.G_FALSE,
510 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
512 x_return_status out nocopy varchar2,
513 x_msg_count out nocopy number,
514 x_msg_data out nocopy varchar2 );
515
516 /*----------------
517 -- Concurrent Program to reset the risk and control counts for an organization
518 */
519 procedure reset_count(
520 errbuf out nocopy varchar2,
521 retcode out nocopy varchar2,
522 p_org_id in number
523 );
524
525 /********************************************************
526 KOSRINIV..
527 PROCEDURE to delete the child process from the hierarchy
528 to use this procedure from Process Update Page..
529 ****************************************************************/
530 procedure delete_activities(p_parent_process_id in number,
531 p_organization_id in number,
532 p_child_id_string in varchar2,
533 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
534 x_return_status out nocopy varchar2,
535 x_msg_count out nocopy number,
536 x_msg_data out nocopy varchar2);
537 /********************************************************
538 KOSRINIV..
539 PROCEDURE to add existing child processes to a process the hierarchy
540 to use this procedure from Process Update Page..
541 ****************************************************************/
542 procedure add_org_activities(p_parent_process_id in number,
543 p_organization_id in number,
544 p_child_id_string in varchar2,
545 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
546 x_return_status out nocopy varchar2,
547 x_msg_count out nocopy number,
548 x_msg_data out nocopy varchar2);
549
550 /********************************************************
551 KOSRINIV..
552 PROCEDURE to add Risk Library child processes to a process the hierarchy
553 to use this procedure from Process Update Page..
554 ****************************************************************/
555 procedure add_rl_activities(p_parent_process_id in number,
556 p_organization_id in number,
557 p_comb_string in varchar2,
558 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
559 x_return_status out nocopy varchar2,
560 x_msg_count out nocopy number,
561 x_msg_data out nocopy varchar2);
562
563 /********************************************************
564 KOSRINIV..
565 PROCEDURE to update the denorm hierarchy
566 to use this procedure from Process Update Page..
567 ****************************************************************/
568 PROCEDURE update_latest_denorm_counts
569 ( p_organization_id IN NUMBER,
570 P_process_id IN NUMBER,
571 p_commit IN VARCHAR2 := FND_API.G_FALSE,
572 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
574 x_return_status OUT NOCOPY VARCHAR2,
575 x_msg_count OUT NOCOPY VARCHAR2,
576 x_msg_data OUT NOCOPY VARCHAR2);
577
578
579 end AMW_ORG_HIERARCHY_PKG;
[Home] [Help]