PACKAGE: APPS.FND_AUDIT_PKG

Source

1 PACKAGE FND_AUDIT_PKG 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