DBA Data[Home] [Help]

PACKAGE: APPS.ZX_REGIMES_PKG

Source


1 package ZX_REGIMES_PKG as
2 /* $Header: zxcregimess.pls 120.5 2005/03/29 11:27:19 scsharma ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out nocopy VARCHAR2,
6   X_TAX_REGIME_ID in NUMBER,
7   X_PARENT_REGIME_CODE in VARCHAR2,
8   X_TAX_REGIME_CODE in VARCHAR2,
9   X_Has_Sub_Regime_Flag in VARCHAR2,
10   X_Country_Or_Group_Code in VARCHAR2,
11   X_COUNTRY_CODE in VARCHAR2,
12   X_GEOGRAPHY_TYPE in VARCHAR2,
13   X_GEOGRAPHY_ID in NUMBER,
14   X_EFFECTIVE_FROM in DATE,
15   X_EFFECTIVE_TO in DATE,
16   X_EXCHANGE_RATE_TYPE in VARCHAR2,
17   X_TAX_CURRENCY_CODE in VARCHAR2,
18   X_Thrshld_Grouping_Lvl_Code in VARCHAR2,
19   X_Thrshld_Chk_Tmplt_Code in VARCHAR2,
20   X_PERIOD_SET_NAME in VARCHAR2,
21   X_REP_TAX_AUTHORITY_ID in NUMBER,
22   X_COLL_TAX_AUTHORITY_ID in NUMBER,
23   X_Rounding_Rule_Code in VARCHAR2,
24   X_TAX_PRECISION in NUMBER,
25   X_MINIMUM_ACCOUNTABLE_UNIT in NUMBER,
26   X_Tax_Status_Rule_Flag in VARCHAR2,
27   X_Def_Place_Of_Supply_Type_Cod in VARCHAR2,
28   X_Applicability_Rule_Flag in VARCHAR2,
29   X_Place_Of_Supply_Rule_Flag in VARCHAR2,
30   X_Tax_Calc_Rule_Flag in VARCHAR2,
31   X_Taxable_Basis_Thrshld_Flag in VARCHAR2,
32   X_Tax_Rate_Thrshld_Flag in VARCHAR2,
33   X_Tax_Amt_Thrshld_Flag in VARCHAR2,
34   X_Tax_Rate_Rule_Flag in VARCHAR2,
35   X_Taxable_Basis_Rule_Flag in VARCHAR2,
36   X_Def_Inclusive_Tax_Flag in VARCHAR2,
37   X_Has_Other_Jurisdictions_Flag in VARCHAR2,
38   X_Allow_Rounding_Override_Flag in VARCHAR2,
39   X_Allow_Exemptions_Flag in VARCHAR2,
40   X_Allow_Exceptions_Flag in VARCHAR2,
41   X_Allow_Recoverability_Flag in VARCHAR2,
42   X_Auto_Prvn_Flag in VARCHAR2,
43   X_Has_Tax_Det_Date_Rule_Flag in VARCHAR2,
44   X_Has_Exch_Rate_Date_Rule_Flag in VARCHAR2,
45   X_Has_Tax_Point_Date_Rule_Flag in VARCHAR2,
46   X_Use_Legal_Msg_Flag in VARCHAR2,
47   X_Regn_Num_Same_As_Le_Flag in VARCHAR2,
48   X_Def_Rec_Settlement_Option_Co in VARCHAR2,
49   X_Record_Type_Code in VARCHAR2,
50   X_PROGRAM_APPLICATION_ID in NUMBER,
51   X_PROGRAM_ID in NUMBER,
52   X_Program_Login_Id in NUMBER,
53   X_REQUEST_ID in NUMBER,
54   X_ATTRIBUTE1 in VARCHAR2,
55   X_ATTRIBUTE2 in VARCHAR2,
56   X_ATTRIBUTE3 in VARCHAR2,
57   X_ATTRIBUTE4 in VARCHAR2,
58   X_ATTRIBUTE5 in VARCHAR2,
59   X_ATTRIBUTE6 in VARCHAR2,
60   X_ATTRIBUTE7 in VARCHAR2,
61   X_ATTRIBUTE8 in VARCHAR2,
62   X_ATTRIBUTE9 in VARCHAR2,
63   X_ATTRIBUTE10 in VARCHAR2,
64   X_ATTRIBUTE11 in VARCHAR2,
65   X_ATTRIBUTE12 in VARCHAR2,
66   X_ATTRIBUTE13 in VARCHAR2,
67   X_ATTRIBUTE14 in VARCHAR2,
68   X_ATTRIBUTE15 in VARCHAR2,
69   X_ATTRIBUTE_CATEGORY in VARCHAR2,
70   X_Def_Registr_Party_Type_Code in VARCHAR2,
71   X_Registration_Type_Rule_Flag in VARCHAR2,
72   X_Tax_Inclusive_Override_Flag in VARCHAR2,
73   X_REGIME_PRECEDENCE in NUMBER,
74   X_Cross_Regime_Compounding_Fla in VARCHAR2,
75   X_TAX_REGIME_NAME in VARCHAR2,
76   X_CREATION_DATE in DATE,
77   X_CREATED_BY in NUMBER,
78   X_LAST_UPDATE_DATE in DATE,
79   X_LAST_UPDATED_BY in NUMBER,
80   X_LAST_UPDATE_LOGIN in NUMBER,
81   X_TAX_ACCOUNT_PRECEDENCE_CODE in VARCHAR2,
82   X_OBJECT_VERSION_NUMBER in NUMBER);
83 
84 procedure LOCK_ROW (
85   X_TAX_REGIME_ID in NUMBER,
86   X_PARENT_REGIME_CODE in VARCHAR2,
87   X_TAX_REGIME_CODE in VARCHAR2,
88   X_Has_Sub_Regime_Flag in VARCHAR2,
89   X_Country_Or_Group_Code in VARCHAR2,
90   X_COUNTRY_CODE in VARCHAR2,
91   X_GEOGRAPHY_TYPE in VARCHAR2,
92   X_GEOGRAPHY_ID in NUMBER,
93   X_EFFECTIVE_FROM in DATE,
94   X_EFFECTIVE_TO in DATE,
95   X_EXCHANGE_RATE_TYPE in VARCHAR2,
96   X_TAX_CURRENCY_CODE in VARCHAR2,
97   X_Thrshld_Grouping_Lvl_Code in VARCHAR2,
98   X_Thrshld_Chk_Tmplt_Code in VARCHAR2,
99   X_PERIOD_SET_NAME in VARCHAR2,
100   X_REP_TAX_AUTHORITY_ID in NUMBER,
101   X_COLL_TAX_AUTHORITY_ID in NUMBER,
102   X_Rounding_Rule_Code in VARCHAR2,
103   X_TAX_PRECISION in NUMBER,
104   X_MINIMUM_ACCOUNTABLE_UNIT in NUMBER,
105   X_Tax_Status_Rule_Flag in VARCHAR2,
106   X_Def_Place_Of_Supply_Type_Cod in VARCHAR2,
107   X_Applicability_Rule_Flag in VARCHAR2,
108   X_Place_Of_Supply_Rule_Flag in VARCHAR2,
109   X_Tax_Calc_Rule_Flag in VARCHAR2,
110   X_Taxable_Basis_Thrshld_Flag in VARCHAR2,
111   X_Tax_Rate_Thrshld_Flag in VARCHAR2,
112   X_Tax_Amt_Thrshld_Flag in VARCHAR2,
113   X_Tax_Rate_Rule_Flag in VARCHAR2,
114   X_Taxable_Basis_Rule_Flag in VARCHAR2,
115   X_Def_Inclusive_Tax_Flag in VARCHAR2,
116   X_Has_Other_Jurisdictions_Flag in VARCHAR2,
117   X_Allow_Rounding_Override_Flag in VARCHAR2,
118   X_Allow_Exemptions_Flag in VARCHAR2,
119   X_Allow_Exceptions_Flag in VARCHAR2,
120   X_Allow_Recoverability_Flag in VARCHAR2,
121   X_Auto_Prvn_Flag in VARCHAR2,
122   X_Has_Tax_Det_Date_Rule_Flag in VARCHAR2,
123   X_Has_Exch_Rate_Date_Rule_Flag in VARCHAR2,
124   X_Has_Tax_Point_Date_Rule_Flag in VARCHAR2,
125   X_Use_Legal_Msg_Flag in VARCHAR2,
126   X_Regn_Num_Same_As_Le_Flag in VARCHAR2,
127   X_Def_Rec_Settlement_Option_Co in VARCHAR2,
128   X_Record_Type_Code in VARCHAR2,
129   X_PROGRAM_APPLICATION_ID in NUMBER,
130   X_PROGRAM_ID in NUMBER,
131   X_Program_Login_Id in NUMBER,
132   X_REQUEST_ID in NUMBER,
133   X_ATTRIBUTE1 in VARCHAR2,
134   X_ATTRIBUTE2 in VARCHAR2,
135   X_ATTRIBUTE3 in VARCHAR2,
136   X_ATTRIBUTE4 in VARCHAR2,
137   X_ATTRIBUTE5 in VARCHAR2,
138   X_ATTRIBUTE6 in VARCHAR2,
139   X_ATTRIBUTE7 in VARCHAR2,
140   X_ATTRIBUTE8 in VARCHAR2,
141   X_ATTRIBUTE9 in VARCHAR2,
142   X_ATTRIBUTE10 in VARCHAR2,
143   X_ATTRIBUTE11 in VARCHAR2,
144   X_ATTRIBUTE12 in VARCHAR2,
145   X_ATTRIBUTE13 in VARCHAR2,
146   X_ATTRIBUTE14 in VARCHAR2,
147   X_ATTRIBUTE15 in VARCHAR2,
148   X_ATTRIBUTE_CATEGORY in VARCHAR2,
149   X_Def_Registr_Party_Type_Code in VARCHAR2,
150   X_Registration_Type_Rule_Flag in VARCHAR2,
151   X_Tax_Inclusive_Override_Flag in VARCHAR2,
152   X_REGIME_PRECEDENCE in NUMBER,
153   X_Cross_Regime_Compounding_Fla in VARCHAR2,
154   X_TAX_REGIME_NAME in VARCHAR2,
155   X_TAX_ACCOUNT_PRECEDENCE_CODE in VARCHAR2,
156   X_OBJECT_VERSION_NUMBER in NUMBER
157 );
158 
159 procedure UPDATE_ROW (
160   X_TAX_REGIME_ID in NUMBER,
161   X_PARENT_REGIME_CODE in VARCHAR2,
162   X_TAX_REGIME_CODE in VARCHAR2,
163   X_Has_Sub_Regime_Flag in VARCHAR2,
164   X_Country_Or_Group_Code in VARCHAR2,
165   X_COUNTRY_CODE in VARCHAR2,
166   X_GEOGRAPHY_TYPE in VARCHAR2,
167   X_GEOGRAPHY_ID in NUMBER,
168   X_EFFECTIVE_FROM in DATE,
169   X_EFFECTIVE_TO in DATE,
170   X_EXCHANGE_RATE_TYPE in VARCHAR2,
171   X_TAX_CURRENCY_CODE in VARCHAR2,
172   X_Thrshld_Grouping_Lvl_Code in VARCHAR2,
173   X_Thrshld_Chk_Tmplt_Code in VARCHAR2,
174   X_PERIOD_SET_NAME in VARCHAR2,
175   X_REP_TAX_AUTHORITY_ID in NUMBER,
176   X_COLL_TAX_AUTHORITY_ID in NUMBER,
177   X_Rounding_Rule_Code in VARCHAR2,
178   X_TAX_PRECISION in NUMBER,
179   X_MINIMUM_ACCOUNTABLE_UNIT in NUMBER,
180   X_Tax_Status_Rule_Flag in VARCHAR2,
181   X_Def_Place_Of_Supply_Type_Cod in VARCHAR2,
182   X_Applicability_Rule_Flag in VARCHAR2,
183   X_Place_Of_Supply_Rule_Flag in VARCHAR2,
184   X_Tax_Calc_Rule_Flag in VARCHAR2,
185   X_Taxable_Basis_Thrshld_Flag in VARCHAR2,
186   X_Tax_Rate_Thrshld_Flag in VARCHAR2,
187   X_Tax_Amt_Thrshld_Flag in VARCHAR2,
188   X_Tax_Rate_Rule_Flag in VARCHAR2,
189   X_Taxable_Basis_Rule_Flag in VARCHAR2,
190   X_Def_Inclusive_Tax_Flag in VARCHAR2,
191   X_Has_Other_Jurisdictions_Flag in VARCHAR2,
192   X_Allow_Rounding_Override_Flag in VARCHAR2,
193   X_Allow_Exemptions_Flag in VARCHAR2,
194   X_Allow_Exceptions_Flag in VARCHAR2,
195   X_Allow_Recoverability_Flag in VARCHAR2,
196   X_Auto_Prvn_Flag in VARCHAR2,
197   X_Has_Tax_Det_Date_Rule_Flag in VARCHAR2,
198   X_Has_Exch_Rate_Date_Rule_Flag in VARCHAR2,
199   X_Has_Tax_Point_Date_Rule_Flag in VARCHAR2,
200   X_Use_Legal_Msg_Flag in VARCHAR2,
201   X_Regn_Num_Same_As_Le_Flag in VARCHAR2,
202   X_Def_Rec_Settlement_Option_Co in VARCHAR2,
203   X_Record_Type_Code in VARCHAR2,
204   X_PROGRAM_APPLICATION_ID in NUMBER,
205   X_PROGRAM_ID in NUMBER,
206   X_Program_Login_Id in NUMBER,
207   X_REQUEST_ID in NUMBER,
208   X_ATTRIBUTE1 in VARCHAR2,
209   X_ATTRIBUTE2 in VARCHAR2,
210   X_ATTRIBUTE3 in VARCHAR2,
211   X_ATTRIBUTE4 in VARCHAR2,
212   X_ATTRIBUTE5 in VARCHAR2,
213   X_ATTRIBUTE6 in VARCHAR2,
214   X_ATTRIBUTE7 in VARCHAR2,
215   X_ATTRIBUTE8 in VARCHAR2,
216   X_ATTRIBUTE9 in VARCHAR2,
217   X_ATTRIBUTE10 in VARCHAR2,
218   X_ATTRIBUTE11 in VARCHAR2,
219   X_ATTRIBUTE12 in VARCHAR2,
220   X_ATTRIBUTE13 in VARCHAR2,
221   X_ATTRIBUTE14 in VARCHAR2,
222   X_ATTRIBUTE15 in VARCHAR2,
223   X_ATTRIBUTE_CATEGORY in VARCHAR2,
224   X_Def_Registr_Party_Type_Code in VARCHAR2,
225   X_Registration_Type_Rule_Flag in VARCHAR2,
226   X_Tax_Inclusive_Override_Flag in VARCHAR2,
227   X_REGIME_PRECEDENCE in NUMBER,
228   X_Cross_Regime_Compounding_Fla in VARCHAR2,
229   X_TAX_REGIME_NAME in VARCHAR2,
230   X_LAST_UPDATE_DATE in DATE,
231   X_LAST_UPDATED_BY in NUMBER,
232   X_LAST_UPDATE_LOGIN in NUMBER,
233   X_TAX_ACCOUNT_PRECEDENCE_CODE in VARCHAR2,
234   X_OBJECT_VERSION_NUMBER in NUMBER
235 );
236 
237 procedure DELETE_ROW (
238   X_TAX_REGIME_ID in NUMBER
239 );
240 
241 procedure ADD_LANGUAGE;
242 end ZX_REGIMES_PKG;
243