DBA Data[Home] [Help]

PACKAGE: APPS.PAY_IE_P35_XML_PKG

Source


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;