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 3165: FUNCTION get_fin_struct_id(p_project_id pa_projects_all.project_id%TYPE,

3161: END get_bv_name_from_id;
3162:
3163: --Created for bug 3546208. This function will return the financial structure version id for the project
3164: --id passed.
3165: FUNCTION get_fin_struct_id(p_project_id pa_projects_all.project_id%TYPE,
3166: p_budget_version_id pa_budget_versions.budget_Version_id%TYPE)
3167: RETURN NUMBER
3168: IS
3169: BEGIN

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

3191: -- This function returns the wbs element name, either from the wbs_element_version_id
3192: -- or from the proj_element_id. If using proj_element_id, then p_use_element_version_id_flag
3193: -- must be set to 'N'
3194: FUNCTION get_wbs_element_name_from_id
3195: (p_project_id IN pa_projects_all.project_id%TYPE,
3196: p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE,
3197: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
3198: p_use_element_version_flag IN VARCHAR2)
3199: return VARCHAR2

Line 3205: from pa_projects_all

3201: l_return_value pa_proj_elements.name%TYPE;
3202: BEGIN
3203: select name
3204: into l_return_value
3205: from pa_projects_all
3206: where project_id = p_project_id;
3207: -- if wbs_element_version_id is 0 or -1, then it is a project-level row
3208: if p_wbs_element_version_id = 0 or p_wbs_element_version_id = -1 then
3209: return l_return_value;

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

3273: END get_rbs_element_name_from_id;
3274:
3275:
3276: FUNCTION get_task_percent_complete
3277: (p_project_id IN pa_projects_all.project_id%TYPE,
3278: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3279: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
3280: p_calling_context IN VARCHAR2) return NUMBER
3281: is

Line 3360: p_project_id IN pa_projects_all.project_id%TYPE

3356: of same plan type
3357: */
3358: FUNCTION get_prior_forecast_version_id
3359: (p_plan_version_id IN pa_budget_versions.budget_version_id%TYPE,
3360: p_project_id IN pa_projects_all.project_id%TYPE
3361: ) return NUMBER
3362: is
3363: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
3364: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;