[Home] [Help]
PACKAGE BODY: APPS.AR_EBI_INVOICE_PUB
Source
1 PACKAGE BODY AR_EBI_INVOICE_PUB AS
2 /* $Header: AREIINVB.pls 120.2.12010000.6 2009/02/17 11:05:42 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 ,
352 HEADER_GDF_ATTRIBUTE26 ,
349 HEADER_GDF_ATTRIBUTE23 ,
350 HEADER_GDF_ATTRIBUTE24 ,
351 HEADER_GDF_ATTRIBUTE25 ,
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
490
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;
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 ,
624 REFERENCE_LINE_ATTRIBUTE5 ,
621 REFERENCE_LINE_ATTRIBUTE2 ,
622 REFERENCE_LINE_ATTRIBUTE3 ,
623 REFERENCE_LINE_ATTRIBUTE4 ,
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 ,
756 HEADER_GDF_ATTRIBUTE23 ,
753 HEADER_GDF_ATTRIBUTE20 ,
754 HEADER_GDF_ATTRIBUTE21 ,
755 HEADER_GDF_ATTRIBUTE22 ,
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 ,
881 r_lines_all.GL_DATE ,
878 l_conversion_rate ,
879 r_lines_all.CUSTOMER_TRX_ID ,
880 r_lines_all.TRX_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 ,
990 r_lines_all.ATTRIBUTE11 ,
987 r_lines_all.ATTRIBUTE8 ,
988 r_lines_all.ATTRIBUTE9 ,
989 r_lines_all.ATTRIBUTE10 ,
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 ,
1098 r_lines_all.LINE_GDF_ATTRIBUTE3 ,
1095 r_lines_all.LINE_GDF_ATTR_CATEGORY ,
1096 r_lines_all.LINE_GDF_ATTRIBUTE1 ,
1097 r_lines_all.LINE_GDF_ATTRIBUTE2 ,
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 ,
1220 ATTRIBUTE10 ,
1217 ATTRIBUTE7 ,
1218 ATTRIBUTE8 ,
1219 ATTRIBUTE9 ,
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 ,
1361 INTERIM_TAX_SEGMENT6 ,
1358 INTERIM_TAX_SEGMENT3 ,
1359 INTERIM_TAX_SEGMENT4 ,
1360 INTERIM_TAX_SEGMENT5 ,
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 ,
1476 r_distributions.INTERIM_TAX_SEGMENT9 ,
1473 r_distributions.INTERIM_TAX_SEGMENT6 ,
1474 r_distributions.INTERIM_TAX_SEGMENT7 ,
1475 r_distributions.INTERIM_TAX_SEGMENT8 ,
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 ,
1613 r_salescredits.INTERFACE_LINE_ATTRIBUTE2 ,
1610 r_salescredits.INTERFACE_LINE_ID ,
1611 r_salescredits.INTERFACE_LINE_CONTEXT ,
1612 r_salescredits.INTERFACE_LINE_ATTRIBUTE1 ,
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
1675
1676 apps.mo_global.init('AR');
1677 mo_global.set_policy_context('S',r_cp_input.ORG_ID);
1678 arp_global.init_global(r_cp_input.ORG_ID);
1679 arp_standard.init_standard(r_cp_input.ORG_ID);
1680
1681 l_conc_req_id := FND_REQUEST.SUBMIT_REQUEST
1682 (
1683 'AR' -- Application
1684 ,'RAXMTR' -- Program : Autoinvoice Master Program
1685 ,NULL
1686 ,NULL
1687 ,FALSE -- Sub_request
1688 ,1 -- No of AI instances.
1689 ,r_cp_input.ORG_ID -- Org Id.
1690 ,l_batch_source_id -- Batch Source Id.
1691 ,r_cp_input.BATCH_SOURCE_NAME -- Batch Source Name.
1692 ,FND_DATE.DATE_TO_CANONICAL(TRUNC(SYSDATE)) -- Default Date.
1693 ,NULL -- Trxn Flexfield.
1694 ,NULL -- Trxn Type.
1695 ,NULL -- Bill To Customer Number Low.
1696 ,NULL -- Bill To Customer Number High.
1697 ,NULL -- Bill To Customer Name Low.
1698 ,NULL -- Bill To Customer Name High.
1699 ,NULL -- GL Date Low.
1700 ,NULL -- GL Date High.
1701 ,NULL -- Ship Date Low.
1702 ,NULL -- Ship Date High.
1703 ,NULL -- Trx Number Low. l_trx_number_low
1704 ,NULL -- Trx Number High. l_trx_number_high
1705 ,NULL -- Sales Order Low.
1706 ,NULL -- Sales Order High.
1707 ,NULL -- Trx Date Low.
1708 ,NULL -- Trx Date High.
1709 ,NULL -- Ship To Customer Number Low.
1710 ,NULL -- Ship To Customer Number High.
1711 ,NULL -- Ship To Customer Name Low.
1712 ,NULL -- Ship To Customer Name High.
1713 ,'Y' -- Base Due Date On Trx Date Flag.
1714 ,NULL -- Due Date Adjustment Days.
1715 ,CHR(0) -- End of Parameter List Indicator.
1716 ,'', '', '', '', '', '', ''
1717 ,'', '', '', '', '', '', '', '', '', ''
1718 ,'', '', '', '', '', '', '', '', '', ''
1719 ,'', '', '', '', '', '', '', '', '', ''
1720 ,'', '', '', '', '', '', '', '', '', ''
1721 ,'', '', '', '', '', '', '', '', '', ''
1722 ,'', '', '', '', '', '', '', '', '', '');
1723
1724 IF l_conc_req_id = 0 THEN
1725 FND_MESSAGE.set_name('AR','AR_EBI_CONC_PRO_SUBMIT_FAILED'); /*Concurrent program submission failed!!!!!*/
1726 FND_MSG_PUB.add;
1727 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728 END IF;
1729
1730 x_conc_req_ids.EXTEND;
1731 x_conc_req_ids(x_conc_req_ids.COUNT) :=l_conc_req_id;
1732 END LOOP;
1733 END IF;
1734
1735 IF FND_API.to_boolean(p_commit) THEN
1736 COMMIT;
1737 END IF;
1738
1739 EXCEPTION
1740 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1741 x_return_status := FND_API.G_RET_STS_ERROR;
1742 IF (x_err_msg IS NULL) THEN
1743 FND_MSG_PUB.count_and_get(
1744 p_encoded => FND_API.G_FALSE,
1745 p_count => l_msg_count,
1746 p_data => x_err_msg
1747 );
1748 END IF;
1749 ROLLBACK TO ar_ebi_invoice_sub_save_pnt;
1750
1751 WHEN OTHERS THEN
1752 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1753 x_err_msg := SQLERRM ||' at EBI_AR_PKG.ar_invoice_submission ';
1754 ROLLBACK TO ar_ebi_invoice_sub_save_pnt;
1755
1756 END ar_invoice_submission;
1757
1758
1759 END AR_EBI_INVOICE_PUB;
1760