[Home] [Help]
PACKAGE BODY: APPS.AR_EBI_INVOICE_PUB
Source
1 PACKAGE BODY AR_EBI_INVOICE_PUB AS
2 /* $Header: AREIINVB.pls 120.4 2009/02/17 11:48:38 rsamanta noship $ */
3
4 /************************************************************************************
5 -- API name : ar_get_trx_type
6 -- Type : Private
7 -- Function :
8 -- This API is used to querry transaction type from transaction name
9 --
10 ************************************************************************************/
11 PROCEDURE ar_get_trx_type
12 ( p_cust_trx_type_name IN VARCHAR2
13 , p_org_id IN NUMBER
14 , x_trx_type OUT NOCOPY VARCHAR2
15 , x_err_msg OUT NOCOPY VARCHAR2
16 , x_return_status OUT NOCOPY VARCHAR2
17 ) AS
18 CURSOR c_cust_trx_types IS
19 SELECT type
20 FROM ra_cust_trx_types_all
21 WHERE name = p_cust_trx_type_name
22 AND org_id = p_org_id;
23
24 BEGIN
25 x_return_status := FND_API.G_RET_STS_SUCCESS;
26 IF c_cust_trx_types%ISOPEN THEN
27 CLOSE c_cust_trx_types;
28 END IF;
29
30 OPEN c_cust_trx_types;
31 FETCH c_cust_trx_types into x_trx_type;
32 IF c_cust_trx_types%NOTFOUND THEN
33 x_trx_type := NULL;
34 END IF;
35 CLOSE c_cust_trx_types;
36 EXCEPTION
37 WHEN OTHERS THEN
38 IF c_cust_trx_types%ISOPEN THEN
39 CLOSE c_cust_trx_types;
40 END IF;
41 x_trx_type := NULL;
42 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
43 x_err_msg := SQLERRM ||' at EBI_AR_PKG.ar_get_trx_type ';
44 END ar_get_trx_type;
45
46 /************************************************************************************
47 -- API name : ar_invoice_submission
48 -- Type : Public
49 -- Function :
50 -- This API is used to submit Auto Invoice from AIA Layer
51 --
52 ************************************************************************************/
53 PROCEDURE ar_invoice_submission
54 ( p_lines_all IN AR_EBI_RA_INT_LINES_ALL_LIST
55 , p_distributions IN AR_EBI_RA_INT_DIST_LIST
56 , p_salescredits IN AR_EBI_RA_INT_SALESCREDIT_LIST
57 , p_run_autoinvoice_cp IN VARCHAR2 := FND_API.g_true
58 , p_commit IN VARCHAR2 := FND_API.g_false
59 , x_conc_req_ids OUT NOCOPY FND_TABLE_OF_NUMBER
60 , x_err_msg OUT NOCOPY VARCHAR2
61 , x_return_status OUT NOCOPY VARCHAR2
62 ) AS
63
64 l_bill_to_address_id NUMBER;
65 l_ship_to_address_id NUMBER;
66 l_payment_term_id NUMBER;
67 l_conversion_type VARCHAR2(30);
68 l_conversion_date DATE;
69 l_conversion_rate NUMBER;
70
71 l_default_bill_to_address_id NUMBER;
72 l_default_ship_to_address_id NUMBER;
73 l_default_payment_term_id NUMBER;
74 l_default_conversion_type VARCHAR2(30);
75 l_default_conversion_date DATE;
76 l_default_conversion_rate NUMBER;
77
78 l_msg_count NUMBER;
79 l_conc_req_id NUMBER;
80
81 l_batch_source_id NUMBER(15);
82
83 l_trx_type VARCHAR2(20);
84 BEGIN
85 x_return_status := FND_API.G_RET_STS_SUCCESS;
86
87 SAVEPOINT ar_ebi_invoice_sub_save_pnt;
88 FND_MSG_PUB.initialize;
89
90 /* Inserting into ra_interface_lines_all Tables */
91 FOR r_lines_all IN
92 (SELECT INTERFACE_LINE_ID ,
93 INTERFACE_LINE_CONTEXT ,
94 INTERFACE_LINE_ATTRIBUTE1 ,
95 INTERFACE_LINE_ATTRIBUTE2 ,
96 INTERFACE_LINE_ATTRIBUTE3 ,
97 INTERFACE_LINE_ATTRIBUTE4 ,
98 INTERFACE_LINE_ATTRIBUTE5 ,
99 INTERFACE_LINE_ATTRIBUTE6 ,
100 INTERFACE_LINE_ATTRIBUTE7 ,
101 INTERFACE_LINE_ATTRIBUTE8 ,
102 BATCH_SOURCE_NAME ,
103 SET_OF_BOOKS_ID ,
104 LINE_TYPE ,
105 DESCRIPTION ,
106 CURRENCY_CODE ,
107 AMOUNT ,
108 CUST_TRX_TYPE_NAME ,
109 CUST_TRX_TYPE_ID ,
110 TERM_NAME ,
111 TERM_ID ,
112 ORIG_SYSTEM_BATCH_NAME ,
113 ORIG_SYSTEM_BILL_CUSTOMER_REF ,
114 ORIG_SYSTEM_BILL_CUSTOMER_ID ,
115 ORIG_SYSTEM_BILL_ADDRESS_REF ,
116 ORIG_SYSTEM_BILL_ADDRESS_ID ,
117 ORIG_SYSTEM_BILL_CONTACT_REF ,
118 ORIG_SYSTEM_BILL_CONTACT_ID ,
119 ORIG_SYSTEM_SHIP_CUSTOMER_REF ,
120 ORIG_SYSTEM_SHIP_CUSTOMER_ID ,
121 ORIG_SYSTEM_SHIP_ADDRESS_REF ,
122 ORIG_SYSTEM_SHIP_ADDRESS_ID ,
123 ORIG_SYSTEM_SHIP_CONTACT_REF ,
124 ORIG_SYSTEM_SHIP_CONTACT_ID ,
125 ORIG_SYSTEM_SOLD_CUSTOMER_REF ,
126 ORIG_SYSTEM_SOLD_CUSTOMER_ID ,
127 LINK_TO_LINE_ID ,
128 LINK_TO_LINE_CONTEXT ,
129 LINK_TO_LINE_ATTRIBUTE1 ,
130 LINK_TO_LINE_ATTRIBUTE2 ,
131 LINK_TO_LINE_ATTRIBUTE3 ,
132 LINK_TO_LINE_ATTRIBUTE4 ,
133 LINK_TO_LINE_ATTRIBUTE5 ,
134 LINK_TO_LINE_ATTRIBUTE6 ,
135 LINK_TO_LINE_ATTRIBUTE7 ,
136 RECEIPT_METHOD_NAME ,
137 RECEIPT_METHOD_ID ,
138 CONVERSION_TYPE ,
139 CONVERSION_DATE ,
140 CONVERSION_RATE ,
141 CUSTOMER_TRX_ID ,
142 TRX_DATE ,
143 GL_DATE ,
144 DOCUMENT_NUMBER ,
145 TRX_NUMBER ,
146 LINE_NUMBER ,
147 QUANTITY ,
148 QUANTITY_ORDERED ,
149 UNIT_SELLING_PRICE ,
150 UNIT_STANDARD_PRICE ,
151 PRINTING_OPTION ,
152 INTERFACE_STATUS ,
153 REQUEST_ID ,
154 RELATED_BATCH_SOURCE_NAME ,
155 RELATED_TRX_NUMBER ,
156 RELATED_CUSTOMER_TRX_ID ,
157 PREVIOUS_CUSTOMER_TRX_ID ,
158 CREDIT_METHOD_FOR_ACCT_RULE ,
159 CREDIT_METHOD_FOR_INSTALLMENTS,
160 REASON_CODE ,
161 TAX_RATE ,
162 TAX_CODE ,
163 TAX_PRECEDENCE ,
164 EXCEPTION_ID ,
165 EXEMPTION_ID ,
166 SHIP_DATE_ACTUAL ,
167 FOB_POINT ,
168 SHIP_VIA ,
169 WAYBILL_NUMBER ,
170 INVOICING_RULE_NAME ,
171 INVOICING_RULE_ID ,
172 ACCOUNTING_RULE_NAME ,
173 ACCOUNTING_RULE_ID ,
174 ACCOUNTING_RULE_DURATION ,
175 RULE_START_DATE ,
176 PRIMARY_SALESREP_NUMBER ,
177 PRIMARY_SALESREP_ID ,
178 SALES_ORDER ,
179 SALES_ORDER_LINE ,
180 SALES_ORDER_DATE ,
181 SALES_ORDER_SOURCE ,
182 SALES_ORDER_REVISION ,
183 PURCHASE_ORDER ,
184 PURCHASE_ORDER_REVISION ,
185 PURCHASE_ORDER_DATE ,
186 AGREEMENT_NAME ,
187 AGREEMENT_ID ,
188 MEMO_LINE_NAME ,
189 MEMO_LINE_ID ,
190 INVENTORY_ITEM_ID ,
191 MTL_SYSTEM_ITEMS_SEG1 ,
192 MTL_SYSTEM_ITEMS_SEG2 ,
193 MTL_SYSTEM_ITEMS_SEG3 ,
194 MTL_SYSTEM_ITEMS_SEG4 ,
195 MTL_SYSTEM_ITEMS_SEG5 ,
196 MTL_SYSTEM_ITEMS_SEG6 ,
197 MTL_SYSTEM_ITEMS_SEG7 ,
198 MTL_SYSTEM_ITEMS_SEG8 ,
199 MTL_SYSTEM_ITEMS_SEG9 ,
200 MTL_SYSTEM_ITEMS_SEG10 ,
201 MTL_SYSTEM_ITEMS_SEG11 ,
202 MTL_SYSTEM_ITEMS_SEG12 ,
203 MTL_SYSTEM_ITEMS_SEG13 ,
204 MTL_SYSTEM_ITEMS_SEG14 ,
205 MTL_SYSTEM_ITEMS_SEG15 ,
206 MTL_SYSTEM_ITEMS_SEG16 ,
207 MTL_SYSTEM_ITEMS_SEG17 ,
208 MTL_SYSTEM_ITEMS_SEG18 ,
209 MTL_SYSTEM_ITEMS_SEG19 ,
210 MTL_SYSTEM_ITEMS_SEG20 ,
211 REFERENCE_LINE_ID ,
212 REFERENCE_LINE_CONTEXT ,
213 REFERENCE_LINE_ATTRIBUTE1 ,
214 REFERENCE_LINE_ATTRIBUTE2 ,
215 REFERENCE_LINE_ATTRIBUTE3 ,
216 REFERENCE_LINE_ATTRIBUTE4 ,
217 REFERENCE_LINE_ATTRIBUTE5 ,
218 REFERENCE_LINE_ATTRIBUTE6 ,
219 REFERENCE_LINE_ATTRIBUTE7 ,
220 TERRITORY_ID ,
221 TERRITORY_SEGMENT1 ,
222 TERRITORY_SEGMENT2 ,
223 TERRITORY_SEGMENT3 ,
224 TERRITORY_SEGMENT4 ,
225 TERRITORY_SEGMENT5 ,
226 TERRITORY_SEGMENT6 ,
227 TERRITORY_SEGMENT7 ,
228 TERRITORY_SEGMENT8 ,
229 TERRITORY_SEGMENT9 ,
230 TERRITORY_SEGMENT10 ,
231 TERRITORY_SEGMENT11 ,
232 TERRITORY_SEGMENT12 ,
233 TERRITORY_SEGMENT13 ,
234 TERRITORY_SEGMENT14 ,
235 TERRITORY_SEGMENT15 ,
236 TERRITORY_SEGMENT16 ,
237 TERRITORY_SEGMENT17 ,
238 TERRITORY_SEGMENT18 ,
239 TERRITORY_SEGMENT19 ,
240 TERRITORY_SEGMENT20 ,
241 ATTRIBUTE_CATEGORY ,
242 ATTRIBUTE1 ,
243 ATTRIBUTE2 ,
244 ATTRIBUTE3 ,
245 ATTRIBUTE4 ,
246 ATTRIBUTE5 ,
247 ATTRIBUTE6 ,
248 ATTRIBUTE7 ,
249 ATTRIBUTE8 ,
250 ATTRIBUTE9 ,
251 ATTRIBUTE10 ,
252 ATTRIBUTE11 ,
253 ATTRIBUTE12 ,
254 ATTRIBUTE13 ,
255 ATTRIBUTE14 ,
256 ATTRIBUTE15 ,
257 HEADER_ATTRIBUTE_CATEGORY ,
258 HEADER_ATTRIBUTE1 ,
259 HEADER_ATTRIBUTE2 ,
260 HEADER_ATTRIBUTE3 ,
261 HEADER_ATTRIBUTE4 ,
262 HEADER_ATTRIBUTE5 ,
263 HEADER_ATTRIBUTE6 ,
264 HEADER_ATTRIBUTE7 ,
265 HEADER_ATTRIBUTE8 ,
266 HEADER_ATTRIBUTE9 ,
267 HEADER_ATTRIBUTE10 ,
268 HEADER_ATTRIBUTE11 ,
269 HEADER_ATTRIBUTE12 ,
270 HEADER_ATTRIBUTE13 ,
271 HEADER_ATTRIBUTE14 ,
272 HEADER_ATTRIBUTE15 ,
273 COMMENTS ,
274 INTERNAL_NOTES ,
275 INITIAL_CUSTOMER_TRX_ID ,
276 USSGL_TRANSACTION_CODE_CONTEXT,
277 USSGL_TRANSACTION_CODE ,
278 ACCTD_AMOUNT ,
279 CUSTOMER_BANK_ACCOUNT_ID ,
280 CUSTOMER_BANK_ACCOUNT_NAME ,
281 UOM_CODE ,
282 UOM_NAME ,
283 DOCUMENT_NUMBER_SEQUENCE_ID ,
284 LINK_TO_LINE_ATTRIBUTE10 ,
285 LINK_TO_LINE_ATTRIBUTE11 ,
286 LINK_TO_LINE_ATTRIBUTE12 ,
287 LINK_TO_LINE_ATTRIBUTE13 ,
288 LINK_TO_LINE_ATTRIBUTE14 ,
289 LINK_TO_LINE_ATTRIBUTE15 ,
290 LINK_TO_LINE_ATTRIBUTE8 ,
291 LINK_TO_LINE_ATTRIBUTE9 ,
292 REFERENCE_LINE_ATTRIBUTE10 ,
293 REFERENCE_LINE_ATTRIBUTE11 ,
294 REFERENCE_LINE_ATTRIBUTE12 ,
295 REFERENCE_LINE_ATTRIBUTE13 ,
296 REFERENCE_LINE_ATTRIBUTE14 ,
297 REFERENCE_LINE_ATTRIBUTE15 ,
298 REFERENCE_LINE_ATTRIBUTE8 ,
299 REFERENCE_LINE_ATTRIBUTE9 ,
300 INTERFACE_LINE_ATTRIBUTE10 ,
301 INTERFACE_LINE_ATTRIBUTE11 ,
302 INTERFACE_LINE_ATTRIBUTE12 ,
303 INTERFACE_LINE_ATTRIBUTE13 ,
304 INTERFACE_LINE_ATTRIBUTE14 ,
305 INTERFACE_LINE_ATTRIBUTE15 ,
306 INTERFACE_LINE_ATTRIBUTE9 ,
307 VAT_TAX_ID ,
308 REASON_CODE_MEANING ,
309 LAST_PERIOD_TO_CREDIT ,
310 PAYING_CUSTOMER_ID ,
311 PAYING_SITE_USE_ID ,
312 TAX_EXEMPT_FLAG ,
313 TAX_EXEMPT_REASON_CODE ,
314 TAX_EXEMPT_REASON_CODE_MEANING,
315 TAX_EXEMPT_NUMBER ,
316 SALES_TAX_ID ,
317 CREATED_BY ,
318 CREATION_DATE ,
319 LAST_UPDATED_BY ,
320 LAST_UPDATE_DATE ,
321 LAST_UPDATE_LOGIN ,
322 LOCATION_SEGMENT_ID ,
323 MOVEMENT_ID ,
324 ORG_ID ,
325 AMOUNT_INCLUDES_TAX_FLAG ,
326 HEADER_GDF_ATTR_CATEGORY ,
327 HEADER_GDF_ATTRIBUTE1 ,
328 HEADER_GDF_ATTRIBUTE2 ,
329 HEADER_GDF_ATTRIBUTE3 ,
330 HEADER_GDF_ATTRIBUTE4 ,
331 HEADER_GDF_ATTRIBUTE5 ,
332 HEADER_GDF_ATTRIBUTE6 ,
333 HEADER_GDF_ATTRIBUTE7 ,
334 HEADER_GDF_ATTRIBUTE8 ,
335 HEADER_GDF_ATTRIBUTE9 ,
336 HEADER_GDF_ATTRIBUTE10 ,
337 HEADER_GDF_ATTRIBUTE11 ,
338 HEADER_GDF_ATTRIBUTE12 ,
339 HEADER_GDF_ATTRIBUTE13 ,
340 HEADER_GDF_ATTRIBUTE14 ,
341 HEADER_GDF_ATTRIBUTE15 ,
342 HEADER_GDF_ATTRIBUTE16 ,
343 HEADER_GDF_ATTRIBUTE17 ,
344 HEADER_GDF_ATTRIBUTE18 ,
345 HEADER_GDF_ATTRIBUTE19 ,
346 HEADER_GDF_ATTRIBUTE20 ,
347 HEADER_GDF_ATTRIBUTE21 ,
348 HEADER_GDF_ATTRIBUTE22 ,
349 HEADER_GDF_ATTRIBUTE23 ,
350 HEADER_GDF_ATTRIBUTE24 ,
351 HEADER_GDF_ATTRIBUTE25 ,
352 HEADER_GDF_ATTRIBUTE26 ,
353 HEADER_GDF_ATTRIBUTE27 ,
354 HEADER_GDF_ATTRIBUTE28 ,
355 HEADER_GDF_ATTRIBUTE29 ,
356 HEADER_GDF_ATTRIBUTE30 ,
357 LINE_GDF_ATTR_CATEGORY ,
358 LINE_GDF_ATTRIBUTE1 ,
359 LINE_GDF_ATTRIBUTE2 ,
360 LINE_GDF_ATTRIBUTE3 ,
361 LINE_GDF_ATTRIBUTE4 ,
362 LINE_GDF_ATTRIBUTE5 ,
363 LINE_GDF_ATTRIBUTE6 ,
364 LINE_GDF_ATTRIBUTE7 ,
365 LINE_GDF_ATTRIBUTE8 ,
366 LINE_GDF_ATTRIBUTE9 ,
367 LINE_GDF_ATTRIBUTE10 ,
368 LINE_GDF_ATTRIBUTE11 ,
369 LINE_GDF_ATTRIBUTE12 ,
370 LINE_GDF_ATTRIBUTE13 ,
371 LINE_GDF_ATTRIBUTE14 ,
372 LINE_GDF_ATTRIBUTE15 ,
373 LINE_GDF_ATTRIBUTE16 ,
374 LINE_GDF_ATTRIBUTE17 ,
375 LINE_GDF_ATTRIBUTE18 ,
376 LINE_GDF_ATTRIBUTE19 ,
377 LINE_GDF_ATTRIBUTE20 ,
378 RESET_TRX_DATE_FLAG ,
379 PAYMENT_SERVER_ORDER_NUM ,
380 APPROVAL_CODE ,
381 ADDRESS_VERIFICATION_CODE ,
382 WAREHOUSE_ID ,
383 TRANSLATED_DESCRIPTION ,
384 CONS_BILLING_NUMBER ,
385 PROMISED_COMMITMENT_AMOUNT ,
386 PAYMENT_SET_ID ,
387 ORIGINAL_GL_DATE ,
388 CONTRACT_LINE_ID ,
389 CONTRACT_ID ,
390 SOURCE_DATA_KEY1 ,
391 SOURCE_DATA_KEY2 ,
392 SOURCE_DATA_KEY3 ,
393 SOURCE_DATA_KEY4 ,
394 SOURCE_DATA_KEY5 ,
395 INVOICED_LINE_ACCTG_LEVEL ,
396 OVERRIDE_AUTO_ACCOUNTING_FLAG ,
397 SOURCE_APPLICATION_ID ,
398 SOURCE_EVENT_CLASS_CODE ,
399 SOURCE_ENTITY_CODE ,
400 SOURCE_TRX_ID ,
401 SOURCE_TRX_LINE_ID ,
402 SOURCE_TRX_LINE_TYPE ,
403 SOURCE_TRX_DETAIL_TAX_LINE_ID ,
404 HISTORICAL_FLAG ,
405 TAX_REGIME_CODE ,
406 TAX ,
407 TAX_STATUS_CODE ,
408 TAX_RATE_CODE ,
409 TAX_JURISDICTION_CODE ,
410 TAXABLE_AMOUNT ,
411 TAXABLE_FLAG ,
412 LEGAL_ENTITY_ID ,
413 PARENT_LINE_ID ,
414 DEFERRAL_EXCLUSION_FLAG ,
415 PAYMENT_TRXN_EXTENSION_ID ,
416 RULE_END_DATE ,
417 PAYMENT_ATTRIBUTES ,
418 APPLICATION_ID ,
419 BILLING_DATE
420 FROM TABLE(p_lines_all)
421 )
422 LOOP
423
424 l_bill_to_address_id := r_lines_all.ORIG_SYSTEM_BILL_ADDRESS_ID;
425 l_ship_to_address_id := r_lines_all.ORIG_SYSTEM_SHIP_ADDRESS_ID;
426 l_payment_term_id := r_lines_all.TERM_ID;
427 l_conversion_type := r_lines_all.CONVERSION_TYPE;
428 l_conversion_date := r_lines_all.CONVERSION_DATE;
429 l_conversion_rate := r_lines_all.CONVERSION_RATE;
430
431
432 AR_AI_INTEG_PKG.DEFAULT_ATTRIBUTES(
433 p_org_id => r_lines_all.ORG_ID,
434 p_bill_to_customer_account_id => r_lines_all.ORIG_SYSTEM_BILL_CUSTOMER_ID,
435 p_ship_to_customer_account_id => r_lines_all.ORIG_SYSTEM_SHIP_CUSTOMER_ID,
436 p_currency_code => r_lines_all.CURRENCY_CODE,
437 x_bill_to_address_id => l_default_bill_to_address_id,
438 x_ship_to_address_id => l_default_ship_to_address_id,
439 x_payment_term_id => l_default_payment_term_id,
440 x_conversion_type => l_default_conversion_type,
441 x_conversion_date => l_default_conversion_date,
442 x_conversion_rate => l_default_conversion_rate,
443 x_return_status => x_return_status,
444 x_msg_data => x_err_msg
445 );
446
447 IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
448 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449 END IF;
450
451 IF(l_bill_to_address_id IS NULL OR l_bill_to_address_id = FND_API.G_MISS_NUM) THEN
452 l_bill_to_address_id := l_default_bill_to_address_id;
453 END IF;
454
455 IF(l_ship_to_address_id IS NULL OR l_ship_to_address_id = FND_API.G_MISS_NUM) THEN
456 l_ship_to_address_id := l_default_ship_to_address_id;
457 END IF;
458
459 IF(l_payment_term_id IS NULL OR l_payment_term_id = FND_API.G_MISS_NUM) THEN
460
461 /* If the Trx name is null no need to default the l_payment_term_id value*/
462 IF(r_lines_all.CUST_TRX_TYPE_NAME IS NOT NULL) THEN
463
464 AR_EBI_INVOICE_PUB.ar_get_trx_type(
465 p_cust_trx_type_name => r_lines_all.CUST_TRX_TYPE_NAME
466 ,p_org_id => r_lines_all.ORG_ID
467 ,x_trx_type => l_trx_type
468 ,x_return_status => x_return_status
469 ,x_err_msg => x_err_msg
470 );
471
472 IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
473 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474 END IF;
475
476 /* Trx type is Credit Memo We should not default the values*/
477 IF(l_trx_type IS NOT NULL AND l_trx_type <> 'CM') THEN
478 l_payment_term_id := l_default_payment_term_id;
479 END IF;
480 END IF;
481 END IF;
482
483 IF(l_conversion_type IS NULL OR l_conversion_type = FND_API.G_MISS_CHAR) THEN
484 l_conversion_type := l_default_conversion_type;
485 END IF;
486
487 IF(l_conversion_date IS NULL OR l_conversion_date = FND_API.G_MISS_DATE) THEN
488 l_conversion_date := l_default_conversion_date;
489 END IF;
490
491 IF(l_conversion_rate IS NULL OR l_conversion_rate = FND_API.G_MISS_NUM) THEN
492 l_conversion_rate := l_default_conversion_rate;
493 END IF;
494
495
496 INSERT
497 INTO ra_interface_lines_all
498 (
499 INTERFACE_LINE_ID ,
500 INTERFACE_LINE_CONTEXT ,
501 INTERFACE_LINE_ATTRIBUTE1 ,
502 INTERFACE_LINE_ATTRIBUTE2 ,
503 INTERFACE_LINE_ATTRIBUTE3 ,
504 INTERFACE_LINE_ATTRIBUTE4 ,
505 INTERFACE_LINE_ATTRIBUTE5 ,
506 INTERFACE_LINE_ATTRIBUTE6 ,
507 INTERFACE_LINE_ATTRIBUTE7 ,
508 INTERFACE_LINE_ATTRIBUTE8 ,
509 BATCH_SOURCE_NAME ,
510 SET_OF_BOOKS_ID ,
511 LINE_TYPE ,
512 DESCRIPTION ,
513 CURRENCY_CODE ,
514 AMOUNT ,
515 CUST_TRX_TYPE_NAME ,
516 CUST_TRX_TYPE_ID ,
517 TERM_NAME ,
518 TERM_ID ,
519 ORIG_SYSTEM_BATCH_NAME ,
520 ORIG_SYSTEM_BILL_CUSTOMER_REF ,
521 ORIG_SYSTEM_BILL_CUSTOMER_ID ,
522 ORIG_SYSTEM_BILL_ADDRESS_REF ,
523 ORIG_SYSTEM_BILL_ADDRESS_ID ,
524 ORIG_SYSTEM_BILL_CONTACT_REF ,
525 ORIG_SYSTEM_BILL_CONTACT_ID ,
526 ORIG_SYSTEM_SHIP_CUSTOMER_REF ,
527 ORIG_SYSTEM_SHIP_CUSTOMER_ID ,
528 ORIG_SYSTEM_SHIP_ADDRESS_REF ,
529 ORIG_SYSTEM_SHIP_ADDRESS_ID ,
530 ORIG_SYSTEM_SHIP_CONTACT_REF ,
531 ORIG_SYSTEM_SHIP_CONTACT_ID ,
532 ORIG_SYSTEM_SOLD_CUSTOMER_REF ,
533 ORIG_SYSTEM_SOLD_CUSTOMER_ID ,
534 LINK_TO_LINE_ID ,
535 LINK_TO_LINE_CONTEXT ,
536 LINK_TO_LINE_ATTRIBUTE1 ,
537 LINK_TO_LINE_ATTRIBUTE2 ,
538 LINK_TO_LINE_ATTRIBUTE3 ,
539 LINK_TO_LINE_ATTRIBUTE4 ,
540 LINK_TO_LINE_ATTRIBUTE5 ,
541 LINK_TO_LINE_ATTRIBUTE6 ,
542 LINK_TO_LINE_ATTRIBUTE7 ,
543 RECEIPT_METHOD_NAME ,
544 RECEIPT_METHOD_ID ,
545 CONVERSION_TYPE ,
546 CONVERSION_DATE ,
547 CONVERSION_RATE ,
548 CUSTOMER_TRX_ID ,
549 TRX_DATE ,
550 GL_DATE ,
551 DOCUMENT_NUMBER ,
552 TRX_NUMBER ,
553 LINE_NUMBER ,
554 QUANTITY ,
555 QUANTITY_ORDERED ,
556 UNIT_SELLING_PRICE ,
557 UNIT_STANDARD_PRICE ,
558 PRINTING_OPTION ,
559 INTERFACE_STATUS ,
560 REQUEST_ID ,
561 RELATED_BATCH_SOURCE_NAME ,
562 RELATED_TRX_NUMBER ,
563 RELATED_CUSTOMER_TRX_ID ,
564 PREVIOUS_CUSTOMER_TRX_ID ,
565 CREDIT_METHOD_FOR_ACCT_RULE ,
566 CREDIT_METHOD_FOR_INSTALLMENTS,
567 REASON_CODE ,
568 TAX_RATE ,
569 TAX_CODE ,
570 TAX_PRECEDENCE ,
571 EXCEPTION_ID ,
572 EXEMPTION_ID ,
573 SHIP_DATE_ACTUAL ,
574 FOB_POINT ,
575 SHIP_VIA ,
576 WAYBILL_NUMBER ,
577 INVOICING_RULE_NAME ,
578 INVOICING_RULE_ID ,
579 ACCOUNTING_RULE_NAME ,
580 ACCOUNTING_RULE_ID ,
581 ACCOUNTING_RULE_DURATION ,
582 RULE_START_DATE ,
583 PRIMARY_SALESREP_NUMBER ,
584 PRIMARY_SALESREP_ID ,
585 SALES_ORDER ,
586 SALES_ORDER_LINE ,
587 SALES_ORDER_DATE ,
588 SALES_ORDER_SOURCE ,
589 SALES_ORDER_REVISION ,
590 PURCHASE_ORDER ,
591 PURCHASE_ORDER_REVISION ,
592 PURCHASE_ORDER_DATE ,
593 AGREEMENT_NAME ,
594 AGREEMENT_ID ,
595 MEMO_LINE_NAME ,
596 MEMO_LINE_ID ,
597 INVENTORY_ITEM_ID ,
598 MTL_SYSTEM_ITEMS_SEG1 ,
599 MTL_SYSTEM_ITEMS_SEG2 ,
600 MTL_SYSTEM_ITEMS_SEG3 ,
601 MTL_SYSTEM_ITEMS_SEG4 ,
602 MTL_SYSTEM_ITEMS_SEG5 ,
603 MTL_SYSTEM_ITEMS_SEG6 ,
604 MTL_SYSTEM_ITEMS_SEG7 ,
605 MTL_SYSTEM_ITEMS_SEG8 ,
606 MTL_SYSTEM_ITEMS_SEG9 ,
607 MTL_SYSTEM_ITEMS_SEG10 ,
608 MTL_SYSTEM_ITEMS_SEG11 ,
609 MTL_SYSTEM_ITEMS_SEG12 ,
610 MTL_SYSTEM_ITEMS_SEG13 ,
611 MTL_SYSTEM_ITEMS_SEG14 ,
612 MTL_SYSTEM_ITEMS_SEG15 ,
613 MTL_SYSTEM_ITEMS_SEG16 ,
614 MTL_SYSTEM_ITEMS_SEG17 ,
615 MTL_SYSTEM_ITEMS_SEG18 ,
616 MTL_SYSTEM_ITEMS_SEG19 ,
617 MTL_SYSTEM_ITEMS_SEG20 ,
618 REFERENCE_LINE_ID ,
619 REFERENCE_LINE_CONTEXT ,
620 REFERENCE_LINE_ATTRIBUTE1 ,
621 REFERENCE_LINE_ATTRIBUTE2 ,
622 REFERENCE_LINE_ATTRIBUTE3 ,
623 REFERENCE_LINE_ATTRIBUTE4 ,
624 REFERENCE_LINE_ATTRIBUTE5 ,
625 REFERENCE_LINE_ATTRIBUTE6 ,
626 REFERENCE_LINE_ATTRIBUTE7 ,
627 TERRITORY_ID ,
628 TERRITORY_SEGMENT1 ,
629 TERRITORY_SEGMENT2 ,
630 TERRITORY_SEGMENT3 ,
631 TERRITORY_SEGMENT4 ,
632 TERRITORY_SEGMENT5 ,
633 TERRITORY_SEGMENT6 ,
634 TERRITORY_SEGMENT7 ,
635 TERRITORY_SEGMENT8 ,
636 TERRITORY_SEGMENT9 ,
637 TERRITORY_SEGMENT10 ,
638 TERRITORY_SEGMENT11 ,
639 TERRITORY_SEGMENT12 ,
640 TERRITORY_SEGMENT13 ,
641 TERRITORY_SEGMENT14 ,
642 TERRITORY_SEGMENT15 ,
643 TERRITORY_SEGMENT16 ,
644 TERRITORY_SEGMENT17 ,
645 TERRITORY_SEGMENT18 ,
646 TERRITORY_SEGMENT19 ,
647 TERRITORY_SEGMENT20 ,
648 ATTRIBUTE_CATEGORY ,
649 ATTRIBUTE1 ,
650 ATTRIBUTE2 ,
651 ATTRIBUTE3 ,
652 ATTRIBUTE4 ,
653 ATTRIBUTE5 ,
654 ATTRIBUTE6 ,
655 ATTRIBUTE7 ,
656 ATTRIBUTE8 ,
657 ATTRIBUTE9 ,
658 ATTRIBUTE10 ,
659 ATTRIBUTE11 ,
660 ATTRIBUTE12 ,
661 ATTRIBUTE13 ,
662 ATTRIBUTE14 ,
663 ATTRIBUTE15 ,
664 HEADER_ATTRIBUTE_CATEGORY ,
665 HEADER_ATTRIBUTE1 ,
666 HEADER_ATTRIBUTE2 ,
667 HEADER_ATTRIBUTE3 ,
668 HEADER_ATTRIBUTE4 ,
669 HEADER_ATTRIBUTE5 ,
670 HEADER_ATTRIBUTE6 ,
671 HEADER_ATTRIBUTE7 ,
672 HEADER_ATTRIBUTE8 ,
673 HEADER_ATTRIBUTE9 ,
674 HEADER_ATTRIBUTE10 ,
675 HEADER_ATTRIBUTE11 ,
676 HEADER_ATTRIBUTE12 ,
677 HEADER_ATTRIBUTE13 ,
678 HEADER_ATTRIBUTE14 ,
679 HEADER_ATTRIBUTE15 ,
680 COMMENTS ,
681 INTERNAL_NOTES ,
682 INITIAL_CUSTOMER_TRX_ID ,
683 USSGL_TRANSACTION_CODE_CONTEXT,
684 USSGL_TRANSACTION_CODE ,
685 ACCTD_AMOUNT ,
686 CUSTOMER_BANK_ACCOUNT_ID ,
687 CUSTOMER_BANK_ACCOUNT_NAME ,
688 UOM_CODE ,
689 UOM_NAME ,
690 DOCUMENT_NUMBER_SEQUENCE_ID ,
691 LINK_TO_LINE_ATTRIBUTE10 ,
692 LINK_TO_LINE_ATTRIBUTE11 ,
693 LINK_TO_LINE_ATTRIBUTE12 ,
694 LINK_TO_LINE_ATTRIBUTE13 ,
695 LINK_TO_LINE_ATTRIBUTE14 ,
696 LINK_TO_LINE_ATTRIBUTE15 ,
697 LINK_TO_LINE_ATTRIBUTE8 ,
698 LINK_TO_LINE_ATTRIBUTE9 ,
699 REFERENCE_LINE_ATTRIBUTE10 ,
700 REFERENCE_LINE_ATTRIBUTE11 ,
701 REFERENCE_LINE_ATTRIBUTE12 ,
702 REFERENCE_LINE_ATTRIBUTE13 ,
703 REFERENCE_LINE_ATTRIBUTE14 ,
704 REFERENCE_LINE_ATTRIBUTE15 ,
705 REFERENCE_LINE_ATTRIBUTE8 ,
706 REFERENCE_LINE_ATTRIBUTE9 ,
707 INTERFACE_LINE_ATTRIBUTE10 ,
708 INTERFACE_LINE_ATTRIBUTE11 ,
709 INTERFACE_LINE_ATTRIBUTE12 ,
710 INTERFACE_LINE_ATTRIBUTE13 ,
711 INTERFACE_LINE_ATTRIBUTE14 ,
712 INTERFACE_LINE_ATTRIBUTE15 ,
713 INTERFACE_LINE_ATTRIBUTE9 ,
714 VAT_TAX_ID ,
715 REASON_CODE_MEANING ,
716 LAST_PERIOD_TO_CREDIT ,
717 PAYING_CUSTOMER_ID ,
718 PAYING_SITE_USE_ID ,
719 TAX_EXEMPT_FLAG ,
720 TAX_EXEMPT_REASON_CODE ,
721 TAX_EXEMPT_REASON_CODE_MEANING,
722 TAX_EXEMPT_NUMBER ,
723 SALES_TAX_ID ,
724 CREATED_BY ,
725 CREATION_DATE ,
726 LAST_UPDATED_BY ,
727 LAST_UPDATE_DATE ,
728 LAST_UPDATE_LOGIN ,
729 LOCATION_SEGMENT_ID ,
730 MOVEMENT_ID ,
731 ORG_ID ,
732 AMOUNT_INCLUDES_TAX_FLAG ,
733 HEADER_GDF_ATTR_CATEGORY ,
734 HEADER_GDF_ATTRIBUTE1 ,
735 HEADER_GDF_ATTRIBUTE2 ,
736 HEADER_GDF_ATTRIBUTE3 ,
737 HEADER_GDF_ATTRIBUTE4 ,
738 HEADER_GDF_ATTRIBUTE5 ,
739 HEADER_GDF_ATTRIBUTE6 ,
740 HEADER_GDF_ATTRIBUTE7 ,
741 HEADER_GDF_ATTRIBUTE8 ,
742 HEADER_GDF_ATTRIBUTE9 ,
743 HEADER_GDF_ATTRIBUTE10 ,
744 HEADER_GDF_ATTRIBUTE11 ,
745 HEADER_GDF_ATTRIBUTE12 ,
746 HEADER_GDF_ATTRIBUTE13 ,
747 HEADER_GDF_ATTRIBUTE14 ,
748 HEADER_GDF_ATTRIBUTE15 ,
749 HEADER_GDF_ATTRIBUTE16 ,
750 HEADER_GDF_ATTRIBUTE17 ,
751 HEADER_GDF_ATTRIBUTE18 ,
752 HEADER_GDF_ATTRIBUTE19 ,
753 HEADER_GDF_ATTRIBUTE20 ,
754 HEADER_GDF_ATTRIBUTE21 ,
755 HEADER_GDF_ATTRIBUTE22 ,
756 HEADER_GDF_ATTRIBUTE23 ,
757 HEADER_GDF_ATTRIBUTE24 ,
758 HEADER_GDF_ATTRIBUTE25 ,
759 HEADER_GDF_ATTRIBUTE26 ,
760 HEADER_GDF_ATTRIBUTE27 ,
761 HEADER_GDF_ATTRIBUTE28 ,
762 HEADER_GDF_ATTRIBUTE29 ,
763 HEADER_GDF_ATTRIBUTE30 ,
764 LINE_GDF_ATTR_CATEGORY ,
765 LINE_GDF_ATTRIBUTE1 ,
766 LINE_GDF_ATTRIBUTE2 ,
767 LINE_GDF_ATTRIBUTE3 ,
768 LINE_GDF_ATTRIBUTE4 ,
769 LINE_GDF_ATTRIBUTE5 ,
770 LINE_GDF_ATTRIBUTE6 ,
771 LINE_GDF_ATTRIBUTE7 ,
772 LINE_GDF_ATTRIBUTE8 ,
773 LINE_GDF_ATTRIBUTE9 ,
774 LINE_GDF_ATTRIBUTE10 ,
775 LINE_GDF_ATTRIBUTE11 ,
776 LINE_GDF_ATTRIBUTE12 ,
777 LINE_GDF_ATTRIBUTE13 ,
778 LINE_GDF_ATTRIBUTE14 ,
779 LINE_GDF_ATTRIBUTE15 ,
780 LINE_GDF_ATTRIBUTE16 ,
781 LINE_GDF_ATTRIBUTE17 ,
782 LINE_GDF_ATTRIBUTE18 ,
783 LINE_GDF_ATTRIBUTE19 ,
784 LINE_GDF_ATTRIBUTE20 ,
785 RESET_TRX_DATE_FLAG ,
786 PAYMENT_SERVER_ORDER_NUM ,
787 APPROVAL_CODE ,
788 ADDRESS_VERIFICATION_CODE ,
789 WAREHOUSE_ID ,
790 TRANSLATED_DESCRIPTION ,
791 CONS_BILLING_NUMBER ,
792 PROMISED_COMMITMENT_AMOUNT ,
793 PAYMENT_SET_ID ,
794 ORIGINAL_GL_DATE ,
795 CONTRACT_LINE_ID ,
796 CONTRACT_ID ,
797 SOURCE_DATA_KEY1 ,
798 SOURCE_DATA_KEY2 ,
799 SOURCE_DATA_KEY3 ,
800 SOURCE_DATA_KEY4 ,
801 SOURCE_DATA_KEY5 ,
802 INVOICED_LINE_ACCTG_LEVEL ,
803 OVERRIDE_AUTO_ACCOUNTING_FLAG ,
804 SOURCE_APPLICATION_ID ,
805 SOURCE_EVENT_CLASS_CODE ,
806 SOURCE_ENTITY_CODE ,
807 SOURCE_TRX_ID ,
808 SOURCE_TRX_LINE_ID ,
809 SOURCE_TRX_LINE_TYPE ,
810 SOURCE_TRX_DETAIL_TAX_LINE_ID ,
811 HISTORICAL_FLAG ,
812 TAX_REGIME_CODE ,
813 TAX ,
814 TAX_STATUS_CODE ,
815 TAX_RATE_CODE ,
816 TAX_JURISDICTION_CODE ,
817 TAXABLE_AMOUNT ,
818 TAXABLE_FLAG ,
819 LEGAL_ENTITY_ID ,
820 PARENT_LINE_ID ,
821 DEFERRAL_EXCLUSION_FLAG ,
822 PAYMENT_TRXN_EXTENSION_ID ,
823 RULE_END_DATE ,
824 PAYMENT_ATTRIBUTES ,
825 APPLICATION_ID ,
826 BILLING_DATE
827 )
828 VALUES
829 (
830 r_lines_all.INTERFACE_LINE_ID ,
831 r_lines_all.INTERFACE_LINE_CONTEXT ,
832 r_lines_all.INTERFACE_LINE_ATTRIBUTE1 ,
833 r_lines_all.INTERFACE_LINE_ATTRIBUTE2 ,
834 r_lines_all.INTERFACE_LINE_ATTRIBUTE3 ,
835 r_lines_all.INTERFACE_LINE_ATTRIBUTE4 ,
836 r_lines_all.INTERFACE_LINE_ATTRIBUTE5 ,
837 r_lines_all.INTERFACE_LINE_ATTRIBUTE6 ,
838 r_lines_all.INTERFACE_LINE_ATTRIBUTE7 ,
839 r_lines_all.INTERFACE_LINE_ATTRIBUTE8 ,
840 r_lines_all.BATCH_SOURCE_NAME ,
841 r_lines_all.SET_OF_BOOKS_ID ,
842 r_lines_all.LINE_TYPE ,
843 r_lines_all.DESCRIPTION ,
844 r_lines_all.CURRENCY_CODE ,
845 r_lines_all.AMOUNT ,
846 r_lines_all.CUST_TRX_TYPE_NAME ,
847 r_lines_all.CUST_TRX_TYPE_ID ,
848 r_lines_all.TERM_NAME ,
849 l_payment_term_id ,
850 r_lines_all.ORIG_SYSTEM_BATCH_NAME ,
851 r_lines_all.ORIG_SYSTEM_BILL_CUSTOMER_REF ,
852 r_lines_all.ORIG_SYSTEM_BILL_CUSTOMER_ID ,
853 r_lines_all.ORIG_SYSTEM_BILL_ADDRESS_REF ,
854 l_bill_to_address_id ,
855 r_lines_all.ORIG_SYSTEM_BILL_CONTACT_REF ,
856 r_lines_all.ORIG_SYSTEM_BILL_CONTACT_ID ,
857 r_lines_all.ORIG_SYSTEM_SHIP_CUSTOMER_REF ,
858 r_lines_all.ORIG_SYSTEM_SHIP_CUSTOMER_ID ,
859 r_lines_all.ORIG_SYSTEM_SHIP_ADDRESS_REF ,
860 l_ship_to_address_id ,
861 r_lines_all.ORIG_SYSTEM_SHIP_CONTACT_REF ,
862 r_lines_all.ORIG_SYSTEM_SHIP_CONTACT_ID ,
863 r_lines_all.ORIG_SYSTEM_SOLD_CUSTOMER_REF ,
864 r_lines_all.ORIG_SYSTEM_SOLD_CUSTOMER_ID ,
865 r_lines_all.LINK_TO_LINE_ID ,
866 r_lines_all.LINK_TO_LINE_CONTEXT ,
867 r_lines_all.LINK_TO_LINE_ATTRIBUTE1 ,
868 r_lines_all.LINK_TO_LINE_ATTRIBUTE2 ,
869 r_lines_all.LINK_TO_LINE_ATTRIBUTE3 ,
870 r_lines_all.LINK_TO_LINE_ATTRIBUTE4 ,
871 r_lines_all.LINK_TO_LINE_ATTRIBUTE5 ,
872 r_lines_all.LINK_TO_LINE_ATTRIBUTE6 ,
873 r_lines_all.LINK_TO_LINE_ATTRIBUTE7 ,
874 r_lines_all.RECEIPT_METHOD_NAME ,
875 r_lines_all.RECEIPT_METHOD_ID ,
876 l_conversion_type ,
877 l_conversion_date ,
878 l_conversion_rate ,
879 r_lines_all.CUSTOMER_TRX_ID ,
880 r_lines_all.TRX_DATE ,
881 r_lines_all.GL_DATE ,
882 r_lines_all.DOCUMENT_NUMBER ,
883 r_lines_all.TRX_NUMBER ,
884 r_lines_all.LINE_NUMBER ,
885 r_lines_all.QUANTITY ,
886 r_lines_all.QUANTITY_ORDERED ,
887 r_lines_all.UNIT_SELLING_PRICE ,
888 r_lines_all.UNIT_STANDARD_PRICE ,
889 r_lines_all.PRINTING_OPTION ,
890 r_lines_all.INTERFACE_STATUS ,
891 r_lines_all.REQUEST_ID ,
892 r_lines_all.RELATED_BATCH_SOURCE_NAME ,
893 r_lines_all.RELATED_TRX_NUMBER ,
894 r_lines_all.RELATED_CUSTOMER_TRX_ID ,
895 r_lines_all.PREVIOUS_CUSTOMER_TRX_ID ,
896 r_lines_all.CREDIT_METHOD_FOR_ACCT_RULE ,
897 r_lines_all.CREDIT_METHOD_FOR_INSTALLMENTS,
898 r_lines_all.REASON_CODE ,
899 r_lines_all.TAX_RATE ,
900 r_lines_all.TAX_CODE ,
901 r_lines_all.TAX_PRECEDENCE ,
902 r_lines_all.EXCEPTION_ID ,
903 r_lines_all.EXEMPTION_ID ,
904 r_lines_all.SHIP_DATE_ACTUAL ,
905 r_lines_all.FOB_POINT ,
906 r_lines_all.SHIP_VIA ,
907 r_lines_all.WAYBILL_NUMBER ,
908 r_lines_all.INVOICING_RULE_NAME ,
909 r_lines_all.INVOICING_RULE_ID ,
910 r_lines_all.ACCOUNTING_RULE_NAME ,
911 r_lines_all.ACCOUNTING_RULE_ID ,
912 r_lines_all.ACCOUNTING_RULE_DURATION ,
913 r_lines_all.RULE_START_DATE ,
914 r_lines_all.PRIMARY_SALESREP_NUMBER ,
915 r_lines_all.PRIMARY_SALESREP_ID ,
916 r_lines_all.SALES_ORDER ,
917 r_lines_all.SALES_ORDER_LINE ,
918 r_lines_all.SALES_ORDER_DATE ,
919 r_lines_all.SALES_ORDER_SOURCE ,
920 r_lines_all.SALES_ORDER_REVISION ,
921 r_lines_all.PURCHASE_ORDER ,
922 r_lines_all.PURCHASE_ORDER_REVISION ,
923 r_lines_all.PURCHASE_ORDER_DATE ,
924 r_lines_all.AGREEMENT_NAME ,
925 r_lines_all.AGREEMENT_ID ,
926 r_lines_all.MEMO_LINE_NAME ,
927 r_lines_all.MEMO_LINE_ID ,
928 r_lines_all.INVENTORY_ITEM_ID ,
929 r_lines_all.MTL_SYSTEM_ITEMS_SEG1 ,
930 r_lines_all.MTL_SYSTEM_ITEMS_SEG2 ,
931 r_lines_all.MTL_SYSTEM_ITEMS_SEG3 ,
932 r_lines_all.MTL_SYSTEM_ITEMS_SEG4 ,
933 r_lines_all.MTL_SYSTEM_ITEMS_SEG5 ,
934 r_lines_all.MTL_SYSTEM_ITEMS_SEG6 ,
935 r_lines_all.MTL_SYSTEM_ITEMS_SEG7 ,
936 r_lines_all.MTL_SYSTEM_ITEMS_SEG8 ,
937 r_lines_all.MTL_SYSTEM_ITEMS_SEG9 ,
938 r_lines_all.MTL_SYSTEM_ITEMS_SEG10 ,
939 r_lines_all.MTL_SYSTEM_ITEMS_SEG11 ,
940 r_lines_all.MTL_SYSTEM_ITEMS_SEG12 ,
941 r_lines_all.MTL_SYSTEM_ITEMS_SEG13 ,
942 r_lines_all.MTL_SYSTEM_ITEMS_SEG14 ,
943 r_lines_all.MTL_SYSTEM_ITEMS_SEG15 ,
944 r_lines_all.MTL_SYSTEM_ITEMS_SEG16 ,
945 r_lines_all.MTL_SYSTEM_ITEMS_SEG17 ,
946 r_lines_all.MTL_SYSTEM_ITEMS_SEG18 ,
947 r_lines_all.MTL_SYSTEM_ITEMS_SEG19 ,
948 r_lines_all.MTL_SYSTEM_ITEMS_SEG20 ,
949 r_lines_all.REFERENCE_LINE_ID ,
950 r_lines_all.REFERENCE_LINE_CONTEXT ,
951 r_lines_all.REFERENCE_LINE_ATTRIBUTE1 ,
952 r_lines_all.REFERENCE_LINE_ATTRIBUTE2 ,
953 r_lines_all.REFERENCE_LINE_ATTRIBUTE3 ,
954 r_lines_all.REFERENCE_LINE_ATTRIBUTE4 ,
955 r_lines_all.REFERENCE_LINE_ATTRIBUTE5 ,
956 r_lines_all.REFERENCE_LINE_ATTRIBUTE6 ,
957 r_lines_all.REFERENCE_LINE_ATTRIBUTE7 ,
958 r_lines_all.TERRITORY_ID ,
959 r_lines_all.TERRITORY_SEGMENT1 ,
960 r_lines_all.TERRITORY_SEGMENT2 ,
961 r_lines_all.TERRITORY_SEGMENT3 ,
962 r_lines_all.TERRITORY_SEGMENT4 ,
963 r_lines_all.TERRITORY_SEGMENT5 ,
964 r_lines_all.TERRITORY_SEGMENT6 ,
965 r_lines_all.TERRITORY_SEGMENT7 ,
966 r_lines_all.TERRITORY_SEGMENT8 ,
967 r_lines_all.TERRITORY_SEGMENT9 ,
968 r_lines_all.TERRITORY_SEGMENT10 ,
969 r_lines_all.TERRITORY_SEGMENT11 ,
970 r_lines_all.TERRITORY_SEGMENT12 ,
971 r_lines_all.TERRITORY_SEGMENT13 ,
972 r_lines_all.TERRITORY_SEGMENT14 ,
973 r_lines_all.TERRITORY_SEGMENT15 ,
974 r_lines_all.TERRITORY_SEGMENT16 ,
975 r_lines_all.TERRITORY_SEGMENT17 ,
976 r_lines_all.TERRITORY_SEGMENT18 ,
977 r_lines_all.TERRITORY_SEGMENT19 ,
978 r_lines_all.TERRITORY_SEGMENT20 ,
979 r_lines_all.ATTRIBUTE_CATEGORY ,
980 r_lines_all.ATTRIBUTE1 ,
981 r_lines_all.ATTRIBUTE2 ,
982 r_lines_all.ATTRIBUTE3 ,
983 r_lines_all.ATTRIBUTE4 ,
984 r_lines_all.ATTRIBUTE5 ,
985 r_lines_all.ATTRIBUTE6 ,
986 r_lines_all.ATTRIBUTE7 ,
987 r_lines_all.ATTRIBUTE8 ,
988 r_lines_all.ATTRIBUTE9 ,
989 r_lines_all.ATTRIBUTE10 ,
990 r_lines_all.ATTRIBUTE11 ,
991 r_lines_all.ATTRIBUTE12 ,
992 r_lines_all.ATTRIBUTE13 ,
993 r_lines_all.ATTRIBUTE14 ,
994 r_lines_all.ATTRIBUTE15 ,
995 r_lines_all.HEADER_ATTRIBUTE_CATEGORY ,
996 r_lines_all.HEADER_ATTRIBUTE1 ,
997 r_lines_all.HEADER_ATTRIBUTE2 ,
998 r_lines_all.HEADER_ATTRIBUTE3 ,
999 r_lines_all.HEADER_ATTRIBUTE4 ,
1000 r_lines_all.HEADER_ATTRIBUTE5 ,
1001 r_lines_all.HEADER_ATTRIBUTE6 ,
1002 r_lines_all.HEADER_ATTRIBUTE7 ,
1003 r_lines_all.HEADER_ATTRIBUTE8 ,
1004 r_lines_all.HEADER_ATTRIBUTE9 ,
1005 r_lines_all.HEADER_ATTRIBUTE10 ,
1006 r_lines_all.HEADER_ATTRIBUTE11 ,
1007 r_lines_all.HEADER_ATTRIBUTE12 ,
1008 r_lines_all.HEADER_ATTRIBUTE13 ,
1009 r_lines_all.HEADER_ATTRIBUTE14 ,
1010 r_lines_all.HEADER_ATTRIBUTE15 ,
1011 r_lines_all.COMMENTS ,
1012 r_lines_all.INTERNAL_NOTES ,
1013 r_lines_all.INITIAL_CUSTOMER_TRX_ID ,
1014 r_lines_all.USSGL_TRANSACTION_CODE_CONTEXT,
1015 r_lines_all.USSGL_TRANSACTION_CODE ,
1016 r_lines_all.ACCTD_AMOUNT ,
1017 r_lines_all.CUSTOMER_BANK_ACCOUNT_ID ,
1018 r_lines_all.CUSTOMER_BANK_ACCOUNT_NAME ,
1019 r_lines_all.UOM_CODE ,
1020 r_lines_all.UOM_NAME ,
1021 r_lines_all.DOCUMENT_NUMBER_SEQUENCE_ID ,
1022 r_lines_all.LINK_TO_LINE_ATTRIBUTE10 ,
1023 r_lines_all.LINK_TO_LINE_ATTRIBUTE11 ,
1024 r_lines_all.LINK_TO_LINE_ATTRIBUTE12 ,
1025 r_lines_all.LINK_TO_LINE_ATTRIBUTE13 ,
1026 r_lines_all.LINK_TO_LINE_ATTRIBUTE14 ,
1027 r_lines_all.LINK_TO_LINE_ATTRIBUTE15 ,
1028 r_lines_all.LINK_TO_LINE_ATTRIBUTE8 ,
1029 r_lines_all.LINK_TO_LINE_ATTRIBUTE9 ,
1030 r_lines_all.REFERENCE_LINE_ATTRIBUTE10 ,
1031 r_lines_all.REFERENCE_LINE_ATTRIBUTE11 ,
1032 r_lines_all.REFERENCE_LINE_ATTRIBUTE12 ,
1033 r_lines_all.REFERENCE_LINE_ATTRIBUTE13 ,
1034 r_lines_all.REFERENCE_LINE_ATTRIBUTE14 ,
1035 r_lines_all.REFERENCE_LINE_ATTRIBUTE15 ,
1036 r_lines_all.REFERENCE_LINE_ATTRIBUTE8 ,
1037 r_lines_all.REFERENCE_LINE_ATTRIBUTE9 ,
1038 r_lines_all.INTERFACE_LINE_ATTRIBUTE10 ,
1039 r_lines_all.INTERFACE_LINE_ATTRIBUTE11 ,
1040 r_lines_all.INTERFACE_LINE_ATTRIBUTE12 ,
1041 r_lines_all.INTERFACE_LINE_ATTRIBUTE13 ,
1042 r_lines_all.INTERFACE_LINE_ATTRIBUTE14 ,
1043 r_lines_all.INTERFACE_LINE_ATTRIBUTE15 ,
1044 r_lines_all.INTERFACE_LINE_ATTRIBUTE9 ,
1045 r_lines_all.VAT_TAX_ID ,
1046 r_lines_all.REASON_CODE_MEANING ,
1047 r_lines_all.LAST_PERIOD_TO_CREDIT ,
1048 r_lines_all.PAYING_CUSTOMER_ID ,
1049 r_lines_all.PAYING_SITE_USE_ID ,
1050 r_lines_all.TAX_EXEMPT_FLAG ,
1051 r_lines_all.TAX_EXEMPT_REASON_CODE ,
1052 r_lines_all.TAX_EXEMPT_REASON_CODE_MEANING,
1053 r_lines_all.TAX_EXEMPT_NUMBER ,
1054 r_lines_all.SALES_TAX_ID ,
1055 r_lines_all.CREATED_BY ,
1056 r_lines_all.CREATION_DATE ,
1057 r_lines_all.LAST_UPDATED_BY ,
1058 r_lines_all.LAST_UPDATE_DATE ,
1059 r_lines_all.LAST_UPDATE_LOGIN ,
1060 r_lines_all.LOCATION_SEGMENT_ID ,
1061 r_lines_all.MOVEMENT_ID ,
1062 r_lines_all.ORG_ID ,
1063 r_lines_all.AMOUNT_INCLUDES_TAX_FLAG ,
1064 r_lines_all.HEADER_GDF_ATTR_CATEGORY ,
1065 r_lines_all.HEADER_GDF_ATTRIBUTE1 ,
1066 r_lines_all.HEADER_GDF_ATTRIBUTE2 ,
1067 r_lines_all.HEADER_GDF_ATTRIBUTE3 ,
1068 r_lines_all.HEADER_GDF_ATTRIBUTE4 ,
1069 r_lines_all.HEADER_GDF_ATTRIBUTE5 ,
1070 r_lines_all.HEADER_GDF_ATTRIBUTE6 ,
1071 r_lines_all.HEADER_GDF_ATTRIBUTE7 ,
1072 r_lines_all.HEADER_GDF_ATTRIBUTE8 ,
1073 r_lines_all.HEADER_GDF_ATTRIBUTE9 ,
1074 r_lines_all.HEADER_GDF_ATTRIBUTE10 ,
1075 r_lines_all.HEADER_GDF_ATTRIBUTE11 ,
1076 r_lines_all.HEADER_GDF_ATTRIBUTE12 ,
1077 r_lines_all.HEADER_GDF_ATTRIBUTE13 ,
1078 r_lines_all.HEADER_GDF_ATTRIBUTE14 ,
1079 r_lines_all.HEADER_GDF_ATTRIBUTE15 ,
1080 r_lines_all.HEADER_GDF_ATTRIBUTE16 ,
1081 r_lines_all.HEADER_GDF_ATTRIBUTE17 ,
1082 r_lines_all.HEADER_GDF_ATTRIBUTE18 ,
1083 r_lines_all.HEADER_GDF_ATTRIBUTE19 ,
1084 r_lines_all.HEADER_GDF_ATTRIBUTE20 ,
1085 r_lines_all.HEADER_GDF_ATTRIBUTE21 ,
1086 r_lines_all.HEADER_GDF_ATTRIBUTE22 ,
1087 r_lines_all.HEADER_GDF_ATTRIBUTE23 ,
1088 r_lines_all.HEADER_GDF_ATTRIBUTE24 ,
1089 r_lines_all.HEADER_GDF_ATTRIBUTE25 ,
1090 r_lines_all.HEADER_GDF_ATTRIBUTE26 ,
1091 r_lines_all.HEADER_GDF_ATTRIBUTE27 ,
1092 r_lines_all.HEADER_GDF_ATTRIBUTE28 ,
1093 r_lines_all.HEADER_GDF_ATTRIBUTE29 ,
1094 r_lines_all.HEADER_GDF_ATTRIBUTE30 ,
1095 r_lines_all.LINE_GDF_ATTR_CATEGORY ,
1096 r_lines_all.LINE_GDF_ATTRIBUTE1 ,
1097 r_lines_all.LINE_GDF_ATTRIBUTE2 ,
1098 r_lines_all.LINE_GDF_ATTRIBUTE3 ,
1099 r_lines_all.LINE_GDF_ATTRIBUTE4 ,
1100 r_lines_all.LINE_GDF_ATTRIBUTE5 ,
1101 r_lines_all.LINE_GDF_ATTRIBUTE6 ,
1102 r_lines_all.LINE_GDF_ATTRIBUTE7 ,
1103 r_lines_all.LINE_GDF_ATTRIBUTE8 ,
1104 r_lines_all.LINE_GDF_ATTRIBUTE9 ,
1105 r_lines_all.LINE_GDF_ATTRIBUTE10 ,
1106 r_lines_all.LINE_GDF_ATTRIBUTE11 ,
1107 r_lines_all.LINE_GDF_ATTRIBUTE12 ,
1108 r_lines_all.LINE_GDF_ATTRIBUTE13 ,
1109 r_lines_all.LINE_GDF_ATTRIBUTE14 ,
1110 r_lines_all.LINE_GDF_ATTRIBUTE15 ,
1111 r_lines_all.LINE_GDF_ATTRIBUTE16 ,
1112 r_lines_all.LINE_GDF_ATTRIBUTE17 ,
1113 r_lines_all.LINE_GDF_ATTRIBUTE18 ,
1114 r_lines_all.LINE_GDF_ATTRIBUTE19 ,
1115 r_lines_all.LINE_GDF_ATTRIBUTE20 ,
1116 r_lines_all.RESET_TRX_DATE_FLAG ,
1117 r_lines_all.PAYMENT_SERVER_ORDER_NUM ,
1118 r_lines_all.APPROVAL_CODE ,
1119 r_lines_all.ADDRESS_VERIFICATION_CODE ,
1120 r_lines_all.WAREHOUSE_ID ,
1121 r_lines_all.TRANSLATED_DESCRIPTION ,
1122 r_lines_all.CONS_BILLING_NUMBER ,
1123 r_lines_all.PROMISED_COMMITMENT_AMOUNT ,
1124 r_lines_all.PAYMENT_SET_ID ,
1125 r_lines_all.ORIGINAL_GL_DATE ,
1126 r_lines_all.CONTRACT_LINE_ID ,
1127 r_lines_all.CONTRACT_ID ,
1128 r_lines_all.SOURCE_DATA_KEY1 ,
1129 r_lines_all.SOURCE_DATA_KEY2 ,
1130 r_lines_all.SOURCE_DATA_KEY3 ,
1131 r_lines_all.SOURCE_DATA_KEY4 ,
1132 r_lines_all.SOURCE_DATA_KEY5 ,
1133 r_lines_all.INVOICED_LINE_ACCTG_LEVEL ,
1134 r_lines_all.OVERRIDE_AUTO_ACCOUNTING_FLAG ,
1135 r_lines_all.SOURCE_APPLICATION_ID ,
1136 r_lines_all.SOURCE_EVENT_CLASS_CODE ,
1137 r_lines_all.SOURCE_ENTITY_CODE ,
1138 r_lines_all.SOURCE_TRX_ID ,
1139 r_lines_all.SOURCE_TRX_LINE_ID ,
1140 r_lines_all.SOURCE_TRX_LINE_TYPE ,
1141 r_lines_all.SOURCE_TRX_DETAIL_TAX_LINE_ID ,
1142 r_lines_all.HISTORICAL_FLAG ,
1143 r_lines_all.TAX_REGIME_CODE ,
1144 r_lines_all.TAX ,
1145 r_lines_all.TAX_STATUS_CODE ,
1146 r_lines_all.TAX_RATE_CODE ,
1147 r_lines_all.TAX_JURISDICTION_CODE ,
1148 r_lines_all.TAXABLE_AMOUNT ,
1149 r_lines_all.TAXABLE_FLAG ,
1150 r_lines_all.LEGAL_ENTITY_ID ,
1151 r_lines_all.PARENT_LINE_ID ,
1152 r_lines_all.DEFERRAL_EXCLUSION_FLAG ,
1153 r_lines_all.PAYMENT_TRXN_EXTENSION_ID ,
1154 r_lines_all.RULE_END_DATE ,
1155 r_lines_all.PAYMENT_ATTRIBUTES ,
1156 r_lines_all.APPLICATION_ID ,
1157 r_lines_all.BILLING_DATE
1158 );
1159 END LOOP;
1160 /* Inserting into ra_interface_distributions_all Tables */
1161 FOR r_distributions IN
1162 (SELECT INTERFACE_DISTRIBUTION_ID ,
1163 INTERFACE_LINE_ID ,
1164 INTERFACE_LINE_CONTEXT ,
1165 INTERFACE_LINE_ATTRIBUTE1 ,
1166 INTERFACE_LINE_ATTRIBUTE2 ,
1167 INTERFACE_LINE_ATTRIBUTE3 ,
1168 INTERFACE_LINE_ATTRIBUTE4 ,
1169 INTERFACE_LINE_ATTRIBUTE5 ,
1170 INTERFACE_LINE_ATTRIBUTE6 ,
1171 INTERFACE_LINE_ATTRIBUTE7 ,
1172 INTERFACE_LINE_ATTRIBUTE8 ,
1173 ACCOUNT_CLASS ,
1174 AMOUNT ,
1175 PERCENT ,
1176 INTERFACE_STATUS ,
1177 REQUEST_ID ,
1178 CODE_COMBINATION_ID ,
1179 SEGMENT1 ,
1180 SEGMENT2 ,
1181 SEGMENT3 ,
1182 SEGMENT4 ,
1183 SEGMENT5 ,
1184 SEGMENT6 ,
1185 SEGMENT7 ,
1186 SEGMENT8 ,
1187 SEGMENT9 ,
1188 SEGMENT10 ,
1189 SEGMENT11 ,
1190 SEGMENT12 ,
1191 SEGMENT13 ,
1192 SEGMENT14 ,
1193 SEGMENT15 ,
1194 SEGMENT16 ,
1195 SEGMENT17 ,
1196 SEGMENT18 ,
1197 SEGMENT19 ,
1198 SEGMENT20 ,
1199 SEGMENT21 ,
1200 SEGMENT22 ,
1201 SEGMENT23 ,
1202 SEGMENT24 ,
1203 SEGMENT25 ,
1204 SEGMENT26 ,
1205 SEGMENT27 ,
1206 SEGMENT28 ,
1207 SEGMENT29 ,
1208 SEGMENT30 ,
1209 COMMENTS ,
1210 ATTRIBUTE_CATEGORY ,
1211 ATTRIBUTE1 ,
1212 ATTRIBUTE2 ,
1213 ATTRIBUTE3 ,
1214 ATTRIBUTE4 ,
1215 ATTRIBUTE5 ,
1216 ATTRIBUTE6 ,
1217 ATTRIBUTE7 ,
1218 ATTRIBUTE8 ,
1219 ATTRIBUTE9 ,
1220 ATTRIBUTE10 ,
1221 ATTRIBUTE11 ,
1222 ATTRIBUTE12 ,
1223 ATTRIBUTE13 ,
1224 ATTRIBUTE14 ,
1225 ATTRIBUTE15 ,
1226 ACCTD_AMOUNT ,
1227 INTERFACE_LINE_ATTRIBUTE10 ,
1228 INTERFACE_LINE_ATTRIBUTE11 ,
1229 INTERFACE_LINE_ATTRIBUTE12 ,
1230 INTERFACE_LINE_ATTRIBUTE13 ,
1231 INTERFACE_LINE_ATTRIBUTE14 ,
1232 INTERFACE_LINE_ATTRIBUTE15 ,
1233 INTERFACE_LINE_ATTRIBUTE9 ,
1234 CREATED_BY ,
1235 CREATION_DATE ,
1236 LAST_UPDATED_BY ,
1237 LAST_UPDATE_DATE ,
1238 LAST_UPDATE_LOGIN ,
1239 ORG_ID ,
1240 INTERIM_TAX_CCID ,
1241 INTERIM_TAX_SEGMENT1 ,
1242 INTERIM_TAX_SEGMENT2 ,
1243 INTERIM_TAX_SEGMENT3 ,
1244 INTERIM_TAX_SEGMENT4 ,
1245 INTERIM_TAX_SEGMENT5 ,
1246 INTERIM_TAX_SEGMENT6 ,
1247 INTERIM_TAX_SEGMENT7 ,
1248 INTERIM_TAX_SEGMENT8 ,
1249 INTERIM_TAX_SEGMENT9 ,
1250 INTERIM_TAX_SEGMENT10 ,
1251 INTERIM_TAX_SEGMENT11 ,
1252 INTERIM_TAX_SEGMENT12 ,
1253 INTERIM_TAX_SEGMENT13 ,
1254 INTERIM_TAX_SEGMENT14 ,
1255 INTERIM_TAX_SEGMENT15 ,
1256 INTERIM_TAX_SEGMENT16 ,
1257 INTERIM_TAX_SEGMENT17 ,
1258 INTERIM_TAX_SEGMENT18 ,
1259 INTERIM_TAX_SEGMENT19 ,
1260 INTERIM_TAX_SEGMENT20 ,
1261 INTERIM_TAX_SEGMENT21 ,
1262 INTERIM_TAX_SEGMENT22 ,
1263 INTERIM_TAX_SEGMENT23 ,
1264 INTERIM_TAX_SEGMENT24 ,
1265 INTERIM_TAX_SEGMENT25 ,
1266 INTERIM_TAX_SEGMENT26 ,
1267 INTERIM_TAX_SEGMENT27 ,
1268 INTERIM_TAX_SEGMENT28 ,
1269 INTERIM_TAX_SEGMENT29 ,
1270 INTERIM_TAX_SEGMENT30
1271 FROM TABLE( p_distributions)
1272 )
1273 LOOP
1274 INSERT
1275 INTO ra_interface_distributions_all
1276 (
1277 INTERFACE_DISTRIBUTION_ID ,
1278 INTERFACE_LINE_ID ,
1279 INTERFACE_LINE_CONTEXT ,
1280 INTERFACE_LINE_ATTRIBUTE1 ,
1281 INTERFACE_LINE_ATTRIBUTE2 ,
1282 INTERFACE_LINE_ATTRIBUTE3 ,
1283 INTERFACE_LINE_ATTRIBUTE4 ,
1284 INTERFACE_LINE_ATTRIBUTE5 ,
1285 INTERFACE_LINE_ATTRIBUTE6 ,
1286 INTERFACE_LINE_ATTRIBUTE7 ,
1287 INTERFACE_LINE_ATTRIBUTE8 ,
1288 ACCOUNT_CLASS ,
1289 AMOUNT ,
1290 PERCENT ,
1291 INTERFACE_STATUS ,
1292 REQUEST_ID ,
1293 CODE_COMBINATION_ID ,
1294 SEGMENT1 ,
1295 SEGMENT2 ,
1296 SEGMENT3 ,
1297 SEGMENT4 ,
1298 SEGMENT5 ,
1299 SEGMENT6 ,
1300 SEGMENT7 ,
1301 SEGMENT8 ,
1302 SEGMENT9 ,
1303 SEGMENT10 ,
1304 SEGMENT11 ,
1305 SEGMENT12 ,
1306 SEGMENT13 ,
1307 SEGMENT14 ,
1308 SEGMENT15 ,
1309 SEGMENT16 ,
1310 SEGMENT17 ,
1311 SEGMENT18 ,
1312 SEGMENT19 ,
1313 SEGMENT20 ,
1314 SEGMENT21 ,
1315 SEGMENT22 ,
1316 SEGMENT23 ,
1317 SEGMENT24 ,
1318 SEGMENT25 ,
1319 SEGMENT26 ,
1320 SEGMENT27 ,
1321 SEGMENT28 ,
1322 SEGMENT29 ,
1323 SEGMENT30 ,
1324 COMMENTS ,
1325 ATTRIBUTE_CATEGORY ,
1326 ATTRIBUTE1 ,
1327 ATTRIBUTE2 ,
1328 ATTRIBUTE3 ,
1329 ATTRIBUTE4 ,
1330 ATTRIBUTE5 ,
1331 ATTRIBUTE6 ,
1332 ATTRIBUTE7 ,
1333 ATTRIBUTE8 ,
1334 ATTRIBUTE9 ,
1335 ATTRIBUTE10 ,
1336 ATTRIBUTE11 ,
1337 ATTRIBUTE12 ,
1338 ATTRIBUTE13 ,
1339 ATTRIBUTE14 ,
1340 ATTRIBUTE15 ,
1341 ACCTD_AMOUNT ,
1342 INTERFACE_LINE_ATTRIBUTE10 ,
1343 INTERFACE_LINE_ATTRIBUTE11 ,
1344 INTERFACE_LINE_ATTRIBUTE12 ,
1345 INTERFACE_LINE_ATTRIBUTE13 ,
1346 INTERFACE_LINE_ATTRIBUTE14 ,
1347 INTERFACE_LINE_ATTRIBUTE15 ,
1348 INTERFACE_LINE_ATTRIBUTE9 ,
1349 CREATED_BY ,
1350 CREATION_DATE ,
1351 LAST_UPDATED_BY ,
1352 LAST_UPDATE_DATE ,
1353 LAST_UPDATE_LOGIN ,
1354 ORG_ID ,
1355 INTERIM_TAX_CCID ,
1356 INTERIM_TAX_SEGMENT1 ,
1357 INTERIM_TAX_SEGMENT2 ,
1358 INTERIM_TAX_SEGMENT3 ,
1359 INTERIM_TAX_SEGMENT4 ,
1360 INTERIM_TAX_SEGMENT5 ,
1361 INTERIM_TAX_SEGMENT6 ,
1362 INTERIM_TAX_SEGMENT7 ,
1363 INTERIM_TAX_SEGMENT8 ,
1364 INTERIM_TAX_SEGMENT9 ,
1365 INTERIM_TAX_SEGMENT10 ,
1366 INTERIM_TAX_SEGMENT11 ,
1367 INTERIM_TAX_SEGMENT12 ,
1368 INTERIM_TAX_SEGMENT13 ,
1369 INTERIM_TAX_SEGMENT14 ,
1370 INTERIM_TAX_SEGMENT15 ,
1371 INTERIM_TAX_SEGMENT16 ,
1372 INTERIM_TAX_SEGMENT17 ,
1373 INTERIM_TAX_SEGMENT18 ,
1374 INTERIM_TAX_SEGMENT19 ,
1375 INTERIM_TAX_SEGMENT20 ,
1376 INTERIM_TAX_SEGMENT21 ,
1377 INTERIM_TAX_SEGMENT22 ,
1378 INTERIM_TAX_SEGMENT23 ,
1379 INTERIM_TAX_SEGMENT24 ,
1380 INTERIM_TAX_SEGMENT25 ,
1381 INTERIM_TAX_SEGMENT26 ,
1382 INTERIM_TAX_SEGMENT27 ,
1383 INTERIM_TAX_SEGMENT28 ,
1384 INTERIM_TAX_SEGMENT29 ,
1385 INTERIM_TAX_SEGMENT30
1386 )
1387 VALUES
1388 (
1389 r_distributions.INTERFACE_DISTRIBUTION_ID ,
1390 r_distributions.INTERFACE_LINE_ID ,
1391 r_distributions.INTERFACE_LINE_CONTEXT ,
1392 r_distributions.INTERFACE_LINE_ATTRIBUTE1 ,
1393 r_distributions.INTERFACE_LINE_ATTRIBUTE2 ,
1394 r_distributions.INTERFACE_LINE_ATTRIBUTE3 ,
1395 r_distributions.INTERFACE_LINE_ATTRIBUTE4 ,
1396 r_distributions.INTERFACE_LINE_ATTRIBUTE5 ,
1397 r_distributions.INTERFACE_LINE_ATTRIBUTE6 ,
1398 r_distributions.INTERFACE_LINE_ATTRIBUTE7 ,
1399 r_distributions.INTERFACE_LINE_ATTRIBUTE8 ,
1400 r_distributions.ACCOUNT_CLASS ,
1401 r_distributions.AMOUNT ,
1402 r_distributions.PERCENT ,
1403 r_distributions.INTERFACE_STATUS ,
1404 r_distributions.REQUEST_ID ,
1405 r_distributions.CODE_COMBINATION_ID ,
1406 r_distributions.SEGMENT1 ,
1407 r_distributions.SEGMENT2 ,
1408 r_distributions.SEGMENT3 ,
1409 r_distributions.SEGMENT4 ,
1410 r_distributions.SEGMENT5 ,
1411 r_distributions.SEGMENT6 ,
1412 r_distributions.SEGMENT7 ,
1413 r_distributions.SEGMENT8 ,
1414 r_distributions.SEGMENT9 ,
1415 r_distributions.SEGMENT10 ,
1416 r_distributions.SEGMENT11 ,
1417 r_distributions.SEGMENT12 ,
1418 r_distributions.SEGMENT13 ,
1419 r_distributions.SEGMENT14 ,
1420 r_distributions.SEGMENT15 ,
1421 r_distributions.SEGMENT16 ,
1422 r_distributions.SEGMENT17 ,
1423 r_distributions.SEGMENT18 ,
1424 r_distributions.SEGMENT19 ,
1425 r_distributions.SEGMENT20 ,
1426 r_distributions.SEGMENT21 ,
1427 r_distributions.SEGMENT22 ,
1428 r_distributions.SEGMENT23 ,
1429 r_distributions.SEGMENT24 ,
1430 r_distributions.SEGMENT25 ,
1431 r_distributions.SEGMENT26 ,
1432 r_distributions.SEGMENT27 ,
1433 r_distributions.SEGMENT28 ,
1434 r_distributions.SEGMENT29 ,
1435 r_distributions.SEGMENT30 ,
1436 r_distributions.COMMENTS ,
1437 r_distributions.ATTRIBUTE_CATEGORY ,
1438 r_distributions.ATTRIBUTE1 ,
1439 r_distributions.ATTRIBUTE2 ,
1440 r_distributions.ATTRIBUTE3 ,
1441 r_distributions.ATTRIBUTE4 ,
1442 r_distributions.ATTRIBUTE5 ,
1443 r_distributions.ATTRIBUTE6 ,
1444 r_distributions.ATTRIBUTE7 ,
1445 r_distributions.ATTRIBUTE8 ,
1446 r_distributions.ATTRIBUTE9 ,
1447 r_distributions.ATTRIBUTE10 ,
1448 r_distributions.ATTRIBUTE11 ,
1449 r_distributions.ATTRIBUTE12 ,
1450 r_distributions.ATTRIBUTE13 ,
1451 r_distributions.ATTRIBUTE14 ,
1452 r_distributions.ATTRIBUTE15 ,
1453 r_distributions.ACCTD_AMOUNT ,
1454 r_distributions.INTERFACE_LINE_ATTRIBUTE10 ,
1455 r_distributions.INTERFACE_LINE_ATTRIBUTE11 ,
1456 r_distributions.INTERFACE_LINE_ATTRIBUTE12 ,
1457 r_distributions.INTERFACE_LINE_ATTRIBUTE13 ,
1458 r_distributions.INTERFACE_LINE_ATTRIBUTE14 ,
1459 r_distributions.INTERFACE_LINE_ATTRIBUTE15 ,
1460 r_distributions.INTERFACE_LINE_ATTRIBUTE9 ,
1461 r_distributions.CREATED_BY ,
1462 r_distributions.CREATION_DATE ,
1463 r_distributions.LAST_UPDATED_BY ,
1464 r_distributions.LAST_UPDATE_DATE ,
1465 r_distributions.LAST_UPDATE_LOGIN ,
1466 r_distributions.ORG_ID ,
1467 r_distributions.INTERIM_TAX_CCID ,
1468 r_distributions.INTERIM_TAX_SEGMENT1 ,
1469 r_distributions.INTERIM_TAX_SEGMENT2 ,
1470 r_distributions.INTERIM_TAX_SEGMENT3 ,
1471 r_distributions.INTERIM_TAX_SEGMENT4 ,
1472 r_distributions.INTERIM_TAX_SEGMENT5 ,
1473 r_distributions.INTERIM_TAX_SEGMENT6 ,
1474 r_distributions.INTERIM_TAX_SEGMENT7 ,
1475 r_distributions.INTERIM_TAX_SEGMENT8 ,
1476 r_distributions.INTERIM_TAX_SEGMENT9 ,
1477 r_distributions.INTERIM_TAX_SEGMENT10 ,
1478 r_distributions.INTERIM_TAX_SEGMENT11 ,
1479 r_distributions.INTERIM_TAX_SEGMENT12 ,
1480 r_distributions.INTERIM_TAX_SEGMENT13 ,
1481 r_distributions.INTERIM_TAX_SEGMENT14 ,
1482 r_distributions.INTERIM_TAX_SEGMENT15 ,
1483 r_distributions.INTERIM_TAX_SEGMENT16 ,
1484 r_distributions.INTERIM_TAX_SEGMENT17 ,
1485 r_distributions.INTERIM_TAX_SEGMENT18 ,
1486 r_distributions.INTERIM_TAX_SEGMENT19 ,
1487 r_distributions.INTERIM_TAX_SEGMENT20 ,
1488 r_distributions.INTERIM_TAX_SEGMENT21 ,
1489 r_distributions.INTERIM_TAX_SEGMENT22 ,
1490 r_distributions.INTERIM_TAX_SEGMENT23 ,
1491 r_distributions.INTERIM_TAX_SEGMENT24 ,
1492 r_distributions.INTERIM_TAX_SEGMENT25 ,
1493 r_distributions.INTERIM_TAX_SEGMENT26 ,
1494 r_distributions.INTERIM_TAX_SEGMENT27 ,
1495 r_distributions.INTERIM_TAX_SEGMENT28 ,
1496 r_distributions.INTERIM_TAX_SEGMENT29 ,
1497 r_distributions.INTERIM_TAX_SEGMENT30
1498 );
1499 END LOOP;
1500 /* Inserting into ra_interface_salescredits_all Tables */
1501 FOR r_salescredits IN
1502 (SELECT INTERFACE_SALESCREDIT_ID ,
1503 INTERFACE_LINE_ID ,
1504 INTERFACE_LINE_CONTEXT ,
1505 INTERFACE_LINE_ATTRIBUTE1 ,
1506 INTERFACE_LINE_ATTRIBUTE2 ,
1507 INTERFACE_LINE_ATTRIBUTE3 ,
1508 INTERFACE_LINE_ATTRIBUTE4 ,
1509 INTERFACE_LINE_ATTRIBUTE5 ,
1510 INTERFACE_LINE_ATTRIBUTE6 ,
1511 INTERFACE_LINE_ATTRIBUTE7 ,
1512 INTERFACE_LINE_ATTRIBUTE8 ,
1513 SALESREP_NUMBER ,
1514 SALESREP_ID ,
1515 SALES_CREDIT_TYPE_NAME ,
1516 SALES_CREDIT_TYPE_ID ,
1517 SALES_CREDIT_AMOUNT_SPLIT ,
1518 SALES_CREDIT_PERCENT_SPLIT ,
1519 INTERFACE_STATUS ,
1520 REQUEST_ID ,
1521 ATTRIBUTE_CATEGORY ,
1522 ATTRIBUTE1 ,
1523 ATTRIBUTE2 ,
1524 ATTRIBUTE3 ,
1525 ATTRIBUTE4 ,
1526 ATTRIBUTE5 ,
1527 ATTRIBUTE6 ,
1528 ATTRIBUTE7 ,
1529 ATTRIBUTE8 ,
1530 ATTRIBUTE9 ,
1531 ATTRIBUTE10 ,
1532 ATTRIBUTE11 ,
1533 ATTRIBUTE12 ,
1534 ATTRIBUTE13 ,
1535 ATTRIBUTE14 ,
1536 ATTRIBUTE15 ,
1537 INTERFACE_LINE_ATTRIBUTE10 ,
1538 INTERFACE_LINE_ATTRIBUTE11 ,
1539 INTERFACE_LINE_ATTRIBUTE12 ,
1540 INTERFACE_LINE_ATTRIBUTE13 ,
1541 INTERFACE_LINE_ATTRIBUTE14 ,
1542 INTERFACE_LINE_ATTRIBUTE15 ,
1543 INTERFACE_LINE_ATTRIBUTE9 ,
1544 CREATED_BY ,
1545 CREATION_DATE ,
1546 LAST_UPDATED_BY ,
1547 LAST_UPDATE_DATE ,
1548 LAST_UPDATE_LOGIN ,
1549 ORG_ID ,
1550 SALESGROUP_ID
1551 FROM TABLE( p_salescredits)
1552 )
1553 LOOP
1554 INSERT
1555 INTO ra_interface_salescredits_all
1556 (
1557 INTERFACE_SALESCREDIT_ID ,
1558 INTERFACE_LINE_ID ,
1559 INTERFACE_LINE_CONTEXT ,
1560 INTERFACE_LINE_ATTRIBUTE1 ,
1561 INTERFACE_LINE_ATTRIBUTE2 ,
1562 INTERFACE_LINE_ATTRIBUTE3 ,
1563 INTERFACE_LINE_ATTRIBUTE4 ,
1564 INTERFACE_LINE_ATTRIBUTE5 ,
1565 INTERFACE_LINE_ATTRIBUTE6 ,
1566 INTERFACE_LINE_ATTRIBUTE7 ,
1567 INTERFACE_LINE_ATTRIBUTE8 ,
1568 SALESREP_NUMBER ,
1569 SALESREP_ID ,
1570 SALES_CREDIT_TYPE_NAME ,
1571 SALES_CREDIT_TYPE_ID ,
1572 SALES_CREDIT_AMOUNT_SPLIT ,
1573 SALES_CREDIT_PERCENT_SPLIT ,
1574 INTERFACE_STATUS ,
1575 REQUEST_ID ,
1576 ATTRIBUTE_CATEGORY ,
1577 ATTRIBUTE1 ,
1578 ATTRIBUTE2 ,
1579 ATTRIBUTE3 ,
1580 ATTRIBUTE4 ,
1581 ATTRIBUTE5 ,
1582 ATTRIBUTE6 ,
1583 ATTRIBUTE7 ,
1584 ATTRIBUTE8 ,
1585 ATTRIBUTE9 ,
1586 ATTRIBUTE10 ,
1587 ATTRIBUTE11 ,
1588 ATTRIBUTE12 ,
1589 ATTRIBUTE13 ,
1590 ATTRIBUTE14 ,
1591 ATTRIBUTE15 ,
1592 INTERFACE_LINE_ATTRIBUTE10 ,
1593 INTERFACE_LINE_ATTRIBUTE11 ,
1594 INTERFACE_LINE_ATTRIBUTE12 ,
1595 INTERFACE_LINE_ATTRIBUTE13 ,
1596 INTERFACE_LINE_ATTRIBUTE14 ,
1597 INTERFACE_LINE_ATTRIBUTE15 ,
1598 INTERFACE_LINE_ATTRIBUTE9 ,
1599 CREATED_BY ,
1600 CREATION_DATE ,
1601 LAST_UPDATED_BY ,
1602 LAST_UPDATE_DATE ,
1603 LAST_UPDATE_LOGIN ,
1604 ORG_ID ,
1605 SALESGROUP_ID
1606 )
1607 VALUES
1608 (
1609 r_salescredits.INTERFACE_SALESCREDIT_ID ,
1610 r_salescredits.INTERFACE_LINE_ID ,
1611 r_salescredits.INTERFACE_LINE_CONTEXT ,
1612 r_salescredits.INTERFACE_LINE_ATTRIBUTE1 ,
1613 r_salescredits.INTERFACE_LINE_ATTRIBUTE2 ,
1614 r_salescredits.INTERFACE_LINE_ATTRIBUTE3 ,
1615 r_salescredits.INTERFACE_LINE_ATTRIBUTE4 ,
1616 r_salescredits.INTERFACE_LINE_ATTRIBUTE5 ,
1617 r_salescredits.INTERFACE_LINE_ATTRIBUTE6 ,
1618 r_salescredits.INTERFACE_LINE_ATTRIBUTE7 ,
1619 r_salescredits.INTERFACE_LINE_ATTRIBUTE8 ,
1620 r_salescredits.SALESREP_NUMBER ,
1621 r_salescredits.SALESREP_ID ,
1622 r_salescredits.SALES_CREDIT_TYPE_NAME ,
1623 r_salescredits.SALES_CREDIT_TYPE_ID ,
1624 r_salescredits.SALES_CREDIT_AMOUNT_SPLIT ,
1625 r_salescredits.SALES_CREDIT_PERCENT_SPLIT ,
1626 r_salescredits.INTERFACE_STATUS ,
1627 r_salescredits.REQUEST_ID ,
1628 r_salescredits.ATTRIBUTE_CATEGORY ,
1629 r_salescredits.ATTRIBUTE1 ,
1630 r_salescredits.ATTRIBUTE2 ,
1631 r_salescredits.ATTRIBUTE3 ,
1632 r_salescredits.ATTRIBUTE4 ,
1633 r_salescredits.ATTRIBUTE5 ,
1634 r_salescredits.ATTRIBUTE6 ,
1635 r_salescredits.ATTRIBUTE7 ,
1636 r_salescredits.ATTRIBUTE8 ,
1637 r_salescredits.ATTRIBUTE9 ,
1638 r_salescredits.ATTRIBUTE10 ,
1639 r_salescredits.ATTRIBUTE11 ,
1640 r_salescredits.ATTRIBUTE12 ,
1641 r_salescredits.ATTRIBUTE13 ,
1642 r_salescredits.ATTRIBUTE14 ,
1643 r_salescredits.ATTRIBUTE15 ,
1644 r_salescredits.INTERFACE_LINE_ATTRIBUTE10 ,
1645 r_salescredits.INTERFACE_LINE_ATTRIBUTE11 ,
1646 r_salescredits.INTERFACE_LINE_ATTRIBUTE12 ,
1647 r_salescredits.INTERFACE_LINE_ATTRIBUTE13 ,
1648 r_salescredits.INTERFACE_LINE_ATTRIBUTE14 ,
1649 r_salescredits.INTERFACE_LINE_ATTRIBUTE15 ,
1650 r_salescredits.INTERFACE_LINE_ATTRIBUTE9 ,
1651 r_salescredits.CREATED_BY ,
1652 r_salescredits.CREATION_DATE ,
1653 r_salescredits.LAST_UPDATED_BY ,
1654 r_salescredits.LAST_UPDATE_DATE ,
1655 r_salescredits.LAST_UPDATE_LOGIN ,
1656 r_salescredits.ORG_ID ,
1657 r_salescredits.SALESGROUP_ID
1658 );
1659 END LOOP;
1660
1661 /* Calling the Auto Invoice Concurrent Program */
1662 IF FND_API.to_boolean(p_run_autoinvoice_cp) THEN
1663 x_conc_req_ids := FND_TABLE_OF_NUMBER();
1664 FOR r_cp_input IN
1665 ( SELECT DISTINCT org_id,
1666 batch_source_name
1667 FROM TABLE(p_lines_all)
1668 )
1669 LOOP
1670 SELECT batch_source_id INTO l_batch_source_id
1671 FROM ra_batch_sources_all
1672 WHERE ORG_ID = r_cp_input.ORG_ID
1673 AND NAME = r_cp_input.BATCH_SOURCE_NAME;
1674 l_conc_req_id:= FND_REQUEST.submit_request
1675 (
1676 application => 'AR'
1677 ,program => 'RAXMTR' /*Autoinvoice Master Program*/
1678 ,sub_request => TRUE
1679 ,argument1 => 1 /*Number of Instances*/
1680 ,argument2 => r_cp_input.ORG_ID /*Organization -- pass org_id for a particular organization or pass -99 for all */
1681 ,argument3 => l_batch_source_id /*Batch Source Id*/
1682 ,argument4 => r_cp_input.BATCH_SOURCE_NAME /*Batch Source Name*/
1683 ,argument5 => SYSDATE /*Default Date*/
1684
1685 );
1686
1687 IF l_conc_req_id = 0 THEN
1688 FND_MESSAGE.set_name('AR','AR_EBI_CONC_PRO_SUBMIT_FAILED'); /*Concurrent program submission failed!!!!!*/
1689 FND_MSG_PUB.add;
1690 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1691 END IF;
1692
1693 x_conc_req_ids.EXTEND;
1694 x_conc_req_ids(x_conc_req_ids.COUNT) :=l_conc_req_id;
1695 END LOOP;
1696 END IF;
1697
1698 IF FND_API.to_boolean(p_commit) THEN
1699 COMMIT;
1700 END IF;
1701
1702 EXCEPTION
1703 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704 x_return_status := FND_API.G_RET_STS_ERROR;
1705 IF (x_err_msg IS NULL) THEN
1706 FND_MSG_PUB.count_and_get(
1707 p_encoded => FND_API.G_FALSE,
1708 p_count => l_msg_count,
1709 p_data => x_err_msg
1710 );
1711 END IF;
1712 ROLLBACK TO ar_ebi_invoice_sub_save_pnt;
1713
1714 WHEN OTHERS THEN
1715 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1716 x_err_msg := SQLERRM ||' at EBI_AR_PKG.ar_invoice_submission ';
1717 ROLLBACK TO ar_ebi_invoice_sub_save_pnt;
1718
1719 END ar_invoice_submission;
1720
1721
1722 END AR_EBI_INVOICE_PUB;
1723