PACKAGE: APPS.GMA_AUDIT_PKG

Source

1 PACKAGE GMA_AUDIT_PKG AUTHID CURRENT_USER AS
2 /*$Header: GMAAUDTS.pls 115.0 2001/10/23 09:31:24 pkm ship       $*/
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(240),
17   COLUMN2_VALUE           VARCHAR2(240),
18   COLUMN3_VALUE           VARCHAR2(240),
19   COLUMN4_VALUE           VARCHAR2(240),
20   COLUMN5_VALUE           VARCHAR2(240));
21 
22 
23  PROCEDURE RETRIEVE_RESULT_TABLES(AUDIT_WHERE_CLAUSE   VARCHAR2,
24                                   TABLE_WHERE_CLAUSE   VARCHAR2,
25                                   QUERY_TABLES IN OUT AUDIT_REQUIRED_TABLES_TYPE);
26  PROCEDURE POPULATE_TAB_REP_DATA(P_SELECT_CLAUSE   VARCHAR2,
27                                  P_TABLE_NAME      VARCHAR2,
28                                  P_USER_TABLE_NAME VARCHAR2,
29                                  P_WHERE_CLAUSE    VARCHAR2,
30                                  P_APPLICATION_ID  NUMBER,
31                                  P_TABLE_ID        NUMBER,
32                                  P_REP_ID          NUMBER);
33 
34 END GMA_AUDIT_PKG;
35 
36 
37