[Home] [Help]
PACKAGE: APPS.HZ_PARTY_INFO_PUB
Source
1 package HZ_PARTY_INFO_PUB AS
2 /*$Header: ARHPTISS.pls 120.3 2005/06/24 16:03:51 sponnamb ship $ */
3
4 G_MISS_CONTENT_SOURCE_TYPE CONSTANT VARCHAR2(30) := 'USER_ENTERED';
5
6 -------------------------------------------------------------------------
7 TYPE credit_ratings_rec_type IS RECORD(
8 credit_rating_id NUMBER := FND_API.G_MISS_NUM,
9 description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
10 party_id NUMBER := FND_API.G_MISS_NUM,
11 rating VARCHAR2(60) := FND_API.G_MISS_CHAR,
12 rated_as_of_date DATE := FND_API.G_MISS_DATE,
13 rating_organization VARCHAR2(240) := FND_API.G_MISS_CHAR,
14 wh_update_date DATE := FND_API.G_MISS_DATE,
15 comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
16 det_history_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
17 fincl_embt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
18 criminal_proceeding_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
19 suit_judge_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
20 claims_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
21 secured_flng_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
22 fincl_lgl_event_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
23 disaster_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
24 oprg_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
25 other_spec_evnt_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
26 content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
27 status VARCHAR2(1) := FND_API.G_MISS_CHAR,
28 avg_high_credit NUMBER := FND_API.G_MISS_NUM,
29 credit_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
30 credit_score_age NUMBER := FND_API.G_MISS_NUM,
31 credit_score_class NUMBER := FND_API.G_MISS_NUM,
32 credit_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
33 credit_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
34 credit_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
35 credit_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
36 credit_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
37 credit_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
38 credit_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
39 credit_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
40 credit_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
41 credit_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
42 credit_score_date DATE := FND_API.G_MISS_DATE,
43 credit_score_incd_default NUMBER := FND_API.G_MISS_NUM,
44 credit_score_natl_percentile NUMBER := FND_API.G_MISS_NUM,
45 failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
46 failure_score_age NUMBER := FND_API.G_MISS_NUM,
47 failure_score_class NUMBER := FND_API.G_MISS_NUM,
48 failure_score_commentary VARCHAR2(30) := FND_API.G_MISS_CHAR,
49 failure_score_commentary2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
50 failure_score_commentary3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
51 failure_score_commentary4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
52 failure_score_commentary5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
53 failure_score_commentary6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
54 failure_score_commentary7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
55 failure_score_commentary8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
56 failure_score_commentary9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
57 failure_score_commentary10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
58 failure_score_date DATE := FND_API.G_MISS_DATE,
59 failure_score_incd_default NUMBER := FND_API.G_MISS_NUM,
60 failure_score_natnl_percentile NUMBER := FND_API.G_MISS_NUM,
61 failure_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62 global_failure_score VARCHAR2(30) := FND_API.G_MISS_CHAR,
63 debarment_ind VARCHAR2(30) := FND_API.G_MISS_CHAR,
64 debarments_count NUMBER := FND_API.G_MISS_NUM,
65 debarments_date DATE := FND_API.G_MISS_DATE,
66 high_credit NUMBER := FND_API.G_MISS_NUM,
67 maximum_credit_currency_code VARCHAR2(240) := FND_API.G_MISS_CHAR,
68 maximum_credit_rcmd NUMBER := FND_API.G_MISS_NUM,
69 paydex_norm VARCHAR2(3) := FND_API.G_MISS_CHAR,
70 paydex_score VARCHAR2(3) := FND_API.G_MISS_CHAR,
71 paydex_three_months_ago VARCHAR2(3) := FND_API.G_MISS_CHAR,
72 credit_score_override_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73 cr_scr_clas_expl VARCHAR2(30) := FND_API.G_MISS_CHAR,
74 low_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
75 high_rng_delq_scr NUMBER := FND_API.G_MISS_NUM,
76 delq_pmt_rng_prcnt NUMBER := FND_API.G_MISS_NUM,
77 delq_pmt_pctg_for_all_firms NUMBER := FND_API.G_MISS_NUM,
78 num_trade_experiences NUMBER := FND_API.G_MISS_NUM,
79 paydex_firm_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
80 paydex_firm_comment VARCHAR2(60) := FND_API.G_MISS_CHAR,
81 paydex_industry_days VARCHAR2(15) := FND_API.G_MISS_CHAR,
82 paydex_industry_comment VARCHAR2(50) := FND_API.G_MISS_CHAR,
83 paydex_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
84 suit_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
85 lien_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
86 judgement_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
87 bankruptcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
88 no_trade_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
89 prnt_hq_bkcy_ind VARCHAR2(5) := FND_API.G_MISS_CHAR,
90 num_prnt_bkcy_filing NUMBER := FND_API.G_MISS_NUM,
91 prnt_bkcy_filg_type VARCHAR2(20) := FND_API.G_MISS_CHAR,
92 prnt_bkcy_filg_chapter NUMBER := FND_API.G_MISS_NUM,
93 prnt_bkcy_filg_date DATE := FND_API.G_MISS_DATE,
94 num_prnt_bkcy_convs NUMBER := FND_API.G_MISS_NUM,
95 prnt_bkcy_conv_date DATE := FND_API.G_MISS_DATE,
96 prnt_bkcy_chapter_conv VARCHAR2(60) := FND_API.G_MISS_CHAR,
97 slow_trade_expl VARCHAR2(100) := FND_API.G_MISS_CHAR,
98 negv_pmt_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
99 pub_rec_expl VARCHAR2(150) := FND_API.G_MISS_CHAR,
100 business_discontinued VARCHAR2(240) := FND_API.G_MISS_CHAR,
101 spcl_event_comment VARCHAR2(150) := FND_API.G_MISS_CHAR,
102 num_spcl_event NUMBER := FND_API.G_MISS_NUM,
103 spcl_event_update_date DATE := FND_API.G_MISS_DATE,
104 spcl_evnt_txt VARCHAR2(2000) := FND_API.G_MISS_CHAR,
105 actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
106 );
107
108
109 TYPE financial_profile_rec_type IS RECORD(
110 financial_profile_id NUMBER := FND_API.G_MISS_NUM,
111 access_authority_date DATE := FND_API.G_MISS_DATE,
112 access_authority_granted VARCHAR2(1) := FND_API.G_MISS_CHAR,
113 balance_amount NUMBER := FND_API.G_MISS_NUM,
114 balance_verified_on_date DATE := FND_API.G_MISS_DATE,
115 financial_account_number VARCHAR2(60) := FND_API.G_MISS_CHAR,
116 financial_account_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
117 financial_org_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
118 financial_organization_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
119 party_id NUMBER := FND_API.G_MISS_NUM,
120 wh_update_date DATE := FND_API.G_MISS_DATE,
121 status varchar2(1) := FND_API.G_MISS_CHAR);
122
123 ----------------------------------------------------------------------------
124 /* Obsolete V1 API
125 procedure create_credit_ratings(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
128 p_commit IN VARCHAR2:= FND_API.G_FALSE,
129 p_credit_ratings_rec IN CREDIT_RATINGS_REC_TYPE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 x_credit_rating_id OUT NOCOPY NUMBER,
134 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
135 );
136
137
138 procedure update_credit_ratings(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
141 p_commit IN VARCHAR2:= FND_API.G_FALSE,
142 p_credit_ratings_rec IN CREDIT_RATINGS_REC_TYPE,
143 p_last_update_date IN OUT NOCOPY DATE,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
148 );
149
150 */
151 procedure create_financial_profile(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
154 p_commit IN VARCHAR2:= FND_API.G_FALSE,
155 p_financial_profile_rec IN FINANCIAL_PROFILE_REC_TYPE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 x_financial_profile_id OUT NOCOPY NUMBER,
160 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
161 );
162
163
164 procedure update_financial_profile(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
167 p_commit IN VARCHAR2:= FND_API.G_FALSE,
168 p_financial_profile_rec IN FINANCIAL_PROFILE_REC_TYPE,
169 p_last_update_date IN OUT NOCOPY DATE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
174 );
175
176
177 procedure get_current_credit_rating(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
180 p_credit_rating_id IN NUMBER,
181 x_credit_ratings_rec OUT NOCOPY CREDIT_RATINGS_REC_TYPE,
182 x_return_status IN OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2
185 );
186
187
188 END HZ_PARTY_INFO_PUB;