DBA Data[Home] [Help]

APPS.AP_WEB_DB_PA_INT_PKG dependencies on PA_PROJECTS_ALL

Line 172: l_project_number PA_PROJECTS_ALL.segment1%type;

168: FUNCTION GetProjectNumber(
169: p_project_id IN proj_projID
170: ) RETURN VARCHAR2 IS
171: -------------------------------------------------------------------
172: l_project_number PA_PROJECTS_ALL.segment1%type;
173: BEGIN
174: select segment1 --project number
175: into l_project_number
176: from PA_PROJECTS_ALL

Line 176: from PA_PROJECTS_ALL

172: l_project_number PA_PROJECTS_ALL.segment1%type;
173: BEGIN
174: select segment1 --project number
175: into l_project_number
176: from PA_PROJECTS_ALL
177: where project_id = p_project_id;
178:
179: RETURN l_project_number;
180: EXCEPTION

Line 198: from pa_projects_all

194: -------------------------------------------------------------------
195: BEGIN
196: select segment1, name
197: into p_project_number, p_project_name
198: from pa_projects_all
199: where project_id = p_project_id;
200:
201: RETURN TRUE;
202: EXCEPTION