[Home] [Help]
PACKAGE: APPS.ARH_CPC_PKG
Source
1 PACKAGE ARH_CPC_PKG AUTHID CURRENT_USER as
2 /*$Header: ARHCPCS.pls 120.5.12010000.2 2009/02/02 14:07:48 mpsingh 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 X_AUTOMATCH_SET_ID NUMBER DEFAULT NULL);
161
162
163 /* Bug 3619062 Overloaded this procedure with X_Credit_Classification as parameter*/
164 PROCEDURE Insert_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
165 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER ,
166 X_Last_Updated_By NUMBER,
167 X_Last_Update_Date DATE,
168 X_Last_Update_Login NUMBER,
169 X_Created_By NUMBER,
170 X_Creation_Date DATE,
171 X_Profile_Class_Name VARCHAR2,
172 X_Profile_Class_Description VARCHAR2,
173 X_Status VARCHAR2,
174 X_Collector_Id NUMBER,
175 X_Credit_Checking VARCHAR2,
176 X_Tolerance NUMBER,
177 X_Interest_Charges VARCHAR2,
178 X_Charge_On_Finance_Charge_Flg VARCHAR2,
179 X_Interest_Period_Days NUMBER,
180 X_Discount_Terms VARCHAR2,
181 X_Discount_Grace_Days NUMBER,
182 X_Statements VARCHAR2,
183 X_Statement_Cycle_Id NUMBER,
184 X_Credit_Balance_Statements VARCHAR2,
185 X_Standard_Terms NUMBER,
186 X_Override_Terms VARCHAR2,
187 X_Payment_Grace_Days NUMBER,
188 X_Dunning_Letters VARCHAR2,
189 X_Dunning_Letter_Set_Id NUMBER,
190 X_Autocash_Hierarchy_Id NUMBER,
191 X_Copy_Method VARCHAR2,
192 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
193 X_Tax_Printing_Option VARCHAR2,
194 X_Tax_Printing_Option_Meaning VARCHAR2,
195 X_Grouping_Rule_Id NUMBER,
196 X_Cons_Inv_Flag VARCHAR2,
197 X_Cons_Inv_Type VARCHAR2,
198 X_Request_Id NUMBER,
199 X_Attribute_Category VARCHAR2,
200 X_Attribute1 VARCHAR2,
201 X_Attribute2 VARCHAR2,
202 X_Attribute3 VARCHAR2,
203 X_Attribute4 VARCHAR2,
204 X_Attribute5 VARCHAR2,
205 X_Attribute6 VARCHAR2,
206 X_Attribute7 VARCHAR2,
207 X_Attribute8 VARCHAR2,
208 X_Attribute9 VARCHAR2,
209 X_Attribute10 VARCHAR2,
210 X_Attribute11 VARCHAR2,
211 X_Attribute12 VARCHAR2,
212 X_Attribute13 VARCHAR2,
213 X_Attribute14 VARCHAR2,
214 X_Attribute15 VARCHAR2,
215 X_Jgzz_attribute_Category VARCHAR2,
216 X_Jgzz_attribute1 VARCHAR2,
217 X_Jgzz_attribute2 VARCHAR2,
218 X_Jgzz_attribute3 VARCHAR2,
219 X_Jgzz_attribute4 VARCHAR2,
220 X_Jgzz_attribute5 VARCHAR2,
221 X_Jgzz_attribute6 VARCHAR2,
222 X_Jgzz_attribute7 VARCHAR2,
223 X_Jgzz_attribute8 VARCHAR2,
224 X_Jgzz_attribute9 VARCHAR2,
225 X_Jgzz_attribute10 VARCHAR2,
226 X_Jgzz_attribute11 VARCHAR2,
227 X_Jgzz_attribute12 VARCHAR2,
228 X_Jgzz_attribute13 VARCHAR2,
229 X_Jgzz_attribute14 VARCHAR2,
230 X_Jgzz_attribute15 VARCHAR2,
231 X_global_attribute_category VARCHAR2,
232 X_global_attribute1 VARCHAR2,
233 X_global_attribute2 VARCHAR2,
234 X_global_attribute3 VARCHAR2,
235 X_global_attribute4 VARCHAR2,
236 X_global_attribute5 VARCHAR2,
237 X_global_attribute6 VARCHAR2,
238 X_global_attribute7 VARCHAR2,
239 X_global_attribute8 VARCHAR2,
240 X_global_attribute9 VARCHAR2,
241 X_global_attribute10 VARCHAR2,
242 X_global_attribute11 VARCHAR2,
243 X_global_attribute12 VARCHAR2,
244 X_global_attribute13 VARCHAR2,
245 X_global_attribute14 VARCHAR2,
246 X_global_attribute15 VARCHAR2,
247 X_global_attribute16 VARCHAR2,
248 X_global_attribute17 VARCHAR2,
249 X_global_attribute18 VARCHAR2,
250 X_global_attribute19 VARCHAR2,
251 X_global_attribute20 VARCHAR2,
252 X_lockbox_matching_option VARCHAR2,
256 X_credit_classification VARCHAR2, /*Bug 3619062*/
253 X_autocash_hierarchy_id_adr NUMBER ,
254 X_review_cycle VARCHAR2 DEFAULT NULL,
255 X_credit_analyst_id NUMBER DEFAULT NULL,
257 X_Cons_Bill_Level VARCHAR2 DEFAULT NULL,
258 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2 DEFAULT NULL,
259 X_CREDIT_ITEMS_FLAG VARCHAR2 DEFAULT NULL,
260 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2 DEFAULT NULL,
261 X_LATE_CHARGE_TYPE VARCHAR2 DEFAULT NULL,
262 X_LATE_CHARGE_TERM_ID NUMBER DEFAULT NULL,
263 X_INTEREST_CALCULATION_PERIOD VARCHAR2 DEFAULT NULL,
264 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2 DEFAULT NULL,
265 X_MESSAGE_TEXT_ID NUMBER DEFAULT NULL,
266 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 DEFAULT NULL,
267 X_CHARGE_BEGIN_DATE DATE DEFAULT NULL,
268 X_AUTOMATCH_SET_ID NUMBER DEFAULT NULL);
269
270
271 PROCEDURE Lock_Row (X_Row_Id VARCHAR2,
272 X_Customer_Profile_Class_Id NUMBER,
273 X_Profile_Class_Name VARCHAR2,
274 X_Profile_Class_Description VARCHAR2,
275 X_Status VARCHAR2,
276 X_Collector_Id NUMBER,
277 X_Credit_Checking VARCHAR2,
278 X_Tolerance NUMBER,
279 X_Interest_Charges VARCHAR2,
280 X_Charge_On_Finance_Charge_Flg VARCHAR2,
281 X_Interest_Period_Days NUMBER,
282 X_Discount_Terms VARCHAR2,
283 X_Discount_Grace_Days NUMBER,
284 X_Statements VARCHAR2,
285 X_Statement_Cycle_Id NUMBER,
286 X_Credit_Balance_Statements VARCHAR2,
287 X_Standard_Terms NUMBER,
288 X_Override_Terms VARCHAR2,
289 X_Payment_Grace_Days NUMBER,
290 X_Dunning_Letters VARCHAR2,
291 X_Dunning_Letter_Set_Id NUMBER,
292 X_Autocash_Hierarchy_Id NUMBER,
293 X_Copy_Method VARCHAR2,
294 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
295 X_Tax_Printing_Option VARCHAR2,
296 X_Tax_Printing_Option_Meaning VARCHAR2,
297 X_Grouping_Rule_Id NUMBER,
298 X_Cons_Inv_Flag VARCHAR2,
299 X_Cons_Inv_Type VARCHAR2,
300 X_Request_Id NUMBER,
301 X_Attribute_Category VARCHAR2,
302 X_Attribute1 VARCHAR2,
303 X_Attribute2 VARCHAR2,
304 X_Attribute3 VARCHAR2,
305 X_Attribute4 VARCHAR2,
306 X_Attribute5 VARCHAR2,
307 X_Attribute6 VARCHAR2,
308 X_Attribute7 VARCHAR2,
309 X_Attribute8 VARCHAR2,
310 X_Attribute9 VARCHAR2,
311 X_Attribute10 VARCHAR2,
312 X_Attribute11 VARCHAR2,
313 X_Attribute12 VARCHAR2,
314 X_Attribute13 VARCHAR2,
315 X_Attribute14 VARCHAR2,
316 X_Attribute15 VARCHAR2,
317 X_Jgzz_attribute_Category VARCHAR2,
318 X_Jgzz_attribute1 VARCHAR2,
319 X_Jgzz_attribute2 VARCHAR2,
320 X_Jgzz_attribute3 VARCHAR2,
321 X_Jgzz_attribute4 VARCHAR2,
322 X_Jgzz_attribute5 VARCHAR2,
323 X_Jgzz_attribute6 VARCHAR2,
324 X_Jgzz_attribute7 VARCHAR2,
325 X_Jgzz_attribute8 VARCHAR2,
326 X_Jgzz_attribute9 VARCHAR2,
327 X_Jgzz_attribute10 VARCHAR2,
328 X_Jgzz_attribute11 VARCHAR2,
329 X_Jgzz_attribute12 VARCHAR2,
330 X_Jgzz_attribute13 VARCHAR2,
331 X_Jgzz_attribute14 VARCHAR2,
332 X_Jgzz_attribute15 VARCHAR2,
333 X_global_attribute_category VARCHAR2,
334 X_global_attribute1 VARCHAR2,
335 X_global_attribute2 VARCHAR2,
336 X_global_attribute3 VARCHAR2,
337 X_global_attribute4 VARCHAR2,
341 X_global_attribute8 VARCHAR2,
338 X_global_attribute5 VARCHAR2,
339 X_global_attribute6 VARCHAR2,
340 X_global_attribute7 VARCHAR2,
342 X_global_attribute9 VARCHAR2,
343 X_global_attribute10 VARCHAR2,
344 X_global_attribute11 VARCHAR2,
345 X_global_attribute12 VARCHAR2,
346 X_global_attribute13 VARCHAR2,
347 X_global_attribute14 VARCHAR2,
348 X_global_attribute15 VARCHAR2,
349 X_global_attribute16 VARCHAR2,
350 X_global_attribute17 VARCHAR2,
351 X_global_attribute18 VARCHAR2,
352 X_global_attribute19 VARCHAR2,
353 X_global_attribute20 VARCHAR2,
354 X_lockbox_matching_option VARCHAR2,
355 X_autocash_hierarchy_id_adr NUMBER,
356 X_review_cycle VARCHAR2,
357 X_credit_analyst_id NUMBER,
358 X_Cons_Bill_Level VARCHAR2,
359 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2,
360 X_CREDIT_ITEMS_FLAG VARCHAR2,
361 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2,
362 X_LATE_CHARGE_TYPE VARCHAR2,
363 X_LATE_CHARGE_TERM_ID NUMBER ,
364 X_INTEREST_CALCULATION_PERIOD VARCHAR2,
365 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2,
366 X_MESSAGE_TEXT_ID NUMBER ,
367 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2,
368 X_CHARGE_BEGIN_DATE DATE ,
369 X_AUTOMATCH_SET_ID NUMBER);
370
371
372 /* Bug 3619062 Overloaded this procedure with X_Credit_Classification as parameter*/
373 PROCEDURE Lock_Row (X_Row_Id VARCHAR2,
374 X_Customer_Profile_Class_Id NUMBER,
375 X_Profile_Class_Name VARCHAR2,
376 X_Profile_Class_Description VARCHAR2,
377 X_Status VARCHAR2,
378 X_Collector_Id NUMBER,
379 X_Credit_Checking VARCHAR2,
380 X_Tolerance NUMBER,
381 X_Interest_Charges VARCHAR2,
382 X_Charge_On_Finance_Charge_Flg VARCHAR2,
383 X_Interest_Period_Days NUMBER,
384 X_Discount_Terms VARCHAR2,
385 X_Discount_Grace_Days NUMBER,
386 X_Statements VARCHAR2,
387 X_Statement_Cycle_Id NUMBER,
388 X_Credit_Balance_Statements VARCHAR2,
389 X_Standard_Terms NUMBER,
390 X_Override_Terms VARCHAR2,
391 X_Payment_Grace_Days NUMBER,
392 X_Dunning_Letters VARCHAR2,
393 X_Dunning_Letter_Set_Id NUMBER,
394 X_Autocash_Hierarchy_Id NUMBER,
395 X_Copy_Method VARCHAR2,
396 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
397 X_Tax_Printing_Option VARCHAR2,
398 X_Tax_Printing_Option_Meaning VARCHAR2,
399 X_Grouping_Rule_Id NUMBER,
400 X_Cons_Inv_Flag VARCHAR2,
401 X_Cons_Inv_Type VARCHAR2,
402 X_Request_Id NUMBER,
403 X_Attribute_Category VARCHAR2,
404 X_Attribute1 VARCHAR2,
405 X_Attribute2 VARCHAR2,
406 X_Attribute3 VARCHAR2,
407 X_Attribute4 VARCHAR2,
408 X_Attribute5 VARCHAR2,
409 X_Attribute6 VARCHAR2,
410 X_Attribute7 VARCHAR2,
411 X_Attribute8 VARCHAR2,
412 X_Attribute9 VARCHAR2,
413 X_Attribute10 VARCHAR2,
414 X_Attribute11 VARCHAR2,
415 X_Attribute12 VARCHAR2,
416 X_Attribute13 VARCHAR2,
417 X_Attribute14 VARCHAR2,
418 X_Attribute15 VARCHAR2,
419 X_Jgzz_attribute_Category VARCHAR2,
420 X_Jgzz_attribute1 VARCHAR2,
421 X_Jgzz_attribute2 VARCHAR2,
422 X_Jgzz_attribute3 VARCHAR2,
423 X_Jgzz_attribute4 VARCHAR2,
424 X_Jgzz_attribute5 VARCHAR2,
428 X_Jgzz_attribute9 VARCHAR2,
425 X_Jgzz_attribute6 VARCHAR2,
426 X_Jgzz_attribute7 VARCHAR2,
427 X_Jgzz_attribute8 VARCHAR2,
429 X_Jgzz_attribute10 VARCHAR2,
430 X_Jgzz_attribute11 VARCHAR2,
431 X_Jgzz_attribute12 VARCHAR2,
432 X_Jgzz_attribute13 VARCHAR2,
433 X_Jgzz_attribute14 VARCHAR2,
434 X_Jgzz_attribute15 VARCHAR2,
435 X_global_attribute_category VARCHAR2,
436 X_global_attribute1 VARCHAR2,
437 X_global_attribute2 VARCHAR2,
438 X_global_attribute3 VARCHAR2,
439 X_global_attribute4 VARCHAR2,
440 X_global_attribute5 VARCHAR2,
441 X_global_attribute6 VARCHAR2,
442 X_global_attribute7 VARCHAR2,
443 X_global_attribute8 VARCHAR2,
444 X_global_attribute9 VARCHAR2,
445 X_global_attribute10 VARCHAR2,
446 X_global_attribute11 VARCHAR2,
447 X_global_attribute12 VARCHAR2,
448 X_global_attribute13 VARCHAR2,
449 X_global_attribute14 VARCHAR2,
450 X_global_attribute15 VARCHAR2,
451 X_global_attribute16 VARCHAR2,
452 X_global_attribute17 VARCHAR2,
453 X_global_attribute18 VARCHAR2,
454 X_global_attribute19 VARCHAR2,
455 X_global_attribute20 VARCHAR2,
456 X_lockbox_matching_option VARCHAR2,
457 X_autocash_hierarchy_id_adr NUMBER,
458 X_review_cycle VARCHAR2,
459 X_credit_analyst_id NUMBER,
460 X_credit_classification VARCHAR2, /*Bug 3619062*/
461 X_Cons_Bill_Level VARCHAR2,
462 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2,
463 X_CREDIT_ITEMS_FLAG VARCHAR2,
464 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2,
465 X_LATE_CHARGE_TYPE VARCHAR2,
466 X_LATE_CHARGE_TERM_ID NUMBER,
467 X_INTEREST_CALCULATION_PERIOD VARCHAR2,
468 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2,
469 X_MESSAGE_TEXT_ID NUMBER,
470 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2,
471 X_CHARGE_BEGIN_DATE DATE ,
472 X_AUTOMATCH_SET_ID NUMBER);
473
474
475 PROCEDURE Update_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
476 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER,
477 X_Last_Updated_By NUMBER,
478 X_Last_Update_Date DATE,
479 X_Last_Update_Login NUMBER,
480 X_Profile_Class_Name VARCHAR2,
481 X_Profile_Class_Description VARCHAR2,
482 X_Status VARCHAR2,
483 X_Collector_Id NUMBER,
484 X_Credit_Checking VARCHAR2,
485 X_Tolerance NUMBER,
486 X_Interest_Charges VARCHAR2,
487 X_Charge_On_Finance_Charge_Flg VARCHAR2,
488 X_Interest_Period_Days NUMBER,
489 X_Discount_Terms VARCHAR2,
490 X_Discount_Grace_Days NUMBER,
491 X_Statements VARCHAR2,
492 X_Statement_Cycle_Id NUMBER,
493 X_Credit_Balance_Statements VARCHAR2,
494 X_Standard_Terms NUMBER,
495 X_Override_Terms VARCHAR2,
496 X_Payment_Grace_Days NUMBER,
497 X_Dunning_Letters VARCHAR2,
498 X_Dunning_Letter_Set_Id NUMBER,
499 X_Autocash_Hierarchy_Id NUMBER,
500 X_Copy_Method VARCHAR2,
501 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
502 X_Tax_Printing_Option VARCHAR2,
503 X_Tax_Printing_Option_Meaning VARCHAR2,
504 X_Grouping_Rule_Id NUMBER,
505 X_Cons_Inv_Flag VARCHAR2,
506 X_Cons_Inv_Type VARCHAR2,
507 X_Request_Id NUMBER,
508 X_Attribute_Category VARCHAR2,
509 X_Attribute1 VARCHAR2,
510 X_Attribute2 VARCHAR2,
511 X_Attribute3 VARCHAR2,
515 X_Attribute7 VARCHAR2,
512 X_Attribute4 VARCHAR2,
513 X_Attribute5 VARCHAR2,
514 X_Attribute6 VARCHAR2,
516 X_Attribute8 VARCHAR2,
517 X_Attribute9 VARCHAR2,
518 X_Attribute10 VARCHAR2,
519 X_Attribute11 VARCHAR2,
520 X_Attribute12 VARCHAR2,
521 X_Attribute13 VARCHAR2,
522 X_Attribute14 VARCHAR2,
523 X_Attribute15 VARCHAR2,
524 X_Jgzz_attribute_Category VARCHAR2,
525 X_Jgzz_attribute1 VARCHAR2,
526 X_Jgzz_attribute2 VARCHAR2,
527 X_Jgzz_attribute3 VARCHAR2,
528 X_Jgzz_attribute4 VARCHAR2,
529 X_Jgzz_attribute5 VARCHAR2,
530 X_Jgzz_attribute6 VARCHAR2,
531 X_Jgzz_attribute7 VARCHAR2,
532 X_Jgzz_attribute8 VARCHAR2,
533 X_Jgzz_attribute9 VARCHAR2,
534 X_Jgzz_attribute10 VARCHAR2,
535 X_Jgzz_attribute11 VARCHAR2,
536 X_Jgzz_attribute12 VARCHAR2,
537 X_Jgzz_attribute13 VARCHAR2,
538 X_Jgzz_attribute14 VARCHAR2,
539 X_Jgzz_attribute15 VARCHAR2,
540 X_global_attribute_category VARCHAR2,
541 X_global_attribute1 VARCHAR2,
542 X_global_attribute2 VARCHAR2,
543 X_global_attribute3 VARCHAR2,
544 X_global_attribute4 VARCHAR2,
545 X_global_attribute5 VARCHAR2,
546 X_global_attribute6 VARCHAR2,
547 X_global_attribute7 VARCHAR2,
548 X_global_attribute8 VARCHAR2,
549 X_global_attribute9 VARCHAR2,
550 X_global_attribute10 VARCHAR2,
551 X_global_attribute11 VARCHAR2,
552 X_global_attribute12 VARCHAR2,
553 X_global_attribute13 VARCHAR2,
554 X_global_attribute14 VARCHAR2,
555 X_global_attribute15 VARCHAR2,
556 X_global_attribute16 VARCHAR2,
557 X_global_attribute17 VARCHAR2,
558 X_global_attribute18 VARCHAR2,
559 X_global_attribute19 VARCHAR2,
560 X_global_attribute20 VARCHAR2,
561 X_lockbox_matching_option VARCHAR2,
562 X_autocash_hierarchy_id_adr NUMBER ,
563 X_review_cycle VARCHAR2 DEFAULT NULL,
564 X_credit_analyst_id NUMBER DEFAULT NULL,
565 X_Cons_Bill_Level VARCHAR2 DEFAULT NULL,
566 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2 DEFAULT NULL,
567 X_CREDIT_ITEMS_FLAG VARCHAR2 DEFAULT NULL,
568 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2 DEFAULT NULL,
569 X_LATE_CHARGE_TYPE VARCHAR2 DEFAULT NULL,
570 X_LATE_CHARGE_TERM_ID NUMBER DEFAULT NULL,
571 X_INTEREST_CALCULATION_PERIOD VARCHAR2 DEFAULT NULL,
572 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2 DEFAULT NULL,
573 X_MESSAGE_TEXT_ID NUMBER DEFAULT NULL,
574 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 DEFAULT NULL,
575 X_CHARGE_BEGIN_DATE DATE DEFAULT NULL,
576 X_AUTOMATCH_SET_ID NUMBER DEFAULT NULL);
577
578 /* Bug 3619062 Overloaded this procedure with X_Credit_Classification as parameter*/
579 PROCEDURE Update_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
580 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER,
581 X_Last_Updated_By NUMBER,
582 X_Last_Update_Date DATE,
583 X_Last_Update_Login NUMBER,
584 X_Profile_Class_Name VARCHAR2,
585 X_Profile_Class_Description VARCHAR2,
586 X_Status VARCHAR2,
587 X_Collector_Id NUMBER,
588 X_Credit_Checking VARCHAR2,
589 X_Tolerance NUMBER,
590 X_Interest_Charges VARCHAR2,
591 X_Charge_On_Finance_Charge_Flg VARCHAR2,
592 X_Interest_Period_Days NUMBER,
593 X_Discount_Terms VARCHAR2,
594 X_Discount_Grace_Days NUMBER,
595 X_Statements VARCHAR2,
599 X_Override_Terms VARCHAR2,
596 X_Statement_Cycle_Id NUMBER,
597 X_Credit_Balance_Statements VARCHAR2,
598 X_Standard_Terms NUMBER,
600 X_Payment_Grace_Days NUMBER,
601 X_Dunning_Letters VARCHAR2,
602 X_Dunning_Letter_Set_Id NUMBER,
603 X_Autocash_Hierarchy_Id NUMBER,
604 X_Copy_Method VARCHAR2,
605 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
606 X_Tax_Printing_Option VARCHAR2,
607 X_Tax_Printing_Option_Meaning VARCHAR2,
608 X_Grouping_Rule_Id NUMBER,
609 X_Cons_Inv_Flag VARCHAR2,
610 X_Cons_Inv_Type VARCHAR2,
611 X_Request_Id NUMBER,
612 X_Attribute_Category VARCHAR2,
613 X_Attribute1 VARCHAR2,
614 X_Attribute2 VARCHAR2,
615 X_Attribute3 VARCHAR2,
616 X_Attribute4 VARCHAR2,
617 X_Attribute5 VARCHAR2,
618 X_Attribute6 VARCHAR2,
619 X_Attribute7 VARCHAR2,
620 X_Attribute8 VARCHAR2,
621 X_Attribute9 VARCHAR2,
622 X_Attribute10 VARCHAR2,
623 X_Attribute11 VARCHAR2,
624 X_Attribute12 VARCHAR2,
625 X_Attribute13 VARCHAR2,
626 X_Attribute14 VARCHAR2,
627 X_Attribute15 VARCHAR2,
628 X_Jgzz_attribute_Category VARCHAR2,
629 X_Jgzz_attribute1 VARCHAR2,
630 X_Jgzz_attribute2 VARCHAR2,
631 X_Jgzz_attribute3 VARCHAR2,
632 X_Jgzz_attribute4 VARCHAR2,
633 X_Jgzz_attribute5 VARCHAR2,
634 X_Jgzz_attribute6 VARCHAR2,
635 X_Jgzz_attribute7 VARCHAR2,
636 X_Jgzz_attribute8 VARCHAR2,
637 X_Jgzz_attribute9 VARCHAR2,
638 X_Jgzz_attribute10 VARCHAR2,
639 X_Jgzz_attribute11 VARCHAR2,
640 X_Jgzz_attribute12 VARCHAR2,
641 X_Jgzz_attribute13 VARCHAR2,
642 X_Jgzz_attribute14 VARCHAR2,
643 X_Jgzz_attribute15 VARCHAR2,
644 X_global_attribute_category VARCHAR2,
645 X_global_attribute1 VARCHAR2,
646 X_global_attribute2 VARCHAR2,
647 X_global_attribute3 VARCHAR2,
648 X_global_attribute4 VARCHAR2,
649 X_global_attribute5 VARCHAR2,
650 X_global_attribute6 VARCHAR2,
651 X_global_attribute7 VARCHAR2,
652 X_global_attribute8 VARCHAR2,
653 X_global_attribute9 VARCHAR2,
654 X_global_attribute10 VARCHAR2,
655 X_global_attribute11 VARCHAR2,
656 X_global_attribute12 VARCHAR2,
657 X_global_attribute13 VARCHAR2,
658 X_global_attribute14 VARCHAR2,
659 X_global_attribute15 VARCHAR2,
660 X_global_attribute16 VARCHAR2,
661 X_global_attribute17 VARCHAR2,
662 X_global_attribute18 VARCHAR2,
666 X_autocash_hierarchy_id_adr NUMBER ,
663 X_global_attribute19 VARCHAR2,
664 X_global_attribute20 VARCHAR2,
665 X_lockbox_matching_option VARCHAR2,
667 X_review_cycle VARCHAR2 DEFAULT NULL,
668 X_credit_analyst_id NUMBER DEFAULT NULL,
669 X_credit_classification VARCHAR2, /*Bug 3619062*/
670 X_Cons_Bill_Level VARCHAR2 DEFAULT NULL,
671 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2 DEFAULT NULL,
672 X_CREDIT_ITEMS_FLAG VARCHAR2 DEFAULT NULL,
673 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2 DEFAULT NULL,
674 X_LATE_CHARGE_TYPE VARCHAR2 DEFAULT NULL,
675 X_LATE_CHARGE_TERM_ID NUMBER DEFAULT NULL,
676 X_INTEREST_CALCULATION_PERIOD VARCHAR2 DEFAULT NULL,
677 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2 DEFAULT NULL,
678 X_MESSAGE_TEXT_ID NUMBER DEFAULT NULL,
679 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 DEFAULT NULL,
680 X_CHARGE_BEGIN_DATE DATE DEFAULT NULL,
681 X_AUTOMATCH_SET_ID NUMBER DEFAULT NULL);
682 --
683 --
684 PROCEDURE Delete_Row(X_Row_id VARCHAR2);
685 --
686 --
687 PROCEDURE compute_negative_id (X_Customer_Profile_Class_Id Number,
688 X_Negative_Id IN OUT NOCOPY Number,
689 Notify_Flag IN OUT NOCOPY varchar2);
690 --
691 --
692 PROCEDURE insert_negative_row (X_Customer_Profile_Class_Id Number,
693 X_Negative_Id Number,
694 X_Update_Options Varchar2);
695
696 --
697 --
698 END ARH_CPC_PKG;