1 PACKAGE pay_archiver_report_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyempdtl.pkh 115.4 2003/06/13 21:07:49 ekim 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_archiver_report_pkg
22
23 Description : Package for Employee Periodic Report. The package
24 generated the output file in the specified user
25 format. The current formats supported are
26 - HTML
27 - CSV
28
29 Change List
30 -----------
31 Date Name Vers Bug No Description
32 ----------- ---- ------ ------- -----------
33 06-Mar-2002 ekim 115.0 Created.
34 24-Mar-2002 ahanda 115.1 Fixed GSCC warnings.
35 01-Apr-2002 ekim 115.2 Removed p_is_city_mandatory
36 parameter from archiver_extract.
37 15-Apr-2002 ekim 115.3 Removed p_is_county_mandatory.
38 13-Jun-2003 ekim 115.4 Fixed GSCC warnings.
39
40 */
41
42 PROCEDURE archiver_extract
43 (errbuf out nocopy varchar2
44 ,retcode out nocopy number
45 ,p_business_group_id in number
46 ,p_beginning_date in varchar2
47 ,p_end_date in varchar2
48 ,p_jurisdiction_level in varchar2
49 ,p_detail_level in varchar2
50 ,p_is_byRun in varchar2
51 ,p_organization_id in number
52 ,p_location_id in number
53 ,p_is_summary in varchar2
54 ,p_is_state in varchar2
55 ,p_state_id in varchar2
56 ,p_is_county in varchar2
57 ,p_is_state_mandatory in varchar2
58 ,p_county_id in varchar2
59 ,p_is_city in varchar2
60 ,p_city_id in varchar2
61 ,p_is_school in varchar2
62 ,p_school_id in varchar2
63 ,p_payroll_id in number
64 ,p_consolidation_set_id in number
65 ,p_tax_unit_id in varchar2
66 ,p_assignment_set_id in number
67 ,p_output_file_type in varchar2
68 );
69
70 end pay_archiver_report_pkg;