1 PACKAGE CAC_AVLBLTY_PVT AS
2 /* $Header: caccaps.pls 120.1 2005/07/02 02:17:52 appldev noship $ */
3
4 /*******************************************************************************
5 ** todo list
6 *******************************************************************************/
7 --
8 -- + Add published schedule lookup logic
9 -- + Add overloaded versions for defaulting
10 -- + Add error handling
11 -- + Add time zone support
12 -- + Profile code for performance
13 -- + create java wrappers
14
15 /*******************************************************************************
16 ** Private APIs
17 *******************************************************************************/
18
19 FUNCTION CONVERT_TO_MILLIS
20 /*******************************************************************************
21 ** ConvertToMiliiseconds
22 **
23 ** Will return the period + UOM in day so it can be added to an Oracle DATE.
24 *******************************************************************************/
25 ( p_Duration IN NUMBER
26 , p_UOM IN VARCHAR2
27 )RETURN NUMBER;
28
29
30 FUNCTION ADJUST_FOR_TIMEZONE
31 ( p_source_tz_id IN NUMBER
32 , p_dest_tz_id IN NUMBER
33 , p_source_day_time IN DATE
34 )RETURN DATE;
35
36
37 PROCEDURE GET_SCHEDULE_DATA
38 /*******************************************************************************
39 **
40 ** GET_SCHEDULE_DATA
41 **
42 ** returns the schedule for the given:
43 ** - Object Instance
44 ** - Schedule Type
45 ** - Period
46 **
47 *******************************************************************************/
48 ( p_Object_Type IN VARCHAR2 -- JTF OBJECTS type of the Object being queried
49 , p_Object_ID IN NUMBER -- JTF OBJECTS select ID of the Object Instance being queried
50 , p_Start_Date_Time IN DATE -- start date and time of period of interest
51 , p_End_Date_Time IN DATE -- end date and time of period of interest
52 , p_Schdl_Cat IN VARCHAR2 -- Schedule Category of the schedule instance we'll look at
53 , p_Include_Exception IN VARCHAR2 -- 'T' or 'F' depending on whether the exceptions be included or not
54 , p_Busy_Tentative IN VARCHAR2 -- How to treat periods with FREEBUSYTYPE = BUSY TENTATIVE?
55 -- FREE: BUSY TENTATIVE means FREE
56 -- BUSY: BUSY TENTATIVE means BUSY
57 -- NULL: leave the interpretation to caller
58 , p_return_type IN VARCHAR2 -- 'D': Detailed schedule
59 -- 'S': Schedule Summary
60 -- 'B': Both detailed and summary of schedule
61 , x_Schedule OUT NOCOPY CAC_AVLBLTY_TIME_VARRAY
62 , x_Schedule_Summary OUT NOCOPY CAC_AVLBLTY_SUMMARY_VARRAY
63 -- return schedule
64 );
65
66
67 PROCEDURE POPULATE_SCHEDULE_DETAILS
68 /*******************************************************************************
69 **
70 ** POPULATE_SCHEDULE_DETAILS
71 **
72 ** expands the schedule for the given:
73 ** - Schedule
74 ** - template
75 ** - duration
76 **
77 *******************************************************************************/
78 ( p_Schedule_Id IN NUMBER -- id of the schedule
79 , p_Schdl_Tmpl_Id IN NUMBER
80 , p_Schdl_Tmpl_Length IN NUMBER
81 , p_Schdl_Tmpl_Type IN VARCHAR2
82 , p_Schdl_Start_Date IN DATE
83 , p_Schdl_End_Date IN DATE
84 );
85
86
87 PROCEDURE POPULATE_OBJECT_SCHDL_DETAILS
88 /*******************************************************************************
89 **
90 ** POPULATE_OBJECT_SCHDL_DETAILS
91 **
92 ** expands the schedule for the given:
93 ** - Resource
94 ** - Schedule
95 **
96 *******************************************************************************/
97 ( p_Schedule_Id IN NUMBER -- id of the schedule
98 , p_Schedule_Object_Id IN NUMBER
99 , p_Object_Start_Date IN DATE
100 , p_Object_End_Date IN DATE
101 , p_Start_Template_Detail_Id IN NUMBER
102 );
103
104
105 PROCEDURE POST_CREATE_SCHEDULE
106 /*******************************************************************************
107 **
108 ** POST_CREATE_SCHEDULE
109 **
110 ** expands the schedule for the given:
111 ** - Schedule
112 ** - template
113 ** - duration
114 ** and submits business events
115 **
116 *******************************************************************************/
117 ( p_Schedule_Id IN NUMBER -- id of the schedule
118 , p_Schedule_Category IN VARCHAR2
119 , p_Schdl_Tmpl_Id IN NUMBER
120 , p_Schdl_Tmpl_Length IN NUMBER
121 , p_Schdl_Tmpl_Type IN VARCHAR2
122 , p_Schdl_Start_Date IN DATE
123 , p_Schdl_End_Date IN DATE
124 );
125
126
127 PROCEDURE POST_UPDATE_SCHEDULE
128 /*******************************************************************************
129 **
130 ** POST_UPDATE_SCHEDULE
131 **
132 ** expands the schedule for the given:
133 ** - Schedule
134 ** - template
135 ** - duration
136 ** and submits business events
137 **
138 *******************************************************************************/
139 ( p_Schedule_Id IN NUMBER -- id of the schedule
140 , p_Schedule_Category IN VARCHAR2
141 , p_Schdl_Tmpl_Id IN NUMBER
142 , p_Schdl_Tmpl_Length IN NUMBER
143 , p_Schdl_Tmpl_Type IN VARCHAR2
144 , p_Schdl_Start_Date IN DATE
145 , p_Schdl_End_Date IN DATE
146 );
147
148
149 PROCEDURE POST_DELETE_SCHEDULE
150 /*******************************************************************************
151 **
152 ** POST_DELETE_SCHEDULE
153 **
154 ** submits business events
155 **
156 *******************************************************************************/
157 ( p_Schedule_Id IN NUMBER -- id of the schedule
158 , p_Schedule_Category IN VARCHAR2
159 , p_Schdl_Start_Date IN DATE
160 , p_Schdl_End_Date IN DATE
161 );
162
163
164 END CAC_AVLBLTY_PVT;