[Home] [Help]
PACKAGE: APPS.SSPWSENT_PKG
Source
1 PACKAGE SSPWSENT_PKG 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;