[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 120.1 2011/11/25 09:47:32 nkjaladi ship $*/
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 REM 115.5 22-NOV-2011 nkjaladi Bug #11926304 Modified procedure local_trr
20 to add new parmaeters p_is_psd and p_psd
21 to support PSD for PA state.
22 */
23 --
24 type gre_info is record
25 (
26 gre_size number,
27 gre_id number,
28 gre_name varchar2(240)
29 );
30
31 type gre_info_list is table of gre_info index by binary_integer;
32
33 procedure federal_trr(errbuf OUT nocopy VARCHAR2,
34 retcode OUT nocopy NUMBER,
35 p_business_group number,
36 p_start_date varchar2,
37 p_end_date varchar2,
38 p_gre number,
39 p_federal varchar2,
40 p_state varchar2,
41 p_dimension varchar2);
42 procedure state_trr;
43 --
44 procedure local_trr(errbuf out nocopy varchar2
45 ,retcode out nocopy number
46 ,p_business_group number
47 ,p_start_date varchar2
48 ,p_end_date varchar2
49 ,p_gre number
50 ,p_state varchar2
51 ,p_locality_type varchar2
52 ,p_is_city varchar2
53 ,p_city varchar2
54 ,p_is_county varchar2
55 ,p_county varchar2
56 ,p_is_school varchar2
57 ,p_school varchar2
58 ,p_is_psd varchar2 --Added for #11926304
59 ,p_psd varchar2 --Added for #11926304
60 ,p_sort_option_1 varchar2
61 ,p_sort_option_2 varchar2
62 ,p_sort_option_3 varchar2
63 ,p_dimension varchar2);
64 end PAY_US_TRR_ENGINE_PKG;