DBA Data[Home] [Help]

APPS.PA_PROJECT_SET_UTILS dependencies on PA_PROJECTS_ALL

Line 258: l_project_name pa_projects_all.name%TYPE;

254: l_msg_data VARCHAR2(200);
255: l_exists VARCHAR2(4);
256: l_proj_set_name pa_project_sets_tl.name%TYPE;
257: l_project_list VARCHAR2(2000) := '';
258: l_project_name pa_projects_all.name%TYPE;
259: l_project_number pa_projects_all.segment1%TYPE;
260: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
261:
262: CURSOR get_proj_name_number(l_project_id IN NUMBER)

Line 259: l_project_number pa_projects_all.segment1%TYPE;

255: l_exists VARCHAR2(4);
256: l_proj_set_name pa_project_sets_tl.name%TYPE;
257: l_project_list VARCHAR2(2000) := '';
258: l_project_name pa_projects_all.name%TYPE;
259: l_project_number pa_projects_all.segment1%TYPE;
260: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
261:
262: CURSOR get_proj_name_number(l_project_id IN NUMBER)
263: IS

Line 265: FROM pa_projects_all

261:
262: CURSOR get_proj_name_number(l_project_id IN NUMBER)
263: IS
264: SELECT name, segment1
265: FROM pa_projects_all
266: WHERE project_id = l_project_id;
267:
268: BEGIN
269: