[Home] [Help]
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
71: AND ts.task_status_id (+) = ta.assignment_status_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'
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
780:
781: -- cursor to fetch the Cancelled Flag corresponding to the new Task Status.
782: CURSOR c_task_status_info IS
783: SELECT NVL (ts.cancelled_flag, 'N') cancelled_flag
784: FROM jtf_task_statuses_b ts
785: WHERE ts.task_status_id = p_assignment_status_id;
786:
787: -- cursor to fetch Information about the Task Assignment.
788: CURSOR c_task_assignment_info IS
1061:
1062: -- Fetch the Cancelled Flag corresponding to the new Task Status.
1063: CURSOR c_task_status_info IS
1064: SELECT NVL (ts.cancelled_flag, 'N') cancelled_flag
1065: FROM jtf_task_statuses_b ts
1066: WHERE ts.task_status_id = p_assignment_status_id;
1067:
1068: l_old_assignment_status_id NUMBER;
1069: l_new_sts_cancelled_flag VARCHAR2(1);