[Home] [Help]
PACKAGE BODY: APPS.HZ_CREDIT_RATINGS_PKG
Source
1 PACKAGE BODY HZ_CREDIT_RATINGS_PKG as
2 /* $Header: ARHPCRTB.pls 120.11 2005/10/30 04:21:33 appldev ship $ */
3
4 g_miss_content_source_type CONSTANT VARCHAR2(30) := 'USER_ENTERED';
5
6 PROCEDURE Insert_Row (
7 x_rowid IN OUT NOCOPY VARCHAR2,
8 x_credit_rating_id IN OUT NOCOPY NUMBER,
9 x_description IN VARCHAR2,
10 x_party_id IN NUMBER,
11 x_rating IN VARCHAR2,
12 x_rated_as_of_date IN DATE,
13 x_rating_organization IN VARCHAR2,
14 x_comments IN VARCHAR2,
15 x_det_history_ind IN VARCHAR2,
16 x_fincl_embt_ind IN VARCHAR2,
17 x_criminal_proceeding_ind IN VARCHAR2,
18 x_suit_judge_ind IN VARCHAR2,
19 x_claims_ind IN VARCHAR2,
20 x_secured_flng_ind IN VARCHAR2,
21 x_fincl_lgl_event_ind IN VARCHAR2,
22 x_disaster_ind IN VARCHAR2,
23 x_oprg_spec_evnt_ind IN VARCHAR2,
24 x_other_spec_evnt_ind IN VARCHAR2,
25 x_content_source_type IN VARCHAR2,
26 x_status IN VARCHAR2,
27 x_object_version_number IN NUMBER,
28 x_created_by_module IN VARCHAR2,
29 x_avg_high_credit IN NUMBER,
30 x_credit_score IN VARCHAR2,
31 x_credit_score_age IN NUMBER,
32 x_credit_score_class IN NUMBER,
33 x_credit_score_commentary IN VARCHAR2,
34 x_credit_score_commentary2 IN VARCHAR2,
35 x_credit_score_commentary3 IN VARCHAR2,
36 x_credit_score_commentary4 IN VARCHAR2,
37 x_credit_score_commentary5 IN VARCHAR2,
38 x_credit_score_commentary6 IN VARCHAR2,
39 x_credit_score_commentary7 IN VARCHAR2,
40 x_credit_score_commentary8 IN VARCHAR2,
41 x_credit_score_commentary9 IN VARCHAR2,
42 x_credit_score_commentary10 IN VARCHAR2,
43 x_credit_score_date IN DATE,
44 x_credit_score_incd_default IN NUMBER,
45 x_credit_score_natl_percentile IN NUMBER,
46 x_debarment_ind IN VARCHAR2,
47 x_debarments_count IN NUMBER,
48 x_debarments_date IN DATE,
49 x_high_credit IN NUMBER,
50 x_maximum_credit_currency_code IN VARCHAR2,
51 x_maximum_credit_rcmd IN NUMBER,
52 x_paydex_norm IN VARCHAR2,
53 x_paydex_score IN VARCHAR2,
54 x_paydex_three_months_ago IN VARCHAR2,
55 x_credit_score_override_code IN VARCHAR2,
56 x_cr_scr_clas_expl IN VARCHAR2,
57 x_low_rng_delq_scr IN NUMBER,
58 x_high_rng_delq_scr IN NUMBER,
59 x_delq_pmt_rng_prcnt IN NUMBER,
60 x_delq_pmt_pctg_for_all_firms IN NUMBER,
61 x_num_trade_experiences IN NUMBER,
62 x_paydex_firm_days IN VARCHAR2,
63 x_paydex_firm_comment IN VARCHAR2,
64 x_paydex_industry_days IN VARCHAR2,
65 x_paydex_industry_comment IN VARCHAR2,
66 x_paydex_comment IN VARCHAR2,
67 x_suit_ind IN VARCHAR2,
68 x_lien_ind IN VARCHAR2,
69 x_judgement_ind IN VARCHAR2,
70 x_bankruptcy_ind IN VARCHAR2,
71 x_no_trade_ind IN VARCHAR2,
72 x_prnt_hq_bkcy_ind IN VARCHAR2,
73 x_num_prnt_bkcy_filing IN NUMBER,
74 x_prnt_bkcy_filg_type IN VARCHAR2,
75 x_prnt_bkcy_filg_chapter IN NUMBER,
76 x_prnt_bkcy_filg_date IN DATE,
77 x_num_prnt_bkcy_convs IN NUMBER,
78 x_prnt_bkcy_conv_date IN DATE,
79 x_prnt_bkcy_chapter_conv IN VARCHAR2,
80 x_slow_trade_expl IN VARCHAR2,
81 x_negv_pmt_expl IN VARCHAR2,
82 x_pub_rec_expl IN VARCHAR2,
83 x_business_discontinued IN VARCHAR2,
84 x_spcl_event_comment IN VARCHAR2,
85 x_num_spcl_event IN NUMBER,
86 x_spcl_event_update_date IN DATE,
87 x_spcl_evnt_txt IN VARCHAR2,
88 x_failure_score IN VARCHAR2,
89 x_failure_score_age IN NUMBER,
90 x_failure_score_class IN NUMBER,
91 x_failure_score_commentary IN VARCHAR2,
92 x_failure_score_commentary2 IN VARCHAR2,
93 x_failure_score_commentary3 IN VARCHAR2,
94 x_failure_score_commentary4 IN VARCHAR2,
95 x_failure_score_commentary5 IN VARCHAR2,
96 x_failure_score_commentary6 IN VARCHAR2,
97 x_failure_score_commentary7 IN VARCHAR2,
98 x_failure_score_commentary8 IN VARCHAR2,
99 x_failure_score_commentary9 IN VARCHAR2,
100 x_failure_score_commentary10 IN VARCHAR2,
101 x_failure_score_date IN DATE,
102 x_failure_score_incd_default IN NUMBER,
103 x_fail_score_natnl_percentile IN NUMBER,
104 x_failure_score_override_code IN VARCHAR2,
105 x_global_failure_score IN VARCHAR2,
106 x_actual_content_source IN VARCHAR2
107 ) IS
108
109 l_success VARCHAR2(1) := 'N';
110
111 BEGIN
112
113 WHILE l_success = 'N' LOOP
114 BEGIN
115 INSERT INTO HZ_CREDIT_RATINGS (
116 credit_rating_id,
117 description,
118 party_id,
119 rating,
120 rated_as_of_date,
121 rating_organization,
122 created_by,
123 creation_date,
124 last_update_login,
125 last_update_date,
126 last_updated_by,
127 request_id,
128 program_application_id,
129 program_id,
130 program_update_date,
131 wh_update_date,
132 comments,
133 det_history_ind,
134 fincl_embt_ind,
135 criminal_proceeding_ind,
136 suit_judge_ind,
137 claims_ind,
138 secured_flng_ind,
139 fincl_lgl_event_ind,
140 disaster_ind,
141 oprg_spec_evnt_ind,
142 other_spec_evnt_ind,
143 content_source_type,
144 status,
145 object_version_number,
146 created_by_module,
147 application_id,
148 avg_high_credit,
149 credit_score,
150 credit_score_age,
151 credit_score_class,
152 credit_score_commentary,
153 credit_score_commentary2,
154 credit_score_commentary3,
155 credit_score_commentary4,
156 credit_score_commentary5,
157 credit_score_commentary6,
158 credit_score_commentary7,
159 credit_score_commentary8,
160 credit_score_commentary9,
161 credit_score_commentary10,
162 credit_score_date,
163 credit_score_incd_default,
164 credit_score_natl_percentile,
165 debarment_ind,
166 debarments_count,
167 debarments_date,
168 high_credit,
169 maximum_credit_currency_code,
170 maximum_credit_recommendation,
171 paydex_norm,
172 paydex_score,
173 paydex_three_months_ago,
174 credit_score_override_code,
175 cr_scr_clas_expl,
176 low_rng_delq_scr,
177 high_rng_delq_scr,
178 delq_pmt_rng_prcnt,
179 delq_pmt_pctg_for_all_firms,
180 num_trade_experiences,
181 paydex_firm_days,
182 paydex_firm_comment,
183 paydex_industry_days,
184 paydex_industry_comment,
185 paydex_comment,
186 suit_ind,
187 lien_ind,
188 judgement_ind,
189 bankruptcy_ind,
190 no_trade_ind,
191 prnt_hq_bkcy_ind,
192 num_prnt_bkcy_filing,
193 prnt_bkcy_filg_type,
194 prnt_bkcy_filg_chapter,
195 prnt_bkcy_filg_date,
196 num_prnt_bkcy_convs,
197 prnt_bkcy_conv_date,
198 prnt_bkcy_chapter_conv,
199 slow_trade_expl,
200 negv_pmt_expl,
201 pub_rec_expl,
202 business_discontinued,
203 spcl_event_comment,
204 num_spcl_event,
205 spcl_event_update_date,
206 spcl_evnt_txt,
207 failure_score,
208 failure_score_age,
209 failure_score_class,
210 failure_score_commentary,
211 failure_score_commentary2,
212 failure_score_commentary3,
213 failure_score_commentary4,
214 failure_score_commentary5,
215 failure_score_commentary6,
216 failure_score_commentary7,
217 failure_score_commentary8,
218 failure_score_commentary9,
219 failure_score_commentary10,
220 failure_score_date,
221 failure_score_incd_default,
222 failure_score_natnl_percentile,
223 failure_score_override_code,
224 global_failure_score,
225 actual_content_source
226 )
227 VALUES (
228 DECODE(x_credit_rating_id,
229 FND_API.G_MISS_NUM, HZ_CREDIT_RATINGS_S.NEXTVAL,
230 NULL, HZ_CREDIT_RATINGS_S.NEXTVAL,
231 x_credit_rating_id),
232 DECODE(x_description,
233 FND_API.G_MISS_CHAR, NULL,
234 x_description),
235 DECODE(x_party_id,
236 FND_API.G_MISS_NUM, NULL,
237 x_party_id),
238 DECODE(x_rating,
239 FND_API.G_MISS_CHAR, NULL,
240 x_rating),
241 --Bug 3090928
242 trunc(DECODE(x_rated_as_of_date,
243 FND_API.G_MISS_DATE, TO_DATE(NULL),
244 x_rated_as_of_date)),
245 DECODE(x_rating_organization,
246 FND_API.G_MISS_CHAR, NULL,
247 x_rating_organization),
248 hz_utility_v2pub.created_by,
249 hz_utility_v2pub.creation_date,
250 hz_utility_v2pub.last_update_login,
251 hz_utility_v2pub.last_update_date,
252 hz_utility_v2pub.last_updated_by,
253 hz_utility_v2pub.request_id,
254 hz_utility_v2pub.program_application_id,
255 hz_utility_v2pub.program_id,
256 hz_utility_v2pub.program_update_date,
257 FND_API.G_MISS_DATE,
258 DECODE(x_comments,
259 FND_API.G_MISS_CHAR, NULL,
260 x_comments),
261 DECODE(x_det_history_ind,
262 FND_API.G_MISS_CHAR, NULL,
263 x_det_history_ind),
264 DECODE(x_fincl_embt_ind,
265 FND_API.G_MISS_CHAR, NULL,
266 x_fincl_embt_ind),
267 DECODE(x_criminal_proceeding_ind,
268 FND_API.G_MISS_CHAR, NULL,
269 x_criminal_proceeding_ind),
270 DECODE(x_suit_judge_ind,
271 FND_API.G_MISS_CHAR, NULL,
272 x_suit_judge_ind),
273 DECODE(x_claims_ind,
274 FND_API.G_MISS_CHAR, NULL,
275 x_claims_ind),
276 DECODE(x_secured_flng_ind,
277 FND_API.G_MISS_CHAR, NULL,
278 x_secured_flng_ind),
279 DECODE(x_fincl_lgl_event_ind,
280 FND_API.G_MISS_CHAR, NULL,
281 x_fincl_lgl_event_ind),
282 DECODE(x_disaster_ind,
283 FND_API.G_MISS_CHAR, NULL,
284 x_disaster_ind),
285 DECODE(x_oprg_spec_evnt_ind,
286 FND_API.G_MISS_CHAR, NULL,
287 x_oprg_spec_evnt_ind),
288 DECODE(x_other_spec_evnt_ind,
289 FND_API.G_MISS_CHAR, NULL,
290 x_other_spec_evnt_ind),
291 DECODE(x_content_source_type,
292 FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
293 NULL, G_MISS_CONTENT_SOURCE_TYPE,
294 x_content_source_type),
295 DECODE(x_status,
296 FND_API.G_MISS_CHAR, 'A',
297 NULL, 'A',
298 x_status),
299 DECODE(x_object_version_number,
300 FND_API.G_MISS_NUM, NULL,
301 x_object_version_number),
302 DECODE(x_created_by_module,
303 FND_API.G_MISS_CHAR, NULL,
304 x_created_by_module),
305 hz_utility_v2pub.application_id,
306 DECODE(x_avg_high_credit,
307 FND_API.G_MISS_NUM, NULL,
308 x_avg_high_credit),
309 DECODE(x_credit_score,
310 FND_API.G_MISS_CHAR, NULL,
311 x_credit_score),
312 DECODE(x_credit_score_age,
313 FND_API.G_MISS_NUM, NULL,
314 x_credit_score_age),
315 DECODE(x_credit_score_class,
316 FND_API.G_MISS_NUM, NULL,
317 x_credit_score_class),
318 DECODE(x_credit_score_commentary,
319 FND_API.G_MISS_CHAR, NULL,
320 x_credit_score_commentary),
321 DECODE(x_credit_score_commentary2,
322 FND_API.G_MISS_CHAR, NULL,
323 x_credit_score_commentary2),
324 DECODE(x_credit_score_commentary3,
325 FND_API.G_MISS_CHAR, NULL,
326 x_credit_score_commentary3),
327 DECODE(x_credit_score_commentary4,
328 FND_API.G_MISS_CHAR, NULL,
329 x_credit_score_commentary4),
330 DECODE(x_credit_score_commentary5,
331 FND_API.G_MISS_CHAR, NULL,
332 x_credit_score_commentary5),
333 DECODE(x_credit_score_commentary6,
334 FND_API.G_MISS_CHAR, NULL,
335 x_credit_score_commentary6),
336 DECODE(x_credit_score_commentary7,
337 FND_API.G_MISS_CHAR, NULL,
338 x_credit_score_commentary7),
339 DECODE(x_credit_score_commentary8,
340 FND_API.G_MISS_CHAR, NULL,
341 x_credit_score_commentary8),
342 DECODE(x_credit_score_commentary9,
343 FND_API.G_MISS_CHAR, NULL,
344 x_credit_score_commentary9),
345 DECODE(x_credit_score_commentary10,
346 FND_API.G_MISS_CHAR, NULL,
347 x_credit_score_commentary10),
348 DECODE(x_credit_score_date,
349 FND_API.G_MISS_DATE, TO_DATE(NULL),
350 x_credit_score_date),
351 DECODE(x_credit_score_incd_default,
352 FND_API.G_MISS_NUM, NULL,
353 x_credit_score_incd_default),
354 DECODE(x_credit_score_natl_percentile,
355 FND_API.G_MISS_NUM, NULL,
356 x_credit_score_natl_percentile),
357 DECODE(x_debarment_ind,
358 FND_API.G_MISS_CHAR, NULL,
359 x_debarment_ind),
360 DECODE(x_debarments_count,
361 FND_API.G_MISS_NUM, NULL,
362 x_debarments_count),
363 DECODE(x_debarments_date,
364 FND_API.G_MISS_DATE, TO_DATE(NULL),
365 x_debarments_date),
366 DECODE(x_high_credit,
367 FND_API.G_MISS_NUM, NULL,
368 x_high_credit),
369 DECODE(x_maximum_credit_currency_code,
370 FND_API.G_MISS_CHAR, NULL,
371 x_maximum_credit_currency_code),
372 DECODE(x_maximum_credit_rcmd,
373 FND_API.G_MISS_NUM, NULL,
374 x_maximum_credit_rcmd),
375 DECODE(x_paydex_norm,
376 FND_API.G_MISS_CHAR, NULL,
377 x_paydex_norm),
378 DECODE(x_paydex_score,
379 FND_API.G_MISS_CHAR, NULL,
380 x_paydex_score),
381 DECODE(x_paydex_three_months_ago,
382 FND_API.G_MISS_CHAR, NULL,
383 x_paydex_three_months_ago),
384 DECODE(x_credit_score_override_code,
385 FND_API.G_MISS_CHAR, NULL,
386 x_credit_score_override_code),
387 DECODE(x_cr_scr_clas_expl,
388 FND_API.G_MISS_CHAR, NULL,
389 x_cr_scr_clas_expl),
390 DECODE(x_low_rng_delq_scr,
391 FND_API.G_MISS_NUM, NULL,
392 x_low_rng_delq_scr),
393 DECODE(x_high_rng_delq_scr,
394 FND_API.G_MISS_NUM, NULL,
395 x_high_rng_delq_scr),
396 DECODE(x_delq_pmt_rng_prcnt,
397 FND_API.G_MISS_NUM, NULL,
398 x_delq_pmt_rng_prcnt),
399 DECODE(x_delq_pmt_pctg_for_all_firms,
400 FND_API.G_MISS_NUM, NULL,
401 x_delq_pmt_pctg_for_all_firms),
402 DECODE(x_num_trade_experiences,
403 FND_API.G_MISS_NUM, NULL,
404 x_num_trade_experiences),
405 DECODE(x_paydex_firm_days,
406 FND_API.G_MISS_CHAR, NULL,
407 x_paydex_firm_days),
408 DECODE(x_paydex_firm_comment,
409 FND_API.G_MISS_CHAR, NULL,
410 x_paydex_firm_comment),
411 DECODE(x_paydex_industry_days,
412 FND_API.G_MISS_CHAR, NULL,
413 x_paydex_industry_days),
414 DECODE(x_paydex_industry_comment,
415 FND_API.G_MISS_CHAR, NULL,
416 x_paydex_industry_comment),
417 DECODE(x_paydex_comment,
418 FND_API.G_MISS_CHAR, NULL,
419 x_paydex_comment),
420 DECODE(x_suit_ind,
421 FND_API.G_MISS_CHAR, NULL,
422 x_suit_ind),
423 DECODE(x_lien_ind,
424 FND_API.G_MISS_CHAR, NULL,
425 x_lien_ind),
426 DECODE(x_judgement_ind,
427 FND_API.G_MISS_CHAR, NULL,
428 x_judgement_ind),
429 DECODE(x_bankruptcy_ind,
430 FND_API.G_MISS_CHAR, NULL,
431 x_bankruptcy_ind),
432 DECODE(x_no_trade_ind,
433 FND_API.G_MISS_CHAR, NULL,
434 x_no_trade_ind),
435 DECODE(x_prnt_hq_bkcy_ind,
436 FND_API.G_MISS_CHAR, NULL,
437 x_prnt_hq_bkcy_ind),
438 DECODE(x_num_prnt_bkcy_filing,
439 FND_API.G_MISS_NUM, NULL,
440 x_num_prnt_bkcy_filing),
441 DECODE(x_prnt_bkcy_filg_type,
442 FND_API.G_MISS_CHAR, NULL,
443 x_prnt_bkcy_filg_type),
444 DECODE(x_prnt_bkcy_filg_chapter,
445 FND_API.G_MISS_NUM, NULL,
446 x_prnt_bkcy_filg_chapter),
447 DECODE(x_prnt_bkcy_filg_date,
448 FND_API.G_MISS_DATE, TO_DATE(NULL),
449 x_prnt_bkcy_filg_date),
450 DECODE(x_num_prnt_bkcy_convs,
451 FND_API.G_MISS_NUM, NULL,
452 x_num_prnt_bkcy_convs),
453 DECODE(x_prnt_bkcy_conv_date,
454 FND_API.G_MISS_DATE, TO_DATE(NULL),
455 x_prnt_bkcy_conv_date),
456 DECODE(x_prnt_bkcy_chapter_conv,
457 FND_API.G_MISS_CHAR, NULL,
458 x_prnt_bkcy_chapter_conv),
459 DECODE(x_slow_trade_expl,
460 FND_API.G_MISS_CHAR, NULL,
461 x_slow_trade_expl),
462 DECODE(x_negv_pmt_expl,
463 FND_API.G_MISS_CHAR, NULL,
464 x_negv_pmt_expl),
465 DECODE(x_pub_rec_expl,
466 FND_API.G_MISS_CHAR, NULL,
467 x_pub_rec_expl),
468 DECODE(x_business_discontinued,
469 FND_API.G_MISS_CHAR, NULL,
470 x_business_discontinued),
471 DECODE(x_spcl_event_comment,
472 FND_API.G_MISS_CHAR, NULL,
473 x_spcl_event_comment),
474 DECODE(x_num_spcl_event,
475 FND_API.G_MISS_NUM, NULL,
476 x_num_spcl_event),
477 DECODE(x_spcl_event_update_date,
478 FND_API.G_MISS_DATE, TO_DATE(NULL),
479 x_spcl_event_update_date),
480 DECODE(x_spcl_evnt_txt,
481 FND_API.G_MISS_CHAR, NULL,
482 x_spcl_evnt_txt),
483 DECODE(x_failure_score,
484 FND_API.G_MISS_CHAR, NULL,
485 x_failure_score),
486 DECODE(x_failure_score_age,
487 FND_API.G_MISS_NUM, NULL,
488 x_failure_score_age),
489 DECODE(x_failure_score_class,
490 FND_API.G_MISS_NUM, NULL,
491 x_failure_score_class),
492 DECODE(x_failure_score_commentary,
493 FND_API.G_MISS_CHAR, NULL,
494 x_failure_score_commentary),
495 DECODE(x_failure_score_commentary2,
496 FND_API.G_MISS_CHAR, NULL,
497 x_failure_score_commentary2),
498 DECODE(x_failure_score_commentary3,
499 FND_API.G_MISS_CHAR, NULL,
500 x_failure_score_commentary3),
501 DECODE(x_failure_score_commentary4,
502 FND_API.G_MISS_CHAR, NULL,
503 x_failure_score_commentary4),
504 DECODE(x_failure_score_commentary5,
505 FND_API.G_MISS_CHAR, NULL,
506 x_failure_score_commentary5),
507 DECODE(x_failure_score_commentary6,
508 FND_API.G_MISS_CHAR, NULL,
509 x_failure_score_commentary6),
510 DECODE(x_failure_score_commentary7,
511 FND_API.G_MISS_CHAR, NULL,
512 x_failure_score_commentary7),
513 DECODE(x_failure_score_commentary8,
514 FND_API.G_MISS_CHAR, NULL,
515 x_failure_score_commentary8),
516 DECODE(x_failure_score_commentary9,
517 FND_API.G_MISS_CHAR, NULL,
518 x_failure_score_commentary9),
519 DECODE(x_failure_score_commentary10,
520 FND_API.G_MISS_CHAR, NULL,
521 x_failure_score_commentary10),
522 DECODE(x_failure_score_date,
523 FND_API.G_MISS_DATE, TO_DATE(NULL),
524 x_failure_score_date),
525 DECODE(x_failure_score_incd_default,
526 FND_API.G_MISS_NUM, NULL,
527 x_failure_score_incd_default),
528 DECODE(x_fail_score_natnl_percentile,
529 FND_API.G_MISS_NUM, NULL,
530 x_fail_score_natnl_percentile),
531 DECODE(x_failure_score_override_code,
532 FND_API.G_MISS_CHAR, NULL,
533 x_failure_score_override_code),
534 DECODE(x_global_failure_score,
535 FND_API.G_MISS_CHAR, NULL,
536 x_global_failure_score),
537 DECODE(x_actual_content_source,
538 FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
539 NULL, G_MISS_CONTENT_SOURCE_TYPE,
540 x_actual_content_source)
541 ) RETURNING
542 rowid,
543 credit_rating_id
544 INTO
545 x_rowid,
546 x_credit_rating_id;
547
548 l_success := 'Y';
549
550 EXCEPTION
551 WHEN DUP_VAL_ON_INDEX THEN
552 IF INSTR(SQLERRM, 'HZ_CREDIT_RATINGS_U1') <> 0 THEN
553 DECLARE
554 l_count NUMBER;
555 l_dummy VARCHAR2(1);
556 BEGIN
557 l_count := 1;
558 WHILE l_count > 0 LOOP
559 SELECT HZ_CREDIT_RATINGS_S.NEXTVAL
560 INTO x_credit_rating_id FROM dual;
561 BEGIN
562 SELECT 'Y' INTO l_dummy
563 FROM HZ_CREDIT_RATINGS
564 WHERE credit_rating_id = x_credit_rating_id;
565 l_count := 1;
566 EXCEPTION
567 WHEN NO_DATA_FOUND THEN
568 l_count := 0;
569 END;
570 END LOOP;
571 END;
572 END IF;
573 --Bug 3090928
574 IF INSTR(SQLERRM,'HZ_CREDIT_RATINGS_U2') <> 0 THEN
575 fnd_message.set_name('AR', 'HZ_API_DUP_CREDIT_RATING_REC');
576 fnd_msg_pub.add;
577 RAISE FND_API.G_EXC_ERROR;
578 END IF;
579 END;
580 END LOOP;
581
582 END Insert_Row;
583
584 PROCEDURE Update_Row (
585 x_rowid IN OUT NOCOPY VARCHAR2,
586 x_credit_rating_id IN NUMBER,
587 x_description IN VARCHAR2,
588 x_party_id IN NUMBER,
589 x_rating IN VARCHAR2,
590 x_rated_as_of_date IN DATE,
591 x_rating_organization IN VARCHAR2,
592 x_comments IN VARCHAR2,
593 x_det_history_ind IN VARCHAR2,
594 x_fincl_embt_ind IN VARCHAR2,
595 x_criminal_proceeding_ind IN VARCHAR2,
596 x_suit_judge_ind IN VARCHAR2,
597 x_claims_ind IN VARCHAR2,
598 x_secured_flng_ind IN VARCHAR2,
599 x_fincl_lgl_event_ind IN VARCHAR2,
600 x_disaster_ind IN VARCHAR2,
601 x_oprg_spec_evnt_ind IN VARCHAR2,
602 x_other_spec_evnt_ind IN VARCHAR2,
603 x_content_source_type IN VARCHAR2,
604 x_status IN VARCHAR2,
605 x_object_version_number IN NUMBER,
606 x_created_by_module IN VARCHAR2,
607 x_avg_high_credit IN NUMBER,
608 x_credit_score IN VARCHAR2,
609 x_credit_score_age IN NUMBER,
610 x_credit_score_class IN NUMBER,
611 x_credit_score_commentary IN VARCHAR2,
612 x_credit_score_commentary2 IN VARCHAR2,
613 x_credit_score_commentary3 IN VARCHAR2,
614 x_credit_score_commentary4 IN VARCHAR2,
615 x_credit_score_commentary5 IN VARCHAR2,
616 x_credit_score_commentary6 IN VARCHAR2,
617 x_credit_score_commentary7 IN VARCHAR2,
618 x_credit_score_commentary8 IN VARCHAR2,
619 x_credit_score_commentary9 IN VARCHAR2,
620 x_credit_score_commentary10 IN VARCHAR2,
621 x_credit_score_date IN DATE,
622 x_credit_score_incd_default IN NUMBER,
623 x_credit_score_natl_percentile IN NUMBER,
624 x_debarment_ind IN VARCHAR2,
625 x_debarments_count IN NUMBER,
626 x_debarments_date IN DATE,
627 x_high_credit IN NUMBER,
628 x_maximum_credit_currency_code IN VARCHAR2,
629 x_maximum_credit_rcmd IN NUMBER,
630 x_paydex_norm IN VARCHAR2,
631 x_paydex_score IN VARCHAR2,
632 x_paydex_three_months_ago IN VARCHAR2,
633 x_credit_score_override_code IN VARCHAR2,
634 x_cr_scr_clas_expl IN VARCHAR2,
635 x_low_rng_delq_scr IN NUMBER,
636 x_high_rng_delq_scr IN NUMBER,
637 x_delq_pmt_rng_prcnt IN NUMBER,
638 x_delq_pmt_pctg_for_all_firms IN NUMBER,
639 x_num_trade_experiences IN NUMBER,
640 x_paydex_firm_days IN VARCHAR2,
641 x_paydex_firm_comment IN VARCHAR2,
642 x_paydex_industry_days IN VARCHAR2,
643 x_paydex_industry_comment IN VARCHAR2,
644 x_paydex_comment IN VARCHAR2,
645 x_suit_ind IN VARCHAR2,
646 x_lien_ind IN VARCHAR2,
647 x_judgement_ind IN VARCHAR2,
648 x_bankruptcy_ind IN VARCHAR2,
649 x_no_trade_ind IN VARCHAR2,
650 x_prnt_hq_bkcy_ind IN VARCHAR2,
651 x_num_prnt_bkcy_filing IN NUMBER,
652 x_prnt_bkcy_filg_type IN VARCHAR2,
653 x_prnt_bkcy_filg_chapter IN NUMBER,
654 x_prnt_bkcy_filg_date IN DATE,
655 x_num_prnt_bkcy_convs IN NUMBER,
656 x_prnt_bkcy_conv_date IN DATE,
657 x_prnt_bkcy_chapter_conv IN VARCHAR2,
658 x_slow_trade_expl IN VARCHAR2,
659 x_negv_pmt_expl IN VARCHAR2,
660 x_pub_rec_expl IN VARCHAR2,
661 x_business_discontinued IN VARCHAR2,
662 x_spcl_event_comment IN VARCHAR2,
663 x_num_spcl_event IN NUMBER,
664 x_spcl_event_update_date IN DATE,
665 x_spcl_evnt_txt IN VARCHAR2,
666 x_failure_score IN VARCHAR2,
667 x_failure_score_age IN NUMBER,
668 x_failure_score_class IN NUMBER,
669 x_failure_score_commentary IN VARCHAR2,
670 x_failure_score_commentary2 IN VARCHAR2,
671 x_failure_score_commentary3 IN VARCHAR2,
672 x_failure_score_commentary4 IN VARCHAR2,
673 x_failure_score_commentary5 IN VARCHAR2,
674 x_failure_score_commentary6 IN VARCHAR2,
675 x_failure_score_commentary7 IN VARCHAR2,
676 x_failure_score_commentary8 IN VARCHAR2,
677 x_failure_score_commentary9 IN VARCHAR2,
678 x_failure_score_commentary10 IN VARCHAR2,
679 x_failure_score_date IN DATE,
680 x_failure_score_incd_default IN NUMBER,
681 x_fail_score_natnl_percentile IN NUMBER,
682 x_failure_score_override_code IN VARCHAR2,
683 x_global_failure_score IN VARCHAR2,
684 x_actual_content_source IN VARCHAR2
685 ) IS
686 BEGIN
687
688 UPDATE HZ_CREDIT_RATINGS
689 SET
690 credit_rating_id =
691 DECODE(x_credit_rating_id,
692 NULL, credit_rating_id,
693 FND_API.G_MISS_NUM, NULL,
694 x_credit_rating_id),
695 description =
696 DECODE(x_description,
697 NULL, description,
698 FND_API.G_MISS_CHAR, NULL,
699 x_description),
700 party_id =
701 DECODE(x_party_id,
702 NULL, party_id,
703 FND_API.G_MISS_NUM, NULL,
704 x_party_id),
705 rating =
706 DECODE(x_rating,
707 NULL, rating,
708 FND_API.G_MISS_CHAR, NULL,
709 x_rating),
710 rated_as_of_date =
711 --Bug 3090928
712 trunc( DECODE(x_rated_as_of_date,
713 NULL, rated_as_of_date,
714 FND_API.G_MISS_DATE, NULL,
715 x_rated_as_of_date)),
716 rating_organization =
717 DECODE(x_rating_organization,
718 NULL, rating_organization,
719 FND_API.G_MISS_CHAR, NULL,
720 x_rating_organization),
721 created_by = created_by,
722 creation_date = creation_date,
723 last_update_login = hz_utility_v2pub.last_update_login,
724 last_update_date = hz_utility_v2pub.last_update_date,
725 last_updated_by = hz_utility_v2pub.last_updated_by,
726 request_id = hz_utility_v2pub.request_id,
727 program_application_id = hz_utility_v2pub.program_application_id,
728 program_id = hz_utility_v2pub.program_id,
729 wh_update_date = FND_API.G_MISS_DATE,
730 comments =
731 DECODE(x_comments,
732 NULL, comments,
733 FND_API.G_MISS_CHAR, NULL,
734 x_comments),
735 det_history_ind =
736 DECODE(x_det_history_ind,
737 NULL, det_history_ind,
738 FND_API.G_MISS_CHAR, NULL,
739 x_det_history_ind),
740 fincl_embt_ind =
741 DECODE(x_fincl_embt_ind,
742 NULL, fincl_embt_ind,
743 FND_API.G_MISS_CHAR, NULL,
744 x_fincl_embt_ind),
745 criminal_proceeding_ind =
746 DECODE(x_criminal_proceeding_ind,
747 NULL, criminal_proceeding_ind,
748 FND_API.G_MISS_CHAR, NULL,
749 x_criminal_proceeding_ind),
750 suit_judge_ind =
751 DECODE(x_suit_judge_ind,
752 NULL, suit_judge_ind,
753 FND_API.G_MISS_CHAR, NULL,
754 x_suit_judge_ind),
755 claims_ind =
756 DECODE(x_claims_ind,
757 NULL, claims_ind,
758 FND_API.G_MISS_CHAR, NULL,
759 x_claims_ind),
760 secured_flng_ind =
761 DECODE(x_secured_flng_ind,
762 NULL, secured_flng_ind,
763 FND_API.G_MISS_CHAR, NULL,
764 x_secured_flng_ind),
765 fincl_lgl_event_ind =
766 DECODE(x_fincl_lgl_event_ind,
767 NULL, fincl_lgl_event_ind,
768 FND_API.G_MISS_CHAR, NULL,
769 x_fincl_lgl_event_ind),
770 disaster_ind =
771 DECODE(x_disaster_ind,
772 NULL, disaster_ind,
773 FND_API.G_MISS_CHAR, NULL,
774 x_disaster_ind),
775 oprg_spec_evnt_ind =
776 DECODE(x_oprg_spec_evnt_ind,
777 NULL, oprg_spec_evnt_ind,
778 FND_API.G_MISS_CHAR, NULL,
779 x_oprg_spec_evnt_ind),
780 other_spec_evnt_ind =
781 DECODE(x_other_spec_evnt_ind,
782 NULL, other_spec_evnt_ind,
783 FND_API.G_MISS_CHAR, NULL,
784 x_other_spec_evnt_ind),
785 content_source_type =
786 DECODE(x_content_source_type,
787 NULL, G_MISS_CONTENT_SOURCE_TYPE,
788 FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
789 x_content_source_type),
790 program_update_date = hz_utility_v2pub.program_update_date,
791 status =
792 DECODE(x_status,
793 NULL, status,
794 FND_API.G_MISS_CHAR, NULL,
795 x_status),
796 object_version_number =
797 DECODE(x_object_version_number,
798 NULL, object_version_number,
799 FND_API.G_MISS_NUM, NULL,
800 x_object_version_number),
801 created_by_module =
802 DECODE(x_created_by_module,
803 NULL, created_by_module,
804 FND_API.G_MISS_CHAR, NULL,
805 x_created_by_module),
806 application_id = hz_utility_v2pub.application_id,
807 avg_high_credit =
808 DECODE(x_avg_high_credit,
809 NULL, avg_high_credit,
810 FND_API.G_MISS_NUM, NULL,
811 x_avg_high_credit),
812 credit_score =
813 DECODE(x_credit_score,
814 NULL, credit_score,
815 FND_API.G_MISS_CHAR, NULL,
816 x_credit_score),
817 credit_score_age =
818 DECODE(x_credit_score_age,
819 NULL, credit_score_age,
820 FND_API.G_MISS_NUM, NULL,
821 x_credit_score_age),
822 credit_score_class =
823 DECODE(x_credit_score_class,
824 NULL, credit_score_class,
825 FND_API.G_MISS_NUM, NULL,
826 x_credit_score_class),
827 credit_score_commentary =
828 DECODE(x_credit_score_commentary,
829 NULL, credit_score_commentary,
830 FND_API.G_MISS_CHAR, NULL,
831 x_credit_score_commentary),
832 credit_score_commentary2 =
833 DECODE(x_credit_score_commentary2,
834 NULL, credit_score_commentary2,
835 FND_API.G_MISS_CHAR, NULL,
836 x_credit_score_commentary2),
837 credit_score_commentary3 =
838 DECODE(x_credit_score_commentary3,
839 NULL, credit_score_commentary3,
840 FND_API.G_MISS_CHAR, NULL,
841 x_credit_score_commentary3),
842 credit_score_commentary4 =
843 DECODE(x_credit_score_commentary4,
844 NULL, credit_score_commentary4,
845 FND_API.G_MISS_CHAR, NULL,
846 x_credit_score_commentary4),
847 credit_score_commentary5 =
848 DECODE(x_credit_score_commentary5,
849 NULL, credit_score_commentary5,
850 FND_API.G_MISS_CHAR, NULL,
851 x_credit_score_commentary5),
852 credit_score_commentary6 =
853 DECODE(x_credit_score_commentary6,
854 NULL, credit_score_commentary6,
855 FND_API.G_MISS_CHAR, NULL,
856 x_credit_score_commentary6),
857 credit_score_commentary7 =
858 DECODE(x_credit_score_commentary7,
859 NULL, credit_score_commentary7,
860 FND_API.G_MISS_CHAR, NULL,
861 x_credit_score_commentary7),
862 credit_score_commentary8 =
863 DECODE(x_credit_score_commentary8,
864 NULL, credit_score_commentary8,
865 FND_API.G_MISS_CHAR, NULL,
866 x_credit_score_commentary8),
867 credit_score_commentary9 =
868 DECODE(x_credit_score_commentary9,
869 NULL, credit_score_commentary9,
870 FND_API.G_MISS_CHAR, NULL,
871 x_credit_score_commentary9),
872 credit_score_commentary10 =
873 DECODE(x_credit_score_commentary10,
874 NULL, credit_score_commentary10,
875 FND_API.G_MISS_CHAR, NULL,
876 x_credit_score_commentary10),
877 credit_score_date =
878 DECODE(x_credit_score_date,
879 NULL, credit_score_date,
880 FND_API.G_MISS_DATE, NULL,
881 x_credit_score_date),
882 credit_score_incd_default =
883 DECODE(x_credit_score_incd_default,
884 NULL, credit_score_incd_default,
885 FND_API.G_MISS_NUM, NULL,
886 x_credit_score_incd_default),
887 credit_score_natl_percentile =
888 DECODE(x_credit_score_natl_percentile,
889 NULL, credit_score_natl_percentile,
890 FND_API.G_MISS_NUM, NULL,
891 x_credit_score_natl_percentile),
892 debarment_ind =
893 DECODE(x_debarment_ind,
894 NULL, debarment_ind,
895 FND_API.G_MISS_CHAR, NULL,
896 x_debarment_ind),
897 debarments_count =
898 DECODE(x_debarments_count,
899 NULL, debarments_count,
900 FND_API.G_MISS_NUM, NULL,
901 x_debarments_count),
902 debarments_date =
903 DECODE(x_debarments_date,
904 NULL, debarments_date,
905 FND_API.G_MISS_DATE, NULL,
906 x_debarments_date),
907 high_credit =
908 DECODE(x_high_credit,
909 NULL, high_credit,
910 FND_API.G_MISS_NUM, NULL,
911 x_high_credit),
912 maximum_credit_currency_code =
913 DECODE(x_maximum_credit_currency_code,
914 NULL, maximum_credit_currency_code,
915 FND_API.G_MISS_CHAR, NULL,
916 x_maximum_credit_currency_code),
917 maximum_credit_recommendation =
918 DECODE(x_maximum_credit_rcmd,
919 NULL, maximum_credit_recommendation,
920 FND_API.G_MISS_NUM, NULL,
921 x_maximum_credit_rcmd),
922 paydex_norm =
923 DECODE(x_paydex_norm,
924 NULL, paydex_norm,
925 FND_API.G_MISS_CHAR, NULL,
926 x_paydex_norm),
927 paydex_score =
928 DECODE(x_paydex_score,
929 NULL, paydex_score,
930 FND_API.G_MISS_CHAR, NULL,
931 x_paydex_score),
932 paydex_three_months_ago =
933 DECODE(x_paydex_three_months_ago,
934 NULL, paydex_three_months_ago,
935 FND_API.G_MISS_CHAR, NULL,
936 x_paydex_three_months_ago),
937 credit_score_override_code =
938 DECODE(x_credit_score_override_code,
939 NULL, credit_score_override_code,
940 FND_API.G_MISS_CHAR, NULL,
941 x_credit_score_override_code),
942 cr_scr_clas_expl =
943 DECODE(x_cr_scr_clas_expl,
944 NULL, cr_scr_clas_expl,
945 FND_API.G_MISS_CHAR, NULL,
946 x_cr_scr_clas_expl),
947 low_rng_delq_scr =
948 DECODE(x_low_rng_delq_scr,
949 NULL, low_rng_delq_scr,
950 FND_API.G_MISS_NUM, NULL,
951 x_low_rng_delq_scr),
952 high_rng_delq_scr =
953 DECODE(x_high_rng_delq_scr,
954 NULL, high_rng_delq_scr,
955 FND_API.G_MISS_NUM, NULL,
956 x_high_rng_delq_scr),
957 delq_pmt_rng_prcnt =
958 DECODE(x_delq_pmt_rng_prcnt,
959 NULL, delq_pmt_rng_prcnt,
960 FND_API.G_MISS_NUM, NULL,
961 x_delq_pmt_rng_prcnt),
962 delq_pmt_pctg_for_all_firms =
963 DECODE(x_delq_pmt_pctg_for_all_firms,
964 NULL, delq_pmt_pctg_for_all_firms,
965 FND_API.G_MISS_NUM, NULL,
966 x_delq_pmt_pctg_for_all_firms),
967 num_trade_experiences =
968 DECODE(x_num_trade_experiences,
969 NULL, num_trade_experiences,
970 FND_API.G_MISS_NUM, NULL,
971 x_num_trade_experiences),
972 paydex_firm_days =
973 DECODE(x_paydex_firm_days,
974 NULL, paydex_firm_days,
975 FND_API.G_MISS_CHAR, NULL,
976 x_paydex_firm_days),
977 paydex_firm_comment =
978 DECODE(x_paydex_firm_comment,
979 NULL, paydex_firm_comment,
980 FND_API.G_MISS_CHAR, NULL,
981 x_paydex_firm_comment),
982 paydex_industry_days =
983 DECODE(x_paydex_industry_days,
984 NULL, paydex_industry_days,
985 FND_API.G_MISS_CHAR, NULL,
986 x_paydex_industry_days),
987 paydex_industry_comment =
988 DECODE(x_paydex_industry_comment,
989 NULL, paydex_industry_comment,
990 FND_API.G_MISS_CHAR, NULL,
991 x_paydex_industry_comment),
992 paydex_comment =
993 DECODE(x_paydex_comment,
994 NULL, paydex_comment,
995 FND_API.G_MISS_CHAR, NULL,
996 x_paydex_comment),
997 suit_ind =
998 DECODE(x_suit_ind,
999 NULL, suit_ind,
1000 FND_API.G_MISS_CHAR, NULL,
1001 x_suit_ind),
1002 lien_ind =
1003 DECODE(x_lien_ind,
1004 NULL, lien_ind,
1005 FND_API.G_MISS_CHAR, NULL,
1006 x_lien_ind),
1007 judgement_ind =
1008 DECODE(x_judgement_ind,
1009 NULL, judgement_ind,
1010 FND_API.G_MISS_CHAR, NULL,
1011 x_judgement_ind),
1012 bankruptcy_ind =
1013 DECODE(x_bankruptcy_ind,
1014 NULL, bankruptcy_ind,
1015 FND_API.G_MISS_CHAR, NULL,
1016 x_bankruptcy_ind),
1017 no_trade_ind =
1018 DECODE(x_no_trade_ind,
1019 NULL, no_trade_ind,
1020 FND_API.G_MISS_CHAR, NULL,
1021 x_no_trade_ind),
1022 prnt_hq_bkcy_ind =
1023 DECODE(x_prnt_hq_bkcy_ind,
1024 NULL, prnt_hq_bkcy_ind,
1025 FND_API.G_MISS_CHAR, NULL,
1026 x_prnt_hq_bkcy_ind),
1027 num_prnt_bkcy_filing =
1028 DECODE(x_num_prnt_bkcy_filing,
1029 NULL, num_prnt_bkcy_filing,
1030 FND_API.G_MISS_NUM, NULL,
1031 x_num_prnt_bkcy_filing),
1032 prnt_bkcy_filg_type =
1033 DECODE(x_prnt_bkcy_filg_type,
1034 NULL, prnt_bkcy_filg_type,
1035 FND_API.G_MISS_CHAR, NULL,
1036 x_prnt_bkcy_filg_type),
1037 prnt_bkcy_filg_chapter =
1038 DECODE(x_prnt_bkcy_filg_chapter,
1039 NULL, prnt_bkcy_filg_chapter,
1040 FND_API.G_MISS_NUM, NULL,
1041 x_prnt_bkcy_filg_chapter),
1042 prnt_bkcy_filg_date =
1043 DECODE(x_prnt_bkcy_filg_date,
1044 NULL, prnt_bkcy_filg_date,
1045 FND_API.G_MISS_DATE, NULL,
1046 x_prnt_bkcy_filg_date),
1047 num_prnt_bkcy_convs =
1048 DECODE(x_num_prnt_bkcy_convs,
1049 NULL, num_prnt_bkcy_convs,
1050 FND_API.G_MISS_NUM, NULL,
1051 x_num_prnt_bkcy_convs),
1052 prnt_bkcy_conv_date =
1053 DECODE(x_prnt_bkcy_conv_date,
1054 NULL, prnt_bkcy_conv_date,
1055 FND_API.G_MISS_DATE, NULL,
1056 x_prnt_bkcy_conv_date),
1057 prnt_bkcy_chapter_conv =
1058 DECODE(x_prnt_bkcy_chapter_conv,
1059 NULL, prnt_bkcy_chapter_conv,
1060 FND_API.G_MISS_CHAR, NULL,
1061 x_prnt_bkcy_chapter_conv),
1062 slow_trade_expl =
1063 DECODE(x_slow_trade_expl,
1064 NULL, slow_trade_expl,
1065 FND_API.G_MISS_CHAR, NULL,
1066 x_slow_trade_expl),
1067 negv_pmt_expl =
1068 DECODE(x_negv_pmt_expl,
1069 NULL, negv_pmt_expl,
1070 FND_API.G_MISS_CHAR, NULL,
1071 x_negv_pmt_expl),
1072 pub_rec_expl =
1073 DECODE(x_pub_rec_expl,
1074 NULL, pub_rec_expl,
1075 FND_API.G_MISS_CHAR, NULL,
1076 x_pub_rec_expl),
1077 business_discontinued =
1078 DECODE(x_business_discontinued,
1079 NULL, business_discontinued,
1080 FND_API.G_MISS_CHAR, NULL,
1081 x_business_discontinued),
1082 spcl_event_comment =
1083 DECODE(x_spcl_event_comment,
1084 NULL, spcl_event_comment,
1085 FND_API.G_MISS_CHAR, NULL,
1086 x_spcl_event_comment),
1087 num_spcl_event =
1088 DECODE(x_num_spcl_event,
1089 NULL, num_spcl_event,
1090 FND_API.G_MISS_NUM, NULL,
1091 x_num_spcl_event),
1092 spcl_event_update_date =
1093 DECODE(x_spcl_event_update_date,
1094 NULL, spcl_event_update_date,
1095 FND_API.G_MISS_DATE, NULL,
1096 x_spcl_event_update_date),
1097 spcl_evnt_txt =
1098 DECODE(x_spcl_evnt_txt,
1099 NULL, spcl_evnt_txt,
1100 FND_API.G_MISS_CHAR, NULL,
1101 x_spcl_evnt_txt),
1102 failure_score =
1103 DECODE(x_failure_score,
1104 NULL, failure_score,
1105 FND_API.G_MISS_CHAR, NULL,
1106 x_failure_score),
1107 failure_score_age =
1108 DECODE(x_failure_score_age,
1109 NULL, failure_score_age,
1110 FND_API.G_MISS_NUM, NULL,
1111 x_failure_score_age),
1112 failure_score_class =
1113 DECODE(x_failure_score_class,
1114 NULL, failure_score_class,
1115 FND_API.G_MISS_NUM, NULL,
1116 x_failure_score_class),
1117 failure_score_commentary =
1118 DECODE(x_failure_score_commentary,
1119 NULL, failure_score_commentary,
1120 FND_API.G_MISS_CHAR, NULL,
1121 x_failure_score_commentary),
1122 failure_score_commentary2 =
1123 DECODE(x_failure_score_commentary2,
1124 NULL, failure_score_commentary2,
1125 FND_API.G_MISS_CHAR, NULL,
1126 x_failure_score_commentary2),
1127 failure_score_commentary3 =
1128 DECODE(x_failure_score_commentary3,
1129 NULL, failure_score_commentary3,
1130 FND_API.G_MISS_CHAR, NULL,
1131 x_failure_score_commentary3),
1132 failure_score_commentary4 =
1133 DECODE(x_failure_score_commentary4,
1134 NULL, failure_score_commentary4,
1135 FND_API.G_MISS_CHAR, NULL,
1136 x_failure_score_commentary4),
1137 failure_score_commentary5 =
1138 DECODE(x_failure_score_commentary5,
1139 NULL, failure_score_commentary5,
1140 FND_API.G_MISS_CHAR, NULL,
1141 x_failure_score_commentary5),
1142 failure_score_commentary6 =
1143 DECODE(x_failure_score_commentary6,
1144 NULL, failure_score_commentary6,
1145 FND_API.G_MISS_CHAR, NULL,
1146 x_failure_score_commentary6),
1147 failure_score_commentary7 =
1148 DECODE(x_failure_score_commentary7,
1149 NULL, failure_score_commentary7,
1150 FND_API.G_MISS_CHAR, NULL,
1151 x_failure_score_commentary7),
1152 failure_score_commentary8 =
1153 DECODE(x_failure_score_commentary8,
1154 NULL, failure_score_commentary8,
1155 FND_API.G_MISS_CHAR, NULL,
1156 x_failure_score_commentary8),
1157 failure_score_commentary9 =
1158 DECODE(x_failure_score_commentary9,
1159 NULL, failure_score_commentary9,
1160 FND_API.G_MISS_CHAR, NULL,
1161 x_failure_score_commentary9),
1162 failure_score_commentary10 =
1163 DECODE(x_failure_score_commentary10,
1164 NULL, failure_score_commentary10,
1165 FND_API.G_MISS_CHAR, NULL,
1166 x_failure_score_commentary10),
1167 failure_score_date =
1168 DECODE(x_failure_score_date,
1169 NULL, failure_score_date,
1170 FND_API.G_MISS_DATE, NULL,
1171 x_failure_score_date),
1172 failure_score_incd_default =
1173 DECODE(x_failure_score_incd_default,
1174 NULL, failure_score_incd_default,
1175 FND_API.G_MISS_NUM, NULL,
1176 x_failure_score_incd_default),
1177 failure_score_natnl_percentile =
1178 DECODE(x_fail_score_natnl_percentile,
1179 NULL, failure_score_natnl_percentile,
1180 FND_API.G_MISS_NUM, NULL,
1181 x_fail_score_natnl_percentile),
1182 failure_score_override_code =
1183 DECODE(x_failure_score_override_code,
1184 NULL, failure_score_override_code,
1185 FND_API.G_MISS_CHAR, NULL,
1186 x_failure_score_override_code),
1187 global_failure_score =
1188 DECODE(x_global_failure_score,
1189 NULL, global_failure_score,
1190 FND_API.G_MISS_CHAR, NULL,
1191 x_global_failure_score)/*,
1192
1193 ** SSM SST Integration and Extension
1194 ** actual_content_source will not be updateable for non-SSM enabled entities.
1195
1196 actual_content_source =
1197 DECODE(x_actual_content_source,
1198 NULL, actual_content_source,
1199 FND_API.G_MISS_CHAR, NULL,
1200 x_actual_content_source) */
1201 WHERE rowid = x_rowid;
1202
1203 IF ( SQL%NOTFOUND ) THEN
1204 RAISE NO_DATA_FOUND;
1205 END IF;
1206
1207 END Update_Row;
1208
1209 PROCEDURE Lock_Row (
1210 x_rowid IN OUT NOCOPY VARCHAR2,
1211 x_credit_rating_id IN NUMBER,
1212 x_description IN VARCHAR2,
1213 x_party_id IN NUMBER,
1214 x_rating IN VARCHAR2,
1215 x_rated_as_of_date IN DATE,
1216 x_rating_organization IN VARCHAR2,
1217 x_created_by IN NUMBER,
1218 x_creation_date IN DATE,
1219 x_last_update_login IN NUMBER,
1220 x_last_update_date IN DATE,
1221 x_last_updated_by IN NUMBER,
1222 x_request_id IN NUMBER,
1223 x_program_application_id IN NUMBER,
1224 x_program_id IN NUMBER,
1225 x_program_update_date IN DATE,
1226 x_wh_update_date IN DATE,
1227 x_comments IN VARCHAR2,
1228 x_det_history_ind IN VARCHAR2,
1229 x_fincl_embt_ind IN VARCHAR2,
1230 x_criminal_proceeding_ind IN VARCHAR2,
1231 x_suit_judge_ind IN VARCHAR2,
1232 x_claims_ind IN VARCHAR2,
1233 x_secured_flng_ind IN VARCHAR2,
1234 x_fincl_lgl_event_ind IN VARCHAR2,
1235 x_disaster_ind IN VARCHAR2,
1236 x_oprg_spec_evnt_ind IN VARCHAR2,
1237 x_other_spec_evnt_ind IN VARCHAR2,
1238 x_content_source_type IN VARCHAR2,
1239 x_status IN VARCHAR2,
1240 x_object_version_number IN NUMBER,
1241 x_created_by_module IN VARCHAR2,
1242 x_application_id IN NUMBER,
1243 x_avg_high_credit IN NUMBER,
1244 x_credit_score IN VARCHAR2,
1245 x_credit_score_age IN NUMBER,
1246 x_credit_score_class IN NUMBER,
1247 x_credit_score_commentary IN VARCHAR2,
1248 x_credit_score_commentary2 IN VARCHAR2,
1249 x_credit_score_commentary3 IN VARCHAR2,
1250 x_credit_score_commentary4 IN VARCHAR2,
1251 x_credit_score_commentary5 IN VARCHAR2,
1252 x_credit_score_commentary6 IN VARCHAR2,
1253 x_credit_score_commentary7 IN VARCHAR2,
1254 x_credit_score_commentary8 IN VARCHAR2,
1255 x_credit_score_commentary9 IN VARCHAR2,
1256 x_credit_score_commentary10 IN VARCHAR2,
1257 x_credit_score_date IN DATE,
1258 x_credit_score_incd_default IN NUMBER,
1259 x_credit_score_natl_percentile IN NUMBER,
1260 x_debarment_ind IN VARCHAR2,
1261 x_debarments_count IN NUMBER,
1262 x_debarments_date IN DATE,
1263 x_high_credit IN NUMBER,
1264 x_maximum_credit_currency_code IN VARCHAR2,
1265 x_maximum_credit_rcmd IN NUMBER,
1266 x_paydex_norm IN VARCHAR2,
1267 x_paydex_score IN VARCHAR2,
1268 x_paydex_three_months_ago IN VARCHAR2,
1269 x_credit_score_override_code IN VARCHAR2,
1270 x_cr_scr_clas_expl IN VARCHAR2,
1271 x_low_rng_delq_scr IN NUMBER,
1272 x_high_rng_delq_scr IN NUMBER,
1273 x_delq_pmt_rng_prcnt IN NUMBER,
1274 x_delq_pmt_pctg_for_all_firms IN NUMBER,
1275 x_num_trade_experiences IN NUMBER,
1276 x_paydex_firm_days IN VARCHAR2,
1277 x_paydex_firm_comment IN VARCHAR2,
1278 x_paydex_industry_days IN VARCHAR2,
1279 x_paydex_industry_comment IN VARCHAR2,
1280 x_paydex_comment IN VARCHAR2,
1281 x_suit_ind IN VARCHAR2,
1282 x_lien_ind IN VARCHAR2,
1283 x_judgement_ind IN VARCHAR2,
1284 x_bankruptcy_ind IN VARCHAR2,
1285 x_no_trade_ind IN VARCHAR2,
1286 x_prnt_hq_bkcy_ind IN VARCHAR2,
1287 x_num_prnt_bkcy_filing IN NUMBER,
1288 x_prnt_bkcy_filg_type IN VARCHAR2,
1289 x_prnt_bkcy_filg_chapter IN NUMBER,
1290 x_prnt_bkcy_filg_date IN DATE,
1291 x_num_prnt_bkcy_convs IN NUMBER,
1292 x_prnt_bkcy_conv_date IN DATE,
1293 x_prnt_bkcy_chapter_conv IN VARCHAR2,
1294 x_slow_trade_expl IN VARCHAR2,
1295 x_negv_pmt_expl IN VARCHAR2,
1296 x_pub_rec_expl IN VARCHAR2,
1297 x_business_discontinued IN VARCHAR2,
1298 x_spcl_event_comment IN VARCHAR2,
1299 x_num_spcl_event IN NUMBER,
1300 x_spcl_event_update_date IN DATE,
1301 x_spcl_evnt_txt IN VARCHAR2,
1302 x_failure_score IN VARCHAR2,
1303 x_failure_score_age IN NUMBER,
1304 x_failure_score_class IN NUMBER,
1305 x_failure_score_commentary IN VARCHAR2,
1306 x_failure_score_commentary2 IN VARCHAR2,
1307 x_failure_score_commentary3 IN VARCHAR2,
1308 x_failure_score_commentary4 IN VARCHAR2,
1309 x_failure_score_commentary5 IN VARCHAR2,
1310 x_failure_score_commentary6 IN VARCHAR2,
1311 x_failure_score_commentary7 IN VARCHAR2,
1312 x_failure_score_commentary8 IN VARCHAR2,
1313 x_failure_score_commentary9 IN VARCHAR2,
1314 x_failure_score_commentary10 IN VARCHAR2,
1315 x_failure_score_date IN DATE,
1316 x_failure_score_incd_default IN NUMBER,
1317 x_fail_score_natnl_percentile IN NUMBER,
1318 x_failure_score_override_code IN VARCHAR2,
1319 x_global_failure_score IN VARCHAR2,
1320 x_actual_content_source IN VARCHAR2
1321 ) IS
1322
1323 CURSOR c IS
1324 SELECT * FROM hz_credit_ratings
1325 WHERE rowid = x_rowid
1326 FOR UPDATE NOWAIT;
1327 Recinfo c%ROWTYPE;
1328
1329 BEGIN
1330
1331 OPEN c;
1332 FETCH c INTO Recinfo;
1333 IF ( c%NOTFOUND ) THEN
1334 CLOSE c;
1335 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1336 APP_EXCEPTION.RAISE_EXCEPTION;
1337 END IF;
1338 CLOSE C;
1339
1340 IF (
1341 ( ( Recinfo.credit_rating_id = x_credit_rating_id )
1342 OR ( ( Recinfo.credit_rating_id IS NULL )
1343 AND ( x_credit_rating_id IS NULL ) ) )
1344 AND ( ( Recinfo.description = x_description )
1345 OR ( ( Recinfo.description IS NULL )
1346 AND ( x_description IS NULL ) ) )
1347 AND ( ( Recinfo.party_id = x_party_id )
1348 OR ( ( Recinfo.party_id IS NULL )
1349 AND ( x_party_id IS NULL ) ) )
1350 AND ( ( Recinfo.rating = x_rating )
1351 OR ( ( Recinfo.rating IS NULL )
1352 AND ( x_rating IS NULL ) ) )
1353 AND ( ( Recinfo.rated_as_of_date = x_rated_as_of_date )
1354 OR ( ( Recinfo.rated_as_of_date IS NULL )
1355 AND ( x_rated_as_of_date IS NULL ) ) )
1356 AND ( ( Recinfo.rating_organization = x_rating_organization )
1357 OR ( ( Recinfo.rating_organization IS NULL )
1358 AND ( x_rating_organization IS NULL ) ) )
1359 AND ( ( Recinfo.created_by = x_created_by )
1360 OR ( ( Recinfo.created_by IS NULL )
1361 AND ( x_created_by IS NULL ) ) )
1362 AND ( ( Recinfo.creation_date = x_creation_date )
1363 OR ( ( Recinfo.creation_date IS NULL )
1364 AND ( x_creation_date IS NULL ) ) )
1365 AND ( ( Recinfo.last_update_login = x_last_update_login )
1366 OR ( ( Recinfo.last_update_login IS NULL )
1367 AND ( x_last_update_login IS NULL ) ) )
1368 AND ( ( Recinfo.last_update_date = x_last_update_date )
1369 OR ( ( Recinfo.last_update_date IS NULL )
1370 AND ( x_last_update_date IS NULL ) ) )
1371 AND ( ( Recinfo.last_updated_by = x_last_updated_by )
1372 OR ( ( Recinfo.last_updated_by IS NULL )
1373 AND ( x_last_updated_by IS NULL ) ) )
1374 AND ( ( Recinfo.request_id = x_request_id )
1375 OR ( ( Recinfo.request_id IS NULL )
1376 AND ( x_request_id IS NULL ) ) )
1377 AND ( ( Recinfo.program_application_id = x_program_application_id )
1378 OR ( ( Recinfo.program_application_id IS NULL )
1379 AND ( x_program_application_id IS NULL ) ) )
1380 AND ( ( Recinfo.program_id = x_program_id )
1381 OR ( ( Recinfo.program_id IS NULL )
1382 AND ( x_program_id IS NULL ) ) )
1383 AND ( ( Recinfo.program_update_date = x_program_update_date )
1384 OR ( ( Recinfo.program_update_date IS NULL )
1385 AND ( x_program_update_date IS NULL ) ) )
1386 AND ( ( Recinfo.wh_update_date = x_wh_update_date )
1387 OR ( ( Recinfo.wh_update_date IS NULL )
1388 AND ( x_wh_update_date IS NULL ) ) )
1389 AND ( ( Recinfo.comments = x_comments )
1390 OR ( ( Recinfo.comments IS NULL )
1391 AND ( x_comments IS NULL ) ) )
1392 AND ( ( Recinfo.det_history_ind = x_det_history_ind )
1393 OR ( ( Recinfo.det_history_ind IS NULL )
1394 AND ( x_det_history_ind IS NULL ) ) )
1395 AND ( ( Recinfo.fincl_embt_ind = x_fincl_embt_ind )
1396 OR ( ( Recinfo.fincl_embt_ind IS NULL )
1397 AND ( x_fincl_embt_ind IS NULL ) ) )
1398 AND ( ( Recinfo.criminal_proceeding_ind = x_criminal_proceeding_ind )
1399 OR ( ( Recinfo.criminal_proceeding_ind IS NULL )
1400 AND ( x_criminal_proceeding_ind IS NULL ) ) )
1401 AND ( ( Recinfo.suit_judge_ind = x_suit_judge_ind )
1402 OR ( ( Recinfo.suit_judge_ind IS NULL )
1403 AND ( x_suit_judge_ind IS NULL ) ) )
1404 AND ( ( Recinfo.claims_ind = x_claims_ind )
1405 OR ( ( Recinfo.claims_ind IS NULL )
1406 AND ( x_claims_ind IS NULL ) ) )
1407 AND ( ( Recinfo.secured_flng_ind = x_secured_flng_ind )
1408 OR ( ( Recinfo.secured_flng_ind IS NULL )
1409 AND ( x_secured_flng_ind IS NULL ) ) )
1410 AND ( ( Recinfo.fincl_lgl_event_ind = x_fincl_lgl_event_ind )
1411 OR ( ( Recinfo.fincl_lgl_event_ind IS NULL )
1412 AND ( x_fincl_lgl_event_ind IS NULL ) ) )
1413 AND ( ( Recinfo.disaster_ind = x_disaster_ind )
1414 OR ( ( Recinfo.disaster_ind IS NULL )
1415 AND ( x_disaster_ind IS NULL ) ) )
1416 AND ( ( Recinfo.oprg_spec_evnt_ind = x_oprg_spec_evnt_ind )
1417 OR ( ( Recinfo.oprg_spec_evnt_ind IS NULL )
1418 AND ( x_oprg_spec_evnt_ind IS NULL ) ) )
1419 AND ( ( Recinfo.other_spec_evnt_ind = x_other_spec_evnt_ind )
1420 OR ( ( Recinfo.other_spec_evnt_ind IS NULL )
1421 AND ( x_other_spec_evnt_ind IS NULL ) ) )
1422 AND ( ( Recinfo.content_source_type = x_content_source_type )
1423 OR ( ( Recinfo.content_source_type IS NULL )
1424 AND ( x_content_source_type IS NULL ) ) )
1425 AND ( ( Recinfo.status = x_status )
1426 OR ( ( Recinfo.status IS NULL )
1427 AND ( x_status IS NULL ) ) )
1428 AND ( ( Recinfo.object_version_number = x_object_version_number )
1429 OR ( ( Recinfo.object_version_number IS NULL )
1430 AND ( x_object_version_number IS NULL ) ) )
1431 AND ( ( Recinfo.created_by_module = x_created_by_module )
1432 OR ( ( Recinfo.created_by_module IS NULL )
1433 AND ( x_created_by_module IS NULL ) ) )
1434 AND ( ( Recinfo.application_id = x_application_id )
1435 OR ( ( Recinfo.application_id IS NULL )
1436 AND ( x_application_id IS NULL ) ) )
1437 AND ( ( Recinfo.avg_high_credit = x_avg_high_credit )
1438 OR ( ( Recinfo.avg_high_credit IS NULL )
1439 AND ( x_avg_high_credit IS NULL ) ) )
1440 AND ( ( Recinfo.credit_score = x_credit_score )
1441 OR ( ( Recinfo.credit_score IS NULL )
1442 AND ( x_credit_score IS NULL ) ) )
1443 AND ( ( Recinfo.credit_score_age = x_credit_score_age )
1444 OR ( ( Recinfo.credit_score_age IS NULL )
1445 AND ( x_credit_score_age IS NULL ) ) )
1446 AND ( ( Recinfo.credit_score_class = x_credit_score_class )
1447 OR ( ( Recinfo.credit_score_class IS NULL )
1448 AND ( x_credit_score_class IS NULL ) ) )
1449 AND ( ( Recinfo.credit_score_commentary = x_credit_score_commentary )
1450 OR ( ( Recinfo.credit_score_commentary IS NULL )
1451 AND ( x_credit_score_commentary IS NULL ) ) )
1452 AND ( ( Recinfo.credit_score_commentary2 = x_credit_score_commentary2 )
1453 OR ( ( Recinfo.credit_score_commentary2 IS NULL )
1454 AND ( x_credit_score_commentary2 IS NULL ) ) )
1455 AND ( ( Recinfo.credit_score_commentary3 = x_credit_score_commentary3 )
1456 OR ( ( Recinfo.credit_score_commentary3 IS NULL )
1457 AND ( x_credit_score_commentary3 IS NULL ) ) )
1458 AND ( ( Recinfo.credit_score_commentary4 = x_credit_score_commentary4 )
1459 OR ( ( Recinfo.credit_score_commentary4 IS NULL )
1460 AND ( x_credit_score_commentary4 IS NULL ) ) )
1461 AND ( ( Recinfo.credit_score_commentary5 = x_credit_score_commentary5 )
1462 OR ( ( Recinfo.credit_score_commentary5 IS NULL )
1463 AND ( x_credit_score_commentary5 IS NULL ) ) )
1464 AND ( ( Recinfo.credit_score_commentary6 = x_credit_score_commentary6 )
1465 OR ( ( Recinfo.credit_score_commentary6 IS NULL )
1466 AND ( x_credit_score_commentary6 IS NULL ) ) )
1467 AND ( ( Recinfo.credit_score_commentary7 = x_credit_score_commentary7 )
1468 OR ( ( Recinfo.credit_score_commentary7 IS NULL )
1469 AND ( x_credit_score_commentary7 IS NULL ) ) )
1470 AND ( ( Recinfo.credit_score_commentary8 = x_credit_score_commentary8 )
1471 OR ( ( Recinfo.credit_score_commentary8 IS NULL )
1472 AND ( x_credit_score_commentary8 IS NULL ) ) )
1473 AND ( ( Recinfo.credit_score_commentary9 = x_credit_score_commentary9 )
1474 OR ( ( Recinfo.credit_score_commentary9 IS NULL )
1475 AND ( x_credit_score_commentary9 IS NULL ) ) )
1476 AND ( ( Recinfo.credit_score_commentary10 = x_credit_score_commentary10 )
1477 OR ( ( Recinfo.credit_score_commentary10 IS NULL )
1478 AND ( x_credit_score_commentary10 IS NULL ) ) )
1479 AND ( ( Recinfo.credit_score_date = x_credit_score_date )
1480 OR ( ( Recinfo.credit_score_date IS NULL )
1481 AND ( x_credit_score_date IS NULL ) ) )
1482 AND ( ( Recinfo.credit_score_incd_default = x_credit_score_incd_default )
1483 OR ( ( Recinfo.credit_score_incd_default IS NULL )
1484 AND ( x_credit_score_incd_default IS NULL ) ) )
1485 AND ( ( Recinfo.credit_score_natl_percentile = x_credit_score_natl_percentile )
1486 OR ( ( Recinfo.credit_score_natl_percentile IS NULL )
1487 AND ( x_credit_score_natl_percentile IS NULL ) ) )
1488 AND ( ( Recinfo.debarment_ind = x_debarment_ind )
1489 OR ( ( Recinfo.debarment_ind IS NULL )
1490 AND ( x_debarment_ind IS NULL ) ) )
1491 AND ( ( Recinfo.debarments_count = x_debarments_count )
1492 OR ( ( Recinfo.debarments_count IS NULL )
1493 AND ( x_debarments_count IS NULL ) ) )
1494 AND ( ( Recinfo.debarments_date = x_debarments_date )
1495 OR ( ( Recinfo.debarments_date IS NULL )
1496 AND ( x_debarments_date IS NULL ) ) )
1497 AND ( ( Recinfo.high_credit = x_high_credit )
1498 OR ( ( Recinfo.high_credit IS NULL )
1499 AND ( x_high_credit IS NULL ) ) )
1500 AND ( ( Recinfo.maximum_credit_currency_code = x_maximum_credit_currency_code )
1501 OR ( ( Recinfo.maximum_credit_currency_code IS NULL )
1502 AND ( x_maximum_credit_currency_code IS NULL ) ) )
1503 AND ( ( Recinfo.maximum_credit_recommendation = x_maximum_credit_rcmd )
1504 OR ( ( Recinfo.maximum_credit_recommendation IS NULL )
1505 AND ( x_maximum_credit_rcmd IS NULL ) ) )
1506 AND ( ( Recinfo.paydex_norm = x_paydex_norm )
1507 OR ( ( Recinfo.paydex_norm IS NULL )
1508 AND ( x_paydex_norm IS NULL ) ) )
1509 AND ( ( Recinfo.paydex_score = x_paydex_score )
1510 OR ( ( Recinfo.paydex_score IS NULL )
1511 AND ( x_paydex_score IS NULL ) ) )
1512 AND ( ( Recinfo.paydex_three_months_ago = x_paydex_three_months_ago )
1513 OR ( ( Recinfo.paydex_three_months_ago IS NULL )
1514 AND ( x_paydex_three_months_ago IS NULL ) ) )
1515 AND ( ( Recinfo.credit_score_override_code = x_credit_score_override_code )
1516 OR ( ( Recinfo.credit_score_override_code IS NULL )
1517 AND ( x_credit_score_override_code IS NULL ) ) )
1518 AND ( ( Recinfo.cr_scr_clas_expl = x_cr_scr_clas_expl )
1519 OR ( ( Recinfo.cr_scr_clas_expl IS NULL )
1520 AND ( x_cr_scr_clas_expl IS NULL ) ) )
1521 AND ( ( Recinfo.low_rng_delq_scr = x_low_rng_delq_scr )
1522 OR ( ( Recinfo.low_rng_delq_scr IS NULL )
1523 AND ( x_low_rng_delq_scr IS NULL ) ) )
1524 AND ( ( Recinfo.high_rng_delq_scr = x_high_rng_delq_scr )
1525 OR ( ( Recinfo.high_rng_delq_scr IS NULL )
1526 AND ( x_high_rng_delq_scr IS NULL ) ) )
1527 AND ( ( Recinfo.delq_pmt_rng_prcnt = x_delq_pmt_rng_prcnt )
1528 OR ( ( Recinfo.delq_pmt_rng_prcnt IS NULL )
1529 AND ( x_delq_pmt_rng_prcnt IS NULL ) ) )
1530 AND ( ( Recinfo.delq_pmt_pctg_for_all_firms = x_delq_pmt_pctg_for_all_firms )
1531 OR ( ( Recinfo.delq_pmt_pctg_for_all_firms IS NULL )
1532 AND ( x_delq_pmt_pctg_for_all_firms IS NULL ) ) )
1533 AND ( ( Recinfo.num_trade_experiences = x_num_trade_experiences )
1534 OR ( ( Recinfo.num_trade_experiences IS NULL )
1535 AND ( x_num_trade_experiences IS NULL ) ) )
1536 AND ( ( Recinfo.paydex_firm_days = x_paydex_firm_days )
1537 OR ( ( Recinfo.paydex_firm_days IS NULL )
1538 AND ( x_paydex_firm_days IS NULL ) ) )
1539 AND ( ( Recinfo.paydex_firm_comment = x_paydex_firm_comment )
1540 OR ( ( Recinfo.paydex_firm_comment IS NULL )
1541 AND ( x_paydex_firm_comment IS NULL ) ) )
1542 AND ( ( Recinfo.paydex_industry_days = x_paydex_industry_days )
1543 OR ( ( Recinfo.paydex_industry_days IS NULL )
1544 AND ( x_paydex_industry_days IS NULL ) ) )
1545 AND ( ( Recinfo.paydex_industry_comment = x_paydex_industry_comment )
1546 OR ( ( Recinfo.paydex_industry_comment IS NULL )
1547 AND ( x_paydex_industry_comment IS NULL ) ) )
1548 AND ( ( Recinfo.paydex_comment = x_paydex_comment )
1549 OR ( ( Recinfo.paydex_comment IS NULL )
1550 AND ( x_paydex_comment IS NULL ) ) )
1551 AND ( ( Recinfo.suit_ind = x_suit_ind )
1552 OR ( ( Recinfo.suit_ind IS NULL )
1553 AND ( x_suit_ind IS NULL ) ) )
1554 AND ( ( Recinfo.lien_ind = x_lien_ind )
1555 OR ( ( Recinfo.lien_ind IS NULL )
1556 AND ( x_lien_ind IS NULL ) ) )
1557 AND ( ( Recinfo.judgement_ind = x_judgement_ind )
1558 OR ( ( Recinfo.judgement_ind IS NULL )
1559 AND ( x_judgement_ind IS NULL ) ) )
1560 AND ( ( Recinfo.bankruptcy_ind = x_bankruptcy_ind )
1561 OR ( ( Recinfo.bankruptcy_ind IS NULL )
1562 AND ( x_bankruptcy_ind IS NULL ) ) )
1563 AND ( ( Recinfo.no_trade_ind = x_no_trade_ind )
1564 OR ( ( Recinfo.no_trade_ind IS NULL )
1565 AND ( x_no_trade_ind IS NULL ) ) )
1566 AND ( ( Recinfo.prnt_hq_bkcy_ind = x_prnt_hq_bkcy_ind )
1567 OR ( ( Recinfo.prnt_hq_bkcy_ind IS NULL )
1568 AND ( x_prnt_hq_bkcy_ind IS NULL ) ) )
1569 AND ( ( Recinfo.num_prnt_bkcy_filing = x_num_prnt_bkcy_filing )
1570 OR ( ( Recinfo.num_prnt_bkcy_filing IS NULL )
1571 AND ( x_num_prnt_bkcy_filing IS NULL ) ) )
1572 AND ( ( Recinfo.prnt_bkcy_filg_type = x_prnt_bkcy_filg_type )
1573 OR ( ( Recinfo.prnt_bkcy_filg_type IS NULL )
1574 AND ( x_prnt_bkcy_filg_type IS NULL ) ) )
1575 AND ( ( Recinfo.prnt_bkcy_filg_chapter = x_prnt_bkcy_filg_chapter )
1576 OR ( ( Recinfo.prnt_bkcy_filg_chapter IS NULL )
1577 AND ( x_prnt_bkcy_filg_chapter IS NULL ) ) )
1578 AND ( ( Recinfo.prnt_bkcy_filg_date = x_prnt_bkcy_filg_date )
1579 OR ( ( Recinfo.prnt_bkcy_filg_date IS NULL )
1580 AND ( x_prnt_bkcy_filg_date IS NULL ) ) )
1581 AND ( ( Recinfo.num_prnt_bkcy_convs = x_num_prnt_bkcy_convs )
1582 OR ( ( Recinfo.num_prnt_bkcy_convs IS NULL )
1583 AND ( x_num_prnt_bkcy_convs IS NULL ) ) )
1584 AND ( ( Recinfo.prnt_bkcy_conv_date = x_prnt_bkcy_conv_date )
1585 OR ( ( Recinfo.prnt_bkcy_conv_date IS NULL )
1586 AND ( x_prnt_bkcy_conv_date IS NULL ) ) )
1587 AND ( ( Recinfo.prnt_bkcy_chapter_conv = x_prnt_bkcy_chapter_conv )
1588 OR ( ( Recinfo.prnt_bkcy_chapter_conv IS NULL )
1589 AND ( x_prnt_bkcy_chapter_conv IS NULL ) ) )
1590 AND ( ( Recinfo.slow_trade_expl = x_slow_trade_expl )
1591 OR ( ( Recinfo.slow_trade_expl IS NULL )
1592 AND ( x_slow_trade_expl IS NULL ) ) )
1593 AND ( ( Recinfo.negv_pmt_expl = x_negv_pmt_expl )
1594 OR ( ( Recinfo.negv_pmt_expl IS NULL )
1595 AND ( x_negv_pmt_expl IS NULL ) ) )
1596 AND ( ( Recinfo.pub_rec_expl = x_pub_rec_expl )
1597 OR ( ( Recinfo.pub_rec_expl IS NULL )
1598 AND ( x_pub_rec_expl IS NULL ) ) )
1599 AND ( ( Recinfo.business_discontinued = x_business_discontinued )
1600 OR ( ( Recinfo.business_discontinued IS NULL )
1601 AND ( x_business_discontinued IS NULL ) ) )
1602 AND ( ( Recinfo.spcl_event_comment = x_spcl_event_comment )
1603 OR ( ( Recinfo.spcl_event_comment IS NULL )
1604 AND ( x_spcl_event_comment IS NULL ) ) )
1605 AND ( ( Recinfo.num_spcl_event = x_num_spcl_event )
1606 OR ( ( Recinfo.num_spcl_event IS NULL )
1607 AND ( x_num_spcl_event IS NULL ) ) )
1608 AND ( ( Recinfo.spcl_event_update_date = x_spcl_event_update_date )
1609 OR ( ( Recinfo.spcl_event_update_date IS NULL )
1610 AND ( x_spcl_event_update_date IS NULL ) ) )
1611 AND ( ( Recinfo.spcl_evnt_txt = x_spcl_evnt_txt )
1612 OR ( ( Recinfo.spcl_evnt_txt IS NULL )
1613 AND ( x_spcl_evnt_txt IS NULL ) ) )
1614 AND ( ( Recinfo.failure_score = x_failure_score )
1615 OR ( ( Recinfo.failure_score IS NULL )
1616 AND ( x_failure_score IS NULL ) ) )
1617 AND ( ( Recinfo.failure_score_age = x_failure_score_age )
1618 OR ( ( Recinfo.failure_score_age IS NULL )
1619 AND ( x_failure_score_age IS NULL ) ) )
1620 AND ( ( Recinfo.failure_score_class = x_failure_score_class )
1621 OR ( ( Recinfo.failure_score_class IS NULL )
1622 AND ( x_failure_score_class IS NULL ) ) )
1623 AND ( ( Recinfo.failure_score_commentary = x_failure_score_commentary )
1624 OR ( ( Recinfo.failure_score_commentary IS NULL )
1625 AND ( x_failure_score_commentary IS NULL ) ) )
1626 AND ( ( Recinfo.failure_score_commentary2 = x_failure_score_commentary2 )
1627 OR ( ( Recinfo.failure_score_commentary2 IS NULL )
1628 AND ( x_failure_score_commentary2 IS NULL ) ) )
1629 AND ( ( Recinfo.failure_score_commentary3 = x_failure_score_commentary3 )
1630 OR ( ( Recinfo.failure_score_commentary3 IS NULL )
1631 AND ( x_failure_score_commentary3 IS NULL ) ) )
1632 AND ( ( Recinfo.failure_score_commentary4 = x_failure_score_commentary4 )
1633 OR ( ( Recinfo.failure_score_commentary4 IS NULL )
1634 AND ( x_failure_score_commentary4 IS NULL ) ) )
1635 AND ( ( Recinfo.failure_score_commentary5 = x_failure_score_commentary5 )
1636 OR ( ( Recinfo.failure_score_commentary5 IS NULL )
1637 AND ( x_failure_score_commentary5 IS NULL ) ) )
1638 AND ( ( Recinfo.failure_score_commentary6 = x_failure_score_commentary6 )
1639 OR ( ( Recinfo.failure_score_commentary6 IS NULL )
1640 AND ( x_failure_score_commentary6 IS NULL ) ) )
1641 AND ( ( Recinfo.failure_score_commentary7 = x_failure_score_commentary7 )
1642 OR ( ( Recinfo.failure_score_commentary7 IS NULL )
1643 AND ( x_failure_score_commentary7 IS NULL ) ) )
1644 AND ( ( Recinfo.failure_score_commentary8 = x_failure_score_commentary8 )
1645 OR ( ( Recinfo.failure_score_commentary8 IS NULL )
1646 AND ( x_failure_score_commentary8 IS NULL ) ) )
1647 AND ( ( Recinfo.failure_score_commentary9 = x_failure_score_commentary9 )
1648 OR ( ( Recinfo.failure_score_commentary9 IS NULL )
1649 AND ( x_failure_score_commentary9 IS NULL ) ) )
1650 AND ( ( Recinfo.failure_score_commentary10 = x_failure_score_commentary10 )
1651 OR ( ( Recinfo.failure_score_commentary10 IS NULL )
1652 AND ( x_failure_score_commentary10 IS NULL ) ) )
1653 AND ( ( Recinfo.failure_score_date = x_failure_score_date )
1654 OR ( ( Recinfo.failure_score_date IS NULL )
1655 AND ( x_failure_score_date IS NULL ) ) )
1656 AND ( ( Recinfo.failure_score_incd_default = x_failure_score_incd_default )
1657 OR ( ( Recinfo.failure_score_incd_default IS NULL )
1658 AND ( x_failure_score_incd_default IS NULL ) ) )
1659 AND ( ( Recinfo.failure_score_natnl_percentile = x_fail_score_natnl_percentile )
1660 OR ( ( Recinfo.failure_score_natnl_percentile IS NULL )
1661 AND ( x_fail_score_natnl_percentile IS NULL ) ) )
1662 AND ( ( Recinfo.failure_score_override_code = x_failure_score_override_code )
1663 OR ( ( Recinfo.failure_score_override_code IS NULL )
1664 AND ( x_failure_score_override_code IS NULL ) ) )
1665 AND ( ( Recinfo.global_failure_score = x_global_failure_score )
1666 OR ( ( Recinfo.global_failure_score IS NULL )
1667 AND ( x_global_failure_score IS NULL ) ) )
1668 AND ( ( Recinfo.actual_content_source = x_actual_content_source )
1669 OR ( ( Recinfo.actual_content_source IS NULL )
1670 AND ( x_actual_content_source IS NULL ) ) )
1671 ) THEN
1672 RETURN;
1673 ELSE
1674 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1675 APP_EXCEPTION.RAISE_EXCEPTION;
1676 END IF;
1677
1678 END Lock_Row;
1679
1680 PROCEDURE Select_Row (
1681 x_credit_rating_id IN OUT NOCOPY NUMBER,
1682 x_description OUT NOCOPY VARCHAR2,
1683 x_party_id OUT NOCOPY NUMBER,
1684 x_rating OUT NOCOPY VARCHAR2,
1685 x_rated_as_of_date OUT NOCOPY DATE,
1686 x_rating_organization OUT NOCOPY VARCHAR2,
1687 x_comments OUT NOCOPY VARCHAR2,
1688 x_det_history_ind OUT NOCOPY VARCHAR2,
1689 x_fincl_embt_ind OUT NOCOPY VARCHAR2,
1690 x_criminal_proceeding_ind OUT NOCOPY VARCHAR2,
1691 x_claims_ind OUT NOCOPY VARCHAR2,
1692 x_secured_flng_ind OUT NOCOPY VARCHAR2,
1693 x_fincl_lgl_event_ind OUT NOCOPY VARCHAR2,
1694 x_disaster_ind OUT NOCOPY VARCHAR2,
1695 x_oprg_spec_evnt_ind OUT NOCOPY VARCHAR2,
1696 x_other_spec_evnt_ind OUT NOCOPY VARCHAR2,
1697 x_status OUT NOCOPY VARCHAR2,
1698 x_created_by_module OUT NOCOPY VARCHAR2,
1699 x_avg_high_credit OUT NOCOPY NUMBER,
1700 x_credit_score OUT NOCOPY VARCHAR2,
1701 x_credit_score_age OUT NOCOPY NUMBER,
1702 x_credit_score_class OUT NOCOPY NUMBER,
1703 x_credit_score_commentary OUT NOCOPY VARCHAR2,
1704 x_credit_score_commentary2 OUT NOCOPY VARCHAR2,
1705 x_credit_score_commentary3 OUT NOCOPY VARCHAR2,
1706 x_credit_score_commentary4 OUT NOCOPY VARCHAR2,
1707 x_credit_score_commentary5 OUT NOCOPY VARCHAR2,
1708 x_credit_score_commentary6 OUT NOCOPY VARCHAR2,
1709 x_credit_score_commentary7 OUT NOCOPY VARCHAR2,
1710 x_credit_score_commentary8 OUT NOCOPY VARCHAR2,
1711 x_credit_score_commentary9 OUT NOCOPY VARCHAR2,
1712 x_credit_score_commentary10 OUT NOCOPY VARCHAR2,
1713 x_credit_score_date OUT NOCOPY DATE,
1714 x_credit_score_incd_default OUT NOCOPY NUMBER,
1715 x_credit_score_natl_percentile OUT NOCOPY NUMBER,
1716 x_debarment_ind OUT NOCOPY VARCHAR2,
1717 x_debarments_count OUT NOCOPY NUMBER,
1718 x_debarments_date OUT NOCOPY DATE,
1719 x_high_credit OUT NOCOPY NUMBER,
1720 x_maximum_credit_currency_code OUT NOCOPY VARCHAR2,
1721 x_maximum_credit_rcmd OUT NOCOPY NUMBER,
1722 x_paydex_norm OUT NOCOPY VARCHAR2,
1723 x_paydex_score OUT NOCOPY VARCHAR2,
1724 x_paydex_three_months_ago OUT NOCOPY VARCHAR2,
1725 x_credit_score_override_code OUT NOCOPY VARCHAR2,
1726 x_cr_scr_clas_expl OUT NOCOPY VARCHAR2,
1727 x_low_rng_delq_scr OUT NOCOPY NUMBER,
1728 x_high_rng_delq_scr OUT NOCOPY NUMBER,
1729 x_delq_pmt_rng_prcnt OUT NOCOPY NUMBER,
1730 x_delq_pmt_pctg_for_all_firms OUT NOCOPY NUMBER,
1731 x_num_trade_experiences OUT NOCOPY NUMBER,
1732 x_paydex_firm_days OUT NOCOPY VARCHAR2,
1733 x_paydex_firm_comment OUT NOCOPY VARCHAR2,
1734 x_paydex_industry_days OUT NOCOPY VARCHAR2,
1735 x_paydex_industry_comment OUT NOCOPY VARCHAR2,
1736 x_paydex_comment OUT NOCOPY VARCHAR2,
1737 x_suit_ind OUT NOCOPY VARCHAR2,
1738 x_lien_ind OUT NOCOPY VARCHAR2,
1739 x_judgement_ind OUT NOCOPY VARCHAR2,
1740 x_bankruptcy_ind OUT NOCOPY VARCHAR2,
1741 x_no_trade_ind OUT NOCOPY VARCHAR2,
1742 x_prnt_hq_bkcy_ind OUT NOCOPY VARCHAR2,
1743 x_num_prnt_bkcy_filing OUT NOCOPY NUMBER,
1744 x_prnt_bkcy_filg_type OUT NOCOPY VARCHAR2,
1745 x_prnt_bkcy_filg_chapter OUT NOCOPY NUMBER,
1746 x_prnt_bkcy_filg_date OUT NOCOPY DATE,
1747 x_num_prnt_bkcy_convs OUT NOCOPY NUMBER,
1748 x_prnt_bkcy_conv_date OUT NOCOPY DATE,
1749 x_prnt_bkcy_chapter_conv OUT NOCOPY VARCHAR2,
1750 x_slow_trade_expl OUT NOCOPY VARCHAR2,
1751 x_negv_pmt_expl OUT NOCOPY VARCHAR2,
1752 x_pub_rec_expl OUT NOCOPY VARCHAR2,
1753 x_business_discontinued OUT NOCOPY VARCHAR2,
1754 x_spcl_event_comment OUT NOCOPY VARCHAR2,
1755 x_num_spcl_event OUT NOCOPY NUMBER,
1756 x_spcl_event_update_date OUT NOCOPY DATE,
1757 x_spcl_evnt_txt OUT NOCOPY VARCHAR2,
1758 x_failure_score OUT NOCOPY VARCHAR2,
1759 x_failure_score_age OUT NOCOPY NUMBER,
1760 x_failure_score_class OUT NOCOPY NUMBER,
1761 x_failure_score_commentary OUT NOCOPY VARCHAR2,
1762 x_failure_score_commentary2 OUT NOCOPY VARCHAR2,
1763 x_failure_score_commentary3 OUT NOCOPY VARCHAR2,
1764 x_failure_score_commentary4 OUT NOCOPY VARCHAR2,
1765 x_failure_score_commentary5 OUT NOCOPY VARCHAR2,
1766 x_failure_score_commentary6 OUT NOCOPY VARCHAR2,
1767 x_failure_score_commentary7 OUT NOCOPY VARCHAR2,
1768 x_failure_score_commentary8 OUT NOCOPY VARCHAR2,
1769 x_failure_score_commentary9 OUT NOCOPY VARCHAR2,
1770 x_failure_score_commentary10 OUT NOCOPY VARCHAR2,
1771 x_failure_score_date OUT NOCOPY DATE,
1772 x_failure_score_incd_default OUT NOCOPY NUMBER,
1773 x_fail_score_natnl_percentile OUT NOCOPY NUMBER,
1774 x_failure_score_override_code OUT NOCOPY VARCHAR2,
1775 x_global_failure_score OUT NOCOPY VARCHAR2,
1776 x_actual_content_source OUT NOCOPY VARCHAR2
1777 ) IS
1778 BEGIN
1779
1780 SELECT
1781 NVL(credit_rating_id, FND_API.G_MISS_NUM),
1782 NVL(description, FND_API.G_MISS_CHAR),
1783 NVL(party_id, FND_API.G_MISS_NUM),
1784 NVL(rating, FND_API.G_MISS_CHAR),
1785 NVL(rated_as_of_date, FND_API.G_MISS_DATE),
1786 NVL(rating_organization, FND_API.G_MISS_CHAR),
1787 NVL(comments, FND_API.G_MISS_CHAR),
1788 NVL(det_history_ind, FND_API.G_MISS_CHAR),
1789 NVL(fincl_embt_ind, FND_API.G_MISS_CHAR),
1790 NVL(criminal_proceeding_ind, FND_API.G_MISS_CHAR),
1791 NVL(claims_ind, FND_API.G_MISS_CHAR),
1792 NVL(secured_flng_ind, FND_API.G_MISS_CHAR),
1793 NVL(fincl_lgl_event_ind, FND_API.G_MISS_CHAR),
1794 NVL(disaster_ind, FND_API.G_MISS_CHAR),
1795 NVL(oprg_spec_evnt_ind, FND_API.G_MISS_CHAR),
1796 NVL(other_spec_evnt_ind, FND_API.G_MISS_CHAR),
1797 NVL(status, FND_API.G_MISS_CHAR),
1798 NVL(created_by_module, FND_API.G_MISS_CHAR),
1799 NVL(avg_high_credit, FND_API.G_MISS_NUM),
1800 NVL(credit_score, FND_API.G_MISS_CHAR),
1801 NVL(credit_score_age, FND_API.G_MISS_NUM),
1802 NVL(credit_score_class, FND_API.G_MISS_NUM),
1803 NVL(credit_score_commentary, FND_API.G_MISS_CHAR),
1804 NVL(credit_score_commentary2, FND_API.G_MISS_CHAR),
1805 NVL(credit_score_commentary3, FND_API.G_MISS_CHAR),
1806 NVL(credit_score_commentary4, FND_API.G_MISS_CHAR),
1807 NVL(credit_score_commentary5, FND_API.G_MISS_CHAR),
1808 NVL(credit_score_commentary6, FND_API.G_MISS_CHAR),
1809 NVL(credit_score_commentary7, FND_API.G_MISS_CHAR),
1810 NVL(credit_score_commentary8, FND_API.G_MISS_CHAR),
1811 NVL(credit_score_commentary9, FND_API.G_MISS_CHAR),
1812 NVL(credit_score_commentary10, FND_API.G_MISS_CHAR),
1813 NVL(credit_score_date, FND_API.G_MISS_DATE),
1814 NVL(credit_score_incd_default, FND_API.G_MISS_NUM),
1815 NVL(credit_score_natl_percentile, FND_API.G_MISS_NUM),
1816 NVL(debarment_ind, FND_API.G_MISS_CHAR),
1817 NVL(debarments_count, FND_API.G_MISS_NUM),
1818 NVL(debarments_date, FND_API.G_MISS_DATE),
1819 NVL(high_credit, FND_API.G_MISS_NUM),
1820 NVL(maximum_credit_currency_code, FND_API.G_MISS_CHAR),
1821 NVL(maximum_credit_recommendation, FND_API.G_MISS_NUM),
1822 NVL(paydex_norm, FND_API.G_MISS_CHAR),
1823 NVL(paydex_score, FND_API.G_MISS_CHAR),
1824 NVL(paydex_three_months_ago, FND_API.G_MISS_CHAR),
1825 NVL(credit_score_override_code, FND_API.G_MISS_CHAR),
1826 NVL(cr_scr_clas_expl, FND_API.G_MISS_CHAR),
1827 NVL(low_rng_delq_scr, FND_API.G_MISS_NUM),
1828 NVL(high_rng_delq_scr, FND_API.G_MISS_NUM),
1829 NVL(delq_pmt_rng_prcnt, FND_API.G_MISS_NUM),
1830 NVL(delq_pmt_pctg_for_all_firms, FND_API.G_MISS_NUM),
1831 NVL(num_trade_experiences, FND_API.G_MISS_NUM),
1832 NVL(paydex_firm_days, FND_API.G_MISS_CHAR),
1833 NVL(paydex_firm_comment, FND_API.G_MISS_CHAR),
1834 NVL(paydex_industry_days, FND_API.G_MISS_CHAR),
1835 NVL(paydex_industry_comment, FND_API.G_MISS_CHAR),
1836 NVL(paydex_comment, FND_API.G_MISS_CHAR),
1837 NVL(suit_ind, FND_API.G_MISS_CHAR),
1838 NVL(lien_ind, FND_API.G_MISS_CHAR),
1839 NVL(judgement_ind, FND_API.G_MISS_CHAR),
1840 NVL(bankruptcy_ind, FND_API.G_MISS_CHAR),
1841 NVL(no_trade_ind, FND_API.G_MISS_CHAR),
1842 NVL(prnt_hq_bkcy_ind, FND_API.G_MISS_CHAR),
1843 NVL(num_prnt_bkcy_filing, FND_API.G_MISS_NUM),
1844 NVL(prnt_bkcy_filg_type, FND_API.G_MISS_CHAR),
1845 NVL(prnt_bkcy_filg_chapter, FND_API.G_MISS_NUM),
1846 NVL(prnt_bkcy_filg_date, FND_API.G_MISS_DATE),
1847 NVL(num_prnt_bkcy_convs, FND_API.G_MISS_NUM),
1848 NVL(prnt_bkcy_conv_date, FND_API.G_MISS_DATE),
1849 NVL(prnt_bkcy_chapter_conv, FND_API.G_MISS_CHAR),
1850 NVL(slow_trade_expl, FND_API.G_MISS_CHAR),
1851 NVL(negv_pmt_expl, FND_API.G_MISS_CHAR),
1852 NVL(pub_rec_expl, FND_API.G_MISS_CHAR),
1853 NVL(business_discontinued, FND_API.G_MISS_CHAR),
1854 NVL(spcl_event_comment, FND_API.G_MISS_CHAR),
1855 NVL(num_spcl_event, FND_API.G_MISS_NUM),
1856 NVL(spcl_event_update_date, FND_API.G_MISS_DATE),
1857 NVL(spcl_evnt_txt, FND_API.G_MISS_CHAR),
1858 NVL(failure_score, FND_API.G_MISS_CHAR),
1859 NVL(failure_score_age, FND_API.G_MISS_NUM),
1860 NVL(failure_score_class, FND_API.G_MISS_NUM),
1861 NVL(failure_score_commentary, FND_API.G_MISS_CHAR),
1862 NVL(failure_score_commentary2, FND_API.G_MISS_CHAR),
1863 NVL(failure_score_commentary3, FND_API.G_MISS_CHAR),
1864 NVL(failure_score_commentary4, FND_API.G_MISS_CHAR),
1865 NVL(failure_score_commentary5, FND_API.G_MISS_CHAR),
1866 NVL(failure_score_commentary6, FND_API.G_MISS_CHAR),
1867 NVL(failure_score_commentary7, FND_API.G_MISS_CHAR),
1868 NVL(failure_score_commentary8, FND_API.G_MISS_CHAR),
1869 NVL(failure_score_commentary9, FND_API.G_MISS_CHAR),
1870 NVL(failure_score_commentary10, FND_API.G_MISS_CHAR),
1871 NVL(failure_score_date, FND_API.G_MISS_DATE),
1872 NVL(failure_score_incd_default, FND_API.G_MISS_NUM),
1873 NVL(failure_score_natnl_percentile, FND_API.G_MISS_NUM),
1874 NVL(failure_score_override_code, FND_API.G_MISS_CHAR),
1875 NVL(global_failure_score, FND_API.G_MISS_CHAR),
1876 NVL(actual_content_source, FND_API.G_MISS_CHAR)
1877 INTO
1878 x_credit_rating_id,
1879 x_description,
1880 x_party_id,
1881 x_rating,
1882 x_rated_as_of_date,
1883 x_rating_organization,
1884 x_comments,
1885 x_det_history_ind,
1886 x_fincl_embt_ind,
1887 x_criminal_proceeding_ind,
1888 x_claims_ind,
1889 x_secured_flng_ind,
1890 x_fincl_lgl_event_ind,
1891 x_disaster_ind,
1892 x_oprg_spec_evnt_ind,
1893 x_other_spec_evnt_ind,
1894 x_status,
1895 x_created_by_module,
1896 x_avg_high_credit,
1897 x_credit_score,
1898 x_credit_score_age,
1899 x_credit_score_class,
1900 x_credit_score_commentary,
1901 x_credit_score_commentary2,
1902 x_credit_score_commentary3,
1903 x_credit_score_commentary4,
1904 x_credit_score_commentary5,
1905 x_credit_score_commentary6,
1906 x_credit_score_commentary7,
1907 x_credit_score_commentary8,
1908 x_credit_score_commentary9,
1909 x_credit_score_commentary10,
1910 x_credit_score_date,
1911 x_credit_score_incd_default,
1912 x_credit_score_natl_percentile,
1913 x_debarment_ind,
1914 x_debarments_count,
1915 x_debarments_date,
1916 x_high_credit,
1917 x_maximum_credit_currency_code,
1918 x_maximum_credit_rcmd,
1919 x_paydex_norm,
1920 x_paydex_score,
1921 x_paydex_three_months_ago,
1922 x_credit_score_override_code,
1923 x_cr_scr_clas_expl,
1924 x_low_rng_delq_scr,
1925 x_high_rng_delq_scr,
1926 x_delq_pmt_rng_prcnt,
1927 x_delq_pmt_pctg_for_all_firms,
1928 x_num_trade_experiences,
1929 x_paydex_firm_days,
1930 x_paydex_firm_comment,
1931 x_paydex_industry_days,
1932 x_paydex_industry_comment,
1933 x_paydex_comment,
1934 x_suit_ind,
1935 x_lien_ind,
1936 x_judgement_ind,
1937 x_bankruptcy_ind,
1938 x_no_trade_ind,
1939 x_prnt_hq_bkcy_ind,
1940 x_num_prnt_bkcy_filing,
1941 x_prnt_bkcy_filg_type,
1942 x_prnt_bkcy_filg_chapter,
1943 x_prnt_bkcy_filg_date,
1944 x_num_prnt_bkcy_convs,
1945 x_prnt_bkcy_conv_date,
1946 x_prnt_bkcy_chapter_conv,
1947 x_slow_trade_expl,
1948 x_negv_pmt_expl,
1949 x_pub_rec_expl,
1950 x_business_discontinued,
1951 x_spcl_event_comment,
1952 x_num_spcl_event,
1953 x_spcl_event_update_date,
1954 x_spcl_evnt_txt,
1955 x_failure_score,
1956 x_failure_score_age,
1957 x_failure_score_class,
1958 x_failure_score_commentary,
1959 x_failure_score_commentary2,
1960 x_failure_score_commentary3,
1961 x_failure_score_commentary4,
1962 x_failure_score_commentary5,
1963 x_failure_score_commentary6,
1964 x_failure_score_commentary7,
1965 x_failure_score_commentary8,
1966 x_failure_score_commentary9,
1967 x_failure_score_commentary10,
1968 x_failure_score_date,
1969 x_failure_score_incd_default,
1970 x_fail_score_natnl_percentile,
1971 x_failure_score_override_code,
1972 x_global_failure_score,
1973 x_actual_content_source
1974 FROM HZ_CREDIT_RATINGS
1975 WHERE credit_rating_id = x_credit_rating_id;
1976
1977 EXCEPTION
1978 WHEN NO_DATA_FOUND THEN
1979 FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1980 FND_MESSAGE.SET_TOKEN('RECORD', 'credit_rating_rec');
1981 FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_credit_rating_id));
1982 FND_MSG_PUB.ADD;
1983 RAISE FND_API.G_EXC_ERROR;
1984
1985 END Select_Row;
1986
1987 PROCEDURE Delete_Row (
1988 x_credit_rating_id IN NUMBER
1989 ) IS
1990 BEGIN
1991
1992 DELETE FROM HZ_CREDIT_RATINGS
1993 WHERE credit_rating_id = x_credit_rating_id;
1994
1995 IF ( SQL%NOTFOUND ) THEN
1996 RAISE NO_DATA_FOUND;
1997 END IF;
1998
1999 END Delete_Row;
2000
2001 END HZ_CREDIT_RATINGS_PKG;