[Home] [Help]
PACKAGE: APPS.ARH_CPC_PKG
Source
1 PACKAGE ARH_CPC_PKG as
2 /*$Header: ARHCPCS.pls 120.5 2006/02/14 20:07:36 hyu ship $*/
3
4 PROCEDURE sel_class (x_customer_profile_class_id IN NUMBER,
5 x_collector_id IN OUT NOCOPY NUMBER,
6 x_collector_name IN OUT NOCOPY VARCHAR2,
7 x_credit_checking IN OUT NOCOPY VARCHAR2,
8 x_tolerance IN OUT NOCOPY VARCHAR2,
9 x_interest_charges IN OUT NOCOPY VARCHAR2,
10 x_charge_on_fin_charge_flag IN OUT NOCOPY VARCHAR2,
11 x_interest_period_days IN OUT NOCOPY NUMBER,
12 x_discount_terms IN OUT NOCOPY VARCHAR2,
13 x_discount_grace_days IN OUT NOCOPY NUMBER,
14 x_statements IN OUT NOCOPY VARCHAR2,
15 x_statement_cycle_id IN OUT NOCOPY NUMBER,
16 x_statement_cycle_name IN OUT NOCOPY VARCHAR2,
17 x_credit_balance_statements IN OUT NOCOPY VARCHAR2,
18 x_standard_terms IN OUT NOCOPY NUMBER,
19 x_standard_terms_name IN OUT NOCOPY VARCHAR2,
20 x_override_terms IN OUT NOCOPY VARCHAR2,
21 x_payment_grace_days IN OUT NOCOPY NUMBER,
22 x_dunning_letters IN OUT NOCOPY VARCHAR2,
23 x_dunning_letter_set_id IN OUT NOCOPY NUMBER,
24 x_dunning_letter_set_name IN OUT NOCOPY VARCHAR2,
25 x_autocash_hierarchy_id IN OUT NOCOPY NUMBER,
26 x_autocash_hierarchy_name IN OUT NOCOPY VARCHAR2,
27 x_auto_rec_incl_disputed_flag IN OUT NOCOPY VARCHAR2,
28 x_tax_printing_option IN OUT NOCOPY VARCHAR2,
29 x_grouping_rule_id IN OUT NOCOPY VARCHAR2,
30 x_grouping_rule_name IN OUT NOCOPY VARCHAR2,
31 x_attribute_category IN OUT NOCOPY VARCHAR2,
32 x_attribute1 IN OUT NOCOPY VARCHAR2,
33 x_attribute2 IN OUT NOCOPY VARCHAR2,
34 x_attribute3 IN OUT NOCOPY VARCHAR2,
35 x_attribute4 IN OUT NOCOPY VARCHAR2,
36 x_attribute5 IN OUT NOCOPY VARCHAR2,
37 x_attribute6 IN OUT NOCOPY VARCHAR2,
38 x_attribute7 IN OUT NOCOPY VARCHAR2,
39 x_attribute8 IN OUT NOCOPY VARCHAR2,
40 x_attribute9 IN OUT NOCOPY VARCHAR2,
41 x_attribute10 IN OUT NOCOPY VARCHAR2,
42 x_attribute11 IN OUT NOCOPY VARCHAR2,
43 x_attribute12 IN OUT NOCOPY VARCHAR2,
44 x_attribute13 IN OUT NOCOPY VARCHAR2,
45 x_attribute14 IN OUT NOCOPY VARCHAR2,
46 x_attribute15 IN OUT NOCOPY VARCHAR2,
47 x_review_cycle IN OUT NOCOPY VARCHAR2,
48 x_credit_analyst_id IN OUT NOCOPY NUMBER
49 );
50 --
51 --
52 PROCEDURE check_unique
53 ( c_profile_class_name in VARCHAR2,
54 c_rowid in VARCHAR2 );
55 --
56 --
57 PROCEDURE Insert_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
58 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER ,
59 X_Last_Updated_By NUMBER,
60 X_Last_Update_Date DATE,
61 X_Last_Update_Login NUMBER,
62 X_Created_By NUMBER,
63 X_Creation_Date DATE,
64 X_Profile_Class_Name VARCHAR2,
65 X_Profile_Class_Description VARCHAR2,
66 X_Status VARCHAR2,
67 X_Collector_Id NUMBER,
68 X_Credit_Checking VARCHAR2,
69 X_Tolerance NUMBER,
70 X_Interest_Charges VARCHAR2,
71 X_Charge_On_Finance_Charge_Flg VARCHAR2,
72 X_Interest_Period_Days NUMBER,
73 X_Discount_Terms VARCHAR2,
74 X_Discount_Grace_Days NUMBER,
75 X_Statements VARCHAR2,
76 X_Statement_Cycle_Id NUMBER,
77 X_Credit_Balance_Statements VARCHAR2,
78 X_Standard_Terms NUMBER,
79 X_Override_Terms VARCHAR2,
80 X_Payment_Grace_Days NUMBER,
81 X_Dunning_Letters VARCHAR2,
82 X_Dunning_Letter_Set_Id NUMBER,
83 X_Autocash_Hierarchy_Id NUMBER,
84 X_Copy_Method VARCHAR2,
85 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
86 X_Tax_Printing_Option VARCHAR2,
87 X_Tax_Printing_Option_Meaning VARCHAR2,
88 X_Grouping_Rule_Id NUMBER,
89 X_Cons_Inv_Flag VARCHAR2,
90 X_Cons_Inv_Type VARCHAR2,
91 X_Request_Id NUMBER,
92 X_Attribute_Category VARCHAR2,
93 X_Attribute1 VARCHAR2,
94 X_Attribute2 VARCHAR2,
95 X_Attribute3 VARCHAR2,
96 X_Attribute4 VARCHAR2,
97 X_Attribute5 VARCHAR2,
98 X_Attribute6 VARCHAR2,
99 X_Attribute7 VARCHAR2,
100 X_Attribute8 VARCHAR2,
101 X_Attribute9 VARCHAR2,
102 X_Attribute10 VARCHAR2,
103 X_Attribute11 VARCHAR2,
104 X_Attribute12 VARCHAR2,
105 X_Attribute13 VARCHAR2,
106 X_Attribute14 VARCHAR2,
107 X_Attribute15 VARCHAR2,
108 X_Jgzz_attribute_Category VARCHAR2,
109 X_Jgzz_attribute1 VARCHAR2,
110 X_Jgzz_attribute2 VARCHAR2,
111 X_Jgzz_attribute3 VARCHAR2,
112 X_Jgzz_attribute4 VARCHAR2,
113 X_Jgzz_attribute5 VARCHAR2,
114 X_Jgzz_attribute6 VARCHAR2,
115 X_Jgzz_attribute7 VARCHAR2,
116 X_Jgzz_attribute8 VARCHAR2,
117 X_Jgzz_attribute9 VARCHAR2,
118 X_Jgzz_attribute10 VARCHAR2,
119 X_Jgzz_attribute11 VARCHAR2,
120 X_Jgzz_attribute12 VARCHAR2,
121 X_Jgzz_attribute13 VARCHAR2,
122 X_Jgzz_attribute14 VARCHAR2,
123 X_Jgzz_attribute15 VARCHAR2,
124 X_global_attribute_category VARCHAR2,
125 X_global_attribute1 VARCHAR2,
126 X_global_attribute2 VARCHAR2,
127 X_global_attribute3 VARCHAR2,
128 X_global_attribute4 VARCHAR2,
129 X_global_attribute5 VARCHAR2,
130 X_global_attribute6 VARCHAR2,
131 X_global_attribute7 VARCHAR2,
132 X_global_attribute8 VARCHAR2,
133 X_global_attribute9 VARCHAR2,
134 X_global_attribute10 VARCHAR2,
135 X_global_attribute11 VARCHAR2,
136 X_global_attribute12 VARCHAR2,
137 X_global_attribute13 VARCHAR2,
138 X_global_attribute14 VARCHAR2,
139 X_global_attribute15 VARCHAR2,
140 X_global_attribute16 VARCHAR2,
141 X_global_attribute17 VARCHAR2,
142 X_global_attribute18 VARCHAR2,
143 X_global_attribute19 VARCHAR2,
144 X_global_attribute20 VARCHAR2,
145 X_lockbox_matching_option VARCHAR2,
146 X_autocash_hierarchy_id_adr NUMBER ,
147 X_review_cycle VARCHAR2 DEFAULT NULL,
148 X_credit_analyst_id NUMBER DEFAULT NULL,
149 X_Cons_Bill_Level VARCHAR2 DEFAULT NULL,
150 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2 DEFAULT NULL,
151 X_CREDIT_ITEMS_FLAG VARCHAR2 DEFAULT NULL,
152 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2 DEFAULT NULL,
153 X_LATE_CHARGE_TYPE VARCHAR2 DEFAULT NULL,
154 X_LATE_CHARGE_TERM_ID NUMBER DEFAULT NULL,
155 X_INTEREST_CALCULATION_PERIOD VARCHAR2 DEFAULT NULL,
156 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2 DEFAULT NULL,
157 X_MESSAGE_TEXT_ID NUMBER DEFAULT NULL,
158 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 DEFAULT NULL,
159 X_CHARGE_BEGIN_DATE DATE DEFAULT NULL);
160
161
162 /* Bug 3619062 Overloaded this procedure with X_Credit_Classification as parameter*/
163 PROCEDURE Insert_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
164 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER ,
165 X_Last_Updated_By NUMBER,
166 X_Last_Update_Date DATE,
167 X_Last_Update_Login NUMBER,
168 X_Created_By NUMBER,
169 X_Creation_Date DATE,
170 X_Profile_Class_Name VARCHAR2,
171 X_Profile_Class_Description VARCHAR2,
172 X_Status VARCHAR2,
173 X_Collector_Id NUMBER,
174 X_Credit_Checking VARCHAR2,
175 X_Tolerance NUMBER,
176 X_Interest_Charges VARCHAR2,
177 X_Charge_On_Finance_Charge_Flg VARCHAR2,
178 X_Interest_Period_Days NUMBER,
179 X_Discount_Terms VARCHAR2,
180 X_Discount_Grace_Days NUMBER,
181 X_Statements VARCHAR2,
182 X_Statement_Cycle_Id NUMBER,
183 X_Credit_Balance_Statements VARCHAR2,
184 X_Standard_Terms NUMBER,
185 X_Override_Terms VARCHAR2,
186 X_Payment_Grace_Days NUMBER,
187 X_Dunning_Letters VARCHAR2,
188 X_Dunning_Letter_Set_Id NUMBER,
189 X_Autocash_Hierarchy_Id NUMBER,
190 X_Copy_Method VARCHAR2,
191 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
192 X_Tax_Printing_Option VARCHAR2,
193 X_Tax_Printing_Option_Meaning VARCHAR2,
194 X_Grouping_Rule_Id NUMBER,
195 X_Cons_Inv_Flag VARCHAR2,
196 X_Cons_Inv_Type VARCHAR2,
197 X_Request_Id NUMBER,
198 X_Attribute_Category VARCHAR2,
199 X_Attribute1 VARCHAR2,
200 X_Attribute2 VARCHAR2,
201 X_Attribute3 VARCHAR2,
202 X_Attribute4 VARCHAR2,
203 X_Attribute5 VARCHAR2,
204 X_Attribute6 VARCHAR2,
205 X_Attribute7 VARCHAR2,
206 X_Attribute8 VARCHAR2,
207 X_Attribute9 VARCHAR2,
208 X_Attribute10 VARCHAR2,
209 X_Attribute11 VARCHAR2,
210 X_Attribute12 VARCHAR2,
211 X_Attribute13 VARCHAR2,
212 X_Attribute14 VARCHAR2,
213 X_Attribute15 VARCHAR2,
214 X_Jgzz_attribute_Category VARCHAR2,
215 X_Jgzz_attribute1 VARCHAR2,
216 X_Jgzz_attribute2 VARCHAR2,
217 X_Jgzz_attribute3 VARCHAR2,
218 X_Jgzz_attribute4 VARCHAR2,
219 X_Jgzz_attribute5 VARCHAR2,
220 X_Jgzz_attribute6 VARCHAR2,
221 X_Jgzz_attribute7 VARCHAR2,
222 X_Jgzz_attribute8 VARCHAR2,
223 X_Jgzz_attribute9 VARCHAR2,
224 X_Jgzz_attribute10 VARCHAR2,
225 X_Jgzz_attribute11 VARCHAR2,
226 X_Jgzz_attribute12 VARCHAR2,
227 X_Jgzz_attribute13 VARCHAR2,
228 X_Jgzz_attribute14 VARCHAR2,
229 X_Jgzz_attribute15 VARCHAR2,
230 X_global_attribute_category VARCHAR2,
234 X_global_attribute4 VARCHAR2,
231 X_global_attribute1 VARCHAR2,
232 X_global_attribute2 VARCHAR2,
233 X_global_attribute3 VARCHAR2,
235 X_global_attribute5 VARCHAR2,
236 X_global_attribute6 VARCHAR2,
237 X_global_attribute7 VARCHAR2,
238 X_global_attribute8 VARCHAR2,
239 X_global_attribute9 VARCHAR2,
240 X_global_attribute10 VARCHAR2,
241 X_global_attribute11 VARCHAR2,
242 X_global_attribute12 VARCHAR2,
243 X_global_attribute13 VARCHAR2,
244 X_global_attribute14 VARCHAR2,
245 X_global_attribute15 VARCHAR2,
246 X_global_attribute16 VARCHAR2,
247 X_global_attribute17 VARCHAR2,
248 X_global_attribute18 VARCHAR2,
249 X_global_attribute19 VARCHAR2,
250 X_global_attribute20 VARCHAR2,
251 X_lockbox_matching_option VARCHAR2,
252 X_autocash_hierarchy_id_adr NUMBER ,
253 X_review_cycle VARCHAR2 DEFAULT NULL,
254 X_credit_analyst_id NUMBER DEFAULT NULL,
255 X_credit_classification VARCHAR2, /*Bug 3619062*/
256 X_Cons_Bill_Level VARCHAR2 DEFAULT NULL,
257 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2 DEFAULT NULL,
258 X_CREDIT_ITEMS_FLAG VARCHAR2 DEFAULT NULL,
259 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2 DEFAULT NULL,
260 X_LATE_CHARGE_TYPE VARCHAR2 DEFAULT NULL,
261 X_LATE_CHARGE_TERM_ID NUMBER DEFAULT NULL,
262 X_INTEREST_CALCULATION_PERIOD VARCHAR2 DEFAULT NULL,
263 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2 DEFAULT NULL,
264 X_MESSAGE_TEXT_ID NUMBER DEFAULT NULL,
265 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 DEFAULT NULL,
266 X_CHARGE_BEGIN_DATE DATE DEFAULT NULL);
267
268
269 PROCEDURE Lock_Row (X_Row_Id VARCHAR2,
270 X_Customer_Profile_Class_Id NUMBER,
271 X_Profile_Class_Name VARCHAR2,
272 X_Profile_Class_Description VARCHAR2,
273 X_Status VARCHAR2,
274 X_Collector_Id NUMBER,
275 X_Credit_Checking VARCHAR2,
276 X_Tolerance NUMBER,
277 X_Interest_Charges VARCHAR2,
278 X_Charge_On_Finance_Charge_Flg VARCHAR2,
279 X_Interest_Period_Days NUMBER,
280 X_Discount_Terms VARCHAR2,
281 X_Discount_Grace_Days NUMBER,
282 X_Statements VARCHAR2,
283 X_Statement_Cycle_Id NUMBER,
284 X_Credit_Balance_Statements VARCHAR2,
285 X_Standard_Terms NUMBER,
286 X_Override_Terms VARCHAR2,
287 X_Payment_Grace_Days NUMBER,
288 X_Dunning_Letters VARCHAR2,
289 X_Dunning_Letter_Set_Id NUMBER,
290 X_Autocash_Hierarchy_Id NUMBER,
291 X_Copy_Method VARCHAR2,
292 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
293 X_Tax_Printing_Option VARCHAR2,
294 X_Tax_Printing_Option_Meaning VARCHAR2,
295 X_Grouping_Rule_Id NUMBER,
296 X_Cons_Inv_Flag VARCHAR2,
297 X_Cons_Inv_Type VARCHAR2,
298 X_Request_Id NUMBER,
299 X_Attribute_Category VARCHAR2,
300 X_Attribute1 VARCHAR2,
301 X_Attribute2 VARCHAR2,
302 X_Attribute3 VARCHAR2,
303 X_Attribute4 VARCHAR2,
304 X_Attribute5 VARCHAR2,
305 X_Attribute6 VARCHAR2,
306 X_Attribute7 VARCHAR2,
307 X_Attribute8 VARCHAR2,
308 X_Attribute9 VARCHAR2,
309 X_Attribute10 VARCHAR2,
310 X_Attribute11 VARCHAR2,
311 X_Attribute12 VARCHAR2,
312 X_Attribute13 VARCHAR2,
313 X_Attribute14 VARCHAR2,
314 X_Attribute15 VARCHAR2,
315 X_Jgzz_attribute_Category VARCHAR2,
316 X_Jgzz_attribute1 VARCHAR2,
320 X_Jgzz_attribute5 VARCHAR2,
317 X_Jgzz_attribute2 VARCHAR2,
318 X_Jgzz_attribute3 VARCHAR2,
319 X_Jgzz_attribute4 VARCHAR2,
321 X_Jgzz_attribute6 VARCHAR2,
322 X_Jgzz_attribute7 VARCHAR2,
323 X_Jgzz_attribute8 VARCHAR2,
324 X_Jgzz_attribute9 VARCHAR2,
325 X_Jgzz_attribute10 VARCHAR2,
326 X_Jgzz_attribute11 VARCHAR2,
327 X_Jgzz_attribute12 VARCHAR2,
328 X_Jgzz_attribute13 VARCHAR2,
329 X_Jgzz_attribute14 VARCHAR2,
330 X_Jgzz_attribute15 VARCHAR2,
331 X_global_attribute_category VARCHAR2,
332 X_global_attribute1 VARCHAR2,
333 X_global_attribute2 VARCHAR2,
334 X_global_attribute3 VARCHAR2,
335 X_global_attribute4 VARCHAR2,
336 X_global_attribute5 VARCHAR2,
337 X_global_attribute6 VARCHAR2,
338 X_global_attribute7 VARCHAR2,
339 X_global_attribute8 VARCHAR2,
340 X_global_attribute9 VARCHAR2,
341 X_global_attribute10 VARCHAR2,
342 X_global_attribute11 VARCHAR2,
343 X_global_attribute12 VARCHAR2,
344 X_global_attribute13 VARCHAR2,
345 X_global_attribute14 VARCHAR2,
346 X_global_attribute15 VARCHAR2,
347 X_global_attribute16 VARCHAR2,
348 X_global_attribute17 VARCHAR2,
349 X_global_attribute18 VARCHAR2,
350 X_global_attribute19 VARCHAR2,
351 X_global_attribute20 VARCHAR2,
352 X_lockbox_matching_option VARCHAR2,
353 X_autocash_hierarchy_id_adr NUMBER,
354 X_review_cycle VARCHAR2,
355 X_credit_analyst_id NUMBER,
356 X_Cons_Bill_Level VARCHAR2,
357 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2,
358 X_CREDIT_ITEMS_FLAG VARCHAR2,
359 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2,
360 X_LATE_CHARGE_TYPE VARCHAR2,
361 X_LATE_CHARGE_TERM_ID NUMBER ,
362 X_INTEREST_CALCULATION_PERIOD VARCHAR2,
363 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2,
364 X_MESSAGE_TEXT_ID NUMBER ,
365 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2,
366 X_CHARGE_BEGIN_DATE DATE );
367
368
369 /* Bug 3619062 Overloaded this procedure with X_Credit_Classification as parameter*/
370 PROCEDURE Lock_Row (X_Row_Id VARCHAR2,
371 X_Customer_Profile_Class_Id NUMBER,
372 X_Profile_Class_Name VARCHAR2,
373 X_Profile_Class_Description VARCHAR2,
374 X_Status VARCHAR2,
375 X_Collector_Id NUMBER,
376 X_Credit_Checking VARCHAR2,
377 X_Tolerance NUMBER,
378 X_Interest_Charges VARCHAR2,
379 X_Charge_On_Finance_Charge_Flg VARCHAR2,
380 X_Interest_Period_Days NUMBER,
381 X_Discount_Terms VARCHAR2,
382 X_Discount_Grace_Days NUMBER,
383 X_Statements VARCHAR2,
384 X_Statement_Cycle_Id NUMBER,
385 X_Credit_Balance_Statements VARCHAR2,
386 X_Standard_Terms NUMBER,
387 X_Override_Terms VARCHAR2,
388 X_Payment_Grace_Days NUMBER,
389 X_Dunning_Letters VARCHAR2,
390 X_Dunning_Letter_Set_Id NUMBER,
391 X_Autocash_Hierarchy_Id NUMBER,
392 X_Copy_Method VARCHAR2,
393 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
394 X_Tax_Printing_Option VARCHAR2,
395 X_Tax_Printing_Option_Meaning VARCHAR2,
396 X_Grouping_Rule_Id NUMBER,
397 X_Cons_Inv_Flag VARCHAR2,
398 X_Cons_Inv_Type VARCHAR2,
399 X_Request_Id NUMBER,
400 X_Attribute_Category VARCHAR2,
401 X_Attribute1 VARCHAR2,
402 X_Attribute2 VARCHAR2,
403 X_Attribute3 VARCHAR2,
407 X_Attribute7 VARCHAR2,
404 X_Attribute4 VARCHAR2,
405 X_Attribute5 VARCHAR2,
406 X_Attribute6 VARCHAR2,
408 X_Attribute8 VARCHAR2,
409 X_Attribute9 VARCHAR2,
410 X_Attribute10 VARCHAR2,
411 X_Attribute11 VARCHAR2,
412 X_Attribute12 VARCHAR2,
413 X_Attribute13 VARCHAR2,
414 X_Attribute14 VARCHAR2,
415 X_Attribute15 VARCHAR2,
416 X_Jgzz_attribute_Category VARCHAR2,
417 X_Jgzz_attribute1 VARCHAR2,
418 X_Jgzz_attribute2 VARCHAR2,
419 X_Jgzz_attribute3 VARCHAR2,
420 X_Jgzz_attribute4 VARCHAR2,
421 X_Jgzz_attribute5 VARCHAR2,
422 X_Jgzz_attribute6 VARCHAR2,
423 X_Jgzz_attribute7 VARCHAR2,
424 X_Jgzz_attribute8 VARCHAR2,
425 X_Jgzz_attribute9 VARCHAR2,
426 X_Jgzz_attribute10 VARCHAR2,
427 X_Jgzz_attribute11 VARCHAR2,
428 X_Jgzz_attribute12 VARCHAR2,
429 X_Jgzz_attribute13 VARCHAR2,
430 X_Jgzz_attribute14 VARCHAR2,
431 X_Jgzz_attribute15 VARCHAR2,
432 X_global_attribute_category VARCHAR2,
433 X_global_attribute1 VARCHAR2,
434 X_global_attribute2 VARCHAR2,
435 X_global_attribute3 VARCHAR2,
436 X_global_attribute4 VARCHAR2,
437 X_global_attribute5 VARCHAR2,
438 X_global_attribute6 VARCHAR2,
439 X_global_attribute7 VARCHAR2,
440 X_global_attribute8 VARCHAR2,
441 X_global_attribute9 VARCHAR2,
442 X_global_attribute10 VARCHAR2,
443 X_global_attribute11 VARCHAR2,
444 X_global_attribute12 VARCHAR2,
445 X_global_attribute13 VARCHAR2,
446 X_global_attribute14 VARCHAR2,
447 X_global_attribute15 VARCHAR2,
448 X_global_attribute16 VARCHAR2,
449 X_global_attribute17 VARCHAR2,
450 X_global_attribute18 VARCHAR2,
451 X_global_attribute19 VARCHAR2,
452 X_global_attribute20 VARCHAR2,
453 X_lockbox_matching_option VARCHAR2,
454 X_autocash_hierarchy_id_adr NUMBER,
455 X_review_cycle VARCHAR2,
456 X_credit_analyst_id NUMBER,
457 X_credit_classification VARCHAR2, /*Bug 3619062*/
458 X_Cons_Bill_Level VARCHAR2,
459 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2,
460 X_CREDIT_ITEMS_FLAG VARCHAR2,
461 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2,
462 X_LATE_CHARGE_TYPE VARCHAR2,
463 X_LATE_CHARGE_TERM_ID NUMBER,
464 X_INTEREST_CALCULATION_PERIOD VARCHAR2,
465 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2,
466 X_MESSAGE_TEXT_ID NUMBER,
467 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2,
468 X_CHARGE_BEGIN_DATE DATE );
469
470
471 PROCEDURE Update_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
472 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER,
473 X_Last_Updated_By NUMBER,
474 X_Last_Update_Date DATE,
475 X_Last_Update_Login NUMBER,
476 X_Profile_Class_Name VARCHAR2,
477 X_Profile_Class_Description VARCHAR2,
478 X_Status VARCHAR2,
479 X_Collector_Id NUMBER,
480 X_Credit_Checking VARCHAR2,
481 X_Tolerance NUMBER,
482 X_Interest_Charges VARCHAR2,
483 X_Charge_On_Finance_Charge_Flg VARCHAR2,
484 X_Interest_Period_Days NUMBER,
485 X_Discount_Terms VARCHAR2,
486 X_Discount_Grace_Days NUMBER,
487 X_Statements VARCHAR2,
488 X_Statement_Cycle_Id NUMBER,
489 X_Credit_Balance_Statements VARCHAR2,
490 X_Standard_Terms NUMBER,
494 X_Dunning_Letter_Set_Id NUMBER,
491 X_Override_Terms VARCHAR2,
492 X_Payment_Grace_Days NUMBER,
493 X_Dunning_Letters VARCHAR2,
495 X_Autocash_Hierarchy_Id NUMBER,
496 X_Copy_Method VARCHAR2,
497 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
498 X_Tax_Printing_Option VARCHAR2,
499 X_Tax_Printing_Option_Meaning VARCHAR2,
500 X_Grouping_Rule_Id NUMBER,
501 X_Cons_Inv_Flag VARCHAR2,
502 X_Cons_Inv_Type VARCHAR2,
503 X_Request_Id NUMBER,
504 X_Attribute_Category VARCHAR2,
505 X_Attribute1 VARCHAR2,
506 X_Attribute2 VARCHAR2,
507 X_Attribute3 VARCHAR2,
508 X_Attribute4 VARCHAR2,
509 X_Attribute5 VARCHAR2,
510 X_Attribute6 VARCHAR2,
511 X_Attribute7 VARCHAR2,
512 X_Attribute8 VARCHAR2,
513 X_Attribute9 VARCHAR2,
514 X_Attribute10 VARCHAR2,
515 X_Attribute11 VARCHAR2,
516 X_Attribute12 VARCHAR2,
517 X_Attribute13 VARCHAR2,
518 X_Attribute14 VARCHAR2,
519 X_Attribute15 VARCHAR2,
520 X_Jgzz_attribute_Category VARCHAR2,
521 X_Jgzz_attribute1 VARCHAR2,
522 X_Jgzz_attribute2 VARCHAR2,
523 X_Jgzz_attribute3 VARCHAR2,
524 X_Jgzz_attribute4 VARCHAR2,
525 X_Jgzz_attribute5 VARCHAR2,
526 X_Jgzz_attribute6 VARCHAR2,
527 X_Jgzz_attribute7 VARCHAR2,
528 X_Jgzz_attribute8 VARCHAR2,
529 X_Jgzz_attribute9 VARCHAR2,
530 X_Jgzz_attribute10 VARCHAR2,
531 X_Jgzz_attribute11 VARCHAR2,
532 X_Jgzz_attribute12 VARCHAR2,
533 X_Jgzz_attribute13 VARCHAR2,
534 X_Jgzz_attribute14 VARCHAR2,
535 X_Jgzz_attribute15 VARCHAR2,
536 X_global_attribute_category VARCHAR2,
537 X_global_attribute1 VARCHAR2,
538 X_global_attribute2 VARCHAR2,
539 X_global_attribute3 VARCHAR2,
540 X_global_attribute4 VARCHAR2,
541 X_global_attribute5 VARCHAR2,
542 X_global_attribute6 VARCHAR2,
543 X_global_attribute7 VARCHAR2,
544 X_global_attribute8 VARCHAR2,
545 X_global_attribute9 VARCHAR2,
546 X_global_attribute10 VARCHAR2,
547 X_global_attribute11 VARCHAR2,
548 X_global_attribute12 VARCHAR2,
549 X_global_attribute13 VARCHAR2,
550 X_global_attribute14 VARCHAR2,
551 X_global_attribute15 VARCHAR2,
552 X_global_attribute16 VARCHAR2,
553 X_global_attribute17 VARCHAR2,
554 X_global_attribute18 VARCHAR2,
555 X_global_attribute19 VARCHAR2,
556 X_global_attribute20 VARCHAR2,
557 X_lockbox_matching_option VARCHAR2,
558 X_autocash_hierarchy_id_adr NUMBER ,
559 X_review_cycle VARCHAR2 DEFAULT NULL,
560 X_credit_analyst_id NUMBER DEFAULT NULL,
561 X_Cons_Bill_Level VARCHAR2 DEFAULT NULL,
562 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2 DEFAULT NULL,
563 X_CREDIT_ITEMS_FLAG VARCHAR2 DEFAULT NULL,
564 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2 DEFAULT NULL,
565 X_LATE_CHARGE_TYPE VARCHAR2 DEFAULT NULL,
566 X_LATE_CHARGE_TERM_ID NUMBER DEFAULT NULL,
567 X_INTEREST_CALCULATION_PERIOD VARCHAR2 DEFAULT NULL,
568 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2 DEFAULT NULL,
569 X_MESSAGE_TEXT_ID NUMBER DEFAULT NULL,
570 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 DEFAULT NULL,
571 X_CHARGE_BEGIN_DATE DATE DEFAULT NULL);
572
573 /* Bug 3619062 Overloaded this procedure with X_Credit_Classification as parameter*/
574 PROCEDURE Update_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
578 X_Last_Update_Login NUMBER,
575 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER,
576 X_Last_Updated_By NUMBER,
577 X_Last_Update_Date DATE,
579 X_Profile_Class_Name VARCHAR2,
580 X_Profile_Class_Description VARCHAR2,
581 X_Status VARCHAR2,
582 X_Collector_Id NUMBER,
583 X_Credit_Checking VARCHAR2,
584 X_Tolerance NUMBER,
585 X_Interest_Charges VARCHAR2,
586 X_Charge_On_Finance_Charge_Flg VARCHAR2,
587 X_Interest_Period_Days NUMBER,
588 X_Discount_Terms VARCHAR2,
589 X_Discount_Grace_Days NUMBER,
590 X_Statements VARCHAR2,
591 X_Statement_Cycle_Id NUMBER,
592 X_Credit_Balance_Statements VARCHAR2,
593 X_Standard_Terms NUMBER,
594 X_Override_Terms VARCHAR2,
595 X_Payment_Grace_Days NUMBER,
596 X_Dunning_Letters VARCHAR2,
597 X_Dunning_Letter_Set_Id NUMBER,
598 X_Autocash_Hierarchy_Id NUMBER,
599 X_Copy_Method VARCHAR2,
600 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
601 X_Tax_Printing_Option VARCHAR2,
602 X_Tax_Printing_Option_Meaning VARCHAR2,
603 X_Grouping_Rule_Id NUMBER,
604 X_Cons_Inv_Flag VARCHAR2,
605 X_Cons_Inv_Type VARCHAR2,
606 X_Request_Id NUMBER,
607 X_Attribute_Category VARCHAR2,
608 X_Attribute1 VARCHAR2,
609 X_Attribute2 VARCHAR2,
610 X_Attribute3 VARCHAR2,
611 X_Attribute4 VARCHAR2,
612 X_Attribute5 VARCHAR2,
613 X_Attribute6 VARCHAR2,
614 X_Attribute7 VARCHAR2,
615 X_Attribute8 VARCHAR2,
616 X_Attribute9 VARCHAR2,
617 X_Attribute10 VARCHAR2,
618 X_Attribute11 VARCHAR2,
619 X_Attribute12 VARCHAR2,
620 X_Attribute13 VARCHAR2,
621 X_Attribute14 VARCHAR2,
622 X_Attribute15 VARCHAR2,
623 X_Jgzz_attribute_Category VARCHAR2,
624 X_Jgzz_attribute1 VARCHAR2,
625 X_Jgzz_attribute2 VARCHAR2,
626 X_Jgzz_attribute3 VARCHAR2,
627 X_Jgzz_attribute4 VARCHAR2,
628 X_Jgzz_attribute5 VARCHAR2,
629 X_Jgzz_attribute6 VARCHAR2,
630 X_Jgzz_attribute7 VARCHAR2,
631 X_Jgzz_attribute8 VARCHAR2,
632 X_Jgzz_attribute9 VARCHAR2,
633 X_Jgzz_attribute10 VARCHAR2,
634 X_Jgzz_attribute11 VARCHAR2,
635 X_Jgzz_attribute12 VARCHAR2,
636 X_Jgzz_attribute13 VARCHAR2,
637 X_Jgzz_attribute14 VARCHAR2,
638 X_Jgzz_attribute15 VARCHAR2,
639 X_global_attribute_category VARCHAR2,
640 X_global_attribute1 VARCHAR2,
644 X_global_attribute5 VARCHAR2,
641 X_global_attribute2 VARCHAR2,
642 X_global_attribute3 VARCHAR2,
643 X_global_attribute4 VARCHAR2,
645 X_global_attribute6 VARCHAR2,
646 X_global_attribute7 VARCHAR2,
647 X_global_attribute8 VARCHAR2,
648 X_global_attribute9 VARCHAR2,
649 X_global_attribute10 VARCHAR2,
650 X_global_attribute11 VARCHAR2,
651 X_global_attribute12 VARCHAR2,
652 X_global_attribute13 VARCHAR2,
653 X_global_attribute14 VARCHAR2,
654 X_global_attribute15 VARCHAR2,
655 X_global_attribute16 VARCHAR2,
656 X_global_attribute17 VARCHAR2,
657 X_global_attribute18 VARCHAR2,
658 X_global_attribute19 VARCHAR2,
659 X_global_attribute20 VARCHAR2,
660 X_lockbox_matching_option VARCHAR2,
661 X_autocash_hierarchy_id_adr NUMBER ,
662 X_review_cycle VARCHAR2 DEFAULT NULL,
663 X_credit_analyst_id NUMBER DEFAULT NULL,
664 X_credit_classification VARCHAR2, /*Bug 3619062*/
665 X_Cons_Bill_Level VARCHAR2 DEFAULT NULL,
666 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2 DEFAULT NULL,
667 X_CREDIT_ITEMS_FLAG VARCHAR2 DEFAULT NULL,
668 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2 DEFAULT NULL,
669 X_LATE_CHARGE_TYPE VARCHAR2 DEFAULT NULL,
670 X_LATE_CHARGE_TERM_ID NUMBER DEFAULT NULL,
671 X_INTEREST_CALCULATION_PERIOD VARCHAR2 DEFAULT NULL,
672 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2 DEFAULT NULL,
673 X_MESSAGE_TEXT_ID NUMBER DEFAULT NULL,
674 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 DEFAULT NULL,
675 X_CHARGE_BEGIN_DATE DATE DEFAULT NULL);
676 --
677 --
678 PROCEDURE Delete_Row(X_Row_id VARCHAR2);
679 --
680 --
681 PROCEDURE compute_negative_id (X_Customer_Profile_Class_Id Number,
682 X_Negative_Id IN OUT NOCOPY Number,
683 Notify_Flag IN OUT NOCOPY varchar2);
684 --
685 --
686 PROCEDURE insert_negative_row (X_Customer_Profile_Class_Id Number,
687 X_Negative_Id Number,
688 X_Update_Options Varchar2);
689
690 --
691 --
692 END ARH_CPC_PKG;