1 PACKAGE PAY_IE_P35_XML_PKG AS
2 /* $Header: pyiep35p.pkh 120.0.12010000.1 2008/07/27 22:50:20 appldev ship $ */
3 TYPE XMLRec IS RECORD(
4 xmlString VARCHAR2(6000)
5 );
6 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
7 vXMLTable tXMLTable;
8 vCtr NUMBER;
9 PROCEDURE WritetoCLOB (p_xfdf_string out nocopy clob);
10 PROCEDURE populate_p35_rep
11 (p_bg_id IN NUMBER
12 ,p_emp_no IN VARCHAR2
13 ,p_payroll IN NUMBER
14 ,p_assignment_set IN NUMBER
15 ,p_end_date IN VARCHAR2
16 ,p_weeks IN VARCHAR2
17 ,p_template_name IN VARCHAR2
18 ,p_xml OUT NOCOPY CLOB
19 );
20 PROCEDURE populate_plsql_table
21 (p_bg_id IN NUMBER
22 ,p_emp_no IN VARCHAR2
23 ,p_payroll IN NUMBER
24 ,p_assignment_set IN NUMBER
25 ,p_end_date IN VARCHAR2
26 ,p_weeks IN VARCHAR2);
27 FUNCTION get_start_date
28 RETURN DATE;
29 FUNCTION get_end_date
30 RETURN DATE;
31 END PAY_IE_P35_XML_PKG;