1644: BEGIN
1645: ---8430171
1646: SELECT name
1647: INTO l_project_name
1648: FROM PA_PROJECTS_ALL
1649: WHERE PROJECT_ID = l_project_id and rownum=1 ;
1650: EXCEPTION
1651: WHEN no_data_found THEN
1652: IF (l_debug = 1) THEN
1649: WHERE PROJECT_ID = l_project_id and rownum=1 ;
1650: EXCEPTION
1651: WHEN no_data_found THEN
1652: IF (l_debug = 1) THEN
1653: trace('No record found in PA_PROJECTS_ALL with l_project_id as :- '|| l_project_id);
1654: END IF;
1655: END;
1656: END IF;
1657: