1 Package pay_taxability_rules_api as
2 /* $Header: paytxabltyrulapi.pkh 120.0 2005/05/29 11:51 appldev noship $ */
3
4
5 FUNCTION check_taxability_rule_exists
6 (p_jurisdiction IN VARCHAR2
7 ,p_legislation_code IN VARCHAR2
8 ,p_classification_id IN NUMBER default null
9 ,p_tax_category IN VARCHAR2 default null
10 ,p_tax_type IN VARCHAR2 default null
11 ,p_secondary_classification_id IN NUMBER default null
12 )
13 RETURN VARCHAR2;
14
15 Procedure create_taxability_rules
16 ( p_validate IN BOOLEAN
17 ,p_jurisdiction IN VARCHAR2
18 ,p_tax_type IN VARCHAR2 default null
19 ,p_tax_category IN VARCHAR2 default null
20 ,p_classification_id IN NUMBER default null
21 ,p_taxability_rules_date_id IN NUMBER
22 ,p_legislation_code IN VARCHAR2
23 ,p_status IN VARCHAR2
24 ,p_secondary_classification_id IN NUMBER default null);
25
26
27 Procedure update_taxability_rules
28 ( p_validate IN BOOLEAN
29 ,p_jurisdiction IN VARCHAR2
30 ,p_tax_type IN VARCHAR2 default null
31 ,p_tax_category IN VARCHAR2 default null
32 ,p_classification_id IN NUMBER default null
33 ,p_taxability_rules_date_id IN NUMBER
34 ,p_legislation_code IN VARCHAR2
35 ,p_status IN VARCHAR2
36 ,p_secondary_classification_id IN NUMBER default null
37 ) ;
38
39
40 /***********************************************************
41 ** We will never be deleting the data in pay_taxability_rules
42 ** table. We will be updating the status to 'D' if the value
43 ** already exists.
44 **
45 ** Commenting out the delete becasue of the reason mentioned
46 ** above.
47 Procedure delete_taxability_rules
48 ( p_validate IN BOOLEAN
49 ,p_jurisdiction IN VARCHAR2
50 ,p_tax_type IN VARCHAR2
51 ,p_tax_category IN VARCHAR2
52 ,p_classification_id IN NUMBER
53 ,p_taxability_rules_date_id IN NUMBER
54 ,p_legislation_code IN VARCHAR2
55 ,p_status IN VARCHAR2);
56 ***********************************************************/
57
58
59 end pay_taxability_rules_api;