[Home] [Help]
PACKAGE BODY: APPS.ZX_GET_TAX_PARAM_DRIVER_PKG
Source
4
1 PACKAGE BODY ZX_GET_TAX_PARAM_DRIVER_PKG AS
2 /* $Header: zxifgetparampkgb.pls 120.39 2011/08/08 13:57:55 srajapar ship $ */
3
5 G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6 G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7 G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8 G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9 G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10 G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11 G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12 G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_GET_TAX_PARAM_DRIVER_PKG.';
13
14
15
16 PROCEDURE get_driver_value
17 (
18 p_struct_name IN VARCHAR2,
19 p_struct_index IN BINARY_INTEGER,
20 p_tax_param_code IN VARCHAR2,
21 x_tax_param_value OUT NOCOPY NUMBER,
22 x_return_status OUT NOCOPY VARCHAR2
23 ) IS
24
25 BEGIN
26
27 IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
28 FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'GET_DRIVER_VALUE.BEGIN','ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()+ Number');
29 END IF;
30
31 x_return_status := FND_API.G_RET_STS_SUCCESS;
32
33 IF p_struct_name = 'TRX_LINE_DIST_TBL' THEN
34
35 IF p_tax_param_code = 'BILL_TO_LOCATION_ID' THEN
36 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_TO_LOCATION_ID(p_struct_index) ;
37 ELSIF p_tax_param_code = 'BILL_TO_PARTY_ID' THEN
38 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_TO_PARTY_ID(p_struct_index) ;
39 ELSIF p_tax_param_code = 'BILL_TO_PARTY_TAX_PROF_ID' THEN
40 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_TO_PARTY_TAX_PROF_ID(p_struct_index) ;
41 ELSIF p_tax_param_code = 'BILL_FROM_LOCATION_ID' THEN
42 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_FROM_LOCATION_ID(p_struct_index) ;
43 ELSIF p_tax_param_code = 'BILL_FROM_PARTY_ID' THEN
44 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_FROM_PARTY_ID(p_struct_index) ;
45 ELSIF p_tax_param_code = 'BILL_FROM_PARTY_TAX_PROF_ID' THEN
46 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_FROM_PARTY_TAX_PROF_ID(p_struct_index) ;
47 ELSIF p_tax_param_code = 'SHIP_TO_LOCATION_ID' THEN
48 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_TO_LOCATION_ID(p_struct_index) ;
49 ELSIF p_tax_param_code = 'SHIP_TO_PARTY_ID' THEN
50 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_TO_PARTY_ID(p_struct_index) ;
51 ELSIF p_tax_param_code = 'SHIP_TO_SITE_TAX_PROF_ID' THEN
52 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_TO_SITE_TAX_PROF_ID(p_struct_index) ;
53 ELSIF p_tax_param_code = 'SHIP_FROM_LOCATION_ID' THEN
54 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_FROM_LOCATION_ID(p_struct_index) ;
55 ELSIF p_tax_param_code = 'SHIP_FROM_PARTY_ID' THEN
56 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_FROM_PARTY_ID(p_struct_index) ;
57 ELSIF p_tax_param_code = 'SHIP_FROM_SITE_TAX_PROF_ID' THEN
58 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_FROM_SITE_TAX_PROF_ID(p_struct_index) ;
59 ELSIF p_tax_param_code = 'PRODUCT_ID' THEN
60 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_ID(p_struct_index) ;
61 ELSIF p_tax_param_code = 'PRODUCT_ORG_ID' THEN
62 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_ORG_ID(p_struct_index) ;
63 ELSIF p_tax_param_code = 'LEDGER_ID' THEN
64 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LEDGER_ID(p_struct_index) ;
65 ELSIF p_tax_param_code = 'ACCOUNT_CCID' THEN
66 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_struct_index) ;
67 ELSIF p_tax_param_code = 'HQ_ESTB_PARTY_TAX_PROF_ID' THEN
68 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.HQ_ESTB_PARTY_TAX_PROF_ID(p_struct_index) ;
69 ELSIF p_tax_param_code = 'INTERNAL_ORG_LOCATION_ID' THEN
70 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORG_LOCATION_ID(p_struct_index) ;
71 ELSIF p_tax_param_code = 'INTERNAL_ORGANIZATION_ID' THEN
72 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_struct_index) ;
73 ELSIF p_tax_param_code = 'APPLICATION_ID' THEN
74 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLICATION_ID(p_struct_index) ;
75 ELSIF p_tax_param_code = 'TRX_ID' THEN
76 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_ID(p_struct_index) ;
77 ELSIF p_tax_param_code = 'TRX_LINE_ID' THEN
78 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_ID(p_struct_index) ;
79 ELSIF p_tax_param_code = 'CURRENCY_CONVERSION_RATE' THEN
83 ELSIF p_tax_param_code = 'PRECISION' THEN
80 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CURRENCY_CONVERSION_RATE(p_struct_index) ;
81 ELSIF p_tax_param_code = 'MINIMUM_ACCOUNTABLE_UNIT' THEN
82 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.MINIMUM_ACCOUNTABLE_UNIT(p_struct_index) ;
84 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRECISION(p_struct_index) ;
85 ELSIF p_tax_param_code = 'LEGAL_ENTITY_ID' THEN
86 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LEGAL_ENTITY_ID(p_struct_index) ;
87 ELSIF p_tax_param_code = 'ESTABLISHMENT_ID' THEN
88 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ESTABLISHMENT_ID(p_struct_index) ;
89 ELSIF p_tax_param_code = 'LINE_AMT' THEN
90 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_AMT(p_struct_index) ;
91 ELSIF p_tax_param_code = 'TRX_LINE_QUANTITY' THEN
92 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_QUANTITY(p_struct_index) ;
93 ELSIF p_tax_param_code = 'UNIT_PRICE' THEN
94 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.UNIT_PRICE(p_struct_index) ;
95 ELSIF p_tax_param_code = 'CASH_DISCOUNT' THEN
96 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CASH_DISCOUNT(p_struct_index) ;
97 ELSIF p_tax_param_code = 'VOLUME_DISCOUNT' THEN
98 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.VOLUME_DISCOUNT(p_struct_index) ;
99 ELSIF p_tax_param_code = 'TRADING_DISCOUNT' THEN
100 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRADING_DISCOUNT(p_struct_index) ;
101 ELSIF p_tax_param_code = 'TRANSFER_CHARGE' THEN
102 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRANSFER_CHARGE(p_struct_index) ;
103 ELSIF p_tax_param_code = 'TRANSPORTATION_CHARGE' THEN
104 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRANSPORTATION_CHARGE(p_struct_index) ;
105 ELSIF p_tax_param_code = 'INSURANCE_CHARGE' THEN
106 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INSURANCE_CHARGE(p_struct_index) ;
107 ELSIF p_tax_param_code = 'OTHER_CHARGE' THEN
108 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.OTHER_CHARGE(p_struct_index) ;
109 ELSIF p_tax_param_code = 'POA_LOCATION_ID' THEN
110 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POA_LOCATION_ID(p_struct_index) ;
111 ELSIF p_tax_param_code = 'POO_LOCATION_ID' THEN
112 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POO_LOCATION_ID(p_struct_index) ;
113 ELSIF p_tax_param_code = 'RECEIVABLES_TRX_TYPE_ID' THEN
114 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RECEIVABLES_TRX_TYPE_ID(p_struct_index) ;
115 ELSIF p_tax_param_code = 'REF_DOC_APPLICATION_ID' THEN
116 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_APPLICATION_ID(p_struct_index) ;
117 ELSIF p_tax_param_code = 'REF_DOC_TRX_ID' THEN
118 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_TRX_ID(p_struct_index) ;
119 ELSIF p_tax_param_code = 'REF_DOC_LINE_ID' THEN
120 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_LINE_ID(p_struct_index) ;
121 ELSIF p_tax_param_code = 'REF_DOC_LINE_QUANTITY' THEN
122 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_LINE_QUANTITY(p_struct_index) ;
123 ELSIF p_tax_param_code = 'RELATED_DOC_APPLICATION_ID' THEN
124 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RELATED_DOC_APPLICATION_ID(p_struct_index) ;
125 ELSIF p_tax_param_code = 'RELATED_DOC_TRX_ID' THEN
126 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RELATED_DOC_TRX_ID(p_struct_index) ;
127 ELSIF p_tax_param_code = 'APPLIED_FROM_APPLICATION_ID' THEN
128 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_FROM_APPLICATION_ID(p_struct_index) ;
129 ELSIF p_tax_param_code = 'APPLIED_FROM_TRX_ID' THEN
130 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_FROM_TRX_ID(p_struct_index) ;
131 ELSIF p_tax_param_code = 'APPLIED_FROM_LINE_ID' THEN
132 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_FROM_LINE_ID(p_struct_index) ;
133 ELSIF p_tax_param_code = 'APPLIED_FROM_DIST_ID' THEN
134 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_FROM_DIST_ID(p_struct_index) ;
135 ELSIF p_tax_param_code = 'ADJUSTED_DOC_APPLICATION_ID' THEN
136 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJUSTED_DOC_APPLICATION_ID(p_struct_index) ;
137 ELSIF p_tax_param_code = 'ADJUSTED_DOC_EVENT_CLASS_CODE' THEN
138 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJUSTED_DOC_EVENT_CLASS_CODE(p_struct_index) ;
139 ELSIF p_tax_param_code = 'ADJUSTED_DOC_TRX_ID' THEN
140 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJUSTED_DOC_TRX_ID(p_struct_index) ;
141 ELSIF p_tax_param_code = 'ADJUSTED_DOC_LINE_ID' THEN
142 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJUSTED_DOC_LINE_ID(p_struct_index) ;
143 ELSIF p_tax_param_code = 'APPLIED_TO_APPLICATION_ID' THEN
144 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_TO_APPLICATION_ID(p_struct_index) ;
145 ELSIF p_tax_param_code = 'APPLIED_TO_TRX_ID' THEN
146 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_TO_TRX_ID(p_struct_index) ;
147 ELSIF p_tax_param_code = 'APPLIED_TO_TRX_LINE_ID' THEN
148 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_TO_TRX_LINE_ID(p_struct_index) ;
149 ELSIF p_tax_param_code = 'TRX_LINE_NUMBER' THEN
150 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_NUMBER(p_struct_index) ;
151 ELSIF p_tax_param_code = 'BATCH_SOURCE_ID' THEN
152 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BATCH_SOURCE_ID(p_struct_index) ;
153 ELSIF p_tax_param_code = 'DOC_SEQ_ID' THEN
157 ELSIF p_tax_param_code = 'OWN_HQ_LOCATION_ID' THEN
154 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DOC_SEQ_ID(p_struct_index) ;
155 ELSIF p_tax_param_code = 'PAYING_LOCATION_ID' THEN
156 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PAYING_LOCATION_ID(p_struct_index) ;
158 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.OWN_HQ_LOCATION_ID(p_struct_index) ;
159 ELSIF p_tax_param_code = 'TRADING_HQ_LOCATION_ID' THEN
160 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRADING_HQ_LOCATION_ID(p_struct_index) ;
161 ELSIF p_tax_param_code = 'POC_LOCATION_ID' THEN
162 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POC_LOCATION_ID(p_struct_index) ;
163 ELSIF p_tax_param_code = 'POI_LOCATION_ID' THEN
164 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POI_LOCATION_ID(p_struct_index) ;
165 ELSIF p_tax_param_code = 'POD_LOCATION_ID' THEN
166 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POD_LOCATION_ID(p_struct_index) ;
167 ELSIF p_tax_param_code = 'TITLE_TRANSFER_LOCATION_ID' THEN
168 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TITLE_TRANSFER_LOCATION_ID(p_struct_index) ;
169 ELSIF p_tax_param_code = 'ASSESSABLE_VALUE' THEN
170 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ASSESSABLE_VALUE(p_struct_index) ;
171 ELSIF p_tax_param_code = 'ASSET_ACCUM_DEPRECIATION' THEN
172 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ASSET_ACCUM_DEPRECIATION(p_struct_index) ;
173 ELSIF p_tax_param_code = 'ASSET_COST' THEN
174 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ASSET_COST(p_struct_index) ;
175 ELSIF p_tax_param_code = 'FIRST_PTY_ORG_ID' THEN
176 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.FIRST_PTY_ORG_ID(p_struct_index) ;
177 ELSIF p_tax_param_code = 'RDNG_SHIP_TO_PTY_TX_PROF_ID' THEN
178 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RDNG_SHIP_TO_PTY_TX_PROF_ID(p_struct_index) ;
179 ELSIF p_tax_param_code = 'RDNG_SHIP_FROM_PTY_TX_PROF_ID' THEN
180 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RDNG_SHIP_FROM_PTY_TX_PROF_ID(p_struct_index) ;
181 ELSIF p_tax_param_code = 'RDNG_BILL_TO_PTY_TX_PROF_ID' THEN
182 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RDNG_BILL_TO_PTY_TX_PROF_ID(p_struct_index) ;
183 ELSIF p_tax_param_code = 'RDNG_BILL_FROM_PTY_TX_PROF_ID' THEN
184 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RDNG_BILL_FROM_PTY_TX_PROF_ID(p_struct_index) ;
185 ELSIF p_tax_param_code = 'RDNG_SHIP_TO_PTY_TX_P_ST_ID' THEN
186 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RDNG_SHIP_TO_PTY_TX_P_ST_ID(p_struct_index) ;
187 ELSIF p_tax_param_code = 'RDNG_SHIP_FROM_PTY_TX_P_ST_ID' THEN
188 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RDNG_SHIP_FROM_PTY_TX_P_ST_ID(p_struct_index) ;
189 ELSIF p_tax_param_code = 'RDNG_BILL_TO_PTY_TX_P_ST_ID' THEN
190 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RDNG_BILL_TO_PTY_TX_P_ST_ID(p_struct_index) ;
191 ELSIF p_tax_param_code = 'RDNG_BILL_FROM_PTY_TX_P_ST_ID' THEN
192 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RDNG_BILL_FROM_PTY_TX_P_ST_ID(p_struct_index) ;
193 ELSIF p_tax_param_code = 'SHIP_TO_PARTY_TAX_PROF_ID' THEN
194 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_TO_PARTY_TAX_PROF_ID(p_struct_index) ;
195 ELSIF p_tax_param_code = 'SHIP_FROM_PARTY_TAX_PROF_ID' THEN
196 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_FROM_PARTY_TAX_PROF_ID(p_struct_index) ;
197 ELSIF p_tax_param_code = 'POA_PARTY_TAX_PROF_ID' THEN
198 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POA_PARTY_TAX_PROF_ID(p_struct_index) ;
199 ELSIF p_tax_param_code = 'POO_PARTY_TAX_PROF_ID' THEN
200 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POO_PARTY_TAX_PROF_ID(p_struct_index) ;
201 ELSIF p_tax_param_code = 'PAYING_PARTY_TAX_PROF_ID' THEN
202 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PAYING_PARTY_TAX_PROF_ID(p_struct_index) ;
203 ELSIF p_tax_param_code = 'OWN_HQ_PARTY_TAX_PROF_ID' THEN
204 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.OWN_HQ_PARTY_TAX_PROF_ID(p_struct_index) ;
205 ELSIF p_tax_param_code = 'TRADING_HQ_PARTY_TAX_PROF_ID' THEN
206 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRADING_HQ_PARTY_TAX_PROF_ID(p_struct_index) ;
207 ELSIF p_tax_param_code = 'POI_PARTY_TAX_PROF_ID' THEN
208 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POI_PARTY_TAX_PROF_ID(p_struct_index) ;
209 ELSIF p_tax_param_code = 'POD_PARTY_TAX_PROF_ID' THEN
210 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POD_PARTY_TAX_PROF_ID(p_struct_index) ;
211 ELSIF p_tax_param_code = 'TITLE_TRANS_PARTY_TAX_PROF_ID' THEN
212 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TITLE_TRANS_PARTY_TAX_PROF_ID(p_struct_index) ;
213 ELSIF p_tax_param_code = 'POA_SITE_TAX_PROF_ID' THEN
214 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POA_SITE_TAX_PROF_ID(p_struct_index) ;
215 ELSIF p_tax_param_code = 'POO_SITE_TAX_PROF_ID' THEN
216 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POO_SITE_TAX_PROF_ID(p_struct_index) ;
217 ELSIF p_tax_param_code = 'PAYING_SITE_TAX_PROF_ID' THEN
218 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PAYING_SITE_TAX_PROF_ID(p_struct_index) ;
219 ELSIF p_tax_param_code = 'OWN_HQ_SITE_TAX_PROF_ID' THEN
220 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.OWN_HQ_SITE_TAX_PROF_ID(p_struct_index) ;
221 ELSIF p_tax_param_code = 'TRADING_HQ_SITE_TAX_PROF_ID' THEN
222 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRADING_HQ_SITE_TAX_PROF_ID(p_struct_index) ;
223 ELSIF p_tax_param_code = 'POI_SITE_TAX_PROF_ID' THEN
224 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POI_SITE_TAX_PROF_ID(p_struct_index) ;
228 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_TO_SITE_TAX_PROF_ID(p_struct_index) ;
225 ELSIF p_tax_param_code = 'POD_SITE_TAX_PROF_ID' THEN
226 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POD_SITE_TAX_PROF_ID(p_struct_index) ;
227 ELSIF p_tax_param_code = 'BILL_TO_SITE_TAX_PROF_ID' THEN
229 ELSIF p_tax_param_code = 'BILL_FROM_SITE_TAX_PROF_ID' THEN
230 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_FROM_SITE_TAX_PROF_ID(p_struct_index) ;
231 ELSIF p_tax_param_code = 'TITLE_TRANS_SITE_TAX_PROF_ID' THEN
232 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TITLE_TRANS_SITE_TAX_PROF_ID(p_struct_index) ;
233 ELSIF p_tax_param_code = 'MERCHANT_PARTY_TAX_PROF_ID' THEN
234 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.MERCHANT_PARTY_TAX_PROF_ID(p_struct_index) ;
235 ELSIF p_tax_param_code = 'ITEM_DIST_NUMBER' THEN
236 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ITEM_DIST_NUMBER(p_struct_index) ;
237 ELSIF p_tax_param_code = 'TASK_ID' THEN
238 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TASK_ID(p_struct_index) ;
239 ELSIF p_tax_param_code = 'APPLIED_FROM_TAX_DIST_ID' THEN
240 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_FROM_TAX_DIST_ID(p_struct_index) ;
241 ELSIF p_tax_param_code = 'ADJUSTED_DOC_TAX_DIST_ID' THEN
242 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJUSTED_DOC_TAX_DIST_ID(p_struct_index) ;
243 ELSIF p_tax_param_code = 'AWARD_ID' THEN
244 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.AWARD_ID(p_struct_index) ;
245 ELSIF p_tax_param_code = 'PROJECT_ID' THEN
246 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PROJECT_ID(p_struct_index) ;
247 ELSIF p_tax_param_code = 'EXPENDITURE_ORGANIZATION_ID' THEN
248 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ORGANIZATION_ID(p_struct_index) ;
249 ELSIF p_tax_param_code = 'TRX_LINE_DIST_AMT' THEN
250 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_struct_index) ;
251 ELSIF p_tax_param_code = 'TRX_LINE_DIST_QUANTITY' THEN
252 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_struct_index) ;
253 ELSIF p_tax_param_code = 'REF_DOC_DIST_ID' THEN
254 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_DIST_ID(p_struct_index) ;
255 ELSIF p_tax_param_code = 'REF_DOC_CURR_CONV_RATE' THEN
256 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_CURR_CONV_RATE(p_struct_index) ;
257 ELSIF p_tax_param_code = 'TRX_LINE_DIST_TAX_AMT' THEN
258 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_TAX_AMT(p_struct_index) ;
259 ELSIF p_tax_param_code = 'TRX_LINE_DIST_ID' THEN
260 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_ID(p_struct_index) ;
261 ELSIF p_tax_param_code = 'ADJUSTED_DOC_DIST_ID' THEN
262 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJUSTED_DOC_DIST_ID(p_struct_index) ;
263 ELSIF p_tax_param_code = 'CTRL_TOTAL_HDR_TX_AMT' THEN
264 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CTRL_TOTAL_HDR_TX_AMT(p_struct_index) ;
265 ELSIF p_tax_param_code = 'CTRL_TOTAL_LINE_TX_AMT' THEN
266 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CTRL_TOTAL_LINE_TX_AMT(p_struct_index) ;
267 ELSIF p_tax_param_code = 'SUPPLIER_EXCHANGE_RATE' THEN
268 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SUPPLIER_EXCHANGE_RATE(p_struct_index) ;
269 ELSIF p_tax_param_code = 'TAX_INVOICE_NUMBER' THEN
270 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TAX_INVOICE_NUMBER(p_struct_index) ;
271 ELSIF p_tax_param_code = 'SHIP_TO_PARTY_SITE_ID' THEN
272 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_TO_PARTY_SITE_ID(p_struct_index) ;
273 ELSIF p_tax_param_code = 'SHIP_FROM_PARTY_SITE_ID' THEN
274 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_FROM_PARTY_SITE_ID(p_struct_index) ;
275 ELSIF p_tax_param_code = 'POA_PARTY_SITE_ID' THEN
276 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POA_PARTY_SITE_ID(p_struct_index) ;
277 ELSIF p_tax_param_code = 'POO_PARTY_SITE_ID' THEN
278 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POO_PARTY_SITE_ID(p_struct_index) ;
279 ELSIF p_tax_param_code = 'BILL_TO_PARTY_SITE_ID' THEN
280 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_TO_PARTY_SITE_ID(p_struct_index) ;
281 ELSIF p_tax_param_code = 'BILL_FROM_PARTY_SITE_ID' THEN
282 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_FROM_PARTY_SITE_ID(p_struct_index) ;
283 ELSIF p_tax_param_code = 'PAYING_PARTY_SITE_ID' THEN
284 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PAYING_PARTY_SITE_ID(p_struct_index) ;
285 ELSIF p_tax_param_code = 'OWN_HQ_PARTY_SITE_ID' THEN
286 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.OWN_HQ_PARTY_SITE_ID(p_struct_index) ;
287 ELSIF p_tax_param_code = 'TRADING_HQ_PARTY_SITE_ID' THEN
288 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRADING_HQ_PARTY_SITE_ID(p_struct_index) ;
289 ELSIF p_tax_param_code = 'POI_PARTY_SITE_ID' THEN
290 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POI_PARTY_SITE_ID(p_struct_index) ;
291 ELSIF p_tax_param_code = 'POD_PARTY_SITE_ID' THEN
292 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POD_PARTY_SITE_ID(p_struct_index) ;
293 ELSIF p_tax_param_code = 'TITLE_TRANSFER_PARTY_SITE_ID' THEN
294 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TITLE_TRANSFER_PARTY_SITE_ID(p_struct_index) ;
295 ELSIF p_tax_param_code = 'ROUNDING_SHIP_TO_PARTY_ID' THEN
296 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ROUNDING_SHIP_TO_PARTY_ID(p_struct_index) ;
297 ELSIF p_tax_param_code = 'ROUNDING_SHIP_FROM_PARTY_ID' THEN
301 ELSIF p_tax_param_code = 'ROUNDING_BILL_FROM_PARTY_ID' THEN
298 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ROUNDING_SHIP_FROM_PARTY_ID(p_struct_index) ;
299 ELSIF p_tax_param_code = 'ROUNDING_BILL_TO_PARTY_ID' THEN
300 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ROUNDING_BILL_TO_PARTY_ID(p_struct_index) ;
302 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ROUNDING_BILL_FROM_PARTY_ID(p_struct_index) ;
303 ELSIF p_tax_param_code = 'RNDG_SHIP_TO_PARTY_SITE_ID' THEN
304 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RNDG_SHIP_TO_PARTY_SITE_ID(p_struct_index) ;
305 ELSIF p_tax_param_code = 'RNDG_SHIP_FROM_PARTY_SITE_ID' THEN
306 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RNDG_SHIP_FROM_PARTY_SITE_ID(p_struct_index) ;
307 ELSIF p_tax_param_code = 'RNDG_BILL_TO_PARTY_SITE_ID' THEN
308 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RNDG_BILL_TO_PARTY_SITE_ID(p_struct_index) ;
309 ELSIF p_tax_param_code = 'RNDG_BILL_FROM_PARTY_SITE_ID' THEN
310 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RNDG_BILL_FROM_PARTY_SITE_ID(p_struct_index) ;
311 ELSIF p_tax_param_code = 'POA_PARTY_ID' THEN
312 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POA_PARTY_ID(p_struct_index) ;
313 ELSIF p_tax_param_code = 'POO_PARTY_ID' THEN
314 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POO_PARTY_ID(p_struct_index) ;
315 ELSIF p_tax_param_code = 'MERCHANT_PARTY_ID' THEN
316 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.MERCHANT_PARTY_ID(p_struct_index) ;
317 ELSIF p_tax_param_code = 'PAYING_PARTY_ID' THEN
318 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PAYING_PARTY_ID(p_struct_index) ;
319 ELSIF p_tax_param_code = 'OWN_HQ_PARTY_ID' THEN
320 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.OWN_HQ_PARTY_ID(p_struct_index) ;
321 ELSIF p_tax_param_code = 'TRADING_HQ_PARTY_ID' THEN
322 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRADING_HQ_PARTY_ID(p_struct_index) ;
323 ELSIF p_tax_param_code = 'POI_PARTY_ID' THEN
324 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POI_PARTY_ID(p_struct_index) ;
325 ELSIF p_tax_param_code = 'POD_PARTY_ID' THEN
326 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.POD_PARTY_ID(p_struct_index) ;
327 ELSIF p_tax_param_code = 'TITLE_TRANSFER_PARTY_ID' THEN
328 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TITLE_TRANSFER_PARTY_ID(p_struct_index) ;
329 ELSIF p_tax_param_code = 'SHIP_THIRD_PTY_ACCT_SITE_ID' THEN
330 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_THIRD_PTY_ACCT_SITE_ID(p_struct_index) ;
331 ELSIF p_tax_param_code = 'BILL_THIRD_PTY_ACCT_SITE_ID' THEN
332 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_THIRD_PTY_ACCT_SITE_ID(p_struct_index) ;
333 ELSIF p_tax_param_code = 'SHIP_TO_CUST_ACCT_SITE_USE_ID' THEN
334 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_TO_CUST_ACCT_SITE_USE_ID(p_struct_index) ;
335 ELSIF p_tax_param_code = 'BILL_TO_CUST_ACCT_SITE_USE_ID' THEN
336 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_TO_CUST_ACCT_SITE_USE_ID(p_struct_index) ;
337 ELSIF p_tax_param_code = 'SHIP_THIRD_PTY_ACCT_ID' THEN
338 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SHIP_THIRD_PTY_ACCT_ID(p_struct_index) ;
339 ELSIF p_tax_param_code = 'BILL_THIRD_PTY_ACCT_ID' THEN
340 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BILL_THIRD_PTY_ACCT_ID(p_struct_index) ;
341 ELSIF p_tax_param_code = 'SOURCE_APPLICATION_ID' THEN
342 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SOURCE_APPLICATION_ID(p_struct_index) ;
343 ELSIF p_tax_param_code = 'SOURCE_TRX_ID' THEN
344 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SOURCE_TRX_ID(p_struct_index) ;
345 ELSIF p_tax_param_code = 'SOURCE_LINE_ID' THEN
346 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SOURCE_LINE_ID(p_struct_index) ;
347 ELSIF p_tax_param_code = 'TRX_BATCH_ID' THEN
348 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_BATCH_ID(p_struct_index) ;
349 ELSIF p_tax_param_code = 'OVERRIDING_RECOVERY_RATE' THEN
350 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.OVERRIDING_RECOVERY_RATE(p_struct_index) ;
351 ELSIF p_tax_param_code = 'SOURCE_TAX_LINE_ID' THEN
352 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SOURCE_TAX_LINE_ID(p_struct_index) ;
353 ELSIF p_tax_param_code = 'HISTORICAL_TAX_CODE_ID' THEN
354 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.HISTORICAL_TAX_CODE_ID(p_struct_index) ;
355 ELSIF p_tax_param_code = 'TRX_LINE_CURRENCY_CONV_RATE' THEN
356 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_CURRENCY_CONV_RATE(p_struct_index) ;
357 ELSIF p_tax_param_code = 'TRX_LINE_MAU' THEN
358 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_MAU(p_struct_index) ;
359 ELSIF p_tax_param_code = 'TRX_LINE_PRECISION' THEN
360 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_PRECISION(p_struct_index) ;
361 ELSIF p_tax_param_code = 'INTERFACE_LINE_ID' THEN
362 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERFACE_LINE_ID(p_struct_index) ;
363 ELSIF p_tax_param_code = 'REVERSED_APPLN_ID' THEN
364 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REVERSED_APPLN_ID(p_struct_index) ;
365 ELSIF p_tax_param_code = 'REVERSED_TRX_ID' THEN
366 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REVERSED_TRX_ID(p_struct_index) ;
367 ELSIF p_tax_param_code = 'REVERSED_TRX_LINE_ID' THEN
368 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REVERSED_TRX_LINE_ID(p_struct_index) ;
369 ELSIF p_tax_param_code = 'TRX_ID_LEVEL2' THEN
373 ELSIF p_tax_param_code = 'TRX_ID_LEVEL4' THEN
370 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_ID_LEVEL2(p_struct_index) ;
371 ELSIF p_tax_param_code = 'TRX_ID_LEVEL3' THEN
372 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_ID_LEVEL3(p_struct_index) ;
374 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_ID_LEVEL4(p_struct_index) ;
375 ELSIF p_tax_param_code = 'TRX_ID_LEVEL5' THEN
376 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_ID_LEVEL5(p_struct_index) ;
377 ELSIF p_tax_param_code = 'TRX_ID_LEVEL6' THEN
378 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_ID_LEVEL6(p_struct_index) ;
379 ELSIF p_tax_param_code = 'NUMERIC1' THEN
380 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.NUMERIC1(p_struct_index) ;
381 ELSIF p_tax_param_code = 'NUMERIC2' THEN
382 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.NUMERIC2(p_struct_index) ;
383 ELSIF p_tax_param_code = 'NUMERIC3' THEN
384 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.NUMERIC3(p_struct_index) ;
385 ELSIF p_tax_param_code = 'NUMERIC4' THEN
386 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.NUMERIC4(p_struct_index) ;
387 ELSIF p_tax_param_code = 'NUMERIC5' THEN
388 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.NUMERIC5(p_struct_index) ;
389 ELSIF p_tax_param_code = 'NUMERIC6' THEN
390 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.NUMERIC6(p_struct_index) ;
391 ELSIF p_tax_param_code = 'NUMERIC7' THEN
392 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.NUMERIC7(p_struct_index) ;
393 ELSIF p_tax_param_code = 'NUMERIC8' THEN
394 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.NUMERIC8(p_struct_index) ;
395 ELSIF p_tax_param_code = 'NUMERIC9' THEN
396 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.NUMERIC9(p_struct_index) ;
397 ELSIF p_tax_param_code = 'NUMERIC10' THEN
398 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.NUMERIC10(p_struct_index) ;
399 END IF;
400 END IF;
401
402 IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
403 FND_LOG.STRING(
404 G_LEVEL_STATEMENT,
405 G_MODULE_NAME||'GET_DRIVER_VALUE.END',
406 'ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()- Number'||
407 ', p_tax_param_code:'||p_tax_param_code||' x_tax_param_value:'||to_char(x_tax_param_value)
408 );
409 END IF;
410
411 EXCEPTION
412 WHEN OTHERS THEN
413 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414 IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
415 FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||'GET_DRIVER_VALUE - Number:',SQLERRM);
416 END IF;
417
418 END get_driver_value;
419
420 PROCEDURE get_driver_value
421 (
422 p_struct_name IN VARCHAR2,
423 p_struct_index IN BINARY_INTEGER,
424 p_tax_param_code IN VARCHAR2,
425 x_tax_param_value OUT NOCOPY DATE,
426 x_return_status OUT NOCOPY VARCHAR2
427 ) IS
428
429
430 BEGIN
431
432 IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
433 FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'GET_DRIVER_VALUE.BEGIN','ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()+ Date');
434 END IF;
435
436 x_return_status := FND_API.G_RET_STS_SUCCESS;
437
438 IF p_struct_name = 'TRX_LINE_DIST_TBL' THEN
439
440 IF p_tax_param_code = 'TRX_DATE' THEN
441 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_DATE(p_struct_index) ;
442 ELSIF p_tax_param_code = 'TAX_INVOICE_DATE' THEN
443 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TAX_INVOICE_DATE(p_struct_index) ;
444 ELSIF p_tax_param_code = 'TRX_SHIPPING_DATE' THEN
445 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_SHIPPING_DATE(p_struct_index) ;
446 ELSIF p_tax_param_code = 'TRX_RECEIPT_DATE' THEN
447 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_RECEIPT_DATE(p_struct_index) ;
448 ELSIF p_tax_param_code = 'TRX_LINE_DATE' THEN
449 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DATE(p_struct_index) ;
450 ELSIF p_tax_param_code = 'CURRENCY_CONVERSION_DATE' THEN
451 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CURRENCY_CONVERSION_DATE(p_struct_index) ;
452 ELSIF p_tax_param_code = 'RELATED_DOC_DATE' THEN
453 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RELATED_DOC_DATE(p_struct_index) ;
454 ELSIF p_tax_param_code = 'ADJUSTED_DOC_DATE' THEN
455 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJUSTED_DOC_DATE(p_struct_index) ;
456 ELSIF p_tax_param_code = 'TRX_COMMUNICATED_DATE' THEN
457 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_COMMUNICATED_DATE(p_struct_index) ;
458 ELSIF p_tax_param_code = 'TRX_LINE_GL_DATE' THEN
459 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_struct_index) ;
460 ELSIF p_tax_param_code = 'TRX_DUE_DATE' THEN
461 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_DUE_DATE(p_struct_index) ;
462 ELSIF p_tax_param_code = 'EXPENDITURE_ITEM_DATE' THEN
463 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ITEM_DATE(p_struct_index) ;
464 ELSIF p_tax_param_code = 'SUPPLIER_TAX_INVOICE_DATE' THEN
465 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SUPPLIER_TAX_INVOICE_DATE(p_struct_index) ;
466 ELSIF p_tax_param_code = 'PROVNL_TAX_DETERMINATION_DATE' THEN
467 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PROVNL_TAX_DETERMINATION_DATE(p_struct_index) ;
468 ELSIF p_tax_param_code = 'START_EXPENSE_DATE' THEN
472 ELSIF p_tax_param_code = 'DATE1' THEN
469 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.START_EXPENSE_DATE(p_struct_index) ;
470 ELSIF p_tax_param_code = 'TRX_LINE_CURRENCY_CONV_DATE' THEN
471 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_CURRENCY_CONV_DATE(p_struct_index) ;
473 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DATE1(p_struct_index) ;
474 ELSIF p_tax_param_code = 'DATE2' THEN
475 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DATE2(p_struct_index) ;
476 ELSIF p_tax_param_code = 'DATE3' THEN
477 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DATE3(p_struct_index) ;
478 ELSIF p_tax_param_code = 'DATE4' THEN
479 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DATE4(p_struct_index) ;
480 ELSIF p_tax_param_code = 'DATE5' THEN
481 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DATE5(p_struct_index) ;
482 ELSIF p_tax_param_code = 'DATE6' THEN
483 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DATE6(p_struct_index) ;
484 ELSIF p_tax_param_code = 'DATE7' THEN
485 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DATE7(p_struct_index) ;
486 ELSIF p_tax_param_code = 'DATE8' THEN
487 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DATE8(p_struct_index) ;
488 ELSIF p_tax_param_code = 'DATE9' THEN
489 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DATE9(p_struct_index) ;
490 ELSIF p_tax_param_code = 'DATE10' THEN
491 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DATE10(p_struct_index) ;
492 END IF;
493
494 END IF;
495
496 IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
497 FND_LOG.STRING(
498 G_LEVEL_STATEMENT,
499 G_MODULE_NAME||'GET_DRIVER_VALUE.END',
500 'ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()- Date'||
501 'p_tax_param_code:'||p_tax_param_code||' x_tax_param_value:'||to_char(x_tax_param_value));
502 END IF;
503
504 EXCEPTION
505
506 WHEN OTHERS THEN
507 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508 IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
509 FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||'GET_DRIVER_VALUE - Date:',SQLERRM);
510 END IF;
511
512 END get_driver_value;
513
514 PROCEDURE get_driver_value
515 (
516 p_struct_name IN VARCHAR2,
517 p_struct_index IN BINARY_INTEGER,
518 p_tax_param_code IN VARCHAR2,
519 x_tax_param_value OUT NOCOPY VARCHAR2,
520 x_return_status OUT NOCOPY VARCHAR2
521 ) IS
522
523 BEGIN
524
525 IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
526 FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'GET_DRIVER_VALUE.BEGIN','ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()+ Varchar');
527 END IF;
528
529 x_return_status := FND_API.G_RET_STS_SUCCESS;
530
531 IF p_struct_name = 'TRX_LINE_DIST_TBL' THEN
532
533 IF p_tax_param_code = 'PRODUCT_CATEGORY' THEN
534 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_CATEGORY(p_struct_index) ;
535 ELSIF p_tax_param_code = 'PRODUCT_TYPE' THEN
536 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_TYPE(p_struct_index) ;
537 ELSIF p_tax_param_code = 'PRODUCT_CODE' THEN
538 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_CODE(p_struct_index) ;
539 ELSIF p_tax_param_code = 'PRODUCT_FISC_CLASSIFICATION' THEN
540 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_FISC_CLASSIFICATION(p_struct_index) ;
541 ELSIF p_tax_param_code = 'USER_DEFINED_FISC_CLASS' THEN
542 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.USER_DEFINED_FISC_CLASS(p_struct_index) ;
543 ELSIF p_tax_param_code = 'INPUT_TAX_CLASSIFICATION_CODE' THEN
544 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INPUT_TAX_CLASSIFICATION_CODE(p_struct_index) ;
545 ELSIF p_tax_param_code = 'OUTPUT_TAX_CLASSIFICATION_CODE' THEN
546 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.OUTPUT_TAX_CLASSIFICATION_CODE(p_struct_index) ;
547 ELSIF p_tax_param_code = 'ACCOUNT_STRING' THEN
548 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_struct_index) ;
549 ELSIF p_tax_param_code = 'DEFAULT_TAXATION_COUNTRY' THEN
550 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULT_TAXATION_COUNTRY(p_struct_index) ;
551 ELSIF p_tax_param_code = 'ENTITY_CODE' THEN
552 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ENTITY_CODE(p_struct_index) ;
553 ELSIF p_tax_param_code = 'EVENT_CLASS_CODE' THEN
554 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EVENT_CLASS_CODE(p_struct_index) ;
555 ELSIF p_tax_param_code = 'EVENT_TYPE_CODE' THEN
556 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EVENT_TYPE_CODE(p_struct_index) ;
557 ELSIF p_tax_param_code = 'TRX_LEVEL_TYPE' THEN
558 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LEVEL_TYPE(p_struct_index) ;
559 ELSIF p_tax_param_code = 'LINE_LEVEL_ACTION' THEN
560 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_LEVEL_ACTION(p_struct_index) ;
561 ELSIF p_tax_param_code = 'TRX_DOC_REVISION' THEN
562 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_DOC_REVISION(p_struct_index) ;
563 ELSIF p_tax_param_code = 'TRX_CURRENCY_CODE' THEN
564 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_CURRENCY_CODE(p_struct_index) ;
565 ELSIF p_tax_param_code = 'CURRENCY_CONVERSION_TYPE' THEN
566 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CURRENCY_CONVERSION_TYPE(p_struct_index) ;
567 ELSIF p_tax_param_code = 'TRX_LINE_TYPE' THEN
571 ELSIF p_tax_param_code = 'LINE_INTENDED_USE' THEN
568 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_TYPE(p_struct_index) ;
569 ELSIF p_tax_param_code = 'TRX_BUSINESS_CATEGORY' THEN
570 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_BUSINESS_CATEGORY(p_struct_index) ;
572 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_INTENDED_USE(p_struct_index) ;
573 ELSIF p_tax_param_code = 'EXEMPT_CERTIFICATE_NUMBER' THEN
574 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXEMPT_CERTIFICATE_NUMBER(p_struct_index) ;
575 ELSIF p_tax_param_code = 'EXEMPT_REASON' THEN
576 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXEMPT_REASON(p_struct_index) ;
577 ELSIF p_tax_param_code = 'UOM_CODE' THEN
578 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.UOM_CODE(p_struct_index) ;
579 ELSIF p_tax_param_code = 'TRX_SIC_CODE' THEN
580 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_SIC_CODE(p_struct_index) ;
581 ELSIF p_tax_param_code = 'FOB_POINT' THEN
582 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.FOB_POINT(p_struct_index) ;
583 ELSIF p_tax_param_code = 'MERCHANT_PARTY_COUNTRY' THEN
584 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.MERCHANT_PARTY_COUNTRY(p_struct_index) ;
585 ELSIF p_tax_param_code = 'REF_DOC_ENTITY_CODE' THEN
586 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_ENTITY_CODE(p_struct_index) ;
587 ELSIF p_tax_param_code = 'REF_DOC_EVENT_CLASS_CODE' THEN
588 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_EVENT_CLASS_CODE(p_struct_index) ;
589 ELSIF p_tax_param_code = 'RELATED_DOC_ENTITY_CODE' THEN
590 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RELATED_DOC_ENTITY_CODE(p_struct_index) ;
591 ELSIF p_tax_param_code = 'RELATED_DOC_EVENT_CLASS_CODE' THEN
592 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RELATED_DOC_EVENT_CLASS_CODE(p_struct_index) ;
593 ELSIF p_tax_param_code = 'RELATED_DOC_NUMBER' THEN
594 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.RELATED_DOC_NUMBER(p_struct_index) ;
595 ELSIF p_tax_param_code = 'APPLIED_FROM_ENTITY_CODE' THEN
596 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_FROM_ENTITY_CODE(p_struct_index) ;
597 ELSIF p_tax_param_code = 'APPLIED_FROM_EVENT_CLASS_CODE' THEN
598 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_FROM_EVENT_CLASS_CODE(p_struct_index) ;
599 ELSIF p_tax_param_code = 'ADJUSTED_DOC_ENTITY_CODE' THEN
600 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJUSTED_DOC_ENTITY_CODE(p_struct_index) ;
601 ELSIF p_tax_param_code = 'ADJUSTED_DOC_NUMBER' THEN
602 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJUSTED_DOC_NUMBER(p_struct_index) ;
603 ELSIF p_tax_param_code = 'APPLIED_TO_ENTITY_CODE' THEN
604 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_TO_ENTITY_CODE(p_struct_index) ;
605 ELSIF p_tax_param_code = 'APPLIED_TO_EVENT_CLASS_CODE' THEN
606 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_TO_EVENT_CLASS_CODE(p_struct_index) ;
607 ELSIF p_tax_param_code = 'TRX_NUMBER' THEN
608 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_NUMBER(p_struct_index) ;
609 ELSIF p_tax_param_code = 'TRX_DESCRIPTION' THEN
610 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_DESCRIPTION(p_struct_index) ;
611 ELSIF p_tax_param_code = 'TRX_LINE_DESCRIPTION' THEN
612 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DESCRIPTION(p_struct_index) ;
613 ELSIF p_tax_param_code = 'PRODUCT_DESCRIPTION' THEN
614 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_DESCRIPTION(p_struct_index) ;
615 ELSIF p_tax_param_code = 'TRX_WAYBILL_NUMBER' THEN
616 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_WAYBILL_NUMBER(p_struct_index) ;
617 ELSIF p_tax_param_code = 'BATCH_SOURCE_NAME' THEN
618 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.BATCH_SOURCE_NAME(p_struct_index) ;
619 ELSIF p_tax_param_code = 'DOC_SEQ_NAME' THEN
620 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DOC_SEQ_NAME(p_struct_index) ;
621 ELSIF p_tax_param_code = 'DOC_SEQ_VALUE' THEN
622 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DOC_SEQ_VALUE(p_struct_index) ;
623 ELSIF p_tax_param_code = 'TRX_TYPE_DESCRIPTION' THEN
624 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_TYPE_DESCRIPTION(p_struct_index) ;
625 ELSIF p_tax_param_code = 'MERCHANT_PARTY_NAME' THEN
626 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.MERCHANT_PARTY_NAME(p_struct_index) ;
627 ELSIF p_tax_param_code = 'MERCHANT_PARTY_DOCUMENT_NUMBER' THEN
628 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.MERCHANT_PARTY_DOCUMENT_NUMBER(p_struct_index) ;
629 ELSIF p_tax_param_code = 'MERCHANT_PARTY_REFERENCE' THEN
630 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.MERCHANT_PARTY_REFERENCE(p_struct_index) ;
631 ELSIF p_tax_param_code = 'MERCHANT_PARTY_TAXPAYER_ID' THEN
632 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.MERCHANT_PARTY_TAXPAYER_ID(p_struct_index) ;
633 ELSIF p_tax_param_code = 'MERCHANT_PARTY_TAX_REG_NUMBER' THEN
634 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.MERCHANT_PARTY_TAX_REG_NUMBER(p_struct_index) ;
635 ELSIF p_tax_param_code = 'ASSET_FLAG' THEN
636 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ASSET_FLAG(p_struct_index) ;
637 ELSIF p_tax_param_code = 'ASSET_NUMBER' THEN
638 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ASSET_NUMBER(p_struct_index) ;
639 ELSIF p_tax_param_code = 'ASSET_TYPE' THEN
640 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ASSET_TYPE(p_struct_index) ;
644 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TAX_EVENT_TYPE_CODE(p_struct_index) ;
641 ELSIF p_tax_param_code = 'TAX_EVENT_CLASS_CODE' THEN
642 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TAX_EVENT_CLASS_CODE(p_struct_index) ;
643 ELSIF p_tax_param_code = 'TAX_EVENT_TYPE_CODE' THEN
645 ELSIF p_tax_param_code = 'DOC_EVENT_STATUS' THEN
646 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DOC_EVENT_STATUS(p_struct_index) ;
647 ELSIF p_tax_param_code = 'DIST_LEVEL_ACTION' THEN
648 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DIST_LEVEL_ACTION(p_struct_index) ;
649 ELSIF p_tax_param_code = 'EXPENDITURE_TYPE' THEN
650 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_TYPE(p_struct_index) ;
651 ELSIF p_tax_param_code = 'LINE_AMT_INCLUDES_TAX_FLAG' THEN
652 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_AMT_INCLUDES_TAX_FLAG(p_struct_index) ;
653 ELSIF p_tax_param_code = 'QUOTE_FLAG' THEN
654 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.Quote_Flag(p_struct_index) ;
655 ELSIF p_tax_param_code = 'HISTORICAL_FLAG' THEN
656 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.HISTORICAL_FLAG(p_struct_index) ;
657 ELSIF p_tax_param_code = 'CTRL_HDR_TX_APPL_FLAG' THEN
658 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CTRL_HDR_TX_APPL_FLAG(p_struct_index) ;
659 ELSIF p_tax_param_code = 'DOCUMENT_SUB_TYPE' THEN
660 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DOCUMENT_SUB_TYPE(p_struct_index) ;
661 ELSIF p_tax_param_code = 'SUPPLIER_TAX_INVOICE_NUMBER' THEN
662 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SUPPLIER_TAX_INVOICE_NUMBER(p_struct_index) ;
663 ELSIF p_tax_param_code = 'PORT_OF_ENTRY_CODE' THEN
664 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PORT_OF_ENTRY_CODE(p_struct_index) ;
665 ELSIF p_tax_param_code = 'TAX_REPORTING_FLAG' THEN
666 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TAX_REPORTING_FLAG(p_struct_index) ;
667 ELSIF p_tax_param_code = 'TAX_AMT_INCLUDED_FLAG' THEN
668 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TAX_AMT_INCLUDED_FLAG(p_struct_index) ;
669 ELSIF p_tax_param_code = 'COMPOUNDING_TAX_FLAG' THEN
670 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.COMPOUNDING_TAX_FLAG(p_struct_index) ;
671 ELSIF p_tax_param_code = 'SOURCE_ENTITY_CODE' THEN
672 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SOURCE_ENTITY_CODE(p_struct_index) ;
673 ELSIF p_tax_param_code = 'SOURCE_EVENT_CLASS_CODE' THEN
674 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SOURCE_EVENT_CLASS_CODE(p_struct_index) ;
675 ELSIF p_tax_param_code = 'SOURCE_TRX_LEVEL_TYPE' THEN
676 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.SOURCE_TRX_LEVEL_TYPE(p_struct_index) ;
677 ELSIF p_tax_param_code = 'APPLIED_TO_TRX_NUMBER' THEN
678 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_TO_TRX_NUMBER(p_struct_index) ;
679 ELSIF p_tax_param_code = 'APPLIED_TO_TRX_LEVEL_TYPE' THEN
680 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_TO_TRX_LEVEL_TYPE(p_struct_index) ;
681 ELSIF p_tax_param_code = 'APPLIED_FROM_TRX_LEVEL_TYPE' THEN
682 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_FROM_TRX_LEVEL_TYPE(p_struct_index) ;
683 ELSIF p_tax_param_code = 'REF_DOC_TRX_LEVEL_TYPE' THEN
684 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_TRX_LEVEL_TYPE(p_struct_index) ;
685 ELSIF p_tax_param_code = 'ADJUSTED_DOC_TRX_LEVEL_TYPE' THEN
686 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJUSTED_DOC_TRX_LEVEL_TYPE(p_struct_index) ;
687 ELSIF p_tax_param_code = 'EXEMPTION_CONTROL_FLAG' THEN
688 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXEMPTION_CONTROL_FLAG(p_struct_index) ;
689 ELSIF p_tax_param_code = 'APPLICATION_DOC_STATUS' THEN
690 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLICATION_DOC_STATUS(p_struct_index) ;
691 ELSIF p_tax_param_code = 'APPLIED_FROM_TRX_NUMBER' THEN
692 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLIED_FROM_TRX_NUMBER(p_struct_index) ;
693 ELSIF p_tax_param_code = 'EXEMPT_REASON_CODE' THEN
694 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXEMPT_REASON_CODE(p_struct_index) ;
695 ELSIF p_tax_param_code = 'TRX_LINE_CURRENCY_CODE' THEN
696 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_CURRENCY_CODE(p_struct_index) ;
697 ELSIF p_tax_param_code = 'TRX_LINE_CURRENCY_CONV_TYPE' THEN
698 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_CURRENCY_CONV_TYPE(p_struct_index) ;
699 ELSIF p_tax_param_code = 'LINE_CLASS' THEN
700 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_CLASS(p_struct_index) ;
701 ELSIF p_tax_param_code = 'INTERFACE_ENTITY_CODE' THEN
702 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERFACE_ENTITY_CODE(p_struct_index) ;
703 ELSIF p_tax_param_code = 'REVERSED_ENTITY_CODE' THEN
704 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REVERSED_ENTITY_CODE(p_struct_index) ;
705 ELSIF p_tax_param_code = 'REVERSED_EVNT_CLS_CODE' THEN
706 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REVERSED_EVNT_CLS_CODE(p_struct_index) ;
707 ELSIF p_tax_param_code = 'REVERSED_TRX_LEVEL_TYPE' THEN
708 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REVERSED_TRX_LEVEL_TYPE(p_struct_index) ;
709 ELSIF p_tax_param_code = 'REF_DOC_HDR_TRX_USER_KEY1' THEN
710 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_HDR_TRX_USER_KEY1(p_struct_index) ;
711 ELSIF p_tax_param_code = 'REF_DOC_HDR_TRX_USER_KEY2' THEN
712 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_HDR_TRX_USER_KEY2(p_struct_index) ;
716 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_HDR_TRX_USER_KEY4(p_struct_index) ;
713 ELSIF p_tax_param_code = 'REF_DOC_HDR_TRX_USER_KEY3' THEN
714 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_HDR_TRX_USER_KEY3(p_struct_index) ;
715 ELSIF p_tax_param_code = 'REF_DOC_HDR_TRX_USER_KEY4' THEN
717 ELSIF p_tax_param_code = 'REF_DOC_HDR_TRX_USER_KEY5' THEN
718 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_HDR_TRX_USER_KEY5(p_struct_index) ;
719 ELSIF p_tax_param_code = 'REF_DOC_HDR_TRX_USER_KEY6' THEN
720 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_HDR_TRX_USER_KEY6(p_struct_index) ;
721 ELSIF p_tax_param_code = 'REF_DOC_LIN_TRX_USER_KEY1' THEN
722 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_LIN_TRX_USER_KEY1(p_struct_index) ;
723 ELSIF p_tax_param_code = 'REF_DOC_LIN_TRX_USER_KEY2' THEN
724 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_LIN_TRX_USER_KEY2(p_struct_index) ;
725 ELSIF p_tax_param_code = 'REF_DOC_LIN_TRX_USER_KEY3' THEN
726 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_LIN_TRX_USER_KEY3(p_struct_index) ;
727 ELSIF p_tax_param_code = 'REF_DOC_LIN_TRX_USER_KEY4' THEN
728 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_LIN_TRX_USER_KEY4(p_struct_index) ;
729 ELSIF p_tax_param_code = 'REF_DOC_LIN_TRX_USER_KEY5' THEN
730 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_LIN_TRX_USER_KEY5(p_struct_index) ;
731 ELSIF p_tax_param_code = 'REF_DOC_LIN_TRX_USER_KEY6' THEN
732 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REF_DOC_LIN_TRX_USER_KEY6(p_struct_index) ;
733 ELSIF p_tax_param_code = 'REL_DOC_HDR_TRX_USER_KEY1' THEN
734 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REL_DOC_HDR_TRX_USER_KEY1(p_struct_index) ;
735 ELSIF p_tax_param_code = 'REL_DOC_HDR_TRX_USER_KEY2' THEN
736 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REL_DOC_HDR_TRX_USER_KEY2(p_struct_index) ;
737 ELSIF p_tax_param_code = 'REL_DOC_HDR_TRX_USER_KEY3' THEN
738 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REL_DOC_HDR_TRX_USER_KEY3(p_struct_index) ;
739 ELSIF p_tax_param_code = 'REL_DOC_HDR_TRX_USER_KEY4' THEN
740 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REL_DOC_HDR_TRX_USER_KEY4(p_struct_index) ;
741 ELSIF p_tax_param_code = 'REL_DOC_HDR_TRX_USER_KEY5' THEN
742 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REL_DOC_HDR_TRX_USER_KEY5(p_struct_index) ;
743 ELSIF p_tax_param_code = 'REL_DOC_HDR_TRX_USER_KEY6' THEN
744 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.REL_DOC_HDR_TRX_USER_KEY6(p_struct_index) ;
745 ELSIF p_tax_param_code = 'APP_FROM_HDR_TRX_USER_KEY1' THEN
746 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_HDR_TRX_USER_KEY1(p_struct_index) ;
747 ELSIF p_tax_param_code = 'APP_FROM_HDR_TRX_USER_KEY2' THEN
748 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_HDR_TRX_USER_KEY2(p_struct_index) ;
749 ELSIF p_tax_param_code = 'APP_FROM_HDR_TRX_USER_KEY3' THEN
750 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_HDR_TRX_USER_KEY3(p_struct_index) ;
751 ELSIF p_tax_param_code = 'APP_FROM_HDR_TRX_USER_KEY4' THEN
752 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_HDR_TRX_USER_KEY4(p_struct_index) ;
753 ELSIF p_tax_param_code = 'APP_FROM_HDR_TRX_USER_KEY5' THEN
754 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_HDR_TRX_USER_KEY5(p_struct_index) ;
755 ELSIF p_tax_param_code = 'APP_FROM_HDR_TRX_USER_KEY6' THEN
756 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_HDR_TRX_USER_KEY6(p_struct_index) ;
757 ELSIF p_tax_param_code = 'ADJ_DOC_HDR_TRX_USER_KEY1' THEN
758 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_HDR_TRX_USER_KEY1(p_struct_index) ;
759 ELSIF p_tax_param_code = 'ADJ_DOC_HDR_TRX_USER_KEY2' THEN
760 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_HDR_TRX_USER_KEY2(p_struct_index) ;
761 ELSIF p_tax_param_code = 'ADJ_DOC_HDR_TRX_USER_KEY3' THEN
762 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_HDR_TRX_USER_KEY3(p_struct_index) ;
763 ELSIF p_tax_param_code = 'ADJ_DOC_HDR_TRX_USER_KEY4' THEN
764 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_HDR_TRX_USER_KEY4(p_struct_index) ;
765 ELSIF p_tax_param_code = 'ADJ_DOC_HDR_TRX_USER_KEY5' THEN
766 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_HDR_TRX_USER_KEY5(p_struct_index) ;
767 ELSIF p_tax_param_code = 'ADJ_DOC_HDR_TRX_USER_KEY6' THEN
768 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_HDR_TRX_USER_KEY6(p_struct_index) ;
769 ELSIF p_tax_param_code = 'ADJ_DOC_LIN_TRX_USER_KEY1' THEN
770 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_LIN_TRX_USER_KEY1(p_struct_index) ;
771 ELSIF p_tax_param_code = 'ADJ_DOC_LIN_TRX_USER_KEY2' THEN
772 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_LIN_TRX_USER_KEY2(p_struct_index) ;
773 ELSIF p_tax_param_code = 'ADJ_DOC_LIN_TRX_USER_KEY3' THEN
774 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_LIN_TRX_USER_KEY3(p_struct_index) ;
775 ELSIF p_tax_param_code = 'ADJ_DOC_LIN_TRX_USER_KEY4' THEN
776 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_LIN_TRX_USER_KEY4(p_struct_index) ;
777 ELSIF p_tax_param_code = 'ADJ_DOC_LIN_TRX_USER_KEY5' THEN
778 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_LIN_TRX_USER_KEY5(p_struct_index) ;
779 ELSIF p_tax_param_code = 'ADJ_DOC_LIN_TRX_USER_KEY6' THEN
780 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_LIN_TRX_USER_KEY6(p_struct_index) ;
781 ELSIF p_tax_param_code = 'APP_TO_HDR_TRX_USER_KEY1' THEN
785 ELSIF p_tax_param_code = 'APP_TO_HDR_TRX_USER_KEY3' THEN
782 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_TO_HDR_TRX_USER_KEY1(p_struct_index) ;
783 ELSIF p_tax_param_code = 'APP_TO_HDR_TRX_USER_KEY2' THEN
784 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_TO_HDR_TRX_USER_KEY2(p_struct_index) ;
786 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_TO_HDR_TRX_USER_KEY3(p_struct_index) ;
787 ELSIF p_tax_param_code = 'APP_TO_HDR_TRX_USER_KEY4' THEN
788 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_TO_HDR_TRX_USER_KEY4(p_struct_index) ;
789 ELSIF p_tax_param_code = 'APP_TO_HDR_TRX_USER_KEY5' THEN
790 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_TO_HDR_TRX_USER_KEY5(p_struct_index) ;
791 ELSIF p_tax_param_code = 'APP_TO_HDR_TRX_USER_KEY6' THEN
792 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_TO_HDR_TRX_USER_KEY6(p_struct_index) ;
793 ELSIF p_tax_param_code = 'APP_TO_LIN_TRX_USER_KEY1' THEN
794 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_TO_LIN_TRX_USER_KEY1(p_struct_index) ;
795 ELSIF p_tax_param_code = 'APP_TO_LIN_TRX_USER_KEY2' THEN
796 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_TO_LIN_TRX_USER_KEY2(p_struct_index) ;
797 ELSIF p_tax_param_code = 'APP_TO_LIN_TRX_USER_KEY3' THEN
798 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_TO_LIN_TRX_USER_KEY3(p_struct_index) ;
799 ELSIF p_tax_param_code = 'APP_TO_LIN_TRX_USER_KEY4' THEN
800 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_TO_LIN_TRX_USER_KEY4(p_struct_index) ;
801 ELSIF p_tax_param_code = 'APP_TO_LIN_TRX_USER_KEY5' THEN
802 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_TO_LIN_TRX_USER_KEY5(p_struct_index) ;
803 ELSIF p_tax_param_code = 'APP_TO_LIN_TRX_USER_KEY6' THEN
804 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_TO_LIN_TRX_USER_KEY6(p_struct_index) ;
805 ELSIF p_tax_param_code = 'HDR_TRX_USER_KEY1' THEN
806 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.HDR_TRX_USER_KEY1(p_struct_index) ;
807 ELSIF p_tax_param_code = 'HDR_TRX_USER_KEY2' THEN
808 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.HDR_TRX_USER_KEY2(p_struct_index) ;
809 ELSIF p_tax_param_code = 'HDR_TRX_USER_KEY3' THEN
810 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.HDR_TRX_USER_KEY3(p_struct_index) ;
811 ELSIF p_tax_param_code = 'HDR_TRX_USER_KEY4' THEN
812 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.HDR_TRX_USER_KEY4(p_struct_index) ;
813 ELSIF p_tax_param_code = 'HDR_TRX_USER_KEY5' THEN
814 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.HDR_TRX_USER_KEY5(p_struct_index) ;
815 ELSIF p_tax_param_code = 'HDR_TRX_USER_KEY6' THEN
816 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.HDR_TRX_USER_KEY6(p_struct_index) ;
817 ELSIF p_tax_param_code = 'LINE_TRX_USER_KEY1' THEN
818 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_TRX_USER_KEY1(p_struct_index) ;
819 ELSIF p_tax_param_code = 'LINE_TRX_USER_KEY2' THEN
820 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_TRX_USER_KEY2(p_struct_index) ;
821 ELSIF p_tax_param_code = 'LINE_TRX_USER_KEY3' THEN
822 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_TRX_USER_KEY3(p_struct_index) ;
823 ELSIF p_tax_param_code = 'LINE_TRX_USER_KEY4' THEN
824 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_TRX_USER_KEY4(p_struct_index) ;
825 ELSIF p_tax_param_code = 'LINE_TRX_USER_KEY5' THEN
826 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_TRX_USER_KEY5(p_struct_index) ;
827 ELSIF p_tax_param_code = 'LINE_TRX_USER_KEY6' THEN
828 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_TRX_USER_KEY6(p_struct_index) ;
829 ELSIF p_tax_param_code = 'DIST_TRX_USER_KEY1' THEN
830 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DIST_TRX_USER_KEY1(p_struct_index) ;
831 ELSIF p_tax_param_code = 'DIST_TRX_USER_KEY2' THEN
832 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DIST_TRX_USER_KEY2(p_struct_index) ;
833 ELSIF p_tax_param_code = 'DIST_TRX_USER_KEY3' THEN
834 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DIST_TRX_USER_KEY3(p_struct_index) ;
835 ELSIF p_tax_param_code = 'DIST_TRX_USER_KEY4' THEN
836 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DIST_TRX_USER_KEY4(p_struct_index) ;
837 ELSIF p_tax_param_code = 'DIST_TRX_USER_KEY5' THEN
838 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DIST_TRX_USER_KEY5(p_struct_index) ;
839 ELSIF p_tax_param_code = 'DIST_TRX_USER_KEY6' THEN
840 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DIST_TRX_USER_KEY6(p_struct_index) ;
841 ELSIF p_tax_param_code = 'APP_FROM_LIN_TRX_USER_KEY1' THEN
842 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_LIN_TRX_USER_KEY1(p_struct_index) ;
843 ELSIF p_tax_param_code = 'APP_FROM_LIN_TRX_USER_KEY2' THEN
844 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_LIN_TRX_USER_KEY2(p_struct_index) ;
845 ELSIF p_tax_param_code = 'APP_FROM_LIN_TRX_USER_KEY3' THEN
846 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_LIN_TRX_USER_KEY3(p_struct_index) ;
847 ELSIF p_tax_param_code = 'APP_FROM_LIN_TRX_USER_KEY4' THEN
848 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_LIN_TRX_USER_KEY4(p_struct_index) ;
849 ELSIF p_tax_param_code = 'APP_FROM_LIN_TRX_USER_KEY5' THEN
850 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_LIN_TRX_USER_KEY5(p_struct_index) ;
851 ELSIF p_tax_param_code = 'APP_FROM_LIN_TRX_USER_KEY6' THEN
852 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_LIN_TRX_USER_KEY6(p_struct_index) ;
853 ELSIF p_tax_param_code = 'APP_FROM_DST_TRX_USER_KEY1' THEN
857 ELSIF p_tax_param_code = 'APP_FROM_DST_TRX_USER_KEY3' THEN
854 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_DST_TRX_USER_KEY1(p_struct_index) ;
855 ELSIF p_tax_param_code = 'APP_FROM_DST_TRX_USER_KEY2' THEN
856 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_DST_TRX_USER_KEY2(p_struct_index) ;
858 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_DST_TRX_USER_KEY3(p_struct_index) ;
859 ELSIF p_tax_param_code = 'APP_FROM_DST_TRX_USER_KEY4' THEN
860 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_DST_TRX_USER_KEY4(p_struct_index) ;
861 ELSIF p_tax_param_code = 'APP_FROM_DST_TRX_USER_KEY5' THEN
862 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_DST_TRX_USER_KEY5(p_struct_index) ;
863 ELSIF p_tax_param_code = 'APP_FROM_DST_TRX_USER_KEY6' THEN
864 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APP_FROM_DST_TRX_USER_KEY6(p_struct_index) ;
865 ELSIF p_tax_param_code = 'ADJ_DOC_DST_TRX_USER_KEY1' THEN
866 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_DST_TRX_USER_KEY1(p_struct_index) ;
867 ELSIF p_tax_param_code = 'ADJ_DOC_DST_TRX_USER_KEY2' THEN
868 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_DST_TRX_USER_KEY2(p_struct_index) ;
869 ELSIF p_tax_param_code = 'ADJ_DOC_DST_TRX_USER_KEY3' THEN
870 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_DST_TRX_USER_KEY3(p_struct_index) ;
871 ELSIF p_tax_param_code = 'ADJ_DOC_DST_TRX_USER_KEY4' THEN
872 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_DST_TRX_USER_KEY4(p_struct_index) ;
873 ELSIF p_tax_param_code = 'ADJ_DOC_DST_TRX_USER_KEY5' THEN
874 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_DST_TRX_USER_KEY5(p_struct_index) ;
875 ELSIF p_tax_param_code = 'ADJ_DOC_DST_TRX_USER_KEY6' THEN
876 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ADJ_DOC_DST_TRX_USER_KEY6(p_struct_index) ;
877 ELSIF p_tax_param_code = 'GLOBAL_ATTRIBUTE_CATEGORY' THEN
878 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.GLOBAL_ATTRIBUTE_CATEGORY(p_struct_index) ;
879 ELSIF p_tax_param_code = 'GLOBAL_ATTRIBUTE1' THEN
880 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.GLOBAL_ATTRIBUTE1(p_struct_index) ;
881 ELSIF p_tax_param_code = 'DEFAULTING_ATTRIBUTE1' THEN
882 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULTING_ATTRIBUTE1(p_struct_index) ;
883 ELSIF p_tax_param_code = 'DEFAULTING_ATTRIBUTE2' THEN
884 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULTING_ATTRIBUTE2(p_struct_index) ;
885 ELSIF p_tax_param_code = 'DEFAULTING_ATTRIBUTE3' THEN
886 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULTING_ATTRIBUTE3(p_struct_index) ;
887 ELSIF p_tax_param_code = 'DEFAULTING_ATTRIBUTE4' THEN
888 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULTING_ATTRIBUTE4(p_struct_index) ;
889 ELSIF p_tax_param_code = 'DEFAULTING_ATTRIBUTE5' THEN
890 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULTING_ATTRIBUTE5(p_struct_index) ;
891 ELSIF p_tax_param_code = 'DEFAULTING_ATTRIBUTE6' THEN
892 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULTING_ATTRIBUTE6(p_struct_index) ;
893 ELSIF p_tax_param_code = 'DEFAULTING_ATTRIBUTE7' THEN
894 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULTING_ATTRIBUTE7(p_struct_index) ;
895 ELSIF p_tax_param_code = 'DEFAULTING_ATTRIBUTE8' THEN
896 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULTING_ATTRIBUTE8(p_struct_index) ;
897 ELSIF p_tax_param_code = 'DEFAULTING_ATTRIBUTE9' THEN
898 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULTING_ATTRIBUTE9(p_struct_index) ;
899 ELSIF p_tax_param_code = 'DEFAULTING_ATTRIBUTE10' THEN
900 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULTING_ATTRIBUTE10(p_struct_index) ;
901 ELSIF p_tax_param_code = 'CHAR1' THEN
902 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CHAR1(p_struct_index) ;
903 ELSIF p_tax_param_code = 'CHAR2' THEN
904 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CHAR2(p_struct_index) ;
905 ELSIF p_tax_param_code = 'CHAR3' THEN
906 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CHAR3(p_struct_index) ;
907 ELSIF p_tax_param_code = 'CHAR4' THEN
908 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CHAR4(p_struct_index) ;
909 ELSIF p_tax_param_code = 'CHAR5' THEN
910 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CHAR5(p_struct_index) ;
911 ELSIF p_tax_param_code = 'CHAR6' THEN
912 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CHAR6(p_struct_index) ;
913 ELSIF p_tax_param_code = 'CHAR7' THEN
914 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CHAR7(p_struct_index) ;
915 ELSIF p_tax_param_code = 'CHAR8' THEN
916 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CHAR8(p_struct_index) ;
917 ELSIF p_tax_param_code = 'CHAR9' THEN
918 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CHAR9(p_struct_index) ;
919 ELSIF p_tax_param_code = 'CHAR10' THEN
920 x_tax_param_value := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.CHAR10(p_struct_index) ;
921 END IF;
922 END IF;
923
924 IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
925 FND_LOG.STRING(
926 G_LEVEL_STATEMENT,
927 G_MODULE_NAME||'GET_DRIVER_VALUE.END',
928 'ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()- Varchar'||
929 'p_tax_param_code:'||p_tax_param_code||' x_tax_param_value:'||to_char(x_tax_param_value));
930 END IF;
931
932 EXCEPTION
933 WHEN OTHERS THEN
934 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935 IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
939
936 FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||'GET_DRIVER_VALUE - Varchar:',SQLERRM);
937 END IF;
938 END get_driver_value;
940 END ZX_GET_TAX_PARAM_DRIVER_PKG;
941