[Home] [Help]
PACKAGE: APPS.AMW_AUDIT_PROCEDURES_PVT
Source
1 PACKAGE AMW_AUDIT_PROCEDURES_PVT AS
2 /* $Header: amwvrcds.pls 120.0 2005/05/31 20:31:01 appldev noship $ */
3 -- ===============================================================
4 -- Package name
5 -- AMW_AUDIT_PROCEDURES_PVT
6 -- Purpose
7 -- for Import Audit Procedure : Load_AP (without knowing any audit_procedure_id in advance)
8 -- for direct call : Operate_AP (knowing audit_procedure_id or audit_procedure_rev_id)
9 -- History
10 -- 12/08/2003 tsho Creates
11 -- ===============================================================
12
13 -- Default number of records fetch per call
14 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
15
16
17 G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
18 G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
19 G_OBJ_TYPE CONSTANT VARCHAR2(80) := AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','AP');
20
21 -- FND_API global constant
22 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
23 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
24 G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
25 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
26 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
27 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
28
29
30 -- Operate_AP with global p_operate_mode
31 G_OP_CREATE CONSTANT NUMBER := 10;
32 G_OP_UPDATE CONSTANT NUMBER := 20;
33 G_OP_REVISE CONSTANT NUMBER := 30;
34 G_OP_DELETE CONSTANT NUMBER := 40;
35
36
37 -- ===================================================================
38 -- Record name
39 -- audit_procedure_rec_type
40 -- Parameters:
41 -- audit_procedure_id
42 -- audit_procedure_rev_id
43 -- audit_procedure_rev_num
44 -- end_date
45 -- approval_date
46 -- curr_approved_flag
47 -- latest_revision_flag
48 -- last_update_date
49 -- last_updated_by
50 -- creation_date
51 -- created_by
52 -- last_update_login
53 -- attribute_category
54 -- attribute1
55 -- attribute2
56 -- attribute3
57 -- attribute4
58 -- attribute5
59 -- attribute6
60 -- attribute7
61 -- attribute8
62 -- attribute9
63 -- attribute10
64 -- attribute11
65 -- attribute12
66 -- attribute13
67 -- attribute14
68 -- attribute15
69 -- security_group_id
70 -- object_version_number
71 -- approval_status
72 -- orig_system_reference
73 -- requestor_id
74 -- audit_procedure_name
75 -- audit_procedure_description
76 -- ===================================================================
77 TYPE audit_procedure_rec_type IS RECORD
78 (
79 audit_procedure_id NUMBER := NULL,
80 audit_procedure_rev_id NUMBER := NULL,
81 audit_procedure_rev_num NUMBER := NULL,
82 end_date DATE := NULL,
83 approval_date DATE := NULL,
84 curr_approved_flag VARCHAR2(1) := NULL,
85 latest_revision_flag VARCHAR2(1) := NULL,
86 last_update_date DATE := NULL,
87 last_updated_by NUMBER := NULL,
88 creation_date DATE := NULL,
89 created_by NUMBER := NULL,
90 last_update_login NUMBER := NULL,
91 attribute_category VARCHAR2(30) := NULL,
92 attribute1 VARCHAR2(150) := NULL,
93 attribute2 VARCHAR2(150) := NULL,
94 attribute3 VARCHAR2(150) := NULL,
95 attribute4 VARCHAR2(150) := NULL,
96 attribute5 VARCHAR2(150) := NULL,
97 attribute6 VARCHAR2(150) := NULL,
98 attribute7 VARCHAR2(150) := NULL,
99 attribute8 VARCHAR2(150) := NULL,
100 attribute9 VARCHAR2(150) := NULL,
101 attribute10 VARCHAR2(150) := NULL,
102 attribute11 VARCHAR2(150) := NULL,
103 attribute12 VARCHAR2(150) := NULL,
104 attribute13 VARCHAR2(150) := NULL,
105 attribute14 VARCHAR2(150) := NULL,
106 attribute15 VARCHAR2(150) := NULL,
107 security_group_id NUMBER := NULL,
108 object_version_number NUMBER := NULL,
109 approval_status VARCHAR2(30) := NULL,
110 orig_system_reference VARCHAR2(240) := NULL,
111 requestor_id NUMBER := G_USER_ID,
112 audit_procedure_name VARCHAR2(240) := NULL,
113 audit_procedure_description VARCHAR2(4000) := NULL,
114 project_id NUMBER := NULL,
115 classification NUMBER := NULL
116 );
117
118 g_miss_audit_procedure_rec audit_procedure_rec_type;
119 TYPE audit_procedure_tbl_type IS TABLE OF audit_procedure_rec_type INDEX BY BINARY_INTEGER;
120 g_miss_audit_procedure_tbl audit_procedure_tbl_type;
121
122
123
124 -- ===============================================================
125 -- Procedure name
126 -- Load_AP
127 -- Purpose
128 -- for Import Audit Procedure with approval_status 'A' or 'D'
129 -- ===============================================================
130 PROCEDURE Load_AP(
131 p_api_version_number IN NUMBER,
132 p_init_msg_list IN VARCHAR2 := G_FALSE,
133 p_commit IN VARCHAR2 := G_FALSE,
134 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_audit_procedure_rec IN audit_procedure_rec_type,
139 x_audit_procedure_rev_id OUT NOCOPY NUMBER,
140 x_audit_procedure_id OUT NOCOPY NUMBER,
141 p_approval_date IN DATE
142 );
143
144
145
146 -- ===============================================================
147 -- Procedure name
148 -- Operate_AP
149 -- Purpose
150 -- operate audit procedure depends on the pass-in p_operate_mode:
151 -- G_OP_CREATE
152 -- G_OP_UPDATE
153 -- G_OP_REVISE
154 -- G_OP_DELETE
155 -- Notes
156 -- the G_OP_UPDATE mode here is in business logic meaning,
157 -- not as the same as update in table handler meaning.
158 -- same goes to other p_operate_mode if it happens to
159 -- have similar name.
160 -- ===============================================================
161 PROCEDURE Operate_AP(
162 p_operate_mode IN VARCHAR2,
163 p_api_version_number IN NUMBER,
164 p_init_msg_list IN VARCHAR2 := G_FALSE,
165 p_commit IN VARCHAR2 := G_FALSE,
166 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_audit_procedure_rec IN audit_procedure_rec_type,
171 x_audit_procedure_rev_id OUT NOCOPY NUMBER,
172 x_audit_procedure_id OUT NOCOPY NUMBER,
173 p_approval_date IN DATE
174 );
175
176
177
178 -- ===============================================================
179 -- Procedure name
180 -- Create_AP
181 -- Purpose
182 -- create audit procedure with specified approval_status,
183 -- if no specified approval_status in pass-in p_audit_procedure_rec,
184 -- the default approval_status is set to 'D'.
185 -- ===============================================================
186 PROCEDURE Create_AP(
187 p_operate_mode IN VARCHAR2,
188 p_api_version_number IN NUMBER,
189 p_init_msg_list IN VARCHAR2 := G_FALSE,
190 p_commit IN VARCHAR2 := G_FALSE,
191 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
192
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196
197 p_audit_procedure_rec IN audit_procedure_rec_type,
198 x_audit_procedure_rev_id OUT NOCOPY NUMBER,
199 x_audit_procedure_id OUT NOCOPY NUMBER
200 );
201
202
203
204 -- ===============================================================
205 -- Procedure name
206 -- Update_AP
207 -- Purpose
208 -- update audit procedure with specified audit_procedure_rev_id,
209 -- if no specified audit_procedure_rev_id in pass-in p_audit_procedure_rec,
210 -- this will update the one with specified audit_procedure_id having
211 -- latest_revision_flag='Y' AND approval_status='D'.
212 -- Notes
213 -- if audit_procedure_rev_id is not specified, then
214 -- audit_procedure_id is a must when calling Update_AP
215 -- ===============================================================
216 PROCEDURE Update_AP(
217 p_operate_mode IN VARCHAR2,
218 p_api_version_number IN NUMBER,
219 p_init_msg_list IN VARCHAR2 := G_FALSE,
220 p_commit IN VARCHAR2 := G_FALSE,
221 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
222
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226
227 p_audit_procedure_rec IN audit_procedure_rec_type,
228 x_audit_procedure_rev_id OUT NOCOPY NUMBER,
229 x_audit_procedure_id OUT NOCOPY NUMBER
230 );
231
232
233
234 -- ===============================================================
235 -- Procedure name
236 -- Delete_AP
237 -- Purpose
238 -- delete audit procedure with specified audit_procedure_rev_id.
239 -- ===============================================================
240 PROCEDURE Delete_AP(
241 p_operate_mode IN VARCHAR2,
242 p_api_version_number IN NUMBER,
243 p_init_msg_list IN VARCHAR2 := G_FALSE,
244 p_commit IN VARCHAR2 := G_FALSE,
245 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER,
248 x_msg_data OUT NOCOPY VARCHAR2,
249 p_audit_procedure_rev_id IN NUMBER,
250 x_audit_procedure_id OUT NOCOPY NUMBER
251 );
252
253
254
255
256 -- ===============================================================
257 -- Procedure name
258 -- Revise_Without_Revision_Exists
259 -- Purpose
260 -- revise audit procedure with specified audit_procedure_id,
261 -- it'll revise the one having latest_revision_flag='Y'
262 -- AND approval_status='A' OR 'R' of specified audit_procedure_id.
263 -- the new revision created by this call will have
264 -- latest_revision_flag='Y', and the approval_status
265 -- will be set to 'D' if not specified in the p_audit_procedure_rec
266 -- the revisee(the old one) will have latest_revision_flag='N'
267 -- Note
268 -- actually the name for Revise_Without_Revision_Exists
269 -- should be Revise_Without_Draft_Revision_Exists if there's
270 -- no limitation for the procedure name.
271 -- ===============================================================
272 PROCEDURE Revise_Without_Revision_Exists(
273 p_operate_mode IN VARCHAR2,
274 p_api_version_number IN NUMBER,
275 p_init_msg_list IN VARCHAR2 := G_FALSE,
276 p_commit IN VARCHAR2 := G_FALSE,
277 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
278
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2,
282
283 p_audit_procedure_rec IN audit_procedure_rec_type,
284 x_audit_procedure_rev_id OUT NOCOPY NUMBER,
285 x_audit_procedure_id OUT NOCOPY NUMBER
286 );
287
288
289
290 -- ===============================================================
291 -- Procedure name
292 -- Validate_AP
293 -- Purpose
294 -- Validate_AP is the container for calling all the other
295 -- validation procedures on one record(Validate_xxx_Rec) and
296 -- the container of validation on items(Check_AP_Items)
297 -- Note
298 -- basically, this should be called before calling table handler
299 -- ===============================================================
300 PROCEDURE Validate_AP(
301 p_operate_mode IN VARCHAR2,
302 p_api_version_number IN NUMBER,
303 p_init_msg_list IN VARCHAR2 := G_FALSE,
304 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
305 p_audit_procedure_rec IN audit_procedure_rec_type,
309 x_msg_data OUT NOCOPY VARCHAR2
306 x_audit_procedure_rec OUT NOCOPY audit_procedure_rec_type,
307 x_return_status OUT NOCOPY VARCHAR2,
308 x_msg_count OUT NOCOPY NUMBER,
310 );
311
312
313
314 -- ===============================================================
315 -- Procedure name
316 -- Check_AP_Items
317 -- Purpose
318 -- check all the necessaries for items
319 -- Note
320 -- Check_AP_Items is the container for calling all the
321 -- other validation procedures on items(check_xxx_Items)
322 -- the validation on items should be only table column constraints
323 -- not the business logic validation.
324 -- ===============================================================
325 PROCEDURE Check_AP_Items (
326 p_operate_mode IN VARCHAR2,
327 P_audit_procedure_rec IN audit_procedure_rec_type,
328 x_return_status OUT NOCOPY VARCHAR2
329 );
330
331
332
333 -- ===============================================================
334 -- Procedure name
335 -- check_AP_uk_items
336 -- Purpose
337 -- check the uniqueness of the items which have been marked
338 -- as unique in table
339 -- ===============================================================
340 PROCEDURE check_AP_uk_items(
341 p_operate_mode IN VARCHAR2,
342 p_audit_procedure_rec IN audit_procedure_rec_type,
343 x_return_status OUT NOCOPY VARCHAR2
344 );
345
346
347
348 -- ===============================================================
349 -- Procedure name
350 -- check_AP_req_items
351 -- Purpose
352 -- check the requireness of the items which have been marked
353 -- as NOT NULL in table
354 -- Note
355 -- since the standard default with
356 -- FND_API.G_MISS_XXX v.s. NULL has been changed to:
357 -- if user want to update to Null, pass in G_MISS_XXX
358 -- else if user want to update to some value, pass in value
359 -- else if user doesn't want to update, pass in NULL.
360 -- Reference
361 -- http://www-apps.us.oracle.com/atg/performance/
362 -- Standards and Templates>Business Object API Coding Standards
363 -- 2.3.1 Differentiating between Missing parameters and Null parameters
364 -- ===============================================================
365 PROCEDURE check_AP_req_items(
366 p_operate_mode IN VARCHAR2,
367 p_audit_procedure_rec IN audit_procedure_rec_type,
368 x_return_status OUT NOCOPY VARCHAR2
369 );
370
371
372
373 -- ===============================================================
374 -- Procedure name
375 -- check_AP_FK_items
376 -- Purpose
377 -- check forien key of the items
378 -- ===============================================================
379 PROCEDURE check_AP_FK_items(
380 p_operate_mode IN VARCHAR2,
381 p_audit_procedure_rec IN audit_procedure_rec_type,
385
382 x_return_status OUT NOCOPY VARCHAR2
383 );
384
386
387 -- ===============================================================
388 -- Procedure name
389 -- check_AP_Lookup_items
390 -- Purpose
391 -- check lookup of the items
392 -- ===============================================================
393 PROCEDURE check_AP_Lookup_items(
394 p_operate_mode IN VARCHAR2,
395 p_audit_procedure_rec IN audit_procedure_rec_type,
396 x_return_status OUT NOCOPY VARCHAR2
397 );
398
399
400
401
402 -- ===============================================================
403 -- Procedure name
404 -- Complete_AP_Rec
405 -- Purpose
406 -- complete(fill out) the items which are not specified.
407 -- Note
408 -- basically, this is called when G_OP_UPDATE, G_OP_REVISE
409 -- ===============================================================
410 PROCEDURE Complete_AP_Rec (
411 p_audit_procedure_rec IN audit_procedure_rec_type,
412 x_complete_rec OUT NOCOPY audit_procedure_rec_type
413 );
414
415
416
417
418 -- ===============================================================
419 -- Procedure name
420 -- Validate_AP_rec
421 -- Purpose
422 -- check all the necessaries for one record,
423 -- this includes the cross-items validation
424 -- Note
425 -- Validate_AP_rec is the dispatcher of
426 -- other validation procedures on one record.
427 -- business logic validation should go here.
428 -- ===============================================================
429 PROCEDURE Validate_AP_rec(
430 p_operate_mode IN VARCHAR2,
431 p_api_version_number IN NUMBER,
432 p_init_msg_list IN VARCHAR2 := G_FALSE,
433 x_return_status OUT NOCOPY VARCHAR2,
434 x_msg_count OUT NOCOPY NUMBER,
435 x_msg_data OUT NOCOPY VARCHAR2,
436 p_audit_procedure_rec IN audit_procedure_rec_type
437 );
438
439
440
441
442 -- ===============================================================
443 -- Procedure name
444 -- Validate_create_AP_rec
445 -- Purpose
446 -- this is the validation for mode G_OP_CREATE.
447 -- Note
448 -- risk name cannot be duplicated in table
449 -- ===============================================================
450 PROCEDURE Validate_create_AP_rec(
451 x_return_status OUT NOCOPY VARCHAR2,
452 x_msg_count OUT NOCOPY NUMBER,
453 x_msg_data OUT NOCOPY VARCHAR2,
454 p_audit_procedure_rec IN audit_procedure_rec_type
455 );
456
457
458
459
460 -- ===============================================================
461 -- Procedure name
462 -- Validate_update_AP_rec
463 -- Purpose
464 -- this is the validation for mode G_OP_UPDATE.
468 -- ===============================================================
465 -- Note
466 -- risk name cannot be duplicated in table.
467 -- only the risk with approval_status='D' can be use G_OP_UPDATE
469 PROCEDURE Validate_update_AP_rec(
470 x_return_status OUT NOCOPY VARCHAR2,
471 x_msg_count OUT NOCOPY NUMBER,
472 x_msg_data OUT NOCOPY VARCHAR2,
473 p_audit_procedure_rec IN audit_procedure_rec_type
474 );
475
476
477
478
479 -- ===============================================================
480 -- Procedure name
481 -- Validate_revise_AP_rec
485 -- changing audit procedure name when revising an audit procedure is not allowed.
482 -- Purpose
483 -- this is the validation for mode G_OP_REVISE.
484 -- Note
486 -- ===============================================================
487 PROCEDURE Validate_revise_AP_rec(
488 x_return_status OUT NOCOPY VARCHAR2,
489 x_msg_count OUT NOCOPY NUMBER,
490 x_msg_data OUT NOCOPY VARCHAR2,
491 p_audit_procedure_rec IN audit_procedure_rec_type
492 );
493
494
495
496 -- ===============================================================
497 -- Procedure name
498 -- Validate_delete_AP_rec
499 -- Purpose
500 -- this is the validation for mode G_OP_DELETE.
501 -- Note
502 -- not implemented yet.
503 -- need to find out when(approval_status='?') can G_OP_DELETE.
504 -- ===============================================================
505 PROCEDURE Validate_delete_AP_rec(
506 x_return_status OUT NOCOPY VARCHAR2,
507 x_msg_count OUT NOCOPY NUMBER,
508 x_msg_data OUT NOCOPY VARCHAR2,
509 p_audit_procedure_rec IN audit_procedure_rec_type
510 );
511
512
513 -- ===============================================================
514 -- Procedure name
515 -- copy_audit_step
516 -- Purpose
517 -- this procedure copies audit steps from from_ap_rev_id to
518 -- to_ap_rev_id
519 -- Note
520 --
521 -- ===============================================================
522 PROCEDURE copy_audit_steps(
523 p_api_version IN NUMBER,
524 p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,
525 p_commit IN VARCHAR2, -- default FND_API.G_FALSE,
526 p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,
527 x_return_status OUT NOCOPY VARCHAR2,
528 x_msg_count OUT NOCOPY NUMBER,
529 x_msg_data OUT NOCOPY VARCHAR2,
530 x_from_ap_rev_id IN NUMBER,
531 x_to_ap_id IN NUMBER
532 );
533
534 -- ===============================================================
535 -- Procedure name
536 -- copy_tasks
537 -- Purpose
538 -- this procedure copies tasks from from_ap_id to
539 -- to_ap_id
540 -- Note
541 --
542 -- ===============================================================
543 PROCEDURE copy_tasks(
544 p_api_version IN NUMBER,
545 p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,
546 p_commit IN VARCHAR2, -- default FND_API.G_FALSE,
547 p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,
548 x_return_status OUT NOCOPY VARCHAR2,
549 x_msg_count OUT NOCOPY NUMBER,
550 x_msg_data OUT NOCOPY VARCHAR2,
551 x_from_ap_id IN NUMBER,
552 x_to_ap_id IN NUMBER
553 );
554
555 -- ===============================================================
556 -- Procedure name
557 -- copy_controls
558 -- Purpose
559 -- this procedure copies controls from from_ap_id to
560 -- to_ap_id
561 -- Note
562 --
563 -- ===============================================================
564 PROCEDURE copy_controls(
565 p_api_version IN NUMBER,
566 p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,
567 p_commit IN VARCHAR2, -- default FND_API.G_FALSE,
568 p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,
569 x_return_status OUT NOCOPY VARCHAR2,
570 x_msg_count OUT NOCOPY NUMBER,
571 x_msg_data OUT NOCOPY VARCHAR2,
572 x_from_ap_id IN NUMBER,
573 x_to_ap_id IN NUMBER
574 );
575
576 procedure insert_ap_step(
577 p_api_version_number IN NUMBER,
578 p_init_msg_list IN VARCHAR2 := G_FALSE,
579 p_commit IN VARCHAR2 := G_FALSE,
580 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
581 p_samplesize in number,
582 p_audit_procedure_id in number,
583 p_seqnum in varchar2,
584 p_requestor_id in number,
585 p_name in varchar2,
586 p_description in varchar2,
587 p_audit_procedure_rev_id in number,
588 p_user_id in number,
589 x_return_status OUT NOCOPY VARCHAR2,
590 x_msg_count OUT NOCOPY NUMBER,
591 x_msg_data OUT NOCOPY VARCHAR2);
592
593 procedure insert_ap_control_assoc(
594 p_api_version_number IN NUMBER,
595 p_init_msg_list IN VARCHAR2 := G_FALSE,
596 p_commit IN VARCHAR2 := G_FALSE,
597 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
598 p_control_id in number,
599 p_audit_procedure_id in number,
600 p_des_eff in varchar2,
601 p_op_eff in varchar2,
602 p_approval_date in date,
603 p_user_id in number,
604 x_return_status OUT NOCOPY VARCHAR2,
608 procedure copy_ext_attr(
605 x_msg_count OUT NOCOPY NUMBER,
606 x_msg_data OUT NOCOPY VARCHAR2);
607
609 p_api_version_number IN NUMBER,
610 p_init_msg_list IN VARCHAR2 := G_FALSE,
611 p_commit IN VARCHAR2 := G_FALSE,
612 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
613 p_from_audit_procedure_id in number,
614 p_to_audit_procedure_id in number,
615 x_return_status OUT NOCOPY VARCHAR2,
616 x_msg_count OUT NOCOPY NUMBER,
617 x_msg_data OUT NOCOPY VARCHAR2);
618 procedure revise_ap_if_necessary(
619 p_api_version_number IN NUMBER,
620 p_init_msg_list IN VARCHAR2 := G_FALSE,
621 p_commit IN VARCHAR2 := G_FALSE,
622 p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
623 p_audit_procedure_id IN NUMBER,
624 x_return_status OUT NOCOPY VARCHAR2,
625 x_msg_count OUT NOCOPY NUMBER,
626 x_msg_data OUT NOCOPY VARCHAR2);
627 -- ----------------------------------------------------------------------
628 END AMW_AUDIT_PROCEDURES_PVT;
629