1 PACKAGE CSP_CUSTOMER_ACCOUNT_PVT AUTHID CURRENT_USER AS
2 /*$Header: cspvcuss.pls 115.3 2002/11/26 07:54:02 hhaugeru noship $*/
3 --Start of comments
4 --
5 -- API name : CSP_CUSTOMER_ACCOUNT_PVT
6 -- Type : Private
7 -- Purpose : Copy of some ERP APIs so the csp_ship_to_address_pvt won't fail due to incorrect parameters issue.
8 -- Modification History
9 -- Person Date Comments
10 -- --------- ----------- ------------------------------------------
11 -- iouyang 24-Sep-2001 New
12 --
13
14 /* This procedure is a copy of hzp_cprof_pkg.create_profile_from_class. */
15 PROCEDURE create_profile_from_class
16 (x_customer_profile_class_id in number,
17 x_customer_profile_id in OUT NOCOPY number,
18 x_customer_id in OUT NOCOPY number,
19 x_site_use_id in number,
20 x_collector_id OUT NOCOPY number,
21 x_collector_name OUT NOCOPY varchar2,
22 x_credit_checking OUT NOCOPY varchar2,
23 x_tolerance OUT NOCOPY number,
24 x_interest_charges OUT NOCOPY varchar2,
25 x_charge_on_fin_charge_flag OUT NOCOPY varchar2,
26 x_interest_period_days OUT NOCOPY number,
27 x_discount_terms OUT NOCOPY varchar2,
28 x_discount_grace_days OUT NOCOPY number,
29 x_statements OUT NOCOPY varchar2,
30 x_statement_cycle_id OUT NOCOPY number,
31 x_statement_cycle_name OUT NOCOPY varchar2,
32 x_credit_balance_statements OUT NOCOPY varchar2,
33 x_standard_terms OUT NOCOPY number,
34 x_standard_terms_name OUT NOCOPY varchar2,
35 x_override_terms OUT NOCOPY varchar2,
36 x_payment_grace_days OUT NOCOPY number,
37 x_dunning_letters OUT NOCOPY varchar2,
38 x_dunning_letter_set_id OUT NOCOPY number,
39 x_dunning_letter_set_name OUT NOCOPY varchar2,
40 x_autocash_hierarchy_id OUT NOCOPY number,
41 x_autocash_hierarchy_name OUT NOCOPY varchar2,
42 x_auto_rec_incl_disputed_flag OUT NOCOPY varchar2,
43 x_tax_printing_option OUT NOCOPY varchar2,
44 x_grouping_rule_id OUT NOCOPY number,
45 x_grouping_rule_name OUT NOCOPY varchar2,
46 x_cons_inv_flag OUT NOCOPY varchar2,
47 x_cons_inv_type OUT NOCOPY varchar2,
48 x_attribute_category OUT NOCOPY varchar2,
49 x_attribute1 OUT NOCOPY varchar2,
50 x_attribute2 OUT NOCOPY varchar2,
51 x_attribute3 OUT NOCOPY varchar2,
52 x_attribute4 OUT NOCOPY varchar2,
53 x_attribute5 OUT NOCOPY varchar2,
54 x_attribute6 OUT NOCOPY varchar2,
55 x_attribute7 OUT NOCOPY varchar2,
56 x_attribute8 OUT NOCOPY varchar2,
57 x_attribute9 OUT NOCOPY varchar2,
58 x_attribute10 OUT NOCOPY varchar2,
59 x_attribute11 OUT NOCOPY varchar2,
60 x_attribute12 OUT NOCOPY varchar2,
61 x_attribute13 OUT NOCOPY varchar2,
62 x_attribute14 OUT NOCOPY varchar2,
63 x_attribute15 OUT NOCOPY varchar2,
64 x_jgzz_attribute_category OUT NOCOPY varchar2,
65 x_jgzz_attribute1 OUT NOCOPY varchar2,
66 x_jgzz_attribute2 OUT NOCOPY varchar2,
67 x_jgzz_attribute3 OUT NOCOPY varchar2,
68 x_jgzz_attribute4 OUT NOCOPY varchar2,
69 x_jgzz_attribute5 OUT NOCOPY varchar2,
70 x_jgzz_attribute6 OUT NOCOPY varchar2,
71 x_jgzz_attribute7 OUT NOCOPY varchar2,
72 x_jgzz_attribute8 OUT NOCOPY varchar2,
73 x_jgzz_attribute9 OUT NOCOPY varchar2,
74 x_jgzz_attribute10 OUT NOCOPY varchar2,
75 x_jgzz_attribute11 OUT NOCOPY varchar2,
76 x_jgzz_attribute12 OUT NOCOPY varchar2,
77 x_jgzz_attribute13 OUT NOCOPY varchar2,
78 x_jgzz_attribute14 OUT NOCOPY varchar2,
79 x_jgzz_attribute15 OUT NOCOPY varchar2,
80 x_global_attribute_category OUT NOCOPY varchar2,
81 x_global_attribute1 OUT NOCOPY varchar2,
82 x_global_attribute2 OUT NOCOPY varchar2,
83 x_global_attribute3 OUT NOCOPY varchar2,
84 x_global_attribute4 OUT NOCOPY varchar2,
85 x_global_attribute5 OUT NOCOPY varchar2,
86 x_global_attribute6 OUT NOCOPY varchar2,
87 x_global_attribute7 OUT NOCOPY varchar2,
88 x_global_attribute8 OUT NOCOPY varchar2,
89 x_global_attribute9 OUT NOCOPY varchar2,
90 x_global_attribute10 OUT NOCOPY varchar2,
91 x_global_attribute11 OUT NOCOPY varchar2,
92 x_global_attribute12 OUT NOCOPY varchar2,
93 x_global_attribute13 OUT NOCOPY varchar2,
94 x_global_attribute14 OUT NOCOPY varchar2,
95 x_global_attribute15 OUT NOCOPY varchar2,
96 x_global_attribute16 OUT NOCOPY varchar2,
97 x_global_attribute17 OUT NOCOPY varchar2,
98 x_global_attribute18 OUT NOCOPY varchar2,
99 x_global_attribute19 OUT NOCOPY varchar2,
100 x_global_attribute20 OUT NOCOPY varchar2,
101 x_lockbox_matching_option OUT NOCOPY varchar2,
102 x_lockbox_matching_name OUT NOCOPY varchar2,
103 x_autocash_hierarchy_id_adr OUT NOCOPY number,
104 x_autocash_hierarchy_name_adr OUT NOCOPY varchar2,
105 x_return_status OUT NOCOPY varchar2,
106 x_msg_count OUT NOCOPY number,
107 x_msg_data OUT NOCOPY varchar2);
108
109
110 /* This procedure is a copy of hz_acct_create_pkg.insert_person_row. */
111 PROCEDURE insert_person_row
112 (c_cust_account_id IN OUT NOCOPY NUMBER ,
113 c_party_id IN OUT NOCOPY NUMBER,
114 c_account_number IN OUT NOCOPY VARCHAR2,
115 c_Attribute_Category IN VARCHAR2,
116 c_Attribute1 IN VARCHAR2,
117 c_Attribute2 IN VARCHAR2,
118 c_Attribute3 IN VARCHAR2,
119 c_Attribute4 IN VARCHAR2,
120 c_Attribute5 IN VARCHAR2,
121 c_Attribute6 IN VARCHAR2,
122 c_Attribute7 IN VARCHAR2,
123 c_Attribute8 IN VARCHAR2,
124 c_Attribute9 IN VARCHAR2,
125 c_Attribute10 IN VARCHAR2,
126 c_Attribute11 IN VARCHAR2,
127 c_Attribute12 IN VARCHAR2,
128 c_Attribute13 IN VARCHAR2,
129 c_Attribute14 IN VARCHAR2,
130 c_Attribute15 IN VARCHAR2,
131 c_Attribute16 IN VARCHAR2,
132 c_Attribute17 IN VARCHAR2,
133 c_Attribute18 IN VARCHAR2,
134 c_Attribute19 IN VARCHAR2,
135 c_Attribute20 IN VARCHAR2,
136 c_global_attribute_category IN VARCHAR2,
137 c_global_attribute1 IN VARCHAR2,
138 c_global_attribute2 IN VARCHAR2,
139 c_global_attribute3 IN VARCHAR2,
140 c_global_attribute4 IN VARCHAR2,
141 c_global_attribute5 IN VARCHAR2,
142 c_global_attribute6 IN VARCHAR2,
143 c_global_attribute7 IN VARCHAR2,
144 c_global_attribute8 IN VARCHAR2,
145 c_global_attribute9 IN VARCHAR2,
146 c_global_attribute10 IN VARCHAR2,
147 c_global_attribute11 IN VARCHAR2,
148 c_global_attribute12 IN VARCHAR2,
149 c_global_attribute13 IN VARCHAR2,
150 c_global_attribute14 IN VARCHAR2,
151 c_global_attribute15 IN VARCHAR2,
152 c_global_attribute16 IN VARCHAR2,
153 c_global_attribute17 IN VARCHAR2,
154 c_global_attribute18 IN VARCHAR2,
155 c_global_attribute19 IN VARCHAR2,
156 c_global_attribute20 IN VARCHAR2,
157 c_orig_system_reference IN VARCHAR2,
158 c_status IN VARCHAR2,
159 c_customer_type IN VARCHAR2,
160 c_customer_class_code IN VARCHAR2,
161 c_primary_salesrep_id IN NUMBER ,
162 c_sales_channel_code IN VARCHAR2,
163 c_order_type_id IN NUMBER,
164 c_price_list_id IN NUMBER ,
165 c_category_code IN VARCHAR2,
166 c_reference_use_flag IN VARCHAR2,
167 c_tax_code IN VARCHAR2,
168 c_third_party_flag IN VARCHAR2,
169 c_competitor_flag IN VARCHAR2,
170 c_fob_point IN VARCHAR2,
171 c_tax_header_level_flag IN VARCHAR2,
172 c_tax_rounding_rule IN VARCHAR2,
173 c_account_name IN VARCHAR2,
174 c_freight_term IN VARCHAR2,
175 c_ship_partial IN VARCHAR2,
176 c_ship_via IN VARCHAR2,
177 c_warehouse_id IN NUMBER,
178 c_payment_term_id IN NUMBER ,
179 c_DATES_NEGATIVE_TOLERANCE IN NUMBER,
180 c_DATES_POSITIVE_TOLERANCE IN NUMBER,
181 c_DATE_TYPE_PREFERENCE IN VARCHAR2,
182 c_OVER_SHIPMENT_TOLERANCE IN NUMBER,
183 c_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
184 c_ITEM_CROSS_REF_PREF IN VARCHAR2,
185 c_OVER_RETURN_TOLERANCE IN NUMBER,
186 c_UNDER_RETURN_TOLERANCE IN NUMBER,
187 c_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
188 c_ARRIVALSETS_INCL_LINES_FLAG IN VARCHAR2,
189 c_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
190 c_INVOICE_QUANTITY_RULE IN VARCHAR2,
191 t_party_id IN NUMBER ,
192 t_party_number IN OUT NOCOPY VARCHAR2,
193 t_customer_key IN VARCHAR2,
194 t_Attribute_Category IN VARCHAR2,
195 t_Attribute1 IN VARCHAR2,
196 t_Attribute2 IN VARCHAR2,
197 t_Attribute3 IN VARCHAR2,
198 t_Attribute4 IN VARCHAR2,
199 t_Attribute5 IN VARCHAR2,
200 t_Attribute6 IN VARCHAR2,
201 t_Attribute7 IN VARCHAR2,
202 t_Attribute8 IN VARCHAR2,
203 t_Attribute9 IN VARCHAR2,
204 t_Attribute10 IN VARCHAR2,
205 t_Attribute11 IN VARCHAR2,
206 t_Attribute12 IN VARCHAR2,
207 t_Attribute13 IN VARCHAR2,
208 t_Attribute14 IN VARCHAR2,
209 t_Attribute15 IN VARCHAR2,
210 t_Attribute16 IN VARCHAR2,
211 t_Attribute17 IN VARCHAR2,
212 t_Attribute18 IN VARCHAR2,
213 t_Attribute19 IN VARCHAR2,
214 t_Attribute20 IN VARCHAR2,
215 t_global_attribute_category IN VARCHAR2,
216 t_global_attribute1 IN VARCHAR2,
217 t_global_attribute2 IN VARCHAR2,
218 t_global_attribute3 IN VARCHAR2,
219 t_global_attribute4 IN VARCHAR2,
220 t_global_attribute5 IN VARCHAR2,
221 t_global_attribute6 IN VARCHAR2,
222 t_global_attribute7 IN VARCHAR2,
223 t_global_attribute8 IN VARCHAR2,
224 t_global_attribute9 IN VARCHAR2,
225 t_global_attribute10 IN VARCHAR2,
226 t_global_attribute11 IN VARCHAR2,
227 t_global_attribute12 IN VARCHAR2,
228 t_global_attribute13 IN VARCHAR2,
229 t_global_attribute14 IN VARCHAR2,
230 t_global_attribute15 IN VARCHAR2,
231 t_global_attribute16 IN VARCHAR2,
232 t_global_attribute17 IN VARCHAR2,
233 t_global_attribute18 IN VARCHAR2,
234 t_global_attribute19 IN VARCHAR2,
235 t_global_attribute20 IN VARCHAR2,
236 o_pre_name_adjunct IN VARCHAR2,
237 o_first_name IN VARCHAR2,
238 o_middle_name IN VARCHAR2,
239 o_last_name IN VARCHAR2,
240 o_name_suffix IN VARCHAR2,
241 o_tax_reference IN VARCHAR2,
242 o_taxpayer_id IN VARCHAR2,
243 o_party_name_phonetic IN VARCHAR2,
244 p_cust_account_profile_id IN NUMBER ,
245 p_cust_account_id IN NUMBER ,
246 p_status IN VARCHAR2,
247 p_collector_id IN NUMBER ,
248 p_credit_analyst_id IN NUMBER ,
249 p_credit_checking IN VARCHAR2,
250 p_next_credit_review_date DATE ,
251 p_tolerance IN NUMBER,
252 p_discount_terms IN VARCHAR2,
253 p_dunning_letters IN VARCHAR2,
254 p_interest_charges IN VARCHAR2,
255 p_send_statements IN VARCHAR2,
256 p_credit_balance_statements IN VARCHAR2,
257 p_credit_hold IN VARCHAR2,
258 p_profile_class_id IN NUMBER ,
259 p_site_use_id IN NUMBER ,
260 p_credit_rating IN VARCHAR2,
261 p_risk_code IN VARCHAR2,
265 p_interest_period_days IN NUMBER,
262 p_standard_terms IN NUMBER ,
263 p_override_terms IN VARCHAR2,
264 p_dunning_letter_set_id IN NUMBER,
266 p_payment_grace_days IN NUMBER,
267 p_discount_grace_days IN NUMBER,
268 p_statement_cycle_id IN NUMBER ,
269 p_account_status IN VARCHAR2,
270 p_percent_collectable IN NUMBER ,
271 p_autocash_hierarchy_id IN NUMBER,
272 p_Attribute_Category IN VARCHAR2,
273 p_Attribute1 IN VARCHAR2,
274 p_Attribute2 IN VARCHAR2,
275 p_Attribute3 IN VARCHAR2,
276 p_Attribute4 IN VARCHAR2,
277 p_Attribute5 IN VARCHAR2,
278 p_Attribute6 IN VARCHAR2,
279 p_Attribute7 IN VARCHAR2,
280 p_Attribute8 IN VARCHAR2,
281 p_Attribute9 IN VARCHAR2,
282 p_Attribute10 IN VARCHAR2,
283 p_Attribute11 IN VARCHAR2,
284 p_Attribute12 IN VARCHAR2,
285 p_Attribute13 IN VARCHAR2,
286 p_Attribute14 IN VARCHAR2,
287 p_Attribute15 IN VARCHAR2,
288 p_auto_rec_incl_disputed_flag IN VARCHAR2,
289 p_tax_printing_option IN VARCHAR2,
290 p_charge_on_fin_charge_flag IN VARCHAR2,
291 p_grouping_rule_id IN NUMBER ,
292 p_clearing_days IN NUMBER,
293 p_jgzz_attribute_category IN VARCHAR2,
294 p_jgzz_attribute1 IN VARCHAR2,
295 p_jgzz_attribute2 IN VARCHAR2,
296 p_jgzz_attribute3 IN VARCHAR2,
297 p_jgzz_attribute4 IN VARCHAR2,
298 p_jgzz_attribute5 IN VARCHAR2,
299 p_jgzz_attribute6 IN VARCHAR2,
300 p_jgzz_attribute7 IN VARCHAR2,
301 p_jgzz_attribute8 IN VARCHAR2,
302 p_jgzz_attribute9 IN VARCHAR2,
303 p_jgzz_attribute10 IN VARCHAR2,
304 p_jgzz_attribute11 IN VARCHAR2,
305 p_jgzz_attribute12 IN VARCHAR2,
306 p_jgzz_attribute13 IN VARCHAR2,
307 p_jgzz_attribute14 IN VARCHAR2,
308 p_jgzz_attribute15 IN VARCHAR2,
309 p_global_attribute_category IN VARCHAR2,
310 p_global_attribute1 IN VARCHAR2,
311 p_global_attribute2 IN VARCHAR2,
312 p_global_attribute3 IN VARCHAR2,
313 p_global_attribute4 IN VARCHAR2,
314 p_global_attribute5 IN VARCHAR2,
315 p_global_attribute6 IN VARCHAR2,
316 p_global_attribute7 IN VARCHAR2,
317 p_global_attribute8 IN VARCHAR2,
318 p_global_attribute9 IN VARCHAR2,
319 p_global_attribute10 IN VARCHAR2,
320 p_global_attribute11 IN VARCHAR2,
321 p_global_attribute12 IN VARCHAR2,
322 p_global_attribute13 IN VARCHAR2,
323 p_global_attribute14 IN VARCHAR2,
324 p_global_attribute15 IN VARCHAR2,
325 p_global_attribute16 IN VARCHAR2,
326 p_global_attribute17 IN VARCHAR2,
327 p_global_attribute18 IN VARCHAR2,
328 p_global_attribute19 IN VARCHAR2,
329 p_global_attribute20 IN VARCHAR2,
330 p_cons_inv_flag IN VARCHAR2,
331 p_cons_inv_type IN VARCHAR2,
332 p_autocash_hier_id_for_adr IN NUMBER ,
333 p_lockbox_matching_option IN VARCHAR2,
334 o_person_profile_id in OUT NOCOPY number,
335 x_msg_count OUT NOCOPY NUMBER,
336 x_msg_data OUT NOCOPY varchar2,
337 x_return_status OUT NOCOPY VARCHAR2);
338
339 END CSP_CUSTOMER_ACCOUNT_PVT;