[Home] [Help]
PACKAGE: APPS.ZX_ACCOUNT_TAX_RATES_PKG
Source
1 PACKAGE zx_account_tax_rates_pkg AS
2 /* $Header: zxglatrs.pls 120.2 2005/09/30 17:29:46 mparihar noship $ */
3 --
4 -- Package
5 -- zx_account_tax_rates_pkg
6 -- Purpose
7 -- To implement various data checking needed for the
8 -- gl_tax_options table
9 -- History
10 -- 24-NOV-04 Tai-Hyun Won Created
11 --
12
13 --
14 -- Procedure
15 -- select_columns
16 -- Purpose
17 -- Gets the values of some columns from zx_account_rates associated
18 -- with the given ledger and content owner.
19 -- History
20 -- 24-NOV-04 Tai-Hyun Won Created.
21 -- Arguments
22 -- x_ledger_id ID of the current ledger
23 -- x_content_owner_id ID of the current Content Owner
24 -- x_tax_precision Tax precision
25 -- x_tax_mau Tax mau
26 PROCEDURE select_columns(
27 x_ledger_id NUMBER,
28 x_content_owner_id NUMBER,
29 x_tax_precision IN OUT NOCOPY NUMBER,
30 x_tax_mau IN OUT NOCOPY NUMBER);
31
32
33 --
34 -- Procedure
35 -- duplicate_tax_options
36 --
37 -- Purpose
38 -- Check if another record for the same ledger id and org id exists
39 --
40 -- History
41 --
42 --
43 -- Arguments
44 -- x_ledger_id ID of the current Ledger
45 -- x_content_owner_id ID of the current Content Owner
46 -- x_rowid Row ID
47 --
48 PROCEDURE duplicate_tax_options(
49 x_ledger_id NUMBER,
50 x_content_owner_id NUMBER,
51 x_rowid VARCHAR2);
52
53
54 --
55 -- Procedure
56 -- org_name
57 --
58 -- Purpose
59 -- Gets the name of the current organization
60 --
61 -- History
62 --
63 --
64 -- Arguments
65 -- x_org_id ID of the current organization
66 -- x_org_name Name of the current organization
67 --
68 PROCEDURE org_name(
69 x_org_id NUMBER,
70 x_org_name IN OUT NOCOPY VARCHAR2);
71
72
73 --
74 -- Procedure
75 -- insert_row
76 -- Purpose
77 --
78 -- History
79 -- 24-Nov-04 Tai-Hyun Won Created
80 --
81 PROCEDURE insert_row(
82 X_LEDGER_ID NUMBER,
83 X_CONTENT_OWNER_ID NUMBER,
84 X_ACCOUNT_SEGMENT_VALUE VARCHAR2,
85 X_TAX_PRECISION NUMBER,
86 X_CALCULATION_LEVEL_CODE VARCHAR2,
87 X_ALLOW_RATE_OVERRIDE_FLAG VARCHAR2,
88 X_TAX_MAU NUMBER,
89 X_TAX_CURRENCY_CODE VARCHAR2,
90 X_TAX_CLASS VARCHAR2,
91 X_TAX_REGIME_CODE VARCHAR2,
92 X_TAX VARCHAR2,
93 X_TAX_STATUS_CODE VARCHAR2,
94 X_TAX_RATE_CODE VARCHAR2,
95 X_ROUNDING_RULE_CODE VARCHAR2,
96 X_AMT_INCL_TAX_FLAG VARCHAR2,
97 X_RECORD_TYPE_CODE VARCHAR2,
98 X_CREATION_DATE DATE,
99 X_CREATED_BY NUMBER,
100 X_LAST_UPDATED_BY NUMBER,
101 X_LAST_UPDATE_DATE DATE,
102 X_LAST_UPDATE_LOGIN NUMBER,
103 X_ATTRIBUTE_CATEGORY VARCHAR2,
104 X_ATTRIBUTE1 VARCHAR2,
105 X_ATTRIBUTE2 VARCHAR2,
106 X_ATTRIBUTE3 VARCHAR2,
107 X_ATTRIBUTE4 VARCHAR2,
108 X_ATTRIBUTE5 VARCHAR2,
109 X_ATTRIBUTE6 VARCHAR2,
110 X_ATTRIBUTE7 VARCHAR2,
111 X_ATTRIBUTE8 VARCHAR2,
112 X_ATTRIBUTE9 VARCHAR2,
113 X_ATTRIBUTE10 VARCHAR2,
114 X_ATTRIBUTE11 VARCHAR2,
115 X_ATTRIBUTE12 VARCHAR2,
116 X_ATTRIBUTE13 VARCHAR2,
117 X_ATTRIBUTE14 VARCHAR2,
118 X_ATTRIBUTE15 VARCHAR2,
119 X_ALLOW_ROUNDING_OVERRIDE_FLAG VARCHAR2);
120
121 --
122 -- Procedure
123 -- update_row
124 -- Purpose
125 --
126 -- History
127 -- 24-Nov-04 Tai-Hyun Won Created
128 --
129 PROCEDURE update_row(
130 X_RECORD_LEVEL VARCHAR2,
131 X_LEDGER_ID NUMBER,
132 X_CONTENT_OWNER_ID NUMBER,
133 X_ACCOUNT_SEGMENT_VALUE VARCHAR2,
134 X_TAX_PRECISION NUMBER,
135 X_CALCULATION_LEVEL_CODE VARCHAR2,
136 X_ALLOW_RATE_OVERRIDE_FLAG VARCHAR2,
137 X_TAX_MAU NUMBER,
138 X_TAX_CURRENCY_CODE VARCHAR2,
139 X_TAX_CLASS VARCHAR2,
140 X_TAX_REGIME_CODE VARCHAR2,
141 X_TAX VARCHAR2,
142 X_TAX_STATUS_CODE VARCHAR2,
143 X_TAX_RATE_CODE VARCHAR2,
144 X_ROUNDING_RULE_CODE VARCHAR2,
145 X_AMT_INCL_TAX_FLAG VARCHAR2,
146 X_RECORD_TYPE_CODE VARCHAR2,
147 X_CREATION_DATE DATE,
148 X_CREATED_BY NUMBER,
149 X_LAST_UPDATED_BY NUMBER,
150 X_LAST_UPDATE_DATE DATE,
151 X_LAST_UPDATE_LOGIN NUMBER,
152 X_ATTRIBUTE_CATEGORY VARCHAR2,
153 X_ATTRIBUTE1 VARCHAR2,
154 X_ATTRIBUTE2 VARCHAR2,
155 X_ATTRIBUTE3 VARCHAR2,
156 X_ATTRIBUTE4 VARCHAR2,
157 X_ATTRIBUTE5 VARCHAR2,
158 X_ATTRIBUTE6 VARCHAR2,
159 X_ATTRIBUTE7 VARCHAR2,
160 X_ATTRIBUTE8 VARCHAR2,
161 X_ATTRIBUTE9 VARCHAR2,
162 X_ATTRIBUTE10 VARCHAR2,
163 X_ATTRIBUTE11 VARCHAR2,
164 X_ATTRIBUTE12 VARCHAR2,
165 X_ATTRIBUTE13 VARCHAR2,
166 X_ATTRIBUTE14 VARCHAR2,
167 X_ATTRIBUTE15 VARCHAR2,
168 X_ALLOW_ROUNDING_OVERRIDE_FLAG VARCHAR2,
169 X_CONTENT_OWNER_ID_ORIG NUMBER,
170 X_ACCOUNT_SEGMENT_VALUE_ORIG VARCHAR2,
171 X_TAX_CLASS_ORIG VARCHAR2);
172
173 --
174 -- Procedure
175 -- lock_row
176 -- Purpose
177 --
178 -- History
179 -- 24-Nov-04 Tai-Hyun Won Created
180 --
181 PROCEDURE lock_row(
182 X_RECORD_LEVEL VARCHAR2,
183 X_LEDGER_ID NUMBER,
184 X_CONTENT_OWNER_ID NUMBER,
185 X_ACCOUNT_SEGMENT_VALUE VARCHAR2,
186 X_TAX_PRECISION NUMBER,
187 X_CALCULATION_LEVEL_CODE VARCHAR2,
188 X_ALLOW_RATE_OVERRIDE_FLAG VARCHAR2,
189 X_TAX_MAU NUMBER,
190 X_TAX_CURRENCY_CODE VARCHAR2,
191 X_TAX_CLASS VARCHAR2,
192 X_TAX_REGIME_CODE VARCHAR2,
193 X_TAX VARCHAR2,
194 X_TAX_STATUS_CODE VARCHAR2,
195 X_TAX_RATE_CODE VARCHAR2,
196 X_ROUNDING_RULE_CODE VARCHAR2,
197 X_AMT_INCL_TAX_FLAG VARCHAR2,
198 X_RECORD_TYPE_CODE VARCHAR2,
199 X_CREATION_DATE DATE,
200 X_CREATED_BY NUMBER,
201 X_LAST_UPDATED_BY NUMBER,
202 X_LAST_UPDATE_DATE DATE,
203 X_LAST_UPDATE_LOGIN NUMBER,
204 X_ATTRIBUTE_CATEGORY VARCHAR2,
205 X_ATTRIBUTE1 VARCHAR2,
206 X_ATTRIBUTE2 VARCHAR2,
207 X_ATTRIBUTE3 VARCHAR2,
208 X_ATTRIBUTE4 VARCHAR2,
209 X_ATTRIBUTE5 VARCHAR2,
210 X_ATTRIBUTE6 VARCHAR2,
211 X_ATTRIBUTE7 VARCHAR2,
212 X_ATTRIBUTE8 VARCHAR2,
213 X_ATTRIBUTE9 VARCHAR2,
214 X_ATTRIBUTE10 VARCHAR2,
215 X_ATTRIBUTE11 VARCHAR2,
216 X_ATTRIBUTE12 VARCHAR2,
217 X_ATTRIBUTE13 VARCHAR2,
218 X_ATTRIBUTE14 VARCHAR2,
219 X_ATTRIBUTE15 VARCHAR2,
220 X_ALLOW_ROUNDING_OVERRIDE_FLAG VARCHAR2);
221
222 END zx_account_tax_rates_pkg;