10: -------------------------------------------------------------------
11: BEGIN
12: select PROJECT_NUMBER
13: into p_project_number
14: from PA_PROJECTS_EXPEND_V
15: where PROJECT_ID = p_project_id;
16:
17: RETURN TRUE;
18:
37: -------------------------------------------------------------------
38: BEGIN
39: select PROJECT_ID, PROJECT_NAME
40: into p_project_id, p_project_name
41: from PA_PROJECTS_EXPEND_V
42: where PROJECT_NUMBER = p_project_number;
43:
44: RETURN TRUE;
45: EXCEPTION
147: -------------------------------------------------------------------
148: BEGIN
149: select PROJECT_ID
150: into p_project_id
151: from PA_PROJECTS_EXPEND_V
152: where PROJECT_NUMBER = p_project_number;
153:
154: RETURN TRUE;
155: EXCEPTION