1 PACKAGE pay_ca_yeer_pkg AS
2 /* $Header: pycayeer.pkh 120.0.12000000.1 2007/01/17 17:44:36 appldev noship $ */
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_ca_yeer_pkg
22
23 Description : Package for the Elements Reports. The package
24 generated the output file in the specified user
25 format. The current formats supported are
26 - HTML
27 - CSV
28
29 Change List
30 -----------
31 Date Name Vers Bug No Description
32 ---- ---- ------ ------- -----------
33 28-NOV-2000 vpandya 115.0 Created
34 10-NOV-2001 vpandya 115.1 Added set veify off at top as per
35 GSCC
36 12-NOV-2001 vpandya 115.2 Added dbdrv line.
37 10-AUG-2002 vpandya 115.4 Added OSERROR command at top.
38 19-DEC-2002 vpandya 115.5 Added nocopy with out parameter.
39 13-NOV-2003 ssouresr 115.6 Passing p_pre instead of p_qin
40
41 */
42
43 PROCEDURE pier_yeer
44 (errbuf out nocopy varchar2
45 ,retcode out nocopy number
46 ,p_reporting_year in varchar2
47 ,p_pier_yeer in varchar2
48 ,p_fed_prov in varchar2
49 ,p_gre in number
50 ,p_pre in number
51 ,p_b_g_id in number
52 );
53
54
55 /**************************************************************
56 ** PL/SQL table of records to store archived item name and value
57 ** PL/SQL table of records to store messages and required column
58 ** name.
59 ***************************************************************/
60 TYPE rec_dbi IS RECORD ( dbi_name varchar2(240),
61 dbi_value varchar2(240),
62 dbi_short_name varchar2(240),
63 archive_item_id number(15));
64 TYPE tab_mesg IS TABLE OF varchar2(100) INDEX BY BINARY_INTEGER;
65 TYPE tab_col_name IS TABLE OF varchar2(240) INDEX BY BINARY_INTEGER;
66 TYPE tab_dbi IS TABLE OF rec_dbi INDEX BY BINARY_INTEGER;
67
68 end pay_ca_yeer_pkg;