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;