1151: ,p_organization OUT NOCOPY VARCHAR2) AS
1152: CURSOR c IS
1153: SELECT projects.name project_name
1154: ,org.name organization
1155: FROM pa_projects_all projects, hr_organization_units org
1156: WHERE projects.project_id = p_project_id
1157: AND projects.carrying_out_organization_id = org.organization_id;
1158: BEGIN
1159: FOR c_rec IN c
1322: l_project_name VARCHAR2 (100);
1323: BEGIN
1324: SELECT name
1325: INTO l_project_name
1326: FROM pa_projects_all
1327: WHERE project_id = p_project_id;
1328: RETURN l_project_name;
1329: EXCEPTION
1330: WHEN OTHERS
1593: l_project_name VARCHAR2 (100);
1594: BEGIN
1595: SELECT name
1596: INTO l_project_name
1597: FROM pa_projects_all
1598: WHERE project_id = p_project_id
1599: AND org_id = p_org_id;
1600:
1601: RETURN l_project_name;