[Home] [Help]
PACKAGE: APPS.HZ_PARTY_INFO_V2PUB
Source
1 PACKAGE HZ_PARTY_INFO_V2PUB AUTHID CURRENT_USER AS
2 /* $Header: ARH2PRSS.pls 120.6 2006/08/17 10:19:44 idali noship $ */
3 /*#
4 * The Credit Request Creation API creates a credit request in the Credit
5 * Management system based on the specified parameters. After the credit request
6 * is created with minimal validations, an asynchronous workflow is initiated
7 * that starts processing the credit request.
8 * @rep:scope public
9 * @rep:product HZ
10 * @rep:displayname Credit Request Creation
11 * @rep:category BUSINESS_ENTITY HZ_ORGANIZATION
12 * @rep:lifecycle active
13 * @rep:doccd 120hztig.pdf Classification API Use, Oracle Trading Community Architecture Technical Implementation Guide
14 */
15
16
17 --------------------------------------
18 -- declaration of record type
19 --------------------------------------
20
21 TYPE credit_rating_rec_type IS RECORD(
22 credit_rating_id NUMBER,
23 description VARCHAR2(2000),
24 party_id NUMBER,
25 rating VARCHAR2(60),
26 rated_as_of_date DATE,
27 rating_organization VARCHAR2(240),
28 comments VARCHAR2(240),
29 det_history_ind VARCHAR2(5),
30 fincl_embt_ind VARCHAR2(5),
31 criminal_proceeding_ind VARCHAR2(5),
32 claims_ind VARCHAR2(5),
33 secured_flng_ind VARCHAR2(5),
34 fincl_lgl_event_ind VARCHAR2(5),
35 disaster_ind VARCHAR2(5),
36 oprg_spec_evnt_ind VARCHAR2(5),
37 other_spec_evnt_ind VARCHAR2(5),
38 status VARCHAR2(1),
39 avg_high_credit NUMBER,
40 credit_score VARCHAR2(30),
41 credit_score_age NUMBER,
42 credit_score_class NUMBER,
43 credit_score_commentary VARCHAR2(30),
44 credit_score_commentary2 VARCHAR2(30),
45 credit_score_commentary3 VARCHAR2(30),
46 credit_score_commentary4 VARCHAR2(30),
47 credit_score_commentary5 VARCHAR2(30),
48 credit_score_commentary6 VARCHAR2(30),
49 credit_score_commentary7 VARCHAR2(30),
50 credit_score_commentary8 VARCHAR2(30),
51 credit_score_commentary9 VARCHAR2(30),
52 credit_score_commentary10 VARCHAR2(30),
53 credit_score_date DATE,
54 credit_score_incd_default NUMBER,
55 credit_score_natl_percentile NUMBER,
56 failure_score VARCHAR2(30),
57 failure_score_age NUMBER,
58 failure_score_class NUMBER,
59 failure_score_commentary VARCHAR2(30),
60 failure_score_commentary2 VARCHAR2(30),
61 failure_score_commentary3 VARCHAR2(30),
62 failure_score_commentary4 VARCHAR2(30),
63 failure_score_commentary5 VARCHAR2(30),
64 failure_score_commentary6 VARCHAR2(30),
65 failure_score_commentary7 VARCHAR2(30),
66 failure_score_commentary8 VARCHAR2(30),
67 failure_score_commentary9 VARCHAR2(30),
68 failure_score_commentary10 VARCHAR2(30),
69 failure_score_date DATE,
70 failure_score_incd_default NUMBER,
71 failure_score_natnl_percentile NUMBER,
72 failure_score_override_code VARCHAR2(30),
73 global_failure_score VARCHAR2(30),
74 debarment_ind VARCHAR2(30),
75 debarments_count NUMBER,
76 debarments_date DATE,
77 high_credit NUMBER,
78 maximum_credit_currency_code VARCHAR2(240),
79 maximum_credit_rcmd NUMBER,
80 paydex_norm VARCHAR2(3),
81 paydex_score VARCHAR2(3),
82 paydex_three_months_ago VARCHAR2(3),
83 credit_score_override_code VARCHAR2(30),
84 cr_scr_clas_expl VARCHAR2(30),
85 low_rng_delq_scr NUMBER,
86 high_rng_delq_scr NUMBER,
87 delq_pmt_rng_prcnt NUMBER,
88 delq_pmt_pctg_for_all_firms NUMBER,
89 num_trade_experiences NUMBER,
90 paydex_firm_days VARCHAR2(15),
91 paydex_firm_comment VARCHAR2(60),
92 paydex_industry_days VARCHAR2(15),
93 paydex_industry_comment VARCHAR2(50),
94 paydex_comment VARCHAR2(240),
95 suit_ind VARCHAR2(5),
96 lien_ind VARCHAR2(5),
97 judgement_ind VARCHAR2(5),
98 bankruptcy_ind VARCHAR2(5),
99 no_trade_ind VARCHAR2(5),
100 prnt_hq_bkcy_ind VARCHAR2(5),
101 num_prnt_bkcy_filing NUMBER,
102 prnt_bkcy_filg_type VARCHAR2(20),
103 prnt_bkcy_filg_chapter NUMBER,
104 prnt_bkcy_filg_date DATE,
105 num_prnt_bkcy_convs NUMBER,
106 prnt_bkcy_conv_date DATE,
107 prnt_bkcy_chapter_conv VARCHAR2(60),
108 slow_trade_expl VARCHAR2(100),
109 negv_pmt_expl VARCHAR2(150),
110 pub_rec_expl VARCHAR2(150),
111 business_discontinued VARCHAR2(240),
112 spcl_event_comment VARCHAR2(150),
113 num_spcl_event NUMBER,
114 spcl_event_update_date DATE,
115 spcl_evnt_txt VARCHAR2(2000),
116 actual_content_source VARCHAR2(30),
117 created_by_module VARCHAR2(150)
118 );
119
120 --------------------------------------
121 -- declaration of public procedures and functions
122 --------------------------------------
123
124 /**
125 * PROCEDURE create_credit_rating
126 *
127 * DESCRIPTION
128 * Creates credit rating.
129 *
130 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
131 *
132 * ARGUMENTS
133 * IN:
134 * p_init_msg_list Initialize message stack if it is set to
135 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
136 * p_credit_rating_rec credit rating record.
137 * IN/OUT:
138 * OUT:
139 * x_credit_rating_id Credit rating Id.
140 * x_return_status Return status after the call. The status can
141 * be FND_API.G_RET_STS_SUCCESS (success),
142 * FND_API.G_RET_STS_ERROR (error),
143 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
144 * x_msg_count Number of messages in message stack.
145 * x_msg_data Message text if x_msg_count is 1.
146 *
147 * NOTES
148 *
149 * MODIFICATION HISTORY
150 *
151 * 27-JAN-2003 Sreedhar Mohan o Created.
152 *
153 */
154
155 /*#
156 * Creates a credit rating for initiating a credit review for a party
157 * @rep:scope public
158 * @rep:lifecycle active
159 * @rep:displayname Create Credit Rating
160 * @rep:businessevent oracle.apps.ar.hz.CreditRating.create
161 * @rep:doccd 120hztig.pdf Classification API Use, Oracle Trading Community Architecture Technical Implementation Guide
162 */
163 PROCEDURE create_credit_rating(
164 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165 p_credit_rating_rec IN CREDIT_RATING_REC_TYPE,
166 x_credit_rating_id OUT NOCOPY NUMBER,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2
170 );
171
172
173 /**
174 * PROCEDURE update_credit_rating
175 *
176 * DESCRIPTION
177 * Updates credit rating.
178 *
179 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
180 *
181 * ARGUMENTS
182 * IN:
183 * p_init_msg_list Initialize message stack if it is set to
184 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
185 * p_credit_rating_rec credit rating record.
186 * IN/OUT:
187 * p_object_version_number Used for locking the being updated record.
188 * OUT:
189 * x_return_status Return status after the call. The status can
190 * be FND_API.G_RET_STS_SUCCESS (success),
191 * FND_API.G_RET_STS_ERROR (error),
192 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
193 * x_msg_count Number of messages in message stack.
194 * x_msg_data Message text if x_msg_count is 1.
195 *
196 * NOTES
197 *
198 * MODIFICATION HISTORY
199 *
200 * 27-JAN-2003 Sreedhar Mohan o Created.
201 *
202 */
203
204 /*#
205 * Update credit rating for initiating a credit review for a party
206 * @rep:scope public
207 * @rep:lifecycle active
208 * @rep:displayname Update Credit Rating
209 * @rep:businessevent oracle.apps.ar.hz.CreditRating.update
210 * @rep:doccd 120hztig.pdf Classification API Use, Oracle Trading Community Architecture Technical Implementation Guide
211 */
212 PROCEDURE update_credit_rating(
213 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214 p_credit_rating_rec IN CREDIT_RATING_REC_TYPE,
215 p_object_version_number IN OUT NOCOPY NUMBER,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2
219 );
220
221
222 /**
223 * PROCEDURE get_credit_rating_rec
224 *
225 * DESCRIPTION
226 * Gets credit rating record.
227 *
228 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
229 *
230 * ARGUMENTS
231 * IN:
232 * p_init_msg_list Initialize message stack if it is set to
233 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
234 * x_credit_rating_id Credit rating id.
235 * IN/OUT:
236 * OUT:
237 * x_credit_rating_rec Returned credit rating record.
238 * x_return_status Return status after the call. The status can
239 * be FND_API.G_RET_STS_SUCCESS (success),
240 * FND_API.G_RET_STS_ERROR (error),
241 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
242 * x_msg_count Number of messages in message stack.
243 * x_msg_data Message text if x_msg_count is 1.
244 *
245 * NOTES
246 *
247 * MODIFICATION HISTORY
248 *
249 * 27-JAN-2003 Sreedhar Mohan o Created.
250 *
251 */
252
253 PROCEDURE get_credit_rating_rec(
254 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255 p_credit_rating_id IN NUMBER,
256 x_credit_rating_rec OUT NOCOPY CREDIT_RATING_REC_TYPE,
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_count OUT NOCOPY NUMBER,
259 x_msg_data OUT NOCOPY VARCHAR2
260 );
261
262
263 END HZ_PARTY_INFO_V2PUB;