PACKAGE: APPS.XLE_HISTORY_PUB

Source

1 PACKAGE XLE_History_PUB AS
2 /* $Header: xlehisps.pls 120.2 2005/08/08 19:02:49 shijain ship $ */
3 --------------------------------------
4 -- declaration of record type
5 --------------------------------------
6 
7 TYPE T_VALUE_REC IS RECORD (
8     column_name VARCHAR2(30),
9     data_type VARCHAR2(106),
10     old_value VARCHAR2(2000),
11     new_value VARCHAR2(2000)
12 );
13 TYPE T_VALUE_TBL IS TABLE OF T_VALUE_REC INDEX BY BINARY_INTEGER;
14 
15 --------------------------------------
16 -- declaration of global variables
17 --------------------------------------
18 
19 G_VALUE_LIST T_VALUE_TBL;
20 G_TABLE_NAME VARCHAR2(30);
21 G_PRIMARY_KEY_NAME VARCHAR2(30);
22 G_PRIMARY_KEY_ID NUMBER;
23 
24 --------------------------------------
25 -- declaration of public procedures
26 --------------------------------------
27 
28 procedure log_record_pre(
29     p_id NUMBER,
30     p_primary_key_name VARCHAR2,
31     p_table_name VARCHAR2
32 );
33 
34 procedure log_record_post(
35     p_id NUMBER,
36     p_primary_key_name VARCHAR2,
37     p_table_name VARCHAR2,
38     p_effective_from DATE,
39     p_comment VARCHAR2,
40     p_error_type     OUT NOCOPY  VARCHAR2,
41     p_return_status  OUT NOCOPY  VARCHAR2
42 );
43 
44 procedure log_record_ins(
45     p_id NUMBER,
46     p_primary_key_name VARCHAR2,
47     p_table_name VARCHAR2,
48     p_effective_from DATE,
49     p_comment VARCHAR2,
50     p_error_type     OUT NOCOPY  VARCHAR2,
51     p_return_status  OUT NOCOPY  VARCHAR2
52 );
53 
54 
55 END XLE_History_PUB;
56