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.AR_VAT_TAX_PKG

Source


1 PACKAGE AR_VAT_TAX_PKG AS
2 /* $Header: ARPAVTSS.pls 120.5 2006/03/30 02:41:09 sachandr ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_ORG_ID in NUMBER,
7   X_VAT_TAX_ID in NUMBER,
8   X_TAX_CONSTRAINT_ID in NUMBER,
9   X_TAX_CLASS in VARCHAR2,
10   X_DISPLAYED_FLAG in VARCHAR2,
11   X_ENABLED_FLAG in VARCHAR2,
12   X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
13   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
14   X_AMOUNT_INCLUDES_TAX_FLAG in VARCHAR2,
15   X_AMOUNT_INCLUDES_TAX_OVERRIDE in VARCHAR2,
16   X_TAXABLE_BASIS in VARCHAR2,
17   X_TAX_CALCULATION_PLSQL_BLOCK in VARCHAR2,
18   X_INTERIM_TAX_CCID in NUMBER,
19   X_ADJ_CCID in NUMBER,
20   X_EDISC_CCID in NUMBER,
21   X_UNEDISC_CCID in NUMBER,
22   X_FINCHRG_CCID in NUMBER,
23   X_ADJ_NON_REC_TAX_CCID in NUMBER,
24   X_EDISC_NON_REC_TAX_CCID in NUMBER,
25   X_UNEDISC_NON_REC_TAX_CCID in NUMBER,
26   X_FINCHRG_NON_REC_TAX_CCID in NUMBER,
27   X_SET_OF_BOOKS_ID in NUMBER,
28   X_TAX_CODE in VARCHAR2,
29   X_TAX_RATE in NUMBER,
30   X_TAX_TYPE in VARCHAR2,
31   X_VALIDATE_FLAG in VARCHAR2,
32   X_TAX_ACCOUNT_ID in NUMBER,
33   X_START_DATE in DATE,
34   X_END_DATE in DATE,
35   X_ATTRIBUTE_CATEGORY in VARCHAR2,
36   X_ATTRIBUTE1 in VARCHAR2,
37   X_ATTRIBUTE2 in VARCHAR2,
38   X_ATTRIBUTE3 in VARCHAR2,
39   X_ATTRIBUTE4 in VARCHAR2,
40   X_ATTRIBUTE5 in VARCHAR2,
41   X_ATTRIBUTE6 in VARCHAR2,
42   X_ATTRIBUTE7 in VARCHAR2,
43   X_ATTRIBUTE8 in VARCHAR2,
44   X_ATTRIBUTE9 in VARCHAR2,
45   X_ATTRIBUTE10 in VARCHAR2,
46   X_ATTRIBUTE11 in VARCHAR2,
47   X_ATTRIBUTE12 in VARCHAR2,
48   X_ATTRIBUTE13 in VARCHAR2,
49   X_ATTRIBUTE14 in VARCHAR2,
50   X_ATTRIBUTE15 in VARCHAR2,
51   X_UNAPPROVED_EXEMPTION_FLAG in VARCHAR2,
52   X_DESCRIPTION in VARCHAR2,
53   X_VAT_TRANSACTION_TYPE in VARCHAR2,
54   X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
55   X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
56   X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
57   X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
58   X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
59   X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
60   X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
61   X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
62   X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
63   X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
64   X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
65   X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
66   X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
67   X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
68   X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
69   X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
70   X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
71   X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
72   X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
73   X_PRINTED_TAX_NAME in VARCHAR2,
74   X_ADJUSTMENT_TAX_CODE in VARCHAR2,
75   X_CREATION_DATE in DATE,
76   X_CREATED_BY in NUMBER,
77   X_LAST_UPDATE_DATE in DATE,
78   X_LAST_UPDATED_BY in NUMBER,
79   X_LAST_UPDATE_LOGIN in NUMBER,
80   X_LEASING_FLAG in VARCHAR2 DEFAULT 'N',
81   X_TAX_REGIME_CODE in VARCHAR2     DEFAULT  NULL,
82   X_TAX             in VARCHAR2     DEFAULT  NULL,
83   X_TAX_STATUS_CODE in VARCHAR2     DEFAULT  NULL);
84 
85 procedure LOCK_ROW (
86   X_ORG_ID in NUMBER,
87   X_VAT_TAX_ID in NUMBER,
88   X_TAX_CONSTRAINT_ID in NUMBER,
89   X_TAX_CLASS in VARCHAR2,
90   X_DISPLAYED_FLAG in VARCHAR2,
91   X_ENABLED_FLAG in VARCHAR2,
92   X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
93   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
94   X_AMOUNT_INCLUDES_TAX_FLAG in VARCHAR2,
95   X_AMOUNT_INCLUDES_TAX_OVERRIDE in VARCHAR2,
96   X_TAXABLE_BASIS in VARCHAR2,
97   X_TAX_CALCULATION_PLSQL_BLOCK in VARCHAR2,
98   X_INTERIM_TAX_CCID in NUMBER,
99   X_ADJ_CCID in NUMBER,
100   X_EDISC_CCID in NUMBER,
101   X_UNEDISC_CCID in NUMBER,
102   X_FINCHRG_CCID in NUMBER,
103   X_ADJ_NON_REC_TAX_CCID in NUMBER,
104   X_EDISC_NON_REC_TAX_CCID in NUMBER,
105   X_UNEDISC_NON_REC_TAX_CCID in NUMBER,
106   X_FINCHRG_NON_REC_TAX_CCID in NUMBER,
107   X_SET_OF_BOOKS_ID in NUMBER,
108   X_TAX_CODE in VARCHAR2,
109   X_TAX_RATE in NUMBER,
110   X_TAX_TYPE in VARCHAR2,
111   X_VALIDATE_FLAG in VARCHAR2,
112   X_TAX_ACCOUNT_ID in NUMBER,
113   X_START_DATE in DATE,
114   X_END_DATE in DATE,
115   X_ATTRIBUTE_CATEGORY in VARCHAR2,
116   X_ATTRIBUTE1 in VARCHAR2,
117   X_ATTRIBUTE2 in VARCHAR2,
118   X_ATTRIBUTE3 in VARCHAR2,
119   X_ATTRIBUTE4 in VARCHAR2,
120   X_ATTRIBUTE5 in VARCHAR2,
121   X_ATTRIBUTE6 in VARCHAR2,
122   X_ATTRIBUTE7 in VARCHAR2,
123   X_ATTRIBUTE8 in VARCHAR2,
124   X_ATTRIBUTE9 in VARCHAR2,
125   X_ATTRIBUTE10 in VARCHAR2,
126   X_ATTRIBUTE11 in VARCHAR2,
127   X_ATTRIBUTE12 in VARCHAR2,
128   X_ATTRIBUTE13 in VARCHAR2,
129   X_ATTRIBUTE14 in VARCHAR2,
130   X_ATTRIBUTE15 in VARCHAR2,
131   X_UNAPPROVED_EXEMPTION_FLAG in VARCHAR2,
132   X_DESCRIPTION in VARCHAR2,
133   X_VAT_TRANSACTION_TYPE in VARCHAR2,
134   X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
135   X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
136   X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
137   X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
138   X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
139   X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
140   X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
141   X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
142   X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
143   X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
144   X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
145   X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
146   X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
147   X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
148   X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
149   X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
150   X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
151   X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
152   X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
153   X_PRINTED_TAX_NAME in VARCHAR2,
154   X_ADJUSTMENT_TAX_CODE in VARCHAR2,
155   X_LEASING_FLAG in VARCHAR2 DEFAULT 'N',
156   X_TAX_REGIME_CODE in VARCHAR2     DEFAULT  NULL,
157   X_TAX             in VARCHAR2     DEFAULT  NULL,
158   X_TAX_STATUS_CODE in VARCHAR2     DEFAULT  NULL
159 );
160 
161 procedure UPDATE_ROW (
162   X_ORG_ID in NUMBER,
163   X_VAT_TAX_ID in NUMBER,
164   X_TAX_CONSTRAINT_ID in NUMBER,
165   X_TAX_CLASS in VARCHAR2,
166   X_DISPLAYED_FLAG in VARCHAR2,
167   X_ENABLED_FLAG in VARCHAR2,
168   X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
169   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
170   X_AMOUNT_INCLUDES_TAX_FLAG in VARCHAR2,
171   X_AMOUNT_INCLUDES_TAX_OVERRIDE in VARCHAR2,
172   X_TAXABLE_BASIS in VARCHAR2,
173   X_TAX_CALCULATION_PLSQL_BLOCK in VARCHAR2,
174   X_INTERIM_TAX_CCID in NUMBER,
175   X_ADJ_CCID in NUMBER,
176   X_EDISC_CCID in NUMBER,
177   X_UNEDISC_CCID in NUMBER,
178   X_FINCHRG_CCID in NUMBER,
179   X_ADJ_NON_REC_TAX_CCID in NUMBER,
180   X_EDISC_NON_REC_TAX_CCID in NUMBER,
181   X_UNEDISC_NON_REC_TAX_CCID in NUMBER,
182   X_FINCHRG_NON_REC_TAX_CCID in NUMBER,
183   X_SET_OF_BOOKS_ID in NUMBER,
184   X_TAX_CODE in VARCHAR2,
185   X_TAX_RATE in NUMBER,
186   X_TAX_TYPE in VARCHAR2,
187   X_VALIDATE_FLAG in VARCHAR2,
188   X_TAX_ACCOUNT_ID in NUMBER,
189   X_START_DATE in DATE,
190   X_END_DATE in DATE,
191   X_ATTRIBUTE_CATEGORY in VARCHAR2,
192   X_ATTRIBUTE1 in VARCHAR2,
193   X_ATTRIBUTE2 in VARCHAR2,
194   X_ATTRIBUTE3 in VARCHAR2,
195   X_ATTRIBUTE4 in VARCHAR2,
196   X_ATTRIBUTE5 in VARCHAR2,
197   X_ATTRIBUTE6 in VARCHAR2,
198   X_ATTRIBUTE7 in VARCHAR2,
199   X_ATTRIBUTE8 in VARCHAR2,
200   X_ATTRIBUTE9 in VARCHAR2,
201   X_ATTRIBUTE10 in VARCHAR2,
202   X_ATTRIBUTE11 in VARCHAR2,
203   X_ATTRIBUTE12 in VARCHAR2,
204   X_ATTRIBUTE13 in VARCHAR2,
205   X_ATTRIBUTE14 in VARCHAR2,
206   X_ATTRIBUTE15 in VARCHAR2,
207   X_UNAPPROVED_EXEMPTION_FLAG in VARCHAR2,
208   X_DESCRIPTION in VARCHAR2,
209   X_VAT_TRANSACTION_TYPE in VARCHAR2,
210   X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
211   X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
212   X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
213   X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
214   X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
215   X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
216   X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
217   X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
218   X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
219   X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
220   X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
221   X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
222   X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
223   X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
224   X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
225   X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
226   X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
227   X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
228   X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
229   X_PRINTED_TAX_NAME in VARCHAR2,
230   X_ADJUSTMENT_TAX_CODE in VARCHAR2,
231   X_LAST_UPDATE_DATE in DATE,
232   X_LAST_UPDATED_BY in NUMBER,
233   X_LAST_UPDATE_LOGIN in NUMBER,
234   X_LEASING_FLAG in VARCHAR2 DEFAULT 'N',
235   X_TAX_REGIME_CODE in VARCHAR2     DEFAULT  NULL,
236   X_TAX             in VARCHAR2     DEFAULT  NULL,
237   X_TAX_STATUS_CODE in VARCHAR2     DEFAULT  NULL
238 );
239 
240 procedure DELETE_ROW (
241   X_VAT_TAX_ID in NUMBER
242 );
243 
244 procedure ADD_LANGUAGE;
245 
246 procedure LOAD_ROW (
247    X_ORG_ID in NUMBER,
248    X_VAT_TAX_ID in NUMBER,
249    X_TAX_CONSTRAINT_ID in NUMBER,
250    X_TAX_CLASS in VARCHAR2,
251    X_DISPLAYED_FLAG in VARCHAR2,
252    X_ENABLED_FLAG in VARCHAR2,
253    X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
254    X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
255    X_AMOUNT_INCLUDES_TAX_FLAG in VARCHAR2,
256    X_AMOUNT_INCLUDES_TAX_OVERRIDE in VARCHAR2,
257    X_TAXABLE_BASIS in VARCHAR2,
258    X_TAX_CALCULATION_PLSQL_BLOCK in VARCHAR2,
259    X_INTERIM_TAX_CCID in NUMBER,
260    X_ADJ_CCID in NUMBER,
261    X_EDISC_CCID in NUMBER,
262    X_UNEDISC_CCID in NUMBER,
263    X_FINCHRG_CCID in NUMBER,
264    X_ADJ_NON_REC_TAX_CCID in NUMBER,
265    X_EDISC_NON_REC_TAX_CCID in NUMBER,
266    X_UNEDISC_NON_REC_TAX_CCID in NUMBER,
267    X_FINCHRG_NON_REC_TAX_CCID in NUMBER,
268    X_SET_OF_BOOKS_ID in NUMBER,
269    X_TAX_CODE in VARCHAR2,
270    X_TAX_RATE in NUMBER,
271    X_TAX_TYPE in VARCHAR2,
272    X_VALIDATE_FLAG in VARCHAR2,
273    X_TAX_ACCOUNT_ID in NUMBER,
274    X_START_DATE in DATE,
275    X_END_DATE in DATE,
276    X_ATTRIBUTE_CATEGORY in VARCHAR2,
277    X_ATTRIBUTE1 in VARCHAR2,
278    X_ATTRIBUTE2 in VARCHAR2,
279    X_ATTRIBUTE3 in VARCHAR2,
280    X_ATTRIBUTE4 in VARCHAR2,
281    X_ATTRIBUTE5 in VARCHAR2,
282    X_ATTRIBUTE6 in VARCHAR2,
283    X_ATTRIBUTE7 in VARCHAR2,
284    X_ATTRIBUTE8 in VARCHAR2,
285    X_ATTRIBUTE9 in VARCHAR2,
286    X_ATTRIBUTE10 in VARCHAR2,
287    X_ATTRIBUTE11 in VARCHAR2,
288    X_ATTRIBUTE12 in VARCHAR2,
289    X_ATTRIBUTE13 in VARCHAR2,
290    X_ATTRIBUTE14 in VARCHAR2,
291    X_ATTRIBUTE15 in VARCHAR2,
292    X_UNAPPROVED_EXEMPTION_FLAG in VARCHAR2,
293    X_DESCRIPTION in VARCHAR2,
294    X_VAT_TRANSACTION_TYPE in VARCHAR2,
295    X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
296    X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
297    X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
298    X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
299    X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
300    X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
301    X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
302    X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
303    X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
304    X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
305    X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
306    X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
307    X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
308    X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
309    X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
310    X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
311    X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
312    X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
313    X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
314    X_PRINTED_TAX_NAME in VARCHAR2,
315    X_ADJUSTMENT_TAX_CODE in VARCHAR2,
316    X_OWNER in VARCHAR2,
317    X_LEASING_FLAG in VARCHAR2 DEFAULT 'N',
318    X_TAX_REGIME_CODE in VARCHAR2     DEFAULT  NULL,
319    X_TAX             in VARCHAR2     DEFAULT  NULL,
320    X_TAX_STATUS_CODE in VARCHAR2     DEFAULT  NULL);
321 
322 procedure TRANSLATE_ROW (
323   X_VAT_TAX_ID in NUMBER,
324   X_PRINTED_TAX_NAME in VARCHAR2,
325   X_OWNER in VARCHAR2);
326 
327 end AR_VAT_TAX_PKG;