1 PACKAGE pay_ca_yeer_pkg AUTHID CURRENT_USER AS
2 /* $Header: pycayeer.pkh 120.0.12020000.4 2012/11/06 10:28:03 sgotlasw 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_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 13-SEP-2012 sgotlasw 115.7 13542043 Added tab_cpp_date table type to
41 hold Cpp Election Date, Cpp Revocation Date
42 values.
43 16-SEP-2012 sgotlasw 115.8 6773615 Added 'validateSIN' function to validate
44 SIN of the employee.
45 06-NOV-2012 sgotlasw 115.9 4344652 Added Parms for pier_yeer.
46
47 */
48
49 PROCEDURE pier_yeer
50 (errbuf out nocopy varchar2
51 ,retcode out nocopy number
52 ,p_reporting_year in varchar2
53 ,p_pier_yeer in varchar2
54 ,p_fed_prov in varchar2
55 ,p_fed_prov_dummy in varchar2
56 ,p_is_gre in number
57 ,p_gre in number
58 ,p_is_pre in number
59 ,p_pre in number
60 ,p_b_g_id in number
61 );
62
63
64 /**************************************************************
65 ** PL/SQL table of records to store archived item name and value
66 ** PL/SQL table of records to store messages and required column
67 ** name.
68 ***************************************************************/
69 TYPE rec_dbi IS RECORD ( dbi_name varchar2(240),
70 dbi_value varchar2(240),
71 dbi_short_name varchar2(240),
72 archive_item_id number(15));
73 TYPE tab_mesg IS TABLE OF varchar2(100) INDEX BY BINARY_INTEGER;
74 TYPE tab_col_name IS TABLE OF varchar2(240) INDEX BY BINARY_INTEGER;
75 TYPE tab_dbi IS TABLE OF rec_dbi INDEX BY BINARY_INTEGER;
76 /* Bug 13542043 */
77 TYPE rec_cpp_date IS RECORD ( cpp_election_date date,
78 cpp_revocation_date date);
79 TYPE tab_cpp_date IS TABLE OF rec_cpp_date INDEX BY BINARY_INTEGER;
80
81 FUNCTION validateSIN( national_identifier in varchar2 ) RETURN BOOLEAN ;
82
83 end pay_ca_yeer_pkg;