1 package fnd_audit_report AUTHID CURRENT_USER as
2 /* $Header: AFATRPTS.pls 120.2 2005/10/25 14:26:28 jwsmith noship $ */
3
4 --
5 -- Procedure
6 -- PRINT_OUTPUT
7 --
8 -- Purpose
9 -- Print to a concurrent manager log file or to dbms_output
10 --
11 -- Arguments:
12 -- IN:
13 -- LOG - send to cm log file if 'Y' and dbms_output if 'N'
14 -- DATA - string to print
15 -- PROGNM - name of this program, written to logfile for tagging
16 -- LOG - send to cm log file if 'Y' and dbms_output if 'N'
17 -- OUT:
18 -- ERRBUF - standard CP output
19 -- RETCODE - 0 if successful
20 --
21 procedure print_output( LOG IN VARCHAR2 DEFAULT 'Y',
22 DATA IN VARCHAR2 DEFAULT null);
23
24
25 --
26 -- Procedure
27 -- AUDIT_GROUP_VALIDATION
28 --
29 -- Purpose
30 -- PL/SQL stored procedure concurrent program which creates
31 -- an exception report for audit schema validation.
32 --
33 -- Arguments:
34 -- IN:
35 -- GROUP_NAME - name of the audit group
36 -- PROGNM - name of this program, written to logfile for tagging
37 -- LOG - send to cm log file if 'Y' and dbms_output if 'N'
38 -- OUT:
39 -- ERRBUF - standard CP output
40 -- RETCODE - 0 if successful
41 --
42 procedure audit_group_validation(ERRBUF OUT NOCOPY VARCHAR2,
43 RETCODE OUT NOCOPY NUMBER,
44 GROUP_NAME IN VARCHAR2 DEFAULT null,
45 PROGNM IN VARCHAR2 DEFAULT null,
46 LOG IN VARCHAR2 DEFAULT 'Y');
47
48
49 end;