1 PACKAGE PAY_NL_ATS_REPORT AUTHID CURRENT_USER AS
2 /* $Header: paynlats.pkh 120.0.12000000.3 2007/08/31 05:28:43 rsahai noship $ */
3
4 TYPE UserBalValRec IS RECORD(
5 BalValue NUMBER,
6 TagName VARCHAR2(1000));
7
8 TYPE tUserBalValTable IS TABLE OF UserBalValRec INDEX BY BINARY_INTEGER;
9 vUserBalVal tUserBalValTable;
10
11 /*Procedure to fetch necessary data for the report.
12 This procedure then calls procedure WritetoCLOB to write the contents of the XML file as a CLOB*/
13
14 /*-------------------------------------------------------------------------------
15 |Name : populate_ats_report_data |
16 |Type : Procedure |
17 |Description : Procedure to generate the Annual Tax Statement Report |
18 ------------------------------------------------------------------------------*/
19
20
21 PROCEDURE populate_ats_report_data(p_person_id IN NUMBER,
22 p_year IN VARCHAR2,
23 p_bg_id IN NUMBER,
24 p_employer_id IN NUMBER,
25 p_agg_flag IN VARCHAR2,
26 p_xfdf_blob OUT NOCOPY BLOB);
27
28 -- new procedure with CLOB as out parameter
29 procedure populate_ats_report_data_new
30 (p_person_id IN NUMBER,
31 p_year IN VARCHAR2,
32 p_bg_id IN NUMBER,
33 p_employer_id IN NUMBER,
34 p_agg_flag IN VARCHAR2,
35 p_aggregate_multi_assign IN VARCHAR2,
36 p_employee_name IN VARCHAR2,
37 p_top_hr_organization_name IN VARCHAR2,
38 p_eff_date IN VARCHAR2,
39 p_template_format IN VARCHAR2,
40 p_template_name IN VARCHAR2,
41 p_xml OUT NOCOPY CLOB);
42
43 PROCEDURE record_4712(p_file_id NUMBER);
44
45 /*-----------------------------------------------------------------------------
46 |Name : populate_UserBalVal |
47 |Type : Procedure |
48 |Description: Procedure which populates pl/sql table with user defined balance |
49 | values and tag names |
50 -------------------------------------------------------------------------------*/
51
52 PROCEDURE populate_UserBalVal(p_User_Bal_String VARCHAR2, p_agg_flag VARCHAR2);
53
54 /*-----------------------------------------------------------------------------
55 |Name : get_Address_Style |
56 |Type : Function |
57 |Description: Function that returns the address style of the address record of |
58 | a person at a given date |
59 -------------------------------------------------------------------------------*/
60
61 FUNCTION get_Address_Style(p_person_id NUMBER, p_effective_date DATE) RETURN VARCHAR2;
62
63 /*-----------------------------------------------------------------------------
64 |Name : get_Post_Code |
65 |Type : Function |
66 |Description: Function that returns the postal code of the address record of |
67 | a person at a given date |
68 -------------------------------------------------------------------------------*/
69
70 FUNCTION get_Post_Code(p_person_id NUMBER, p_effective_date DATE) RETURN VARCHAR2;
71
72
73 END PAY_NL_ATS_REPORT;