[Home] [Help]
PACKAGE: APPS.TRR_ENGINE_PKG
Source
1 package TRR_ENGINE_PKG AUTHID CURRENT_USER as
2 /*$Header: pytrreng.pkh 115.3 2002/06/14 10:15:47 pkm ship $*/
3 /*===========================================================================*
4 | Copyright (c) 1997 Oracle Corporation |
5 | All rights reserved. |
6 *============================================================================*/
7 -- DESCRIPTION
8 -- This script creates the federal tax remittance report SRS definitions
9 --
10 -------------------------------------------------------------------------------
11 -- Change History
12 --
13 -- Vers Date Author Reason
14 -- 10.0 11/05/98 tbattoo Created.
15 -- 110.2 01/05/99 ahanda Changed the datatype for p_state parameter
16 -- from NUMBER to VARCHAR2.
17 --
18 -------------------------------------------------------------------------------
19 --
20 type gre_info is record
21 (
22 gre_size number,
23 gre_id number,
24 gre_name varchar2(60)
25 );
26
27 type gre_info_list is table of gre_info index by binary_integer;
28
29 procedure federal_trr(errbuf OUT VARCHAR2,
30 retcode OUT NUMBER,
31 p_business_group number,
32 p_start_date varchar2,
33 p_end_date varchar2,
34 p_gre number,
35 p_federal varchar2,
36 p_state varchar2,
37 p_dimension varchar2);
38 procedure state_trr;
39 --
40 procedure local_trr(errbuf out varchar2
41 ,retcode out number
42 ,p_business_group number
43 ,p_start_date varchar2
44 ,p_end_date varchar2
45 ,p_gre number
46 ,p_state varchar2
47 ,p_locality_type varchar2
48 ,p_is_city varchar2
49 ,p_city varchar2
50 ,p_is_county varchar2
51 ,p_county varchar2
52 ,p_is_school varchar2
53 ,p_school varchar2
54 ,p_sort_option_1 varchar2
55 ,p_sort_option_2 varchar2
56 ,p_sort_option_3 varchar2
57 ,p_dimension varchar2);
58 end TRR_ENGINE_PKG;