1 PACKAGE CAC_HR_CAL_EVENTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cachrevts.pls 120.1 2005/07/02 02:17:58 appldev noship $ */
3
4
5 /*******************************************************************************
6 ** Record type that holds the Calendar Event Information
7 *******************************************************************************/
8 TYPE HR_CAL_EVENT_REC_TYPE IS RECORD
9 ( CAL_EVENT_ID NUMBER
10 , EVENT_NAME VARCHAR2(2000)
11 , EVENT_TYPE VARCHAR2(30)
12 , START_DATE_TIME DATE
13 , END_DATE_TIME DATE
14 );
15
16 /*******************************************************************************
17 ** PL/SQL table TYPE definition for the results of the GET_HR_CAL_EVENTS procedure
18 *******************************************************************************/
19 TYPE HR_CAL_EVENT_TBL_TYPE IS TABLE OF HR_CAL_EVENT_REC_TYPE INDEX BY BINARY_INTEGER;
20
21
22 PROCEDURE GET_HR_CAL_EVENTS
23 /*******************************************************************************
24 ** GET_HR_CAL_EVENTS
25 **
26 ** This API will return calendar events defined in hr events
27 **
28 *******************************************************************************/
29 ( p_Object_Type IN VARCHAR2 -- JTF OBJECTS type of the Object being queried
30 , p_Object_ID IN NUMBER -- JTF OBJECTS select ID of the Object Instance being queried
31 , p_Start_Date IN DATE -- start date of period of interest
32 , p_End_Date IN DATE -- end date of period of interest
33 , p_Event_Type IN VARCHAR2
34 , p_Event_Id IN NUMBER
35 , x_hr_cal_events OUT NOCOPY HR_CAL_EVENT_TBL_TYPE
36 );
37
38
39 END CAC_HR_CAL_EVENTS_PVT;