DBA Data[Home] [Help]

PACKAGE: APPS.PAY_1099R_FORMULA_DRIVER

Source


1 PACKAGE pay_1099R_formula_driver AUTHID CURRENT_USER AS
2 /* $Header: py1099fd.pkh 115.0 99/07/17 05:40:47 porting ship $ */
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_1099R_formula_driver
22 
23     Description : Allows the creation of formulas which are neccessary
24 		  for 1099R reporting on a federal level. This set of
25 		  formulas includes the following :
26 			US_1099R_FILE_TOTALS
27 			US_1099R_PAYEES
28 			US_1099R_PAYER
29 			US_1099R_PAYER_TOTALS
30 			US_1099R_STATE_TOTALS
31 			US_1099R_TRANSMITTER
32 
33     Uses        : For any 1099R installation.
34 
35     Change List
36     -----------
37     Date        Name     Vers    Bug No     Description
38     ----        ----     ----    ------     -----------
39     05-NOV-96   GPERRY   40.0               Created.
40 
41 */
42 --
43 -- Define start / end of time constants.
44 --
45 	c_start_of_time constant date := to_date('01/01/0001','DD/MM/YYYY');
46 	c_end_of_time   constant date := to_date('31/12/4712','DD/MM/YYYY');
47 --
48 TYPE char240_data_table IS TABLE OF VARCHAR2(240)
49                                   INDEX BY BINARY_INTEGER;
50 --
51 TYPE char80_data_table IS TABLE OF VARCHAR2(80)
52 				  INDEX BY BINARY_INTEGER;
53 --
54 procedure setup;
55 --
56 end pay_1099R_formula_driver;