1 package arp_tax_view_vertex AUTHID CURRENT_USER as
2 /* $Header: zxtxvwvs.pls 120.2 2006/10/06 11:45:14 vchallur ship $ */
3
4
5 USE_SHIP_TO CONSTANT VARCHAR2(10) := 'XXXXXXXXXX';
6
7 /*===========================================================================+
8 | FUNCTION |
9 | product_code |
10 | |
11 | DESCRIPTION |
12 | Returns the product_code |
13 | Returns segment1 from MTL_SYSTEM_ITEMS. |
14 | Users may have a different segment for the product code. |
15 | |
16 | SCOPE - PUBLIC |
17 | |
18 | MODIFICATION HISTORY |
19 | 09-DEC-97 Kenichi Mizuta Created |
20 | |
21 +===========================================================================*/
22
23 function PRODUCT_CODE(
24 p_view_name IN VARCHAR2,
25 p_header_id IN Number,
26 p_line_id IN Number,
27 p_item_id IN NUMBER,
28 p_memo_line_id IN NUMBER)
29 return VARCHAR2;
30
31 /*===========================================================================+
32 | FUNCTION |
33 | vendor_control_exemptions |
34 | |
35 | DESCRIPTION |
36 | NOT USED BY VERTEX |
37 | |
38 | SCOPE - PUBLIC |
39 | |
40 | MODIFICATION HISTORY |
41 | 09-DEC-97 Kenichi Mizuta Created |
42 | |
43 +===========================================================================*/
44
45 function VENDOR_CONTROL_EXEMPTIONS (
46 p_view_name IN VARCHAR2,
47 p_header_id IN Number,
48 p_line_id IN Number,
49 p_trx_type_id IN Number)
50 return VARCHAR2;
51
52 /*===========================================================================+
53 | FUNCTION |
54 | company_code |
55 | |
56 | DESCRIPTION |
57 | Returns the company_code. |
58 | Constant value of '01'. |
59 | |
60 | SCOPE - PUBLIC |
61 | |
62 | MODIFICATION HISTORY |
63 | 09-DEC-97 Kenichi Mizuta Created |
64 | |
65 +===========================================================================*/
66
67 function COMPANY_CODE(
68 p_view_name IN VARCHAR2,
69 p_header_id IN Number,
70 p_line_id IN Number)
71 return VARCHAR2;
72
73
74 /*===========================================================================+
75 | FUNCTION |
76 | division_code |
77 | |
78 | DESCRIPTION |
79 | Returns the division_code |
80 | Constant value of '01'. |
81 | |
82 | SCOPE - PUBLIC |
83 | |
84 | MODIFICATION HISTORY |
85 | 09-DEC-97 Kenichi Mizuta Created |
86 | |
87 +===========================================================================*/
88
89 function DIVISION_CODE(
90 p_view_name IN VARCHAR2,
91 p_header_id IN Number,
92 p_line_id IN Number)
93 return VARCHAR2;
94
95
96 /*===========================================================================+
97 | FUNCTION |
98 | trx_line_type |
99 | |
100 | DESCRIPTION |
101 | Returns the Trx Line type. Constant value of 'SALE' |
102 | |
103 | SCOPE - PUBLIC |
104 | |
105 | MODIFICATION HISTORY |
106 | 09-DEC-97 Kenichi Mizuta Created |
107 | |
108 +===========================================================================*/
109
110 function TRX_LINE_TYPE(
111 p_view_name IN VARCHAR2,
112 p_header_id IN Number,
113 p_line_id IN Number)
114 return VARCHAR2;
115
116 /*===========================================================================+
117 | FUNCTION |
118 | customer_class |
119 | |
120 | DESCRIPTION |
121 | Returns the customer class code of the customer |
122 | |
123 | SCOPE - PUBLIC |
124 | |
125 | MODIFICATION HISTORY |
126 | 09-DEC-97 Kenichi Mizuta Created |
127 | |
128 +===========================================================================*/
129
130 function customer_class (
131 p_view_name IN VARCHAR2,
132 p_header_id IN Number,
133 p_line_id IN Number,
134 p_customer_id IN Number)
135 return VARCHAR2;
136
137 /*===========================================================================+
138 | PROCEDURE |
139 | get_exemptions |
140 | |
141 | DESCRIPTION |
142 | Returns the separated State/County/District/City exemption levels. |
143 | |
144 | SCOPE - PUBLIC |
145 | |
146 | MODIFICATION HISTORY |
147 | 09-DEC-97 Kenichi Mizuta Created |
148 | |
149 +===========================================================================*/
150
151 procedure GET_EXEMPTIONS(
152 p_exemption_id In Number,
153 p_cert_no Out NOCOPY Varchar2,
154 p_State_Exempt_Percent Out NOCOPY Number,
155 p_State_Exempt_Reason Out NOCOPY Varchar2,
156 p_County_Exempt_Percent Out NOCOPY Number,
157 p_County_Exempt_Reason Out NOCOPY Varchar2,
158 p_City_Exempt_Percent Out NOCOPY Number,
159 p_City_Exempt_Reason Out NOCOPY Varchar2,
160 p_District_Exempt_Percent Out NOCOPY Number,
161 p_District_Exempt_Reason Out NOCOPY Varchar2);
162
163
164
165 /*===========================================================================+
166 | FUNCTION |
167 | poo_address_code |
168 | |
169 | DESCRIPTION |
170 | NOT USED BY VERTEX |
171 | |
172 | SCOPE - Public |
173 | |
174 | MODIFICATION HISTORY |
175 | 09-DEC-97 Kenichi Mizuta Created |
176 | |
177 +===========================================================================*/
178
179
180 function POO_ADDRESS_CODE(
181 p_view_name IN VARCHAR2,
182 p_header_id IN Number,
183 p_line_id IN Number)
184 return Varchar2;
185
186
187 /*===========================================================================+
188 | FUNCTION |
189 | poa_address_code |
190 | |
191 | DESCRIPTION |
192 | Concatenates the In/Out City Limits and the Geocode |
193 | |
194 | SCOPE - Public |
195 | |
196 | MODIFICATION HISTORY |
197 | 09-DEC-97 Kenichi Mizuta Created |
198 | |
199 +===========================================================================*/
200
201
202 function POA_ADDRESS_CODE(
203 p_view_name IN VARCHAR2,
204 p_header_id IN Number,
205 p_line_id IN Number,
206 p_salesrep_id IN Number)
207 return Varchar2;
208
209
210 /*===========================================================================+
211 | FUNCTION |
212 | ship_from_address_code |
213 | |
214 | DESCRIPTION |
215 | Concatenates the In/Out City Limits and the Geocode |
216 | |
217 | SCOPE - Public |
218 | |
219 | MODIFICATION HISTORY |
220 | 09-DEC-97 Kenichi Mizuta Created |
221 | |
222 +===========================================================================*/
223
224
225 function SHIP_FROM_ADDRESS_CODE(
226 p_view_name IN VARCHAR2,
227 p_header_id IN Number,
228 p_line_id IN Number,
229 p_warehouse_id IN Number)
230 return Varchar2;
231
232 /*===========================================================================+
233 | FUNCTION |
234 | ship_to_address_code |
235 | |
236 | DESCRIPTION |
237 | Concatenates the In/Out City Limits and the Geocode |
238 | |
239 | SCOPE - Public |
240 | |
241 | MODIFICATION HISTORY |
242 | 09-DEC-97 Kenichi Mizuta Created |
243 | |
244 +===========================================================================*/
245
246 function SHIP_TO_ADDRESS_CODE(
247 p_view_name IN VARCHAR2,
248 p_header_id IN Number,
249 p_line_id IN Number,
250 p_ship_to_address_id In Number,
251 p_ship_to_location_id In Number,
252 p_trx_date In Date,
253 p_ship_to_state In Varchar2,
254 p_postal_code In Varchar2)
255 return Varchar2;
256
257
258 /*===========================================================================+
259 | FUNCTION |
260 | audit_flag |
261 | |
262 | DESCRIPTION |
263 | Return appropriate audit_flag |
264 | |
265 | SCOPE - Public |
266 | |
267 | MODIFICATION HISTORY |
268 | 20-MAY-99 Toru Kawamura Created |
269 | |
270 +===========================================================================*/
271
272 function AUDIT_FLAG(
273 p_view_name IN VARCHAR2,
274 p_header_id IN Number,
275 p_line_id IN Number)
276 return Varchar2;
277
278
279 /*===========================================================================+
280 | FUNCTION |
281 | total_tax |
282 | |
283 | DESCRIPTION |
284 | Return total tax amount for an invoice |
285 | This function is used in view TAX_ADJUSTMENTS_V_A and |
286 | TAX_ADJUSTMENTS_V_V |
287 | |
288 | SCOPE - Public |
289 | |
290 | MODIFICATION HISTORY |
291 | 14-JUN-99 Nilesh Patel Created |
292 | |
293 +===========================================================================*/
294
295 function total_tax(
296 p_customer_trx_id IN Number )
297 return number;
298
299
303 | |
300 /*===========================================================================+
301 | FUNCTION |
302 | customer_code |
304 | DESCRIPTION |
305 | Returns the customer code to be passed to Vertex |
306 | |
307 | SCOPE - PUBLIC |
308 | |
309 | MODIFICATION HISTORY |
310 | 03-SEP-03 Santosh Vaze Created |
311 | 18-MAr-04 Debasis Bug3486347 |
312 +===========================================================================*/
313
314 function customer_code (
315 p_view_name IN VARCHAR2,
316 p_header_id IN Number,
317 p_line_id IN Number)
318 return varchar2;
319 --Bug 3486347 return number;
320
321
322
323 /*===========================================================================+
324 | FUNCTION |
325 | transaction_date |
326 | |
327 | DESCRIPTION |
328 | Returns the transaction date to be passed to Vertex |
329 | |
330 | SCOPE - PUBLIC |
331 | |
332 | MODIFICATION HISTORY |
333 | 29-Jun-2005 Sanjeev Ahuja Created |
334 | |
335 +===========================================================================*/
336 function transaction_date (
337 p_view_name IN VARCHAR2,
338 p_header_id IN Number,
339 p_line_id IN Number)
340 return DATE;
341 --Bug 4175816 return date;
342
343 /*===========================================================================+
344 | PROCEDURE |
345 | override_parameters |
346 | |
347 | DESCRIPTION |
348 | This procedure will be executed between RESET_PARAMETERS and |
349 | SET_PARAMETERS in ARP_TAX_VERTEX.calculate and will enable the |
350 | user to override the parameters set therein |
351 | |
352 | SCOPE - Public |
353 | |
354 | MODIFICATION HISTORY |
355 | 16-JUN-99 Nilesh Patel Created |
356 | |
357 +===========================================================================*/
358
359 PROCEDURE override_parameters;
360
361
362 /*-----------------------------------------------------------+
363 WRITES NO DATABASE STATE
364 WRITES NO PROGRAM STATE PRAGMAS
365 +-----------------------------------------------------------*/
366
367
368 end ARP_TAX_VIEW_VERTEX;
|
|
|