APPS.PA_PLANNING_ELEMENT_UTILS dependencies on PA_PROJECTS_ALL

Line 21: l_edit_plan_project_id pa_projects_all.project_id%TYPE;

17: */
18:
19: --These variables are internally used by the API get_fin_struct_id. They should not be used by other
20: --APIs in this package. These are created for bug 3546208
21: l_edit_plan_project_id pa_projects_all.project_id%TYPE;
22: l_edit_plan_struct_id pa_budget_versions.project_structure_version_id%TYPE;
23: l_edit_plan_bv_id pa_budget_versions.budget_version_id%TYPE;
24:
25: PROCEDURE get_workplan_bvids

Line 367: pa_projects_all pa

363: -- GET PROJECT NAME AND NUMBER
364: select pa.name || ' (' || pa.segment1 || ')'
365: into l_return_value
366: from pa_resource_assignments ra,
367: pa_projects_all pa
368: where ra.resource_assignment_id = p_resource_assignment_id and
369: ra.project_id = pa.project_id;
370: else
371: -- GET TASK NAME AND NUMBER

Line 681: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,

677: */
678: PROCEDURE get_common_budget_version_info
679: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
680: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
681: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
682: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
683: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
684: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
685: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),

Line 682: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

678: PROCEDURE get_common_budget_version_info
679: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
680: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
681: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
682: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
683: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
684: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
685: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
686: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 1515: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,

1511: */
1512: PROCEDURE get_common_bv_info_fcst
1513: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1514: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
1515: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
1516: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
1517: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
1518: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
1519: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),

Line 1516: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

1512: PROCEDURE get_common_bv_info_fcst
1513: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1514: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
1515: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
1516: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
1517: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
1518: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
1519: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
1520: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 3121: FUNCTION get_fin_struct_id(p_project_id pa_projects_all.project_id%TYPE,

3117: END get_bv_name_from_id;
3118:
3119: --Created for bug 3546208. This function will return the financial structure version id for the project
3120: --id passed.
3121: FUNCTION get_fin_struct_id(p_project_id pa_projects_all.project_id%TYPE,
3122: p_budget_version_id pa_budget_versions.budget_Version_id%TYPE)
3123: RETURN NUMBER
3124: IS
3125: BEGIN

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

3147: -- This function returns the wbs element name, either from the wbs_element_version_id
3148: -- or from the proj_element_id. If using proj_element_id, then p_use_element_version_id_flag
3149: -- must be set to 'N'
3150: FUNCTION get_wbs_element_name_from_id
3151: (p_project_id IN pa_projects_all.project_id%TYPE,
3152: p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE,
3153: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
3154: p_use_element_version_flag IN VARCHAR2)
3155: return VARCHAR2

Line 3161: from pa_projects_all

3157: l_return_value pa_proj_elements.name%TYPE;
3158: BEGIN
3159: select name
3160: into l_return_value
3161: from pa_projects_all
3162: where project_id = p_project_id;
3163: -- if wbs_element_version_id is 0 or -1, then it is a project-level row
3164: if p_wbs_element_version_id = 0 or p_wbs_element_version_id = -1 then
3165: return l_return_value;

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

3229: END get_rbs_element_name_from_id;
3230:
3231:
3232: FUNCTION get_task_percent_complete
3233: (p_project_id IN pa_projects_all.project_id%TYPE,
3234: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3235: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
3236: p_calling_context IN VARCHAR2) return NUMBER
3237: is

Line 3316: p_project_id IN pa_projects_all.project_id%TYPE

3312: of same plan type
3313: */
3314: FUNCTION get_prior_forecast_version_id
3315: (p_plan_version_id IN pa_budget_versions.budget_version_id%TYPE,
3316: p_project_id IN pa_projects_all.project_id%TYPE
3317: ) return NUMBER
3318: is
3319: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
3320: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;