1 PACKAGE pay_ca_payreg_extract_pkg AS
2 /* $Header: pycaprpe.pkh 120.0.12000000.1 2007/01/17 17:14:53 appldev 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_ca_payreg_extract_pkg
22
23 Description : Package for the Payment 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 10-OCT-2001 ssattini 115.0 Created.
34 20-NOV-2001 ssattini 115.1 Added dbdrv line.
35 19-DEC-2001 ssattini 115.2 Added checkfile line.
36 22-JAN-2003 ssattini 115.3 Added NOCOPY for GSCC.
37
38 */
39
40 PROCEDURE payment_extract
41 (errbuf out NOCOPY varchar2
42 ,retcode out NOCOPY number
43 ,p_business_group_id in number
44 ,p_start_date in varchar2
45 ,p_end_date in varchar2
46 ,p_payroll_id in number default NULL
47 ,p_consolidation_set_id in number
48 ,p_tax_unit_id in number default NULL
49 ,p_payment_type_id in number default NULL
50 ,p_payment_method_id in number default NULL
51 ,p_output_file_type in varchar2
52 );
53
54 end pay_ca_payreg_extract_pkg;