1 PACKAGE HZ_IMP_LOAD_CREDITRATINGS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHLCRDS.pls 120.11 2005/10/30 04:20:24 appldev noship $*/
3
4 --TYPE insert_cursor_type IS REF CURSOR;
5 TYPE update_cursor_type IS REF CURSOR;
6 TYPE ROWID IS TABLE OF VARCHAR2(50); -- isn't row id about 60 chars?
7 TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CREDITRTNGS_SG.ACTION_FLAG%TYPE;
8 TYPE AVG_HIGH_CREDIT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.AVG_HIGH_CREDIT%TYPE;
9 TYPE BANKRUPTCY_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.BANKRUPTCY_IND%TYPE;
10 TYPE BUSINESS_DISCONTINUED IS TABLE OF HZ_IMP_CREDITRTNGS_INT.BUSINESS_DISCONTINUED%TYPE;
11 TYPE CLAIMS_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CLAIMS_IND%TYPE;
12 TYPE COMMENTS IS TABLE OF HZ_IMP_CREDITRTNGS_INT.COMMENTS%TYPE;
13 TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREATED_BY_MODULE%TYPE;
14 TYPE CREDIT_RATING_ID IS TABLE OF HZ_IMP_CREDITRTNGS_SG.CREDIT_RATING_ID%TYPE;
15 TYPE CREDIT_SCORE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE%TYPE;
16 TYPE CREDIT_SCORE_AGE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_AGE%TYPE;
17 TYPE CREDIT_SCORE_CLASS IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_CLASS%TYPE;
18 TYPE CREDIT_SCORE_COMMENTARY IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_COMMENTARY%TYPE;
19 TYPE CREDIT_SCORE_COMMENTARY10 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_COMMENTARY10%TYPE;
20 TYPE CREDIT_SCORE_COMMENTARY2 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_COMMENTARY2%TYPE;
21 TYPE CREDIT_SCORE_COMMENTARY3 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_COMMENTARY3%TYPE;
22 TYPE CREDIT_SCORE_COMMENTARY4 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_COMMENTARY4%TYPE;
23 TYPE CREDIT_SCORE_COMMENTARY5 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_COMMENTARY5%TYPE;
24 TYPE CREDIT_SCORE_COMMENTARY6 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_COMMENTARY6%TYPE;
25 TYPE CREDIT_SCORE_COMMENTARY7 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_COMMENTARY7%TYPE;
26 TYPE CREDIT_SCORE_COMMENTARY8 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_COMMENTARY8%TYPE;
27 TYPE CREDIT_SCORE_COMMENTARY9 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_COMMENTARY9%TYPE;
28 TYPE CREDIT_SCORE_DATE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_DATE%TYPE;
29 TYPE CREDIT_SCORE_INCD_DEFAULT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_INCD_DEFAULT%TYPE;
30 TYPE CREDIT_SCORE_NATL_PERCENTILE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_NATL_PERCENTILE%TYPE;
31 TYPE CREDIT_SCORE_OVERRIDE_CODE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_OVERRIDE_CODE%TYPE;
32 TYPE CRIMINAL_PROCEEDING_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CRIMINAL_PROCEEDING_IND%TYPE;
33 TYPE CR_SCR_CLAS_EXPL IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CR_SCR_CLAS_EXPL%TYPE;
34 TYPE DEBARMENTS_COUNT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.DEBARMENTS_COUNT%TYPE;
35 TYPE DEBARMENTS_DATE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.DEBARMENTS_DATE%TYPE;
36 TYPE DEBARMENT_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.DEBARMENT_IND%TYPE;
37 TYPE DELQ_PMT_PCTG_FOR_ALL_FIRMS IS TABLE OF HZ_IMP_CREDITRTNGS_INT.DELQ_PMT_PCTG_FOR_ALL_FIRMS%TYPE;
38 TYPE DELQ_PMT_RNG_PRCNT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.DELQ_PMT_RNG_PRCNT%TYPE;
39 TYPE DESCRIPTION IS TABLE OF HZ_IMP_CREDITRTNGS_INT.DESCRIPTION%TYPE;
40 TYPE DET_HISTORY_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.DET_HISTORY_IND%TYPE;
41 TYPE DISASTER_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.DISASTER_IND%TYPE;
42
43 TYPE FAILURE_SCORE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE%TYPE;
44 TYPE FAILURE_SCORE_AGE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_AGE%TYPE;
45 TYPE FAILURE_SCORE_CLASS IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_CLASS%TYPE;
46 TYPE FAILURE_SCORE_COMMENTARY IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_COMMENTARY%TYPE;
47 TYPE FAILURE_SCORE_COMMENTARY10 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_COMMENTARY10%TYPE;
48 TYPE FAILURE_SCORE_COMMENTARY2 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_COMMENTARY2%TYPE;
49 TYPE FAILURE_SCORE_COMMENTARY3 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_COMMENTARY3%TYPE;
50 TYPE FAILURE_SCORE_COMMENTARY4 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_COMMENTARY4%TYPE;
51 TYPE FAILURE_SCORE_COMMENTARY5 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_COMMENTARY5%TYPE;
52 TYPE FAILURE_SCORE_COMMENTARY6 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_COMMENTARY6%TYPE;
53 TYPE FAILURE_SCORE_COMMENTARY7 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_COMMENTARY7%TYPE;
54 TYPE FAILURE_SCORE_COMMENTARY8 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_COMMENTARY8%TYPE;
55 TYPE FAILURE_SCORE_COMMENTARY9 IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_COMMENTARY9%TYPE;
56 TYPE FAILURE_SCORE_DATE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_DATE%TYPE;
57 TYPE FAILURE_SCORE_INCD_DEFAULT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_INCD_DEFAULT%TYPE;
58 TYPE FAILURE_SCORE_NATNL_PERCENTILE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_NATNL_PERCENTILE%TYPE;
59 TYPE FAILURE_SCORE_OVERRIDE_CODE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FAILURE_SCORE_OVERRIDE_CODE%TYPE;
60 TYPE FINCL_EMBT_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FINCL_EMBT_IND%TYPE;
61 TYPE FINCL_LGL_EVENT_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.FINCL_LGL_EVENT_IND%TYPE;
62 TYPE GLOBAL_FAILURE_SCORE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.GLOBAL_FAILURE_SCORE%TYPE;
63 TYPE HIGH_CREDIT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.HIGH_CREDIT%TYPE;
64 TYPE HIGH_RNG_DELQ_SCR IS TABLE OF HZ_IMP_CREDITRTNGS_INT.HIGH_RNG_DELQ_SCR%TYPE;
65 TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CREDITRTNGS_INT.INSERT_UPDATE_FLAG%TYPE;
66 TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CREDITRTNGS_INT.INTERFACE_STATUS%TYPE;
67 TYPE JUDGEMENT_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.JUDGEMENT_IND%TYPE;
68 TYPE LIEN_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.LIEN_IND%TYPE;
69 TYPE LOW_RNG_DELQ_SCR IS TABLE OF HZ_IMP_CREDITRTNGS_INT.LOW_RNG_DELQ_SCR%TYPE;
70 TYPE MAXIMUM_CREDIT_CURRENCY_CODE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.MAXIMUM_CREDIT_CURRENCY_CODE%TYPE;
71 TYPE MAXIMUM_CREDIT_RECOMMENDATION IS TABLE OF HZ_IMP_CREDITRTNGS_INT.MAXIMUM_CREDIT_RECOMMENDATION%TYPE;
72 TYPE NEGV_PMT_EXPL IS TABLE OF HZ_IMP_CREDITRTNGS_INT.NEGV_PMT_EXPL%TYPE;
73 TYPE NO_TRADE_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.NO_TRADE_IND%TYPE;
74 TYPE NUM_PRNT_BKCY_CONVS IS TABLE OF HZ_IMP_CREDITRTNGS_INT.NUM_PRNT_BKCY_CONVS%TYPE;
75 TYPE NUM_PRNT_BKCY_FILING IS TABLE OF HZ_IMP_CREDITRTNGS_INT.NUM_PRNT_BKCY_FILING%TYPE;
76 TYPE NUM_SPCL_EVENT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.NUM_SPCL_EVENT%TYPE;
77 TYPE NUM_TRADE_EXPERIENCES IS TABLE OF HZ_IMP_CREDITRTNGS_INT.NUM_TRADE_EXPERIENCES%TYPE;
78 TYPE OPRG_SPEC_EVNT_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.OPRG_SPEC_EVNT_IND%TYPE;
79 TYPE OTHER_SPEC_EVNT_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.OTHER_SPEC_EVNT_IND%TYPE;
80 TYPE PARENT_PARTY_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID%TYPE;
81 TYPE PARTY_ID IS TABLE OF HZ_IMP_CREDITRTNGS_SG.PARTY_ID%TYPE;
82 TYPE PARTY_ORIG_SYSTEM IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PARTY_ORIG_SYSTEM%TYPE;
83 TYPE PARTY_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
84 TYPE PAYDEX_COMMENT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PAYDEX_COMMENT%TYPE;
85 TYPE PAYDEX_FIRM_COMMENT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PAYDEX_FIRM_COMMENT%TYPE;
86 TYPE PAYDEX_FIRM_DAYS IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PAYDEX_FIRM_DAYS%TYPE;
87 TYPE PAYDEX_INDUSTRY_COMMENT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PAYDEX_INDUSTRY_COMMENT%TYPE;
88 TYPE PAYDEX_INDUSTRY_DAYS IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PAYDEX_INDUSTRY_DAYS%TYPE;
89 TYPE PAYDEX_NORM IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PAYDEX_NORM%TYPE;
90 TYPE PAYDEX_SCORE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PAYDEX_SCORE%TYPE;
91 TYPE PAYDEX_THREE_MONTHS_AGO IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PAYDEX_THREE_MONTHS_AGO%TYPE;
92 TYPE PRNT_BKCY_CHAPTER_CONV IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PRNT_BKCY_CHAPTER_CONV%TYPE;
93 TYPE PRNT_BKCY_CONV_DATE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PRNT_BKCY_CONV_DATE%TYPE;
94 TYPE PRNT_BKCY_FILG_DATE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PRNT_BKCY_FILG_DATE%TYPE;
95 TYPE PRNT_BKCY_FILG_TYPE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PRNT_BKCY_FILG_TYPE%TYPE;
96 TYPE PRNT_BKCY_FILG_CHAPTER IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PRNT_BKCY_FILG_CHAPTER%TYPE;
97 TYPE PRNT_HQ_BKCY_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PRNT_HQ_BKCY_IND%TYPE;
98 TYPE PUB_REC_EXPL IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PUB_REC_EXPL%TYPE;
99 TYPE RATED_AS_OF_DATE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.RATED_AS_OF_DATE%TYPE;
100 TYPE RATING IS TABLE OF HZ_IMP_CREDITRTNGS_INT.RATING%TYPE;
101 TYPE RATING_ORGANIZATION IS TABLE OF HZ_IMP_CREDITRTNGS_INT.RATING_ORGANIZATION%TYPE;
102 TYPE SECURED_FLNG_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.SECURED_FLNG_IND%TYPE;
103 TYPE SLOW_TRADE_EXPL IS TABLE OF HZ_IMP_CREDITRTNGS_INT.SLOW_TRADE_EXPL%TYPE;
104 TYPE SPCL_EVENT_COMMENT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.SPCL_EVENT_COMMENT%TYPE;
105 TYPE SPCL_EVENT_UPDATE_DATE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.SPCL_EVENT_UPDATE_DATE%TYPE;
106 TYPE SPCL_EVNT_TXT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.SPCL_EVNT_TXT%TYPE;
107 TYPE SUIT_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.SUIT_IND%TYPE;
108
109 TYPE LOOKUP_ERROR IS TABLE OF ar_lookups.lookup_code%TYPE;
110 TYPE FLAG_ERROR IS TABLE OF VARCHAR2(1);
111 TYPE TYPE_COLUMN IS TABLE OF VARCHAR2(30);
112 TYPE NUMBER_COLUMN IS TABLE OF NUMBER;
113
114 PROCEDURE load_creditratings (
115 P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
116 ,x_return_status OUT NOCOPY VARCHAR2
117 ,x_msg_count OUT NOCOPY NUMBER
118 ,x_msg_data OUT NOCOPY VARCHAR2 ) ;
119
120
121 END HZ_IMP_LOAD_CREDITRATINGS_PKG; -- Package spec