[Home] [Help]
PACKAGE: APPS.JTF_TASK_ASSIGNMENTS_PUB_W
Source
1 package jtf_task_assignments_pub_w AUTHID CURRENT_USER as
2 /* $Header: jtfbtkas.pls 120.3 2006/04/26 04:18 knayyar ship $ */
3 procedure create_task_assignment(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_task_assignment_id NUMBER
7 , p_task_id NUMBER
8 , p_task_number VARCHAR2
9 , p_task_name VARCHAR2
10 , p_resource_type_code VARCHAR2
11 , p_resource_id NUMBER
12 , p_resource_name NUMBER
13 , p_actual_effort NUMBER
14 , p_actual_effort_uom VARCHAR2
15 , p_schedule_flag VARCHAR2
16 , p_alarm_type_code VARCHAR2
17 , p_alarm_contact VARCHAR2
18 , p_sched_travel_distance NUMBER
19 , p_sched_travel_duration NUMBER
20 , p_sched_travel_duration_uom VARCHAR2
21 , p_actual_travel_distance NUMBER
22 , p_actual_travel_duration NUMBER
23 , p_actual_travel_duration_uom VARCHAR2
24 , p_actual_start_date date
25 , p_actual_end_date date
26 , p_palm_flag VARCHAR2
27 , p_wince_flag VARCHAR2
28 , p_laptop_flag VARCHAR2
29 , p_device1_flag VARCHAR2
30 , p_device2_flag VARCHAR2
31 , p_device3_flag VARCHAR2
32 , p_resource_territory_id NUMBER
33 , p_assignment_status_id NUMBER
34 , p_shift_construct_id NUMBER
35 , x_return_status out nocopy VARCHAR2
36 , x_msg_count out nocopy NUMBER
37 , x_msg_data out nocopy VARCHAR2
38 , x_task_assignment_id out nocopy NUMBER
39 , p_attribute1 VARCHAR2
40 , p_attribute2 VARCHAR2
41 , p_attribute3 VARCHAR2
42 , p_attribute4 VARCHAR2
43 , p_attribute5 VARCHAR2
44 , p_attribute6 VARCHAR2
45 , p_attribute7 VARCHAR2
46 , p_attribute8 VARCHAR2
47 , p_attribute9 VARCHAR2
48 , p_attribute10 VARCHAR2
49 , p_attribute11 VARCHAR2
50 , p_attribute12 VARCHAR2
51 , p_attribute13 VARCHAR2
52 , p_attribute14 VARCHAR2
53 , p_attribute15 VARCHAR2
54 , p_attribute_category VARCHAR2
55 , p_show_on_calendar VARCHAR2
56 , p_category_id NUMBER
57 , p_enable_workflow VARCHAR2
58 , p_abort_workflow VARCHAR2
59 , p_object_capacity_id NUMBER
60 , p_free_busy_type VARCHAR2
61 );
62 procedure create_task_assignment(p_api_version NUMBER
63 , p_init_msg_list VARCHAR2
64 , p_commit VARCHAR2
65 , p_task_assignment_id NUMBER
66 , p_task_id NUMBER
67 , p_task_number VARCHAR2
68 , p_task_name VARCHAR2
69 , p_resource_type_code VARCHAR2
70 , p_resource_id NUMBER
71 , p_resource_name NUMBER
72 , p_actual_effort NUMBER
73 , p_actual_effort_uom VARCHAR2
74 , p_schedule_flag VARCHAR2
75 , p_alarm_type_code VARCHAR2
76 , p_alarm_contact VARCHAR2
77 , p_sched_travel_distance NUMBER
78 , p_sched_travel_duration NUMBER
79 , p_sched_travel_duration_uom VARCHAR2
80 , p_actual_travel_distance NUMBER
81 , p_actual_travel_duration NUMBER
82 , p_actual_travel_duration_uom VARCHAR2
83 , p_actual_start_date date
84 , p_actual_end_date date
85 , p_palm_flag VARCHAR2
86 , p_wince_flag VARCHAR2
87 , p_laptop_flag VARCHAR2
88 , p_device1_flag VARCHAR2
89 , p_device2_flag VARCHAR2
90 , p_device3_flag VARCHAR2
91 , p_resource_territory_id NUMBER
92 , p_assignment_status_id NUMBER
93 , p_shift_construct_id NUMBER
94 , x_return_status out nocopy VARCHAR2
95 , x_msg_count out nocopy NUMBER
96 , x_msg_data out nocopy VARCHAR2
97 , x_task_assignment_id out nocopy NUMBER
98 , p_attribute1 VARCHAR2
99 , p_attribute2 VARCHAR2
100 , p_attribute3 VARCHAR2
101 , p_attribute4 VARCHAR2
102 , p_attribute5 VARCHAR2
103 , p_attribute6 VARCHAR2
104 , p_attribute7 VARCHAR2
105 , p_attribute8 VARCHAR2
106 , p_attribute9 VARCHAR2
107 , p_attribute10 VARCHAR2
108 , p_attribute11 VARCHAR2
109 , p_attribute12 VARCHAR2
110 , p_attribute13 VARCHAR2
111 , p_attribute14 VARCHAR2
112 , p_attribute15 VARCHAR2
113 , p_attribute_category VARCHAR2
114 , p_show_on_calendar VARCHAR2
115 , p_category_id NUMBER
116 , p_enable_workflow VARCHAR2
117 , p_abort_workflow VARCHAR2
118 , p_object_capacity_id NUMBER
119 );
120 procedure create_task_assignment(p_api_version NUMBER
121 , p_init_msg_list VARCHAR2
122 , p_commit VARCHAR2
123 , p_task_assignment_id NUMBER
124 , p_task_id NUMBER
125 , p_task_number VARCHAR2
126 , p_task_name VARCHAR2
127 , p_resource_type_code VARCHAR2
128 , p_resource_id NUMBER
129 , p_resource_name NUMBER
130 , p_actual_effort NUMBER
131 , p_actual_effort_uom VARCHAR2
132 , p_schedule_flag VARCHAR2
133 , p_alarm_type_code VARCHAR2
134 , p_alarm_contact VARCHAR2
135 , p_sched_travel_distance NUMBER
136 , p_sched_travel_duration NUMBER
137 , p_sched_travel_duration_uom VARCHAR2
138 , p_actual_travel_distance NUMBER
139 , p_actual_travel_duration NUMBER
140 , p_actual_travel_duration_uom VARCHAR2
141 , p_actual_start_date date
142 , p_actual_end_date date
143 , p_palm_flag VARCHAR2
144 , p_wince_flag VARCHAR2
145 , p_laptop_flag VARCHAR2
146 , p_device1_flag VARCHAR2
147 , p_device2_flag VARCHAR2
148 , p_device3_flag VARCHAR2
149 , p_resource_territory_id NUMBER
150 , p_assignment_status_id NUMBER
151 , p_shift_construct_id NUMBER
152 , x_return_status out nocopy VARCHAR2
153 , x_msg_count out nocopy NUMBER
154 , x_msg_data out nocopy VARCHAR2
155 , x_task_assignment_id out nocopy NUMBER
156 , p_attribute1 VARCHAR2
157 , p_attribute2 VARCHAR2
158 , p_attribute3 VARCHAR2
159 , p_attribute4 VARCHAR2
160 , p_attribute5 VARCHAR2
161 , p_attribute6 VARCHAR2
162 , p_attribute7 VARCHAR2
163 , p_attribute8 VARCHAR2
164 , p_attribute9 VARCHAR2
165 , p_attribute10 VARCHAR2
166 , p_attribute11 VARCHAR2
167 , p_attribute12 VARCHAR2
168 , p_attribute13 VARCHAR2
169 , p_attribute14 VARCHAR2
170 , p_attribute15 VARCHAR2
171 , p_attribute_category VARCHAR2
172 , p_show_on_calendar VARCHAR2
173 , p_category_id NUMBER
174 , p_enable_workflow VARCHAR2
175 , p_abort_workflow VARCHAR2
176 );
177 procedure create_task_assignment(p_api_version NUMBER
178 , p_init_msg_list VARCHAR2
179 , p_commit VARCHAR2
180 , p_task_assignment_id NUMBER
181 , p_task_id NUMBER
182 , p_task_number VARCHAR2
183 , p_task_name VARCHAR2
184 , p_resource_type_code VARCHAR2
185 , p_resource_id NUMBER
186 , p_resource_name NUMBER
187 , p_actual_effort NUMBER
188 , p_actual_effort_uom VARCHAR2
189 , p_schedule_flag VARCHAR2
190 , p_alarm_type_code VARCHAR2
191 , p_alarm_contact VARCHAR2
192 , p_sched_travel_distance NUMBER
193 , p_sched_travel_duration NUMBER
194 , p_sched_travel_duration_uom VARCHAR2
195 , p_actual_travel_distance NUMBER
196 , p_actual_travel_duration NUMBER
197 , p_actual_travel_duration_uom VARCHAR2
198 , p_actual_start_date date
199 , p_actual_end_date date
200 , p_palm_flag VARCHAR2
201 , p_wince_flag VARCHAR2
202 , p_laptop_flag VARCHAR2
203 , p_device1_flag VARCHAR2
204 , p_device2_flag VARCHAR2
205 , p_device3_flag VARCHAR2
206 , p_resource_territory_id NUMBER
207 , p_assignment_status_id NUMBER
208 , p_shift_construct_id NUMBER
209 , x_return_status out nocopy VARCHAR2
210 , x_msg_count out nocopy NUMBER
211 , x_msg_data out nocopy VARCHAR2
212 , x_task_assignment_id out nocopy NUMBER
213 , p_attribute1 VARCHAR2
214 , p_attribute2 VARCHAR2
215 , p_attribute3 VARCHAR2
216 , p_attribute4 VARCHAR2
217 , p_attribute5 VARCHAR2
218 , p_attribute6 VARCHAR2
219 , p_attribute7 VARCHAR2
220 , p_attribute8 VARCHAR2
221 , p_attribute9 VARCHAR2
222 , p_attribute10 VARCHAR2
223 , p_attribute11 VARCHAR2
224 , p_attribute12 VARCHAR2
225 , p_attribute13 VARCHAR2
226 , p_attribute14 VARCHAR2
227 , p_attribute15 VARCHAR2
228 , p_attribute_category VARCHAR2
229 , p_show_on_calendar VARCHAR2
230 , p_category_id NUMBER
231 );
232 procedure update_task_assignment(p_api_version NUMBER
233 , p_object_version_number in out nocopy NUMBER
234 , p_init_msg_list VARCHAR2
235 , p_commit VARCHAR2
236 , p_task_assignment_id NUMBER
237 , p_task_id NUMBER
238 , p_task_number VARCHAR2
239 , p_task_name VARCHAR2
240 , p_resource_type_code VARCHAR2
241 , p_resource_id NUMBER
242 , p_resource_name VARCHAR2
243 , p_actual_effort NUMBER
244 , p_actual_effort_uom VARCHAR2
245 , p_schedule_flag VARCHAR2
246 , p_alarm_type_code VARCHAR2
247 , p_alarm_contact VARCHAR2
248 , p_sched_travel_distance NUMBER
249 , p_sched_travel_duration NUMBER
250 , p_sched_travel_duration_uom VARCHAR2
251 , p_actual_travel_distance NUMBER
252 , p_actual_travel_duration NUMBER
253 , p_actual_travel_duration_uom VARCHAR2
254 , p_actual_start_date date
255 , p_actual_end_date date
256 , p_palm_flag VARCHAR2
257 , p_wince_flag VARCHAR2
258 , p_laptop_flag VARCHAR2
259 , p_device1_flag VARCHAR2
260 , p_device2_flag VARCHAR2
261 , p_device3_flag VARCHAR2
262 , p_resource_territory_id NUMBER
263 , p_assignment_status_id NUMBER
264 , p_shift_construct_id NUMBER
265 , x_return_status out nocopy VARCHAR2
266 , x_msg_count out nocopy NUMBER
267 , x_msg_data out nocopy VARCHAR2
268 , p_attribute1 VARCHAR2
269 , p_attribute2 VARCHAR2
270 , p_attribute3 VARCHAR2
271 , p_attribute4 VARCHAR2
272 , p_attribute5 VARCHAR2
273 , p_attribute6 VARCHAR2
274 , p_attribute7 VARCHAR2
275 , p_attribute8 VARCHAR2
276 , p_attribute9 VARCHAR2
277 , p_attribute10 VARCHAR2
278 , p_attribute11 VARCHAR2
279 , p_attribute12 VARCHAR2
280 , p_attribute13 VARCHAR2
281 , p_attribute14 VARCHAR2
282 , p_attribute15 VARCHAR2
283 , p_attribute_category VARCHAR2
284 , p_show_on_calendar VARCHAR2
285 , p_category_id NUMBER
286 , p_enable_workflow VARCHAR2
287 , p_abort_workflow VARCHAR2
288 , p_object_capacity_id NUMBER
289 );
290 procedure update_task_assignment(p_api_version NUMBER
291 , p_object_version_number in out nocopy NUMBER
292 , p_init_msg_list VARCHAR2
293 , p_commit VARCHAR2
294 , p_task_assignment_id NUMBER
295 , p_task_id NUMBER
296 , p_task_number VARCHAR2
297 , p_task_name VARCHAR2
298 , p_resource_type_code VARCHAR2
299 , p_resource_id NUMBER
300 , p_resource_name VARCHAR2
301 , p_actual_effort NUMBER
302 , p_actual_effort_uom VARCHAR2
303 , p_schedule_flag VARCHAR2
304 , p_alarm_type_code VARCHAR2
305 , p_alarm_contact VARCHAR2
306 , p_sched_travel_distance NUMBER
307 , p_sched_travel_duration NUMBER
308 , p_sched_travel_duration_uom VARCHAR2
309 , p_actual_travel_distance NUMBER
310 , p_actual_travel_duration NUMBER
311 , p_actual_travel_duration_uom VARCHAR2
312 , p_actual_start_date date
313 , p_actual_end_date date
314 , p_palm_flag VARCHAR2
315 , p_wince_flag VARCHAR2
316 , p_laptop_flag VARCHAR2
317 , p_device1_flag VARCHAR2
318 , p_device2_flag VARCHAR2
319 , p_device3_flag VARCHAR2
320 , p_resource_territory_id NUMBER
321 , p_assignment_status_id NUMBER
322 , p_shift_construct_id NUMBER
323 , x_return_status out nocopy VARCHAR2
324 , x_msg_count out nocopy NUMBER
325 , x_msg_data out nocopy VARCHAR2
326 , p_attribute1 VARCHAR2
327 , p_attribute2 VARCHAR2
328 , p_attribute3 VARCHAR2
329 , p_attribute4 VARCHAR2
330 , p_attribute5 VARCHAR2
331 , p_attribute6 VARCHAR2
332 , p_attribute7 VARCHAR2
333 , p_attribute8 VARCHAR2
334 , p_attribute9 VARCHAR2
335 , p_attribute10 VARCHAR2
336 , p_attribute11 VARCHAR2
337 , p_attribute12 VARCHAR2
338 , p_attribute13 VARCHAR2
339 , p_attribute14 VARCHAR2
340 , p_attribute15 VARCHAR2
341 , p_attribute_category VARCHAR2
342 , p_show_on_calendar VARCHAR2
343 , p_category_id NUMBER
344 , p_enable_workflow VARCHAR2
345 , p_abort_workflow VARCHAR2
346 );
347 procedure update_task_assignment(p_api_version NUMBER
348 , p_object_version_number in out nocopy NUMBER
349 , p_init_msg_list VARCHAR2
350 , p_commit VARCHAR2
351 , p_task_assignment_id NUMBER
352 , p_task_id NUMBER
353 , p_task_number VARCHAR2
354 , p_task_name VARCHAR2
355 , p_resource_type_code VARCHAR2
356 , p_resource_id NUMBER
357 , p_resource_name VARCHAR2
358 , p_actual_effort NUMBER
359 , p_actual_effort_uom VARCHAR2
360 , p_schedule_flag VARCHAR2
361 , p_alarm_type_code VARCHAR2
362 , p_alarm_contact VARCHAR2
363 , p_sched_travel_distance NUMBER
364 , p_sched_travel_duration NUMBER
365 , p_sched_travel_duration_uom VARCHAR2
366 , p_actual_travel_distance NUMBER
367 , p_actual_travel_duration NUMBER
368 , p_actual_travel_duration_uom VARCHAR2
369 , p_actual_start_date date
370 , p_actual_end_date date
371 , p_palm_flag VARCHAR2
372 , p_wince_flag VARCHAR2
373 , p_laptop_flag VARCHAR2
374 , p_device1_flag VARCHAR2
375 , p_device2_flag VARCHAR2
376 , p_device3_flag VARCHAR2
377 , p_resource_territory_id NUMBER
378 , p_assignment_status_id NUMBER
379 , p_shift_construct_id NUMBER
380 , x_return_status out nocopy VARCHAR2
381 , x_msg_count out nocopy NUMBER
382 , x_msg_data out nocopy VARCHAR2
383 , p_attribute1 VARCHAR2
384 , p_attribute2 VARCHAR2
385 , p_attribute3 VARCHAR2
386 , p_attribute4 VARCHAR2
387 , p_attribute5 VARCHAR2
388 , p_attribute6 VARCHAR2
389 , p_attribute7 VARCHAR2
390 , p_attribute8 VARCHAR2
391 , p_attribute9 VARCHAR2
392 , p_attribute10 VARCHAR2
393 , p_attribute11 VARCHAR2
394 , p_attribute12 VARCHAR2
395 , p_attribute13 VARCHAR2
396 , p_attribute14 VARCHAR2
397 , p_attribute15 VARCHAR2
398 , p_attribute_category VARCHAR2
399 , p_show_on_calendar VARCHAR2
400 , p_category_id NUMBER
401 );
402 end jtf_task_assignments_pub_w;