286: END IF;
287:
288: SELECT jtf_task_template_number_s.nextval
289: INTO l_task_number
290: FROM dual;
291: ELSE
292: SELECT jtf_task_templates_s.nextval
293: INTO l_task_id
294: FROM dual;
290: FROM dual;
291: ELSE
292: SELECT jtf_task_templates_s.nextval
293: INTO l_task_id
294: FROM dual;
295: SELECT jtf_task_template_number_s.nextval
296: INTO l_task_number
297: FROM dual;
298: END IF;
293: INTO l_task_id
294: FROM dual;
295: SELECT jtf_task_template_number_s.nextval
296: INTO l_task_number
297: FROM dual;
298: END IF;
299:
300: BEGIN
301: SELECT 1