[Home] [Help]
PACKAGE: APPS.HZP_CPROF_PKG
Source
1 PACKAGE hzp_cprof_pkg AUTHID CURRENT_USER as
2 /* $Header: ARHCPRFS.pls 120.8 2005/06/16 21:09:32 jhuang ship $ */
3
4 PROCEDURE Insert_Row(
5 X_Customer_Profile_Id IN OUT NOCOPY NUMBER,
6 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
7 X_Collector_Id NUMBER,
8 X_Created_By NUMBER,
9 X_Creation_Date DATE,
10 X_Credit_Balance_Statements VARCHAR2,
11 X_Credit_Checking VARCHAR2,
12 X_Credit_Hold VARCHAR2,
13 X_Customer_Id NUMBER,
14 X_Discount_Terms VARCHAR2,
15 X_Dunning_Letters VARCHAR2,
16 X_Interest_Charges VARCHAR2,
17 X_Last_Updated_By NUMBER,
18 X_Last_Update_Date DATE,
19 X_Statements VARCHAR2,
20 X_Status VARCHAR2,
21 X_Tolerance NUMBER,
22 X_Tax_Printing_Option VARCHAR2,
23 X_Account_Status VARCHAR2,
24 X_Autocash_Hierarchy_Id NUMBER,
25 X_Credit_Rating VARCHAR2,
26 X_Customer_Profile_Class_Id NUMBER,
27 X_Discount_Grace_Days NUMBER,
28 X_Dunning_Letter_Set_Id NUMBER,
29 X_Interest_Period_Days NUMBER,
30 X_Last_Update_Login NUMBER,
31 X_Override_Terms VARCHAR2,
32 X_Payment_Grace_Days NUMBER,
33 X_Percent_Collectable NUMBER,
34 X_Risk_Code VARCHAR2,
35 X_Site_Use_Id NUMBER,
36 X_Standard_Terms NUMBER,
37 X_Statement_Cycle_Id NUMBER,
38 X_Attribute_Category VARCHAR2,
39 X_Attribute1 VARCHAR2,
40 X_Attribute2 VARCHAR2,
41 X_Attribute3 VARCHAR2,
42 X_Attribute4 VARCHAR2,
43 X_Attribute5 VARCHAR2,
44 X_Attribute6 VARCHAR2,
45 X_Attribute7 VARCHAR2,
46 X_Attribute8 VARCHAR2,
47 X_Attribute9 VARCHAR2,
48 X_Attribute10 VARCHAR2,
49 X_Attribute11 VARCHAR2,
50 X_Attribute12 VARCHAR2,
51 X_Attribute13 VARCHAR2,
52 X_Attribute14 VARCHAR2,
53 X_Attribute15 VARCHAR2,
54 X_Charge_On_Fin_Charge_Flag VARCHAR2,
55 X_Grouping_Rule_Id NUMBER,
56 X_Cons_Inv_Flag VARCHAR2,
57 X_Cons_Inv_Type VARCHAR2,
58 X_Clearing_Days NUMBER,
59 X_Jgzz_attribute_Category VARCHAR2,
60 X_Jgzz_attribute1 VARCHAR2,
61 X_Jgzz_attribute2 VARCHAR2,
62 X_Jgzz_attribute3 VARCHAR2,
63 X_Jgzz_attribute4 VARCHAR2,
64 X_Jgzz_attribute5 VARCHAR2,
65 X_Jgzz_attribute6 VARCHAR2,
66 X_Jgzz_attribute7 VARCHAR2,
67 X_Jgzz_attribute8 VARCHAR2,
68 X_Jgzz_attribute9 VARCHAR2,
69 X_Jgzz_attribute10 VARCHAR2,
70 X_Jgzz_attribute11 VARCHAR2,
71 X_Jgzz_attribute12 VARCHAR2,
72 X_Jgzz_attribute13 VARCHAR2,
73 X_Jgzz_attribute14 VARCHAR2,
74 X_Jgzz_attribute15 VARCHAR2,
75 X_global_attribute_category VARCHAR2,
76 X_global_attribute1 VARCHAR2,
77 X_global_attribute2 VARCHAR2,
78 X_global_attribute3 VARCHAR2,
79 X_global_attribute4 VARCHAR2,
80 X_global_attribute5 VARCHAR2,
81 X_global_attribute6 VARCHAR2,
82 X_global_attribute7 VARCHAR2,
83 X_global_attribute8 VARCHAR2,
84 X_global_attribute9 VARCHAR2,
85 X_global_attribute10 VARCHAR2,
86 X_global_attribute11 VARCHAR2,
87 X_global_attribute12 VARCHAR2,
88 X_global_attribute13 VARCHAR2,
89 X_global_attribute14 VARCHAR2,
90 X_global_attribute15 VARCHAR2,
91 X_global_attribute16 VARCHAR2,
92 X_global_attribute17 VARCHAR2,
93 X_global_attribute18 VARCHAR2,
94 X_global_attribute19 VARCHAR2,
95 X_global_attribute20 VARCHAR2,
96 X_lockbox_matching_option VARCHAR2,
97 X_autocash_hierarchy_id_adr NUMBER,
98 --{BUG 2310474
99 X_Review_Cycle VARCHAR2 DEFAULT NULL,
100 X_Credit_Classification VARCHAR2 DEFAULT NULL,
101 X_Next_Credit_Review_Date DATE DEFAULT NULL,
102 X_Last_Credit_Review_Date DATE DEFAULT NULL,
103 X_Credit_Analyst_id NUMBER DEFAULT NULL,
104 X_Party_id NUMBER DEFAULT NULL,
105 --}
106 x_return_status out NOCOPY varchar2,
107 x_msg_count out NOCOPY number,
108 x_msg_data out NOCOPY varchar2
109 );
110
111 PROCEDURE insert_row( x_customer_id number,
112 x_site_use_id number,
113 x_customer_profile_class_id number,
114 --{2310474
115 x_party_id NUMBER DEFAULT NULL,
116 x_last_credit_review_date DATE DEFAULT NULL,
117 x_next_credit_review_date DATE DEFAULT NULL
118 --}
119 );
120
121
122
123
124 PROCEDURE Update_Row(X_Rowid VARCHAR2,
125 X_Customer_Profile_Id NUMBER,
126 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
127 X_Collector_Id NUMBER,
128 X_Credit_Balance_Statements VARCHAR2,
129 X_Credit_Checking VARCHAR2,
130 X_Credit_Hold VARCHAR2,
131 X_Customer_Id NUMBER,
132 X_Discount_Terms VARCHAR2,
133 X_Dunning_Letters VARCHAR2,
134 X_Interest_Charges VARCHAR2,
135 X_Last_Updated_By NUMBER,
136 X_Last_Update_Date DATE,
137 X_Statements VARCHAR2,
138 X_Status VARCHAR2,
139 X_Tolerance NUMBER,
140 X_Tax_Printing_Option VARCHAR2,
141 X_Account_Status VARCHAR2,
142 X_Autocash_Hierarchy_Id NUMBER,
143 X_Credit_Rating VARCHAR2,
144 X_Customer_Profile_Class_Id NUMBER,
145 X_Discount_Grace_Days NUMBER,
146 X_Dunning_Letter_Set_Id NUMBER,
147 X_Interest_Period_Days NUMBER,
148 X_Last_Update_Login NUMBER,
149 X_Override_Terms VARCHAR2,
150 X_Payment_Grace_Days NUMBER,
151 X_Percent_Collectable NUMBER,
152 X_Risk_Code VARCHAR2,
153 X_Site_Use_Id NUMBER,
154 X_Standard_Terms NUMBER,
155 X_Statement_Cycle_Id NUMBER,
156 X_Attribute_Category VARCHAR2,
157 X_Attribute1 VARCHAR2,
158 X_Attribute2 VARCHAR2,
159 X_Attribute3 VARCHAR2,
160 X_Attribute4 VARCHAR2,
161 X_Attribute5 VARCHAR2,
162 X_Attribute6 VARCHAR2,
163 X_Attribute7 VARCHAR2,
164 X_Attribute8 VARCHAR2,
165 X_Attribute9 VARCHAR2,
166 X_Attribute10 VARCHAR2,
167 X_Attribute11 VARCHAR2,
168 X_Attribute12 VARCHAR2,
169 X_Attribute13 VARCHAR2,
170 X_Attribute14 VARCHAR2,
171 X_Attribute15 VARCHAR2,
172 X_Charge_On_Fin_Charge_Flag VARCHAR2,
173 X_Grouping_Rule_Id NUMBER,
174 X_Cons_Inv_Flag VARCHAR2,
175 X_Cons_Inv_Type VARCHAR2,
176 X_Clearing_Days NUMBER,
177 X_Jgzz_attribute_Category VARCHAR2,
178 X_Jgzz_attribute1 VARCHAR2,
179 X_Jgzz_attribute2 VARCHAR2,
180 X_Jgzz_attribute3 VARCHAR2,
181 X_Jgzz_attribute4 VARCHAR2,
182 X_Jgzz_attribute5 VARCHAR2,
183 X_Jgzz_attribute6 VARCHAR2,
184 X_Jgzz_attribute7 VARCHAR2,
185 X_Jgzz_attribute8 VARCHAR2,
186 X_Jgzz_attribute9 VARCHAR2,
187 X_Jgzz_attribute10 VARCHAR2,
188 X_Jgzz_attribute11 VARCHAR2,
189 X_Jgzz_attribute12 VARCHAR2,
190 X_Jgzz_attribute13 VARCHAR2,
191 X_Jgzz_attribute14 VARCHAR2,
192 X_Jgzz_attribute15 VARCHAR2,
193 X_global_attribute_category VARCHAR2,
194 X_global_attribute1 VARCHAR2,
195 X_global_attribute2 VARCHAR2,
196 X_global_attribute3 VARCHAR2,
197 X_global_attribute4 VARCHAR2,
198 X_global_attribute5 VARCHAR2,
199 X_global_attribute6 VARCHAR2,
200 X_global_attribute7 VARCHAR2,
201 X_global_attribute8 VARCHAR2,
202 X_global_attribute9 VARCHAR2,
203 X_global_attribute10 VARCHAR2,
204 X_global_attribute11 VARCHAR2,
205 X_global_attribute12 VARCHAR2,
206 X_global_attribute13 VARCHAR2,
207 X_global_attribute14 VARCHAR2,
208 X_global_attribute15 VARCHAR2,
209 X_global_attribute16 VARCHAR2,
210 X_global_attribute17 VARCHAR2,
211 X_global_attribute18 VARCHAR2,
212 X_global_attribute19 VARCHAR2,
213 X_global_attribute20 VARCHAR2,
214 X_lockbox_matching_option VARCHAR2,
215 X_autocash_hierarchy_id_adr NUMBER,
216 --{2310474
217 X_party_id NUMBER DEFAULT NULL,
218 X_review_cycle VARCHAR2 DEFAULT NULL,
219 X_credit_classification VARCHAR2 DEFAULT NULL,
220 X_credit_analyst_id NUMBER DEFAULT NULL,
221 X_last_credit_review_date DATE DEFAULT NULL,
222 X_next_credit_review_date DATE DEFAULT NULL,
223 --}
224 X_OBJECT_VERSION IN NUMBER DEFAULT -1
225 );
226
227 PROCEDURE create_profile_from_class
228 ( x_customer_profile_class_id in number,
229 x_customer_profile_id in out NOCOPY number,
230 x_customer_id in out NOCOPY number,
231 x_site_use_id in number,
232 x_collector_id out NOCOPY number,
233 x_collector_name out NOCOPY varchar2,
234 x_credit_checking out NOCOPY varchar2,
235 x_tolerance out NOCOPY number,
236 x_interest_charges out NOCOPY varchar2,
237 x_charge_on_fin_charge_flag out NOCOPY varchar2,
238 x_interest_period_days out NOCOPY number,
239 x_discount_terms out NOCOPY varchar2,
240 x_discount_grace_days out NOCOPY number,
241 x_statements out NOCOPY varchar2,
242 x_statement_cycle_id out NOCOPY number,
243 x_statement_cycle_name out NOCOPY varchar2,
244 x_credit_balance_statements out NOCOPY varchar2,
245 x_standard_terms out NOCOPY number,
246 x_standard_terms_name out NOCOPY varchar2,
247 x_override_terms out NOCOPY varchar2,
248 x_payment_grace_days out NOCOPY number,
249 x_dunning_letters out NOCOPY varchar2,
250 x_dunning_letter_set_id out NOCOPY number,
251 x_dunning_letter_set_name out NOCOPY varchar2,
252 x_autocash_hierarchy_id out NOCOPY number,
253 x_autocash_hierarchy_name out NOCOPY varchar2,
254 x_auto_rec_incl_disputed_flag out NOCOPY varchar2,
255 x_tax_printing_option out NOCOPY varchar2,
256 x_grouping_rule_id out NOCOPY number,
257 x_grouping_rule_name out NOCOPY varchar2,
258 x_cons_inv_flag out NOCOPY varchar2,
259 x_cons_inv_type out NOCOPY varchar2,
260 x_attribute_category out NOCOPY varchar2,
261 x_attribute1 out NOCOPY varchar2,
262 x_attribute2 out NOCOPY varchar2,
263 x_attribute3 out NOCOPY varchar2,
264 x_attribute4 out NOCOPY varchar2,
265 x_attribute5 out NOCOPY varchar2,
266 x_attribute6 out NOCOPY varchar2,
267 x_attribute7 out NOCOPY varchar2,
268 x_attribute8 out NOCOPY varchar2,
269 x_attribute9 out NOCOPY varchar2,
270 x_attribute10 out NOCOPY varchar2,
271 x_attribute11 out NOCOPY varchar2,
272 x_attribute12 out NOCOPY varchar2,
273 x_attribute13 out NOCOPY varchar2,
274 x_attribute14 out NOCOPY varchar2,
275 x_attribute15 out NOCOPY varchar2,
276 x_jgzz_attribute_category out NOCOPY varchar2,
277 x_jgzz_attribute1 out NOCOPY varchar2,
278 x_jgzz_attribute2 out NOCOPY varchar2,
279 x_jgzz_attribute3 out NOCOPY varchar2,
280 x_jgzz_attribute4 out NOCOPY varchar2,
281 x_jgzz_attribute5 out NOCOPY varchar2,
282 x_jgzz_attribute6 out NOCOPY varchar2,
283 x_jgzz_attribute7 out NOCOPY varchar2,
287 x_jgzz_attribute11 out NOCOPY varchar2,
284 x_jgzz_attribute8 out NOCOPY varchar2,
285 x_jgzz_attribute9 out NOCOPY varchar2,
286 x_jgzz_attribute10 out NOCOPY varchar2,
288 x_jgzz_attribute12 out NOCOPY varchar2,
289 x_jgzz_attribute13 out NOCOPY varchar2,
290 x_jgzz_attribute14 out NOCOPY varchar2,
291 x_jgzz_attribute15 out NOCOPY varchar2,
292 x_lockbox_matching_option out NOCOPY varchar2,
293 x_lockbox_matching_name out NOCOPY varchar2,
294 x_autocash_hierarchy_id_adr out NOCOPY number,
295 x_autocash_hierarchy_name_adr out NOCOPY varchar2,
296 x_return_status out NOCOPY varchar2,
297 x_msg_count out NOCOPY number,
298 x_msg_data out NOCOPY varchar2,
299 --{BUG#3046535
300 p_keep_replace IN VARCHAR2 DEFAULT 'KEEP'
301 --}
302 );
303
304 --
305 PROCEDURE create_profile_from_class
306 ( x_customer_profile_class_id in number,
307 x_customer_profile_id in out NOCOPY number,
308 x_customer_id in out NOCOPY number,
309 x_site_use_id in number,
310 x_collector_id out NOCOPY number,
311 x_collector_name out NOCOPY varchar2,
312 x_credit_checking out NOCOPY varchar2,
313 x_tolerance out NOCOPY number,
314 x_interest_charges out NOCOPY varchar2,
315 x_charge_on_fin_charge_flag out NOCOPY varchar2,
316 x_interest_period_days out NOCOPY number,
317 x_discount_terms out NOCOPY varchar2,
318 x_discount_grace_days out NOCOPY number,
319 x_statements out NOCOPY varchar2,
320 x_statement_cycle_id out NOCOPY number,
321 x_statement_cycle_name out NOCOPY varchar2,
322 x_credit_balance_statements out NOCOPY varchar2,
323 x_standard_terms out NOCOPY number,
324 x_standard_terms_name out NOCOPY varchar2,
325 x_override_terms out NOCOPY varchar2,
326 x_payment_grace_days out NOCOPY number,
327 x_dunning_letters out NOCOPY varchar2,
328 x_dunning_letter_set_id out NOCOPY number,
329 x_dunning_letter_set_name out NOCOPY varchar2,
330 x_autocash_hierarchy_id out NOCOPY number,
331 x_autocash_hierarchy_name out NOCOPY varchar2,
332 x_auto_rec_incl_disputed_flag out NOCOPY varchar2,
333 x_tax_printing_option out NOCOPY varchar2,
334 x_grouping_rule_id out NOCOPY number,
335 x_grouping_rule_name out NOCOPY varchar2,
336 x_cons_inv_flag out NOCOPY varchar2,
337 x_cons_inv_type out NOCOPY varchar2,
338 x_attribute_category out NOCOPY varchar2,
339 x_attribute1 out NOCOPY varchar2,
340 x_attribute2 out NOCOPY varchar2,
341 x_attribute3 out NOCOPY varchar2,
342 x_attribute4 out NOCOPY varchar2,
343 x_attribute5 out NOCOPY varchar2,
344 x_attribute6 out NOCOPY varchar2,
345 x_attribute7 out NOCOPY varchar2,
346 x_attribute8 out NOCOPY varchar2,
347 x_attribute9 out NOCOPY varchar2,
348 x_attribute10 out NOCOPY varchar2,
349 x_attribute11 out NOCOPY varchar2,
350 x_attribute12 out NOCOPY varchar2,
351 x_attribute13 out NOCOPY varchar2,
352 x_attribute14 out NOCOPY varchar2,
353 x_attribute15 out NOCOPY varchar2,
354 x_jgzz_attribute_category out NOCOPY varchar2,
355 x_jgzz_attribute1 out NOCOPY varchar2,
356 x_jgzz_attribute2 out NOCOPY varchar2,
357 x_jgzz_attribute3 out NOCOPY varchar2,
358 x_jgzz_attribute4 out NOCOPY varchar2,
359 x_jgzz_attribute5 out NOCOPY varchar2,
360 x_jgzz_attribute6 out NOCOPY varchar2,
361 x_jgzz_attribute7 out NOCOPY varchar2,
362 x_jgzz_attribute8 out NOCOPY varchar2,
363 x_jgzz_attribute9 out NOCOPY varchar2,
364 x_jgzz_attribute10 out NOCOPY varchar2,
365 x_jgzz_attribute11 out NOCOPY varchar2,
366 x_jgzz_attribute12 out NOCOPY varchar2,
367 x_jgzz_attribute13 out NOCOPY varchar2,
368 x_jgzz_attribute14 out NOCOPY varchar2,
369 x_jgzz_attribute15 out NOCOPY varchar2,
370 x_lockbox_matching_option out NOCOPY varchar2,
371 x_lockbox_matching_name out NOCOPY varchar2,
372 x_autocash_hierarchy_id_adr out NOCOPY number,
373 x_autocash_hierarchy_name_adr out NOCOPY varchar2,
374 --{2310474
375 x_review_cycle out NOCOPY varchar2,
376 x_credit_classification out NOCOPY varchar2,
377 x_credit_classification_m out NOCOPY varchar2,
378 x_review_cycle_name out NOCOPY varchar2,
379 x_credit_analyst_id out NOCOPY number,
380 x_credit_analyst_name out NOCOPY varchar2,
381 --}
382 x_return_status out NOCOPY varchar2,
383 x_msg_count out NOCOPY number,
384 x_msg_data out NOCOPY varchar2,
385 --{BUG#3046535
386 p_keep_replace IN VARCHAR2 DEFAULT 'KEEP'
387 --}
388 );
389
393 | PARAMETERS : |
390 /*---------------------------------------------------------------+
391 | PROCEDURE : CREATE_PROFILE_AMOUNT |
392 | |
394 | Arguments in the record type |
395 | Hz_Customer_Profile_V2pub.Cust_Profile_Amt_Rec_Type |
396 | |
397 | DESCRIPTION : |
398 | From the arguments entered contruct the recors type and call |
399 | Hz_Customer_Profile_V2pub.create_cust_profile_amt |
400 | |
401 | HISTORY : |
402 | 12-DEC-2002 H. Yu Created |
403 | 16/07/04 Bhushan Dhotkar bug3751887 :Replaced 'TCA-FORM-WRAPPER'
404 | to 'TCA_FORM_WRAPPER' for created_by_module|
405 +---------------------------------------------------------------*/
406 PROCEDURE create_profile_amount
407 ( p_cust_account_profile_id IN NUMBER,
408 p_currency_code IN VARCHAR2,
409 p_trx_credit_limit IN NUMBER,
410 p_overall_credit_limit IN NUMBER,
411 p_min_dunning_amount IN NUMBER,
412 p_min_dunning_invoice_amount IN NUMBER,
413 p_max_interest_charge IN NUMBER,
414 p_min_statement_amount IN NUMBER,
415 p_auto_rec_min_receipt_amount IN NUMBER,
416 p_interest_rate IN NUMBER,
417 p_attribute_category IN VARCHAR2 DEFAULT NULL,
418 p_attribute1 IN VARCHAR2 DEFAULT NULL,
419 p_attribute2 IN VARCHAR2 DEFAULT NULL,
420 p_attribute3 IN VARCHAR2 DEFAULT NULL,
421 p_attribute4 IN VARCHAR2 DEFAULT NULL,
422 p_attribute5 IN VARCHAR2 DEFAULT NULL,
423 p_attribute6 IN VARCHAR2 DEFAULT NULL,
424 p_attribute7 IN VARCHAR2 DEFAULT NULL,
425 p_attribute8 IN VARCHAR2 DEFAULT NULL,
426 p_attribute9 IN VARCHAR2 DEFAULT NULL,
427 p_attribute10 IN VARCHAR2 DEFAULT NULL,
428 p_attribute11 IN VARCHAR2 DEFAULT NULL,
429 p_attribute12 IN VARCHAR2 DEFAULT NULL,
430 p_attribute13 IN VARCHAR2 DEFAULT NULL,
431 p_attribute14 IN VARCHAR2 DEFAULT NULL,
432 p_attribute15 IN VARCHAR2 DEFAULT NULL,
433 p_min_fc_balance_amount IN NUMBER,
434 p_min_fc_invoice_amount IN NUMBER,
435 p_cust_account_id IN NUMBER,
436 p_site_use_id IN NUMBER,
437 p_expiration_date IN DATE,
438 p_jgzz_attribute_category IN VARCHAR2 DEFAULT NULL,
439 p_jgzz_attribute1 IN VARCHAR2 DEFAULT NULL,
440 p_jgzz_attribute2 IN VARCHAR2 DEFAULT NULL,
441 p_jgzz_attribute3 IN VARCHAR2 DEFAULT NULL,
442 p_jgzz_attribute4 IN VARCHAR2 DEFAULT NULL,
443 p_jgzz_attribute5 IN VARCHAR2 DEFAULT NULL,
444 p_jgzz_attribute6 IN VARCHAR2 DEFAULT NULL,
445 p_jgzz_attribute7 IN VARCHAR2 DEFAULT NULL,
446 p_jgzz_attribute8 IN VARCHAR2 DEFAULT NULL,
447 p_jgzz_attribute9 IN VARCHAR2 DEFAULT NULL,
448 p_jgzz_attribute10 IN VARCHAR2 DEFAULT NULL,
449 p_jgzz_attribute11 IN VARCHAR2 DEFAULT NULL,
450 p_jgzz_attribute12 IN VARCHAR2 DEFAULT NULL,
451 p_jgzz_attribute13 IN VARCHAR2 DEFAULT NULL,
452 p_jgzz_attribute14 IN VARCHAR2 DEFAULT NULL,
453 p_jgzz_attribute15 IN VARCHAR2 DEFAULT NULL,
454 p_global_attribute1 IN VARCHAR2 DEFAULT NULL,
455 p_global_attribute2 IN VARCHAR2 DEFAULT NULL,
456 p_global_attribute3 IN VARCHAR2 DEFAULT NULL,
457 p_global_attribute4 IN VARCHAR2 DEFAULT NULL,
458 p_global_attribute5 IN VARCHAR2 DEFAULT NULL,
459 p_global_attribute6 IN VARCHAR2 DEFAULT NULL,
460 p_global_attribute7 IN VARCHAR2 DEFAULT NULL,
461 p_global_attribute8 IN VARCHAR2 DEFAULT NULL,
462 p_global_attribute9 IN VARCHAR2 DEFAULT NULL,
463 p_global_attribute10 IN VARCHAR2 DEFAULT NULL,
464 p_global_attribute11 IN VARCHAR2 DEFAULT NULL,
465 p_global_attribute12 IN VARCHAR2 DEFAULT NULL,
466 p_global_attribute13 IN VARCHAR2 DEFAULT NULL,
467 p_global_attribute14 IN VARCHAR2 DEFAULT NULL,
468 p_global_attribute15 IN VARCHAR2 DEFAULT NULL,
469 p_global_attribute16 IN VARCHAR2 DEFAULT NULL,
470 p_global_attribute17 IN VARCHAR2 DEFAULT NULL,
471 p_global_attribute18 IN VARCHAR2 DEFAULT NULL,
472 p_global_attribute19 IN VARCHAR2 DEFAULT NULL,
473 p_global_attribute20 IN VARCHAR2 DEFAULT NULL,
474 p_global_attribute_category IN VARCHAR2 DEFAULT NULL,
475 p_created_by_module IN VARCHAR2 DEFAULT 'TCA_FORM_WRAPPER',
476 p_application_id IN NUMBER DEFAULT NULL,
480 x_msg_data OUT NOCOPY VARCHAR2 );
477 x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
478 x_return_status OUT NOCOPY VARCHAR2,
479 x_msg_count OUT NOCOPY NUMBER,
481
482
483 /*---------------------------------------------------------------+
484 | PROCEDURE : UPDATE_PROFILE_AMOUNT |
485 | |
486 | PARAMETERS : |
487 | Arguments in the record type |
488 | Hz_Customer_Profile_V2pub.Cust_Profile_Amt_Rec_Type |
489 | |
490 | DESCRIPTION : |
491 | From the arguments entered contruct the recors type and call |
492 | Hz_Customer_Profile_V2pub.update_cust_profile_amt |
493 | |
494 | HISTORY : |
495 | 12-DEC-2002 H. Yu Created |
496 +---------------------------------------------------------------*/
497 PROCEDURE update_profile_amount
498 ( p_cust_acct_profile_amt_id IN NUMBER,
499 p_cust_account_profile_id IN NUMBER,
500 p_currency_code IN VARCHAR2,
501 p_trx_credit_limit IN NUMBER,
502 p_overall_credit_limit IN NUMBER,
503 p_min_dunning_amount IN NUMBER,
504 p_min_dunning_invoice_amount IN NUMBER,
505 p_max_interest_charge IN NUMBER,
506 p_min_statement_amount IN NUMBER,
507 p_auto_rec_min_receipt_amount IN NUMBER,
508 p_interest_rate IN NUMBER,
509 p_attribute_category IN VARCHAR2 DEFAULT NULL,
510 p_attribute1 IN VARCHAR2 DEFAULT NULL,
511 p_attribute2 IN VARCHAR2 DEFAULT NULL,
512 p_attribute3 IN VARCHAR2 DEFAULT NULL,
513 p_attribute4 IN VARCHAR2 DEFAULT NULL,
514 p_attribute5 IN VARCHAR2 DEFAULT NULL,
515 p_attribute6 IN VARCHAR2 DEFAULT NULL,
516 p_attribute7 IN VARCHAR2 DEFAULT NULL,
517 p_attribute8 IN VARCHAR2 DEFAULT NULL,
518 p_attribute9 IN VARCHAR2 DEFAULT NULL,
519 p_attribute10 IN VARCHAR2 DEFAULT NULL,
520 p_attribute11 IN VARCHAR2 DEFAULT NULL,
521 p_attribute12 IN VARCHAR2 DEFAULT NULL,
522 p_attribute13 IN VARCHAR2 DEFAULT NULL,
523 p_attribute14 IN VARCHAR2 DEFAULT NULL,
524 p_attribute15 IN VARCHAR2 DEFAULT NULL,
525 p_min_fc_balance_amount IN NUMBER,
526 p_min_fc_invoice_amount IN NUMBER,
527 p_cust_account_id IN NUMBER,
528 p_site_use_id IN NUMBER,
529 p_expiration_date IN DATE,
530 p_jgzz_attribute_category IN VARCHAR2 DEFAULT NULL,
531 p_jgzz_attribute1 IN VARCHAR2 DEFAULT NULL,
532 p_jgzz_attribute2 IN VARCHAR2 DEFAULT NULL,
533 p_jgzz_attribute3 IN VARCHAR2 DEFAULT NULL,
534 p_jgzz_attribute4 IN VARCHAR2 DEFAULT NULL,
535 p_jgzz_attribute5 IN VARCHAR2 DEFAULT NULL,
536 p_jgzz_attribute6 IN VARCHAR2 DEFAULT NULL,
537 p_jgzz_attribute7 IN VARCHAR2 DEFAULT NULL,
538 p_jgzz_attribute8 IN VARCHAR2 DEFAULT NULL,
539 p_jgzz_attribute9 IN VARCHAR2 DEFAULT NULL,
540 p_jgzz_attribute10 IN VARCHAR2 DEFAULT NULL,
541 p_jgzz_attribute11 IN VARCHAR2 DEFAULT NULL,
542 p_jgzz_attribute12 IN VARCHAR2 DEFAULT NULL,
543 p_jgzz_attribute13 IN VARCHAR2 DEFAULT NULL,
544 p_jgzz_attribute14 IN VARCHAR2 DEFAULT NULL,
545 p_jgzz_attribute15 IN VARCHAR2 DEFAULT NULL,
546 p_global_attribute1 IN VARCHAR2 DEFAULT NULL,
547 p_global_attribute2 IN VARCHAR2 DEFAULT NULL,
548 p_global_attribute3 IN VARCHAR2 DEFAULT NULL,
549 p_global_attribute4 IN VARCHAR2 DEFAULT NULL,
550 p_global_attribute5 IN VARCHAR2 DEFAULT NULL,
551 p_global_attribute6 IN VARCHAR2 DEFAULT NULL,
552 p_global_attribute7 IN VARCHAR2 DEFAULT NULL,
553 p_global_attribute8 IN VARCHAR2 DEFAULT NULL,
554 p_global_attribute9 IN VARCHAR2 DEFAULT NULL,
555 p_global_attribute10 IN VARCHAR2 DEFAULT NULL,
556 p_global_attribute11 IN VARCHAR2 DEFAULT NULL,
557 p_global_attribute12 IN VARCHAR2 DEFAULT NULL,
558 p_global_attribute13 IN VARCHAR2 DEFAULT NULL,
559 p_global_attribute14 IN VARCHAR2 DEFAULT NULL,
560 p_global_attribute15 IN VARCHAR2 DEFAULT NULL,
561 p_global_attribute16 IN VARCHAR2 DEFAULT NULL,
562 p_global_attribute17 IN VARCHAR2 DEFAULT NULL,
563 p_global_attribute18 IN VARCHAR2 DEFAULT NULL,
564 p_global_attribute19 IN VARCHAR2 DEFAULT NULL,
565 p_global_attribute20 IN VARCHAR2 DEFAULT NULL,
569 x_msg_data OUT NOCOPY VARCHAR2,
566 p_global_attribute_category IN VARCHAR2 DEFAULT NULL,
567 x_return_status OUT NOCOPY VARCHAR2,
568 x_msg_count OUT NOCOPY NUMBER,
570 p_object_version IN NUMBER DEFAULT -1,
571 X_Last_Update_Date IN DATE);
572
573 /*---------------------------------------------------------------+
574 | PROCEDURE : DELETE_PROFILE_AMOUNT |
575 | |
576 | PARAMETERS : |
577 | NUMBER Customer_profile_amt_id |
578 | |
579 | DESCRIPTION : |
580 | Delete a record from Hz_Cust_Profile_Amts |
581 | |
582 | HISTORY : |
583 | 12-DEC-2002 H. Yu Created |
584 +---------------------------------------------------------------*/
585 PROCEDURE delete_profile_amount
586 (p_cust_acct_profile_amt_id IN NUMBER,
587 x_return_status OUT NOCOPY VARCHAR2,
588 x_msg_count OUT NOCOPY NUMBER,
589 x_msg_data OUT NOCOPY VARCHAR2);
590
591 END hzp_cprof_pkg;