1 PACKAGE PAY_NL_ABP_REPORT AUTHID CURRENT_USER as
2 /* $Header: pynlabprep.pkh 120.0.12020000.2 2012/08/10 13:27:26 asudhaka noship $ */
3
4 /*Record for storing XML tag and its value*/
5 TYPE XMLRec IS RECORD (TagName VARCHAR2(1000)
6 ,TagValue VARCHAR2(4000));
7
8 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
9
10 xXMLTable tXMLTable;
11
12 TYPE ERTotal IS RECORD (pension_base NUMBER DEFAULT 0
13 ,contr_base NUMBER DEFAULT 0
14 ,contr_amt NUMBER DEFAULT 0
15 ,flag NUMBER DEFAULT 0);
16
17 TYPE tERTotal IS TABLE OF ERTotal INDEX BY BINARY_INTEGER;
18
19 g_er_amount tERTotal;
20 g_tot_amount tERTotal;
21
22 TYPE pension_type IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
23 tPension pension_type;
24
25 PROCEDURE generate(p_action_context_id NUMBER
26 ,p_abp_output_type VARCHAR2
27 ,p_template_name VARCHAR2
28 ,p_xml OUT NOCOPY CLOB);
29 END PAY_NL_ABP_REPORT;
30