1 PACKAGE pay_us_tax_info_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyusgjit.pkh 115.2 99/07/17 06:44:19 porting ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1997 Oracle Corporation US Ltd., *
7 * *
8 * *
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 US Ltd. *
18 * *
19 * *
20 ******************************************************************
21 Name : pay_us_tax_info_pkg (HEADER)
22 File : pyusgjit.pkh
23 Description : This package declares procedures which are used
24 for any jurisdiction specific tax information
25 stored on the database.
26
27 Change List
28 -----------
29
30 Version Date Author ER/CR No. Description of Change
31 -------+---------+----------+---------+--------------------------
32 40.0 07-DEC-97 lwthomps Date Created
33 40.1/
34 110.1 08-DEC-98 rthirlby 735626 Added get_tax_exist. Used
35 in state balance views.
36 =================================================================
37 */
38
39 FUNCTION get_sit_exist (p_state_abbrev varchar2,
40 p_date DATE)
41 return boolean;
42
43 FUNCTION get_lit_exist ( p_tax_type varchar2,
44 p_jurisdiction_code varchar2,
45 p_date date)
46 return boolean;
47
48 FUNCTION get_tax_exist ( p_tax_type varchar2,
49 p_jurisdiction_code varchar2,
50 p_ee_or_er varchar2,
51 p_date date)
52 return varchar2;
53
54 PRAGMA RESTRICT_REFERENCES(get_tax_exist, WNDS, WNPS);
55
56
57 end pay_us_tax_info_pkg;