eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.OM_TAX_UTIL

Source


1 PACKAGE BODY OM_TAX_UTIL AS
2 /* $Header: OEXUTAXB.pls 120.20.12010000.4 2008/11/13 08:40:06 amallik ship $ */
3 G_DEBUG_BYPASS_TAX            CONSTANT VARCHAR2(1):=nvl(Fnd_Profile.value('OE_DBG_BYPASS'),'N');
4  -- structure for caching loc_ship_bill_info
5  TYPE loc_ship_bill_info_rec IS RECORD (
6           site_use_id                 HZ_CUST_SITE_USES_ALL.site_use_id%TYPE,
7           acct_site_id                HZ_CUST_SITE_USES_ALL.cust_acct_site_id%TYPE,
8           cust_acct_id                HZ_CUST_ACCT_SITES_ALL.cust_account_id%TYPE,
9           postal_code                 HZ_LOCATIONS.postal_code%TYPE,
10           customer_name               HZ_PARTIES.party_name%TYPE,
11           customer_number             HZ_CUST_ACCOUNTS_ALL.account_number%TYPE,
12           party_id                    HZ_PARTIES.party_id%TYPE,
13           party_site_id               HZ_PARTY_SITES.party_site_id%TYPE,
14           location_id                 HZ_LOCATIONS.location_id%TYPE);
15 
16  TYPE ship_bill_records IS TABLE OF loc_ship_bill_info_rec INDEX BY BINARY_INTEGER;
17  ship_bill_records_tab  ship_bill_records;
18  pr_index    number;
19 
20 -- salesrep criteria
21 G_SALESREP_ID                     NUMBER;
22 G_SALESREP_POA_ID                 NUMBER;
23 
24 -- cache values
25 G_POO_PARTY_ID                          NUMBER;
26 G_POO_LOCATION_ID                   NUMBER;
27 
28 Procedure Debug_msg(p_index         IN  NUMBER,
29 		    x_return_status OUT NOCOPY Varchar2) ;
30 
31 
32 Function get_le_id(p_order_type_id NUMBER
33                   , p_sold_to_customer_id NUMBER
34                   , p_bill_to_customer_id NUMBER
35                   , p_org_id NUMBER
36 ) RETURN NUMBER;
37 
38 PROCEDURE TAX_LINE( p_line_rec           in OE_Order_PUB.Line_Rec_Type,
39                     p_header_rec         in OE_Order_PUB.Header_Rec_Type,
40                     x_tax_value          out NOCOPY /* file.sql.39 change */ number,
41                     x_tax_out_tbl OUT NOCOPY OM_TAX_UTIL.om_tax_out_tab_type,
42                     x_return_status      out NOCOPY /* file.sql.39 change */ varchar2) as
43 
44  l_tax_rec_out_tbl              OM_TAX_UTIL.om_tax_out_tab_type;
45  -- x_ret_sts                       VARCHAR2(10) := NULL; --bug 3064854
46  l_return_status                VARCHAR2(1);
47  -- l_ren_tax_timing            NUMBER := 0;
48  -- lp                          BINARY_INTEGER;
49  l_call_tax                     VARCHAR2(1);
50  l_tax_value                    NUMBER;
51  l_msg_count                    NUMBER;
52  l_msg_data                     VARCHAR2(1000);
53  l_trx_shipping_date		DATE;
54  l_trx_business_category	VARCHAR2(240);
55  l_product_fisc_classification	VARCHAR2(240);
56  l_uom_code			VARCHAR2(3);
57  l_product_code			VARCHAR2(1000);
58  l_trx_line_number		NUMBER;
59  l_user_item_description	VARCHAR2(1000);
60  i				NUMBER;
61  l_ship_party_id		NUMBER(15);
62  l_ship_party_site_id	        NUMBER(15);
63  l_ship_location_id	        NUMBER(15);
64  l_bill_party_id		NUMBER(15);
65  l_bill_party_site_id	        NUMBER(15);
66  l_bill_location_id	        NUMBER(15);
67  l_ship_to_site_use_id		HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;
68  l_ship_to_address_id           NUMBER ;
69  l_ship_to_customer_id          NUMBER ;
70  l_ship_to_postal_code          VARCHAR2(60);
71  l_ship_to_customer_name        VARCHAR2(360);
72  l_ship_to_customer_number      VARCHAR2(30);
73  l_bill_to_address_id           NUMBER;
74  l_bill_to_site_use_id          NUMBER;
75  l_bill_to_customer_id          NUMBER;
76  l_bill_to_postal_code          VARCHAR2(60);
77  l_internal_org_location_id        NUMBER;
78  l_bill_to_customer_name        VARCHAR2(360);
79  l_bill_to_customer_number      VARCHAR2(30);
80  l_header_id			oe_order_headers.header_id%type;
81  l_tax_date			oe_order_lines.tax_date%type;
82  l_ordered_quantity		oe_order_lines.ordered_quantity%type;
83  l_unit_selling_price		oe_order_lines.unit_selling_price%type;
84  l_tax_exempt_number		oe_order_lines.tax_exempt_number%type;
85  l_tax_exempt_reason		oe_order_lines.tax_exempt_reason_code%type;
86  l_inventory_item_id		oe_order_lines.inventory_item_id%type;
87  l_ship_from_org_id		oe_order_lines.ship_from_org_id%type;
88  l_ship_from_location_id        NUMBER;
89  l_fob_point_code		oe_order_lines.fob_point_code%type;
90  l_ship_to_org_id		oe_order_lines.ship_to_org_id%type;
91  l_invoice_to_org_id		oe_order_lines.invoice_to_org_id%type;
92  l_application_id               NUMBER;
93  l_entity_code_crsr	        zx_detail_tax_lines_gt.entity_code%TYPE;
94  l_event_class_code_crsr	zx_detail_tax_lines_gt.event_class_code%TYPE ;
95  l_trx_level_type_crsr	        zx_detail_tax_lines_gt.trx_level_type%TYPE;
96  l_line_id                      NUMBER;
97  l_line_rec                     OE_Order_PUB.Line_Rec_Type;
98  l_inventory_org_id 	        NUMBER;
99  l_currency_code  	        VARCHAR2(30);
100  l_tax_code                     VARCHAR2(50);
101  l_header_org_id  	        NUMBER;
102  l_conversion_rate 	        NUMBER;
103  l_precision                    fnd_currencies.precision%type;
104  l_minimum_accountable_unit     fnd_currencies.minimum_accountable_unit%type;
105  l_commitment_id                oe_order_lines.commitment_id%type;
106  l_cust_trx_type_id             ra_cust_trx_types_all.cust_Trx_type_id%type;
107  l_AR_Sys_Param_Rec             ar_system_parameters_all%ROWTYPE;
108  l_product_type			zx_product_types_def_v.classification_code%TYPE;
109  --x_otoc_le_info_rec   		XLE_BUSINESSINFO_GRP.otoc_le_rec;
110  l_legal_entity_id    		NUMBER(15);
111  l_customer_type      		VARCHAR2(30);
112  l_customer_id        		NUMBER;
113  l_batch_source_id		NUMBER;
114  l_sold_to_customer_id		NUMBER;
115  l_invoice_number_profile	VARCHAR2(30);
116  l_bill_from_location_id        NUMBER;
117 
118 
119  cursor getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
120  SELECT /* MOAC_SQL_CHANGE */ s_ship.site_use_id,
121        s_ship.cust_acct_site_id,
122        acct_site_ship.cust_account_id,
123        loc_ship.postal_code,
124        party.party_name,
125        cust_acct.account_number,
126        party.party_id,
127        party_site_ship.party_site_id,
128        loc_ship.location_id
129  FROM
130        HZ_CUST_SITE_USES           S_SHIP ,
131        HZ_CUST_ACCT_SITES_ALL      ACCT_SITE_SHIP,
132        HZ_PARTY_SITES              PARTY_SITE_SHIP,
133        HZ_LOCATIONS                LOC_SHIP,
134        HZ_PARTIES                  PARTY,
135        HZ_CUST_ACCOUNTS_ALL        CUST_ACCT
136 WHERE  s_ship.site_use_id = p_site_org_id
137   AND  s_ship.cust_acct_site_id  = acct_site_ship.cust_acct_site_id
138   and  acct_site_ship.cust_account_id = cust_acct.cust_account_id
139   and  cust_acct.party_id = party.party_id
140   and  acct_site_ship.party_site_id = party_site_ship.party_site_id
141   and  party_site_ship.location_id = loc_ship.location_id;
142 
143  /*
144   CURSOR oeorderline IS
145   SELECT
146   oe_order_lines.header_id,
147   oe_order_lines.tax_date,
148   oe_order_lines.pricing_quantity,
149   oe_order_lines.unit_selling_price,
150   oe_order_lines.tax_exempt_number,
151   oe_order_lines.tax_exempt_reason_code,
152   oe_order_lines.inventory_item_id,
153   oe_order_lines.ship_from_org_id,
154   oe_order_lines.fob_point_code,
155   oe_order_lines.tax_code,
156   NVL(oe_order_lines.actual_shipment_date, oe_order_lines.schedule_ship_date),
157   DECODE(	oe_order_lines.global_attribute_category,
158   	'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
159   	'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
160   	'JL.CO.OEXOEORD.LINES', oe_order_lines.global_attribute6,NULL) ,
161   Decode(oe_order_lines.global_attribute_category,
162   	'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
163   	'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
164   	'JL.CO.OEXOEORD.LINES',oe_order_lines.global_attribute5,NULL) ,
165   NVL(oe_order_lines.pricing_quantity_uom, oe_order_lines.order_quantity_uom) ,
166   DECODE(oe_order_lines.user_item_description, NULL, 'MEMO', 'SERVICE'),
167   oe_order_lines.line_number ,
168   oe_order_lines.user_item_description
169   FROM 	oe_order_lines, oe_system_parameters
170   WHERE	oe_order_lines.org_id = oe_system_parameters.org_id
171   --AND	header_id = p_header_id
172   AND	line_id = p_line_rec.line_id;
173  */
174 
175  CURSOR get_internal_loc(p_organization_id number) IS
176  select location_id
177  from   hr_organization_units
178  where  organization_id = p_organization_id;
179 
180 
181  CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type,
182 			    p_line_id oe_order_lines.line_id%type)
183   is
184   select * from
185   ZX_DETAIL_TAX_LINES_GT
186   where
187   application_id = l_application_id
188   and entity_code = l_entity_code_crsr 		 --'OE_ORDER_HEADERS'
189   and event_class_code = l_event_class_code_crsr --'SALES_TRANSACTION_TAX_QUOTE'
190   and trx_id =  p_header_id
191   and trx_line_id = p_line_id
192   and trx_level_type = l_trx_level_type_crsr;	 --'LINE';
193 
194 
195  detail_tax_lines_gt_rec detail_tax_lines_gt%rowtype;
196  l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
197  l_transaction_rec zx_api_pub.transaction_rec_type;
198  l_doc_level_recalc_flag varchar2(30);
199  l_trx_date DATE;
200  L_POO_PARTY_ID    NUMBER;
201  l_POO_LOCATION_ID  NUMBER;
202 BEGIN
203 
204     IF G_DEBUG_BYPASS_TAX = 'Y' THEN
205       l_return_status         := FND_API.G_RET_STS_SUCCESS;
206       return;
207     END IF;
208 
209     l_line_rec              := p_line_rec;
210     l_return_status         := FND_API.G_RET_STS_SUCCESS;
211     l_entity_code_crsr	    := 'OE_ORDER_HEADERS';
212     l_event_class_code_crsr := 'SALES_TRANSACTION_TAX_QUOTE';
213     l_trx_level_type_crsr   := 'LINE';
214     l_line_id               := l_line_rec.line_id;
215     l_call_tax              := 'N';
216     l_tax_value             := 0;
217     l_application_id        := 660;
218 
219     IF l_debug_level > 0 THEN
220 
221 	 oe_debug_pub.add('entering tax_line:'||l_line_id , 1);
222 	 oe_debug_pub.add('tax_line 1' , 1);
223     END IF;
224 
225     -- Get Header Information
226 /*
227     oe_order_cache.load_order_header(l_line_rec.header_id);
228     l_currency_code := oe_order_cache.g_header_rec.transactional_curr_code;
229     l_header_org_id := oe_order_cache.g_header_rec.org_id;
230     l_conversion_rate := oe_order_cache.g_header_rec.conversion_rate;
231     l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',oe_order_cache.g_header_rec.org_id);
232 */
233 
234     l_currency_code := p_header_rec.transactional_curr_code;
235     l_header_org_id := p_header_rec.org_id;
236     l_conversion_rate := p_header_rec.conversion_rate;
237     l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',p_header_rec.org_id);
238 
239 
240      select    c.minimum_accountable_unit,
241                c.precision
242      into      l_minimum_accountable_unit,
243                l_precision
244      from      fnd_currencies c
245      where     c.currency_code = l_currency_code;
246 
247      l_AR_Sys_Param_Rec          := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
248 
249      --code changes made for bug 1883552  begin
250      l_commitment_id := nvl(l_line_rec.commitment_id,0);
251      if l_commitment_id <> 0 then
252 
253 
254           IF l_debug_level > 0 THEN
255             oe_debug_pub.add('Commitment id is:'||l_commitment_id,4);
256           END IF;
257 
258           begin
259 
260            select /* MOAC_SQL_CHANGE */ nvl(cust_type.subsequent_trx_type_id, cust_type.cust_trx_type_id)
261            into l_cust_trx_type_id
262            from ra_cust_trx_types_all cust_type,
263                 ra_customer_trx cust_trx
264            where
265                 cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
266            and  cust_type.org_id = cust_trx.org_id
267            and  cust_trx.customer_trx_id = l_commitment_id;
268 
269           exception
270              when others then
271 
272              IF l_debug_level > 0 THEN
273                oe_debug_pub.add('In commitment exception ',4);
274              END IF;
275              null;
276           end;
277 
278         IF l_debug_level > 0 THEN
279           oe_debug_pub.add('cust trx type from commitment:'||l_cust_Trx_type_id,4);
280         END IF;
281      else
282 
283        IF l_debug_level > 0 THEN
284          oe_debug_pub.add('In else part of commitment id',4);
285        END IF;
286        l_cust_trx_type_id :=    OE_INVOICE_PUB.Get_Customer_Transaction_Type(p_line_rec);
287      end if;
288      --code changes made for bug 1883552  end
289 
290     IF l_debug_level > 0 THEN
291      oe_debug_pub.add('Customer trx type id is:'||l_cust_trx_type_id,4);
292     END IF;
293 
294     l_ship_to_org_id := l_line_rec.ship_to_org_id ;
295     l_invoice_to_org_id := l_line_rec.invoice_to_org_id;
296 
297     IF l_ship_to_org_id is not null THEN
298 
299 	pr_index := l_ship_to_org_id;
300 	BEGIN
301 
302          IF l_debug_level > 0 THEN
303 	  oe_debug_pub.add('om_tax_line  3' , 4);
304 	 END IF;
305 
306 	 IF ship_bill_records_tab.exists(pr_index) THEN
307 
308 	   IF l_debug_level > 0 THEN
309 	      oe_debug_pub.add('om_tax_line  3.5' , 4);
310 	   END IF;
311 
312 	   l_ship_to_site_use_id :=          ship_bill_records_tab(pr_index).site_use_id;
313 	   l_ship_to_address_id  :=          ship_bill_records_tab(pr_index).acct_site_id;
314 	   l_ship_to_customer_id  :=         ship_bill_records_tab(pr_index).cust_acct_id;
315 	   l_ship_to_postal_code  :=         ship_bill_records_tab(pr_index).postal_code;
316 	   l_ship_to_customer_name  :=       ship_bill_records_tab(pr_index).customer_name;
317 	   l_ship_to_customer_number  :=     ship_bill_records_tab(pr_index).customer_number;
318 	   l_ship_party_id  :=               ship_bill_records_tab(pr_index).party_id;
319 	   l_ship_party_site_id  :=          ship_bill_records_tab(pr_index).party_site_id;
320 	   l_ship_location_id :=             ship_bill_records_tab(pr_index).location_id;
321 
322 	 ELSE
323 	   OPEN getlocinfo(l_ship_to_org_id);
324 
325 	   IF l_debug_level > 0 THEN
326 	        oe_debug_pub.add('om_tax_line  4' , 4);
327 	   END IF;
328 
329            FETCH getlocinfo
330            INTO l_ship_to_site_use_id,
331                 l_ship_to_address_id,
332                 l_ship_to_customer_id,
333                 l_ship_to_postal_code,
334                 l_ship_to_customer_name,
335                 l_ship_to_customer_number,
336 	        l_ship_party_id,
337 	        l_ship_party_site_id,
338 	        l_ship_location_id;
339 
340 
341 	    ship_bill_records_tab(pr_index).site_use_id  :=               l_ship_to_site_use_id;
342 	    ship_bill_records_tab(pr_index).acct_site_id  :=              l_ship_to_address_id;
343 	    ship_bill_records_tab(pr_index).cust_acct_id  :=              l_ship_to_customer_id;
344 	    ship_bill_records_tab(pr_index).postal_code  :=               l_ship_to_postal_code;
345 	    ship_bill_records_tab(pr_index).customer_name  :=             l_ship_to_customer_name;
346 	    ship_bill_records_tab(pr_index).customer_number  :=           l_ship_to_customer_number;
347 	    ship_bill_records_tab(pr_index).party_id  :=                  l_ship_party_id;
348 	    ship_bill_records_tab(pr_index).party_site_id  :=             l_ship_party_site_id;
349 	    ship_bill_records_tab(pr_index).location_id  :=               l_ship_location_id;
350 
351 
352 	   IF l_debug_level > 0 THEN
353 	    oe_debug_pub.add('om_tax_line  5' , 4);
354 	   END IF;
355            close getlocinfo;
356 
357           END IF;
358 
359        EXCEPTION
360             when no_data_found then
361 		 IF l_debug_level > 0 THEN
362 		   oe_debug_pub.add('om_tax_line  6' , 1);
363 		 END IF;
364 
365                  NULL;
366                  close getlocinfo;
367        END;
368     END IF;
369 
370     IF l_invoice_to_org_id is not null THEN
371 
372        pr_index := l_invoice_to_org_id;
373        BEGIN
374          IF l_debug_level > 0 THEN
375 	    oe_debug_pub.add('om_tax_line  7' , 4);
376 	 END IF;
377 
378 
379 	 IF ship_bill_records_tab.exists(pr_index) THEN
380 
381 	    IF l_debug_level > 0 THEN
382 	        oe_debug_pub.add('om_tax_line  7.5' , 4);
383 	    END IF;
384 
385 	   l_bill_to_site_use_id :=          ship_bill_records_tab(pr_index).site_use_id;
386 	   l_bill_to_address_id  :=          ship_bill_records_tab(pr_index).acct_site_id;
387 	   l_bill_to_customer_id  :=         ship_bill_records_tab(pr_index).cust_acct_id;
388 	   l_bill_to_postal_code  :=         ship_bill_records_tab(pr_index).postal_code;
389 	   l_bill_to_customer_name  :=       ship_bill_records_tab(pr_index).customer_name;
390 	   l_bill_to_customer_number  :=     ship_bill_records_tab(pr_index).customer_number;
391 	   l_bill_party_id  :=               ship_bill_records_tab(pr_index).party_id;
392 	   l_bill_party_site_id  :=          ship_bill_records_tab(pr_index).party_site_id;
393 	   l_bill_location_id :=             ship_bill_records_tab(pr_index).location_id;
394 
395 	 ELSE
396 
397              OPEN getlocinfo(l_invoice_to_org_id);
398              IF l_debug_level > 0 THEN
399 	          oe_debug_pub.add('om_tax_line  8' , 4);
400 	     END IF;
401 
402               FETCH getlocinfo
403               INTO l_bill_to_site_use_id,
404                    l_bill_to_address_id,
405                    l_bill_to_customer_id,
406                    l_bill_to_postal_code,
407                    l_bill_to_customer_name,
408                    l_bill_to_customer_number,
409 	           l_bill_party_id,
410 	           l_bill_party_site_id,
411 	           l_bill_location_id;
412               IF l_debug_level > 0 THEN
413                  oe_debug_pub.add('om_tax_line  9' , 4);
414               END IF;
415 
416             ship_bill_records_tab(pr_index).site_use_id  :=      l_bill_to_site_use_id;
417 	    ship_bill_records_tab(pr_index).acct_site_id  :=     l_bill_to_address_id;
418 	    ship_bill_records_tab(pr_index).cust_acct_id  :=     l_bill_to_customer_id;
419 	    ship_bill_records_tab(pr_index).postal_code  :=      l_bill_to_postal_code;
420 	    ship_bill_records_tab(pr_index).customer_name  :=    l_bill_to_customer_name;
421 	    ship_bill_records_tab(pr_index).customer_number  :=  l_bill_to_customer_number;
422 	    ship_bill_records_tab(pr_index).party_id  :=         l_bill_party_id;
423 	    ship_bill_records_tab(pr_index).party_site_id  :=    l_bill_party_site_id;
424 	    ship_bill_records_tab(pr_index).location_id  :=      l_bill_location_id;
425 
426             close getlocinfo;
427 
428          END IF;
429 
430        EXCEPTION
431            when no_data_found then
432             IF l_debug_level > 0 THEN
433             	oe_debug_pub.add('om_tax_line  10' , 1);
434             END IF;
435             close getlocinfo;
436        END;
437     END IF;
438 
439      open get_internal_loc(p_header_Rec.org_id );
440      fetch get_internal_loc into l_internal_org_location_id;
441      close get_internal_loc;
442 
443 
444     BEGIN
445        -- assign values from l_line_rec
446        l_header_id          := l_line_rec.header_id;
447        l_tax_date           := l_line_rec.tax_date;
448        l_ordered_quantity   := l_line_rec.ordered_quantity;
449        l_unit_selling_price := l_line_rec.unit_selling_price;
450        l_tax_exempt_number  := l_line_rec.tax_exempt_number;
451        l_tax_exempt_reason  := l_line_rec.tax_exempt_reason_code;
452        l_inventory_item_id  := l_line_rec.inventory_item_id;
453        l_ship_from_org_id   := l_line_rec.ship_from_org_id;
454        l_fob_point_code     := l_line_rec.fob_point_code;
455        l_tax_code           := l_line_rec.tax_code;
456        l_trx_shipping_date  := NVL(l_line_rec.actual_shipment_date, l_line_rec.schedule_ship_date);
457        l_uom_code           := NVL(l_line_rec.order_quantity_uom, l_line_rec.pricing_quantity_uom);
458        -- l_product_code      := l_line_rec.user_item_description;  -- this should be mtl_system_items_b.segment1
459        l_trx_line_number    := l_line_rec.line_number;
460        l_user_item_description := l_line_rec.user_item_description;
461        IF l_line_rec.global_attribute_category in
462           ('JL.AR.OEXOEORD.LINES',
463            'JL.BR.OEXOEORD.LINES',
464            'JL.CO.OEXOEORD.LINES')
465        THEN
466            l_trx_business_category := l_line_rec.global_attribute6;
467        ELSE
468            l_trx_business_category := NULL;
469        END IF;
470 
471        IF l_line_rec.global_attribute_category in
472           ('JL.AR.OEXOEORD.LINES',
473            'JL.BR.OEXOEORD.LINES',
474            'JL.CO.OEXOEORD.LINES')
475        THEN
476            l_product_fisc_classification := l_line_rec.global_attribute5;
477        ELSE
478            l_product_fisc_classification := NULL;
479        END IF;
480 
481     END;
482 
483       IF l_debug_level > 0 THEN
484        oe_debug_pub.add('trx business:'||l_trx_business_category,3);
485      END IF;
486     /* per bug 5193035:OM should not pass product_type, otherwise other product category etc won't default*/
487    l_product_type := NULL;
488    /*
489     BEGIN
490       -- for getting product_type
491       SELECT classification_code
492         INTO l_product_type
493         FROM zx_product_types_def_v
494        WHERE org_id = l_inventory_org_id
495          AND inventory_item_id = l_line_rec.inventory_item_id;
496      IF l_debug_level > 0 THEN
497        oe_debug_pub.add('product type:'||l_product_type,3);
498      END IF;
499     EXCEPTION
500      WHEN OTHERS THEN
501       NULL;
502     END;
503     */
504     -- bug 4622791
505     IF (l_ship_from_org_id IS NOT NULL
506        AND l_ship_from_org_id <> FND_API.G_MISS_NUM)
507     THEN
508       BEGIN
509         SELECT location_id
510         INTO l_ship_from_location_id
511         FROM hr_all_organization_units hu
512         WHERE hu.organization_id = l_ship_from_org_id;
513       EXCEPTION
514        WHEN OTHERS THEN
515          NULL;
516       END;
517     END IF;
518 
519     -- bug 5061910: pass l_poo_party_id poa_party_id
520     IF l_line_rec.salesrep_id IS NOT NULL THEN
521 
522      IF NOT (OE_GLOBALS.Equal(l_line_rec.salesrep_id, G_SALESREP_ID) AND
523              OE_Globals.Equal(l_header_org_id, G_SALESREP_POA_ID)) THEN
524          -- fetch and cache salerep info
525       BEGIN
526 
527        G_SALESREP_ID := l_line_rec.salesrep_id;
528        G_SALESREP_POA_ID := l_header_org_id;
529 
530        IF l_debug_level > 0 then
531         oe_debug_pub.add('om_tax_line, need to query  poo for salesrep'||l_line_rec.salesrep_id , 4);
532        END IF;
533 
534          SELECT ASGN.ORGANIZATION_ID
535             , hou.location_id
536          INTO l_poo_party_id
537            , l_poo_location_id
538          FROM  RA_SALESREPS_ALL sales
539             ,  PER_ALL_ASSIGNMENTS_F ASGN
540             , hr_organization_units hou
541          WHERE ASGN.PERSON_ID = sales.PERSON_ID
542          AND sales.salesrep_id = l_line_rec.salesrep_id
543          AND sales.org_id = l_header_org_id
544          AND  NVL(ASGN.PRIMARY_FLAG, 'Y') = 'Y'
545          AND hou.organization_id = ASGN.ORGANIZATION_ID
546          AND    l_TAX_DATE
547             BETWEEN nvl(ASGN.EFFECTIVE_START_DATE,TO_DATE( '01011900'
548              , 'DDMMYYYY'))
549             AND nvl(ASGN.EFFECTIVE_END_DATE,TO_DATE( '31122199', 'DDMMYYYY'))
550          AND ASSIGNMENT_TYPE = 'E';
551 
552        G_POO_PARTY_ID := l_poo_party_id;
553        G_POO_LOCATION_ID := l_poo_location_id;
554 
555       EXCEPTION
556 
557         WHEN NO_DATA_FOUND THEN
558           IF l_debug_level > 0 then
559            oe_debug_pub.add('om_tax_line  9' , 1);
560           END IF;
561 
562               G_POO_PARTY_ID := NULL;
563               G_POO_LOCATION_ID := NULL;
564       END;
565     ELSE -- get cached values
566 
567        IF l_debug_level > 0 then
568         oe_debug_pub.add('om_tax_line  getting poo from cache for salesrep:'||l_line_rec.salesrep_id , 4);
569        END IF;
570 
571        l_poo_party_id := G_POO_PARTY_ID;
572        l_poo_location_id := G_POO_LOCATION_ID;
573 
574     END IF; -- if cached
575 
576   END IF; -- if p_salerep_id is not null
577 
578 --bug7228640
579 begin
580 	select location_id
581 	into l_bill_from_location_id
582 	from HR_ALL_ORGANIZATION_UNITS
583 	where organization_id = p_header_rec.org_id ;
584 Exception
585 	when others then
586 	l_bill_from_location_id := NULL;
587 End;
588 
589 
590 IF l_debug_level > 0 then
591  oe_debug_pub.add('om_tax_line  13' , 4);
592  oe_debug_pub.add('l_poo_party_id: '|| l_poo_party_id , 4);
593 END IF;
594 
595     l_legal_entity_id := get_le_id(p_order_type_id => p_header_rec.order_type_id
596                                  , p_sold_to_customer_id => p_header_rec.sold_to_org_id
597                                  , p_bill_to_customer_id => l_bill_to_customer_id
598                                  , p_org_id         => p_header_rec.org_id
599                                   );
600 
601     if l_legal_entity_id = -1 THEN
602         RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603     END IF;
604 
605        i:= 1;
606        zx_global_structures_pkg.init_trx_line_dist_tbl(i);
607        zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID(i)	:= 660;
608        zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE(i)	:= 'OE_ORDER_HEADERS';
609        zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE(i)	:= 'SALES_TRANSACTION_TAX_QUOTE';
610        zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i)		:= L_HEADER_ID;
611        zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i)	:= 'LINE';
612 
613        zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(i)          := p_header_rec.org_id;
614        zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE(i)                   := 'CREATE';
615        -- bug 4700796
616        IF p_header_rec.transaction_phase_code = 'N' THEN
617          l_trx_date := p_header_rec.quote_date;
618        ELSE
619          l_trx_date := p_header_rec.ordered_date;
620        END IF;
621        zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(i)               := l_trx_date;
622        zx_global_structures_pkg.trx_line_dist_tbl.TRX_DOC_REVISION(i)                  := NULL; --   VARCHAR2_150_tbl_type  ,
623        zx_global_structures_pkg.trx_line_dist_tbl.LEDGER_ID(i)                         := l_AR_Sys_Param_Rec.set_of_books_id;
624        zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(i)                 := p_header_rec.TRANSACTIONAL_CURR_CODE;
625        zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(i)          := p_header_rec.CONVERSION_RATE_DATE;
626        zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(i)          := p_header_rec.CONVERSION_RATE;
627        zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(i)          := p_header_rec.CONVERSION_TYPE_CODE;
628        zx_global_structures_pkg.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(i)          := l_minimum_accountable_unit;
629        zx_global_structures_pkg.trx_line_dist_tbl.PRECISION(i)                         := l_precision;
630    -- revisit the logic to derive legal_entity_id later when legal_entity_id approach is clarified.
631        zx_global_structures_pkg.trx_line_dist_tbl.LEGAL_ENTITY_ID(i)                   := l_legal_entity_id; --   NUMBER_tbl_type        ,
632        zx_global_structures_pkg.trx_line_dist_tbl.ESTABLISHMENT_ID(i)                  := NULL; --   NUMBER_tbl_type        ,
633        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER(i)           := NULL; --   VARCHAR2_150_tbl_type  ,
634        zx_global_structures_pkg.trx_line_dist_tbl.TRX_NUMBER(i)                        := p_header_Rec.order_number;
635        zx_global_structures_pkg.trx_line_dist_tbl.TRX_DESCRIPTION(i)                   := NULL; --   VARCHAR2_240_tbl_type  ,
636        zx_global_structures_pkg.trx_line_dist_tbl.TRX_COMMUNICATED_DATE(i)             := NULL; --   DATE_tbl_type          ,
637        zx_global_structures_pkg.trx_line_dist_tbl.BATCH_SOURCE_ID(i)                   := NULL; --   NUMBER_tbl_type        ,
638        zx_global_structures_pkg.trx_line_dist_tbl.BATCH_SOURCE_NAME(i)                 := NULL; --   VARCHAR2_150_tbl_type  ,
639        zx_global_structures_pkg.trx_line_dist_tbl.DOC_SEQ_ID(i)                        := NULL; --   NUMBER_tbl_type        ,
640        zx_global_structures_pkg.trx_line_dist_tbl.DOC_SEQ_NAME(i)                      := NULL; --   VARCHAR2_150_tbl_type  ,
641        zx_global_structures_pkg.trx_line_dist_tbl.DOC_SEQ_VALUE(i)                     := NULL; --   VARCHAR2_240_tbl_type  ,
642        zx_global_structures_pkg.trx_line_dist_tbl.TRX_DUE_DATE(i)                      := NULL; --   DATE_tbl_type          ,
643        zx_global_structures_pkg.trx_line_dist_tbl.TRX_TYPE_DESCRIPTION(i)              := NULL; --   VARCHAR2_240_tbl_type  ,
644        zx_global_structures_pkg.trx_line_dist_tbl.FIRST_PTY_ORG_ID(i)                  := NULL; --   NUMBER_tbl_type        ,
645        zx_global_structures_pkg.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID(i)           := l_cust_trx_type_id;
646        zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE(i)              := NULL; --   VARCHAR2_30_tbl_type   ,
647        zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_TYPE_CODE(i)               := NULL; --   VARCHAR2_30_tbl_type   ,
648        zx_global_structures_pkg.trx_line_dist_tbl.DOC_EVENT_STATUS(i)                  := NULL; --   VARCHAR2_30_tbl_type   ,
649        zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(i)                 := NULL; --   VARCHAR2_240_tbl_type  ,
650        zx_global_structures_pkg.trx_line_dist_tbl.SUPPLIER_TAX_INVOICE_NUMBER(i)       := NULL; --   VARCHAR2_150_tbl_type  ,
651        zx_global_structures_pkg.trx_line_dist_tbl.SUPPLIER_TAX_INVOICE_DATE(i)         := NULL; --   DATE_tbl_type          ,
652        zx_global_structures_pkg.trx_line_dist_tbl.SUPPLIER_EXCHANGE_RATE(i)            := NULL; --   NUMBER_tbl_type        ,
653        zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE(i)                  := NULL; --   DATE_tbl_type          ,
654        zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER(i)                := NULL; --   VARCHAR2_150_tbl_type  ,
655        zx_global_structures_pkg.trx_line_dist_tbl.QUOTE_FLAG(i)                        := 'Y'; --   VARCHAR2_1_tbl_type   ,
656        zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(i)          := NULL; --   VARCHAR2_2_tbl_type   ,
657        zx_global_structures_pkg.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(i)             := NULL; --   VARCHAR2_1_tbl_type    ,
658        zx_global_structures_pkg.trx_line_dist_tbl.CTRL_TOTAL_HDR_TX_AMT(i)             := NULL; --   NUMBER_tbl_type        ,
659        zx_global_structures_pkg.trx_line_dist_tbl.PORT_OF_ENTRY_CODE(i)                := NULL; --   VARCHAR2_30_tbl_type,
660        zx_global_structures_pkg.trx_line_dist_tbl.TAX_REPORTING_FLAG(i)                := 'N'; --   VARCHAR2_1_tbl_type,
661        zx_global_structures_pkg.trx_line_dist_tbl.TAX_AMT_INCLUDED_FLAG(i)             := NULL; --   VARCHAR2_1_tbl_type ,
662        zx_global_structures_pkg.trx_line_dist_tbl.COMPOUNDING_TAX_FLAG(i)              := NULL; --   VARCHAR2_1_tbl_type,
663        zx_global_structures_pkg.trx_line_dist_tbl.PROVNL_TAX_DETERMINATION_DATE(i)     := NULL; --   DATE_tbl_type,
664        zx_global_structures_pkg.trx_line_dist_tbl.INSERT_UPDATE_FLAG(i)                := NULL; --   VARCHAR2_1_tbl_type,
665        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_NUMBER(i)             := NULL; --   VARCHAR2_150_tbl_type,
666        zx_global_structures_pkg.trx_line_dist_tbl.START_EXPENSE_DATE(i)                := NULL; --   DATE_tbl_type,
667        zx_global_structures_pkg.trx_line_dist_tbl.TRX_BATCH_ID(i)                      := NULL; --   NUMBER_tbl_type,
668        zx_global_structures_pkg.trx_line_dist_tbl.RECORD_TYPE_CODE(i)                  := NULL; --   VARCHAR2_30_tbl_type,
669        zx_global_structures_pkg.trx_line_dist_tbl.TAX_PROCESSING_COMPLETED_FLAG(i)     := NULL; --   VARCHAR2_1_tbl_type,
670        zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_DOC_STATUS(i)            := NULL; --   VARCHAR2_30_tbl_type,
671        zx_global_structures_pkg.trx_line_dist_tbl.OVERRIDING_RECOVERY_RATE(i)          := NULL; --   NUMBER_tbl_type,
672        zx_global_structures_pkg.trx_line_dist_tbl.TAX_CALCULATION_DONE_FLAG(i)         := NULL; --   VARCHAR2_1_tbl_type,
673        zx_global_structures_pkg.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG(i)         := NULL; --   VARCHAR2_1_tbl_type,
674        zx_global_structures_pkg.trx_line_dist_tbl.ICX_SESSION_ID(i)                    := NULL; --   NUMBER_tbl_type
675        -- line level columns
676        --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CODE(i)            := NULL; --   VARCHAR2_15_tbl_type   ,
677        --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_DATE(i)       := NULL; --   DATE_tbl_type          ,
678        --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_RATE(i)       := NULL; --   NUMBER_tbl_type        ,
679        --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_TYPE(i)       := NULL; --   VARCHAR2_30_tbl_type   ,
680        --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_MAU(i)                      := NULL; --   NUMBER_tbl_type        ,
681        --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_PRECISION(i)                := NULL; --   NUMBER_tbl_type        ,
682        zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(i)                 := NULL; --   VARCHAR2_240_tbl_type   ,
683        zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(i)     := NULL; --   VARCHAR2_30_tbl_type   ,
684        zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(i)            := l_line_rec.TAX_EXEMPT_FLAG;
685        zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(i)                := l_line_rec.TAX_EXEMPT_REASON_CODE;
686        zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_ENTITY_CODE(i)             := NULL; --   VARCHAR2_30_tbl_type,
687        zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_LINE_ID(i)                 := NULL; --   NUMBER_tbl_type,
688        zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_TAX_CODE_ID(i)            := NULL; --   NUMBER_tbl_type,
689        zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i)	:= l_line_rec.line_id;
690        zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(i)	        := 'INVOICE';
691        zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(i)	:= 'CREATE';
692        zx_global_structures_pkg.trx_line_dist_tbl.TRX_SHIPPING_DATE(i)	:= l_trx_shipping_date;
693        zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(i)	:= NULL ;
694        zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_TYPE(i)	:= 'LINE';
695        zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i)	:= l_tax_date;
696        zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i)	:= l_trx_business_category;
697        zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(i)	:= NULL;
698        zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS(i)	:= NULL;
699        zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(i)	:= 'S';
700        zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i)	:= l_ordered_quantity*l_unit_selling_price;
701        zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i)	:= l_ordered_quantity;
702        zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i)	:= l_unit_selling_price;
703        zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i)	:= l_tax_exempt_number;
704        zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i)	:= l_tax_exempt_reason;
705        zx_global_structures_pkg.trx_line_dist_tbl.CASH_DISCOUNT(i)	:= NULL;
706        zx_global_structures_pkg.trx_line_dist_tbl.VOLUME_DISCOUNT(i)	:= NULL;
707        zx_global_structures_pkg.trx_line_dist_tbl.TRADING_DISCOUNT(i)	:= NULL;
708        zx_global_structures_pkg.trx_line_dist_tbl.TRANSFER_CHARGE(i)	:= NULL ;
709        zx_global_structures_pkg.trx_line_dist_tbl.TRANSPORTATION_CHARGE(i)	:= NULL;
710        zx_global_structures_pkg.trx_line_dist_tbl.INSURANCE_CHARGE(i)	:= NULL;
711        zx_global_structures_pkg.trx_line_dist_tbl.OTHER_CHARGE(i)	:= NULL;
712        zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i)	:= l_inventory_item_id;
713        zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i):= l_product_fisc_classification;
714        zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i)	:= NVL(l_ship_from_org_id,l_inventory_org_id); --bug7456264
715        zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i)		:= l_uom_code;
716        if l_inventory_item_id is NULL then
717           zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(i)	:= NULL;
718        else
719          -- this should be GOODS/SERVICES based on zx_product_types_def_v.
720          -- to be changed when zx_product_types_def_v is available.
721           zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(i)	:= l_product_type;
722        end if;
723        zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(i)	:= l_product_code;
724        zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(i)	:= NULL;
725        zx_global_structures_pkg.trx_line_dist_tbl.TRX_SIC_CODE(i)	:= NULL ;
726        zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i)		:= l_fob_point_code;
727        zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_ID(i)	:= l_ship_party_id; --1001;
728        zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i):= l_ship_from_org_id; -- Bug 7532302
729        zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_ID(i)	:= l_header_org_id;
730        zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_ID(i)	:= l_poo_party_id;
731        zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_ID(i)	:= l_bill_party_id; --1001;
732        zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_ID(i):= NULL;
733        zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_ID(i)	:= NULL;
734        zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID(i)	:= l_ship_party_site_id;--1024;
735        zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_SITE_ID(i)	:= NULL;
736        zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_SITE_ID(i)	:= NULL ;
737        zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_SITE_ID(i)	:= NULL ;
738        zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_SITE_ID(i)	:= l_bill_party_site_id; --1024;
739        zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_SITE_ID(i)	:= NULL;
740        zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(i)	:= l_ship_location_id;--1067;
741        zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(i)	:= l_ship_from_location_id;
742        zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(i)		:= l_internal_org_location_id;
743        zx_global_structures_pkg.trx_line_dist_tbl.POO_LOCATION_ID(i)		:= l_poo_location_id ;
744        zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(i)	:= l_bill_location_id;--1067;
745        zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(i)	:= l_bill_from_location_id; --bug7228640
746        zx_global_structures_pkg.trx_line_dist_tbl.ACCOUNT_CCID(i)		:= NULL;
747        zx_global_structures_pkg.trx_line_dist_tbl.ACCOUNT_STRING(i)		:= NULL;
748        zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_COUNTRY(i)	:= NULL;
749        zx_global_structures_pkg.trx_line_dist_tbl.ASSET_FLAG(i)		:= NULL;
750        zx_global_structures_pkg.trx_line_dist_tbl.ASSET_NUMBER(i)	:= NULL;
751        zx_global_structures_pkg.trx_line_dist_tbl.ASSET_ACCUM_DEPRECIATION(i)	:= NULL;
752        zx_global_structures_pkg.trx_line_dist_tbl.ASSET_TYPE(i)	:= NULL;
753        zx_global_structures_pkg.trx_line_dist_tbl.ASSET_COST(i)	:= NULL;
754        zx_global_structures_pkg.trx_line_dist_tbl.DIST_LEVEL_ACTION(i)           := NULL; --   VARCHAR2_30_tbl_type   ,
755        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TAX_DIST_ID(i)    := NULL; --   NUMBER_tbl_type        ,
756        zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TAX_DIST_ID(i)    := NULL; --   NUMBER_tbl_type        ,
757        zx_global_structures_pkg.trx_line_dist_tbl.TASK_ID(i)                     := NULL; --   NUMBER_tbl_type        ,
758        zx_global_structures_pkg.trx_line_dist_tbl.AWARD_ID(i)                    := NULL; --   NUMBER_tbl_type        ,
759        zx_global_structures_pkg.trx_line_dist_tbl.PROJECT_ID(i)                  := NULL; --   NUMBER_tbl_type        ,
760        zx_global_structures_pkg.trx_line_dist_tbl.EXPENDITURE_TYPE(i)            := NULL; --   VARCHAR2_30_tbl_type   ,
761        zx_global_structures_pkg.trx_line_dist_tbl.EXPENDITURE_ORGANIZATION_ID(i) := NULL; --   NUMBER_tbl_type        ,
762        zx_global_structures_pkg.trx_line_dist_tbl.EXPENDITURE_ITEM_DATE(i)       := NULL; --   DATE_tbl_type          ,
763        zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_AMT(i)           := NULL; --   NUMBER_tbl_type        ,
764        zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_QUANTITY(i)      := NULL; --   NUMBER_tbl_type        ,
765        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_CURR_CONV_RATE(i)      := NULL; --   NUMBER_tbl_type        ,
766        zx_global_structures_pkg.trx_line_dist_tbl.ITEM_DIST_NUMBER(i)            := NULL; --   NUMBER_tbl_type        ,
767        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_DIST_ID(i)             := NULL; --   NUMBER_tbl_type        ,
768        zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_TAX_AMT(i)       := NULL; --   NUMBER_tbl_type        ,
769 
770        zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE(i)		:= NULL ;
771        zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i)	:= l_tax_code;
772        zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL2(i)	:= NULL;
773        zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL3(i)	:= NULL;
774        zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL4(i)	:= NULL;
775        zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL5(i)	:= NULL;
776        zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL6(i)	:= NULL;
777        zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY1(i)	:= NULL;
778        zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY2(i)	:= NULL;
779        zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY3(i)	:= NULL;
780        zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY4(i)	:= NULL;
781        zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY5(i)	:= NULL;
782        zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY6(i)	:= NULL;
783        zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY1(i):= NULL;
784        zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY2(i):= NULL;
785        zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY3(i):= NULL;
786        zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY4(i):= NULL;
787        zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY5(i):= NULL;
788        zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY6(i):= NULL;
789        zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i)   := l_trx_line_number;
790        zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_ID(i)   := NULL;
791        zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY1(i) := NULL;
792        zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY2(i) := NULL;
793        zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY3(i) := NULL;
794        zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY4(i) := NULL;
795        zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY5(i) := NULL;
796        zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY6(i) := NULL;
797        zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_FLAG(i)	:='N';
798        zx_global_structures_pkg.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(i)	:='N';
799        zx_global_structures_pkg.trx_line_dist_tbl.CTRL_TOTAL_LINE_TX_AMT(i)	:=NULL;
800        zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i)	:= l_user_item_description;
801        zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i)	:= l_user_item_description ;
802        zx_global_structures_pkg.trx_line_dist_tbl.TRX_WAYBILL_NUMBER(i)	:= NULL;
803        zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_GL_DATE(i)		:= NULL;
804        zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_NAME(i)	:= NULL;
805        zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_DOCUMENT_NUMBER(i)	:= NULL;
806        zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_REFERENCE(i)	:= NULL;
807        zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAXPAYER_ID(i):= NULL;
808        zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAX_REG_NUMBER(i)	:= NULL;
809        zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_ID(i)		:= NULL;
810        zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_ID(i)		:= NULL;
811        zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_ID(i)	:= NULL;
812        zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_ID(i)		:= NULL;
813        zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_ID(i)		:= NULL;
814        zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_ID(i)	:= NULL;
815        zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_SITE_ID(i)	:= NULL;
816        zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_SITE_ID(i)	:= NULL;
817        zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_SITE_ID(i)	:= NULL;
818        zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_SITE_ID(i)		:= NULL;
819        zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_SITE_ID(i)		:= NULL;
820        zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_SITE_ID(i)	:= NULL;
821        zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(i)	:= NULL;
822        zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(i)	:= NULL;
823        zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(i)	:= NULL;
824        zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(i)		:= NULL;
825        zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(i)		:= NULL;
826        zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(i)		:= NULL;
827        zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID(i):= NULL;
828        -- Rounding parties not required for OM. No override of rounding level
829        zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_SHIP_TO_PARTY_ID(i)   := NULL;
830        zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_SHIP_FROM_PARTY_ID(i) := NULL;
831        zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_BILL_TO_PARTY_ID(i)   := NULL;
832        zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_BILL_FROM_PARTY_ID(i) := NULL;
833        zx_global_structures_pkg.trx_line_dist_tbl.RNDG_SHIP_TO_PARTY_SITE_ID(i)  := NULL;
834        zx_global_structures_pkg.trx_line_dist_tbl.RNDG_SHIP_FROM_PARTY_SITE_ID(i):= NULL;
835        zx_global_structures_pkg.trx_line_dist_tbl.RNDG_BILL_TO_PARTY_SITE_ID(i)  := NULL;
836        zx_global_structures_pkg.trx_line_dist_tbl.RNDG_BILL_FROM_PARTY_SITE_ID(i):= NULL;
837 
838        -- Ref_doc, applied_from, applied_to, related_doc are not applicable for OM
839        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_APPLICATION_ID(i)	:= NULL;
840        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_ENTITY_CODE(i)	:= NULL;
841        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_EVENT_CLASS_CODE(i)	:= NULL;
842        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_TRX_ID(i)		:= NULL;
843        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY1(i)	:= NULL;
844        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY2(i)	:= NULL;
845        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY3(i)	:= NULL;
846        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY4(i)	:= NULL;
847        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY5(i)	:= NULL;
848        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY6(i)	:= NULL;
849        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LINE_ID(i)		:= NULL;
850        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY1(i)	:= NULL;
851        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY2(i)	:= NULL;
852        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY3(i)	:= NULL;
853        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY4(i)	:= NULL;
854        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY5(i)	:= NULL;
855        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY6(i)	:= NULL;
856        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LINE_QUANTITY(i)	:= NULL;
857        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_APPLICATION_ID(i):= NULL;
858        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_ENTITY_CODE(i)	:= NULL;
859        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_EVENT_CLASS_CODE(i) := NULL;
860        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_ID(i)	:= NULL;
861        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY1(i):= NULL;
862        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY2(i):= NULL;
863        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY3(i):= NULL;
864        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY4(i):= NULL;
865        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY5(i):= NULL;
866        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY6(i):= NULL;
867        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_LINE_ID(i)	:= NULL;
868        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY1(i):= NULL;
869        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY2(i):= NULL;
870        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY3(i):= NULL;
871        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY4(i):= NULL;
872        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY5(i):= NULL;
873        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY6(i):= NULL;
874        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_DIST_ID(i)      := NULL;
875        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY1(i) := NULL;
876        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY2(i) := NULL;
877        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY3(i) := NULL;
878        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY4(i) := NULL;
879        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY5(i) := NULL;
880        zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY6(i) := NULL;
881        zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_APPLICATION_ID(i)	:= NULL;
882        zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_ENTITY_CODE(i)	:= NULL;
883        zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE(i)	:= NULL;
884        zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TRX_ID(i)	:= NULL ;
885        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY1(i)	:= NULL;
886        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY2(i)	:= NULL;
887        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY3(i)	:= NULL;
888        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY4(i)	:= NULL;
889        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY5(i)	:= NULL;
890        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY6(i)	:= NULL;
891        zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_LINE_ID(i)	:= NULL;
892        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY1(i)	:= NULL;
893        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY2(i)	:= NULL;
894        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY3(i)	:= NULL;
895        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY4(i)	:= NULL;
896        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY5(i)	:= NULL;
897        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY6(i)	:= NULL;
898        zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_DIST_ID(i)       := NULL;
899        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY1(i)  := NULL;
900        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY2(i)  := NULL;
901        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY3(i)  := NULL;
902        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY4(i)  := NULL;
903        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY5(i)  := NULL;
904        zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY6(i)     := NULL;
905        zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_NUMBER(i)	:= NULL;
906        zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_DATE(i)		:= NULL;
907        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_APPLICATION_ID(i)	:= NULL;
908        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_ENTITY_CODE(i)	:= NULL;
909        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_EVENT_CLASS_CODE(i):= NULL;
910        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_ID(i)		:= NULL;
911        zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY1(i)	:= NULL;
912        zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY2(i)	:= NULL;
913        zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY3(i)	:= NULL;
914        zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY4(i)	:= NULL;
915        zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY5(i)	:= NULL;
916        zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY6(i)	:= NULL;
917        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_LINE_ID(i)	:= NULL;
918        zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY1(i)	:= NULL;
919        zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY2(i)	:= NULL;
920        zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY3(i)	:= NULL;
921        zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY4(i)	:= NULL;
922        zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY5(i)	:= NULL;
923        zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY6(i)	:= NULL;
924        zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_APPLICATION_ID(i)  := NULL;
925        zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_ENTITY_CODE(i)     := NULL;
926        zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_EVENT_CLASS_CODE(i):= NULL;
927        zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_TRX_ID(i)          := NULL;
928        zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY1(i)   := NULL;
929        zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY2(i)   := NULL;
930        zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY3(i)   := NULL;
931        zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY4(i)   := NULL;
932        zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY5(i)   := NULL;
933        zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY6(i)   := NULL;
934        zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_NUMBER(i)          := NULL;
935        zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_DATE(i)            := NULL;
936        zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_APPLN_ID(i)           := NULL;
937        zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_ENTITY_CODE(i)        := NULL;
938        zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_EVNT_CLS_CODE(i)      := NULL;
939        zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_TRX_ID(i)             := NULL;
940        zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_TRX_LEVEL_TYPE(i)     := NULL;
941        zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_TRX_LINE_ID(i)        := NULL;
942 
943        zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC1(i)	:= NULL;
944        zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC2(i)	:= NULL;
945        zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC3(i)	:= NULL;
946        zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC4(i)	:= NULL;
947        zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC5(i)	:= NULL;
948        zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC6(i)	:= NULL;
949        zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC7(i)	:= NULL;
950        zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC8(i)	:= NULL;
951        zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC9(i)	:= NULL;
952        zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC10(i)	:= NULL;
953        zx_global_structures_pkg.trx_line_dist_tbl.CHAR1(i)	:= NULL;
954        zx_global_structures_pkg.trx_line_dist_tbl.CHAR2(i)	:= NULL;
955        zx_global_structures_pkg.trx_line_dist_tbl.CHAR3(i)	:= NULL;
956        zx_global_structures_pkg.trx_line_dist_tbl.CHAR4(i)	:= NULL;
957        zx_global_structures_pkg.trx_line_dist_tbl.CHAR5(i)	:= NULL;
958        zx_global_structures_pkg.trx_line_dist_tbl.CHAR6(i)	:= NULL;
959        zx_global_structures_pkg.trx_line_dist_tbl.CHAR7(i)	:= NULL;
960        zx_global_structures_pkg.trx_line_dist_tbl.CHAR8(i)	:= NULL;
961        zx_global_structures_pkg.trx_line_dist_tbl.CHAR9(i)	:= NULL;
962        zx_global_structures_pkg.trx_line_dist_tbl.CHAR10(i)	:= NULL;
963        zx_global_structures_pkg.trx_line_dist_tbl.DATE1(i)	:= NULL;
964        zx_global_structures_pkg.trx_line_dist_tbl.DATE2(i)	:= NULL;
965        zx_global_structures_pkg.trx_line_dist_tbl.DATE3(i)	:= NULL;
966        zx_global_structures_pkg.trx_line_dist_tbl.DATE4(i)	:= NULL;
967        zx_global_structures_pkg.trx_line_dist_tbl.DATE5(i)	:= NULL;
968        zx_global_structures_pkg.trx_line_dist_tbl.DATE6(i)	:= NULL;
969        zx_global_structures_pkg.trx_line_dist_tbl.DATE7(i)	:= NULL;
970        zx_global_structures_pkg.trx_line_dist_tbl.DATE8(i)	:= NULL;
971        zx_global_structures_pkg.trx_line_dist_tbl.DATE9(i)	:= NULL;
972        zx_global_structures_pkg.trx_line_dist_tbl.DATE10(i)	:= NULL;
973        zx_global_structures_pkg.trx_line_dist_tbl.internal_org_location_id(i) := l_internal_org_location_id;
974      /*
975        zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_TAX_PROF_ID(i)	:= NULL;
976        zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_TAX_PROF_ID(i):= NULL;
977        zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_TAX_PROF_ID(i)	:= NULL;
978        zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_TAX_PROF_ID(i)	:= NULL;
979        zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_TAX_PROF_ID(i)	:= NULL;
980        zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_TAX_PROF_ID(i)	:= NULL;
981        zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_TAX_PROF_ID(i)	:= NULL;
982        zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_TAX_PROF_ID(i)	:= NULL;
983        zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_TAX_PROF_ID(i)	:= NULL;
984        zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_TAX_PROF_ID(i)	:= NULL;
985        zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_TAX_PROF_ID(i)	:= NULL;
986        zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANS_PARTY_TAX_PROF_ID(i)	:= NULL;
987        zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_SITE_TAX_PROF_ID(i)	:= NULL;
988        zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_SITE_TAX_PROF_ID(i)	:= NULL;
989        zx_global_structures_pkg.trx_line_dist_tbl.POA_SITE_TAX_PROF_ID(i)	:= NULL;
990        zx_global_structures_pkg.trx_line_dist_tbl.POO_SITE_TAX_PROF_ID(i)	:= NULL;
991        zx_global_structures_pkg.trx_line_dist_tbl.PAYING_SITE_TAX_PROF_ID(i)	:= NULL;
992        zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_SITE_TAX_PROF_ID(i)	:= NULL;
993        zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_SITE_TAX_PROF_ID(i):= NULL;
994        zx_global_structures_pkg.trx_line_dist_tbl.POI_SITE_TAX_PROF_ID(i)	:= NULL;
995        zx_global_structures_pkg.trx_line_dist_tbl.POD_SITE_TAX_PROF_ID(i)	:= NULL;
996        zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_SITE_TAX_PROF_ID(i)	:= NULL;
997        zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_SITE_TAX_PROF_ID(i):= NULL;
998        zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANS_SITE_TAX_PROF_ID(i)	:= NULL;
999        zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAX_PROF_ID(i):= NULL;
1000        zx_global_structures_pkg.trx_line_dist_tbl.RDNG_SHIP_TO_PTY_TX_PROF_ID(i)    := NULL;
1001        zx_global_structures_pkg.trx_line_dist_tbl.RDNG_SHIP_FROM_PTY_TX_PROF_ID(i)  := NULL;
1002        zx_global_structures_pkg.trx_line_dist_tbl.RDNG_BILL_TO_PTY_TX_PROF_ID(i)    := NULL;
1003        zx_global_structures_pkg.trx_line_dist_tbl.RDNG_BILL_FROM_PTY_TX_PROF_ID(i)  := NULL;
1004        zx_global_structures_pkg.trx_line_dist_tbl.RDNG_SHIP_TO_PTY_TX_P_ST_ID(i)    := NULL;
1005        zx_global_structures_pkg.trx_line_dist_tbl.RDNG_SHIP_FROM_PTY_TX_P_ST_ID(i)  := NULL;
1006        zx_global_structures_pkg.trx_line_dist_tbl.RDNG_BILL_TO_PTY_TX_P_ST_ID(i)    := NULL;
1007        zx_global_structures_pkg.trx_line_dist_tbl.RDNG_BILL_FROM_PTY_TX_P_ST_ID(i)  := NULL;
1008        zx_global_structures_pkg.trx_line_dist_tbl.HQ_ESTB_PARTY_TAX_PROF_ID(i)      := NULL;
1009 
1010      */
1011        zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_APPLICATION_ID(i)	:= NULL;
1012        zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_ENTITY_CODE(i)	:= NULL;
1013        zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_EVENT_CLASS_CODE(i)	:= NULL;
1014        zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TRX_ID(i)		:= NULL;
1015        zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_LINE_ID(i)		:= NULL;
1016        zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TRX_LEVEL_TYPE(i)	:= NULL;
1017        zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_TRX_LEVEL_TYPE(i)	:= NULL;
1018        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_LEVEL_TYPE(i)	:= NULL;
1019        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_LEVEL_TYPE(i):= NULL;
1020        zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TRX_LEVEL_TYPE(i):= NULL;
1021        zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE1(i)	:= 'N';
1022        zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE2(i)	:= NULL;
1023        zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE3(i)	:= NULL;
1024        zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE4(i)	:= NULL;
1025        zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE5(i)	:= NULL;
1026        zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE6(i)	:= NULL;
1027        zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE7(i)	:= NULL;
1028        zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE8(i)	:= NULL;
1029        zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE9(i)	:= NULL;
1030        zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE10(i)	:= NULL;
1031        zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TAX_LINE_ID(i)	:= NULL;
1032        zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER(i)	:= NULL;
1033 
1034 	zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(i)	:= l_SHIP_TO_ADDRESS_ID;--1024;
1035 	zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID(i)	:= l_BILL_TO_ADDRESS_ID;--1024;
1036 	zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i)	:= l_SHIP_TO_SITE_USE_ID;--1007;
1037 	zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i)	:= l_BILL_TO_SITE_USE_ID;--1006;
1038 	zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(i)		:= l_SHIP_TO_CUSTOMER_ID;--1001;
1039 	zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID(i)		:= l_BILL_TO_CUSTOMER_ID;--1001;
1040 
1041   IF l_debug_level > 0 THEN
1042     debug_msg(i, x_return_status);
1043  		null;
1044   END IF;
1045 
1046   l_line_rec.tax_value := l_tax_value;
1047 
1048   IF ( NOT ( l_line_rec.header_id is null OR
1049              l_line_rec.inventory_item_id is null OR
1050              --p_ship_to_org_id is null OR   /*commented for the bug#3336052*/
1051              l_line_rec.unit_selling_price is null)
1052            -- OR
1053             -- l_line_rec.tax_code is null)
1054            )
1055   THEN
1056 
1057 
1058     IF l_debug_level > 0 THEN
1059  	oe_debug_pub.add('tax_line 11' , 1);
1060     END IF;
1061 
1062     l_call_tax := 'Y';
1063 
1064       l_transaction_rec.application_id := 660;
1065       l_transaction_rec.entity_code := 'OE_ORDER_HEADERS';
1066       l_transaction_rec.event_class_code := 'SALES_TRANSACTION_TAX_QUOTE';
1067       l_transaction_rec.event_type_code := 'CREATE';
1068       l_transaction_rec.trx_id := l_line_rec.header_id;
1069       l_transaction_rec.internal_organization_id := l_line_rec.org_id;
1070 
1071        zx_api_pub.calculate_tax(
1072                         p_api_version => 1.0,
1073                         p_init_msg_list => FND_API.G_TRUE,
1074                         p_commit           => NULL,
1075                         p_validation_level => NULL,
1076                         x_return_status => l_return_status,
1077                         x_msg_count => l_msg_count,
1078                         x_msg_data => l_msg_data,
1079                         p_transaction_rec => l_transaction_rec,
1080                         p_quote_flag  => 'Y',
1081                         p_data_transfer_mode => 'PLS',
1082                         x_doc_level_recalc_flag => l_doc_level_recalc_flag);
1083 
1084           IF l_debug_level > 0 THEN
1085              oe_debug_pub.add('Message returned by tax API ZX_API_PUB.calculate_tax: '||l_msg_count,2);
1086           END IF;
1087 
1088           IF l_msg_count = 1 THEN
1089 	       --there is one message raised by the API
1090            IF l_debug_level > 0 THEN
1091              oe_debug_pub.add(l_msg_data,2);
1092            END IF;
1093 
1094            IF l_msg_data is not null then
1095   	     FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
1096 	     FND_MESSAGE.SET_TOKEN('TEXT',l_msg_data);
1097 	     OE_MSG_PUB.Add;
1098            ELSE
1099 	     OE_MSG_PUB.Add_text('Tax engine call raised Error ' );  --For bug # 4206796
1100  	   END IF;
1101 
1102 	  ELSIF l_msg_count > 1 THEN
1103 	     LOOP
1104 	       l_msg_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
1105 	       IF l_msg_data is null then
1106                  IF l_debug_level > 0 THEN
1107 	              oe_debug_pub.add('msg data is null',2);
1108  	         END IF;
1109 	         EXIT;
1110 	       ELSE
1111 	          IF l_debug_level > 0 THEN
1112 	              oe_debug_pub.add(l_msg_data,2);
1113  	          END IF;
1114        	          FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
1115                   FND_MESSAGE.SET_TOKEN('TEXT',l_msg_data);
1116 	          OE_MSG_PUB.Add;
1117   	       END IF;
1118 	     END LOOP;
1119          END IF;
1120 
1121         IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1122           IF l_debug_level > 0 THEN
1123       	    oe_debug_pub.add('tax engine call returned unexp error',1);
1124            END IF;
1125            x_return_status := l_return_status; -- nocopy related change
1126            RETURN;
1127         ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1128            IF l_debug_level > 0 THEN
1129       	    oe_debug_pub.add('tax engine call returned error',1);
1130            END IF;
1131            x_return_status := l_return_status; -- nocopy related change
1132            RETURN;
1133         ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1134            IF l_debug_level > 0 THEN
1135       	    oe_debug_pub.add('tax engine call returned successfully',1);
1136            END IF;
1137            x_return_status := l_return_status; -- nocopy related change
1138 
1139         END IF;
1140 
1141  END IF; /* IF inventory_item_id is not null */
1142 
1143 
1144 /*    i:=0;
1145     open detail_tax_lines_gt(l_line_rec.header_id, l_line_rec.line_id);
1146     fetch detail_tax_lines_gt into detail_tax_lines_gt_rec;
1147     loop
1148        exit when detail_tax_lines_gt%NOTFOUND;*/
1149     i := 1;
1150     for detail_tax_lines_gt_rec in detail_tax_lines_gt(l_line_rec.header_id, l_line_rec.line_id) loop
1151 
1152        x_tax_out_tbl(i).tax_amount := detail_tax_lines_gt_rec.tax_amt;
1153        x_tax_out_tbl(i).taxable_amount := detail_tax_lines_gt_rec.taxable_amt;
1154        x_tax_out_tbl(i).tax_rate_id := detail_tax_lines_gt_rec.tax_rate_id;
1155        x_tax_out_tbl(i).tax_rate := detail_tax_lines_gt_rec.tax_rate;
1156        x_tax_out_tbl(i).trx_line_id := detail_tax_lines_gt_rec.trx_line_id;
1157        x_tax_out_tbl(i).amount_includes_tax_flag := detail_tax_lines_gt_rec.tax_amt_included_flag;
1158 
1159         IF l_debug_level > 0 THEN
1160           oe_debug_pub.add('tax amount, taxable amount  ' || i || ' : ' || x_tax_out_tbl(i).tax_amount || ';' || x_tax_out_tbl(i).taxable_amount);
1161         END IF;
1162 
1163        if ( nvl( x_tax_out_tbl(i).amount_includes_tax_flag, 'N' ) <> 'Y'
1164            and x_tax_out_tbl(i).trx_line_id = l_line_rec.line_id )  then
1165 
1166          l_tax_value := l_tax_value + nvl(x_tax_out_tbl(i).tax_amount,0);
1167 
1168        end if;
1169       i := i + 1;
1170     end loop;
1171 
1172     IF l_debug_level > 0 THEN
1173     	oe_debug_pub.add('tax amount after excluding inclusive tax : ' || l_tax_value);
1174     END IF;
1175 
1176    x_tax_value := l_tax_value;
1177 
1178 
1179   IF l_debug_level > 0 THEN
1180    oe_debug_pub.add('tax_line 12' , 1);
1181    oe_debug_pub.add('success - tax call success ' , 1);
1182    oe_debug_pub.add('exiting tax_line' , 1);
1183   END IF;
1184 
1185   x_return_status := l_return_status;
1186 
1187   IF l_call_tax = 'N' then
1188     x_return_status := 'N';
1189   END IF;
1190 
1191  EXCEPTION
1192 
1193    WHEN NO_DATA_FOUND THEN
1194 	  x_return_status  := FND_API.G_RET_STS_SUCCESS;
1195 
1196    WHEN OTHERS THEN
1197      IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1198         THEN
1199             OE_MSG_PUB.Add_Exc_Msg
1200             (   'OM_TAX_UTIL'          ,
1201                 'Tax_Line'
1202             );
1203         END IF;
1204 
1205    IF l_debug_level > 0 THEN
1206     oe_debug_pub.add('some error occurred  ' || sqlerrm , 1);
1207    END IF;
1208    	x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1209         RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210 
1211     --dbms_output.put_line('some error occurred  ' || sqlerrm  );
1212 
1213  END TAX_LINE;
1214 
1215 -- added for bug 1406890
1216 PROCEDURE CALCULATE_TAX(p_header_id IN NUMBER
1217                        ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2) AS
1218 
1219 l_index			NUMBER := 1;
1220 l_entity_id_tbl         OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type;
1221 l_return_status         VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1222 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1223 
1224 TYPE num_tbl is TABLE OF NUMBER;
1225 l_num_tbl num_tbl := num_tbl();
1226 
1227 CURSOR order_line_cur IS
1228 SELECT line_id
1229 FROM   oe_order_lines_all
1230 WHERE  header_id = p_header_id;
1231 
1232 BEGIN
1233   -- performance bug 4255597
1234   OPEN order_line_cur;
1235   FETCH order_line_cur BULK COLLECT INTO l_num_tbl;
1236   CLOSE order_line_cur;
1237 
1238   FOR i in 1..l_num_tbl.count LOOP
1239     l_entity_id_tbl(i).request_ind := i;
1240     l_entity_id_tbl(i).entity_id := l_num_tbl(i);
1241   END LOOP;
1242 
1243   OE_Delayed_Requests_UTIL.Process_Tax
1244    ( p_Entity_id_tbl      => l_entity_id_tbl
1245     ,x_return_status     => l_return_status
1246     );
1247 
1248   x_return_status := l_return_status;
1249 
1250   EXCEPTION
1251 
1252     WHEN OTHERS THEN
1253       IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1254         THEN
1255             OE_MSG_PUB.Add_Exc_Msg
1256             (   'OM_TAX_UTIL'          ,
1257                 'Calculate_Tax'
1258             );
1259       END IF;
1260 
1261       IF l_debug_level > 0 THEN
1262        oe_debug_pub.add('some error occurred  ' || sqlerrm , 1);
1263       END IF;
1264 
1265       x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266     RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267 
1268 END CALCULATE_TAX;
1269 
1270 
1271 Procedure Debug_msg(p_index         IN  NUMBER,
1272 		    x_return_status OUT NOCOPY Varchar2) IS
1273 
1274 i	NUMBER;
1275 Begin
1276         i:=p_index;
1277 	IF i IS NOT NULL
1278 	   AND zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID.exists(I)
1279 THEN
1280         oe_debug_pub.add('Entering OM_TAX_UTIL.Debug_msg procedure ');
1281         oe_debug_pub.add(' i = '||i);
1282 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID(i));
1283 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE(i));
1284 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE(i));
1285 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(i));
1286 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i));
1287 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(i));
1288 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(i));
1289 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(i));
1290 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_SHIPPING_DATE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_SHIPPING_DATE(i));
1291 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(i));
1292 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_TYPE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_TYPE(i));
1293 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(i));
1294 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(i));
1295 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(i));
1296 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS(i));
1297 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(i));
1298 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(i));
1299 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i));
1300 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(i));
1301 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(i));
1302 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(i));
1303 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CASH_DISCOUNT(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CASH_DISCOUNT(i));
1304 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.VOLUME_DISCOUNT(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.VOLUME_DISCOUNT(i));
1305 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRADING_DISCOUNT(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRADING_DISCOUNT(i));
1306 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRANSFER_CHARGE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRANSFER_CHARGE(i));
1307 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRANSPORTATION_CHARGE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRANSPORTATION_CHARGE(i));
1308 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.INSURANCE_CHARGE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.INSURANCE_CHARGE(i));
1309 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.OTHER_CHARGE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.OTHER_CHARGE(i));
1310 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(i));
1311 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(i));
1312 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i));
1313 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i));
1314 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(i));
1315 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(i));
1316 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(i));
1317 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_SIC_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_SIC_CODE(i));
1318 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(i));
1319 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_ID(i));
1320 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(i));
1321 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_ID(i));
1322 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_ID(i));
1323 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_ID(i));
1324 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_ID(i));
1325 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_ID(i));
1326 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID(i));
1327 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_SITE_ID(i));
1328 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_SITE_ID(i));
1329 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_SITE_ID(i));
1330 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_SITE_ID(i));
1331 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_SITE_ID(i));
1332 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(i));
1333 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(i));
1334 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(i));
1335 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POO_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POO_LOCATION_ID(i));
1336 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(i));
1337 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(i));
1338 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ACCOUNT_CCID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ACCOUNT_CCID(i));
1339 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ACCOUNT_STRING(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ACCOUNT_STRING(i));
1340 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_COUNTRY(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_COUNTRY(i));
1341 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_APPLICATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_APPLICATION_ID(i));
1342 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_ENTITY_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_ENTITY_CODE(i));
1343 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_EVENT_CLASS_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_EVENT_CLASS_CODE(i));
1344 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_TRX_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_TRX_ID(i));
1345 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY1(i));
1346 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY2(i));
1347 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY3(i));
1348 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY4(i));
1349 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY5(i));
1350 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY6(i));
1351 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LINE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LINE_ID(i));
1352 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY1(i));
1353 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY2(i));
1354 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY3(i));
1355 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY4(i));
1356 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY5(i));
1357 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY6(i));
1358 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LINE_QUANTITY(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LINE_QUANTITY(i));
1359 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_APPLICATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_APPLICATION_ID(i));
1360 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_ENTITY_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_ENTITY_CODE(i));
1361 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_EVENT_CLASS_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_EVENT_CLASS_CODE(i));
1362 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_ID(i));
1363 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY1(i));
1364 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY2(i));
1365 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY3(i));
1366 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY4(i));
1367 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY5(i));
1368 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY6(i));
1369 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_LINE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_LINE_ID(i));
1370 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY1(i));
1371 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY2(i));
1372 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY3(i));
1373 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY4(i));
1374 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY5(i));
1375 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY6(i));
1376 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_APPLICATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_APPLICATION_ID(i));
1377 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_ENTITY_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_ENTITY_CODE(i));
1378 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE(i));
1379 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TRX_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TRX_ID(i));
1380 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY1(i));
1381 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY2(i));
1382 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY3(i));
1383 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY4(i));
1384 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY5(i));
1385 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY6(i));
1386 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_LINE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_LINE_ID(i));
1387 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY1(i));
1388 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY2(i));
1389 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY3(i));
1390 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY4(i));
1391 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY5(i));
1392 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY6(i));
1393 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_NUMBER(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_NUMBER(i));
1394 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_DATE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_DATE(i));
1395 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_APPLICATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_APPLICATION_ID(i));
1396 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_ENTITY_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_ENTITY_CODE(i));
1397 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_EVENT_CLASS_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_EVENT_CLASS_CODE(i));
1398 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_ID(i));
1399 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY1(i));
1400 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY2(i));
1401 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY3(i));
1402 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY4(i));
1403 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY5(i));
1404 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY6(i));
1405 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_LINE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_LINE_ID(i));
1406 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY1(i));
1407 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY2(i));
1408 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY3(i));
1409 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY4(i));
1410 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY5(i));
1411 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY6(i));
1412 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE(i));
1413 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(i));
1414 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL2(i));
1415 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL3(i));
1416 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL4(i));
1417 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL5(i));
1418 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL6(i));
1419 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY1(i));
1420 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY2(i));
1421 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY3(i));
1422 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY4(i));
1423 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY5(i));
1424 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY6(i));
1425 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY1(i));
1426 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY2(i));
1427 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY3(i));
1428 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY4(i));
1429 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY5(i));
1430 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY6(i));
1431 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(i));
1432 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_FLAG(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_FLAG(i));
1433 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(i));
1434 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CTRL_TOTAL_LINE_TX_AMT(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CTRL_TOTAL_LINE_TX_AMT(i));
1435 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i));
1436 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(i));
1437 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_WAYBILL_NUMBER(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_WAYBILL_NUMBER(i));
1438 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_GL_DATE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_GL_DATE(i));
1439 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_NAME(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_NAME(i));
1440 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_DOCUMENT_NUMBER(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_DOCUMENT_NUMBER(i));
1441 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_REFERENCE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_REFERENCE(i));
1442 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAXPAYER_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAXPAYER_ID(i));
1443 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAX_REG_NUMBER(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAX_REG_NUMBER(i));
1444 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_ID(i));
1445 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_ID(i));
1446 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_ID(i));
1447 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_ID(i));
1448 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_ID(i));
1449 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_ID(i));
1450 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_SITE_ID(i));
1451 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_SITE_ID(i));
1452 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_SITE_ID(i));
1453 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_SITE_ID(i));
1454 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_SITE_ID(i));
1455 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_SITE_ID(i));
1456 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(i));
1457 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(i));
1458 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(i));
1459 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(i));
1460 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(i));
1461 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(i));
1462 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID(i));
1463 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ASSET_FLAG(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ASSET_FLAG(i));
1464 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ASSET_NUMBER(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ASSET_NUMBER(i));
1465 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ASSET_ACCUM_DEPRECIATION(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ASSET_ACCUM_DEPRECIATION(i));
1466 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ASSET_TYPE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ASSET_TYPE(i));
1467 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ASSET_COST(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ASSET_COST(i));
1468 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC1(i));
1469 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC2(i));
1470 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC3(i));
1471 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC4(i));
1472 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC5(i));
1473 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC6(i));
1474 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC7(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC7(i));
1475 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC8(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC8(i));
1476 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC9(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC9(i));
1477 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC10(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC10(i));
1478 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR1(i));
1479 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR2(i));
1480 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR3(i));
1481 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR4(i));
1482 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR5(i));
1483 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR6(i));
1484 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR7(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR7(i));
1485 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR8(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR8(i));
1486 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR9(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR9(i));
1487 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR10(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR10(i));
1488 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE1(i));
1489 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE2(i));
1490 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE3(i));
1491 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE4(i));
1492 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE5(i));
1493 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE6(i));
1494 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE7(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE7(i));
1495 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE8(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE8(i));
1496 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE9(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE9(i));
1497 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE10(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE10(i));
1498 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_TAX_PROF_ID(i));
1499 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_TAX_PROF_ID(i));
1500 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_TAX_PROF_ID(i));
1501 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_TAX_PROF_ID(i));
1502 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_TAX_PROF_ID(i));
1503 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_TAX_PROF_ID(i));
1504 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_TAX_PROF_ID(i));
1505 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_TAX_PROF_ID(i));
1506 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_TAX_PROF_ID(i));
1507 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_TAX_PROF_ID(i));
1508 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_TAX_PROF_ID(i));
1509 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANS_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANS_PARTY_TAX_PROF_ID(i));
1510 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_SITE_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_SITE_TAX_PROF_ID(i));
1511 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_SITE_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_SITE_TAX_PROF_ID(i));
1512 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POA_SITE_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POA_SITE_TAX_PROF_ID(i));
1513 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POO_SITE_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POO_SITE_TAX_PROF_ID(i));
1514 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.PAYING_SITE_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.PAYING_SITE_TAX_PROF_ID(i));
1515 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_SITE_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_SITE_TAX_PROF_ID(i));
1516 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_SITE_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_SITE_TAX_PROF_ID(i));
1517 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POI_SITE_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POI_SITE_TAX_PROF_ID(i));
1518 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.POD_SITE_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.POD_SITE_TAX_PROF_ID(i));
1519 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_SITE_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_SITE_TAX_PROF_ID(i));
1520 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_SITE_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_SITE_TAX_PROF_ID(i));
1521 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANS_SITE_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANS_SITE_TAX_PROF_ID(i));
1522 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAX_PROF_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAX_PROF_ID(i));
1523 
1524 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_APPLICATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_APPLICATION_ID(i));
1525 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_ENTITY_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_ENTITY_CODE(i));
1526 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_EVENT_CLASS_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_EVENT_CLASS_CODE(i));
1527 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TRX_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TRX_ID(i));
1528 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_LINE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_LINE_ID(i));
1529 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TRX_LEVEL_TYPE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TRX_LEVEL_TYPE(i));
1530 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_TRX_LEVEL_TYPE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_TRX_LEVEL_TYPE(i));
1531 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_LEVEL_TYPE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_LEVEL_TYPE(i));
1532 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_LEVEL_TYPE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_LEVEL_TYPE(i));
1533 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TRX_LEVEL_TYPE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TRX_LEVEL_TYPE(i));
1534 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE1(i));
1535 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE2(i));
1536 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE3(i));
1537 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE4(i));
1538 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE5(i));
1539 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE6(i));
1540 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE7(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE7(i));
1541 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE8(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE8(i));
1542 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE9(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE9(i));
1543 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE10(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE10(i));
1544 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TAX_LINE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TAX_LINE_ID(i));
1545 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER(i));
1546 
1547 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(i));
1548 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID(i));
1549 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(i));
1550 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(i));
1551 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(i));
1552 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID(i));
1553         oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LEGAL_ENTITY_ID(i)= '||
1554                                    zx_global_structures_pkg.trx_line_dist_tbl.LEGAL_ENTITY_ID(i),3);
1555         oe_debug_pub.add('Exiting OM_TAX_UTIL.Debug_msg procedure ');
1556 ELSE
1557 	oe_debug_pub.add(' Index:'||i||' not avail for debug');
1558 END IF;
1559 End Debug_msg ;
1560 
1561 Function get_le_id(p_order_type_id NUMBER
1562                   , p_sold_to_customer_id NUMBER
1563                   , p_bill_to_customer_id NUMBER
1564                   , p_org_id NUMBER
1565 ) RETURN NUMBER IS
1566 
1567 l_invoice_source_id	NUMBER;
1568 l_invoice_source	VARCHAR2(50);
1569 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1570 l_order_type_rec  OE_ORDER_CACHE.ORDER_TYPE_REC_TYPE;
1571  l_customer_type      		VARCHAR2(30);
1572  l_customer_id        		NUMBER;
1573  l_batch_source_id		NUMBER;
1574  l_sold_to_customer_id		NUMBER;
1575 l_cust_trx_type_id              NUMBER;
1576 l_return_status         VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1577 l_legal_entity_id NUMBER;
1578 l_msg_data                     VARCHAR2(1000);
1579 BEGIN
1580 
1581       IF p_sold_to_customer_id IS NOT NULL THEN
1582         l_customer_type := 'SOLD_TO';
1583         l_customer_id := p_sold_to_customer_id;
1584       ELSIF p_bill_to_customer_id IS NOT NULL THEN
1585         l_customer_type := 'BILL_TO';
1586         l_customer_id := p_bill_to_customer_id;
1587       END IF;
1588 
1589      IF l_debug_level > 0 THEN
1590        oe_debug_pub.add('l_customer_type:'||l_customer_type, 3);
1591        oe_debug_pub.add('l_customer_id:'||l_customer_id, 3);
1592      END IF;
1593 
1594      l_order_type_rec := OE_ORDER_CACHE.Load_Order_Type(p_order_type_id);
1595      l_invoice_source_id := l_order_type_rec.invoice_source_id;
1596      l_cust_trx_type_id := l_order_type_rec.cust_trx_type_id;
1597 
1598      IF l_invoice_source_id IS NOT NULL THEN
1599         IF l_debug_level  > 0 THEN
1600           oe_debug_pub.add(  'INVOICE SOURCE ID IS ( 3 ) : '||L_INVOICE_SOURCE_ID , 5 ) ;
1601         END IF;
1602      ELSE
1603         l_invoice_source := oe_sys_parameters.value('INVOICE_SOURCE', p_org_id);
1604 
1605                    IF (l_invoice_source IS NOT NULL) THEN
1606 		   SELECT batch_source_id
1607 		     INTO l_invoice_source_id
1608 		     FROM ra_batch_sources
1609 		    WHERE name = l_invoice_source;
1610 
1611                    END IF;
1612 
1613 		   IF l_debug_level  > 0 THEN
1614 		       oe_debug_pub.add(  'INVOICE_SOURCE_ID IS ( 4 ) : '||L_INVOICE_SOURCE_ID , 5 ) ;
1615 		   END IF;
1616     END IF;
1617 
1618     IF l_cust_trx_type_id IS NULL THEN
1619           l_cust_trx_type_id := oe_sys_parameters.value('OE_INVOICE_TRANSACTION_TYPE_ID',p_org_id);
1620           IF l_debug_level  > 0 THEN
1621               oe_debug_pub.add(  'CUSTOMER TRANSACTION TYPE ID FROM sys parameter : '||L_CUST_TRX_TYPE_ID , 5 ) ;
1622           END IF;
1623    END IF;
1624 
1625    IF l_debug_level > 0 THEN
1626        oe_debug_pub.add('customer type:'||l_customer_type,3);
1627        oe_debug_pub.add('customer id:'||l_customer_id,3);
1628        oe_debug_pub.add('ar trx type:'||l_cust_trx_type_id,3);
1629        oe_debug_pub.add('batch source:'||l_invoice_source_id,3);
1630        oe_debug_pub.add('OU:'||p_org_id,3);
1631    END IF;
1632 
1633    l_legal_entity_id := XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info(
1634      x_return_status => l_return_status,		-- OUT
1635      x_msg_data => l_msg_data,		-- OUT
1636      p_customer_type => l_customer_type,		-- IN	P_customer_type
1637      p_customer_id => l_customer_id, 		-- IN	P_customer_id (sold_to/bill_to customer_id)
1638      p_transaction_type_id => l_cust_trx_type_id,	-- IN	P_transaction_type_id
1639      p_batch_source_id => l_invoice_source_id,		-- IN	P_batch_source_id
1640      p_operating_unit_id => p_org_id 	-- IN	P_operating_unit_id (org_id)
1641      );
1642 
1643      IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_legal_entity_id = -1 THEN
1644 
1645         IF l_debug_level > 0 THEN
1646    	    oe_debug_pub.add('In getting legal_entity_id, return status error'||l_msg_data);
1647         END IF;
1648            IF l_msg_data is not null then
1649   	     FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
1650 	     FND_MESSAGE.SET_TOKEN('TEXT',l_msg_data);
1651 	     OE_MSG_PUB.Add;
1652            ELSE
1653 	     OE_MSG_PUB.Add_text('XLE call raised Error ' );  --For bug # 4206796
1654  	   END IF;
1655          RETURN -1;
1656      END IF;
1657 
1658      IF l_debug_level > 0 THEN
1659    	oe_debug_pub.add('legal_entity_id is '||l_legal_entity_id);
1660      END IF;
1661 
1662      RETURN l_legal_entity_id;
1663   EXCEPTION
1664       WHEN OTHERS THEN
1665 
1666       	IF l_debug_level  > 0 THEN
1667 	   oe_debug_pub.add(  'Error getting legal_entity_id'||sqlerrm);
1668 	END IF;
1669       RETURN -1;
1670 END get_le_id;
1671 
1672 /* ==============================================================+
1673  * FUNCTION Get_Content_Owner_Id
1674  *
1675  * Description:
1676  *  Created for R12  Vertext project called from oip and sales order form
1677  *  Function Get_Content_Owner_Id
1678  *  is calling  APIs : XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info
1679  *  and ZX_TCM_PTP_PKG.get_tax_subscriber to get content_owner_id
1680  *================================================================*/
1681 
1682 FUNCTION Get_Content_Owner_Id(
1683 p_header_id          IN  NUMBER)
1684 RETURN  NUMBER
1685 IS
1686 
1687 l_org_id               NUMBER;
1688 l_le_id                NUMBER;
1689 l_conten_owner_id      NUMBER;
1690 l_return_status        VARCHAR2(1);
1691 l_msg_data             VARCHAR2(1000);
1692 l_sold_to_customer_id  NUMBER;
1693 l_bill_to_customer_id          NUMBER;
1694 l_invoice_to_org_id NUMBER;
1695 l_order_type_id        NUMBER;
1696 l_batch_source_id      NUMBER;
1697 l_otoc_Le_info         XLE_BUSINESSINFO_GRP.otoc_le_rec;
1698 
1699 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1700 
1701 BEGIN
1702 
1703 
1704   SELECT org_id
1705         ,SOLD_TO_ORG_ID
1706         ,INVOICE_TO_ORG_ID
1707         ,ORDER_TYPE_ID
1708   INTO l_org_id
1709       ,l_sold_to_customer_id
1710       ,l_invoice_to_org_id
1711       ,l_order_type_id
1712   FROM oe_order_headers_all
1713   WHERE header_id = p_header_id;
1714 
1715   IF (l_invoice_to_org_id IS NOT NULL) THEN
1716     SELECT acct_site.cust_account_id
1717     INTO l_bill_to_customer_id
1718     FROM HZ_CUST_SITE_USES_ALL         site_use ,
1719        HZ_CUST_ACCT_SITES_ALL      acct_site
1720     WHERE site_use.site_use_id = l_invoice_to_org_id
1721     AND   site_use.cust_acct_site_id = acct_site.cust_acct_site_id;
1722   END IF;
1723 
1724   l_le_id := Get_Le_Id(p_order_type_id => l_order_type_id
1725             , p_sold_to_customer_id => l_sold_to_customer_id
1726             , p_bill_to_customer_id => l_bill_to_customer_id
1727             , p_org_id      => l_org_id);
1728 
1729 
1730     IF l_debug_level  > 0 THEN
1731           oe_debug_pub.add('Get_le_id: '||l_le_id, 2) ;
1732     END IF;
1733 
1734 
1735 
1736   -- Call ZX_TCM_PTP_PKG.get_tax_subscriber
1737   -- to get conten_owner_id
1738 
1739   ZX_TCM_PTP_PKG.get_tax_subscriber(
1740                  p_le_id   => l_le_id
1741                 ,p_org_id  => l_org_id
1742                 ,p_ptp_id  => l_conten_owner_id
1743                 ,p_return_status => l_return_status);
1744 
1745   IF l_return_status = 'S' THEN
1746      return l_conten_owner_id ;
1747   ELSE
1748      IF l_debug_level  > 0 THEN
1749           oe_debug_pub.add('Return Status from ZX_TCM_PTP_PKG.get_tax_subscriber '||l_return_status, 1) ;
1750      END IF;
1751      RAISE FND_API.G_EXC_ERROR;
1752   END IF;
1753 
1754 EXCEPTION
1755 WHEN OTHERS THEN
1756          OE_MSG_PUB.Add_Exc_Msg
1757             (   'OM_TAX_UTIL'
1758             ,  'Get_Content_Owner_Id'
1759             );
1760          RETURN -99;
1761 
1762 END Get_Content_Owner_Id;
1763 
1764 
1765 END OM_TAX_UTIL;