PACKAGE: APPS.PAY_IE_EOY_INCOMELEVY_REPORT

Source

1 package pay_ie_eoy_incomelevy_report AUTHID CURRENT_USER as
2 /* $Header: pyieeoyc.pkh 120.0.12010000.1 2009/10/01 09:38:24 knadhan noship $ */
3 
4 TYPE XMLRec IS RECORD(
5 xmlstring VARCHAR2(32000));
6 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
7 vXMLTable tXMLTable;
8 
9 	procedure get_eoy_income_details( cp_start_date in date,
10 					  cp_effective_date in date,
11 					  cp_end_date in date,
12 					  p_business_group_id in number,
13 					  p_assignment_set_id in number,
14 					  p_payroll_id in number,
15 					  p_consolidation_set_id in number,
16 				  p_sort_order in varchar2);
17 
18 	procedure populate_eoy_income_details(P_START_DATE IN VARCHAR2 DEFAULT NULL
19 				      ,CP_EFFECTIVE_DATE IN VARCHAR2 DEFAULT NULL
20 				      ,P_END_DATE IN VARCHAR2 DEFAULT NULL
21 				      ,P_BUSINESS_GROUP_ID IN VARCHAR2 DEFAULT NULL
22 				      ,P_ASSIGNMENT_SET_ID IN VARCHAR2 DEFAULT NULL
23 				      ,P_PAYROLL_ID IN VARCHAR2 DEFAULT NULL
24 				      ,P_CONSOLIDATION_SET_ID IN VARCHAR2 DEFAULT NULL
25 				      ,P_SORT_ORDER IN VARCHAR2 DEFAULT NULL
26 				      ,P_TEMPLATE_NAME IN VARCHAR2
27 				      ,P_XML OUT NOCOPY CLOB
28 				      ) ;
29 
30 	PROCEDURE WritetoCLOB (p_xml out nocopy clob);
31 
32 
33 
34 
35 end pay_ie_eoy_incomelevy_report;