1 PACKAGE LNS_COND_ASSIGNMENTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: LNS_CASGM_TBLH_S.pls 120.2.12010000.3 2010/03/17 13:34:58 scherkas ship $ */
3
4 /* Insert_Row procedure */
5 PROCEDURE Insert_Row(
6 X_COND_ASSIGNMENT_ID IN OUT NOCOPY NUMBER
7 ,P_LOAN_ID IN NUMBER
8 ,P_CONDITION_ID IN NUMBER
9 ,P_CONDITION_DESCRIPTION IN VARCHAR2
10 ,P_CONDITION_MET_FLAG IN VARCHAR2
11 ,P_MANDATORY_FLAG IN VARCHAR2
12 ,P_CREATED_BY IN NUMBER
13 ,P_CREATION_DATE IN DATE
14 ,P_LAST_UPDATED_BY IN NUMBER
15 ,P_LAST_UPDATE_DATE IN DATE
16 ,P_LAST_UPDATE_LOGIN IN NUMBER
17 ,P_OBJECT_VERSION_NUMBER IN NUMBER
18 ,P_FULFILLMENT_DATE IN DATE
19 ,P_FULFILLMENT_UPDATED_BY IN NUMBER
20 ,P_START_DATE_ACTIVE IN DATE
21 ,P_END_DATE_ACTIVE IN DATE
22 ,P_DISB_HEADER_ID IN NUMBER
23 ,P_DELETE_DISABLED_FLAG IN VARCHAR2
24 ,P_OWNER_OBJECT_ID IN NUMBER
25 ,P_OWNER_TABLE IN VARCHAR2
26 );
27
28 /* Update_Row procedure */
29 PROCEDURE Update_Row(
30 P_COND_ASSIGNMENT_ID IN NUMBER
31 ,P_LOAN_ID IN NUMBER
32 ,P_CONDITION_ID IN NUMBER
33 ,P_CONDITION_DESCRIPTION IN VARCHAR2
34 ,P_CONDITION_MET_FLAG IN VARCHAR2
35 ,P_MANDATORY_FLAG IN VARCHAR2
36 ,P_LAST_UPDATED_BY IN NUMBER
37 ,P_LAST_UPDATE_DATE IN DATE
38 ,P_LAST_UPDATE_LOGIN IN NUMBER
39 ,P_OBJECT_VERSION_NUMBER IN NUMBER
40 ,P_FULFILLMENT_DATE IN DATE
41 ,P_FULFILLMENT_UPDATED_BY IN NUMBER
42 ,P_START_DATE_ACTIVE IN DATE
43 ,P_END_DATE_ACTIVE IN DATE
44 ,P_DISB_HEADER_ID IN NUMBER
45 ,P_DELETE_DISABLED_FLAG IN VARCHAR2
46 ,P_OWNER_OBJECT_ID IN NUMBER
47 ,P_OWNER_TABLE IN VARCHAR2
48 );
49
50 /* Delete_Row procedure */
51 PROCEDURE Delete_Row(P_COND_ASSIGNMENT_ID IN NUMBER);
52
53 procedure ADD_LANGUAGE;
54
55 /* Lock_Row procedure */
56 PROCEDURE Lock_Row(
57 P_COND_ASSIGNMENT_ID IN NUMBER
58 ,P_LOAN_ID IN NUMBER
59 ,P_CONDITION_ID IN NUMBER
60 ,P_CONDITION_DESCRIPTION IN VARCHAR2
61 ,P_CONDITION_MET_FLAG IN VARCHAR2
62 ,P_MANDATORY_FLAG IN VARCHAR2
63 ,P_CREATED_BY IN NUMBER
64 ,P_CREATION_DATE IN DATE
65 ,P_LAST_UPDATED_BY IN NUMBER
66 ,P_LAST_UPDATE_DATE IN DATE
67 ,P_LAST_UPDATE_LOGIN IN NUMBER
68 ,P_OBJECT_VERSION_NUMBER IN NUMBER
69 ,P_FULFILLMENT_DATE IN DATE
70 ,P_FULFILLMENT_UPDATED_BY IN NUMBER
71 ,P_START_DATE_ACTIVE IN DATE
72 ,P_END_DATE_ACTIVE IN DATE
73 ,P_DISB_HEADER_ID IN NUMBER
74 ,P_DELETE_DISABLED_FLAG IN VARCHAR2
75 ,P_OWNER_OBJECT_ID IN NUMBER
76 ,P_OWNER_TABLE IN VARCHAR2
77 );
78 END;
79