PACKAGE: APPS.LNS_COND_ASSIGNMENTS_PKG

Source

1 PACKAGE LNS_COND_ASSIGNMENTS_PKG AS
2 /* $Header: LNS_CASGM_TBLH_S.pls 120.2.12010000.2 2008/08/29 20:11:33 mbolli 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 );
25 
26 /* Update_Row procedure */
27 PROCEDURE Update_Row(
28 	P_COND_ASSIGNMENT_ID		IN NUMBER
29 	,P_LOAN_ID		IN NUMBER
30 	,P_CONDITION_ID		IN NUMBER
31 	,P_CONDITION_DESCRIPTION		IN VARCHAR2
32 	,P_CONDITION_MET_FLAG		IN VARCHAR2
33 	,P_MANDATORY_FLAG		IN VARCHAR2
34 	,P_LAST_UPDATED_BY		IN NUMBER
35 	,P_LAST_UPDATE_DATE		IN DATE
36 	,P_LAST_UPDATE_LOGIN		IN NUMBER
37 	,P_OBJECT_VERSION_NUMBER		IN NUMBER
38 	,P_FULFILLMENT_DATE		IN DATE
39 	,P_FULFILLMENT_UPDATED_BY		IN NUMBER
40 	,P_START_DATE_ACTIVE		IN DATE
41 	,P_END_DATE_ACTIVE		IN DATE
42  	,P_DISB_HEADER_ID		IN NUMBER
43 	,P_DELETE_DISABLED_FLAG		IN VARCHAR2
44 );
45 
46 /* Delete_Row procedure */
47 PROCEDURE Delete_Row(P_COND_ASSIGNMENT_ID IN NUMBER);
48 
49 procedure ADD_LANGUAGE;
50 
51 /* Lock_Row procedure */
52 PROCEDURE Lock_Row(
53 	P_COND_ASSIGNMENT_ID		IN NUMBER
54 	,P_LOAN_ID		IN NUMBER
55 	,P_CONDITION_ID		IN NUMBER
56 	,P_CONDITION_DESCRIPTION		IN VARCHAR2
57 	,P_CONDITION_MET_FLAG		IN VARCHAR2
58 	,P_MANDATORY_FLAG		IN VARCHAR2
59 	,P_CREATED_BY		IN NUMBER
60 	,P_CREATION_DATE		IN DATE
61 	,P_LAST_UPDATED_BY		IN NUMBER
62 	,P_LAST_UPDATE_DATE		IN DATE
63 	,P_LAST_UPDATE_LOGIN		IN NUMBER
64 	,P_OBJECT_VERSION_NUMBER		IN NUMBER
65 	,P_FULFILLMENT_DATE		IN DATE
66 	,P_FULFILLMENT_UPDATED_BY		IN NUMBER
67 	,P_START_DATE_ACTIVE		IN DATE
68 	,P_END_DATE_ACTIVE		IN DATE
69 	,P_DISB_HEADER_ID		IN NUMBER
70 	,P_DELETE_DISABLED_FLAG		IN VARCHAR2
71 );
72 END;
73