1 PACKAGE pay_us_taxability_rules_pkg AUTHID CURRENT_USER as
2 /* $Header: paysuetw.pkh 115.2 2003/09/22 19:03:16 asasthan ship $ */
3 --
4 --
5 /*
6 ******************************************************************
7 * *
8 * Copyright (C) 1993 Oracle Corporation. *
9 * All rights reserved. *
10 * *
11 * This material has been provided pursuant to an agreement *
12 * containing restrictions on its use. The material is also *
13 * protected by copyright law. No part of this material may *
14 * be copied or distributed, transmitted or transcribed, in *
15 * any form or by any means, electronic, mechanical, magnetic, *
16 * manual, or otherwise, or disclosed to third parties without *
17 * the express written permission of Oracle Corporation, *
18 * 500 Oracle Parkway, Redwood City, CA, 94065. *
19 * *
20 ******************************************************************
21
22
23 Name : pay_us_taxability_rules_pkg
24
25 Description : This package holds building blocks used in maintenace
26 of US taxability rule using PAY_TAXABILITY_RULES
27 table.
28
29 Uses : hr_utility
30
31 Change List
32 -----------
33 Date Name Vers Bug No Description
34 ---- ---- ---- ------ -----------
35 NOV-11-1993 RMAMGAIN 1.0 Created with following proc.
36 get_or_update
37 05-OCT-1994 RFINE 40.2 Added 'PAY_' to package name.
38 05-OCT-1994 RFINE 40.3 ... and suffix '_PKG'
39 03-APR-1995 gpaytonm 40.4 Modified to handle popuilating
40 classification id.
41
42 22-SEP-2003 gpaytonm 115.2 Added get_balance_type
43 */
44 --
45
46 PROCEDURE get_or_update(X_MODE VARCHAR2,
47 X_CONTEXT VARCHAR2,
48 X_JURISDICTION VARCHAR2,
49 X_TAX_CAT VARCHAR2,
50 X_classification_id NUMBER,
51 X_BOX1 IN OUT NOCOPY VARCHAR2,
52 X_BOX2 IN OUT NOCOPY VARCHAR2,
53 X_BOX3 IN OUT NOCOPY VARCHAR2,
54 X_BOX4 IN OUT NOCOPY VARCHAR2,
55 X_BOX5 IN OUT NOCOPY VARCHAR2,
56 X_BOX6 IN OUT NOCOPY VARCHAR2);
57
58 FUNCTION get_classification_id (p_classification_name VARCHAR2) RETURN NUMBER;
59
60 PROCEDURE get_balance_type(p_tax_type in varchar2,
61 p_tax_category in varchar2,
62 p_taxability_rules_date_id in number,
63 p_legislation_code in varchar2,
64 p_classification_id in number);
65
66 END pay_us_taxability_rules_pkg;