[Home] [Help]
711: p_task_type varchar2,
712: p_text_right varchar2)
713: is
714: begin
715: INSERT INTO FWK_TBX_PROJECT_DETAILS
716: ( PROJECT_ID,
717: TOP_TASK_ID,
718: TASK_ID,
719: TASK_NUMBER,
740: sysdate,
741: 0
742: FROM DUAL
743: WHERE not exists (SELECT null
744: FROM FWK_TBX_PROJECT_DETAILS
745: WHERE TASK_ID = p_task_id);
746:
747: end insert_project_detail;
748: