PACKAGE: APPS.SSPWSENT_PKG

Source

1 PACKAGE SSPWSENT_PKG AUTHID CURRENT_USER as
2 /* $Header: sspwsent.pkh 120.1 2005/06/15 03:20:37 tukumar noship $ */
3 
4  PROCEDURE fetch_maternity_details ( P_MATERNITY_ID in number,
5 				     P_SMP_DUE_DATE out NOCOPY date,
6 				     P_PERSON_ID out NOCOPY number,
7 				     P_MATCHING_DATE out NOCOPY DATE);
8 
9  PROCEDURE fetch_absence_details ( p_absence_id in number,
10 				   p_ABSENCE_CATEGORY out NOCOPY varchar2,
11 				   P_PERSON_ID out NOCOPY number,
12 				   p_SICKNESS_START_DATE out NOCOPY date,
13 				   p_SICKNESS_END_DATE out NOCOPY  date,
14                                    P_MATERNITY_ID out NOCOPY number,
15 				   P_SMP_DUE_DATE out NOCOPY date,
16 				   P_LINKED_ABSENCE_ID out NOCOPY number) ;
17 
18 
19  FUNCTION fetch_element_type (p_effective_date in date,
20 			      p_absence_category varchar2)  return number;
21 
22 
23 END SSPWSENT_PKG;