[Home] [Help]
TYPE BODY: APPS.HZ_CREDIT_RATING_OBJ
Source
1 TYPE BODY hz_credit_rating_obj AS
2
3 STATIC FUNCTION create_object(
4 p_credit_rating_id IN NUMBER := NULL,
5 p_description IN VARCHAR2 := NULL,
6 p_rating IN VARCHAR2 := NULL,
7 p_rated_as_of_date IN DATE := NULL,
8 p_rating_organization IN VARCHAR2 := NULL,
9 p_comments IN VARCHAR2 := NULL,
10 p_det_history_ind IN VARCHAR2 := NULL,
11 p_fincl_embt_ind IN VARCHAR2 := NULL,
12 p_criminal_proceeding_ind IN VARCHAR2 := NULL,
13 p_claims_ind IN VARCHAR2 := NULL,
14 p_secured_flng_ind IN VARCHAR2 := NULL,
15 p_fincl_lgl_event_ind IN VARCHAR2 := NULL,
16 p_disaster_ind IN VARCHAR2 := NULL,
17 p_oprg_spec_evnt_ind IN VARCHAR2 := NULL,
18 p_other_spec_evnt_ind IN VARCHAR2 := NULL,
19 p_status IN VARCHAR2 := NULL,
20 p_avg_high_credit IN NUMBER := NULL,
21 p_credit_score IN VARCHAR2 := NULL,
22 p_credit_score_age IN NUMBER := NULL,
23 p_credit_score_class IN NUMBER := NULL,
24 p_credit_score_commentary IN VARCHAR2 := NULL,
25 p_credit_score_commentary2 IN VARCHAR2 := NULL,
26 p_credit_score_commentary3 IN VARCHAR2 := NULL,
27 p_credit_score_commentary4 IN VARCHAR2 := NULL,
28 p_credit_score_commentary5 IN VARCHAR2 := NULL,
29 p_credit_score_commentary6 IN VARCHAR2 := NULL,
30 p_credit_score_commentary7 IN VARCHAR2 := NULL,
31 p_credit_score_commentary8 IN VARCHAR2 := NULL,
32 p_credit_score_commentary9 IN VARCHAR2 := NULL,
33 p_credit_score_commentary10 IN VARCHAR2 := NULL,
34 p_credit_score_date IN DATE := NULL,
35 p_credit_score_incd_default IN NUMBER := NULL,
36 p_credit_score_natl_percentile IN NUMBER := NULL,
37 p_failure_score IN VARCHAR2 := NULL,
38 p_failure_score_age IN NUMBER := NULL,
39 p_failure_score_class IN NUMBER := NULL,
40 p_failure_score_commentary IN VARCHAR2 := NULL,
41 p_failure_score_commentary2 IN VARCHAR2 := NULL,
42 p_failure_score_commentary3 IN VARCHAR2 := NULL,
43 p_failure_score_commentary4 IN VARCHAR2 := NULL,
44 p_failure_score_commentary5 IN VARCHAR2 := NULL,
45 p_failure_score_commentary6 IN VARCHAR2 := NULL,
46 p_failure_score_commentary7 IN VARCHAR2 := NULL,
47 p_failure_score_commentary8 IN VARCHAR2 := NULL,
48 p_failure_score_commentary9 IN VARCHAR2 := NULL,
49 p_failure_score_commentary10 IN VARCHAR2 := NULL,
50 p_failure_score_date IN DATE := NULL,
51 p_failure_score_incd_default IN NUMBER := NULL,
52 p_failure_score_natnl_per IN NUMBER := NULL,
53 p_failure_score_override_code IN VARCHAR2 := NULL,
54 p_global_failure_score IN VARCHAR2 := NULL,
55 p_debarment_ind IN VARCHAR2 := NULL,
56 p_debarments_count IN NUMBER := NULL,
57 p_debarments_date IN DATE := NULL,
58 p_high_credit IN NUMBER := NULL,
59 p_maximum_credit_currency_code IN VARCHAR2 := NULL,
60 p_maximum_credit_rcmd IN NUMBER := NULL,
61 p_paydex_norm IN VARCHAR2 := NULL,
62 p_paydex_score IN VARCHAR2 := NULL,
63 p_paydex_three_months_ago IN VARCHAR2 := NULL,
64 p_credit_score_override_code IN VARCHAR2 := NULL,
65 p_cr_scr_clas_expl IN VARCHAR2 := NULL,
66 p_low_rng_delq_scr IN NUMBER := NULL,
67 p_high_rng_delq_scr IN NUMBER := NULL,
68 p_delq_pmt_rng_prcnt IN NUMBER := NULL,
69 p_delq_pmt_pctg_for_all_firms IN NUMBER := NULL,
70 p_num_trade_experiences IN NUMBER := NULL,
71 p_paydex_firm_days IN VARCHAR2 := NULL,
72 p_paydex_firm_comment IN VARCHAR2 := NULL,
73 p_paydex_industry_days IN VARCHAR2 := NULL,
74 p_paydex_industry_comment IN VARCHAR2 := NULL,
75 p_paydex_comment IN VARCHAR2 := NULL,
76 p_suit_ind IN VARCHAR2 := NULL,
77 p_lien_ind IN VARCHAR2 := NULL,
78 p_judgement_ind IN VARCHAR2 := NULL,
79 p_bankruptcy_ind IN VARCHAR2 := NULL,
80 p_no_trade_ind IN VARCHAR2 := NULL,
81 p_prnt_hq_bkcy_ind IN VARCHAR2 := NULL,
82 p_num_prnt_bkcy_filing IN NUMBER := NULL,
83 p_prnt_bkcy_filg_type IN VARCHAR2 := NULL,
84 p_prnt_bkcy_filg_chapter IN NUMBER := NULL,
85 p_prnt_bkcy_filg_date IN DATE := NULL,
86 p_num_prnt_bkcy_convs IN NUMBER := NULL,
87 p_prnt_bkcy_conv_date IN DATE := NULL,
88 p_prnt_bkcy_chapter_conv IN VARCHAR2 := NULL,
89 p_slow_trade_expl IN VARCHAR2 := NULL,
90 p_negv_pmt_expl IN VARCHAR2 := NULL,
91 p_pub_rec_expl IN VARCHAR2 := NULL,
92 p_business_discontinued IN VARCHAR2 := NULL,
93 p_spcl_event_comment IN VARCHAR2 := NULL,
94 p_num_spcl_event IN NUMBER := NULL,
95 p_spcl_event_update_date IN DATE := NULL,
96 p_spcl_evnt_txt IN VARCHAR2 := NULL,
97 p_actual_content_source IN VARCHAR2 := NULL
98 ) RETURN hz_credit_rating_obj AS
99 BEGIN
100 RETURN hz_credit_rating_obj(
101 action_type => NULL,
102 common_obj_id => NULL,
103 credit_rating_id => p_credit_rating_id,
104 description => p_description,
105 organization_id => NULL,
106 rating => p_rating,
107 rated_as_of_date => p_rated_as_of_date,
108 rating_organization => p_rating_organization,
109 comments => p_comments,
110 det_history_ind => p_det_history_ind,
111 fincl_embt_ind => p_fincl_embt_ind,
112 criminal_proceeding_ind => p_criminal_proceeding_ind,
113 claims_ind => p_claims_ind,
114 secured_flng_ind => p_secured_flng_ind,
115 fincl_lgl_event_ind => p_fincl_lgl_event_ind,
116 disaster_ind => p_disaster_ind,
117 oprg_spec_evnt_ind => p_oprg_spec_evnt_ind,
118 other_spec_evnt_ind => p_other_spec_evnt_ind,
119 status => p_status,
120 avg_high_credit => p_avg_high_credit,
121 credit_score => p_credit_score,
122 credit_score_age => p_credit_score_age,
123 credit_score_class => p_credit_score_class,
124 credit_score_commentary => p_credit_score_commentary,
125 credit_score_commentary2 => p_credit_score_commentary2,
126 credit_score_commentary3 => p_credit_score_commentary3,
127 credit_score_commentary4 => p_credit_score_commentary4,
128 credit_score_commentary5 => p_credit_score_commentary5,
129 credit_score_commentary6 => p_credit_score_commentary6,
130 credit_score_commentary7 => p_credit_score_commentary7,
131 credit_score_commentary8 => p_credit_score_commentary8,
132 credit_score_commentary9 => p_credit_score_commentary9,
133 credit_score_commentary10 => p_credit_score_commentary10,
134 credit_score_date => p_credit_score_date,
135 credit_score_incd_default => p_credit_score_incd_default,
136 credit_score_natl_percentile => p_credit_score_natl_percentile,
137 failure_score => p_failure_score,
138 failure_score_age => p_failure_score_age,
139 failure_score_class => p_failure_score_class,
140 failure_score_commentary => p_failure_score_commentary,
141 failure_score_commentary2 => p_failure_score_commentary2,
142 failure_score_commentary3 => p_failure_score_commentary3,
143 failure_score_commentary4 => p_failure_score_commentary4,
144 failure_score_commentary5 => p_failure_score_commentary5,
145 failure_score_commentary6 => p_failure_score_commentary6,
146 failure_score_commentary7 => p_failure_score_commentary7,
147 failure_score_commentary8 => p_failure_score_commentary8,
148 failure_score_commentary9 => p_failure_score_commentary9,
149 failure_score_commentary10 => p_failure_score_commentary10,
150 failure_score_date => p_failure_score_date,
151 failure_score_incd_default => p_failure_score_incd_default,
152 failure_score_natnl_per => p_failure_score_natnl_per,
153 failure_score_override_code => p_failure_score_override_code,
154 global_failure_score => p_global_failure_score,
155 debarment_ind => p_debarment_ind,
156 debarments_count => p_debarments_count,
157 debarments_date => p_debarments_date,
158 high_credit => p_high_credit,
159 maximum_credit_currency_code => p_maximum_credit_currency_code,
160 maximum_credit_rcmd => p_maximum_credit_rcmd,
161 paydex_norm => p_paydex_norm,
162 paydex_score => p_paydex_score,
163 paydex_three_months_ago => p_paydex_three_months_ago,
164 credit_score_override_code => p_credit_score_override_code,
165 cr_scr_clas_expl => p_cr_scr_clas_expl,
166 low_rng_delq_scr => p_low_rng_delq_scr,
167 high_rng_delq_scr => p_high_rng_delq_scr,
168 delq_pmt_rng_prcnt => p_delq_pmt_rng_prcnt,
169 delq_pmt_pctg_for_all_firms => p_delq_pmt_pctg_for_all_firms,
170 num_trade_experiences => p_num_trade_experiences,
171 paydex_firm_days => p_paydex_firm_days,
172 paydex_firm_comment => p_paydex_firm_comment,
173 paydex_industry_days => p_paydex_industry_days,
174 paydex_industry_comment => p_paydex_industry_comment,
175 paydex_comment => p_paydex_comment,
176 suit_ind => p_suit_ind,
177 lien_ind => p_lien_ind,
178 judgement_ind => p_judgement_ind,
179 bankruptcy_ind => p_bankruptcy_ind,
180 no_trade_ind => p_no_trade_ind,
181 prnt_hq_bkcy_ind => p_prnt_hq_bkcy_ind,
182 num_prnt_bkcy_filing => p_num_prnt_bkcy_filing,
183 prnt_bkcy_filg_type => p_prnt_bkcy_filg_type,
184 prnt_bkcy_filg_chapter => p_prnt_bkcy_filg_chapter,
185 prnt_bkcy_filg_date => p_prnt_bkcy_filg_date,
186 num_prnt_bkcy_convs => p_num_prnt_bkcy_convs,
187 prnt_bkcy_conv_date => p_prnt_bkcy_conv_date,
188 prnt_bkcy_chapter_conv => p_prnt_bkcy_chapter_conv,
189 slow_trade_expl => p_slow_trade_expl,
190 negv_pmt_expl => p_negv_pmt_expl,
191 pub_rec_expl => p_pub_rec_expl,
192 business_discontinued => p_business_discontinued,
193 spcl_event_comment => p_spcl_event_comment,
194 num_spcl_event => p_num_spcl_event,
195 spcl_event_update_date => p_spcl_event_update_date,
196 spcl_evnt_txt => p_spcl_evnt_txt,
197 actual_content_source => p_actual_content_source,
198 program_update_date => NULL,
199 created_by_module => NULL,
200 created_by_name => NULL,
201 creation_date => NULL,
202 last_update_date => NULL,
203 last_updated_by_name => NULL
204 );
205 END create_object;
206 END;