1 package arp_tax_view_taxware AUTHID CURRENT_USER as
2 /* $Header: zxtxvwas.pls 120.2 2006/10/06 11:41:38 vchallur ship $ */
3
4 USE_SHIP_TO CONSTANT VARCHAR2(10) := 'XXXXXXXXXX';
5 /* Bug 2158220 */
6 g_usenexpro VARCHAR2(100);
7 g_sectaxs NUMBER;
8 g_taxselparam NUMBER;
9 g_taxtype NUMBER;
10 g_serviceind NUMBER;
11 g_orgid NUMBER;
12
13
14
15 /*===========================================================================+
16 | FUNCTION |
17 | product_code |
18 | |
19 | DESCRIPTION |
20 | Returns the product_code |
21 | Returns segment1 from MTL_SYSTEM_ITEMS. |
22 | Users may have a different segment for the product code. |
23 | |
24 | SCOPE - PUBLIC |
25 | |
26 | MODIFICATION HISTORY |
27 | 09-DEC-97 Kenichi Mizuta Created |
28 | |
29 +===========================================================================*/
30
31 function PRODUCT_CODE(
32 p_view_name IN VARCHAR2,
33 p_header_id IN Number,
34 p_line_id IN Number,
35 p_item_id IN NUMBER,
36 p_memo_line_id IN NUMBER)
37 return VARCHAR2;
38
39 /*===========================================================================+
40 | FUNCTION |
41 | company_code |
42 | |
43 | DESCRIPTION |
44 | Returns the company_code. |
45 | Constant value of null. |
46 | |
47 | SCOPE - PUBLIC |
48 | |
49 | MODIFICATION HISTORY |
50 | 09-DEC-97 Kenichi Mizuta Created |
51 | |
52 +===========================================================================*/
53
54 function COMPANY_CODE(
55 p_view_name IN VARCHAR2,
56 p_header_id IN Number,
57 p_line_id IN Number)
58 return VARCHAR2;
59
60 /*===========================================================================+
61 | FUNCTION |
62 | division_code |
63 | |
64 | DESCRIPTION |
65 | Returns the division_code |
66 | Constant value of 'D_CODE'. |
67 | |
68 | SCOPE - PUBLIC |
69 | |
70 | MODIFICATION HISTORY |
71 | 09-DEC-97 Kenichi Mizuta Created |
72 | |
73 +===========================================================================*/
74
75 function DIVISION_CODE(
76 p_view_name IN VARCHAR2,
77 p_header_id IN Number,
78 p_line_id IN Number)
79 return VARCHAR2;
80
81
82 /*===========================================================================+
83 | FUNCTION |
84 | vendor_control_exemptions |
85 | |
86 | DESCRIPTION |
87 | Returns the Job No. ATTRIBUTE1 of ra_cust_trx_types |
88 | |
89 | SCOPE - PUBLIC |
90 | |
91 | MODIFICATION HISTORY |
92 | 09-DEC-97 Kenichi Mizuta Created |
93 | |
94 +===========================================================================*/
95
96 function VENDOR_CONTROL_EXEMPTIONS (
97 p_view_name IN VARCHAR2,
98 p_header_id IN Number,
99 p_line_id IN Number,
100 p_trx_type_id In Number)
101 return VARCHAR2;
102
103
104 /*===========================================================================+
105 | FUNCTION |
106 | use_nexpro |
107 | |
108 | DESCRIPTION |
109 | Returns the use nexpro flag. |
110 | 'Y' - use Nexpro |
111 | 'N' - use Nexpro |
112 | |
113 | SCOPE - PUBLIC |
114 | |
115 | MODIFICATION HISTORY |
116 | 09-DEC-97 Kenichi Mizuta Created |
117 | |
118 +===========================================================================*/
119
120 function Use_Nexpro (
121 p_view_name IN VARCHAR2,
122 p_header_id IN Number,
123 p_line_id IN Number)
124 return VARCHAR2;
125
126
127 /*===========================================================================+
128 | FUNCTION |
129 | use_secondary |
130 | |
131 | DESCRIPTION |
132 | Returns the use Secondary taxes flag |
133 | 1 = Use secondary taxes |
134 | 2 = Do not use secondary taxes |
135 | |
136 | SCOPE - PUBLIC |
137 | |
138 | MODIFICATION HISTORY |
139 | 09-DEC-97 Kenichi Mizuta Created |
140 | |
141 +===========================================================================*/
142
143 function Use_Secondary (
144 p_view_name IN VARCHAR2,
145 p_header_id IN Number,
146 p_line_id IN Number)
147 return NUMBER;
148
149
150 /*===========================================================================+
151 | FUNCTION |
152 | Tax_Sel_Parm |
153 | |
154 | DESCRIPTION |
155 | Returns the Tax Selection parameter flag |
156 | 2 = Use only ship-to address |
157 | 3 = Use only all jurisdications |
158 | |
159 | SCOPE - PUBLIC |
160 | |
161 | MODIFICATION HISTORY |
162 | 09-DEC-97 Kenichi Mizuta Created |
163 | |
164 +===========================================================================*/
165
166 function Tax_Sel_Parm (
167 p_view_name IN VARCHAR2,
168 p_header_id IN Number,
169 p_line_id IN Number)
170 return NUMBER;
171
172
173 /*===========================================================================+
174 | FUNCTION |
175 | Tax_Type |
176 | |
177 | DESCRIPTION |
178 | Returns the tax type. |
179 | '1' = Sales Tax |
180 | '2' = Use Tax |
181 | '3' = Rental |
182 | |
183 | SCOPE - PUBLIC |
184 | |
185 | MODIFICATION HISTORY |
186 | 09-DEC-97 Kenichi Mizuta Created |
187 | |
188 +===========================================================================*/
189
190 /*As per Taxware recommendation, removing this function*/
191 /*function Tax_Type (
192 p_view_name IN VARCHAR2,
193 p_header_id IN Number,
194 p_line_id IN Number)
195 return NUMBER;*/
196
197
198 /*===========================================================================+
199 | FUNCTION |
200 | Service_Indicator |
201 | |
202 | DESCRIPTION |
203 | Returns the service indicator flag |
204 | 1 = Service |
205 | 2 = Rental |
206 | 3 = Non-Service |
207 | |
208 | SCOPE - PUBLIC |
209 | |
210 | MODIFICATION HISTORY |
211 | 09-DEC-97 Kenichi Mizuta Created |
212 | |
213 +===========================================================================*/
214
215 function Service_Indicator (
216 p_view_name IN VARCHAR2,
217 p_header_id IN Number,
218 p_line_id IN Number)
219 return NUMBER;
220
221
222
223 /*===========================================================================+
224 | PROCEDURE |
225 | get_exemptions |
226 | |
227 | DESCRIPTION |
228 | Returns the separated State/County/City/Sec Cnty/Sec City |
229 | exemption levels. |
230 | Also returns the STEP90 flags - UseStep, StepProcFlag, CritFlag |
231 | |
232 | |
233 | SCOPE - PUBLIC |
234 | |
235 | MODIFICATION HISTORY |
236 | 09-DEC-97 Kenichi Mizuta Created |
237 | |
238 +===========================================================================*/
239
240 procedure GET_EXEMPTIONS(
241 p_exemption_id In Number,
242 p_State_Exempt_Percent Out NOCOPY Number,
243 p_State_Exempt_Reason Out NOCOPY Varchar2,
244 p_State_Cert_No Out NOCOPY Varchar2,
245 p_County_Exempt_Percent Out NOCOPY Number,
246 p_County_Exempt_Reason Out NOCOPY Varchar2,
247 p_County_Cert_No Out NOCOPY Varchar2,
248 p_City_Exempt_Percent Out NOCOPY Number,
249 p_City_Exempt_Reason Out NOCOPY Varchar2,
250 p_City_Cert_No Out NOCOPY Varchar2,
251 p_Sec_County_Exempt_Percent Out NOCOPY Number,
252 p_Sec_City_Exempt_Percent Out NOCOPY Number,
253 p_Use_Step Out NOCOPY Varchar2,
254 p_Step_Proc_Flag Out NOCOPY Varchar2,
255 p_Crit_Flag Out NOCOPY Varchar2);
256
257
258
259
260 /*===========================================================================+
261 | FUNCTION |
262 | poa_address_code |
263 | |
264 | DESCRIPTION |
265 | Returns POA Geocode |
266 | |
267 | SCOPE - PRIVATE |
268 | |
269 | MODIFICATION HISTORY |
270 | 09-DEC-97 Kenichi Mizuta Created |
271 | |
272 +===========================================================================*/
273
274
275 function POA_ADDRESS_CODE(
276 p_view_name IN VARCHAR2,
277 p_header_id IN Number,
278 p_line_id IN Number)
279
280 return Varchar2;
281
282 /*===========================================================================+
283 | FUNCTION |
284 | poo_address_code |
285 | |
286 | DESCRIPTION |
287 | Returns POO Geocode |
288 | |
289 | SCOPE - PRIVATE |
290 | |
291 | MODIFICATION HISTORY |
292 | 09-DEC-97 Kenichi Mizuta Created |
293 | |
294 +===========================================================================*/
295
296
297 function POO_ADDRESS_CODE(
298 p_view_name IN VARCHAR2,
299 p_header_id IN Number,
303
300 p_line_id IN Number,
301 p_salesrep_id IN Number)
302 return Varchar2;
304 /*===========================================================================+
305 | FUNCTION |
306 | ship_from_address_code |
307 | |
308 | DESCRIPTION |
309 | Returns Ship From Geocode |
310 | |
311 | SCOPE - Private |
312 | |
313 | MODIFICATION HISTORY |
314 | 09-DEC-97 Kenichi Mizuta Created |
315 | |
316 +===========================================================================*/
317
318
319 function SHIP_FROM_ADDRESS_CODE(
320 p_view_name IN VARCHAR2,
321 p_header_id IN Number,
322 p_line_id IN Number,
323 p_warehouse_id IN Number)
324 return Varchar2;
325
326 /*===========================================================================+
327 | FUNCTION |
328 | ship_to_address_code |
329 | |
330 | DESCRIPTION |
331 | Returns Ship To Geocode |
332 | Character 1 = In/Out City Limits |
333 | Character 2-10 = Geocode |
334 | |
335 | SCOPE - PRIVATE |
336 | |
337 | MODIFICATION HISTORY |
338 | 09-DEC-97 Kenichi Mizuta Created |
339 | |
340 +===========================================================================*/
341
342 function SHIP_TO_ADDRESS_CODE(
343 p_view_name IN VARCHAR2,
344 p_header_id IN Number,
345 p_line_id IN Number,
346 p_ship_to_address_id In Number,
347 p_ship_to_location_id In Number,
348 p_trx_date In Date,
349 p_ship_to_state In Varchar2,
350 p_postal_code In Varchar2)
351 return Varchar2;
352
353
354
355 /*===========================================================================+
356 | FUNCTION |
357 | Calculation_Flag |
358 | |
359 | DESCRIPTION |
360 | Returns the levels that tax should be calculated at |
361 | Character 1 = Calculate tax at State |
362 | Character 2 = Calculate tax at County |
363 | Character 3 = Calculate tax at City |
364 | Character 4 = Calculate tax at Secondary County |
365 | Character 5 = Calculate tax at Secondary City |
366 | 0 = Calculate tax |
367 | 1 = Do not Calculate tax |
368 | |
369 | SCOPE - PRIVATE |
370 | |
371 | MODIFICATION HISTORY |
372 | 09-DEC-97 Kenichi Mizuta Created |
373 | |
374 +===========================================================================*/
375 function Calculation_Flag(
376 p_view_name IN VARCHAR2,
377 p_header_id IN Number,
378 p_line_id IN Number)
379 return Varchar2;
380
381
382 /*===========================================================================+
383 | FUNCTION |
384 | audit_flag |
385 | |
386 | DESCRIPTION |
387 | Return appropriate audit_flag |
388 | |
389 | SCOPE - Public |
390 | |
391 | MODIFICATION HISTORY |
392 | 20-MAY-99 Toru Kawamura Created |
393 | |
394 +===========================================================================*/
395
396 function AUDIT_FLAG(
400 return Varchar2;
397 p_view_name IN VARCHAR2,
398 p_header_id IN Number,
399 p_line_id IN Number)
401
402
403 /*===========================================================================+
404 | FUNCTION |
405 | total_tax |
406 | |
407 | DESCRIPTION |
408 | Return total tax amount for an invoice |
409 | This function is used in view TAX_ADJUSTMENTS_V_A and |
410 | TAX_ADJUSTMENTS_V_V |
411 | |
412 | SCOPE - Public |
413 | |
414 | MODIFICATION HISTORY |
415 | 14-JUN-99 Nilesh Patel Created |
416 | |
417 +===========================================================================*/
418
419 function total_tax(
420 p_customer_trx_id IN Number )
421 return number;
422
423
424 /*===========================================================================+
425 | FUNCTION |
426 | customer_code |
427 | |
428 | DESCRIPTION |
429 | Returns the customer code to be passed to Taxware |
430 | |
431 | SCOPE - PUBLIC |
432 | |
433 | MODIFICATION HISTORY |
434 | 03-SEP-03 Santosh Vaze Created (Bug # 3139351) |
435 | 16-JUL-04 Debasis bug 3768303 |
436 | |
437 +===========================================================================*/
438
439 function customer_code (
440 p_view_name IN VARCHAR2,
441 p_header_id IN Number,
442 p_line_id IN Number)
443 return varchar2;
444 --3768303 return number;
445
446
447 /*===========================================================================+
448 | FUNCTION |
449 | transaction_date |
450 | |
451 | DESCRIPTION |
452 | Returns the transaction date to be passed to Vertex |
453 | |
454 | SCOPE - PUBLIC |
455 | |
456 | MODIFICATION HISTORY |
457 | 29-Jun-2005 Sanjeev Ahuja Created |
458 | |
459 +===========================================================================*/
460 function transaction_date (
461 p_view_name IN VARCHAR2,
462 p_header_id IN Number,
463 p_line_id IN Number)
464 return DATE;
465 --Bug 4175816 return date;
466
467
468 /*===========================================================================+
469 | FUNCTION |
470 | customer_name |
471 | |
472 | DESCRIPTION |
473 | Returns the customer name to be passed to Taxware |
474 | |
475 | SCOPE - PUBLIC |
476 | |
477 | MODIFICATION HISTORY |
478 | 03-SEP-03 Santosh Vaze Created (Bug # 3139351) |
479 | |
480 +===========================================================================*/
481
482 function customer_name (
483 p_view_name IN VARCHAR2,
484 p_header_id IN Number,
485 p_line_id IN Number)
486 return varchar2;
487
488
489 /*-----------------------------------------------------------+
490 WRITES NO DATABASE STATE
491 WRITES NO PROGRAM STATE PRAGMAS
492 +-----------------------------------------------------------*/
493
494 -- Needed to comment out the following pragma for 11.5 OE/OM changes
495 -- in the Package Body
496
497 end ARP_TAX_VIEW_TAXWARE;
|
|
|