[Home] [Help]
143: oe_debug_pub.add( 'ENTERING OE_BULK_TAX_UTIL.GET_DEFAULT_TAX_CODE' ) ;
144: END IF;
145: --Loop over the loaded lines to default the tax code
146: l_index := 1;
147: WHILE l_index <= OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID.COUNT LOOP
148: l_index_inc := 1;
149:
150: --IF (OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index) = 'R'
151: -- OR
146: l_index := 1;
147: WHILE l_index <= OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID.COUNT LOOP
148: l_index_inc := 1;
149:
150: --IF (OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index) = 'R'
151: -- OR
152: -- OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index) = 'Y')
153: --THEN
154: --bug7685103
148: l_index_inc := 1;
149:
150: --IF (OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index) = 'R'
151: -- OR
152: -- OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index) = 'Y')
153: --THEN
154: --bug7685103
155:
156: l_header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(l_index);
152: -- OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index) = 'Y')
153: --THEN
154: --bug7685103
155:
156: l_header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(l_index);
157:
158:
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add( 'line index: ' || l_index || ' line id: '|| OE_Bulk_Order_PVT.G_LINE_REC.line_id(l_index) || ' header index: ' || l_header_index || ' header id: ' || OE_Bulk_Order_PVT.G_HEADER_REC.header_id(l_header_index));
156: l_header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(l_index);
157:
158:
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add( 'line index: ' || l_index || ' line id: '|| OE_Bulk_Order_PVT.G_LINE_REC.line_id(l_index) || ' header index: ' || l_header_index || ' header id: ' || OE_Bulk_Order_PVT.G_HEADER_REC.header_id(l_header_index));
161: END IF;
162:
163: IF nvl(OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(l_header_index),0) = -99
164: THEN
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add( 'line index: ' || l_index || ' line id: '|| OE_Bulk_Order_PVT.G_LINE_REC.line_id(l_index) || ' header index: ' || l_header_index || ' header id: ' || OE_Bulk_Order_PVT.G_HEADER_REC.header_id(l_header_index));
161: END IF;
162:
163: IF nvl(OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(l_header_index),0) = -99
164: THEN
165: IF l_debug_level > 0 THEN
166: oe_debug_pub.add( 'lock control set. skipping header with header id: '|| OE_Bulk_Order_PVT.G_HEADER_REC.header_id(l_header_index));
167: END IF;
162:
163: IF nvl(OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(l_header_index),0) = -99
164: THEN
165: IF l_debug_level > 0 THEN
166: oe_debug_pub.add( 'lock control set. skipping header with header id: '|| OE_Bulk_Order_PVT.G_HEADER_REC.header_id(l_header_index));
167: END IF;
168: --Skip the remaining lines in this header as it is marked for error
169: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
170: l_index_inc := l_remaining_lines + 1;
165: IF l_debug_level > 0 THEN
166: oe_debug_pub.add( 'lock control set. skipping header with header id: '|| OE_Bulk_Order_PVT.G_HEADER_REC.header_id(l_header_index));
167: END IF;
168: --Skip the remaining lines in this header as it is marked for error
169: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
170: l_index_inc := l_remaining_lines + 1;
171: ELSE
172:
173: --default the tax_date with the following precedence: 1. schedule_ship_date, 2. request_date, 3. promise_date, 4. sysdate
170: l_index_inc := l_remaining_lines + 1;
171: ELSE
172:
173: --default the tax_date with the following precedence: 1. schedule_ship_date, 2. request_date, 3. promise_date, 4. sysdate
174: IF OE_Bulk_Order_PVT.G_LINE_REC.schedule_ship_date(l_index) IS NOT NULL
175: THEN
176: IF l_debug_level > 0 THEN
177: oe_debug_pub.add( 'defaulting tax date from schedule ship date');
178: END IF;
175: THEN
176: IF l_debug_level > 0 THEN
177: oe_debug_pub.add( 'defaulting tax date from schedule ship date');
178: END IF;
179: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := OE_Bulk_Order_PVT.G_LINE_REC.schedule_ship_date(l_index);
180: ELSIF OE_Bulk_Order_PVT.G_LINE_REC.request_date(l_index) IS NOT NULL
181: THEN
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'defaulting tax date from request date');
176: IF l_debug_level > 0 THEN
177: oe_debug_pub.add( 'defaulting tax date from schedule ship date');
178: END IF;
179: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := OE_Bulk_Order_PVT.G_LINE_REC.schedule_ship_date(l_index);
180: ELSIF OE_Bulk_Order_PVT.G_LINE_REC.request_date(l_index) IS NOT NULL
181: THEN
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'defaulting tax date from request date');
184: END IF;
181: THEN
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'defaulting tax date from request date');
184: END IF;
185: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := OE_Bulk_Order_PVT.G_LINE_REC.request_date(l_index);
186: ELSIF OE_Bulk_Order_PVT.G_LINE_REC.promise_date(l_index) IS NOT NULL
187: THEN
188: IF l_debug_level > 0 THEN
189: oe_debug_pub.add( 'defaulting tax date from promise date');
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'defaulting tax date from request date');
184: END IF;
185: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := OE_Bulk_Order_PVT.G_LINE_REC.request_date(l_index);
186: ELSIF OE_Bulk_Order_PVT.G_LINE_REC.promise_date(l_index) IS NOT NULL
187: THEN
188: IF l_debug_level > 0 THEN
189: oe_debug_pub.add( 'defaulting tax date from promise date');
190: END IF;
187: THEN
188: IF l_debug_level > 0 THEN
189: oe_debug_pub.add( 'defaulting tax date from promise date');
190: END IF;
191: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := OE_Bulk_Order_PVT.G_LINE_REC.promise_date(l_index);
192: ELSE
193: IF l_debug_level > 0 THEN
194: oe_debug_pub.add( 'defaulting tax date from sysdate');
195: END IF;
192: ELSE
193: IF l_debug_level > 0 THEN
194: oe_debug_pub.add( 'defaulting tax date from sysdate');
195: END IF;
196: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := sysdate;
197: END IF; --end of schedule_ship_date is not null
198:
199: --get the tax code
200: IF OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) IS NULL
196: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := sysdate;
197: END IF; --end of schedule_ship_date is not null
198:
199: --get the tax code
200: IF OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) IS NULL
201: THEN
202:
203: BEGIN
204:
203: BEGIN
204:
205: IF l_debug_level > 0 THEN
206: oe_debug_pub.add( 'before calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION');
207: oe_debug_pub.add( 'OE_Bulk_Order_PVT.G_LINE_REC.org_id('||l_index||') :'||OE_Bulk_Order_PVT.G_LINE_REC.org_id(l_index) );
208: END IF;
209:
210: SELECT hsecs INTO l_start_time from v$timer;
211:
209:
210: SELECT hsecs INTO l_start_time from v$timer;
211:
212: ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION
213: ( p_ship_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index) ,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
210: SELECT hsecs INTO l_start_time from v$timer;
211:
212: ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION
213: ( p_ship_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index) ,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
218: p_trx_date => OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index),
211:
212: ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION
213: ( p_ship_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index) ,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
218: p_trx_date => OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index),
219: p_trx_type_id => OE_Bulk_Order_PVT.G_LINE_REC.cust_trx_type_id(l_index),
212: ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION
213: ( p_ship_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index) ,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
218: p_trx_date => OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index),
219: p_trx_type_id => OE_Bulk_Order_PVT.G_LINE_REC.cust_trx_type_id(l_index),
220: p_tax_classification_code => x_tax_code,
213: ( p_ship_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index) ,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
218: p_trx_date => OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index),
219: p_trx_type_id => OE_Bulk_Order_PVT.G_LINE_REC.cust_trx_type_id(l_index),
220: p_tax_classification_code => x_tax_code,
221: -- p_cust_trx_id => l_ra_cust_trx_type_id,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
218: p_trx_date => OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index),
219: p_trx_type_id => OE_Bulk_Order_PVT.G_LINE_REC.cust_trx_type_id(l_index),
220: p_tax_classification_code => x_tax_code,
221: -- p_cust_trx_id => l_ra_cust_trx_type_id,
222: -- p_customer_id => nvl(l_shipment_rec.ship_to_cust_party_id,l_shipment_header_rec.ship_to_cust_party_id),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
218: p_trx_date => OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index),
219: p_trx_type_id => OE_Bulk_Order_PVT.G_LINE_REC.cust_trx_type_id(l_index),
220: p_tax_classification_code => x_tax_code,
221: -- p_cust_trx_id => l_ra_cust_trx_type_id,
222: -- p_customer_id => nvl(l_shipment_rec.ship_to_cust_party_id,l_shipment_header_rec.ship_to_cust_party_id),
223: appl_short_name => 'ONT',
223: appl_short_name => 'ONT',
224: p_entity_code => 'OE_ORDER_HEADERS',
225: p_event_class_code => 'SALES_TRANSACTION_TAX_QUOTE',
226: p_application_id => 660,
227: p_internal_organization_id => OE_Bulk_Order_PVT.G_LINE_REC.org_id(l_index) --bug7759207
228: );
229:
230:
231:
257: */
258: NULL;
259:
260: ELSE
261: OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) := x_tax_code;
262: oe_debug_pub.add( ' Tax Code :'|| OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index),1);
263: END IF; -- tax_code IS NULL
264:
265:
258: NULL;
259:
260: ELSE
261: OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) := x_tax_code;
262: oe_debug_pub.add( ' Tax Code :'|| OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index),1);
263: END IF; -- tax_code IS NULL
264:
265:
266: EXCEPTION
269: IF l_debug_level > 0 THEN
270: oe_debug_pub.add( 'in others exception in get default tax: ' || SQLERRM);
271: END IF;
272:
273: OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) := x_tax_code;
274:
275: /*Handle_Tax_Code_Error(p_index => l_index,
276: p_header_index => l_header_index,
277: x_index_inc => l_error_inc);
289:
290: --bug7685103
291: --This validation will be done in OEBLLINB.pls
292: /* -- Validating Tax Information
293: IF OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) IS NOT NULL AND
294: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) IS NOT NULL
295: THEN
296: BEGIN
297: IF oe_code_control.code_release_level >= '110510' THEN
290: --bug7685103
291: --This validation will be done in OEBLLINB.pls
292: /* -- Validating Tax Information
293: IF OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) IS NOT NULL AND
294: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) IS NOT NULL
295: THEN
296: BEGIN
297: IF oe_code_control.code_release_level >= '110510' THEN
298:
301:
302: SELECT 'VALID'
303: INTO l_dummy
304: FROM AR_VAT_TAX V
305: WHERE V.TAX_CODE = OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index)
306: AND V.SET_OF_BOOKS_ID = l_sob_id
307: AND NVL(V.ENABLED_FLAG,'Y')='Y'
308: AND NVL(V.TAX_CLASS,'O')='O'
309: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
306: AND V.SET_OF_BOOKS_ID = l_sob_id
307: AND NVL(V.ENABLED_FLAG,'Y')='Y'
308: AND NVL(V.TAX_CLASS,'O')='O'
309: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
310: AND TRUNC(OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index))
311: BETWEEN TRUNC(V.START_DATE) AND
312: TRUNC(NVL(V.END_DATE, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index)))
313: AND ROWNUM = 1;
314:
308: AND NVL(V.TAX_CLASS,'O')='O'
309: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
310: AND TRUNC(OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index))
311: BETWEEN TRUNC(V.START_DATE) AND
312: TRUNC(NVL(V.END_DATE, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index)))
313: AND ROWNUM = 1;
314:
315: ELSE
316:
317: SELECT 'VALID'
318: INTO l_dummy
319: FROM AR_VAT_TAX V,
320: AR_SYSTEM_PARAMETERS P
321: WHERE V.TAX_CODE = OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index)
322: AND V.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
323: AND NVL(V.ENABLED_FLAG,'Y')='Y'
324: AND NVL(V.TAX_CLASS,'O')='O'
325: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
322: AND V.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
323: AND NVL(V.ENABLED_FLAG,'Y')='Y'
324: AND NVL(V.TAX_CLASS,'O')='O'
325: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
326: AND TRUNC(OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index))
327: BETWEEN TRUNC(V.START_DATE) AND
328: TRUNC(NVL(V.END_DATE, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index)))
329: AND ROWNUM = 1;
330:
324: AND NVL(V.TAX_CLASS,'O')='O'
325: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
326: AND TRUNC(OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index))
327: BETWEEN TRUNC(V.START_DATE) AND
328: TRUNC(NVL(V.END_DATE, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index)))
329: AND ROWNUM = 1;
330:
331: END IF;
332:
559: END IF;
560: l_index := 1;
561: l_tax_index := 1;
562: l_adj_index := 1;
563: FOR i IN 1.. OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID.COUNT
564: LOOP
565: G_LINE_ID(i) :=OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
566: oe_debug_pub.add( 'Entering Values for line in entity info table for line');
567: Entity_info_tbl(l_index).trx_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(i);
561: l_tax_index := 1;
562: l_adj_index := 1;
563: FOR i IN 1.. OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID.COUNT
564: LOOP
565: G_LINE_ID(i) :=OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
566: oe_debug_pub.add( 'Entering Values for line in entity info table for line');
567: Entity_info_tbl(l_index).trx_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(i);
568: Entity_info_tbl(l_index).trx_line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
569: Entity_info_tbl(l_index).line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
563: FOR i IN 1.. OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID.COUNT
564: LOOP
565: G_LINE_ID(i) :=OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
566: oe_debug_pub.add( 'Entering Values for line in entity info table for line');
567: Entity_info_tbl(l_index).trx_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(i);
568: Entity_info_tbl(l_index).trx_line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
569: Entity_info_tbl(l_index).line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
570: Entity_info_tbl(l_index).header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(i);
571: Entity_info_tbl(l_index).line_index := i;
564: LOOP
565: G_LINE_ID(i) :=OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
566: oe_debug_pub.add( 'Entering Values for line in entity info table for line');
567: Entity_info_tbl(l_index).trx_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(i);
568: Entity_info_tbl(l_index).trx_line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
569: Entity_info_tbl(l_index).line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
570: Entity_info_tbl(l_index).header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(i);
571: Entity_info_tbl(l_index).line_index := i;
572: oe_debug_pub.add( 'line_index for line'||OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i) ||' :'|| i);
565: G_LINE_ID(i) :=OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
566: oe_debug_pub.add( 'Entering Values for line in entity info table for line');
567: Entity_info_tbl(l_index).trx_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(i);
568: Entity_info_tbl(l_index).trx_line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
569: Entity_info_tbl(l_index).line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
570: Entity_info_tbl(l_index).header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(i);
571: Entity_info_tbl(l_index).line_index := i;
572: oe_debug_pub.add( 'line_index for line'||OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i) ||' :'|| i);
573: Entity_info_tbl(l_index).trx_level_type := 'LINE';
566: oe_debug_pub.add( 'Entering Values for line in entity info table for line');
567: Entity_info_tbl(l_index).trx_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(i);
568: Entity_info_tbl(l_index).trx_line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
569: Entity_info_tbl(l_index).line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
570: Entity_info_tbl(l_index).header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(i);
571: Entity_info_tbl(l_index).line_index := i;
572: oe_debug_pub.add( 'line_index for line'||OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i) ||' :'|| i);
573: Entity_info_tbl(l_index).trx_level_type := 'LINE';
574: Entity_info_tbl(l_index).charge_amt := NULL;
568: Entity_info_tbl(l_index).trx_line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
569: Entity_info_tbl(l_index).line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
570: Entity_info_tbl(l_index).header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(i);
571: Entity_info_tbl(l_index).line_index := i;
572: oe_debug_pub.add( 'line_index for line'||OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i) ||' :'|| i);
573: Entity_info_tbl(l_index).trx_level_type := 'LINE';
574: Entity_info_tbl(l_index).charge_amt := NULL;
575: l_index := l_index+1;
576: IF ( NVL (oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y' ) THEN
574: Entity_info_tbl(l_index).charge_amt := NULL;
575: l_index := l_index+1;
576: IF ( NVL (oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y' ) THEN
577:
578: l_charge_tbl := om_tax_util.get_charge_details(p_header_id =>OE_Bulk_Order_PVT.G_LINE_REC.header_id(i) , p_line_id =>OE_Bulk_Order_PVT.G_LINE_REC.line_id(i));
579: IF l_charge_tbl.Count > 0 THEN
580: oe_debug_pub.add( 'Entering Values for line charges in entity info table');
581: END IF;
582:
582:
583:
584: FOR j IN 1.. l_charge_tbl.count
585: LOOP
586: Entity_info_tbl(l_index).trx_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(i);
587: Entity_info_tbl(l_index).trx_line_id := l_charge_tbl(j).charge_id ;
588: Entity_info_tbl(l_index).line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
589: Entity_info_tbl(l_index).header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(i);
590: Entity_info_tbl(l_index).line_index := i;
584: FOR j IN 1.. l_charge_tbl.count
585: LOOP
586: Entity_info_tbl(l_index).trx_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(i);
587: Entity_info_tbl(l_index).trx_line_id := l_charge_tbl(j).charge_id ;
588: Entity_info_tbl(l_index).line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
589: Entity_info_tbl(l_index).header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(i);
590: Entity_info_tbl(l_index).line_index := i;
591: oe_debug_pub.add( 'line_index for line charge '||OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i)|| ' :'|| i);
592: Entity_info_tbl(l_index).trx_level_type := 'FREIGHT CHARGE';
585: LOOP
586: Entity_info_tbl(l_index).trx_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(i);
587: Entity_info_tbl(l_index).trx_line_id := l_charge_tbl(j).charge_id ;
588: Entity_info_tbl(l_index).line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
589: Entity_info_tbl(l_index).header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(i);
590: Entity_info_tbl(l_index).line_index := i;
591: oe_debug_pub.add( 'line_index for line charge '||OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i)|| ' :'|| i);
592: Entity_info_tbl(l_index).trx_level_type := 'FREIGHT CHARGE';
593: Entity_info_tbl(l_index).charge_amt := l_charge_tbl(j).charge_amount;
587: Entity_info_tbl(l_index).trx_line_id := l_charge_tbl(j).charge_id ;
588: Entity_info_tbl(l_index).line_id := OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i);
589: Entity_info_tbl(l_index).header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(i);
590: Entity_info_tbl(l_index).line_index := i;
591: oe_debug_pub.add( 'line_index for line charge '||OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i)|| ' :'|| i);
592: Entity_info_tbl(l_index).trx_level_type := 'FREIGHT CHARGE';
593: Entity_info_tbl(l_index).charge_amt := l_charge_tbl(j).charge_amount;
594: l_index := l_index+1;
595: END LOOP;
595: END LOOP;
596: END IF;
597: END LOOP;
598: IF ( NVL (oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y' ) THEN
599: FOR i IN 1.. OE_Bulk_Order_PVT.G_HEADER_REC.HEADER_ID.COUNT
600: LOOP
601: l_charge_tbl := om_tax_util.get_charge_details(p_header_id =>OE_Bulk_Order_PVT.G_HEADER_REC.HEADER_ID(i) , p_line_id =>NULL);
602: IF l_charge_tbl.Count > 0 THEN
603: oe_debug_pub.add( 'Entering Values for header charges in entity info table');
597: END LOOP;
598: IF ( NVL (oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y' ) THEN
599: FOR i IN 1.. OE_Bulk_Order_PVT.G_HEADER_REC.HEADER_ID.COUNT
600: LOOP
601: l_charge_tbl := om_tax_util.get_charge_details(p_header_id =>OE_Bulk_Order_PVT.G_HEADER_REC.HEADER_ID(i) , p_line_id =>NULL);
602: IF l_charge_tbl.Count > 0 THEN
603: oe_debug_pub.add( 'Entering Values for header charges in entity info table');
604: END IF;
605:
604: END IF;
605:
606: FOR j IN 1..l_charge_tbl.count
607: LOOP
608: Entity_info_tbl(l_index).trx_id := OE_Bulk_Order_PVT.G_HEADER_REC.header_id(i);
609: Entity_info_tbl(l_index).trx_line_id := l_charge_tbl(j).charge_id ;
610: Entity_info_tbl(l_index).line_id := NULL;
611: Entity_info_tbl(l_index).header_index := i;
612: oe_debug_pub.add( 'header_index for header'||OE_Bulk_Order_PVT.G_HEADER_REC.header_id(i)|| ' :'|| i);
608: Entity_info_tbl(l_index).trx_id := OE_Bulk_Order_PVT.G_HEADER_REC.header_id(i);
609: Entity_info_tbl(l_index).trx_line_id := l_charge_tbl(j).charge_id ;
610: Entity_info_tbl(l_index).line_id := NULL;
611: Entity_info_tbl(l_index).header_index := i;
612: oe_debug_pub.add( 'header_index for header'||OE_Bulk_Order_PVT.G_HEADER_REC.header_id(i)|| ' :'|| i);
613: Entity_info_tbl(l_index).line_index := NULL;
614: Entity_info_tbl(l_index).trx_level_type := 'FREIGHT CHARGE';
615: Entity_info_tbl(l_index).charge_amt := l_charge_tbl(j).charge_amount;
616: l_index := l_index+1;
626: l_header_index := Entity_info_tbl(i).header_index;
627: l_header_id := Entity_info_tbl(i).trx_id;
628: l_line_id := Entity_info_tbl(i).trx_line_id;
629: l_level := 'L';
630: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_LINE_REC.salesrep_id(Entity_info_tbl(i).line_index));
631: elsif Entity_info_tbl(i).trx_level_type = 'FREIGHT CHARGE' AND Entity_info_tbl(i).line_id IS NOT NULL THEN
632: oe_debug_pub.add( 'Processing Line charge for line : ' ||Entity_info_tbl(i).line_id);
633: oe_debug_pub.add( 'Processing charge: ' ||Entity_info_tbl(i).trx_line_id);
634: l_header_index := Entity_info_tbl(i).header_index;
635: l_header_id := Entity_info_tbl(i).trx_id;
636: l_line_id := Entity_info_tbl(i).line_id;
637: l_charge_id := Entity_info_tbl(i).trx_line_id;
638: l_level := 'LC';
639: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_LINE_REC.salesrep_id(Entity_info_tbl(i).line_index));
640: elsif Entity_info_tbl(i).trx_level_type = 'FREIGHT CHARGE' AND Entity_info_tbl(i).line_id IS NULL THEN
641: oe_debug_pub.add( 'Processing Header charge for Header : ' ||Entity_info_tbl(i).trx_id);
642: oe_debug_pub.add( 'Processing charge: ' ||Entity_info_tbl(i).trx_line_id);
643: l_header_index := Entity_info_tbl(i).header_index;
644: l_header_id := Entity_info_tbl(i).trx_id;
645: l_line_id := NULL;
646: l_charge_id := Entity_info_tbl(i).trx_line_id;
647: l_level := 'HC';
648: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_HEADER_REC.salesrep_id(Entity_info_tbl(i).header_index));
649: END IF;
650: zx_global_structures_pkg.init_trx_line_dist_tbl(i);
651: IF NVL(OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(l_header_index),0) = -99 THEN
652: IF l_debug_level > 0 THEN
647: l_level := 'HC';
648: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_HEADER_REC.salesrep_id(Entity_info_tbl(i).header_index));
649: END IF;
650: zx_global_structures_pkg.init_trx_line_dist_tbl(i);
651: IF NVL(OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(l_header_index),0) = -99 THEN
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( 'lock control set. skipping header with header id: '|| l_header_id);
654: END IF;
655: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index) ,
651: IF NVL(OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(l_header_index),0) = -99 THEN
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( 'lock control set. skipping header with header id: '|| l_header_id);
654: END IF;
655: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index) ,
656: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(l_header_index) ,
657: p_bill_to_customer_id => l_bill_to_customer_id ,
658: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index) );
659: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( 'lock control set. skipping header with header id: '|| l_header_id);
654: END IF;
655: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index) ,
656: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(l_header_index) ,
657: p_bill_to_customer_id => l_bill_to_customer_id ,
658: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index) );
659: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
660: l_index_inc := l_remaining_lines + 1;
654: END IF;
655: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index) ,
656: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(l_header_index) ,
657: p_bill_to_customer_id => l_bill_to_customer_id ,
658: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index) );
659: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
660: l_index_inc := l_remaining_lines + 1;
661: ELSE
662: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
655: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index) ,
656: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(l_header_index) ,
657: p_bill_to_customer_id => l_bill_to_customer_id ,
658: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index) );
659: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
660: l_index_inc := l_remaining_lines + 1;
661: ELSE
662: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
663: BEGIN
663: BEGIN
664: SELECT location_id
665: INTO l_bill_from_location_id
666: FROM HR_ALL_ORGANIZATION_UNITS
667: WHERE organization_id = OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index);
668: EXCEPTION
669: WHEN OTHERS THEN
670: l_bill_from_location_id := NULL;
671: END;
676: l_person_id := OE_BULK_CACHE.G_SALESREP_TBL(l_salesrep_cache_key).person_id;
677: IF l_debug_level > 0 THEN
678: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);
679: END IF;
680: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(Entity_info_tbl(i).line_index));
681: EXCEPTION
682: WHEN OTHERS THEN
683: l_load_person_failed := true;
684: IF l_debug_level > 0 THEN
691: ELSE
692: l_asgn_org_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).ORGANIZATION_ID; -- the cache key is l_person_id only
693: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;
694: END IF;
695: IF OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
696: IF l_debug_level > 0 THEN
697: oe_debug_pub.add( 'retrieving bill_to info');
698: oe_debug_pub.add( 'Line index:'||Entity_info_tbl(i).line_index);
699: oe_debug_pub.add( 'Line index invoice to org:'||OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
695: IF OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
696: IF l_debug_level > 0 THEN
697: oe_debug_pub.add( 'retrieving bill_to info');
698: oe_debug_pub.add( 'Line index:'||Entity_info_tbl(i).line_index);
699: oe_debug_pub.add( 'Line index invoice to org:'||OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
700: END IF;
701: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
702: oe_debug_pub.add( 'After invoice line chache :'||l_invoice_to_cache_key);
703: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
697: oe_debug_pub.add( 'retrieving bill_to info');
698: oe_debug_pub.add( 'Line index:'||Entity_info_tbl(i).line_index);
699: oe_debug_pub.add( 'Line index invoice to org:'||OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
700: END IF;
701: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
702: oe_debug_pub.add( 'After invoice line chache :'||l_invoice_to_cache_key);
703: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
704: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
705: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
715: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
716: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
717: oe_debug_pub.add( 'before end if');
718: END IF; --end of if invoice_to_org_id IS NOT NULL
719: l_commitment_id := NVL(OE_Bulk_Order_PVT.G_LINE_REC.commitment_id(Entity_info_tbl(i).line_index),0);
720: IF l_commitment_id <> 0 THEN
721: IF l_debug_level > 0 THEN
722: oe_debug_pub.add('Commitment id is:'||l_commitment_id,4);
723: END IF;
745: IF l_debug_level > 0 THEN
746: oe_debug_pub.add('In else part of commitment id',4);
747: END IF;
748: /*l_cust_trx_type_id :=
749: OE_INVOICE_PUB.Get_Customer_Transaction_Type(OE_Bulk_Order_PVT.G_LINE_REC(l_index)); */
750: END IF;
751: --code changes made for bug 1883552 end
752: IF l_debug_level > 0 THEN
753: oe_debug_pub.add('Customer trx type id is:'||l_cust_trx_type_id,4);
751: --code changes made for bug 1883552 end
752: IF l_debug_level > 0 THEN
753: oe_debug_pub.add('Customer trx type id is:'||l_cust_trx_type_id,4);
754: END IF;
755: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
756: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
757: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
758: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
759: SELECT c.minimum_accountable_unit,
752: IF l_debug_level > 0 THEN
753: oe_debug_pub.add('Customer trx type id is:'||l_cust_trx_type_id,4);
754: END IF;
755: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
756: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
757: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
758: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
759: SELECT c.minimum_accountable_unit,
760: c.precision
753: oe_debug_pub.add('Customer trx type id is:'||l_cust_trx_type_id,4);
754: END IF;
755: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
756: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
757: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
758: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
759: SELECT c.minimum_accountable_unit,
760: c.precision
761: INTO l_minimum_accountable_unit,
754: END IF;
755: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
756: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
757: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
758: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
759: SELECT c.minimum_accountable_unit,
760: c.precision
761: INTO l_minimum_accountable_unit,
762: l_precision
761: INTO l_minimum_accountable_unit,
762: l_precision
763: FROM fnd_currencies c
764: WHERE c.currency_code = l_currency_code;
765: OPEN get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
766: FETCH get_internal_loc INTO l_internal_org_location_id;
767: CLOSE get_internal_loc;
768: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
769: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
764: WHERE c.currency_code = l_currency_code;
765: OPEN get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
766: FETCH get_internal_loc INTO l_internal_org_location_id;
767: CLOSE get_internal_loc;
768: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
769: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
770: p_bill_to_customer_id => l_bill_to_cust_id ,
771: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index) );
772: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
765: OPEN get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
766: FETCH get_internal_loc INTO l_internal_org_location_id;
767: CLOSE get_internal_loc;
768: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
769: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
770: p_bill_to_customer_id => l_bill_to_cust_id ,
771: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index) );
772: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
773: BEGIN
767: CLOSE get_internal_loc;
768: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
769: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
770: p_bill_to_customer_id => l_bill_to_cust_id ,
771: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index) );
772: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
773: BEGIN
774: SELECT location_id
775: INTO l_ship_from_location_id
768: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
769: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
770: p_bill_to_customer_id => l_bill_to_cust_id ,
771: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index) );
772: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
773: BEGIN
774: SELECT location_id
775: INTO l_ship_from_location_id
776: FROM hr_all_organization_units hu
773: BEGIN
774: SELECT location_id
775: INTO l_ship_from_location_id
776: FROM hr_all_organization_units hu
777: WHERE hu.organization_id = OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index);
778: EXCEPTION
779: WHEN OTHERS THEN
780: NULL;
781: END;
779: WHEN OTHERS THEN
780: NULL;
781: END;
782: END IF;
783: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add( 'retrieving ship_to info');
786: END IF;
787: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
783: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add( 'retrieving ship_to info');
786: END IF;
787: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
788: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
789: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
790: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
791: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
800: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
801: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
802: END IF; -- end of if ship_to_org_id IS NOT NULL
803: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i) := 'LINE';
804: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index),l_inventory_org_id);
805: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);
806: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
807: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
808: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
801: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
802: END IF; -- end of if ship_to_org_id IS NOT NULL
803: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i) := 'LINE';
804: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index),l_inventory_org_id);
805: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);
806: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
807: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
808: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
809: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
802: END IF; -- end of if ship_to_org_id IS NOT NULL
803: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i) := 'LINE';
804: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index),l_inventory_org_id);
805: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);
806: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
807: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
808: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
809: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
810: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
803: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i) := 'LINE';
804: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index),l_inventory_org_id);
805: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);
806: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
807: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
808: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
809: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
810: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
811: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
804: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index),l_inventory_org_id);
805: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);
806: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
807: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
808: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
809: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
810: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
811: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
812: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
805: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);
806: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
807: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
808: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
809: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
810: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
811: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
812: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
813: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.line_number(Entity_info_tbl(i).line_index);
806: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
807: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
808: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
809: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
810: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
811: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
812: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
813: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.line_number(Entity_info_tbl(i).line_index);
814: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
807: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
808: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
809: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
810: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
811: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
812: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
813: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.line_number(Entity_info_tbl(i).line_index);
814: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
815: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
808: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
809: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
810: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
811: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
812: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
813: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.line_number(Entity_info_tbl(i).line_index);
814: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
815: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
816: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
809: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
810: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
811: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
812: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
813: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.line_number(Entity_info_tbl(i).line_index);
814: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
815: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
816: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
817: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
810: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
811: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
812: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
813: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.line_number(Entity_info_tbl(i).line_index);
814: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
815: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
816: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
817: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
818: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
811: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
812: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
813: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.line_number(Entity_info_tbl(i).line_index);
814: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
815: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
816: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
817: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
818: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
819: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
812: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
813: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.line_number(Entity_info_tbl(i).line_index);
814: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
815: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
816: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
817: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
818: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
819: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
820: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
813: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.line_number(Entity_info_tbl(i).line_index);
814: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
815: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
816: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
817: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
818: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
819: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
820: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
821: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
814: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
815: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
816: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
817: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
818: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
819: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
820: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
821: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
822: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
815: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
816: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
817: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
818: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
819: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
820: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
821: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
822: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
823: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
816: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
817: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
818: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
819: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
820: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
821: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
822: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
823: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
824: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i) := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
817: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
818: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
819: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
820: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
821: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
822: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
823: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
824: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i) := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
825: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
818: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
819: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
820: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
821: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
822: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
823: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
824: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i) := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
825: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
826: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index) *
819: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
820: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
821: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
822: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
823: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
824: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i) := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
825: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
826: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index) *
827: OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
820: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
821: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
822: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
823: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
824: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i) := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
825: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
826: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index) *
827: OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
828:
821: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
822: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
823: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
824: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i) := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
825: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
826: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index) *
827: OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
828:
829: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(Entity_info_tbl(i).line_index)
822: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
823: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
824: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i) := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
825: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
826: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index) *
827: OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
828:
829: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(Entity_info_tbl(i).line_index)
830: IN ('JL.AR.OEXOEORD.LINES', 'JL.BR.OEXOEORD.LINES', 'JL.CO.OEXOEORD.LINES') THEN
823: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
824: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i) := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
825: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
826: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index) *
827: OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
828:
829: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(Entity_info_tbl(i).line_index)
830: IN ('JL.AR.OEXOEORD.LINES', 'JL.BR.OEXOEORD.LINES', 'JL.CO.OEXOEORD.LINES') THEN
831: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute6(Entity_info_tbl(i).line_index);
825: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
826: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index) *
827: OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
828:
829: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(Entity_info_tbl(i).line_index)
830: IN ('JL.AR.OEXOEORD.LINES', 'JL.BR.OEXOEORD.LINES', 'JL.CO.OEXOEORD.LINES') THEN
831: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute6(Entity_info_tbl(i).line_index);
832: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute5(Entity_info_tbl(i).line_index);
833: ELSE
827: OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
828:
829: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(Entity_info_tbl(i).line_index)
830: IN ('JL.AR.OEXOEORD.LINES', 'JL.BR.OEXOEORD.LINES', 'JL.CO.OEXOEORD.LINES') THEN
831: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute6(Entity_info_tbl(i).line_index);
832: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute5(Entity_info_tbl(i).line_index);
833: ELSE
834: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := NULL;
835: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i):= NULL;
828:
829: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(Entity_info_tbl(i).line_index)
830: IN ('JL.AR.OEXOEORD.LINES', 'JL.BR.OEXOEORD.LINES', 'JL.CO.OEXOEORD.LINES') THEN
831: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute6(Entity_info_tbl(i).line_index);
832: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute5(Entity_info_tbl(i).line_index);
833: ELSE
834: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := NULL;
835: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i):= NULL;
836: END IF;
833: ELSE
834: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := NULL;
835: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i):= NULL;
836: END IF;
837: zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_LINE_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
838: elsif l_level = 'LC' THEN
839: oe_debug_pub.add( 'Loading Line charge details in ZX global package');
840:
841: BEGIN
842: l_person_id := OE_BULK_CACHE.G_SALESREP_TBL(l_salesrep_cache_key).person_id;
843: IF l_debug_level > 0 THEN
844: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);
845: END IF;
846: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(Entity_info_tbl(i).line_index));
847: EXCEPTION
848: WHEN OTHERS THEN
849: l_load_person_failed := true;
850: IF l_debug_level > 0 THEN
857: ELSE
858: l_asgn_org_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).ORGANIZATION_ID; -- the cache key is l_person_id only
859: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;
860: END IF;
861: IF OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
862: IF l_debug_level > 0 THEN
863: oe_debug_pub.add( 'retrieving bill_to info');
864: oe_debug_pub.add( '2Line index:'||Entity_info_tbl(i).line_index);
865: oe_debug_pub.add( '2Line index invoice to org:'||OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
861: IF OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
862: IF l_debug_level > 0 THEN
863: oe_debug_pub.add( 'retrieving bill_to info');
864: oe_debug_pub.add( '2Line index:'||Entity_info_tbl(i).line_index);
865: oe_debug_pub.add( '2Line index invoice to org:'||OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
866: END IF;
867: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
868: oe_debug_pub.add( '2After invoice line chache :'||l_invoice_to_cache_key);
869: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
863: oe_debug_pub.add( 'retrieving bill_to info');
864: oe_debug_pub.add( '2Line index:'||Entity_info_tbl(i).line_index);
865: oe_debug_pub.add( '2Line index invoice to org:'||OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
866: END IF;
867: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
868: oe_debug_pub.add( '2After invoice line chache :'||l_invoice_to_cache_key);
869: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
870: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
871: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
881: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
882: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
883: oe_debug_pub.add( '2 before end if');
884: END IF; --end of if invoice_to_org_id IS NOT NULL
885: l_commitment_id := NVL(OE_Bulk_Order_PVT.G_LINE_REC.commitment_id(Entity_info_tbl(i).line_index),0);
886: IF l_commitment_id <> 0 THEN
887: IF l_debug_level > 0 THEN
888: oe_debug_pub.add('Commitment id is:'||l_commitment_id,4);
889: END IF;
911: IF l_debug_level > 0 THEN
912: oe_debug_pub.add('In else part of commitment id',4);
913: END IF;
914: /*l_cust_trx_type_id :=
915: OE_INVOICE_PUB.Get_Customer_Transaction_Type(OE_Bulk_Order_PVT.G_LINE_REC(l_index)); */
916: END IF;
917: --code changes made for bug 1883552 end
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add('Customer trx type id is:'||l_cust_trx_type_id,4);
917: --code changes made for bug 1883552 end
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add('Customer trx type id is:'||l_cust_trx_type_id,4);
920: END IF;
921: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
922: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
923: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
924: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
925: SELECT c.minimum_accountable_unit,
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add('Customer trx type id is:'||l_cust_trx_type_id,4);
920: END IF;
921: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
922: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
923: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
924: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
925: SELECT c.minimum_accountable_unit,
926: c.precision
919: oe_debug_pub.add('Customer trx type id is:'||l_cust_trx_type_id,4);
920: END IF;
921: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
922: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
923: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
924: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
925: SELECT c.minimum_accountable_unit,
926: c.precision
927: INTO l_minimum_accountable_unit,
920: END IF;
921: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
922: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
923: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
924: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
925: SELECT c.minimum_accountable_unit,
926: c.precision
927: INTO l_minimum_accountable_unit,
928: l_precision
927: INTO l_minimum_accountable_unit,
928: l_precision
929: FROM fnd_currencies c
930: WHERE c.currency_code = l_currency_code;
931: OPEN get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
932: FETCH get_internal_loc INTO l_internal_org_location_id;
933: CLOSE get_internal_loc;
934: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
935: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
930: WHERE c.currency_code = l_currency_code;
931: OPEN get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
932: FETCH get_internal_loc INTO l_internal_org_location_id;
933: CLOSE get_internal_loc;
934: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
935: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
936: p_bill_to_customer_id => l_bill_to_cust_id ,
937: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index) );
938: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
931: OPEN get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
932: FETCH get_internal_loc INTO l_internal_org_location_id;
933: CLOSE get_internal_loc;
934: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
935: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
936: p_bill_to_customer_id => l_bill_to_cust_id ,
937: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index) );
938: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
939: BEGIN
933: CLOSE get_internal_loc;
934: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
935: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
936: p_bill_to_customer_id => l_bill_to_cust_id ,
937: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index) );
938: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
939: BEGIN
940: SELECT location_id
941: INTO l_ship_from_location_id
934: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
935: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
936: p_bill_to_customer_id => l_bill_to_cust_id ,
937: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index) );
938: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
939: BEGIN
940: SELECT location_id
941: INTO l_ship_from_location_id
942: FROM hr_all_organization_units hu
939: BEGIN
940: SELECT location_id
941: INTO l_ship_from_location_id
942: FROM hr_all_organization_units hu
943: WHERE hu.organization_id = OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index);
944: EXCEPTION
945: WHEN OTHERS THEN
946: NULL;
947: END;
945: WHEN OTHERS THEN
946: NULL;
947: END;
948: END IF;
949: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
950: IF l_debug_level > 0 THEN
951: oe_debug_pub.add( 'retrieving ship_to info');
952: END IF;
953: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
949: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
950: IF l_debug_level > 0 THEN
951: oe_debug_pub.add( 'retrieving ship_to info');
952: END IF;
953: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
954:
955: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
956: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
957: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
972:
973:
974: END IF; -- end of if ship_to_org_id IS NOT NULL
975: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i) := 'FREIGHT CHARGE';
976: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index),l_inventory_org_id);
977: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);
978: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
979: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
980: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
973:
974: END IF; -- end of if ship_to_org_id IS NOT NULL
975: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i) := 'FREIGHT CHARGE';
976: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index),l_inventory_org_id);
977: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);
978: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
979: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
980: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
981: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
974: END IF; -- end of if ship_to_org_id IS NOT NULL
975: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i) := 'FREIGHT CHARGE';
976: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index),l_inventory_org_id);
977: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);
978: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
979: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
980: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
981: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
982: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
975: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i) := 'FREIGHT CHARGE';
976: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index),l_inventory_org_id);
977: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);
978: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
979: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
980: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
981: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
982: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
983: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
976: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index),l_inventory_org_id);
977: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);
978: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
979: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
980: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
981: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
982: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
983: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
984: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := Entity_info_tbl(i).trx_line_id ;
977: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);
978: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
979: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
980: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
981: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
982: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
983: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
984: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := Entity_info_tbl(i).trx_line_id ;
985: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
978: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
979: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
980: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
981: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
982: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
983: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
984: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := Entity_info_tbl(i).trx_line_id ;
985: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
986: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
979: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := OE_Bulk_Order_PVT.G_Line_Rec.user_item_description (Entity_info_tbl(i).line_index);
980: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(Entity_info_tbl(i).line_index);
981: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
982: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
983: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
984: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := Entity_info_tbl(i).trx_line_id ;
985: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
986: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
987: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
981: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(Entity_info_tbl(i).line_index);
982: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
983: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
984: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := Entity_info_tbl(i).trx_line_id ;
985: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
986: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
987: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
988: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
989: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
982: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(Entity_info_tbl(i).line_index);
983: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
984: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := Entity_info_tbl(i).trx_line_id ;
985: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
986: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
987: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
988: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
989: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
990: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
983: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index);
984: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := Entity_info_tbl(i).trx_line_id ;
985: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
986: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
987: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
988: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
989: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
990: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
991: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
984: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := Entity_info_tbl(i).trx_line_id ;
985: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
986: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
987: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
988: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
989: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
990: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
991: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
992: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
985: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
986: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
987: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
988: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
989: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
990: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
991: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
992: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
993: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
986: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index);
987: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
988: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
989: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
990: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
991: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
992: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
993: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
994: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
987: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index);
988: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
989: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
990: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
991: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
992: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
993: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
994: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
995: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
988: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(Entity_info_tbl(i).line_index);
989: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
990: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
991: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
992: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
993: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
994: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
995: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
996: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i)
989: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(Entity_info_tbl(i).line_index);
990: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
991: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
992: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
993: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
994: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
995: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
996: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i)
997: := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
990: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(Entity_info_tbl(i).line_index);
991: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
992: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
993: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
994: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
995: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
996: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i)
997: := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
998: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
991: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).line_index);
992: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(Entity_info_tbl(i).line_index);
993: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
994: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
995: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
996: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i)
997: := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
998: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
999: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := Entity_info_tbl(i).charge_amt ;
993: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
994: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
995: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
996: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i)
997: := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
998: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
999: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := Entity_info_tbl(i).charge_amt ;
1000: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(Entity_info_tbl(i).line_index)
1001:
994: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).line_index);
995: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(Entity_info_tbl(i).line_index);
996: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i)
997: := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
998: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
999: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := Entity_info_tbl(i).charge_amt ;
1000: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(Entity_info_tbl(i).line_index)
1001:
1002: IN ('JL.AR.OEXOEORD.LINES', 'JL.BR.OEXOEORD.LINES', 'JL.CO.OEXOEORD.LINES') THEN
996: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i)
997: := NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (Entity_info_tbl(i).line_index),
998: OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(Entity_info_tbl(i).line_index));
999: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := Entity_info_tbl(i).charge_amt ;
1000: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(Entity_info_tbl(i).line_index)
1001:
1002: IN ('JL.AR.OEXOEORD.LINES', 'JL.BR.OEXOEORD.LINES', 'JL.CO.OEXOEORD.LINES') THEN
1003: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute6(Entity_info_tbl(i).line_index);
1004: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute5(Entity_info_tbl(i).line_index);
999: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := Entity_info_tbl(i).charge_amt ;
1000: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(Entity_info_tbl(i).line_index)
1001:
1002: IN ('JL.AR.OEXOEORD.LINES', 'JL.BR.OEXOEORD.LINES', 'JL.CO.OEXOEORD.LINES') THEN
1003: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute6(Entity_info_tbl(i).line_index);
1004: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute5(Entity_info_tbl(i).line_index);
1005: ELSE
1006: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := NULL;
1007: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i):= NULL;
1000: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(Entity_info_tbl(i).line_index)
1001:
1002: IN ('JL.AR.OEXOEORD.LINES', 'JL.BR.OEXOEORD.LINES', 'JL.CO.OEXOEORD.LINES') THEN
1003: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute6(Entity_info_tbl(i).line_index);
1004: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute5(Entity_info_tbl(i).line_index);
1005: ELSE
1006: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := NULL;
1007: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i):= NULL;
1008: END IF;
1005: ELSE
1006: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := NULL;
1007: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i):= NULL;
1008: END IF;
1009: zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_LINE_ID(i) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(Entity_info_tbl(i).line_index);
1010: elsif l_level = 'HC' THEN
1011:
1012: oe_debug_pub.add( 'Loading Header LEVEL charge details');
1013:
1015: l_person_id := OE_BULK_CACHE.G_SALESREP_TBL(l_salesrep_cache_key).person_id;
1016: IF l_debug_level > 0 THEN
1017: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);
1018: oe_debug_pub.add( ' l_index :'|| l_index);
1019: oe_debug_pub.add( ' Tax Date :'|| OE_Bulk_Order_PVT.G_LINE_REC.tax_date(i));
1020: END IF;
1021: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, sysdate);
1022: EXCEPTION
1023: WHEN OTHERS THEN
1032: ELSE
1033: l_asgn_org_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).ORGANIZATION_ID; -- the cache key is l_person_id only
1034: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;
1035: END IF;
1036: IF OE_Bulk_Order_PVT.G_HEADER_REC.invoice_to_org_id(Entity_info_tbl(i).header_index) IS NOT NULL THEN
1037: IF l_debug_level > 0 THEN
1038: oe_debug_pub.add( 'retrieving bill_to info');
1039: oe_debug_pub.add( '3header index:'||Entity_info_tbl(i).header_index);
1040: oe_debug_pub.add( '3header index invoice to org:'||OE_Bulk_Order_PVT.G_header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index));
1036: IF OE_Bulk_Order_PVT.G_HEADER_REC.invoice_to_org_id(Entity_info_tbl(i).header_index) IS NOT NULL THEN
1037: IF l_debug_level > 0 THEN
1038: oe_debug_pub.add( 'retrieving bill_to info');
1039: oe_debug_pub.add( '3header index:'||Entity_info_tbl(i).header_index);
1040: oe_debug_pub.add( '3header index invoice to org:'||OE_Bulk_Order_PVT.G_header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index));
1041: END IF;
1042: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index));
1043: oe_debug_pub.add( 'l_invoice_to_cache_key:' ||l_invoice_to_cache_key );
1044: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1038: oe_debug_pub.add( 'retrieving bill_to info');
1039: oe_debug_pub.add( '3header index:'||Entity_info_tbl(i).header_index);
1040: oe_debug_pub.add( '3header index invoice to org:'||OE_Bulk_Order_PVT.G_header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index));
1041: END IF;
1042: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index));
1043: oe_debug_pub.add( 'l_invoice_to_cache_key:' ||l_invoice_to_cache_key );
1044: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1045: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
1046: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
1062: INTO l_cust_trx_type_id
1063: FROM oe_order_types_v ot,
1064: oe_order_headers_all oh
1065: WHERE ot.order_type_id = oh.order_type_id
1066: AND oh.header_id = OE_Bulk_Order_PVT.G_header_REC.header_id(Entity_info_tbl(i).header_index);
1067: EXCEPTION
1068: WHEN OTHERS THEN
1069: IF l_debug_level > 0 THEN
1070: oe_debug_pub.add('In header exception ',4);
1070: oe_debug_pub.add('In header exception ',4);
1071: END IF;
1072: NULL;
1073: END;
1074: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
1075: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
1076: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
1077: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
1078: SELECT c.minimum_accountable_unit,
1071: END IF;
1072: NULL;
1073: END;
1074: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
1075: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
1076: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
1077: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
1078: SELECT c.minimum_accountable_unit,
1079: c.precision
1072: NULL;
1073: END;
1074: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
1075: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
1076: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
1077: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
1078: SELECT c.minimum_accountable_unit,
1079: c.precision
1080: INTO l_minimum_accountable_unit,
1073: END;
1074: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
1075: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
1076: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
1077: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
1078: SELECT c.minimum_accountable_unit,
1079: c.precision
1080: INTO l_minimum_accountable_unit,
1081: l_precision
1080: INTO l_minimum_accountable_unit,
1081: l_precision
1082: FROM fnd_currencies c
1083: WHERE c.currency_code = l_currency_code;
1084: OPEN get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
1085: FETCH get_internal_loc INTO l_internal_org_location_id;
1086: CLOSE get_internal_loc;
1087: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
1088: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
1083: WHERE c.currency_code = l_currency_code;
1084: OPEN get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
1085: FETCH get_internal_loc INTO l_internal_org_location_id;
1086: CLOSE get_internal_loc;
1087: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
1088: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
1089: p_bill_to_customer_id => l_bill_to_cust_id ,
1090: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index) );
1091: IF OE_Bulk_Order_PVT.G_Header_REC.ship_from_org_id(Entity_info_tbl(i).header_index) IS NOT NULL THEN
1084: OPEN get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
1085: FETCH get_internal_loc INTO l_internal_org_location_id;
1086: CLOSE get_internal_loc;
1087: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
1088: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
1089: p_bill_to_customer_id => l_bill_to_cust_id ,
1090: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index) );
1091: IF OE_Bulk_Order_PVT.G_Header_REC.ship_from_org_id(Entity_info_tbl(i).header_index) IS NOT NULL THEN
1092: BEGIN
1086: CLOSE get_internal_loc;
1087: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
1088: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
1089: p_bill_to_customer_id => l_bill_to_cust_id ,
1090: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index) );
1091: IF OE_Bulk_Order_PVT.G_Header_REC.ship_from_org_id(Entity_info_tbl(i).header_index) IS NOT NULL THEN
1092: BEGIN
1093: SELECT location_id
1094: INTO l_ship_from_location_id
1087: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(Entity_info_tbl(i).header_index) ,
1088: p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(Entity_info_tbl(i).header_index) ,
1089: p_bill_to_customer_id => l_bill_to_cust_id ,
1090: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index) );
1091: IF OE_Bulk_Order_PVT.G_Header_REC.ship_from_org_id(Entity_info_tbl(i).header_index) IS NOT NULL THEN
1092: BEGIN
1093: SELECT location_id
1094: INTO l_ship_from_location_id
1095: FROM hr_all_organization_units hu
1092: BEGIN
1093: SELECT location_id
1094: INTO l_ship_from_location_id
1095: FROM hr_all_organization_units hu
1096: WHERE hu.organization_id = OE_Bulk_Order_PVT.G_Header_REC.ship_from_org_id(Entity_info_tbl(i).header_index);
1097: EXCEPTION
1098: WHEN OTHERS THEN
1099: NULL;
1100: END;
1098: WHEN OTHERS THEN
1099: NULL;
1100: END;
1101: END IF;
1102: IF OE_Bulk_Order_PVT.G_HEADER_REC.ship_to_org_id(Entity_info_tbl(i).header_index) IS NOT NULL THEN
1103: IF l_debug_level > 0 THEN
1104: oe_debug_pub.add( 'retrieving ship_to info for Header record');
1105: oe_debug_pub.add( 'retrieving ship_to info');
1106: oe_debug_pub.add( ' Ship to Header:'||Entity_info_tbl(i).header_index);
1103: IF l_debug_level > 0 THEN
1104: oe_debug_pub.add( 'retrieving ship_to info for Header record');
1105: oe_debug_pub.add( 'retrieving ship_to info');
1106: oe_debug_pub.add( ' Ship to Header:'||Entity_info_tbl(i).header_index);
1107: oe_debug_pub.add( ' ship to Line index invoice to org:'||OE_Bulk_Order_PVT.G_HEADER_REC.ship_to_org_id(Entity_info_tbl(i).header_index));
1108:
1109: END IF;
1110: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_HEADER_REC.ship_to_org_id(Entity_info_tbl(i).header_index));
1111: oe_debug_pub.add(' l_ship_to_cache_key:'||l_ship_to_cache_key);
1106: oe_debug_pub.add( ' Ship to Header:'||Entity_info_tbl(i).header_index);
1107: oe_debug_pub.add( ' ship to Line index invoice to org:'||OE_Bulk_Order_PVT.G_HEADER_REC.ship_to_org_id(Entity_info_tbl(i).header_index));
1108:
1109: END IF;
1110: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_HEADER_REC.ship_to_org_id(Entity_info_tbl(i).header_index));
1111: oe_debug_pub.add(' l_ship_to_cache_key:'||l_ship_to_cache_key);
1112: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1113: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
1114: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
1130: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i) := NULL;
1131: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i) := NULL;
1132: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i) := Entity_info_tbl(i).TRX_ID ;
1133: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := NULL ;
1134: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_Header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index);
1135: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := Entity_info_tbl(i).trx_line_id ;
1136: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := NULL;
1137: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_HEADER_Rec.ship_from_org_id(Entity_info_tbl(i).header_index);
1138: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_Header_REC.ship_to_org_id(Entity_info_tbl(i).header_index);
1133: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i) := NULL ;
1134: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_Header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index);
1135: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := Entity_info_tbl(i).trx_line_id ;
1136: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := NULL;
1137: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_HEADER_Rec.ship_from_org_id(Entity_info_tbl(i).header_index);
1138: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_Header_REC.ship_to_org_id(Entity_info_tbl(i).header_index);
1139: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := NULL;
1140: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := sysdate;
1141: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := sysdate;
1134: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_Header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index);
1135: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i) := Entity_info_tbl(i).trx_line_id ;
1136: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i) := NULL;
1137: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i) := OE_Bulk_Order_PVT.G_HEADER_Rec.ship_from_org_id(Entity_info_tbl(i).header_index);
1138: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_Header_REC.ship_to_org_id(Entity_info_tbl(i).header_index);
1139: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := NULL;
1140: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := sysdate;
1141: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := sysdate;
1142: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).header_index);
1138: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i) := OE_Bulk_Order_PVT.G_Header_REC.ship_to_org_id(Entity_info_tbl(i).header_index);
1139: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := NULL;
1140: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := sysdate;
1141: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := sysdate;
1142: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).header_index);
1143: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_header_Rec.tax_exempt_number(Entity_info_tbl(i).header_index);
1144: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).Header_index);
1145: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).header_index);
1146: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := NULL ;
1139: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i) := NULL;
1140: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := sysdate;
1141: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := sysdate;
1142: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).header_index);
1143: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_header_Rec.tax_exempt_number(Entity_info_tbl(i).header_index);
1144: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).Header_index);
1145: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).header_index);
1146: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := NULL ;
1147: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i) := NULL ;
1140: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i) := sysdate;
1141: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := sysdate;
1142: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).header_index);
1143: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_header_Rec.tax_exempt_number(Entity_info_tbl(i).header_index);
1144: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).Header_index);
1145: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).header_index);
1146: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := NULL ;
1147: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i) := NULL ;
1148: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := Entity_info_tbl(i).charge_amt ;
1141: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i) := sysdate;
1142: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_FLAG(Entity_info_tbl(i).header_index);
1143: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i) := OE_Bulk_Order_PVT.G_header_Rec.tax_exempt_number(Entity_info_tbl(i).header_index);
1144: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).Header_index);
1145: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i) := OE_Bulk_Order_PVT.G_Header_Rec.TAX_EXEMPT_REASON_CODE(Entity_info_tbl(i).header_index);
1146: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i) := NULL ;
1147: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i) := NULL ;
1148: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i) := Entity_info_tbl(i).charge_amt ;
1149: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i) := NULL;
1171: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_ID(i) := l_ship_party_id;
1172: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID(i) := l_ship_party_site_id;
1173: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(i) := l_ship_to_cust_account_id;
1174: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(i) := l_ship_to_cust_acct_site_id;
1175: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(i) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate(Entity_info_tbl(i).header_index);
1176: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(i) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate_Date(Entity_info_tbl(i).header_index);
1177: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(i) := OE_Bulk_Order_PVT.G_Header_Rec.CONVERSION_TYPE_CODE(Entity_info_tbl(i).header_index);
1178: zx_global_structures_pkg.trx_line_dist_tbl.TRX_NUMBER(i) := OE_Bulk_Order_PVT.G_Header_Rec.order_number(Entity_info_tbl(i).header_index);
1179: zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(i) := OE_Bulk_Order_PVT.G_Header_Rec.org_id(Entity_info_tbl(i).header_index);
1172: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID(i) := l_ship_party_site_id;
1173: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(i) := l_ship_to_cust_account_id;
1174: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(i) := l_ship_to_cust_acct_site_id;
1175: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(i) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate(Entity_info_tbl(i).header_index);
1176: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(i) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate_Date(Entity_info_tbl(i).header_index);
1177: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(i) := OE_Bulk_Order_PVT.G_Header_Rec.CONVERSION_TYPE_CODE(Entity_info_tbl(i).header_index);
1178: zx_global_structures_pkg.trx_line_dist_tbl.TRX_NUMBER(i) := OE_Bulk_Order_PVT.G_Header_Rec.order_number(Entity_info_tbl(i).header_index);
1179: zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(i) := OE_Bulk_Order_PVT.G_Header_Rec.org_id(Entity_info_tbl(i).header_index);
1180: zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(i) := OE_Bulk_Order_PVT.G_Header_Rec.transactional_curr_code(Entity_info_tbl(i).header_index);
1173: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(i) := l_ship_to_cust_account_id;
1174: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(i) := l_ship_to_cust_acct_site_id;
1175: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(i) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate(Entity_info_tbl(i).header_index);
1176: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(i) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate_Date(Entity_info_tbl(i).header_index);
1177: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(i) := OE_Bulk_Order_PVT.G_Header_Rec.CONVERSION_TYPE_CODE(Entity_info_tbl(i).header_index);
1178: zx_global_structures_pkg.trx_line_dist_tbl.TRX_NUMBER(i) := OE_Bulk_Order_PVT.G_Header_Rec.order_number(Entity_info_tbl(i).header_index);
1179: zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(i) := OE_Bulk_Order_PVT.G_Header_Rec.org_id(Entity_info_tbl(i).header_index);
1180: zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(i) := OE_Bulk_Order_PVT.G_Header_Rec.transactional_curr_code(Entity_info_tbl(i).header_index);
1181: zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(i) := NULL ;
1174: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(i) := l_ship_to_cust_acct_site_id;
1175: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(i) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate(Entity_info_tbl(i).header_index);
1176: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(i) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate_Date(Entity_info_tbl(i).header_index);
1177: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(i) := OE_Bulk_Order_PVT.G_Header_Rec.CONVERSION_TYPE_CODE(Entity_info_tbl(i).header_index);
1178: zx_global_structures_pkg.trx_line_dist_tbl.TRX_NUMBER(i) := OE_Bulk_Order_PVT.G_Header_Rec.order_number(Entity_info_tbl(i).header_index);
1179: zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(i) := OE_Bulk_Order_PVT.G_Header_Rec.org_id(Entity_info_tbl(i).header_index);
1180: zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(i) := OE_Bulk_Order_PVT.G_Header_Rec.transactional_curr_code(Entity_info_tbl(i).header_index);
1181: zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(i) := NULL ;
1182: zx_global_structures_pkg.trx_line_dist_tbl.TRANSFER_CHARGE(i) := NULL ;
1175: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(i) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate(Entity_info_tbl(i).header_index);
1176: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(i) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate_Date(Entity_info_tbl(i).header_index);
1177: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(i) := OE_Bulk_Order_PVT.G_Header_Rec.CONVERSION_TYPE_CODE(Entity_info_tbl(i).header_index);
1178: zx_global_structures_pkg.trx_line_dist_tbl.TRX_NUMBER(i) := OE_Bulk_Order_PVT.G_Header_Rec.order_number(Entity_info_tbl(i).header_index);
1179: zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(i) := OE_Bulk_Order_PVT.G_Header_Rec.org_id(Entity_info_tbl(i).header_index);
1180: zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(i) := OE_Bulk_Order_PVT.G_Header_Rec.transactional_curr_code(Entity_info_tbl(i).header_index);
1181: zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(i) := NULL ;
1182: zx_global_structures_pkg.trx_line_dist_tbl.TRANSFER_CHARGE(i) := NULL ;
1183: zx_global_structures_pkg.trx_line_dist_tbl.TRX_SIC_CODE(i) := NULL ;
1176: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(i) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate_Date(Entity_info_tbl(i).header_index);
1177: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(i) := OE_Bulk_Order_PVT.G_Header_Rec.CONVERSION_TYPE_CODE(Entity_info_tbl(i).header_index);
1178: zx_global_structures_pkg.trx_line_dist_tbl.TRX_NUMBER(i) := OE_Bulk_Order_PVT.G_Header_Rec.order_number(Entity_info_tbl(i).header_index);
1179: zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(i) := OE_Bulk_Order_PVT.G_Header_Rec.org_id(Entity_info_tbl(i).header_index);
1180: zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(i) := OE_Bulk_Order_PVT.G_Header_Rec.transactional_curr_code(Entity_info_tbl(i).header_index);
1181: zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(i) := NULL ;
1182: zx_global_structures_pkg.trx_line_dist_tbl.TRANSFER_CHARGE(i) := NULL ;
1183: zx_global_structures_pkg.trx_line_dist_tbl.TRX_SIC_CODE(i) := NULL ;
1184: zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_SITE_ID(i) := NULL ;
1506: l_transaction_rec.application_id := 660;
1507: l_transaction_rec.entity_code := 'OE_ORDER_HEADERS';
1508: l_transaction_rec.event_class_code := 'SALES_TRANSACTION_TAX_QUOTE';
1509: l_transaction_rec.event_type_code := 'CREATE';
1510: l_transaction_rec.trx_id := OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index);
1511: l_transaction_rec.internal_organization_id := OE_Bulk_Order_PVT.G_Header_Rec.org_id(l_header_index);
1512: SELECT hsecs INTO l_start_time FROM v$timer;
1513: IF l_call_tax = 'Y' THEN --Call ZX api only if there is atleast one eligible line to be taxed
1514: oe_debug_pub.add( ' Call zx_api_pub.calculate_tax ',1);
1507: l_transaction_rec.entity_code := 'OE_ORDER_HEADERS';
1508: l_transaction_rec.event_class_code := 'SALES_TRANSACTION_TAX_QUOTE';
1509: l_transaction_rec.event_type_code := 'CREATE';
1510: l_transaction_rec.trx_id := OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index);
1511: l_transaction_rec.internal_organization_id := OE_Bulk_Order_PVT.G_Header_Rec.org_id(l_header_index);
1512: SELECT hsecs INTO l_start_time FROM v$timer;
1513: IF l_call_tax = 'Y' THEN --Call ZX api only if there is atleast one eligible line to be taxed
1514: oe_debug_pub.add( ' Call zx_api_pub.calculate_tax ',1);
1515: zx_api_pub.calculate_tax( p_api_version => 1.0,
1541: OE_MSG_PUB.Add;
1542: END IF;
1543: Handle_Error( l_header_index);
1544: IF l_debug_level > 0 THEN
1545: oe_debug_pub.add( 'return status was ERROR. skipping header with header id: '|| OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index));
1546: oe_debug_pub.add( ' Error :'|| l_x_msg_data, 1);
1547: END IF;
1548: --Skip the remaining lines in this header as it is marked for error
1549: -- l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
1545: oe_debug_pub.add( 'return status was ERROR. skipping header with header id: '|| OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index));
1546: oe_debug_pub.add( ' Error :'|| l_x_msg_data, 1);
1547: END IF;
1548: --Skip the remaining lines in this header as it is marked for error
1549: -- l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
1550: -- l_index_inc := l_remaining_lines + 1;
1551: ELSE
1552: IF l_debug_level > 0 THEN
1553: oe_debug_pub.add( 'before building adjustment records');
1558: loop
1559: exit when detail_tax_lines_gt%NOTFOUND;*/
1560: i:=1;
1561:
1562: oe_debug_pub.add( ' Number of records in Header' || OE_Bulk_Order_PVT.G_HEADER_REC.HEADER_ID.Count , 1);
1563:
1564: FOR j IN 1..OE_Bulk_Order_PVT.G_HEADER_REC.HEADER_ID.COUNT
1565: LOOP
1566:
1560: i:=1;
1561:
1562: oe_debug_pub.add( ' Number of records in Header' || OE_Bulk_Order_PVT.G_HEADER_REC.HEADER_ID.Count , 1);
1563:
1564: FOR j IN 1..OE_Bulk_Order_PVT.G_HEADER_REC.HEADER_ID.COUNT
1565: LOOP
1566:
1567: FOR detail_tax_lines_gt_rec IN detail_tax_lines_gt(OE_Bulk_Order_PVT.G_Header_Rec.header_id(j))
1568: LOOP
1563:
1564: FOR j IN 1..OE_Bulk_Order_PVT.G_HEADER_REC.HEADER_ID.COUNT
1565: LOOP
1566:
1567: FOR detail_tax_lines_gt_rec IN detail_tax_lines_gt(OE_Bulk_Order_PVT.G_Header_Rec.header_id(j))
1568: LOOP
1569: oe_debug_pub.add( ' Header il_header_index Lalit' || detail_tax_lines_gt_rec.trx_level_type, 1);
1570: oe_debug_pub.add( ' Header id :' || OE_Bulk_Order_PVT.G_Header_Rec.header_id(j), 1);
1571: oe_debug_pub.add( ' Tax Code :'|| detail_tax_lines_gt_rec.Tax_Code,1);
1566:
1567: FOR detail_tax_lines_gt_rec IN detail_tax_lines_gt(OE_Bulk_Order_PVT.G_Header_Rec.header_id(j))
1568: LOOP
1569: oe_debug_pub.add( ' Header il_header_index Lalit' || detail_tax_lines_gt_rec.trx_level_type, 1);
1570: oe_debug_pub.add( ' Header id :' || OE_Bulk_Order_PVT.G_Header_Rec.header_id(j), 1);
1571: oe_debug_pub.add( ' Tax Code :'|| detail_tax_lines_gt_rec.Tax_Code,1);
1572: oe_debug_pub.add( ' Tax_rate_id :'|| detail_tax_lines_gt_rec.tax_rate_id ,1);
1573: oe_debug_pub.add( ' Trx_line_id :'|| detail_tax_lines_gt_rec.trx_line_id ,1);
1574: --Build the Adjustments records to INSERT Tax Info
1573: oe_debug_pub.add( ' Trx_line_id :'|| detail_tax_lines_gt_rec.trx_line_id ,1);
1574: --Build the Adjustments records to INSERT Tax Info
1575: Extend_Adj_Rec(1, G_LINE_ADJ_REC);
1576: oe_debug_pub.add( ' Aftr Extend '||i);
1577: G_LINE_ADJ_REC.header_id(i) := detail_tax_lines_gt_rec.trx_id; --OE_Bulk_Order_PVT.G_Line_Rec.header_id(i);
1578:
1579: --OE_Bulk_Order_PVT.G_Line_Rec.line_id(i);
1580: -- l_tax_code := OE_Bulk_Order_PVT.G_LINE_REC.Tax_Code(i);
1581: IF detail_tax_lines_gt_rec.trx_level_type = 'FREIGHT CHARGE' THEN
1575: Extend_Adj_Rec(1, G_LINE_ADJ_REC);
1576: oe_debug_pub.add( ' Aftr Extend '||i);
1577: G_LINE_ADJ_REC.header_id(i) := detail_tax_lines_gt_rec.trx_id; --OE_Bulk_Order_PVT.G_Line_Rec.header_id(i);
1578:
1579: --OE_Bulk_Order_PVT.G_Line_Rec.line_id(i);
1580: -- l_tax_code := OE_Bulk_Order_PVT.G_LINE_REC.Tax_Code(i);
1581: IF detail_tax_lines_gt_rec.trx_level_type = 'FREIGHT CHARGE' THEN
1582: oe_debug_pub.add( ' Inside Freight charge ');
1583: G_LINE_ADJ_REC.line_id(i) := detail_tax_lines_gt_rec.TRX_LINE_NUMBER;
1576: oe_debug_pub.add( ' Aftr Extend '||i);
1577: G_LINE_ADJ_REC.header_id(i) := detail_tax_lines_gt_rec.trx_id; --OE_Bulk_Order_PVT.G_Line_Rec.header_id(i);
1578:
1579: --OE_Bulk_Order_PVT.G_Line_Rec.line_id(i);
1580: -- l_tax_code := OE_Bulk_Order_PVT.G_LINE_REC.Tax_Code(i);
1581: IF detail_tax_lines_gt_rec.trx_level_type = 'FREIGHT CHARGE' THEN
1582: oe_debug_pub.add( ' Inside Freight charge ');
1583: G_LINE_ADJ_REC.line_id(i) := detail_tax_lines_gt_rec.TRX_LINE_NUMBER;
1584: G_LINE_ADJ_REC.PARENT_ADJUSTMENT_ID(i) := detail_tax_lines_gt_rec.trx_line_id;
1593: G_LINE_ADJ_REC.automatic_flag(i) := 'N';
1594: G_LINE_ADJ_REC.list_line_type_code(i) := 'TAX';
1595: G_LINE_ADJ_REC.arithmetic_operator(i) := 'AMT';
1596: G_LINE_ADJ_REC.tax_rate_id(i) := detail_tax_lines_gt_rec.tax_rate_id ; --bug7685103
1597: -- OE_Bulk_Order_PVT.G_LINE_REC.tax_value(i) := detail_tax_lines_gt_rec.tax_amt;
1598: IF l_debug_level > 0 THEN
1599: oe_debug_pub.add( 'total tax value: i: ' || detail_tax_lines_gt_rec.tax_amt, 1);
1600: END IF;
1601: --IF p_post_insert THEN
1609: i := i + 1;
1610: END LOOP;
1611: END LOOP;
1612: END IF;
1613: FOR i IN 1..OE_Bulk_Order_PVT.G_LINE_REC.line_id.COUNT
1614: LOOP --bug7685103
1615: FOR j IN 1..G_Tax_Line_Id.COUNT
1616: LOOP
1617: IF OE_Bulk_Order_PVT.G_LINE_REC.line_id(i) = G_Tax_Line_Id(j) THEN
1613: FOR i IN 1..OE_Bulk_Order_PVT.G_LINE_REC.line_id.COUNT
1614: LOOP --bug7685103
1615: FOR j IN 1..G_Tax_Line_Id.COUNT
1616: LOOP
1617: IF OE_Bulk_Order_PVT.G_LINE_REC.line_id(i) = G_Tax_Line_Id(j) THEN
1618: OE_Bulk_Order_PVT.G_LINE_REC.tax_value(i) := NVL(OE_Bulk_Order_PVT.G_LINE_REC.tax_value(i),0)+ G_Tax_Line_Value(j);
1619: END IF;
1620: END LOOP;
1621: END LOOP;
1614: LOOP --bug7685103
1615: FOR j IN 1..G_Tax_Line_Id.COUNT
1616: LOOP
1617: IF OE_Bulk_Order_PVT.G_LINE_REC.line_id(i) = G_Tax_Line_Id(j) THEN
1618: OE_Bulk_Order_PVT.G_LINE_REC.tax_value(i) := NVL(OE_Bulk_Order_PVT.G_LINE_REC.tax_value(i),0)+ G_Tax_Line_Value(j);
1619: END IF;
1620: END LOOP;
1621: END LOOP;
1622: --bug7685103
1834:
1835: FOR i IN 1..G_LINE_ID.COUNT LOOP
1836: total_freight_tax:=0;
1837:
1838: oe_debug_pub.add( 'Updating oe_price_Adjustments for line'||OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i) ) ;
1839:
1840:
1841: FOR j IN freight_charges(G_LINE_ID(i)) LOOP
1842:
1916: IF l_debug_level > 0 THEN
1917: oe_debug_pub.add( 'ENTERING OE_BULK_TAX_UTIL.HANDLE_ERROR' ) ;
1918: END IF;
1919:
1920: --OE_Bulk_Order_PVT.G_LINE_REC.lock_control(p_line_index) := -99;
1921: OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(p_header_index) := -99;
1922: OE_BULK_ORDER_PVT.mark_header_error(p_header_index, OE_Bulk_Order_PVT.G_HEADER_REC);
1923:
1924:
1917: oe_debug_pub.add( 'ENTERING OE_BULK_TAX_UTIL.HANDLE_ERROR' ) ;
1918: END IF;
1919:
1920: --OE_Bulk_Order_PVT.G_LINE_REC.lock_control(p_line_index) := -99;
1921: OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(p_header_index) := -99;
1922: OE_BULK_ORDER_PVT.mark_header_error(p_header_index, OE_Bulk_Order_PVT.G_HEADER_REC);
1923:
1924:
1925: IF l_debug_level > 0 THEN
1918: END IF;
1919:
1920: --OE_Bulk_Order_PVT.G_LINE_REC.lock_control(p_line_index) := -99;
1921: OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(p_header_index) := -99;
1922: OE_BULK_ORDER_PVT.mark_header_error(p_header_index, OE_Bulk_Order_PVT.G_HEADER_REC);
1923:
1924:
1925: IF l_debug_level > 0 THEN
1926: oe_debug_pub.add( 'EXITING OE_BULK_TAX_UTIL.HANDLE_ERROR' ) ;
1958: IF l_debug_level > 0 THEN
1959: oe_debug_pub.add( 'ENTERING OE_BULK_TAX_UTIL.HANDLE_TAX_CODE_ERROR' ) ;
1960: END IF;
1961:
1962: OE_Bulk_Order_PVT.G_LINE_REC.tax_code(p_index) := null;
1963:
1964: IF nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(p_header_index), 'N') = 'Y'
1965: THEN
1966:
1960: END IF;
1961:
1962: OE_Bulk_Order_PVT.G_LINE_REC.tax_code(p_index) := null;
1963:
1964: IF nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(p_header_index), 'N') = 'Y'
1965: THEN
1966:
1967:
1968: IF l_debug_level > 0 THEN
1968: IF l_debug_level > 0 THEN
1969: oe_debug_pub.add( 'order was booked');
1970: END IF;
1971:
1972: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(p_header_index));
1973: IF OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event IN ('ENTERING', 'BOOKING') THEN
1974:
1975: OE_BULK_MSG_PUB.Set_Msg_Context
1976: ( p_entity_code => 'HEADER'
1973: IF OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event IN ('ENTERING', 'BOOKING') THEN
1974:
1975: OE_BULK_MSG_PUB.Set_Msg_Context
1976: ( p_entity_code => 'HEADER'
1977: ,p_entity_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1978: ,p_header_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1979: ,p_orig_sys_document_ref => OE_Bulk_Order_PVT.G_HEADER_REC.orig_sys_document_ref(p_header_index)
1980: ,p_order_source_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_source_id(p_header_index)
1981: );
1974:
1975: OE_BULK_MSG_PUB.Set_Msg_Context
1976: ( p_entity_code => 'HEADER'
1977: ,p_entity_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1978: ,p_header_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1979: ,p_orig_sys_document_ref => OE_Bulk_Order_PVT.G_HEADER_REC.orig_sys_document_ref(p_header_index)
1980: ,p_order_source_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_source_id(p_header_index)
1981: );
1982:
1975: OE_BULK_MSG_PUB.Set_Msg_Context
1976: ( p_entity_code => 'HEADER'
1977: ,p_entity_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1978: ,p_header_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1979: ,p_orig_sys_document_ref => OE_Bulk_Order_PVT.G_HEADER_REC.orig_sys_document_ref(p_header_index)
1980: ,p_order_source_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_source_id(p_header_index)
1981: );
1982:
1983: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TAX_CODE_REQD');
1976: ( p_entity_code => 'HEADER'
1977: ,p_entity_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1978: ,p_header_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1979: ,p_orig_sys_document_ref => OE_Bulk_Order_PVT.G_HEADER_REC.orig_sys_document_ref(p_header_index)
1980: ,p_order_source_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_source_id(p_header_index)
1981: );
1982:
1983: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TAX_CODE_REQD');
1984: OE_BULK_MSG_PUB.Add;
1984: OE_BULK_MSG_PUB.Add;
1985: Handle_Error( p_header_index);
1986:
1987: IF l_debug_level > 0 THEN
1988: oe_debug_pub.add( 'tax code not found. skipping header with header id: '|| OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index));
1989: END IF;
1990:
1991: --Skip the remaining lines in this header
1992: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(p_header_index) - p_index;
1988: oe_debug_pub.add( 'tax code not found. skipping header with header id: '|| OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index));
1989: END IF;
1990:
1991: --Skip the remaining lines in this header
1992: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(p_header_index) - p_index;
1993: l_index_inc := l_remaining_lines + 1;
1994: END IF; -- end of tax event in ENTERING or BOOKING
1995:
1996: END IF; --end of IF booked_flag = 'Y'