1 PACKAGE pay_us_multi_mmrf AUTHID CURRENT_USER AS
2 /* $Header: payusmultimmrf.pkh 120.0.12000000.1 2007/02/24 10:12:13 sackumar noship $ */
3
4
5
6 /*
7 File : payusmultimmrf.pkh
8 Description : This package declares functions and procedures which are
9 used to return values for the W2 US Payroll reports.
10
11 Change List
12 ---------------
13
14 Version Date Author Bug No. Description of Change
15 -------+---------+-----------+---------+----------------------------------
16 115.24 06-feb-2006 djoshi created
17
18 =============================================================================
19
20 */
21
22 TYPE er_sum_rec IS RECORD
23 ( bal_name varchar2(60)
24 , value varchar2(20)
25 );
26 TYPE er_sum_table IS TABLE OF
27 er_sum_rec
28 INDEX BY BINARY_INTEGER;
29
30
31
32
33 FUNCTION get_w2_er_arch_bal(
34 w2_balance_name in varchar2,
35 w2_tax_unit_id in varchar2,
36 w2_jurisdiction_code in varchar2,
37 w2_jurisdiction_level in varchar2,
38 w2_year varchar2,
39 a1 OUT NOCOPY varchar2,
40 a2 OUT NOCOPY varchar2,
41 a3 OUT NOCOPY varchar2,
42 a4 OUT NOCOPY varchar2,
43 a5 OUT NOCOPY varchar2,
44 a6 OUT NOCOPY varchar2,
45 a7 OUT NOCOPY varchar2,
46 a8 OUT NOCOPY varchar2,
47 a9 OUT NOCOPY varchar2,
48 a10 OUT NOCOPY varchar2,
49 a11 OUT NOCOPY varchar2,
50 a12 OUT NOCOPY varchar2,
51 a13 OUT NOCOPY varchar2,
52 a14 OUT NOCOPY varchar2,
53 a15 OUT NOCOPY varchar2,
54 a16 OUT NOCOPY varchar2,
55 a17 OUT NOCOPY varchar2,
56 a18 OUT NOCOPY varchar2,
57 a19 OUT NOCOPY varchar2,
58 a20 OUT NOCOPY varchar2,
59 a21 OUT NOCOPY varchar2,
60 a22 OUT NOCOPY varchar2,
61 a23 OUT NOCOPY varchar2,
62 a24 OUT NOCOPY varchar2,
63 a25 OUT NOCOPY varchar2,
64 a26 OUT NOCOPY varchar2,
65 a27 OUT NOCOPY varchar2,
66 a28 OUT NOCOPY varchar2,
67 a29 OUT NOCOPY varchar2,
68 a30 OUT NOCOPY varchar2,
69 a31 OUT NOCOPY varchar2,
70 a32 OUT NOCOPY varchar2,
71 a33 OUT NOCOPY varchar2,
72 a34 OUT NOCOPY varchar2,
73 a35 OUT NOCOPY varchar2,
74 a36 OUT NOCOPY varchar2,
75 a37 OUT NOCOPY varchar2,
76 a38 OUT NOCOPY varchar2,
77 a39 OUT NOCOPY varchar2,
78 a40 OUT NOCOPY varchar2,
79 a41 OUT NOCOPY varchar2,
80 a42 OUT NOCOPY varchar2,
81 a43 OUT NOCOPY varchar2,
82 a44 OUT NOCOPY varchar2,
83 a45 OUT NOCOPY varchar2,
84 a46 OUT NOCOPY varchar2,
85 a47 OUT NOCOPY varchar2
86 )
87
88 RETURN varchar2;
89 -- PRAGMA RESTRICT_REFERENCES(get_w2_er_arch_bal, WNDS);
90
91
92
93 end pay_us_multi_mmrf;
[Home] [Help]