[Home] [Help]
PACKAGE BODY: APPS.IEX_API_RECORDS_PVT
Source
4 FUNCTION INIT_CASE_CONTACT_REC_TYPE
1 PACKAGE BODY IEX_API_RECORDS_PVT as
2 /* $Header: iexutirb.pls 120.2 2006/04/07 09:52:02 lkkumar noship $ */
3 -- *****************************************************
5 RETURN IEX_CASE_CONTACTS_PVT.CASE_CONTACT_REC_TYPE
6 IS
7 l_return_rec IEX_CASE_CONTACTS_PVT.case_contact_Rec_Type ;
8 BEGIN
9 RETURN l_return_rec;
10 END INIT_CASE_CONTACT_REC_TYPE ;
11 -- *****************************************************
12
13 FUNCTION INIT_WRITEOFFS_REC_TYPE
14 RETURN IEX_WRITEOFFS_PVT.WRITEOFFS_REC_TYPE
15 IS
16 l_return_rec IEX_WRITEOFFS_PVT.WRITEOFFS_REC_TYPE;
17 BEGIN
18 RETURN l_return_rec;
19 END INIT_WRITEOFFS_REC_TYPE ;
20
21 -- *****************************************************
22
23 FUNCTION INIT_LTG_REC_TYPE
24 RETURN IEX_LITIGATION_PVT.LTG_REC_TYPE
25 IS
26 l_return_rec IEX_LITIGATION_PVT.LTG_REC_TYPE;
27 BEGIN
31 -- *****************************************************
28 RETURN l_return_rec;
29 END INIT_LTG_REC_TYPE ;
30
32
33 FUNCTION INIT_RPS_REC_TYPE
34 RETURN IEX_REPOSSESSION_PVT.RPS_REC_TYPE
35 IS
36 l_return_rec IEX_REPOSSESSION_PVT.RPS_REC_TYPE;
37 BEGIN
38 RETURN l_return_rec;
39 END INIT_RPS_REC_TYPE ;
40 -- *****************************************************
41
42 FUNCTION INIT_BANKRUPTCY_REC_TYPE
43 RETURN IEX_BANKRUPTCIES_PVT.BANKRUPTCY_REC_TYPE
44 IS
45 l_return_rec IEX_BANKRUPTCIES_PVT.BANKRUPTCY_REC_TYPE;
46 BEGIN
47 RETURN l_return_rec;
48 END INIT_BANKRUPTCY_REC_TYPE ;
49 -- *****************************************************
50 FUNCTION INIT_CAS_REC_TYPE
51 RETURN IEX_CASES_PVT.CAS_REC_TYPE
52 IS
53 l_return_rec IEX_CASES_PVT.CAS_REC_TYPE;
54 BEGIN
55 RETURN l_return_rec;
56 END INIT_CAS_REC_TYPE ;
57 -- *****************************************************
58 FUNCTION INIT_CASE_OBJECT_REC_TYPE
59 RETURN IEX_CASE_OBJECTS_PVT.CASE_OBJECT_REC_TYPE
60 IS
61 l_return_rec IEX_CASE_OBJECTS_PVT.CASE_OBJECT_REC_TYPE ;
62 BEGIN
63 RETURN l_return_rec;
64 END INIT_CASE_OBJECT_REC_TYPE ;
65 -- *****************************************************
66 FUNCTION INIT_CASE_DEFINITION_REC_TYPE
67 RETURN IEX_CASE_DEFINITIONS_PVT.CASE_DEFINITION_REC_TYPE
68 IS
69 l_return_rec IEX_CASE_DEFINITIONS_PVT.CASE_DEFINITION_REC_TYPE ;
70 BEGIN
71 RETURN l_return_rec;
72 END INIT_CASE_DEFINITION_REC_TYPE ;
73 -- *****************************************************
74
75 FUNCTION INIT_stry_work_rec
76 RETURN IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type IS
77 l_return_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type ;
78 BEGIN
79 RETURN l_return_rec;
80 END INIT_stry_work_rec;
81
82 -- *****************************************************
83
84 FUNCTION INIT_stry_rec
85 RETURN IEX_strategy_PVT.strategy_Rec_Type IS
86 l_return_rec IEX_strategy_PVT.strategy_Rec_Type ;
87 BEGIN
88 RETURN l_return_rec;
89 END INIT_stry_rec;
90
91 -- *****************************************************
92
93 FUNCTION INIT_DEL_REC_TYPE
94 RETURN IEX_DELINQUENCY_PUB.DELINQUENCY_REC_TYPE IS
95 l_return_rec IEX_DELINQUENCY_PUB.DELINQUENCY_REC_TYPE ;
96 BEGIN
97 return l_return_rec;
98 END INIT_DEL_REC_TYPE;
99
100 -- *****************************************************
101 --Begin fix bug #4867510-jypark-12/21/2005-fix for Developer 10g Upgrade
102
103 PROCEDURE Save_Perz_Query
104 ( p_api_version_number IN NUMBER,
105 p_init_msg_list IN VARCHAR2 := 'F',
106 p_commit IN VARCHAR2 := 'F',
107 p_application_id IN NUMBER,
108 p_profile_id IN NUMBER,
109 p_profile_name IN VARCHAR2,
110 p_profile_type IN VARCHAR2,
111 p_query_id IN NUMBER,
112 p_query_name IN VARCHAR2,
113 p_query_type IN VARCHAR2,
114 p_query_desc IN VARCHAR2,
115 p_query_data_source IN VARCHAR2,
116
117 p_query_param_tbl IN IEX_API_RECORDS_PVT.QUERY_PARAMETER_TBL_TYPE,
118 p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
119 p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
120 x_query_id OUT NOCOPY NUMBER,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2
124
125 ) IS
126 l_profile_attrib_tbl JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE;
127 l_query_param_tbl JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_TBL_TYPE;
128
129 BEGIN
130 FOR i IN p_query_param_tbl.FIRST..p_query_param_tbl.LAST LOOP
131
132 l_query_param_tbl(i).parameter_name := p_query_param_tbl(i).parameter_name;
133 l_query_param_tbl(i).parameter_type := p_query_param_tbl(i).parameter_type;
134 l_query_param_tbl(i).parameter_value := p_query_param_tbl(i).parameter_value;
135 l_query_param_tbl(i).parameter_sequence := p_query_param_tbl(i).parameter_sequence;
136
137 END LOOP;
138
139 JTF_PERZ_QUERY_PUB.Save_Perz_Query
140 ( p_api_version_number => p_api_version_number,
141 p_init_msg_list => p_init_msg_list,
142 p_commit => p_commit,
143 p_application_id => p_application_id,
144 p_profile_id => p_profile_id,
145 p_profile_name => p_profile_name,
146 p_profile_type => p_profile_type,
147 p_Profile_Attrib => l_profile_attrib_tbl,
148 p_query_id => p_query_id,
149 p_query_name => p_query_name,
150 p_query_type => p_query_type,
151 p_query_desc => p_query_desc,
152 p_query_data_source => p_query_data_source,
153 p_query_param_tbl => l_query_param_tbl,
154 p_query_order_by_tbl => p_query_order_by_tbl,
155 p_query_raw_sql_rec => p_query_raw_sql_rec,
156 x_query_id => x_query_id,
157 x_return_status => x_return_status,
158 x_msg_count => x_msg_count,
162
159 x_msg_data => x_msg_data
160 );
161 END SAVE_PERZ_QUERY;
163 PROCEDURE Get_Perz_Query
164 ( p_api_version_number IN NUMBER,
165 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
166
167 p_application_id IN NUMBER,
168 p_profile_id IN NUMBER,
169 p_profile_name IN VARCHAR2,
170
171 p_query_id IN NUMBER,
172 p_query_name IN VARCHAR2,
173 p_query_type IN VARCHAR2,
174
175 x_query_id OUT NOCOPY NUMBER,
176 x_query_name OUT NOCOPY VARCHAR2,
177 x_query_type OUT NOCOPY VARCHAR2,
178 x_query_desc OUT NOCOPY VARCHAR2,
179 x_query_data_source OUT NOCOPY VARCHAR2,
180
181 x_query_param_tbl OUT NOCOPY IEX_API_RECORDS_PVT.QUERY_PARAMETER_TBL_TYPE,
182 x_query_order_by_tbl OUT NOCOPY Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
183 x_query_raw_sql_rec OUT NOCOPY Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
184
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2
188 ) IS
189 l_query_param_tbl Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE;
190 BEGIN
191 -- select all the parameters for the given query_id from jtf_perz_query_param into pl/sql table
192 JTF_PERZ_QUERY_PVT.Get_Perz_Query
193 (
194 p_api_version_number => p_api_version_number,
195 p_init_msg_list => p_init_msg_list,
196 p_application_id => p_application_id,
197 p_profile_id => p_profile_id,
198 p_profile_name => p_profile_name,
199 p_query_id => p_query_id,
200 p_query_name => p_query_name,
201 p_query_type => p_query_type,
202 x_query_id => x_query_id,
203 x_query_name => x_query_name,
204 x_query_type => x_query_type,
205 x_query_desc => x_query_desc,
206 x_query_data_source => x_query_data_source,
207 x_query_param_tbl => l_query_param_tbl,
208 x_query_order_by_tbl => x_query_order_by_tbl,
209 x_query_raw_sql_rec => x_query_raw_sql_rec,
210 x_return_status => x_return_status,
211 x_msg_count => x_msg_count,
212 x_msg_data => x_msg_data
213 );
214
215 FOR i IN l_query_param_tbl.FIRST..l_query_param_tbl.LAST LOOP
216
217 x_query_param_tbl(i).parameter_name := l_query_param_tbl(i).parameter_name;
218 x_query_param_tbl(i).parameter_type := l_query_param_tbl(i).parameter_type;
219 x_query_param_tbl(i).parameter_value := l_query_param_tbl(i).parameter_value;
220 x_query_param_tbl(i).parameter_sequence := l_query_param_tbl(i).parameter_sequence;
221
222 END LOOP;
223
224 END GET_PERZ_QUERY;
225
226 PROCEDURE create_task (
227 p_api_version IN NUMBER,
228 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
229 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
230 p_task_id IN NUMBER DEFAULT NULL,
231 p_task_name IN VARCHAR2,
232 p_task_type_name IN VARCHAR2 DEFAULT NULL,
233 p_task_type_id IN NUMBER DEFAULT NULL,
234 p_description IN VARCHAR2 DEFAULT NULL,
235 p_task_status_name IN VARCHAR2 DEFAULT NULL,
236 p_task_status_id IN NUMBER DEFAULT NULL,
237 p_task_priority_name IN VARCHAR2 DEFAULT NULL,
238 p_task_priority_id IN NUMBER DEFAULT NULL,
239 p_owner_type_name IN VARCHAR2 DEFAULT NULL,
240 p_owner_type_code IN VARCHAR2 DEFAULT NULL,
241 p_owner_id IN NUMBER DEFAULT NULL,
242 p_owner_territory_id IN NUMBER DEFAULT NULL,
243 p_assigned_by_name IN VARCHAR2 DEFAULT NULL,
244 p_assigned_by_id IN NUMBER DEFAULT NULL,
245 p_customer_number IN VARCHAR2 DEFAULT NULL, -- from hz_parties
246 p_customer_id IN NUMBER DEFAULT NULL,
247 p_cust_account_number IN VARCHAR2 DEFAULT NULL,
248 p_cust_account_id IN NUMBER DEFAULT NULL,
249 p_address_id IN NUMBER DEFAULT NULL, ---- hz_party_sites
250 p_address_number IN VARCHAR2 DEFAULT NULL,
251 p_planned_start_date IN DATE DEFAULT NULL,
252 p_planned_end_date IN DATE DEFAULT NULL,
253 p_scheduled_start_date IN DATE DEFAULT NULL,
254 p_scheduled_end_date IN DATE DEFAULT NULL,
255 p_actual_start_date IN DATE DEFAULT NULL,
256 p_actual_end_date IN DATE DEFAULT NULL,
257 p_timezone_id IN NUMBER DEFAULT NULL,
258 p_timezone_name IN VARCHAR2 DEFAULT NULL,
259 p_source_object_type_code IN VARCHAR2 DEFAULT NULL,
260 p_source_object_id IN NUMBER DEFAULT NULL,
261 p_source_object_name IN VARCHAR2 DEFAULT NULL,
262 p_duration IN NUMBER DEFAULT NULL,
263 p_duration_uom IN VARCHAR2 DEFAULT NULL,
264 p_planned_effort IN NUMBER DEFAULT NULL,
265 p_planned_effort_uom IN VARCHAR2 DEFAULT NULL,
266 p_actual_effort IN NUMBER DEFAULT NULL,
267 p_actual_effort_uom IN VARCHAR2 DEFAULT NULL,
271 p_publish_flag IN VARCHAR2 DEFAULT NULL,
268 p_percentage_complete IN NUMBER DEFAULT NULL,
269 p_reason_code IN VARCHAR2 DEFAULT NULL,
270 p_private_flag IN VARCHAR2 DEFAULT NULL,
272 p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL,
273 p_multi_booked_flag IN VARCHAR2 DEFAULT NULL,
274 p_milestone_flag IN VARCHAR2 DEFAULT NULL,
275 p_holiday_flag IN VARCHAR2 DEFAULT NULL,
276 p_billable_flag IN VARCHAR2 DEFAULT NULL,
277 p_bound_mode_code IN VARCHAR2 DEFAULT NULL,
278 p_soft_bound_flag IN VARCHAR2 DEFAULT NULL,
279 p_workflow_process_id IN NUMBER DEFAULT NULL,
280 p_notification_flag IN VARCHAR2 DEFAULT NULL,
281 p_notification_period IN NUMBER DEFAULT NULL,
282 p_notification_period_uom IN VARCHAR2 DEFAULT NULL,
283 p_parent_task_number IN VARCHAR2 DEFAULT NULL,
284 p_parent_task_id IN NUMBER DEFAULT NULL,
285 p_alarm_start IN NUMBER DEFAULT NULL,
286 p_alarm_start_uom IN VARCHAR2 DEFAULT NULL,
287 p_alarm_on IN VARCHAR2 DEFAULT NULL,
288 p_alarm_count IN NUMBER DEFAULT NULL,
289 p_alarm_interval IN NUMBER DEFAULT NULL,
290 p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL,
291 p_palm_flag IN VARCHAR2 DEFAULT NULL,
292 p_wince_flag IN VARCHAR2 DEFAULT NULL,
293 p_laptop_flag IN VARCHAR2 DEFAULT NULL,
294 p_device1_flag IN VARCHAR2 DEFAULT NULL,
295 p_device2_flag IN VARCHAR2 DEFAULT NULL,
296 p_device3_flag IN VARCHAR2 DEFAULT NULL,
297 p_costs IN NUMBER DEFAULT NULL,
298 p_currency_code IN VARCHAR2 DEFAULT NULL,
299 p_escalation_level IN VARCHAR2 DEFAULT NULL,
300 p_task_assign_tbl IN jtf_tasks_pub.task_assign_tbl DEFAULT jtf_tasks_pub.g_miss_task_assign_tbl,
301 p_task_depends_tbl IN jtf_tasks_pub.task_depends_tbl DEFAULT jtf_tasks_pub.g_miss_task_depends_tbl,
302 p_task_rsrc_req_tbl IN IEX_API_RECORDS_PVT.task_rsrc_req_tbl DEFAULT IEX_API_RECORDS_PVT.g_miss_task_rsrc_req_tbl,
303 p_task_refer_tbl IN jtf_tasks_pub.task_refer_tbl DEFAULT jtf_tasks_pub.g_miss_task_refer_tbl,
304 p_task_dates_tbl IN jtf_tasks_pub.task_dates_tbl DEFAULT jtf_tasks_pub.g_miss_task_dates_tbl,
305 p_task_notes_tbl IN jtf_tasks_pub.task_notes_tbl DEFAULT jtf_tasks_pub.g_miss_task_notes_tbl,
306 p_task_recur_rec IN jtf_tasks_pub.task_recur_rec DEFAULT jtf_tasks_pub.g_miss_task_recur_rec,
307 p_task_contacts_tbl IN jtf_tasks_pub.task_contacts_tbl DEFAULT jtf_tasks_pub.g_miss_task_contacts_tbl,
308 x_return_status OUT NOCOPY VARCHAR2,
309 x_msg_count OUT NOCOPY NUMBER,
310 x_msg_data OUT NOCOPY VARCHAR2,
311 x_task_id OUT NOCOPY NUMBER,
312 p_attribute1 IN VARCHAR2 DEFAULT null ,
313 p_attribute2 IN VARCHAR2 DEFAULT null ,
314 p_attribute3 IN VARCHAR2 DEFAULT null ,
315 p_attribute4 IN VARCHAR2 DEFAULT null ,
316 p_attribute5 IN VARCHAR2 DEFAULT null ,
317 p_attribute6 IN VARCHAR2 DEFAULT null ,
318 p_attribute7 IN VARCHAR2 DEFAULT null ,
319 p_attribute8 IN VARCHAR2 DEFAULT null ,
320 p_attribute9 IN VARCHAR2 DEFAULT null ,
321 p_attribute10 IN VARCHAR2 DEFAULT null ,
322 p_attribute11 IN VARCHAR2 DEFAULT null ,
323 p_attribute12 IN VARCHAR2 DEFAULT null ,
324 p_attribute13 IN VARCHAR2 DEFAULT null ,
325 p_attribute14 IN VARCHAR2 DEFAULT null ,
326 p_attribute15 IN VARCHAR2 DEFAULT null ,
327 p_attribute_category IN VARCHAR2 DEFAULT null,
328 p_date_selected IN VARCHAR2 DEFAULT null,
329 p_category_id IN NUMBER DEFAULT null,
330 p_show_on_calendar IN VARCHAR2 DEFAULT null,
331 p_owner_status_id IN NUMBER DEFAULT null,
332 p_template_id IN NUMBER DEFAULT null,
333 p_template_group_id IN NUMBER DEFAULT null
334 )
335 IS
336 l_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
337
338 BEGIN
339
340 --Bug5122929. Fix by LKKUMAR on 07-Apr-2006. Start.
341 IF ( p_task_rsrc_req_tbl.COUNT > 0 ) THEN
342 FOR i IN p_task_rsrc_req_tbl.FIRST..p_task_rsrc_req_tbl.LAST LOOP
343 l_task_rsrc_req_tbl(i).RESOURCE_TYPE_CODE := p_task_rsrc_req_tbl(i).RESOURCE_TYPE_CODE;
344 l_task_rsrc_req_tbl(i).REQUIRED_UNITS := p_task_rsrc_req_tbl(i).REQUIRED_UNITS;
345 l_task_rsrc_req_tbl(i).ENABLED_FLAG := p_task_rsrc_req_tbl(i).ENABLED_FLAG;
346 END LOOP;
347 END IF;
348 --Bug5122929. Fix by LKKUMAR on 07-Apr-2006. End.
349
350 JTF_TASKS_PUB.CREATE_TASK(
351 P_API_VERSION => P_API_VERSION,
352 P_INIT_MSG_LIST => P_INIT_MSG_LIST,
353 P_COMMIT => P_COMMIT,
354 P_TASK_ID => P_TASK_ID,
355 P_TASK_NAME => P_TASK_NAME,
356 P_TASK_TYPE_NAME => P_TASK_TYPE_NAME,
357 P_TASK_TYPE_ID => P_TASK_TYPE_ID,
358 P_DESCRIPTION => P_DESCRIPTION,
359 P_TASK_STATUS_NAME => P_TASK_STATUS_NAME,
360 P_TASK_STATUS_ID => P_TASK_STATUS_ID,
361 P_TASK_PRIORITY_NAME => P_TASK_PRIORITY_NAME,
362 P_TASK_PRIORITY_ID => P_TASK_PRIORITY_ID,
363 p_owner_type_name => p_owner_type_name,
364 P_OWNER_TYPE_CODE => P_OWNER_TYPE_CODE,
365 P_OWNER_ID => P_OWNER_ID,
366 P_OWNER_TERRITORY_ID => P_OWNER_TERRITORY_ID,
367 p_assigned_by_name => p_assigned_by_name,
368 P_ASSIGNED_BY_ID => P_ASSIGNED_BY_ID,
369 p_customer_number => p_customer_number,
370 P_CUSTOMER_ID => P_CUSTOMER_ID,
371 p_cust_account_number => p_cust_account_number,
372 P_CUST_ACCOUNT_ID => P_CUST_ACCOUNT_ID,
373 P_ADDRESS_ID => P_ADDRESS_ID,
374 p_address_number => P_ADDRESS_NUMBER,
375 P_PLANNED_START_DATE => P_PLANNED_START_DATE,
376 P_PLANNED_END_DATE => P_PLANNED_END_DATE,
377 P_SCHEDULED_START_DATE => P_SCHEDULED_START_DATE,
378 P_SCHEDULED_END_DATE => P_SCHEDULED_END_DATE,
379 P_ACTUAL_START_DATE => P_ACTUAL_START_DATE,
380 P_ACTUAL_END_DATE => P_ACTUAL_END_DATE,
381 P_TIMEZONE_ID => P_TIMEZONE_ID,
382 p_timezone_name => P_TIMEZONE_NAME,
383 P_SOURCE_OBJECT_TYPE_CODE => P_SOURCE_OBJECT_TYPE_CODE,
384 P_SOURCE_OBJECT_ID => P_SOURCE_OBJECT_ID,
385 P_SOURCE_OBJECT_NAME => P_SOURCE_OBJECT_NAME,
386 P_DURATION => P_DURATION,
387 P_DURATION_UOM => P_DURATION_UOM,
388 P_PLANNED_EFFORT => P_PLANNED_EFFORT,
389 P_PLANNED_EFFORT_UOM => P_PLANNED_EFFORT_UOM,
390 P_ACTUAL_EFFORT => P_ACTUAL_EFFORT,
391 P_ACTUAL_EFFORT_UOM => P_ACTUAL_EFFORT_UOM,
392 P_PERCENTAGE_COMPLETE => P_PERCENTAGE_COMPLETE,
393 P_REASON_CODE => P_REASON_CODE,
394 P_PRIVATE_FLAG => P_PRIVATE_FLAG,
395 P_PUBLISH_FLAG => P_PUBLISH_FLAG,
396 P_RESTRICT_CLOSURE_FLAG => P_RESTRICT_CLOSURE_FLAG,
397 P_MULTI_BOOKED_FLAG => P_MULTI_BOOKED_FLAG,
398 P_MILESTONE_FLAG => P_MILESTONE_FLAG,
399 P_HOLIDAY_FLAG => P_HOLIDAY_FLAG,
400 P_BILLABLE_FLAG => P_BILLABLE_FLAG,
401 P_BOUND_MODE_CODE => P_BOUND_MODE_CODE,
402 P_SOFT_BOUND_FLAG => P_SOFT_BOUND_FLAG,
403 P_WORKFLOW_PROCESS_ID => P_WORKFLOW_PROCESS_ID,
404 P_NOTIFICATION_FLAG => P_NOTIFICATION_FLAG,
405 P_NOTIFICATION_PERIOD => P_NOTIFICATION_PERIOD,
406 P_NOTIFICATION_PERIOD_UOM => P_NOTIFICATION_PERIOD_UOM,
407 p_parent_task_number => P_parent_task_number,
408 P_PARENT_TASK_ID => P_PARENT_TASK_ID,
409 P_ALARM_START => P_ALARM_START,
410 P_ALARM_START_UOM => P_ALARM_START_UOM,
411 P_ALARM_ON => P_ALARM_ON,
412 P_ALARM_COUNT => P_ALARM_COUNT,
413 P_ALARM_INTERVAL => P_ALARM_INTERVAL,
414 P_ALARM_INTERVAL_UOM => P_ALARM_INTERVAL_UOM,
415 P_PALM_FLAG => P_PALM_FLAG,
416 P_WINCE_FLAG => P_WINCE_FLAG,
417 P_LAPTOP_FLAG => P_LAPTOP_FLAG,
418 P_DEVICE1_FLAG => P_DEVICE1_FLAG,
419 P_DEVICE2_FLAG => P_DEVICE2_FLAG,
420 P_DEVICE3_FLAG => P_DEVICE3_FLAG,
421 P_COSTS => P_COSTS,
422 P_CURRENCY_CODE => P_CURRENCY_CODE,
423 P_ESCALATION_LEVEL => P_ESCALATION_LEVEL,
424 p_task_assign_tbl => p_task_assign_tbl,
425 p_task_depends_tbl => p_task_depends_tbl,
426 p_task_rsrc_req_tbl => l_task_rsrc_req_tbl,
427 p_task_refer_tbl => p_task_refer_tbl,
428 p_task_dates_tbl => p_task_dates_tbl,
429 p_task_notes_tbl => p_task_notes_tbl,
430 p_task_recur_rec => p_task_recur_rec,
431 p_task_contacts_tbl => p_task_contacts_tbl,
432 x_return_status => x_return_status,
433 x_msg_count => x_msg_count,
434 x_msg_data => x_msg_data,
435 x_task_id => x_task_id,
436 P_ATTRIBUTE1 => P_ATTRIBUTE1,
437 P_ATTRIBUTE2 => P_ATTRIBUTE2,
438 P_ATTRIBUTE3 => P_ATTRIBUTE3,
439 P_ATTRIBUTE4 => P_ATTRIBUTE4,
440 P_ATTRIBUTE5 => P_ATTRIBUTE5,
441 P_ATTRIBUTE6 => P_ATTRIBUTE6,
442 P_ATTRIBUTE7 => P_ATTRIBUTE7,
443 P_ATTRIBUTE8 => P_ATTRIBUTE8,
444 P_ATTRIBUTE9 => P_ATTRIBUTE9,
445 P_ATTRIBUTE10 => P_ATTRIBUTE10,
446 P_ATTRIBUTE11 => P_ATTRIBUTE11,
447 P_ATTRIBUTE12 => P_ATTRIBUTE12,
448 P_ATTRIBUTE13 => P_ATTRIBUTE13,
449 P_ATTRIBUTE14 => P_ATTRIBUTE14,
450 P_ATTRIBUTE15 => P_ATTRIBUTE15,
451 P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
452 );
453
454
455
456 END CREATE_TASK;
457 --End fix bug #4867510-jypark-12/21/2005-fix for Developer 10g Upgrade
458
459 END IEX_API_RECORDS_PVT;