1 PACKAGE pay_livearchive_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyuslvar.pkh 115.2 2003/09/26 03:02:45 ardsouza noship $ */
3 --
4 /*
5 ******************************************************************
6 * *
7 * Copyright (C) 1996 Oracle Corporation. *
8 * All rights reserved. *
9 * *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disclosed to third parties without *
16 * the express written permission of Oracle Corporation, *
17 * 500 Oracle Parkway, Redwood City, CA, 94065. *
18 * *
19 ******************************************************************
20
21 Name : pay_livearchive_pkg
22
23 Description : Packge header for Year End Reconsilation Report
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ---- ---- ------ ------- -----------
29 01-oct-2002 djoshi 115.0 2202647 Created.
30 02-dec-2002 djoshi 115.1 Corrected to have
31 nocopy with out parameter
32 25-sep-2003 ardsouza 115.2 2554865 Added parameter p_box_type
33 to procedure select_employee
34 */
35
36 function get_archive_value ( p_assignment_action_id number,
37 p_balance_name varchar2,
38 p_tax_unit_id number,
39 p_jurisdiction varchar2,
40 p_jurisdiction_level number
41 ) return number ;
42
43 function get_live_value (
44 p_balance_name varchar2
45 ) return number ;
46
47 PROCEDURE SELECT_EMPLOYEE
48 (errbuf OUT nocopy varchar2,
49 retcode OUT nocopy number,
50 p_year IN VARCHAR2,
51 p_tax_unit_id IN NUMBER,
52 p_fed_state IN VARCHAR2,
53 p_is_state IN VARCHAR2,
54 p_state_code IN VARCHAR2 default null,
55 p_box_type IN VARCHAR2, /* Bug 2554865 */
56 p_box_name IN VARCHAR2 default null,
57 p_output_file_type IN VARCHAR2
58 );
59
60
61 /**************************************************************
62 ** PL/SQL table of records to store element name and value
63 ***************************************************************/
64 /*
65 TYPE rec_element IS RECORD (element_name varchar(100),
66 value number);
67 TYPE tab_element IS TABLE OF rec_element INDEX BY BINARY_INTEGER;
68 */
69 TYPE rec_for_balanace IS RECORD (bal_name varchar(100)
70 ,bal_id number
71 ,bal_value number);
72
73
74 /* following code is for future usage when we move to comparing all the
75 balances.
76 */
77 TYPE live_bal_tab IS TABLE OF rec_for_balanace INDEX BY BINARY_INTEGER;
78 TYPE arch_bal_tab IS TABLE OF rec_for_balanace INDEX BY BINARY_INTEGER;
79
80 end pay_livearchive_pkg;