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