1 PACKAGE JTF_CAL_PVT AS
2 /* $Header: jtfvhcs.pls 120.2 2005/12/20 05:07:08 sankgupt ship $ */
3
4 /*******************************************************************************
5 ** Record type that holds all the information needed to display a Calendar list
6 *******************************************************************************/
7 TYPE CalLstRec IS RECORD
8 ( ResourceID NUMBER -- JTF_RESOURCE resource ID of the logged on user
9 , ResourceType VARCHAR2(30) -- JTF_RESOURCE resource type of the logged on user (save in the cookie)
10 , CalendarName VARCHAR2(360)-- Calendar display name
11 , AccessLevel VARCHAR2(80) -- Access level for the calendar
12 );
13
14 /*******************************************************************************
15 ** PL/SQL table TYPE definition for the results of the GetCalendarList procedure
16 *******************************************************************************/
17 TYPE CalLstTblType IS TABLE OF CalLstRec INDEX BY BINARY_INTEGER;
18
19 /*******************************************************************************
20 ** Record type that holds Start time and End Time for a day
21 *******************************************************************************/
22 TYPE WeekTimePrefRec IS RECORD
23 ( DayStart NUMBER := null -- Start Hours of day 0-24
24 , DayEnd NUMBER := null -- End Hours of day 0-24
25 );
26
27 /*******************************************************************************
28 ** PL/SQL table that holds Start time and End Time of week days
29 *******************************************************************************/
30 TYPE WeekTimePrefTblType IS TABLE OF WeekTimePrefRec INDEX BY BINARY_INTEGER;
31
32 /*******************************************************************************
33 ** Record type that holds all the Calendar Preferences
34 *******************************************************************************/
35 TYPE Preference IS RECORD
36 ( LoggedOnRSID NUMBER -- JTF_RESOURCE resource ID of the logged on user (save in the cookie)
37 , LoggedOnRSType VARCHAR2(30) -- JTF_RESOURCE resource type of the logged on user (save in the cookie)
38 , LoggedOnRSName VARCHAR2(360) -- JTF_RESOURCE resource name of the logged on user
39 , SendEmail VARCHAR2(3) -- 'YES' or 'NO' -- Talk to Sarvi change it to 1/0
40 , TimeFormat VARCHAR2(30) -- fnd_lookup.code
41 , DateFormat VARCHAR2(30) -- fnd_lookup.code
42 , TimeZone NUMBER -- HZ_TIMEZONES.TIMEZONE_ID
43 , WeekStart NUMBER -- fnd_lookup.code
44 , WeekEnd NUMBER -- fnd_lookup.code
45 , ApptIncrement NUMBER -- fnd_lookup.code in minutes
46 , MinStartTime DATE -- MIN(selected(StartDates), Preference(StartDate))
47 , MaxEndTime DATE -- MAX(selected(StartDates), Preference(StartDate))
48 , CurrentTime DATE -- SYSDATE + GMT OFFSET
49 , DisplayItems VARCHAR2(3) -- 'YES' or 'NO'
50 , ApptColor VARCHAR2(7) -- #003333 etc.
51 , ApptPrefix VARCHAR2(50) -- free input field
52 , TaskColor VARCHAR2(7)
53 , TaskPrefix VARCHAR2(50)
54 , ItemColor VARCHAR2(7)
55 , ItemPrefix VARCHAR2(50)
56 , TaskCustomerSource VARCHAR2(3)
57 );
58
59
60 TYPE QueryIn IS RECORD
61 /*******************************************************************************
62 ** Record type that holds all the input iformation needed for the
63 ** Calendar daily/weekly/monthly view
64 *******************************************************************************/
65 ( UserID NUMBER -- FND_USER.USER_ID of the logged on user
66 , LoggedOnRSID NUMBER -- JTF_RESOURCE resource ID of the logged on user
67 , LoggedOnRSType VARCHAR2(30) -- JTF_RESOURCE resource type of the logged on user
68 , QueryRSID NUMBER -- JTF_RESOURCE resource ID of the queried user
69 , QueryRSType VARCHAR2(30) -- JTF_RESOURCE resource Type of the queried user
70 , StartDate DATE -- User StartDate of days to query: NULL means user's today/this week/this month
71 , QueryMode NUMBER -- 1=daily, 2=weekly, 3=monthly
72 );
73
74 TYPE QueryOut IS RECORD
75 /*******************************************************************************
76 ** Record type that holds all the output iformation needed for the Calendar
77 ** daily/weekly/monthly view
78 *******************************************************************************/
79 ( ItemDisplayType NUMBER -- 1=Calendar 2=task 3=memo 4=Calendar and task
80 , ItemSourceID NUMBER -- TASK_ID for task and appt
81 , ItemSourceCode VARCHAR2(30) -- For backward comptblty with Tasks Bins
82 , SourceObjectTypeCode VARCHAR(60) -- source_object_type_code
83 , SourceId NUMBER -- source_id
84 , CustomerId NUMBER -- party_id
85 , ItemName VARCHAR2(130) -- Display name of the item (prefix will be concatenated)
86 , AccessLevel NUMBER -- 0='anonymous block', 1='full access', 2='read access'
87 , Color VARCHAR2(8) -- Color for the hyperlink
88 , InviteIndicator NUMBER -- 1 for invite 0 for the rest
89 , RepeatIndicator NUMBER -- 1 for repeating appointments 0 for the rest
90 , StartDate DATE -- Start date for the item
91 , EndDate DATE -- End date for the item
92 , URL VARCHAR2(2000) -- jsp filename
93 , URLParamList VARCHAR(2000)
94 , PriorityID NUMBER -- Priority ID only populated if shown on todo
95 , PriorityName VARCHAR2(30) -- Priority Name only populated if shown on todo
96 , CategoryID NUMBER -- Category ID only populated if shown on todo
97 , CategoryDesc VARCHAR2(240) -- Category Desc only populated if shown on todo
98 , NoteFlag VARCHAR2(1) -- Note indicator only populated if shown on todo
99 , TaskOVN NUMBER -- Object Version Number of task only populated if shown on todo
100 , AssignmentOVN NUMBER -- Object Version Number of assignment only populated if shown on todo
101 , GroupRSID NUMBER -- Resource ID of the group who owns the task
102 );
103
104 /*******************************************************************************
105 ** PL/SQL table TYPE definition for the results of the GetView procedure
106 *******************************************************************************/
107 TYPE QueryOutTab IS TABLE OF QueryOut INDEX BY BINARY_INTEGER;
108
109 PROCEDURE GetCalendarList
110 /*******************************************************************************
111 ** Given a ResourceID, this procedure will return a list of Calendars that the
112 ** Calendar user has access to
113 *******************************************************************************/
114 ( p_api_version IN NUMBER
115 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
116 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
117 , x_return_status OUT NOCOPY VARCHAR2
118 , x_msg_count OUT NOCOPY NUMBER
119 , x_msg_data OUT NOCOPY VARCHAR2
120 , p_resourceID IN OUT NOCOPY NUMBER
121 , p_resourceType IN OUT NOCOPY VARCHAR2
122 , p_userID IN NUMBER
123 , x_calendarList OUT NOCOPY CalLstTblType
124 );
125
126 PROCEDURE GetView
127 /*******************************************************************************
128 ** This procedure will return all task information needed to display the daily
129 ** Calendar page
130 *******************************************************************************/
131 ( p_api_version IN NUMBER
132 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
133 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
134 , x_return_status OUT NOCOPY VARCHAR2
135 , x_msg_count OUT NOCOPY NUMBER
136 , x_msg_data OUT NOCOPY VARCHAR2
137 , p_input IN JTF_CAL_PVT.QueryIn
138 , x_DisplayItems OUT NOCOPY JTF_CAL_PVT.QueryOutTab
139 , x_Preferences OUT NOCOPY JTF_CAL_PVT.Preference
140 );
141
142 END JTF_CAL_PVT;