[Home] [Help]
PACKAGE: APPS.PAY_US_TRR_ENGINE_PKG
Source
1 package PAY_US_TRR_ENGINE_PKG AUTHID CURRENT_USER as
2 /*$Header: pyusteng.pkh 115.4 2003/08/26 16:48:45 meshah noship $*/
3 /*===========================================================================*
4 | Copyright (c) 1997 Oracle Corporation |
5 | All rights reserved. |
6 *============================================================================*/
7 /*
8 REM DESCRIPTION
9 REM This script creates the federal tax remittance report SRS definitions
10 REM
11 REM
12 REM Change History
13 REM
14 REM Vers Date Author Reason
15 REM 115.0 14-JUN-2002 meshah created. copy for pytrreng.pkh ver 115.3
16 REM 115.1 08-JAN-2002 meshah made nocopy changes.
17 REM 115.2 10-JAN-2002 meshah incorrect comments
18 REM 115.4 26-AUG-2003 meshah increased the GRE Name length to 240.
19 */
20 --
21 type gre_info is record
22 (
23 gre_size number,
24 gre_id number,
25 gre_name varchar2(240)
26 );
27
28 type gre_info_list is table of gre_info index by binary_integer;
29
30 procedure federal_trr(errbuf OUT nocopy VARCHAR2,
31 retcode OUT nocopy NUMBER,
32 p_business_group number,
33 p_start_date varchar2,
34 p_end_date varchar2,
35 p_gre number,
36 p_federal varchar2,
37 p_state varchar2,
38 p_dimension varchar2);
39 procedure state_trr;
40 --
41 procedure local_trr(errbuf out nocopy varchar2
42 ,retcode out nocopy number
43 ,p_business_group number
44 ,p_start_date varchar2
45 ,p_end_date varchar2
46 ,p_gre number
47 ,p_state varchar2
48 ,p_locality_type varchar2
49 ,p_is_city varchar2
50 ,p_city varchar2
51 ,p_is_county varchar2
52 ,p_county varchar2
53 ,p_is_school varchar2
54 ,p_school varchar2
55 ,p_sort_option_1 varchar2
56 ,p_sort_option_2 varchar2
57 ,p_sort_option_3 varchar2
58 ,p_dimension varchar2);
59 end PAY_US_TRR_ENGINE_PKG;