28: l_api_version CONSTANT NUMBER := 1.0;
29: BEGIN
30: if p_actual_start_date is not null AND p_actual_end_date is not null then
31: if p_actual_start_date > p_actual_end_date then
32: x_return_status := FND_API.G_RET_STS_ERROR;
33: FND_MESSAGE.SET_NAME('AMS','AMS_TASK_INVALID_DATE');
34: FND_MSG_PUB.Add;
35: x_return_status := FND_API.G_RET_STS_ERROR;
36: FND_MSG_PUB.Count_and_Get
31: if p_actual_start_date > p_actual_end_date then
32: x_return_status := FND_API.G_RET_STS_ERROR;
33: FND_MESSAGE.SET_NAME('AMS','AMS_TASK_INVALID_DATE');
34: FND_MSG_PUB.Add;
35: x_return_status := FND_API.G_RET_STS_ERROR;
36: FND_MSG_PUB.Count_and_Get
37: (
38: p_count => x_msg_count,
39: p_data => x_msg_data
40: );
41: return;
42: END IF;
43: END IF;
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45: END;
46:
47:
48: procedure check_ntf_required (p_task_id in number,
68: end check_ntf_required;
69:
70: PROCEDURE create_task (
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
73: p_commit IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
74: p_task_id IN NUMBER ,--DEFAULT NULL,
75: p_task_name IN VARCHAR2,
76: p_task_type_id IN NUMBER ,--DEFAULT NULL,
69:
70: PROCEDURE create_task (
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
73: p_commit IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
74: p_task_id IN NUMBER ,--DEFAULT NULL,
75: p_task_name IN VARCHAR2,
76: p_task_type_id IN NUMBER ,--DEFAULT NULL,
77: p_task_status_id IN NUMBER ,--DEFAULT NULL,
104: l_source_object_type_code VARCHAR2(80) := p_source_object_type_code ;
105: l_source_object_id NUMBER := p_source_object_id ;
106: l_source_object_name VARCHAR2(80) := p_source_object_name ;
107: l_owner_type_code VARCHAR2(90) := p_owner_type_code;
108: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
109: l_private_flag VARCHAR2(1) := p_private_flag ;
110: l_planned_start_date DATE := p_planned_start_date ;
111: l_planned_end_date DATE := p_planned_end_date ;
112:
111: l_planned_end_date DATE := p_planned_end_date ;
112:
113: BEGIN
114:
115: IF fnd_api.to_boolean (p_init_msg_list) THEN
116: fnd_msg_pub.initialize;
117: END IF;
118:
119: validate_task (
121: p_actual_end_date =>p_actual_start_date,
122: x_return_status =>l_return_status,
123: x_msg_count =>x_msg_count,
124: x_msg_data =>x_msg_data) ;
125: if l_return_status = FND_API.G_RET_STS_ERROR THEN
126: RAISE FND_API.G_EXC_ERROR ;
127: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
129: end if;
122: x_return_status =>l_return_status,
123: x_msg_count =>x_msg_count,
124: x_msg_data =>x_msg_data) ;
125: if l_return_status = FND_API.G_RET_STS_ERROR THEN
126: RAISE FND_API.G_EXC_ERROR ;
127: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
129: end if;
130: if (l_source_object_id = 0 ) then
123: x_msg_count =>x_msg_count,
124: x_msg_data =>x_msg_data) ;
125: if l_return_status = FND_API.G_RET_STS_ERROR THEN
126: RAISE FND_API.G_EXC_ERROR ;
127: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
129: end if;
130: if (l_source_object_id = 0 ) then
131: l_source_object_id := NULL;
124: x_msg_data =>x_msg_data) ;
125: if l_return_status = FND_API.G_RET_STS_ERROR THEN
126: RAISE FND_API.G_EXC_ERROR ;
127: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
129: end if;
130: if (l_source_object_id = 0 ) then
131: l_source_object_id := NULL;
132: end if;
167:
168:
169: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
170: -- p_api_version => l_api_version,
171: -- p_init_msg_list => FND_API.g_false,
172: -- p_commit => FND_API.g_false,
173: -- p_validation_level => FND_API.g_valid_level_full,
174: -- x_return_status => l_return_status,
175: -- x_msg_count => x_msg_count,
168:
169: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
170: -- p_api_version => l_api_version,
171: -- p_init_msg_list => FND_API.g_false,
172: -- p_commit => FND_API.g_false,
173: -- p_validation_level => FND_API.g_valid_level_full,
174: -- x_return_status => l_return_status,
175: -- x_msg_count => x_msg_count,
176: -- x_msg_data => x_msg_data,
169: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
170: -- p_api_version => l_api_version,
171: -- p_init_msg_list => FND_API.g_false,
172: -- p_commit => FND_API.g_false,
173: -- p_validation_level => FND_API.g_valid_level_full,
174: -- x_return_status => l_return_status,
175: -- x_msg_count => x_msg_count,
176: -- x_msg_data => x_msg_data,
177: -- p_object_type => l_source_object_type_code,
183: -- end if;
184:
185: /**** ADDED BY ABHOLA ****/
186:
187: IF FND_API.to_boolean(p_commit) THEN
188: COMMIT;
189: END IF;
190:
191: EXCEPTION
188: COMMIT;
189: END IF;
190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.count_And_Get
195: ( p_count => x_msg_count,
196: p_data => x_msg_data);
189: END IF;
190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.count_And_Get
195: ( p_count => x_msg_count,
196: p_data => x_msg_data);
197: WHEN FND_API.G_EXC_ERROR THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.count_And_Get
195: ( p_count => x_msg_count,
196: p_data => x_msg_data);
197: WHEN FND_API.G_EXC_ERROR THEN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: FND_MSG_PUB.count_And_Get
200: ( p_count => x_msg_count,
201: p_data => x_msg_data);
194: FND_MSG_PUB.count_And_Get
195: ( p_count => x_msg_count,
196: p_data => x_msg_data);
197: WHEN FND_API.G_EXC_ERROR THEN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: FND_MSG_PUB.count_And_Get
200: ( p_count => x_msg_count,
201: p_data => x_msg_data);
202: /*****************************************************************/
204: ---------------------------------------------------------------
205:
206: PROCEDURE update_task (
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
209: p_commit IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
210: p_object_version_number IN NUMBER ,
211: p_task_id IN NUMBER ,--DEFAULT fnd_api.g_miss_num,
212: p_task_name IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
205:
206: PROCEDURE update_task (
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
209: p_commit IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
210: p_object_version_number IN NUMBER ,
211: p_task_id IN NUMBER ,--DEFAULT fnd_api.g_miss_num,
212: p_task_name IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
213: p_task_type_id IN NUMBER ,--DEFAULT NULL,
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
209: p_commit IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
210: p_object_version_number IN NUMBER ,
211: p_task_id IN NUMBER ,--DEFAULT fnd_api.g_miss_num,
212: p_task_name IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
213: p_task_type_id IN NUMBER ,--DEFAULT NULL,
214: p_task_status_id IN NUMBER ,--DEFAULT NULL,
215: p_task_priority_id IN NUMBER ,--DEFAULT NULL,
208: p_init_msg_list IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
209: p_commit IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
210: p_object_version_number IN NUMBER ,
211: p_task_id IN NUMBER ,--DEFAULT fnd_api.g_miss_num,
212: p_task_name IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
213: p_task_type_id IN NUMBER ,--DEFAULT NULL,
214: p_task_status_id IN NUMBER ,--DEFAULT NULL,
215: p_task_priority_id IN NUMBER ,--DEFAULT NULL,
216: p_owner_id IN NUMBER ,--DEFAULT NULL,
216: p_owner_id IN NUMBER ,--DEFAULT NULL,
217: p_private_flag IN VARCHAR2 ,--DEFAULT NULL,
218: p_planned_start_date IN DATE ,--DEFAULT NULL,
219: p_planned_end_date IN DATE ,--DEFAULT NULL,
220: p_actual_start_date IN DATE ,--DEFAULT fnd_api.g_miss_date,
221: p_actual_end_date IN DATE ,--DEFAULT fnd_api.g_miss_date,
222: p_source_object_type_code IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
223: p_source_object_id IN NUMBER ,--DEFAULT fnd_api.g_miss_num,
224: p_source_object_name IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
217: p_private_flag IN VARCHAR2 ,--DEFAULT NULL,
218: p_planned_start_date IN DATE ,--DEFAULT NULL,
219: p_planned_end_date IN DATE ,--DEFAULT NULL,
220: p_actual_start_date IN DATE ,--DEFAULT fnd_api.g_miss_date,
221: p_actual_end_date IN DATE ,--DEFAULT fnd_api.g_miss_date,
222: p_source_object_type_code IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
223: p_source_object_id IN NUMBER ,--DEFAULT fnd_api.g_miss_num,
224: p_source_object_name IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
225: x_return_status OUT NOCOPY VARCHAR2,
218: p_planned_start_date IN DATE ,--DEFAULT NULL,
219: p_planned_end_date IN DATE ,--DEFAULT NULL,
220: p_actual_start_date IN DATE ,--DEFAULT fnd_api.g_miss_date,
221: p_actual_end_date IN DATE ,--DEFAULT fnd_api.g_miss_date,
222: p_source_object_type_code IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
223: p_source_object_id IN NUMBER ,--DEFAULT fnd_api.g_miss_num,
224: p_source_object_name IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
219: p_planned_end_date IN DATE ,--DEFAULT NULL,
220: p_actual_start_date IN DATE ,--DEFAULT fnd_api.g_miss_date,
221: p_actual_end_date IN DATE ,--DEFAULT fnd_api.g_miss_date,
222: p_source_object_type_code IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
223: p_source_object_id IN NUMBER ,--DEFAULT fnd_api.g_miss_num,
224: p_source_object_name IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2 )
220: p_actual_start_date IN DATE ,--DEFAULT fnd_api.g_miss_date,
221: p_actual_end_date IN DATE ,--DEFAULT fnd_api.g_miss_date,
222: p_source_object_type_code IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
223: p_source_object_id IN NUMBER ,--DEFAULT fnd_api.g_miss_num,
224: p_source_object_name IN VARCHAR2 ,--DEFAULT fnd_api.g_miss_char,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2 )
228: IS
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2 )
228: IS
229:
230: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
231: l_api_version CONSTANT NUMBER := 1.0;
232: l_task_name VARCHAR2(80) := p_task_name ;
233: l_owner_id NUMBER := p_owner_id ;
234: l_actual_start_date DATE := p_actual_start_date;
243: l_task_priority_id NUMBER := p_task_priority_id;
244: l_private_flag VARCHAR2(1) := p_private_flag ;
245: l_planned_start_date DATE := p_planned_start_date ;
246: l_planned_end_date DATE := p_planned_end_date ;
247: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
248:
249: -- For checking if workflow exists for this task
250: -- Workflow is with item_key as task_id || object_version_number
251: CURSOR c_check_wfprocess is
260: -- WHERE name = 'Assigned';
261: WHERE task_status_id = 14 ;-- 'Assigned';
262: l_status_id number;
263: l_return_flag varchar2(1);
264: l_item_type varchar2(100) := FND_API.G_MISS_CHAR;
265:
266: BEGIN
267: IF fnd_api.to_boolean (p_init_msg_list) THEN
268: fnd_msg_pub.initialize;
263: l_return_flag varchar2(1);
264: l_item_type varchar2(100) := FND_API.G_MISS_CHAR;
265:
266: BEGIN
267: IF fnd_api.to_boolean (p_init_msg_list) THEN
268: fnd_msg_pub.initialize;
269: END IF;
270:
271: validate_task (
273: p_actual_end_date =>p_actual_end_date,
274: x_return_status =>x_return_status,
275: x_msg_count =>x_msg_count,
276: x_msg_data =>x_msg_data) ;
277: if x_return_status = FND_API.G_RET_STS_ERROR THEN
278: RAISE FND_API.G_EXC_ERROR ;
279: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
281: end if;
274: x_return_status =>x_return_status,
275: x_msg_count =>x_msg_count,
276: x_msg_data =>x_msg_data) ;
277: if x_return_status = FND_API.G_RET_STS_ERROR THEN
278: RAISE FND_API.G_EXC_ERROR ;
279: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
281: end if;
282:
275: x_msg_count =>x_msg_count,
276: x_msg_data =>x_msg_data) ;
277: if x_return_status = FND_API.G_RET_STS_ERROR THEN
278: RAISE FND_API.G_EXC_ERROR ;
279: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
281: end if;
282:
283: if (l_owner_id = 0) then
276: x_msg_data =>x_msg_data) ;
277: if x_return_status = FND_API.G_RET_STS_ERROR THEN
278: RAISE FND_API.G_EXC_ERROR ;
279: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
281: end if;
282:
283: if (l_owner_id = 0) then
284: l_owner_id := null;
321: if l_status_id = l_task_status_id then
322: OPEN c_check_wfprocess;
323: FETCH c_check_wfprocess into l_item_type ;
324: CLOSE c_check_wfprocess;
325: if ( l_item_type = FND_API.G_MISS_CHAR
326: and l_source_object_type_code is not null )then
327: AMS_TASKS_WF.AmsStartWorkflow(
328: p_api_version => l_api_version,
329: --p_init_msg_list IN VARCHAR2 := FND_API.g_false,
325: if ( l_item_type = FND_API.G_MISS_CHAR
326: and l_source_object_type_code is not null )then
327: AMS_TASKS_WF.AmsStartWorkflow(
328: p_api_version => l_api_version,
329: --p_init_msg_list IN VARCHAR2 := FND_API.g_false,
330: --p_commit IN VARCHAR2 := FND_API.g_false,
331: p_task_id => l_task_id,
332: p_object_version => l_object_version_number,
333: x_return_status => l_return_status
326: and l_source_object_type_code is not null )then
327: AMS_TASKS_WF.AmsStartWorkflow(
328: p_api_version => l_api_version,
329: --p_init_msg_list IN VARCHAR2 := FND_API.g_false,
330: --p_commit IN VARCHAR2 := FND_API.g_false,
331: p_task_id => l_task_id,
332: p_object_version => l_object_version_number,
333: x_return_status => l_return_status
334: --x_msg_count OUT NOCOPY NUMBER,
341: */
342:
343: /**** ADDED BY ABHOLA ****/
344:
345: IF FND_API.to_boolean(p_commit) THEN
346: COMMIT;
347: END IF;
348:
349: EXCEPTION
346: COMMIT;
347: END IF;
348:
349: EXCEPTION
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: FND_MSG_PUB.count_And_Get
353: ( p_count => x_msg_count,
354: p_data => x_msg_data);
347: END IF;
348:
349: EXCEPTION
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: FND_MSG_PUB.count_And_Get
353: ( p_count => x_msg_count,
354: p_data => x_msg_data);
355: WHEN FND_API.G_EXC_ERROR THEN
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: FND_MSG_PUB.count_And_Get
353: ( p_count => x_msg_count,
354: p_data => x_msg_data);
355: WHEN FND_API.G_EXC_ERROR THEN
356: x_return_status := FND_API.G_RET_STS_ERROR;
357: FND_MSG_PUB.count_And_Get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data);
352: FND_MSG_PUB.count_And_Get
353: ( p_count => x_msg_count,
354: p_data => x_msg_data);
355: WHEN FND_API.G_EXC_ERROR THEN
356: x_return_status := FND_API.G_RET_STS_ERROR;
357: FND_MSG_PUB.count_And_Get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data);
360: END update_task;
362: -----------------------------------------------------------
363:
364: PROCEDURE delete_task (
365: p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
367: p_commit IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
368: p_object_version_number IN NUMBER ,
369: p_task_id IN NUMBER ,--DEFAULT NULL,
370: x_return_status OUT NOCOPY VARCHAR2,
363:
364: PROCEDURE delete_task (
365: p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
367: p_commit IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
368: p_object_version_number IN NUMBER ,
369: p_task_id IN NUMBER ,--DEFAULT NULL,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_msg_count OUT NOCOPY NUMBER,
429: -- end if;
430:
431: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
432: -- p_api_version => l_api_version,
433: -- p_init_msg_list => FND_API.g_false,
434: -- p_commit => FND_API.g_false,
435: -- p_validation_level => FND_API.g_valid_level_full,
436: -- x_return_status => l_return_status,
437: -- x_msg_count => x_msg_count,
430:
431: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
432: -- p_api_version => l_api_version,
433: -- p_init_msg_list => FND_API.g_false,
434: -- p_commit => FND_API.g_false,
435: -- p_validation_level => FND_API.g_valid_level_full,
436: -- x_return_status => l_return_status,
437: -- x_msg_count => x_msg_count,
438: -- x_msg_data => x_msg_data,
431: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
432: -- p_api_version => l_api_version,
433: -- p_init_msg_list => FND_API.g_false,
434: -- p_commit => FND_API.g_false,
435: -- p_validation_level => FND_API.g_valid_level_full,
436: -- x_return_status => l_return_status,
437: -- x_msg_count => x_msg_count,
438: -- x_msg_data => x_msg_data,
439: -- p_object_type => l_object_type,
447: ------------------------------------------------------
448:
449: /**** ADDED BY ABHOLA ****/
450:
451: IF FND_API.to_boolean(p_commit) THEN
452: COMMIT;
453: END IF;
454:
455: END delete_task;
457: ---------------------------------------------------------
458:
459: Procedure Create_Task_Assignment (
460: P_API_VERSION IN NUMBER ,
461: P_INIT_MSG_LIST IN VARCHAR2 ,--DEFAULT FND_API.G_FALSE ,
462: P_COMMIT IN VARCHAR2 ,--DEFAULT FND_API.G_FALSE ,
463: P_TASK_ID IN NUMBER ,
464: P_RESOURCE_TYPE_CODE IN VARCHAR2 ,
465: P_RESOURCE_ID IN NUMBER ,
458:
459: Procedure Create_Task_Assignment (
460: P_API_VERSION IN NUMBER ,
461: P_INIT_MSG_LIST IN VARCHAR2 ,--DEFAULT FND_API.G_FALSE ,
462: P_COMMIT IN VARCHAR2 ,--DEFAULT FND_API.G_FALSE ,
463: P_TASK_ID IN NUMBER ,
464: P_RESOURCE_TYPE_CODE IN VARCHAR2 ,
465: P_RESOURCE_ID IN NUMBER ,
466: P_ASSIGNMENT_STATUS_ID IN NUMBER ,
497: l_source_object_type_code varchar2(80);
498: l_return_status varchar2(1);
499: l_status_id number;
500: l_task_status_id number;
501: l_item_type varchar2(100) := FND_API.G_MISS_CHAR;
502: l_return_flag varchar2(1);
503:
504: BEGIN
505:
532: if l_status_id = l_task_status_id then
533: OPEN c_check_wfprocess;
534: FETCH c_check_wfprocess into l_item_type ;
535: CLOSE c_check_wfprocess;
536: if ( l_item_type = FND_API.G_MISS_CHAR
537: and l_source_object_type_code is not null )then
538: AMS_TASKS_WF.AmsStartWorkflow(
539: p_api_version => l_api_version,
540: p_task_id => l_task_id,
589: p_object_version_number IN NUMBER,
590: P_INIT_MSG_LIST IN VARCHAR2 ,--DEFAULT G_FALSE ,
591: P_COMMIT IN VARCHAR2 ,--DEFAULT G_FALSE ,
592: P_TASK_ASSIGNMENT_ID IN NUMBER ,
593: P_TASK_ID IN NUMBER ,--default fnd_api.g_miss_num ,
594: P_RESOURCE_TYPE_CODE IN VARCHAR2 ,--DEFAULT NULL,
595: P_RESOURCE_ID IN NUMBER,
596: P_ASSIGNMENT_STATUS_ID IN NUMBER,
597: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
628: -- Wrapper on JTF Workflow API
629:
630: PROCEDURE start_task_workflow (
631: p_api_version IN NUMBER,
632: p_init_msg_list IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
633: p_commit IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
634: p_task_id IN NUMBER,
635: p_old_assignee_code IN VARCHAR2 ,--DEFAULT NULL,
636: p_old_assignee_id IN NUMBER ,--DEFAULT NULL,
629:
630: PROCEDURE start_task_workflow (
631: p_api_version IN NUMBER,
632: p_init_msg_list IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
633: p_commit IN VARCHAR2 ,--DEFAULT fnd_api.g_false,
634: p_task_id IN NUMBER,
635: p_old_assignee_code IN VARCHAR2 ,--DEFAULT NULL,
636: p_old_assignee_id IN NUMBER ,--DEFAULT NULL,
637: p_new_assignee_code IN VARCHAR2 ,--DEFAULT NULL,