1 PACKAGE HZ_CREDIT_RATINGS_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHPCRTS.pls 115.12 2003/04/17 20:39:58 sponnamb ship $ */
3
4 PROCEDURE Insert_Row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_credit_rating_id IN OUT NOCOPY NUMBER,
7 x_description IN VARCHAR2,
8 x_party_id IN NUMBER,
9 x_rating IN VARCHAR2,
10 x_rated_as_of_date IN DATE,
11 x_rating_organization IN VARCHAR2,
12 x_comments IN VARCHAR2,
13 x_det_history_ind IN VARCHAR2,
14 x_fincl_embt_ind IN VARCHAR2,
15 x_criminal_proceeding_ind IN VARCHAR2,
16 x_suit_judge_ind IN VARCHAR2,
17 x_claims_ind IN VARCHAR2,
18 x_secured_flng_ind IN VARCHAR2,
19 x_fincl_lgl_event_ind IN VARCHAR2,
20 x_disaster_ind IN VARCHAR2,
21 x_oprg_spec_evnt_ind IN VARCHAR2,
22 x_other_spec_evnt_ind IN VARCHAR2,
23 x_content_source_type IN VARCHAR2,
24 x_status IN VARCHAR2,
25 x_object_version_number IN NUMBER,
26 x_created_by_module IN VARCHAR2,
27 x_avg_high_credit IN NUMBER,
28 x_credit_score IN VARCHAR2,
29 x_credit_score_age IN NUMBER,
30 x_credit_score_class IN NUMBER,
31 x_credit_score_commentary IN VARCHAR2,
32 x_credit_score_commentary2 IN VARCHAR2,
33 x_credit_score_commentary3 IN VARCHAR2,
34 x_credit_score_commentary4 IN VARCHAR2,
35 x_credit_score_commentary5 IN VARCHAR2,
36 x_credit_score_commentary6 IN VARCHAR2,
37 x_credit_score_commentary7 IN VARCHAR2,
38 x_credit_score_commentary8 IN VARCHAR2,
39 x_credit_score_commentary9 IN VARCHAR2,
40 x_credit_score_commentary10 IN VARCHAR2,
41 x_credit_score_date IN DATE,
42 x_credit_score_incd_default IN NUMBER,
43 x_credit_score_natl_percentile IN NUMBER,
44 x_debarment_ind IN VARCHAR2,
45 x_debarments_count IN NUMBER,
46 x_debarments_date IN DATE,
47 x_high_credit IN NUMBER,
48 x_maximum_credit_currency_code IN VARCHAR2,
49 x_maximum_credit_rcmd IN NUMBER,
50 x_paydex_norm IN VARCHAR2,
51 x_paydex_score IN VARCHAR2,
52 x_paydex_three_months_ago IN VARCHAR2,
53 x_credit_score_override_code IN VARCHAR2,
54 x_cr_scr_clas_expl IN VARCHAR2,
55 x_low_rng_delq_scr IN NUMBER,
56 x_high_rng_delq_scr IN NUMBER,
57 x_delq_pmt_rng_prcnt IN NUMBER,
58 x_delq_pmt_pctg_for_all_firms IN NUMBER,
59 x_num_trade_experiences IN NUMBER,
60 x_paydex_firm_days IN VARCHAR2,
61 x_paydex_firm_comment IN VARCHAR2,
62 x_paydex_industry_days IN VARCHAR2,
63 x_paydex_industry_comment IN VARCHAR2,
64 x_paydex_comment IN VARCHAR2,
65 x_suit_ind IN VARCHAR2,
66 x_lien_ind IN VARCHAR2,
67 x_judgement_ind IN VARCHAR2,
68 x_bankruptcy_ind IN VARCHAR2,
69 x_no_trade_ind IN VARCHAR2,
70 x_prnt_hq_bkcy_ind IN VARCHAR2,
71 x_num_prnt_bkcy_filing IN NUMBER,
72 x_prnt_bkcy_filg_type IN VARCHAR2,
73 x_prnt_bkcy_filg_chapter IN NUMBER,
74 x_prnt_bkcy_filg_date IN DATE,
75 x_num_prnt_bkcy_convs IN NUMBER,
76 x_prnt_bkcy_conv_date IN DATE,
77 x_prnt_bkcy_chapter_conv IN VARCHAR2,
78 x_slow_trade_expl IN VARCHAR2,
79 x_negv_pmt_expl IN VARCHAR2,
80 x_pub_rec_expl IN VARCHAR2,
81 x_business_discontinued IN VARCHAR2,
82 x_spcl_event_comment IN VARCHAR2,
83 x_num_spcl_event IN NUMBER,
84 x_spcl_event_update_date IN DATE,
85 x_spcl_evnt_txt IN VARCHAR2,
86 x_failure_score IN VARCHAR2,
87 x_failure_score_age IN NUMBER,
88 x_failure_score_class IN NUMBER,
89 x_failure_score_commentary IN VARCHAR2,
90 x_failure_score_commentary2 IN VARCHAR2,
91 x_failure_score_commentary3 IN VARCHAR2,
92 x_failure_score_commentary4 IN VARCHAR2,
93 x_failure_score_commentary5 IN VARCHAR2,
94 x_failure_score_commentary6 IN VARCHAR2,
95 x_failure_score_commentary7 IN VARCHAR2,
96 x_failure_score_commentary8 IN VARCHAR2,
97 x_failure_score_commentary9 IN VARCHAR2,
98 x_failure_score_commentary10 IN VARCHAR2,
99 x_failure_score_date IN DATE,
100 x_failure_score_incd_default IN NUMBER,
101 x_fail_score_natnl_percentile IN NUMBER,
102 x_failure_score_override_code IN VARCHAR2,
103 x_global_failure_score IN VARCHAR2,
104 x_actual_content_source IN VARCHAR2
105 );
106
107 PROCEDURE Update_Row (
108 x_rowid IN OUT NOCOPY VARCHAR2,
109 x_credit_rating_id IN NUMBER,
110 x_description IN VARCHAR2,
111 x_party_id IN NUMBER,
112 x_rating IN VARCHAR2,
113 x_rated_as_of_date IN DATE,
114 x_rating_organization IN VARCHAR2,
115 x_comments IN VARCHAR2,
116 x_det_history_ind IN VARCHAR2,
117 x_fincl_embt_ind IN VARCHAR2,
118 x_criminal_proceeding_ind IN VARCHAR2,
119 x_suit_judge_ind IN VARCHAR2,
120 x_claims_ind IN VARCHAR2,
121 x_secured_flng_ind IN VARCHAR2,
122 x_fincl_lgl_event_ind IN VARCHAR2,
123 x_disaster_ind IN VARCHAR2,
124 x_oprg_spec_evnt_ind IN VARCHAR2,
125 x_other_spec_evnt_ind IN VARCHAR2,
126 x_content_source_type IN VARCHAR2,
127 x_status IN VARCHAR2,
128 x_object_version_number IN NUMBER,
129 x_created_by_module IN VARCHAR2,
130 x_avg_high_credit IN NUMBER,
131 x_credit_score IN VARCHAR2,
132 x_credit_score_age IN NUMBER,
133 x_credit_score_class IN NUMBER,
134 x_credit_score_commentary IN VARCHAR2,
135 x_credit_score_commentary2 IN VARCHAR2,
136 x_credit_score_commentary3 IN VARCHAR2,
137 x_credit_score_commentary4 IN VARCHAR2,
138 x_credit_score_commentary5 IN VARCHAR2,
139 x_credit_score_commentary6 IN VARCHAR2,
140 x_credit_score_commentary7 IN VARCHAR2,
141 x_credit_score_commentary8 IN VARCHAR2,
142 x_credit_score_commentary9 IN VARCHAR2,
143 x_credit_score_commentary10 IN VARCHAR2,
144 x_credit_score_date IN DATE,
145 x_credit_score_incd_default IN NUMBER,
146 x_credit_score_natl_percentile IN NUMBER,
147 x_debarment_ind IN VARCHAR2,
148 x_debarments_count IN NUMBER,
149 x_debarments_date IN DATE,
150 x_high_credit IN NUMBER,
151 x_maximum_credit_currency_code IN VARCHAR2,
152 x_maximum_credit_rcmd IN NUMBER,
153 x_paydex_norm IN VARCHAR2,
154 x_paydex_score IN VARCHAR2,
155 x_paydex_three_months_ago IN VARCHAR2,
156 x_credit_score_override_code IN VARCHAR2,
157 x_cr_scr_clas_expl IN VARCHAR2,
158 x_low_rng_delq_scr IN NUMBER,
159 x_high_rng_delq_scr IN NUMBER,
160 x_delq_pmt_rng_prcnt IN NUMBER,
161 x_delq_pmt_pctg_for_all_firms IN NUMBER,
162 x_num_trade_experiences IN NUMBER,
163 x_paydex_firm_days IN VARCHAR2,
164 x_paydex_firm_comment IN VARCHAR2,
165 x_paydex_industry_days IN VARCHAR2,
166 x_paydex_industry_comment IN VARCHAR2,
167 x_paydex_comment IN VARCHAR2,
168 x_suit_ind IN VARCHAR2,
169 x_lien_ind IN VARCHAR2,
170 x_judgement_ind IN VARCHAR2,
171 x_bankruptcy_ind IN VARCHAR2,
172 x_no_trade_ind IN VARCHAR2,
173 x_prnt_hq_bkcy_ind IN VARCHAR2,
174 x_num_prnt_bkcy_filing IN NUMBER,
175 x_prnt_bkcy_filg_type IN VARCHAR2,
176 x_prnt_bkcy_filg_chapter IN NUMBER,
177 x_prnt_bkcy_filg_date IN DATE,
178 x_num_prnt_bkcy_convs IN NUMBER,
179 x_prnt_bkcy_conv_date IN DATE,
180 x_prnt_bkcy_chapter_conv IN VARCHAR2,
181 x_slow_trade_expl IN VARCHAR2,
182 x_negv_pmt_expl IN VARCHAR2,
183 x_pub_rec_expl IN VARCHAR2,
184 x_business_discontinued IN VARCHAR2,
185 x_spcl_event_comment IN VARCHAR2,
186 x_num_spcl_event IN NUMBER,
187 x_spcl_event_update_date IN DATE,
188 x_spcl_evnt_txt IN VARCHAR2,
189 x_failure_score IN VARCHAR2,
190 x_failure_score_age IN NUMBER,
191 x_failure_score_class IN NUMBER,
192 x_failure_score_commentary IN VARCHAR2,
193 x_failure_score_commentary2 IN VARCHAR2,
194 x_failure_score_commentary3 IN VARCHAR2,
195 x_failure_score_commentary4 IN VARCHAR2,
196 x_failure_score_commentary5 IN VARCHAR2,
197 x_failure_score_commentary6 IN VARCHAR2,
198 x_failure_score_commentary7 IN VARCHAR2,
199 x_failure_score_commentary8 IN VARCHAR2,
200 x_failure_score_commentary9 IN VARCHAR2,
201 x_failure_score_commentary10 IN VARCHAR2,
202 x_failure_score_date IN DATE,
203 x_failure_score_incd_default IN NUMBER,
204 x_fail_score_natnl_percentile IN NUMBER,
205 x_failure_score_override_code IN VARCHAR2,
206 x_global_failure_score IN VARCHAR2,
207 x_actual_content_source IN VARCHAR2
208 );
209
210 PROCEDURE Lock_Row (
211 x_rowid IN OUT NOCOPY VARCHAR2,
212 x_credit_rating_id IN NUMBER,
213 x_description IN VARCHAR2,
214 x_party_id IN NUMBER,
215 x_rating IN VARCHAR2,
216 x_rated_as_of_date IN DATE,
217 x_rating_organization IN VARCHAR2,
218 x_created_by IN NUMBER,
219 x_creation_date IN DATE,
220 x_last_update_login IN NUMBER,
221 x_last_update_date IN DATE,
222 x_last_updated_by IN NUMBER,
223 x_request_id IN NUMBER,
224 x_program_application_id IN NUMBER,
225 x_program_id IN NUMBER,
226 x_program_update_date IN DATE,
227 x_wh_update_date IN DATE,
228 x_comments IN VARCHAR2,
229 x_det_history_ind IN VARCHAR2,
230 x_fincl_embt_ind IN VARCHAR2,
231 x_criminal_proceeding_ind IN VARCHAR2,
232 x_suit_judge_ind IN VARCHAR2,
233 x_claims_ind IN VARCHAR2,
234 x_secured_flng_ind IN VARCHAR2,
235 x_fincl_lgl_event_ind IN VARCHAR2,
236 x_disaster_ind IN VARCHAR2,
237 x_oprg_spec_evnt_ind IN VARCHAR2,
238 x_other_spec_evnt_ind IN VARCHAR2,
239 x_content_source_type IN VARCHAR2,
240 x_status IN VARCHAR2,
241 x_object_version_number IN NUMBER,
242 x_created_by_module IN VARCHAR2,
243 x_application_id IN NUMBER,
244 x_avg_high_credit IN NUMBER,
245 x_credit_score IN VARCHAR2,
246 x_credit_score_age IN NUMBER,
247 x_credit_score_class IN NUMBER,
248 x_credit_score_commentary IN VARCHAR2,
249 x_credit_score_commentary2 IN VARCHAR2,
250 x_credit_score_commentary3 IN VARCHAR2,
251 x_credit_score_commentary4 IN VARCHAR2,
252 x_credit_score_commentary5 IN VARCHAR2,
253 x_credit_score_commentary6 IN VARCHAR2,
254 x_credit_score_commentary7 IN VARCHAR2,
255 x_credit_score_commentary8 IN VARCHAR2,
259 x_credit_score_incd_default IN NUMBER,
256 x_credit_score_commentary9 IN VARCHAR2,
257 x_credit_score_commentary10 IN VARCHAR2,
258 x_credit_score_date IN DATE,
260 x_credit_score_natl_percentile IN NUMBER,
261 x_debarment_ind IN VARCHAR2,
262 x_debarments_count IN NUMBER,
263 x_debarments_date IN DATE,
264 x_high_credit IN NUMBER,
265 x_maximum_credit_currency_code IN VARCHAR2,
266 x_maximum_credit_rcmd IN NUMBER,
267 x_paydex_norm IN VARCHAR2,
268 x_paydex_score IN VARCHAR2,
269 x_paydex_three_months_ago IN VARCHAR2,
270 x_credit_score_override_code IN VARCHAR2,
271 x_cr_scr_clas_expl IN VARCHAR2,
272 x_low_rng_delq_scr IN NUMBER,
273 x_high_rng_delq_scr IN NUMBER,
274 x_delq_pmt_rng_prcnt IN NUMBER,
275 x_delq_pmt_pctg_for_all_firms IN NUMBER,
276 x_num_trade_experiences IN NUMBER,
277 x_paydex_firm_days IN VARCHAR2,
278 x_paydex_firm_comment IN VARCHAR2,
279 x_paydex_industry_days IN VARCHAR2,
280 x_paydex_industry_comment IN VARCHAR2,
281 x_paydex_comment IN VARCHAR2,
282 x_suit_ind IN VARCHAR2,
283 x_lien_ind IN VARCHAR2,
284 x_judgement_ind IN VARCHAR2,
285 x_bankruptcy_ind IN VARCHAR2,
286 x_no_trade_ind IN VARCHAR2,
287 x_prnt_hq_bkcy_ind IN VARCHAR2,
288 x_num_prnt_bkcy_filing IN NUMBER,
289 x_prnt_bkcy_filg_type IN VARCHAR2,
290 x_prnt_bkcy_filg_chapter IN NUMBER,
291 x_prnt_bkcy_filg_date IN DATE,
292 x_num_prnt_bkcy_convs IN NUMBER,
293 x_prnt_bkcy_conv_date IN DATE,
294 x_prnt_bkcy_chapter_conv IN VARCHAR2,
295 x_slow_trade_expl IN VARCHAR2,
296 x_negv_pmt_expl IN VARCHAR2,
297 x_pub_rec_expl IN VARCHAR2,
298 x_business_discontinued IN VARCHAR2,
299 x_spcl_event_comment IN VARCHAR2,
300 x_num_spcl_event IN NUMBER,
301 x_spcl_event_update_date IN DATE,
302 x_spcl_evnt_txt IN VARCHAR2,
303 x_failure_score IN VARCHAR2,
304 x_failure_score_age IN NUMBER,
305 x_failure_score_class IN NUMBER,
306 x_failure_score_commentary IN VARCHAR2,
307 x_failure_score_commentary2 IN VARCHAR2,
308 x_failure_score_commentary3 IN VARCHAR2,
309 x_failure_score_commentary4 IN VARCHAR2,
310 x_failure_score_commentary5 IN VARCHAR2,
311 x_failure_score_commentary6 IN VARCHAR2,
312 x_failure_score_commentary7 IN VARCHAR2,
313 x_failure_score_commentary8 IN VARCHAR2,
314 x_failure_score_commentary9 IN VARCHAR2,
315 x_failure_score_commentary10 IN VARCHAR2,
316 x_failure_score_date IN DATE,
317 x_failure_score_incd_default IN NUMBER,
318 x_fail_score_natnl_percentile IN NUMBER,
319 x_failure_score_override_code IN VARCHAR2,
320 x_global_failure_score IN VARCHAR2,
321 x_actual_content_source IN VARCHAR2
322 );
323
324 PROCEDURE Select_Row (
325 x_credit_rating_id IN OUT NOCOPY NUMBER,
326 x_description OUT NOCOPY VARCHAR2,
327 x_party_id OUT NOCOPY NUMBER,
328 x_rating OUT NOCOPY VARCHAR2,
329 x_rated_as_of_date OUT NOCOPY DATE,
330 x_rating_organization OUT NOCOPY VARCHAR2,
331 x_comments OUT NOCOPY VARCHAR2,
332 x_det_history_ind OUT NOCOPY VARCHAR2,
333 x_fincl_embt_ind OUT NOCOPY VARCHAR2,
334 x_criminal_proceeding_ind OUT NOCOPY VARCHAR2,
335 x_claims_ind OUT NOCOPY VARCHAR2,
336 x_secured_flng_ind OUT NOCOPY VARCHAR2,
337 x_fincl_lgl_event_ind OUT NOCOPY VARCHAR2,
338 x_disaster_ind OUT NOCOPY VARCHAR2,
339 x_oprg_spec_evnt_ind OUT NOCOPY VARCHAR2,
340 x_other_spec_evnt_ind OUT NOCOPY VARCHAR2,
341 x_status OUT NOCOPY VARCHAR2,
342 x_created_by_module OUT NOCOPY VARCHAR2,
343 x_avg_high_credit OUT NOCOPY NUMBER,
344 x_credit_score OUT NOCOPY VARCHAR2,
345 x_credit_score_age OUT NOCOPY NUMBER,
346 x_credit_score_class OUT NOCOPY NUMBER,
347 x_credit_score_commentary OUT NOCOPY VARCHAR2,
351 x_credit_score_commentary5 OUT NOCOPY VARCHAR2,
348 x_credit_score_commentary2 OUT NOCOPY VARCHAR2,
349 x_credit_score_commentary3 OUT NOCOPY VARCHAR2,
350 x_credit_score_commentary4 OUT NOCOPY VARCHAR2,
352 x_credit_score_commentary6 OUT NOCOPY VARCHAR2,
353 x_credit_score_commentary7 OUT NOCOPY VARCHAR2,
354 x_credit_score_commentary8 OUT NOCOPY VARCHAR2,
355 x_credit_score_commentary9 OUT NOCOPY VARCHAR2,
356 x_credit_score_commentary10 OUT NOCOPY VARCHAR2,
357 x_credit_score_date OUT NOCOPY DATE,
358 x_credit_score_incd_default OUT NOCOPY NUMBER,
359 x_credit_score_natl_percentile OUT NOCOPY NUMBER,
360 x_debarment_ind OUT NOCOPY VARCHAR2,
361 x_debarments_count OUT NOCOPY NUMBER,
362 x_debarments_date OUT NOCOPY DATE,
363 x_high_credit OUT NOCOPY NUMBER,
364 x_maximum_credit_currency_code OUT NOCOPY VARCHAR2,
365 x_maximum_credit_rcmd OUT NOCOPY NUMBER,
366 x_paydex_norm OUT NOCOPY VARCHAR2,
367 x_paydex_score OUT NOCOPY VARCHAR2,
368 x_paydex_three_months_ago OUT NOCOPY VARCHAR2,
369 x_credit_score_override_code OUT NOCOPY VARCHAR2,
370 x_cr_scr_clas_expl OUT NOCOPY VARCHAR2,
371 x_low_rng_delq_scr OUT NOCOPY NUMBER,
372 x_high_rng_delq_scr OUT NOCOPY NUMBER,
373 x_delq_pmt_rng_prcnt OUT NOCOPY NUMBER,
374 x_delq_pmt_pctg_for_all_firms OUT NOCOPY NUMBER,
375 x_num_trade_experiences OUT NOCOPY NUMBER,
376 x_paydex_firm_days OUT NOCOPY VARCHAR2,
377 x_paydex_firm_comment OUT NOCOPY VARCHAR2,
378 x_paydex_industry_days OUT NOCOPY VARCHAR2,
379 x_paydex_industry_comment OUT NOCOPY VARCHAR2,
380 x_paydex_comment OUT NOCOPY VARCHAR2,
381 x_suit_ind OUT NOCOPY VARCHAR2,
382 x_lien_ind OUT NOCOPY VARCHAR2,
383 x_judgement_ind OUT NOCOPY VARCHAR2,
384 x_bankruptcy_ind OUT NOCOPY VARCHAR2,
385 x_no_trade_ind OUT NOCOPY VARCHAR2,
386 x_prnt_hq_bkcy_ind OUT NOCOPY VARCHAR2,
387 x_num_prnt_bkcy_filing OUT NOCOPY NUMBER,
388 x_prnt_bkcy_filg_type OUT NOCOPY VARCHAR2,
389 x_prnt_bkcy_filg_chapter OUT NOCOPY NUMBER,
390 x_prnt_bkcy_filg_date OUT NOCOPY DATE,
391 x_num_prnt_bkcy_convs OUT NOCOPY NUMBER,
392 x_prnt_bkcy_conv_date OUT NOCOPY DATE,
393 x_prnt_bkcy_chapter_conv OUT NOCOPY VARCHAR2,
394 x_slow_trade_expl OUT NOCOPY VARCHAR2,
395 x_negv_pmt_expl OUT NOCOPY VARCHAR2,
396 x_pub_rec_expl OUT NOCOPY VARCHAR2,
397 x_business_discontinued OUT NOCOPY VARCHAR2,
398 x_spcl_event_comment OUT NOCOPY VARCHAR2,
399 x_num_spcl_event OUT NOCOPY NUMBER,
400 x_spcl_event_update_date OUT NOCOPY DATE,
401 x_spcl_evnt_txt OUT NOCOPY VARCHAR2,
402 x_failure_score OUT NOCOPY VARCHAR2,
403 x_failure_score_age OUT NOCOPY NUMBER,
404 x_failure_score_class OUT NOCOPY NUMBER,
405 x_failure_score_commentary OUT NOCOPY VARCHAR2,
406 x_failure_score_commentary2 OUT NOCOPY VARCHAR2,
407 x_failure_score_commentary3 OUT NOCOPY VARCHAR2,
408 x_failure_score_commentary4 OUT NOCOPY VARCHAR2,
409 x_failure_score_commentary5 OUT NOCOPY VARCHAR2,
410 x_failure_score_commentary6 OUT NOCOPY VARCHAR2,
411 x_failure_score_commentary7 OUT NOCOPY VARCHAR2,
412 x_failure_score_commentary8 OUT NOCOPY VARCHAR2,
413 x_failure_score_commentary9 OUT NOCOPY VARCHAR2,
414 x_failure_score_commentary10 OUT NOCOPY VARCHAR2,
415 x_failure_score_date OUT NOCOPY DATE,
416 x_failure_score_incd_default OUT NOCOPY NUMBER,
417 x_fail_score_natnl_percentile OUT NOCOPY NUMBER,
418 x_failure_score_override_code OUT NOCOPY VARCHAR2,
419 x_global_failure_score OUT NOCOPY VARCHAR2,
420 x_actual_content_source OUT NOCOPY VARCHAR2
421 );
422
423 PROCEDURE Delete_Row (
424 x_credit_rating_id IN NUMBER
425 );
426
427 END HZ_CREDIT_RATINGS_PKG;