1 PACKAGE CAC_VIEW_UTIL_PVT AUTHID CURRENT_USER as
2 /* $Header: cacpvuts.pls 120.6 2006/01/10 00:02:30 deeprao noship $ */
3 /*#
4 * This package is a private utility for Calendar views.
5 * @rep:scope private
6 * @rep:product CAC
7 * @rep:lifecycle active
8 * @rep:displayname Private Calendar View Util
9 * @rep:compatibility N
10 * @rep:category BUSINESS_ENTITY CAC_APPOINTMENT
11 */
12
13 /**
14 * This procedure creates collaboration details record
15 * for target task_id by copying the data from source task_id
16 * @param p_source_task_id source task id
17 * @param p_target_task_id target task id
18 * @rep:displayname Create Repeating Collaboration Details
19 * @rep:lifecycle active
20 * @rep:compatibility N
21 */
22 PROCEDURE create_repeat_collab_details (
23 p_source_task_id IN NUMBER,
24 p_target_task_id IN NUMBER
25 );
26
27 /**
28 * This procedure updates collaboration details record
29 * for target task_id by copying the data from source task_id
30 * @param p_source_task_id source task id
31 * @param p_target_task_id target task id
32 * @rep:displayname Update Repeating Collaboration Details
33 * @rep:lifecycle active
34 * @rep:compatibility N
35 */
36 PROCEDURE update_repeat_collab_details(
37 p_source_task_id IN NUMBER,
38 p_target_task_id IN NUMBER
39 );
40
41 /**
42 * This procedure is used to convert a given time from a source timezone to a destination timezone.
43 * @param p_source_tz_id a source timezone id
44 * @param p_dest_tz_id a destination timezone id
45 * @rep:displayname Adjust For Timezone
46 * @rep:lifecycle active
47 * @rep:compatibility N
48 */
49 PROCEDURE AdjustForTimezone
50 ( p_source_tz_id IN NUMBER
51 , p_dest_tz_id IN NUMBER
52 , p_source_day_time IN DATE
53 , x_dest_day_time OUT NOCOPY DATE
54 );
55
56 /**
57 * This function is used to get reminder description.
58 * @param p_reminder a reminder
59 * @return a reminder description
60 * @rep:displayname Get Reminder Description
61 * @rep:lifecycle active
62 * @rep:compatibility N
63 */
64 FUNCTION GET_REMINDER_DESCRIPTION (p_reminder IN NUMBER) RETURN VARCHAR2;
65
66 /**
67 * This procedure is used to convert a repeating rule from source timezone to destination timezone.
68 * @param p_source_tz_id a source timezone id
69 * @param p_dest_tz_id a destination timezone id
70 * @param p_base_start_datetime base start date/time
71 * @param p_base_end_datetime base end date/time
72 * @param p_start_date_active repeating start date
73 * @param p_end_date_active repeating end date
74 * @param p_occurs_which relative position occuring in a week
75 * @param p_date_of_month date of the month
76 * @param p_occurs_month occuring month
77 * @param p_sunday sunday
78 * @param p_monday monday
79 * @param p_tuesday tuesday
80 * @param p_wednesday wednesday
81 * @param p_thursday thursday
82 * @param p_friday friday
83 * @param p_saturday saturday
84 * @param x_start_date_active repeating start date
85 * @param x_end_date_active repeating end date
86 * @param x_occurs_which relative position occuring in a week
87 * @param x_date_of_month date of the month
88 * @param x_occurs_month occuring month
89 * @param x_sunday sunday
90 * @param x_monday monday
91 * @param x_tuesday tuesday
92 * @param x_wednesday wednesday
93 * @param x_thursday thursday
94 * @param x_friday friday
95 * @param x_saturday saturday
96 * @rep:displayname Adjust Recurrence Rule For Timezone
97 * @rep:lifecycle active
98 * @rep:compatibility N
99 */
100 PROCEDURE ADJUST_RECUR_RULE_FOR_TIMEZONE
101 (p_source_tz_id IN NUMBER
102 ,p_dest_tz_id IN NUMBER
103 ,p_base_start_datetime IN DATE
104 ,p_base_end_datetime IN DATE
105 ,p_start_date_active IN DATE
106 ,p_end_date_active IN DATE
107 ,p_occurs_which IN NUMBER
108 ,p_date_of_month IN NUMBER
109 ,p_occurs_month IN NUMBER
110 ,p_sunday IN VARCHAR2
111 ,p_monday IN VARCHAR2
112 ,p_tuesday IN VARCHAR2
113 ,p_wednesday IN VARCHAR2
114 ,p_thursday IN VARCHAR2
115 ,p_friday IN VARCHAR2
116 ,p_saturday IN VARCHAR2
117 ,x_start_date_active OUT NOCOPY DATE
118 ,x_end_date_active OUT NOCOPY DATE
119 ,x_occurs_which OUT NOCOPY NUMBER
120 ,x_date_of_month OUT NOCOPY NUMBER
121 ,x_occurs_month OUT NOCOPY NUMBER
122 ,x_sunday OUT NOCOPY VARCHAR2
123 ,x_monday OUT NOCOPY VARCHAR2
124 ,x_tuesday OUT NOCOPY VARCHAR2
125 ,x_wednesday OUT NOCOPY VARCHAR2
126 ,x_thursday OUT NOCOPY VARCHAR2
127 ,x_friday OUT NOCOPY VARCHAR2
128 ,x_saturday OUT NOCOPY VARCHAR2
129 );
130
131 /**
132 * This function is used to get duration description.
133 * @param p_duration a duration
134 * @return a duration description
135 * @rep:displayname Get Duration Description
136 * @rep:lifecycle active
137 * @rep:compatibility N
138 */
139 FUNCTION GET_DURATION_DESCRIPTION (p_duration IN NUMBER) RETURN VARCHAR2;
140
141
142 END CAC_VIEW_UTIL_PVT;