1 PACKAGE pay_ac_taxability_chk_row as
2 /* $Header: paytaxrulchkrow.pkh 120.0 2005/09/10 03:51 psnellin noship $ */
3
4 /*
5 ******************************************************************
6 * *
7 * Copyright (C) 1993 Oracle Corporation. *
8 * All rights reserved. *
9 * *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disclosed to third parties without *
16 * the express written permission of Oracle Corporation, *
17 * 500 Oracle Parkway, Redwood City, CA, 94065. *
18 * *
19 ******************************************************************
20
21 Package Body Name : pay_ac_taxability_chk_row
22 Package File Name : paytaxrulchkrow.pkb
23 Description : This package declares functions and procedures
24 which supports US and CA taxability rules upload
25 via spread sheet loader.
26
27 Change List
28 -----------
29 Date Name Vers Bug No Description
30 ----------- ---------- ------ ------- --------------------------
31 21-JUN-04 fusman 115.0 Created
32 *******************************************************************/
33
34
35 -- Package Variables
36
37
38 /************************************************************
39 ** Function called for US Federal Context is passed
40 ************************************************************/
41 FUNCTION get_taxability_rule_row
42 (p_legislation_code IN VARCHAR2,
43 p_tax_type IN VARCHAR2,
44 p_tax_category IN VARCHAR2,
45 p_classification_id IN NUMBER,
46 p_jurisdiction_code IN VARCHAR2)
47 RETURN VARCHAR2;
48
49 FUNCTION get_county_city_name
50 (p_jurisdiction_code IN VARCHAR2,
51 p_county_or_city IN VARCHAR2)
52 RETURN VARCHAR2;
53
54 FUNCTION get_state_name
55 (p_jurisdiction_code IN VARCHAR2)
56 RETURN VARCHAR2;
57 end pay_ac_taxability_chk_row;