1 PACKAGE LNS_LOAN_HISTORIES_H_PKG AS
2 /* $Header: LNS_LNHIS_TBLH_S.pls 120.0 2005/05/31 17:28:09 appldev noship $ */
3
4 /* Insert_Row procedure */
5 PROCEDURE Insert_Row(
6 X_LOAN_HISTORY_ID IN OUT NOCOPY NUMBER
7 ,P_LOAN_ID IN NUMBER
8 ,P_TABLE_NAME IN VARCHAR2 DEFAULT NULL
9 ,P_COLUMN_NAME IN VARCHAR2 DEFAULT NULL
10 ,P_OLD_VALUE IN VARCHAR2 DEFAULT NULL
11 ,P_NEW_VALUE IN VARCHAR2 DEFAULT NULL
12 ,P_CREATED_BY IN NUMBER DEFAULT NULL
13 ,P_CREATION_DATE IN DATE DEFAULT NULL
14 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
15 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
16 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
17 ,P_DATA_TYPE IN VARCHAR2 DEFAULT NULL
18 ,P_OBJECT_VERSION_NUMBER IN NUMBER
19 ,P_PRIMARY_KEY_ID IN NUMBER
20 );
21
22 /* Update_Row procedure */
23 PROCEDURE Update_Row(
24 P_LOAN_HISTORY_ID IN NUMBER
25 ,P_LOAN_ID IN NUMBER DEFAULT NULL
26 ,P_TABLE_NAME IN VARCHAR2 DEFAULT NULL
27 ,P_COLUMN_NAME IN VARCHAR2 DEFAULT NULL
28 ,P_OLD_VALUE IN VARCHAR2 DEFAULT NULL
29 ,P_NEW_VALUE IN VARCHAR2 DEFAULT NULL
30 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
31 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
32 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
33 ,P_DATA_TYPE IN VARCHAR2 DEFAULT NULL
34 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
35 ,P_PRIMARY_KEY_ID IN NUMBER
36 );
37
38 /* Delete_Row procedure */
39 PROCEDURE Delete_Row(P_LOAN_HISTORY_ID IN NUMBER);
40
41 /* Lock_Row procedure */
42 PROCEDURE Lock_Row(
43 P_LOAN_HISTORY_ID IN NUMBER
44 ,P_LOAN_ID IN NUMBER DEFAULT NULL
45 ,P_TABLE_NAME IN VARCHAR2 DEFAULT NULL
46 ,P_COLUMN_NAME IN VARCHAR2 DEFAULT NULL
47 ,P_OLD_VALUE IN VARCHAR2 DEFAULT NULL
48 ,P_NEW_VALUE IN VARCHAR2 DEFAULT NULL
49 ,P_CREATED_BY IN NUMBER DEFAULT NULL
50 ,P_CREATION_DATE IN DATE DEFAULT NULL
51 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
52 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
53 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
54 ,P_DATA_TYPE IN VARCHAR2 DEFAULT NULL
55 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
56 ,P_PRIMARY_KEY_ID IN NUMBER
57 );
58 END;
59