1 PACKAGE PAY_NL_WTS_REPORT AS
2 /* $Header: paynlwts.pkh 120.0.12000000.2 2007/08/23 05:07:58 abhgangu noship $ */
3
4 /*-------------------------------------------------------------------------------------
5 Function to get the last assignment_action_id for each person and payroll
6 --------------------------------------------------------------------------------------*/
7 FUNCTION GET_LAST_ASG_ACT_ID(l_person_id IN NUMBER,l_payroll_id IN NUMBER,l_date_earned IN DATE)
8 RETURN NUMBER;
9
10 /*-------------------------------------------------------------------------------------
11 Function to get the org_struct_version_id.
12 --------------------------------------------------------------------------------------*/
13 FUNCTION Get_org_struct_version_id(p_org_struct_id IN NUMBER,p_month_to IN VARCHAR2)
14 RETURN NUMBER;
15
16 /*-------------------------------------------------------------------------------------
17 Function to get the Element_Type_id.
18 --------------------------------------------------------------------------------------*/
19 FUNCTION Get_Element_Type_Id(p_element_name IN VARCHAR2)
20 RETURN NUMBER;
21
22 /*-------------------------------------------------------------------------------------
23 Function to get the Input_Value_id.
24 --------------------------------------------------------------------------------------*/
25 FUNCTION Get_Input_Value_Id(p_input_value varchar2,p_element_type_id NUMBER)
26 RETURN NUMBER;
27
28 /*-------------------------------------------------------------------------------------
29 Function to get the Defined_Balance_Id
30 --------------------------------------------------------------------------------------*/
31 FUNCTION Get_Defined_Balance_Id(p_balance_name IN VARCHAR2)
32 RETURN NUMBER;
33
34 /*-------------------------------------------------------------------------------------
35 Function to get the Subsidy Type
36 --------------------------------------------------------------------------------------*/
37 FUNCTION GET_SUBSIDY_TYPE_NAME(p_Subsidy_Element_Type_ID IN NUMBER)
38 RETURN VARCHAR2;
39
40 /*-------------------------------------------------------------------------------------
41 Function to get the Retro Wage Tax Subsidy Amount
42 --------------------------------------------------------------------------------------*/
43 FUNCTION get_retro_wts (p_asg_act_id IN NUMBER
44 ,p_element_type_id IN NUMBER
45 ,p_retro_date IN DATE)
46 RETURN NUMBER;
47
48 /*-------------------------------------------------------------------------------------
49 Procedure to generate XML data for WTS Report
50 --------------------------------------------------------------------------------------*/
51 PROCEDURE populate_wts_report_data(p_bg_id IN NUMBER,
52 p_eff_date IN VARCHAR2,
53 p_month_from IN VARCHAR2,
54 p_month_to IN VARCHAR2,
55 p_org_struct_id IN NUMBER,
56 p_org_struct IN VARCHAR2,
57 p_top_org_id IN NUMBER,
58 p_top_org IN VARCHAR2,
59 p_person_id IN NUMBER,
60 p_employee IN VARCHAR2,
61 p_inc_sub_emp IN VARCHAR2,
62 p_xfdf_blob OUT NOCOPY BLOB);
63
64 PROCEDURE record_4712(p_file_id NUMBER);
65
66 /*-------------------------------------------------------------------------------------
67 Procedure to generate XML data for WTS Report using PYXMLEMG
68 --------------------------------------------------------------------------------------*/
69 procedure populate_wts_report_data_1(p_bg_id IN NUMBER,
70 p_eff_date IN VARCHAR2,
71 p_month_from IN VARCHAR2,
72 p_month_to IN VARCHAR2,
73 p_org_struct_id IN NUMBER,
74 p_org_struct IN VARCHAR2,
75 p_top_org_id IN NUMBER,
76 p_top_org IN VARCHAR2,
77 p_person_id IN NUMBER,
78 p_employee IN VARCHAR2,
79 p_inc_sub_emp IN VARCHAR2,
80 p_dummy_employer IN VARCHAR2,
81 p_template_name IN VARCHAR2,
82 p_xml OUT NOCOPY CLOB);
83
84 END PAY_NL_WTS_REPORT;