[Home] [Help]
PACKAGE BODY: APPS.ARP_TAX_VIEW_TAXWARE
Source
1 package body arp_tax_view_taxware as
2 /* $Header: zxtxvwab.pls 120.8 2006/10/06 11:41:08 vchallur ship $ */
3
4 USE_SHIP_TO_GEO CONSTANT VARCHAR2(10) := 'XXXXXXXXX';
5
6 G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7 g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8 g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
9 g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10 g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11 g_error_buffer VARCHAR2(100);
12
13 /*===========================================================================+
14 | FUNCTION |
15 | product_code |
16 | |
17 | DESCRIPTION |
18 | Returns the product_code |
19 | Returns segment1 from MTL_SYSTEM_ITEMS. |
20 | Users may have a different segment for the product code. |
21 | |
22 | SCOPE - PUBLIC |
23 | |
24 | MODIFICATION HISTORY |
25 | 09-DEC-97 Kenichi Mizuta Created |
26 | 12-AUG-99 Manoj Gudivaka OE/OM change : replaced fnd_profile |
27 | with oe_profile for profile |
28 | SO_ORGANIZATION_ID |
29 | |
30 +===========================================================================*/
31
32 function PRODUCT_CODE(
33 p_view_name IN VARCHAR2,
34 p_header_id IN Number,
35 p_line_id IN Number,
36 p_item_id IN NUMBER,
37 p_memo_line_id IN NUMBER)
38 RETURN VARCHAR2 IS
39 BEGIN
40 IF (g_level_procedure >= g_current_runtime_level ) THEN
41 FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE',
42 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE(+)');
43 END IF;
44
45 RETURN to_char(NULL);
46
47 IF (g_level_procedure >= g_current_runtime_level ) THEN
48 FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE',
49 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE(-)');
50 END IF;
51
52 END PRODUCT_CODE;
53
54
55 /*===========================================================================+
56 | FUNCTION |
57 | company_code |
58 | |
59 | DESCRIPTION |
60 | Returns the company_code. |
61 | Constant value of '01'. |
62 | |
63 | SCOPE - PUBLIC |
64 | |
65 | MODIFICATION HISTORY |
66 | 09-DEC-97 Kenichi Mizuta Created |
67 | |
68 +===========================================================================*/
69
70 function COMPANY_CODE(
71 p_view_name IN VARCHAR2,
72 p_header_id IN Number,
73 p_line_id IN Number)
74 return VARCHAR2 is
75 begin
76 return null;
77 end company_code;
78
79 /*===========================================================================+
80 | FUNCTION |
81 | division_code |
82 | |
83 | DESCRIPTION |
84 | Returns the division_code |
85 | Constant value of '01'. |
86 | |
87 | SCOPE - PUBLIC |
88 | |
89 | MODIFICATION HISTORY |
90 | 09-DEC-97 Kenichi Mizuta Created |
91 | |
92 +===========================================================================*/
93
94 function DIVISION_CODE(
95 p_view_name IN VARCHAR2,
96 p_header_id IN Number,
97 p_line_id IN Number)
98 return VARCHAR2 is
99 begin
100 return null;
101 end division_code;
102
103
104 /*===========================================================================+
105 | FUNCTION |
106 | vendor_control_exemptions |
107 | |
108 | DESCRIPTION |
109 | Returns the Job No. ATTRIBUTE1 of ra_cust_trx_types |
110 | |
111 | SCOPE - PUBLIC |
112 | |
113 | MODIFICATION HISTORY |
114 | 09-DEC-97 Kenichi Mizuta Created |
115 | |
116 +===========================================================================*/
117
118 function VENDOR_CONTROL_EXEMPTIONS(
119 p_view_name IN VARCHAR2,
120 p_header_id IN Number,
121 p_line_id IN Number,
122 p_trx_type_id In Number)
123 return VARCHAR2 is
124 begin
125
126 return null;
127 end vendor_control_exemptions;
128
129
130
131 /*===========================================================================+
132 | FUNCTION |
133 | use_nexpro |
134 | |
135 | DESCRIPTION |
136 | Returns the use nexpro flag. |
137 | 'Y' - use Nexpro |
138 | 'N' - use Nexpro |
139 | |
140 | SCOPE - PUBLIC |
141 | |
142 | MODIFICATION HISTORY |
143 | 09-DEC-97 Kenichi Mizuta Created |
144 | |
145 +===========================================================================*/
146
147 function Use_Nexpro (
148 p_view_name IN VARCHAR2,
149 p_header_id IN Number,
150 p_line_id IN Number)
151 return VARCHAR2
152 is
153 begin
154 return null;
155 end Use_Nexpro;
156
157 /*===========================================================================+
158 | FUNCTION |
159 | use_secondary |
160 | |
161 | DESCRIPTION |
162 | Returns the use Secondary taxes flag |
163 | 1 = Use secondary taxes |
164 | 2 = Do not use secondary taxes |
165 | |
166 | SCOPE - PUBLIC |
167 | |
168 | MODIFICATION HISTORY |
169 | 09-DEC-97 Kenichi Mizuta Created |
170 | |
171 +===========================================================================*/
172
173 function Use_Secondary (
174 p_view_name IN VARCHAR2,
175 p_header_id IN Number,
176 p_line_id IN Number)
177 return NUMBER
178 is
179 begin
180 return NULL;
181 /*This function is obsoleted*/
182 end Use_secondary;
183
184
185
186
187
188 /*===========================================================================+
189 | FUNCTION |
190 | Tax_Sel_Parm |
191 | |
192 | DESCRIPTION |
193 | Returns the Tax Selection parameter flag |
194 | 2 = Use only ship-to address |
195 | 3 = Use only all jurisdications |
196 | |
197 | SCOPE - PUBLIC |
198 | |
199 | MODIFICATION HISTORY |
200 | 09-DEC-97 Kenichi Mizuta Created |
201 | |
202 +===========================================================================*/
203
204 function Tax_Sel_Parm (
205 p_view_name IN VARCHAR2,
206 p_header_id IN Number,
207 p_line_id IN Number)
208 return NUMBER
209 is
210 begin
211 return null;
212 end tax_sel_parm;
213
214 /*===========================================================================+
215 | FUNCTION |
216 | Tax_Type |
217 | |
218 | DESCRIPTION |
219 | Returns the tax type. |
220 | '1' = Sales Tax |
221 | '2' = Use Tax |
222 | '3' = Rental |
223 | |
224 | SCOPE - PUBLIC |
225 | |
226 | MODIFICATION HISTORY |
227 | 09-DEC-97 Kenichi Mizuta Created |
228 | |
229 +===========================================================================*/
230
231 /*As per Taxware recommendation, removing this function*/
232 /*function Tax_Type (
233 p_view_name IN VARCHAR2,
234 p_header_id IN Number,
235 p_line_id IN Number)
236 return NUMBER
237 is
238 begin
239 return null;
240 end tax_type;*/
241
242 /*===========================================================================+
243 | FUNCTION |
244 | Service_Indicator |
245 | |
246 | DESCRIPTION |
247 | Returns the service indicator flag |
248 | 1 = Service |
249 | 2 = Rental |
250 | 3 = Non-Service |
251 | |
252 | SCOPE - PUBLIC |
253 | |
254 | MODIFICATION HISTORY |
255 | 09-DEC-97 Kenichi Mizuta Created |
256 | |
257 +===========================================================================*/
258
259 function Service_Indicator (
260 p_view_name IN VARCHAR2,
261 p_header_id IN Number,
262 p_line_id IN Number)
263 return NUMBER
264 is
265 begin
266 return null;
267 end SERVICE_INDICATOR;
268
269
270 /*===========================================================================+
271 | PROCEDURE |
272 | get_exemptions |
273 | |
274 | DESCRIPTION |
275 | Returns the separated State/County/City/Sec Cnty/Sec City |
276 | exemption levels. |
277 | Also returns the STEP90 flags - UseStep, StepProcFlag, CritFlag |
278 | |
279 | |
280 | SCOPE - PUBLIC |
281 | |
282 | MODIFICATION HISTORY |
283 | 09-DEC-97 Kenichi Mizuta Created |
284 | |
285 +===========================================================================*/
286
287 procedure GET_EXEMPTIONS(
288 p_exemption_id In Number,
289 p_State_Exempt_Percent Out NOCOPY Number,
290 p_State_Exempt_Reason Out NOCOPY Varchar2,
291 p_State_Cert_No Out NOCOPY Varchar2,
292 p_County_Exempt_Percent Out NOCOPY Number,
293 p_County_Exempt_Reason Out NOCOPY Varchar2,
294 p_County_Cert_No Out NOCOPY Varchar2,
295 p_City_Exempt_Percent Out NOCOPY Number,
296 p_City_Exempt_Reason Out NOCOPY Varchar2,
297 p_City_Cert_No Out NOCOPY Varchar2,
298 p_Sec_County_Exempt_Percent Out NOCOPY Number,
299 p_Sec_City_Exempt_Percent Out NOCOPY Number,
300 p_Use_Step Out NOCOPY Varchar2,
301 p_Step_Proc_Flag Out NOCOPY Varchar2,
302 p_Crit_Flag Out NOCOPY Varchar2)
303 is
304 begin
305 NULL;
306 end get_exemptions;
307
308
309
310
311
312 /*===========================================================================+
313 | FUNCTION |
314 | poa_address_code |
318 | Character 1 = In/Out City Limits |
315 | |
316 | DESCRIPTION |
317 | Returns POA Geocode |
319 | Character 2-10 = Geocode |
320 | |
321 | SCOPE - PRIVATE |
322 | |
323 | MODIFICATION HISTORY |
324 | 09-DEC-97 Kenichi Mizuta Created |
325 | |
326 +===========================================================================*/
327
328
329 function POA_ADDRESS_CODE(
330 p_view_name IN VARCHAR2,
331 p_header_id IN Number,
332 p_line_id IN Number)
333 return Varchar2 is
334 begin
335 return NULL;
336 end poa_address_code;
337
338 /*===========================================================================+
339 | FUNCTION |
340 | poo_address_code |
341 | |
342 | DESCRIPTION |
343 | Returns POO Geocode |
344 | Character 1 = In/Out City Limits |
345 | Character 2-10 = Geocode |
346 | |
347 | SCOPE - PRIVATE |
348 | |
349 | MODIFICATION HISTORY |
350 | 09-DEC-97 Kenichi Mizuta Created |
351 | |
352 +===========================================================================*/
353
354
355 function POO_ADDRESS_CODE(
356 p_view_name IN VARCHAR2,
357 p_header_id IN Number,
358 p_line_id IN Number,
359 p_salesrep_id IN Number)
360 return Varchar2 is
361
362 begin
363 return NULL;
364 end poo_address_code;
365
366 /*===========================================================================+
367 | FUNCTION |
368 | ship_from_address_code |
369 | |
370 | DESCRIPTION |
371 | Returns Ship From Geocode |
372 | Character 1 = In/Out City Limits |
373 | Character 2-10 = Geocode |
374 | |
375 | SCOPE - Private |
376 | |
377 | MODIFICATION HISTORY |
378 | 09-DEC-97 Kenichi Mizuta Created |
379 | |
380 +===========================================================================*/
381
382
383 function SHIP_FROM_ADDRESS_CODE(
384 p_view_name IN VARCHAR2,
385 p_header_id IN Number,
386 p_line_id IN Number,
387 p_warehouse_id IN Number)
388 return Varchar2 is
389 l_geocode Varchar2(10);
390 begin
391 return NULL;
392 end ship_from_address_code;
393
394 /*===========================================================================+
395 | FUNCTION |
396 | ship_to_address_code |
397 | |
398 | DESCRIPTION |
399 | Returns Ship To Geocode |
400 | Character 1 = In/Out City Limits |
401 | Character 2-10 = Geocode |
402 | |
403 | SCOPE - PRIVATE |
404 | |
405 | MODIFICATION HISTORY |
406 | 09-DEC-97 Kenichi Mizuta Created |
407 | |
408 +===========================================================================*/
409
410 function SHIP_TO_ADDRESS_CODE(
411 p_view_name IN VARCHAR2,
412 p_header_id IN Number,
413 p_line_id IN Number,
414 p_ship_to_address_id In Number,
415 p_ship_to_location_id In Number,
416 p_trx_date In Date,
417 p_ship_to_state In Varchar2,
421 begin
418 p_postal_code In Varchar2)
419 return Varchar2 is
420 l_geocode Varchar2(10);
422 return NULL;
423 end ship_to_address_code;
424
425
426 /*===========================================================================+
427 | FUNCTION |
428 | Calculation_Flag |
429 | |
430 | DESCRIPTION |
431 | Returns the levels that tax should be calculated at |
432 | Character 1 = Calculate tax at State |
433 | Character 2 = Calculate tax at County |
434 | Character 3 = Calculate tax at City |
435 | Character 4 = Calculate tax at Secondary County |
436 | Character 5 = Calculate tax at Secondary City |
437 | 0 = Calculate tax |
438 | 1 = Do not Calculate tax |
439 | |
440 | SCOPE - PRIVATE |
441 | |
442 | MODIFICATION HISTORY |
443 | 09-DEC-97 Kenichi Mizuta Created |
444 | |
445 +===========================================================================*/
446 function Calculation_Flag (
447 p_view_name IN VARCHAR2,
448 p_header_id IN Number,
449 p_line_id IN Number)
450 return Varchar2 is
451 begin
452 return NULL;
453 end Calculation_Flag;
454
455 /*===========================================================================+
456 | FUNCTION |
457 | audit_flag |
458 | |
459 | DESCRIPTION |
460 | Return appropriate audit_flag |
461 | |
462 | SCOPE - Public |
463 | |
464 | MODIFICATION HISTORY |
465 | 20-MAY-99 Toru Kawamura Created |
466 | |
467 +===========================================================================*/
468
469 function AUDIT_FLAG(
470 p_view_name IN VARCHAR2,
471 p_header_id IN Number,
472 p_line_id IN Number)
473 return Varchar2 is
474 l_audit_flag Varchar2(10);
475 begin
476 IF (g_level_procedure >= g_current_runtime_level ) THEN
477 FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG',
478 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG(+)');
479 END IF;
480 IF (g_level_procedure >= g_current_runtime_level ) THEN
481 FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG',
482 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG(-)');
483 END IF;
484 return null;
485 exception
486 When others then
487 g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
488 IF (g_level_unexpected >= g_current_runtime_level ) THEN
489 FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG EXCEPTION ERROR:',
490 g_error_buffer);
491 END IF;
492 end audit_flag;
493
494 /*===========================================================================+
495 | FUNCTION |
496 | total_tax |
497 | |
498 | DESCRIPTION |
499 | Return total tax amount for an invoice |
500 | This function is used in view TAX_ADJUSTMENTS_V_A and |
501 | TAX_ADJUSTMENTS_V_V |
502 | |
503 | SCOPE - Public |
504 | |
505 | MODIFICATION HISTORY |
506 | 14-JUN-99 Nilesh Patel Created |
507 | |
508 +===========================================================================*/
509
510 function total_tax(
511 p_customer_trx_id IN Number
512 )
513 return number is
514 l_amount number;
515 begin
516 return 0;
517 /*This function obsoleted*/
518 end total_tax;
519
520
521
522 /*===========================================================================+
523 | FUNCTION |
524 | customer_code |
525 | |
526 | DESCRIPTION |
527 | Returns the customer code to be passed to Taxware |
528 | |
529 | SCOPE - PUBLIC |
530 | |
531 | MODIFICATION HISTORY |
532 | 03-SEP-03 Santosh Vaze Created (Bug # 3139351) |
533 | 16-JUL-04 Debasis Choudhuri BUG 3768303 |
534 | |
535 +===========================================================================*/
536
537 function customer_code (
538 p_view_name IN VARCHAR2,
539 p_header_id IN Number,
540 p_line_id IN Number)
541 return VARCHAR2
542
543 is
544 begin
545 return NULL;
546 end customer_code;
547
548 /*===========================================================================+
549 | FUNCTION |
550 | transaction_date |
551 | |
552 | DESCRIPTION |
553 | Returns the transaction date to be passed to Vertex |
554 | |
555 | SCOPE - PUBLIC |
556 | |
557 | MODIFICATION HISTORY |
558 | 29-Jun-2005 Sanjeev Ahuja Created |
559 | |
560 +===========================================================================*/
561
562 function transaction_date (
563 p_view_name IN VARCHAR2,
564 p_header_id IN Number,
565 p_line_id IN Number)
566 return DATE
567 -- Bug 4175816 return DATE
568 is
569 begin
570 return NULL;
571 end transaction_date;
572
573 /*===========================================================================+
574 | FUNCTION |
575 | customer_name |
576 | |
577 | DESCRIPTION |
578 | Returns the customer name to be passed to Taxware |
579 | |
580 | SCOPE - PUBLIC |
581 | |
582 | MODIFICATION HISTORY |
583 | 03-SEP-03 Santosh Vaze Created (Bug # 3139351) |
584 | |
585 +===========================================================================*/
586
587 function customer_name (
588 p_view_name IN VARCHAR2,
589 p_header_id IN Number,
590 p_line_id IN Number)
591 return VARCHAR2
592 is
593 begin
594 return NULL;
595 end customer_name;
596
597 end ARP_TAX_VIEW_TAXWARE;