[Home] [Help]
PACKAGE: APPS.JTF_TASK_TEMPLATES_PUB
Source
1 PACKAGE jtf_task_templates_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfptkms.pls 120.1 2005/07/02 00:59:35 appldev ship $ */
3 TYPE task_details_rec IS RECORD (
4 task_id NUMBER,
5 task_number NUMBER,
6 task_name VARCHAR2(30)
7 );
8
9 TYPE task_depends_rec IS RECORD (
10 dependent_on_task_id NUMBER := NULL,
11 dependent_on_task_number NUMBER := NULL,
12 dependency_type_code VARCHAR2(30),
13 adjustment_time NUMBER := NULL,
14 adjustment_time_uom VARCHAR2(3) := NULL,
15 validated_flag VARCHAR2(1) := NULL
16 );
17
18 TYPE task_depends_tbl IS TABLE OF task_depends_rec
19 INDEX BY BINARY_INTEGER;
20
21 g_miss_task_depends_tbl task_depends_tbl;
22
23 TYPE task_rsrc_req_rec IS RECORD (
24 resource_subtype_id NUMBER,
25 required_units NUMBER,
26 enabled_flag VARCHAR2(1) := NULL
27 );
28
29 TYPE task_rsrc_req_tbl IS TABLE OF task_rsrc_req_rec
30 INDEX BY BINARY_INTEGER;
31
32 g_miss_task_rsrc_req_tbl task_rsrc_req_tbl;
33
34 TYPE task_recur_rec IS RECORD (
35 occurs_which NUMBER := NULL,
36 day_of_week NUMBER := NULL,
37 date_of_month NUMBER := NULL,
38 occurs_month NUMBER := NULL,
39 occurs_uom VARCHAR2(3),
40 occurs_every NUMBER := NULL,
41 occurs_number NUMBER := NULL,
42 start_date_active DATE := NULL,
43 end_date_active DATE := NULL
44 );
45
46 g_miss_task_recur_rec task_recur_rec;
47
48 type task_template_rec is record
49 (
50 ALARM_ON VARCHAR2(1) ,
51 ALARM_COUNT NUMBER,
52 ALARM_INTERVAL NUMBER,
53 ALARM_INTERVAL_UOM VARCHAR2(3) ,
54 DELETED_FLAG VARCHAR2(1) ,
55 ATTRIBUTE1 VARCHAR2(150) ,
56 ATTRIBUTE2 VARCHAR2(150) ,
57 ATTRIBUTE3 VARCHAR2(150) ,
58 ATTRIBUTE4 VARCHAR2(150) ,
59 ATTRIBUTE5 VARCHAR2(150) ,
60 ATTRIBUTE6 VARCHAR2(150) ,
61 ATTRIBUTE7 VARCHAR2(150) ,
62 ATTRIBUTE8 VARCHAR2(150) ,
63 ATTRIBUTE9 VARCHAR2(150) ,
64 ATTRIBUTE10 VARCHAR2(150) ,
65 ATTRIBUTE11 VARCHAR2(150) ,
66 ATTRIBUTE12 VARCHAR2(150) ,
67 ATTRIBUTE13 VARCHAR2(150) ,
68 ATTRIBUTE14 VARCHAR2(150) ,
69 ATTRIBUTE15 VARCHAR2(150) ,
70 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
71 HOLIDAY_FLAG VARCHAR2(1) ,
72 BILLABLE_FLAG VARCHAR2(1) ,
73 RECURRENCE_RULE_ID NUMBER,
74 NOTIFICATION_FLAG VARCHAR2(1) ,
75 NOTIFICATION_PERIOD NUMBER,
76 NOTIFICATION_PERIOD_UOM VARCHAR2(3) ,
77 ALARM_START NUMBER,
78 ALARM_START_UOM VARCHAR2(3) ,
79 PRIVATE_FLAG VARCHAR2(1) ,
80 PUBLISH_FLAG VARCHAR2(1) ,
81 RESTRICT_CLOSURE_FLAG VARCHAR2(1) ,
82 MULTI_BOOKED_FLAG VARCHAR2(240) ,
83 MILESTONE_FLAG VARCHAR2(1) ,
84 TASK_GROUP_ID NUMBER,
85 TASK_NUMBER VARCHAR2(30) ,
89 DURATION NUMBER,
86 TASK_TYPE_ID NUMBER,
87 TASK_STATUS_ID NUMBER,
88 TASK_PRIORITY_ID NUMBER,
90 DURATION_UOM VARCHAR2(3) ,
91 PLANNED_EFFORT NUMBER,
92 PLANNED_EFFORT_UOM VARCHAR2(3) ,
93 TASK_TEMPLATE_ID NUMBER,
94 TASK_NAME VARCHAR2(80) ,
95 DESCRIPTION VARCHAR2(4000) ,
96 OBJECT_VERSION_NUMBER NUMBER,
97 TASK_CONFIRMATION_STATUS VARCHAR2(1)
98 );
99
100 p_task_template_rec task_template_rec ;
101
102 PROCEDURE create_task (
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
105 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
106 p_task_id IN NUMBER DEFAULT NULL,
107 p_task_group_id IN NUMBER DEFAULT NULL,
108 p_task_group_name IN VARCHAR2 DEFAULT NULL,
109 p_task_name IN VARCHAR2,
110 p_task_type_name IN VARCHAR2 DEFAULT NULL,
111 p_task_type_id IN NUMBER DEFAULT NULL,
112 p_description IN VARCHAR2 DEFAULT NULL,
113 p_task_status_name IN VARCHAR2 DEFAULT NULL,
114 p_task_status_id IN NUMBER DEFAULT NULL,
115 p_task_priority_name IN VARCHAR2 DEFAULT NULL,
116 p_task_priority_id IN NUMBER DEFAULT NULL,
117 p_duration IN NUMBER DEFAULT NULL,
118 p_duration_uom IN VARCHAR2 DEFAULT NULL,
119 p_planned_effort IN NUMBER DEFAULT NULL,
120 p_planned_effort_uom IN VARCHAR2 DEFAULT NULL,
121 p_private_flag IN VARCHAR2 DEFAULT NULL,
122 p_publish_flag IN VARCHAR2 DEFAULT NULL,
123 p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL,
124 p_multi_booked_flag IN VARCHAR2 DEFAULT NULL,
125 p_milestone_flag IN VARCHAR2 DEFAULT NULL,
126 p_holiday_flag IN VARCHAR2 DEFAULT NULL,
127 p_billable_flag IN VARCHAR2 DEFAULT NULL,
128 p_notification_flag IN VARCHAR2 DEFAULT NULL,
129 p_notification_period IN NUMBER DEFAULT NULL,
130 p_notification_period_uom IN VARCHAR2 DEFAULT NULL,
131 p_alarm_start IN NUMBER DEFAULT NULL,
132 p_alarm_start_uom IN VARCHAR2 DEFAULT NULL,
133 p_alarm_on IN VARCHAR2 DEFAULT NULL,
134 p_alarm_count IN NUMBER DEFAULT NULL,
135 p_alarm_interval IN NUMBER DEFAULT NULL,
136 p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL,
137 p_task_depends_tbl IN task_depends_tbl
138 DEFAULT g_miss_task_depends_tbl,
139 p_task_rsrc_req_tbl IN task_rsrc_req_tbl
140 DEFAULT g_miss_task_rsrc_req_tbl,
141 p_task_recur_rec IN task_recur_rec
142 DEFAULT g_miss_task_recur_rec,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 x_task_id OUT NOCOPY NUMBER,
147 p_attribute1 IN VARCHAR2 DEFAULT null ,
148 p_attribute2 IN VARCHAR2 DEFAULT null ,
149 p_attribute3 IN VARCHAR2 DEFAULT null ,
150 p_attribute4 IN VARCHAR2 DEFAULT null ,
151 p_attribute5 IN VARCHAR2 DEFAULT null ,
152 p_attribute6 IN VARCHAR2 DEFAULT null ,
153 p_attribute7 IN VARCHAR2 DEFAULT null ,
154 p_attribute8 IN VARCHAR2 DEFAULT null ,
155 p_attribute9 IN VARCHAR2 DEFAULT null ,
156 p_attribute10 IN VARCHAR2 DEFAULT null ,
157 p_attribute11 IN VARCHAR2 DEFAULT null ,
158 p_attribute12 IN VARCHAR2 DEFAULT null ,
159 p_attribute13 IN VARCHAR2 DEFAULT null ,
160 p_attribute14 IN VARCHAR2 DEFAULT null ,
161 p_attribute15 IN VARCHAR2 DEFAULT null ,
162 p_attribute_category IN VARCHAR2 DEFAULT null
163 );
164 -- Overloaded method for Simplex.
165 PROCEDURE create_task (
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
168 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
169 p_task_id IN NUMBER DEFAULT NULL,
170 p_task_group_id IN NUMBER DEFAULT NULL,
171 p_task_group_name IN VARCHAR2 DEFAULT NULL,
172 p_task_name IN VARCHAR2,
173 p_task_type_name IN VARCHAR2 DEFAULT NULL,
174 p_task_type_id IN NUMBER DEFAULT NULL,
175 p_description IN VARCHAR2 DEFAULT NULL,
176 p_task_status_name IN VARCHAR2 DEFAULT NULL,
177 p_task_status_id IN NUMBER DEFAULT NULL,
178 p_task_priority_name IN VARCHAR2 DEFAULT NULL,
179 p_task_priority_id IN NUMBER DEFAULT NULL,
180 p_duration IN NUMBER DEFAULT NULL,
181 p_duration_uom IN VARCHAR2 DEFAULT NULL,
182 p_planned_effort IN NUMBER DEFAULT NULL,
183 p_planned_effort_uom IN VARCHAR2 DEFAULT NULL,
184 p_private_flag IN VARCHAR2 DEFAULT NULL,
185 p_publish_flag IN VARCHAR2 DEFAULT NULL,
186 p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL,
187 p_multi_booked_flag IN VARCHAR2 DEFAULT NULL,
188 p_milestone_flag IN VARCHAR2 DEFAULT NULL,
189 p_holiday_flag IN VARCHAR2 DEFAULT NULL,
190 p_billable_flag IN VARCHAR2 DEFAULT NULL,
191 p_notification_flag IN VARCHAR2 DEFAULT NULL,
192 p_notification_period IN NUMBER DEFAULT NULL,
193 p_notification_period_uom IN VARCHAR2 DEFAULT NULL,
194 p_alarm_start IN NUMBER DEFAULT NULL,
195 p_alarm_start_uom IN VARCHAR2 DEFAULT NULL,
196 p_alarm_on IN VARCHAR2 DEFAULT NULL,
197 p_alarm_count IN NUMBER DEFAULT NULL,
198 p_alarm_interval IN NUMBER DEFAULT NULL,
199 p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL,
200 p_task_depends_tbl IN task_depends_tbl
201 DEFAULT g_miss_task_depends_tbl,
202 p_task_rsrc_req_tbl IN task_rsrc_req_tbl
203 DEFAULT g_miss_task_rsrc_req_tbl,
204 p_task_recur_rec IN task_recur_rec
205 DEFAULT g_miss_task_recur_rec,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 x_task_id OUT NOCOPY NUMBER,
210 p_attribute1 IN VARCHAR2 DEFAULT null ,
211 p_attribute2 IN VARCHAR2 DEFAULT null ,
212 p_attribute3 IN VARCHAR2 DEFAULT null ,
213 p_attribute4 IN VARCHAR2 DEFAULT null ,
214 p_attribute5 IN VARCHAR2 DEFAULT null ,
215 p_attribute6 IN VARCHAR2 DEFAULT null ,
216 p_attribute7 IN VARCHAR2 DEFAULT null ,
217 p_attribute8 IN VARCHAR2 DEFAULT null ,
218 p_attribute9 IN VARCHAR2 DEFAULT null ,
219 p_attribute10 IN VARCHAR2 DEFAULT null ,
220 p_attribute11 IN VARCHAR2 DEFAULT null ,
221 p_attribute12 IN VARCHAR2 DEFAULT null ,
222 p_attribute13 IN VARCHAR2 DEFAULT null ,
223 p_attribute14 IN VARCHAR2 DEFAULT null ,
224 p_attribute15 IN VARCHAR2 DEFAULT null ,
225 p_attribute_category IN VARCHAR2 DEFAULT null ,
226 p_task_confirmation_status IN VARCHAR2
227 );
228
229 PROCEDURE lock_task (
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
232 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
233 p_task_id IN NUMBER,
234 p_object_version_number IN NUMBER,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER
238 ) ;
239
240
241
242
243 PROCEDURE update_task (
244 p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
246 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
247 p_object_version_number IN OUT NOCOPY NUMBER ,
248 p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
249 p_task_number IN VARCHAR2
250 DEFAULT fnd_api.g_miss_char,
251 p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
252 p_task_name IN VARCHAR2
253 DEFAULT fnd_api.g_miss_char,
254 p_task_type_name IN VARCHAR2
255 DEFAULT fnd_api.g_miss_char,
256 p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
257 p_description IN VARCHAR2
258 DEFAULT fnd_api.g_miss_char,
259 p_task_status_name IN VARCHAR2
260 DEFAULT fnd_api.g_miss_char,
261 p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
262 p_task_priority_name IN VARCHAR2
263 DEFAULT fnd_api.g_miss_char,
264 p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
265 p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
266 p_duration_uom IN VARCHAR2
267 DEFAULT fnd_api.g_miss_char,
268 p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
269 p_planned_effort_uom IN VARCHAR2
270 DEFAULT fnd_api.g_miss_char,
271 p_private_flag IN VARCHAR2
272 DEFAULT fnd_api.g_miss_char,
273 p_publish_flag IN VARCHAR2
274 DEFAULT fnd_api.g_miss_char,
275 p_restrict_closure_flag IN VARCHAR2
276 DEFAULT fnd_api.g_miss_char,
277 p_multi_booked_flag IN VARCHAR2
278 DEFAULT fnd_api.g_miss_char,
279 p_milestone_flag IN VARCHAR2
280 DEFAULT fnd_api.g_miss_char,
281 p_holiday_flag IN VARCHAR2
282 DEFAULT fnd_api.g_miss_char,
283 p_billable_flag IN VARCHAR2
284 DEFAULT fnd_api.g_miss_char,
285 p_notification_flag IN VARCHAR2
286 DEFAULT fnd_api.g_miss_char,
287 p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
288 p_notification_period_uom IN VARCHAR2
289 DEFAULT fnd_api.g_miss_char,
290 p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
291 p_alarm_start_uom IN VARCHAR2
292 DEFAULT fnd_api.g_miss_char,
293 p_alarm_on IN VARCHAR2
294 DEFAULT fnd_api.g_miss_char,
295 p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
296 p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
297 p_alarm_interval_uom IN VARCHAR2
298 DEFAULT fnd_api.g_miss_char,
299 x_return_status OUT NOCOPY VARCHAR2,
300 x_msg_count OUT NOCOPY NUMBER,
301 x_msg_data OUT NOCOPY VARCHAR2,
302 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
303 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
304 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
305 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
306 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
307 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
308 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
309 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
310 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
311 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
312 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
313 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
314 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
315 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
316 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
317 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
318 );
319
320 -- Overloaded for Simplex.
321 PROCEDURE update_task (
322 p_api_version IN NUMBER,
323 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
324 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
325 p_object_version_number IN OUT NOCOPY NUMBER ,
326 p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
327 p_task_number IN VARCHAR2
328 DEFAULT fnd_api.g_miss_char,
329 p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
330 p_task_name IN VARCHAR2
331 DEFAULT fnd_api.g_miss_char,
332 p_task_type_name IN VARCHAR2
333 DEFAULT fnd_api.g_miss_char,
334 p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
335 p_description IN VARCHAR2
336 DEFAULT fnd_api.g_miss_char,
337 p_task_status_name IN VARCHAR2
338 DEFAULT fnd_api.g_miss_char,
339 p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
340 p_task_priority_name IN VARCHAR2
341 DEFAULT fnd_api.g_miss_char,
342 p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
343 p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
344 p_duration_uom IN VARCHAR2
345 DEFAULT fnd_api.g_miss_char,
346 p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
347 p_planned_effort_uom IN VARCHAR2
348 DEFAULT fnd_api.g_miss_char,
349 p_private_flag IN VARCHAR2
350 DEFAULT fnd_api.g_miss_char,
351 p_publish_flag IN VARCHAR2
352 DEFAULT fnd_api.g_miss_char,
353 p_restrict_closure_flag IN VARCHAR2
354 DEFAULT fnd_api.g_miss_char,
355 p_multi_booked_flag IN VARCHAR2
356 DEFAULT fnd_api.g_miss_char,
357 p_milestone_flag IN VARCHAR2
358 DEFAULT fnd_api.g_miss_char,
359 p_holiday_flag IN VARCHAR2
360 DEFAULT fnd_api.g_miss_char,
361 p_billable_flag IN VARCHAR2
362 DEFAULT fnd_api.g_miss_char,
363 p_notification_flag IN VARCHAR2
364 DEFAULT fnd_api.g_miss_char,
365 p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
366 p_notification_period_uom IN VARCHAR2
367 DEFAULT fnd_api.g_miss_char,
368 p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
369 p_alarm_start_uom IN VARCHAR2
370 DEFAULT fnd_api.g_miss_char,
371 p_alarm_on IN VARCHAR2
372 DEFAULT fnd_api.g_miss_char,
373 p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
374 p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
375 p_alarm_interval_uom IN VARCHAR2
376 DEFAULT fnd_api.g_miss_char,
377 x_return_status OUT NOCOPY VARCHAR2,
378 x_msg_count OUT NOCOPY NUMBER,
379 x_msg_data OUT NOCOPY VARCHAR2,
380 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
381 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
382 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
383 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
384 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
385 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
386 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
387 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
388 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
389 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
390 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
391 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
392 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
393 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
394 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
395 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
396 p_task_confirmation_status IN VARCHAR2
397 );
398
399 PROCEDURE delete_task (
400 p_api_version IN NUMBER,
401 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
402 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
403 p_object_version_number IN NUMBER ,
404 p_task_id IN NUMBER DEFAULT NULL,
405 p_task_number IN VARCHAR2 DEFAULT NULL,
406 x_return_status OUT NOCOPY VARCHAR2,
407 x_msg_count OUT NOCOPY NUMBER,
408 x_msg_data OUT NOCOPY VARCHAR2
409 );
410 END;