[Home] [Help]
PACKAGE BODY: APPS.ARP_PROCESS_HEADER_INSRT_COVER
Source
1 PACKAGE BODY ARP_PROCESS_HEADER_INSRT_COVER AS
2 /* $Header: ARTEHCIB.pls 120.7 2006/07/26 10:53:48 rkader ship $ */
3
4
5 /*===========================================================================+
6 | PROCEDURE |
7 | insert_header_cover |
8 | |
9 | DESCRIPTION |
10 | Inserts a record into ra_customer_trx. |
11 | |
12 | SCOPE - PUBLIC |
13 | |
14 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
15 | arp_util.debug |
16 | arp_process_header.insert_header |
17 | |
18 | ARGUMENTS : IN: |
19 | p_form_name |
20 | p_form_version |
21 | p_trx_class |
22 | p_gl_date |
23 | p_term_in_use_flag |
24 | p_receivable_ccid |
25 | p_customer_trx_id |
26 | p_trx_number |
27 | p_posting_control_id |
28 | p_complete_flag |
29 | p_initial_customer_trx_id |
30 | p_previous_customer_trx_id |
31 | p_related_customer_trx_id |
32 | p_recurred_from_trx_number |
33 | p_cust_trx_type_id |
34 | p_batch_id |
35 | p_batch_source_id |
36 | p_agreement_id |
37 | p_trx_date |
38 | p_bill_to_customer_id |
39 | p_bill_to_contact_id |
40 | p_bill_to_site_use_id |
41 | p_ship_to_customer_id |
42 | p_ship_to_contact_id |
43 | p_ship_to_site_use_id |
44 | p_sold_to_customer_id |
45 | p_sold_to_site_use_id |
46 | p_sold_to_contact_id |
47 | p_customer_reference |
48 | p_customer_reference_date |
49 | p_cr_method_for_installments |
50 | p_credit_method_for_rules |
51 | p_start_date_commitment |
52 | p_end_date_commitment |
53 | p_exchange_date |
54 | p_exchange_rate |
55 | p_exchange_rate_type |
56 | p_customer_bank_account_id |
57 | p_finance_charges |
58 | p_fob_point |
59 | p_comments |
60 | p_internal_notes |
61 | p_invoice_currency_code |
62 | p_invoicing_rule_id |
63 | p_last_printed_sequence_num |
64 | p_orig_system_batch_name |
65 | p_primary_salesrep_id |
66 | p_printing_count |
67 | p_printing_last_printed |
68 | p_printing_option |
69 | p_printing_original_date |
70 | p_printing_pending |
71 | p_purchase_order |
72 | p_purchase_order_date |
73 | p_purchase_order_revision |
74 | p_receipt_method_id |
75 | p_remit_to_address_id |
76 | p_shipment_id |
77 | p_ship_date_actual |
78 | p_ship_via |
79 | p_term_due_date |
80 | p_term_id |
81 | p_territory_id |
82 | p_waybill_number |
83 | p_status_trx |
84 | p_reason_code |
85 | p_doc_sequence_id |
86 | p_doc_sequence_value |
87 | p_paying_customer_id |
88 | p_paying_site_use_id |
89 | p_related_batch_source_id |
90 | p_default_tax_exempt_flag |
91 | p_created_from |
92 | p_deflt_ussgl_transaction_code |
93 | p_old_trx_number |
94 | p_interface_header_context |
95 | p_interface_header_attribute1 |
96 | p_interface_header_attribute2 |
97 | p_interface_header_attribute3 |
98 | p_interface_header_attribute4 |
99 | p_interface_header_attribute5 |
100 | p_interface_header_attribute6 |
101 | p_interface_header_attribute7 |
102 | p_interface_header_attribute8 |
103 | p_interface_header_attribute9 |
104 | p_interface_header_attribute10 |
105 | p_interface_header_attribute11 |
106 | p_interface_header_attribute12 |
107 | p_interface_header_attribute13 |
108 | p_interface_header_attribute14 |
109 | p_interface_header_attribute15 |
110 | p_attribute_category |
111 | p_attribute1 |
112 | p_attribute2 |
113 | p_attribute3 |
114 | p_attribute4 |
115 | p_attribute5 |
116 | p_attribute6 |
117 | p_attribute7 |
118 | p_attribute8 |
119 | p_attribute9 |
120 | p_attribute10 |
121 | p_attribute11 |
122 | p_attribute12 |
123 | p_attribute13 |
124 | p_attribute14 |
125 | p_attribute15 |
126 | p_commit_customer_trx_line_id |
127 | p_commit_inventory_item_id |
128 | p_commit_memo_line_id |
129 | p_commit_description |
130 | p_commit_extended_amount |
131 | p_commit_interface_line_attr1 |
132 | p_commit_interface_line_attr2 |
133 | p_commit_interface_line_attr3 |
134 | p_commit_interface_line_attr4 |
135 | p_commit_interface_line_attr5 |
136 | p_commit_interface_line_attr6 |
137 | p_commit_interface_line_attr7 |
138 | p_commit_interface_line_attr8 |
139 | p_commit_interface_line_attr9 |
140 | p_commit_interface_line_attr10 |
141 | p_commit_interface_line_attr11 |
142 | p_commit_interface_line_attr12 |
143 | p_commit_interface_line_attr13 |
144 | p_commit_interface_line_attr14 |
145 | p_commit_interface_line_attr15 |
146 | p_commit_interface_line_contxt |
147 | p_commit_attribute_category |
148 | p_commit_attribute1 |
149 | p_commit_attribute2 |
150 | p_commit_attribute3 |
151 | p_commit_attribute4 |
152 | p_commit_attribute5 |
153 | p_commit_attribute6 |
154 | p_commit_attribute7 |
155 | p_commit_attribute8 |
156 | p_commit_attribute9 |
157 | p_commit_attribute10 |
158 | p_commit_attribute11 |
159 | p_commit_attribute12 |
160 | p_commit_attribute13 |
161 | p_commit_attribute14 |
162 | p_commit_attribute15 |
163 | p_ctl_default_ussgl_trx_code |
164 | p_ct_reference |
165 | OUT: |
166 | p_new_trx_number |
167 | p_new_customer_trx_id |
168 | p_new_customer_trx_line_id |
169 | p_new_row_id |
170 | p_status |
171 | IN/ OUT: |
172 | |
173 | RETURNS : NONE |
174 | |
175 | NOTES |
176 | |
177 | MODIFICATION HISTORY |
178 | 27-NOV-95 Charlie Tomberg Created |
179 | 18-May-05 Debbie Jancis Modified to include Legal Entity Id |
180 | 07-Aug-05 Surendra Rajan Added Payment_trxn_extension_id |
181 +===========================================================================*/
182
183 PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
184
185 PROCEDURE insert_header_cover(
186 p_form_name IN varchar2,
187 p_form_version IN number,
188 p_trx_class IN VARCHAR2,
189 p_gl_date IN DATE,
190 p_term_in_use_flag IN varchar2,
191 p_receivable_ccid IN NUMBER,
192 p_customer_trx_id IN NUMBER,
193 p_trx_number IN VARCHAR2,
194 p_posting_control_id IN NUMBER,
195 p_complete_flag IN VARCHAR2,
196 p_initial_customer_trx_id IN NUMBER,
197 p_previous_customer_trx_id IN NUMBER,
198 p_related_customer_trx_id IN NUMBER,
199 p_recurred_from_trx_number IN VARCHAR2,
200 p_cust_trx_type_id IN NUMBER,
201 p_batch_id IN NUMBER,
202 p_batch_source_id IN NUMBER,
203 p_agreement_id IN NUMBER,
204 p_trx_date IN DATE,
205 p_bill_to_customer_id IN NUMBER,
206 p_bill_to_contact_id IN NUMBER,
207 p_bill_to_site_use_id IN NUMBER,
208 p_ship_to_customer_id IN NUMBER,
209 p_ship_to_contact_id IN NUMBER,
210 p_ship_to_site_use_id IN NUMBER,
211 p_sold_to_customer_id IN NUMBER,
212 p_sold_to_site_use_id IN NUMBER,
213 p_sold_to_contact_id IN NUMBER,
214 p_customer_reference IN VARCHAR2,
215 p_customer_reference_date IN DATE,
216 p_cr_method_for_installments IN VARCHAR2,
217 p_credit_method_for_rules IN VARCHAR2,
218 p_start_date_commitment IN DATE,
219 p_end_date_commitment IN DATE,
220 p_exchange_date IN DATE,
221 p_exchange_rate IN NUMBER,
222 p_exchange_rate_type IN VARCHAR2,
223 p_customer_bank_account_id IN NUMBER,
224 p_finance_charges IN VARCHAR2,
225 p_fob_point IN VARCHAR2,
226 p_comments IN VARCHAR2,
227 p_internal_notes IN VARCHAR2,
228 p_invoice_currency_code IN VARCHAR2,
229 p_invoicing_rule_id IN NUMBER,
230 p_last_printed_sequence_num IN NUMBER,
231 p_orig_system_batch_name IN VARCHAR2,
232 p_primary_salesrep_id IN NUMBER,
233 p_printing_count IN NUMBER,
234 p_printing_last_printed IN DATE,
235 p_printing_option IN VARCHAR2,
236 p_printing_original_date IN DATE,
237 p_printing_pending IN VARCHAR2,
238 p_purchase_order IN VARCHAR2,
239 p_purchase_order_date IN DATE,
240 p_purchase_order_revision IN VARCHAR2,
241 p_receipt_method_id IN NUMBER,
242 p_remit_to_address_id IN NUMBER,
243 p_shipment_id IN NUMBER,
244 p_ship_date_actual IN DATE,
245 p_ship_via IN VARCHAR2,
246 p_term_due_date IN DATE,
247 p_term_id IN NUMBER,
248 p_territory_id IN NUMBER,
249 p_waybill_number IN VARCHAR2,
250 p_status_trx IN VARCHAR2,
251 p_reason_code IN VARCHAR2,
252 p_doc_sequence_id IN NUMBER,
253 p_doc_sequence_value IN NUMBER,
254 p_paying_customer_id IN NUMBER,
255 p_paying_site_use_id IN NUMBER,
256 p_related_batch_source_id IN NUMBER,
257 p_default_tax_exempt_flag IN VARCHAR2,
258 p_created_from IN VARCHAR2,
259 p_deflt_ussgl_transaction_code IN VARCHAR2,
260 p_old_trx_number IN VARCHAR2,
261 p_interface_header_context IN VARCHAR2,
262 p_interface_header_attribute1 IN VARCHAR2,
263 p_interface_header_attribute2 IN VARCHAR2,
264 p_interface_header_attribute3 IN VARCHAR2,
265 p_interface_header_attribute4 IN VARCHAR2,
266 p_interface_header_attribute5 IN VARCHAR2,
267 p_interface_header_attribute6 IN VARCHAR2,
268 p_interface_header_attribute7 IN VARCHAR2,
269 p_interface_header_attribute8 IN VARCHAR2,
270 p_interface_header_attribute9 IN VARCHAR2,
271 p_interface_header_attribute10 IN VARCHAR2,
272 p_interface_header_attribute11 IN VARCHAR2,
273 p_interface_header_attribute12 IN VARCHAR2,
274 p_interface_header_attribute13 IN VARCHAR2,
275 p_interface_header_attribute14 IN VARCHAR2,
276 p_interface_header_attribute15 IN VARCHAR2,
277 p_attribute_category IN VARCHAR2,
278 p_attribute1 IN VARCHAR2,
279 p_attribute2 IN VARCHAR2,
280 p_attribute3 IN VARCHAR2,
281 p_attribute4 IN VARCHAR2,
282 p_attribute5 IN VARCHAR2,
283 p_attribute6 IN VARCHAR2,
284 p_attribute7 IN VARCHAR2,
285 p_attribute8 IN VARCHAR2,
286 p_attribute9 IN VARCHAR2,
287 p_attribute10 IN VARCHAR2,
288 p_attribute11 IN VARCHAR2,
289 p_attribute12 IN VARCHAR2,
290 p_attribute13 IN VARCHAR2,
291 p_attribute14 IN VARCHAR2,
292 p_attribute15 IN VARCHAR2,
293 p_commit_customer_trx_line_id IN NUMBER,
294 p_commit_inventory_item_id IN NUMBER,
295 p_commit_memo_line_id IN NUMBER,
296 p_commit_description IN VARCHAR2,
297 p_commit_extended_amount IN NUMBER,
298 p_commit_interface_line_attr1 IN VARCHAR2,
299 p_commit_interface_line_attr2 IN VARCHAR2,
300 p_commit_interface_line_attr3 IN VARCHAR2,
301 p_commit_interface_line_attr4 IN VARCHAR2,
302 p_commit_interface_line_attr5 IN VARCHAR2,
303 p_commit_interface_line_attr6 IN VARCHAR2,
304 p_commit_interface_line_attr7 IN VARCHAR2,
305 p_commit_interface_line_attr8 IN VARCHAR2,
306 p_commit_interface_line_attr9 IN VARCHAR2,
307 p_commit_interface_line_attr10 IN VARCHAR2,
308 p_commit_interface_line_attr11 IN VARCHAR2,
309 p_commit_interface_line_attr12 IN VARCHAR2,
310 p_commit_interface_line_attr13 IN VARCHAR2,
311 p_commit_interface_line_attr14 IN VARCHAR2,
312 p_commit_interface_line_attr15 IN VARCHAR2,
313 p_commit_interface_line_contxt IN VARCHAR2,
314 p_commit_attribute_category IN VARCHAR2,
315 p_commit_attribute1 IN VARCHAR2,
316 p_commit_attribute2 IN VARCHAR2,
317 p_commit_attribute3 IN VARCHAR2,
318 p_commit_attribute4 IN VARCHAR2,
319 p_commit_attribute5 IN VARCHAR2,
320 p_commit_attribute6 IN VARCHAR2,
321 p_commit_attribute7 IN VARCHAR2,
322 p_commit_attribute8 IN VARCHAR2,
323 p_commit_attribute9 IN VARCHAR2,
324 p_commit_attribute10 IN VARCHAR2,
325 p_commit_attribute11 IN VARCHAR2,
326 p_commit_attribute12 IN VARCHAR2,
327 p_commit_attribute13 IN VARCHAR2,
328 p_commit_attribute14 IN VARCHAR2,
329 p_commit_attribute15 IN VARCHAR2,
330 p_ctl_default_ussgl_trx_code IN VARCHAR2,
331 p_new_trx_number OUT NOCOPY VARCHAR2,
332 p_new_customer_trx_id OUT NOCOPY NUMBER,
333 p_new_customer_trx_line_id OUT NOCOPY NUMBER,
334 p_new_row_id OUT NOCOPY varchar2,
335 p_status OUT NOCOPY varchar2,
336 p_legal_entity_id IN NUMBER DEFAULT NULL,
337 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* PAYMENT_UPTAKE */
338 p_billing_date IN DATE DEFAULT NULL, /* R12:BFB */
339 p_ct_reference IN VARCHAR2 DEFAULT NULL) /* Bug fix 5330712 */
340 IS
341
342 l_commit_rec arp_process_commitment.commitment_rec_type;
343 l_trx_rec ra_customer_trx%rowtype;
344
345 BEGIN
346
347 IF PG_DEBUG in ('Y', 'C') THEN
348 arp_util.debug('arp_process_header_insrt_cover.insert_header_cover()+');
349 END IF;
350
351 l_trx_rec.customer_trx_id := p_customer_trx_id;
352 l_trx_rec.trx_number := p_trx_number;
353 l_trx_rec.posting_control_id := p_posting_control_id;
354 l_trx_rec.complete_flag := p_complete_flag;
355 l_trx_rec.initial_customer_trx_id := p_initial_customer_trx_id;
356 l_trx_rec.previous_customer_trx_id := p_previous_customer_trx_id;
357 l_trx_rec.related_customer_trx_id := p_related_customer_trx_id;
358 l_trx_rec.recurred_from_trx_number := p_recurred_from_trx_number;
359 l_trx_rec.cust_trx_type_id := p_cust_trx_type_id;
360 l_trx_rec.batch_id := p_batch_id;
361 l_trx_rec.batch_source_id := p_batch_source_id;
362 l_trx_rec.agreement_id := p_agreement_id;
363 l_trx_rec.trx_date := p_trx_date;
364 l_trx_rec.bill_to_customer_id := p_bill_to_customer_id;
365 l_trx_rec.bill_to_contact_id := p_bill_to_contact_id;
366 l_trx_rec.bill_to_site_use_id := p_bill_to_site_use_id;
367 l_trx_rec.ship_to_customer_id := p_ship_to_customer_id;
368 l_trx_rec.ship_to_contact_id := p_ship_to_contact_id;
369 l_trx_rec.ship_to_site_use_id := p_ship_to_site_use_id;
370 l_trx_rec.sold_to_customer_id := p_sold_to_customer_id;
371 l_trx_rec.sold_to_site_use_id := p_sold_to_site_use_id;
372 l_trx_rec.sold_to_contact_id := p_sold_to_contact_id;
373 l_trx_rec.customer_reference := p_customer_reference;
374 l_trx_rec.customer_reference_date := p_customer_reference_date;
375 l_trx_rec.credit_method_for_installments := p_cr_method_for_installments;
376 l_trx_rec.credit_method_for_rules := p_credit_method_for_rules;
377 l_trx_rec.start_date_commitment := p_start_date_commitment;
378 l_trx_rec.end_date_commitment := p_end_date_commitment;
379 l_trx_rec.exchange_date := p_exchange_date;
380 l_trx_rec.exchange_rate := p_exchange_rate;
381 l_trx_rec.exchange_rate_type := p_exchange_rate_type;
382 l_trx_rec.customer_bank_account_id := p_customer_bank_account_id;
383 l_trx_rec.finance_charges := p_finance_charges;
384 l_trx_rec.fob_point := p_fob_point;
385 l_trx_rec.comments := p_comments;
386 l_trx_rec.internal_notes := p_internal_notes;
387 l_trx_rec.invoice_currency_code := p_invoice_currency_code;
388 l_trx_rec.invoicing_rule_id := p_invoicing_rule_id;
389 l_trx_rec.last_printed_sequence_num := p_last_printed_sequence_num;
390 l_trx_rec.orig_system_batch_name := p_orig_system_batch_name;
391 l_trx_rec.primary_salesrep_id := p_primary_salesrep_id;
392 l_trx_rec.printing_count := p_printing_count;
393 l_trx_rec.printing_last_printed := p_printing_last_printed;
394 l_trx_rec.printing_option := p_printing_option;
395 l_trx_rec.printing_original_date := p_printing_original_date;
396 l_trx_rec.printing_pending := p_printing_pending;
397 l_trx_rec.purchase_order := p_purchase_order;
398 l_trx_rec.purchase_order_date := p_purchase_order_date;
399 l_trx_rec.purchase_order_revision := p_purchase_order_revision;
400 l_trx_rec.receipt_method_id := p_receipt_method_id;
401 l_trx_rec.remit_to_address_id := p_remit_to_address_id;
402 l_trx_rec.shipment_id := p_shipment_id;
403 l_trx_rec.ship_date_actual := p_ship_date_actual;
404 l_trx_rec.ship_via := p_ship_via;
405 l_trx_rec.term_due_date := p_term_due_date;
406 l_trx_rec.term_id := p_term_id;
407 l_trx_rec.territory_id := p_territory_id;
408 l_trx_rec.waybill_number := p_waybill_number;
409 l_trx_rec.status_trx := p_status_trx;
410 l_trx_rec.reason_code := p_reason_code;
411 l_trx_rec.doc_sequence_id := p_doc_sequence_id;
412 l_trx_rec.doc_sequence_value := p_doc_sequence_value;
413 l_trx_rec.paying_customer_id := p_paying_customer_id;
414 l_trx_rec.paying_site_use_id := p_paying_site_use_id;
415 l_trx_rec.related_batch_source_id := p_related_batch_source_id;
416 l_trx_rec.default_tax_exempt_flag := p_default_tax_exempt_flag;
417 l_trx_rec.created_from := p_created_from;
418 l_trx_rec.default_ussgl_transaction_code := p_deflt_ussgl_transaction_code;
419 l_trx_rec.old_trx_number := p_old_trx_number;
420 l_trx_rec.interface_header_context := p_interface_header_context;
421 l_trx_rec.interface_header_attribute1 := p_interface_header_attribute1;
422 l_trx_rec.interface_header_attribute2 := p_interface_header_attribute2;
423 l_trx_rec.interface_header_attribute3 := p_interface_header_attribute3;
424 l_trx_rec.interface_header_attribute4 := p_interface_header_attribute4;
425 l_trx_rec.interface_header_attribute5 := p_interface_header_attribute5;
426 l_trx_rec.interface_header_attribute6 := p_interface_header_attribute6;
427 l_trx_rec.interface_header_attribute7 := p_interface_header_attribute7;
428 l_trx_rec.interface_header_attribute8 := p_interface_header_attribute8;
429 l_trx_rec.interface_header_attribute9 := p_interface_header_attribute9;
430 l_trx_rec.interface_header_attribute10 := p_interface_header_attribute10;
431 l_trx_rec.interface_header_attribute11 := p_interface_header_attribute11;
432 l_trx_rec.interface_header_attribute12 := p_interface_header_attribute12;
433 l_trx_rec.interface_header_attribute13 := p_interface_header_attribute13;
434 l_trx_rec.interface_header_attribute14 := p_interface_header_attribute14;
435 l_trx_rec.interface_header_attribute15 := p_interface_header_attribute15;
436 l_trx_rec.attribute_category := p_attribute_category;
437 l_trx_rec.attribute1 := p_attribute1;
438 l_trx_rec.attribute2 := p_attribute2;
439 l_trx_rec.attribute3 := p_attribute3;
440 l_trx_rec.attribute4 := p_attribute4;
441 l_trx_rec.attribute5 := p_attribute5;
442 l_trx_rec.attribute6 := p_attribute6;
443 l_trx_rec.attribute7 := p_attribute7;
444 l_trx_rec.attribute8 := p_attribute8;
445 l_trx_rec.attribute9 := p_attribute9;
446 l_trx_rec.attribute10 := p_attribute10;
447 l_trx_rec.attribute11 := p_attribute11;
448 l_trx_rec.attribute12 := p_attribute12;
449 l_trx_rec.attribute13 := p_attribute13;
450 l_trx_rec.attribute14 := p_attribute14;
451 l_trx_rec.attribute15 := p_attribute15;
452
453 l_commit_rec.customer_trx_line_id := p_commit_customer_trx_line_id;
454 l_commit_rec.inventory_item_id := p_commit_inventory_item_id;
455 l_commit_rec.memo_line_id := p_commit_memo_line_id;
456 l_commit_rec.description := p_commit_description;
457 l_commit_rec.extended_amount := p_commit_extended_amount;
458 l_commit_rec.interface_line_attribute1 := p_commit_interface_line_attr1;
459 l_commit_rec.interface_line_attribute2 := p_commit_interface_line_attr2;
460 l_commit_rec.interface_line_attribute3 := p_commit_interface_line_attr3;
461 l_commit_rec.interface_line_attribute4 := p_commit_interface_line_attr4;
462 l_commit_rec.interface_line_attribute5 := p_commit_interface_line_attr5;
463 l_commit_rec.interface_line_attribute6 := p_commit_interface_line_attr6;
464 l_commit_rec.interface_line_attribute7 := p_commit_interface_line_attr7;
465 l_commit_rec.interface_line_attribute8 := p_commit_interface_line_attr8;
466 l_commit_rec.interface_line_attribute9 := p_commit_interface_line_attr9;
467 l_commit_rec.interface_line_attribute10 := p_commit_interface_line_attr10;
468 l_commit_rec.interface_line_attribute11 := p_commit_interface_line_attr11;
469 l_commit_rec.interface_line_attribute12 := p_commit_interface_line_attr12;
470 l_commit_rec.interface_line_attribute13 := p_commit_interface_line_attr13;
471 l_commit_rec.interface_line_attribute14 := p_commit_interface_line_attr14;
472 l_commit_rec.interface_line_attribute15 := p_commit_interface_line_attr15;
473 l_commit_rec.interface_line_context := p_commit_interface_line_contxt;
474 l_commit_rec.attribute_category := p_commit_attribute_category;
475 l_commit_rec.attribute1 := p_commit_attribute1;
476 l_commit_rec.attribute2 := p_commit_attribute2;
477 l_commit_rec.attribute3 := p_commit_attribute3;
478 l_commit_rec.attribute4 := p_commit_attribute4;
479 l_commit_rec.attribute5 := p_commit_attribute5;
480 l_commit_rec.attribute6 := p_commit_attribute6;
481 l_commit_rec.attribute7 := p_commit_attribute7;
482 l_commit_rec.attribute8 := p_commit_attribute8;
483 l_commit_rec.attribute9 := p_commit_attribute9;
484 l_commit_rec.attribute10 := p_commit_attribute10;
485 l_commit_rec.attribute11 := p_commit_attribute11;
486 l_commit_rec.attribute12 := p_commit_attribute12;
487 l_commit_rec.attribute13 := p_commit_attribute13;
488 l_commit_rec.attribute14 := p_commit_attribute14;
489 l_commit_rec.attribute15 := p_commit_attribute15;
490 l_commit_rec.default_ussgl_transaction_code := p_ctl_default_ussgl_trx_code;
491
492 /* Legal Entity Project */
493 l_trx_rec.legal_entity_id := p_legal_entity_id;
494 /* PAYMENT_UPTAKE */
495 l_trx_rec.payment_trxn_extension_id := p_payment_trxn_extension_id;
496 l_trx_rec.billing_date := p_billing_date; /* R12:BFB */
497 l_trx_rec.ct_reference := p_ct_reference; /* bug fix 5330712 */
498
499 /*
500 IF PG_DEBUG in ('Y', 'C') THEN
501 arp_util.debug('insert_header_cover: ' || 'p_customer_trx_id = ' ||
502 TO_CHAR(p_customer_trx_id ) );
503 arp_util.debug('insert_header_cover: ' || 'p_trx_number = ' ||
504 p_trx_number );
505 arp_util.debug('insert_header_cover: ' || 'p_posting_control_id = ' ||
506 TO_CHAR(p_posting_control_id ) );
507 arp_util.debug('insert_header_cover: ' || 'p_complete_flag = ' ||
508 p_complete_flag );
509 arp_util.debug('insert_header_cover: ' || 'p_initial_customer_trx_id = ' ||
510 TO_CHAR(p_initial_customer_trx_id ) );
511 arp_util.debug('insert_header_cover: ' || 'p_previous_customer_trx_id = ' ||
512 TO_CHAR(p_previous_customer_trx_id ) );
513 arp_util.debug('insert_header_cover: ' || 'p_related_customer_trx_id = ' ||
514 TO_CHAR(p_related_customer_trx_id ) );
515 arp_util.debug('insert_header_cover: ' || 'p_recurred_from_trx_number = ' ||
516 p_recurred_from_trx_number );
517 arp_util.debug('insert_header_cover: ' || 'p_cust_trx_type_id = ' ||
518 TO_CHAR(p_cust_trx_type_id ) );
519 arp_util.debug('insert_header_cover: ' || 'p_batch_id = ' ||
520 TO_CHAR(p_batch_id ) );
521 arp_util.debug('insert_header_cover: ' || 'p_batch_source_id = ' ||
522 TO_CHAR(p_batch_source_id ) );
523 arp_util.debug('insert_header_cover: ' || 'p_agreement_id = ' ||
524 TO_CHAR(p_agreement_id ) );
525 arp_util.debug('insert_header_cover: ' || 'p_trx_date = ' ||
526 p_trx_date );
527 arp_util.debug('insert_header_cover: ' || 'p_bill_to_customer_id = ' ||
528 TO_CHAR(p_bill_to_customer_id ) );
529 arp_util.debug('insert_header_cover: ' || 'p_bill_to_contact_id = ' ||
530 TO_CHAR(p_bill_to_contact_id ) );
531 arp_util.debug('insert_header_cover: ' || 'p_bill_to_site_use_id = ' ||
532 TO_CHAR(p_bill_to_site_use_id ) );
533 arp_util.debug('insert_header_cover: ' || 'p_ship_to_customer_id = ' ||
534 TO_CHAR(p_ship_to_customer_id ) );
535 arp_util.debug('insert_header_cover: ' || 'p_ship_to_contact_id = ' ||
536 TO_CHAR(p_ship_to_contact_id ) );
537 arp_util.debug('insert_header_cover: ' || 'p_ship_to_site_use_id = ' ||
538 TO_CHAR(p_ship_to_site_use_id ) );
539 arp_util.debug('insert_header_cover: ' || 'p_sold_to_customer_id = ' ||
540 TO_CHAR(p_sold_to_customer_id ) );
541 arp_util.debug('insert_header_cover: ' || 'p_sold_to_site_use_id = ' ||
542 TO_CHAR(p_sold_to_site_use_id ) );
543 arp_util.debug('insert_header_cover: ' || 'p_sold_to_contact_id = ' ||
544 TO_CHAR(p_sold_to_contact_id ) );
545 arp_util.debug('insert_header_cover: ' || 'p_customer_reference = ' ||
546 p_customer_reference );
547 arp_util.debug('insert_header_cover: ' || 'p_customer_reference_date = ' ||
548 p_customer_reference_date );
549 arp_util.debug('insert_header_cover: ' || 'p_cr_method_for_installments = ' ||
550 p_cr_method_for_installments );
551 arp_util.debug('insert_header_cover: ' || 'p_credit_method_for_rules = ' ||
552 p_credit_method_for_rules );
553 arp_util.debug('insert_header_cover: ' || 'p_start_date_commitment = ' ||
554 p_start_date_commitment );
555 arp_util.debug('insert_header_cover: ' || 'p_end_date_commitment = ' ||
556 p_end_date_commitment );
557 arp_util.debug('insert_header_cover: ' || 'p_exchange_date = ' ||
558 p_exchange_date );
559 arp_util.debug('insert_header_cover: ' || 'p_exchange_rate = ' ||
560 p_exchange_rate );
561 arp_util.debug('insert_header_cover: ' || 'p_exchange_rate_type = ' ||
562 p_exchange_rate_type );
563 arp_util.debug('insert_header_cover: ' || 'p_customer_bank_account_id = ' ||
564 p_customer_bank_account_id );
565 arp_util.debug('insert_header_cover: ' || 'p_finance_charges = ' ||
566 p_finance_charges );
567 arp_util.debug('insert_header_cover: ' || 'p_fob_point = ' ||
568 p_fob_point );
569 arp_util.debug('insert_header_cover: ' || 'p_comments = ' ||
570 p_comments );
571 arp_util.debug('insert_header_cover: ' || 'p_internal_notes = ' ||
572 p_internal_notes );
573 arp_util.debug('insert_header_cover: ' || 'p_invoice_currency_code = ' ||
574 p_invoice_currency_code );
575 arp_util.debug('insert_header_cover: ' || 'p_invoicing_rule_id = ' ||
576 TO_CHAR(p_invoicing_rule_id ) );
577 arp_util.debug('insert_header_cover: ' || 'p_last_printed_sequence_num = ' ||
578 p_last_printed_sequence_num );
579 arp_util.debug('insert_header_cover: ' || 'p_orig_system_batch_name = ' ||
580 p_orig_system_batch_name );
581 arp_util.debug('insert_header_cover: ' || 'p_primary_salesrep_id = ' ||
582 TO_CHAR(p_primary_salesrep_id ) );
583 arp_util.debug('insert_header_cover: ' || 'p_printing_count = ' ||
584 p_printing_count );
585 arp_util.debug('insert_header_cover: ' || 'p_printing_last_printed = ' ||
586 p_printing_last_printed );
587 arp_util.debug('insert_header_cover: ' || 'p_printing_option = ' ||
588 p_printing_option );
589 arp_util.debug('insert_header_cover: ' || 'p_printing_original_date = ' ||
590 p_printing_original_date );
591 arp_util.debug('insert_header_cover: ' || 'p_printing_pending = ' ||
592 p_printing_pending );
593 arp_util.debug('insert_header_cover: ' || 'p_purchase_order = ' ||
594 p_purchase_order );
595 arp_util.debug('insert_header_cover: ' || 'p_purchase_order_date = ' ||
596 p_purchase_order_date );
597 arp_util.debug('insert_header_cover: ' || 'p_purchase_order_revision = ' ||
598 p_purchase_order_revision );
599 arp_util.debug('insert_header_cover: ' || 'p_receipt_method_id = ' ||
600 TO_CHAR(p_receipt_method_id ) );
601 arp_util.debug('insert_header_cover: ' || 'p_remit_to_address_id = ' ||
602 TO_CHAR(p_remit_to_address_id ) );
603 arp_util.debug('insert_header_cover: ' || 'p_shipment_id = ' ||
604 TO_CHAR(p_shipment_id ) );
605 arp_util.debug('insert_header_cover: ' || 'p_ship_date_actual = ' ||
606 p_ship_date_actual );
607 arp_util.debug('insert_header_cover: ' || 'p_ship_via = ' ||
608 p_ship_via );
609 arp_util.debug('insert_header_cover: ' || 'p_term_due_date = ' ||
610 p_term_due_date );
611 arp_util.debug('insert_header_cover: ' || 'p_term_id = ' ||
612 TO_CHAR(p_term_id ) );
613 arp_util.debug('insert_header_cover: ' || 'p_territory_id = ' ||
614 p_territory_id );
615 arp_util.debug('insert_header_cover: ' || 'p_waybill_number = ' ||
616 p_waybill_number );
617 arp_util.debug('insert_header_cover: ' || 'p_status_trx = ' ||
618 p_status_trx );
619 arp_util.debug('insert_header_cover: ' || 'p_reason_code = ' ||
620 p_reason_code );
621 arp_util.debug('insert_header_cover: ' || 'p_doc_sequence_id = ' ||
622 p_doc_sequence_id );
623 arp_util.debug('insert_header_cover: ' || 'p_doc_sequence_value = ' ||
624 p_doc_sequence_value );
625 arp_util.debug('insert_header_cover: ' || 'p_paying_customer_id = ' ||
626 TO_CHAR(p_paying_customer_id ) );
627 arp_util.debug('insert_header_cover: ' || 'p_paying_site_use_id = ' ||
628 TO_CHAR(p_paying_site_use_id ) );
629 arp_util.debug('insert_header_cover: ' || 'p_related_batch_source_id = ' ||
630 p_related_batch_source_id );
631 arp_util.debug('insert_header_cover: ' || 'p_default_tax_exempt_flag = ' ||
632 p_default_tax_exempt_flag );
633 arp_util.debug('insert_header_cover: ' || 'p_created_from = ' ||
634 p_created_from );
635 arp_util.debug('insert_header_cover: ' || 'p_deflt_ussgl_transaction_code = ' ||
636 p_deflt_ussgl_transaction_code );
637 arp_util.debug('insert_header_cover: ' || 'p_interface_header_context = ' ||
638 p_interface_header_context );
639 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute1 = ' ||
640 p_interface_header_attribute1 );
641 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute2 = ' ||
642 p_interface_header_attribute2 );
643 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute3 = ' ||
644 p_interface_header_attribute3 );
645 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute4 = ' ||
646 p_interface_header_attribute4 );
647 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute5 = ' ||
648 p_interface_header_attribute5 );
649 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute6 = ' ||
650 p_interface_header_attribute6 );
651 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute7 = ' ||
652 p_interface_header_attribute7 );
653 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute8 = ' ||
654 p_interface_header_attribute8 );
655 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute9 = ' ||
656 p_interface_header_attribute9 );
657 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute10 = ' ||
658 p_interface_header_attribute10 );
659 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute11 = ' ||
660 p_interface_header_attribute11 );
661 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute12 = ' ||
662 p_interface_header_attribute12 );
663 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute13 = ' ||
664 p_interface_header_attribute13 );
665 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute14 = ' ||
666 p_interface_header_attribute14 );
667 arp_util.debug('insert_header_cover: ' || 'p_interface_header_attribute15 = ' ||
668 p_interface_header_attribute15 );
669 arp_util.debug('insert_header_cover: ' || 'p_attribute_category = ' ||
670 p_attribute_category );
671 arp_util.debug('insert_header_cover: ' || 'p_attribute1 = ' ||
672 p_attribute1 );
673 arp_util.debug('insert_header_cover: ' || 'p_attribute2 = ' ||
674 p_attribute2 );
675 arp_util.debug('insert_header_cover: ' || 'p_attribute3 = ' ||
676 p_attribute3 );
677 arp_util.debug('insert_header_cover: ' || 'p_attribute4 = ' ||
678 p_attribute4 );
679 arp_util.debug('insert_header_cover: ' || 'p_attribute5 = ' ||
680 p_attribute5 );
681 arp_util.debug('insert_header_cover: ' || 'p_attribute6 = ' ||
682 p_attribute6 );
683 arp_util.debug('insert_header_cover: ' || 'p_attribute7 = ' ||
684 p_attribute7 );
685 arp_util.debug('insert_header_cover: ' || 'p_attribute8 = ' ||
686 p_attribute8 );
687 arp_util.debug('insert_header_cover: ' || 'p_attribute9 = ' ||
688 p_attribute9 );
689 arp_util.debug('insert_header_cover: ' || 'p_attribute10 = ' ||
690 p_attribute10 );
691 arp_util.debug('insert_header_cover: ' || 'p_attribute11 = ' ||
692 p_attribute11 );
693 arp_util.debug('insert_header_cover: ' || 'p_attribute12 = ' ||
694 p_attribute12 );
695 arp_util.debug('insert_header_cover: ' || 'p_attribute13 = ' ||
696 p_attribute13 );
697 arp_util.debug('insert_header_cover: ' || 'p_attribute14 = ' ||
698 p_attribute14 );
699 arp_util.debug('insert_header_cover: ' || 'p_attribute15 = ' ||
700 p_attribute15 );
701 arp_util.debug('insert_header_cover: ' || 'p_commit_customer_trx_line_id = ' ||
702 TO_CHAR(p_commit_customer_trx_line_id ) );
703 arp_util.debug('insert_header_cover: ' || 'p_commit_inventory_item_id = ' ||
704 TO_CHAR(p_commit_inventory_item_id ) );
705 arp_util.debug('insert_header_cover: ' || 'p_commit_memo_line_id = ' ||
706 TO_CHAR(p_commit_memo_line_id ) );
707 arp_util.debug('insert_header_cover: ' || 'p_commit_description = ' ||
708 p_commit_description );
709 arp_util.debug('insert_header_cover: ' || 'p_commit_extended_amount = ' ||
710 p_commit_extended_amount );
711 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr1 = ' ||
712 p_commit_interface_line_attr1 );
713 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr2 = ' ||
714 p_commit_interface_line_attr2 );
715 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr3 = ' ||
716 p_commit_interface_line_attr3 );
717 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr4 = ' ||
718 p_commit_interface_line_attr4 );
719 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr5 = ' ||
720 p_commit_interface_line_attr5 );
721 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr6 = ' ||
722 p_commit_interface_line_attr6 );
723 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr7 = ' ||
724 p_commit_interface_line_attr7 );
725 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr8 = ' ||
726 p_commit_interface_line_attr8 );
727 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr9 = ' ||
728 p_commit_interface_line_attr9 );
729 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr10 = ' ||
730 p_commit_interface_line_attr10 );
731 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr11 = ' ||
732 p_commit_interface_line_attr11 );
733 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr12 = ' ||
734 p_commit_interface_line_attr12 );
735 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr13 = ' ||
736 p_commit_interface_line_attr13 );
737 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr14 = ' ||
738 p_commit_interface_line_attr14 );
739 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_attr15 = ' ||
740 p_commit_interface_line_attr15 );
741 arp_util.debug('insert_header_cover: ' || 'p_commit_interface_line_contxt = ' ||
742 p_commit_interface_line_contxt );
743 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute_category = ' ||
744 p_commit_attribute_category );
745 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute1 = ' ||
746 p_commit_attribute1 );
747 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute2 = ' ||
748 p_commit_attribute2 );
749 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute3 = ' ||
750 p_commit_attribute3 );
751 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute4 = ' ||
752 p_commit_attribute4 );
753 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute5 = ' ||
754 p_commit_attribute5 );
755 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute6 = ' ||
756 p_commit_attribute6 );
757 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute7 = ' ||
758 p_commit_attribute7 );
759 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute8 = ' ||
760 p_commit_attribute8 );
761 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute9 = ' ||
762 p_commit_attribute9 );
763 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute10 = ' ||
764 p_commit_attribute10 );
765 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute11 = ' ||
766 p_commit_attribute11 );
767 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute12 = ' ||
768 p_commit_attribute12 );
769 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute13 = ' ||
770 p_commit_attribute13 );
771 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute14 = ' ||
772 p_commit_attribute14 );
773 arp_util.debug('insert_header_cover: ' || 'p_commit_attribute15 = ' ||
774 p_commit_attribute15 );
775 arp_util.debug('insert_header_cover: ' || 'p_ctl_default_ussgl_trx_code = ' ||
776 p_ctl_default_ussgl_trx_code );
777 arp_util.debug('insert_header_cover: ' || 'p_old_trx_number = ' ||
778 p_old_trx_number );
779 END IF;
780 */
781
782 arp_process_header.insert_header(
783 p_form_name,
784 p_form_version,
785 l_trx_rec,
786 p_trx_class,
787 p_gl_date,
788 p_term_in_use_flag,
789 l_commit_rec,
790 p_new_trx_number,
791 p_new_customer_trx_id,
792 p_new_customer_trx_line_id,
793 p_new_row_id,
794 p_status,
795 p_receivable_ccid);
796
797
798 IF PG_DEBUG in ('Y', 'C') THEN
799 arp_util.debug('arp_process_header_insrt_cover.insert_header_cover()-');
800 END IF;
801
802 EXCEPTION
803 WHEN OTHERS THEN
804 IF PG_DEBUG in ('Y', 'C') THEN
805 arp_util.debug('insert_header_cover: ' ||
806 'EXCEPTION: arp_process_header_insrt_cover.insert_header_cover()');
807 END IF;
808 RAISE;
809
810 END insert_header_cover;
811
812
813 END ARP_PROCESS_HEADER_INSRT_COVER;