1 PACKAGE pay_us_over_limit_tax_rpt_pkg
2 /* $Header: pyusoltx.pkh 120.0.12000000.1 2007/01/18 02:44:46 appldev noship $ */
3 /* ******************************************************************
4 * *
5 * Copyright (C) 1993 Oracle Corporation. *
6 * All rights reserved. *
7 * *
8 * This material has been provided pursuant to an agreement *
9 * containing restrictions on its use. The material AUTHID CURRENT_USER is also *
10 * protected by copyright law. No part of this material may *
11 * be copied or distributed, transmitted or transcribed, in *
12 * any form or by any means, electronic, mechanical, magnetic, *
13 * manual, or otherwise, or disclosed to third parties without *
14 * the express written permission of Oracle Corporation, *
15 * 500 Oracle Parkway, Redwood City, CA, 94065. *
16 * *
17 ******************************************************************
18
19 Name : pyusoltx.pkh
20
21
22 Description :
23
24 Uses :
25
26 Change List
27 -----------
28 Date Name Vers Bug No Description
29 ----------- -------- ------ -------- -----------
30 01-NOV-1999 hzhao 110.0 Initial Version.
31 22-NOV-1999 hzhao 110.1 Moved Header below Create Stmt.
32 06-DEC-2001 tmehra 110.2 Added dbdrv command.
33 04-FEB-2002 meshah 115.2 2166701 Added procedure load_data.
34 05-FEB-2002 meshah 115.3 Added checkfile entry to the file.
35 04-APR-2002 meshah 115.4 Removed the PRAGMA from
36 get_taxable_balance.
37 25-NOV-2002 irgonzal 115.5 2664340 Added logic to handle Catchup
38 balances.
39 18-MAY-2003 vgunasek 115.6 2938556 report rewrite including support for
40 new balance reporting architecture (run
41 balances) and multi threading.
42 02-JUN-2003 vgunasek 115.7 2938556 Added Comments and change history.
43 02-JUN-2003 vgunasek 115.8 2938556 Commented Pragma restrict references.
44 02-JUN-2003 vgunasek 115.9 2938556 Corrections to change history.
45 02-JUN-2003 vgunasek 115.10 2938556 Corrections to change history.
46
47 ***************************************************************************/
48 AS
49
50 -- Removed the Overloaded function and global limit variables for bug # 2938556
51
52 -- As part of bug # 2938556 the parameters of the function are changed
53 -- to receive balance id instead of attributes from pay_balance_sets
54
55 FUNCTION get_taxable_balance (
56 p_assignment_id IN NUMBER
57 ,p_effective_date IN DATE
58 ,p_assignment_action_id IN NUMBER
59 ,p_tax_unit_id IN NUMBER
60 ,p_tax_group IN VARCHAR2
61 ,p_jurisdiction_code IN VARCHAR2
62 ,p_tax_type IN VARCHAR2
63 ,p_balance_id IN NUMBER
64 )
65 RETURN NUMBER;
66
67 -- The parameter of this function is changed from tax limit name to tax type
68
69 FUNCTION get_state_limit(
70 p_state_code IN NUMBER
71 ,p_tax_type IN VARCHAR2 )
72 RETURN NUMBER;
73
74 -- Additional parameters assignment_id, assignment_action_id and tax unit id
75 -- were added for bug # 2938556.
76
77 procedure load_data
78 ( pactid in number, /* payroll action id */
79 chnkno in number,
80 p_assignment_id IN NUMBER,
81 p_assignment_action_id IN NUMBER,
82 p_tax_unit_id IN NUMBER
83 );
84
85 -- PRAGMA RESTRICT_REFERENCES(get_taxable_balance, WNDS,WNPS);
86 -- PRAGMA RESTRICT_REFERENCES(get_state_limit, WNDS);
87
88
89 END pay_us_over_limit_tax_rpt_pkg;