[Home] [Help]
PACKAGE: APPS.ZX_MIGRATE_AR_TAX_DEF
Source
1 PACKAGE zx_migrate_ar_tax_def as
2 /* $Header: zxartaxdefmigs.pls 120.3 2005/10/30 01:52:41 appldev ship $ */
3 /*===========================================================================+
4 | PROCEDURE
5 | migrate_ar_tax_code_setup
6 | IN
7 | p_tax_id : ar_vat_tax_all_b.vat_tax_id is passed when it is called from
8 | AR Tax Codes form for synchronization.
9 |
10 | OUT
11 |
12 |
13 | DESCRIPTION
14 | This routine is a wrapper for migration of O2C TAX SETUP.
15 |
16 | SCOPE - PUBLIC
17 |
18 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
19 |
20 | CALLED FROM
21 |
22 | NOTES
23 |
24 | MODIFICATION HISTORY
25 | 08/31/2004 Yoshimichi Konishi Created.
26 |
27 +==========================================================================*/
28
29 PROCEDURE migrate_ar_tax_code_setup (p_tax_id NUMBER);
30
31
32
33 /*===========================================================================+
34 | PROCEDURE
35 | get_r2r_for_ar_taxcode
36 | IN
37 | p_tax_code: varchar2: AR Tax Code (ar_vat_tax_all_b.tax_code)
38 | p_org_id : number : Org ID for AR Tax Code (ar_vat_tax_all_b.org_id)
39 | OUT
40 | p_tax_regime_code : varchar2: Tax Regime Code derived for AR Tax Code
41 | p_tax : varchar2: Tax derived for AR Tax Code
42 | p_tax_status_code : varchar2: Tax Status Code derived for AR Tax Code
43 | p_tax_rate_code : varchar2" Tax Rate Code derived for AR Tax Code
44 |
45 | DESCRIPTION
46 | This routine returns Tax Regime Code, Tax, Tax Status Code, Tax Rate
47 | Code derived for AR Tax Code during eBTax tax definition migration.
48 |
49 | SCOPE - PUBLIC
50 |
51 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
52 |
53 | CALLED FROM
54 |
55 | NOTES
56 | Although this procedure is opened to public it should only be called from
57 | eBTax migration related pl/sql packages after AR Tax Definition migration
58 | has been completed successfully.
59 |
60 | MODIFICATION HISTORY
61 | 12/21/2004 Yoshimichi Konishi Created.
62 |
63 +==========================================================================*/
64
65 PROCEDURE get_r2r_for_ar_taxcode
66 (p_tax_code IN VARCHAR2,
67 p_org_id IN NUMBER,
68 p_tax_class IN VARCHAR2,
69 p_tax_regime_code OUT NOCOPY VARCHAR2,
70 p_tax OUT NOCOPY VARCHAR2,
71 p_tax_status_code OUT NOCOPY VARCHAR2,
72 p_tax_rate_code OUT NOCOPY VARCHAR2);
73
74 /*===========================================================================+
75 | PROCEDURE
76 | migrate_vnd_tax_code
77 |
78 | IN
79 | p_tax_id NUMBER : NULL for initial load.
80 | NOT NULL for synch.
81 | p_tax_type VARCHAR2 DEFAULT NULL : NULL for initial load.
82 | NOT NULL for synch.
83 |
84 | OUT
85 | NA
86 |
87 | DESCRIPTION
88 | This procedure populates Regime to Rate entity for Tax Codes used to
89 | implement tax vendors (VERTEX, TAXWARE).
90 |
91 | Naming Convention
92 | ------------------
93 | Regime Code : 'US-SALES-TAX-VERTEX/TAXWARE'
94 | Tax : STATE, COUNTY, CITY, DISTRICT
95 | Status Code : STD_AR_OUTPUT
96 | Rates : NA
97 |
98 |
99 | SCOPE - PUBLIC
100 |
101 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
102 |
103 | CALLED FROM
104 | zx_migrate_ar_tax_def.migrate_ar_tax_code_setup
105 |
106 | NOTES
107 |
108 |
109 | MODIFICATION HISTORY
110 | 01/19/2005 Yoshimichi Konishi Created.
111 |
112 +==========================================================================*/
113 PROCEDURE migrate_vnd_tax_code (p_tax_id NUMBER,
114 p_tax_type VARCHAR2 DEFAULT NULL);
115
116 /*===========================================================================+
117 | PROCEDURE
118 | migrate_loc_tax_code
119 |
120 | IN
121 | p_tax_id NUMBER : NULL for initial load.
122 | NOT NULL when it is called for SYNCH.
123 | p_tax_type VARCHAR2 DEFAULT NULL: NULL for initial load.
124 | NOT NULL when it is called for SYNCH.
125 |
126 | OUT
127 |
128 | DESCRIPTION
129 | This routine creates records in zx_taxes_b/tl for tax code with tax
130 | type = 'LOCATION' and tax code used by tax vendors.
131 | It creates regime, tax, status.
132 |
133 | SCOPE - PUBLIC
134 |
135 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
136 |
137 | CALLED FROM
138 | zx_migrate_ar_tax_def.migrate_ar_tax_code_setup
139 | zx_upgrade_control_pkg
140 |
141 | NOTES
142 | 8/31/2004 : The logic could be distributed to create_zx_regime, create_zx_tax,
143 | create_zx_status, migrate_ar_vat_tax after the approach is finalized.
144 | 9/28/2004 : May need a synch logic.
145 |
146 | MODIFICATION HISTORY
147 | 08/31/2004 Yoshimichi Konishi Created.
148 | 09/28/2004 Yoshimichi Konishi Modified ZX_TAX population logic.
149 | 10/29/2004 Yoshimichi Konishi Bug 3961322. Modified ZX_TAX population logic.
150 | 11/05/2004 Yoshimichi Konishi Bug 3961322. Added logic to derive parent_
151 | geography_id.
152 | 01/10/2005 Yoshimichi Konishi Reimplemented logic:
153 | -Populates regimes per location structure.
154 | -Populates taxes using segment qualifier.
155 |
156 +==========================================================================*/
157
158 PROCEDURE migrate_loc_tax_code (p_tax_id NUMBER,
159 p_tax_type VARCHAR2 DEFAULT NULL);
160 END;