1 PACKAGE pay_archiver_report_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyempdtl.pkh 120.0.12020000.2 2012/07/06 10:05:41 vmaripal ship $ */
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 17-Jan-2012 nkjaladi 115.5 11927527 Modified Package Procedure
40 pay_archiver_report_pkg.archiver_extract
41 to support for PSD. Added two new
42 parameters p_is_psd and p_psd_id.
43
44 */
45
46 PROCEDURE archiver_extract
47 (errbuf out nocopy varchar2
48 ,retcode out nocopy number
49 ,p_business_group_id in number
50 ,p_beginning_date in varchar2
51 ,p_end_date in varchar2
52 ,p_jurisdiction_level in varchar2
53 ,p_detail_level in varchar2
54 ,p_is_byRun in varchar2
55 ,p_organization_id in number
56 ,p_location_id in number
57 ,p_is_summary in varchar2
58 ,p_is_state in varchar2
59 ,p_state_id in varchar2
60 ,p_is_county in varchar2
61 ,p_is_state_mandatory in varchar2
62 ,p_county_id in varchar2
63 ,p_is_city in varchar2
64 ,p_city_id in varchar2
65 ,p_is_school in varchar2
66 ,p_school_id in varchar2
67 ,p_is_psd in varchar2 --#11927527
68 ,p_psd_id in varchar2 --#11927527
69 ,p_payroll_id in number
70 ,p_consolidation_set_id in number
71 ,p_tax_unit_id in varchar2
72 ,p_assignment_set_id in number
73 ,p_output_file_type in varchar2
74 );
75
76 end pay_archiver_report_pkg;