DBA Data[Home] [Help]

PACKAGE: APPS.PAY_CA_PAYREG_EXTRACT_PKG

Source


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;