1 Package AR_CMGT_CONTROLS AS
2 /* $Header: ARCMGCCS.pls 120.9 2005/11/30 23:08:02 bsarkar noship $ */
3 PROCEDURE POPULATE_DNB_DATA (
4 p_case_folder_id IN NUMBER,
5 p_source_table_name IN VARCHAR2,
6 p_source_key IN VARCHAR2,
7 p_source_key_type IN VARCHAR2 default NULL,
8 p_source_key_column_name IN VARCHAR2,
9 p_source_key_column_type IN VARCHAR2 default NULL,
10 p_errmsg OUT NOCOPY VARCHAR2,
11 p_resultout OUT NOCOPY VARCHAR2);
12
13 PROCEDURE POPULATE_CASE_FOLDER (
14 p_case_folder_id IN NUMBER,
15 p_case_folder_number IN VARCHAR2 default NULL,
16 p_credit_request_id IN NUMBER default NULL,
17 p_check_list_id IN NUMBER default NULL,
18 p_status IN VARCHAR2 default NULL,
19 p_party_id IN NUMBER,
20 p_cust_account_id IN NUMBER,
21 p_cust_acct_site_id IN NUMBER,
22 p_score_model_id IN NUMBER default NULL,
23 p_credit_classification IN VARCHAR2 default NULL,
24 p_review_type IN VARCHAR2 default NULL,
25 p_limit_currency IN VARCHAR2,
26 p_exchange_rate_type IN VARCHAR2,
27 p_type IN VARCHAR2,
28 p_errmsg OUT NOCOPY VARCHAR2,
29 p_resultout OUT NOCOPY VARCHAR2);
30
31 PROCEDURE POPULATE_CASE_FOLDER_DETAILS (
32 p_case_folder_id IN NUMBER,
33 p_data_point_id IN NUMBER,
34 p_data_point_value IN VARCHAR2,
35 p_included_in_check_list IN VARCHAR2,
36 p_score IN NUMBER default NULL,
37 p_errmsg OUT NOCOPY VARCHAR2,
38 p_resultout OUT NOCOPY VARCHAR2);
39
40 PROCEDURE UPDATE_CASE_FOLDER_DETAILS (
41 p_case_folder_id IN NUMBER,
42 p_data_point_id IN NUMBER,
43 p_data_point_value IN VARCHAR2,
44 p_score IN NUMBER default NULL,
45 p_errmsg OUT NOCOPY VARCHAR2,
46 p_resultout OUT NOCOPY VARCHAR2);
47
48 procedure populate_recommendation(
49 p_case_folder_id IN NUMBER,
50 p_credit_request_id IN NUMBER,
51 p_score IN NUMBER,
52 p_recommended_credit_limit IN NUMBER,
53 p_credit_review_date IN DATE,
54 p_credit_recommendation IN VARCHAR2,
55 p_recommendation_value1 IN VARCHAR2,
56 p_recommendation_value2 IN VARCHAR2,
57 p_status IN VARCHAR2,
58 p_credit_type IN VARCHAR2,
59 p_errmsg OUT NOCOPY VARCHAR2,
60 p_resultout OUT NOCOPY VARCHAR2 );
61
62 procedure populate_data_points
63 ( p_data_point_name IN VARCHAR2,
64 p_data_point_category IN VARCHAR2,
65 p_user_defined_flag IN VARCHAR2,
66 p_scorable_flag IN VARCHAR2,
67 p_display_on_checklist IN VARCHAR2,
68 p_created_by IN NUMBER,
69 p_data_point_code IN VARCHAR2,
70 p_data_point_id OUT NOCOPY NUMBER);
71
72 PROCEDURE populate_add_data_points
73 ( p_data_point_code IN VARCHAR2,
74 p_data_point_name IN VARCHAR2,
75 p_description IN VARCHAR2,
76 p_data_point_sub_category IN VARCHAR2,
77 p_data_point_category IN VARCHAR2,
78 p_user_defined_flag IN VARCHAR2,
79 p_scorable_flag IN VARCHAR2,
80 p_display_on_checklist IN VARCHAR2,
81 p_created_by IN NUMBER,
82 p_application_id IN NUMBER,
83 p_parent_data_point_id IN NUMBER,
84 p_enabled_flag IN VARCHAR2,
85 p_package_name IN VARCHAR2,
86 p_function_name IN VARCHAR2,
87 p_function_type IN VARCHAR2,
88 p_return_data_type IN VARCHAR2,
89 p_return_date_format IN VARCHAR2,
90 x_data_point_id OUT NOCOPY NUMBER);
91
92 PROCEDURE populate_aging_dtls(
93 p_case_folder_id IN NUMBER,
94 p_aging_bucket_id IN NUMBER,
95 p_aging_bucket_line_id IN NUMBER,
96 p_amount IN NUMBER,
97 p_error_msg OUT NOCOPY VARCHAR2,
98 p_resultout OUT NOCOPY VARCHAR2);
99
100 PROCEDURE update_aging_dtls(
101 p_case_folder_id IN NUMBER,
102 p_aging_bucket_id IN NUMBER,
103 p_aging_bucket_line_id IN NUMBER,
104 p_amount IN NUMBER,
105 p_error_msg OUT NOCOPY VARCHAR2,
106 p_resultout OUT NOCOPY VARCHAR2);
107
108 PROCEDURE POPULATE_CF_ADP_DETAILS (
109 p_case_folder_id IN NUMBER,
110 p_data_point_id IN NUMBER,
111 p_sequence_number IN NUMBER,
112 p_parent_data_point_id IN NUMBER,
113 p_parent_cf_detail_id IN NUMBER,
114 p_data_point_value IN VARCHAR2,
115 p_score IN NUMBER default NULL,
116 p_included_in_checklist IN VARCHAR2 default NULL,
117 p_data_point_value_id IN NUMBER default NULL,
118 p_case_folder_detail_id OUT NOCOPY NUMBER,
119 p_errmsg OUT NOCOPY VARCHAR2,
120 p_resultout OUT NOCOPY VARCHAR2);
121
122 PROCEDURE UPDATE_CF_ADP_DETAILS (
123
124 p_case_folder_id IN NUMBER,
125 p_data_point_id IN NUMBER,
126 p_sequence_number IN NUMBER,
127 p_parent_data_point_id IN NUMBER,
128 p_parent_cf_detail_id IN NUMBER,
129 p_data_point_value IN VARCHAR2,
130 p_score IN NUMBER default NULL,
131 p_included_in_checklist IN VARCHAR2 default NULL,
132 p_data_point_value_id IN NUMBER default NULL,
133 p_case_folder_detail_id IN OUT NOCOPY NUMBER,
134 x_errmsg OUT NOCOPY VARCHAR2,
135 x_resultout OUT NOCOPY VARCHAR2);
136
137 PROCEDURE DUPLICATE_CASE_FOLDER_TBL
138 ( p_parnt_case_folder_id IN NUMBER,
139 p_credit_request_id IN NUMBER,
140 p_errmsg OUT NOCOPY VARCHAR2,
141 p_resultout OUT NOCOPY VARCHAR2
142 );
143 PROCEDURE DUPLICATE_CASE_FOLDER_DTLS(
144 p_parnt_case_folder_id IN NUMBER,
145 p_credit_request_id IN NUMBER,
146 p_errmsg OUT NOCOPY VARCHAR2,
147 p_resultout OUT NOCOPY VARCHAR2
148 );
149 PROCEDURE DUPLICATE_AGING_DATA(
150 p_parnt_case_folder_id IN NUMBER,
151 p_credit_request_id IN NUMBER,
152 p_errmsg OUT NOCOPY VARCHAR2,
153 p_resultout OUT NOCOPY VARCHAR2
154 );
155 PROCEDURE DUPLICATE_DNB_DATA(
156 p_parnt_case_folder_id IN NUMBER,
157 p_credit_request_id IN NUMBER,
158 p_errmsg OUT NOCOPY VARCHAR2,
159 p_resultout OUT NOCOPY VARCHAR2
160 );
161 PROCEDURE DUPLICATE_FINANCIAL_DATA(
162 p_parnt_credit_req_id IN NUMBER,
163 p_credit_request_id IN NUMBER,
164 p_errmsg OUT NOCOPY VARCHAR2,
165 p_resultout OUT NOCOPY VARCHAR2
166 );
167 PROCEDURE DUPLICATE_TRADE_DATA(
168 p_parnt_credit_req_id IN NUMBER,
169 p_credit_request_id IN NUMBER,
170 p_errmsg OUT NOCOPY VARCHAR2,
171 p_resultout OUT NOCOPY VARCHAR2
172 );
173 PROCEDURE DUPLICATE_BANK_DATA(
174 p_parnt_credit_req_id IN NUMBER,
175 p_credit_request_id IN NUMBER,
176 p_errmsg OUT NOCOPY VARCHAR2,
177 p_resultout OUT NOCOPY VARCHAR2
178 );
179 PROCEDURE DUPLICATE_COLLATERAL_DATA(
180 p_parnt_credit_req_id IN NUMBER,
181 p_credit_request_id IN NUMBER,
182 p_errmsg OUT NOCOPY VARCHAR2,
183 p_resultout OUT NOCOPY VARCHAR2
184 );
185 PROCEDURE DUPLICATE_OTHER_DATA(
186 p_parnt_credit_req_id IN NUMBER,
187 p_credit_request_id IN NUMBER,
188 p_errmsg OUT NOCOPY VARCHAR2,
189 p_resultout OUT NOCOPY VARCHAR2
190 );
191 PROCEDURE DUPLICATE_RECO_DATA(
192 p_parnt_case_folder_id IN NUMBER,
193 p_credit_request_id IN NUMBER,
194 p_errmsg OUT NOCOPY VARCHAR2,
195 p_resultout OUT NOCOPY VARCHAR2
196 );
197 PROCEDURE DUPLICATE_NOTES_DATA(
198 p_parnt_case_folder_id IN NUMBER,
199 p_credit_request_id IN NUMBER,
200 p_errmsg OUT NOCOPY VARCHAR2,
201 p_resultout OUT NOCOPY VARCHAR2
202 );
203
204 PROCEDURE UPDATE_CASEFOLDER_DETAILS(
205 P_DATA_POINT_ID IN NUMBER,
206 P_CASE_FOLDER_ID IN NUMBER,
207 P_RESULT OUT NOCOPY NUMBER
208 );
209
210 PROCEDURE UPDATE_CF_DETAILS_NEGATION(
211 P_DATA_POINT_ID IN NUMBER,
212 P_CASE_FOLDER_ID IN NUMBER,
213 P_RESULT OUT NOCOPY NUMBER
214 );
215
216 END AR_CMGT_CONTROLS;