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

Source


1 package ZX_TAXES_PKG  AUTHID CURRENT_USER as
2 /* $Header: zxctaxess.pls 120.19 2006/03/16 07:46:20 hdudeja ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out nocopy VARCHAR2,
6   X_Recovery_Rate_Override_Flag VARCHAR2,
7   X_TAX_ID in NUMBER,
8   X_ATTRIBUTE13 in VARCHAR2,
9   X_ATTRIBUTE14 in VARCHAR2,
10   X_ATTRIBUTE15 in VARCHAR2,
11   X_ATTRIBUTE_CATEGORY in VARCHAR2,
12   X_ATTRIBUTE8 in VARCHAR2,
13   X_ATTRIBUTE9 in VARCHAR2,
14   X_ATTRIBUTE10 in VARCHAR2,
15   X_ATTRIBUTE11 in VARCHAR2,
16   X_ATTRIBUTE12 in VARCHAR2,
17   X_Has_Tax_Point_Date_Rule_Flag in VARCHAR2,
18   X_Print_On_Invoice_Flag in VARCHAR2,
19   X_Use_Legal_Msg_Flag in VARCHAR2,
20   X_Calc_Only_Flag in VARCHAR2,
21   X_PRIMARY_RECOVERY_TYPE_CODE in VARCHAR2,
22   X_Primary_Rec_Type_Rule_Flag in VARCHAR2,
23   X_SECONDARY_RECOVERY_TYPE_CODE in VARCHAR2,
24   X_Secondary_Rec_Type_Rule_Flag in VARCHAR2,
25   X_PRIMARY_REC_RATE_DET_RULE_FL in VARCHAR2,
26   X_Sec_Rec_Rate_Det_Rule_Flag in VARCHAR2,
27   X_Offset_Tax_Flag in VARCHAR2,
28   X_REQUEST_ID in NUMBER,
29   X_PROGRAM_APPLICATION_ID in NUMBER,
30   X_PROGRAM_ID in NUMBER,
31   X_Program_Login_Id in NUMBER,
32   X_Record_Type_Code in VARCHAR2,
33   X_Allow_Rounding_Override_Flag in VARCHAR2,
34   X_ATTRIBUTE1 in VARCHAR2,
35   X_ATTRIBUTE2 in VARCHAR2,
36   X_ATTRIBUTE3 in VARCHAR2,
37   X_ATTRIBUTE4 in VARCHAR2,
38   X_ATTRIBUTE5 in VARCHAR2,
39   X_ATTRIBUTE6 in VARCHAR2,
40   X_ATTRIBUTE7 in VARCHAR2,
41   X_Has_Exch_Rate_Date_Rule_Flag in VARCHAR2,
42   X_TAX in VARCHAR2,
43   X_EFFECTIVE_FROM in DATE,
44   X_EFFECTIVE_TO in DATE,
45   X_TAX_REGIME_CODE in VARCHAR2,
46   X_TAX_TYPE_CODE in VARCHAR2,
47   X_Allow_Manual_Entry_Flag in VARCHAR2,
48   X_Allow_Tax_Override_Flag in VARCHAR2,
49   X_MIN_TXBL_BSIS_THRSHLD in NUMBER,
50   X_MAX_TXBL_BSIS_THRSHLD in NUMBER,
51   X_MIN_TAX_RATE_THRSHLD in NUMBER,
52   X_MAX_TAX_RATE_THRSHLD in NUMBER,
53   X_MIN_TAX_AMT_THRSHLD in NUMBER,
54   X_MAX_TAX_AMT_THRSHLD in NUMBER,
55   X_COMPOUNDING_PRECEDENCE in NUMBER,
56   X_PERIOD_SET_NAME in VARCHAR2,
57   X_EXCHANGE_RATE_TYPE in VARCHAR2,
58   X_TAX_CURRENCY_CODE in VARCHAR2,
59   X_REP_TAX_AUTHORITY_ID in NUMBER,
60   X_COLL_TAX_AUTHORITY_ID in NUMBER,
61   X_TAX_PRECISION in NUMBER,
62   X_MINIMUM_ACCOUNTABLE_UNIT in NUMBER,
63   X_Rounding_Rule_Code in VARCHAR2,
64   X_Tax_Status_Rule_Flag in VARCHAR2,
65   X_Tax_Rate_Rule_Flag in VARCHAR2,
66   X_Def_Place_Of_Supply_Type_Cod in VARCHAR2,
67   X_Place_Of_Supply_Rule_Flag in VARCHAR2,
68   X_Applicability_Rule_Flag in VARCHAR2,
69   X_Tax_Calc_Rule_Flag in VARCHAR2,
70   X_Txbl_Bsis_Thrshld_Flag in VARCHAR2,
71   X_Tax_Rate_Thrshld_Flag in VARCHAR2,
72   X_Tax_Amt_Thrshld_Flag in VARCHAR2,
73   X_Taxable_Basis_Rule_Flag in VARCHAR2,
74   X_Def_Inclusive_Tax_Flag in VARCHAR2,
75   X_Thrshld_Grouping_Lvl_Code in VARCHAR2,
76   X_Thrshld_Chk_Tmplt_Code in VARCHAR2,
77   X_Has_Other_Jurisdictions_Flag in VARCHAR2,
78   X_Allow_Exemptions_Flag in VARCHAR2,
79   X_Allow_Exceptions_Flag in VARCHAR2,
80   X_Allow_Recoverability_Flag in VARCHAR2,
81   X_DEF_TAX_CALC_FORMULA in VARCHAR2,
82   X_Tax_Inclusive_Override_Flag in VARCHAR2,
83   X_DEF_TAXABLE_BASIS_FORMULA in VARCHAR2,
84   X_Def_Registr_Party_Type_Code in VARCHAR2,
85   X_Registration_Type_Rule_Flag in VARCHAR2,
86   X_Reporting_Only_Flag in VARCHAR2,
87   X_Auto_Prvn_Flag in VARCHAR2,
88   X_Live_For_Processing_Flag in VARCHAR2,
89   X_Has_Detail_Tb_Thrshld_Flag in VARCHAR2,
90   X_Has_Tax_Det_Date_Rule_Flag in VARCHAR2,
91   X_TAX_FULL_NAME in VARCHAR2,
92   X_ZONE_GEOGRAPHY_TYPE in VARCHAR2,
93   X_Def_Rec_Settlement_Option_Co in VARCHAR2,
94   X_CREATION_DATE in DATE,
95   X_CREATED_BY in NUMBER,
96   X_LAST_UPDATE_DATE in DATE,
97   X_LAST_UPDATED_BY in NUMBER,
98   X_LAST_UPDATE_LOGIN in NUMBER,
99   X_Regn_Num_Same_As_Le_Flag in VARCHAR2   ,
100   X_Direct_Rate_Rule_Flag   in VARCHAR2,
101   X_CONTENT_OWNER_ID in NUMBER,
102   X_APPLIED_AMT_HANDLING_FLAG in VARCHAR2,
103   X_PARENT_GEOGRAPHY_TYPE in VARCHAR2,
104   X_PARENT_GEOGRAPHY_ID in NUMBER,
105   X_ALLOW_MASS_CREATE_FLAG in VARCHAR2,
106   X_SOURCE_TAX_FLAG in VARCHAR2,
107   X_SPECIAL_INCLUSIVE_TAX_FLAG in VARCHAR2,
108   X_DEF_PRIMARY_REC_RATE_CODE in VARCHAR2,
109   X_DEF_SECONDARY_REC_RATE_CODE in VARCHAR2,
110   X_ALLOW_DUP_REGN_NUM_FLAG in VARCHAR2,
111   X_TAX_ACCOUNT_SOURCE_TAX in VARCHAR2,
112   X_TAX_ACCOUNT_CREATE_METHOD_CO in VARCHAR2,
113   X_OVERRIDE_GEOGRAPHY_TYPE in VARCHAR2,
114   X_TAX_EXMPT_SOURCE_TAX in VARCHAR2,
115   X_TAX_EXMPT_CR_METHOD_CODE in VARCHAR2,
116   X_OBJECT_VERSION_NUMBER in NUMBER,
117   X_LIVE_FOR_APPLICABILITY_FLAG in VARCHAR2,
118   X_APPLICABLE_BY_DEFAULT_FLAG in VARCHAR2,
119   X_LEGAL_REPORTING_STATUS_DEF_V in VARCHAR2
120 );
121 
122 procedure LOCK_ROW (
123   X_TAX_ID in NUMBER,
124   X_Recovery_Rate_Override_Flag in VARCHAR2,
125   X_ATTRIBUTE13 in VARCHAR2,
126   X_ATTRIBUTE14 in VARCHAR2,
127   X_ATTRIBUTE15 in VARCHAR2,
128   X_ATTRIBUTE_CATEGORY in VARCHAR2,
129   X_ATTRIBUTE8 in VARCHAR2,
130   X_ATTRIBUTE9 in VARCHAR2,
131   X_ATTRIBUTE10 in VARCHAR2,
132   X_ATTRIBUTE11 in VARCHAR2,
133   X_ATTRIBUTE12 in VARCHAR2,
134   X_Has_Tax_Point_Date_Rule_Flag in VARCHAR2,
135   X_Print_On_Invoice_Flag in VARCHAR2,
136   X_Use_Legal_Msg_Flag in VARCHAR2,
137   X_Calc_Only_Flag in VARCHAR2,
138   X_PRIMARY_RECOVERY_TYPE_CODE in VARCHAR2,
139   X_Primary_Rec_Type_Rule_Flag in VARCHAR2,
140   X_SECONDARY_RECOVERY_TYPE_CODE in VARCHAR2,
141   X_Secondary_Rec_Type_Rule_Flag in VARCHAR2,
142   X_PRIMARY_REC_RATE_DET_RULE_FL in VARCHAR2,
143   X_Sec_Rec_Rate_Det_Rule_Flag in VARCHAR2,
144   X_Offset_Tax_Flag in VARCHAR2,
145   X_REQUEST_ID in NUMBER,
146   X_PROGRAM_APPLICATION_ID in NUMBER,
147   X_PROGRAM_ID in NUMBER,
148   X_Program_Login_Id in NUMBER,
149   X_Record_Type_Code in VARCHAR2,
150   X_Allow_Rounding_Override_Flag in VARCHAR2,
151   X_ATTRIBUTE1 in VARCHAR2,
152   X_ATTRIBUTE2 in VARCHAR2,
153   X_ATTRIBUTE3 in VARCHAR2,
154   X_ATTRIBUTE4 in VARCHAR2,
155   X_ATTRIBUTE5 in VARCHAR2,
156   X_ATTRIBUTE6 in VARCHAR2,
157   X_ATTRIBUTE7 in VARCHAR2,
158   X_Has_Exch_Rate_Date_Rule_Flag in VARCHAR2,
159   X_TAX in VARCHAR2,
160   X_EFFECTIVE_FROM in DATE,
161   X_EFFECTIVE_TO in DATE,
162   X_TAX_REGIME_CODE in VARCHAR2,
163   X_TAX_TYPE_CODE in VARCHAR2,
164   X_Allow_Manual_Entry_Flag in VARCHAR2,
165   X_Allow_Tax_Override_Flag in VARCHAR2,
166   X_MIN_TXBL_BSIS_THRSHLD in NUMBER,
167   X_MAX_TXBL_BSIS_THRSHLD in NUMBER,
168   X_MIN_TAX_RATE_THRSHLD in NUMBER,
169   X_MAX_TAX_RATE_THRSHLD in NUMBER,
170   X_MIN_TAX_AMT_THRSHLD in NUMBER,
171   X_MAX_TAX_AMT_THRSHLD in NUMBER,
172   X_COMPOUNDING_PRECEDENCE in NUMBER,
173   X_PERIOD_SET_NAME in VARCHAR2,
174   X_EXCHANGE_RATE_TYPE in VARCHAR2,
175   X_TAX_CURRENCY_CODE in VARCHAR2,
176   X_REP_TAX_AUTHORITY_ID in NUMBER,
177   X_COLL_TAX_AUTHORITY_ID in NUMBER,
178   X_TAX_PRECISION in NUMBER,
179   X_MINIMUM_ACCOUNTABLE_UNIT in NUMBER,
180   X_Rounding_Rule_Code in VARCHAR2,
181   X_Tax_Status_Rule_Flag in VARCHAR2,
182   X_Tax_Rate_Rule_Flag in VARCHAR2,
183   X_Def_Place_Of_Supply_Type_Cod in VARCHAR2,
184   X_Place_Of_Supply_Rule_Flag in VARCHAR2,
185   X_Applicability_Rule_Flag in VARCHAR2,
186   X_Tax_Calc_Rule_Flag in VARCHAR2,
187   X_Txbl_Bsis_Thrshld_Flag in VARCHAR2,
188   X_Tax_Rate_Thrshld_Flag in VARCHAR2,
189   X_Tax_Amt_Thrshld_Flag in VARCHAR2,
190   X_Taxable_Basis_Rule_Flag in VARCHAR2,
191   X_Def_Inclusive_Tax_Flag in VARCHAR2,
192   X_Thrshld_Grouping_Lvl_Code in VARCHAR2,
193   X_Thrshld_Chk_Tmplt_Code in VARCHAR2,
194   X_Has_Other_Jurisdictions_Flag in VARCHAR2,
195   X_Allow_Exemptions_Flag in VARCHAR2,
196   X_Allow_Exceptions_Flag in VARCHAR2,
197   X_Allow_Recoverability_Flag in VARCHAR2,
198   X_DEF_TAX_CALC_FORMULA in VARCHAR2,
199   X_Tax_Inclusive_Override_Flag in VARCHAR2,
200   X_DEF_TAXABLE_BASIS_FORMULA in VARCHAR2,
201   X_Def_Registr_Party_Type_Code in VARCHAR2,
202   X_Registration_Type_Rule_Flag in VARCHAR2,
203   X_Reporting_Only_Flag in VARCHAR2,
204   X_Auto_Prvn_Flag in VARCHAR2,
205   X_Live_For_Processing_Flag in VARCHAR2,
206   X_Has_Detail_Tb_Thrshld_Flag in VARCHAR2,
207   X_Has_Tax_Det_Date_Rule_Flag in VARCHAR2,
208   X_TAX_FULL_NAME in VARCHAR2,
209   X_ZONE_GEOGRAPHY_TYPE in VARCHAR2,
210   X_Def_Rec_Settlement_Option_Co in VARCHAR2,
211   X_Regn_Num_Same_As_Le_Flag in VARCHAR2,
212   X_Direct_Rate_Rule_Flag   in VARCHAR2  ,
213   X_CONTENT_OWNER_ID in NUMBER,
214   X_APPLIED_AMT_HANDLING_FLAG in VARCHAR2,
215   X_PARENT_GEOGRAPHY_TYPE in VARCHAR2,
216   X_PARENT_GEOGRAPHY_ID in NUMBER,
217   X_ALLOW_MASS_CREATE_FLAG in VARCHAR2,
218   X_SOURCE_TAX_FLAG in VARCHAR2,
219   X_SPECIAL_INCLUSIVE_TAX_FLAG  in VARCHAR2,
220   X_DEF_PRIMARY_REC_RATE_CODE in VARCHAR2,
221   X_DEF_SECONDARY_REC_RATE_CODE in VARCHAR2,
222   X_ALLOW_DUP_REGN_NUM_FLAG in VARCHAR2,
223   X_TAX_ACCOUNT_SOURCE_TAX in VARCHAR2,
224   X_TAX_ACCOUNT_CREATE_METHOD_CO in VARCHAR2,
225   X_OVERRIDE_GEOGRAPHY_TYPE in VARCHAR2,
226   X_TAX_EXMPT_SOURCE_TAX in VARCHAR2,
227   X_TAX_EXMPT_CR_METHOD_CODE in VARCHAR2,
228   X_OBJECT_VERSION_NUMBER in NUMBER,
229   X_LIVE_FOR_APPLICABILITY_FLAG in VARCHAR2,
230   X_APPLICABLE_BY_DEFAULT_FLAG in VARCHAR2,
231   X_LEGAL_REPORTING_STATUS_DEF_V in VARCHAR2
232 );
233 
234 procedure UPDATE_ROW (
235   X_TAX_ID in NUMBER,
236   X_Recovery_Rate_Override_Flag in VARCHAR2,
237   X_ATTRIBUTE13 in VARCHAR2,
238   X_ATTRIBUTE14 in VARCHAR2,
239   X_ATTRIBUTE15 in VARCHAR2,
240   X_ATTRIBUTE_CATEGORY in VARCHAR2,
241   X_ATTRIBUTE8 in VARCHAR2,
242   X_ATTRIBUTE9 in VARCHAR2,
243   X_ATTRIBUTE10 in VARCHAR2,
244   X_ATTRIBUTE11 in VARCHAR2,
245   X_ATTRIBUTE12 in VARCHAR2,
246   X_Has_Tax_Point_Date_Rule_Flag in VARCHAR2,
247   X_Print_On_Invoice_Flag in VARCHAR2,
248   X_Use_Legal_Msg_Flag in VARCHAR2,
249   X_Calc_Only_Flag in VARCHAR2,
250   X_PRIMARY_RECOVERY_TYPE_CODE in VARCHAR2,
251   X_Primary_Rec_Type_Rule_Flag in VARCHAR2,
252   X_SECONDARY_RECOVERY_TYPE_CODE in VARCHAR2,
253   X_Secondary_Rec_Type_Rule_Flag in VARCHAR2,
254   X_PRIMARY_REC_RATE_DET_RULE_FL in VARCHAR2,
255   X_Sec_Rec_Rate_Det_Rule_Flag in VARCHAR2,
256   X_Offset_Tax_Flag in VARCHAR2,
257   X_REQUEST_ID in NUMBER,
258   X_PROGRAM_APPLICATION_ID in NUMBER,
259   X_PROGRAM_ID in NUMBER,
260   X_Program_Login_Id in NUMBER,
261   X_Record_Type_Code in VARCHAR2,
262   X_Allow_Rounding_Override_Flag in VARCHAR2,
263   X_ATTRIBUTE1 in VARCHAR2,
264   X_ATTRIBUTE2 in VARCHAR2,
265   X_ATTRIBUTE3 in VARCHAR2,
266   X_ATTRIBUTE4 in VARCHAR2,
267   X_ATTRIBUTE5 in VARCHAR2,
268   X_ATTRIBUTE6 in VARCHAR2,
269   X_ATTRIBUTE7 in VARCHAR2,
270   X_Has_Exch_Rate_Date_Rule_Flag in VARCHAR2,
271   X_TAX in VARCHAR2,
272   X_EFFECTIVE_FROM in DATE,
273   X_EFFECTIVE_TO in DATE,
274   X_TAX_REGIME_CODE in VARCHAR2,
275   X_TAX_TYPE_CODE in VARCHAR2,
276   X_Allow_Manual_Entry_Flag in VARCHAR2,
277   X_Allow_Tax_Override_Flag in VARCHAR2,
278   X_MIN_TXBL_BSIS_THRSHLD in NUMBER,
279   X_MAX_TXBL_BSIS_THRSHLD in NUMBER,
280   X_MIN_TAX_RATE_THRSHLD in NUMBER,
281   X_MAX_TAX_RATE_THRSHLD in NUMBER,
282   X_MIN_TAX_AMT_THRSHLD in NUMBER,
283   X_MAX_TAX_AMT_THRSHLD in NUMBER,
284   X_COMPOUNDING_PRECEDENCE in NUMBER,
285   X_PERIOD_SET_NAME in VARCHAR2,
286   X_EXCHANGE_RATE_TYPE in VARCHAR2,
287   X_TAX_CURRENCY_CODE in VARCHAR2,
288   X_REP_TAX_AUTHORITY_ID in NUMBER,
289   X_COLL_TAX_AUTHORITY_ID in NUMBER,
290   X_TAX_PRECISION in NUMBER,
291   X_MINIMUM_ACCOUNTABLE_UNIT in NUMBER,
292   X_Rounding_Rule_Code in VARCHAR2,
293   X_Tax_Status_Rule_Flag in VARCHAR2,
294   X_Tax_Rate_Rule_Flag in VARCHAR2,
295   X_Def_Place_Of_Supply_Type_Cod in VARCHAR2,
296   X_Place_Of_Supply_Rule_Flag in VARCHAR2,
297   X_Applicability_Rule_Flag in VARCHAR2,
298   X_Tax_Calc_Rule_Flag in VARCHAR2,
299   X_Txbl_Bsis_Thrshld_Flag in VARCHAR2,
300   X_Tax_Rate_Thrshld_Flag in VARCHAR2,
301   X_Tax_Amt_Thrshld_Flag in VARCHAR2,
302   X_Taxable_Basis_Rule_Flag in VARCHAR2,
303   X_Def_Inclusive_Tax_Flag in VARCHAR2,
304   X_Thrshld_Grouping_Lvl_Code in VARCHAR2,
305   X_Thrshld_Chk_Tmplt_Code in VARCHAR2,
306   X_Has_Other_Jurisdictions_Flag in VARCHAR2,
307   X_Allow_Exemptions_Flag in VARCHAR2,
308   X_Allow_Exceptions_Flag in VARCHAR2,
309   X_Allow_Recoverability_Flag in VARCHAR2,
310   X_DEF_TAX_CALC_FORMULA in VARCHAR2,
311   X_Tax_Inclusive_Override_Flag in VARCHAR2,
312   X_DEF_TAXABLE_BASIS_FORMULA in VARCHAR2,
313   X_Def_Registr_Party_Type_Code in VARCHAR2,
314   X_Registration_Type_Rule_Flag in VARCHAR2,
315   X_Reporting_Only_Flag in VARCHAR2,
316   X_Auto_Prvn_Flag in VARCHAR2,
317   X_Live_For_Processing_Flag in VARCHAR2,
318   X_Has_Detail_Tb_Thrshld_Flag in VARCHAR2,
319   X_Has_Tax_Det_Date_Rule_Flag in VARCHAR2,
320   X_TAX_FULL_NAME in VARCHAR2,
321   X_ZONE_GEOGRAPHY_TYPE in VARCHAR2,
322   X_Def_Rec_Settlement_Option_Co in VARCHAR2,
323   X_LAST_UPDATE_DATE in DATE,
324   X_LAST_UPDATED_BY in NUMBER,
325   X_LAST_UPDATE_LOGIN in NUMBER,
326   X_Regn_Num_Same_As_Le_Flag in VARCHAR2 ,
327   X_Direct_Rate_Rule_Flag in VARCHAR2 ,
328   X_CONTENT_OWNER_ID in NUMBER ,
329   X_APPLIED_AMT_HANDLING_FLAG in VARCHAR2,
330   X_PARENT_GEOGRAPHY_TYPE in VARCHAR2,
331   X_PARENT_GEOGRAPHY_ID in NUMBER,
332   X_ALLOW_MASS_CREATE_FLAG in VARCHAR2,
333   X_SOURCE_TAX_FLAG in VARCHAR2,
334   X_SPECIAL_INCLUSIVE_TAX_FLAG in VARCHAR2,
335   X_DEF_PRIMARY_REC_RATE_CODE in VARCHAR2,
336   X_DEF_SECONDARY_REC_RATE_CODE in VARCHAR2,
337   X_ALLOW_DUP_REGN_NUM_FLAG in VARCHAR2,
338   X_TAX_ACCOUNT_SOURCE_TAX in VARCHAR2,
339   X_TAX_ACCOUNT_CREATE_METHOD_CO in VARCHAR2,
340   X_OVERRIDE_GEOGRAPHY_TYPE in VARCHAR2,
341   X_TAX_EXMPT_SOURCE_TAX in VARCHAR2,
342   X_TAX_EXMPT_CR_METHOD_CODE in VARCHAR2,
343   X_OBJECT_VERSION_NUMBER in NUMBER,
344   X_LIVE_FOR_APPLICABILITY_FLAG in VARCHAR2,
345   X_APPLICABLE_BY_DEFAULT_FLAG in VARCHAR2,
346   X_LEGAL_REPORTING_STATUS_DEF_V in VARCHAR2
347 );
348 
349 procedure DELETE_ROW (
350   X_TAX_ID in NUMBER
351 );
352 
353 procedure ADD_LANGUAGE;
354 
355 end ZX_TAXES_PKG;