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