[Home] [Help]
PACKAGE BODY: APPS.AR_TRX_GLOBAL_PROCESS_TMP
Source
1 PACKAGE BODY AR_TRX_GLOBAL_PROCESS_TMP AS
2 /* $Header: ARINGTTB.pls 120.10 2007/06/21 21:04:13 mraymond ship $ */
3 pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
4
5 PROCEDURE INSERT_ROWS (
6 p_trx_header_tbl IN AR_INVOICE_API_PUB.trx_header_tbl_type,
7 p_trx_lines_tbl IN AR_INVOICE_API_PUB.trx_line_tbl_type,
8 p_trx_dist_tbl IN AR_INVOICE_API_PUB.trx_dist_tbl_type,
9 p_trx_salescredits_tbl IN AR_INVOICE_API_PUB.trx_salescredits_tbl_type,
10 x_errmsg OUT NOCOPY VARCHAR2,
11 x_return_status OUT NOCOPY VARCHAR2
12 ) IS
13 RecExist Number;
14 BEGIN
15
16 IF pg_debug = 'Y'
17 THEN
18 ar_invoice_utils.debug ('AR_TRX_GLOBAL_PROCESS_TMP.INSERT_ROWS(+)');
19 END IF;
20
21 --For header
22 RecExist := p_trx_header_tbl.FIRST;
23 IF pg_debug = 'Y'
24 THEN
25 ar_invoice_utils.debug ('Record Count ' || RecExist);
26 END IF;
27 IF RecExist >= 1
28 THEN
29 FOR i IN p_trx_header_tbl.FIRST .. p_trx_header_tbl.LAST
30 LOOP
31 -- 4188835 added legal_entity_id
32 INSERT INTO ar_trx_header_tmp_gt (
33 TRX_HEADER_ID,
34 TRX_NUMBER,
35 TRX_DATE,
36 TRX_CURRENCY,
37 REFERENCE_NUMBER,
38 TRX_CLASS,
39 CUST_TRX_TYPE_ID,
40 GL_DATE,
41 BILL_TO_CUSTOMER_ID,
42 BILL_TO_ACCOUNT_NUMBER,
43 BILL_TO_CUSTOMER_NAME,
44 BILL_TO_CONTACT_ID,
45 BILL_TO_ADDRESS_ID,
46 BILL_TO_SITE_USE_ID,
47 SHIP_TO_CUSTOMER_ID,
48 SHIP_TO_ACCOUNT_NUMBER,
49 SHIP_TO_CUSTOMER_NAME,
50 SHIP_TO_CONTACT_ID,
51 SHIP_TO_ADDRESS_ID,
52 SHIP_TO_SITE_USE_ID,
53 SOLD_TO_CUSTOMER_ID,
54 TERM_ID,
55 PRIMARY_SALESREP_ID,
56 PRIMARY_SALESREP_NAME,
57 EXCHANGE_RATE_TYPE,
58 EXCHANGE_DATE,
59 EXCHANGE_RATE,
60 TERRITORY_ID,
61 REMIT_TO_ADDRESS_ID,
62 INVOICING_RULE_ID,
63 PRINTING_OPTION,
64 PURCHASE_ORDER,
65 PURCHASE_ORDER_REVISION,
66 PURCHASE_ORDER_DATE,
67 COMMENTS,
68 INTERNAL_NOTES,
69 FINANCE_CHARGES,
70 RECEIPT_METHOD_ID,
71 RELATED_CUSTOMER_TRX_ID,
72 AGREEMENT_ID,
73 SHIP_VIA,
74 SHIP_DATE_ACTUAL,
75 WAYBILL_NUMBER,
76 FOB_POINT,
77 CUSTOMER_BANK_ACCOUNT_ID,
78 DEFAULT_USSGL_TRANSACTION_CODE,
79 STATUS_TRX,
80 PAYING_CUSTOMER_ID,
81 PAYING_SITE_USE_ID,
82 DEFAULT_TAX_EXEMPT_FLAG,
83 DOC_SEQUENCE_VALUE,
84 ATTRIBUTE_CATEGORY,
85 ATTRIBUTE1,
86 ATTRIBUTE2,
87 ATTRIBUTE3,
88 ATTRIBUTE4,
89 ATTRIBUTE5,
90 ATTRIBUTE6,
91 ATTRIBUTE7,
92 ATTRIBUTE8,
93 ATTRIBUTE9,
94 ATTRIBUTE10,
95 ATTRIBUTE11,
96 ATTRIBUTE12,
97 ATTRIBUTE13,
98 ATTRIBUTE14,
99 ATTRIBUTE15,
100 GLOBAL_ATTRIBUTE_CATEGORY,
101 GLOBAL_ATTRIBUTE1,
102 GLOBAL_ATTRIBUTE2,
103 GLOBAL_ATTRIBUTE3,
104 GLOBAL_ATTRIBUTE4,
105 GLOBAL_ATTRIBUTE5,
106 GLOBAL_ATTRIBUTE6,
107 GLOBAL_ATTRIBUTE7,
108 GLOBAL_ATTRIBUTE8,
109 GLOBAL_ATTRIBUTE9,
110 GLOBAL_ATTRIBUTE10,
111 GLOBAL_ATTRIBUTE11,
112 GLOBAL_ATTRIBUTE12,
113 GLOBAL_ATTRIBUTE13,
114 GLOBAL_ATTRIBUTE14,
115 GLOBAL_ATTRIBUTE15,
116 GLOBAL_ATTRIBUTE16,
117 GLOBAL_ATTRIBUTE17,
118 GLOBAL_ATTRIBUTE18,
119 GLOBAL_ATTRIBUTE19,
120 GLOBAL_ATTRIBUTE20,
121 GLOBAL_ATTRIBUTE21,
122 GLOBAL_ATTRIBUTE22,
123 GLOBAL_ATTRIBUTE23,
124 GLOBAL_ATTRIBUTE24,
125 GLOBAL_ATTRIBUTE25,
126 GLOBAL_ATTRIBUTE26,
127 GLOBAL_ATTRIBUTE27,
128 GLOBAL_ATTRIBUTE28,
129 GLOBAL_ATTRIBUTE29,
130 GLOBAL_ATTRIBUTE30,
131 INTERFACE_HEADER_CONTEXT,
132 INTERFACE_HEADER_ATTRIBUTE1,
133 INTERFACE_HEADER_ATTRIBUTE2,
134 INTERFACE_HEADER_ATTRIBUTE3,
135 INTERFACE_HEADER_ATTRIBUTE4,
136 INTERFACE_HEADER_ATTRIBUTE5,
137 INTERFACE_HEADER_ATTRIBUTE6,
138 INTERFACE_HEADER_ATTRIBUTE7,
139 INTERFACE_HEADER_ATTRIBUTE8,
140 INTERFACE_HEADER_ATTRIBUTE9,
141 INTERFACE_HEADER_ATTRIBUTE10,
142 INTERFACE_HEADER_ATTRIBUTE11,
143 INTERFACE_HEADER_ATTRIBUTE12,
144 INTERFACE_HEADER_ATTRIBUTE13,
145 INTERFACE_HEADER_ATTRIBUTE14,
146 INTERFACE_HEADER_ATTRIBUTE15,
147 ORG_ID,
148 LEGAL_ENTITY_ID,
149 payment_trxn_extension_id,
150 BILLING_DATE,
151 interest_header_id,
152 late_charges_assessed,
153 DOCUMENT_SUB_TYPE,
154 DEFAULT_TAXATION_COUNTRY
155 )
156 VALUES
157 ( p_trx_header_tbl(i).TRX_HEADER_ID,
158 p_trx_header_tbl(i).TRX_NUMBER,
159 p_trx_header_tbl(i).TRX_DATE,
160 p_trx_header_tbl(i).TRX_CURRENCY,
161 p_trx_header_tbl(i).REFERENCE_NUMBER,
162 p_trx_header_tbl(i).TRX_CLASS,
163 p_trx_header_tbl(i).CUST_TRX_TYPE_ID,
164 p_trx_header_tbl(i).GL_DATE,
165 p_trx_header_tbl(i).BILL_TO_CUSTOMER_ID,
166 p_trx_header_tbl(i).BILL_TO_ACCOUNT_NUMBER,
167 p_trx_header_tbl(i).BILL_TO_CUSTOMER_NAME,
168 p_trx_header_tbl(i).BILL_TO_CONTACT_ID,
169 p_trx_header_tbl(i).BILL_TO_ADDRESS_ID,
170 p_trx_header_tbl(i).BILL_TO_SITE_USE_ID,
171 p_trx_header_tbl(i).SHIP_TO_CUSTOMER_ID,
172 p_trx_header_tbl(i).SHIP_TO_ACCOUNT_NUMBER,
173 p_trx_header_tbl(i).SHIP_TO_CUSTOMER_NAME,
174 p_trx_header_tbl(i).SHIP_TO_CONTACT_ID,
175 p_trx_header_tbl(i).SHIP_TO_ADDRESS_ID,
176 p_trx_header_tbl(i).SHIP_TO_SITE_USE_ID,
177 p_trx_header_tbl(i).SOLD_TO_CUSTOMER_ID,
178 p_trx_header_tbl(i).TERM_ID,
179 p_trx_header_tbl(i).PRIMARY_SALESREP_ID,
180 p_trx_header_tbl(i).PRIMARY_SALESREP_NAME,
181 p_trx_header_tbl(i).EXCHANGE_RATE_TYPE,
182 p_trx_header_tbl(i).EXCHANGE_DATE,
183 p_trx_header_tbl(i).EXCHANGE_RATE,
184 p_trx_header_tbl(i).TERRITORY_ID,
185 p_trx_header_tbl(i).REMIT_TO_ADDRESS_ID,
186 p_trx_header_tbl(i).INVOICING_RULE_ID,
187 p_trx_header_tbl(i).PRINTING_OPTION,
188 p_trx_header_tbl(i).PURCHASE_ORDER,
189 p_trx_header_tbl(i).PURCHASE_ORDER_REVISION,
190 p_trx_header_tbl(i).PURCHASE_ORDER_DATE,
191 p_trx_header_tbl(i).COMMENTS,
192 p_trx_header_tbl(i).INTERNAL_NOTES,
193 p_trx_header_tbl(i).FINANCE_CHARGES,
194 p_trx_header_tbl(i).RECEIPT_METHOD_ID,
195 p_trx_header_tbl(i).RELATED_CUSTOMER_TRX_ID,
196 p_trx_header_tbl(i).AGREEMENT_ID,
197 p_trx_header_tbl(i).SHIP_VIA,
198 p_trx_header_tbl(i).SHIP_DATE_ACTUAL,
199 p_trx_header_tbl(i).WAYBILL_NUMBER,
200 p_trx_header_tbl(i).FOB_POINT,
201 p_trx_header_tbl(i).CUSTOMER_BANK_ACCOUNT_ID,
202 p_trx_header_tbl(i).DEFAULT_USSGL_TRANSACTION_CODE,
203 p_trx_header_tbl(i).STATUS_TRX,
204 p_trx_header_tbl(i).PAYING_CUSTOMER_ID,
205 p_trx_header_tbl(i).PAYING_SITE_USE_ID,
206 p_trx_header_tbl(i).DEFAULT_TAX_EXEMPT_FLAG,
207 p_trx_header_tbl(i).DOC_SEQUENCE_VALUE,
208 p_trx_header_tbl(i).ATTRIBUTE_CATEGORY,
209 p_trx_header_tbl(i).ATTRIBUTE1,
210 p_trx_header_tbl(i).ATTRIBUTE2,
211 p_trx_header_tbl(i).ATTRIBUTE3,
212 p_trx_header_tbl(i).ATTRIBUTE4,
213 p_trx_header_tbl(i).ATTRIBUTE5,
214 p_trx_header_tbl(i).ATTRIBUTE6,
215 p_trx_header_tbl(i).ATTRIBUTE7,
216 p_trx_header_tbl(i).ATTRIBUTE8,
217 p_trx_header_tbl(i).ATTRIBUTE9,
218 p_trx_header_tbl(i).ATTRIBUTE10,
219 p_trx_header_tbl(i).ATTRIBUTE11,
220 p_trx_header_tbl(i).ATTRIBUTE12,
221 p_trx_header_tbl(i).ATTRIBUTE13,
222 p_trx_header_tbl(i).ATTRIBUTE14,
223 p_trx_header_tbl(i).ATTRIBUTE15,
224 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE_CATEGORY,
225 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE1,
226 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE2,
227 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE3,
228 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE4,
229 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE5,
230 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE6,
231 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE7,
232 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE8,
233 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE9,
234 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE10,
235 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE11,
236 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE12,
237 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE13,
238 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE14,
239 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE15,
240 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE16,
241 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE17,
242 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE18,
243 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE19,
244 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE20,
245 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE21,
246 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE22,
247 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE23,
248 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE24,
249 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE25,
250 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE26,
251 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE27,
252 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE28,
253 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE29,
254 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE30,
255 p_trx_header_tbl(i).INTERFACE_HEADER_CONTEXT,
256 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE1,
257 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE2,
258 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE3,
259 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE4,
260 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE5,
261 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE6,
262 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE7,
263 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE8,
264 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE9,
265 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE10,
266 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE11,
267 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE12,
268 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE13,
269 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE14,
270 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE15,
271 p_trx_header_tbl(i).org_id,
272 p_trx_header_tbl(i).legal_entity_id,
273 p_trx_header_tbl(i).payment_trxn_extension_id,
274 p_trx_header_tbl(i).BILLING_DATE,
275 p_trx_header_tbl(i).interest_header_id,
276 p_trx_header_tbl(i).late_charges_assessed,
277 p_trx_header_tbl(i).document_sub_type,
278 p_trx_header_tbl(i).default_taxation_country
279 );
280 END LOOP;
281 END IF;
282
283 --For Lines
284 RecExist := p_trx_lines_tbl.FIRST;
285 IF pg_debug = 'Y'
286 THEN
287 ar_invoice_utils.debug ('Record Count ' || RecExist);
288 END IF;
289 IF RecExist >= 1
290 THEN
291 FOR i IN p_trx_lines_tbl.FIRST .. p_trx_lines_tbl.LAST
292 LOOP
293 INSERT INTO ar_trx_lines_tmp_gt
294 ( TRX_HEADER_ID,
295 TRX_LINE_ID,
296 LINK_TO_TRX_LINE_ID,
297 LINE_NUMBER,
298 REASON_CODE,
299 INVENTORY_ITEM_ID,
300 DESCRIPTION,
301 QUANTITY_ORDERED,
302 QUANTITY_INVOICED,
303 UNIT_STANDARD_PRICE,
304 UNIT_SELLING_PRICE,
305 SALES_ORDER,
306 SALES_ORDER_LINE,
307 SALES_ORDER_DATE,
308 ACCOUNTING_RULE_ID,
309 LINE_TYPE,
310 ATTRIBUTE_CATEGORY,
311 ATTRIBUTE1,
312 ATTRIBUTE2,
313 ATTRIBUTE3,
314 ATTRIBUTE4,
315 ATTRIBUTE5,
316 ATTRIBUTE6,
317 ATTRIBUTE7,
318 ATTRIBUTE8,
319 ATTRIBUTE9,
320 ATTRIBUTE10,
321 ATTRIBUTE11,
322 ATTRIBUTE12,
323 ATTRIBUTE13,
324 ATTRIBUTE14,
325 ATTRIBUTE15,
326 RULE_START_DATE,
327 INTERFACE_LINE_CONTEXT,
328 INTERFACE_LINE_ATTRIBUTE1,
329 INTERFACE_LINE_ATTRIBUTE2,
330 INTERFACE_LINE_ATTRIBUTE3,
331 INTERFACE_LINE_ATTRIBUTE4,
332 INTERFACE_LINE_ATTRIBUTE5,
333 INTERFACE_LINE_ATTRIBUTE6,
334 INTERFACE_LINE_ATTRIBUTE7,
335 INTERFACE_LINE_ATTRIBUTE8,
336 INTERFACE_LINE_ATTRIBUTE9,
337 INTERFACE_LINE_ATTRIBUTE10,
338 INTERFACE_LINE_ATTRIBUTE11,
339 INTERFACE_LINE_ATTRIBUTE12,
340 INTERFACE_LINE_ATTRIBUTE13,
341 INTERFACE_LINE_ATTRIBUTE14,
342 INTERFACE_LINE_ATTRIBUTE15,
343 SALES_ORDER_SOURCE,
344 AMOUNT,
345 TAX_PRECEDENCE,
346 TAX_RATE,
347 TAX_EXEMPTION_ID,
348 MEMO_LINE_ID,
349 UOM_CODE,
350 DEFAULT_USSGL_TRANSACTION_CODE,
351 DEFAULT_USSGL_TRX_CODE_CONTEXT,
352 VAT_TAX_ID,
353 TAX_EXEMPT_FLAG,
354 TAX_EXEMPT_NUMBER,
355 TAX_EXEMPT_REASON_CODE,
356 TAX_VENDOR_RETURN_CODE,
357 MOVEMENT_ID,
358 GLOBAL_ATTRIBUTE1,
359 GLOBAL_ATTRIBUTE2,
360 GLOBAL_ATTRIBUTE3,
361 GLOBAL_ATTRIBUTE4,
362 GLOBAL_ATTRIBUTE5,
363 GLOBAL_ATTRIBUTE6,
364 GLOBAL_ATTRIBUTE7,
365 GLOBAL_ATTRIBUTE8,
366 GLOBAL_ATTRIBUTE9,
367 GLOBAL_ATTRIBUTE10,
368 GLOBAL_ATTRIBUTE11,
369 GLOBAL_ATTRIBUTE12,
370 GLOBAL_ATTRIBUTE13,
371 GLOBAL_ATTRIBUTE14,
372 GLOBAL_ATTRIBUTE15,
373 GLOBAL_ATTRIBUTE16,
374 GLOBAL_ATTRIBUTE17,
375 GLOBAL_ATTRIBUTE18,
376 GLOBAL_ATTRIBUTE19,
377 GLOBAL_ATTRIBUTE20,
378 GLOBAL_ATTRIBUTE_CATEGORY,
379 AMOUNT_INCLUDES_TAX_FLAG,
380 WAREHOUSE_ID,
381 CONTRACT_LINE_ID,
382 SOURCE_DATA_KEY1,
383 SOURCE_DATA_KEY2,
384 SOURCE_DATA_KEY3,
385 SOURCE_DATA_KEY4,
386 SOURCE_DATA_KEY5,
387 INVOICED_LINE_ACCTG_LEVEL,
388 SHIP_DATE_ACTUAL,
389 RULE_END_DATE,
390 SOURCE_APPLICATION_ID,
391 SOURCE_EVENT_CLASS_CODE,
392 SOURCE_ENTITY_CODE,
393 SOURCE_TRX_ID,
394 SOURCE_TRX_LINE_ID,
395 SOURCE_TRX_LINE_TYPE,
396 SOURCE_TRX_DETAIL_TAX_LINE_ID,
397 HISTORICAL_FLAG,
398 TAXABLE_FLAG,
399 TAX_REGIME_CODE,
400 TAX,
401 TAX_STATUS_CODE,
402 TAX_RATE_CODE,
403 TAX_JURISDICTION_CODE,
404 TAX_CLASSIFICATION_CODE,
405 INTEREST_LINE_ID,
406 TRX_BUSINESS_CATEGORY,
407 PRODUCT_FISC_CLASSIFICATION,
408 PRODUCT_CATEGORY,
409 PRODUCT_TYPE,
410 LINE_INTENDED_USE,
411 ASSESSABLE_VALUE
412 )
413 VALUES
414 ( p_trx_lines_tbl(i).TRX_HEADER_ID,
415 p_trx_lines_tbl(i).TRX_LINE_ID,
416 p_trx_lines_tbl(i).LINK_TO_TRX_LINE_ID,
417 p_trx_lines_tbl(i).LINE_NUMBER,
418 p_trx_lines_tbl(i).REASON_CODE,
419 p_trx_lines_tbl(i).INVENTORY_ITEM_ID,
420 p_trx_lines_tbl(i).DESCRIPTION,
421 p_trx_lines_tbl(i).QUANTITY_ORDERED,
422 p_trx_lines_tbl(i).QUANTITY_INVOICED,
423 p_trx_lines_tbl(i).UNIT_STANDARD_PRICE,
424 p_trx_lines_tbl(i).UNIT_SELLING_PRICE,
425 p_trx_lines_tbl(i).SALES_ORDER,
426 p_trx_lines_tbl(i).SALES_ORDER_LINE,
427 p_trx_lines_tbl(i).SALES_ORDER_DATE,
428 p_trx_lines_tbl(i).ACCOUNTING_RULE_ID,
429 p_trx_lines_tbl(i).LINE_TYPE,
430 p_trx_lines_tbl(i).ATTRIBUTE_CATEGORY,
431 p_trx_lines_tbl(i).ATTRIBUTE1,
432 p_trx_lines_tbl(i).ATTRIBUTE2,
433 p_trx_lines_tbl(i).ATTRIBUTE3,
434 p_trx_lines_tbl(i).ATTRIBUTE4,
435 p_trx_lines_tbl(i).ATTRIBUTE5,
436 p_trx_lines_tbl(i).ATTRIBUTE6,
437 p_trx_lines_tbl(i).ATTRIBUTE7,
438 p_trx_lines_tbl(i).ATTRIBUTE8,
439 p_trx_lines_tbl(i).ATTRIBUTE9,
440 p_trx_lines_tbl(i).ATTRIBUTE10,
441 p_trx_lines_tbl(i).ATTRIBUTE11,
442 p_trx_lines_tbl(i).ATTRIBUTE12,
443 p_trx_lines_tbl(i).ATTRIBUTE13,
444 p_trx_lines_tbl(i).ATTRIBUTE14,
445 p_trx_lines_tbl(i).ATTRIBUTE15,
446 p_trx_lines_tbl(i).RULE_START_DATE,
447 p_trx_lines_tbl(i).INTERFACE_LINE_CONTEXT,
448 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE1,
449 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE2,
450 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE3,
451 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE4,
452 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE5,
453 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE6,
454 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE7,
455 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE8,
456 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE9,
457 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE10,
458 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE11,
459 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE12,
460 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE13,
461 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE14,
462 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE15,
463 p_trx_lines_tbl(i).SALES_ORDER_SOURCE,
464 p_trx_lines_tbl(i).AMOUNT,
465 p_trx_lines_tbl(i).TAX_PRECEDENCE,
466 p_trx_lines_tbl(i).TAX_RATE,
467 p_trx_lines_tbl(i).TAX_EXEMPTION_ID,
468 p_trx_lines_tbl(i).MEMO_LINE_ID,
469 p_trx_lines_tbl(i).UOM_CODE,
470 p_trx_lines_tbl(i).DEFAULT_USSGL_TRANSACTION_CODE,
471 p_trx_lines_tbl(i).DEFAULT_USSGL_TRX_CODE_CONTEXT,
472 p_trx_lines_tbl(i).VAT_TAX_ID,
473 p_trx_lines_tbl(i).TAX_EXEMPT_FLAG,
474 p_trx_lines_tbl(i).TAX_EXEMPT_NUMBER,
475 p_trx_lines_tbl(i).TAX_EXEMPT_REASON_CODE,
476 p_trx_lines_tbl(i).TAX_VENDOR_RETURN_CODE,
477 p_trx_lines_tbl(i).MOVEMENT_ID,
478 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE1,
479 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE2,
480 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE3,
481 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE4,
482 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE5,
483 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE6,
484 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE7,
485 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE8,
486 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE9,
487 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE10,
488 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE11,
489 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE12,
490 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE13,
491 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE14,
492 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE15,
493 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE16,
494 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE17,
495 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE18,
496 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE19,
497 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE20,
498 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE_CATEGORY,
499 p_trx_lines_tbl(i).AMOUNT_INCLUDES_TAX_FLAG,
500 p_trx_lines_tbl(i).WAREHOUSE_ID,
501 p_trx_lines_tbl(i).CONTRACT_LINE_ID,
502 p_trx_lines_tbl(i).SOURCE_DATA_KEY1,
503 p_trx_lines_tbl(i).SOURCE_DATA_KEY2,
504 p_trx_lines_tbl(i).SOURCE_DATA_KEY3,
505 p_trx_lines_tbl(i).SOURCE_DATA_KEY4,
506 p_trx_lines_tbl(i).SOURCE_DATA_KEY5,
507 p_trx_lines_tbl(i).INVOICED_LINE_ACCTG_LEVEL,
508 p_trx_lines_tbl(i).SHIP_DATE_ACTUAL,
509 p_trx_lines_tbl(i).rule_end_date,
510 p_trx_lines_tbl(i).source_application_id,
511 p_trx_lines_tbl(i).source_event_class_code,
512 p_trx_lines_tbl(i).source_entity_code,
513 p_trx_lines_tbl(i).source_trx_id,
514 p_trx_lines_tbl(i).source_trx_line_id,
515 p_trx_lines_tbl(i).source_trx_line_type,
516 p_trx_lines_tbl(i).source_trx_detail_tax_line_id,
517 p_trx_lines_tbl(i).historical_flag,
518 p_trx_lines_tbl(i).taxable_flag,
519 p_trx_lines_tbl(i).tax_regime_code,
520 p_trx_lines_tbl(i).tax,
521 p_trx_lines_tbl(i).tax_status_code,
522 p_trx_lines_tbl(i).tax_rate_code,
523 p_trx_lines_tbl(i).tax_jurisdiction_code,
524 p_trx_lines_tbl(i).tax_classification_code,
525 p_trx_lines_tbl(i).interest_line_id,
526 p_trx_lines_tbl(i).trx_business_category,
527 p_trx_lines_tbl(i).product_fisc_classification,
528 p_trx_lines_tbl(i).product_category,
529 p_trx_lines_tbl(i).product_type,
530 p_trx_lines_tbl(i).line_intended_use,
531 p_trx_lines_tbl(i).assessable_value
532 );
533
534 END LOOP;
535 END IF;
536
537 RecExist := p_trx_dist_tbl.FIRST;
538 IF pg_debug = 'Y'
539 THEN
540 ar_invoice_utils.debug ('Record Count ' || RecExist);
541 END IF;
542 IF RecExist >= 1
543 THEN
544 FOR i IN p_trx_dist_tbl.FIRST .. p_trx_dist_tbl.LAST
545 LOOP
546 INSERT INTO ar_trx_dist_tmp_gt
547 ( TRX_DIST_ID,
548 TRX_HEADER_ID,
549 TRX_LINE_ID,
550 ACCOUNT_CLASS,
551 AMOUNT,
552 ACCTD_AMOUNT,
553 PERCENT,
554 CODE_COMBINATION_ID,
555 ATTRIBUTE_CATEGORY,
556 ATTRIBUTE1,
557 ATTRIBUTE2,
558 ATTRIBUTE3,
559 ATTRIBUTE4,
560 ATTRIBUTE5,
561 ATTRIBUTE6,
562 ATTRIBUTE7,
563 ATTRIBUTE8,
564 ATTRIBUTE9,
565 ATTRIBUTE10,
566 ATTRIBUTE11,
567 ATTRIBUTE12,
568 ATTRIBUTE13,
569 ATTRIBUTE14,
570 ATTRIBUTE15,
571 COMMENTS)
572 VALUES
573 ( p_trx_dist_tbl(i).TRX_DIST_ID,
574 p_trx_dist_tbl(i).TRX_HEADER_ID,
575 p_trx_dist_tbl(i).TRX_LINE_ID,
576 p_trx_dist_tbl(i).ACCOUNT_CLASS,
577 p_trx_dist_tbl(i).AMOUNT,
578 p_trx_dist_tbl(i).ACCTD_AMOUNT,
579 p_trx_dist_tbl(i).PERCENT,
580 p_trx_dist_tbl(i).CODE_COMBINATION_ID,
581 p_trx_dist_tbl(i).ATTRIBUTE_CATEGORY,
582 p_trx_dist_tbl(i).ATTRIBUTE1,
583 p_trx_dist_tbl(i).ATTRIBUTE2,
584 p_trx_dist_tbl(i).ATTRIBUTE3,
585 p_trx_dist_tbl(i).ATTRIBUTE4,
586 p_trx_dist_tbl(i).ATTRIBUTE5,
587 p_trx_dist_tbl(i).ATTRIBUTE6,
588 p_trx_dist_tbl(i).ATTRIBUTE7,
589 p_trx_dist_tbl(i).ATTRIBUTE8,
590 p_trx_dist_tbl(i).ATTRIBUTE9,
591 p_trx_dist_tbl(i).ATTRIBUTE10,
592 p_trx_dist_tbl(i).ATTRIBUTE11,
593 p_trx_dist_tbl(i).ATTRIBUTE12,
594 p_trx_dist_tbl(i).ATTRIBUTE13,
595 p_trx_dist_tbl(i).ATTRIBUTE14,
596 p_trx_dist_tbl(i).ATTRIBUTE15,
597 p_trx_dist_tbl(i).COMMENTS
598 );
599
600 END LOOP;
601
602 END If;
603
604
605 RecExist := p_trx_salescredits_tbl.FIRST;
606 IF pg_debug = 'Y'
607 THEN
608 ar_invoice_utils.debug ('Record Count ' || RecExist);
609 END IF;
610 IF RecExist >= 1
611 THEN
612 FOR i IN p_trx_salescredits_tbl.FIRST .. p_trx_salescredits_tbl.LAST
613 LOOP
614 INSERT INTO ar_trx_salescredits_tmp_gt
615 ( TRX_SALESCREDIT_ID,
616 TRX_LINE_ID,
617 SALESREP_ID,
618 SALESREP_NUMBER,
619 SALES_CREDIT_TYPE_NAME,
620 SALES_CREDIT_TYPE_ID,
621 SALESCREDIT_AMOUNT_SPLIT,
622 SALESCREDIT_PERCENT_SPLIT,
623 ATTRIBUTE_CATEGORY,
624 ATTRIBUTE1,
625 ATTRIBUTE2,
626 ATTRIBUTE3,
627 ATTRIBUTE4,
628 ATTRIBUTE5,
629 ATTRIBUTE6,
630 ATTRIBUTE7,
631 ATTRIBUTE8,
632 ATTRIBUTE9,
633 ATTRIBUTE10,
634 ATTRIBUTE11,
635 ATTRIBUTE12,
636 ATTRIBUTE13,
637 ATTRIBUTE14,
638 ATTRIBUTE15
639 )
640 VALUES
641 ( p_trx_salescredits_tbl(i).TRX_SALESCREDIT_ID,
642 p_trx_salescredits_tbl(i).TRX_LINE_ID,
643 p_trx_salescredits_tbl(i).SALESREP_ID,
644 p_trx_salescredits_tbl(i).SALESREP_NUMBER,
645 p_trx_salescredits_tbl(i).SALES_CREDIT_TYPE_NAME,
646 p_trx_salescredits_tbl(i).SALES_CREDIT_TYPE_ID,
647 p_trx_salescredits_tbl(i).SALESCREDIT_AMOUNT_SPLIT,
648 p_trx_salescredits_tbl(i).SALESCREDIT_PERCENT_SPLIT,
649 p_trx_salescredits_tbl(i).ATTRIBUTE_CATEGORY,
650 p_trx_salescredits_tbl(i).ATTRIBUTE1,
651 p_trx_salescredits_tbl(i).ATTRIBUTE2,
652 p_trx_salescredits_tbl(i).ATTRIBUTE3,
653 p_trx_salescredits_tbl(i).ATTRIBUTE4,
654 p_trx_salescredits_tbl(i).ATTRIBUTE5,
655 p_trx_salescredits_tbl(i).ATTRIBUTE6,
656 p_trx_salescredits_tbl(i).ATTRIBUTE7,
657 p_trx_salescredits_tbl(i).ATTRIBUTE8,
658 p_trx_salescredits_tbl(i).ATTRIBUTE9,
659 p_trx_salescredits_tbl(i).ATTRIBUTE10,
660 p_trx_salescredits_tbl(i).ATTRIBUTE11,
661 p_trx_salescredits_tbl(i).ATTRIBUTE12,
662 p_trx_salescredits_tbl(i).ATTRIBUTE13,
663 p_trx_salescredits_tbl(i).ATTRIBUTE14,
664 p_trx_salescredits_tbl(i).ATTRIBUTE15
665 );
666
667 END LOOP;
668 END IF;
669
670 IF pg_debug = 'Y'
671 THEN
672 ar_invoice_utils.debug ('AR_TRX_GLOBAL_PROCESS_TMP.INSERT_ROWS(-)');
673 END IF;
674
675
676 EXCEPTION
677 WHEN OTHERS THEN
678 x_errmsg := 'Error in AR_TRX_GLOBAL_PROCESS_TMP.INSERT_ROWS '||sqlerrm;
679 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680 RETURN;
681
682 END INSERT_ROWS;
683
684 PROCEDURE GET_ROWS (
685 p_org_id IN NUMBER DEFAULT NULL,
686 p_trx_header_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_header_tbl_type,
687 p_trx_lines_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_line_tbl_type,
688 p_trx_dist_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_dist_tbl_type,
689 p_trx_salescredits_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_salescredits_tbl_type,
690 x_errmsg OUT NOCOPY VARCHAR2,
691 x_return_status OUT NOCOPY VARCHAR2
692 ) AS
693
694 cursor hdr_cur (p_org_id number) is
695 select *
696 from ar_trx_header_tmp_gt
697 where nvl(org_id,-99) = nvl(p_org_id,-99);
698
699 cursor ln_cur (P_TRX_HEADER_ID number) is
700 select *
701 from ar_trx_lines_tmp_gt
702 where TRX_HEADER_ID = P_TRX_HEADER_ID;
703
704 /* 4652982 - Modified to only insert line-level dists */
705 cursor dist_cur (P_TRX_LINE_ID number ) is
706 select *
707 from ar_trx_dist_tmp_gt
708 where TRX_LINE_ID = P_TRX_LINE_ID;
709
710 /* 4652982 - Added to insert header-level dists */
711 cursor dist_rec_cur (P_TRX_HEADER_ID number) is
712 select *
713 from ar_trx_dist_tmp_gt
714 where TRX_HEADER_ID = P_TRX_HEADER_ID
715 and TRX_LINE_ID is NULL;
716
717 cursor sc_cur (P_TRX_HEADER_ID number, P_TRX_LINE_ID number) is
718 select *
719 from ar_trx_salescredits_tmp_gt
720 where --(TRX_HEADER_ID = P_TRX_HEADER_ID) or
721 (TRX_LINE_ID = P_TRX_LINE_ID);
722 i number :=0;
723 j number :=0;
724 k number :=0;
725 l number :=0;
726 BEGIN
727
728 FOR hdr_rec in hdr_cur(p_org_id) LOOP
729 i := i+1;
730 -- put header record
731 p_trx_header_tbl(i).TRX_HEADER_ID:= hdr_rec.TRX_HEADER_ID;
732 p_trx_header_tbl(i).TRX_NUMBER:= hdr_rec.TRX_NUMBER;
733 p_trx_header_tbl(i).TRX_DATE:= hdr_rec.TRX_DATE;
734 p_trx_header_tbl(i).TRX_CURRENCY:= hdr_rec.TRX_CURRENCY;
735 p_trx_header_tbl(i).REFERENCE_NUMBER:= hdr_rec.REFERENCE_NUMBER;
736 p_trx_header_tbl(i).TRX_CLASS:= hdr_rec.TRX_CLASS;
737 p_trx_header_tbl(i).CUST_TRX_TYPE_ID:= hdr_rec.CUST_TRX_TYPE_ID;
738 p_trx_header_tbl(i).GL_DATE:= hdr_rec.GL_DATE;
739 p_trx_header_tbl(i).BILL_TO_CUSTOMER_ID:= hdr_rec.BILL_TO_CUSTOMER_ID;
740 p_trx_header_tbl(i).BILL_TO_ACCOUNT_NUMBER:= hdr_rec.BILL_TO_ACCOUNT_NUMBER;
741 p_trx_header_tbl(i).BILL_TO_CUSTOMER_NAME:= hdr_rec.BILL_TO_CUSTOMER_NAME;
742 p_trx_header_tbl(i).BILL_TO_CONTACT_ID:= hdr_rec.BILL_TO_CONTACT_ID;
743 p_trx_header_tbl(i).BILL_TO_ADDRESS_ID:= hdr_rec.BILL_TO_ADDRESS_ID;
744 p_trx_header_tbl(i).BILL_TO_SITE_USE_ID:= hdr_rec.BILL_TO_SITE_USE_ID;
745 p_trx_header_tbl(i).SHIP_TO_CUSTOMER_ID:= hdr_rec.SHIP_TO_CUSTOMER_ID;
746 p_trx_header_tbl(i).SHIP_TO_ACCOUNT_NUMBER:= hdr_rec.SHIP_TO_ACCOUNT_NUMBER;
747 p_trx_header_tbl(i).SHIP_TO_CUSTOMER_NAME:= hdr_rec.SHIP_TO_CUSTOMER_NAME;
748 p_trx_header_tbl(i).SHIP_TO_CONTACT_ID:= hdr_rec.SHIP_TO_CONTACT_ID;
749 p_trx_header_tbl(i).SHIP_TO_ADDRESS_ID:= hdr_rec.SHIP_TO_ADDRESS_ID;
750 p_trx_header_tbl(i).SHIP_TO_SITE_USE_ID:= hdr_rec.SHIP_TO_SITE_USE_ID;
751 p_trx_header_tbl(i).SOLD_TO_CUSTOMER_ID:= hdr_rec.SOLD_TO_CUSTOMER_ID;
752 p_trx_header_tbl(i).TERM_ID:= hdr_rec.TERM_ID;
753 p_trx_header_tbl(i).PRIMARY_SALESREP_ID:= hdr_rec.PRIMARY_SALESREP_ID;
754 p_trx_header_tbl(i).PRIMARY_SALESREP_NAME:= hdr_rec.PRIMARY_SALESREP_NAME;
755 p_trx_header_tbl(i).EXCHANGE_RATE_TYPE:= hdr_rec.EXCHANGE_RATE_TYPE;
756 p_trx_header_tbl(i).EXCHANGE_DATE:= hdr_rec.EXCHANGE_DATE;
757 p_trx_header_tbl(i).EXCHANGE_RATE:= hdr_rec.EXCHANGE_RATE;
758 p_trx_header_tbl(i).TERRITORY_ID:= hdr_rec.TERRITORY_ID;
759 p_trx_header_tbl(i).REMIT_TO_ADDRESS_ID:= hdr_rec.REMIT_TO_ADDRESS_ID;
760 p_trx_header_tbl(i).INVOICING_RULE_ID:= hdr_rec.INVOICING_RULE_ID;
761 p_trx_header_tbl(i).PRINTING_OPTION:= hdr_rec.PRINTING_OPTION;
762 p_trx_header_tbl(i).PURCHASE_ORDER:= hdr_rec.PURCHASE_ORDER;
763 p_trx_header_tbl(i).PURCHASE_ORDER_REVISION:= hdr_rec.PURCHASE_ORDER_REVISION;
764 p_trx_header_tbl(i).PURCHASE_ORDER_DATE:= hdr_rec.PURCHASE_ORDER_DATE;
765 p_trx_header_tbl(i).COMMENTS:= hdr_rec.COMMENTS;
766 p_trx_header_tbl(i).INTERNAL_NOTES:= hdr_rec.INTERNAL_NOTES;
767 p_trx_header_tbl(i).FINANCE_CHARGES:= hdr_rec.FINANCE_CHARGES;
768 p_trx_header_tbl(i).RECEIPT_METHOD_ID:= hdr_rec.RECEIPT_METHOD_ID;
769 p_trx_header_tbl(i).RELATED_CUSTOMER_TRX_ID:= hdr_rec.RELATED_CUSTOMER_TRX_ID;
770 p_trx_header_tbl(i).AGREEMENT_ID:= hdr_rec.AGREEMENT_ID;
771 p_trx_header_tbl(i).SHIP_VIA:= hdr_rec.SHIP_VIA;
772 p_trx_header_tbl(i).SHIP_DATE_ACTUAL:= hdr_rec.SHIP_DATE_ACTUAL;
773 p_trx_header_tbl(i).WAYBILL_NUMBER:= hdr_rec.WAYBILL_NUMBER;
774 p_trx_header_tbl(i).FOB_POINT:= hdr_rec.FOB_POINT;
775 p_trx_header_tbl(i).CUSTOMER_BANK_ACCOUNT_ID:= hdr_rec.CUSTOMER_BANK_ACCOUNT_ID;
776 p_trx_header_tbl(i).DEFAULT_USSGL_TRANSACTION_CODE:= hdr_rec.DEFAULT_USSGL_TRANSACTION_CODE;
777 p_trx_header_tbl(i).STATUS_TRX:= hdr_rec.STATUS_TRX;
778 p_trx_header_tbl(i).PAYING_CUSTOMER_ID:= hdr_rec.PAYING_CUSTOMER_ID;
779 p_trx_header_tbl(i).PAYING_SITE_USE_ID:= hdr_rec.PAYING_SITE_USE_ID;
780 p_trx_header_tbl(i).DEFAULT_TAX_EXEMPT_FLAG:= hdr_rec.DEFAULT_TAX_EXEMPT_FLAG;
781 p_trx_header_tbl(i).DOC_SEQUENCE_VALUE:= hdr_rec.DOC_SEQUENCE_VALUE;
782 p_trx_header_tbl(i).ATTRIBUTE_CATEGORY:= hdr_rec.ATTRIBUTE_CATEGORY;
783 p_trx_header_tbl(i).ATTRIBUTE1:= hdr_rec.ATTRIBUTE1;
784 p_trx_header_tbl(i).ATTRIBUTE2:= hdr_rec.ATTRIBUTE2;
785 p_trx_header_tbl(i).ATTRIBUTE3:= hdr_rec.ATTRIBUTE3;
786 p_trx_header_tbl(i).ATTRIBUTE4:= hdr_rec.ATTRIBUTE4;
787 p_trx_header_tbl(i).ATTRIBUTE5:= hdr_rec.ATTRIBUTE5;
788 p_trx_header_tbl(i).ATTRIBUTE6:= hdr_rec.ATTRIBUTE6;
789 p_trx_header_tbl(i).ATTRIBUTE7:= hdr_rec.ATTRIBUTE7;
790 p_trx_header_tbl(i).ATTRIBUTE8:= hdr_rec.ATTRIBUTE8;
791 p_trx_header_tbl(i).ATTRIBUTE9:= hdr_rec.ATTRIBUTE9;
792 p_trx_header_tbl(i).ATTRIBUTE10:= hdr_rec.ATTRIBUTE10;
793 p_trx_header_tbl(i).ATTRIBUTE11:= hdr_rec.ATTRIBUTE11;
794 p_trx_header_tbl(i).ATTRIBUTE12:= hdr_rec.ATTRIBUTE12;
795 p_trx_header_tbl(i).ATTRIBUTE13:= hdr_rec.ATTRIBUTE13;
796 p_trx_header_tbl(i).ATTRIBUTE14:= hdr_rec.ATTRIBUTE14;
797 p_trx_header_tbl(i).ATTRIBUTE15:= hdr_rec.ATTRIBUTE15;
798 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE_CATEGORY:= hdr_rec.GLOBAL_ATTRIBUTE_CATEGORY;
799 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE1:= hdr_rec.GLOBAL_ATTRIBUTE1;
800 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE2:= hdr_rec.GLOBAL_ATTRIBUTE2;
801 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE3:= hdr_rec.GLOBAL_ATTRIBUTE3;
802 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE4:= hdr_rec.GLOBAL_ATTRIBUTE4;
803 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE5:= hdr_rec.GLOBAL_ATTRIBUTE5;
804 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE6:= hdr_rec.GLOBAL_ATTRIBUTE6;
805 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE7:= hdr_rec.GLOBAL_ATTRIBUTE7;
806 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE8:= hdr_rec.GLOBAL_ATTRIBUTE8;
807 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE9:= hdr_rec.GLOBAL_ATTRIBUTE9;
808 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE10:= hdr_rec.GLOBAL_ATTRIBUTE10;
809 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE11:= hdr_rec.GLOBAL_ATTRIBUTE11;
810 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE12:= hdr_rec.GLOBAL_ATTRIBUTE12;
811 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE13:= hdr_rec.GLOBAL_ATTRIBUTE13;
812 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE14:= hdr_rec.GLOBAL_ATTRIBUTE14;
813 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE15:= hdr_rec.GLOBAL_ATTRIBUTE15;
814 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE16:= hdr_rec.GLOBAL_ATTRIBUTE16;
815 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE17:= hdr_rec.GLOBAL_ATTRIBUTE17;
816 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE18:= hdr_rec.GLOBAL_ATTRIBUTE18;
817 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE19:= hdr_rec.GLOBAL_ATTRIBUTE19;
818 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE20:= hdr_rec.GLOBAL_ATTRIBUTE20;
819 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE21:= hdr_rec.GLOBAL_ATTRIBUTE21;
820 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE22:= hdr_rec.GLOBAL_ATTRIBUTE22;
821 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE23:= hdr_rec.GLOBAL_ATTRIBUTE23;
822 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE24:= hdr_rec.GLOBAL_ATTRIBUTE24;
823 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE25:= hdr_rec.GLOBAL_ATTRIBUTE25;
824 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE26:= hdr_rec.GLOBAL_ATTRIBUTE26;
825 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE27:= hdr_rec.GLOBAL_ATTRIBUTE27;
826 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE28:= hdr_rec.GLOBAL_ATTRIBUTE28;
827 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE29:= hdr_rec.GLOBAL_ATTRIBUTE29;
828 p_trx_header_tbl(i).GLOBAL_ATTRIBUTE30:= hdr_rec.GLOBAL_ATTRIBUTE30;
829 p_trx_header_tbl(i).INTERFACE_HEADER_CONTEXT:= hdr_rec.INTERFACE_HEADER_CONTEXT;
830 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE1:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE1;
831 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE2:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE2;
832 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE3:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE3;
833 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE4:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE4;
834 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE5:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE5;
835 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE6:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE6;
836 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE7:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE7;
837 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE8:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE8;
838 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE9:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE9;
839 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE10:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE10;
840 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE11:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE11;
841 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE12:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE12;
842 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE13:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE13;
843 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE14:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE14;
844 p_trx_header_tbl(i).INTERFACE_HEADER_ATTRIBUTE15:= hdr_rec.INTERFACE_HEADER_ATTRIBUTE15;
845 p_trx_header_tbl(i).ORG_ID:= hdr_rec.ORG_ID;
846 -- 4188835
847 p_trx_header_tbl(i).LEGAL_ENTITY_ID := hdr_rec.LEGAL_ENTITY_ID;
848 p_trx_header_tbl(i).PAYMENT_TRXN_EXTENSION_ID := hdr_rec.PAYMENT_TRXN_EXTENSION_ID;
849 p_trx_header_tbl(i).BILLING_DATE := hdr_rec.BILLING_DATE;
850 --Late Charges
851 p_trx_header_tbl(i).INTEREST_HEADER_ID := hdr_rec.INTEREST_HEADER_ID;
852 p_trx_header_tbl(i).LATE_CHARGES_ASSESSED := hdr_rec.LATE_CHARGES_ASSESSED;
853 p_trx_header_tbl(i).DOCUMENT_SUB_TYPE := hdr_rec.document_sub_type;
854 p_trx_header_tbl(i).DEFAULT_TAXATION_COUNTRY := hdr_rec.default_taxation_country;
855 FOR ln_rec in ln_cur(hdr_rec.trx_header_id) LOOP
856 j :=j+1;
857 p_trx_lines_tbl(j).TRX_HEADER_ID :=ln_rec.TRX_HEADER_ID;
858 p_trx_lines_tbl(j).TRX_LINE_ID :=ln_rec.TRX_LINE_ID;
859 p_trx_lines_tbl(j).LINK_TO_TRX_LINE_ID :=ln_rec.LINK_TO_TRX_LINE_ID;
860 p_trx_lines_tbl(j).LINE_NUMBER :=ln_rec.LINE_NUMBER;
861 p_trx_lines_tbl(j).REASON_CODE :=ln_rec.REASON_CODE;
862 p_trx_lines_tbl(j).INVENTORY_ITEM_ID :=ln_rec.INVENTORY_ITEM_ID;
863 p_trx_lines_tbl(j).DESCRIPTION :=ln_rec.DESCRIPTION;
864 p_trx_lines_tbl(j).QUANTITY_ORDERED :=ln_rec.QUANTITY_ORDERED;
865 p_trx_lines_tbl(j).QUANTITY_INVOICED :=ln_rec.QUANTITY_INVOICED;
866 p_trx_lines_tbl(j).UNIT_STANDARD_PRICE :=ln_rec.UNIT_STANDARD_PRICE;
867 p_trx_lines_tbl(j).UNIT_SELLING_PRICE :=ln_rec.UNIT_SELLING_PRICE;
868 p_trx_lines_tbl(j).SALES_ORDER :=ln_rec.SALES_ORDER;
869 p_trx_lines_tbl(j).SALES_ORDER_LINE :=ln_rec.SALES_ORDER_LINE;
870 p_trx_lines_tbl(j).SALES_ORDER_DATE :=ln_rec.SALES_ORDER_DATE;
871 p_trx_lines_tbl(j).ACCOUNTING_RULE_ID :=ln_rec.ACCOUNTING_RULE_ID;
872 p_trx_lines_tbl(j).LINE_TYPE :=ln_rec.LINE_TYPE;
873 p_trx_lines_tbl(j).ATTRIBUTE_CATEGORY :=ln_rec.ATTRIBUTE_CATEGORY;
874 p_trx_lines_tbl(j).ATTRIBUTE1 :=ln_rec.ATTRIBUTE1;
875 p_trx_lines_tbl(j).ATTRIBUTE2 :=ln_rec.ATTRIBUTE2;
876 p_trx_lines_tbl(j).ATTRIBUTE3 :=ln_rec.ATTRIBUTE3;
877 p_trx_lines_tbl(j).ATTRIBUTE4 :=ln_rec.ATTRIBUTE4;
878 p_trx_lines_tbl(j).ATTRIBUTE5 :=ln_rec.ATTRIBUTE5;
879 p_trx_lines_tbl(j).ATTRIBUTE6 :=ln_rec.ATTRIBUTE6;
880 p_trx_lines_tbl(j).ATTRIBUTE7 :=ln_rec.ATTRIBUTE7;
881 p_trx_lines_tbl(j).ATTRIBUTE8 :=ln_rec.ATTRIBUTE8;
882 p_trx_lines_tbl(j).ATTRIBUTE9 :=ln_rec.ATTRIBUTE9;
883 p_trx_lines_tbl(j).ATTRIBUTE10 :=ln_rec.ATTRIBUTE10;
884 p_trx_lines_tbl(j).ATTRIBUTE11 :=ln_rec.ATTRIBUTE11;
885 p_trx_lines_tbl(j).ATTRIBUTE12 :=ln_rec.ATTRIBUTE12;
886 p_trx_lines_tbl(j).ATTRIBUTE13 :=ln_rec.ATTRIBUTE13;
887 p_trx_lines_tbl(j).ATTRIBUTE14 :=ln_rec.ATTRIBUTE14;
888 p_trx_lines_tbl(j).ATTRIBUTE15 :=ln_rec.ATTRIBUTE15;
889 p_trx_lines_tbl(j).RULE_START_DATE :=ln_rec.RULE_START_DATE;
890 p_trx_lines_tbl(j).INTERFACE_LINE_CONTEXT :=ln_rec.INTERFACE_LINE_CONTEXT;
891 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE1 :=ln_rec.INTERFACE_LINE_ATTRIBUTE1;
892 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE2 :=ln_rec.INTERFACE_LINE_ATTRIBUTE2;
893 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE3 :=ln_rec.INTERFACE_LINE_ATTRIBUTE3;
894 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE4 :=ln_rec.INTERFACE_LINE_ATTRIBUTE4;
895 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE5 :=ln_rec.INTERFACE_LINE_ATTRIBUTE5;
896 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE6 :=ln_rec.INTERFACE_LINE_ATTRIBUTE6;
897 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE7 :=ln_rec.INTERFACE_LINE_ATTRIBUTE7;
898 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE8 :=ln_rec.INTERFACE_LINE_ATTRIBUTE8;
899 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE9 :=ln_rec.INTERFACE_LINE_ATTRIBUTE9;
900 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE10 :=ln_rec.INTERFACE_LINE_ATTRIBUTE10;
901 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE11 :=ln_rec.INTERFACE_LINE_ATTRIBUTE11;
902 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE12 :=ln_rec.INTERFACE_LINE_ATTRIBUTE12;
903 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE13 :=ln_rec.INTERFACE_LINE_ATTRIBUTE13;
904 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE14 :=ln_rec.INTERFACE_LINE_ATTRIBUTE14;
905 p_trx_lines_tbl(j).INTERFACE_LINE_ATTRIBUTE15 :=ln_rec.INTERFACE_LINE_ATTRIBUTE15;
906 p_trx_lines_tbl(j).SALES_ORDER_SOURCE :=ln_rec.SALES_ORDER_SOURCE;
907 p_trx_lines_tbl(j).AMOUNT :=ln_rec.AMOUNT;
908 p_trx_lines_tbl(j).TAX_PRECEDENCE :=ln_rec.TAX_PRECEDENCE;
909 p_trx_lines_tbl(j).TAX_RATE :=ln_rec.TAX_RATE;
910 p_trx_lines_tbl(j).TAX_EXEMPTION_ID :=ln_rec.TAX_EXEMPTION_ID;
911 p_trx_lines_tbl(j).MEMO_LINE_ID :=ln_rec.MEMO_LINE_ID;
912 p_trx_lines_tbl(j).UOM_CODE :=ln_rec.UOM_CODE;
913 p_trx_lines_tbl(j).DEFAULT_USSGL_TRANSACTION_CODE :=ln_rec.DEFAULT_USSGL_TRANSACTION_CODE;
914 p_trx_lines_tbl(j).DEFAULT_USSGL_TRX_CODE_CONTEXT :=ln_rec.DEFAULT_USSGL_TRX_CODE_CONTEXT;
915 p_trx_lines_tbl(j).VAT_TAX_ID :=ln_rec.VAT_TAX_ID;
916 p_trx_lines_tbl(j).TAX_EXEMPT_FLAG :=ln_rec.TAX_EXEMPT_FLAG;
917 p_trx_lines_tbl(j).TAX_EXEMPT_NUMBER :=ln_rec.TAX_EXEMPT_NUMBER;
918 p_trx_lines_tbl(j).TAX_EXEMPT_REASON_CODE :=ln_rec.TAX_EXEMPT_REASON_CODE;
919 p_trx_lines_tbl(j).TAX_VENDOR_RETURN_CODE :=ln_rec.TAX_VENDOR_RETURN_CODE;
920 p_trx_lines_tbl(j).MOVEMENT_ID :=ln_rec.MOVEMENT_ID;
921 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE1 :=ln_rec.GLOBAL_ATTRIBUTE1;
922 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE2 :=ln_rec.GLOBAL_ATTRIBUTE2;
923 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE3 :=ln_rec.GLOBAL_ATTRIBUTE3;
924 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE4 :=ln_rec.GLOBAL_ATTRIBUTE4;
925 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE5 :=ln_rec.GLOBAL_ATTRIBUTE5;
926 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE6 :=ln_rec.GLOBAL_ATTRIBUTE6;
927 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE7 :=ln_rec.GLOBAL_ATTRIBUTE7;
928 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE8 :=ln_rec.GLOBAL_ATTRIBUTE8;
929 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE9 :=ln_rec.GLOBAL_ATTRIBUTE9;
930 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE10 :=ln_rec.GLOBAL_ATTRIBUTE10;
931 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE11 :=ln_rec.GLOBAL_ATTRIBUTE11;
932 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE12 :=ln_rec.GLOBAL_ATTRIBUTE12;
933 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE13 :=ln_rec.GLOBAL_ATTRIBUTE13;
934 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE14 :=ln_rec.GLOBAL_ATTRIBUTE14;
935 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE15 :=ln_rec.GLOBAL_ATTRIBUTE15;
936 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE16 :=ln_rec.GLOBAL_ATTRIBUTE16;
937 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE17 :=ln_rec.GLOBAL_ATTRIBUTE17;
938 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE18 :=ln_rec.GLOBAL_ATTRIBUTE18;
939 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE19 :=ln_rec.GLOBAL_ATTRIBUTE19;
940 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE20 :=ln_rec.GLOBAL_ATTRIBUTE20;
941 p_trx_lines_tbl(j).GLOBAL_ATTRIBUTE_CATEGORY :=ln_rec.GLOBAL_ATTRIBUTE_CATEGORY;
942 p_trx_lines_tbl(j).AMOUNT_INCLUDES_TAX_FLAG :=ln_rec.AMOUNT_INCLUDES_TAX_FLAG;
943 p_trx_lines_tbl(j).WAREHOUSE_ID :=ln_rec.WAREHOUSE_ID;
944 p_trx_lines_tbl(j).CONTRACT_LINE_ID :=ln_rec.CONTRACT_LINE_ID;
945 p_trx_lines_tbl(j).SOURCE_DATA_KEY1 :=ln_rec.SOURCE_DATA_KEY1;
946 p_trx_lines_tbl(j).SOURCE_DATA_KEY2 :=ln_rec.SOURCE_DATA_KEY2;
947 p_trx_lines_tbl(j).SOURCE_DATA_KEY3 :=ln_rec.SOURCE_DATA_KEY3;
948 p_trx_lines_tbl(j).SOURCE_DATA_KEY4 :=ln_rec.SOURCE_DATA_KEY4;
949 p_trx_lines_tbl(j).SOURCE_DATA_KEY5 :=ln_rec.SOURCE_DATA_KEY5;
950 p_trx_lines_tbl(j).INVOICED_LINE_ACCTG_LEVEL :=ln_rec.INVOICED_LINE_ACCTG_LEVEL;
951 p_trx_lines_tbl(j).SHIP_DATE_ACTUAL :=ln_rec.SHIP_DATE_ACTUAL;
952 p_trx_lines_tbl(j).RULE_END_DATE :=ln_rec.RULE_END_DATE;
953 p_trx_lines_tbl(j).SOURCE_APPLICATION_ID :=ln_rec.SOURCE_APPLICATION_ID;
954 p_trx_lines_tbl(j).SOURCE_EVENT_CLASS_CODE :=ln_rec.SOURCE_EVENT_CLASS_CODE;
955 p_trx_lines_tbl(j).SOURCE_ENTITY_CODE :=ln_rec.SOURCE_ENTITY_CODE;
956 p_trx_lines_tbl(j).SOURCE_TRX_ID :=ln_rec.SOURCE_TRX_ID;
957 p_trx_lines_tbl(j).SOURCE_TRX_LINE_ID :=ln_rec.SOURCE_TRX_LINE_ID;
958 p_trx_lines_tbl(j).SOURCE_TRX_LINE_TYPE :=ln_rec.SOURCE_TRX_LINE_TYPE;
959 p_trx_lines_tbl(j).SOURCE_TRX_DETAIL_TAX_LINE_ID :=
960 ln_rec.SOURCE_TRX_DETAIL_TAX_LINE_ID;
961 p_trx_lines_tbl(j).HISTORICAL_FLAG :=ln_rec.HISTORICAL_FLAG;
962 p_trx_lines_tbl(j).TAXABLE_FLAG :=ln_rec.TAXABLE_FLAG;
963 p_trx_lines_tbl(j).TAX_REGIME_CODE :=ln_rec.TAX_REGIME_CODE;
964 p_trx_lines_tbl(j).TAX :=ln_rec.TAX;
965 p_trx_lines_tbl(j).TAX_STATUS_CODE :=ln_rec.TAX_STATUS_CODE;
966 p_trx_lines_tbl(j).TAX_RATE_CODE :=ln_rec.TAX_RATE_CODE;
967 p_trx_lines_tbl(j).TAX_JURISDICTION_CODE :=ln_rec.TAX_JURISDICTION_CODE;
968 p_trx_lines_tbl(j).TAX_CLASSIFICATION_CODE :=ln_rec.TAX_CLASSIFICATION_CODE;
969 --Late Charges
970 p_trx_lines_tbl(j).interest_line_id :=ln_rec.interest_line_id;
971 p_trx_lines_tbl(j).trx_business_category := ln_rec.trx_business_category;
972 p_trx_lines_tbl(j).product_fisc_classification := ln_rec.product_fisc_classification;
973 p_trx_lines_tbl(j).product_category := ln_rec.product_category;
974 p_trx_lines_tbl(j).product_type := ln_rec.product_type;
975 p_trx_lines_tbl(j).line_intended_use := ln_rec.line_intended_use;
976 p_trx_lines_tbl(j).assessable_value := ln_rec.assessable_value;
977
978 FOR dist_rec in dist_cur(ln_rec.trx_line_id) LOOP
979 -- put dist record
980 k :=k+1;
981 p_trx_dist_tbl(k).TRX_DIST_ID :=dist_rec.TRX_DIST_ID;
982 p_trx_dist_tbl(k).TRX_HEADER_ID :=dist_rec.TRX_HEADER_ID;
983 p_trx_dist_tbl(k).TRX_LINE_ID :=dist_rec.TRX_LINE_ID;
984 p_trx_dist_tbl(k).ACCOUNT_CLASS :=dist_rec.ACCOUNT_CLASS;
985 p_trx_dist_tbl(k).AMOUNT :=dist_rec.AMOUNT;
986 p_trx_dist_tbl(k).ACCTD_AMOUNT :=dist_rec.ACCTD_AMOUNT;
987 p_trx_dist_tbl(k).PERCENT :=dist_rec.PERCENT;
988 p_trx_dist_tbl(k).CODE_COMBINATION_ID :=dist_rec.CODE_COMBINATION_ID;
989 p_trx_dist_tbl(k).ATTRIBUTE_CATEGORY :=dist_rec.ATTRIBUTE_CATEGORY;
990 p_trx_dist_tbl(k).ATTRIBUTE1 :=dist_rec.ATTRIBUTE1;
991 p_trx_dist_tbl(k).ATTRIBUTE2 :=dist_rec.ATTRIBUTE2;
992 p_trx_dist_tbl(k).ATTRIBUTE3 :=dist_rec.ATTRIBUTE3;
993 p_trx_dist_tbl(k).ATTRIBUTE4 :=dist_rec.ATTRIBUTE4;
994 p_trx_dist_tbl(k).ATTRIBUTE5 :=dist_rec.ATTRIBUTE5;
995 p_trx_dist_tbl(k).ATTRIBUTE6 :=dist_rec.ATTRIBUTE6;
996 p_trx_dist_tbl(k).ATTRIBUTE7 :=dist_rec.ATTRIBUTE7;
997 p_trx_dist_tbl(k).ATTRIBUTE8 :=dist_rec.ATTRIBUTE8;
998 p_trx_dist_tbl(k).ATTRIBUTE9 :=dist_rec.ATTRIBUTE9;
999 p_trx_dist_tbl(k).ATTRIBUTE10 :=dist_rec.ATTRIBUTE10;
1000 p_trx_dist_tbl(k).ATTRIBUTE11 :=dist_rec.ATTRIBUTE11;
1001 p_trx_dist_tbl(k).ATTRIBUTE12 :=dist_rec.ATTRIBUTE12;
1002 p_trx_dist_tbl(k).ATTRIBUTE13 :=dist_rec.ATTRIBUTE13;
1003 p_trx_dist_tbl(k).ATTRIBUTE14 :=dist_rec.ATTRIBUTE14;
1004 p_trx_dist_tbl(k).ATTRIBUTE15 :=dist_rec.ATTRIBUTE15;
1005 p_trx_dist_tbl(k).COMMENTS :=dist_rec.COMMENTS;
1006
1007 END LOOP;
1008
1009 FOR sc_rec in sc_cur(ln_rec.trx_header_id,ln_rec.trx_line_id) LOOP
1010 --put SC record
1011 l:=l+1;
1012 p_trx_salescredits_tbl(l).TRX_SALESCREDIT_ID :=sc_rec.TRX_SALESCREDIT_ID;
1013 p_trx_salescredits_tbl(l).TRX_LINE_ID :=sc_rec.TRX_LINE_ID;
1014 p_trx_salescredits_tbl(l).SALESREP_ID :=sc_rec.SALESREP_ID;
1015 p_trx_salescredits_tbl(l).SALESREP_NUMBER :=sc_rec.SALESREP_NUMBER;
1016 p_trx_salescredits_tbl(l).SALES_CREDIT_TYPE_NAME :=sc_rec.SALES_CREDIT_TYPE_NAME;
1017 p_trx_salescredits_tbl(l).SALES_CREDIT_TYPE_ID :=sc_rec.SALES_CREDIT_TYPE_ID;
1018 p_trx_salescredits_tbl(l).SALESCREDIT_AMOUNT_SPLIT :=sc_rec.SALESCREDIT_AMOUNT_SPLIT;
1019 p_trx_salescredits_tbl(l).SALESCREDIT_PERCENT_SPLIT :=sc_rec.SALESCREDIT_PERCENT_SPLIT;
1020 p_trx_salescredits_tbl(l).ATTRIBUTE_CATEGORY :=sc_rec.ATTRIBUTE_CATEGORY;
1021 p_trx_salescredits_tbl(l).ATTRIBUTE1 :=sc_rec.ATTRIBUTE1;
1022 p_trx_salescredits_tbl(l).ATTRIBUTE2 :=sc_rec.ATTRIBUTE2;
1023 p_trx_salescredits_tbl(l).ATTRIBUTE3 :=sc_rec.ATTRIBUTE3;
1024 p_trx_salescredits_tbl(l).ATTRIBUTE4 :=sc_rec.ATTRIBUTE4;
1025 p_trx_salescredits_tbl(l).ATTRIBUTE5 :=sc_rec.ATTRIBUTE5;
1026 p_trx_salescredits_tbl(l).ATTRIBUTE6 :=sc_rec.ATTRIBUTE6;
1027 p_trx_salescredits_tbl(l).ATTRIBUTE7 :=sc_rec.ATTRIBUTE7;
1028 p_trx_salescredits_tbl(l).ATTRIBUTE8 :=sc_rec.ATTRIBUTE8;
1029 p_trx_salescredits_tbl(l).ATTRIBUTE9 :=sc_rec.ATTRIBUTE9;
1030 p_trx_salescredits_tbl(l).ATTRIBUTE10 :=sc_rec.ATTRIBUTE10;
1031 p_trx_salescredits_tbl(l).ATTRIBUTE11 :=sc_rec.ATTRIBUTE11;
1032 p_trx_salescredits_tbl(l).ATTRIBUTE12 :=sc_rec.ATTRIBUTE12;
1033 p_trx_salescredits_tbl(l).ATTRIBUTE13 :=sc_rec.ATTRIBUTE13;
1034 p_trx_salescredits_tbl(l).ATTRIBUTE14 :=sc_rec.ATTRIBUTE14;
1035 p_trx_salescredits_tbl(l).ATTRIBUTE15 :=sc_rec.ATTRIBUTE15;
1036
1037 END LOOP;
1038 END LOOP;
1039
1040 /* 4652982 - Insert header dist rows
1041 NOTE: We use same index as prev dist insert so
1042 our records are consecutive in the table for
1043 future bulk reads. */
1044 FOR dist_rec in dist_rec_cur(hdr_rec.trx_header_id) LOOP
1045 k := k + 1;
1046 p_trx_dist_tbl(k).TRX_DIST_ID :=dist_rec.TRX_DIST_ID;
1047 p_trx_dist_tbl(k).TRX_HEADER_ID :=dist_rec.TRX_HEADER_ID;
1048 p_trx_dist_tbl(k).TRX_LINE_ID :=dist_rec.TRX_LINE_ID;
1049 p_trx_dist_tbl(k).ACCOUNT_CLASS :=dist_rec.ACCOUNT_CLASS;
1050 p_trx_dist_tbl(k).AMOUNT :=dist_rec.AMOUNT;
1051 p_trx_dist_tbl(k).ACCTD_AMOUNT :=dist_rec.ACCTD_AMOUNT;
1052 p_trx_dist_tbl(k).PERCENT :=dist_rec.PERCENT;
1053 p_trx_dist_tbl(k).CODE_COMBINATION_ID :=dist_rec.CODE_COMBINATION_ID;
1054 p_trx_dist_tbl(k).ATTRIBUTE_CATEGORY :=dist_rec.ATTRIBUTE_CATEGORY;
1055 p_trx_dist_tbl(k).ATTRIBUTE1 :=dist_rec.ATTRIBUTE1;
1056 p_trx_dist_tbl(k).ATTRIBUTE2 :=dist_rec.ATTRIBUTE2;
1057 p_trx_dist_tbl(k).ATTRIBUTE3 :=dist_rec.ATTRIBUTE3;
1058 p_trx_dist_tbl(k).ATTRIBUTE4 :=dist_rec.ATTRIBUTE4;
1059 p_trx_dist_tbl(k).ATTRIBUTE5 :=dist_rec.ATTRIBUTE5;
1060 p_trx_dist_tbl(k).ATTRIBUTE6 :=dist_rec.ATTRIBUTE6;
1061 p_trx_dist_tbl(k).ATTRIBUTE7 :=dist_rec.ATTRIBUTE7;
1062 p_trx_dist_tbl(k).ATTRIBUTE8 :=dist_rec.ATTRIBUTE8;
1063 p_trx_dist_tbl(k).ATTRIBUTE9 :=dist_rec.ATTRIBUTE9;
1064 p_trx_dist_tbl(k).ATTRIBUTE10 :=dist_rec.ATTRIBUTE10;
1065 p_trx_dist_tbl(k).ATTRIBUTE11 :=dist_rec.ATTRIBUTE11;
1066 p_trx_dist_tbl(k).ATTRIBUTE12 :=dist_rec.ATTRIBUTE12;
1067 p_trx_dist_tbl(k).ATTRIBUTE13 :=dist_rec.ATTRIBUTE13;
1068 p_trx_dist_tbl(k).ATTRIBUTE14 :=dist_rec.ATTRIBUTE14;
1069 p_trx_dist_tbl(k).ATTRIBUTE15 :=dist_rec.ATTRIBUTE15;
1070 p_trx_dist_tbl(k).COMMENTS :=dist_rec.COMMENTS;
1071
1072 END LOOP; -- end of hdr rec/round dist insert
1073
1074 END LOOP;
1075
1076 EXCEPTION
1077 WHEN OTHERS THEN
1078 x_errmsg := 'Error in AR_TRX_GLOBAL_PROCESS_TMP.GET_ROWS '||sqlerrm;
1079 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080 RETURN;
1081
1082 END GET_ROWS;
1083
1084 END AR_TRX_GLOBAL_PROCESS_TMP;