1 PACKAGE PAY_DK_SICKNESS_DP201 AUTHID CURRENT_USER AS
2 /* $Header: pydkdp201.pkh 120.3 2006/03/06 22:23:32 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 which returns the last pay (after pre-Paymnents) of 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 /*Re-opened Bug 5059274 fix.*/
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 /*Function to return the working hours per week of an assignment*/
32 FUNCTION WORKING_HOURS_PER_WEEK
33 (p_assignment_id IN NUMBER
34 ,p_leg_emp_id IN NUMBER
35 ,p_effective_date IN DATE )
36 RETURN NUMBER;
37
38 /*Procudure to get the sick leave details for reporting*/
39 /*Bug 5059274 fix- Added p_start_date and p_end_Date parameters*/
40 PROCEDURE POPULATE_DETAILS
41 (p_template_name in VARCHAR2
42 ,p_assignment_id NUMBER DEFAULT NULL
43 ,p_person_id NUMBER
44 ,p_start_date IN VARCHAR2
45 ,p_end_date IN VARCHAR2
46 ,p_le_phone_number IN VARCHAR2
47 ,p_le_email_addr IN varchar2
48 ,p_business_group_id NUMBER
49 , p_xml OUT NOCOPY CLOB );
50
51 PROCEDURE WRITE_TO_CLOB (p_xml OUT NOCOPY CLOB);
52 END PAY_DK_SICKNESS_DP201;