PACKAGE: APPS.PAY_IE_P60XML

Source

1 package pay_ie_p60xml AUTHID CURRENT_USER as
2 /* $Header: pyiep60p.pkh 120.0.12010000.1 2008/07/27 22:50:44 appldev ship $ */
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_p60_details(p_53_indicator in varchar2,
10 					  cp_start_date in date,
11 					  cp_effective_date in date,
12 					  cp_end_date in date,
13 					  p_business_group_id in number,
14 					  p_assignment_set_id in number,
15 					  p_payroll_id in number,
16 					  p_consolidation_set_id in number,
17 				  p_sort_order in varchar2);
18 
19 	procedure populate_p60_details(P_53_INDICATOR IN VARCHAR2 DEFAULT NULL
20 				      ,P_START_DATE IN VARCHAR2 DEFAULT NULL
21 				      ,CP_EFFECTIVE_DATE IN VARCHAR2 DEFAULT NULL
22 				      ,P_END_DATE IN VARCHAR2 DEFAULT NULL
23 				      ,P_BUSINESS_GROUP_ID IN VARCHAR2 DEFAULT NULL
24 				      ,P_ASSIGNMENT_SET_ID IN VARCHAR2 DEFAULT NULL
25 				      ,P_PAYROLL_ID IN VARCHAR2 DEFAULT NULL
26 				      ,P_CONSOLIDATION_SET_ID IN VARCHAR2 DEFAULT NULL
27 				      ,P_SORT_ORDER IN VARCHAR2 DEFAULT NULL
28 				      ,P_TEMPLATE_NAME IN VARCHAR2
29 				      ,P_XML OUT NOCOPY CLOB
30 				      ) ;
31 
32 	PROCEDURE WritetoCLOB (p_xml out nocopy clob);
33 
34 	Procedure  clob_to_blob(p_clob clob
35 			,p_blob IN OUT NOCOPY blob);
36 
37 	Procedure fetch_rtf_blob (p_template_id number
38 			 ,p_rtf_blob OUT NOCOPY blob);
39 end pay_ie_p60xml;