[Home] [Help]
PACKAGE BODY: APPS.ARP_PROCESS_HEADER_UPDTE_COVER
Source
1 PACKAGE BODY ARP_PROCESS_HEADER_UPDTE_COVER AS
2 /* $Header: ARTEHECB.pls 120.10.12010000.3 2008/11/19 12:18:20 ankuagar ship $ */
3
4
5
6 /*===========================================================================+
7 | PROCEDURE |
8 | update_header_cover |
9 | |
10 | DESCRIPTION |
11 | Updates a record in ra_customer_trx. |
12 | |
13 | SCOPE - PUBLIC |
14 | |
15 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
16 | arp_util.debug |
17 | arp_process_header.update_header |
18 | |
19 | ARGUMENTS : IN: |
20 | p_form_name |
21 | p_form_version |
22 | p_trx_amount |
23 | p_trx_class |
24 | p_gl_date |
25 | p_term_in_use_flag |
26 | p_open_rec_flag |
27 | p_recalc_tax_flag |
28 | p_rerun_autoacc_flag |
29 | p_receivable_ccid |
30 | p_customer_trx_id |
31 | p_trx_number |
32 | p_posting_control_id |
33 | p_ra_post_loop_number |
34 | p_complete_flag |
35 | p_initial_customer_trx_id |
36 | p_initial_customer_trx_line_id |
37 | p_previous_customer_trx_id |
38 | p_related_customer_trx_id |
39 | p_recurred_from_trx_number |
40 | p_cust_trx_type_id |
41 | p_batch_id |
42 | p_batch_source_id |
43 | p_agreement_id |
44 | p_trx_date |
45 | p_bill_to_customer_id |
46 | p_bill_to_contact_id |
47 | p_bill_to_site_use_id |
48 | p_ship_to_customer_id |
49 | p_ship_to_contact_id |
50 | p_ship_to_site_use_id |
51 | p_sold_to_customer_id |
52 | p_sold_to_site_use_id |
53 | p_sold_to_contact_id |
54 | p_customer_reference |
55 | p_customer_reference_date |
56 | p_cr_method_for_installments |
57 | p_credit_method_for_rules |
58 | p_start_date_commitment |
59 | p_end_date_commitment |
60 | p_exchange_date |
61 | p_exchange_rate |
62 | p_exchange_rate_type |
63 | p_customer_bank_account_id |
64 | p_finance_charges |
65 | p_fob_point |
66 | p_comments |
67 | p_internal_notes |
68 | p_invoice_currency_code |
69 | p_invoicing_rule_id |
70 | p_last_printed_sequence_num |
71 | p_orig_system_batch_name |
72 | p_primary_salesrep_id |
73 | p_printing_count |
74 | p_printing_last_printed |
75 | p_printing_option |
76 | p_printing_original_date |
77 | p_printing_pending |
78 | p_purchase_order |
79 | p_purchase_order_date |
80 | p_purchase_order_revision |
81 | p_receipt_method_id |
82 | p_remit_to_address_id |
83 | p_shipment_id |
84 | p_ship_date_actual |
85 | p_ship_via |
86 | p_term_due_date |
87 | p_term_id |
88 | p_territory_id |
89 | p_waybill_number |
90 | p_status_trx |
91 | p_reason_code |
92 | p_doc_sequence_id |
93 | p_doc_sequence_value |
94 | p_paying_customer_id |
95 | p_paying_site_use_id |
96 | p_related_batch_source_id |
97 | p_default_tax_exempt_flag |
98 | p_created_from |
99 | p_ps_dispute_amount |
100 | p_ps_dispute_date |
101 | p_deflt_ussgl_trx_code_context |
102 | p_deflt_ussgl_transaction_code |
103 | p_old_trx_number |
104 | p_interface_header_context |
105 | p_interface_header_attribute1 |
106 | p_interface_header_attribute2 |
107 | p_interface_header_attribute3 |
108 | p_interface_header_attribute4 |
109 | p_interface_header_attribute5 |
110 | p_interface_header_attribute6 |
111 | p_interface_header_attribute7 |
112 | p_interface_header_attribute8 |
113 | p_interface_header_attribute9 |
114 | p_interface_header_attribute10 |
115 | p_interface_header_attribute11 |
116 | p_interface_header_attribute12 |
117 | p_interface_header_attribute13 |
118 | p_interface_header_attribute14 |
119 | p_interface_header_attribute15 |
120 | p_attribute_category |
121 | p_attribute1 |
122 | p_attribute2 |
123 | p_attribute3 |
124 | p_attribute4 |
125 | p_attribute5 |
126 | p_attribute6 |
127 | p_attribute7 |
128 | p_attribute8 |
129 | p_attribute9 |
130 | p_attribute10 |
131 | p_attribute11 |
132 | p_attribute12 |
133 | p_attribute13 |
134 | p_attribute14 |
135 | p_attribute15 |
136 | p_commit_customer_trx_line_id |
137 | p_commit_inventory_item_id |
138 | p_commit_memo_line_id |
139 | p_commit_description |
140 | p_commit_extended_amount |
141 | p_commit_interface_line_attr1 |
142 | p_commit_interface_line_attr2 |
143 | p_commit_interface_line_attr3 |
144 | p_commit_interface_line_attr4 |
145 | p_commit_interface_line_attr5 |
146 | p_commit_interface_line_attr6 |
147 | p_commit_interface_line_attr7 |
148 | p_commit_interface_line_attr8 |
149 | p_commit_interface_line_attr9 |
150 | p_commit_interface_line_attr10 |
151 | p_commit_interface_line_attr11 |
152 | p_commit_interface_line_attr12 |
153 | p_commit_interface_line_attr13 |
154 | p_commit_interface_line_attr14 |
155 | p_commit_interface_line_attr15 |
156 | p_commit_interface_line_contxt |
157 | p_commit_attribute_category |
158 | p_commit_attribute1 |
159 | p_commit_attribute2 |
160 | p_commit_attribute3 |
161 | p_commit_attribute4 |
162 | p_commit_attribute5 |
163 | p_commit_attribute6 |
164 | p_commit_attribute7 |
165 | p_commit_attribute8 |
166 | p_commit_attribute9 |
167 | p_commit_attribute10 |
168 | p_commit_attribute11 |
169 | p_commit_attribute12 |
170 | p_commit_attribute13 |
171 | p_commit_attribute14 |
172 | p_commit_attribute15 |
173 | OUT: |
174 | p_trx_number |
175 | p_customer_trx_id |
176 | IN/ OUT: |
177 | |
178 | RETURNS : NONE |
179 | |
180 | NOTES |
181 | |
182 | MODIFICATION HISTORY |
183 | 27-NOV-95 Martin Johnson Created |
184 | 18-May-05 Debbie Sue Jancis Added Legal Entity Id for LE project |
185 | 28-MAR-2006 Herve Yu BUG#4897183 call update XLA events |
186 | |
187 +===========================================================================*/
188
189 PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
190
191 PROCEDURE update_header_cover(
192 p_form_name IN varchar2,
193 p_form_version IN number,
194 p_trx_amount IN number,
195 p_trx_class IN VARCHAR2,
196 p_gl_date IN DATE,
197 p_term_in_use_flag IN varchar2,
198 p_open_rec_flag IN VARCHAR2,
199 p_recalc_tax_flag IN varchar2,
200 p_rerun_autoacc_flag IN varchar2,
201 p_receivable_ccid IN NUMBER,
202 p_customer_trx_id IN NUMBER,
203 p_trx_number IN VARCHAR2,
204 p_posting_control_id IN NUMBER,
205 p_ra_post_loop_number IN NUMBER,
206 p_complete_flag IN VARCHAR2,
207 p_initial_customer_trx_id IN NUMBER,
208 p_initial_customer_trx_line_id IN NUMBER,
209 p_previous_customer_trx_id IN NUMBER,
210 p_related_customer_trx_id IN NUMBER,
211 p_recurred_from_trx_number IN VARCHAR2,
212 p_cust_trx_type_id IN NUMBER,
213 p_batch_id IN NUMBER,
214 p_batch_source_id IN NUMBER,
215 p_agreement_id IN NUMBER,
216 p_trx_date IN DATE,
217 p_bill_to_customer_id IN NUMBER,
218 p_bill_to_contact_id IN NUMBER,
219 p_bill_to_site_use_id IN NUMBER,
220 p_ship_to_customer_id IN NUMBER,
221 p_ship_to_contact_id IN NUMBER,
222 p_ship_to_site_use_id IN NUMBER,
223 p_sold_to_customer_id IN NUMBER,
224 p_sold_to_site_use_id IN NUMBER,
225 p_sold_to_contact_id IN NUMBER,
226 p_customer_reference IN VARCHAR2,
227 p_customer_reference_date IN DATE,
228 p_cr_method_for_installments IN VARCHAR2,
229 p_credit_method_for_rules IN VARCHAR2,
230 p_start_date_commitment IN DATE,
231 p_end_date_commitment IN DATE,
232 p_exchange_date IN DATE,
233 p_exchange_rate IN NUMBER,
234 p_exchange_rate_type IN VARCHAR2,
235 p_customer_bank_account_id IN NUMBER,
236 p_finance_charges IN VARCHAR2,
237 p_fob_point IN VARCHAR2,
238 p_comments IN VARCHAR2,
239 p_internal_notes IN VARCHAR2,
240 p_invoice_currency_code IN VARCHAR2,
241 p_invoicing_rule_id IN NUMBER,
242 p_last_printed_sequence_num IN NUMBER,
243 p_orig_system_batch_name IN VARCHAR2,
244 p_primary_salesrep_id IN NUMBER,
245 p_printing_count IN NUMBER,
246 p_printing_last_printed IN DATE,
247 p_printing_option IN VARCHAR2,
248 p_printing_original_date IN DATE,
249 p_printing_pending IN VARCHAR2,
250 p_purchase_order IN VARCHAR2,
251 p_purchase_order_date IN DATE,
252 p_purchase_order_revision IN VARCHAR2,
253 p_receipt_method_id IN NUMBER,
254 p_remit_to_address_id IN NUMBER,
255 p_shipment_id IN NUMBER,
256 p_ship_date_actual IN DATE,
257 p_ship_via IN VARCHAR2,
258 p_term_due_date IN DATE,
259 p_term_id IN NUMBER,
260 p_territory_id IN NUMBER,
261 p_waybill_number IN VARCHAR2,
262 p_status_trx IN VARCHAR2,
263 p_reason_code IN VARCHAR2,
264 p_doc_sequence_id IN NUMBER,
265 p_doc_sequence_value IN NUMBER,
266 p_paying_customer_id IN NUMBER,
267 p_paying_site_use_id IN NUMBER,
268 p_related_batch_source_id IN NUMBER,
269 p_default_tax_exempt_flag IN VARCHAR2,
270 p_created_from IN VARCHAR2,
271 p_ps_dispute_amount IN number,
272 p_ps_dispute_date IN date,
273 p_deflt_ussgl_trx_code_context IN VARCHAR2,
274 p_deflt_ussgl_transaction_code IN VARCHAR2,
275 p_old_trx_number IN VARCHAR2,
276 p_interface_header_context IN VARCHAR2,
277 p_interface_header_attribute1 IN VARCHAR2,
278 p_interface_header_attribute2 IN VARCHAR2,
279 p_interface_header_attribute3 IN VARCHAR2,
280 p_interface_header_attribute4 IN VARCHAR2,
281 p_interface_header_attribute5 IN VARCHAR2,
282 p_interface_header_attribute6 IN VARCHAR2,
283 p_interface_header_attribute7 IN VARCHAR2,
284 p_interface_header_attribute8 IN VARCHAR2,
285 p_interface_header_attribute9 IN VARCHAR2,
286 p_interface_header_attribute10 IN VARCHAR2,
287 p_interface_header_attribute11 IN VARCHAR2,
288 p_interface_header_attribute12 IN VARCHAR2,
289 p_interface_header_attribute13 IN VARCHAR2,
290 p_interface_header_attribute14 IN VARCHAR2,
291 p_interface_header_attribute15 IN VARCHAR2,
292 p_attribute_category IN VARCHAR2,
293 p_attribute1 IN VARCHAR2,
294 p_attribute2 IN VARCHAR2,
295 p_attribute3 IN VARCHAR2,
296 p_attribute4 IN VARCHAR2,
297 p_attribute5 IN VARCHAR2,
298 p_attribute6 IN VARCHAR2,
299 p_attribute7 IN VARCHAR2,
300 p_attribute8 IN VARCHAR2,
301 p_attribute9 IN VARCHAR2,
302 p_attribute10 IN VARCHAR2,
303 p_attribute11 IN VARCHAR2,
304 p_attribute12 IN VARCHAR2,
305 p_attribute13 IN VARCHAR2,
306 p_attribute14 IN VARCHAR2,
307 p_attribute15 IN VARCHAR2,
308 p_commit_customer_trx_line_id IN NUMBER,
309 p_commit_inventory_item_id IN NUMBER,
310 p_commit_memo_line_id IN NUMBER,
311 p_commit_description IN VARCHAR2,
312 p_commit_extended_amount IN NUMBER,
313 p_commit_interface_line_attr1 IN VARCHAR2,
314 p_commit_interface_line_attr2 IN VARCHAR2,
315 p_commit_interface_line_attr3 IN VARCHAR2,
316 p_commit_interface_line_attr4 IN VARCHAR2,
317 p_commit_interface_line_attr5 IN VARCHAR2,
318 p_commit_interface_line_attr6 IN VARCHAR2,
319 p_commit_interface_line_attr7 IN VARCHAR2,
320 p_commit_interface_line_attr8 IN VARCHAR2,
321 p_commit_interface_line_attr9 IN VARCHAR2,
322 p_commit_interface_line_attr10 IN VARCHAR2,
323 p_commit_interface_line_attr11 IN VARCHAR2,
324 p_commit_interface_line_attr12 IN VARCHAR2,
325 p_commit_interface_line_attr13 IN VARCHAR2,
326 p_commit_interface_line_attr14 IN VARCHAR2,
327 p_commit_interface_line_attr15 IN VARCHAR2,
328 p_commit_interface_line_contxt IN VARCHAR2,
329 p_commit_attribute_category IN VARCHAR2,
330 p_commit_attribute1 IN VARCHAR2,
331 p_commit_attribute2 IN VARCHAR2,
332 p_commit_attribute3 IN VARCHAR2,
333 p_commit_attribute4 IN VARCHAR2,
334 p_commit_attribute5 IN VARCHAR2,
335 p_commit_attribute6 IN VARCHAR2,
336 p_commit_attribute7 IN VARCHAR2,
337 p_commit_attribute8 IN VARCHAR2,
338 p_commit_attribute9 IN VARCHAR2,
339 p_commit_attribute10 IN VARCHAR2,
340 p_commit_attribute11 IN VARCHAR2,
341 p_commit_attribute12 IN VARCHAR2,
342 p_commit_attribute13 IN VARCHAR2,
343 p_commit_attribute14 IN VARCHAR2,
344 p_commit_attribute15 IN VARCHAR2,
345 p_ctl_default_ussgl_trx_code IN varchar2,
346 p_status OUT NOCOPY varchar2,
347 p_legal_entity_id IN NUMBER DEFAULT NULL,
348 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL,
349 p_billing_date IN DATE DEFAULT NULL,
350 p_ct_reference IN VARCHAR2 DEFAULT NULL) IS /* Bug fix 5330712 */
351
352 --{BUG#4897183
353 CURSOR cev IS
354 SELECT t.trx_date,
355 d.gl_date,
356 t.org_id,
357 d.set_of_books_id,
358 t.term_id,
359 t.initial_customer_trx_id /*bug6957444*/
360 FROM ra_customer_trx t,
361 ra_cust_trx_line_gl_dist d
362 WHERE t.customer_trx_id = p_customer_trx_id
363 AND t.customer_trx_id = d.customer_trx_id
364 AND d.account_class = 'REC' ;
365
366 CURSOR c_line (p_trx_id NUMBER) IS
367 SELECT customer_trx_line_id
368 FROM ra_customer_trx_lines_all
369 WHERE customer_trx_id = p_trx_id
370 AND line_type = 'LINE';
371
372 l_trx_date DATE;
373 l_gl_date DATE;
374 l_org_id NUMBER;
375 l_sob_id NUMBER;
376 l_term_id NUMBER;
377 l_initial_cust_trx_id number;--bug6957444
378 lf BOOLEAN;
379 x_event_id NUMBER;
380 --}
381
382 l_commit_rec arp_process_commitment.commitment_rec_type;
383 l_trx_rec ra_customer_trx%rowtype;
384 l_recalc_tax_flag boolean;
385 l_rerun_autoacc_flag boolean;
386 l_return_status NUMBER;
387
388 BEGIN
389
390 IF PG_DEBUG in ('Y', 'C') THEN
391 arp_util.debug('arp_process_header_updte_cover.update_header_cover()+');
392 END IF;
393
394 arp_ct_pkg.set_to_dummy(l_trx_rec);
395 arp_process_commitment.set_to_dummy(l_commit_rec);
396
397 l_trx_rec.customer_trx_id := p_customer_trx_id;
398 l_trx_rec.trx_number := p_trx_number;
399 l_trx_rec.complete_flag := p_complete_flag;
400 l_trx_rec.initial_customer_trx_id := p_initial_customer_trx_id;
401 l_trx_rec.previous_customer_trx_id := p_previous_customer_trx_id;
402 l_trx_rec.related_customer_trx_id := p_related_customer_trx_id;
403 l_trx_rec.recurred_from_trx_number := p_recurred_from_trx_number;
404 l_trx_rec.cust_trx_type_id := p_cust_trx_type_id;
405 l_trx_rec.batch_id := p_batch_id;
406 l_trx_rec.batch_source_id := p_batch_source_id;
407 l_trx_rec.agreement_id := p_agreement_id;
408 l_trx_rec.trx_date := p_trx_date;
409 l_trx_rec.bill_to_customer_id := p_bill_to_customer_id;
410 l_trx_rec.bill_to_contact_id := p_bill_to_contact_id;
411 l_trx_rec.bill_to_site_use_id := p_bill_to_site_use_id;
412 l_trx_rec.ship_to_customer_id := p_ship_to_customer_id;
413 l_trx_rec.ship_to_contact_id := p_ship_to_contact_id;
414 l_trx_rec.ship_to_site_use_id := p_ship_to_site_use_id;
415 l_trx_rec.sold_to_customer_id := p_sold_to_customer_id;
416 l_trx_rec.sold_to_site_use_id := p_sold_to_site_use_id;
417 l_trx_rec.sold_to_contact_id := p_sold_to_contact_id;
418 l_trx_rec.customer_reference := p_customer_reference;
419 l_trx_rec.customer_reference_date := p_customer_reference_date;
420 l_trx_rec.credit_method_for_installments := p_cr_method_for_installments;
421 l_trx_rec.credit_method_for_rules := p_credit_method_for_rules;
422 l_trx_rec.start_date_commitment := p_start_date_commitment;
423 l_trx_rec.end_date_commitment := p_end_date_commitment;
424 l_trx_rec.exchange_date := p_exchange_date;
425 l_trx_rec.exchange_rate := p_exchange_rate;
426 l_trx_rec.exchange_rate_type := p_exchange_rate_type;
427 l_trx_rec.customer_bank_account_id := p_customer_bank_account_id;
428 l_trx_rec.finance_charges := p_finance_charges;
429 l_trx_rec.fob_point := p_fob_point;
430 l_trx_rec.comments := p_comments;
431 l_trx_rec.internal_notes := p_internal_notes;
432 l_trx_rec.invoice_currency_code := p_invoice_currency_code;
433 l_trx_rec.invoicing_rule_id := p_invoicing_rule_id;
434 l_trx_rec.last_printed_sequence_num := p_last_printed_sequence_num;
435 l_trx_rec.orig_system_batch_name := p_orig_system_batch_name;
436 l_trx_rec.primary_salesrep_id := p_primary_salesrep_id;
437 l_trx_rec.printing_count := p_printing_count;
438 l_trx_rec.printing_last_printed := p_printing_last_printed;
439 l_trx_rec.printing_option := p_printing_option;
440 l_trx_rec.printing_original_date := p_printing_original_date;
441 l_trx_rec.printing_pending := p_printing_pending;
442 l_trx_rec.purchase_order := p_purchase_order;
443 l_trx_rec.purchase_order_date := p_purchase_order_date;
444 l_trx_rec.purchase_order_revision := p_purchase_order_revision;
445 l_trx_rec.receipt_method_id := p_receipt_method_id;
446 l_trx_rec.remit_to_address_id := p_remit_to_address_id;
447 l_trx_rec.shipment_id := p_shipment_id;
448 l_trx_rec.ship_date_actual := p_ship_date_actual;
449 l_trx_rec.ship_via := p_ship_via;
450 l_trx_rec.term_due_date := p_term_due_date;
451 l_trx_rec.term_id := p_term_id;
452 l_trx_rec.territory_id := p_territory_id;
453 l_trx_rec.waybill_number := p_waybill_number;
454 l_trx_rec.status_trx := p_status_trx;
455 l_trx_rec.reason_code := p_reason_code;
456 l_trx_rec.doc_sequence_id := p_doc_sequence_id;
457 l_trx_rec.doc_sequence_value := p_doc_sequence_value;
458 l_trx_rec.paying_customer_id := p_paying_customer_id;
459 l_trx_rec.paying_site_use_id := p_paying_site_use_id;
460 l_trx_rec.related_batch_source_id := p_related_batch_source_id;
461 l_trx_rec.default_tax_exempt_flag := p_default_tax_exempt_flag;
462 l_trx_rec.created_from := p_created_from;
463 l_trx_rec.default_ussgl_trx_code_context := p_deflt_ussgl_trx_code_context;
464 l_trx_rec.default_ussgl_transaction_code := p_deflt_ussgl_transaction_code;
465 l_trx_rec.old_trx_number := p_old_trx_number;
466 l_trx_rec.interface_header_context := p_interface_header_context;
467 l_trx_rec.interface_header_attribute1 := p_interface_header_attribute1;
468 l_trx_rec.interface_header_attribute2 := p_interface_header_attribute2;
469 l_trx_rec.interface_header_attribute3 := p_interface_header_attribute3;
470 l_trx_rec.interface_header_attribute4 := p_interface_header_attribute4;
471 l_trx_rec.interface_header_attribute5 := p_interface_header_attribute5;
472 l_trx_rec.interface_header_attribute6 := p_interface_header_attribute6;
473 l_trx_rec.interface_header_attribute7 := p_interface_header_attribute7;
474 l_trx_rec.interface_header_attribute8 := p_interface_header_attribute8;
475 l_trx_rec.interface_header_attribute9 := p_interface_header_attribute9;
476 l_trx_rec.interface_header_attribute10 := p_interface_header_attribute10;
477 l_trx_rec.interface_header_attribute11 := p_interface_header_attribute11;
478 l_trx_rec.interface_header_attribute12 := p_interface_header_attribute12;
479 l_trx_rec.interface_header_attribute13 := p_interface_header_attribute13;
480 l_trx_rec.interface_header_attribute14 := p_interface_header_attribute14;
481 l_trx_rec.interface_header_attribute15 := p_interface_header_attribute15;
482 l_trx_rec.attribute_category := p_attribute_category;
483 l_trx_rec.attribute1 := p_attribute1;
484 l_trx_rec.attribute2 := p_attribute2;
485 l_trx_rec.attribute3 := p_attribute3;
486 l_trx_rec.attribute4 := p_attribute4;
487 l_trx_rec.attribute5 := p_attribute5;
488 l_trx_rec.attribute6 := p_attribute6;
489 l_trx_rec.attribute7 := p_attribute7;
490 l_trx_rec.attribute8 := p_attribute8;
491 l_trx_rec.attribute9 := p_attribute9;
492 l_trx_rec.attribute10 := p_attribute10;
493 l_trx_rec.attribute11 := p_attribute11;
494 l_trx_rec.attribute12 := p_attribute12;
495 l_trx_rec.attribute13 := p_attribute13;
496 l_trx_rec.attribute14 := p_attribute14;
497 l_trx_rec.attribute15 := p_attribute15;
498
499 l_trx_rec.legal_entity_id := p_legal_entity_id;
500 /* PAYMENT_UPTAKE */
501 l_trx_rec.payment_trxn_extension_id := p_payment_trxn_extension_id;
502 l_trx_rec.billing_date := p_billing_date;
503 l_trx_rec.ct_reference := p_ct_reference; /* Bug fix 5330712 */
504
505 l_commit_rec.customer_trx_line_id := p_commit_customer_trx_line_id;
506 l_commit_rec.inventory_item_id := p_commit_inventory_item_id;
507 l_commit_rec.memo_line_id := p_commit_memo_line_id;
508 l_commit_rec.description := p_commit_description;
509 l_commit_rec.extended_amount := p_commit_extended_amount;
510 l_commit_rec.interface_line_attribute1 := p_commit_interface_line_attr1;
511 l_commit_rec.interface_line_attribute2 := p_commit_interface_line_attr2;
512 l_commit_rec.interface_line_attribute3 := p_commit_interface_line_attr3;
513 l_commit_rec.interface_line_attribute4 := p_commit_interface_line_attr4;
514 l_commit_rec.interface_line_attribute5 := p_commit_interface_line_attr5;
515 l_commit_rec.interface_line_attribute6 := p_commit_interface_line_attr6;
516 l_commit_rec.interface_line_attribute7 := p_commit_interface_line_attr7;
517 l_commit_rec.interface_line_attribute8 := p_commit_interface_line_attr8;
518 l_commit_rec.interface_line_attribute9 := p_commit_interface_line_attr9;
519 l_commit_rec.interface_line_attribute10 := p_commit_interface_line_attr10;
520 l_commit_rec.interface_line_attribute11 := p_commit_interface_line_attr11;
521 l_commit_rec.interface_line_attribute12 := p_commit_interface_line_attr12;
522 l_commit_rec.interface_line_attribute13 := p_commit_interface_line_attr13;
523 l_commit_rec.interface_line_attribute14 := p_commit_interface_line_attr14;
524 l_commit_rec.interface_line_attribute15 := p_commit_interface_line_attr15;
525 l_commit_rec.interface_line_context := p_commit_interface_line_contxt;
526 l_commit_rec.attribute_category := p_commit_attribute_category;
527 l_commit_rec.attribute1 := p_commit_attribute1;
528 l_commit_rec.attribute2 := p_commit_attribute2;
529 l_commit_rec.attribute3 := p_commit_attribute3;
530 l_commit_rec.attribute4 := p_commit_attribute4;
531 l_commit_rec.attribute5 := p_commit_attribute5;
532 l_commit_rec.attribute6 := p_commit_attribute6;
533 l_commit_rec.attribute7 := p_commit_attribute7;
534 l_commit_rec.attribute8 := p_commit_attribute8;
535 l_commit_rec.attribute9 := p_commit_attribute9;
536 l_commit_rec.attribute10 := p_commit_attribute10;
537 l_commit_rec.attribute11 := p_commit_attribute11;
538 l_commit_rec.attribute12 := p_commit_attribute12;
539 l_commit_rec.attribute13 := p_commit_attribute13;
540 l_commit_rec.attribute14 := p_commit_attribute14;
541 l_commit_rec.attribute15 := p_commit_attribute15;
542 l_commit_rec.default_ussgl_transaction_code := p_ctl_default_ussgl_trx_code;
543
544
545 IF PG_DEBUG in ('Y', 'C') THEN
546 arp_util.debug( 'p_customer_trx_id = ' ||
547 TO_CHAR(p_customer_trx_id ) );
548 arp_util.debug( 'p_trx_number = ' ||
549 p_trx_number );
550 arp_util.debug( 'p_trx_amount = ' ||
551 TO_CHAR(p_trx_amount ) );
552 arp_util.debug( 'p_open_rec_flag = '||
553 p_open_rec_flag);
554 arp_util.debug( 'p_term_in_use_flag = '||
555 p_term_in_use_flag);
556 arp_util.debug( 'p_recalc_tax_flag = '||
557 p_recalc_tax_flag);
558 arp_util.debug( 'p_rerun_autoacc_flag = '||
559 p_rerun_autoacc_flag);
560 arp_util.debug( 'p_posting_control_id = ' ||
561 TO_CHAR(p_posting_control_id ) );
562 arp_util.debug( 'p_ra_post_loop_number = ' ||
563 p_ra_post_loop_number );
564 arp_util.debug( 'p_complete_flag = ' ||
565 p_complete_flag );
566 arp_util.debug( 'p_initial_customer_trx_id = ' ||
567 TO_CHAR(p_initial_customer_trx_id ) );
568 arp_util.debug( 'p_initial_customer_trx_line_id = ' ||
569 TO_CHAR(p_initial_customer_trx_line_id ) );
570 arp_util.debug( 'p_previous_customer_trx_id = ' ||
571 TO_CHAR(p_previous_customer_trx_id ) );
572 arp_util.debug( 'p_related_customer_trx_id = ' ||
573 TO_CHAR(p_related_customer_trx_id ) );
574 arp_util.debug( 'p_recurred_from_trx_number = ' ||
575 p_recurred_from_trx_number );
576 arp_util.debug( 'p_cust_trx_type_id = ' ||
577 TO_CHAR(p_cust_trx_type_id ) );
578 arp_util.debug( 'p_batch_id = ' ||
579 TO_CHAR(p_batch_id ) );
580 arp_util.debug( 'p_batch_source_id = ' ||
581 TO_CHAR(p_batch_source_id ) );
582 arp_util.debug( 'p_agreement_id = ' ||
583 TO_CHAR(p_agreement_id ) );
584 arp_util.debug( 'p_trx_date = ' ||
585 p_trx_date );
586 arp_util.debug( 'p_bill_to_customer_id = ' ||
587 TO_CHAR(p_bill_to_customer_id ) );
588 arp_util.debug( 'p_bill_to_contact_id = ' ||
589 TO_CHAR(p_bill_to_contact_id ) );
590 arp_util.debug( 'p_bill_to_site_use_id = ' ||
591 TO_CHAR(p_bill_to_site_use_id ) );
592 arp_util.debug( 'p_ship_to_customer_id = ' ||
593 TO_CHAR(p_ship_to_customer_id ) );
594 arp_util.debug( 'p_ship_to_contact_id = ' ||
595 TO_CHAR(p_ship_to_contact_id ) );
596 arp_util.debug( 'p_ship_to_site_use_id = ' ||
597 TO_CHAR(p_ship_to_site_use_id ) );
598 arp_util.debug( 'p_sold_to_customer_id = ' ||
599 TO_CHAR(p_sold_to_customer_id ) );
600 arp_util.debug( 'p_sold_to_site_use_id = ' ||
601 TO_CHAR(p_sold_to_site_use_id ) );
602 arp_util.debug( 'p_sold_to_contact_id = ' ||
603 TO_CHAR(p_sold_to_contact_id ) );
604 arp_util.debug( 'p_customer_reference = ' ||
605 p_customer_reference );
606 arp_util.debug( 'p_customer_reference_date = ' ||
607 p_customer_reference_date );
608 arp_util.debug( 'p_cr_method_for_installments = ' ||
609 p_cr_method_for_installments );
610 arp_util.debug( 'p_credit_method_for_rules = ' ||
611 p_credit_method_for_rules );
612 arp_util.debug( 'p_start_date_commitment = ' ||
613 p_start_date_commitment );
614 arp_util.debug( 'p_end_date_commitment = ' ||
615 p_end_date_commitment );
616 arp_util.debug( 'p_exchange_date = ' ||
617 p_exchange_date );
618 arp_util.debug( 'p_exchange_rate = ' ||
619 p_exchange_rate );
620 arp_util.debug( 'p_exchange_rate_type = ' ||
621 p_exchange_rate_type );
622 arp_util.debug( 'p_customer_bank_account_id = ' ||
623 p_customer_bank_account_id );
624 arp_util.debug( 'p_finance_charges = ' ||
625 p_finance_charges );
626 arp_util.debug( 'p_fob_point = ' ||
627 p_fob_point );
628 arp_util.debug( 'p_comments = ' ||
629 p_comments );
630 arp_util.debug( 'p_internal_notes = ' ||
631 p_internal_notes );
632 arp_util.debug( 'p_invoice_currency_code = ' ||
633 p_invoice_currency_code );
634 arp_util.debug( 'p_invoicing_rule_id = ' ||
635 TO_CHAR(p_invoicing_rule_id ) );
636 arp_util.debug( 'p_last_printed_sequence_num = ' ||
637 p_last_printed_sequence_num );
638 arp_util.debug( 'p_orig_system_batch_name = ' ||
639 p_orig_system_batch_name );
640 arp_util.debug( 'p_primary_salesrep_id = ' ||
641 TO_CHAR(p_primary_salesrep_id ) );
642 arp_util.debug( 'p_printing_count = ' ||
643 p_printing_count );
644 arp_util.debug( 'p_printing_last_printed = ' ||
645 p_printing_last_printed );
646 arp_util.debug( 'p_printing_option = ' ||
647 p_printing_option );
648 arp_util.debug( 'p_printing_original_date = ' ||
649 p_printing_original_date );
650 arp_util.debug( 'p_printing_pending = ' ||
651 p_printing_pending );
652 arp_util.debug( 'p_purchase_order = ' ||
653 p_purchase_order );
654 arp_util.debug( 'p_purchase_order_date = ' ||
655 p_purchase_order_date );
656 arp_util.debug( 'p_purchase_order_revision = ' ||
657 p_purchase_order_revision );
658 arp_util.debug( 'p_receipt_method_id = ' ||
659 TO_CHAR(p_receipt_method_id ) );
660 arp_util.debug( 'p_remit_to_address_id = ' ||
661 TO_CHAR(p_remit_to_address_id ) );
662 arp_util.debug( 'p_shipment_id = ' ||
663 TO_CHAR(p_shipment_id ) );
664 arp_util.debug( 'p_ship_date_actual = ' ||
665 p_ship_date_actual );
666 arp_util.debug( 'p_ship_via = ' ||
667 p_ship_via );
668 arp_util.debug( 'p_term_due_date = ' ||
669 p_term_due_date );
670 arp_util.debug( 'p_term_id = ' ||
671 TO_CHAR(p_term_id ) );
672 arp_util.debug( 'p_territory_id = ' ||
673 p_territory_id );
674 arp_util.debug( 'p_waybill_number = ' ||
675 p_waybill_number );
676 arp_util.debug( 'p_status_trx = ' ||
677 p_status_trx );
678 arp_util.debug( 'p_reason_code = ' ||
679 p_reason_code );
680 arp_util.debug( 'p_doc_sequence_id = ' ||
681 p_doc_sequence_id );
682 arp_util.debug( 'p_doc_sequence_value = ' ||
683 p_doc_sequence_value );
684 arp_util.debug( 'p_paying_customer_id = ' ||
685 TO_CHAR(p_paying_customer_id ) );
686 arp_util.debug( 'p_paying_site_use_id = ' ||
687 TO_CHAR(p_paying_site_use_id ) );
688 arp_util.debug( 'p_related_batch_source_id = ' ||
689 p_related_batch_source_id );
690 arp_util.debug( 'p_default_tax_exempt_flag = ' ||
691 p_default_tax_exempt_flag );
692 arp_util.debug( 'p_created_from = ' ||
693 p_created_from );
694 arp_util.debug( 'p_ps_dispute_amount = ' ||
695 p_ps_dispute_amount );
696 arp_util.debug( 'p_ps_dispute_date = ' ||
697 p_ps_dispute_date );
698 arp_util.debug( 'p_deflt_ussgl_trx_code_context = ' ||
699 p_deflt_ussgl_trx_code_context );
700 arp_util.debug( 'p_deflt_ussgl_transaction_code = ' ||
701 p_deflt_ussgl_transaction_code );
702 arp_util.debug( 'p_old_trx_number = ' ||
703 p_old_trx_number );
704 arp_util.debug( 'p_interface_header_context = ' ||
705 p_interface_header_context );
706 arp_util.debug( 'p_interface_header_attribute1 = ' ||
707 p_interface_header_attribute1 );
708 arp_util.debug( 'p_interface_header_attribute2 = ' ||
709 p_interface_header_attribute2 );
710 arp_util.debug( 'p_interface_header_attribute3 = ' ||
711 p_interface_header_attribute3 );
712 arp_util.debug( 'p_interface_header_attribute4 = ' ||
713 p_interface_header_attribute4 );
714 arp_util.debug( 'p_interface_header_attribute5 = ' ||
715 p_interface_header_attribute5 );
716 arp_util.debug( 'p_interface_header_attribute6 = ' ||
717 p_interface_header_attribute6 );
718 arp_util.debug( 'p_interface_header_attribute7 = ' ||
719 p_interface_header_attribute7 );
720 arp_util.debug( 'p_interface_header_attribute8 = ' ||
721 p_interface_header_attribute8 );
722 arp_util.debug( 'p_interface_header_attribute9 = ' ||
723 p_interface_header_attribute9 );
724 arp_util.debug( 'p_interface_header_attribute10 = ' ||
725 p_interface_header_attribute10 );
726 arp_util.debug( 'p_interface_header_attribute11 = ' ||
727 p_interface_header_attribute11 );
728 arp_util.debug( 'p_interface_header_attribute12 = ' ||
729 p_interface_header_attribute12 );
730 arp_util.debug( 'p_interface_header_attribute13 = ' ||
731 p_interface_header_attribute13 );
732 arp_util.debug( 'p_interface_header_attribute14 = ' ||
733 p_interface_header_attribute14 );
734 arp_util.debug( 'p_interface_header_attribute15 = ' ||
735 p_interface_header_attribute15 );
736 arp_util.debug( 'p_attribute_category = ' ||
737 p_attribute_category );
738 arp_util.debug( 'p_attribute1 = ' ||
739 p_attribute1 );
740 arp_util.debug( 'p_attribute2 = ' ||
741 p_attribute2 );
742 arp_util.debug( 'p_attribute3 = ' ||
743 p_attribute3 );
744 arp_util.debug( 'p_attribute4 = ' ||
745 p_attribute4 );
746 arp_util.debug( 'p_attribute5 = ' ||
747 p_attribute5 );
748 arp_util.debug( 'p_attribute6 = ' ||
749 p_attribute6 );
750 arp_util.debug( 'p_attribute7 = ' ||
751 p_attribute7 );
752 arp_util.debug( 'p_attribute8 = ' ||
753 p_attribute8 );
754 arp_util.debug( 'p_attribute9 = ' ||
755 p_attribute9 );
756 arp_util.debug( 'p_attribute10 = ' ||
757 p_attribute10 );
758 arp_util.debug( 'p_attribute11 = ' ||
759 p_attribute11 );
760 arp_util.debug( 'p_attribute12 = ' ||
761 p_attribute12 );
762 arp_util.debug( 'p_attribute13 = ' ||
763 p_attribute13 );
764 arp_util.debug( 'p_attribute14 = ' ||
765 p_attribute14 );
766 arp_util.debug( 'p_attribute15 = ' ||
767 p_attribute15 );
768 arp_util.debug( 'p_commit_customer_trx_line_id = ' ||
769 TO_CHAR(p_commit_customer_trx_line_id ) );
770 arp_util.debug( 'p_commit_inventory_item_id = ' ||
771 TO_CHAR(p_commit_inventory_item_id ) );
772 arp_util.debug( 'p_commit_memo_line_id = ' ||
773 TO_CHAR(p_commit_memo_line_id ) );
774 arp_util.debug( 'p_commit_description = ' ||
775 p_commit_description );
776 arp_util.debug( 'p_commit_extended_amount = ' ||
777 p_commit_extended_amount );
778 arp_util.debug( 'p_commit_interface_line_attr1 = ' ||
779 p_commit_interface_line_attr1 );
780 arp_util.debug( 'p_commit_interface_line_attr2 = ' ||
781 p_commit_interface_line_attr2 );
782 arp_util.debug( 'p_commit_interface_line_attr3 = ' ||
783 p_commit_interface_line_attr3 );
784 arp_util.debug( 'p_commit_interface_line_attr4 = ' ||
785 p_commit_interface_line_attr4 );
786 arp_util.debug( 'p_commit_interface_line_attr5 = ' ||
787 p_commit_interface_line_attr5 );
788 arp_util.debug( 'p_commit_interface_line_attr6 = ' ||
789 p_commit_interface_line_attr6 );
790 arp_util.debug( 'p_commit_interface_line_attr7 = ' ||
791 p_commit_interface_line_attr7 );
792 arp_util.debug( 'p_commit_interface_line_attr8 = ' ||
793 p_commit_interface_line_attr8 );
794 arp_util.debug( 'p_commit_interface_line_attr9 = ' ||
795 p_commit_interface_line_attr9 );
796 arp_util.debug( 'p_commit_interface_line_attr10 = ' ||
797 p_commit_interface_line_attr10 );
798 arp_util.debug( 'p_commit_interface_line_attr11 = ' ||
799 p_commit_interface_line_attr11 );
800 arp_util.debug( 'p_commit_interface_line_attr12 = ' ||
801 p_commit_interface_line_attr12 );
802 arp_util.debug( 'p_commit_interface_line_attr13 = ' ||
803 p_commit_interface_line_attr13 );
804 arp_util.debug( 'p_commit_interface_line_attr14 = ' ||
805 p_commit_interface_line_attr14 );
806 arp_util.debug( 'p_commit_interface_line_attr15 = ' ||
807 p_commit_interface_line_attr15 );
808 arp_util.debug( 'p_commit_interface_line_contxt = ' ||
809 p_commit_interface_line_contxt );
810 arp_util.debug( 'p_commit_attribute_category = ' ||
811 p_commit_attribute_category );
812 arp_util.debug( 'p_commit_attribute1 = ' ||
813 p_commit_attribute1 );
814 arp_util.debug( 'p_commit_attribute2 = ' ||
815 p_commit_attribute2 );
816 arp_util.debug( 'p_commit_attribute3 = ' ||
817 p_commit_attribute3 );
818 arp_util.debug( 'p_commit_attribute4 = ' ||
819 p_commit_attribute4 );
820 arp_util.debug( 'p_commit_attribute5 = ' ||
821 p_commit_attribute5 );
822 arp_util.debug( 'p_commit_attribute6 = ' ||
823 p_commit_attribute6 );
824 arp_util.debug( 'p_commit_attribute7 = ' ||
825 p_commit_attribute7 );
826 arp_util.debug( 'p_commit_attribute8 = ' ||
827 p_commit_attribute8 );
828 arp_util.debug( 'p_commit_attribute9 = ' ||
829 p_commit_attribute9 );
830 arp_util.debug( 'p_commit_attribute10 = ' ||
831 p_commit_attribute10 );
832 arp_util.debug( 'p_commit_attribute11 = ' ||
833 p_commit_attribute11 );
834 arp_util.debug( 'p_commit_attribute12 = ' ||
835 p_commit_attribute12 );
836 arp_util.debug( 'p_commit_attribute13 = ' ||
837 p_commit_attribute13 );
838 arp_util.debug( 'p_commit_attribute14 = ' ||
839 p_commit_attribute14 );
840 arp_util.debug( 'p_commit_attribute15 = ' ||
841 p_commit_attribute15 );
842 arp_util.debug( 'p_ctl_default_ussgl_trx_code = ' ||
843 p_ctl_default_ussgl_trx_code );
844 END IF;
845
846 --{BUG#4897183
847 OPEN cev;
848 FETCH cev INTO l_trx_date, l_gl_date, l_org_id, l_sob_id, l_term_id,/*bug6957444*/l_initial_cust_trx_id;
849 IF cev%FOUND THEN
850 lf := TRUE;
851 ELSE
852 lf := FALSE;
853 END IF;
854 CLOSE cev;
855
856 IF lf THEN
857 arp_acct_event_pkg.update_dates_for_trx_event
858 (p_source_id_int_1 => p_customer_trx_id,
859 p_trx_number => p_trx_number,
860 p_legal_entity_id => p_legal_entity_id,
861 p_ledger_id => l_sob_id,
862 p_org_id => l_org_id,
863 p_event_id => NULL,
864 p_valuation_method => NULL,
865 p_entity_type_code => 'TRANSACTIONS',
866 p_event_type_code => 'INV_CREATE',
867 p_curr_event_date => l_gl_date,
868 p_event_date => p_gl_date,
869 p_status => 'I',
870 p_action => 'UPDATE_EVENT_DATE',
871 p_curr_trx_date => l_trx_date,
872 p_transaction_date => p_trx_date,
873 x_event_id => x_event_id);
874
875 arp_util.debug( 'x_event_id = ' ||x_event_id );
876 END IF;
877 --}
878
879
880
881
882
883 /*-------------------------------------------+
884 | Convert Y/N parameter flags to booleans |
885 +-------------------------------------------*/
886
887
888 IF (p_recalc_tax_flag = 'Y')
889 THEN l_recalc_tax_flag := TRUE;
890 ELSE l_recalc_tax_flag := FALSE;
891 END IF;
892
893 IF (p_rerun_autoacc_flag = 'Y')
894 THEN l_rerun_autoacc_flag := TRUE;
895 ELSE l_rerun_autoacc_flag := FALSE;
896 END IF;
897
898 /* Bug 654051: added NVL around dispute amount */
899 /* Bug No 1311297 : added NVL around dispute amount */
900 arp_process_header.update_header(
901 p_form_name,
902 p_form_version,
903 l_trx_rec,
904 p_customer_trx_id,
905 NVL(p_trx_amount,0),
906 p_trx_class,
907 p_gl_date,
908 p_initial_customer_trx_line_id,
909 l_commit_rec,
910 p_open_rec_flag,
911 p_term_in_use_flag,
912 l_recalc_tax_flag,
913 l_rerun_autoacc_flag,
914 NVL(p_ps_dispute_amount,0),
915 p_ps_dispute_date,
916 p_status);
917
918 /* 5468039 - call etax synchronize routine when gl_dates change */
919 /* 5594687 - call line_det_factors if term_id has changed */
920 IF lf
921 THEN
922 /* Determine state for etax sync call */
923 IF PG_DEBUG in ('Y','C')
924 THEN
925 arp_util.debug('Header exists (lf = TRUE) ');
926 arp_util.debug(' old term_id = ' || l_term_id);
927 arp_util.debug(' new term_id = ' || p_term_id);
928 arp_util.debug(' old_gl_date = ' || l_gl_date);
929 arp_util.debug(' new_gl_date = ' || p_gl_date);
930 arp_util.debug(' new initial_customer_trx_id = ' || p_initial_customer_trx_id);
931 arp_util.debug(' old initial_customer_trx_id = ' || l_initial_cust_trx_id);
932 END IF;
933
934 IF NVL(p_term_id, l_term_id) <> l_term_id
935 THEN
936 /* execute line_det_factor update (discount amount
937 may have changed) */
938 IF PG_DEBUG in ('Y','C')
939 THEN
940 arp_debug.debug('term has changed, execute update of LDF');
941 END IF;
942
943 /* loop through the lines and update line det factors
944 for each */
945 FOR line IN c_line(p_customer_trx_id)
946 LOOP
947 arp_etax_services_pkg.line_det_factors(line.customer_trx_line_id,
948 p_customer_trx_id,
949 'UPDATE');
950 END LOOP;
951
952 ELSIF NVL(p_gl_date, l_gl_date) <> l_gl_date
953 THEN
954 IF PG_DEBUG in ('Y','C')
955 THEN
956 arp_debug.debug('gl_date has changed, execute synchronize w/lines');
957 END IF;
958 /* execute synchronize w/ line update */
959 arp_etax_util.synchronize_for_doc_seq(p_customer_trx_id,l_return_status,
960 NULL,
961 'Y');
962 IF l_return_status > 0
963 THEN
964 arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
965 l_return_status);
966 arp_util.debug('Please review the plsql debug log for additional details.');
967 p_status := 'SYNCH_DOC_SEQ_ERROR';
968 END IF;
969 -- bug 6957444 {
970 ELSIF p_initial_customer_trx_id IS NOT NULL and l_initial_cust_trx_id is null then
971 /* Case: Deposit is applied on Invoice */
972 IF PG_DEBUG in ('Y','C')
973 THEN
974 arp_debug.debug('Deposit Application on Inv dont need the ETax call.');
975 END IF;
976 -- bug 6957444 }
977 ELSE
978 /* execute synchronize w/out line update */
979 IF PG_DEBUG in ('Y','C')
980 THEN
981 arp_debug.debug('execute synchronize for doc seq only');
982 END IF;
983
984 arp_etax_util.synchronize_for_doc_seq(p_customer_trx_id,l_return_status);
985
986 IF l_return_status > 0
987 THEN
988 arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
989 l_return_status);
990 arp_util.debug('Please review the plsql debug log for additional details.');
991 p_status := 'SYNCH_DOC_SEQ_ERROR';
992 END IF;
993 END IF;
994 END IF;
995
996 IF PG_DEBUG in ('Y', 'C') THEN
997 arp_util.debug('arp_process_header_updte_cover.update_header_cover()-');
998 END IF;
999
1000 EXCEPTION
1001 WHEN OTHERS THEN
1002 IF PG_DEBUG in ('Y', 'C') THEN
1003 arp_util.debug(
1004 'exception: arp_process_header_updte_cover.update_header_cover()');
1005 END IF;
1006 RAISE;
1007
1008 END update_header_cover;
1009
1010 END ARP_PROCESS_HEADER_UPDTE_COVER;