DBA Data[Home] [Help]

PACKAGE: APPS.PER_MX_SSAFFL_EXTRACT_PKG

Source


1 PACKAGE per_mx_ssaffl_extract_pkg AUTHID CURRENT_USER AS
2 /* $Header: pemxssrp.pkh 115.1 2004/05/16 18:43:32 kthirmiy 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        : per_mx_ssaffl_extract_pkg
22 
23     Description : Package for the SS Affiliation Reports. 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      07-MAY-2004 kthirmiy    115.0             Created.
34 
35 */
36 
37   PROCEDURE ssaffl_extract
38              (errbuf                      out nocopy varchar2
39              ,retcode                     out nocopy number
40              ,p_business_group_id         in  number
41              ,p_tax_unit_id               in  number
42              ,p_affl_type                 in  varchar2
43              ,p_output_file_type          in  varchar2
44              );
45 
46 
47   FUNCTION formated_data_string
48              (p_input_string     in varchar2
49              )
50   RETURN VARCHAR2 ;
51 
52 
53 end per_mx_ssaffl_extract_pkg;