744: --===========================================================================
745:
746: FUNCTION GET_PROJECT_NUM(p_project_id IN NUMBER) --Fixing bug#8478003
747: RETURN VARCHAR2 IS
748: l_project_num PA_PROJECTS_ALL.Segment1%type:=null;
749: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
750: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
751: l_proc_name VARCHAR2(100) :='GET_PROJECT_NUM';
752: BEGIN
769: RETURN NULL;
770: ELSE
771: SELECT ppa.SEGMENT1
772: INTO l_project_num
773: FROM PA_PROJECTS_ALL ppa
774: WHERE ppa.PROJECT_ID = p_project_id;
775: RETURN l_project_num;
776: END IF;
777: