155: END update_free_busy_type;
156:
157: PROCEDURE create_task_assignment (
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
160: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
161: p_task_assignment_id IN NUMBER DEFAULT NULL,
162: p_task_id IN NUMBER DEFAULT NULL,
163: p_resource_type_code IN VARCHAR2,
156:
157: PROCEDURE create_task_assignment (
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
160: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
161: p_task_assignment_id IN NUMBER DEFAULT NULL,
162: p_task_id IN NUMBER DEFAULT NULL,
163: p_resource_type_code IN VARCHAR2,
164: p_resource_id IN NUMBER,
218: := 1.0;
219: l_api_name CONSTANT VARCHAR(30)
220: := 'CREATE_TASK_ASSIGNMENTS';
221: l_return_status VARCHAR2(1)
222: := fnd_api.g_ret_sts_success;
223: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
224: l_task_id jtf_tasks_b.task_id%TYPE
225: := p_task_id;
226: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
320: x_event_return_status varchar2(100);
321: ------------------------------------------
322: BEGIN
323: SAVEPOINT create_task_assign_pvt;
324: x_return_status := fnd_api.g_ret_sts_success;
325:
326: ------------------------------------------
327: -- For XP
328: ------------------------------------------
333: CLOSE c_task;
334: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
335: fnd_message.set_token ('P_TASK_ID', l_task_id);
336: fnd_msg_pub.add;
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: RAISE fnd_api.g_exc_unexpected_error;
339: END IF;
340: CLOSE c_task;
341:
334: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
335: fnd_message.set_token ('P_TASK_ID', l_task_id);
336: fnd_msg_pub.add;
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: RAISE fnd_api.g_exc_unexpected_error;
339: END IF;
340: CLOSE c_task;
341:
342: IF rec_task.source_object_type_code = 'APPOINTMENT' AND
358: l_add_assignee_rec.abort_workflow := p_abort_workflow;
359:
360: jtf_task_repeat_assignment_pvt.add_assignee(
361: p_api_version => 1.0,
362: p_init_msg_list => fnd_api.g_false,
363: p_commit => fnd_api.g_false,
364: p_add_assignee_rec => l_add_assignee_rec,
365: x_return_status => x_return_status,
366: x_msg_count => x_msg_count,
359:
360: jtf_task_repeat_assignment_pvt.add_assignee(
361: p_api_version => 1.0,
362: p_init_msg_list => fnd_api.g_false,
363: p_commit => fnd_api.g_false,
364: p_add_assignee_rec => l_add_assignee_rec,
365: x_return_status => x_return_status,
366: x_msg_count => x_msg_count,
367: x_msg_data => x_msg_data,
375: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
376: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_add_option ');
377: fnd_msg_pub.add;
378:
379: x_return_status := fnd_api.g_ret_sts_unexp_error;
380: RAISE fnd_api.g_exc_unexpected_error;
381: END IF;
382: END IF;
383: ------------------------------------------
376: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_add_option ');
377: fnd_msg_pub.add;
378:
379: x_return_status := fnd_api.g_ret_sts_unexp_error;
380: RAISE fnd_api.g_exc_unexpected_error;
381: END IF;
382: END IF;
383: ------------------------------------------
384:
388: p_task_assignment_id < 1e+12
389: THEN
390: fnd_message.set_name ('JTF', 'JTF_TASK_OUT_OF_RANGE');
391: fnd_msg_pub.add;
392: x_return_status := fnd_api.g_ret_sts_unexp_error;
393: RAISE fnd_api.g_exc_unexpected_error;
394: ELSE
395: l_task_assignment_id := p_task_assignment_id;
396: END IF;
389: THEN
390: fnd_message.set_name ('JTF', 'JTF_TASK_OUT_OF_RANGE');
391: fnd_msg_pub.add;
392: x_return_status := fnd_api.g_ret_sts_unexp_error;
393: RAISE fnd_api.g_exc_unexpected_error;
394: ELSE
395: l_task_assignment_id := p_task_assignment_id;
396: END IF;
397: ELSE
412: 'JTF_TASK_ASSIGNEE_ROLES',
413: NVL (l_assignee_role, 'ASSIGNEE'),
414: 'assignment assignee role ( JTF_TK_ASSOGNEE_ROLE )')
415: THEN
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417: RAISE fnd_api.g_exc_unexpected_error;
418: END IF;
419:
420:
413: NVL (l_assignee_role, 'ASSIGNEE'),
414: 'assignment assignee role ( JTF_TK_ASSOGNEE_ROLE )')
415: THEN
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417: RAISE fnd_api.g_exc_unexpected_error;
418: END IF;
419:
420:
421: -- Implicit booking for tasks
520:
521: IF ra_cur1%NOTFOUND
522: THEN
523: CLOSE ra_cur1; -- Fix a missing CLOSE on 4/18/2002
524: x_return_status := fnd_api.g_ret_sts_unexp_error;
525: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
526: fnd_msg_pub.add;
527: RAISE fnd_api.g_exc_unexpected_error;
528: ELSE
523: CLOSE ra_cur1; -- Fix a missing CLOSE on 4/18/2002
524: x_return_status := fnd_api.g_ret_sts_unexp_error;
525: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
526: fnd_msg_pub.add;
527: RAISE fnd_api.g_exc_unexpected_error;
528: ELSE
529: x_task_assignment_id := l_task_assignment_id;
530: END IF;
531: CLOSE ra_cur1; -- Fix a missing CLOSE on 4/18/2002
561: THEN
562: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
563: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
564: fnd_msg_pub.add;
565: x_return_status := fnd_api.g_ret_sts_unexp_error;
566: RAISE fnd_api.g_exc_unexpected_error;
567: END IF ;
568:
569: END IF;
562: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
563: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
564: fnd_msg_pub.add;
565: x_return_status := fnd_api.g_ret_sts_unexp_error;
566: RAISE fnd_api.g_exc_unexpected_error;
567: END IF ;
568:
569: END IF;
570:
582: x_msg_count => x_msg_count,
583: x_msg_data => x_msg_data,
584: x_return_status => x_return_status);
585:
586: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
587: THEN
588: x_return_status := fnd_api.g_ret_sts_unexp_error;
589: RAISE fnd_api.g_exc_unexpected_error;
590: END IF;
584: x_return_status => x_return_status);
585:
586: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
587: THEN
588: x_return_status := fnd_api.g_ret_sts_unexp_error;
589: RAISE fnd_api.g_exc_unexpected_error;
590: END IF;
591:
592: END IF; -- for the if statement for (rec_task.source_object_type_code <> 'APPOINTMENT')
585:
586: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
587: THEN
588: x_return_status := fnd_api.g_ret_sts_unexp_error;
589: RAISE fnd_api.g_exc_unexpected_error;
590: END IF;
591:
592: END IF; -- for the if statement for (rec_task.source_object_type_code <> 'APPOINTMENT')
593:
592: END IF; -- for the if statement for (rec_task.source_object_type_code <> 'APPOINTMENT')
593:
594: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
595: EXCEPTION
596: WHEN fnd_api.g_exc_unexpected_error
597: THEN
598: ROLLBACK TO create_task_assign_pvt;
599: x_return_status := fnd_api.g_ret_sts_unexp_error;
600: fnd_msg_pub.count_and_get (
595: EXCEPTION
596: WHEN fnd_api.g_exc_unexpected_error
597: THEN
598: ROLLBACK TO create_task_assign_pvt;
599: x_return_status := fnd_api.g_ret_sts_unexp_error;
600: fnd_msg_pub.count_and_get (
601: p_count => x_msg_count,
602: p_data => x_msg_data
603: );
606: ROLLBACK TO create_task_assign_pvt;
607: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
608: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
609: fnd_msg_pub.add;
610: x_return_status := fnd_api.g_ret_sts_unexp_error;
611: fnd_msg_pub.count_and_get (
612: p_count => x_msg_count,
613: p_data => x_msg_data
614: );
615: END;
616:
617: PROCEDURE create_task_assignment (
618: p_api_version IN NUMBER,
619: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
620: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
621: p_task_assignment_id IN NUMBER DEFAULT NULL,
622: p_task_id IN NUMBER DEFAULT NULL,
623: p_resource_type_code IN VARCHAR2,
616:
617: PROCEDURE create_task_assignment (
618: p_api_version IN NUMBER,
619: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
620: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
621: p_task_assignment_id IN NUMBER DEFAULT NULL,
622: p_task_id IN NUMBER DEFAULT NULL,
623: p_resource_type_code IN VARCHAR2,
624: p_resource_id IN NUMBER,
737: END;
738:
739: PROCEDURE create_task_assignment (
740: p_api_version IN NUMBER,
741: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
742: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
743: p_task_assignment_id IN NUMBER DEFAULT NULL,
744: p_task_id IN NUMBER DEFAULT NULL,
745: p_resource_type_code IN VARCHAR2,
738:
739: PROCEDURE create_task_assignment (
740: p_api_version IN NUMBER,
741: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
742: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
743: p_task_assignment_id IN NUMBER DEFAULT NULL,
744: p_task_id IN NUMBER DEFAULT NULL,
745: p_resource_type_code IN VARCHAR2,
746: p_resource_id IN NUMBER,
857:
858:
859: PROCEDURE create_task_assignment (
860: p_api_version IN NUMBER,
861: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
862: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
863: p_task_assignment_id IN NUMBER DEFAULT NULL,
864: p_task_id IN NUMBER DEFAULT NULL,
865: p_resource_type_code IN VARCHAR2,
858:
859: PROCEDURE create_task_assignment (
860: p_api_version IN NUMBER,
861: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
862: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
863: p_task_assignment_id IN NUMBER DEFAULT NULL,
864: p_task_id IN NUMBER DEFAULT NULL,
865: p_resource_type_code IN VARCHAR2,
866: p_resource_id IN NUMBER,
976: END;
977:
978: PROCEDURE create_task_assignment (
979: p_api_version IN NUMBER,
980: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
981: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
982: p_task_assignment_id IN NUMBER DEFAULT NULL,
983: p_task_id IN NUMBER DEFAULT NULL,
984: p_resource_type_code IN VARCHAR2,
977:
978: PROCEDURE create_task_assignment (
979: p_api_version IN NUMBER,
980: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
981: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
982: p_task_assignment_id IN NUMBER DEFAULT NULL,
983: p_task_id IN NUMBER DEFAULT NULL,
984: p_resource_type_code IN VARCHAR2,
985: p_resource_id IN NUMBER,
1095: --Procedure to Update the Task Assignment
1096: PROCEDURE update_task_assignment (
1097: p_api_version IN NUMBER,
1098: p_object_version_number IN OUT NOCOPY NUMBER,
1099: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1100: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1101: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1102: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1103: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1096: PROCEDURE update_task_assignment (
1097: p_api_version IN NUMBER,
1098: p_object_version_number IN OUT NOCOPY NUMBER,
1099: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1100: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1101: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1102: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1103: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1104: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1097: p_api_version IN NUMBER,
1098: p_object_version_number IN OUT NOCOPY NUMBER,
1099: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1100: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1101: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1102: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1103: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1104: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1105: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1098: p_object_version_number IN OUT NOCOPY NUMBER,
1099: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1100: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1101: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1102: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1103: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1104: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1105: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1106: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1099: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1100: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1101: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1102: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1103: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1104: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1105: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1106: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1107: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1100: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1101: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1102: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1103: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1104: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1105: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1106: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1107: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1108: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1101: p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1102: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1103: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1104: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1105: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1106: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1107: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1108: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1109: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1102: p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1103: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1104: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1105: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1106: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1107: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1108: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1109: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1110: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1103: p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1104: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1105: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1106: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1107: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1108: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1109: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1110: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1111: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1104: p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1105: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1106: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1107: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1108: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1109: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1110: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1111: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1112: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1105: p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1106: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1107: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1108: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1109: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1110: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1111: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1112: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1113: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1106: p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1107: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1108: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1109: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1110: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1111: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1112: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1113: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1114: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1107: p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1108: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1109: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1110: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1111: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1112: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1113: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1114: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1115: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1108: p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1109: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1110: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1111: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1112: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1113: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1114: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1115: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1116: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1109: p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1110: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1111: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1112: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1113: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1114: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1115: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1116: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1117: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1110: p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1111: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1112: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1113: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1114: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1115: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1116: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1117: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1118: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1111: p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1112: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1113: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1114: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1115: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1116: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1117: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1118: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1119: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1112: p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
1113: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1114: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1115: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1116: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1117: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1118: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1119: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1120: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1113: p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1114: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1115: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1116: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1117: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1118: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1119: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1120: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1121: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1114: p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1115: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1116: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1117: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1118: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1119: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1120: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1121: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1122: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1115: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1116: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1117: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1118: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1119: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1120: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1121: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1122: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1123: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1116: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1117: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1118: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1119: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1120: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1121: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1122: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1123: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1124: p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1117: p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1118: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1119: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1120: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1121: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1122: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1123: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1124: p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1125: p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1118: p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1119: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1120: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1121: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1122: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1123: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1124: p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1125: p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1126: x_return_status OUT NOCOPY VARCHAR2,
1119: p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1120: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1121: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1122: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1123: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1124: p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1125: p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1126: x_return_status OUT NOCOPY VARCHAR2,
1127: x_msg_count OUT NOCOPY NUMBER,
1120: p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1121: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1122: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1123: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1124: p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1125: p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1126: x_return_status OUT NOCOPY VARCHAR2,
1127: x_msg_count OUT NOCOPY NUMBER,
1128: x_msg_data OUT NOCOPY VARCHAR2,
1121: p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1122: p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1123: p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1124: p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1125: p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1126: x_return_status OUT NOCOPY VARCHAR2,
1127: x_msg_count OUT NOCOPY NUMBER,
1128: x_msg_data OUT NOCOPY VARCHAR2,
1129: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1205: p_category_id => p_category_id,
1206: p_enable_workflow => p_enable_workflow,
1207: p_abort_workflow => p_abort_workflow,
1208: p_free_busy_type => p_free_busy_type,
1209: p_object_capacity_id => fnd_api.g_miss_num
1210: );
1211: END;
1212:
1213: --Procedure to Update the Task Assignment
1213: --Procedure to Update the Task Assignment
1214: PROCEDURE update_task_assignment (
1215: p_api_version IN NUMBER,
1216: p_object_version_number IN OUT NOCOPY NUMBER,
1217: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1218: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1219: p_task_assignment_id IN NUMBER
1220: DEFAULT fnd_api.g_miss_num,
1221: p_resource_type_code IN VARCHAR2
1214: PROCEDURE update_task_assignment (
1215: p_api_version IN NUMBER,
1216: p_object_version_number IN OUT NOCOPY NUMBER,
1217: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1218: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1219: p_task_assignment_id IN NUMBER
1220: DEFAULT fnd_api.g_miss_num,
1221: p_resource_type_code IN VARCHAR2
1222: DEFAULT fnd_api.g_miss_char,
1216: p_object_version_number IN OUT NOCOPY NUMBER,
1217: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1218: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1219: p_task_assignment_id IN NUMBER
1220: DEFAULT fnd_api.g_miss_num,
1221: p_resource_type_code IN VARCHAR2
1222: DEFAULT fnd_api.g_miss_char,
1223: p_resource_id IN NUMBER
1224: DEFAULT fnd_api.g_miss_num,
1218: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1219: p_task_assignment_id IN NUMBER
1220: DEFAULT fnd_api.g_miss_num,
1221: p_resource_type_code IN VARCHAR2
1222: DEFAULT fnd_api.g_miss_char,
1223: p_resource_id IN NUMBER
1224: DEFAULT fnd_api.g_miss_num,
1225: p_actual_effort IN NUMBER
1226: DEFAULT fnd_api.g_miss_num,
1220: DEFAULT fnd_api.g_miss_num,
1221: p_resource_type_code IN VARCHAR2
1222: DEFAULT fnd_api.g_miss_char,
1223: p_resource_id IN NUMBER
1224: DEFAULT fnd_api.g_miss_num,
1225: p_actual_effort IN NUMBER
1226: DEFAULT fnd_api.g_miss_num,
1227: p_actual_effort_uom IN VARCHAR2
1228: DEFAULT fnd_api.g_miss_char,
1222: DEFAULT fnd_api.g_miss_char,
1223: p_resource_id IN NUMBER
1224: DEFAULT fnd_api.g_miss_num,
1225: p_actual_effort IN NUMBER
1226: DEFAULT fnd_api.g_miss_num,
1227: p_actual_effort_uom IN VARCHAR2
1228: DEFAULT fnd_api.g_miss_char,
1229: p_schedule_flag IN VARCHAR2
1230: DEFAULT fnd_api.g_miss_char,
1224: DEFAULT fnd_api.g_miss_num,
1225: p_actual_effort IN NUMBER
1226: DEFAULT fnd_api.g_miss_num,
1227: p_actual_effort_uom IN VARCHAR2
1228: DEFAULT fnd_api.g_miss_char,
1229: p_schedule_flag IN VARCHAR2
1230: DEFAULT fnd_api.g_miss_char,
1231: p_alarm_type_code IN VARCHAR2
1232: DEFAULT fnd_api.g_miss_char,
1226: DEFAULT fnd_api.g_miss_num,
1227: p_actual_effort_uom IN VARCHAR2
1228: DEFAULT fnd_api.g_miss_char,
1229: p_schedule_flag IN VARCHAR2
1230: DEFAULT fnd_api.g_miss_char,
1231: p_alarm_type_code IN VARCHAR2
1232: DEFAULT fnd_api.g_miss_char,
1233: p_alarm_contact IN VARCHAR2
1234: DEFAULT fnd_api.g_miss_char,
1228: DEFAULT fnd_api.g_miss_char,
1229: p_schedule_flag IN VARCHAR2
1230: DEFAULT fnd_api.g_miss_char,
1231: p_alarm_type_code IN VARCHAR2
1232: DEFAULT fnd_api.g_miss_char,
1233: p_alarm_contact IN VARCHAR2
1234: DEFAULT fnd_api.g_miss_char,
1235: p_sched_travel_distance IN NUMBER
1236: DEFAULT fnd_api.g_miss_num,
1230: DEFAULT fnd_api.g_miss_char,
1231: p_alarm_type_code IN VARCHAR2
1232: DEFAULT fnd_api.g_miss_char,
1233: p_alarm_contact IN VARCHAR2
1234: DEFAULT fnd_api.g_miss_char,
1235: p_sched_travel_distance IN NUMBER
1236: DEFAULT fnd_api.g_miss_num,
1237: p_sched_travel_duration IN NUMBER
1238: DEFAULT fnd_api.g_miss_num,
1232: DEFAULT fnd_api.g_miss_char,
1233: p_alarm_contact IN VARCHAR2
1234: DEFAULT fnd_api.g_miss_char,
1235: p_sched_travel_distance IN NUMBER
1236: DEFAULT fnd_api.g_miss_num,
1237: p_sched_travel_duration IN NUMBER
1238: DEFAULT fnd_api.g_miss_num,
1239: p_sched_travel_duration_uom IN VARCHAR2
1240: DEFAULT fnd_api.g_miss_char,
1234: DEFAULT fnd_api.g_miss_char,
1235: p_sched_travel_distance IN NUMBER
1236: DEFAULT fnd_api.g_miss_num,
1237: p_sched_travel_duration IN NUMBER
1238: DEFAULT fnd_api.g_miss_num,
1239: p_sched_travel_duration_uom IN VARCHAR2
1240: DEFAULT fnd_api.g_miss_char,
1241: p_actual_travel_distance IN NUMBER
1242: DEFAULT fnd_api.g_miss_num,
1236: DEFAULT fnd_api.g_miss_num,
1237: p_sched_travel_duration IN NUMBER
1238: DEFAULT fnd_api.g_miss_num,
1239: p_sched_travel_duration_uom IN VARCHAR2
1240: DEFAULT fnd_api.g_miss_char,
1241: p_actual_travel_distance IN NUMBER
1242: DEFAULT fnd_api.g_miss_num,
1243: p_actual_travel_duration IN NUMBER
1244: DEFAULT fnd_api.g_miss_num,
1238: DEFAULT fnd_api.g_miss_num,
1239: p_sched_travel_duration_uom IN VARCHAR2
1240: DEFAULT fnd_api.g_miss_char,
1241: p_actual_travel_distance IN NUMBER
1242: DEFAULT fnd_api.g_miss_num,
1243: p_actual_travel_duration IN NUMBER
1244: DEFAULT fnd_api.g_miss_num,
1245: p_actual_travel_duration_uom IN VARCHAR2
1246: DEFAULT fnd_api.g_miss_char,
1240: DEFAULT fnd_api.g_miss_char,
1241: p_actual_travel_distance IN NUMBER
1242: DEFAULT fnd_api.g_miss_num,
1243: p_actual_travel_duration IN NUMBER
1244: DEFAULT fnd_api.g_miss_num,
1245: p_actual_travel_duration_uom IN VARCHAR2
1246: DEFAULT fnd_api.g_miss_char,
1247: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1248: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1242: DEFAULT fnd_api.g_miss_num,
1243: p_actual_travel_duration IN NUMBER
1244: DEFAULT fnd_api.g_miss_num,
1245: p_actual_travel_duration_uom IN VARCHAR2
1246: DEFAULT fnd_api.g_miss_char,
1247: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1248: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1249: p_palm_flag IN VARCHAR2
1250: DEFAULT fnd_api.g_miss_char,
1243: p_actual_travel_duration IN NUMBER
1244: DEFAULT fnd_api.g_miss_num,
1245: p_actual_travel_duration_uom IN VARCHAR2
1246: DEFAULT fnd_api.g_miss_char,
1247: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1248: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1249: p_palm_flag IN VARCHAR2
1250: DEFAULT fnd_api.g_miss_char,
1251: p_wince_flag IN VARCHAR2
1244: DEFAULT fnd_api.g_miss_num,
1245: p_actual_travel_duration_uom IN VARCHAR2
1246: DEFAULT fnd_api.g_miss_char,
1247: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1248: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1249: p_palm_flag IN VARCHAR2
1250: DEFAULT fnd_api.g_miss_char,
1251: p_wince_flag IN VARCHAR2
1252: DEFAULT fnd_api.g_miss_char,
1246: DEFAULT fnd_api.g_miss_char,
1247: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1248: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1249: p_palm_flag IN VARCHAR2
1250: DEFAULT fnd_api.g_miss_char,
1251: p_wince_flag IN VARCHAR2
1252: DEFAULT fnd_api.g_miss_char,
1253: p_laptop_flag IN VARCHAR2
1254: DEFAULT fnd_api.g_miss_char,
1248: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1249: p_palm_flag IN VARCHAR2
1250: DEFAULT fnd_api.g_miss_char,
1251: p_wince_flag IN VARCHAR2
1252: DEFAULT fnd_api.g_miss_char,
1253: p_laptop_flag IN VARCHAR2
1254: DEFAULT fnd_api.g_miss_char,
1255: p_device1_flag IN VARCHAR2
1256: DEFAULT fnd_api.g_miss_char,
1250: DEFAULT fnd_api.g_miss_char,
1251: p_wince_flag IN VARCHAR2
1252: DEFAULT fnd_api.g_miss_char,
1253: p_laptop_flag IN VARCHAR2
1254: DEFAULT fnd_api.g_miss_char,
1255: p_device1_flag IN VARCHAR2
1256: DEFAULT fnd_api.g_miss_char,
1257: p_device2_flag IN VARCHAR2
1258: DEFAULT fnd_api.g_miss_char,
1252: DEFAULT fnd_api.g_miss_char,
1253: p_laptop_flag IN VARCHAR2
1254: DEFAULT fnd_api.g_miss_char,
1255: p_device1_flag IN VARCHAR2
1256: DEFAULT fnd_api.g_miss_char,
1257: p_device2_flag IN VARCHAR2
1258: DEFAULT fnd_api.g_miss_char,
1259: p_device3_flag IN VARCHAR2
1260: DEFAULT fnd_api.g_miss_char,
1254: DEFAULT fnd_api.g_miss_char,
1255: p_device1_flag IN VARCHAR2
1256: DEFAULT fnd_api.g_miss_char,
1257: p_device2_flag IN VARCHAR2
1258: DEFAULT fnd_api.g_miss_char,
1259: p_device3_flag IN VARCHAR2
1260: DEFAULT fnd_api.g_miss_char,
1261: p_resource_territory_id IN NUMBER
1262: DEFAULT fnd_api.g_miss_num,
1256: DEFAULT fnd_api.g_miss_char,
1257: p_device2_flag IN VARCHAR2
1258: DEFAULT fnd_api.g_miss_char,
1259: p_device3_flag IN VARCHAR2
1260: DEFAULT fnd_api.g_miss_char,
1261: p_resource_territory_id IN NUMBER
1262: DEFAULT fnd_api.g_miss_num,
1263: p_assignment_status_id IN NUMBER
1264: DEFAULT fnd_api.g_miss_num,
1258: DEFAULT fnd_api.g_miss_char,
1259: p_device3_flag IN VARCHAR2
1260: DEFAULT fnd_api.g_miss_char,
1261: p_resource_territory_id IN NUMBER
1262: DEFAULT fnd_api.g_miss_num,
1263: p_assignment_status_id IN NUMBER
1264: DEFAULT fnd_api.g_miss_num,
1265: p_shift_construct_id IN NUMBER
1266: DEFAULT fnd_api.g_miss_num,
1260: DEFAULT fnd_api.g_miss_char,
1261: p_resource_territory_id IN NUMBER
1262: DEFAULT fnd_api.g_miss_num,
1263: p_assignment_status_id IN NUMBER
1264: DEFAULT fnd_api.g_miss_num,
1265: p_shift_construct_id IN NUMBER
1266: DEFAULT fnd_api.g_miss_num,
1267: x_return_status OUT NOCOPY VARCHAR2,
1268: x_msg_count OUT NOCOPY NUMBER,
1262: DEFAULT fnd_api.g_miss_num,
1263: p_assignment_status_id IN NUMBER
1264: DEFAULT fnd_api.g_miss_num,
1265: p_shift_construct_id IN NUMBER
1266: DEFAULT fnd_api.g_miss_num,
1267: x_return_status OUT NOCOPY VARCHAR2,
1268: x_msg_count OUT NOCOPY NUMBER,
1269: x_msg_data OUT NOCOPY VARCHAR2,
1270: p_attribute1 IN VARCHAR2
1315: := 1.0;
1316: l_api_name CONSTANT VARCHAR(30)
1317: := 'Update_Task_Assignment';
1318: l_return_status VARCHAR2(1)
1319: := fnd_api.g_ret_sts_success;
1320: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
1321: := p_task_assignment_id;
1322: l_task_id jtf_task_all_assignments.task_id%TYPE;
1323: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1397: SELECT task_id,
1398: assignment_status_id old_assignment_status_id,
1399: DECODE (
1400: p_resource_id,
1401: fnd_api.g_miss_num, resource_id,
1402: p_resource_id
1403: ) resource_id,
1404: DECODE (
1405: p_resource_type_code,
1402: p_resource_id
1403: ) resource_id,
1404: DECODE (
1405: p_resource_type_code,
1406: fnd_api.g_miss_char, resource_type_code,
1407: p_resource_type_code
1408: ) resource_type_code,
1409: DECODE (
1410: p_assignment_status_id,
1407: p_resource_type_code
1408: ) resource_type_code,
1409: DECODE (
1410: p_assignment_status_id,
1411: fnd_api.g_miss_num, assignment_status_id,
1412: p_assignment_status_id
1413: ) assignment_status_id,
1414: DECODE (
1415: p_actual_effort,
1412: p_assignment_status_id
1413: ) assignment_status_id,
1414: DECODE (
1415: p_actual_effort,
1416: fnd_api.g_miss_num, actual_effort,
1417: p_actual_effort
1418: ) actual_effort,
1419: DECODE (
1420: p_actual_effort_uom,
1417: p_actual_effort
1418: ) actual_effort,
1419: DECODE (
1420: p_actual_effort_uom,
1421: fnd_api.g_miss_char, actual_effort_uom,
1422: p_actual_effort_uom
1423: ) actual_effort_uom,
1424: DECODE (
1425: p_alarm_type_code,
1422: p_actual_effort_uom
1423: ) actual_effort_uom,
1424: DECODE (
1425: p_alarm_type_code,
1426: fnd_api.g_miss_char, alarm_type_code,
1427: p_alarm_type_code
1428: ) alarm_type_code,
1429: DECODE (
1430: p_alarm_contact,
1427: p_alarm_type_code
1428: ) alarm_type_code,
1429: DECODE (
1430: p_alarm_contact,
1431: fnd_api.g_miss_char, alarm_contact,
1432: p_alarm_contact
1433: ) alarm_contact,
1434: DECODE (
1435: p_sched_travel_distance,
1432: p_alarm_contact
1433: ) alarm_contact,
1434: DECODE (
1435: p_sched_travel_distance,
1436: fnd_api.g_miss_num, sched_travel_distance,
1437: p_sched_travel_distance
1438: ) sched_travel_distance,
1439: DECODE (
1440: p_sched_travel_duration,
1437: p_sched_travel_distance
1438: ) sched_travel_distance,
1439: DECODE (
1440: p_sched_travel_duration,
1441: fnd_api.g_miss_num, sched_travel_duration,
1442: p_sched_travel_duration
1443: ) sched_travel_duration,
1444: DECODE (
1445: p_sched_travel_duration_uom,
1442: p_sched_travel_duration
1443: ) sched_travel_duration,
1444: DECODE (
1445: p_sched_travel_duration_uom,
1446: fnd_api.g_miss_char, sched_travel_duration_uom,
1447: p_sched_travel_duration_uom
1448: ) sched_travel_dur_uom,
1449: DECODE (
1450: p_actual_travel_distance,
1447: p_sched_travel_duration_uom
1448: ) sched_travel_dur_uom,
1449: DECODE (
1450: p_actual_travel_distance,
1451: fnd_api.g_miss_num, actual_travel_distance,
1452: p_actual_travel_distance
1453: ) actual_travel_distance,
1454: DECODE (
1455: p_actual_travel_duration,
1452: p_actual_travel_distance
1453: ) actual_travel_distance,
1454: DECODE (
1455: p_actual_travel_duration,
1456: fnd_api.g_miss_num, actual_travel_duration,
1457: p_actual_travel_duration
1458: ) actual_travel_duration,
1459: DECODE (
1460: p_resource_territory_id,
1457: p_actual_travel_duration
1458: ) actual_travel_duration,
1459: DECODE (
1460: p_resource_territory_id,
1461: fnd_api.g_miss_num, resource_territory_id,
1462: p_resource_territory_id
1463: ) resource_territory_id,
1464: DECODE (
1465: p_shift_construct_id,
1462: p_resource_territory_id
1463: ) resource_territory_id,
1464: DECODE (
1465: p_shift_construct_id,
1466: fnd_api.g_miss_num, shift_construct_id,
1467: p_shift_construct_id
1468: ) shift_construct_id,
1469: DECODE (
1470: p_actual_travel_duration_uom,
1467: p_shift_construct_id
1468: ) shift_construct_id,
1469: DECODE (
1470: p_actual_travel_duration_uom,
1471: fnd_api.g_miss_char, actual_travel_duration_uom,
1472: p_actual_travel_duration_uom
1473: ) actual_travel_dur_uom,
1474: DECODE (
1475: p_schedule_flag,
1472: p_actual_travel_duration_uom
1473: ) actual_travel_dur_uom,
1474: DECODE (
1475: p_schedule_flag,
1476: fnd_api.g_miss_char, schedule_flag,
1477: p_schedule_flag
1478: ) schedule_flag,
1479: DECODE (
1480: p_actual_start_date,
1477: p_schedule_flag
1478: ) schedule_flag,
1479: DECODE (
1480: p_actual_start_date,
1481: fnd_api.g_miss_date, actual_start_date,
1482: p_actual_start_date
1483: ) actual_start_date,
1484: DECODE (
1485: p_actual_end_date,
1482: p_actual_start_date
1483: ) actual_start_date,
1484: DECODE (
1485: p_actual_end_date,
1486: fnd_api.g_miss_date, actual_end_date,
1487: p_actual_end_date
1488: ) actual_end_date,
1489: DECODE (
1490: p_palm_flag,
1487: p_actual_end_date
1488: ) actual_end_date,
1489: DECODE (
1490: p_palm_flag,
1491: fnd_api.g_miss_char, palm_flag,
1492: p_palm_flag
1493: ) palm_flag,
1494: DECODE (
1495: p_wince_flag,
1492: p_palm_flag
1493: ) palm_flag,
1494: DECODE (
1495: p_wince_flag,
1496: fnd_api.g_miss_char, wince_flag,
1497: p_wince_flag
1498: ) wince_flag,
1499: DECODE (
1500: p_laptop_flag,
1497: p_wince_flag
1498: ) wince_flag,
1499: DECODE (
1500: p_laptop_flag,
1501: fnd_api.g_miss_char, laptop_flag,
1502: p_laptop_flag
1503: ) laptop_flag,
1504: DECODE (
1505: p_device1_flag,
1502: p_laptop_flag
1503: ) laptop_flag,
1504: DECODE (
1505: p_device1_flag,
1506: fnd_api.g_miss_char, device1_flag,
1507: p_device1_flag
1508: ) device1_flag,
1509: DECODE (
1510: p_device2_flag,
1507: p_device1_flag
1508: ) device1_flag,
1509: DECODE (
1510: p_device2_flag,
1511: fnd_api.g_miss_char, device2_flag,
1512: p_device2_flag
1513: ) device2_flag,
1514: DECODE (
1515: p_device3_flag,
1512: p_device2_flag
1513: ) device2_flag,
1514: DECODE (
1515: p_device3_flag,
1516: fnd_api.g_miss_char, device3_flag,
1517: p_device3_flag
1518: ) device3_flag,
1519: DECODE (
1520: p_assignee_role,
1517: p_device3_flag
1518: ) device3_flag,
1519: DECODE (
1520: p_assignee_role,
1521: fnd_api.g_miss_char, assignee_role,
1522: p_assignee_role
1523: ) assignee_role,
1524: DECODE (
1525: p_show_on_calendar,
1522: p_assignee_role
1523: ) assignee_role,
1524: DECODE (
1525: p_show_on_calendar,
1526: fnd_api.g_miss_char, show_on_calendar,
1527: p_show_on_calendar
1528: ) show_on_calendar,
1529: DECODE (
1530: p_category_id,
1532: p_category_id
1533: ) category_id,
1534: DECODE (
1535: p_attribute1,
1536: fnd_api.g_miss_char, attribute1,
1537: p_attribute1
1538: ) attribute1,
1539: DECODE (
1540: p_attribute2,
1537: p_attribute1
1538: ) attribute1,
1539: DECODE (
1540: p_attribute2,
1541: fnd_api.g_miss_char, attribute2,
1542: p_attribute2
1543: ) attribute2,
1544: DECODE (
1545: p_attribute3,
1542: p_attribute2
1543: ) attribute2,
1544: DECODE (
1545: p_attribute3,
1546: fnd_api.g_miss_char, attribute3,
1547: p_attribute3
1548: ) attribute3,
1549: DECODE (
1550: p_attribute4,
1547: p_attribute3
1548: ) attribute3,
1549: DECODE (
1550: p_attribute4,
1551: fnd_api.g_miss_char, attribute4,
1552: p_attribute4
1553: ) attribute4,
1554: DECODE (
1555: p_attribute5,
1552: p_attribute4
1553: ) attribute4,
1554: DECODE (
1555: p_attribute5,
1556: fnd_api.g_miss_char, attribute5,
1557: p_attribute5
1558: ) attribute5,
1559: DECODE (
1560: p_attribute6,
1557: p_attribute5
1558: ) attribute5,
1559: DECODE (
1560: p_attribute6,
1561: fnd_api.g_miss_char, attribute6,
1562: p_attribute6
1563: ) attribute6,
1564: DECODE (
1565: p_attribute7,
1562: p_attribute6
1563: ) attribute6,
1564: DECODE (
1565: p_attribute7,
1566: fnd_api.g_miss_char, attribute7,
1567: p_attribute7
1568: ) attribute7,
1569: DECODE (
1570: p_attribute8,
1567: p_attribute7
1568: ) attribute7,
1569: DECODE (
1570: p_attribute8,
1571: fnd_api.g_miss_char, attribute8,
1572: p_attribute8
1573: ) attribute8,
1574: DECODE (
1575: p_attribute9,
1572: p_attribute8
1573: ) attribute8,
1574: DECODE (
1575: p_attribute9,
1576: fnd_api.g_miss_char, attribute9,
1577: p_attribute9
1578: ) attribute9,
1579: DECODE (
1580: p_attribute10,
1577: p_attribute9
1578: ) attribute9,
1579: DECODE (
1580: p_attribute10,
1581: fnd_api.g_miss_char, attribute10,
1582: p_attribute10
1583: ) attribute10,
1584: DECODE (
1585: p_attribute11,
1582: p_attribute10
1583: ) attribute10,
1584: DECODE (
1585: p_attribute11,
1586: fnd_api.g_miss_char, attribute11,
1587: p_attribute11
1588: ) attribute11,
1589: DECODE (
1590: p_attribute12,
1587: p_attribute11
1588: ) attribute11,
1589: DECODE (
1590: p_attribute12,
1591: fnd_api.g_miss_char, attribute12,
1592: p_attribute12
1593: ) attribute12,
1594: DECODE (
1595: p_attribute13,
1592: p_attribute12
1593: ) attribute12,
1594: DECODE (
1595: p_attribute13,
1596: fnd_api.g_miss_char, attribute13,
1597: p_attribute13
1598: ) attribute13,
1599: DECODE (
1600: p_attribute14,
1597: p_attribute13
1598: ) attribute13,
1599: DECODE (
1600: p_attribute14,
1601: fnd_api.g_miss_char, attribute14,
1602: p_attribute14
1603: ) attribute14,
1604: DECODE (
1605: p_attribute15,
1602: p_attribute14
1603: ) attribute14,
1604: DECODE (
1605: p_attribute15,
1606: fnd_api.g_miss_char, attribute15,
1607: p_attribute15
1608: ) attribute15,
1609: DECODE (
1610: p_attribute_category,
1607: p_attribute15
1608: ) attribute15,
1609: DECODE (
1610: p_attribute_category,
1611: fnd_api.g_miss_char, attribute_category,
1612: p_attribute_category
1613: ) attribute_category,
1614: DECODE (
1615: p_free_busy_type,
1617: p_free_busy_type
1618: ) free_busy_type,
1619: DECODE (
1620: p_object_capacity_id,
1621: fnd_api.g_miss_num, object_capacity_id,
1622: p_object_capacity_id
1623: ) object_capacity_id
1624: FROM jtf_task_all_assignments
1625: WHERE task_assignment_id = l_task_assignment_id;
1665: l_open_flag jtf_tasks_b.open_flag%TYPE;
1666: l_response_invitation_rec jtf_task_repeat_assignment_pvt.response_invitation_rec;
1667: BEGIN
1668: SAVEPOINT update_task_assign_pvt;
1669: x_return_status := fnd_api.g_ret_sts_success;
1670:
1671: OPEN task_ass_u;
1672: FETCH task_ass_u INTO task_ass;
1673:
1676: CLOSE task_ass_u;
1677: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1678: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1679: fnd_msg_pub.add;
1680: x_return_status := fnd_api.g_ret_sts_unexp_error;
1681: RAISE fnd_api.g_exc_unexpected_error;
1682: END IF;
1683: CLOSE task_ass_u;
1684:
1677: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1678: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1679: fnd_msg_pub.add;
1680: x_return_status := fnd_api.g_ret_sts_unexp_error;
1681: RAISE fnd_api.g_exc_unexpected_error;
1682: END IF;
1683: CLOSE task_ass_u;
1684:
1685: -- Business Event System Enhancement # 2391065
1691: CLOSE jtf_task_utl.c_ass_orig;
1692: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1693: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1694: fnd_msg_pub.add;
1695: x_return_status := fnd_api.g_ret_sts_unexp_error;
1696: RAISE fnd_api.g_exc_unexpected_error;
1697: END IF;
1698: CLOSE jtf_task_utl.c_ass_orig;
1699:
1692: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1693: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1694: fnd_msg_pub.add;
1695: x_return_status := fnd_api.g_ret_sts_unexp_error;
1696: RAISE fnd_api.g_exc_unexpected_error;
1697: END IF;
1698: CLOSE jtf_task_utl.c_ass_orig;
1699:
1700: l_task_assignment_id := p_task_assignment_id;
1751: CLOSE c_task;
1752: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
1753: fnd_message.set_token ('P_TASK_ID', l_task_id);
1754: fnd_msg_pub.add;
1755: x_return_status := fnd_api.g_ret_sts_unexp_error;
1756: RAISE fnd_api.g_exc_unexpected_error;
1757: END IF;
1758: CLOSE c_task;
1759:
1752: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
1753: fnd_message.set_token ('P_TASK_ID', l_task_id);
1754: fnd_msg_pub.add;
1755: x_return_status := fnd_api.g_ret_sts_unexp_error;
1756: RAISE fnd_api.g_exc_unexpected_error;
1757: END IF;
1758: CLOSE c_task;
1759:
1760: IF l_recurrence_rule_id IS NOT NULL AND
1769: l_response_invitation_rec.recurrence_rule_id := l_recurrence_rule_id;
1770:
1771: jtf_task_repeat_assignment_pvt.response_invitation(
1772: p_api_version => 1.0,
1773: p_init_msg_list => fnd_api.g_false,
1774: p_commit => fnd_api.g_false,
1775: p_object_version_number => p_object_version_number,
1776: p_response_invitation_rec => l_response_invitation_rec,
1777: x_return_status => x_return_status,
1770:
1771: jtf_task_repeat_assignment_pvt.response_invitation(
1772: p_api_version => 1.0,
1773: p_init_msg_list => fnd_api.g_false,
1774: p_commit => fnd_api.g_false,
1775: p_object_version_number => p_object_version_number,
1776: p_response_invitation_rec => l_response_invitation_rec,
1777: x_return_status => x_return_status,
1778: x_msg_count => x_msg_count,
1794: ------------------------------------------------------------------------
1795:
1796: jtf_task_assignments_pub.lock_task_assignment (
1797: p_api_version => 1.0,
1798: p_init_msg_list => fnd_api.g_false,
1799: p_commit => fnd_api.g_false,
1800: p_task_assignment_id => l_task_assignment_id,
1801: p_object_version_number => p_object_version_number,
1802: x_return_status => x_return_status,
1795:
1796: jtf_task_assignments_pub.lock_task_assignment (
1797: p_api_version => 1.0,
1798: p_init_msg_list => fnd_api.g_false,
1799: p_commit => fnd_api.g_false,
1800: p_task_assignment_id => l_task_assignment_id,
1801: p_object_version_number => p_object_version_number,
1802: x_return_status => x_return_status,
1803: x_msg_data => x_msg_data,
1803: x_msg_data => x_msg_data,
1804: x_msg_count => x_msg_count
1805: );
1806:
1807: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1808: THEN
1809: x_return_status := fnd_api.g_ret_sts_unexp_error;
1810: RAISE fnd_api.g_exc_unexpected_error;
1811: END IF;
1805: );
1806:
1807: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1808: THEN
1809: x_return_status := fnd_api.g_ret_sts_unexp_error;
1810: RAISE fnd_api.g_exc_unexpected_error;
1811: END IF;
1812:
1813:
1806:
1807: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1808: THEN
1809: x_return_status := fnd_api.g_ret_sts_unexp_error;
1810: RAISE fnd_api.g_exc_unexpected_error;
1811: END IF;
1812:
1813:
1814: -- Validate the user_id
1817: p_session => l_session,
1818: x_return_status => x_return_status
1819: );
1820:
1821: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1822: THEN
1823: x_return_status := fnd_api.g_ret_sts_unexp_error;
1824: RAISE fnd_api.g_exc_unexpected_error;
1825: END IF;
1819: );
1820:
1821: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1822: THEN
1823: x_return_status := fnd_api.g_ret_sts_unexp_error;
1824: RAISE fnd_api.g_exc_unexpected_error;
1825: END IF;
1826:
1827: --Bug 2467222 for assignee category update
1820:
1821: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1822: THEN
1823: x_return_status := fnd_api.g_ret_sts_unexp_error;
1824: RAISE fnd_api.g_exc_unexpected_error;
1825: END IF;
1826:
1827: --Bug 2467222 for assignee category update
1828: IF (p_category_id <> jtf_task_utl.g_miss_number) OR (p_category_id IS NULL)
1855: l_assignee_role,
1856: 'assignment assignee role ( JTF_TK_ASSOGNEE_ROLE )'
1857: )
1858: THEN
1859: x_return_status := fnd_api.g_ret_sts_unexp_error;
1860: RAISE fnd_api.g_exc_unexpected_error;
1861: END IF;
1862:
1863: -- Update the values based on ASSIGNEE_ROLE
1856: 'assignment assignee role ( JTF_TK_ASSOGNEE_ROLE )'
1857: )
1858: THEN
1859: x_return_status := fnd_api.g_ret_sts_unexp_error;
1860: RAISE fnd_api.g_exc_unexpected_error;
1861: END IF;
1862:
1863: -- Update the values based on ASSIGNEE_ROLE
1864: select assignee_role
1882:
1883: -- OPEN ass_res_orig (l_task_assignment_id);
1884: -- 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;
1885:
1886: -- IF (p_object_capacity_id <> fnd_api.g_miss_num and p_object_capacity_id is not null)
1887: -- then
1888: -- l_object_capacity_id := p_object_capacity_id;
1889: -- end if;
1890:
1890:
1891: -- IF ass_res_orig%NOTFOUND
1892: -- THEN
1893: -- CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
1894: -- RAISE fnd_api.g_exc_unexpected_error;
1895: -- END IF;
1896: -- CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
1897:
1898: -- Booking Changes for Simplex ..
1913: );
1914:
1915: IF l_entity = 'TASK' AND
1916: p_free_busy_type = jtf_task_utl.g_miss_char AND -- no explicit value
1917: nvl(p_assignment_status_id, 0) <> fnd_api.g_miss_num AND
1918: nvl(l_old_assignment_status_id, 0) <> nvl(l_assignment_status_id, 0) -- Modified for bug# 5514013 on 11/09/2006
1919: THEN
1920: update_free_busy_type(
1921: p_assignment_status_id => l_assignment_status_id,
1987:
1988: -- ------------------------------------------------------------------------
1989: -- Update reference to resource if changed, fix enh #1845501
1990: -- ------------------------------------------------------------------------
1991: if (nvl(l_resource_id, 0) <> fnd_api.g_miss_num and
1992: nvl(l_resource_id, 0) <> nvl(l_orig_res_id, 0))
1993: or (nvl(l_resource_type_code, fnd_api.g_miss_char) <> nvl(l_orig_res_type_code, fnd_api.g_miss_char)) then
1994: -- delete the old one
1995: jtf_task_utl.delete_party_reference(
1989: -- Update reference to resource if changed, fix enh #1845501
1990: -- ------------------------------------------------------------------------
1991: if (nvl(l_resource_id, 0) <> fnd_api.g_miss_num and
1992: nvl(l_resource_id, 0) <> nvl(l_orig_res_id, 0))
1993: or (nvl(l_resource_type_code, fnd_api.g_miss_char) <> nvl(l_orig_res_type_code, fnd_api.g_miss_char)) then
1994: -- delete the old one
1995: jtf_task_utl.delete_party_reference(
1996: p_reference_from => 'ASSIGNMENT',
1997: p_task_id => l_task_id,
2000: x_msg_count => x_msg_count,
2001: x_msg_data => x_msg_data,
2002: x_return_status => x_return_status);
2003:
2004: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2005: THEN
2006: x_return_status := fnd_api.g_ret_sts_unexp_error;
2007: RAISE fnd_api.g_exc_unexpected_error;
2008: END IF;
2002: x_return_status => x_return_status);
2003:
2004: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2005: THEN
2006: x_return_status := fnd_api.g_ret_sts_unexp_error;
2007: RAISE fnd_api.g_exc_unexpected_error;
2008: END IF;
2009: -- create a new one
2010: jtf_task_utl.create_party_reference(
2003:
2004: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2005: THEN
2006: x_return_status := fnd_api.g_ret_sts_unexp_error;
2007: RAISE fnd_api.g_exc_unexpected_error;
2008: END IF;
2009: -- create a new one
2010: jtf_task_utl.create_party_reference(
2011: p_reference_from => 'ASSIGNMENT',
2015: x_msg_count => x_msg_count,
2016: x_msg_data => x_msg_data,
2017: x_return_status => x_return_status);
2018:
2019: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2020: THEN
2021: x_return_status := fnd_api.g_ret_sts_unexp_error;
2022: RAISE fnd_api.g_exc_unexpected_error;
2023: END IF;
2017: x_return_status => x_return_status);
2018:
2019: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2020: THEN
2021: x_return_status := fnd_api.g_ret_sts_unexp_error;
2022: RAISE fnd_api.g_exc_unexpected_error;
2023: END IF;
2024: end if;
2025:
2018:
2019: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2020: THEN
2021: x_return_status := fnd_api.g_ret_sts_unexp_error;
2022: RAISE fnd_api.g_exc_unexpected_error;
2023: END IF;
2024: end if;
2025:
2026: ---
2068: THEN
2069: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2070: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2071: fnd_msg_pub.add;
2072: x_return_status := fnd_api.g_ret_sts_unexp_error;
2073: RAISE fnd_api.g_exc_unexpected_error;
2074: END IF ;
2075:
2076: END IF;
2069: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2070: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2071: fnd_msg_pub.add;
2072: x_return_status := fnd_api.g_ret_sts_unexp_error;
2073: RAISE fnd_api.g_exc_unexpected_error;
2074: END IF ;
2075:
2076: END IF;
2077:
2079: -- THEN
2080: -- CLOSE ass_res_orig;
2081: -- END IF;
2082:
2083: IF fnd_api.to_boolean (p_commit)
2084: THEN
2085: COMMIT WORK;
2086: END IF;
2087:
2086: END IF;
2087:
2088: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2089: EXCEPTION
2090: WHEN fnd_api.g_exc_unexpected_error
2091: THEN
2092: IF task_ass_u%ISOPEN
2093: THEN
2094: CLOSE task_ass_u;
2094: CLOSE task_ass_u;
2095: END IF;
2096:
2097: ROLLBACK TO update_task_assign_pvt;
2098: x_return_status := fnd_api.g_ret_sts_unexp_error;
2099: fnd_msg_pub.count_and_get (
2100: p_count => x_msg_count,
2101: p_data => x_msg_data
2102: );
2113: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2114: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2115: fnd_msg_pub.add;
2116:
2117: x_return_status := fnd_api.g_ret_sts_unexp_error;
2118: fnd_msg_pub.count_and_get (
2119: p_count => x_msg_count,
2120: p_data => x_msg_data
2121: );
2123:
2124: PROCEDURE update_task_assignment (
2125: p_api_version IN NUMBER,
2126: p_object_version_number IN OUT NOCOPY NUMBER,
2127: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2128: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2129: p_task_assignment_id IN NUMBER
2130: DEFAULT fnd_api.g_miss_num,
2131: p_resource_type_code IN VARCHAR2
2124: PROCEDURE update_task_assignment (
2125: p_api_version IN NUMBER,
2126: p_object_version_number IN OUT NOCOPY NUMBER,
2127: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2128: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2129: p_task_assignment_id IN NUMBER
2130: DEFAULT fnd_api.g_miss_num,
2131: p_resource_type_code IN VARCHAR2
2132: DEFAULT fnd_api.g_miss_char,
2126: p_object_version_number IN OUT NOCOPY NUMBER,
2127: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2128: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2129: p_task_assignment_id IN NUMBER
2130: DEFAULT fnd_api.g_miss_num,
2131: p_resource_type_code IN VARCHAR2
2132: DEFAULT fnd_api.g_miss_char,
2133: p_resource_id IN NUMBER
2134: DEFAULT fnd_api.g_miss_num,
2128: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2129: p_task_assignment_id IN NUMBER
2130: DEFAULT fnd_api.g_miss_num,
2131: p_resource_type_code IN VARCHAR2
2132: DEFAULT fnd_api.g_miss_char,
2133: p_resource_id IN NUMBER
2134: DEFAULT fnd_api.g_miss_num,
2135: p_actual_effort IN NUMBER
2136: DEFAULT fnd_api.g_miss_num,
2130: DEFAULT fnd_api.g_miss_num,
2131: p_resource_type_code IN VARCHAR2
2132: DEFAULT fnd_api.g_miss_char,
2133: p_resource_id IN NUMBER
2134: DEFAULT fnd_api.g_miss_num,
2135: p_actual_effort IN NUMBER
2136: DEFAULT fnd_api.g_miss_num,
2137: p_actual_effort_uom IN VARCHAR2
2138: DEFAULT fnd_api.g_miss_char,
2132: DEFAULT fnd_api.g_miss_char,
2133: p_resource_id IN NUMBER
2134: DEFAULT fnd_api.g_miss_num,
2135: p_actual_effort IN NUMBER
2136: DEFAULT fnd_api.g_miss_num,
2137: p_actual_effort_uom IN VARCHAR2
2138: DEFAULT fnd_api.g_miss_char,
2139: p_schedule_flag IN VARCHAR2
2140: DEFAULT fnd_api.g_miss_char,
2134: DEFAULT fnd_api.g_miss_num,
2135: p_actual_effort IN NUMBER
2136: DEFAULT fnd_api.g_miss_num,
2137: p_actual_effort_uom IN VARCHAR2
2138: DEFAULT fnd_api.g_miss_char,
2139: p_schedule_flag IN VARCHAR2
2140: DEFAULT fnd_api.g_miss_char,
2141: p_alarm_type_code IN VARCHAR2
2142: DEFAULT fnd_api.g_miss_char,
2136: DEFAULT fnd_api.g_miss_num,
2137: p_actual_effort_uom IN VARCHAR2
2138: DEFAULT fnd_api.g_miss_char,
2139: p_schedule_flag IN VARCHAR2
2140: DEFAULT fnd_api.g_miss_char,
2141: p_alarm_type_code IN VARCHAR2
2142: DEFAULT fnd_api.g_miss_char,
2143: p_alarm_contact IN VARCHAR2
2144: DEFAULT fnd_api.g_miss_char,
2138: DEFAULT fnd_api.g_miss_char,
2139: p_schedule_flag IN VARCHAR2
2140: DEFAULT fnd_api.g_miss_char,
2141: p_alarm_type_code IN VARCHAR2
2142: DEFAULT fnd_api.g_miss_char,
2143: p_alarm_contact IN VARCHAR2
2144: DEFAULT fnd_api.g_miss_char,
2145: p_sched_travel_distance IN NUMBER
2146: DEFAULT fnd_api.g_miss_num,
2140: DEFAULT fnd_api.g_miss_char,
2141: p_alarm_type_code IN VARCHAR2
2142: DEFAULT fnd_api.g_miss_char,
2143: p_alarm_contact IN VARCHAR2
2144: DEFAULT fnd_api.g_miss_char,
2145: p_sched_travel_distance IN NUMBER
2146: DEFAULT fnd_api.g_miss_num,
2147: p_sched_travel_duration IN NUMBER
2148: DEFAULT fnd_api.g_miss_num,
2142: DEFAULT fnd_api.g_miss_char,
2143: p_alarm_contact IN VARCHAR2
2144: DEFAULT fnd_api.g_miss_char,
2145: p_sched_travel_distance IN NUMBER
2146: DEFAULT fnd_api.g_miss_num,
2147: p_sched_travel_duration IN NUMBER
2148: DEFAULT fnd_api.g_miss_num,
2149: p_sched_travel_duration_uom IN VARCHAR2
2150: DEFAULT fnd_api.g_miss_char,
2144: DEFAULT fnd_api.g_miss_char,
2145: p_sched_travel_distance IN NUMBER
2146: DEFAULT fnd_api.g_miss_num,
2147: p_sched_travel_duration IN NUMBER
2148: DEFAULT fnd_api.g_miss_num,
2149: p_sched_travel_duration_uom IN VARCHAR2
2150: DEFAULT fnd_api.g_miss_char,
2151: p_actual_travel_distance IN NUMBER
2152: DEFAULT fnd_api.g_miss_num,
2146: DEFAULT fnd_api.g_miss_num,
2147: p_sched_travel_duration IN NUMBER
2148: DEFAULT fnd_api.g_miss_num,
2149: p_sched_travel_duration_uom IN VARCHAR2
2150: DEFAULT fnd_api.g_miss_char,
2151: p_actual_travel_distance IN NUMBER
2152: DEFAULT fnd_api.g_miss_num,
2153: p_actual_travel_duration IN NUMBER
2154: DEFAULT fnd_api.g_miss_num,
2148: DEFAULT fnd_api.g_miss_num,
2149: p_sched_travel_duration_uom IN VARCHAR2
2150: DEFAULT fnd_api.g_miss_char,
2151: p_actual_travel_distance IN NUMBER
2152: DEFAULT fnd_api.g_miss_num,
2153: p_actual_travel_duration IN NUMBER
2154: DEFAULT fnd_api.g_miss_num,
2155: p_actual_travel_duration_uom IN VARCHAR2
2156: DEFAULT fnd_api.g_miss_char,
2150: DEFAULT fnd_api.g_miss_char,
2151: p_actual_travel_distance IN NUMBER
2152: DEFAULT fnd_api.g_miss_num,
2153: p_actual_travel_duration IN NUMBER
2154: DEFAULT fnd_api.g_miss_num,
2155: p_actual_travel_duration_uom IN VARCHAR2
2156: DEFAULT fnd_api.g_miss_char,
2157: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2158: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2152: DEFAULT fnd_api.g_miss_num,
2153: p_actual_travel_duration IN NUMBER
2154: DEFAULT fnd_api.g_miss_num,
2155: p_actual_travel_duration_uom IN VARCHAR2
2156: DEFAULT fnd_api.g_miss_char,
2157: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2158: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2159: p_palm_flag IN VARCHAR2
2160: DEFAULT fnd_api.g_miss_char,
2153: p_actual_travel_duration IN NUMBER
2154: DEFAULT fnd_api.g_miss_num,
2155: p_actual_travel_duration_uom IN VARCHAR2
2156: DEFAULT fnd_api.g_miss_char,
2157: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2158: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2159: p_palm_flag IN VARCHAR2
2160: DEFAULT fnd_api.g_miss_char,
2161: p_wince_flag IN VARCHAR2
2154: DEFAULT fnd_api.g_miss_num,
2155: p_actual_travel_duration_uom IN VARCHAR2
2156: DEFAULT fnd_api.g_miss_char,
2157: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2158: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2159: p_palm_flag IN VARCHAR2
2160: DEFAULT fnd_api.g_miss_char,
2161: p_wince_flag IN VARCHAR2
2162: DEFAULT fnd_api.g_miss_char,
2156: DEFAULT fnd_api.g_miss_char,
2157: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2158: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2159: p_palm_flag IN VARCHAR2
2160: DEFAULT fnd_api.g_miss_char,
2161: p_wince_flag IN VARCHAR2
2162: DEFAULT fnd_api.g_miss_char,
2163: p_laptop_flag IN VARCHAR2
2164: DEFAULT fnd_api.g_miss_char,
2158: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2159: p_palm_flag IN VARCHAR2
2160: DEFAULT fnd_api.g_miss_char,
2161: p_wince_flag IN VARCHAR2
2162: DEFAULT fnd_api.g_miss_char,
2163: p_laptop_flag IN VARCHAR2
2164: DEFAULT fnd_api.g_miss_char,
2165: p_device1_flag IN VARCHAR2
2166: DEFAULT fnd_api.g_miss_char,
2160: DEFAULT fnd_api.g_miss_char,
2161: p_wince_flag IN VARCHAR2
2162: DEFAULT fnd_api.g_miss_char,
2163: p_laptop_flag IN VARCHAR2
2164: DEFAULT fnd_api.g_miss_char,
2165: p_device1_flag IN VARCHAR2
2166: DEFAULT fnd_api.g_miss_char,
2167: p_device2_flag IN VARCHAR2
2168: DEFAULT fnd_api.g_miss_char,
2162: DEFAULT fnd_api.g_miss_char,
2163: p_laptop_flag IN VARCHAR2
2164: DEFAULT fnd_api.g_miss_char,
2165: p_device1_flag IN VARCHAR2
2166: DEFAULT fnd_api.g_miss_char,
2167: p_device2_flag IN VARCHAR2
2168: DEFAULT fnd_api.g_miss_char,
2169: p_device3_flag IN VARCHAR2
2170: DEFAULT fnd_api.g_miss_char,
2164: DEFAULT fnd_api.g_miss_char,
2165: p_device1_flag IN VARCHAR2
2166: DEFAULT fnd_api.g_miss_char,
2167: p_device2_flag IN VARCHAR2
2168: DEFAULT fnd_api.g_miss_char,
2169: p_device3_flag IN VARCHAR2
2170: DEFAULT fnd_api.g_miss_char,
2171: p_resource_territory_id IN NUMBER
2172: DEFAULT fnd_api.g_miss_num,
2166: DEFAULT fnd_api.g_miss_char,
2167: p_device2_flag IN VARCHAR2
2168: DEFAULT fnd_api.g_miss_char,
2169: p_device3_flag IN VARCHAR2
2170: DEFAULT fnd_api.g_miss_char,
2171: p_resource_territory_id IN NUMBER
2172: DEFAULT fnd_api.g_miss_num,
2173: p_assignment_status_id IN NUMBER
2174: DEFAULT fnd_api.g_miss_num,
2168: DEFAULT fnd_api.g_miss_char,
2169: p_device3_flag IN VARCHAR2
2170: DEFAULT fnd_api.g_miss_char,
2171: p_resource_territory_id IN NUMBER
2172: DEFAULT fnd_api.g_miss_num,
2173: p_assignment_status_id IN NUMBER
2174: DEFAULT fnd_api.g_miss_num,
2175: p_shift_construct_id IN NUMBER
2176: DEFAULT fnd_api.g_miss_num,
2170: DEFAULT fnd_api.g_miss_char,
2171: p_resource_territory_id IN NUMBER
2172: DEFAULT fnd_api.g_miss_num,
2173: p_assignment_status_id IN NUMBER
2174: DEFAULT fnd_api.g_miss_num,
2175: p_shift_construct_id IN NUMBER
2176: DEFAULT fnd_api.g_miss_num,
2177: x_return_status OUT NOCOPY VARCHAR2,
2178: x_msg_count OUT NOCOPY NUMBER,
2172: DEFAULT fnd_api.g_miss_num,
2173: p_assignment_status_id IN NUMBER
2174: DEFAULT fnd_api.g_miss_num,
2175: p_shift_construct_id IN NUMBER
2176: DEFAULT fnd_api.g_miss_num,
2177: x_return_status OUT NOCOPY VARCHAR2,
2178: x_msg_count OUT NOCOPY NUMBER,
2179: x_msg_data OUT NOCOPY VARCHAR2,
2180: p_attribute1 IN VARCHAR2
2271: p_show_on_calendar => p_show_on_calendar,
2272: p_category_id => p_category_id,
2273: p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
2274: p_abort_workflow => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
2275: p_free_busy_type => fnd_api.g_miss_char
2276: );
2277: END;
2278:
2279: PROCEDURE update_task_assignment (
2278:
2279: PROCEDURE update_task_assignment (
2280: p_api_version IN NUMBER,
2281: p_object_version_number IN OUT NOCOPY NUMBER,
2282: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2283: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2284: p_task_assignment_id IN NUMBER
2285: DEFAULT fnd_api.g_miss_num,
2286: p_resource_type_code IN VARCHAR2
2279: PROCEDURE update_task_assignment (
2280: p_api_version IN NUMBER,
2281: p_object_version_number IN OUT NOCOPY NUMBER,
2282: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2283: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2284: p_task_assignment_id IN NUMBER
2285: DEFAULT fnd_api.g_miss_num,
2286: p_resource_type_code IN VARCHAR2
2287: DEFAULT fnd_api.g_miss_char,
2281: p_object_version_number IN OUT NOCOPY NUMBER,
2282: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2283: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2284: p_task_assignment_id IN NUMBER
2285: DEFAULT fnd_api.g_miss_num,
2286: p_resource_type_code IN VARCHAR2
2287: DEFAULT fnd_api.g_miss_char,
2288: p_resource_id IN NUMBER
2289: DEFAULT fnd_api.g_miss_num,
2283: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2284: p_task_assignment_id IN NUMBER
2285: DEFAULT fnd_api.g_miss_num,
2286: p_resource_type_code IN VARCHAR2
2287: DEFAULT fnd_api.g_miss_char,
2288: p_resource_id IN NUMBER
2289: DEFAULT fnd_api.g_miss_num,
2290: p_actual_effort IN NUMBER
2291: DEFAULT fnd_api.g_miss_num,
2285: DEFAULT fnd_api.g_miss_num,
2286: p_resource_type_code IN VARCHAR2
2287: DEFAULT fnd_api.g_miss_char,
2288: p_resource_id IN NUMBER
2289: DEFAULT fnd_api.g_miss_num,
2290: p_actual_effort IN NUMBER
2291: DEFAULT fnd_api.g_miss_num,
2292: p_actual_effort_uom IN VARCHAR2
2293: DEFAULT fnd_api.g_miss_char,
2287: DEFAULT fnd_api.g_miss_char,
2288: p_resource_id IN NUMBER
2289: DEFAULT fnd_api.g_miss_num,
2290: p_actual_effort IN NUMBER
2291: DEFAULT fnd_api.g_miss_num,
2292: p_actual_effort_uom IN VARCHAR2
2293: DEFAULT fnd_api.g_miss_char,
2294: p_schedule_flag IN VARCHAR2
2295: DEFAULT fnd_api.g_miss_char,
2289: DEFAULT fnd_api.g_miss_num,
2290: p_actual_effort IN NUMBER
2291: DEFAULT fnd_api.g_miss_num,
2292: p_actual_effort_uom IN VARCHAR2
2293: DEFAULT fnd_api.g_miss_char,
2294: p_schedule_flag IN VARCHAR2
2295: DEFAULT fnd_api.g_miss_char,
2296: p_alarm_type_code IN VARCHAR2
2297: DEFAULT fnd_api.g_miss_char,
2291: DEFAULT fnd_api.g_miss_num,
2292: p_actual_effort_uom IN VARCHAR2
2293: DEFAULT fnd_api.g_miss_char,
2294: p_schedule_flag IN VARCHAR2
2295: DEFAULT fnd_api.g_miss_char,
2296: p_alarm_type_code IN VARCHAR2
2297: DEFAULT fnd_api.g_miss_char,
2298: p_alarm_contact IN VARCHAR2
2299: DEFAULT fnd_api.g_miss_char,
2293: DEFAULT fnd_api.g_miss_char,
2294: p_schedule_flag IN VARCHAR2
2295: DEFAULT fnd_api.g_miss_char,
2296: p_alarm_type_code IN VARCHAR2
2297: DEFAULT fnd_api.g_miss_char,
2298: p_alarm_contact IN VARCHAR2
2299: DEFAULT fnd_api.g_miss_char,
2300: p_sched_travel_distance IN NUMBER
2301: DEFAULT fnd_api.g_miss_num,
2295: DEFAULT fnd_api.g_miss_char,
2296: p_alarm_type_code IN VARCHAR2
2297: DEFAULT fnd_api.g_miss_char,
2298: p_alarm_contact IN VARCHAR2
2299: DEFAULT fnd_api.g_miss_char,
2300: p_sched_travel_distance IN NUMBER
2301: DEFAULT fnd_api.g_miss_num,
2302: p_sched_travel_duration IN NUMBER
2303: DEFAULT fnd_api.g_miss_num,
2297: DEFAULT fnd_api.g_miss_char,
2298: p_alarm_contact IN VARCHAR2
2299: DEFAULT fnd_api.g_miss_char,
2300: p_sched_travel_distance IN NUMBER
2301: DEFAULT fnd_api.g_miss_num,
2302: p_sched_travel_duration IN NUMBER
2303: DEFAULT fnd_api.g_miss_num,
2304: p_sched_travel_duration_uom IN VARCHAR2
2305: DEFAULT fnd_api.g_miss_char,
2299: DEFAULT fnd_api.g_miss_char,
2300: p_sched_travel_distance IN NUMBER
2301: DEFAULT fnd_api.g_miss_num,
2302: p_sched_travel_duration IN NUMBER
2303: DEFAULT fnd_api.g_miss_num,
2304: p_sched_travel_duration_uom IN VARCHAR2
2305: DEFAULT fnd_api.g_miss_char,
2306: p_actual_travel_distance IN NUMBER
2307: DEFAULT fnd_api.g_miss_num,
2301: DEFAULT fnd_api.g_miss_num,
2302: p_sched_travel_duration IN NUMBER
2303: DEFAULT fnd_api.g_miss_num,
2304: p_sched_travel_duration_uom IN VARCHAR2
2305: DEFAULT fnd_api.g_miss_char,
2306: p_actual_travel_distance IN NUMBER
2307: DEFAULT fnd_api.g_miss_num,
2308: p_actual_travel_duration IN NUMBER
2309: DEFAULT fnd_api.g_miss_num,
2303: DEFAULT fnd_api.g_miss_num,
2304: p_sched_travel_duration_uom IN VARCHAR2
2305: DEFAULT fnd_api.g_miss_char,
2306: p_actual_travel_distance IN NUMBER
2307: DEFAULT fnd_api.g_miss_num,
2308: p_actual_travel_duration IN NUMBER
2309: DEFAULT fnd_api.g_miss_num,
2310: p_actual_travel_duration_uom IN VARCHAR2
2311: DEFAULT fnd_api.g_miss_char,
2305: DEFAULT fnd_api.g_miss_char,
2306: p_actual_travel_distance IN NUMBER
2307: DEFAULT fnd_api.g_miss_num,
2308: p_actual_travel_duration IN NUMBER
2309: DEFAULT fnd_api.g_miss_num,
2310: p_actual_travel_duration_uom IN VARCHAR2
2311: DEFAULT fnd_api.g_miss_char,
2312: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2313: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2307: DEFAULT fnd_api.g_miss_num,
2308: p_actual_travel_duration IN NUMBER
2309: DEFAULT fnd_api.g_miss_num,
2310: p_actual_travel_duration_uom IN VARCHAR2
2311: DEFAULT fnd_api.g_miss_char,
2312: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2313: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2314: p_palm_flag IN VARCHAR2
2315: DEFAULT fnd_api.g_miss_char,
2308: p_actual_travel_duration IN NUMBER
2309: DEFAULT fnd_api.g_miss_num,
2310: p_actual_travel_duration_uom IN VARCHAR2
2311: DEFAULT fnd_api.g_miss_char,
2312: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2313: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2314: p_palm_flag IN VARCHAR2
2315: DEFAULT fnd_api.g_miss_char,
2316: p_wince_flag IN VARCHAR2
2309: DEFAULT fnd_api.g_miss_num,
2310: p_actual_travel_duration_uom IN VARCHAR2
2311: DEFAULT fnd_api.g_miss_char,
2312: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2313: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2314: p_palm_flag IN VARCHAR2
2315: DEFAULT fnd_api.g_miss_char,
2316: p_wince_flag IN VARCHAR2
2317: DEFAULT fnd_api.g_miss_char,
2311: DEFAULT fnd_api.g_miss_char,
2312: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2313: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2314: p_palm_flag IN VARCHAR2
2315: DEFAULT fnd_api.g_miss_char,
2316: p_wince_flag IN VARCHAR2
2317: DEFAULT fnd_api.g_miss_char,
2318: p_laptop_flag IN VARCHAR2
2319: DEFAULT fnd_api.g_miss_char,
2313: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2314: p_palm_flag IN VARCHAR2
2315: DEFAULT fnd_api.g_miss_char,
2316: p_wince_flag IN VARCHAR2
2317: DEFAULT fnd_api.g_miss_char,
2318: p_laptop_flag IN VARCHAR2
2319: DEFAULT fnd_api.g_miss_char,
2320: p_device1_flag IN VARCHAR2
2321: DEFAULT fnd_api.g_miss_char,
2315: DEFAULT fnd_api.g_miss_char,
2316: p_wince_flag IN VARCHAR2
2317: DEFAULT fnd_api.g_miss_char,
2318: p_laptop_flag IN VARCHAR2
2319: DEFAULT fnd_api.g_miss_char,
2320: p_device1_flag IN VARCHAR2
2321: DEFAULT fnd_api.g_miss_char,
2322: p_device2_flag IN VARCHAR2
2323: DEFAULT fnd_api.g_miss_char,
2317: DEFAULT fnd_api.g_miss_char,
2318: p_laptop_flag IN VARCHAR2
2319: DEFAULT fnd_api.g_miss_char,
2320: p_device1_flag IN VARCHAR2
2321: DEFAULT fnd_api.g_miss_char,
2322: p_device2_flag IN VARCHAR2
2323: DEFAULT fnd_api.g_miss_char,
2324: p_device3_flag IN VARCHAR2
2325: DEFAULT fnd_api.g_miss_char,
2319: DEFAULT fnd_api.g_miss_char,
2320: p_device1_flag IN VARCHAR2
2321: DEFAULT fnd_api.g_miss_char,
2322: p_device2_flag IN VARCHAR2
2323: DEFAULT fnd_api.g_miss_char,
2324: p_device3_flag IN VARCHAR2
2325: DEFAULT fnd_api.g_miss_char,
2326: p_resource_territory_id IN NUMBER
2327: DEFAULT fnd_api.g_miss_num,
2321: DEFAULT fnd_api.g_miss_char,
2322: p_device2_flag IN VARCHAR2
2323: DEFAULT fnd_api.g_miss_char,
2324: p_device3_flag IN VARCHAR2
2325: DEFAULT fnd_api.g_miss_char,
2326: p_resource_territory_id IN NUMBER
2327: DEFAULT fnd_api.g_miss_num,
2328: p_assignment_status_id IN NUMBER
2329: DEFAULT fnd_api.g_miss_num,
2323: DEFAULT fnd_api.g_miss_char,
2324: p_device3_flag IN VARCHAR2
2325: DEFAULT fnd_api.g_miss_char,
2326: p_resource_territory_id IN NUMBER
2327: DEFAULT fnd_api.g_miss_num,
2328: p_assignment_status_id IN NUMBER
2329: DEFAULT fnd_api.g_miss_num,
2330: p_shift_construct_id IN NUMBER
2331: DEFAULT fnd_api.g_miss_num,
2325: DEFAULT fnd_api.g_miss_char,
2326: p_resource_territory_id IN NUMBER
2327: DEFAULT fnd_api.g_miss_num,
2328: p_assignment_status_id IN NUMBER
2329: DEFAULT fnd_api.g_miss_num,
2330: p_shift_construct_id IN NUMBER
2331: DEFAULT fnd_api.g_miss_num,
2332: x_return_status OUT NOCOPY VARCHAR2,
2333: x_msg_count OUT NOCOPY NUMBER,
2327: DEFAULT fnd_api.g_miss_num,
2328: p_assignment_status_id IN NUMBER
2329: DEFAULT fnd_api.g_miss_num,
2330: p_shift_construct_id IN NUMBER
2331: DEFAULT fnd_api.g_miss_num,
2332: x_return_status OUT NOCOPY VARCHAR2,
2333: x_msg_count OUT NOCOPY NUMBER,
2334: x_msg_data OUT NOCOPY VARCHAR2,
2335: p_attribute1 IN VARCHAR2
2428: p_show_on_calendar => p_show_on_calendar,
2429: p_category_id => p_category_id,
2430: p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
2431: p_abort_workflow => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
2432: p_free_busy_type => fnd_api.g_miss_char
2433: );
2434: END;
2435:
2436: PROCEDURE delete_task_assignment (
2435:
2436: PROCEDURE delete_task_assignment (
2437: p_api_version IN NUMBER,
2438: p_object_version_number IN NUMBER,
2439: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2440: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2441: p_task_assignment_id IN NUMBER,
2442: x_return_status OUT NOCOPY VARCHAR2,
2443: x_msg_count OUT NOCOPY NUMBER,
2436: PROCEDURE delete_task_assignment (
2437: p_api_version IN NUMBER,
2438: p_object_version_number IN NUMBER,
2439: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2440: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2441: p_task_assignment_id IN NUMBER,
2442: x_return_status OUT NOCOPY VARCHAR2,
2443: x_msg_count OUT NOCOPY NUMBER,
2444: x_msg_data OUT NOCOPY VARCHAR2,
2499: x_event_return_status varchar2(100);
2500: ------------------------------------------
2501: BEGIN
2502: SAVEPOINT delete_task_ass_pvt;
2503: x_return_status := fnd_api.g_ret_sts_success;
2504:
2505: ------------------------------------------
2506: -- For XP
2507: ------------------------------------------
2512: CLOSE c_task;
2513: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2514: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2515: fnd_msg_pub.add;
2516: x_return_status := fnd_api.g_ret_sts_unexp_error;
2517: RAISE fnd_api.g_exc_unexpected_error;
2518: END IF;
2519: CLOSE c_task;
2520:
2513: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2514: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2515: fnd_msg_pub.add;
2516: x_return_status := fnd_api.g_ret_sts_unexp_error;
2517: RAISE fnd_api.g_exc_unexpected_error;
2518: END IF;
2519: CLOSE c_task;
2520:
2521: l_task_id := rec_task.task_id;
2536: l_delete_assignee_rec.abort_workflow := p_abort_workflow;
2537:
2538: jtf_task_repeat_assignment_pvt.delete_assignee(
2539: p_api_version => 1.0,
2540: p_init_msg_list => fnd_api.g_false,
2541: p_commit => fnd_api.g_false,
2542: p_delete_assignee_rec => l_delete_assignee_rec,
2543: x_return_status => x_return_status,
2544: x_msg_count => x_msg_count,
2537:
2538: jtf_task_repeat_assignment_pvt.delete_assignee(
2539: p_api_version => 1.0,
2540: p_init_msg_list => fnd_api.g_false,
2541: p_commit => fnd_api.g_false,
2542: p_delete_assignee_rec => l_delete_assignee_rec,
2543: x_return_status => x_return_status,
2544: x_msg_count => x_msg_count,
2545: x_msg_data => x_msg_data
2552: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
2553: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_delete_option ');
2554: fnd_msg_pub.add;
2555:
2556: x_return_status := fnd_api.g_ret_sts_unexp_error;
2557: RAISE fnd_api.g_exc_unexpected_error;
2558: END IF;
2559: END IF;
2560: ------------------------------------------
2553: fnd_message.set_token ('P_FLAG_NAME', 'The parameter p_delete_option ');
2554: fnd_msg_pub.add;
2555:
2556: x_return_status := fnd_api.g_ret_sts_unexp_error;
2557: RAISE fnd_api.g_exc_unexpected_error;
2558: END IF;
2559: END IF;
2560: ------------------------------------------
2561:
2561:
2562: ---call the table handler to delete the resource req
2563: jtf_task_assignments_pub.lock_task_assignment (
2564: p_api_version => 1.0,
2565: p_init_msg_list => fnd_api.g_false,
2566: p_commit => fnd_api.g_false,
2567: p_task_assignment_id => l_task_assignment_id,
2568: p_object_version_number => p_object_version_number,
2569: x_return_status => x_return_status,
2562: ---call the table handler to delete the resource req
2563: jtf_task_assignments_pub.lock_task_assignment (
2564: p_api_version => 1.0,
2565: p_init_msg_list => fnd_api.g_false,
2566: p_commit => fnd_api.g_false,
2567: p_task_assignment_id => l_task_assignment_id,
2568: p_object_version_number => p_object_version_number,
2569: x_return_status => x_return_status,
2570: x_msg_data => x_msg_data,
2570: x_msg_data => x_msg_data,
2571: x_msg_count => x_msg_count
2572: );
2573:
2574: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2575: THEN
2576: x_return_status := fnd_api.g_ret_sts_unexp_error;
2577: RAISE fnd_api.g_exc_unexpected_error;
2578: END IF;
2572: );
2573:
2574: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2575: THEN
2576: x_return_status := fnd_api.g_ret_sts_unexp_error;
2577: RAISE fnd_api.g_exc_unexpected_error;
2578: END IF;
2579:
2580: -- ------------------------------------------------------------------------
2573:
2574: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2575: THEN
2576: x_return_status := fnd_api.g_ret_sts_unexp_error;
2577: RAISE fnd_api.g_exc_unexpected_error;
2578: END IF;
2579:
2580: -- ------------------------------------------------------------------------
2581: -- Get the original resource_id so we can delete the reference details
2591: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
2592: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2593: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2594: fnd_msg_pub.add;
2595: x_return_status := fnd_api.g_ret_sts_unexp_error;
2596: RAISE fnd_api.g_exc_unexpected_error;
2597: END IF;
2598: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
2599:
2592: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2593: fnd_message.set_token ('P_TASK_ASSIGNMENT_ID', p_task_assignment_id);
2594: fnd_msg_pub.add;
2595: x_return_status := fnd_api.g_ret_sts_unexp_error;
2596: RAISE fnd_api.g_exc_unexpected_error;
2597: END IF;
2598: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
2599:
2600: jtf_task_utl.check_security_privilege(
2602: p_session => l_session,
2603: x_return_status => x_return_status
2604: );
2605:
2606: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2607: THEN
2608: x_return_status := fnd_api.g_ret_sts_unexp_error;
2609: RAISE fnd_api.g_exc_unexpected_error;
2610: END IF;
2604: );
2605:
2606: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2607: THEN
2608: x_return_status := fnd_api.g_ret_sts_unexp_error;
2609: RAISE fnd_api.g_exc_unexpected_error;
2610: END IF;
2611:
2612:
2605:
2606: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2607: THEN
2608: x_return_status := fnd_api.g_ret_sts_unexp_error;
2609: RAISE fnd_api.g_exc_unexpected_error;
2610: END IF;
2611:
2612:
2613: jtf_task_assignments_pkg.delete_row (
2620: THEN
2621: CLOSE c_res_ass; -- Fix a missing CLOSE on 4/18/2002
2622: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_TK_ASS');
2623: fnd_msg_pub.add;
2624: x_return_status := fnd_api.g_ret_sts_unexp_error;
2625: RAISE fnd_api.g_exc_unexpected_error;
2626: --CLOSE c_res_ass; -- Incorrect position for CLOSE
2627: ELSE
2628: CLOSE c_res_ass;
2621: CLOSE c_res_ass; -- Fix a missing CLOSE on 4/18/2002
2622: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_TK_ASS');
2623: fnd_msg_pub.add;
2624: x_return_status := fnd_api.g_ret_sts_unexp_error;
2625: RAISE fnd_api.g_exc_unexpected_error;
2626: --CLOSE c_res_ass; -- Incorrect position for CLOSE
2627: ELSE
2628: CLOSE c_res_ass;
2629: END IF;
2644: x_msg_count => x_msg_count,
2645: x_msg_data => x_msg_data,
2646: x_return_status => x_return_status);
2647:
2648: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2649: THEN
2650: x_return_status := fnd_api.g_ret_sts_unexp_error;
2651: RAISE fnd_api.g_exc_unexpected_error;
2652: END IF;
2646: x_return_status => x_return_status);
2647:
2648: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2649: THEN
2650: x_return_status := fnd_api.g_ret_sts_unexp_error;
2651: RAISE fnd_api.g_exc_unexpected_error;
2652: END IF;
2653:
2654: ---
2647:
2648: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2649: THEN
2650: x_return_status := fnd_api.g_ret_sts_unexp_error;
2651: RAISE fnd_api.g_exc_unexpected_error;
2652: END IF;
2653:
2654: ---
2655: --- decide the launch of workflow
2678: THEN
2679: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2680: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2681: fnd_msg_pub.add;
2682: x_return_status := fnd_api.g_ret_sts_unexp_error;
2683: RAISE fnd_api.g_exc_unexpected_error;
2684: END IF ;
2685:
2686: END IF;
2679: fnd_message.set_name ('JTF', 'JTF_TASK_ASS_EVENT_ERROR');
2680: fnd_message.set_token ('P_ASSIGNMENT_ID', l_task_assignment_id);
2681: fnd_msg_pub.add;
2682: x_return_status := fnd_api.g_ret_sts_unexp_error;
2683: RAISE fnd_api.g_exc_unexpected_error;
2684: END IF ;
2685:
2686: END IF;
2687:
2689: THEN
2690: CLOSE ass_res_orig;
2691: END IF;
2692:
2693: IF fnd_api.to_boolean (p_commit)
2694: THEN
2695: COMMIT WORK;
2696: END IF;
2697:
2696: END IF;
2697:
2698: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2699: EXCEPTION
2700: WHEN fnd_api.g_exc_unexpected_error
2701: THEN
2702: ROLLBACK TO delete_task_ass_pvt;
2703: x_return_status := fnd_api.g_ret_sts_unexp_error;
2704: fnd_msg_pub.count_and_get (
2699: EXCEPTION
2700: WHEN fnd_api.g_exc_unexpected_error
2701: THEN
2702: ROLLBACK TO delete_task_ass_pvt;
2703: x_return_status := fnd_api.g_ret_sts_unexp_error;
2704: fnd_msg_pub.count_and_get (
2705: p_count => x_msg_count,
2706: p_data => x_msg_data
2707: );
2713: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2714: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2715: fnd_msg_pub.add;
2716:
2717: x_return_status := fnd_api.g_ret_sts_unexp_error;
2718: fnd_msg_pub.count_and_get (
2719: p_count => x_msg_count,
2720: p_data => x_msg_data
2721: );
2723:
2724: PROCEDURE delete_task_assignment (
2725: p_api_version IN NUMBER,
2726: p_object_version_number IN NUMBER,
2727: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2728: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2729: p_task_assignment_id IN NUMBER,
2730: x_return_status OUT NOCOPY VARCHAR2,
2731: x_msg_count OUT NOCOPY NUMBER,
2724: PROCEDURE delete_task_assignment (
2725: p_api_version IN NUMBER,
2726: p_object_version_number IN NUMBER,
2727: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2728: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2729: p_task_assignment_id IN NUMBER,
2730: x_return_status OUT NOCOPY VARCHAR2,
2731: x_msg_count OUT NOCOPY NUMBER,
2732: x_msg_data OUT NOCOPY VARCHAR2,
2752:
2753: PROCEDURE delete_task_assignment (
2754: p_api_version IN NUMBER,
2755: p_object_version_number IN NUMBER,
2756: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2757: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2758: p_task_assignment_id IN NUMBER,
2759: x_return_status OUT NOCOPY VARCHAR2,
2760: x_msg_count OUT NOCOPY NUMBER,
2753: PROCEDURE delete_task_assignment (
2754: p_api_version IN NUMBER,
2755: p_object_version_number IN NUMBER,
2756: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2757: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2758: p_task_assignment_id IN NUMBER,
2759: x_return_status OUT NOCOPY VARCHAR2,
2760: x_msg_count OUT NOCOPY NUMBER,
2761: x_msg_data OUT NOCOPY VARCHAR2