1 PACKAGE PAY_DK_SICKNESS_DP202 AUTHID CURRENT_USER AS
2 /* $Header: pydkdp202.pkh 120.2 2006/03/06 22:24:58 pgopal noship $ */
3 TYPE xml_rec_type IS RECORD
4 ( tagname VARCHAR2(32000)
5 ,tagvalue VARCHAR2(32000)
6 );
7
8 -- Table Type for XML Table
9 TYPE xml_tab_type IS TABLE OF xml_rec_type INDEX BY BINARY_INTEGER;
10
11 -- Global declaration of XML Table
12 xml_tab xml_tab_type; ------Pl/Sql Table for storing Xml Data
13
14
15 /*Procedure to get the last pay for an assignment*/
16 PROCEDURE LAST_PAY
17 (p_business_group_id IN NUMBER
18 ,p_assignment_id IN NUMBER
19 ,p_effective_date IN DATE
20 ,p_pay OUT NOCOPY VARCHAR2
21 ,p_period_type OUT NOCOPY VARCHAR2
22 );
23
24 /*Function to get the defined balance id */
25 FUNCTION GET_DEFINED_BALANCE_ID
26 (p_balance_name IN VARCHAR2
27 ,p_dbi_suffix IN VARCHAR2
28 ,p_business_group_id IN NUMBER )
29 RETURN NUMBER;
30
31 /*Procudure to get the sick leave details for reporting*/
32 /*Bug 5059274 fix- Added p_start_date and p_end_Date parameters*/
33 PROCEDURE POPULATE_DETAILS
34 (p_template_name in VARCHAR2
35 ,p_assignment_id NUMBER
36 ,p_person_id NUMBER
37 ,p_start_date IN VARCHAR2
38 ,p_end_date IN VARCHAR2
39 ,p_le_phone_number IN VARCHAR2
40 ,p_le_email_addr IN varchar2
41 ,p_business_group_id NUMBER
42 , p_xml OUT NOCOPY CLOB );
43
44 procedure WRITE_TO_CLOB (p_xml OUT NOCOPY clob);
45 END PAY_DK_SICKNESS_DP202;