[Home] [Help]
PACKAGE BODY: APPS.ARH_CPC_PKG
Source
1 PACKAGE BODY ARH_CPC_PKG as
2 /*$Header: ARHCPCB.pls 120.5.12010000.2 2009/02/02 14:08:38 mpsingh ship $*/
3
4 --
5 PROCEDURE sel_class (x_customer_profile_class_id IN NUMBER,
6 x_collector_id IN OUT NOCOPY NUMBER,
7 x_collector_name IN OUT NOCOPY VARCHAR2,
8 x_credit_checking IN OUT NOCOPY VARCHAR2,
9 x_tolerance IN OUT NOCOPY VARCHAR2,
10 x_interest_charges IN OUT NOCOPY VARCHAR2,
11 x_charge_on_fin_charge_flag IN OUT NOCOPY VARCHAR2,
12 x_interest_period_days IN OUT NOCOPY NUMBER,
13 x_discount_terms IN OUT NOCOPY VARCHAR2,
14 x_discount_grace_days IN OUT NOCOPY NUMBER,
15 x_statements IN OUT NOCOPY VARCHAR2,
16 x_statement_cycle_id IN OUT NOCOPY NUMBER,
17 x_statement_cycle_name IN OUT NOCOPY VARCHAR2,
18 x_credit_balance_statements IN OUT NOCOPY VARCHAR2,
19 x_standard_terms IN OUT NOCOPY NUMBER,
20 x_standard_terms_name IN OUT NOCOPY VARCHAR2,
21 x_override_terms IN OUT NOCOPY VARCHAR2,
22 x_payment_grace_days IN OUT NOCOPY NUMBER,
23 x_dunning_letters IN OUT NOCOPY VARCHAR2,
24 x_dunning_letter_set_id IN OUT NOCOPY NUMBER,
25 x_dunning_letter_set_name IN OUT NOCOPY VARCHAR2,
26 x_autocash_hierarchy_id IN OUT NOCOPY NUMBER,
27 x_autocash_hierarchy_name IN OUT NOCOPY VARCHAR2,
28 x_auto_rec_incl_disputed_flag IN OUT NOCOPY VARCHAR2,
29 x_tax_printing_option IN OUT NOCOPY VARCHAR2,
30 x_grouping_rule_id IN OUT NOCOPY VARCHAR2,
31 x_grouping_rule_name IN OUT NOCOPY VARCHAR2,
32 x_attribute_category IN OUT NOCOPY VARCHAR2,
33 x_attribute1 IN OUT NOCOPY VARCHAR2,
34 x_attribute2 IN OUT NOCOPY VARCHAR2,
35 x_attribute3 IN OUT NOCOPY VARCHAR2,
36 x_attribute4 IN OUT NOCOPY VARCHAR2,
37 x_attribute5 IN OUT NOCOPY VARCHAR2,
38 x_attribute6 IN OUT NOCOPY VARCHAR2,
39 x_attribute7 IN OUT NOCOPY VARCHAR2,
40 x_attribute8 IN OUT NOCOPY VARCHAR2,
41 x_attribute9 IN OUT NOCOPY VARCHAR2,
42 x_attribute10 IN OUT NOCOPY VARCHAR2,
43 x_attribute11 IN OUT NOCOPY VARCHAR2,
44 x_attribute12 IN OUT NOCOPY VARCHAR2,
45 x_attribute13 IN OUT NOCOPY VARCHAR2,
46 x_attribute14 IN OUT NOCOPY VARCHAR2,
47 x_attribute15 IN OUT NOCOPY VARCHAR2,
48 x_review_cycle IN OUT NOCOPY VARCHAR2,
49 x_credit_analyst_id IN OUT NOCOPY NUMBER
50 )
51 IS
52 CURSOR c_cust_prof IS
53 SELECT collector_id,
54 collector_name,
55 credit_checking,
56 tolerance,
57 interest_charges,
58 charge_on_finance_charge_flag,
59 interest_period_days,
60 discount_terms,
61 discount_grace_days,
62 statements,
63 statement_cycle_id,
64 statement_cycle_name,
65 credit_balance_statements,
66 standard_terms,
67 standard_terms_name,
68 override_terms,
69 payment_grace_days,
70 dunning_letters,
71 dunning_letter_set_id,
72 dunning_letter_set_name,
73 autocash_hierarchy_id,
74 autocash_hierarchy_name,
75 auto_rec_incl_disputed_flag,
76 tax_printing_option,
77 grouping_rule_id,
78 grouping_rule_name,
79 attribute_category,
80 attribute1,
81 attribute2,
82 attribute3,
83 attribute4,
84 attribute5,
85 attribute6,
86 attribute7,
87 attribute8,
88 attribute9,
89 attribute10,
90 attribute11,
91 attribute12,
92 attribute13,
93 attribute14,
94 attribute15,
95 review_cycle,
96 credit_analyst_id
97 FROM ar_customer_profiles_v
98 WHERE customer_profile_class_id = x_customer_profile_class_id;
99 BEGIN
100 OPEN c_cust_prof;
101 FETCH c_cust_prof INTO
102 x_collector_id,
103 x_collector_name,
104 x_credit_checking,
105 x_tolerance,
106 x_interest_charges,
107 x_charge_on_fin_charge_flag,
108 x_interest_period_days,
109 x_discount_terms,
110 x_discount_grace_days,
111 x_statements,
112 x_statement_cycle_id,
113 x_statement_cycle_name,
114 x_credit_balance_statements,
115 x_standard_terms,
116 x_standard_terms_name,
117 x_override_terms,
118 x_payment_grace_days,
119 x_dunning_letters,
120 x_dunning_letter_set_id,
121 x_dunning_letter_set_name,
122 x_autocash_hierarchy_id,
123 x_autocash_hierarchy_name,
124 x_auto_rec_incl_disputed_flag,
125 x_tax_printing_option,
126 x_grouping_rule_id,
127 x_grouping_rule_name,
128 x_attribute_category,
129 x_attribute1,
130 x_attribute2,
131 x_attribute3,
132 x_attribute4,
133 x_attribute5,
134 x_attribute6,
135 x_attribute7,
136 x_attribute8,
137 x_attribute9,
138 x_attribute10,
139 x_attribute11,
140 x_attribute12,
141 x_attribute13,
142 x_attribute14,
143 x_attribute15,
144 x_review_cycle,
145 x_credit_analyst_id;
146 CLOSE c_cust_prof;
147 END sel_class;
148 --
149 --
150 PROCEDURE check_unique
151 (c_profile_class_name in varchar2,
152 c_rowid in varchar2)
153 is
154 profile_class_count number;
155 BEGIN
156 select 1
157 into profile_class_count
158 from dual
159 where not exists ( select 1
160 from hz_cust_profile_classes
161 where name = c_profile_class_name
162 and profile_class_id >= 0
163 and ( ( c_rowid is null ) or ( rowid <> c_rowid ) )
164 );
165 exception
166 when no_data_found then
167 fnd_message.set_name ('AR', 'AR_CUST_DUP_PROF_NAME');
168 app_exception.raise_exception;
169 END check_unique;
170
171
172
173
174
175 PROCEDURE Insert_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
176 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER,
177 X_Last_Updated_By NUMBER,
178 X_Last_Update_Date DATE,
179 X_Last_Update_Login NUMBER,
180 X_Created_By NUMBER,
181 X_Creation_Date DATE,
182 X_Profile_Class_Name VARCHAR2,
183 X_Profile_Class_Description VARCHAR2,
184 X_Status VARCHAR2,
185 X_Collector_Id NUMBER,
186 X_Credit_Checking VARCHAR2,
187 X_Tolerance NUMBER,
188 X_Interest_Charges VARCHAR2,
189 X_Charge_On_Finance_Charge_Flg VARCHAR2,
190 X_Interest_Period_Days NUMBER,
191 X_Discount_Terms VARCHAR2,
192 X_Discount_Grace_Days NUMBER,
193 X_Statements VARCHAR2,
194 X_Statement_Cycle_Id NUMBER,
195 X_Credit_Balance_Statements VARCHAR2,
196 X_Standard_Terms NUMBER,
197 X_Override_Terms VARCHAR2,
198 X_Payment_Grace_Days NUMBER,
199 X_Dunning_Letters VARCHAR2,
200 X_Dunning_Letter_Set_Id NUMBER,
201 X_Autocash_Hierarchy_Id NUMBER,
202 X_Copy_Method VARCHAR2,
203 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
204 X_Tax_Printing_Option VARCHAR2,
205 X_Tax_Printing_Option_Meaning VARCHAR2,
206 X_Grouping_Rule_Id NUMBER,
207 X_Cons_Inv_Flag VARCHAR2,
208 X_Cons_Inv_Type VARCHAR2,
209 X_Request_Id NUMBER,
210 X_Attribute_Category VARCHAR2,
211 X_Attribute1 VARCHAR2,
212 X_Attribute2 VARCHAR2,
213 X_Attribute3 VARCHAR2,
214 X_Attribute4 VARCHAR2,
215 X_Attribute5 VARCHAR2,
216 X_Attribute6 VARCHAR2,
217 X_Attribute7 VARCHAR2,
218 X_Attribute8 VARCHAR2,
219 X_Attribute9 VARCHAR2,
220 X_Attribute10 VARCHAR2,
221 X_Attribute11 VARCHAR2,
222 X_Attribute12 VARCHAR2,
223 X_Attribute13 VARCHAR2,
224 X_Attribute14 VARCHAR2,
225 X_Attribute15 VARCHAR2,
226 X_Jgzz_attribute_Category VARCHAR2,
227 X_Jgzz_attribute1 VARCHAR2,
228 X_Jgzz_attribute2 VARCHAR2,
229 X_Jgzz_attribute3 VARCHAR2,
230 X_Jgzz_attribute4 VARCHAR2,
231 X_Jgzz_attribute5 VARCHAR2,
232 X_Jgzz_attribute6 VARCHAR2,
233 X_Jgzz_attribute7 VARCHAR2,
234 X_Jgzz_attribute8 VARCHAR2,
235 X_Jgzz_attribute9 VARCHAR2,
236 X_Jgzz_attribute10 VARCHAR2,
237 X_Jgzz_attribute11 VARCHAR2,
238 X_Jgzz_attribute12 VARCHAR2,
239 X_Jgzz_attribute13 VARCHAR2,
240 X_Jgzz_attribute14 VARCHAR2,
241 X_Jgzz_attribute15 VARCHAR2,
242 X_global_attribute_category VARCHAR2,
243 X_global_attribute1 VARCHAR2,
244 X_global_attribute2 VARCHAR2,
245 X_global_attribute3 VARCHAR2,
246 X_global_attribute4 VARCHAR2,
247 X_global_attribute5 VARCHAR2,
248 X_global_attribute6 VARCHAR2,
249 X_global_attribute7 VARCHAR2,
250 X_global_attribute8 VARCHAR2,
251 X_global_attribute9 VARCHAR2,
252 X_global_attribute10 VARCHAR2,
253 X_global_attribute11 VARCHAR2,
254 X_global_attribute12 VARCHAR2,
255 X_global_attribute13 VARCHAR2,
256 X_global_attribute14 VARCHAR2,
257 X_global_attribute15 VARCHAR2,
258 X_global_attribute16 VARCHAR2,
259 X_global_attribute17 VARCHAR2,
260 X_global_attribute18 VARCHAR2,
261 X_global_attribute19 VARCHAR2,
262 X_global_attribute20 VARCHAR2,
263 X_lockbox_matching_option VARCHAR2,
264 X_autocash_hierarchy_id_adr NUMBER,
265 X_review_cycle VARCHAR2 DEFAULT NULL,
266 X_credit_analyst_id NUMBER DEFAULT NULL,
267 X_Cons_Bill_Level VARCHAR2 DEFAULT NULL,
268 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2 DEFAULT NULL,
269 X_CREDIT_ITEMS_FLAG VARCHAR2 DEFAULT NULL,
270 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2 DEFAULT NULL,
271 X_LATE_CHARGE_TYPE VARCHAR2 DEFAULT NULL,
272 X_LATE_CHARGE_TERM_ID NUMBER DEFAULT NULL,
273 X_INTEREST_CALCULATION_PERIOD VARCHAR2 DEFAULT NULL,
274 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2 DEFAULT NULL,
275 X_MESSAGE_TEXT_ID NUMBER DEFAULT NULL,
276 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 DEFAULT NULL,
277 X_CHARGE_BEGIN_DATE DATE DEFAULT NULL,
278 X_AUTOMATCH_SET_ID NUMBER DEFAULT NULL)
279 IS
280 BEGIN
281
282 /*Bug 3619062 Call overloaded procedure with credit_classification set as NULL*/
283 Insert_Row ( X_Row_Id => X_Row_Id ,
284 X_Customer_Profile_Class_Id => X_Customer_Profile_Class_Id ,
285 X_Last_Updated_By => X_Last_Updated_By ,
286 X_Last_Update_Date => X_Last_Update_Date ,
287 X_Last_Update_Login => X_Last_Update_Login ,
288 X_Created_By => X_Created_By ,
289 X_Creation_Date => X_Creation_Date ,
290 X_Profile_Class_Name => X_Profile_Class_Name ,
291 X_Profile_Class_Description => X_Profile_Class_Description ,
292 X_Status => X_Status ,
293 X_Collector_Id => X_Collector_Id ,
294 X_Credit_Checking => X_Credit_Checking ,
295 X_Tolerance => X_Tolerance ,
296 X_Interest_Charges => X_Interest_Charges ,
297 X_Charge_On_Finance_Charge_Flg => X_Charge_On_Finance_Charge_Flg ,
298 X_Interest_Period_Days => X_Interest_Period_Days ,
299 X_Discount_Terms => X_Discount_Terms ,
300 X_Discount_Grace_Days => X_Discount_Grace_Days ,
301 X_Statements => X_Statements ,
302 X_Statement_Cycle_Id => X_Statement_Cycle_Id ,
303 X_Credit_Balance_Statements => X_Credit_Balance_Statements ,
304 X_Standard_Terms => X_Standard_Terms ,
305 X_Override_Terms => X_Override_Terms ,
306 X_Payment_Grace_Days => X_Payment_Grace_Days ,
307 X_Dunning_Letters => X_Dunning_Letters ,
308 X_Dunning_Letter_Set_Id => X_Dunning_Letter_Set_Id ,
309 X_Autocash_Hierarchy_Id => X_Autocash_Hierarchy_Id ,
310 X_Copy_Method => X_Copy_Method ,
311 X_Auto_Rec_Incl_Disputed_Flag => X_Auto_Rec_Incl_Disputed_Flag ,
312 X_Tax_Printing_Option => X_Tax_Printing_Option ,
313 X_Tax_Printing_Option_Meaning => X_Tax_Printing_Option_Meaning ,
314 X_Grouping_Rule_Id => X_Grouping_Rule_Id ,
315 X_Cons_Inv_Flag => X_Cons_Inv_Flag ,
316 X_Cons_Inv_Type => X_Cons_Inv_Type ,
317 X_Request_Id => X_Request_Id ,
318 X_Attribute_Category => X_Attribute_Category ,
319 X_Attribute1 => X_Attribute1 ,
320 X_Attribute2 => X_Attribute2 ,
321 X_Attribute3 => X_Attribute3 ,
322 X_Attribute4 => X_Attribute4 ,
323 X_Attribute5 => X_Attribute5 ,
324 X_Attribute6 => X_Attribute6 ,
325 X_Attribute7 => X_Attribute7 ,
326 X_Attribute8 => X_Attribute8 ,
327 X_Attribute9 => X_Attribute9 ,
328 X_Attribute10 => X_Attribute10 ,
329 X_Attribute11 => X_Attribute11 ,
330 X_Attribute12 => X_Attribute12 ,
331 X_Attribute13 => X_Attribute13 ,
332 X_Attribute14 => X_Attribute14 ,
333 X_Attribute15 => X_Attribute15 ,
334 X_Jgzz_attribute_Category => X_Jgzz_attribute_Category ,
335 X_Jgzz_attribute1 => X_Jgzz_attribute1 ,
336 X_Jgzz_attribute2 => X_Jgzz_attribute2 ,
337 X_Jgzz_attribute3 => X_Jgzz_attribute3 ,
338 X_Jgzz_attribute4 => X_Jgzz_attribute4 ,
339 X_Jgzz_attribute5 => X_Jgzz_attribute5 ,
340 X_Jgzz_attribute6 => X_Jgzz_attribute6 ,
341 X_Jgzz_attribute7 => X_Jgzz_attribute7 ,
342 X_Jgzz_attribute8 => X_Jgzz_attribute8 ,
343 X_Jgzz_attribute9 => X_Jgzz_attribute9 ,
344 X_Jgzz_attribute10 => X_Jgzz_attribute10 ,
345 X_Jgzz_attribute11 => X_Jgzz_attribute11 ,
346 X_Jgzz_attribute12 => X_Jgzz_attribute12 ,
347 X_Jgzz_attribute13 => X_Jgzz_attribute13 ,
348 X_Jgzz_attribute14 => X_Jgzz_attribute14 ,
349 X_Jgzz_attribute15 => X_Jgzz_attribute15 ,
350 X_global_attribute_category => X_global_attribute_category ,
351 X_global_attribute1 => X_global_attribute1 ,
352 X_global_attribute2 => X_global_attribute2 ,
353 X_global_attribute3 => X_global_attribute3 ,
354 X_global_attribute4 => X_global_attribute4 ,
355 X_global_attribute5 => X_global_attribute5 ,
356 X_global_attribute6 => X_global_attribute6 ,
357 X_global_attribute7 => X_global_attribute7 ,
358 X_global_attribute8 => X_global_attribute8 ,
359 X_global_attribute9 => X_global_attribute9 ,
360 X_global_attribute10 => X_global_attribute10 ,
361 X_global_attribute11 => X_global_attribute11 ,
362 X_global_attribute12 => X_global_attribute12 ,
363 X_global_attribute13 => X_global_attribute13 ,
364 X_global_attribute14 => X_global_attribute14 ,
365 X_global_attribute15 => X_global_attribute15 ,
366 X_global_attribute16 => X_global_attribute16 ,
367 X_global_attribute17 => X_global_attribute17 ,
368 X_global_attribute18 => X_global_attribute18 ,
369 X_global_attribute19 => X_global_attribute19 ,
370 X_global_attribute20 => X_global_attribute20 ,
371 X_lockbox_matching_option => X_lockbox_matching_option ,
372 X_autocash_hierarchy_id_adr => X_autocash_hierarchy_id_adr ,
373 X_review_cycle => X_review_cycle ,
374 X_credit_analyst_id => X_credit_analyst_id ,
375 X_credit_classification => NULL ,
376 X_Cons_Bill_Level => X_Cons_Bill_Level,
377 X_LATE_CHARGE_CALCULATION_TRX => X_LATE_CHARGE_CALCULATION_TRX,
378 X_CREDIT_ITEMS_FLAG => X_CREDIT_ITEMS_FLAG,
379 X_DISPUTED_TRANSACTIONS_FLAG => X_DISPUTED_TRANSACTIONS_FLAG,
380 X_LATE_CHARGE_TYPE => X_LATE_CHARGE_TYPE,
381 X_LATE_CHARGE_TERM_ID => X_LATE_CHARGE_TERM_ID,
382 X_INTEREST_CALCULATION_PERIOD => X_INTEREST_CALCULATION_PERIOD,
383 X_HOLD_CHARGED_INVOICES_FLAG => X_HOLD_CHARGED_INVOICES_FLAG,
384 X_MESSAGE_TEXT_ID => X_MESSAGE_TEXT_ID,
385 X_MULTIPLE_INTEREST_RATES_FLAG => X_MULTIPLE_INTEREST_RATES_FLAG,
386 X_CHARGE_BEGIN_DATE => X_CHARGE_BEGIN_DATE ,
387 X_AUTOMATCH_SET_ID => X_AUTOMATCH_SET_ID);
388
389 END Insert_Row;
390
391 PROCEDURE Insert_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
392 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER,
393 X_Last_Updated_By NUMBER,
394 X_Last_Update_Date DATE,
395 X_Last_Update_Login NUMBER,
396 X_Created_By NUMBER,
397 X_Creation_Date DATE,
398 X_Profile_Class_Name VARCHAR2,
399 X_Profile_Class_Description VARCHAR2,
400 X_Status VARCHAR2,
401 X_Collector_Id NUMBER,
402 X_Credit_Checking VARCHAR2,
403 X_Tolerance NUMBER,
404 X_Interest_Charges VARCHAR2,
405 X_Charge_On_Finance_Charge_Flg VARCHAR2,
406 X_Interest_Period_Days NUMBER,
407 X_Discount_Terms VARCHAR2,
408 X_Discount_Grace_Days NUMBER,
409 X_Statements VARCHAR2,
410 X_Statement_Cycle_Id NUMBER,
411 X_Credit_Balance_Statements VARCHAR2,
412 X_Standard_Terms NUMBER,
413 X_Override_Terms VARCHAR2,
414 X_Payment_Grace_Days NUMBER,
415 X_Dunning_Letters VARCHAR2,
416 X_Dunning_Letter_Set_Id NUMBER,
417 X_Autocash_Hierarchy_Id NUMBER,
418 X_Copy_Method VARCHAR2,
419 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
420 X_Tax_Printing_Option VARCHAR2,
421 X_Tax_Printing_Option_Meaning VARCHAR2,
422 X_Grouping_Rule_Id NUMBER,
423 X_Cons_Inv_Flag VARCHAR2,
424 X_Cons_Inv_Type VARCHAR2,
425 X_Request_Id NUMBER,
426 X_Attribute_Category VARCHAR2,
427 X_Attribute1 VARCHAR2,
428 X_Attribute2 VARCHAR2,
429 X_Attribute3 VARCHAR2,
430 X_Attribute4 VARCHAR2,
431 X_Attribute5 VARCHAR2,
432 X_Attribute6 VARCHAR2,
433 X_Attribute7 VARCHAR2,
434 X_Attribute8 VARCHAR2,
435 X_Attribute9 VARCHAR2,
436 X_Attribute10 VARCHAR2,
437 X_Attribute11 VARCHAR2,
438 X_Attribute12 VARCHAR2,
439 X_Attribute13 VARCHAR2,
440 X_Attribute14 VARCHAR2,
441 X_Attribute15 VARCHAR2,
442 X_Jgzz_attribute_Category VARCHAR2,
443 X_Jgzz_attribute1 VARCHAR2,
444 X_Jgzz_attribute2 VARCHAR2,
445 X_Jgzz_attribute3 VARCHAR2,
446 X_Jgzz_attribute4 VARCHAR2,
447 X_Jgzz_attribute5 VARCHAR2,
448 X_Jgzz_attribute6 VARCHAR2,
449 X_Jgzz_attribute7 VARCHAR2,
450 X_Jgzz_attribute8 VARCHAR2,
451 X_Jgzz_attribute9 VARCHAR2,
452 X_Jgzz_attribute10 VARCHAR2,
453 X_Jgzz_attribute11 VARCHAR2,
454 X_Jgzz_attribute12 VARCHAR2,
455 X_Jgzz_attribute13 VARCHAR2,
456 X_Jgzz_attribute14 VARCHAR2,
457 X_Jgzz_attribute15 VARCHAR2,
458 X_global_attribute_category VARCHAR2,
459 X_global_attribute1 VARCHAR2,
460 X_global_attribute2 VARCHAR2,
461 X_global_attribute3 VARCHAR2,
462 X_global_attribute4 VARCHAR2,
463 X_global_attribute5 VARCHAR2,
464 X_global_attribute6 VARCHAR2,
465 X_global_attribute7 VARCHAR2,
466 X_global_attribute8 VARCHAR2,
467 X_global_attribute9 VARCHAR2,
468 X_global_attribute10 VARCHAR2,
469 X_global_attribute11 VARCHAR2,
470 X_global_attribute12 VARCHAR2,
471 X_global_attribute13 VARCHAR2,
472 X_global_attribute14 VARCHAR2,
473 X_global_attribute15 VARCHAR2,
474 X_global_attribute16 VARCHAR2,
475 X_global_attribute17 VARCHAR2,
476 X_global_attribute18 VARCHAR2,
477 X_global_attribute19 VARCHAR2,
478 X_global_attribute20 VARCHAR2,
479 X_lockbox_matching_option VARCHAR2,
480 X_autocash_hierarchy_id_adr NUMBER,
481 X_review_cycle VARCHAR2 DEFAULT NULL,
482 X_credit_analyst_id NUMBER DEFAULT NULL,
483 X_credit_classification VARCHAR2, /*Bug 3619062*/
484 X_Cons_Bill_Level VARCHAR2 DEFAULT NULL,
485 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2 DEFAULT NULL,
486 X_CREDIT_ITEMS_FLAG VARCHAR2 DEFAULT NULL,
487 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2 DEFAULT NULL,
488 X_LATE_CHARGE_TYPE VARCHAR2 DEFAULT NULL,
489 X_LATE_CHARGE_TERM_ID NUMBER DEFAULT NULL,
490 X_INTEREST_CALCULATION_PERIOD VARCHAR2 DEFAULT NULL,
491 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2 DEFAULT NULL,
492 X_MESSAGE_TEXT_ID NUMBER DEFAULT NULL,
493 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 DEFAULT NULL,
494 X_CHARGE_BEGIN_DATE DATE DEFAULT NULL,
495 X_AUTOMATCH_SET_ID NUMBER DEFAULT NULL)
496 IS
497 CURSOR C IS SELECT rowid
498 FROM hz_cust_profile_classes
499 WHERE profile_class_id = X_Customer_Profile_Class_Id;
500
501 BEGIN
502 IF X_CUSTOMER_PROFILE_CLASS_ID IS NULL THEN
503 select hz_cust_profile_classes_s.nextval
504 into x_customer_profile_class_id
505 from dual;
506 END IF;
507
508 -- Calling check_unique Procedure To Verify The Uniqueness Of The Customer
509 -- Profile Class Id
510 check_unique
511 ( c_profile_class_name => x_customer_profile_class_id,
512 c_rowid => x_row_id );
513
514 INSERT INTO HZ_CUST_PROFILE_CLASSES(
515 profile_class_id,
516 last_updated_by,
517 last_update_date,
518 last_update_login,
519 created_by,
520 creation_date,
521 name,
522 description,
523 status,
524 collector_id,
525 credit_checking,
526 tolerance,
527 interest_charges,
528 charge_on_finance_charge_flag,
529 interest_period_days,
530 discount_terms,
531 discount_grace_days,
532 statements,
533 statement_cycle_id,
534 credit_balance_statements,
535 standard_terms,
536 override_terms,
537 payment_grace_days,
538 dunning_letters,
539 dunning_letter_set_id,
540 autocash_hierarchy_id,
541 copy_method,
542 auto_rec_incl_disputed_flag,
543 tax_printing_option,
544 grouping_rule_id,
545 cons_inv_flag,
546 cons_inv_type,
547 request_Id,
548 attribute_category,
549 attribute1,
550 attribute2,
551 attribute3,
552 attribute4,
553 attribute5,
554 attribute6,
555 attribute7,
556 attribute8,
557 attribute9,
558 attribute10,
559 attribute11,
560 attribute12,
561 attribute13,
562 attribute14,
563 attribute15,
564 jgzz_attribute_category,
565 jgzz_attribute1,
566 jgzz_attribute2,
567 jgzz_attribute3,
568 jgzz_attribute4,
569 jgzz_attribute5,
570 jgzz_attribute6,
571 jgzz_attribute7,
572 jgzz_attribute8,
573 jgzz_attribute9,
574 jgzz_attribute10,
575 jgzz_attribute11,
576 jgzz_attribute12,
577 jgzz_attribute13,
578 jgzz_attribute14,
579 jgzz_attribute15,
580 global_attribute_category,
581 global_attribute1,
582 global_attribute2,
583 global_attribute3,
584 global_attribute4,
585 global_attribute5,
586 global_attribute6,
587 global_attribute7,
588 global_attribute8,
589 global_attribute9,
590 global_attribute10,
591 global_attribute11,
592 global_attribute12,
593 global_attribute13,
594 global_attribute14,
595 global_attribute15,
596 global_attribute16,
597 global_attribute17,
598 global_attribute18,
599 global_attribute19,
600 global_attribute20,
601 lockbox_matching_option,
602 autocash_hierarchy_id_for_adr,
603 review_cycle,
604 credit_analyst_id,
605 credit_classification, /*Bug 3619062*/
606 Cons_Bill_Level,
607 LATE_CHARGE_CALCULATION_TRX ,
608 CREDIT_ITEMS_FLAG ,
609 DISPUTED_TRANSACTIONS_FLAG ,
610 LATE_CHARGE_TYPE ,
611 LATE_CHARGE_TERM_ID ,
612 INTEREST_CALCULATION_PERIOD ,
613 HOLD_CHARGED_INVOICES_FLAG ,
614 MESSAGE_TEXT_ID ,
615 MULTIPLE_INTEREST_RATES_FLAG,
616 CHARGE_BEGIN_DATE ,
617 AUTOMATCH_SET_ID )
618 VALUES (
619 X_Customer_Profile_Class_Id,
620 X_Last_Updated_By,
621 X_Last_Update_Date,
622 X_Last_Update_Login,
623 X_Created_By,
624 X_Creation_Date,
625 X_Profile_Class_Name,
626 X_Profile_Class_Description,
627 X_Status,
628 X_Collector_Id,
629 X_Credit_Checking,
630 X_Tolerance,
631 X_Interest_Charges,
632 X_Charge_On_Finance_Charge_Flg,
633 X_Interest_Period_Days,
634 X_Discount_Terms,
635 X_Discount_Grace_Days,
636 X_Statements,
637 X_Statement_Cycle_Id,
638 X_Credit_Balance_Statements,
639 X_Standard_Terms,
640 X_Override_Terms,
641 X_Payment_Grace_Days,
642 X_Dunning_Letters,
643 X_Dunning_Letter_Set_Id,
644 X_Autocash_Hierarchy_Id,
645 X_Copy_Method,
646 X_Auto_Rec_Incl_Disputed_Flag,
647 X_Tax_Printing_Option,
648 X_Grouping_Rule_Id,
649 X_Cons_Inv_Flag,
650 X_Cons_Inv_Type,
651 X_Request_Id,
652 X_Attribute_Category,
653 X_Attribute1,
654 X_Attribute2,
655 X_Attribute3,
656 X_Attribute4,
657 X_Attribute5,
658 X_Attribute6,
659 X_Attribute7,
660 X_Attribute8,
661 X_Attribute9,
662 X_Attribute10,
663 X_Attribute11,
664 X_Attribute12,
665 X_Attribute13,
666 X_Attribute14,
667 X_Attribute15,
668 X_Jgzz_attribute_Category,
669 X_Jgzz_attribute1,
670 X_Jgzz_attribute2,
671 X_Jgzz_attribute3,
672 X_Jgzz_attribute4,
673 X_Jgzz_attribute5,
674 X_Jgzz_attribute6,
675 X_Jgzz_attribute7,
676 X_Jgzz_attribute8,
677 X_Jgzz_attribute9,
678 X_Jgzz_attribute10,
679 X_Jgzz_attribute11,
680 X_Jgzz_attribute12,
681 X_Jgzz_attribute13,
682 X_Jgzz_attribute14,
683 X_Jgzz_attribute15,
684 X_global_attribute_category,
685 X_global_attribute1,
686 X_global_attribute2,
687 X_global_attribute3,
688 X_global_attribute4,
689 X_global_attribute5,
690 X_global_attribute6,
691 X_global_attribute7,
692 X_global_attribute8,
693 X_global_attribute9,
694 X_global_attribute10,
695 X_global_attribute11,
696 X_global_attribute12,
697 X_global_attribute13,
698 X_global_attribute14,
699 X_global_attribute15,
700 X_global_attribute16,
701 X_global_attribute17,
702 X_global_attribute18,
703 X_global_attribute19,
704 X_global_attribute20,
705 X_lockbox_matching_option,
706 X_autocash_hierarchy_id_adr,
707 X_review_cycle,
708 X_credit_analyst_id,
709 X_credit_classification, /*Bug 3619062*/
710 X_Cons_Bill_Level,
711 X_LATE_CHARGE_CALCULATION_TRX ,
712 X_CREDIT_ITEMS_FLAG ,
713 X_DISPUTED_TRANSACTIONS_FLAG ,
714 X_LATE_CHARGE_TYPE ,
715 X_LATE_CHARGE_TERM_ID ,
716 X_INTEREST_CALCULATION_PERIOD ,
717 X_HOLD_CHARGED_INVOICES_FLAG ,
718 X_MESSAGE_TEXT_ID ,
719 X_MULTIPLE_INTEREST_RATES_FLAG,
720 X_CHARGE_BEGIN_DATE ,
721 X_AUTOMATCH_SET_ID );
722
723 -- Setting The Value Of Row Id To Be Returned To The Forms Block
724 -- "cust_prof" Block
725 OPEN C;
726 FETCH C INTO X_Row_id;
727 if (C%NOTFOUND) then
728 CLOSE C;
729 Raise NO_DATA_FOUND;
730 end if;
731 CLOSE C;
732 END Insert_Row;
733
734
735
736
737
738 PROCEDURE Lock_Row (X_Row_Id VARCHAR2,
739 X_Customer_Profile_Class_Id NUMBER,
740 X_Profile_Class_Name VARCHAR2,
741 X_Profile_Class_Description VARCHAR2,
742 X_Status VARCHAR2,
743 X_Collector_Id NUMBER,
744 X_Credit_Checking VARCHAR2,
745 X_Tolerance NUMBER,
746 X_Interest_Charges VARCHAR2,
747 X_Charge_On_Finance_Charge_Flg VARCHAR2,
748 X_Interest_Period_Days NUMBER,
749 X_Discount_Terms VARCHAR2,
750 X_Discount_Grace_Days NUMBER,
751 X_Statements VARCHAR2,
752 X_Statement_Cycle_Id NUMBER,
753 X_Credit_Balance_Statements VARCHAR2,
754 X_Standard_Terms NUMBER,
755 X_Override_Terms VARCHAR2,
756 X_Payment_Grace_Days NUMBER,
757 X_Dunning_Letters VARCHAR2,
758 X_Dunning_Letter_Set_Id NUMBER,
759 X_Autocash_Hierarchy_Id NUMBER,
760 X_Copy_Method VARCHAR2,
761 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
762 X_Tax_Printing_Option VARCHAR2,
763 X_Tax_Printing_Option_Meaning VARCHAR2,
764 X_Grouping_Rule_Id NUMBER,
765 X_Cons_Inv_Flag VARCHAR2,
766 X_Cons_Inv_Type VARCHAR2,
767 X_Request_Id NUMBER,
768 X_Attribute_Category VARCHAR2,
769 X_Attribute1 VARCHAR2,
770 X_Attribute2 VARCHAR2,
771 X_Attribute3 VARCHAR2,
772 X_Attribute4 VARCHAR2,
773 X_Attribute5 VARCHAR2,
774 X_Attribute6 VARCHAR2,
775 X_Attribute7 VARCHAR2,
776 X_Attribute8 VARCHAR2,
777 X_Attribute9 VARCHAR2,
778 X_Attribute10 VARCHAR2,
779 X_Attribute11 VARCHAR2,
780 X_Attribute12 VARCHAR2,
781 X_Attribute13 VARCHAR2,
782 X_Attribute14 VARCHAR2,
783 X_Attribute15 VARCHAR2,
784 X_Jgzz_attribute_Category VARCHAR2,
785 X_Jgzz_attribute1 VARCHAR2,
786 X_Jgzz_attribute2 VARCHAR2,
787 X_Jgzz_attribute3 VARCHAR2,
788 X_Jgzz_attribute4 VARCHAR2,
789 X_Jgzz_attribute5 VARCHAR2,
790 X_Jgzz_attribute6 VARCHAR2,
791 X_Jgzz_attribute7 VARCHAR2,
792 X_Jgzz_attribute8 VARCHAR2,
793 X_Jgzz_attribute9 VARCHAR2,
794 X_Jgzz_attribute10 VARCHAR2,
795 X_Jgzz_attribute11 VARCHAR2,
796 X_Jgzz_attribute12 VARCHAR2,
797 X_Jgzz_attribute13 VARCHAR2,
798 X_Jgzz_attribute14 VARCHAR2,
799 X_Jgzz_attribute15 VARCHAR2,
800 X_global_attribute_category VARCHAR2,
801 X_global_attribute1 VARCHAR2,
802 X_global_attribute2 VARCHAR2,
803 X_global_attribute3 VARCHAR2,
804 X_global_attribute4 VARCHAR2,
805 X_global_attribute5 VARCHAR2,
806 X_global_attribute6 VARCHAR2,
807 X_global_attribute7 VARCHAR2,
808 X_global_attribute8 VARCHAR2,
809 X_global_attribute9 VARCHAR2,
810 X_global_attribute10 VARCHAR2,
811 X_global_attribute11 VARCHAR2,
812 X_global_attribute12 VARCHAR2,
813 X_global_attribute13 VARCHAR2,
814 X_global_attribute14 VARCHAR2,
815 X_global_attribute15 VARCHAR2,
816 X_global_attribute16 VARCHAR2,
817 X_global_attribute17 VARCHAR2,
818 X_global_attribute18 VARCHAR2,
819 X_global_attribute19 VARCHAR2,
820 X_global_attribute20 VARCHAR2,
821 X_lockbox_matching_option VARCHAR2,
822 X_autocash_hierarchy_id_adr NUMBER,
823 X_review_cycle VARCHAR2,
824 X_credit_analyst_id NUMBER,
825 X_Cons_Bill_Level VARCHAR2,
826 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2,
827 X_CREDIT_ITEMS_FLAG VARCHAR2,
828 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2,
829 X_LATE_CHARGE_TYPE VARCHAR2,
830 X_LATE_CHARGE_TERM_ID NUMBER,
831 X_INTEREST_CALCULATION_PERIOD VARCHAR2,
832 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2,
833 X_MESSAGE_TEXT_ID NUMBER,
834 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2,
835 X_CHARGE_BEGIN_DATE DATE,
836 X_AUTOMATCH_SET_ID NUMBER)
837 IS
838 BEGIN
839
840 /*Bug 3619062 Call overloaded procedure with credit_classification set as NULL*/
841 Lock_Row ( X_Row_Id => X_Row_id ,
842 X_Customer_Profile_Class_Id => X_Customer_Profile_Class_Id ,
843 X_Profile_Class_Name => X_Profile_Class_Name ,
844 X_Profile_Class_Description => X_Profile_Class_Description ,
845 X_Status => X_Status ,
846 X_Collector_Id => X_Collector_Id ,
847 X_Credit_Checking => X_Credit_Checking ,
848 X_Tolerance => X_Tolerance ,
849 X_Interest_Charges => X_Interest_Charges ,
850 X_Charge_On_Finance_Charge_Flg => X_Charge_On_Finance_Charge_Flg ,
851 X_Interest_Period_Days => X_Interest_Period_Days ,
852 X_Discount_Terms => X_Discount_Terms ,
853 X_Discount_Grace_Days => X_Discount_Grace_Days ,
854 X_Statements => X_Statements ,
855 X_Statement_Cycle_Id => X_Statement_Cycle_Id ,
856 X_Credit_Balance_Statements => X_Credit_Balance_Statements ,
857 X_Standard_Terms => X_Standard_Terms ,
858 X_Override_Terms => X_Override_Terms ,
859 X_Payment_Grace_Days => X_Payment_Grace_Days ,
860 X_Dunning_Letters => X_Dunning_Letters ,
861 X_Dunning_Letter_Set_Id => X_Dunning_Letter_Set_Id ,
862 X_Autocash_Hierarchy_Id => X_Autocash_Hierarchy_Id ,
863 X_Copy_Method => X_Copy_Method ,
864 X_Auto_Rec_Incl_Disputed_Flag => X_Auto_Rec_Incl_Disputed_Flag ,
865 X_Tax_Printing_Option => X_Tax_Printing_Option ,
866 X_Tax_Printing_Option_Meaning => X_Tax_Printing_Option_Meaning ,
867 X_Grouping_Rule_Id => X_Grouping_Rule_Id ,
868 X_Cons_Inv_Flag => X_Cons_Inv_Flag ,
869 X_Cons_Inv_Type => X_Cons_Inv_Type ,
870 X_Request_Id => X_Request_Id ,
871 X_Attribute_Category => X_Attribute_Category ,
872 X_Attribute1 => X_Attribute1 ,
873 X_Attribute2 => X_Attribute2 ,
874 X_Attribute3 => X_Attribute3 ,
875 X_Attribute4 => X_Attribute4 ,
876 X_Attribute5 => X_Attribute5 ,
877 X_Attribute6 => X_Attribute6 ,
878 X_Attribute7 => X_Attribute7 ,
879 X_Attribute8 => X_Attribute8 ,
880 X_Attribute9 => X_Attribute9 ,
881 X_Attribute10 => X_Attribute10 ,
882 X_Attribute11 => X_Attribute11 ,
883 X_Attribute12 => X_Attribute12 ,
884 X_Attribute13 => X_Attribute13 ,
885 X_Attribute14 => X_Attribute14 ,
886 X_Attribute15 => X_Attribute15 ,
887 X_Jgzz_attribute_Category => X_Jgzz_attribute_Category ,
888 X_Jgzz_attribute1 => X_Jgzz_attribute1 ,
889 X_Jgzz_attribute2 => X_Jgzz_attribute2 ,
890 X_Jgzz_attribute3 => X_Jgzz_attribute3 ,
891 X_Jgzz_attribute4 => X_Jgzz_attribute4 ,
892 X_Jgzz_attribute5 => X_Jgzz_attribute5 ,
893 X_Jgzz_attribute6 => X_Jgzz_attribute6 ,
894 X_Jgzz_attribute7 => X_Jgzz_attribute7 ,
895 X_Jgzz_attribute8 => X_Jgzz_attribute8 ,
896 X_Jgzz_attribute9 => X_Jgzz_attribute9 ,
897 X_Jgzz_attribute10 => X_Jgzz_attribute10 ,
898 X_Jgzz_attribute11 => X_Jgzz_attribute11 ,
899 X_Jgzz_attribute12 => X_Jgzz_attribute12 ,
900 X_Jgzz_attribute13 => X_Jgzz_attribute13 ,
901 X_Jgzz_attribute14 => X_Jgzz_attribute14 ,
902 X_Jgzz_attribute15 => X_Jgzz_attribute15 ,
903 X_global_attribute_category => X_global_attribute_category ,
904 X_global_attribute1 => X_global_attribute1 ,
905 X_global_attribute2 => X_global_attribute2 ,
906 X_global_attribute3 => X_global_attribute3 ,
907 X_global_attribute4 => X_global_attribute4 ,
908 X_global_attribute5 => X_global_attribute5 ,
909 X_global_attribute6 => X_global_attribute6 ,
910 X_global_attribute7 => X_global_attribute7 ,
911 X_global_attribute8 => X_global_attribute8 ,
912 X_global_attribute9 => X_global_attribute9 ,
913 X_global_attribute10 => X_global_attribute10 ,
914 X_global_attribute11 => X_global_attribute11 ,
915 X_global_attribute12 => X_global_attribute12 ,
916 X_global_attribute13 => X_global_attribute13 ,
917 X_global_attribute14 => X_global_attribute14 ,
918 X_global_attribute15 => X_global_attribute15 ,
919 X_global_attribute16 => X_global_attribute16 ,
920 X_global_attribute17 => X_global_attribute17 ,
921 X_global_attribute18 => X_global_attribute18 ,
922 X_global_attribute19 => X_global_attribute19 ,
923 X_global_attribute20 => X_global_attribute20 ,
924 X_lockbox_matching_option => X_lockbox_matching_option ,
925 X_autocash_hierarchy_id_adr => X_autocash_hierarchy_id_adr ,
926 X_review_cycle => X_review_cycle ,
927 X_credit_analyst_id => X_credit_analyst_id ,
928 X_credit_classification => NULL ,
929 X_Cons_Bill_Level => X_Cons_Bill_Level,
930 X_LATE_CHARGE_CALCULATION_TRX => X_LATE_CHARGE_CALCULATION_TRX,
931 X_CREDIT_ITEMS_FLAG => X_CREDIT_ITEMS_FLAG,
932 X_DISPUTED_TRANSACTIONS_FLAG => X_DISPUTED_TRANSACTIONS_FLAG,
933 X_LATE_CHARGE_TYPE => X_LATE_CHARGE_TYPE,
934 X_LATE_CHARGE_TERM_ID => X_LATE_CHARGE_TERM_ID,
935 X_INTEREST_CALCULATION_PERIOD => X_INTEREST_CALCULATION_PERIOD,
936 X_HOLD_CHARGED_INVOICES_FLAG => X_HOLD_CHARGED_INVOICES_FLAG,
937 X_MESSAGE_TEXT_ID => X_MESSAGE_TEXT_ID,
938 X_MULTIPLE_INTEREST_RATES_FLAG => X_MULTIPLE_INTEREST_RATES_FLAG,
939 X_CHARGE_BEGIN_DATE => X_CHARGE_BEGIN_DATE,
940 X_AUTOMATCH_SET_ID => X_AUTOMATCH_SET_ID);
941 END Lock_Row;
942
943 PROCEDURE Lock_Row (X_Row_Id VARCHAR2,
944 X_Customer_Profile_Class_Id NUMBER,
945 X_Profile_Class_Name VARCHAR2,
946 X_Profile_Class_Description VARCHAR2,
947 X_Status VARCHAR2,
948 X_Collector_Id NUMBER,
949 X_Credit_Checking VARCHAR2,
950 X_Tolerance NUMBER,
951 X_Interest_Charges VARCHAR2,
952 X_Charge_On_Finance_Charge_Flg VARCHAR2,
953 X_Interest_Period_Days NUMBER,
954 X_Discount_Terms VARCHAR2,
955 X_Discount_Grace_Days NUMBER,
956 X_Statements VARCHAR2,
957 X_Statement_Cycle_Id NUMBER,
958 X_Credit_Balance_Statements VARCHAR2,
959 X_Standard_Terms NUMBER,
960 X_Override_Terms VARCHAR2,
961 X_Payment_Grace_Days NUMBER,
962 X_Dunning_Letters VARCHAR2,
963 X_Dunning_Letter_Set_Id NUMBER,
964 X_Autocash_Hierarchy_Id NUMBER,
965 X_Copy_Method VARCHAR2,
966 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
967 X_Tax_Printing_Option VARCHAR2,
968 X_Tax_Printing_Option_Meaning VARCHAR2,
969 X_Grouping_Rule_Id NUMBER,
970 X_Cons_Inv_Flag VARCHAR2,
971 X_Cons_Inv_Type VARCHAR2,
972 X_Request_Id NUMBER,
973 X_Attribute_Category VARCHAR2,
974 X_Attribute1 VARCHAR2,
975 X_Attribute2 VARCHAR2,
976 X_Attribute3 VARCHAR2,
977 X_Attribute4 VARCHAR2,
978 X_Attribute5 VARCHAR2,
979 X_Attribute6 VARCHAR2,
980 X_Attribute7 VARCHAR2,
981 X_Attribute8 VARCHAR2,
982 X_Attribute9 VARCHAR2,
983 X_Attribute10 VARCHAR2,
984 X_Attribute11 VARCHAR2,
985 X_Attribute12 VARCHAR2,
986 X_Attribute13 VARCHAR2,
987 X_Attribute14 VARCHAR2,
988 X_Attribute15 VARCHAR2,
989 X_Jgzz_attribute_Category VARCHAR2,
990 X_Jgzz_attribute1 VARCHAR2,
991 X_Jgzz_attribute2 VARCHAR2,
992 X_Jgzz_attribute3 VARCHAR2,
993 X_Jgzz_attribute4 VARCHAR2,
994 X_Jgzz_attribute5 VARCHAR2,
995 X_Jgzz_attribute6 VARCHAR2,
996 X_Jgzz_attribute7 VARCHAR2,
997 X_Jgzz_attribute8 VARCHAR2,
998 X_Jgzz_attribute9 VARCHAR2,
999 X_Jgzz_attribute10 VARCHAR2,
1000 X_Jgzz_attribute11 VARCHAR2,
1001 X_Jgzz_attribute12 VARCHAR2,
1002 X_Jgzz_attribute13 VARCHAR2,
1003 X_Jgzz_attribute14 VARCHAR2,
1004 X_Jgzz_attribute15 VARCHAR2,
1005 X_global_attribute_category VARCHAR2,
1006 X_global_attribute1 VARCHAR2,
1007 X_global_attribute2 VARCHAR2,
1008 X_global_attribute3 VARCHAR2,
1009 X_global_attribute4 VARCHAR2,
1010 X_global_attribute5 VARCHAR2,
1011 X_global_attribute6 VARCHAR2,
1012 X_global_attribute7 VARCHAR2,
1013 X_global_attribute8 VARCHAR2,
1014 X_global_attribute9 VARCHAR2,
1015 X_global_attribute10 VARCHAR2,
1016 X_global_attribute11 VARCHAR2,
1017 X_global_attribute12 VARCHAR2,
1018 X_global_attribute13 VARCHAR2,
1019 X_global_attribute14 VARCHAR2,
1020 X_global_attribute15 VARCHAR2,
1021 X_global_attribute16 VARCHAR2,
1022 X_global_attribute17 VARCHAR2,
1023 X_global_attribute18 VARCHAR2,
1024 X_global_attribute19 VARCHAR2,
1025 X_global_attribute20 VARCHAR2,
1026 X_lockbox_matching_option VARCHAR2,
1027 X_autocash_hierarchy_id_adr NUMBER,
1028 X_review_cycle VARCHAR2,
1029 X_credit_analyst_id NUMBER,
1030 X_credit_classification VARCHAR2, /*Bug 3619062*/
1031 X_Cons_Bill_Level VARCHAR2,
1032 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2,
1033 X_CREDIT_ITEMS_FLAG VARCHAR2,
1034 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2,
1035 X_LATE_CHARGE_TYPE VARCHAR2,
1036 X_LATE_CHARGE_TERM_ID NUMBER,
1037 X_INTEREST_CALCULATION_PERIOD VARCHAR2,
1038 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2,
1039 X_MESSAGE_TEXT_ID NUMBER,
1040 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2,
1041 X_CHARGE_BEGIN_DATE DATE,
1042 X_AUTOMATCH_SET_ID NUMBER)
1043 IS
1044 CURSOR C IS
1045 SELECT *
1046 FROM HZ_CUST_PROFILE_CLASSES
1047 WHERE rowid = X_Row_Id
1048 FOR UPDATE of Profile_Class_Id NOWAIT;
1049 Recinfo C%ROWTYPE;
1050 BEGIN
1051 OPEN C;
1052 FETCH C INTO Recinfo;
1053 if (C%NOTFOUND) then
1054 CLOSE C;
1055 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1056 APP_EXCEPTION.Raise_Exception;
1057 end if;
1058 CLOSE C;
1059
1060 IF ( (Recinfo.profile_class_id = X_Customer_Profile_Class_Id)
1061 AND (Recinfo.name = X_Profile_Class_Name)
1062 AND ( (Recinfo.description = X_Profile_Class_Description)
1063 OR ( (Recinfo.description IS NULL)
1064 AND (X_Profile_Class_Description IS NULL)) )
1065 AND (Recinfo.status = X_Status)
1066 AND (Recinfo.collector_id = X_Collector_Id)
1067 AND (Recinfo.credit_checking = X_Credit_Checking)
1068 AND (Recinfo.tolerance = X_Tolerance)
1069 AND (Recinfo.interest_charges = X_Interest_Charges)
1070 AND ( (Recinfo.charge_on_finance_charge_flag = X_Charge_On_Finance_Charge_Flg)
1071 OR ( (Recinfo.charge_on_finance_charge_flag IS NULL)
1072 AND (X_Charge_On_Finance_Charge_Flg IS NULL)))
1073 AND ( (Recinfo.interest_period_days = X_Interest_Period_Days)
1074 OR ( (Recinfo.interest_period_days IS NULL)
1075 AND (X_Interest_Period_Days IS NULL)))
1076 AND (Recinfo.discount_terms = X_Discount_Terms)
1077 AND ( (Recinfo.discount_grace_days = X_Discount_Grace_Days)
1078 OR ( (Recinfo.discount_grace_days IS NULL)
1079 AND (X_Discount_Grace_Days IS NULL)))
1080 AND (Recinfo.statements = X_Statements)
1081 AND ( (Recinfo.statement_cycle_id = X_Statement_Cycle_Id)
1082 OR ( (Recinfo.statement_cycle_id IS NULL)
1083 AND (X_Statement_Cycle_Id IS NULL)))
1084 AND (Recinfo.credit_balance_statements = X_Credit_Balance_Statements)
1085 AND ( (Recinfo.standard_terms = X_Standard_Terms)
1086 OR ( (Recinfo.standard_terms IS NULL)
1087 AND (X_Standard_Terms IS NULL)))
1088 AND ( (Recinfo.override_terms = X_Override_Terms)
1089 OR ( (Recinfo.override_terms IS NULL)
1090 AND (X_Override_Terms IS NULL)))
1091 AND ( (Recinfo.payment_grace_days = X_Payment_Grace_Days)
1092 OR ( (Recinfo.payment_grace_days IS NULL)
1093 AND (X_Payment_Grace_Days IS NULL)))
1094 AND (Recinfo.dunning_letters = X_Dunning_Letters)
1095 AND ( (Recinfo.dunning_letter_set_id = X_Dunning_Letter_Set_Id)
1096 OR ( (Recinfo.dunning_letter_set_id IS NULL)
1097 AND (X_Dunning_Letter_Set_Id IS NULL)))
1098 AND ( (Recinfo.autocash_hierarchy_id = X_Autocash_Hierarchy_Id)
1099 OR ( (Recinfo.autocash_hierarchy_id IS NULL)
1100 AND (X_Autocash_Hierarchy_Id IS NULL)))
1101 AND ( (Recinfo.copy_method = X_Copy_Method)
1102 OR ( (Recinfo.copy_method IS NULL)
1103 AND (X_Copy_Method IS NULL)))
1104 AND (Recinfo.auto_rec_incl_disputed_flag = X_Auto_Rec_Incl_Disputed_Flag)
1105 AND ( (Recinfo.tax_printing_option = X_Tax_Printing_Option)
1106 OR ( (Recinfo.tax_printing_option IS NULL)
1107 AND (X_Tax_Printing_Option IS NULL)))
1108 AND ( (Recinfo.grouping_rule_id = X_Grouping_Rule_Id)
1109 OR ( (Recinfo.grouping_rule_id IS NULL)
1110 AND (X_Grouping_Rule_Id IS NULL)))
1111 AND nvl( Recinfo.cons_inv_flag , 'N' ) = X_Cons_Inv_Flag
1112 AND ( (Recinfo.cons_inv_type = X_Cons_Inv_Type)
1113 OR ( (Recinfo.cons_inv_type IS NULL)
1114 AND (X_Cons_Inv_Type IS NULL)))
1115 AND ( (Recinfo.request_id = X_Request_Id)
1116 OR ( (Recinfo.request_id IS NULL)
1117 AND (X_Request_Id IS NULL)))
1118 AND ( (Recinfo.attribute_category = X_Attribute_Category)
1119 OR ( (Recinfo.attribute_category IS NULL)
1120 AND (X_Attribute_Category IS NULL)))
1121 AND ( (Recinfo.attribute1 = X_Attribute1)
1122 OR ( (Recinfo.attribute1 IS NULL)
1123 AND (X_Attribute1 IS NULL)))
1124 AND ( (Recinfo.attribute2 = X_Attribute2)
1125 OR ( (Recinfo.attribute2 IS NULL)
1126 AND (X_Attribute2 IS NULL)))
1127 AND ( (Recinfo.attribute3 = X_Attribute3)
1128 OR ( (Recinfo.attribute3 IS NULL)
1129 AND (X_Attribute3 IS NULL)))
1130 AND ( (Recinfo.attribute4 = X_Attribute4)
1131 OR ( (Recinfo.attribute4 IS NULL)
1132 AND (X_Attribute4 IS NULL)))
1133 AND ( (Recinfo.attribute5 = X_Attribute5)
1134 OR ( (Recinfo.attribute5 IS NULL)
1135 AND (X_Attribute5 IS NULL)))
1136 AND ( (Recinfo.attribute6 = X_Attribute6)
1137 OR ( (Recinfo.attribute6 IS NULL)
1138 AND (X_Attribute6 IS NULL)))
1139 AND ( (Recinfo.attribute7 = X_Attribute7)
1140 OR ( (Recinfo.attribute7 IS NULL)
1141 AND (X_Attribute7 IS NULL)))
1142 AND ( (Recinfo.attribute8 = X_Attribute8)
1143 OR ( (Recinfo.attribute8 IS NULL)
1144 AND (X_Attribute8 IS NULL)))
1145 AND ( (Recinfo.attribute9 = X_Attribute9)
1146 OR ( (Recinfo.attribute9 IS NULL)
1147 AND (X_Attribute9 IS NULL)))
1148 AND ( (Recinfo.attribute10 = X_Attribute10)
1149 OR ( (Recinfo.attribute10 IS NULL)
1150 AND (X_Attribute10 IS NULL)))
1151 AND ( (Recinfo.attribute11 = X_Attribute11)
1152 OR ( (Recinfo.attribute11 IS NULL)
1153 AND (X_Attribute11 IS NULL)))
1154 AND ( (Recinfo.attribute12 = X_Attribute12)
1155 OR ( (Recinfo.attribute12 IS NULL)
1156 AND (X_Attribute12 IS NULL)))
1157 AND ( (Recinfo.attribute13 = X_Attribute13)
1158 OR ( (Recinfo.attribute13 IS NULL)
1159 AND (X_Attribute13 IS NULL)))
1160 AND ( (Recinfo.attribute14 = X_Attribute14)
1161 OR ( (Recinfo.attribute14 IS NULL)
1162 AND (X_Attribute14 IS NULL)))
1163 AND ( (Recinfo.attribute15 = X_Attribute15)
1164 OR ( (Recinfo.attribute15 IS NULL)
1165 AND (X_Attribute15 IS NULL)))
1166 AND ( (Recinfo.jgzz_attribute_category = X_Jgzz_attribute_Category)
1167 OR ( (Recinfo.jgzz_attribute_category IS NULL)
1168 AND (X_Jgzz_attribute_Category IS NULL)))
1169 AND ( (Recinfo.jgzz_attribute1 = X_Jgzz_attribute1)
1170 OR ( (Recinfo.jgzz_attribute1 IS NULL)
1171 AND (X_Jgzz_attribute1 IS NULL)))
1172 AND ( (Recinfo.jgzz_attribute2 = X_Jgzz_attribute2)
1173 OR ( (Recinfo.jgzz_attribute2 IS NULL)
1174 AND (X_Jgzz_attribute2 IS NULL)))
1175 AND ( (Recinfo.jgzz_attribute3 = X_Jgzz_attribute3)
1176 OR ( (Recinfo.jgzz_attribute3 IS NULL)
1177 AND (X_Jgzz_attribute3 IS NULL)))
1178 AND ( (Recinfo.jgzz_attribute4 = X_Jgzz_attribute4)
1179 OR ( (Recinfo.jgzz_attribute4 IS NULL)
1180 AND (X_Jgzz_attribute4 IS NULL)))
1181 AND ( (Recinfo.jgzz_attribute5 = X_Jgzz_attribute5)
1182 OR ( (Recinfo.jgzz_attribute5 IS NULL)
1183 AND (X_Jgzz_attribute5 IS NULL)))
1184 AND ( (Recinfo.jgzz_attribute6 = X_Jgzz_attribute6)
1185 OR ( (Recinfo.jgzz_attribute6 IS NULL)
1186 AND (X_Jgzz_attribute6 IS NULL)))
1187 AND ( (Recinfo.jgzz_attribute7 = X_Jgzz_attribute7)
1188 OR ( (Recinfo.jgzz_attribute7 IS NULL)
1189 AND (X_Jgzz_attribute7 IS NULL)))
1190 AND ( (Recinfo.jgzz_attribute8 = X_Jgzz_attribute8)
1191 OR ( (Recinfo.jgzz_attribute8 IS NULL)
1192 AND (X_Jgzz_attribute8 IS NULL)))
1193 AND ( (Recinfo.jgzz_attribute9 = X_Jgzz_attribute9)
1194 OR ( (Recinfo.jgzz_attribute9 IS NULL)
1195 AND (X_Jgzz_attribute9 IS NULL)))
1196 AND ( (Recinfo.jgzz_attribute10 = X_Jgzz_attribute10)
1197 OR ( (Recinfo.jgzz_attribute10 IS NULL)
1198 AND (X_Jgzz_attribute10 IS NULL)))
1199 AND ( (Recinfo.jgzz_attribute11 = X_Jgzz_attribute11)
1200 OR ( (Recinfo.jgzz_attribute11 IS NULL)
1201 AND (X_Jgzz_attribute11 IS NULL)))
1202 AND ( (Recinfo.jgzz_attribute12 = X_Jgzz_attribute12)
1203 OR ( (Recinfo.jgzz_attribute12 IS NULL)
1204 AND (X_Jgzz_attribute12 IS NULL)))
1205 AND ( (Recinfo.jgzz_attribute13 = X_Jgzz_attribute13)
1206 OR ( (Recinfo.jgzz_attribute13 IS NULL)
1207 AND (X_Jgzz_attribute13 IS NULL)))
1208 AND ( (Recinfo.jgzz_attribute14 = X_Jgzz_attribute14)
1209 OR ( (Recinfo.jgzz_attribute14 IS NULL)
1210 AND (X_Jgzz_attribute14 IS NULL)))
1211 AND ( (Recinfo.jgzz_attribute15 = X_Jgzz_attribute15)
1212 OR ( (Recinfo.jgzz_attribute15 IS NULL)
1213 AND (X_Jgzz_attribute15 IS NULL)))
1214 AND ( (Recinfo.global_attribute_category = X_global_attribute_category)
1215 OR ( (Recinfo.global_attribute_category IS NULL)
1216 AND (X_global_attribute_category IS NULL)))
1217 AND ( (Recinfo.global_attribute1 = X_global_attribute1)
1218 OR ( (Recinfo.global_attribute1 IS NULL)
1219 AND (X_global_Attribute1 IS NULL)))
1220 AND ( (Recinfo.global_attribute2 = X_global_attribute2)
1221 OR ( (Recinfo.global_attribute2 IS NULL)
1222 AND (X_global_attribute2 IS NULL)))
1223 AND ( (Recinfo.global_attribute3 = X_global_attribute3)
1224 OR ( (Recinfo.global_attribute3 IS NULL)
1225 AND (X_global_attribute3 IS NULL)))
1226 AND ( (Recinfo.global_attribute4 = X_global_attribute4)
1227 OR ( (Recinfo.global_attribute4 IS NULL)
1228 AND (X_global_attribute4 IS NULL)))
1229 AND ( (Recinfo.global_attribute5 = X_global_attribute5)
1230 OR ( (Recinfo.global_attribute5 IS NULL)
1231 AND (X_global_attribute5 IS NULL)))
1232 AND ( (Recinfo.global_attribute6 = X_global_attribute6)
1233 OR ( (Recinfo.global_attribute6 IS NULL)
1234 AND (X_global_attribute6 IS NULL)))
1235 AND ( (Recinfo.global_attribute7 = X_global_attribute7)
1236 OR ( (Recinfo.global_attribute7 IS NULL)
1237 AND (X_global_attribute7 IS NULL)))
1238 AND ( (Recinfo.global_attribute8 = X_global_attribute8)
1239 OR ( (Recinfo.global_attribute8 IS NULL)
1240 AND (X_global_attribute8 IS NULL)))
1241 AND ( (Recinfo.global_attribute9 = X_global_attribute9)
1242 OR ( (Recinfo.global_attribute9 IS NULL)
1243 AND (X_global_attribute9 IS NULL)))
1244 AND ( (Recinfo.global_attribute10 = X_global_attribute10)
1245 OR ( (Recinfo.global_attribute10 IS NULL)
1246 AND (X_global_attribute10 IS NULL))))
1247 AND ( (Recinfo.global_attribute11 = X_global_attribute11)
1248 OR ( (Recinfo.global_attribute11 IS NULL)
1249 AND (X_global_attribute11 IS NULL)))
1250 AND ( (Recinfo.global_attribute12 = X_global_attribute12)
1251 OR ( (Recinfo.global_attribute12 IS NULL)
1252 AND (X_global_attribute12 IS NULL)))
1253 AND ( (Recinfo.global_attribute13 = X_global_attribute13)
1254 OR ( (Recinfo.global_attribute13 IS NULL)
1255 AND (X_global_attribute13 IS NULL))
1256 AND ( (Recinfo.global_attribute14 = X_global_attribute14)
1257 OR ( (Recinfo.global_attribute14 IS NULL)
1258 AND (X_global_attribute14 IS NULL)))
1259 AND ( (Recinfo.global_attribute15 = X_global_attribute15)
1260 OR ( (Recinfo.global_attribute15 IS NULL)
1261 AND (X_global_attribute15 IS NULL)))
1262 AND ( (Recinfo.global_attribute16 = X_global_attribute16)
1263 OR ( (Recinfo.global_attribute16 IS NULL)
1264 AND (X_global_attribute16 IS NULL)))
1265 AND ( (Recinfo.global_attribute17 = X_global_attribute17)
1266 OR ( (Recinfo.global_attribute17 IS NULL)
1267 AND (X_global_attribute17 IS NULL)))
1268 AND ( (Recinfo.global_attribute18 = X_global_attribute18)
1269 OR ( (Recinfo.global_attribute18 IS NULL)
1270 AND (X_global_attribute18 IS NULL)))
1271 AND ( (Recinfo.global_attribute19 = X_global_attribute19)
1272 OR ( (Recinfo.global_attribute19 IS NULL)
1273 AND (X_global_attribute19 IS NULL)))
1274 AND ( (Recinfo.global_attribute20 = X_global_attribute20)
1275 OR ( (Recinfo.global_attribute20 IS NULL)
1276 AND (X_global_attribute20 IS NULL)))
1277 AND ( (Recinfo.lockbox_matching_option = X_lockbox_matching_option)
1278 OR ( (Recinfo.lockbox_matching_option IS NULL)
1279 AND (X_lockbox_matching_option IS NULL)))
1280 AND ( (Recinfo.autocash_hierarchy_id_for_adr = X_autocash_hierarchy_id_adr)
1281 OR ( (Recinfo.autocash_hierarchy_id_for_adr IS NULL)
1282 AND (X_autocash_hierarchy_id_adr IS NULL)))
1283 AND ( (Recinfo.review_cycle = X_review_cycle)
1284 OR ( (Recinfo.review_cycle IS NULL)
1285 AND (X_review_cycle IS NULL)))
1286 AND ( (Recinfo.credit_analyst_id = X_credit_analyst_id)
1287 OR ( (Recinfo.credit_analyst_id IS NULL)
1288 AND (X_credit_analyst_id IS NULL)))
1289 AND ( (Recinfo.credit_classification = X_credit_classification)
1290 OR ( (Recinfo.credit_classification IS NULL)
1291 AND (X_credit_classification IS NULL)))
1292 AND ( (Recinfo.Cons_Bill_Level = X_Cons_Bill_Level)
1293 OR ( (Recinfo.Cons_Bill_Level IS NULL)
1294 AND (X_Cons_Bill_Level IS NULL)))
1295 AND ( (Recinfo.LATE_CHARGE_CALCULATION_TRX = X_LATE_CHARGE_CALCULATION_TRX)
1296 OR ( (Recinfo.LATE_CHARGE_CALCULATION_TRX IS NULL)
1297 AND (X_LATE_CHARGE_CALCULATION_TRX IS NULL)))
1298 AND ( (Recinfo.CREDIT_ITEMS_FLAG = X_CREDIT_ITEMS_FLAG)
1299 OR ( (Recinfo.CREDIT_ITEMS_FLAG IS NULL)
1300 AND (X_CREDIT_ITEMS_FLAG IS NULL)))
1301 AND ( (Recinfo.DISPUTED_TRANSACTIONS_FLAG = X_DISPUTED_TRANSACTIONS_FLAG)
1302 OR ( (Recinfo.DISPUTED_TRANSACTIONS_FLAG IS NULL)
1303 AND (X_DISPUTED_TRANSACTIONS_FLAG IS NULL)))
1304 AND ( (Recinfo.LATE_CHARGE_TYPE = X_LATE_CHARGE_TYPE)
1305 OR ( (Recinfo.LATE_CHARGE_TYPE IS NULL)
1306 AND (X_LATE_CHARGE_TYPE IS NULL)))
1307 AND ( (Recinfo.LATE_CHARGE_TERM_ID = X_LATE_CHARGE_TERM_ID)
1308 OR ( (Recinfo.LATE_CHARGE_TERM_ID IS NULL)
1309 AND (X_LATE_CHARGE_TERM_ID IS NULL)))
1310 AND ( (Recinfo.INTEREST_CALCULATION_PERIOD = X_INTEREST_CALCULATION_PERIOD)
1311 OR ( (Recinfo.INTEREST_CALCULATION_PERIOD IS NULL)
1312 AND (X_INTEREST_CALCULATION_PERIOD IS NULL)))
1313 AND ( (Recinfo.HOLD_CHARGED_INVOICES_FLAG = X_HOLD_CHARGED_INVOICES_FLAG)
1314 OR ( (Recinfo.HOLD_CHARGED_INVOICES_FLAG IS NULL)
1315 AND (X_HOLD_CHARGED_INVOICES_FLAG IS NULL)))
1316 AND ( (Recinfo.MESSAGE_TEXT_ID = X_MESSAGE_TEXT_ID)
1317 OR ( (Recinfo.MESSAGE_TEXT_ID IS NULL)
1318 AND (X_MESSAGE_TEXT_ID IS NULL)))
1319 AND ( (Recinfo.MULTIPLE_INTEREST_RATES_FLAG = X_MULTIPLE_INTEREST_RATES_FLAG)
1320 OR ( (Recinfo.MULTIPLE_INTEREST_RATES_FLAG IS NULL)
1321 AND (X_MULTIPLE_INTEREST_RATES_FLAG IS NULL)))
1322 AND ( (Recinfo.CHARGE_BEGIN_DATE = X_CHARGE_BEGIN_DATE)
1323 OR ( (Recinfo.CHARGE_BEGIN_DATE IS NULL)
1324 AND (X_CHARGE_BEGIN_DATE IS NULL)))
1325 AND ( (Recinfo.AUTOMATCH_SET_ID = X_AUTOMATCH_SET_ID)
1326 OR ( (Recinfo.AUTOMATCH_SET_ID IS NULL)
1327 AND (X_AUTOMATCH_SET_ID IS NULL)))
1328 )
1329 THEN
1330 RETURN;
1331 ELSE
1332 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1333 APP_EXCEPTION.Raise_Exception;
1334 END IF;
1335 END Lock_Row;
1336
1337
1338 PROCEDURE Update_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
1339 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER,
1340 X_Last_Updated_By NUMBER,
1341 X_Last_Update_Date DATE,
1342 X_Last_Update_Login NUMBER,
1343 X_Profile_Class_Name VARCHAR2,
1344 X_Profile_Class_Description VARCHAR2,
1345 X_Status VARCHAR2,
1346 X_Collector_Id NUMBER,
1347 X_Credit_Checking VARCHAR2,
1348 X_Tolerance NUMBER,
1349 X_Interest_Charges VARCHAR2,
1350 X_Charge_On_Finance_Charge_Flg VARCHAR2,
1351 X_Interest_Period_Days NUMBER,
1352 X_Discount_Terms VARCHAR2,
1353 X_Discount_Grace_Days NUMBER,
1354 X_Statements VARCHAR2,
1355 X_Statement_Cycle_Id NUMBER,
1356 X_Credit_Balance_Statements VARCHAR2,
1357 X_Standard_Terms NUMBER,
1358 X_Override_Terms VARCHAR2,
1359 X_Payment_Grace_Days NUMBER,
1360 X_Dunning_Letters VARCHAR2,
1361 X_Dunning_Letter_Set_Id NUMBER,
1362 X_Autocash_Hierarchy_Id NUMBER,
1363 X_Copy_Method VARCHAR2,
1364 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
1365 X_Tax_Printing_Option VARCHAR2,
1366 X_Tax_Printing_Option_Meaning VARCHAR2,
1367 X_Grouping_Rule_Id NUMBER,
1368 X_Cons_Inv_Flag VARCHAR2,
1369 X_Cons_Inv_Type VARCHAR2,
1370 X_Request_Id NUMBER,
1371 X_Attribute_Category VARCHAR2,
1372 X_Attribute1 VARCHAR2,
1373 X_Attribute2 VARCHAR2,
1374 X_Attribute3 VARCHAR2,
1375 X_Attribute4 VARCHAR2,
1376 X_Attribute5 VARCHAR2,
1377 X_Attribute6 VARCHAR2,
1378 X_Attribute7 VARCHAR2,
1379 X_Attribute8 VARCHAR2,
1380 X_Attribute9 VARCHAR2,
1381 X_Attribute10 VARCHAR2,
1382 X_Attribute11 VARCHAR2,
1383 X_Attribute12 VARCHAR2,
1384 X_Attribute13 VARCHAR2,
1385 X_Attribute14 VARCHAR2,
1386 X_Attribute15 VARCHAR2,
1387 X_Jgzz_attribute_Category VARCHAR2,
1388 X_Jgzz_attribute1 VARCHAR2,
1389 X_Jgzz_attribute2 VARCHAR2,
1390 X_Jgzz_attribute3 VARCHAR2,
1391 X_Jgzz_attribute4 VARCHAR2,
1392 X_Jgzz_attribute5 VARCHAR2,
1393 X_Jgzz_attribute6 VARCHAR2,
1394 X_Jgzz_attribute7 VARCHAR2,
1395 X_Jgzz_attribute8 VARCHAR2,
1396 X_Jgzz_attribute9 VARCHAR2,
1397 X_Jgzz_attribute10 VARCHAR2,
1398 X_Jgzz_attribute11 VARCHAR2,
1399 X_Jgzz_attribute12 VARCHAR2,
1400 X_Jgzz_attribute13 VARCHAR2,
1401 X_Jgzz_attribute14 VARCHAR2,
1402 X_Jgzz_attribute15 VARCHAR2,
1403 X_global_attribute_category VARCHAR2,
1404 X_global_attribute1 VARCHAR2,
1405 X_global_attribute2 VARCHAR2,
1406 X_global_attribute3 VARCHAR2,
1407 X_global_attribute4 VARCHAR2,
1408 X_global_attribute5 VARCHAR2,
1409 X_global_attribute6 VARCHAR2,
1410 X_global_attribute7 VARCHAR2,
1411 X_global_attribute8 VARCHAR2,
1412 X_global_attribute9 VARCHAR2,
1413 X_global_attribute10 VARCHAR2,
1414 X_global_attribute11 VARCHAR2,
1415 X_global_attribute12 VARCHAR2,
1416 X_global_attribute13 VARCHAR2,
1417 X_global_attribute14 VARCHAR2,
1418 X_global_attribute15 VARCHAR2,
1419 X_global_attribute16 VARCHAR2,
1420 X_global_attribute17 VARCHAR2,
1421 X_global_attribute18 VARCHAR2,
1422 X_global_attribute19 VARCHAR2,
1423 X_global_attribute20 VARCHAR2,
1424 X_lockbox_matching_option VARCHAR2,
1425 X_autocash_hierarchy_id_adr NUMBER ,
1426 X_review_cycle VARCHAR2 DEFAULT NULL,
1427 X_credit_analyst_id NUMBER DEFAULT NULL,
1428 X_Cons_Bill_Level VARCHAR2 DEFAULT NULL,
1429 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2 DEFAULT NULL,
1430 X_CREDIT_ITEMS_FLAG VARCHAR2 DEFAULT NULL,
1431 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2 DEFAULT NULL,
1432 X_LATE_CHARGE_TYPE VARCHAR2 DEFAULT NULL,
1433 X_LATE_CHARGE_TERM_ID NUMBER DEFAULT NULL,
1434 X_INTEREST_CALCULATION_PERIOD VARCHAR2 DEFAULT NULL,
1435 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2 DEFAULT NULL,
1436 X_MESSAGE_TEXT_ID NUMBER DEFAULT NULL,
1437 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 DEFAULT NULL,
1438 X_CHARGE_BEGIN_DATE DATE DEFAULT NULL,
1439 X_AUTOMATCH_SET_ID NUMBER DEFAULT NULL)
1440 IS
1441 BEGIN
1442
1443 /*Bug 3619062 Call overloaded procedure with credit_classification set as NULL*/
1444 UPDATE_ROW ( X_ROW_ID => X_ROW_ID ,
1445 X_CUSTOMER_PROFILE_CLASS_ID => X_CUSTOMER_PROFILE_CLASS_ID ,
1446 X_LAST_UPDATED_BY => X_LAST_UPDATED_BY ,
1447 X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE ,
1448 X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN ,
1449 X_PROFILE_CLASS_NAME => X_PROFILE_CLASS_NAME ,
1450 X_PROFILE_CLASS_DESCRIPTION => X_PROFILE_CLASS_DESCRIPTION ,
1451 X_STATUS => X_STATUS ,
1452 X_COLLECTOR_ID => X_COLLECTOR_ID ,
1453 X_CREDIT_CHECKING => X_CREDIT_CHECKING ,
1454 X_TOLERANCE => X_TOLERANCE ,
1455 X_INTEREST_CHARGES => X_INTEREST_CHARGES ,
1456 X_CHARGE_ON_FINANCE_CHARGE_FLG => X_CHARGE_ON_FINANCE_CHARGE_FLG ,
1457 X_INTEREST_PERIOD_DAYS => X_INTEREST_PERIOD_DAYS ,
1458 X_DISCOUNT_TERMS => X_DISCOUNT_TERMS ,
1459 X_DISCOUNT_GRACE_DAYS => X_DISCOUNT_GRACE_DAYS ,
1460 X_STATEMENTS => X_STATEMENTS ,
1461 X_STATEMENT_CYCLE_ID => X_STATEMENT_CYCLE_ID ,
1462 X_CREDIT_BALANCE_STATEMENTS => X_CREDIT_BALANCE_STATEMENTS ,
1463 X_STANDARD_TERMS => X_STANDARD_TERMS ,
1464 X_OVERRIDE_TERMS => X_OVERRIDE_TERMS ,
1465 X_PAYMENT_GRACE_DAYS => X_PAYMENT_GRACE_DAYS ,
1466 X_DUNNING_LETTERS => X_DUNNING_LETTERS ,
1467 X_DUNNING_LETTER_SET_ID => X_DUNNING_LETTER_SET_ID ,
1468 X_AUTOCASH_HIERARCHY_ID => X_AUTOCASH_HIERARCHY_ID ,
1469 X_COPY_METHOD => X_COPY_METHOD ,
1470 X_AUTO_REC_INCL_DISPUTED_FLAG => X_AUTO_REC_INCL_DISPUTED_FLAG ,
1471 X_TAX_PRINTING_OPTION => X_TAX_PRINTING_OPTION ,
1472 X_TAX_PRINTING_OPTION_MEANING => X_TAX_PRINTING_OPTION_MEANING ,
1473 X_GROUPING_RULE_ID => X_GROUPING_RULE_ID ,
1474 X_CONS_INV_FLAG => X_CONS_INV_FLAG ,
1475 X_CONS_INV_TYPE => X_CONS_INV_TYPE ,
1476 X_REQUEST_ID => X_REQUEST_ID ,
1477 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY ,
1478 X_ATTRIBUTE1 => X_ATTRIBUTE1 ,
1479 X_ATTRIBUTE2 => X_ATTRIBUTE2 ,
1480 X_ATTRIBUTE3 => X_ATTRIBUTE3 ,
1481 X_ATTRIBUTE4 => X_ATTRIBUTE4 ,
1482 X_ATTRIBUTE5 => X_ATTRIBUTE5 ,
1483 X_ATTRIBUTE6 => X_ATTRIBUTE6 ,
1484 X_ATTRIBUTE7 => X_ATTRIBUTE7 ,
1485 X_ATTRIBUTE8 => X_ATTRIBUTE8 ,
1486 X_ATTRIBUTE9 => X_ATTRIBUTE9 ,
1487 X_ATTRIBUTE10 => X_ATTRIBUTE10 ,
1488 X_ATTRIBUTE11 => X_ATTRIBUTE11 ,
1489 X_ATTRIBUTE12 => X_ATTRIBUTE12 ,
1490 X_ATTRIBUTE13 => X_ATTRIBUTE13 ,
1491 X_ATTRIBUTE14 => X_ATTRIBUTE14 ,
1492 X_ATTRIBUTE15 => X_ATTRIBUTE15 ,
1493 X_JGZZ_ATTRIBUTE_CATEGORY => X_JGZZ_ATTRIBUTE_CATEGORY ,
1494 X_JGZZ_ATTRIBUTE1 => X_JGZZ_ATTRIBUTE1 ,
1495 X_JGZZ_ATTRIBUTE2 => X_JGZZ_ATTRIBUTE2 ,
1496 X_JGZZ_ATTRIBUTE3 => X_JGZZ_ATTRIBUTE3 ,
1497 X_JGZZ_ATTRIBUTE4 => X_JGZZ_ATTRIBUTE4 ,
1498 X_JGZZ_ATTRIBUTE5 => X_JGZZ_ATTRIBUTE5 ,
1499 X_JGZZ_ATTRIBUTE6 => X_JGZZ_ATTRIBUTE6 ,
1500 X_JGZZ_ATTRIBUTE7 => X_JGZZ_ATTRIBUTE7 ,
1501 X_JGZZ_ATTRIBUTE8 => X_JGZZ_ATTRIBUTE8 ,
1502 X_JGZZ_ATTRIBUTE9 => X_JGZZ_ATTRIBUTE9 ,
1503 X_JGZZ_ATTRIBUTE10 => X_JGZZ_ATTRIBUTE10 ,
1504 X_JGZZ_ATTRIBUTE11 => X_JGZZ_ATTRIBUTE11 ,
1505 X_JGZZ_ATTRIBUTE12 => X_JGZZ_ATTRIBUTE12 ,
1506 X_JGZZ_ATTRIBUTE13 => X_JGZZ_ATTRIBUTE13 ,
1507 X_JGZZ_ATTRIBUTE14 => X_JGZZ_ATTRIBUTE14 ,
1508 X_JGZZ_ATTRIBUTE15 => X_JGZZ_ATTRIBUTE15 ,
1509 X_GLOBAL_ATTRIBUTE_CATEGORY => X_GLOBAL_ATTRIBUTE_CATEGORY ,
1510 X_GLOBAL_ATTRIBUTE1 => X_GLOBAL_ATTRIBUTE1 ,
1511 X_GLOBAL_ATTRIBUTE2 => X_GLOBAL_ATTRIBUTE2 ,
1512 X_GLOBAL_ATTRIBUTE3 => X_GLOBAL_ATTRIBUTE3 ,
1513 X_GLOBAL_ATTRIBUTE4 => X_GLOBAL_ATTRIBUTE4 ,
1514 X_GLOBAL_ATTRIBUTE5 => X_GLOBAL_ATTRIBUTE5 ,
1515 X_GLOBAL_ATTRIBUTE6 => X_GLOBAL_ATTRIBUTE6 ,
1516 X_GLOBAL_ATTRIBUTE7 => X_GLOBAL_ATTRIBUTE7 ,
1517 X_GLOBAL_ATTRIBUTE8 => X_GLOBAL_ATTRIBUTE8 ,
1518 X_GLOBAL_ATTRIBUTE9 => X_GLOBAL_ATTRIBUTE9 ,
1519 X_GLOBAL_ATTRIBUTE10 => X_GLOBAL_ATTRIBUTE10 ,
1520 X_GLOBAL_ATTRIBUTE11 => X_GLOBAL_ATTRIBUTE11 ,
1521 X_GLOBAL_ATTRIBUTE12 => X_GLOBAL_ATTRIBUTE12 ,
1522 X_GLOBAL_ATTRIBUTE13 => X_GLOBAL_ATTRIBUTE13 ,
1523 X_GLOBAL_ATTRIBUTE14 => X_GLOBAL_ATTRIBUTE14 ,
1524 X_GLOBAL_ATTRIBUTE15 => X_GLOBAL_ATTRIBUTE15 ,
1525 X_GLOBAL_ATTRIBUTE16 => X_GLOBAL_ATTRIBUTE16 ,
1526 X_GLOBAL_ATTRIBUTE17 => X_GLOBAL_ATTRIBUTE17 ,
1527 X_GLOBAL_ATTRIBUTE18 => X_GLOBAL_ATTRIBUTE18 ,
1528 X_GLOBAL_ATTRIBUTE19 => X_GLOBAL_ATTRIBUTE19 ,
1529 X_GLOBAL_ATTRIBUTE20 => X_GLOBAL_ATTRIBUTE20 ,
1530 X_LOCKBOX_MATCHING_OPTION => X_LOCKBOX_MATCHING_OPTION ,
1531 X_AUTOCASH_HIERARCHY_ID_ADR => X_AUTOCASH_HIERARCHY_ID_ADR ,
1532 X_REVIEW_CYCLE => X_REVIEW_CYCLE ,
1533 X_CREDIT_ANALYST_ID => X_CREDIT_ANALYST_ID ,
1534 X_CREDIT_CLASSIFICATION => NULL ,
1535 X_Cons_Bill_Level => X_Cons_Bill_Level ,
1536 X_LATE_CHARGE_CALCULATION_TRX => X_LATE_CHARGE_CALCULATION_TRX,
1537 X_CREDIT_ITEMS_FLAG => X_CREDIT_ITEMS_FLAG,
1538 X_DISPUTED_TRANSACTIONS_FLAG => X_DISPUTED_TRANSACTIONS_FLAG,
1539 X_LATE_CHARGE_TYPE => X_LATE_CHARGE_TYPE,
1540 X_LATE_CHARGE_TERM_ID => X_LATE_CHARGE_TERM_ID,
1541 X_INTEREST_CALCULATION_PERIOD => X_INTEREST_CALCULATION_PERIOD,
1542 X_HOLD_CHARGED_INVOICES_FLAG => X_HOLD_CHARGED_INVOICES_FLAG,
1543 X_MESSAGE_TEXT_ID => X_MESSAGE_TEXT_ID,
1544 X_MULTIPLE_INTEREST_RATES_FLAG => X_MULTIPLE_INTEREST_RATES_FLAG,
1545 X_CHARGE_BEGIN_DATE => X_CHARGE_BEGIN_DATE,
1546 X_AUTOMATCH_SET_ID => X_AUTOMATCH_SET_ID);
1547 END Update_Row;
1548
1549 PROCEDURE Update_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
1550 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER,
1551 X_Last_Updated_By NUMBER,
1552 X_Last_Update_Date DATE,
1553 X_Last_Update_Login NUMBER,
1554 X_Profile_Class_Name VARCHAR2,
1555 X_Profile_Class_Description VARCHAR2,
1556 X_Status VARCHAR2,
1557 X_Collector_Id NUMBER,
1558 X_Credit_Checking VARCHAR2,
1559 X_Tolerance NUMBER,
1560 X_Interest_Charges VARCHAR2,
1561 X_Charge_On_Finance_Charge_Flg VARCHAR2,
1562 X_Interest_Period_Days NUMBER,
1563 X_Discount_Terms VARCHAR2,
1564 X_Discount_Grace_Days NUMBER,
1565 X_Statements VARCHAR2,
1566 X_Statement_Cycle_Id NUMBER,
1567 X_Credit_Balance_Statements VARCHAR2,
1568 X_Standard_Terms NUMBER,
1569 X_Override_Terms VARCHAR2,
1570 X_Payment_Grace_Days NUMBER,
1571 X_Dunning_Letters VARCHAR2,
1572 X_Dunning_Letter_Set_Id NUMBER,
1573 X_Autocash_Hierarchy_Id NUMBER,
1574 X_Copy_Method VARCHAR2,
1575 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
1576 X_Tax_Printing_Option VARCHAR2,
1577 X_Tax_Printing_Option_Meaning VARCHAR2,
1578 X_Grouping_Rule_Id NUMBER,
1579 X_Cons_Inv_Flag VARCHAR2,
1580 X_Cons_Inv_Type VARCHAR2,
1581 X_Request_Id NUMBER,
1582 X_Attribute_Category VARCHAR2,
1583 X_Attribute1 VARCHAR2,
1584 X_Attribute2 VARCHAR2,
1585 X_Attribute3 VARCHAR2,
1586 X_Attribute4 VARCHAR2,
1587 X_Attribute5 VARCHAR2,
1588 X_Attribute6 VARCHAR2,
1589 X_Attribute7 VARCHAR2,
1590 X_Attribute8 VARCHAR2,
1591 X_Attribute9 VARCHAR2,
1592 X_Attribute10 VARCHAR2,
1593 X_Attribute11 VARCHAR2,
1594 X_Attribute12 VARCHAR2,
1595 X_Attribute13 VARCHAR2,
1596 X_Attribute14 VARCHAR2,
1597 X_Attribute15 VARCHAR2,
1598 X_Jgzz_attribute_Category VARCHAR2,
1599 X_Jgzz_attribute1 VARCHAR2,
1600 X_Jgzz_attribute2 VARCHAR2,
1601 X_Jgzz_attribute3 VARCHAR2,
1602 X_Jgzz_attribute4 VARCHAR2,
1603 X_Jgzz_attribute5 VARCHAR2,
1604 X_Jgzz_attribute6 VARCHAR2,
1605 X_Jgzz_attribute7 VARCHAR2,
1606 X_Jgzz_attribute8 VARCHAR2,
1607 X_Jgzz_attribute9 VARCHAR2,
1608 X_Jgzz_attribute10 VARCHAR2,
1609 X_Jgzz_attribute11 VARCHAR2,
1610 X_Jgzz_attribute12 VARCHAR2,
1611 X_Jgzz_attribute13 VARCHAR2,
1612 X_Jgzz_attribute14 VARCHAR2,
1613 X_Jgzz_attribute15 VARCHAR2,
1614 X_global_attribute_category VARCHAR2,
1615 X_global_attribute1 VARCHAR2,
1616 X_global_attribute2 VARCHAR2,
1617 X_global_attribute3 VARCHAR2,
1618 X_global_attribute4 VARCHAR2,
1619 X_global_attribute5 VARCHAR2,
1620 X_global_attribute6 VARCHAR2,
1621 X_global_attribute7 VARCHAR2,
1622 X_global_attribute8 VARCHAR2,
1623 X_global_attribute9 VARCHAR2,
1624 X_global_attribute10 VARCHAR2,
1625 X_global_attribute11 VARCHAR2,
1626 X_global_attribute12 VARCHAR2,
1627 X_global_attribute13 VARCHAR2,
1628 X_global_attribute14 VARCHAR2,
1629 X_global_attribute15 VARCHAR2,
1630 X_global_attribute16 VARCHAR2,
1631 X_global_attribute17 VARCHAR2,
1632 X_global_attribute18 VARCHAR2,
1633 X_global_attribute19 VARCHAR2,
1634 X_global_attribute20 VARCHAR2,
1635 X_lockbox_matching_option VARCHAR2,
1636 X_autocash_hierarchy_id_adr NUMBER ,
1637 X_review_cycle VARCHAR2 DEFAULT NULL,
1638 X_credit_analyst_id NUMBER DEFAULT NULL,
1639 X_credit_classification VARCHAR2, /*Bug 3619062*/
1640 X_Cons_Bill_Level VARCHAR2 DEFAULT NULL,
1641 X_LATE_CHARGE_CALCULATION_TRX VARCHAR2 DEFAULT NULL,
1642 X_CREDIT_ITEMS_FLAG VARCHAR2 DEFAULT NULL,
1643 X_DISPUTED_TRANSACTIONS_FLAG VARCHAR2 DEFAULT NULL,
1644 X_LATE_CHARGE_TYPE VARCHAR2 DEFAULT NULL,
1645 X_LATE_CHARGE_TERM_ID NUMBER DEFAULT NULL,
1646 X_INTEREST_CALCULATION_PERIOD VARCHAR2 DEFAULT NULL,
1647 X_HOLD_CHARGED_INVOICES_FLAG VARCHAR2 DEFAULT NULL,
1648 X_MESSAGE_TEXT_ID NUMBER DEFAULT NULL,
1649 X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 DEFAULT NULL,
1650 X_CHARGE_BEGIN_DATE DATE DEFAULT NULL,
1651 X_AUTOMATCH_SET_ID NUMBER DEFAULT NULL)
1652 IS
1653 BEGIN
1654 -- Calling check_unique Procedure To Varify The Uniqueness Of The Customer Profile
1655 -- Class Id
1656 check_unique ( c_profile_class_name => x_customer_profile_class_id,
1657 c_rowid => x_row_id );
1658
1659 UPDATE HZ_CUST_PROFILE_CLASSES
1660 SET
1661 profile_class_id = X_Customer_Profile_Class_Id,
1662 last_updated_by = X_Last_Updated_By,
1663 last_update_date = X_Last_Update_Date,
1664 last_update_login = X_Last_Update_Login,
1665 name = X_Profile_Class_Name,
1666 description = X_Profile_Class_Description,
1667 status = X_Status,
1668 collector_id = X_Collector_Id,
1669 credit_checking = X_Credit_Checking,
1670 tolerance = X_Tolerance,
1671 interest_charges = X_Interest_Charges,
1672 charge_on_finance_charge_flag = X_Charge_On_Finance_Charge_Flg,
1673 interest_period_days = X_Interest_Period_Days,
1674 discount_terms = X_Discount_Terms,
1675 discount_grace_days = X_Discount_Grace_Days,
1676 statements = X_Statements,
1677 statement_cycle_id = X_Statement_Cycle_Id,
1678 credit_balance_statements = X_Credit_Balance_Statements,
1679 standard_terms = X_Standard_Terms,
1680 override_terms = X_Override_Terms,
1681 payment_grace_days = X_Payment_Grace_Days,
1682 dunning_letters = X_Dunning_Letters,
1683 dunning_letter_set_id = X_Dunning_Letter_Set_Id,
1684 autocash_hierarchy_id = X_Autocash_Hierarchy_Id,
1685 copy_method = X_Copy_Method,
1686 auto_rec_incl_disputed_flag = X_Auto_Rec_Incl_Disputed_Flag,
1687 tax_printing_option = X_Tax_Printing_Option,
1688 grouping_rule_id = X_Grouping_Rule_Id,
1689 cons_inv_flag = X_Cons_Inv_Flag,
1690 cons_inv_type = X_Cons_Inv_Type,
1691 request_id = X_Request_Id,
1692 attribute_category = X_Attribute_Category,
1693 attribute1 = X_Attribute1,
1694 attribute2 = X_Attribute2,
1695 attribute3 = X_Attribute3,
1696 attribute4 = X_Attribute4,
1697 attribute5 = X_Attribute5,
1698 attribute6 = X_Attribute6,
1699 attribute7 = X_Attribute7,
1700 attribute8 = X_Attribute8,
1701 attribute9 = X_Attribute9,
1702 attribute10 = X_Attribute10,
1703 attribute11 = X_Attribute11,
1704 attribute12 = X_Attribute12,
1705 attribute13 = X_Attribute13,
1706 attribute14 = X_Attribute14,
1707 attribute15 = X_Attribute15,
1708 jgzz_attribute_category = X_Jgzz_attribute_Category,
1709 jgzz_attribute1 = X_Jgzz_attribute1,
1710 jgzz_attribute2 = X_Jgzz_attribute2,
1711 jgzz_attribute3 = X_Jgzz_attribute3,
1712 jgzz_attribute4 = X_Jgzz_attribute4,
1713 jgzz_attribute5 = X_Jgzz_attribute5,
1714 jgzz_attribute6 = X_Jgzz_attribute6,
1715 jgzz_attribute7 = X_Jgzz_attribute7,
1716 jgzz_attribute8 = X_Jgzz_attribute8,
1717 jgzz_attribute9 = X_Jgzz_attribute9,
1718 jgzz_attribute10 = X_Jgzz_attribute10,
1719 jgzz_attribute11 = X_Jgzz_attribute11,
1720 jgzz_attribute12 = X_Jgzz_attribute12,
1721 jgzz_attribute13 = X_Jgzz_attribute13,
1722 jgzz_attribute14 = X_Jgzz_attribute14,
1723 jgzz_attribute15 = X_Jgzz_attribute15,
1724 global_attribute_category = X_global_attribute_category,
1725 global_attribute1 = X_global_attribute1,
1726 global_attribute2 = X_global_attribute2,
1727 global_attribute3 = X_global_attribute3,
1728 global_attribute4 = X_global_attribute4,
1729 global_attribute5 = X_global_attribute5,
1730 global_attribute6 = X_global_attribute6,
1731 global_attribute7 = X_global_attribute7,
1732 global_attribute8 = X_global_attribute8,
1733 global_attribute9 = X_global_attribute9,
1734 global_attribute10 = X_global_attribute10,
1735 global_attribute11 = X_global_attribute11,
1736 global_attribute12 = X_global_attribute12,
1737 global_attribute13 = X_global_attribute13,
1738 global_attribute14 = X_global_attribute14,
1739 global_attribute15 = X_global_attribute15,
1740 global_attribute16 = X_global_attribute16,
1741 global_attribute17 = X_global_attribute17,
1742 global_attribute18 = X_global_attribute18,
1743 global_attribute19 = X_global_attribute19,
1744 global_attribute20 = X_global_attribute20,
1745 lockbox_matching_option = X_lockbox_matching_option,
1746 autocash_hierarchy_id_for_adr = X_autocash_hierarchy_id_adr,
1747 review_cycle = X_review_cycle,
1748 credit_analyst_id = X_credit_analyst_id,
1749 credit_classification = X_credit_classification, /*Bug 3619062*/
1750 Cons_Bill_Level = X_Cons_Bill_Level,
1751 LATE_CHARGE_CALCULATION_TRX = X_LATE_CHARGE_CALCULATION_TRX,
1752 CREDIT_ITEMS_FLAG = X_CREDIT_ITEMS_FLAG,
1753 DISPUTED_TRANSACTIONS_FLAG = X_DISPUTED_TRANSACTIONS_FLAG,
1754 LATE_CHARGE_TYPE = X_LATE_CHARGE_TYPE,
1755 LATE_CHARGE_TERM_ID = X_LATE_CHARGE_TERM_ID,
1756 INTEREST_CALCULATION_PERIOD = X_INTEREST_CALCULATION_PERIOD,
1757 HOLD_CHARGED_INVOICES_FLAG = X_HOLD_CHARGED_INVOICES_FLAG,
1758 MESSAGE_TEXT_ID = X_MESSAGE_TEXT_ID,
1759 MULTIPLE_INTEREST_RATES_FLAG = X_MULTIPLE_INTEREST_RATES_FLAG,
1760 CHARGE_BEGIN_DATE = X_CHARGE_BEGIN_DATE,
1761 AUTOMATCH_SET_ID = X_AUTOMATCH_SET_ID
1762 WHERE rowid = X_Row_Id;
1763
1764 IF (SQL%NOTFOUND) THEN
1765 Raise NO_DATA_FOUND;
1766 END IF;
1767 END Update_Row;
1768
1769
1770
1771
1772
1773 PROCEDURE Delete_Row(X_Row_Id VARCHAR2) IS
1774 BEGIN
1775 DELETE FROM HZ_CUST_PROFILE_CLASSES
1776 WHERE rowid = X_Row_Id;
1777
1778 if (SQL%NOTFOUND) then
1779 Raise NO_DATA_FOUND;
1780 end if;
1781 END Delete_Row;
1782
1783
1784
1785
1786
1787 PROCEDURE compute_negative_id (X_Customer_Profile_Class_Id Number,
1788 X_Negative_Id IN OUT NOCOPY Number,
1789 Notify_Flag IN OUT NOCOPY varchar2)
1790 IS
1791 number_in_update number;
1792 min_negative_id number;
1793 BEGIN
1794 --IDENTIFY EXISTING ROW WITH NEGATIVE ID IN HZ_CUST_PROFILE_CLASSES
1795 --RETRIEVE THE MIN id WHERE id BETWEEN -100*ID-99 AND -100*ID-2
1796 SELECT count(*), min(profile_class_id) - 1
1797 INTO number_in_update, x_negative_id
1798 FROM hz_cust_profile_classes
1799 WHERE profile_class_id BETWEEN
1800 (X_Customer_Profile_Class_Id) * (-100) -99
1801 AND (X_Customer_Profile_Class_Id) * (-100) -2;
1802
1803 --IF ANY RECORDS EXIST, THEN SET GIVE WARNING MESSAGE TO "W"-
1804 --"Warning - Customer Profiles Currently Being Updated"
1805 IF number_in_update > 0 THEN
1806 fnd_message.set_name ('AR', 'AR_CUST_PROFILE_CURR_UPD');
1807 Notify_Flag := 'W';
1808 END IF;
1809 END compute_negative_id;
1810
1811
1812
1813
1814
1815 PROCEDURE insert_negative_row (X_Customer_Profile_Class_Id Number,
1816 X_Negative_Id Number,
1817 X_Update_Options Varchar2) is
1818 cursor C is
1819 select *
1820 from hz_cust_profile_classes
1821 where profile_class_id = x_customer_profile_class_id
1822 FOR UPDATE of Profile_Class_Id NOWAIT;
1823 Classinfo C%ROWTYPE;
1824 dummy_rowid varchar2(20);
1825 dummy_class number(15) := X_Negative_Id;
1826 BEGIN
1827 OPEN C;
1828 FETCH C INTO Classinfo;
1829 if (C%NOTFOUND) then
1830 CLOSE C;
1831 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1832 APP_EXCEPTION.Raise_Exception;
1833 end if;
1834 CLOSE C;
1835
1836 Insert_Row (dummy_rowid,
1837 dummy_class,
1838 Classinfo.Last_Updated_By,
1839 Classinfo.Last_Update_Date,
1840 Classinfo.Last_Update_Login,
1841 Classinfo.Created_By,
1842 Classinfo.Creation_Date,
1843 Classinfo.Name,
1844 Classinfo.Description,
1845 Classinfo.Status,
1846 Classinfo.Collector_Id,
1847 Classinfo.Credit_Checking,
1848 Classinfo.Tolerance,
1849 Classinfo.Interest_Charges,
1850 Classinfo.Charge_On_Finance_Charge_Flag,
1851 Classinfo.Interest_Period_Days,
1852 Classinfo.Discount_Terms,
1853 Classinfo.Discount_Grace_Days,
1854 Classinfo.Statements,
1855 Classinfo.Statement_Cycle_Id,
1856 Classinfo.Credit_Balance_Statements,
1857 Classinfo.Standard_Terms,
1858 Classinfo.Override_Terms,
1859 Classinfo.Payment_Grace_Days,
1860 Classinfo.Dunning_Letters,
1861 Classinfo.Dunning_Letter_Set_Id,
1862 Classinfo.Autocash_Hierarchy_Id,
1863 x_update_options,
1864 Classinfo.Auto_Rec_Incl_Disputed_Flag,
1865 Classinfo.Tax_Printing_Option,
1866 '',
1867 Classinfo.Grouping_Rule_Id,
1868 Classinfo.Cons_Inv_Flag,
1869 Classinfo.Cons_Inv_Type,
1870 Classinfo.Request_Id,
1871 Classinfo.Attribute_Category,
1872 Classinfo.Attribute1,
1873 Classinfo.Attribute2,
1874 Classinfo.Attribute3,
1875 Classinfo.Attribute4,
1876 Classinfo.Attribute5,
1877 Classinfo.Attribute6,
1878 Classinfo.Attribute7,
1879 Classinfo.Attribute8,
1880 Classinfo.Attribute9,
1881 Classinfo.Attribute10,
1882 Classinfo.Attribute11,
1883 Classinfo.Attribute12,
1884 Classinfo.Attribute13,
1885 Classinfo.Attribute14,
1886 Classinfo.Attribute15,
1887 Classinfo.Jgzz_attribute_Category,
1888 Classinfo.Jgzz_attribute1,
1889 Classinfo.Jgzz_attribute2,
1890 Classinfo.Jgzz_attribute3,
1891 Classinfo.Jgzz_attribute4,
1892 Classinfo.Jgzz_attribute5,
1893 Classinfo.Jgzz_attribute6,
1894 Classinfo.Jgzz_attribute7,
1895 Classinfo.Jgzz_attribute8,
1896 Classinfo.Jgzz_attribute9,
1897 Classinfo.Jgzz_attribute10,
1898 Classinfo.Jgzz_attribute11,
1899 Classinfo.Jgzz_attribute12,
1900 Classinfo.Jgzz_attribute13,
1901 Classinfo.Jgzz_attribute14,
1902 Classinfo.Jgzz_attribute15,
1903 Classinfo.global_attribute_category,
1904 Classinfo.global_attribute1,
1905 Classinfo.global_attribute2,
1906 Classinfo.global_attribute3,
1907 Classinfo.global_attribute4,
1908 Classinfo.global_attribute5,
1909 Classinfo.global_attribute6,
1910 Classinfo.global_attribute7,
1911 Classinfo.global_attribute8,
1912 Classinfo.global_attribute9,
1913 Classinfo.global_attribute10,
1914 Classinfo.global_attribute11,
1915 Classinfo.global_attribute12,
1916 Classinfo.global_attribute13,
1917 Classinfo.global_attribute14,
1918 Classinfo.global_attribute15,
1919 Classinfo.global_attribute16,
1920 Classinfo.global_attribute17,
1921 Classinfo.global_attribute18,
1922 Classinfo.global_attribute19,
1923 Classinfo.global_attribute20,
1924 Classinfo.lockbox_matching_option,
1925 Classinfo.autocash_hierarchy_id_for_adr,
1926 Classinfo.review_cycle,
1927 Classinfo.credit_analyst_id,
1928 Classinfo.credit_classification, -- Bug 3619062
1929 Classinfo.cons_bill_level,
1930 Classinfo.LATE_CHARGE_CALCULATION_TRX,
1931 Classinfo.CREDIT_ITEMS_FLAG ,
1932 Classinfo.DISPUTED_TRANSACTIONS_FLAG ,
1933 Classinfo.LATE_CHARGE_TYPE ,
1934 Classinfo.LATE_CHARGE_TERM_ID ,
1935 Classinfo.INTEREST_CALCULATION_PERIOD,
1936 Classinfo.HOLD_CHARGED_INVOICES_FLAG ,
1937 Classinfo.MESSAGE_TEXT_ID ,
1938 Classinfo.MULTIPLE_INTEREST_RATES_FLAG,
1939 Classinfo.CHARGE_BEGIN_DATE);
1940
1941 END insert_negative_row;
1942 --
1943
1944 END ARH_CPC_PKG;