[Home] [Help]
PACKAGE: APPS.FND_AUDIT_PKG
Source
1 PACKAGE FND_AUDIT_PKG AUTHID CURRENT_USER AS
2 /*$Header: FNDAUDTS.pls 120.2 2005/10/25 14:18:59 jwsmith noship $*/
3 TYPE AUDIT_REQUIRED_TABLE IS RECORD
4 (TABLE_NAME VARCHAR2(40),
5 USER_TABLE_NAME VARCHAR2(240),
6 TABLE_ID NUMBER,
7 TABLE_APPLICATION_ID NUMBER);
8
9 TYPE AUDIT_REQUIRED_TABLES_TYPE IS TABLE OF AUDIT_REQUIRED_TABLE INDEX BY BINARY_INTEGER;
10
11 TYPE REPORT_TABLE IS RECORD
12 (AUDIT_KEY VARCHAR2(240),
13 AUDIT_TIMESTAMP DATE,
14 AUDIT_TRANSACTION_TYPE VARCHAR2(20),
15 AUDIT_USER_NAME VARCHAR2(80),
16 COLUMN1_VALUE VARCHAR2(360),
17 COLUMN2_VALUE VARCHAR2(360),
18 COLUMN3_VALUE VARCHAR2(360),
19 COLUMN4_VALUE VARCHAR2(360),
20 COLUMN5_VALUE VARCHAR2(360));
21
22 AUDIT_ON BOOLEAN;
23
24 PROCEDURE RETRIEVE_RESULT_TABLES(AUDIT_WHERE_CLAUSE VARCHAR2,
25 TABLE_WHERE_CLAUSE VARCHAR2,
26 QUERY_TABLES IN OUT NOCOPY AUDIT_REQUIRED_TABLES_TYPE);
27 PROCEDURE POPULATE_TAB_REP_DATA(P_SELECT_CLAUSE VARCHAR2,
28 P_TABLE_NAME VARCHAR2,
29 P_USER_TABLE_NAME VARCHAR2,
30 P_WHERE_CLAUSE VARCHAR2,
31 P_APPLICATION_ID NUMBER,
32 P_TABLE_ID NUMBER,
33 P_REP_ID NUMBER);
34
35 END FND_AUDIT_PKG;
36
37
38