[Home] [Help]
PACKAGE: APPS.LNS_COND_ASSIGNMENT_PUB
Source
1 PACKAGE LNS_COND_ASSIGNMENT_PUB AUTHID CURRENT_USER AS
2 /* $Header: LNS_CASGM_PUBP_S.pls 120.5.12010000.2 2010/03/17 13:39:34 scherkas ship $ */
3
4 TYPE cond_assignment_rec_type IS RECORD(
5 COND_ASSIGNMENT_ID NUMBER,
6 LOAN_ID NUMBER,
7 CONDITION_ID NUMBER,
8 CONDITION_DESCRIPTION VARCHAR2(250),
9 CONDITION_MET_FLAG VARCHAR2(1),
10 FULFILLMENT_DATE DATE,
11 FULFILLMENT_UPDATED_BY NUMBER(15),
12 MANDATORY_FLAG VARCHAR2(1),
13 CREATED_BY NUMBER(15),
14 CREATION_DATE DATE,
15 LAST_UPDATED_BY NUMBER(15),
16 LAST_UPDATE_DATE DATE,
17 LAST_UPDATE_LOGIN NUMBER(15),
18 OBJECT_VERSION_NUMBER NUMBER,
19 DISB_HEADER_ID NUMBER,
20 DELETE_DISABLED_FLAG VARCHAR2(1),
21 OWNER_OBJECT_ID NUMBER,
22 OWNER_TABLE VARCHAR2(100)
23 );
24 TYPE cond_assignment_tbl_type IS TABLE OF cond_assignment_rec_type INDEX BY BINARY_INTEGER;
25
26 PROCEDURE create_COND_ASSIGNMENT (
27 p_init_msg_list IN VARCHAR2,
28 p_COND_ASSIGNMENT_rec IN cond_assignment_rec_type,
29 x_COND_ASSIGNMENT_id OUT NOCOPY NUMBER,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2
33 );
34
35 PROCEDURE update_COND_ASSIGNMENT (
36 p_init_msg_list IN VARCHAR2,
37 p_COND_ASSIGNMENT_rec IN cond_assignment_rec_type,
38 p_object_version_number IN OUT NOCOPY NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44 PROCEDURE delete_COND_ASSIGNMENT (
45 p_init_msg_list IN VARCHAR2,
46 p_COND_ASSIGNMENT_id IN NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2
50 );
51 /*
52 PROCEDURE get_COND_ASSIGNMENT_rec (
53 p_init_msg_list IN VARCHAR2,
54 p_COND_ASSIGNMENT_id IN NUMBER,
55 x_COND_ASSIGNMENT_rec OUT NOCOPY cond_assignment_rec_type,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2
59 );
60 */
61
62 PROCEDURE create_LP_COND_ASSIGNMENT( P_LOAN_ID IN NUMBER ) ;
63
64
65 PROCEDURE create_LP_DISB_COND_ASSIGNMENT(
66 P_LOAN_ID IN NUMBER,
67 P_DISB_HEADER_ID IN NUMBER ,
68 P_LOAN_PRODUCT_LINE_ID IN NUMBER);
69
70 PROCEDURE delete_DISB_COND_ASSIGNMENT( P_DISB_HEADER_ID IN NUMBER ) ;
71
72
73 -- function used to check if any condition assignment exists for a specific condition
74 -- if so, disallow deletion of that condition in LNS_CONDITIONS
75 FUNCTION IS_EXIST_COND_ASSIGNMENT (
76 p_condition_id NUMBER
77 ) RETURN VARCHAR2;
78
79
80 PROCEDURE VALIDATE_CUSTOM_CONDITIONS(
81 P_API_VERSION IN NUMBER,
82 P_INIT_MSG_LIST IN VARCHAR2,
83 P_COMMIT IN VARCHAR2,
84 P_VALIDATION_LEVEL IN NUMBER,
85 P_OWNER_OBJECT_ID IN NUMBER,
86 P_CONDITION_TYPE IN VARCHAR2,
87 P_COMPLETE_FLAG IN VARCHAR2,
88 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
89 X_MSG_COUNT OUT NOCOPY NUMBER,
90 X_MSG_DATA OUT NOCOPY VARCHAR2);
91
92
93 PROCEDURE VALIDATE_CUSTOM_CONDITION(
94 P_API_VERSION IN NUMBER,
95 P_INIT_MSG_LIST IN VARCHAR2,
96 P_COMMIT IN VARCHAR2,
97 P_VALIDATION_LEVEL IN NUMBER,
98 P_COND_ASSIGNMENT_ID IN NUMBER,
99 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
100 X_MSG_COUNT OUT NOCOPY NUMBER,
101 X_MSG_DATA OUT NOCOPY VARCHAR2);
102
103
104 PROCEDURE DEFAULT_COND_ASSIGNMENTS(
105 P_API_VERSION IN NUMBER,
106 P_INIT_MSG_LIST IN VARCHAR2,
107 P_COMMIT IN VARCHAR2,
108 P_VALIDATION_LEVEL IN NUMBER,
109 P_LOAN_ID IN NUMBER,
110 P_OWNER_OBJECT_ID IN NUMBER,
111 P_CONDITION_TYPE IN VARCHAR2,
112 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
113 X_MSG_COUNT OUT NOCOPY NUMBER,
114 X_MSG_DATA OUT NOCOPY VARCHAR2);
115
116 PROCEDURE VALIDATE_NONCUSTOM_CONDITIONS(
117 P_API_VERSION IN NUMBER,
118 P_INIT_MSG_LIST IN VARCHAR2,
119 P_COMMIT IN VARCHAR2,
120 P_VALIDATION_LEVEL IN NUMBER,
121 P_OWNER_OBJECT_ID IN NUMBER,
122 P_CONDITION_TYPE IN VARCHAR2,
123 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
124 X_MSG_COUNT OUT NOCOPY NUMBER,
125 X_MSG_DATA OUT NOCOPY VARCHAR2);
126
127 END LNS_COND_ASSIGNMENT_PUB;