1 package pay_us_pr_w2 as
2 /* $Header: pyusprw2.pkh 120.0.12010000.1 2008/07/27 23:55:44 appldev ship $*/
3
4 /*
5 +=====================================================================+
6 | Copyright (c) 1997 Orcale Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +=====================================================================+
10 Name : pay_us_pr_w2
11 Description : This package is called by the Puerto Rico W2 Totals and
12 Exceptions Report
13 History : 23-AUG-2002
14 Change List
15 -----------
16 Date Name Vers Bug No Description
17 ----------- ---------- ----- ------- -----------------------------------
18 27-AUG-2002 fusman 115.0 Created.
19 07-AUG-2003 jgoswami 115.1 added p_report_type,Nocopy changes.
20 25-AUG-2003 jgoswami 115.2 2778370 added defination for pl/sql table
21 of records to store label and value
22 03-sep-2003 jgoswami 115.3 3097463 added r_type to record to store data type.
23 --
24
25 */
26
27
28 PROCEDURE insert_pr_w2_totals(errbuf OUT nocopy VARCHAR2,
29 retcode OUT nocopy NUMBER,
30 p_seq_num IN VARCHAR2,
31 p_report_type IN VARCHAR2) ;
32
33 /**************************************************************
34 ** PL/SQL table of records to store Label name and Value
35 ***************************************************************/
36
37 TYPE rec_total IS RECORD (r_label varchar2(240),
38 r_value varchar2(240),
39 r_type varchar2(240));
40 TYPE tab_rec_total IS TABLE OF rec_total INDEX BY BINARY_INTEGER;
41
42 end pay_us_pr_w2;