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.32 2011/05/31 10:58:42 jmedaven ship $ */
3 G_BINARY_LIMIT                CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT;
4 G_DEBUG_BYPASS_TAX            CONSTANT VARCHAR2(1):=nvl(Fnd_Profile.value('OE_DBG_BYPASS'),'N');
5  -- structure for caching loc_ship_bill_info
6  TYPE loc_ship_bill_info_rec IS RECORD (
7           site_use_id                 HZ_CUST_SITE_USES_ALL.site_use_id%TYPE,
8           acct_site_id                HZ_CUST_SITE_USES_ALL.cust_acct_site_id%TYPE,
9           cust_acct_id                HZ_CUST_ACCT_SITES_ALL.cust_account_id%TYPE,
10           postal_code                 HZ_LOCATIONS.postal_code%TYPE,
11           customer_name               HZ_PARTIES.party_name%TYPE,
12           customer_number             HZ_CUST_ACCOUNTS_ALL.account_number%TYPE,
13           party_id                    HZ_PARTIES.party_id%TYPE,
14           party_site_id               HZ_PARTY_SITES.party_site_id%TYPE,
15           location_id                 HZ_LOCATIONS.location_id%TYPE);
16 
17  TYPE ship_bill_records IS TABLE OF loc_ship_bill_info_rec INDEX BY BINARY_INTEGER;
18  ship_bill_records_tab  ship_bill_records;
19  pr_index    number;
20 
21 -- salesrep criteria
22 G_SALESREP_ID                     NUMBER;
23 G_SALESREP_POA_ID                 NUMBER;
24 
25 -- cache values
26 G_POO_PARTY_ID                          NUMBER;
27 G_POO_LOCATION_ID                   NUMBER;
28 
29 Procedure Debug_msg(p_index         IN  NUMBER,
30 		    x_return_status OUT NOCOPY Varchar2) ;
31 
32 
33 Function get_le_id(p_order_type_id NUMBER
34                   , p_sold_to_customer_id NUMBER
35                   , p_bill_to_customer_id NUMBER
36                   , p_org_id NUMBER
37 ) RETURN NUMBER;
38 
39 
40 --TaxER Start
41 Function get_charge_details(p_header_id		NUMBER,
42 				       p_line_id		NUMBER)
43 	     RETURN charge_tbl
44 	     IS
45 	     l_charge_tbl	charge_tbl;
46        Is_fmt  BOOLEAN;
47 
48 	     BEGIN
49 	    IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN
50 
51 	        IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
52 	        THEN
53 
54 	            fnd_message.set_name ('ONT','OE_ATTRIBUTE_REQUIRED');
55 	            FND_MESSAGE.SET_TOKEN ('ATTRIBUTE','header');
56 	            OE_MSG_PUB.Add;
57 
58 	        END IF;
59 	        RAISE FND_API.G_EXC_ERROR;
60 
61 	    END IF;
62 
63 	    IF NVL (p_header_id,-1) <>NVL(OE_ORDER_UTIL.G_Header_id,-10)
64 	    OR OE_ORDER_UTIL.G_Precision IS NULL THEN
65 	      Is_fmt:=   OE_ORDER_UTIL.Get_Precision (
66 	                p_header_id=>p_header_id
67 	               );
68 	    END IF;
69 
70 	    IF OE_ORDER_UTIL.G_Precision IS NULL THEN
71 	      OE_ORDER_UTIL.G_Precision:=2;
72 	    END IF;
73 
74 	    IF p_header_id IS NOT NULL and p_line_id IS NULL THEN
75 
76 	      SELECT PRICE_ADJUSTMENT_ID,ROUND (
77 	                DECODE (P.CREDIT_OR_CHARGE_FLAG,'C',-P.OPERAND,P.OPERAND)
78 	                ,OE_ORDER_UTIL.G_Precision)
79 	      BULK COLLECT INTO l_charge_tbl
80 	      FROM OE_PRICE_ADJUSTMENTS P
81 	      WHERE P.HEADER_ID = p_header_id
82 	      AND   P.LINE_ID IS NULL
83 	      AND   P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
84 	      AND   P.APPLIED_FLAG = 'Y';
85 
86 	   ELSIF p_header_id IS NOT NULL and p_line_id IS NOT NULL THEN
87 
88 	      SELECT PRICE_ADJUSTMENT_ID,ROUND (
89 	                DECODE (P.CREDIT_OR_CHARGE_FLAG,'C', -1, 1) *
90 	                        DECODE (P.ARITHMETIC_OPERATOR, 'LUMPSUM',
91 	                               DECODE (L.ORDERED_QUANTITY,0,0,P.OPERAND),
92 	                               (L.ORDERED_QUANTITY* nvl(P.ADJUSTED_AMOUNT,0)))
93 	                  ,OE_ORDER_UTIL.G_Precision)
94 	      BULK COLLECT  INTO l_charge_tbl
95 	      FROM OE_PRICE_ADJUSTMENTS P,
96 	          OE_ORDER_LINES_ALL L
97 	      WHERE P.HEADER_ID = p_header_id
98 	      AND   P.LINE_ID = p_line_id
99 	      AND   P.LINE_ID = L.LINE_ID
100 	      AND   P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
101 	      AND   P.APPLIED_FLAG = 'Y';
102 
103 	   END IF;
104 
105      RETURN  l_charge_tbl;
106 
107 EXCEPTION
108 WHEN OTHERS THEN
109   RETURN l_charge_tbl;
110 END  get_charge_details;
111 --TaxER End
112 
113 
114 PROCEDURE TAX_LINE(
115     p_entity_id_tbl IN OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type,
116     x_tax_out_tbl OUT NOCOPY OM_TAX_UTIL.om_tax_out_tab_type,
117     x_return_status OUT NOCOPY    /* file.sql.39 change */    VARCHAR2)
118 AS
119 TYPE ship_bill_records
120 IS
121   TABLE OF loc_ship_bill_info_rec INDEX BY BINARY_INTEGER;
122   ship_bill_records_tab ship_bill_records;
123   pr_index NUMBER;
124   CURSOR getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type)
125   IS
126     SELECT
127       /* MOAC_SQL_CHANGE */
128       s_ship.site_use_id,
129       s_ship.cust_acct_site_id,
130       acct_site_ship.cust_account_id,
131       loc_ship.postal_code,
132       party.party_name,
133       cust_acct.account_number,
134       party.party_id,
135       party_site_ship.party_site_id,
136       loc_ship.location_id
137     FROM HZ_CUST_SITE_USES S_SHIP ,
138       HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP,
139       HZ_PARTY_SITES PARTY_SITE_SHIP,
140       HZ_LOCATIONS LOC_SHIP,
141       HZ_PARTIES PARTY,
142       HZ_CUST_ACCOUNTS_ALL CUST_ACCT
143     WHERE s_ship.site_use_id           = p_site_org_id
144     AND s_ship.cust_acct_site_id       = acct_site_ship.cust_acct_site_id
145     AND acct_site_ship.cust_account_id = cust_acct.cust_account_id
146     AND cust_acct.party_id             = party.party_id
147     AND acct_site_ship.party_site_id   = party_site_ship.party_site_id
148     AND party_site_ship.location_id    = loc_ship.location_id;
149   CURSOR get_internal_loc(p_organization_id NUMBER)
150   IS
151     SELECT location_id
152     FROM hr_organization_units
153     WHERE organization_id = p_organization_id;
154   CURSOR detail_tax_charges_gt (p_header_id oe_order_lines.header_id%type, p_adj_id oe_order_lines.line_id%type )
155   IS
156     SELECT *
157     FROM ZX_DETAIL_TAX_LINES_GT
158     WHERE application_id = 660
159     AND entity_code      = 'OE_ORDER_HEADERS'
160     AND event_class_code = 'SALES_TRANSACTION_TAX_QUOTE'
161     AND trx_id           = p_header_id
162     AND trx_line_id      = p_adj_id
163     AND trx_level_type   = 'FREIGHT_CHARGE';
164   CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type, p_line_id oe_order_lines.line_id%type)
165   IS
166     SELECT *
167     FROM ZX_DETAIL_TAX_LINES_GT
168     WHERE application_id = 660
169     AND entity_code      = 'OE_ORDER_HEADERS'
170     AND event_class_code = 'SALES_TRANSACTION_TAX_QUOTE'
171     AND trx_id           = p_header_id
172     AND trx_line_id      = p_line_id
173     AND trx_level_type   = 'LINE'; --'LINE';
174   l_dummy VARCHAR2(100);
175   k       NUMBER;
176   p       NUMBER;
177   l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE;
178   l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE ;
179   l_call_tax       VARCHAR2(1);
180   l_tax_value      NUMBER;
181   l_application_id NUMBER;
182   l_header_rec OE_Order_PUB.Header_Rec_Type;
183   l_line_rec OE_Order_PUB.Line_Rec_Type;
184   l_currency_code    VARCHAR2(30);
185   l_header_org_id    NUMBER;
186   l_conversion_rate  NUMBER;
187   l_inventory_org_id NUMBER;
188   l_level            VARCHAR2(1); -- Tax ER
189   l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%type;
190   l_precision fnd_currencies.precision%type;
191   Is_fmt BOOLEAN; --8431420
192   l_AR_Sys_Param_Rec ar_system_parameters_all%ROWTYPE;
193   l_commitment_id oe_order_lines.commitment_id%type;
194   l_cust_trx_type_id ra_cust_trx_types_all.cust_Trx_type_id%type;
195   l_ship_to_org_id oe_order_lines.ship_to_org_id%type;
196   l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;
197   l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;
198   l_ship_to_address_id       NUMBER ;
199   l_ship_to_customer_id      NUMBER ;
200   l_ship_to_postal_code      VARCHAR2(60);
201   l_ship_to_customer_name    VARCHAR2(360);
202   l_ship_to_customer_number  VARCHAR2(30);
203   l_ship_party_id            NUMBER(15);
204   l_ship_party_site_id       NUMBER(15);
205   l_ship_location_id         NUMBER(15);
206   l_bill_to_address_id       NUMBER;
207   l_bill_to_site_use_id      NUMBER;
208   l_bill_to_customer_id      NUMBER;
209   l_bill_to_postal_code      VARCHAR2(60);
210   l_bill_to_customer_name    VARCHAR2(360);
211   l_bill_to_customer_number  VARCHAR2(30);
212   l_bill_party_id            NUMBER(15);
213   l_bill_party_site_id       NUMBER(15);
214   l_bill_location_id         NUMBER(15);
215   l_internal_org_location_id NUMBER;
216   l_header_id oe_order_headers.header_id%type;
217   l_tax_date oe_order_lines.tax_date%type;
218   l_ordered_quantity oe_order_lines.ordered_quantity%type;
219   l_unit_selling_price oe_order_lines.unit_selling_price%type;
220   l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
221   l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
222   l_inventory_item_id oe_order_lines.inventory_item_id%type;
223   l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
224   l_fob_point_code oe_order_lines.fob_point_code%type;
225   l_tax_code VARCHAR2(50);
226   l_trx_shipping_date DATE;
227   l_trx_business_category       VARCHAR2(240);
228   l_uom_code                    VARCHAR2(3);
229   l_trx_line_number             NUMBER;
230   l_user_item_description       VARCHAR2(1000);
231   l_product_fisc_classification VARCHAR2(240);
232   l_ship_from_location_id       NUMBER;
233   l_salesrep_id oe_order_headers.salesrep_id%type;
234   L_POO_PARTY_ID          NUMBER;
235   l_POO_LOCATION_ID       NUMBER;
236   l_bill_from_location_id NUMBER;
237   l_legal_entity_id       NUMBER(15);
238   l_charge_tbl charge_tbl;
239   l_transaction_rec zx_api_pub.transaction_rec_type;
240   l_org_id                NUMBER(15):=MO_GLOBAL.Get_Current_Org_Id;
241   l_doc_level_recalc_flag VARCHAR2(30);
242   l_return_status         VARCHAR2(1);
243   l_msg_count             NUMBER;
244   l_msg_data              VARCHAR2(1000);
245   om_tax_info_rec_tbl om_tax_rec_tab_type;
246   l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
247   l_product_type zx_product_types_def_v.classification_code%TYPE;
248   l_trx_date DATE;
249   l_product_code VARCHAR2(1000);
250 BEGIN
251   SELECT FND_PROFILE.VALUE('ONT_SOURCE_CODE') INTO l_dummy FROM DUAL;
252   oe_debug_pub.add('11056686-Profile Value-1 = '||l_dummy);
253   IF G_DEBUG_BYPASS_TAX = 'Y' THEN
254     l_return_status    := FND_API.G_RET_STS_SUCCESS;
255     RETURN;
256   END IF;
257   /* initialising common variables */
258   l_return_status         := FND_API.G_RET_STS_SUCCESS;
259   l_entity_code_crsr      := 'OE_ORDER_HEADERS';
260   l_event_class_code_crsr := 'SALES_TRANSACTION_TAX_QUOTE';
261   l_call_tax              := 'N';
262   l_tax_value             := 0;
263   l_application_id        := 660;
264   /* initialising common variables */
265   k     :=1;
266   p     :=1;
267   FOR i IN 1..p_entity_id_tbl.count
268   LOOP
269     IF p_entity_id_tbl(i).requesting_entity_code = OE_GLOBALS.G_ENTITY_HEADER AND (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y') THEN
270       /*  getting header record */
271       l_header_rec                                 := OE_Header_UTIL.Query_Row(p_header_id=> p_entity_id_tbl(i).entity_id );
272       l_level                                      := 'H' ;
273     elsif p_entity_id_tbl(i).requesting_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
274       /*  getting header record and line record*/
275       l_line_rec  := OE_line_UTIL.Query_Row(p_line_id=> p_entity_id_tbl(i).entity_id );
276       l_header_rec:= OE_Header_UTIL.Query_Row(p_header_id=> l_line_rec.header_id );
277       l_level     := 'L';
278     END IF;
279     l_currency_code    := l_header_rec.transactional_curr_code;
280     l_header_org_id    := l_header_rec.org_id;
281     l_conversion_rate  := l_header_rec.conversion_rate;
282     l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_header_rec.org_id);
283     SELECT c.minimum_accountable_unit,
284       c.precision
285     INTO l_minimum_accountable_unit,
286       l_precision
287     FROM fnd_currencies c
288     WHERE c.currency_code = l_currency_code;
289     l_AR_Sys_Param_Rec   := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
290     --8431420
291     IF OE_ORDER_UTIL.G_Precision   IS NULL THEN
292       Is_fmt                       := OE_ORDER_UTIL.Get_Precision(p_header_id=> l_header_rec.header_id);
293       IF OE_ORDER_UTIL.G_Precision IS NULL THEN
294         OE_ORDER_UTIL.G_Precision  :=2;
295       END IF;
296     END IF;
297     IF l_level            = 'L' THEN
298 oe_debug_pub.ADD('Populating line level details', 5);
299       l_commitment_id    := NVL(l_line_rec.commitment_id,0);
300       IF l_commitment_id <> 0 THEN
301         IF l_debug_level  > 0 THEN
302           oe_debug_pub.add('Commitment id is:'||l_commitment_id,4);
303         END IF;
304         BEGIN
305           SELECT
306             /* MOAC_SQL_CHANGE */
307             NVL(cust_type.subsequent_trx_type_id, cust_type.cust_trx_type_id)
308           INTO l_cust_trx_type_id
309           FROM ra_cust_trx_types_all cust_type,
310             ra_customer_trx cust_trx
311           WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
312           AND cust_type.org_id             = cust_trx.org_id
313           AND cust_trx.customer_trx_id     = l_commitment_id;
314         EXCEPTION
315         WHEN OTHERS THEN
316           IF l_debug_level > 0 THEN
317             oe_debug_pub.add('In commitment exception ',4);
318           END IF;
319           NULL;
320         END;
321       ELSE
322         IF l_debug_level > 0 THEN
323           oe_debug_pub.add('In else part of commitment at line level id',4);
324         END IF;
325         l_cust_trx_type_id := OE_INVOICE_PUB.Get_Customer_Transaction_Type(l_line_rec);
326       END IF;
327     ELSE -- if level is header
328       BEGIN
329         SELECT NVL (ot.cust_trx_type_id, 0)
330         INTO l_cust_trx_type_id
331         FROM oe_order_types_v ot,
332           oe_order_headers_all oh
333         WHERE ot.order_type_id = oh.order_type_id
334         AND oh.header_id       = l_header_rec.header_id;
335       EXCEPTION
336       WHEN OTHERS THEN
337         IF l_debug_level > 0 THEN
338           oe_debug_pub.add('In header exception ',4);
339         END IF;
340         NULL;
341       END;
342     END IF;
343     IF l_debug_level > 0 THEN
344       oe_debug_pub.add('Customer trx type id is:'||l_cust_trx_type_id,4);
345     END IF;
346     IF l_level             = 'L' THEN
347       l_ship_to_org_id    := l_line_rec.ship_to_org_id ;
348       l_invoice_to_org_id := l_line_rec.invoice_to_org_id;
349     ELSE
350       l_ship_to_org_id    := l_header_rec.ship_to_org_id ;
351       l_invoice_to_org_id := l_header_rec.invoice_to_org_id;
352     END IF;
353     IF l_ship_to_org_id IS NOT NULL THEN
354       pr_index          := MOD(l_ship_to_org_id,G_BINARY_LIMIT);
355       BEGIN
356         IF l_debug_level > 0 THEN
357           oe_debug_pub.add('om_tax_line  3' , 4);
358         END IF;
359         IF ship_bill_records_tab.exists(pr_index) THEN --bug8799250
360           IF l_debug_level > 0 THEN
361             oe_debug_pub.add('om_tax_line  3.5' , 4);
362           END IF;
363           l_ship_to_site_use_id     := ship_bill_records_tab(pr_index).site_use_id;
364           l_ship_to_address_id      := ship_bill_records_tab(pr_index).acct_site_id;
365           l_ship_to_customer_id     := ship_bill_records_tab(pr_index).cust_acct_id;
366           l_ship_to_postal_code     := ship_bill_records_tab(pr_index).postal_code;
367           l_ship_to_customer_name   := ship_bill_records_tab(pr_index).customer_name;
368           l_ship_to_customer_number := ship_bill_records_tab(pr_index).customer_number;
369           l_ship_party_id           := ship_bill_records_tab(pr_index).party_id;
370           l_ship_party_site_id      := ship_bill_records_tab(pr_index).party_site_id;
371           l_ship_location_id        := ship_bill_records_tab(pr_index).location_id;
372         ELSE
373           OPEN getlocinfo(l_ship_to_org_id);
374           IF l_debug_level > 0 THEN
375             oe_debug_pub.add('om_tax_line  4' , 4);
376           END IF;
377           FETCH getlocinfo
378           INTO l_ship_to_site_use_id,
379             l_ship_to_address_id,
380             l_ship_to_customer_id,
381             l_ship_to_postal_code,
382             l_ship_to_customer_name,
383             l_ship_to_customer_number,
384             l_ship_party_id,
385             l_ship_party_site_id,
386             l_ship_location_id;
387           ship_bill_records_tab(pr_index).site_use_id     := l_ship_to_site_use_id;
388           ship_bill_records_tab(pr_index).acct_site_id    := l_ship_to_address_id;
389           ship_bill_records_tab(pr_index).cust_acct_id    := l_ship_to_customer_id;
390           ship_bill_records_tab(pr_index).postal_code     := l_ship_to_postal_code;
391           ship_bill_records_tab(pr_index).customer_name   := l_ship_to_customer_name;
392           ship_bill_records_tab(pr_index).customer_number := l_ship_to_customer_number;
393           ship_bill_records_tab(pr_index).party_id        := l_ship_party_id;
394           ship_bill_records_tab(pr_index).party_site_id   := l_ship_party_site_id;
395           ship_bill_records_tab(pr_index).location_id     := l_ship_location_id;
396           IF l_debug_level                                 > 0 THEN
397             oe_debug_pub.add('om_tax_line  5' , 4);
398           END IF;
399           CLOSE getlocinfo;
400         END IF;
401       EXCEPTION
402       WHEN no_data_found THEN
403         IF l_debug_level > 0 THEN
404           oe_debug_pub.add('om_tax_line  6' , 1);
405         END IF;
406         NULL;
407         CLOSE getlocinfo;
408       END;
409     END IF;
410     IF l_invoice_to_org_id IS NOT NULL THEN
411       pr_index             := MOD(l_invoice_to_org_id,G_BINARY_LIMIT); --bug8799250
412       BEGIN
413         IF l_debug_level > 0 THEN
414           oe_debug_pub.add('om_tax_line  7' , 4);
415         END IF;
416         IF ship_bill_records_tab.exists(pr_index) THEN
417           IF l_debug_level > 0 THEN
418             oe_debug_pub.add('om_tax_line  7.5' , 4);
419           END IF;
420           l_bill_to_site_use_id     := ship_bill_records_tab(pr_index).site_use_id;
421           l_bill_to_address_id      := ship_bill_records_tab(pr_index).acct_site_id;
422           l_bill_to_customer_id     := ship_bill_records_tab(pr_index).cust_acct_id;
423           l_bill_to_postal_code     := ship_bill_records_tab(pr_index).postal_code;
424           l_bill_to_customer_name   := ship_bill_records_tab(pr_index).customer_name;
425           l_bill_to_customer_number := ship_bill_records_tab(pr_index).customer_number;
426           l_bill_party_id           := ship_bill_records_tab(pr_index).party_id;
427           l_bill_party_site_id      := ship_bill_records_tab(pr_index).party_site_id;
428           l_bill_location_id        := ship_bill_records_tab(pr_index).location_id;
429         ELSE
430           OPEN getlocinfo(l_invoice_to_org_id);
431           IF l_debug_level > 0 THEN
432             oe_debug_pub.add('om_tax_line  8' , 4);
433           END IF;
434           FETCH getlocinfo
435           INTO l_bill_to_site_use_id,
436             l_bill_to_address_id,
437             l_bill_to_customer_id,
438             l_bill_to_postal_code,
439             l_bill_to_customer_name,
440             l_bill_to_customer_number,
441             l_bill_party_id,
442             l_bill_party_site_id,
443             l_bill_location_id;
444           IF l_debug_level > 0 THEN
445             oe_debug_pub.add('om_tax_line  9' , 4);
446           END IF;
447           ship_bill_records_tab(pr_index).site_use_id     := l_bill_to_site_use_id;
448           ship_bill_records_tab(pr_index).acct_site_id    := l_bill_to_address_id;
449           ship_bill_records_tab(pr_index).cust_acct_id    := l_bill_to_customer_id;
450           ship_bill_records_tab(pr_index).postal_code     := l_bill_to_postal_code;
451           ship_bill_records_tab(pr_index).customer_name   := l_bill_to_customer_name;
452           ship_bill_records_tab(pr_index).customer_number := l_bill_to_customer_number;
453           ship_bill_records_tab(pr_index).party_id        := l_bill_party_id;
454           ship_bill_records_tab(pr_index).party_site_id   := l_bill_party_site_id;
455           ship_bill_records_tab(pr_index).location_id     := l_bill_location_id;
456           CLOSE getlocinfo;
457         END IF;
458       EXCEPTION
459       WHEN no_data_found THEN
460         IF l_debug_level > 0 THEN
461           oe_debug_pub.add('om_tax_line  10' , 1);
462         END IF;
463         CLOSE getlocinfo;
464       END;
465     END IF;
466     OPEN get_internal_loc(l_header_Rec.org_id );
467     FETCH get_internal_loc INTO l_internal_org_location_id;
468     CLOSE get_internal_loc;
469     IF l_level = 'L' THEN
470       BEGIN
471         -- assign values from l_line_rec
472         l_header_id                             := l_line_rec.header_id;
473         l_tax_date                              := l_line_rec.tax_date;
474         /* added for Bug#12598464 */
475         IF l_line_rec.LINE_CATEGORY_CODE = 'RETURN'
476         THEN
477         l_ordered_quantity                      := l_line_rec.ordered_quantity * -1;
478         ELSE
479         l_ordered_quantity                      := l_line_rec.ordered_quantity;
480          END IF;
481         /* End for bug#12598464  */
482         --12598464 l_ordered_quantity                      := l_line_rec.ordered_quantity;
483         l_unit_selling_price                    := l_line_rec.unit_selling_price;
484         l_tax_exempt_number                     := l_line_rec.tax_exempt_number;
485         l_tax_exempt_reason                     := l_line_rec.tax_exempt_reason_code;
486         l_inventory_item_id                     := l_line_rec.inventory_item_id;
487         l_ship_from_org_id                      := l_line_rec.ship_from_org_id;
488         l_fob_point_code                        := l_line_rec.fob_point_code;
489         l_tax_code                              := l_line_rec.tax_code;
490         l_trx_shipping_date                     := NVL(l_line_rec.actual_shipment_date, l_line_rec.schedule_ship_date);
491         l_uom_code                              := NVL(l_line_rec.order_quantity_uom, l_line_rec.pricing_quantity_uom);
492         l_trx_line_number                       := l_line_rec.line_number;
493         l_user_item_description                 := l_line_rec.user_item_description;
494         l_salesrep_id                           := l_line_rec.salesrep_id;
495         l_org_id                                := l_line_rec.org_id;
496         IF l_line_rec.global_attribute_category IN ('JL.AR.OEXOEORD.LINES', 'JL.BR.OEXOEORD.LINES', 'JL.CO.OEXOEORD.LINES') THEN
497           l_trx_business_category               := l_line_rec.global_attribute6;
498           l_product_fisc_classification         := l_line_rec.global_attribute5;
499         ELSE
500           l_trx_business_category       := NULL;
501           l_product_fisc_classification := NULL;
502         END IF;
503       END;
504     elsif l_level = 'H' THEN
505 oe_debug_pub.ADD('populating header level details', 5);
506 
507       -- assign values from l_header_rec
508       l_header_id                   := l_header_rec.header_id;
509       l_tax_date                    := sysdate;
510       l_ordered_quantity            := NULL;
511       l_unit_selling_price          := NULL;
512       l_tax_exempt_number           := NULL;
513       l_tax_exempt_reason           := NULL;
514       l_inventory_item_id           := NULL;
515       l_ship_from_org_id            := l_header_rec.ship_from_org_id;
516       l_fob_point_code              := l_header_rec.fob_point_code;
517       l_tax_code                    := NULL;
518       l_trx_shipping_date           := NULL;
519       l_uom_code                    := NULL;
520       l_trx_line_number             := NULL;
521       l_user_item_description       := NULL;
522       l_trx_business_category       := NULL;
523       l_product_fisc_classification := NULL;
524       l_salesrep_id                 := l_header_rec.salesrep_id;
525       l_org_id                      := l_header_rec.org_id;
526     END IF;
527     IF l_debug_level > 0 THEN
528       oe_debug_pub.add('trx business:'||l_trx_business_category,3);
529     END IF;
530     /* per bug 5193035:OM should not pass product_type, otherwise other product category etc won't default*/
531     l_product_type         := NULL;
532     IF (l_ship_from_org_id IS NOT NULL AND l_ship_from_org_id <> FND_API.G_MISS_NUM) THEN
533       BEGIN
534         SELECT location_id
535         INTO l_ship_from_location_id
536         FROM hr_all_organization_units hu
537         WHERE hu.organization_id = l_ship_from_org_id;
538       EXCEPTION
539       WHEN OTHERS THEN
540         NULL;
541       END;
542     END IF;
543     IF l_salesrep_id IS NOT NULL THEN
544       IF NOT (OE_GLOBALS.Equal(l_salesrep_id, G_SALESREP_ID) AND OE_Globals.Equal(l_header_org_id, G_SALESREP_POA_ID)) THEN
545         -- fetch and cache salerep info
546         BEGIN
547           G_SALESREP_ID     := l_salesrep_id;
548           G_SALESREP_POA_ID := l_header_org_id;
549           IF l_debug_level   > 0 THEN
550             oe_debug_pub.add('om_tax_line, need to query  poo for salesrep'||l_salesrep_id , 4);
551           END IF;
552           SELECT ASGN.ORGANIZATION_ID ,
553             hou.location_id
554           INTO l_poo_party_id ,
555             l_poo_location_id
556           FROM RA_SALESREPS_ALL sales ,
557             PER_ALL_ASSIGNMENTS_F ASGN ,
558             hr_organization_units hou
559           WHERE ASGN.PERSON_ID            = sales.PERSON_ID
560           AND sales.salesrep_id           = l_salesrep_id
561           AND sales.org_id                = l_header_org_id
562           AND NVL(ASGN.PRIMARY_FLAG, 'Y') = 'Y'
563           AND hou.organization_id         = ASGN.ORGANIZATION_ID
564           AND l_TAX_DATE BETWEEN NVL(ASGN.EFFECTIVE_START_DATE,TO_DATE( '01011900' , 'DDMMYYYY')) AND NVL(ASGN.EFFECTIVE_END_DATE,TO_DATE( '31122199', 'DDMMYYYY'))
565           AND ASSIGNMENT_TYPE = 'E';
566           G_POO_PARTY_ID     := l_poo_party_id;
567           G_POO_LOCATION_ID  := l_poo_location_id;
568         EXCEPTION
569         WHEN NO_DATA_FOUND THEN
570           IF l_debug_level > 0 THEN
571             oe_debug_pub.add('om_tax_line  9' , 1);
572           END IF;
573           G_POO_PARTY_ID    := NULL;
574           G_POO_LOCATION_ID := NULL;
575         END;
576       ELSE -- get cached values
577         IF l_debug_level > 0 THEN
578           oe_debug_pub.add('om_tax_line  getting poo from cache for salesrep:'||l_line_rec.salesrep_id , 4);
579         END IF;
580         l_poo_party_id    := G_POO_PARTY_ID;
581         l_poo_location_id := G_POO_LOCATION_ID;
582       END IF; -- if cached
583     END IF;   -- if p_salerep_id is not null
584     --bug7228640
585     IF l_debug_level > 0 THEN
586       oe_debug_pub.add('om_tax_line  13' , 4);
587       oe_debug_pub.add('l_poo_party_id: '|| l_poo_party_id , 4);
588     END IF;
589     BEGIN
590       SELECT location_id
591       INTO l_bill_from_location_id
592       FROM HR_ALL_ORGANIZATION_UNITS
593       WHERE organization_id = l_header_rec.org_id ;
594     EXCEPTION
595     WHEN OTHERS THEN
596       l_bill_from_location_id := NULL;
597     END;
598     l_legal_entity_id   := get_le_id(p_order_type_id => l_header_rec.order_type_id , p_sold_to_customer_id => l_header_rec.sold_to_org_id , p_bill_to_customer_id => l_bill_to_customer_id , p_org_id => l_header_rec.org_id );
599     IF l_legal_entity_id = -1 THEN
600       RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601     END IF;
602     IF l_level     = 'H' THEN
603       l_charge_tbl:= get_charge_details(p_header_id=>l_header_rec.header_id, p_line_id=>NULL);
604       FOR j       IN 1..l_charge_tbl.count
605       LOOP
606         -- Initialising zx_global_structures_pkg.init_trx_line_dist_tbl for header charges
607         IF ( NOT ( l_header_rec.header_id IS NULL OR l_charge_tbl(j).charge_id IS NULL OR
608             --p_ship_to_org_id is null OR   /*commented for the bug#3336052*/
609             l_charge_tbl(j).charge_amount IS NULL)
610           -- OR
611           -- l_line_rec.tax_code is null)
612           ) THEN
613           l_call_tax := 'Y';
614           zx_global_structures_pkg.init_trx_line_dist_tbl(k);
615           zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID(k)           := 660;
616           zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE(k)              := l_entity_code_crsr;
617           zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE(k)         := l_event_class_code_crsr;
618           zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(k)                   := L_HEADER_ID;
619           zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(k)           := 'FREIGHT_CHARGE';
620           zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(k) := l_header_rec.org_id;
621           zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE(k)          := 'CREATE';
622           -- bug 4700796
623           IF l_header_rec.transaction_phase_code = 'N' THEN
624             l_trx_date                          := l_header_rec.quote_date;
625           ELSE
626             l_trx_date :=l_header_rec.ordered_date;
627           END IF;
628           zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(k)                 := l_trx_date;
629           zx_global_structures_pkg.trx_line_dist_tbl.TRX_DOC_REVISION(k)         := NULL; --   VARCHAR2_150_tbl_type  ,
630           zx_global_structures_pkg.trx_line_dist_tbl.LEDGER_ID(k)                := l_AR_Sys_Param_Rec.set_of_books_id;
631           zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(k)        := l_header_rec.TRANSACTIONAL_CURR_CODE;
632           zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(k) := l_header_rec.CONVERSION_RATE_DATE;
633           zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(k) := l_header_rec.CONVERSION_RATE;
634           zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(k) := l_header_rec.CONVERSION_TYPE_CODE;
635           zx_global_structures_pkg.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(k) := l_minimum_accountable_unit;
636           zx_global_structures_pkg.trx_line_dist_tbl.PRECISION(k)                := l_precision;
637           -- revisit the logic to derive legal_entity_id later when legal_entity_id approach is clarified.
638           zx_global_structures_pkg.trx_line_dist_tbl.LEGAL_ENTITY_ID(k)               := l_legal_entity_id; --   NUMBER_tbl_type        ,
639           zx_global_structures_pkg.trx_line_dist_tbl.ESTABLISHMENT_ID(k)              := NULL;              --   NUMBER_tbl_type        ,
640           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER(k)       := NULL;              --   VARCHAR2_150_tbl_type  ,
641           zx_global_structures_pkg.trx_line_dist_tbl.TRX_NUMBER(k)                    := l_header_Rec.order_number;
642           zx_global_structures_pkg.trx_line_dist_tbl.TRX_DESCRIPTION(k)               := NULL; --   VARCHAR2_240_tbl_type  ,
643           zx_global_structures_pkg.trx_line_dist_tbl.TRX_COMMUNICATED_DATE(k)         := NULL; --   DATE_tbl_type          ,
644           zx_global_structures_pkg.trx_line_dist_tbl.BATCH_SOURCE_ID(k)               := NULL; --   NUMBER_tbl_type        ,
645           zx_global_structures_pkg.trx_line_dist_tbl.BATCH_SOURCE_NAME(k)             := NULL; --   VARCHAR2_150_tbl_type  ,
646           zx_global_structures_pkg.trx_line_dist_tbl.DOC_SEQ_ID(k)                    := NULL; --   NUMBER_tbl_type        ,
647           zx_global_structures_pkg.trx_line_dist_tbl.DOC_SEQ_NAME(k)                  := NULL; --   VARCHAR2_150_tbl_type  ,
648           zx_global_structures_pkg.trx_line_dist_tbl.DOC_SEQ_VALUE(k)                 := NULL; --   VARCHAR2_240_tbl_type  ,
649           zx_global_structures_pkg.trx_line_dist_tbl.TRX_DUE_DATE(k)                  := NULL; --   DATE_tbl_type          ,
650           zx_global_structures_pkg.trx_line_dist_tbl.TRX_TYPE_DESCRIPTION(k)          := NULL; --   VARCHAR2_240_tbl_type  ,
651           zx_global_structures_pkg.trx_line_dist_tbl.FIRST_PTY_ORG_ID(k)              := NULL; --   NUMBER_tbl_type        ,
652           zx_global_structures_pkg.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID(k)       := l_cust_trx_type_id;
653           zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE(k)          := NULL; --   VARCHAR2_30_tbl_type   ,
654           zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_TYPE_CODE(k)           := NULL; --   VARCHAR2_30_tbl_type   ,
655           zx_global_structures_pkg.trx_line_dist_tbl.DOC_EVENT_STATUS(k)              := NULL; --   VARCHAR2_30_tbl_type   ,
656           zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(k)             := NULL; --   VARCHAR2_240_tbl_type  ,
657           zx_global_structures_pkg.trx_line_dist_tbl.SUPPLIER_TAX_INVOICE_NUMBER(k)   := NULL; --   VARCHAR2_150_tbl_type  ,
658           zx_global_structures_pkg.trx_line_dist_tbl.SUPPLIER_TAX_INVOICE_DATE(k)     := NULL; --   DATE_tbl_type          ,
659           zx_global_structures_pkg.trx_line_dist_tbl.SUPPLIER_EXCHANGE_RATE(k)        := NULL; --   NUMBER_tbl_type        ,
660           zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE(k)              := NULL; --   DATE_tbl_type          ,
661           zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER(k)            := NULL; --   VARCHAR2_150_tbl_type  ,
662           zx_global_structures_pkg.trx_line_dist_tbl.QUOTE_FLAG(k)                    := 'Y';  --   VARCHAR2_1_tbl_type   ,
663           zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(k)      := NULL; --   VARCHAR2_2_tbl_type   ,
664           zx_global_structures_pkg.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(k)         := NULL; --   VARCHAR2_1_tbl_type    ,
665           zx_global_structures_pkg.trx_line_dist_tbl.CTRL_TOTAL_HDR_TX_AMT(k)         := NULL; --   NUMBER_tbl_type        ,
666           zx_global_structures_pkg.trx_line_dist_tbl.PORT_OF_ENTRY_CODE(k)            := NULL; --   VARCHAR2_30_tbl_type,
667           zx_global_structures_pkg.trx_line_dist_tbl.TAX_REPORTING_FLAG(k)            := 'N';  --   VARCHAR2_1_tbl_type,
668           zx_global_structures_pkg.trx_line_dist_tbl.TAX_AMT_INCLUDED_FLAG(k)         := NULL; --   VARCHAR2_1_tbl_type ,
669           zx_global_structures_pkg.trx_line_dist_tbl.COMPOUNDING_TAX_FLAG(k)          := NULL; --   VARCHAR2_1_tbl_type,
670           zx_global_structures_pkg.trx_line_dist_tbl.PROVNL_TAX_DETERMINATION_DATE(k) := NULL; --   DATE_tbl_type,
671           zx_global_structures_pkg.trx_line_dist_tbl.INSERT_UPDATE_FLAG(k)            := NULL; --   VARCHAR2_1_tbl_type,
672           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_NUMBER(k)         := NULL; --   VARCHAR2_150_tbl_type,
673           zx_global_structures_pkg.trx_line_dist_tbl.START_EXPENSE_DATE(k)            := NULL; --   DATE_tbl_type,
674           zx_global_structures_pkg.trx_line_dist_tbl.TRX_BATCH_ID(k)                  := NULL; --   NUMBER_tbl_type,
675           zx_global_structures_pkg.trx_line_dist_tbl.RECORD_TYPE_CODE(k)              := NULL; --   VARCHAR2_30_tbl_type,
676           zx_global_structures_pkg.trx_line_dist_tbl.TAX_PROCESSING_COMPLETED_FLAG(k) := NULL; --   VARCHAR2_1_tbl_type,
677           zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_DOC_STATUS(k)        := NULL; --   VARCHAR2_30_tbl_type,
678           zx_global_structures_pkg.trx_line_dist_tbl.OVERRIDING_RECOVERY_RATE(k)      := NULL; --   NUMBER_tbl_type,
679           zx_global_structures_pkg.trx_line_dist_tbl.TAX_CALCULATION_DONE_FLAG(k)     := NULL; --   VARCHAR2_1_tbl_type,
680           zx_global_structures_pkg.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG(k)     := NULL; --   VARCHAR2_1_tbl_type,
681           zx_global_structures_pkg.trx_line_dist_tbl.ICX_SESSION_ID(k)                := NULL; --   NUMBER_tbl_type
682           -- line level columns
683           --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CODE(k)            := NULL; --   VARCHAR2_15_tbl_type   ,
684           --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_DATE(k)       := NULL; --   DATE_tbl_type          ,
685           --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_RATE(k)       := NULL; --   NUMBER_tbl_type        ,
686           --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_TYPE(k)       := NULL; --   VARCHAR2_30_tbl_type   ,
687           --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_MAU(k)                      := NULL; --   NUMBER_tbl_type        ,
688           --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_PRECISION(k)                := NULL; --   NUMBER_tbl_type        ,
689           zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(k)             := NULL; --   VARCHAR2_240_tbl_type   ,
690           zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(k) := NULL; --   VARCHAR2_30_tbl_type   ,
691           zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(k)        := l_header_rec.TAX_EXEMPT_FLAG;
692           zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(k)            := l_header_rec.TAX_EXEMPT_REASON_CODE;
693           zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_ENTITY_CODE(k)         := NULL; --   VARCHAR2_30_tbl_type,
694           zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_LINE_ID(k)             := NULL; --   NUMBER_tbl_type,
695           zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_TAX_CODE_ID(k)        := NULL; --   NUMBER_tbl_type,
696           zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(k)                   := l_charge_tbl(j).charge_id;
697           zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(k)                    := 'INVOICE';
698           zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(k)             := 'CREATE';
699           zx_global_structures_pkg.trx_line_dist_tbl.TRX_SHIPPING_DATE(k)             := l_trx_shipping_date;
700           zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(k)              := NULL ;
701           zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_TYPE(k)                 := 'LINE';
702           zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(k)                 := l_tax_date;
703           zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(k)         := l_trx_business_category;
704           zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(k)             := NULL;
705           zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS(k)       := NULL;
706           zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(k)    := 'S';
707           --8431420 zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(k) := l_ordered_quantity*l_unit_selling_price;
708           zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(k)                   := l_charge_tbl(j).charge_amount;
709           --TaxER zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(k)          := l_ordered_quantity;
710           zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(k)          := 1;  --TaxER
711           --TaxER zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(k)                 := l_unit_selling_price;
712           zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(k)                 := l_charge_tbl(j).charge_amount;  --TaxER
713           zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(k)  := l_tax_exempt_number;
714           zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(k)              := l_tax_exempt_reason;
715           zx_global_structures_pkg.trx_line_dist_tbl.CASH_DISCOUNT(k)              := NULL;
716           zx_global_structures_pkg.trx_line_dist_tbl.VOLUME_DISCOUNT(k)            := NULL;
717           zx_global_structures_pkg.trx_line_dist_tbl.TRADING_DISCOUNT(k)           := NULL;
718           zx_global_structures_pkg.trx_line_dist_tbl.TRANSFER_CHARGE(k)            := NULL ;
719           zx_global_structures_pkg.trx_line_dist_tbl.TRANSPORTATION_CHARGE(k)      := NULL;
720           zx_global_structures_pkg.trx_line_dist_tbl.INSURANCE_CHARGE(k)           := NULL;
721           zx_global_structures_pkg.trx_line_dist_tbl.OTHER_CHARGE(k)               := NULL;
722           zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(k)                 := l_inventory_item_id;
723           zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(k):= l_product_fisc_classification;
724           zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(k)             := NVL(l_ship_from_org_id,l_inventory_org_id); --bug7456264
725           zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(k)                   := l_uom_code;
726           IF l_inventory_item_id                                                   IS NULL THEN
727             zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k)             := NULL;
728           ELSE
729             -- this should be GOODS/SERVICES based on zx_product_types_def_v.
730             -- to be changed when zx_product_types_def_v is available.
731             zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := l_product_type;
732           END IF;
733           zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(k)                   := l_product_code;
734           zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(k)               := NULL;
735           zx_global_structures_pkg.trx_line_dist_tbl.TRX_SIC_CODE(k)                   := NULL ;
736           zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(k)                      := l_fob_point_code;
737           zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_ID(k)               := l_ship_party_id;    --1001;
738           zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(k)             := l_ship_from_org_id; -- Bug 7532302
739           zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_ID(k)                   := l_header_org_id;
740           zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_ID(k)                   := l_poo_party_id;
741           zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_ID(k)               := l_bill_party_id; --1001;
742           zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_ID(k)             := NULL;
743           zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_ID(k)              := NULL;
744           zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID(k)          := l_ship_party_site_id;--1024;
745           zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_SITE_ID(k)        := NULL;
746           zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_SITE_ID(k)              := NULL ;
747           zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_SITE_ID(k)              := NULL ;
748           zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_SITE_ID(k)          := l_bill_party_site_id; --1024;
749           zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_SITE_ID(k)        := NULL;
750           zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(k)            := l_ship_location_id;--1067;
751           zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(k)          := l_ship_from_location_id;
752           zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(k)                := l_internal_org_location_id;
753           zx_global_structures_pkg.trx_line_dist_tbl.POO_LOCATION_ID(k)                := l_poo_location_id ;
754           zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(k)            := l_bill_location_id;      --1067;
755           zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(k)          := l_bill_from_location_id; --bug7228640
756           zx_global_structures_pkg.trx_line_dist_tbl.ACCOUNT_CCID(k)                   := NULL;
757           zx_global_structures_pkg.trx_line_dist_tbl.ACCOUNT_STRING(k)                 := NULL;
758           zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_COUNTRY(k)         := NULL;
759           zx_global_structures_pkg.trx_line_dist_tbl.ASSET_FLAG(k)                     := NULL;
760           zx_global_structures_pkg.trx_line_dist_tbl.ASSET_NUMBER(k)                   := NULL;
761           zx_global_structures_pkg.trx_line_dist_tbl.ASSET_ACCUM_DEPRECIATION(k)       := NULL;
762           zx_global_structures_pkg.trx_line_dist_tbl.ASSET_TYPE(k)                     := NULL;
763           zx_global_structures_pkg.trx_line_dist_tbl.ASSET_COST(k)                     := NULL;
764           zx_global_structures_pkg.trx_line_dist_tbl.DIST_LEVEL_ACTION(k)              := NULL; --   VARCHAR2_30_tbl_type   ,
765           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TAX_DIST_ID(k)       := NULL; --   NUMBER_tbl_type        ,
766           zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TAX_DIST_ID(k)       := NULL; --   NUMBER_tbl_type        ,
767           zx_global_structures_pkg.trx_line_dist_tbl.TASK_ID(k)                        := NULL; --   NUMBER_tbl_type        ,
768           zx_global_structures_pkg.trx_line_dist_tbl.AWARD_ID(k)                       := NULL; --   NUMBER_tbl_type        ,
769           zx_global_structures_pkg.trx_line_dist_tbl.PROJECT_ID(k)                     := NULL; --   NUMBER_tbl_type        ,
770           zx_global_structures_pkg.trx_line_dist_tbl.EXPENDITURE_TYPE(k)               := NULL; --   VARCHAR2_30_tbl_type   ,
771           zx_global_structures_pkg.trx_line_dist_tbl.EXPENDITURE_ORGANIZATION_ID(k)    := NULL; --   NUMBER_tbl_type        ,
772           zx_global_structures_pkg.trx_line_dist_tbl.EXPENDITURE_ITEM_DATE(k)          := NULL; --   DATE_tbl_type          ,
773           zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_AMT(k)              := NULL; --   NUMBER_tbl_type        ,
774           zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_QUANTITY(k)         := NULL; --   NUMBER_tbl_type        ,
775           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_CURR_CONV_RATE(k)         := NULL; --   NUMBER_tbl_type        ,
776           zx_global_structures_pkg.trx_line_dist_tbl.ITEM_DIST_NUMBER(k)               := NULL; --   NUMBER_tbl_type        ,
777           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_DIST_ID(k)                := NULL; --   NUMBER_tbl_type        ,
778           zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_TAX_AMT(k)          := NULL; --   NUMBER_tbl_type        ,
779           zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE(k)               := NULL ;
780           zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(k) := l_tax_code;
781           zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL2(k)                  := NULL;
782           zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL3(k)                  := NULL;
783           zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL4(k)                  := NULL;
784           zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL5(k)                  := NULL;
785           zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL6(k)                  := NULL;
786           zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY1(k)              := NULL;
787           zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY2(k)              := NULL;
788           zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY3(k)              := NULL;
789           zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY4(k)              := NULL;
790           zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY5(k)              := NULL;
791           zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY6(k)              := NULL;
792           zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY1(k)             := NULL;
793           zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY2(k)             := NULL;
794           zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY3(k)             := NULL;
795           zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY4(k)             := NULL;
796           zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY5(k)             := NULL;
797           zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY6(k)             := NULL;
798           zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(k)                := l_trx_line_number;
799           zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_ID(k)               := NULL;
800           zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY1(k)             := NULL;
801           zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY2(k)             := NULL;
802           zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY3(k)             := NULL;
803           zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY4(k)             := NULL;
804           zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY5(k)             := NULL;
805           zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY6(k)             := NULL;
806           zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_FLAG(k)                :='N';
807           zx_global_structures_pkg.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(k)          :='N';
808           zx_global_structures_pkg.trx_line_dist_tbl.CTRL_TOTAL_LINE_TX_AMT(k)         :=NULL;
809           zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(k)           := substrb(l_user_item_description,1,240); --bug9293783
810           zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(k)            := substrb(l_user_item_description,1,240); --bug9293783
811           zx_global_structures_pkg.trx_line_dist_tbl.TRX_WAYBILL_NUMBER(k)             := NULL;
812           zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_GL_DATE(k)               := NULL;
813           zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_NAME(k)            := NULL;
814           zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_DOCUMENT_NUMBER(k) := NULL;
815           zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_REFERENCE(k)       := NULL;
816           zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAXPAYER_ID(k)     := NULL;
817           zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAX_REG_NUMBER(k)  := NULL;
818           zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_ID(k)                := NULL;
819           zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_ID(k)                := NULL;
820           zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_ID(k)            := NULL;
821           zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_ID(k)                   := NULL;
822           zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_ID(k)                   := NULL;
823           zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_ID(k)        := NULL;
824           zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_SITE_ID(k)           := NULL;
825           zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_SITE_ID(k)           := NULL;
826           zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_SITE_ID(k)       := NULL;
827           zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_SITE_ID(k)              := NULL;
828           zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_SITE_ID(k)              := NULL;
829           zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_SITE_ID(k)   := NULL;
830           zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(k)             := NULL;
831           zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(k)             := NULL;
832           zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(k)         := NULL;
833           zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(k)                := NULL;
834           zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(k)                := NULL;
835           zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(k)                := NULL;
836           zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID(k)     := NULL;
837           -- Rounding parties not required for OM. No override of rounding level
838           zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_SHIP_TO_PARTY_ID(k)   := NULL;
839           zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_SHIP_FROM_PARTY_ID(k) := NULL;
840           zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_BILL_TO_PARTY_ID(k)   := NULL;
841           zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_BILL_FROM_PARTY_ID(k) := NULL;
842           zx_global_structures_pkg.trx_line_dist_tbl.RNDG_SHIP_TO_PARTY_SITE_ID(k)  := NULL;
843           zx_global_structures_pkg.trx_line_dist_tbl.RNDG_SHIP_FROM_PARTY_SITE_ID(k):= NULL;
844           zx_global_structures_pkg.trx_line_dist_tbl.RNDG_BILL_TO_PARTY_SITE_ID(k)  := NULL;
845           zx_global_structures_pkg.trx_line_dist_tbl.RNDG_BILL_FROM_PARTY_SITE_ID(k):= NULL;
846           -- Ref_doc, applied_from, applied_to, related_doc are not applicable for OM
847           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_APPLICATION_ID(k)        := NULL;
848           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_ENTITY_CODE(k)           := NULL;
849           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_EVENT_CLASS_CODE(k)      := NULL;
850           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_TRX_ID(k)                := NULL;
851           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY1(k)     := NULL;
852           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY2(k)     := NULL;
853           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY3(k)     := NULL;
854           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY4(k)     := NULL;
855           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY5(k)     := NULL;
856           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY6(k)     := NULL;
857           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LINE_ID(k)               := NULL;
858           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY1(k)     := NULL;
859           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY2(k)     := NULL;
860           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY3(k)     := NULL;
861           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY4(k)     := NULL;
862           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY5(k)     := NULL;
863           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY6(k)     := NULL;
864           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LINE_QUANTITY(k)         := NULL;
865           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_APPLICATION_ID(k)   := NULL;
866           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_ENTITY_CODE(k)      := NULL;
867           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_EVENT_CLASS_CODE(k) := NULL;
868           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_ID(k)           := NULL;
869           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY1(k)    := NULL;
870           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY2(k)    := NULL;
871           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY3(k)    := NULL;
872           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY4(k)    := NULL;
873           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY5(k)    := NULL;
874           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY6(k)    := NULL;
875           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_LINE_ID(k)          := NULL;
876           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY1(k)    := NULL;
877           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY2(k)    := NULL;
878           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY3(k)    := NULL;
879           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY4(k)    := NULL;
880           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY5(k)    := NULL;
881           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY6(k)    := NULL;
882           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_DIST_ID(k)          := NULL;
883           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY1(k)    := NULL;
884           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY2(k)    := NULL;
885           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY3(k)    := NULL;
886           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY4(k)    := NULL;
887           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY5(k)    := NULL;
888           zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY6(k)    := NULL;
889           zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_APPLICATION_ID(k)   := NULL;
890           zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_ENTITY_CODE(k)      := NULL;
891           zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE(k) := NULL;
892           zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TRX_ID(k)           := NULL ;
893           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY1(k)     := NULL;
894           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY2(k)     := NULL;
895           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY3(k)     := NULL;
896           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY4(k)     := NULL;
897           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY5(k)     := NULL;
898           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY6(k)     := NULL;
899           zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_LINE_ID(k)          := NULL;
900           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY1(k)     := NULL;
901           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY2(k)     := NULL;
902           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY3(k)     := NULL;
903           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY4(k)     := NULL;
904           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY5(k)     := NULL;
905           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY6(k)     := NULL;
906           zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_DIST_ID(k)          := NULL;
907           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY1(k)     := NULL;
908           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY2(k)     := NULL;
909           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY3(k)     := NULL;
910           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY4(k)     := NULL;
911           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY5(k)     := NULL;
912           zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY6(k)     := NULL;
913           zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_NUMBER(k)           := NULL;
914           zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_DATE(k)             := NULL;
915           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_APPLICATION_ID(k)     := NULL;
916           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_ENTITY_CODE(k)        := NULL;
917           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_EVENT_CLASS_CODE(k)   := NULL;
918           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_ID(k)             := NULL;
919           zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY1(k)      := NULL;
920           zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY2(k)      := NULL;
921           zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY3(k)      := NULL;
922           zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY4(k)      := NULL;
923           zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY5(k)      := NULL;
924           zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY6(k)      := NULL;
925           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_LINE_ID(k)        := NULL;
926           zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY1(k)      := NULL;
927           zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY2(k)      := NULL;
928           zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY3(k)      := NULL;
929           zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY4(k)      := NULL;
930           zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY5(k)      := NULL;
931           zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY6(k)      := NULL;
932           zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_APPLICATION_ID(k)    := NULL;
933           zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_ENTITY_CODE(k)       := NULL;
934           zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_EVENT_CLASS_CODE(k)  := NULL;
935           zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_TRX_ID(k)            := NULL;
936           zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY1(k)     := NULL;
937           zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY2(k)     := NULL;
938           zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY3(k)     := NULL;
939           zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY4(k)     := NULL;
940           zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY5(k)     := NULL;
941           zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY6(k)     := NULL;
942           zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_NUMBER(k)            := NULL;
943           zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_DATE(k)              := NULL;
944           zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_APPLN_ID(k)             := NULL;
945           zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_ENTITY_CODE(k)          := NULL;
946           zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_EVNT_CLS_CODE(k)        := NULL;
947           zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_TRX_ID(k)               := NULL;
948           zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_TRX_LEVEL_TYPE(k)       := NULL;
949           zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_TRX_LINE_ID(k)          := NULL;
950           zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC1(k)                      := NULL;
951           zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC2(k)                      := NULL;
952           zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC3(k)                      := NULL;
953           zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC4(k)                      := NULL;
954           zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC5(k)                      := NULL;
955           zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC6(k)                      := NULL;
956           zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC7(k)                      := NULL;
957           zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC8(k)                      := NULL;
958           zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC9(k)                      := NULL;
959           zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC10(k)                     := NULL;
960           zx_global_structures_pkg.trx_line_dist_tbl.CHAR1(k)                         := NULL;
961           zx_global_structures_pkg.trx_line_dist_tbl.CHAR2(k)                         := NULL;
962           zx_global_structures_pkg.trx_line_dist_tbl.CHAR3(k)                         := NULL;
963           zx_global_structures_pkg.trx_line_dist_tbl.CHAR4(k)                         := NULL;
964           zx_global_structures_pkg.trx_line_dist_tbl.CHAR5(k)                         := NULL;
965           zx_global_structures_pkg.trx_line_dist_tbl.CHAR6(k)                         := NULL;
966           zx_global_structures_pkg.trx_line_dist_tbl.CHAR7(k)                         := NULL;
967           zx_global_structures_pkg.trx_line_dist_tbl.CHAR8(k)                         := NULL;
968           zx_global_structures_pkg.trx_line_dist_tbl.CHAR9(k)                         := NULL;
969           zx_global_structures_pkg.trx_line_dist_tbl.CHAR10(k)                        := NULL;
970           zx_global_structures_pkg.trx_line_dist_tbl.DATE1(k)                         := NULL;
971           zx_global_structures_pkg.trx_line_dist_tbl.DATE2(k)                         := NULL;
972           zx_global_structures_pkg.trx_line_dist_tbl.DATE3(k)                         := NULL;
973           zx_global_structures_pkg.trx_line_dist_tbl.DATE4(k)                         := NULL;
974           zx_global_structures_pkg.trx_line_dist_tbl.DATE5(k)                         := NULL;
975           zx_global_structures_pkg.trx_line_dist_tbl.DATE6(k)                         := NULL;
976           zx_global_structures_pkg.trx_line_dist_tbl.DATE7(k)                         := NULL;
977           zx_global_structures_pkg.trx_line_dist_tbl.DATE8(k)                         := NULL;
978           zx_global_structures_pkg.trx_line_dist_tbl.DATE9(k)                         := NULL;
979           zx_global_structures_pkg.trx_line_dist_tbl.DATE10(k)                        := NULL;
980           zx_global_structures_pkg.trx_line_dist_tbl.internal_org_location_id(k)      := l_internal_org_location_id;
981           zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_APPLICATION_ID(k)         := NULL;
982           zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_ENTITY_CODE(k)            := NULL;
983           zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_EVENT_CLASS_CODE(k)       := NULL;
984           zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TRX_ID(k)                 := NULL;
985           zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_LINE_ID(k)                := NULL;
986           zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TRX_LEVEL_TYPE(k)         := NULL;
987           zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_TRX_LEVEL_TYPE(k)        := NULL;
988           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_LEVEL_TYPE(k)     := NULL;
989           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_LEVEL_TYPE(k)   := NULL;
990           zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TRX_LEVEL_TYPE(k)   := NULL;
991           zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE1(k)         := 'N';
992           zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE2(k)         := NULL;
993           zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE3(k)         := NULL;
994           zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE4(k)         := NULL;
995           zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE5(k)         := NULL;
996           zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE6(k)         := NULL;
997           zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE7(k)         := NULL;
998           zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE8(k)         := NULL;
999           zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE9(k)         := NULL;
1000           zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE10(k)        := NULL;
1001           zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TAX_LINE_ID(k)            := NULL;
1002           zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER(k)       := NULL;
1003           zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(k)   := l_SHIP_TO_ADDRESS_ID; --1024;
1004           zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID(k)   := l_BILL_TO_ADDRESS_ID; --1024;
1005           zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(k) := l_SHIP_TO_SITE_USE_ID;--1007;
1006           zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(k) := l_BILL_TO_SITE_USE_ID;--1006;
1007           zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(k)        := l_SHIP_TO_CUSTOMER_ID;--1001;
1008           zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID(k)        := l_BILL_TO_CUSTOMER_ID;--1001;
1009           --populating om_tax_info_rec_tbl record
1010           om_tax_info_rec_tbl(p).trx_id        := l_header_rec.header_id;
1011           om_tax_info_rec_tbl(p).trx_line_id   := l_charge_tbl(j).charge_id;
1012           om_tax_info_rec_tbl(p).line_id       := NULL;
1013           om_tax_info_rec_tbl(p).trx_level_type:= 'FREIGHT_CHARGE';
1014           IF l_debug_level > 0 THEN
1015           oe_debug_pub.add('zx_global_structures_pkg.trx_line_dist_tbl parameters for Header level charges' , 1);
1016           debug_msg(k, x_return_status);
1017            END IF;
1018           k                                    := k+1;
1019           p                                    := p+1;
1020         END IF;
1021 
1022       END LOOP;
1023     elsif l_level = 'L' THEN
1024       -- Initialising zx_global_structures_pkg.init_trx_line_dist_tbl for Line
1025       IF ( NOT ( l_line_rec.header_id IS NULL OR l_line_rec.inventory_item_id IS NULL OR
1026           --p_ship_to_org_id is null OR   /*commented for the bug#3336052*/
1027           l_line_rec.unit_selling_price IS NULL)
1028         -- OR
1029         -- l_line_rec.tax_code is null)
1030         ) THEN
1031         l_call_tax := 'Y';
1032         zx_global_structures_pkg.init_trx_line_dist_tbl(k);
1033         zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID(k)           := 660;
1034         zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE(k)              := l_entity_code_crsr;
1035         zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE(k)         := l_event_class_code_crsr;
1036         zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(k)                   := L_HEADER_ID;
1037         zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(k)           := 'LINE';
1038         zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(k) := l_header_rec.org_id;
1039         zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE(k)          := 'CREATE';
1040         -- bug 4700796
1041         IF l_header_rec.transaction_phase_code = 'N' THEN
1042           l_trx_date                          := l_header_rec.quote_date;
1043         ELSE
1044           l_trx_date := l_header_rec.ordered_date;
1045         END IF;
1046         zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(k)                 := l_trx_date;
1047         zx_global_structures_pkg.trx_line_dist_tbl.TRX_DOC_REVISION(k)         := NULL; --   VARCHAR2_150_tbl_type  ,
1048         zx_global_structures_pkg.trx_line_dist_tbl.LEDGER_ID(k)                := l_AR_Sys_Param_Rec.set_of_books_id;
1049         zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(k)        := l_header_rec.TRANSACTIONAL_CURR_CODE;
1050         zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(k) := l_header_rec.CONVERSION_RATE_DATE;
1051         zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(k) := l_header_rec.CONVERSION_RATE;
1052         zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(k) := l_header_rec.CONVERSION_TYPE_CODE;
1053         zx_global_structures_pkg.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(k) := l_minimum_accountable_unit;
1054         zx_global_structures_pkg.trx_line_dist_tbl.PRECISION(k)                := l_precision;
1055         -- revisit the logic to derive legal_entity_id later when legal_entity_id approach is clarified.
1056         zx_global_structures_pkg.trx_line_dist_tbl.LEGAL_ENTITY_ID(k)               := l_legal_entity_id; --   NUMBER_tbl_type        ,
1057         zx_global_structures_pkg.trx_line_dist_tbl.ESTABLISHMENT_ID(k)              := NULL;              --   NUMBER_tbl_type        ,
1058         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER(k)       := NULL;              --   VARCHAR2_150_tbl_type  ,
1059         zx_global_structures_pkg.trx_line_dist_tbl.TRX_NUMBER(k)                    := l_header_Rec.order_number;
1060         zx_global_structures_pkg.trx_line_dist_tbl.TRX_DESCRIPTION(k)               := NULL; --   VARCHAR2_240_tbl_type  ,
1061         zx_global_structures_pkg.trx_line_dist_tbl.TRX_COMMUNICATED_DATE(k)         := NULL; --   DATE_tbl_type          ,
1062         zx_global_structures_pkg.trx_line_dist_tbl.BATCH_SOURCE_ID(k)               := NULL; --   NUMBER_tbl_type        ,
1063         zx_global_structures_pkg.trx_line_dist_tbl.BATCH_SOURCE_NAME(k)             := NULL; --   VARCHAR2_150_tbl_type  ,
1064         zx_global_structures_pkg.trx_line_dist_tbl.DOC_SEQ_ID(k)                    := NULL; --   NUMBER_tbl_type        ,
1065         zx_global_structures_pkg.trx_line_dist_tbl.DOC_SEQ_NAME(k)                  := NULL; --   VARCHAR2_150_tbl_type  ,
1066         zx_global_structures_pkg.trx_line_dist_tbl.DOC_SEQ_VALUE(k)                 := NULL; --   VARCHAR2_240_tbl_type  ,
1067         zx_global_structures_pkg.trx_line_dist_tbl.TRX_DUE_DATE(k)                  := NULL; --   DATE_tbl_type          ,
1068         zx_global_structures_pkg.trx_line_dist_tbl.TRX_TYPE_DESCRIPTION(k)          := NULL; --   VARCHAR2_240_tbl_type  ,
1069         zx_global_structures_pkg.trx_line_dist_tbl.FIRST_PTY_ORG_ID(k)              := NULL; --   NUMBER_tbl_type        ,
1070         zx_global_structures_pkg.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID(k)       := l_cust_trx_type_id;
1071         zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE(k)          := NULL; --   VARCHAR2_30_tbl_type   ,
1072         zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_TYPE_CODE(k)           := NULL; --   VARCHAR2_30_tbl_type   ,
1073         zx_global_structures_pkg.trx_line_dist_tbl.DOC_EVENT_STATUS(k)              := NULL; --   VARCHAR2_30_tbl_type   ,
1074         zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(k)             := NULL; --   VARCHAR2_240_tbl_type  ,
1075         zx_global_structures_pkg.trx_line_dist_tbl.SUPPLIER_TAX_INVOICE_NUMBER(k)   := NULL; --   VARCHAR2_150_tbl_type  ,
1076         zx_global_structures_pkg.trx_line_dist_tbl.SUPPLIER_TAX_INVOICE_DATE(k)     := NULL; --   DATE_tbl_type          ,
1077         zx_global_structures_pkg.trx_line_dist_tbl.SUPPLIER_EXCHANGE_RATE(k)        := NULL; --   NUMBER_tbl_type        ,
1078         zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE(k)              := NULL; --   DATE_tbl_type          ,
1079         zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER(k)            := NULL; --   VARCHAR2_150_tbl_type  ,
1080         zx_global_structures_pkg.trx_line_dist_tbl.QUOTE_FLAG(k)                    := 'Y';  --   VARCHAR2_1_tbl_type   ,
1081         zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(k)      := NULL; --   VARCHAR2_2_tbl_type   ,
1082         zx_global_structures_pkg.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(k)         := NULL; --   VARCHAR2_1_tbl_type    ,
1083         zx_global_structures_pkg.trx_line_dist_tbl.CTRL_TOTAL_HDR_TX_AMT(k)         := NULL; --   NUMBER_tbl_type        ,
1084         zx_global_structures_pkg.trx_line_dist_tbl.PORT_OF_ENTRY_CODE(k)            := NULL; --   VARCHAR2_30_tbl_type,
1085         zx_global_structures_pkg.trx_line_dist_tbl.TAX_REPORTING_FLAG(k)            := 'N';  --   VARCHAR2_1_tbl_type,
1086         zx_global_structures_pkg.trx_line_dist_tbl.TAX_AMT_INCLUDED_FLAG(k)         := NULL; --   VARCHAR2_1_tbl_type ,
1087         zx_global_structures_pkg.trx_line_dist_tbl.COMPOUNDING_TAX_FLAG(k)          := NULL; --   VARCHAR2_1_tbl_type,
1088         zx_global_structures_pkg.trx_line_dist_tbl.PROVNL_TAX_DETERMINATION_DATE(k) := NULL; --   DATE_tbl_type,
1089         zx_global_structures_pkg.trx_line_dist_tbl.INSERT_UPDATE_FLAG(k)            := NULL; --   VARCHAR2_1_tbl_type,
1090         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_NUMBER(k)         := NULL; --   VARCHAR2_150_tbl_type,
1091         zx_global_structures_pkg.trx_line_dist_tbl.START_EXPENSE_DATE(k)            := NULL; --   DATE_tbl_type,
1092         zx_global_structures_pkg.trx_line_dist_tbl.TRX_BATCH_ID(k)                  := NULL; --   NUMBER_tbl_type,
1093         zx_global_structures_pkg.trx_line_dist_tbl.RECORD_TYPE_CODE(k)              := NULL; --   VARCHAR2_30_tbl_type,
1094         zx_global_structures_pkg.trx_line_dist_tbl.TAX_PROCESSING_COMPLETED_FLAG(k) := NULL; --   VARCHAR2_1_tbl_type,
1095         zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_DOC_STATUS(k)        := NULL; --   VARCHAR2_30_tbl_type,
1096         zx_global_structures_pkg.trx_line_dist_tbl.OVERRIDING_RECOVERY_RATE(k)      := NULL; --   NUMBER_tbl_type,
1097         zx_global_structures_pkg.trx_line_dist_tbl.TAX_CALCULATION_DONE_FLAG(k)     := NULL; --   VARCHAR2_1_tbl_type,
1098         zx_global_structures_pkg.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG(k)     := NULL; --   VARCHAR2_1_tbl_type,
1099         zx_global_structures_pkg.trx_line_dist_tbl.ICX_SESSION_ID(k)                := NULL; --   NUMBER_tbl_type
1100         -- line level columns
1101         --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CODE(k)            := NULL; --   VARCHAR2_15_tbl_type   ,
1102         --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_DATE(k)       := NULL; --   DATE_tbl_type          ,
1103         --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_RATE(k)       := NULL; --   NUMBER_tbl_type        ,
1104         --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_TYPE(k)       := NULL; --   VARCHAR2_30_tbl_type   ,
1105         --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_MAU(k)                      := NULL; --   NUMBER_tbl_type        ,
1106         --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_PRECISION(k)                := NULL; --   NUMBER_tbl_type        ,
1107         zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(k)             := NULL; --   VARCHAR2_240_tbl_type   ,
1108         zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(k) := NULL; --   VARCHAR2_30_tbl_type   ,
1109         zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(k)        := l_line_rec.TAX_EXEMPT_FLAG;
1110         zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(k)            := l_line_rec.TAX_EXEMPT_REASON_CODE;
1111         zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_ENTITY_CODE(k)         := NULL; --   VARCHAR2_30_tbl_type,
1112         zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_LINE_ID(k)             := NULL; --   NUMBER_tbl_type,
1113         zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_TAX_CODE_ID(k)        := NULL; --   NUMBER_tbl_type,
1114         zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(k)                   := l_line_rec.line_id;
1115         zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(k)                    := 'INVOICE';
1116         zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(k)             := 'CREATE';
1117         zx_global_structures_pkg.trx_line_dist_tbl.TRX_SHIPPING_DATE(k)             := l_trx_shipping_date;
1118         zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(k)              := NULL ;
1119         zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_TYPE(k)                 := 'LINE';
1120         zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(k)                 := l_tax_date;
1121         zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(k)         := l_trx_business_category;
1122         zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(k)             := NULL;
1123         zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS(k)       := NULL;
1124         zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(k)    := 'S';
1125         --8431420 zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(k) := l_ordered_quantity*l_unit_selling_price;
1126         zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(k)                   := ROUND(l_ordered_quantity*l_unit_selling_price,OE_ORDER_UTIL.G_Precision); --8431420
1127         zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(k)          := l_ordered_quantity;
1128         zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(k)                 := l_unit_selling_price;
1129         zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(k)  := l_tax_exempt_number;
1130         zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(k)              := l_tax_exempt_reason;
1131         zx_global_structures_pkg.trx_line_dist_tbl.CASH_DISCOUNT(k)              := NULL;
1132         zx_global_structures_pkg.trx_line_dist_tbl.VOLUME_DISCOUNT(k)            := NULL;
1133         zx_global_structures_pkg.trx_line_dist_tbl.TRADING_DISCOUNT(k)           := NULL;
1134         zx_global_structures_pkg.trx_line_dist_tbl.TRANSFER_CHARGE(k)            := NULL ;
1135         zx_global_structures_pkg.trx_line_dist_tbl.TRANSPORTATION_CHARGE(k)      := NULL;
1136         zx_global_structures_pkg.trx_line_dist_tbl.INSURANCE_CHARGE(k)           := NULL;
1137         zx_global_structures_pkg.trx_line_dist_tbl.OTHER_CHARGE(k)               := NULL;
1138         zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(k)                 := l_inventory_item_id;
1139         zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(k):= l_product_fisc_classification;
1140         zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(k)             := NVL(l_ship_from_org_id,l_inventory_org_id); --bug7456264
1141         zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(k)                   := l_uom_code;
1142         IF l_inventory_item_id                                                   IS NULL THEN
1143           zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k)             := NULL;
1144         ELSE
1145           -- this should be GOODS/SERVICES based on zx_product_types_def_v.
1146           -- to be changed when zx_product_types_def_v is available.
1147           zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := l_product_type;
1148         END IF;
1149         zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(k)                   := l_product_code;
1150         zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(k)               := NULL;
1151         zx_global_structures_pkg.trx_line_dist_tbl.TRX_SIC_CODE(k)                   := NULL ;
1152         zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(k)                      := l_fob_point_code;
1153         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_ID(k)               := l_ship_party_id;    --1001;
1154         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(k)             := l_ship_from_org_id; -- Bug 7532302
1155         zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_ID(k)                   := l_header_org_id;
1156         zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_ID(k)                   := l_poo_party_id;
1157         zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_ID(k)               := l_bill_party_id; --1001;
1158         zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_ID(k)             := NULL;
1159         zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_ID(k)              := NULL;
1160         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID(k)          := l_ship_party_site_id;--1024;
1161         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_SITE_ID(k)        := NULL;
1162         zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_SITE_ID(k)              := NULL ;
1163         zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_SITE_ID(k)              := NULL ;
1164         zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_SITE_ID(k)          := l_bill_party_site_id; --1024;
1165         zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_SITE_ID(k)        := NULL;
1166         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(k)            := l_ship_location_id;--1067;
1167         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(k)          := l_ship_from_location_id;
1168         zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(k)                := l_internal_org_location_id;
1169         zx_global_structures_pkg.trx_line_dist_tbl.POO_LOCATION_ID(k)                := l_poo_location_id ;
1170         zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(k)            := l_bill_location_id;      --1067;
1171         zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(k)          := l_bill_from_location_id; --bug7228640
1172         zx_global_structures_pkg.trx_line_dist_tbl.ACCOUNT_CCID(k)                   := NULL;
1173         zx_global_structures_pkg.trx_line_dist_tbl.ACCOUNT_STRING(k)                 := NULL;
1174         zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_COUNTRY(k)         := NULL;
1175         zx_global_structures_pkg.trx_line_dist_tbl.ASSET_FLAG(k)                     := NULL;
1176         zx_global_structures_pkg.trx_line_dist_tbl.ASSET_NUMBER(k)                   := NULL;
1177         zx_global_structures_pkg.trx_line_dist_tbl.ASSET_ACCUM_DEPRECIATION(k)       := NULL;
1178         zx_global_structures_pkg.trx_line_dist_tbl.ASSET_TYPE(k)                     := NULL;
1179         zx_global_structures_pkg.trx_line_dist_tbl.ASSET_COST(k)                     := NULL;
1180         zx_global_structures_pkg.trx_line_dist_tbl.DIST_LEVEL_ACTION(k)              := NULL; --   VARCHAR2_30_tbl_type   ,
1181         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TAX_DIST_ID(k)       := NULL; --   NUMBER_tbl_type        ,
1182         zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TAX_DIST_ID(k)       := NULL; --   NUMBER_tbl_type        ,
1183         zx_global_structures_pkg.trx_line_dist_tbl.TASK_ID(k)                        := NULL; --   NUMBER_tbl_type        ,
1184         zx_global_structures_pkg.trx_line_dist_tbl.AWARD_ID(k)                       := NULL; --   NUMBER_tbl_type        ,
1185         zx_global_structures_pkg.trx_line_dist_tbl.PROJECT_ID(k)                     := NULL; --   NUMBER_tbl_type        ,
1186         zx_global_structures_pkg.trx_line_dist_tbl.EXPENDITURE_TYPE(k)               := NULL; --   VARCHAR2_30_tbl_type   ,
1187         zx_global_structures_pkg.trx_line_dist_tbl.EXPENDITURE_ORGANIZATION_ID(k)    := NULL; --   NUMBER_tbl_type        ,
1188         zx_global_structures_pkg.trx_line_dist_tbl.EXPENDITURE_ITEM_DATE(k)          := NULL; --   DATE_tbl_type          ,
1189         zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_AMT(k)              := NULL; --   NUMBER_tbl_type        ,
1190         zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_QUANTITY(k)         := NULL; --   NUMBER_tbl_type        ,
1191         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_CURR_CONV_RATE(k)         := NULL; --   NUMBER_tbl_type        ,
1192         zx_global_structures_pkg.trx_line_dist_tbl.ITEM_DIST_NUMBER(k)               := NULL; --   NUMBER_tbl_type        ,
1193         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_DIST_ID(k)                := NULL; --   NUMBER_tbl_type        ,
1194         zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_TAX_AMT(k)          := NULL; --   NUMBER_tbl_type        ,
1195         zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE(k)               := NULL ;
1196         zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(k) := l_tax_code;
1197         zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL2(k)                  := NULL;
1198         zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL3(k)                  := NULL;
1199         zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL4(k)                  := NULL;
1200         zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL5(k)                  := NULL;
1201         zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL6(k)                  := NULL;
1202         zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY1(k)              := NULL;
1203         zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY2(k)              := NULL;
1204         zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY3(k)              := NULL;
1205         zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY4(k)              := NULL;
1206         zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY5(k)              := NULL;
1207         zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY6(k)              := NULL;
1208         zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY1(k)             := NULL;
1209         zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY2(k)             := NULL;
1210         zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY3(k)             := NULL;
1211         zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY4(k)             := NULL;
1212         zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY5(k)             := NULL;
1213         zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY6(k)             := NULL;
1214         zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(k)                := l_trx_line_number;
1215         zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_ID(k)               := NULL;
1216         zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY1(k)             := NULL;
1217         zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY2(k)             := NULL;
1218         zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY3(k)             := NULL;
1219         zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY4(k)             := NULL;
1220         zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY5(k)             := NULL;
1221         zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY6(k)             := NULL;
1222         zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_FLAG(k)                :='N';
1223         zx_global_structures_pkg.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(k)          :='N';
1224         zx_global_structures_pkg.trx_line_dist_tbl.CTRL_TOTAL_LINE_TX_AMT(k)         :=NULL;
1225         zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(k)           := substrb(l_user_item_description,1,240); --bug9293783
1226         zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(k)            := substrb(l_user_item_description,1,240); --bug9293783
1227         zx_global_structures_pkg.trx_line_dist_tbl.TRX_WAYBILL_NUMBER(k)             := NULL;
1228         zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_GL_DATE(k)               := NULL;
1229         zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_NAME(k)            := NULL;
1230         zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_DOCUMENT_NUMBER(k) := NULL;
1231         zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_REFERENCE(k)       := NULL;
1232         zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAXPAYER_ID(k)     := NULL;
1233         zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAX_REG_NUMBER(k)  := NULL;
1234         zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_ID(k)                := NULL;
1235         zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_ID(k)                := NULL;
1236         zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_ID(k)            := NULL;
1237         zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_ID(k)                   := NULL;
1238         zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_ID(k)                   := NULL;
1239         zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_ID(k)        := NULL;
1240         zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_SITE_ID(k)           := NULL;
1241         zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_SITE_ID(k)           := NULL;
1242         zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_SITE_ID(k)       := NULL;
1243         zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_SITE_ID(k)              := NULL;
1244         zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_SITE_ID(k)              := NULL;
1245         zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_SITE_ID(k)   := NULL;
1246         zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(k)             := NULL;
1247         zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(k)             := NULL;
1248         zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(k)         := NULL;
1249         zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(k)                := NULL;
1250         zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(k)                := NULL;
1251         zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(k)                := NULL;
1252         zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID(k)     := NULL;
1253         -- Rounding parties not required for OM. No override of rounding level
1254         zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_SHIP_TO_PARTY_ID(k)   := NULL;
1255         zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_SHIP_FROM_PARTY_ID(k) := NULL;
1256         zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_BILL_TO_PARTY_ID(k)   := NULL;
1257         zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_BILL_FROM_PARTY_ID(k) := NULL;
1258         zx_global_structures_pkg.trx_line_dist_tbl.RNDG_SHIP_TO_PARTY_SITE_ID(k)  := NULL;
1259         zx_global_structures_pkg.trx_line_dist_tbl.RNDG_SHIP_FROM_PARTY_SITE_ID(k):= NULL;
1260         zx_global_structures_pkg.trx_line_dist_tbl.RNDG_BILL_TO_PARTY_SITE_ID(k)  := NULL;
1261         zx_global_structures_pkg.trx_line_dist_tbl.RNDG_BILL_FROM_PARTY_SITE_ID(k):= NULL;
1262         -- Ref_doc, applied_from, applied_to, related_doc are not applicable for OM
1263         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_APPLICATION_ID(k)        := NULL;
1264         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_ENTITY_CODE(k)           := NULL;
1265         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_EVENT_CLASS_CODE(k)      := NULL;
1266         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_TRX_ID(k)                := NULL;
1267         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY1(k)     := NULL;
1268         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY2(k)     := NULL;
1269         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY3(k)     := NULL;
1270         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY4(k)     := NULL;
1271         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY5(k)     := NULL;
1272         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY6(k)     := NULL;
1273         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LINE_ID(k)               := NULL;
1274         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY1(k)     := NULL;
1275         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY2(k)     := NULL;
1276         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY3(k)     := NULL;
1277         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY4(k)     := NULL;
1278         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY5(k)     := NULL;
1279         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY6(k)     := NULL;
1280         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LINE_QUANTITY(k)         := NULL;
1281         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_APPLICATION_ID(k)   := NULL;
1282         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_ENTITY_CODE(k)      := NULL;
1283         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_EVENT_CLASS_CODE(k) := NULL;
1284         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_ID(k)           := NULL;
1285         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY1(k)    := NULL;
1286         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY2(k)    := NULL;
1287         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY3(k)    := NULL;
1288         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY4(k)    := NULL;
1289         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY5(k)    := NULL;
1290         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY6(k)    := NULL;
1291         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_LINE_ID(k)          := NULL;
1292         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY1(k)    := NULL;
1293         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY2(k)    := NULL;
1294         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY3(k)    := NULL;
1295         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY4(k)    := NULL;
1296         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY5(k)    := NULL;
1297         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY6(k)    := NULL;
1298         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_DIST_ID(k)          := NULL;
1299         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY1(k)    := NULL;
1300         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY2(k)    := NULL;
1301         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY3(k)    := NULL;
1302         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY4(k)    := NULL;
1303         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY5(k)    := NULL;
1304         zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY6(k)    := NULL;
1305         zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_APPLICATION_ID(k)   := NULL;
1306         zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_ENTITY_CODE(k)      := NULL;
1307         zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE(k) := NULL;
1308         zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TRX_ID(k)           := NULL ;
1309         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY1(k)     := NULL;
1310         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY2(k)     := NULL;
1311         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY3(k)     := NULL;
1312         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY4(k)     := NULL;
1313         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY5(k)     := NULL;
1314         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY6(k)     := NULL;
1315         zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_LINE_ID(k)          := NULL;
1316         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY1(k)     := NULL;
1317         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY2(k)     := NULL;
1318         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY3(k)     := NULL;
1319         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY4(k)     := NULL;
1320         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY5(k)     := NULL;
1321         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY6(k)     := NULL;
1322         zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_DIST_ID(k)          := NULL;
1323         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY1(k)     := NULL;
1324         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY2(k)     := NULL;
1325         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY3(k)     := NULL;
1326         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY4(k)     := NULL;
1327         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY5(k)     := NULL;
1328         zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY6(k)     := NULL;
1329         zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_NUMBER(k)           := NULL;
1330         zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_DATE(k)             := NULL;
1331         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_APPLICATION_ID(k)     := NULL;
1332         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_ENTITY_CODE(k)        := NULL;
1333         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_EVENT_CLASS_CODE(k)   := NULL;
1334         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_ID(k)             := NULL;
1335         zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY1(k)      := NULL;
1336         zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY2(k)      := NULL;
1337         zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY3(k)      := NULL;
1338         zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY4(k)      := NULL;
1339         zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY5(k)      := NULL;
1340         zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY6(k)      := NULL;
1341         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_LINE_ID(k)        := NULL;
1342         zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY1(k)      := NULL;
1343         zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY2(k)      := NULL;
1344         zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY3(k)      := NULL;
1345         zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY4(k)      := NULL;
1346         zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY5(k)      := NULL;
1347         zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY6(k)      := NULL;
1348         zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_APPLICATION_ID(k)    := NULL;
1349         zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_ENTITY_CODE(k)       := NULL;
1350         zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_EVENT_CLASS_CODE(k)  := NULL;
1351         zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_TRX_ID(k)            := NULL;
1352         zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY1(k)     := NULL;
1353         zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY2(k)     := NULL;
1354         zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY3(k)     := NULL;
1355         zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY4(k)     := NULL;
1356         zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY5(k)     := NULL;
1357         zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY6(k)     := NULL;
1358         zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_NUMBER(k)            := NULL;
1359         zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_DATE(k)              := NULL;
1360         zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_APPLN_ID(k)             := NULL;
1361         zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_ENTITY_CODE(k)          := NULL;
1362         zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_EVNT_CLS_CODE(k)        := NULL;
1363         zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_TRX_ID(k)               := NULL;
1364         zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_TRX_LEVEL_TYPE(k)       := NULL;
1365         zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_TRX_LINE_ID(k)          := NULL;
1366         zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC1(k)                      := NULL;
1367         zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC2(k)                      := NULL;
1368         zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC3(k)                      := NULL;
1369         zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC4(k)                      := NULL;
1370         zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC5(k)                      := NULL;
1371         zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC6(k)                      := NULL;
1372         zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC7(k)                      := NULL;
1373         zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC8(k)                      := NULL;
1374         zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC9(k)                      := NULL;
1375         zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC10(k)                     := NULL;
1376         zx_global_structures_pkg.trx_line_dist_tbl.CHAR1(k)                         := NULL;
1377         zx_global_structures_pkg.trx_line_dist_tbl.CHAR2(k)                         := NULL;
1378         zx_global_structures_pkg.trx_line_dist_tbl.CHAR3(k)                         := NULL;
1379         zx_global_structures_pkg.trx_line_dist_tbl.CHAR4(k)                         := NULL;
1380         zx_global_structures_pkg.trx_line_dist_tbl.CHAR5(k)                         := NULL;
1381         zx_global_structures_pkg.trx_line_dist_tbl.CHAR6(k)                         := NULL;
1382         zx_global_structures_pkg.trx_line_dist_tbl.CHAR7(k)                         := NULL;
1383         zx_global_structures_pkg.trx_line_dist_tbl.CHAR8(k)                         := NULL;
1384         zx_global_structures_pkg.trx_line_dist_tbl.CHAR9(k)                         := NULL;
1385         zx_global_structures_pkg.trx_line_dist_tbl.CHAR10(k)                        := NULL;
1386         zx_global_structures_pkg.trx_line_dist_tbl.DATE1(k)                         := NULL;
1387         zx_global_structures_pkg.trx_line_dist_tbl.DATE2(k)                         := NULL;
1388         zx_global_structures_pkg.trx_line_dist_tbl.DATE3(k)                         := NULL;
1389         zx_global_structures_pkg.trx_line_dist_tbl.DATE4(k)                         := NULL;
1390         zx_global_structures_pkg.trx_line_dist_tbl.DATE5(k)                         := NULL;
1391         zx_global_structures_pkg.trx_line_dist_tbl.DATE6(k)                         := NULL;
1392         zx_global_structures_pkg.trx_line_dist_tbl.DATE7(k)                         := NULL;
1393         zx_global_structures_pkg.trx_line_dist_tbl.DATE8(k)                         := NULL;
1394         zx_global_structures_pkg.trx_line_dist_tbl.DATE9(k)                         := NULL;
1395         zx_global_structures_pkg.trx_line_dist_tbl.DATE10(k)                        := NULL;
1396         zx_global_structures_pkg.trx_line_dist_tbl.internal_org_location_id(k)      := l_internal_org_location_id;
1397         /*
1398         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_TAX_PROF_ID(k) := NULL;
1399         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_TAX_PROF_ID(k):= NULL;
1400         zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_TAX_PROF_ID(k) := NULL;
1401         zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_TAX_PROF_ID(k) := NULL;
1402         zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_TAX_PROF_ID(k) := NULL;
1403         zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_TAX_PROF_ID(k) := NULL;
1404         zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_TAX_PROF_ID(k) := NULL;
1405         zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_TAX_PROF_ID(k) := NULL;
1406         zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_TAX_PROF_ID(k) := NULL;
1407         zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_TAX_PROF_ID(k) := NULL;
1408         zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_TAX_PROF_ID(k) := NULL;
1409         zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANS_PARTY_TAX_PROF_ID(k) := NULL;
1410         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_SITE_TAX_PROF_ID(k) := NULL;
1411         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_SITE_TAX_PROF_ID(k) := NULL;
1412         zx_global_structures_pkg.trx_line_dist_tbl.POA_SITE_TAX_PROF_ID(k) := NULL;
1413         zx_global_structures_pkg.trx_line_dist_tbl.POO_SITE_TAX_PROF_ID(k) := NULL;
1414         zx_global_structures_pkg.trx_line_dist_tbl.PAYING_SITE_TAX_PROF_ID(k) := NULL;
1415         zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_SITE_TAX_PROF_ID(k) := NULL;
1416         zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_SITE_TAX_PROF_ID(k):= NULL;
1417         zx_global_structures_pkg.trx_line_dist_tbl.POI_SITE_TAX_PROF_ID(k) := NULL;
1418         zx_global_structures_pkg.trx_line_dist_tbl.POD_SITE_TAX_PROF_ID(k) := NULL;
1419         zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_SITE_TAX_PROF_ID(k) := NULL;
1420         zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_SITE_TAX_PROF_ID(k):= NULL;
1421         zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANS_SITE_TAX_PROF_ID(k) := NULL;
1422         zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAX_PROF_ID(k):= NULL;
1423         zx_global_structures_pkg.trx_line_dist_tbl.RDNG_SHIP_TO_PTY_TX_PROF_ID(k)    := NULL;
1424         zx_global_structures_pkg.trx_line_dist_tbl.RDNG_SHIP_FROM_PTY_TX_PROF_ID(k)  := NULL;
1425         zx_global_structures_pkg.trx_line_dist_tbl.RDNG_BILL_TO_PTY_TX_PROF_ID(k)    := NULL;
1426         zx_global_structures_pkg.trx_line_dist_tbl.RDNG_BILL_FROM_PTY_TX_PROF_ID(k)  := NULL;
1427         zx_global_structures_pkg.trx_line_dist_tbl.RDNG_SHIP_TO_PTY_TX_P_ST_ID(k)    := NULL;
1428         zx_global_structures_pkg.trx_line_dist_tbl.RDNG_SHIP_FROM_PTY_TX_P_ST_ID(k)  := NULL;
1429         zx_global_structures_pkg.trx_line_dist_tbl.RDNG_BILL_TO_PTY_TX_P_ST_ID(k)    := NULL;
1430         zx_global_structures_pkg.trx_line_dist_tbl.RDNG_BILL_FROM_PTY_TX_P_ST_ID(k)  := NULL;
1431         zx_global_structures_pkg.trx_line_dist_tbl.HQ_ESTB_PARTY_TAX_PROF_ID(k)      := NULL;
1432         */
1433         zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_APPLICATION_ID(k)         := NULL;
1434         zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_ENTITY_CODE(k)            := NULL;
1435         zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_EVENT_CLASS_CODE(k)       := NULL;
1436         zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TRX_ID(k)                 := NULL;
1437         zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_LINE_ID(k)                := NULL;
1438         zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TRX_LEVEL_TYPE(k)         := NULL;
1439         zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_TRX_LEVEL_TYPE(k)        := NULL;
1440         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_LEVEL_TYPE(k)     := NULL;
1441         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_LEVEL_TYPE(k)   := NULL;
1442         zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TRX_LEVEL_TYPE(k)   := NULL;
1443         zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE1(k)         := 'N';
1444         zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE2(k)         := NULL;
1445         zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE3(k)         := NULL;
1446         zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE4(k)         := NULL;
1447         zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE5(k)         := NULL;
1448         zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE6(k)         := NULL;
1449         zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE7(k)         := NULL;
1450         zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE8(k)         := NULL;
1451         zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE9(k)         := NULL;
1452         zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE10(k)        := NULL;
1453         zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TAX_LINE_ID(k)            := NULL;
1454         zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER(k)       := NULL;
1455         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(k)   := l_SHIP_TO_ADDRESS_ID; --1024;
1456         zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID(k)   := l_BILL_TO_ADDRESS_ID; --1024;
1457         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(k) := l_SHIP_TO_SITE_USE_ID;--1007;
1458         zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(k) := l_BILL_TO_SITE_USE_ID;--1006;
1459         zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(k)        := l_SHIP_TO_CUSTOMER_ID;--1001;
1460         zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID(k)        := l_BILL_TO_CUSTOMER_ID;--1001;
1461         om_tax_info_rec_tbl(p).trx_id                                               := l_line_rec.header_id;
1462         om_tax_info_rec_tbl(p).trx_line_id                                          := l_line_rec.line_id;
1463         om_tax_info_rec_tbl(p).line_id                                              := l_line_rec.line_id;
1464         om_tax_info_rec_tbl(p).trx_level_type                                       := 'LINE';
1465         IF l_debug_level > 0 THEN
1466         oe_debug_pub.add('zx_global_structures_pkg.trx_line_dist_tbl parameters for Line' , 1);
1467         debug_msg(k, x_return_status);
1468         END IF;
1469         k                                                                           := k+1;
1470         p                                                                           :=p +1;
1471       END IF;
1472 
1473       IF (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y') THEN
1474         l_charge_tbl                                                              :=get_charge_details(l_line_rec.header_id, l_line_rec.line_id);
1475         FOR j                                                                     IN 1..l_charge_tbl.count
1476         LOOP
1477           -- Initialising zx_global_structures_pkg.init_trx_line_dist_tbl for line charges
1478           IF ( NOT ( l_line_rec.header_id IS NULL OR l_charge_tbl(j).charge_id IS NULL OR
1479               --p_ship_to_org_id is null OR   /*commented for the bug#3336052*/
1480               l_charge_tbl(j).charge_amount IS NULL)
1481             -- OR
1482             -- l_line_rec.tax_code is null)
1483             ) THEN
1484             l_call_tax := 'Y';
1485             zx_global_structures_pkg.init_trx_line_dist_tbl(k);
1486             zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID(k)           := 660;
1487             zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE(k)              := l_entity_code_crsr;
1488             zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE(k)         := l_event_class_code_crsr;
1489             zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(k)                   := L_HEADER_ID;
1490             zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(k)           := 'FREIGHT_CHARGE';
1491             zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(k) := l_header_rec.org_id;
1492             zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE(k)          := 'CREATE';
1493             -- bug 4700796
1494             IF l_header_rec.transaction_phase_code = 'N' THEN
1495               l_trx_date                          := l_header_rec.quote_date;
1496             ELSE
1497               l_trx_date := l_header_rec.ordered_date;
1498             END IF;
1499             zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(k)                 := l_trx_date;
1500             zx_global_structures_pkg.trx_line_dist_tbl.TRX_DOC_REVISION(k)         := NULL; --   VARCHAR2_150_tbl_type  ,
1501             zx_global_structures_pkg.trx_line_dist_tbl.LEDGER_ID(k)                := l_AR_Sys_Param_Rec.set_of_books_id;
1502             zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(k)        := l_header_rec.TRANSACTIONAL_CURR_CODE;
1503             zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(k) := l_header_rec.CONVERSION_RATE_DATE;
1504             zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(k) := l_header_rec.CONVERSION_RATE;
1505             zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(k) := l_header_rec.CONVERSION_TYPE_CODE;
1506             zx_global_structures_pkg.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(k) := l_minimum_accountable_unit;
1507             zx_global_structures_pkg.trx_line_dist_tbl.PRECISION(k)                := l_precision;
1508             -- revisit the logic to derive legal_entity_id later when legal_entity_id approach is clarified.
1509             zx_global_structures_pkg.trx_line_dist_tbl.LEGAL_ENTITY_ID(k)               := l_legal_entity_id; --   NUMBER_tbl_type        ,
1510             zx_global_structures_pkg.trx_line_dist_tbl.ESTABLISHMENT_ID(k)              := NULL;              --   NUMBER_tbl_type        ,
1511             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER(k)       := NULL;              --   VARCHAR2_150_tbl_type  ,
1512             zx_global_structures_pkg.trx_line_dist_tbl.TRX_NUMBER(k)                    := l_header_rec.order_number;
1513             zx_global_structures_pkg.trx_line_dist_tbl.TRX_DESCRIPTION(k)               := NULL; --   VARCHAR2_240_tbl_type  ,
1514             zx_global_structures_pkg.trx_line_dist_tbl.TRX_COMMUNICATED_DATE(k)         := NULL; --   DATE_tbl_type          ,
1515             zx_global_structures_pkg.trx_line_dist_tbl.BATCH_SOURCE_ID(k)               := NULL; --   NUMBER_tbl_type        ,
1516             zx_global_structures_pkg.trx_line_dist_tbl.BATCH_SOURCE_NAME(k)             := NULL; --   VARCHAR2_150_tbl_type  ,
1517             zx_global_structures_pkg.trx_line_dist_tbl.DOC_SEQ_ID(k)                    := NULL; --   NUMBER_tbl_type        ,
1518             zx_global_structures_pkg.trx_line_dist_tbl.DOC_SEQ_NAME(k)                  := NULL; --   VARCHAR2_150_tbl_type  ,
1519             zx_global_structures_pkg.trx_line_dist_tbl.DOC_SEQ_VALUE(k)                 := NULL; --   VARCHAR2_240_tbl_type  ,
1520             zx_global_structures_pkg.trx_line_dist_tbl.TRX_DUE_DATE(k)                  := NULL; --   DATE_tbl_type          ,
1521             zx_global_structures_pkg.trx_line_dist_tbl.TRX_TYPE_DESCRIPTION(k)          := NULL; --   VARCHAR2_240_tbl_type  ,
1522             zx_global_structures_pkg.trx_line_dist_tbl.FIRST_PTY_ORG_ID(k)              := NULL; --   NUMBER_tbl_type        ,
1523             zx_global_structures_pkg.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID(k)       := l_cust_trx_type_id;
1524             zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE(k)          := NULL; --   VARCHAR2_30_tbl_type   ,
1525             zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_TYPE_CODE(k)           := NULL; --   VARCHAR2_30_tbl_type   ,
1526             zx_global_structures_pkg.trx_line_dist_tbl.DOC_EVENT_STATUS(k)              := NULL; --   VARCHAR2_30_tbl_type   ,
1527             zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(k)             := NULL; --   VARCHAR2_240_tbl_type  ,
1528             zx_global_structures_pkg.trx_line_dist_tbl.SUPPLIER_TAX_INVOICE_NUMBER(k)   := NULL; --   VARCHAR2_150_tbl_type  ,
1529             zx_global_structures_pkg.trx_line_dist_tbl.SUPPLIER_TAX_INVOICE_DATE(k)     := NULL; --   DATE_tbl_type          ,
1530             zx_global_structures_pkg.trx_line_dist_tbl.SUPPLIER_EXCHANGE_RATE(k)        := NULL; --   NUMBER_tbl_type        ,
1531             zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE(k)              := NULL; --   DATE_tbl_type          ,
1532             zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER(k)            := NULL; --   VARCHAR2_150_tbl_type  ,
1533             zx_global_structures_pkg.trx_line_dist_tbl.QUOTE_FLAG(k)                    := 'Y';  --   VARCHAR2_1_tbl_type   ,
1534             zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(k)      := NULL; --   VARCHAR2_2_tbl_type   ,
1535             zx_global_structures_pkg.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(k)         := NULL; --   VARCHAR2_1_tbl_type    ,
1536             zx_global_structures_pkg.trx_line_dist_tbl.CTRL_TOTAL_HDR_TX_AMT(k)         := NULL; --   NUMBER_tbl_type        ,
1537             zx_global_structures_pkg.trx_line_dist_tbl.PORT_OF_ENTRY_CODE(k)            := NULL; --   VARCHAR2_30_tbl_type,
1538             zx_global_structures_pkg.trx_line_dist_tbl.TAX_REPORTING_FLAG(k)            := 'N';  --   VARCHAR2_1_tbl_type,
1539             zx_global_structures_pkg.trx_line_dist_tbl.TAX_AMT_INCLUDED_FLAG(k)         := NULL; --   VARCHAR2_1_tbl_type ,
1540             zx_global_structures_pkg.trx_line_dist_tbl.COMPOUNDING_TAX_FLAG(k)          := NULL; --   VARCHAR2_1_tbl_type,
1541             zx_global_structures_pkg.trx_line_dist_tbl.PROVNL_TAX_DETERMINATION_DATE(k) := NULL; --   DATE_tbl_type,
1542             zx_global_structures_pkg.trx_line_dist_tbl.INSERT_UPDATE_FLAG(k)            := NULL; --   VARCHAR2_1_tbl_type,
1543             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_NUMBER(k)         := NULL; --   VARCHAR2_150_tbl_type,
1544             zx_global_structures_pkg.trx_line_dist_tbl.START_EXPENSE_DATE(k)            := NULL; --   DATE_tbl_type,
1545             zx_global_structures_pkg.trx_line_dist_tbl.TRX_BATCH_ID(k)                  := NULL; --   NUMBER_tbl_type,
1546             zx_global_structures_pkg.trx_line_dist_tbl.RECORD_TYPE_CODE(k)              := NULL; --   VARCHAR2_30_tbl_type,
1547             zx_global_structures_pkg.trx_line_dist_tbl.TAX_PROCESSING_COMPLETED_FLAG(k) := NULL; --   VARCHAR2_1_tbl_type,
1548             zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_DOC_STATUS(k)        := NULL; --   VARCHAR2_30_tbl_type,
1549             zx_global_structures_pkg.trx_line_dist_tbl.OVERRIDING_RECOVERY_RATE(k)      := NULL; --   NUMBER_tbl_type,
1550             zx_global_structures_pkg.trx_line_dist_tbl.TAX_CALCULATION_DONE_FLAG(k)     := NULL; --   VARCHAR2_1_tbl_type,
1551             zx_global_structures_pkg.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG(k)     := NULL; --   VARCHAR2_1_tbl_type,
1552             zx_global_structures_pkg.trx_line_dist_tbl.ICX_SESSION_ID(k)                := NULL; --   NUMBER_tbl_type
1553             -- line level columns
1554             --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CODE(k)            := NULL; --   VARCHAR2_15_tbl_type   ,
1555             --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_DATE(k)       := NULL; --   DATE_tbl_type          ,
1556             --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_RATE(k)       := NULL; --   NUMBER_tbl_type        ,
1557             --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_TYPE(k)       := NULL; --   VARCHAR2_30_tbl_type   ,
1558             --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_MAU(k)                      := NULL; --   NUMBER_tbl_type        ,
1559             --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_PRECISION(k)                := NULL; --   NUMBER_tbl_type        ,
1560             zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(k)             := NULL; --   VARCHAR2_240_tbl_type   ,
1561             zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(k) := NULL; --   VARCHAR2_30_tbl_type   ,
1562             zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(k)        := l_line_rec.TAX_EXEMPT_FLAG;
1563             zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(k)            := l_line_rec.TAX_EXEMPT_REASON_CODE;
1564             zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_ENTITY_CODE(k)         := NULL; --   VARCHAR2_30_tbl_type,
1565             zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_LINE_ID(k)             := NULL; --   NUMBER_tbl_type,
1566             zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_TAX_CODE_ID(k)        := NULL; --   NUMBER_tbl_type,
1567             zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(k)                   := l_charge_tbl(j).charge_id;
1568             zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(k)                    := 'INVOICE';
1569             zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(k)             := 'CREATE';
1570             zx_global_structures_pkg.trx_line_dist_tbl.TRX_SHIPPING_DATE(k)             := l_trx_shipping_date;
1571             zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(k)              := NULL ;
1572             zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_TYPE(k)                 := 'LINE';
1573             zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(k)                 := l_tax_date;
1574             zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(k)         := l_trx_business_category;
1575             zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(k)             := NULL;
1576             zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS(k)       := NULL;
1577             zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(k)    := 'S';
1578             --8431420 zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(k) := l_ordered_quantity*l_unit_selling_price;
1579             zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(k)                   := l_charge_tbl(j).charge_amount;
1580             --TaxER zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(k)          := l_ordered_quantity;
1581             zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(k)          := 1;  --TaxER
1582             --TaxER zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(k)                 := l_unit_selling_price;
1583             zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(k)                 := l_charge_tbl(j).charge_amount;  --TaxER
1584             zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(k)  := l_tax_exempt_number;
1585             zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(k)              := l_tax_exempt_reason;
1586             zx_global_structures_pkg.trx_line_dist_tbl.CASH_DISCOUNT(k)              := NULL;
1587             zx_global_structures_pkg.trx_line_dist_tbl.VOLUME_DISCOUNT(k)            := NULL;
1588             zx_global_structures_pkg.trx_line_dist_tbl.TRADING_DISCOUNT(k)           := NULL;
1589             zx_global_structures_pkg.trx_line_dist_tbl.TRANSFER_CHARGE(k)            := NULL ;
1590             zx_global_structures_pkg.trx_line_dist_tbl.TRANSPORTATION_CHARGE(k)      := NULL;
1591             zx_global_structures_pkg.trx_line_dist_tbl.INSURANCE_CHARGE(k)           := NULL;
1592             zx_global_structures_pkg.trx_line_dist_tbl.OTHER_CHARGE(k)               := NULL;
1593             zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(k)                 := l_inventory_item_id;
1594             zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(k):= l_product_fisc_classification;
1595             zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(k)             := NVL(l_ship_from_org_id,l_inventory_org_id); --bug7456264
1596             zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(k)                   := l_uom_code;
1597             IF l_inventory_item_id                                                   IS NULL THEN
1598               zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k)             := NULL;
1599             ELSE
1600               -- this should be GOODS/SERVICES based on zx_product_types_def_v.
1601               -- to be changed when zx_product_types_def_v is available.
1602               zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(k) := l_product_type;
1603             END IF;
1604             zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(k)                   := l_product_code;
1605             zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(k)               := NULL;
1606             zx_global_structures_pkg.trx_line_dist_tbl.TRX_SIC_CODE(k)                   := NULL ;
1607             zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(k)                      := l_fob_point_code;
1608             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_ID(k)               := l_ship_party_id;    --1001;
1609             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(k)             := l_ship_from_org_id; -- Bug 7532302
1610             zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_ID(k)                   := l_header_org_id;
1611             zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_ID(k)                   := l_poo_party_id;
1612             zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_ID(k)               := l_bill_party_id; --1001;
1613             zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_ID(k)             := NULL;
1614             zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_ID(k)              := NULL;
1615             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID(k)          := l_ship_party_site_id;--1024;
1616             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_SITE_ID(k)        := NULL;
1617             zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_SITE_ID(k)              := NULL ;
1618             zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_SITE_ID(k)              := NULL ;
1619             zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_SITE_ID(k)          := l_bill_party_site_id; --1024;
1620             zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_SITE_ID(k)        := NULL;
1621             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(k)            := l_ship_location_id;--1067;
1622             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(k)          := l_ship_from_location_id;
1623             zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(k)                := l_internal_org_location_id;
1624             zx_global_structures_pkg.trx_line_dist_tbl.POO_LOCATION_ID(k)                := l_poo_location_id ;
1625             zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(k)            := l_bill_location_id;      --1067;
1626             zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(k)          := l_bill_from_location_id; --bug7228640
1627             zx_global_structures_pkg.trx_line_dist_tbl.ACCOUNT_CCID(k)                   := NULL;
1628             zx_global_structures_pkg.trx_line_dist_tbl.ACCOUNT_STRING(k)                 := NULL;
1629             zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_COUNTRY(k)         := NULL;
1630             zx_global_structures_pkg.trx_line_dist_tbl.ASSET_FLAG(k)                     := NULL;
1631             zx_global_structures_pkg.trx_line_dist_tbl.ASSET_NUMBER(k)                   := NULL;
1632             zx_global_structures_pkg.trx_line_dist_tbl.ASSET_ACCUM_DEPRECIATION(k)       := NULL;
1633             zx_global_structures_pkg.trx_line_dist_tbl.ASSET_TYPE(k)                     := NULL;
1634             zx_global_structures_pkg.trx_line_dist_tbl.ASSET_COST(k)                     := NULL;
1635             zx_global_structures_pkg.trx_line_dist_tbl.DIST_LEVEL_ACTION(k)              := NULL; --   VARCHAR2_30_tbl_type   ,
1636             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TAX_DIST_ID(k)       := NULL; --   NUMBER_tbl_type        ,
1637             zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TAX_DIST_ID(k)       := NULL; --   NUMBER_tbl_type        ,
1638             zx_global_structures_pkg.trx_line_dist_tbl.TASK_ID(k)                        := NULL; --   NUMBER_tbl_type        ,
1639             zx_global_structures_pkg.trx_line_dist_tbl.AWARD_ID(k)                       := NULL; --   NUMBER_tbl_type        ,
1640             zx_global_structures_pkg.trx_line_dist_tbl.PROJECT_ID(k)                     := NULL; --   NUMBER_tbl_type        ,
1641             zx_global_structures_pkg.trx_line_dist_tbl.EXPENDITURE_TYPE(k)               := NULL; --   VARCHAR2_30_tbl_type   ,
1642             zx_global_structures_pkg.trx_line_dist_tbl.EXPENDITURE_ORGANIZATION_ID(k)    := NULL; --   NUMBER_tbl_type        ,
1643             zx_global_structures_pkg.trx_line_dist_tbl.EXPENDITURE_ITEM_DATE(k)          := NULL; --   DATE_tbl_type          ,
1644             zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_AMT(k)              := NULL; --   NUMBER_tbl_type        ,
1645             zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_QUANTITY(k)         := NULL; --   NUMBER_tbl_type        ,
1646             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_CURR_CONV_RATE(k)         := NULL; --   NUMBER_tbl_type        ,
1647             zx_global_structures_pkg.trx_line_dist_tbl.ITEM_DIST_NUMBER(k)               := NULL; --   NUMBER_tbl_type        ,
1648             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_DIST_ID(k)                := NULL; --   NUMBER_tbl_type        ,
1649             zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_TAX_AMT(k)          := NULL; --   NUMBER_tbl_type        ,
1650             zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE(k)               := NULL ;
1651             zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(k) := l_tax_code;
1652             zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL2(k)                  := NULL;
1653             zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL3(k)                  := NULL;
1654             zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL4(k)                  := NULL;
1655             zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL5(k)                  := NULL;
1656             zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL6(k)                  := NULL;
1657             zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY1(k)              := NULL;
1658             zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY2(k)              := NULL;
1659             zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY3(k)              := NULL;
1660             zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY4(k)              := NULL;
1661             zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY5(k)              := NULL;
1662             zx_global_structures_pkg.trx_line_dist_tbl.HDR_TRX_USER_KEY6(k)              := NULL;
1663             zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY1(k)             := NULL;
1664             zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY2(k)             := NULL;
1665             zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY3(k)             := NULL;
1666             zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY4(k)             := NULL;
1667             zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY5(k)             := NULL;
1668             zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY6(k)             := NULL;
1669             zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(k)                := l_trx_line_number;
1670             zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_ID(k)               := NULL;
1671             zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY1(k)             := NULL;
1672             zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY2(k)             := NULL;
1673             zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY3(k)             := NULL;
1674             zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY4(k)             := NULL;
1675             zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY5(k)             := NULL;
1676             zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY6(k)             := NULL;
1677             zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_FLAG(k)                :='N';
1678             zx_global_structures_pkg.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(k)          :='N';
1679             zx_global_structures_pkg.trx_line_dist_tbl.CTRL_TOTAL_LINE_TX_AMT(k)         :=NULL;
1680             zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(k)           := substrb(l_user_item_description,1,240); --bug9293783
1681             zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(k)            := substrb(l_user_item_description,1,240); --bug9293783
1682             zx_global_structures_pkg.trx_line_dist_tbl.TRX_WAYBILL_NUMBER(k)             := NULL;
1683             zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_GL_DATE(k)               := NULL;
1684             zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_NAME(k)            := NULL;
1685             zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_DOCUMENT_NUMBER(k) := NULL;
1686             zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_REFERENCE(k)       := NULL;
1687             zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAXPAYER_ID(k)     := NULL;
1688             zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAX_REG_NUMBER(k)  := NULL;
1689             zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_ID(k)                := NULL;
1690             zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_ID(k)                := NULL;
1691             zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_ID(k)            := NULL;
1692             zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_ID(k)                   := NULL;
1693             zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_ID(k)                   := NULL;
1694             zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_ID(k)        := NULL;
1695             zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_SITE_ID(k)           := NULL;
1696             zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_SITE_ID(k)           := NULL;
1697             zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_SITE_ID(k)       := NULL;
1698             zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_SITE_ID(k)              := NULL;
1699             zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_SITE_ID(k)              := NULL;
1700             zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_SITE_ID(k)   := NULL;
1701             zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(k)             := NULL;
1702             zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(k)             := NULL;
1703             zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(k)         := NULL;
1704             zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(k)                := NULL;
1705             zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(k)                := NULL;
1706             zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(k)                := NULL;
1707             zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID(k)     := NULL;
1708             -- Rounding parties not required for OM. No override of rounding level
1709             zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_SHIP_TO_PARTY_ID(k)   := NULL;
1710             zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_SHIP_FROM_PARTY_ID(k) := NULL;
1711             zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_BILL_TO_PARTY_ID(k)   := NULL;
1712             zx_global_structures_pkg.trx_line_dist_tbl.ROUNDING_BILL_FROM_PARTY_ID(k) := NULL;
1713             zx_global_structures_pkg.trx_line_dist_tbl.RNDG_SHIP_TO_PARTY_SITE_ID(k)  := NULL;
1714             zx_global_structures_pkg.trx_line_dist_tbl.RNDG_SHIP_FROM_PARTY_SITE_ID(k):= NULL;
1715             zx_global_structures_pkg.trx_line_dist_tbl.RNDG_BILL_TO_PARTY_SITE_ID(k)  := NULL;
1716             zx_global_structures_pkg.trx_line_dist_tbl.RNDG_BILL_FROM_PARTY_SITE_ID(k):= NULL;
1717             -- Ref_doc, applied_from, applied_to, related_doc are not applicable for OM
1718             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_APPLICATION_ID(k)        := NULL;
1719             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_ENTITY_CODE(k)           := NULL;
1720             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_EVENT_CLASS_CODE(k)      := NULL;
1721             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_TRX_ID(k)                := NULL;
1722             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY1(k)     := NULL;
1723             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY2(k)     := NULL;
1724             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY3(k)     := NULL;
1725             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY4(k)     := NULL;
1726             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY5(k)     := NULL;
1727             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY6(k)     := NULL;
1728             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LINE_ID(k)               := NULL;
1729             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY1(k)     := NULL;
1730             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY2(k)     := NULL;
1731             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY3(k)     := NULL;
1732             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY4(k)     := NULL;
1733             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY5(k)     := NULL;
1734             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY6(k)     := NULL;
1735             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_LINE_QUANTITY(k)         := NULL;
1736             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_APPLICATION_ID(k)   := NULL;
1737             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_ENTITY_CODE(k)      := NULL;
1738             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_EVENT_CLASS_CODE(k) := NULL;
1739             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_ID(k)           := NULL;
1740             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY1(k)    := NULL;
1741             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY2(k)    := NULL;
1742             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY3(k)    := NULL;
1743             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY4(k)    := NULL;
1744             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY5(k)    := NULL;
1745             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY6(k)    := NULL;
1746             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_LINE_ID(k)          := NULL;
1747             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY1(k)    := NULL;
1748             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY2(k)    := NULL;
1749             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY3(k)    := NULL;
1750             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY4(k)    := NULL;
1751             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY5(k)    := NULL;
1752             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY6(k)    := NULL;
1753             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_DIST_ID(k)          := NULL;
1754             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY1(k)    := NULL;
1755             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY2(k)    := NULL;
1756             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY3(k)    := NULL;
1757             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY4(k)    := NULL;
1758             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY5(k)    := NULL;
1759             zx_global_structures_pkg.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY6(k)    := NULL;
1760             zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_APPLICATION_ID(k)   := NULL;
1761             zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_ENTITY_CODE(k)      := NULL;
1762             zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE(k) := NULL;
1763             zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TRX_ID(k)           := NULL ;
1764             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY1(k)     := NULL;
1765             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY2(k)     := NULL;
1766             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY3(k)     := NULL;
1767             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY4(k)     := NULL;
1768             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY5(k)     := NULL;
1769             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY6(k)     := NULL;
1770             zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_LINE_ID(k)          := NULL;
1771             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY1(k)     := NULL;
1772             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY2(k)     := NULL;
1773             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY3(k)     := NULL;
1774             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY4(k)     := NULL;
1775             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY5(k)     := NULL;
1776             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY6(k)     := NULL;
1777             zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_DIST_ID(k)          := NULL;
1778             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY1(k)     := NULL;
1779             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY2(k)     := NULL;
1780             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY3(k)     := NULL;
1781             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY4(k)     := NULL;
1782             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY5(k)     := NULL;
1783             zx_global_structures_pkg.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY6(k)     := NULL;
1784             zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_NUMBER(k)           := NULL;
1785             zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_DATE(k)             := NULL;
1786             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_APPLICATION_ID(k)     := NULL;
1787             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_ENTITY_CODE(k)        := NULL;
1788             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_EVENT_CLASS_CODE(k)   := NULL;
1789             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_ID(k)             := NULL;
1790             zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY1(k)      := NULL;
1791             zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY2(k)      := NULL;
1792             zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY3(k)      := NULL;
1793             zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY4(k)      := NULL;
1794             zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY5(k)      := NULL;
1795             zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY6(k)      := NULL;
1796             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_LINE_ID(k)        := NULL;
1797             zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY1(k)      := NULL;
1798             zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY2(k)      := NULL;
1799             zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY3(k)      := NULL;
1800             zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY4(k)      := NULL;
1801             zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY5(k)      := NULL;
1802             zx_global_structures_pkg.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY6(k)      := NULL;
1803             zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_APPLICATION_ID(k)    := NULL;
1804             zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_ENTITY_CODE(k)       := NULL;
1805             zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_EVENT_CLASS_CODE(k)  := NULL;
1806             zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_TRX_ID(k)            := NULL;
1807             zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY1(k)     := NULL;
1808             zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY2(k)     := NULL;
1809             zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY3(k)     := NULL;
1810             zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY4(k)     := NULL;
1811             zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY5(k)     := NULL;
1812             zx_global_structures_pkg.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY6(k)     := NULL;
1813             zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_NUMBER(k)            := NULL;
1814             zx_global_structures_pkg.trx_line_dist_tbl.RELATED_DOC_DATE(k)              := NULL;
1815             zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_APPLN_ID(k)             := NULL;
1816             zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_ENTITY_CODE(k)          := NULL;
1817             zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_EVNT_CLS_CODE(k)        := NULL;
1818             zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_TRX_ID(k)               := NULL;
1819             zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_TRX_LEVEL_TYPE(k)       := NULL;
1820             zx_global_structures_pkg.trx_line_dist_tbl.REVERSED_TRX_LINE_ID(k)          := NULL;
1821             zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC1(k)                      := NULL;
1822             zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC2(k)                      := NULL;
1823             zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC3(k)                      := NULL;
1824             zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC4(k)                      := NULL;
1825             zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC5(k)                      := NULL;
1826             zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC6(k)                      := NULL;
1827             zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC7(k)                      := NULL;
1828             zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC8(k)                      := NULL;
1829             zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC9(k)                      := NULL;
1830             zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC10(k)                     := NULL;
1831             zx_global_structures_pkg.trx_line_dist_tbl.CHAR1(k)                         := NULL;
1832             zx_global_structures_pkg.trx_line_dist_tbl.CHAR2(k)                         := NULL;
1833             zx_global_structures_pkg.trx_line_dist_tbl.CHAR3(k)                         := NULL;
1834             zx_global_structures_pkg.trx_line_dist_tbl.CHAR4(k)                         := NULL;
1835             zx_global_structures_pkg.trx_line_dist_tbl.CHAR5(k)                         := NULL;
1836             zx_global_structures_pkg.trx_line_dist_tbl.CHAR6(k)                         := NULL;
1837             zx_global_structures_pkg.trx_line_dist_tbl.CHAR7(k)                         := NULL;
1838             zx_global_structures_pkg.trx_line_dist_tbl.CHAR8(k)                         := NULL;
1839             zx_global_structures_pkg.trx_line_dist_tbl.CHAR9(k)                         := NULL;
1840             zx_global_structures_pkg.trx_line_dist_tbl.CHAR10(k)                        := NULL;
1841             zx_global_structures_pkg.trx_line_dist_tbl.DATE1(k)                         := NULL;
1842             zx_global_structures_pkg.trx_line_dist_tbl.DATE2(k)                         := NULL;
1843             zx_global_structures_pkg.trx_line_dist_tbl.DATE3(k)                         := NULL;
1844             zx_global_structures_pkg.trx_line_dist_tbl.DATE4(k)                         := NULL;
1845             zx_global_structures_pkg.trx_line_dist_tbl.DATE5(k)                         := NULL;
1846             zx_global_structures_pkg.trx_line_dist_tbl.DATE6(k)                         := NULL;
1847             zx_global_structures_pkg.trx_line_dist_tbl.DATE7(k)                         := NULL;
1848             zx_global_structures_pkg.trx_line_dist_tbl.DATE8(k)                         := NULL;
1849             zx_global_structures_pkg.trx_line_dist_tbl.DATE9(k)                         := NULL;
1850             zx_global_structures_pkg.trx_line_dist_tbl.DATE10(k)                        := NULL;
1851             zx_global_structures_pkg.trx_line_dist_tbl.internal_org_location_id(k)      := l_internal_org_location_id;
1852             /*
1853             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_TAX_PROF_ID(k) := NULL;
1854             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_TAX_PROF_ID(k):= NULL;
1855             zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_TAX_PROF_ID(k) := NULL;
1856             zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_TAX_PROF_ID(k) := NULL;
1857             zx_global_structures_pkg.trx_line_dist_tbl.PAYING_PARTY_TAX_PROF_ID(k) := NULL;
1858             zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_PARTY_TAX_PROF_ID(k) := NULL;
1859             zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_PARTY_TAX_PROF_ID(k) := NULL;
1860             zx_global_structures_pkg.trx_line_dist_tbl.POI_PARTY_TAX_PROF_ID(k) := NULL;
1861             zx_global_structures_pkg.trx_line_dist_tbl.POD_PARTY_TAX_PROF_ID(k) := NULL;
1862             zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_TAX_PROF_ID(k) := NULL;
1863             zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_TAX_PROF_ID(k) := NULL;
1864             zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANS_PARTY_TAX_PROF_ID(k) := NULL;
1865             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_SITE_TAX_PROF_ID(k) := NULL;
1866             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_SITE_TAX_PROF_ID(k) := NULL;
1867             zx_global_structures_pkg.trx_line_dist_tbl.POA_SITE_TAX_PROF_ID(k) := NULL;
1868             zx_global_structures_pkg.trx_line_dist_tbl.POO_SITE_TAX_PROF_ID(k) := NULL;
1869             zx_global_structures_pkg.trx_line_dist_tbl.PAYING_SITE_TAX_PROF_ID(k) := NULL;
1870             zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_SITE_TAX_PROF_ID(k) := NULL;
1871             zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_SITE_TAX_PROF_ID(k):= NULL;
1872             zx_global_structures_pkg.trx_line_dist_tbl.POI_SITE_TAX_PROF_ID(k) := NULL;
1873             zx_global_structures_pkg.trx_line_dist_tbl.POD_SITE_TAX_PROF_ID(k) := NULL;
1874             zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_SITE_TAX_PROF_ID(k) := NULL;
1875             zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_SITE_TAX_PROF_ID(k):= NULL;
1876             zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANS_SITE_TAX_PROF_ID(k) := NULL;
1877             zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_TAX_PROF_ID(k):= NULL;
1878             zx_global_structures_pkg.trx_line_dist_tbl.RDNG_SHIP_TO_PTY_TX_PROF_ID(k)    := NULL;
1879             zx_global_structures_pkg.trx_line_dist_tbl.RDNG_SHIP_FROM_PTY_TX_PROF_ID(k)  := NULL;
1880             zx_global_structures_pkg.trx_line_dist_tbl.RDNG_BILL_TO_PTY_TX_PROF_ID(k)    := NULL;
1881             zx_global_structures_pkg.trx_line_dist_tbl.RDNG_BILL_FROM_PTY_TX_PROF_ID(k)  := NULL;
1882             zx_global_structures_pkg.trx_line_dist_tbl.RDNG_SHIP_TO_PTY_TX_P_ST_ID(k)    := NULL;
1883             zx_global_structures_pkg.trx_line_dist_tbl.RDNG_SHIP_FROM_PTY_TX_P_ST_ID(k)  := NULL;
1884             zx_global_structures_pkg.trx_line_dist_tbl.RDNG_BILL_TO_PTY_TX_P_ST_ID(k)    := NULL;
1885             zx_global_structures_pkg.trx_line_dist_tbl.RDNG_BILL_FROM_PTY_TX_P_ST_ID(k)  := NULL;
1886             zx_global_structures_pkg.trx_line_dist_tbl.HQ_ESTB_PARTY_TAX_PROF_ID(k)      := NULL;
1887             */
1888             zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_APPLICATION_ID(k)         := NULL;
1889             zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_ENTITY_CODE(k)            := NULL;
1890             zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_EVENT_CLASS_CODE(k)       := NULL;
1891             zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TRX_ID(k)                 := NULL;
1892             zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_LINE_ID(k)                := NULL;
1893             zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TRX_LEVEL_TYPE(k)         := NULL;
1894             zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_TRX_LEVEL_TYPE(k)        := NULL;
1895             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_TO_TRX_LEVEL_TYPE(k)     := NULL;
1896             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_LEVEL_TYPE(k)   := NULL;
1897             zx_global_structures_pkg.trx_line_dist_tbl.ADJUSTED_DOC_TRX_LEVEL_TYPE(k)   := NULL;
1898             zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE1(k)         := 'N';
1899             zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE2(k)         := NULL;
1900             zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE3(k)         := NULL;
1901             zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE4(k)         := NULL;
1902             zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE5(k)         := NULL;
1903             zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE6(k)         := NULL;
1904             zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE7(k)         := NULL;
1905             zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE8(k)         := NULL;
1906             zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE9(k)         := NULL;
1907             zx_global_structures_pkg.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE10(k)        := NULL;
1908             zx_global_structures_pkg.trx_line_dist_tbl.SOURCE_TAX_LINE_ID(k)            := NULL;
1909             zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER(k)       := NULL;
1910             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(k)   := l_SHIP_TO_ADDRESS_ID; --1024;
1911             zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID(k)   := l_BILL_TO_ADDRESS_ID; --1024;
1912             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(k) := l_SHIP_TO_SITE_USE_ID;--1007;
1913             zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(k) := l_BILL_TO_SITE_USE_ID;--1006;
1914             zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(k)        := l_SHIP_TO_CUSTOMER_ID;--1001;
1915             zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID(k)        := l_BILL_TO_CUSTOMER_ID;--1001;
1916             om_tax_info_rec_tbl(p).trx_id                                               := l_line_rec.header_id;
1917             om_tax_info_rec_tbl(p).trx_line_id                                          := l_charge_tbl(j).charge_id;
1918             om_tax_info_rec_tbl(p).line_id                                              := l_line_rec.line_id;
1919             om_tax_info_rec_tbl(p).trx_level_type                                       := 'FREIGHT_CHARGE';
1920             IF l_debug_level > 0 THEN
1921             oe_debug_pub.add('zx_global_structures_pkg.trx_line_dist_tbl parameters for line level charges' , 1);
1922             debug_msg(k, x_return_status);
1923             END IF;
1924             k                                                                           := k+1;
1925             p                                                                           :=p +1;
1926           END IF;
1927 
1928         END LOOP;
1929       END IF;
1930     END IF;
1931   END LOOP;
1932 
1933   l_transaction_rec.application_id           := 660;
1934 --TaxER start
1935   l_transaction_rec.entity_code := 'OE_ORDER_HEADERS';
1936   l_transaction_rec.event_class_code := 'SALES_TRANSACTION_TAX_QUOTE';
1937 --TaxER end
1938   l_transaction_rec.event_type_code          := 'CREATE';
1939   l_transaction_rec.trx_id                   := l_header_id;
1940   l_transaction_rec.internal_organization_id := l_org_id;
1941 
1942   IF l_call_tax = 'Y' THEN
1943         zx_api_pub.calculate_tax( p_api_version => 1.0,
1944                                   p_init_msg_list => FND_API.G_TRUE,
1945                                   p_commit => NULL,
1946                                   p_validation_level => NULL,
1947                                   x_return_status => l_return_status,
1948                                   x_msg_count => l_msg_count,
1949                                   x_msg_data => l_msg_data,
1950                                   p_transaction_rec => l_transaction_rec,
1951                                   p_quote_flag => 'Y',
1952                                   p_data_transfer_mode => 'PLS',
1953                                   x_doc_level_recalc_flag => l_doc_level_recalc_flag);
1954   END IF;
1955 
1956 
1957   IF l_debug_level > 0 THEN
1958     oe_debug_pub.add('Message returned by tax API ZX_API_PUB.calculate_tax: '||l_msg_count||'return status'||l_return_status,2);
1959     oe_debug_pub.add('Message returned by tax API ZX_API_PUB.calculate_tax: '||l_msg_data||'return status'||l_return_status,2);
1960   END IF;
1961   IF l_msg_count = 1 THEN
1962     --there is one message raised by the API
1963     IF l_debug_level > 0 THEN
1964       oe_debug_pub.add(l_msg_data,2);
1965     END IF;
1966     IF l_msg_data IS NOT NULL THEN
1967       FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
1968       FND_MESSAGE.SET_TOKEN('TEXT',l_msg_data);
1969       OE_MSG_PUB.Add;
1970     ELSE
1971       OE_MSG_PUB.Add_text('Tax engine call raised Error ' ); --For bug # 4206796
1972     END IF;
1973   ELSIF l_msg_count > 1 THEN
1974     LOOP
1975       l_msg_data        := FND_MSG_PUB.GET(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
1976       IF l_msg_data     IS NULL THEN
1977         IF l_debug_level > 0 THEN
1978           oe_debug_pub.add('msg data is null',2);
1979         END IF;
1980         EXIT;
1981       ELSE
1982         IF l_debug_level > 0 THEN
1983           oe_debug_pub.add(l_msg_data,2);
1984         END IF;
1985         FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
1986         FND_MESSAGE.SET_TOKEN('TEXT',l_msg_data);
1987         OE_MSG_PUB.Add;
1988       END IF;
1989     END LOOP;
1990   END IF;
1991   IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1992     IF l_debug_level > 0 THEN
1993       oe_debug_pub.add('tax engine call returned unexp error',1);
1994     END IF;
1995     x_return_status := l_return_status; -- nocopy related change
1996     RETURN;
1997   ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1998     IF l_debug_level    > 0 THEN
1999       oe_debug_pub.add('tax engine call returned error',1);
2000     END IF;
2001     x_return_status := l_return_status; -- nocopy related change
2002     RETURN;
2003   ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2004     IF l_debug_level    > 0 THEN
2005       oe_debug_pub.add('tax engine call returned successfully',1);
2006     END IF;
2007     x_return_status := l_return_status; -- nocopy related change
2008   END IF;
2009   k     :=1;
2010 
2011 
2012   FOR i IN 1..om_tax_info_rec_tbl.count
2013   LOOP
2014     IF om_tax_info_rec_tbl(i).trx_level_type= 'LINE' THEN
2015 
2016       FOR detail_tax_lines_gt_rec          IN detail_tax_lines_gt(om_tax_info_rec_tbl(i).trx_id, om_tax_info_rec_tbl(i).line_id)
2017       LOOP
2018         x_tax_out_tbl(k).trx_id                   := om_tax_info_rec_tbl(i).trx_id  ;
2019         x_tax_out_tbl(k).tax_amount               := detail_tax_lines_gt_rec.tax_amt;
2020         x_tax_out_tbl(k).taxable_amount           := detail_tax_lines_gt_rec.taxable_amt;
2021         x_tax_out_tbl(k).tax_rate_id              := detail_tax_lines_gt_rec.tax_rate_id;
2022         x_tax_out_tbl(k).tax_rate                 := detail_tax_lines_gt_rec.tax_rate;
2023         x_tax_out_tbl(k).trx_line_id              := detail_tax_lines_gt_rec.trx_line_id;
2024         x_tax_out_tbl(k).amount_includes_tax_flag := detail_tax_lines_gt_rec.tax_amt_included_flag;
2025         x_tax_out_tbl(k).line_id                  := om_tax_info_rec_tbl(i).line_id;
2026         x_tax_out_tbl(k).trx_level_type           := om_tax_info_rec_tbl(i).trx_level_type;
2027         k                                         := k + 1;
2028       END LOOP;
2029     ELSE
2030       FOR detail_tax_lines_gt_rec IN detail_tax_charges_gt(om_tax_info_rec_tbl(i).trx_id, om_tax_info_rec_tbl(i).trx_line_id)
2031       LOOP
2032         x_tax_out_tbl(k).trx_id                   := om_tax_info_rec_tbl(i).trx_id ;
2033         x_tax_out_tbl(k).tax_amount               := detail_tax_lines_gt_rec.tax_amt;
2034         x_tax_out_tbl(k).taxable_amount           := detail_tax_lines_gt_rec.taxable_amt;
2035         x_tax_out_tbl(k).tax_rate_id              := detail_tax_lines_gt_rec.tax_rate_id;
2036         x_tax_out_tbl(k).tax_rate                 := detail_tax_lines_gt_rec.tax_rate;
2037         x_tax_out_tbl(k).trx_line_id              := detail_tax_lines_gt_rec.trx_line_id;
2038         x_tax_out_tbl(k).amount_includes_tax_flag := detail_tax_lines_gt_rec.tax_amt_included_flag;
2039         x_tax_out_tbl(k).line_id                  := om_tax_info_rec_tbl(i).line_id;
2040         x_tax_out_tbl(k).trx_level_type           := om_tax_info_rec_tbl(i).trx_level_type;
2041         k                                         := k + 1;
2042       END LOOP;
2043     END IF;
2044   END LOOP;
2045 
2046   oe_debug_pub.add('End tax Line');
2047 EXCEPTION
2048 WHEN NO_DATA_FOUND THEN
2049 
2050   x_return_status := FND_API.G_RET_STS_SUCCESS;
2051 WHEN OTHERS THEN
2052   IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2053     OE_MSG_PUB.Add_Exc_Msg ( 'OM_TAX_UTIL' , 'Tax_Line' );
2054   END IF;
2055   IF l_debug_level > 0 THEN
2056     oe_debug_pub.add('some error occurred  ' || sqlerrm , 1);
2057   END IF;
2058   x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2059   RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060   --dbms_output.put_line('some error occurred  ' || sqlerrm  );
2061 END TAX_LINE;
2062 
2063 
2064 -- added for bug 1406890
2065 PROCEDURE CALCULATE_TAX(p_header_id IN NUMBER
2066                        ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2) AS
2067 
2068 l_index			NUMBER := 1;
2069 j  NUMBER;       --TAX ER
2070 l_entity_id_tbl         OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type;
2071 l_return_status         VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2072 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2073 l_org_id                NUMBER(15):=MO_GLOBAL.Get_Current_Org_Id;
2074 
2075 TYPE num_tbl is TABLE OF NUMBER;
2076 l_num_tbl num_tbl := num_tbl();
2077 
2078 CURSOR order_line_cur IS
2079 SELECT line_id
2080 FROM   oe_order_lines_all
2081 WHERE  header_id = p_header_id
2082 AND    open_flag = 'Y';           -- OPEN_FLAG added for bug 9897108
2083 
2084 BEGIN
2085   -- performance bug 4255597
2086   OPEN order_line_cur;
2087   FETCH order_line_cur BULK COLLECT INTO l_num_tbl;
2088   CLOSE order_line_cur;
2089 
2090   FOR i in 1..l_num_tbl.count LOOP
2091     l_entity_id_tbl(i).request_ind := i;
2092     l_entity_id_tbl(i).entity_id := l_num_tbl(i);
2093     l_entity_id_tbl(i).requesting_entity_code := OE_GLOBALS.G_ENTITY_LINE;  --TaxER
2094   END LOOP;
2095 
2096   --Bug#12311063
2097   if  (	NVL (oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y' ) then -- added if for bug#12333456
2098    j:= l_entity_id_tbl.Count + 1;
2099    l_entity_id_tbl(j).request_ind := j;
2100    l_entity_id_tbl(j).entity_id :=  p_header_id;
2101    l_entity_id_tbl(j).requesting_entity_code := OE_GLOBALS.G_ENTITY_HEADER;  --TaxER
2102  end if;
2103   --Bug#12311063
2104 
2105 
2106   OE_Delayed_Requests_UTIL.Process_Tax
2107    ( p_Entity_id_tbl      => l_entity_id_tbl
2108     ,x_return_status     => l_return_status
2109     );
2110 
2111   x_return_status := l_return_status;
2112 
2113   EXCEPTION
2114 
2115     WHEN OTHERS THEN
2116       IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2117         THEN
2118             OE_MSG_PUB.Add_Exc_Msg
2119             (   'OM_TAX_UTIL'          ,
2120                 'Calculate_Tax'
2121             );
2122       END IF;
2123 
2124       IF l_debug_level > 0 THEN
2125        oe_debug_pub.add('some error occurred  ' || sqlerrm , 1);
2126       END IF;
2127 
2128       x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129     RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2130 
2131 END CALCULATE_TAX;
2132 
2133 
2134 Procedure Debug_msg(p_index         IN  NUMBER,
2135 		    x_return_status OUT NOCOPY Varchar2) IS
2136 
2137 i	NUMBER;
2138 Begin
2139         i:=p_index;
2140 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));
2141 
2142 
2143 	IF i IS NOT NULL
2144 	   AND zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID.exists(i)
2145 THEN
2146 
2147         oe_debug_pub.add('Entering OM_TAX_UTIL.Debug_msg procedure ');
2148         oe_debug_pub.add(' i = '||i);
2149 	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));
2150 	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));
2151 	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));
2152 	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));
2153 	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));
2154 	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));
2155 	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));
2156 	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));
2157 	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));
2158 	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));
2159 	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));
2160 	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));
2161 	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));
2162 	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));
2163 	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));
2164 	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));
2165 	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));
2166 	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));
2167 	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));
2168 	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));
2169 	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));
2170 	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));
2171 	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));
2172 	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));
2173 	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));
2174 	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));
2175 	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));
2176 	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));
2177 	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));
2178 	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));
2179 	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));
2180 	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));
2181 	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));
2182 	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));
2183 	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));
2184 	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));
2185 	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));
2186 	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));
2187 	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));
2188 	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));
2189 	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));
2190 	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));
2191 	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));
2192 	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));
2193 	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));
2194 	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));
2195 	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));
2196 	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));
2197 	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));
2198 	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));
2199 	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));
2200 	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));
2201 	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));
2202 	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));
2203 	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));
2204 	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));
2205 	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));
2206 	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));
2207 	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));
2208 	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));
2209 	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));
2210 	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));
2211 	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));
2212 	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));
2213 	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));
2214 	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));
2215 	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));
2216 	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));
2217 	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));
2218 	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));
2219 	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));
2220 	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));
2221 	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));
2222 	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));
2223 	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));
2224 	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));
2225 	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));
2226 	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));
2227 	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));
2228 	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));
2229 	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));
2230 	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));
2231 	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));
2232 	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));
2233 	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));
2234 	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));
2235 	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));
2236 	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));
2237 	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));
2238 	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));
2239 	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));
2240 	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));
2241 	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));
2242 	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));
2243 	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));
2244 	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));
2245 	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));
2246 	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));
2247 	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));
2248 	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));
2249 	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));
2250 	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));
2251 	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));
2252 	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));
2253 	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));
2254 	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));
2255 	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));
2256 	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));
2257 	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));
2258 	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));
2259 	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));
2260 	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));
2261 	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));
2262 	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));
2263 	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));
2264 	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));
2265 	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));
2266 	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));
2267 	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));
2268 	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));
2269 	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));
2270 	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));
2271 	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));
2272 	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));
2273 	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));
2274 	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));
2275 	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));
2276 	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));
2277 	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));
2278 	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));
2279 	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));
2280 	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));
2281 	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));
2282 	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));
2283 	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));
2284 	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));
2285 	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));
2286 	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));
2287 	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));
2288 	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));
2289 	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));
2290 	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));
2291 	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));
2292 	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));
2293 	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));
2294 	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));
2295 	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));
2296 	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));
2297 	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));
2298 	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));
2299 	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));
2300 	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));
2301 	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));
2302 	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));
2303 	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));
2304 	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));
2305 	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));
2306 	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));
2307 	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));
2308 	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));
2309 	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));
2310 	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));
2311 	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));
2312 	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));
2313 	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));
2314 	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));
2315 	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));
2316 	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));
2317 	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));
2318 	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));
2319 	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));
2320 	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));
2321 	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));
2322 	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));
2323 	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));
2324 	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));
2325 	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));
2326 	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));
2327 	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));
2328 	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));
2329 	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));
2330 	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));
2331 	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));
2332 	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));
2333 	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));
2334 	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));
2335 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC1(i));
2336 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC2(i));
2337 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC3(i));
2338 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC4(i));
2339 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC5(i));
2340 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC6(i));
2341 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC7(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC7(i));
2342 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC8(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC8(i));
2343 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC9(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC9(i));
2344 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC10(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.NUMERIC10(i));
2345 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR1(i));
2346 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR2(i));
2347 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR3(i));
2348 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR4(i));
2349 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR5(i));
2350 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR6(i));
2351 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR7(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR7(i));
2352 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR8(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR8(i));
2353 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR9(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR9(i));
2354 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.CHAR10(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.CHAR10(i));
2355 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE1(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE1(i));
2356 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE2(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE2(i));
2357 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE3(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE3(i));
2358 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE4(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE4(i));
2359 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE5(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE5(i));
2360 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE6(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE6(i));
2361 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE7(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE7(i));
2362 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE8(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE8(i));
2363 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE9(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE9(i));
2364 	oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.DATE10(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.DATE10(i));
2365 	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));
2366 	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));
2367 	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));
2368 	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));
2369 	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));
2370 	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));
2371 	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));
2372 	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));
2373 	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));
2374 	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));
2375 	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));
2376 	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));
2377 	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));
2378 	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));
2379 	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));
2380 	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));
2381 	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));
2382 	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));
2383 	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));
2384 	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));
2385 	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));
2386 	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));
2387 	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));
2388 	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));
2389 	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));
2390 
2391 	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));
2392 	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));
2393 	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));
2394 	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));
2395 	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));
2396 	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));
2397 	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));
2398 	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));
2399 	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));
2400 	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));
2401 	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));
2402 	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));
2403 	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));
2404 	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));
2405 	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));
2406 	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));
2407 	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));
2408 	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));
2409 	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));
2410 	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));
2411 	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));
2412 	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));
2413 
2414 	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));
2415 	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));
2416 	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));
2417 	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));
2418 	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));
2419 	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));
2420         oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LEGAL_ENTITY_ID(i)= '||
2421                                    zx_global_structures_pkg.trx_line_dist_tbl.LEGAL_ENTITY_ID(i),3);
2422         oe_debug_pub.add('Exiting OM_TAX_UTIL.Debug_msg procedure ');
2423 ELSE
2424 	oe_debug_pub.add(' Index:'||i||' not avail for debug');
2425 END IF;
2426 
2427 End Debug_msg ;
2428 
2429 Function get_le_id(p_order_type_id NUMBER
2430                   , p_sold_to_customer_id NUMBER
2431                   , p_bill_to_customer_id NUMBER
2432                   , p_org_id NUMBER
2433 ) RETURN NUMBER IS
2434 
2435 l_invoice_source_id	NUMBER;
2436 l_invoice_source	VARCHAR2(50);
2437 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2438 l_order_type_rec  OE_ORDER_CACHE.ORDER_TYPE_REC_TYPE;
2439  l_customer_type      		VARCHAR2(30);
2440  l_customer_id        		NUMBER;
2441  l_batch_source_id		NUMBER;
2442  l_sold_to_customer_id		NUMBER;
2443 l_cust_trx_type_id              NUMBER;
2444 l_return_status         VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2445 l_legal_entity_id NUMBER;
2446 l_msg_data                     VARCHAR2(1000);
2447 BEGIN
2448 
2449       IF p_sold_to_customer_id IS NOT NULL THEN
2450         l_customer_type := 'SOLD_TO';
2451         l_customer_id := p_sold_to_customer_id;
2452       ELSIF p_bill_to_customer_id IS NOT NULL THEN
2453         l_customer_type := 'BILL_TO';
2454         l_customer_id := p_bill_to_customer_id;
2455       END IF;
2456 
2457      IF l_debug_level > 0 THEN
2458        oe_debug_pub.add('l_customer_type:'||l_customer_type, 3);
2459        oe_debug_pub.add('l_customer_id:'||l_customer_id, 3);
2460      END IF;
2461 
2462      l_order_type_rec := OE_ORDER_CACHE.Load_Order_Type(p_order_type_id);
2463      l_invoice_source_id := l_order_type_rec.invoice_source_id;
2464      l_cust_trx_type_id := l_order_type_rec.cust_trx_type_id;
2465 
2466      IF l_invoice_source_id IS NOT NULL THEN
2467         IF l_debug_level  > 0 THEN
2468           oe_debug_pub.add(  'INVOICE SOURCE ID IS ( 3 ) : '||L_INVOICE_SOURCE_ID , 5 ) ;
2469         END IF;
2470      ELSE
2471         l_invoice_source := oe_sys_parameters.value('INVOICE_SOURCE', p_org_id);
2472 
2473                    IF (l_invoice_source IS NOT NULL) THEN
2474 		   SELECT batch_source_id
2475 		     INTO l_invoice_source_id
2476 		     FROM ra_batch_sources
2477 		    WHERE name = l_invoice_source;
2478 
2479                    END IF;
2480 
2481 		   IF l_debug_level  > 0 THEN
2482 		       oe_debug_pub.add(  'INVOICE_SOURCE_ID IS ( 4 ) : '||L_INVOICE_SOURCE_ID , 5 ) ;
2483 		   END IF;
2484     END IF;
2485 
2486     IF l_cust_trx_type_id IS NULL THEN
2487           l_cust_trx_type_id := oe_sys_parameters.value('OE_INVOICE_TRANSACTION_TYPE_ID',p_org_id);
2488           IF l_debug_level  > 0 THEN
2489               oe_debug_pub.add(  'CUSTOMER TRANSACTION TYPE ID FROM sys parameter : '||L_CUST_TRX_TYPE_ID , 5 ) ;
2490           END IF;
2491    END IF;
2492 
2493    IF l_debug_level > 0 THEN
2494        oe_debug_pub.add('customer type:'||l_customer_type,3);
2495        oe_debug_pub.add('customer id:'||l_customer_id,3);
2496        oe_debug_pub.add('ar trx type:'||l_cust_trx_type_id,3);
2497        oe_debug_pub.add('batch source:'||l_invoice_source_id,3);
2498        oe_debug_pub.add('OU:'||p_org_id,3);
2499    END IF;
2500 
2501    l_legal_entity_id := XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info(
2502      x_return_status => l_return_status,		-- OUT
2503      x_msg_data => l_msg_data,		-- OUT
2504      p_customer_type => l_customer_type,		-- IN	P_customer_type
2505      p_customer_id => l_customer_id, 		-- IN	P_customer_id (sold_to/bill_to customer_id)
2506      p_transaction_type_id => l_cust_trx_type_id,	-- IN	P_transaction_type_id
2507      p_batch_source_id => l_invoice_source_id,		-- IN	P_batch_source_id
2508      p_operating_unit_id => p_org_id 	-- IN	P_operating_unit_id (org_id)
2509      );
2510 
2511      IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_legal_entity_id = -1 THEN
2512 
2513         IF l_debug_level > 0 THEN
2514    	    oe_debug_pub.add('In getting legal_entity_id, return status error'||l_msg_data);
2515         END IF;
2516            IF l_msg_data is not null then
2517   	     FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
2518 	     FND_MESSAGE.SET_TOKEN('TEXT',l_msg_data);
2519 	     OE_MSG_PUB.Add;
2520            ELSE
2521 	     OE_MSG_PUB.Add_text('XLE call raised Error ' );  --For bug # 4206796
2522  	   END IF;
2523          RETURN -1;
2524      END IF;
2525 
2526      IF l_debug_level > 0 THEN
2527    	oe_debug_pub.add('legal_entity_id is '||l_legal_entity_id);
2528      END IF;
2529 
2530      RETURN l_legal_entity_id;
2531   EXCEPTION
2532       WHEN OTHERS THEN
2533 
2534       	IF l_debug_level  > 0 THEN
2535 	   oe_debug_pub.add(  'Error getting legal_entity_id'||sqlerrm);
2536 	END IF;
2537       RETURN -1;
2538 END get_le_id;
2539 
2540 /* ==============================================================+
2541  * FUNCTION Get_Content_Owner_Id
2542  *
2543  * Description:
2544  *  Created for R12  Vertext project called from oip and sales order form
2545  *  Function Get_Content_Owner_Id
2546  *  is calling  APIs : XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info
2547  *  and ZX_TCM_PTP_PKG.get_tax_subscriber to get content_owner_id
2548  *================================================================*/
2549 
2550 FUNCTION Get_Content_Owner_Id(
2551 p_header_id          IN  NUMBER)
2552 RETURN  NUMBER
2553 IS
2554 
2555 l_org_id               NUMBER;
2556 l_le_id                NUMBER;
2557 l_conten_owner_id      NUMBER;
2558 l_return_status        VARCHAR2(1);
2559 l_msg_data             VARCHAR2(1000);
2560 l_sold_to_customer_id  NUMBER;
2561 l_bill_to_customer_id          NUMBER;
2562 l_invoice_to_org_id NUMBER;
2563 l_order_type_id        NUMBER;
2564 l_batch_source_id      NUMBER;
2565 l_otoc_Le_info         XLE_BUSINESSINFO_GRP.otoc_le_rec;
2566 
2567 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2568 
2569 BEGIN
2570 
2571 
2572   SELECT org_id
2573         ,SOLD_TO_ORG_ID
2574         ,INVOICE_TO_ORG_ID
2575         ,ORDER_TYPE_ID
2576   INTO l_org_id
2577       ,l_sold_to_customer_id
2578       ,l_invoice_to_org_id
2579       ,l_order_type_id
2580   FROM oe_order_headers_all
2581   WHERE header_id = p_header_id;
2582 
2583   IF (l_invoice_to_org_id IS NOT NULL) THEN
2584     SELECT acct_site.cust_account_id
2585     INTO l_bill_to_customer_id
2586     FROM HZ_CUST_SITE_USES_ALL         site_use ,
2587        HZ_CUST_ACCT_SITES_ALL      acct_site
2588     WHERE site_use.site_use_id = l_invoice_to_org_id
2589     AND   site_use.cust_acct_site_id = acct_site.cust_acct_site_id;
2590   END IF;
2591 
2592   l_le_id := Get_Le_Id(p_order_type_id => l_order_type_id
2593             , p_sold_to_customer_id => l_sold_to_customer_id
2594             , p_bill_to_customer_id => l_bill_to_customer_id
2595             , p_org_id      => l_org_id);
2596 
2597 
2598     IF l_debug_level  > 0 THEN
2599           oe_debug_pub.add('Get_le_id: '||l_le_id, 2) ;
2600     END IF;
2601 
2602 
2603 
2604   -- Call ZX_TCM_PTP_PKG.get_tax_subscriber
2605   -- to get conten_owner_id
2606 
2607   ZX_TCM_PTP_PKG.get_tax_subscriber(
2608                  p_le_id   => l_le_id
2609                 ,p_org_id  => l_org_id
2610                 ,p_ptp_id  => l_conten_owner_id
2611                 ,p_return_status => l_return_status);
2612 
2613   IF l_return_status = 'S' THEN
2614      return l_conten_owner_id ;
2615   ELSE
2616      IF l_debug_level  > 0 THEN
2617           oe_debug_pub.add('Return Status from ZX_TCM_PTP_PKG.get_tax_subscriber '||l_return_status, 1) ;
2618      END IF;
2619      RAISE FND_API.G_EXC_ERROR;
2620   END IF;
2621 
2622 EXCEPTION
2623 WHEN OTHERS THEN
2624          OE_MSG_PUB.Add_Exc_Msg
2625             (   'OM_TAX_UTIL'
2626             ,  'Get_Content_Owner_Id'
2627             );
2628          RETURN -99;
2629 
2630 END Get_Content_Owner_Id;
2631 
2632 
2633 END OM_TAX_UTIL;