APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_PROJECTS_ALL

Line 350: from pa_projects_all

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

Line 376: from pa_projects_all

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

Line 401: from pa_projects_all

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

Line 429: from pa_projects_all

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

Line 499: from pa_projects_all

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

Line 517: from pa_projects_all

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

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

4810: END calc_margin_percent;
4811: /* --------------------------------------------------------------------- */
4812:
4813: PROCEDURE refresh_period_profile
4814: (p_project_id IN pa_projects_all.project_id%TYPE,
4815: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
4816: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
4817: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4818: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895