482: l_status_id := 8;
483:
484: SELECT OBJECT_VERSION_NUMBER
485: INTO l_object_version_number
486: FROM JTF_TASKS_B
487: WHERE TASK_ID = P_TASK_ID;
488:
489: SELECT JTF_NOTE_ID
490: INTO l_note_id
628: ELSIF( COMPLETION_STATUS = 'UNASSIGNED' ) THEN
629: l_status_id := 13;
630: END IF;
631:
632: SELECT JTF_TASKS_B.OBJECT_VERSION_NUMBER
633: INTO l_object_version_number
634: FROM JTF_TASKS_B
635: WHERE TASK_ID = P_TASK_ID;
636:
630: END IF;
631:
632: SELECT JTF_TASKS_B.OBJECT_VERSION_NUMBER
633: INTO l_object_version_number
634: FROM JTF_TASKS_B
635: WHERE TASK_ID = P_TASK_ID;
636:
637:
638: --DBMS_OUTPUT.PUT_LINE('Task '||task_id||' status = '||l_status_id||