[Home] [Help]
21: p_task_assignment_id IN NUMBER,
22: x_return_status OUT NOCOPY VARCHAR2
23: )
24: IS
25: l_temp_fnd_end_date DATE := to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR');
26: l_actual_start_date DATE := NVL(p_actual_start_date,to_date('01-01-1900','dd-MM-RRRR'));
27: l_actual_end_date DATE := NVL(p_actual_end_date,to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR'));
28: v_count NUMBER := 0;
29: CURSOR C_TASK_ASSIGNMENT IS SELECT COUNT(TASK_ASSIGNMENT_ID)
23: )
24: IS
25: l_temp_fnd_end_date DATE := to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR');
26: l_actual_start_date DATE := NVL(p_actual_start_date,to_date('01-01-1900','dd-MM-RRRR'));
27: l_actual_end_date DATE := NVL(p_actual_end_date,to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR'));
28: v_count NUMBER := 0;
29: CURSOR C_TASK_ASSIGNMENT IS SELECT COUNT(TASK_ASSIGNMENT_ID)
30: FROM JTF_TASK_ALL_ASSIGNMENTS
31: WHERE TASK_ID = p_task_id
38: OR ( l_actual_end_date BETWEEN NVL(ACTUAL_START_DATE,to_date('01-01-1900','dd-MM-RRRR')) AND NVL(ACTUAL_END_DATE,l_temp_fnd_end_date))
39: OR ((l_actual_start_date > NVL(ACTUAL_START_DATE,to_date('01-01-1900','dd-MM-RRRR'))) AND l_actual_end_date < NVL(ACTUAL_END_DATE,l_temp_fnd_end_date)));
40: BEGIN
41:
42: x_return_status := fnd_api.g_ret_sts_success;
43:
44: OPEN C_TASK_ASSIGNMENT;
45: FETCH C_TASK_ASSIGNMENT INTO v_count;
46: CLOSE C_TASK_ASSIGNMENT;
45: FETCH C_TASK_ASSIGNMENT INTO v_count;
46: CLOSE C_TASK_ASSIGNMENT;
47:
48: IF( v_count > 0) THEN
49: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
50: END IF;
51: END;
52:
53: PROCEDURE populate_owner_booking_dates
196: END update_free_busy_type;
197:
198: PROCEDURE create_task_assignment (
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
201: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
202: p_task_assignment_id IN NUMBER DEFAULT NULL,
203: p_task_id IN NUMBER DEFAULT NULL,
204: p_resource_type_code IN VARCHAR2,
197:
198: PROCEDURE create_task_assignment (
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
201: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
202: p_task_assignment_id IN NUMBER DEFAULT NULL,
203: p_task_id IN NUMBER DEFAULT NULL,
204: p_resource_type_code IN VARCHAR2,
205: p_resource_id IN NUMBER,
259: := 1.0;
260: l_api_name CONSTANT VARCHAR(30)
261: := 'CREATE_TASK_ASSIGNMENTS';
262: l_return_status VARCHAR2(1)
263: := fnd_api.g_ret_sts_success;
264: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
265: l_task_id jtf_tasks_b.task_id%TYPE
266: := p_task_id;
267: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
361: x_event_return_status varchar2(100);
362: ------------------------------------------
363: BEGIN
364: SAVEPOINT create_task_assign_pvt;
365: x_return_status := fnd_api.g_ret_sts_success;
366:
367: ------------------------------------------
368: -- For XP
369: ------------------------------------------
374: CLOSE c_task;
375: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
376: fnd_message.set_token ('P_TASK_ID', l_task_id);
377: fnd_msg_pub.add;
378: x_return_status := fnd_api.g_ret_sts_unexp_error;
379: RAISE fnd_api.g_exc_unexpected_error;
380: END IF;
381: CLOSE c_task;
382:
375: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
376: fnd_message.set_token ('P_TASK_ID', l_task_id);
377: fnd_msg_pub.add;
378: x_return_status := fnd_api.g_ret_sts_unexp_error;
379: RAISE fnd_api.g_exc_unexpected_error;
380: END IF;
381: CLOSE c_task;
382:
383: IF rec_task.source_object_type_code = 'APPOINTMENT' AND
399: l_add_assignee_rec.abort_workflow := p_abort_workflow;
400:
401: jtf_task_repeat_assignment_pvt.add_assignee(
402: p_api_version => 1.0,
403: p_init_msg_list => fnd_api.g_false,
404: p_commit => fnd_api.g_false,
405: p_add_assignee_rec => l_add_assignee_rec,
406: x_return_status => x_return_status,
407: x_msg_count => x_msg_count,
400:
401: jtf_task_repeat_assignment_pvt.add_assignee(
402: p_api_version => 1.0,
403: p_init_msg_list => fnd_api.g_false,
404: p_commit => fnd_api.g_false,
405: p_add_assignee_rec => l_add_assignee_rec,
406: x_return_status => x_return_status,
407: x_msg_count => x_msg_count,
408: x_msg_data => x_msg_data,
416: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
417: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_add_option ');
418: fnd_msg_pub.add;
419:
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
423: END IF;
424: ------------------------------------------
417: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_add_option ');
418: fnd_msg_pub.add;
419:
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
423: END IF;
424: ------------------------------------------
425:
429: p_task_assignment_id < 1e+12
430: THEN
431: fnd_message.set_name ('JTF', 'JTF_TASK_OUT_OF_RANGE');
432: fnd_msg_pub.add;
433: x_return_status := fnd_api.g_ret_sts_unexp_error;
434: RAISE fnd_api.g_exc_unexpected_error;
435: ELSE
436: l_task_assignment_id := p_task_assignment_id;
437: END IF;
430: THEN
431: fnd_message.set_name ('JTF', 'JTF_TASK_OUT_OF_RANGE');
432: fnd_msg_pub.add;
433: x_return_status := fnd_api.g_ret_sts_unexp_error;
434: RAISE fnd_api.g_exc_unexpected_error;
435: ELSE
436: l_task_assignment_id := p_task_assignment_id;
437: END IF;
438: ELSE
453: 'JTF_TASK_ASSIGNEE_ROLES',
454: NVL (l_assignee_role, 'ASSIGNEE'),
455: 'assignment assignee role ( JTF_TK_ASSOGNEE_ROLE )')
456: THEN
457: x_return_status := fnd_api.g_ret_sts_unexp_error;
458: RAISE fnd_api.g_exc_unexpected_error;
459: END IF;
460:
461:
454: NVL (l_assignee_role, 'ASSIGNEE'),
455: 'assignment assignee role ( JTF_TK_ASSOGNEE_ROLE )')
456: THEN
457: x_return_status := fnd_api.g_ret_sts_unexp_error;
458: RAISE fnd_api.g_exc_unexpected_error;
459: END IF;
460:
461:
462: -- Implicit booking for tasks
508: p_task_assignment_id=>l_task_assignment_id,
509: x_return_status=>x_return_status
510: );
511:
512: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
513: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
514: fnd_message.set_name ('JTF', 'JTF_TASK_DUP_TK_ASS');
515: fnd_msg_pub.add;
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: x_return_status=>x_return_status
510: );
511:
512: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
513: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
514: fnd_message.set_name ('JTF', 'JTF_TASK_DUP_TK_ASS');
515: fnd_msg_pub.add;
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;
512: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
513: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
514: fnd_message.set_name ('JTF', 'JTF_TASK_DUP_TK_ASS');
515: fnd_msg_pub.add;
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;
518:
519: jtf_task_assignments_pkg.insert_row (
520: x_rowid => l_rowid,
579:
580: IF ra_cur1%NOTFOUND
581: THEN
582: CLOSE ra_cur1; -- Fix a missing CLOSE on 4/18/2002
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
585: fnd_msg_pub.add;
586: RAISE fnd_api.g_exc_unexpected_error;
587: ELSE
582: CLOSE ra_cur1; -- Fix a missing CLOSE on 4/18/2002
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
585: fnd_msg_pub.add;
586: RAISE fnd_api.g_exc_unexpected_error;
587: ELSE
588: x_task_assignment_id := l_task_assignment_id;
589: END IF;
590: CLOSE ra_cur1; -- Fix a missing CLOSE on 4/18/2002
620: THEN
621: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
622: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
623: fnd_msg_pub.add;
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625: RAISE fnd_api.g_exc_unexpected_error;
626: END IF ;
627:
628: END IF;
621: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
622: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
623: fnd_msg_pub.add;
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625: RAISE fnd_api.g_exc_unexpected_error;
626: END IF ;
627:
628: END IF;
629:
641: x_msg_count => x_msg_count,
642: x_msg_data => x_msg_data,
643: x_return_status => x_return_status);
644:
645: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
646: THEN
647: x_return_status := fnd_api.g_ret_sts_unexp_error;
648: RAISE fnd_api.g_exc_unexpected_error;
649: END IF;
643: x_return_status => x_return_status);
644:
645: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
646: THEN
647: x_return_status := fnd_api.g_ret_sts_unexp_error;
648: RAISE fnd_api.g_exc_unexpected_error;
649: END IF;
650:
651: END IF; -- for the if statement for (rec_task.source_object_type_code <> 'APPOINTMENT')
644:
645: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
646: THEN
647: x_return_status := fnd_api.g_ret_sts_unexp_error;
648: RAISE fnd_api.g_exc_unexpected_error;
649: END IF;
650:
651: END IF; -- for the if statement for (rec_task.source_object_type_code <> 'APPOINTMENT')
652:
651: END IF; -- for the if statement for (rec_task.source_object_type_code <> 'APPOINTMENT')
652:
653: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
654: EXCEPTION
655: WHEN fnd_api.g_exc_unexpected_error
656: THEN
657: ROLLBACK TO create_task_assign_pvt;
658: x_return_status := fnd_api.g_ret_sts_unexp_error;
659: fnd_msg_pub.count_and_get (
654: EXCEPTION
655: WHEN fnd_api.g_exc_unexpected_error
656: THEN
657: ROLLBACK TO create_task_assign_pvt;
658: x_return_status := fnd_api.g_ret_sts_unexp_error;
659: fnd_msg_pub.count_and_get (
660: p_count => x_msg_count,
661: p_data => x_msg_data
662: );
665: ROLLBACK TO create_task_assign_pvt;
666: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
667: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
668: fnd_msg_pub.add;
669: x_return_status := fnd_api.g_ret_sts_unexp_error;
670: fnd_msg_pub.count_and_get (
671: p_count => x_msg_count,
672: p_data => x_msg_data
673: );
674: END;
675:
676: PROCEDURE create_task_assignment (
677: p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
679: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
680: p_task_assignment_id IN NUMBER DEFAULT NULL,
681: p_task_id IN NUMBER DEFAULT NULL,
682: p_resource_type_code IN VARCHAR2,
675:
676: PROCEDURE create_task_assignment (
677: p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
679: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
680: p_task_assignment_id IN NUMBER DEFAULT NULL,
681: p_task_id IN NUMBER DEFAULT NULL,
682: p_resource_type_code IN VARCHAR2,
683: p_resource_id IN NUMBER,
796: END;
797:
798: PROCEDURE create_task_assignment (
799: p_api_version IN NUMBER,
800: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
801: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
802: p_task_assignment_id IN NUMBER DEFAULT NULL,
803: p_task_id IN NUMBER DEFAULT NULL,
804: p_resource_type_code IN VARCHAR2,
797:
798: PROCEDURE create_task_assignment (
799: p_api_version IN NUMBER,
800: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
801: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
802: p_task_assignment_id IN NUMBER DEFAULT NULL,
803: p_task_id IN NUMBER DEFAULT NULL,
804: p_resource_type_code IN VARCHAR2,
805: p_resource_id IN NUMBER,
916:
917:
918: PROCEDURE create_task_assignment (
919: p_api_version IN NUMBER,
920: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
921: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
922: p_task_assignment_id IN NUMBER DEFAULT NULL,
923: p_task_id IN NUMBER DEFAULT NULL,
924: p_resource_type_code IN VARCHAR2,
917:
918: PROCEDURE create_task_assignment (
919: p_api_version IN NUMBER,
920: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
921: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
922: p_task_assignment_id IN NUMBER DEFAULT NULL,
923: p_task_id IN NUMBER DEFAULT NULL,
924: p_resource_type_code IN VARCHAR2,
925: p_resource_id IN NUMBER,
1035: END;
1036:
1037: PROCEDURE create_task_assignment (
1038: p_api_version IN NUMBER,
1039: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1040: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1041: p_task_assignment_id IN NUMBER DEFAULT NULL,
1042: p_task_id IN NUMBER DEFAULT NULL,
1043: p_resource_type_code IN VARCHAR2,
1036:
1037: PROCEDURE create_task_assignment (
1038: p_api_version IN NUMBER,
1039: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1040: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1041: p_task_assignment_id IN NUMBER DEFAULT NULL,
1042: p_task_id IN NUMBER DEFAULT NULL,
1043: p_resource_type_code IN VARCHAR2,
1044: p_resource_id IN NUMBER,
1154: --Procedure to Update the Task Assignment
1155: PROCEDURE update_task_assignment (
1156: p_api_version IN NUMBER,
1157: p_object_version_number IN OUT NOCOPY NUMBER,
1158: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1159: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1160: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1161: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1162: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1155: PROCEDURE update_task_assignment (
1156: p_api_version IN NUMBER,
1157: p_object_version_number IN OUT NOCOPY NUMBER,
1158: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1159: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1160: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1161: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1162: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1163: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1156: p_api_version IN NUMBER,
1157: p_object_version_number IN OUT NOCOPY NUMBER,
1158: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1159: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1160: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1161: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1162: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1163: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1164: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1157: p_object_version_number IN OUT NOCOPY NUMBER,
1158: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1159: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1160: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1161: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1162: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1163: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1164: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1165: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1158: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1159: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1160: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1161: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1162: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1163: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1164: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1165: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1166: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1159: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1160: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1161: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1162: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1163: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1164: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1165: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1166: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1167: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1160: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1161: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1162: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1163: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1164: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1165: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1166: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1167: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1168: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1161: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1162: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1163: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1164: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1165: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1166: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1167: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1168: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1169: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1162: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1163: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1164: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1165: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1166: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1167: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1168: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1169: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1170: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1163: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1164: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1165: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1166: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1167: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1168: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1169: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1170: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1171: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1164: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1165: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1166: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1167: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1168: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1169: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1170: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1171: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1172: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1165: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1166: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1167: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1168: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1169: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1170: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1171: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1172: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1173: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1166: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1167: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1168: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1169: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1170: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1171: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1172: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1173: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1174: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1167: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1168: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1169: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1170: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1171: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1172: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1173: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1174: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1175: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1168: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1169: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1170: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1171: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1172: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1173: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1174: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1175: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1176: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1169: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1170: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1171: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1172: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1173: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1174: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1175: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1176: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1177: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1170: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1171: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1172: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1173: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1174: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1175: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1176: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1177: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1178: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1171: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1172: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1173: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1174: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1175: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1176: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1177: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1178: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1179: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1172: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1173: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1174: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1175: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1176: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1177: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1178: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1179: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1180: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1173: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1174: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1175: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1176: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1177: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1178: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1179: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1180: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1181: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1174: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1175: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1176: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1177: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1178: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1179: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1180: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1181: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1182: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1175: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1176: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1177: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1178: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1179: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1180: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1181: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1182: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1183: p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1176: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1177: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1178: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1179: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1180: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1181: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1182: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1183: p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1184: p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1177: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1178: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1179: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1180: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1181: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1182: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1183: p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1184: p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1185: x_return_status OUT NOCOPY VARCHAR2,
1178: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1179: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1180: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1181: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1182: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1183: p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1184: p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1185: x_return_status OUT NOCOPY VARCHAR2,
1186: x_msg_count OUT NOCOPY NUMBER,
1179: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1180: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1181: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1182: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1183: p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1184: p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1185: x_return_status OUT NOCOPY VARCHAR2,
1186: x_msg_count OUT NOCOPY NUMBER,
1187: x_msg_data OUT NOCOPY VARCHAR2,
1180: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1181: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1182: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1183: p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1184: p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1185: x_return_status OUT NOCOPY VARCHAR2,
1186: x_msg_count OUT NOCOPY NUMBER,
1187: x_msg_data OUT NOCOPY VARCHAR2,
1188: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1264: p_category_id => p_category_id,
1265: p_enable_workflow => p_enable_workflow,
1266: p_abort_workflow => p_abort_workflow,
1267: p_free_busy_type => p_free_busy_type,
1268: p_object_capacity_id => fnd_api.g_miss_num
1269: );
1270: END;
1271:
1272: --Procedure to Update the Task Assignment
1272: --Procedure to Update the Task Assignment
1273: PROCEDURE update_task_assignment (
1274: p_api_version IN NUMBER,
1275: p_object_version_number IN OUT NOCOPY NUMBER,
1276: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1277: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1278: p_task_assignment_id IN NUMBER
1279: DEFAULT fnd_api.g_miss_num,
1280: p_resource_type_code IN VARCHAR2
1273: PROCEDURE update_task_assignment (
1274: p_api_version IN NUMBER,
1275: p_object_version_number IN OUT NOCOPY NUMBER,
1276: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1277: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1278: p_task_assignment_id IN NUMBER
1279: DEFAULT fnd_api.g_miss_num,
1280: p_resource_type_code IN VARCHAR2
1281: DEFAULT fnd_api.g_miss_char,
1275: p_object_version_number IN OUT NOCOPY NUMBER,
1276: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1277: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1278: p_task_assignment_id IN NUMBER
1279: DEFAULT fnd_api.g_miss_num,
1280: p_resource_type_code IN VARCHAR2
1281: DEFAULT fnd_api.g_miss_char,
1282: p_resource_id IN NUMBER
1283: DEFAULT fnd_api.g_miss_num,
1277: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1278: p_task_assignment_id IN NUMBER
1279: DEFAULT fnd_api.g_miss_num,
1280: p_resource_type_code IN VARCHAR2
1281: DEFAULT fnd_api.g_miss_char,
1282: p_resource_id IN NUMBER
1283: DEFAULT fnd_api.g_miss_num,
1284: p_actual_effort IN NUMBER
1285: DEFAULT fnd_api.g_miss_num,
1279: DEFAULT fnd_api.g_miss_num,
1280: p_resource_type_code IN VARCHAR2
1281: DEFAULT fnd_api.g_miss_char,
1282: p_resource_id IN NUMBER
1283: DEFAULT fnd_api.g_miss_num,
1284: p_actual_effort IN NUMBER
1285: DEFAULT fnd_api.g_miss_num,
1286: p_actual_effort_uom IN VARCHAR2
1287: DEFAULT fnd_api.g_miss_char,
1281: DEFAULT fnd_api.g_miss_char,
1282: p_resource_id IN NUMBER
1283: DEFAULT fnd_api.g_miss_num,
1284: p_actual_effort IN NUMBER
1285: DEFAULT fnd_api.g_miss_num,
1286: p_actual_effort_uom IN VARCHAR2
1287: DEFAULT fnd_api.g_miss_char,
1288: p_schedule_flag IN VARCHAR2
1289: DEFAULT fnd_api.g_miss_char,
1283: DEFAULT fnd_api.g_miss_num,
1284: p_actual_effort IN NUMBER
1285: DEFAULT fnd_api.g_miss_num,
1286: p_actual_effort_uom IN VARCHAR2
1287: DEFAULT fnd_api.g_miss_char,
1288: p_schedule_flag IN VARCHAR2
1289: DEFAULT fnd_api.g_miss_char,
1290: p_alarm_type_code IN VARCHAR2
1291: DEFAULT fnd_api.g_miss_char,
1285: DEFAULT fnd_api.g_miss_num,
1286: p_actual_effort_uom IN VARCHAR2
1287: DEFAULT fnd_api.g_miss_char,
1288: p_schedule_flag IN VARCHAR2
1289: DEFAULT fnd_api.g_miss_char,
1290: p_alarm_type_code IN VARCHAR2
1291: DEFAULT fnd_api.g_miss_char,
1292: p_alarm_contact IN VARCHAR2
1293: DEFAULT fnd_api.g_miss_char,
1287: DEFAULT fnd_api.g_miss_char,
1288: p_schedule_flag IN VARCHAR2
1289: DEFAULT fnd_api.g_miss_char,
1290: p_alarm_type_code IN VARCHAR2
1291: DEFAULT fnd_api.g_miss_char,
1292: p_alarm_contact IN VARCHAR2
1293: DEFAULT fnd_api.g_miss_char,
1294: p_sched_travel_distance IN NUMBER
1295: DEFAULT fnd_api.g_miss_num,
1289: DEFAULT fnd_api.g_miss_char,
1290: p_alarm_type_code IN VARCHAR2
1291: DEFAULT fnd_api.g_miss_char,
1292: p_alarm_contact IN VARCHAR2
1293: DEFAULT fnd_api.g_miss_char,
1294: p_sched_travel_distance IN NUMBER
1295: DEFAULT fnd_api.g_miss_num,
1296: p_sched_travel_duration IN NUMBER
1297: DEFAULT fnd_api.g_miss_num,
1291: DEFAULT fnd_api.g_miss_char,
1292: p_alarm_contact IN VARCHAR2
1293: DEFAULT fnd_api.g_miss_char,
1294: p_sched_travel_distance IN NUMBER
1295: DEFAULT fnd_api.g_miss_num,
1296: p_sched_travel_duration IN NUMBER
1297: DEFAULT fnd_api.g_miss_num,
1298: p_sched_travel_duration_uom IN VARCHAR2
1299: DEFAULT fnd_api.g_miss_char,
1293: DEFAULT fnd_api.g_miss_char,
1294: p_sched_travel_distance IN NUMBER
1295: DEFAULT fnd_api.g_miss_num,
1296: p_sched_travel_duration IN NUMBER
1297: DEFAULT fnd_api.g_miss_num,
1298: p_sched_travel_duration_uom IN VARCHAR2
1299: DEFAULT fnd_api.g_miss_char,
1300: p_actual_travel_distance IN NUMBER
1301: DEFAULT fnd_api.g_miss_num,
1295: DEFAULT fnd_api.g_miss_num,
1296: p_sched_travel_duration IN NUMBER
1297: DEFAULT fnd_api.g_miss_num,
1298: p_sched_travel_duration_uom IN VARCHAR2
1299: DEFAULT fnd_api.g_miss_char,
1300: p_actual_travel_distance IN NUMBER
1301: DEFAULT fnd_api.g_miss_num,
1302: p_actual_travel_duration IN NUMBER
1303: DEFAULT fnd_api.g_miss_num,
1297: DEFAULT fnd_api.g_miss_num,
1298: p_sched_travel_duration_uom IN VARCHAR2
1299: DEFAULT fnd_api.g_miss_char,
1300: p_actual_travel_distance IN NUMBER
1301: DEFAULT fnd_api.g_miss_num,
1302: p_actual_travel_duration IN NUMBER
1303: DEFAULT fnd_api.g_miss_num,
1304: p_actual_travel_duration_uom IN VARCHAR2
1305: DEFAULT fnd_api.g_miss_char,
1299: DEFAULT fnd_api.g_miss_char,
1300: p_actual_travel_distance IN NUMBER
1301: DEFAULT fnd_api.g_miss_num,
1302: p_actual_travel_duration IN NUMBER
1303: DEFAULT fnd_api.g_miss_num,
1304: p_actual_travel_duration_uom IN VARCHAR2
1305: DEFAULT fnd_api.g_miss_char,
1306: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1307: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1301: DEFAULT fnd_api.g_miss_num,
1302: p_actual_travel_duration IN NUMBER
1303: DEFAULT fnd_api.g_miss_num,
1304: p_actual_travel_duration_uom IN VARCHAR2
1305: DEFAULT fnd_api.g_miss_char,
1306: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1307: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1308: p_palm_flag IN VARCHAR2
1309: DEFAULT fnd_api.g_miss_char,
1302: p_actual_travel_duration IN NUMBER
1303: DEFAULT fnd_api.g_miss_num,
1304: p_actual_travel_duration_uom IN VARCHAR2
1305: DEFAULT fnd_api.g_miss_char,
1306: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1307: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1308: p_palm_flag IN VARCHAR2
1309: DEFAULT fnd_api.g_miss_char,
1310: p_wince_flag IN VARCHAR2
1303: DEFAULT fnd_api.g_miss_num,
1304: p_actual_travel_duration_uom IN VARCHAR2
1305: DEFAULT fnd_api.g_miss_char,
1306: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1307: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1308: p_palm_flag IN VARCHAR2
1309: DEFAULT fnd_api.g_miss_char,
1310: p_wince_flag IN VARCHAR2
1311: DEFAULT fnd_api.g_miss_char,
1305: DEFAULT fnd_api.g_miss_char,
1306: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1307: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1308: p_palm_flag IN VARCHAR2
1309: DEFAULT fnd_api.g_miss_char,
1310: p_wince_flag IN VARCHAR2
1311: DEFAULT fnd_api.g_miss_char,
1312: p_laptop_flag IN VARCHAR2
1313: DEFAULT fnd_api.g_miss_char,
1307: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1308: p_palm_flag IN VARCHAR2
1309: DEFAULT fnd_api.g_miss_char,
1310: p_wince_flag IN VARCHAR2
1311: DEFAULT fnd_api.g_miss_char,
1312: p_laptop_flag IN VARCHAR2
1313: DEFAULT fnd_api.g_miss_char,
1314: p_device1_flag IN VARCHAR2
1315: DEFAULT fnd_api.g_miss_char,
1309: DEFAULT fnd_api.g_miss_char,
1310: p_wince_flag IN VARCHAR2
1311: DEFAULT fnd_api.g_miss_char,
1312: p_laptop_flag IN VARCHAR2
1313: DEFAULT fnd_api.g_miss_char,
1314: p_device1_flag IN VARCHAR2
1315: DEFAULT fnd_api.g_miss_char,
1316: p_device2_flag IN VARCHAR2
1317: DEFAULT fnd_api.g_miss_char,
1311: DEFAULT fnd_api.g_miss_char,
1312: p_laptop_flag IN VARCHAR2
1313: DEFAULT fnd_api.g_miss_char,
1314: p_device1_flag IN VARCHAR2
1315: DEFAULT fnd_api.g_miss_char,
1316: p_device2_flag IN VARCHAR2
1317: DEFAULT fnd_api.g_miss_char,
1318: p_device3_flag IN VARCHAR2
1319: DEFAULT fnd_api.g_miss_char,
1313: DEFAULT fnd_api.g_miss_char,
1314: p_device1_flag IN VARCHAR2
1315: DEFAULT fnd_api.g_miss_char,
1316: p_device2_flag IN VARCHAR2
1317: DEFAULT fnd_api.g_miss_char,
1318: p_device3_flag IN VARCHAR2
1319: DEFAULT fnd_api.g_miss_char,
1320: p_resource_territory_id IN NUMBER
1321: DEFAULT fnd_api.g_miss_num,
1315: DEFAULT fnd_api.g_miss_char,
1316: p_device2_flag IN VARCHAR2
1317: DEFAULT fnd_api.g_miss_char,
1318: p_device3_flag IN VARCHAR2
1319: DEFAULT fnd_api.g_miss_char,
1320: p_resource_territory_id IN NUMBER
1321: DEFAULT fnd_api.g_miss_num,
1322: p_assignment_status_id IN NUMBER
1323: DEFAULT fnd_api.g_miss_num,
1317: DEFAULT fnd_api.g_miss_char,
1318: p_device3_flag IN VARCHAR2
1319: DEFAULT fnd_api.g_miss_char,
1320: p_resource_territory_id IN NUMBER
1321: DEFAULT fnd_api.g_miss_num,
1322: p_assignment_status_id IN NUMBER
1323: DEFAULT fnd_api.g_miss_num,
1324: p_shift_construct_id IN NUMBER
1325: DEFAULT fnd_api.g_miss_num,
1319: DEFAULT fnd_api.g_miss_char,
1320: p_resource_territory_id IN NUMBER
1321: DEFAULT fnd_api.g_miss_num,
1322: p_assignment_status_id IN NUMBER
1323: DEFAULT fnd_api.g_miss_num,
1324: p_shift_construct_id IN NUMBER
1325: DEFAULT fnd_api.g_miss_num,
1326: x_return_status OUT NOCOPY VARCHAR2,
1327: x_msg_count OUT NOCOPY NUMBER,
1321: DEFAULT fnd_api.g_miss_num,
1322: p_assignment_status_id IN NUMBER
1323: DEFAULT fnd_api.g_miss_num,
1324: p_shift_construct_id IN NUMBER
1325: DEFAULT fnd_api.g_miss_num,
1326: x_return_status OUT NOCOPY VARCHAR2,
1327: x_msg_count OUT NOCOPY NUMBER,
1328: x_msg_data OUT NOCOPY VARCHAR2,
1329: p_attribute1 IN VARCHAR2
1374: := 1.0;
1375: l_api_name CONSTANT VARCHAR(30)
1376: := 'Update_Task_Assignment';
1377: l_return_status VARCHAR2(1)
1378: := fnd_api.g_ret_sts_success;
1379: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
1380: := p_task_assignment_id;
1381: l_task_id jtf_task_all_assignments.task_id%TYPE;
1382: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1456: SELECT task_id,
1457: assignment_status_id old_assignment_status_id,
1458: DECODE (
1459: p_resource_id,
1460: fnd_api.g_miss_num, resource_id,
1461: p_resource_id
1462: ) resource_id,
1463: DECODE (
1464: p_resource_type_code,
1461: p_resource_id
1462: ) resource_id,
1463: DECODE (
1464: p_resource_type_code,
1465: fnd_api.g_miss_char, resource_type_code,
1466: p_resource_type_code
1467: ) resource_type_code,
1468: DECODE (
1469: p_assignment_status_id,
1466: p_resource_type_code
1467: ) resource_type_code,
1468: DECODE (
1469: p_assignment_status_id,
1470: fnd_api.g_miss_num, assignment_status_id,
1471: p_assignment_status_id
1472: ) assignment_status_id,
1473: DECODE (
1474: p_actual_effort,
1471: p_assignment_status_id
1472: ) assignment_status_id,
1473: DECODE (
1474: p_actual_effort,
1475: fnd_api.g_miss_num, actual_effort,
1476: p_actual_effort
1477: ) actual_effort,
1478: DECODE (
1479: p_actual_effort_uom,
1476: p_actual_effort
1477: ) actual_effort,
1478: DECODE (
1479: p_actual_effort_uom,
1480: fnd_api.g_miss_char, actual_effort_uom,
1481: p_actual_effort_uom
1482: ) actual_effort_uom,
1483: DECODE (
1484: p_alarm_type_code,
1481: p_actual_effort_uom
1482: ) actual_effort_uom,
1483: DECODE (
1484: p_alarm_type_code,
1485: fnd_api.g_miss_char, alarm_type_code,
1486: p_alarm_type_code
1487: ) alarm_type_code,
1488: DECODE (
1489: p_alarm_contact,
1486: p_alarm_type_code
1487: ) alarm_type_code,
1488: DECODE (
1489: p_alarm_contact,
1490: fnd_api.g_miss_char, alarm_contact,
1491: p_alarm_contact
1492: ) alarm_contact,
1493: DECODE (
1494: p_sched_travel_distance,
1491: p_alarm_contact
1492: ) alarm_contact,
1493: DECODE (
1494: p_sched_travel_distance,
1495: fnd_api.g_miss_num, sched_travel_distance,
1496: p_sched_travel_distance
1497: ) sched_travel_distance,
1498: DECODE (
1499: p_sched_travel_duration,
1496: p_sched_travel_distance
1497: ) sched_travel_distance,
1498: DECODE (
1499: p_sched_travel_duration,
1500: fnd_api.g_miss_num, sched_travel_duration,
1501: p_sched_travel_duration
1502: ) sched_travel_duration,
1503: DECODE (
1504: p_sched_travel_duration_uom,
1501: p_sched_travel_duration
1502: ) sched_travel_duration,
1503: DECODE (
1504: p_sched_travel_duration_uom,
1505: fnd_api.g_miss_char, sched_travel_duration_uom,
1506: p_sched_travel_duration_uom
1507: ) sched_travel_dur_uom,
1508: DECODE (
1509: p_actual_travel_distance,
1506: p_sched_travel_duration_uom
1507: ) sched_travel_dur_uom,
1508: DECODE (
1509: p_actual_travel_distance,
1510: fnd_api.g_miss_num, actual_travel_distance,
1511: p_actual_travel_distance
1512: ) actual_travel_distance,
1513: DECODE (
1514: p_actual_travel_duration,
1511: p_actual_travel_distance
1512: ) actual_travel_distance,
1513: DECODE (
1514: p_actual_travel_duration,
1515: fnd_api.g_miss_num, actual_travel_duration,
1516: p_actual_travel_duration
1517: ) actual_travel_duration,
1518: DECODE (
1519: p_resource_territory_id,
1516: p_actual_travel_duration
1517: ) actual_travel_duration,
1518: DECODE (
1519: p_resource_territory_id,
1520: fnd_api.g_miss_num, resource_territory_id,
1521: p_resource_territory_id
1522: ) resource_territory_id,
1523: DECODE (
1524: p_shift_construct_id,
1521: p_resource_territory_id
1522: ) resource_territory_id,
1523: DECODE (
1524: p_shift_construct_id,
1525: fnd_api.g_miss_num, shift_construct_id,
1526: p_shift_construct_id
1527: ) shift_construct_id,
1528: DECODE (
1529: p_actual_travel_duration_uom,
1526: p_shift_construct_id
1527: ) shift_construct_id,
1528: DECODE (
1529: p_actual_travel_duration_uom,
1530: fnd_api.g_miss_char, actual_travel_duration_uom,
1531: p_actual_travel_duration_uom
1532: ) actual_travel_dur_uom,
1533: DECODE (
1534: p_schedule_flag,
1531: p_actual_travel_duration_uom
1532: ) actual_travel_dur_uom,
1533: DECODE (
1534: p_schedule_flag,
1535: fnd_api.g_miss_char, schedule_flag,
1536: p_schedule_flag
1537: ) schedule_flag,
1538: DECODE (
1539: p_actual_start_date,
1536: p_schedule_flag
1537: ) schedule_flag,
1538: DECODE (
1539: p_actual_start_date,
1540: fnd_api.g_miss_date, actual_start_date,
1541: p_actual_start_date
1542: ) actual_start_date,
1543: DECODE (
1544: p_actual_end_date,
1541: p_actual_start_date
1542: ) actual_start_date,
1543: DECODE (
1544: p_actual_end_date,
1545: fnd_api.g_miss_date, actual_end_date,
1546: p_actual_end_date
1547: ) actual_end_date,
1548: DECODE (
1549: p_palm_flag,
1546: p_actual_end_date
1547: ) actual_end_date,
1548: DECODE (
1549: p_palm_flag,
1550: fnd_api.g_miss_char, palm_flag,
1551: p_palm_flag
1552: ) palm_flag,
1553: DECODE (
1554: p_wince_flag,
1551: p_palm_flag
1552: ) palm_flag,
1553: DECODE (
1554: p_wince_flag,
1555: fnd_api.g_miss_char, wince_flag,
1556: p_wince_flag
1557: ) wince_flag,
1558: DECODE (
1559: p_laptop_flag,
1556: p_wince_flag
1557: ) wince_flag,
1558: DECODE (
1559: p_laptop_flag,
1560: fnd_api.g_miss_char, laptop_flag,
1561: p_laptop_flag
1562: ) laptop_flag,
1563: DECODE (
1564: p_device1_flag,
1561: p_laptop_flag
1562: ) laptop_flag,
1563: DECODE (
1564: p_device1_flag,
1565: fnd_api.g_miss_char, device1_flag,
1566: p_device1_flag
1567: ) device1_flag,
1568: DECODE (
1569: p_device2_flag,
1566: p_device1_flag
1567: ) device1_flag,
1568: DECODE (
1569: p_device2_flag,
1570: fnd_api.g_miss_char, device2_flag,
1571: p_device2_flag
1572: ) device2_flag,
1573: DECODE (
1574: p_device3_flag,
1571: p_device2_flag
1572: ) device2_flag,
1573: DECODE (
1574: p_device3_flag,
1575: fnd_api.g_miss_char, device3_flag,
1576: p_device3_flag
1577: ) device3_flag,
1578: DECODE (
1579: p_assignee_role,
1576: p_device3_flag
1577: ) device3_flag,
1578: DECODE (
1579: p_assignee_role,
1580: fnd_api.g_miss_char, assignee_role,
1581: p_assignee_role
1582: ) assignee_role,
1583: DECODE (
1584: p_show_on_calendar,
1581: p_assignee_role
1582: ) assignee_role,
1583: DECODE (
1584: p_show_on_calendar,
1585: fnd_api.g_miss_char, show_on_calendar,
1586: p_show_on_calendar
1587: ) show_on_calendar,
1588: DECODE (
1589: p_category_id,
1591: p_category_id
1592: ) category_id,
1593: DECODE (
1594: p_attribute1,
1595: fnd_api.g_miss_char, attribute1,
1596: p_attribute1
1597: ) attribute1,
1598: DECODE (
1599: p_attribute2,
1596: p_attribute1
1597: ) attribute1,
1598: DECODE (
1599: p_attribute2,
1600: fnd_api.g_miss_char, attribute2,
1601: p_attribute2
1602: ) attribute2,
1603: DECODE (
1604: p_attribute3,
1601: p_attribute2
1602: ) attribute2,
1603: DECODE (
1604: p_attribute3,
1605: fnd_api.g_miss_char, attribute3,
1606: p_attribute3
1607: ) attribute3,
1608: DECODE (
1609: p_attribute4,
1606: p_attribute3
1607: ) attribute3,
1608: DECODE (
1609: p_attribute4,
1610: fnd_api.g_miss_char, attribute4,
1611: p_attribute4
1612: ) attribute4,
1613: DECODE (
1614: p_attribute5,
1611: p_attribute4
1612: ) attribute4,
1613: DECODE (
1614: p_attribute5,
1615: fnd_api.g_miss_char, attribute5,
1616: p_attribute5
1617: ) attribute5,
1618: DECODE (
1619: p_attribute6,
1616: p_attribute5
1617: ) attribute5,
1618: DECODE (
1619: p_attribute6,
1620: fnd_api.g_miss_char, attribute6,
1621: p_attribute6
1622: ) attribute6,
1623: DECODE (
1624: p_attribute7,
1621: p_attribute6
1622: ) attribute6,
1623: DECODE (
1624: p_attribute7,
1625: fnd_api.g_miss_char, attribute7,
1626: p_attribute7
1627: ) attribute7,
1628: DECODE (
1629: p_attribute8,
1626: p_attribute7
1627: ) attribute7,
1628: DECODE (
1629: p_attribute8,
1630: fnd_api.g_miss_char, attribute8,
1631: p_attribute8
1632: ) attribute8,
1633: DECODE (
1634: p_attribute9,
1631: p_attribute8
1632: ) attribute8,
1633: DECODE (
1634: p_attribute9,
1635: fnd_api.g_miss_char, attribute9,
1636: p_attribute9
1637: ) attribute9,
1638: DECODE (
1639: p_attribute10,
1636: p_attribute9
1637: ) attribute9,
1638: DECODE (
1639: p_attribute10,
1640: fnd_api.g_miss_char, attribute10,
1641: p_attribute10
1642: ) attribute10,
1643: DECODE (
1644: p_attribute11,
1641: p_attribute10
1642: ) attribute10,
1643: DECODE (
1644: p_attribute11,
1645: fnd_api.g_miss_char, attribute11,
1646: p_attribute11
1647: ) attribute11,
1648: DECODE (
1649: p_attribute12,
1646: p_attribute11
1647: ) attribute11,
1648: DECODE (
1649: p_attribute12,
1650: fnd_api.g_miss_char, attribute12,
1651: p_attribute12
1652: ) attribute12,
1653: DECODE (
1654: p_attribute13,
1651: p_attribute12
1652: ) attribute12,
1653: DECODE (
1654: p_attribute13,
1655: fnd_api.g_miss_char, attribute13,
1656: p_attribute13
1657: ) attribute13,
1658: DECODE (
1659: p_attribute14,
1656: p_attribute13
1657: ) attribute13,
1658: DECODE (
1659: p_attribute14,
1660: fnd_api.g_miss_char, attribute14,
1661: p_attribute14
1662: ) attribute14,
1663: DECODE (
1664: p_attribute15,
1661: p_attribute14
1662: ) attribute14,
1663: DECODE (
1664: p_attribute15,
1665: fnd_api.g_miss_char, attribute15,
1666: p_attribute15
1667: ) attribute15,
1668: DECODE (
1669: p_attribute_category,
1666: p_attribute15
1667: ) attribute15,
1668: DECODE (
1669: p_attribute_category,
1670: fnd_api.g_miss_char, attribute_category,
1671: p_attribute_category
1672: ) attribute_category,
1673: DECODE (
1674: p_free_busy_type,
1676: p_free_busy_type
1677: ) free_busy_type,
1678: DECODE (
1679: p_object_capacity_id,
1680: fnd_api.g_miss_num, object_capacity_id,
1681: p_object_capacity_id
1682: ) object_capacity_id
1683: FROM jtf_task_all_assignments
1684: WHERE task_assignment_id = l_task_assignment_id;
1724: l_open_flag jtf_tasks_b.open_flag%TYPE;
1725: l_response_invitation_rec jtf_task_repeat_assignment_pvt.response_invitation_rec;
1726: BEGIN
1727: SAVEPOINT update_task_assign_pvt;
1728: x_return_status := fnd_api.g_ret_sts_success;
1729:
1730: OPEN task_ass_u;
1731: FETCH task_ass_u INTO task_ass;
1732:
1735: CLOSE task_ass_u;
1736: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1737: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1738: fnd_msg_pub.add;
1739: x_return_status := fnd_api.g_ret_sts_unexp_error;
1740: RAISE fnd_api.g_exc_unexpected_error;
1741: END IF;
1742: CLOSE task_ass_u;
1743:
1736: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1737: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1738: fnd_msg_pub.add;
1739: x_return_status := fnd_api.g_ret_sts_unexp_error;
1740: RAISE fnd_api.g_exc_unexpected_error;
1741: END IF;
1742: CLOSE task_ass_u;
1743:
1744: -- Business Event System Enhancement # 2391065
1750: CLOSE jtf_task_utl.c_ass_orig;
1751: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1752: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1753: fnd_msg_pub.add;
1754: x_return_status := fnd_api.g_ret_sts_unexp_error;
1755: RAISE fnd_api.g_exc_unexpected_error;
1756: END IF;
1757: CLOSE jtf_task_utl.c_ass_orig;
1758:
1751: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1752: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1753: fnd_msg_pub.add;
1754: x_return_status := fnd_api.g_ret_sts_unexp_error;
1755: RAISE fnd_api.g_exc_unexpected_error;
1756: END IF;
1757: CLOSE jtf_task_utl.c_ass_orig;
1758:
1759: l_task_assignment_id := p_task_assignment_id;
1810: CLOSE c_task;
1811: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
1812: fnd_message.set_token ('P_TASK_ID', l_task_id);
1813: fnd_msg_pub.add;
1814: x_return_status := fnd_api.g_ret_sts_unexp_error;
1815: RAISE fnd_api.g_exc_unexpected_error;
1816: END IF;
1817: CLOSE c_task;
1818:
1811: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
1812: fnd_message.set_token ('P_TASK_ID', l_task_id);
1813: fnd_msg_pub.add;
1814: x_return_status := fnd_api.g_ret_sts_unexp_error;
1815: RAISE fnd_api.g_exc_unexpected_error;
1816: END IF;
1817: CLOSE c_task;
1818:
1819: IF l_recurrence_rule_id IS NOT NULL AND
1828: l_response_invitation_rec.recurrence_rule_id := l_recurrence_rule_id;
1829:
1830: jtf_task_repeat_assignment_pvt.response_invitation(
1831: p_api_version => 1.0,
1832: p_init_msg_list => fnd_api.g_false,
1833: p_commit => fnd_api.g_false,
1834: p_object_version_number => p_object_version_number,
1835: p_response_invitation_rec => l_response_invitation_rec,
1836: x_return_status => x_return_status,
1829:
1830: jtf_task_repeat_assignment_pvt.response_invitation(
1831: p_api_version => 1.0,
1832: p_init_msg_list => fnd_api.g_false,
1833: p_commit => fnd_api.g_false,
1834: p_object_version_number => p_object_version_number,
1835: p_response_invitation_rec => l_response_invitation_rec,
1836: x_return_status => x_return_status,
1837: x_msg_count => x_msg_count,
1853: ------------------------------------------------------------------------
1854:
1855: jtf_task_assignments_pub.lock_task_assignment (
1856: p_api_version => 1.0,
1857: p_init_msg_list => fnd_api.g_false,
1858: p_commit => fnd_api.g_false,
1859: p_task_assignment_id => l_task_assignment_id,
1860: p_object_version_number => p_object_version_number,
1861: x_return_status => x_return_status,
1854:
1855: jtf_task_assignments_pub.lock_task_assignment (
1856: p_api_version => 1.0,
1857: p_init_msg_list => fnd_api.g_false,
1858: p_commit => fnd_api.g_false,
1859: p_task_assignment_id => l_task_assignment_id,
1860: p_object_version_number => p_object_version_number,
1861: x_return_status => x_return_status,
1862: x_msg_data => x_msg_data,
1862: x_msg_data => x_msg_data,
1863: x_msg_count => x_msg_count
1864: );
1865:
1866: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1867: THEN
1868: x_return_status := fnd_api.g_ret_sts_unexp_error;
1869: RAISE fnd_api.g_exc_unexpected_error;
1870: END IF;
1864: );
1865:
1866: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1867: THEN
1868: x_return_status := fnd_api.g_ret_sts_unexp_error;
1869: RAISE fnd_api.g_exc_unexpected_error;
1870: END IF;
1871:
1872:
1865:
1866: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1867: THEN
1868: x_return_status := fnd_api.g_ret_sts_unexp_error;
1869: RAISE fnd_api.g_exc_unexpected_error;
1870: END IF;
1871:
1872:
1873: -- Validate the user_id
1876: p_session => l_session,
1877: x_return_status => x_return_status
1878: );
1879:
1880: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1881: THEN
1882: x_return_status := fnd_api.g_ret_sts_unexp_error;
1883: RAISE fnd_api.g_exc_unexpected_error;
1884: END IF;
1878: );
1879:
1880: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1881: THEN
1882: x_return_status := fnd_api.g_ret_sts_unexp_error;
1883: RAISE fnd_api.g_exc_unexpected_error;
1884: END IF;
1885:
1886: --Bug 2467222 for assignee category update
1879:
1880: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1881: THEN
1882: x_return_status := fnd_api.g_ret_sts_unexp_error;
1883: RAISE fnd_api.g_exc_unexpected_error;
1884: END IF;
1885:
1886: --Bug 2467222 for assignee category update
1887: IF (p_category_id <> jtf_task_utl.g_miss_number) OR (p_category_id IS NULL)
1914: l_assignee_role,
1915: 'assignment assignee role ( JTF_TK_ASSOGNEE_ROLE )'
1916: )
1917: THEN
1918: x_return_status := fnd_api.g_ret_sts_unexp_error;
1919: RAISE fnd_api.g_exc_unexpected_error;
1920: END IF;
1921:
1922: -- Update the values based on ASSIGNEE_ROLE
1915: 'assignment assignee role ( JTF_TK_ASSOGNEE_ROLE )'
1916: )
1917: THEN
1918: x_return_status := fnd_api.g_ret_sts_unexp_error;
1919: RAISE fnd_api.g_exc_unexpected_error;
1920: END IF;
1921:
1922: -- Update the values based on ASSIGNEE_ROLE
1923: select assignee_role
1941:
1942: -- OPEN ass_res_orig (l_task_assignment_id);
1943: -- FETCH ass_res_orig INTO l_orig_res_id, l_orig_res_type_code, l_orig_free_busy_type, l_orig_assig_status_id, l_object_capacity_id;
1944:
1945: -- IF (p_object_capacity_id <> fnd_api.g_miss_num and p_object_capacity_id is not null)
1946: -- then
1947: -- l_object_capacity_id := p_object_capacity_id;
1948: -- end if;
1949:
1949:
1950: -- IF ass_res_orig%NOTFOUND
1951: -- THEN
1952: -- CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
1953: -- RAISE fnd_api.g_exc_unexpected_error;
1954: -- END IF;
1955: -- CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
1956:
1957: -- Booking Changes for Simplex ..
1972: );
1973:
1974: IF l_entity = 'TASK' AND
1975: p_free_busy_type = jtf_task_utl.g_miss_char AND -- no explicit value
1976: nvl(p_assignment_status_id, 0) <> fnd_api.g_miss_num AND
1977: nvl(l_old_assignment_status_id, 0) <> nvl(l_assignment_status_id, 0) -- Modified for bug# 5514013 on 11/09/2006
1978: THEN
1979: update_free_busy_type(
1980: p_assignment_status_id => l_assignment_status_id,
1992: p_task_assignment_id=>l_task_assignment_id,
1993: x_return_status=>x_return_status
1994: );
1995:
1996: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1997: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1998: fnd_message.set_name ('JTF', 'JTF_TASK_DUP_TK_ASS');
1999: fnd_msg_pub.add;
2000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1993: x_return_status=>x_return_status
1994: );
1995:
1996: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1997: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1998: fnd_message.set_name ('JTF', 'JTF_TASK_DUP_TK_ASS');
1999: fnd_msg_pub.add;
2000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2001: END IF;
1996: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1997: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1998: fnd_message.set_name ('JTF', 'JTF_TASK_DUP_TK_ASS');
1999: fnd_msg_pub.add;
2000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2001: END IF;
2002:
2003: p_object_version_number := p_object_version_number + 1;
2004: jtf_task_assignments_pkg.update_row (
2064:
2065: -- ------------------------------------------------------------------------
2066: -- Update reference to resource if changed, fix enh #1845501
2067: -- ------------------------------------------------------------------------
2068: if (nvl(l_resource_id, 0) <> fnd_api.g_miss_num and
2069: nvl(l_resource_id, 0) <> nvl(l_orig_res_id, 0))
2070: or (nvl(l_resource_type_code, fnd_api.g_miss_char) <> nvl(l_orig_res_type_code, fnd_api.g_miss_char)) then
2071: -- delete the old one
2072: jtf_task_utl.delete_party_reference(
2066: -- Update reference to resource if changed, fix enh #1845501
2067: -- ------------------------------------------------------------------------
2068: if (nvl(l_resource_id, 0) <> fnd_api.g_miss_num and
2069: nvl(l_resource_id, 0) <> nvl(l_orig_res_id, 0))
2070: or (nvl(l_resource_type_code, fnd_api.g_miss_char) <> nvl(l_orig_res_type_code, fnd_api.g_miss_char)) then
2071: -- delete the old one
2072: jtf_task_utl.delete_party_reference(
2073: p_reference_from => 'ASSIGNMENT',
2074: p_task_id => l_task_id,
2077: x_msg_count => x_msg_count,
2078: x_msg_data => x_msg_data,
2079: x_return_status => x_return_status);
2080:
2081: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2082: THEN
2083: x_return_status := fnd_api.g_ret_sts_unexp_error;
2084: RAISE fnd_api.g_exc_unexpected_error;
2085: END IF;
2079: x_return_status => x_return_status);
2080:
2081: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2082: THEN
2083: x_return_status := fnd_api.g_ret_sts_unexp_error;
2084: RAISE fnd_api.g_exc_unexpected_error;
2085: END IF;
2086: -- create a new one
2087: jtf_task_utl.create_party_reference(
2080:
2081: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2082: THEN
2083: x_return_status := fnd_api.g_ret_sts_unexp_error;
2084: RAISE fnd_api.g_exc_unexpected_error;
2085: END IF;
2086: -- create a new one
2087: jtf_task_utl.create_party_reference(
2088: p_reference_from => 'ASSIGNMENT',
2092: x_msg_count => x_msg_count,
2093: x_msg_data => x_msg_data,
2094: x_return_status => x_return_status);
2095:
2096: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2097: THEN
2098: x_return_status := fnd_api.g_ret_sts_unexp_error;
2099: RAISE fnd_api.g_exc_unexpected_error;
2100: END IF;
2094: x_return_status => x_return_status);
2095:
2096: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2097: THEN
2098: x_return_status := fnd_api.g_ret_sts_unexp_error;
2099: RAISE fnd_api.g_exc_unexpected_error;
2100: END IF;
2101: end if;
2102:
2095:
2096: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2097: THEN
2098: x_return_status := fnd_api.g_ret_sts_unexp_error;
2099: RAISE fnd_api.g_exc_unexpected_error;
2100: END IF;
2101: end if;
2102:
2103: ---
2145: THEN
2146: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2147: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2148: fnd_msg_pub.add;
2149: x_return_status := fnd_api.g_ret_sts_unexp_error;
2150: RAISE fnd_api.g_exc_unexpected_error;
2151: END IF ;
2152:
2153: END IF;
2146: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2147: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2148: fnd_msg_pub.add;
2149: x_return_status := fnd_api.g_ret_sts_unexp_error;
2150: RAISE fnd_api.g_exc_unexpected_error;
2151: END IF ;
2152:
2153: END IF;
2154:
2156: -- THEN
2157: -- CLOSE ass_res_orig;
2158: -- END IF;
2159:
2160: IF fnd_api.to_boolean (p_commit)
2161: THEN
2162: COMMIT WORK;
2163: END IF;
2164:
2163: END IF;
2164:
2165: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2166: EXCEPTION
2167: WHEN fnd_api.g_exc_unexpected_error
2168: THEN
2169: IF task_ass_u%ISOPEN
2170: THEN
2171: CLOSE task_ass_u;
2171: CLOSE task_ass_u;
2172: END IF;
2173:
2174: ROLLBACK TO update_task_assign_pvt;
2175: x_return_status := fnd_api.g_ret_sts_unexp_error;
2176: fnd_msg_pub.count_and_get (
2177: p_count => x_msg_count,
2178: p_data => x_msg_data
2179: );
2190: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2191: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2192: fnd_msg_pub.add;
2193:
2194: x_return_status := fnd_api.g_ret_sts_unexp_error;
2195: fnd_msg_pub.count_and_get (
2196: p_count => x_msg_count,
2197: p_data => x_msg_data
2198: );
2200:
2201: PROCEDURE update_task_assignment (
2202: p_api_version IN NUMBER,
2203: p_object_version_number IN OUT NOCOPY NUMBER,
2204: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2205: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2206: p_task_assignment_id IN NUMBER
2207: DEFAULT fnd_api.g_miss_num,
2208: p_resource_type_code IN VARCHAR2
2201: PROCEDURE update_task_assignment (
2202: p_api_version IN NUMBER,
2203: p_object_version_number IN OUT NOCOPY NUMBER,
2204: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2205: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2206: p_task_assignment_id IN NUMBER
2207: DEFAULT fnd_api.g_miss_num,
2208: p_resource_type_code IN VARCHAR2
2209: DEFAULT fnd_api.g_miss_char,
2203: p_object_version_number IN OUT NOCOPY NUMBER,
2204: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2205: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2206: p_task_assignment_id IN NUMBER
2207: DEFAULT fnd_api.g_miss_num,
2208: p_resource_type_code IN VARCHAR2
2209: DEFAULT fnd_api.g_miss_char,
2210: p_resource_id IN NUMBER
2211: DEFAULT fnd_api.g_miss_num,
2205: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2206: p_task_assignment_id IN NUMBER
2207: DEFAULT fnd_api.g_miss_num,
2208: p_resource_type_code IN VARCHAR2
2209: DEFAULT fnd_api.g_miss_char,
2210: p_resource_id IN NUMBER
2211: DEFAULT fnd_api.g_miss_num,
2212: p_actual_effort IN NUMBER
2213: DEFAULT fnd_api.g_miss_num,
2207: DEFAULT fnd_api.g_miss_num,
2208: p_resource_type_code IN VARCHAR2
2209: DEFAULT fnd_api.g_miss_char,
2210: p_resource_id IN NUMBER
2211: DEFAULT fnd_api.g_miss_num,
2212: p_actual_effort IN NUMBER
2213: DEFAULT fnd_api.g_miss_num,
2214: p_actual_effort_uom IN VARCHAR2
2215: DEFAULT fnd_api.g_miss_char,
2209: DEFAULT fnd_api.g_miss_char,
2210: p_resource_id IN NUMBER
2211: DEFAULT fnd_api.g_miss_num,
2212: p_actual_effort IN NUMBER
2213: DEFAULT fnd_api.g_miss_num,
2214: p_actual_effort_uom IN VARCHAR2
2215: DEFAULT fnd_api.g_miss_char,
2216: p_schedule_flag IN VARCHAR2
2217: DEFAULT fnd_api.g_miss_char,
2211: DEFAULT fnd_api.g_miss_num,
2212: p_actual_effort IN NUMBER
2213: DEFAULT fnd_api.g_miss_num,
2214: p_actual_effort_uom IN VARCHAR2
2215: DEFAULT fnd_api.g_miss_char,
2216: p_schedule_flag IN VARCHAR2
2217: DEFAULT fnd_api.g_miss_char,
2218: p_alarm_type_code IN VARCHAR2
2219: DEFAULT fnd_api.g_miss_char,
2213: DEFAULT fnd_api.g_miss_num,
2214: p_actual_effort_uom IN VARCHAR2
2215: DEFAULT fnd_api.g_miss_char,
2216: p_schedule_flag IN VARCHAR2
2217: DEFAULT fnd_api.g_miss_char,
2218: p_alarm_type_code IN VARCHAR2
2219: DEFAULT fnd_api.g_miss_char,
2220: p_alarm_contact IN VARCHAR2
2221: DEFAULT fnd_api.g_miss_char,
2215: DEFAULT fnd_api.g_miss_char,
2216: p_schedule_flag IN VARCHAR2
2217: DEFAULT fnd_api.g_miss_char,
2218: p_alarm_type_code IN VARCHAR2
2219: DEFAULT fnd_api.g_miss_char,
2220: p_alarm_contact IN VARCHAR2
2221: DEFAULT fnd_api.g_miss_char,
2222: p_sched_travel_distance IN NUMBER
2223: DEFAULT fnd_api.g_miss_num,
2217: DEFAULT fnd_api.g_miss_char,
2218: p_alarm_type_code IN VARCHAR2
2219: DEFAULT fnd_api.g_miss_char,
2220: p_alarm_contact IN VARCHAR2
2221: DEFAULT fnd_api.g_miss_char,
2222: p_sched_travel_distance IN NUMBER
2223: DEFAULT fnd_api.g_miss_num,
2224: p_sched_travel_duration IN NUMBER
2225: DEFAULT fnd_api.g_miss_num,
2219: DEFAULT fnd_api.g_miss_char,
2220: p_alarm_contact IN VARCHAR2
2221: DEFAULT fnd_api.g_miss_char,
2222: p_sched_travel_distance IN NUMBER
2223: DEFAULT fnd_api.g_miss_num,
2224: p_sched_travel_duration IN NUMBER
2225: DEFAULT fnd_api.g_miss_num,
2226: p_sched_travel_duration_uom IN VARCHAR2
2227: DEFAULT fnd_api.g_miss_char,
2221: DEFAULT fnd_api.g_miss_char,
2222: p_sched_travel_distance IN NUMBER
2223: DEFAULT fnd_api.g_miss_num,
2224: p_sched_travel_duration IN NUMBER
2225: DEFAULT fnd_api.g_miss_num,
2226: p_sched_travel_duration_uom IN VARCHAR2
2227: DEFAULT fnd_api.g_miss_char,
2228: p_actual_travel_distance IN NUMBER
2229: DEFAULT fnd_api.g_miss_num,
2223: DEFAULT fnd_api.g_miss_num,
2224: p_sched_travel_duration IN NUMBER
2225: DEFAULT fnd_api.g_miss_num,
2226: p_sched_travel_duration_uom IN VARCHAR2
2227: DEFAULT fnd_api.g_miss_char,
2228: p_actual_travel_distance IN NUMBER
2229: DEFAULT fnd_api.g_miss_num,
2230: p_actual_travel_duration IN NUMBER
2231: DEFAULT fnd_api.g_miss_num,
2225: DEFAULT fnd_api.g_miss_num,
2226: p_sched_travel_duration_uom IN VARCHAR2
2227: DEFAULT fnd_api.g_miss_char,
2228: p_actual_travel_distance IN NUMBER
2229: DEFAULT fnd_api.g_miss_num,
2230: p_actual_travel_duration IN NUMBER
2231: DEFAULT fnd_api.g_miss_num,
2232: p_actual_travel_duration_uom IN VARCHAR2
2233: DEFAULT fnd_api.g_miss_char,
2227: DEFAULT fnd_api.g_miss_char,
2228: p_actual_travel_distance IN NUMBER
2229: DEFAULT fnd_api.g_miss_num,
2230: p_actual_travel_duration IN NUMBER
2231: DEFAULT fnd_api.g_miss_num,
2232: p_actual_travel_duration_uom IN VARCHAR2
2233: DEFAULT fnd_api.g_miss_char,
2234: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2235: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2229: DEFAULT fnd_api.g_miss_num,
2230: p_actual_travel_duration IN NUMBER
2231: DEFAULT fnd_api.g_miss_num,
2232: p_actual_travel_duration_uom IN VARCHAR2
2233: DEFAULT fnd_api.g_miss_char,
2234: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2235: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2236: p_palm_flag IN VARCHAR2
2237: DEFAULT fnd_api.g_miss_char,
2230: p_actual_travel_duration IN NUMBER
2231: DEFAULT fnd_api.g_miss_num,
2232: p_actual_travel_duration_uom IN VARCHAR2
2233: DEFAULT fnd_api.g_miss_char,
2234: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2235: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2236: p_palm_flag IN VARCHAR2
2237: DEFAULT fnd_api.g_miss_char,
2238: p_wince_flag IN VARCHAR2
2231: DEFAULT fnd_api.g_miss_num,
2232: p_actual_travel_duration_uom IN VARCHAR2
2233: DEFAULT fnd_api.g_miss_char,
2234: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2235: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2236: p_palm_flag IN VARCHAR2
2237: DEFAULT fnd_api.g_miss_char,
2238: p_wince_flag IN VARCHAR2
2239: DEFAULT fnd_api.g_miss_char,
2233: DEFAULT fnd_api.g_miss_char,
2234: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2235: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2236: p_palm_flag IN VARCHAR2
2237: DEFAULT fnd_api.g_miss_char,
2238: p_wince_flag IN VARCHAR2
2239: DEFAULT fnd_api.g_miss_char,
2240: p_laptop_flag IN VARCHAR2
2241: DEFAULT fnd_api.g_miss_char,
2235: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2236: p_palm_flag IN VARCHAR2
2237: DEFAULT fnd_api.g_miss_char,
2238: p_wince_flag IN VARCHAR2
2239: DEFAULT fnd_api.g_miss_char,
2240: p_laptop_flag IN VARCHAR2
2241: DEFAULT fnd_api.g_miss_char,
2242: p_device1_flag IN VARCHAR2
2243: DEFAULT fnd_api.g_miss_char,
2237: DEFAULT fnd_api.g_miss_char,
2238: p_wince_flag IN VARCHAR2
2239: DEFAULT fnd_api.g_miss_char,
2240: p_laptop_flag IN VARCHAR2
2241: DEFAULT fnd_api.g_miss_char,
2242: p_device1_flag IN VARCHAR2
2243: DEFAULT fnd_api.g_miss_char,
2244: p_device2_flag IN VARCHAR2
2245: DEFAULT fnd_api.g_miss_char,
2239: DEFAULT fnd_api.g_miss_char,
2240: p_laptop_flag IN VARCHAR2
2241: DEFAULT fnd_api.g_miss_char,
2242: p_device1_flag IN VARCHAR2
2243: DEFAULT fnd_api.g_miss_char,
2244: p_device2_flag IN VARCHAR2
2245: DEFAULT fnd_api.g_miss_char,
2246: p_device3_flag IN VARCHAR2
2247: DEFAULT fnd_api.g_miss_char,
2241: DEFAULT fnd_api.g_miss_char,
2242: p_device1_flag IN VARCHAR2
2243: DEFAULT fnd_api.g_miss_char,
2244: p_device2_flag IN VARCHAR2
2245: DEFAULT fnd_api.g_miss_char,
2246: p_device3_flag IN VARCHAR2
2247: DEFAULT fnd_api.g_miss_char,
2248: p_resource_territory_id IN NUMBER
2249: DEFAULT fnd_api.g_miss_num,
2243: DEFAULT fnd_api.g_miss_char,
2244: p_device2_flag IN VARCHAR2
2245: DEFAULT fnd_api.g_miss_char,
2246: p_device3_flag IN VARCHAR2
2247: DEFAULT fnd_api.g_miss_char,
2248: p_resource_territory_id IN NUMBER
2249: DEFAULT fnd_api.g_miss_num,
2250: p_assignment_status_id IN NUMBER
2251: DEFAULT fnd_api.g_miss_num,
2245: DEFAULT fnd_api.g_miss_char,
2246: p_device3_flag IN VARCHAR2
2247: DEFAULT fnd_api.g_miss_char,
2248: p_resource_territory_id IN NUMBER
2249: DEFAULT fnd_api.g_miss_num,
2250: p_assignment_status_id IN NUMBER
2251: DEFAULT fnd_api.g_miss_num,
2252: p_shift_construct_id IN NUMBER
2253: DEFAULT fnd_api.g_miss_num,
2247: DEFAULT fnd_api.g_miss_char,
2248: p_resource_territory_id IN NUMBER
2249: DEFAULT fnd_api.g_miss_num,
2250: p_assignment_status_id IN NUMBER
2251: DEFAULT fnd_api.g_miss_num,
2252: p_shift_construct_id IN NUMBER
2253: DEFAULT fnd_api.g_miss_num,
2254: x_return_status OUT NOCOPY VARCHAR2,
2255: x_msg_count OUT NOCOPY NUMBER,
2249: DEFAULT fnd_api.g_miss_num,
2250: p_assignment_status_id IN NUMBER
2251: DEFAULT fnd_api.g_miss_num,
2252: p_shift_construct_id IN NUMBER
2253: DEFAULT fnd_api.g_miss_num,
2254: x_return_status OUT NOCOPY VARCHAR2,
2255: x_msg_count OUT NOCOPY NUMBER,
2256: x_msg_data OUT NOCOPY VARCHAR2,
2257: p_attribute1 IN VARCHAR2
2348: p_show_on_calendar => p_show_on_calendar,
2349: p_category_id => p_category_id,
2350: p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
2351: p_abort_workflow => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
2352: p_free_busy_type => fnd_api.g_miss_char
2353: );
2354: END;
2355:
2356: PROCEDURE update_task_assignment (
2355:
2356: PROCEDURE update_task_assignment (
2357: p_api_version IN NUMBER,
2358: p_object_version_number IN OUT NOCOPY NUMBER,
2359: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2360: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2361: p_task_assignment_id IN NUMBER
2362: DEFAULT fnd_api.g_miss_num,
2363: p_resource_type_code IN VARCHAR2
2356: PROCEDURE update_task_assignment (
2357: p_api_version IN NUMBER,
2358: p_object_version_number IN OUT NOCOPY NUMBER,
2359: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2360: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2361: p_task_assignment_id IN NUMBER
2362: DEFAULT fnd_api.g_miss_num,
2363: p_resource_type_code IN VARCHAR2
2364: DEFAULT fnd_api.g_miss_char,
2358: p_object_version_number IN OUT NOCOPY NUMBER,
2359: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2360: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2361: p_task_assignment_id IN NUMBER
2362: DEFAULT fnd_api.g_miss_num,
2363: p_resource_type_code IN VARCHAR2
2364: DEFAULT fnd_api.g_miss_char,
2365: p_resource_id IN NUMBER
2366: DEFAULT fnd_api.g_miss_num,
2360: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2361: p_task_assignment_id IN NUMBER
2362: DEFAULT fnd_api.g_miss_num,
2363: p_resource_type_code IN VARCHAR2
2364: DEFAULT fnd_api.g_miss_char,
2365: p_resource_id IN NUMBER
2366: DEFAULT fnd_api.g_miss_num,
2367: p_actual_effort IN NUMBER
2368: DEFAULT fnd_api.g_miss_num,
2362: DEFAULT fnd_api.g_miss_num,
2363: p_resource_type_code IN VARCHAR2
2364: DEFAULT fnd_api.g_miss_char,
2365: p_resource_id IN NUMBER
2366: DEFAULT fnd_api.g_miss_num,
2367: p_actual_effort IN NUMBER
2368: DEFAULT fnd_api.g_miss_num,
2369: p_actual_effort_uom IN VARCHAR2
2370: DEFAULT fnd_api.g_miss_char,
2364: DEFAULT fnd_api.g_miss_char,
2365: p_resource_id IN NUMBER
2366: DEFAULT fnd_api.g_miss_num,
2367: p_actual_effort IN NUMBER
2368: DEFAULT fnd_api.g_miss_num,
2369: p_actual_effort_uom IN VARCHAR2
2370: DEFAULT fnd_api.g_miss_char,
2371: p_schedule_flag IN VARCHAR2
2372: DEFAULT fnd_api.g_miss_char,
2366: DEFAULT fnd_api.g_miss_num,
2367: p_actual_effort IN NUMBER
2368: DEFAULT fnd_api.g_miss_num,
2369: p_actual_effort_uom IN VARCHAR2
2370: DEFAULT fnd_api.g_miss_char,
2371: p_schedule_flag IN VARCHAR2
2372: DEFAULT fnd_api.g_miss_char,
2373: p_alarm_type_code IN VARCHAR2
2374: DEFAULT fnd_api.g_miss_char,
2368: DEFAULT fnd_api.g_miss_num,
2369: p_actual_effort_uom IN VARCHAR2
2370: DEFAULT fnd_api.g_miss_char,
2371: p_schedule_flag IN VARCHAR2
2372: DEFAULT fnd_api.g_miss_char,
2373: p_alarm_type_code IN VARCHAR2
2374: DEFAULT fnd_api.g_miss_char,
2375: p_alarm_contact IN VARCHAR2
2376: DEFAULT fnd_api.g_miss_char,
2370: DEFAULT fnd_api.g_miss_char,
2371: p_schedule_flag IN VARCHAR2
2372: DEFAULT fnd_api.g_miss_char,
2373: p_alarm_type_code IN VARCHAR2
2374: DEFAULT fnd_api.g_miss_char,
2375: p_alarm_contact IN VARCHAR2
2376: DEFAULT fnd_api.g_miss_char,
2377: p_sched_travel_distance IN NUMBER
2378: DEFAULT fnd_api.g_miss_num,
2372: DEFAULT fnd_api.g_miss_char,
2373: p_alarm_type_code IN VARCHAR2
2374: DEFAULT fnd_api.g_miss_char,
2375: p_alarm_contact IN VARCHAR2
2376: DEFAULT fnd_api.g_miss_char,
2377: p_sched_travel_distance IN NUMBER
2378: DEFAULT fnd_api.g_miss_num,
2379: p_sched_travel_duration IN NUMBER
2380: DEFAULT fnd_api.g_miss_num,
2374: DEFAULT fnd_api.g_miss_char,
2375: p_alarm_contact IN VARCHAR2
2376: DEFAULT fnd_api.g_miss_char,
2377: p_sched_travel_distance IN NUMBER
2378: DEFAULT fnd_api.g_miss_num,
2379: p_sched_travel_duration IN NUMBER
2380: DEFAULT fnd_api.g_miss_num,
2381: p_sched_travel_duration_uom IN VARCHAR2
2382: DEFAULT fnd_api.g_miss_char,
2376: DEFAULT fnd_api.g_miss_char,
2377: p_sched_travel_distance IN NUMBER
2378: DEFAULT fnd_api.g_miss_num,
2379: p_sched_travel_duration IN NUMBER
2380: DEFAULT fnd_api.g_miss_num,
2381: p_sched_travel_duration_uom IN VARCHAR2
2382: DEFAULT fnd_api.g_miss_char,
2383: p_actual_travel_distance IN NUMBER
2384: DEFAULT fnd_api.g_miss_num,
2378: DEFAULT fnd_api.g_miss_num,
2379: p_sched_travel_duration IN NUMBER
2380: DEFAULT fnd_api.g_miss_num,
2381: p_sched_travel_duration_uom IN VARCHAR2
2382: DEFAULT fnd_api.g_miss_char,
2383: p_actual_travel_distance IN NUMBER
2384: DEFAULT fnd_api.g_miss_num,
2385: p_actual_travel_duration IN NUMBER
2386: DEFAULT fnd_api.g_miss_num,
2380: DEFAULT fnd_api.g_miss_num,
2381: p_sched_travel_duration_uom IN VARCHAR2
2382: DEFAULT fnd_api.g_miss_char,
2383: p_actual_travel_distance IN NUMBER
2384: DEFAULT fnd_api.g_miss_num,
2385: p_actual_travel_duration IN NUMBER
2386: DEFAULT fnd_api.g_miss_num,
2387: p_actual_travel_duration_uom IN VARCHAR2
2388: DEFAULT fnd_api.g_miss_char,
2382: DEFAULT fnd_api.g_miss_char,
2383: p_actual_travel_distance IN NUMBER
2384: DEFAULT fnd_api.g_miss_num,
2385: p_actual_travel_duration IN NUMBER
2386: DEFAULT fnd_api.g_miss_num,
2387: p_actual_travel_duration_uom IN VARCHAR2
2388: DEFAULT fnd_api.g_miss_char,
2389: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2390: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2384: DEFAULT fnd_api.g_miss_num,
2385: p_actual_travel_duration IN NUMBER
2386: DEFAULT fnd_api.g_miss_num,
2387: p_actual_travel_duration_uom IN VARCHAR2
2388: DEFAULT fnd_api.g_miss_char,
2389: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2390: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2391: p_palm_flag IN VARCHAR2
2392: DEFAULT fnd_api.g_miss_char,
2385: p_actual_travel_duration IN NUMBER
2386: DEFAULT fnd_api.g_miss_num,
2387: p_actual_travel_duration_uom IN VARCHAR2
2388: DEFAULT fnd_api.g_miss_char,
2389: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2390: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2391: p_palm_flag IN VARCHAR2
2392: DEFAULT fnd_api.g_miss_char,
2393: p_wince_flag IN VARCHAR2
2386: DEFAULT fnd_api.g_miss_num,
2387: p_actual_travel_duration_uom IN VARCHAR2
2388: DEFAULT fnd_api.g_miss_char,
2389: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2390: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2391: p_palm_flag IN VARCHAR2
2392: DEFAULT fnd_api.g_miss_char,
2393: p_wince_flag IN VARCHAR2
2394: DEFAULT fnd_api.g_miss_char,
2388: DEFAULT fnd_api.g_miss_char,
2389: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2390: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2391: p_palm_flag IN VARCHAR2
2392: DEFAULT fnd_api.g_miss_char,
2393: p_wince_flag IN VARCHAR2
2394: DEFAULT fnd_api.g_miss_char,
2395: p_laptop_flag IN VARCHAR2
2396: DEFAULT fnd_api.g_miss_char,
2390: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2391: p_palm_flag IN VARCHAR2
2392: DEFAULT fnd_api.g_miss_char,
2393: p_wince_flag IN VARCHAR2
2394: DEFAULT fnd_api.g_miss_char,
2395: p_laptop_flag IN VARCHAR2
2396: DEFAULT fnd_api.g_miss_char,
2397: p_device1_flag IN VARCHAR2
2398: DEFAULT fnd_api.g_miss_char,
2392: DEFAULT fnd_api.g_miss_char,
2393: p_wince_flag IN VARCHAR2
2394: DEFAULT fnd_api.g_miss_char,
2395: p_laptop_flag IN VARCHAR2
2396: DEFAULT fnd_api.g_miss_char,
2397: p_device1_flag IN VARCHAR2
2398: DEFAULT fnd_api.g_miss_char,
2399: p_device2_flag IN VARCHAR2
2400: DEFAULT fnd_api.g_miss_char,
2394: DEFAULT fnd_api.g_miss_char,
2395: p_laptop_flag IN VARCHAR2
2396: DEFAULT fnd_api.g_miss_char,
2397: p_device1_flag IN VARCHAR2
2398: DEFAULT fnd_api.g_miss_char,
2399: p_device2_flag IN VARCHAR2
2400: DEFAULT fnd_api.g_miss_char,
2401: p_device3_flag IN VARCHAR2
2402: DEFAULT fnd_api.g_miss_char,
2396: DEFAULT fnd_api.g_miss_char,
2397: p_device1_flag IN VARCHAR2
2398: DEFAULT fnd_api.g_miss_char,
2399: p_device2_flag IN VARCHAR2
2400: DEFAULT fnd_api.g_miss_char,
2401: p_device3_flag IN VARCHAR2
2402: DEFAULT fnd_api.g_miss_char,
2403: p_resource_territory_id IN NUMBER
2404: DEFAULT fnd_api.g_miss_num,
2398: DEFAULT fnd_api.g_miss_char,
2399: p_device2_flag IN VARCHAR2
2400: DEFAULT fnd_api.g_miss_char,
2401: p_device3_flag IN VARCHAR2
2402: DEFAULT fnd_api.g_miss_char,
2403: p_resource_territory_id IN NUMBER
2404: DEFAULT fnd_api.g_miss_num,
2405: p_assignment_status_id IN NUMBER
2406: DEFAULT fnd_api.g_miss_num,
2400: DEFAULT fnd_api.g_miss_char,
2401: p_device3_flag IN VARCHAR2
2402: DEFAULT fnd_api.g_miss_char,
2403: p_resource_territory_id IN NUMBER
2404: DEFAULT fnd_api.g_miss_num,
2405: p_assignment_status_id IN NUMBER
2406: DEFAULT fnd_api.g_miss_num,
2407: p_shift_construct_id IN NUMBER
2408: DEFAULT fnd_api.g_miss_num,
2402: DEFAULT fnd_api.g_miss_char,
2403: p_resource_territory_id IN NUMBER
2404: DEFAULT fnd_api.g_miss_num,
2405: p_assignment_status_id IN NUMBER
2406: DEFAULT fnd_api.g_miss_num,
2407: p_shift_construct_id IN NUMBER
2408: DEFAULT fnd_api.g_miss_num,
2409: x_return_status OUT NOCOPY VARCHAR2,
2410: x_msg_count OUT NOCOPY NUMBER,
2404: DEFAULT fnd_api.g_miss_num,
2405: p_assignment_status_id IN NUMBER
2406: DEFAULT fnd_api.g_miss_num,
2407: p_shift_construct_id IN NUMBER
2408: DEFAULT fnd_api.g_miss_num,
2409: x_return_status OUT NOCOPY VARCHAR2,
2410: x_msg_count OUT NOCOPY NUMBER,
2411: x_msg_data OUT NOCOPY VARCHAR2,
2412: p_attribute1 IN VARCHAR2
2505: p_show_on_calendar => p_show_on_calendar,
2506: p_category_id => p_category_id,
2507: p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
2508: p_abort_workflow => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
2509: p_free_busy_type => fnd_api.g_miss_char
2510: );
2511: END;
2512:
2513: PROCEDURE delete_task_assignment (
2512:
2513: PROCEDURE delete_task_assignment (
2514: p_api_version IN NUMBER,
2515: p_object_version_number IN NUMBER,
2516: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2517: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2518: p_task_assignment_id IN NUMBER,
2519: x_return_status OUT NOCOPY VARCHAR2,
2520: x_msg_count OUT NOCOPY NUMBER,
2513: PROCEDURE delete_task_assignment (
2514: p_api_version IN NUMBER,
2515: p_object_version_number IN NUMBER,
2516: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2517: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2518: p_task_assignment_id IN NUMBER,
2519: x_return_status OUT NOCOPY VARCHAR2,
2520: x_msg_count OUT NOCOPY NUMBER,
2521: x_msg_data OUT NOCOPY VARCHAR2,
2576: x_event_return_status varchar2(100);
2577: ------------------------------------------
2578: BEGIN
2579: SAVEPOINT delete_task_ass_pvt;
2580: x_return_status := fnd_api.g_ret_sts_success;
2581:
2582: ------------------------------------------
2583: -- For XP
2584: ------------------------------------------
2589: CLOSE c_task;
2590: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2591: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2592: fnd_msg_pub.add;
2593: x_return_status := fnd_api.g_ret_sts_unexp_error;
2594: RAISE fnd_api.g_exc_unexpected_error;
2595: END IF;
2596: CLOSE c_task;
2597:
2590: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2591: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2592: fnd_msg_pub.add;
2593: x_return_status := fnd_api.g_ret_sts_unexp_error;
2594: RAISE fnd_api.g_exc_unexpected_error;
2595: END IF;
2596: CLOSE c_task;
2597:
2598: l_task_id := rec_task.task_id;
2613: l_delete_assignee_rec.abort_workflow := p_abort_workflow;
2614:
2615: jtf_task_repeat_assignment_pvt.delete_assignee(
2616: p_api_version => 1.0,
2617: p_init_msg_list => fnd_api.g_false,
2618: p_commit => fnd_api.g_false,
2619: p_delete_assignee_rec => l_delete_assignee_rec,
2620: x_return_status => x_return_status,
2621: x_msg_count => x_msg_count,
2614:
2615: jtf_task_repeat_assignment_pvt.delete_assignee(
2616: p_api_version => 1.0,
2617: p_init_msg_list => fnd_api.g_false,
2618: p_commit => fnd_api.g_false,
2619: p_delete_assignee_rec => l_delete_assignee_rec,
2620: x_return_status => x_return_status,
2621: x_msg_count => x_msg_count,
2622: x_msg_data => x_msg_data
2629: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
2630: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_delete_option ');
2631: fnd_msg_pub.add;
2632:
2633: x_return_status := fnd_api.g_ret_sts_unexp_error;
2634: RAISE fnd_api.g_exc_unexpected_error;
2635: END IF;
2636: END IF;
2637: ------------------------------------------
2630: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_delete_option ');
2631: fnd_msg_pub.add;
2632:
2633: x_return_status := fnd_api.g_ret_sts_unexp_error;
2634: RAISE fnd_api.g_exc_unexpected_error;
2635: END IF;
2636: END IF;
2637: ------------------------------------------
2638:
2638:
2639: ---call the table handler to delete the resource req
2640: jtf_task_assignments_pub.lock_task_assignment (
2641: p_api_version => 1.0,
2642: p_init_msg_list => fnd_api.g_false,
2643: p_commit => fnd_api.g_false,
2644: p_task_assignment_id => l_task_assignment_id,
2645: p_object_version_number => p_object_version_number,
2646: x_return_status => x_return_status,
2639: ---call the table handler to delete the resource req
2640: jtf_task_assignments_pub.lock_task_assignment (
2641: p_api_version => 1.0,
2642: p_init_msg_list => fnd_api.g_false,
2643: p_commit => fnd_api.g_false,
2644: p_task_assignment_id => l_task_assignment_id,
2645: p_object_version_number => p_object_version_number,
2646: x_return_status => x_return_status,
2647: x_msg_data => x_msg_data,
2647: x_msg_data => x_msg_data,
2648: x_msg_count => x_msg_count
2649: );
2650:
2651: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2652: THEN
2653: x_return_status := fnd_api.g_ret_sts_unexp_error;
2654: RAISE fnd_api.g_exc_unexpected_error;
2655: END IF;
2649: );
2650:
2651: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2652: THEN
2653: x_return_status := fnd_api.g_ret_sts_unexp_error;
2654: RAISE fnd_api.g_exc_unexpected_error;
2655: END IF;
2656:
2657: -- ------------------------------------------------------------------------
2650:
2651: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2652: THEN
2653: x_return_status := fnd_api.g_ret_sts_unexp_error;
2654: RAISE fnd_api.g_exc_unexpected_error;
2655: END IF;
2656:
2657: -- ------------------------------------------------------------------------
2658: -- Get the original resource_id so we can delete the reference details
2668: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
2669: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2670: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2671: fnd_msg_pub.add;
2672: x_return_status := fnd_api.g_ret_sts_unexp_error;
2673: RAISE fnd_api.g_exc_unexpected_error;
2674: END IF;
2675: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
2676:
2669: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2670: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2671: fnd_msg_pub.add;
2672: x_return_status := fnd_api.g_ret_sts_unexp_error;
2673: RAISE fnd_api.g_exc_unexpected_error;
2674: END IF;
2675: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
2676:
2677: jtf_task_utl.check_security_privilege(
2679: p_session => l_session,
2680: x_return_status => x_return_status
2681: );
2682:
2683: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2684: THEN
2685: x_return_status := fnd_api.g_ret_sts_unexp_error;
2686: RAISE fnd_api.g_exc_unexpected_error;
2687: END IF;
2681: );
2682:
2683: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2684: THEN
2685: x_return_status := fnd_api.g_ret_sts_unexp_error;
2686: RAISE fnd_api.g_exc_unexpected_error;
2687: END IF;
2688:
2689:
2682:
2683: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2684: THEN
2685: x_return_status := fnd_api.g_ret_sts_unexp_error;
2686: RAISE fnd_api.g_exc_unexpected_error;
2687: END IF;
2688:
2689:
2690: jtf_task_assignments_pkg.delete_row (
2697: THEN
2698: CLOSE c_res_ass; -- Fix a missing CLOSE on 4/18/2002
2699: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_TK_ASS');
2700: fnd_msg_pub.add;
2701: x_return_status := fnd_api.g_ret_sts_unexp_error;
2702: RAISE fnd_api.g_exc_unexpected_error;
2703: --CLOSE c_res_ass; -- Incorrect position for CLOSE
2704: ELSE
2705: CLOSE c_res_ass;
2698: CLOSE c_res_ass; -- Fix a missing CLOSE on 4/18/2002
2699: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_TK_ASS');
2700: fnd_msg_pub.add;
2701: x_return_status := fnd_api.g_ret_sts_unexp_error;
2702: RAISE fnd_api.g_exc_unexpected_error;
2703: --CLOSE c_res_ass; -- Incorrect position for CLOSE
2704: ELSE
2705: CLOSE c_res_ass;
2706: END IF;
2721: x_msg_count => x_msg_count,
2722: x_msg_data => x_msg_data,
2723: x_return_status => x_return_status);
2724:
2725: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2726: THEN
2727: x_return_status := fnd_api.g_ret_sts_unexp_error;
2728: RAISE fnd_api.g_exc_unexpected_error;
2729: END IF;
2723: x_return_status => x_return_status);
2724:
2725: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2726: THEN
2727: x_return_status := fnd_api.g_ret_sts_unexp_error;
2728: RAISE fnd_api.g_exc_unexpected_error;
2729: END IF;
2730:
2731: ---
2724:
2725: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2726: THEN
2727: x_return_status := fnd_api.g_ret_sts_unexp_error;
2728: RAISE fnd_api.g_exc_unexpected_error;
2729: END IF;
2730:
2731: ---
2732: --- decide the launch of workflow
2755: THEN
2756: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2757: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2758: fnd_msg_pub.add;
2759: x_return_status := fnd_api.g_ret_sts_unexp_error;
2760: RAISE fnd_api.g_exc_unexpected_error;
2761: END IF ;
2762:
2763: END IF;
2756: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2757: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2758: fnd_msg_pub.add;
2759: x_return_status := fnd_api.g_ret_sts_unexp_error;
2760: RAISE fnd_api.g_exc_unexpected_error;
2761: END IF ;
2762:
2763: END IF;
2764:
2766: THEN
2767: CLOSE ass_res_orig;
2768: END IF;
2769:
2770: IF fnd_api.to_boolean (p_commit)
2771: THEN
2772: COMMIT WORK;
2773: END IF;
2774:
2773: END IF;
2774:
2775: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2776: EXCEPTION
2777: WHEN fnd_api.g_exc_unexpected_error
2778: THEN
2779: ROLLBACK TO delete_task_ass_pvt;
2780: x_return_status := fnd_api.g_ret_sts_unexp_error;
2781: fnd_msg_pub.count_and_get (
2776: EXCEPTION
2777: WHEN fnd_api.g_exc_unexpected_error
2778: THEN
2779: ROLLBACK TO delete_task_ass_pvt;
2780: x_return_status := fnd_api.g_ret_sts_unexp_error;
2781: fnd_msg_pub.count_and_get (
2782: p_count => x_msg_count,
2783: p_data => x_msg_data
2784: );
2790: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2791: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2792: fnd_msg_pub.add;
2793:
2794: x_return_status := fnd_api.g_ret_sts_unexp_error;
2795: fnd_msg_pub.count_and_get (
2796: p_count => x_msg_count,
2797: p_data => x_msg_data
2798: );
2800:
2801: PROCEDURE delete_task_assignment (
2802: p_api_version IN NUMBER,
2803: p_object_version_number IN NUMBER,
2804: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2805: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2806: p_task_assignment_id IN NUMBER,
2807: x_return_status OUT NOCOPY VARCHAR2,
2808: x_msg_count OUT NOCOPY NUMBER,
2801: PROCEDURE delete_task_assignment (
2802: p_api_version IN NUMBER,
2803: p_object_version_number IN NUMBER,
2804: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2805: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2806: p_task_assignment_id IN NUMBER,
2807: x_return_status OUT NOCOPY VARCHAR2,
2808: x_msg_count OUT NOCOPY NUMBER,
2809: x_msg_data OUT NOCOPY VARCHAR2,
2829:
2830: PROCEDURE delete_task_assignment (
2831: p_api_version IN NUMBER,
2832: p_object_version_number IN NUMBER,
2833: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2834: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2835: p_task_assignment_id IN NUMBER,
2836: x_return_status OUT NOCOPY VARCHAR2,
2837: x_msg_count OUT NOCOPY NUMBER,
2830: PROCEDURE delete_task_assignment (
2831: p_api_version IN NUMBER,
2832: p_object_version_number IN NUMBER,
2833: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2834: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2835: p_task_assignment_id IN NUMBER,
2836: x_return_status OUT NOCOPY VARCHAR2,
2837: x_msg_count OUT NOCOPY NUMBER,
2838: x_msg_data OUT NOCOPY VARCHAR2