1 PACKAGE PAY_US_941_REPORT AS
2 /* $Header: payus941report.pkh 120.1.12000000.1 2007/01/17 14:40:03 appldev noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : pay_us_941_report
21
22 Description : This package is called for the 941 Report to
23 generate the XML file.
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ------ ------- --------------------------
29 15-APR-2005 pragupta 115.0 Created
30 30-OCT-2006 alikhar 115.1 5479800 Added procedure pay_us_941_report_wrapper
31
32 ******************************************************************************/
33
34 /******************************************************************************
35 ** Package Local Variables
36 ******************************************************************************/
37 TYPE XMLRec IS RECORD(
38 xmlstring VARCHAR2(32000));
39
40 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
41 vXMLTable tXMLTable;
42
43 PROCEDURE gen_941_report(p_business_group_id IN NUMBER,
44 p_tax_unit_id IN NUMBER,
45 p_year IN VARCHAR2,
46 p_qtr IN VARCHAR2,
47 p_template_name IN VARCHAR2 DEFAULT NULL,
48 p_XML OUT NOCOPY Clob);
49
50 PROCEDURE pay_us_941_report_wrapper
51 ( errbuf OUT NOCOPY VARCHAR2,
52 retcode OUT NOCOPY VARCHAR2,
53 p_business_group_id IN NUMBER,
54 p_tax_unit_id IN VARCHAR2,
55 p_year IN NUMBER,
56 p_qtr IN VARCHAR2,
57 p_valid_template_list IN VARCHAR2,
58 p_appl_short_name IN VARCHAR2,
59 p_template_name IN VARCHAR2,
60 p_effective_date IN VARCHAR2
61 );
62
63 END pay_us_941_report;