ACS3 Data Model

     1: function im_project_ticket_project_id ( v_group_id IN integer )
     2: RETURN integer
     3: IS
     4:   v_project_id    ticket_projects.project_id%TYPE;
     5: BEGIN
     6:   v_project_id := 0;
     7:   BEGIN
     8:     select project_id into v_project_id from ticket_projects where group_id=v_group_id;
     9:     EXCEPTION WHEN OTHERS THEN NULL;
    10:   END;
    11:   return v_project_id;
    12: END;