1 PACKAGE XLE_Histories_PKG AS
2 /* $Header: xlehists.pls 120.1 2005/07/26 17:08:57 shijain ship $ */
3
4 PROCEDURE Insert_Row(
5 x_history_id IN OUT NOCOPY NUMBER,
6 p_source_table IN VARCHAR2 DEFAULT NULL,
7 p_source_id IN NUMBER DEFAULT NULL,
8 p_source_column_name IN VARCHAR2 DEFAULT NULL,
9 p_source_column_value IN VARCHAR2 DEFAULT NULL,
10 p_effective_from IN DATE DEFAULT NULL,
11 p_effective_to IN DATE DEFAULT NULL,
12 p_comment IN VARCHAR2 DEFAULT NULL,
13 p_last_update_date IN DATE DEFAULT NULL,
14 p_last_updated_by IN NUMBER DEFAULT NULL,
15 p_creation_date IN DATE DEFAULT NULL,
16 p_created_by IN NUMBER DEFAULT NULL,
17 p_last_update_login IN NUMBER DEFAULT NULL,
18 p_object_version_number IN NUMBER
19 );
20
21 PROCEDURE Update_Row(
22 p_history_id IN NUMBER,
23 p_source_table IN VARCHAR2 DEFAULT NULL,
24 p_source_id IN NUMBER DEFAULT NULL,
25 p_source_column_name IN VARCHAR2 DEFAULT NULL,
26 p_source_column_value IN VARCHAR2 DEFAULT NULL,
27 p_effective_from IN DATE DEFAULT NULL,
28 p_effective_to IN DATE DEFAULT NULL,
29 p_comment IN VARCHAR2 DEFAULT NULL,
30 p_last_update_date IN DATE DEFAULT NULL,
31 p_last_updated_by IN NUMBER DEFAULT NULL,
32 p_last_update_login IN NUMBER DEFAULT NULL,
33 p_object_version_number IN NUMBER
34 );
35
36 PROCEDURE Delete_Row(p_history_id IN NUMBER);
37
38 PROCEDURE Lock_Row(
39 p_history_id IN NUMBER,
40 p_source_table IN VARCHAR2 DEFAULT NULL,
41 p_source_id IN NUMBER DEFAULT NULL,
42 p_source_column_name IN VARCHAR2 DEFAULT NULL,
43 p_source_column_value IN VARCHAR2 DEFAULT NULL,
44 p_effective_from IN DATE DEFAULT NULL,
45 p_effective_to IN DATE DEFAULT NULL,
46 p_comment IN VARCHAR2 DEFAULT NULL,
47 p_last_update_date IN DATE DEFAULT NULL,
48 p_last_updated_by IN NUMBER DEFAULT NULL,
49 p_creation_date IN DATE DEFAULT NULL,
50 p_created_by IN NUMBER DEFAULT NULL,
51 p_last_update_login IN NUMBER DEFAULT NULL,
52 p_object_version_number IN NUMBER
53 );
54
55 END XLE_Histories_PKG;
56