APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_PROJECTS_ALL

Line 349: from pa_projects_all

345: if l_parent_task_id = -99 then
346: -- this task has no parent; so it must be a top-level task, so PARENT = PROJECT
347: select name || ' (' || segment1 || ')'
348: into l_return_value
349: from pa_projects_all
350: where project_id = p_project_id;
351: else
352: -- this task has a parent; so PARENT = TASK NAME
353: select task_name || ' (' || task_number || ')'

Line 375: from pa_projects_all

371: if l_parent_task_id = -99 then
372: -- this task has no parent; so it must be a top-level task, so PARENT = PROJECT
373: select name || ' (' || segment1 || ')'
374: into l_return_value
375: from pa_projects_all
376: where project_id = p_project_id;
377: else
378: -- this task has a parent; so PARENT = TASK NAME
379: select task_name || ' (' || task_number || ')'

Line 399: from pa_projects_all

395: if l_res_parent_member_id = -99 then
396: -- resource is RESOURCE PARENT: PARENT = PROJECT
397: select name || ' (' || segment1 || ')'
398: into l_return_value
399: from pa_projects_all
400: where project_id = p_project_id;
401: else
402: -- resource is RESOURCE CHILD: PARENT = RESOURCE GROUP NAME
403: /*

Line 427: from pa_projects_all

423: -- updated 11/5/02: PARENT should be TOP-LEVEL-TASK
424: /*
425: select name || ' (' || segment1 || ')'
426: into l_return_value
427: from pa_projects_all
428: where project_id = p_project_id;
429: */
430: select task_name || ' (' || task_number || ')'
431: into l_return_value

Line 497: from pa_projects_all

493: if p_task_id = 0 then
494: -- retrieve PROJECT NAME
495: select name || ' (' || segment1 || ')'
496: into l_return_value
497: from pa_projects_all
498: where project_id = p_project_id;
499: else
500: -- get TASK NAME
501: select task_name || ' (' || task_number || ')'

Line 515: from pa_projects_all

511: -- if both task and rlm id are 0, then this row is a PROJECT row
512: -- retrieve PROJECT NAME
513: select name || ' (' || segment1 || ')'
514: into l_return_value
515: from pa_projects_all
516: where project_id = p_project_id;
517: else
518: -- p_resource_list_member_id is 0, but p_task_id is not 0 --> TASK row
519: -- get TASK NAME

Line 4644: (p_project_id IN pa_projects_all.project_id%TYPE,

4640: END calc_margin_percent;
4641: /* --------------------------------------------------------------------- */
4642:
4643: PROCEDURE refresh_period_profile
4644: (p_project_id IN pa_projects_all.project_id%TYPE,
4645: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
4646: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
4647: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4648: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895