[Home] [Help]
62: , csf_util_pvt.convert_to_minutes(ta.actual_travel_duration, ta.actual_travel_duration_uom) actual_travel_duration
63: , cac.object_capacity_id old_trip_id
64: , cac.object_version_number old_trip_ovn
65: FROM jtf_tasks_b t
66: , jtf_task_assignments ta
67: , jtf_task_statuses_b ts
68: , cac_sr_object_capacity cac
69: WHERE t.task_id = p_task_id
70: AND ta.task_id (+) = t.task_id
306: , cac.object_capacity_id trip_id
307: , cac.object_version_number trip_ovn
308: , NVL(
309: ( SELECT 'Y'
310: FROM jtf_task_assignments ta2, jtf_task_statuses_b ts2
311: WHERE ta2.task_id = t.task_id
312: AND ta2.task_assignment_id <> ta.task_assignment_id
313: AND ts2.task_status_id = ta2.assignment_status_id
314: AND NVL(ts2.cancelled_flag, 'N') <> 'Y'
319: )
320: , 'N'
321: ) other_ta_exists
322: FROM jtf_tasks_b t
323: , jtf_task_assignments ta
324: , cac_sr_object_capacity cac
325: WHERE ta.task_assignment_id = p_task_assignment_id
326: AND t.task_id = ta.task_id
327: AND cac.object_capacity_id (+) = ta.object_capacity_id;
506:
507: CURSOR c_cancelled_assignments IS
508: SELECT ta.task_assignment_id
509: , ta.object_version_number
510: FROM jtf_task_assignments ta, jtf_task_statuses_b ts
511: WHERE ta.task_id = p_task_id
512: AND ta.resource_id = p_resource_id
513: AND ta.resource_type_code = p_resource_type_code
514: AND ta.assignment_status_id = ts.task_status_id
517: AND ts.cancelled_flag = 'Y';
518:
519: CURSOR c_assignment_info IS
520: SELECT object_version_number
521: FROM jtf_task_assignments
522: WHERE task_assignment_id = x_task_assignment_id;
523:
524: l_cancelled_assignments c_cancelled_assignments%ROWTYPE;
525: l_trans_valid VARCHAR2(1);
609: , x_task_object_version_number => x_task_object_version_number
610: , x_task_status_id => x_task_status_id
611: );
612: ELSE
613: jtf_task_assignments_pub.create_task_assignment(
614: p_api_version => 1.0
615: , x_return_status => x_return_status
616: , x_msg_count => x_msg_count
617: , x_msg_data => x_msg_data
786:
787: -- cursor to fetch Information about the Task Assignment.
788: CURSOR c_task_assignment_info IS
789: SELECT ta.assignment_status_id, ta.task_id
790: FROM jtf_task_assignments ta
791: WHERE task_assignment_id = p_task_assignment_id;
792:
793: l_task_id NUMBER;
794: l_old_assignment_status_id NUMBER;
815: FETCH c_task_assignment_info INTO l_old_assignment_status_id, l_task_id;
816: CLOSE c_task_assignment_info;
817:
818: -- We require Task Id for computations. If the caller doesnt pass Task Id
819: -- lets retrieve it from JTF_TASK_ASSIGNMENTS. If the caller has indeeed
820: -- passed it, then use that value.
821: IF p_task_id <> fnd_api.g_miss_num AND p_task_id IS NOT NULL THEN
822: l_task_id := p_task_id;
823: END IF;
878: END IF;
879: END IF;
880: END IF;
881:
882: jtf_task_assignments_pub.update_task_assignment(
883: p_api_version => 1.0
884: , x_return_status => x_return_status
885: , x_msg_count => x_msg_count
886: , x_msg_data => x_msg_data
1055:
1056: -- cursor to fetch Information about the Task Assignment.
1057: CURSOR c_task_assignment_info IS
1058: SELECT ta.assignment_status_id
1059: FROM jtf_task_assignments ta
1060: WHERE task_assignment_id = p_task_assignment_id;
1061:
1062: -- Fetch the Cancelled Flag corresponding to the new Task Status.
1063: CURSOR c_task_status_info IS
1118: l_trip_id := csf_util_pvt.get_miss_num;
1119: END IF;
1120:
1121: -- Update the Task Assignment.
1122: jtf_task_assignments_pub.update_task_assignment(
1123: p_api_version => 1.0
1124: , x_return_status => x_return_status
1125: , x_msg_count => x_msg_count
1126: , x_msg_data => x_msg_data