1 PACKAGE PER_CALENDAR_UTIL AS
2 /* $Header: pecalutl.pkh 120.0.12010000.4 2008/11/19 07:24:13 osamvats noship $ */
3
4 -- Returns ICalendar format varchar2.
5 -- To be called when time is available as date object.
6 PROCEDURE CALENDAR_GENERATE_ICAL
7 (DTSTARTDATE IN DATE
8 ,DTENDDATE IN DATE
9 ,DTSTARTTIME IN DATE DEFAULT NULL
10 ,DTENDTIME IN DATE DEFAULT NULL
11 ,SUBJECT IN VARCHAR2 DEFAULT NULL
12 ,LOCATION IN VARCHAR2 DEFAULT NULL
13 ,DESCRIPTION IN VARCHAR2 DEFAULT NULL
14 ,ACCESS IN VARCHAR2 DEFAULT 'PUBLIC'
15 ,TIMEZONE IN VARCHAR2 DEFAULT NULL
16 ,METHOD IN VARCHAR2 DEFAULT 'PUBLISH'
17 ,IGNORE_TIME_ZONE IN BOOLEAN DEFAULT FALSE
18 ,MAIL_TO IN VARCHAR2 DEFAULT NULL
19 ,ICAL OUT NOCOPY VARCHAR2
20 ,PRIMARY_KEY IN VARCHAR2 DEFAULT NULL
21 );
22
23 -- Returns ICalendar format varchar2.
24 -- To be called when time is available as varchar2
25 PROCEDURE CALENDAR_GENERATE_ICAL
26 (DTSTARTDATE IN DATE
27 ,DTENDDATE IN DATE
28 ,DTSTARTTIME IN VARCHAR2
29 ,DTENDTIME IN VARCHAR2
30 ,DTTIMEFORMAT IN VARCHAR2 DEFAULT NULL
31 ,SUBJECT IN VARCHAR2 DEFAULT NULL
32 ,LOCATION IN VARCHAR2 DEFAULT NULL
33 ,DESCRIPTION IN VARCHAR2 DEFAULT NULL
34 ,ACCESS IN VARCHAR2 DEFAULT 'PUBLIC'
35 ,TIMEZONE IN VARCHAR2 DEFAULT NULL
36 ,METHOD IN VARCHAR2 DEFAULT 'PUBLISH'
37 ,IGNORE_TIME_ZONE IN BOOLEAN DEFAULT FALSE
38 ,MAIL_TO IN VARCHAR2 DEFAULT NULL
39 ,ICAL OUT NOCOPY VARCHAR2
40 ,PRIMARY_KEY IN VARCHAR2 DEFAULT NULL
41 );
42
43
44
45 END PER_CALENDAR_UTIL;