APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_BUDGET_VERSIONS

Line 63: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

59: p_element_type IN VARCHAR2)
60: return VARCHAR2;
61:
62: procedure assign_default_amount
63: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
64: x_default_amount_type_code OUT NOCOPY pa_proj_periods_denorm.amount_type_code%TYPE, --File.Sql.39 bug 4440895
65: x_default_amount_subtype_code OUT NOCOPY pa_proj_periods_denorm.amount_subtype_code%TYPE, --File.Sql.39 bug 4440895
66: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
67: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 72: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

68: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
69:
70: function get_period_n_value
71: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
72: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
73: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
74: p_project_currency_type IN VARCHAR2,
75: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
76: p_period_number IN NUMBER) return NUMBER;

Line 85: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,

81:
82:
83: procedure refresh_period_profile
84: (p_project_id IN pa_projects_all.project_id%TYPE,
85: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
86: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
87: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
88: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
89: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 86: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,

82:
83: procedure refresh_period_profile
84: (p_project_id IN pa_projects_all.project_id%TYPE,
85: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
86: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
87: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
88: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
89: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
90:

Line 92: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

88: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
89: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
90:
91: function has_period_profile_id
92: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
93: return VARCHAR2;
94:
95: procedure roll_up_budget_lines
96: (p_budget_version_id in pa_budget_versions.budget_version_id%TYPE,

Line 96: (p_budget_version_id in pa_budget_versions.budget_version_id%TYPE,

92: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
93: return VARCHAR2;
94:
95: procedure roll_up_budget_lines
96: (p_budget_version_id in pa_budget_versions.budget_version_id%TYPE,
97: p_cost_or_rev in VARCHAR2);
98:
99: -- FP L: used in View/Edit Plan page whenever navigation option to View/Edit
100: -- Plan Line page is chosen. If the resource assignment has been deleted by

Line 118: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

114: -- PLANNING LEVEL OF THE VERSION.
115: -- ** p_entered_amts_only_flag = 'Y' if this is used by the View Plan page
116: -- (query only rows with entered amts), and 'N' if used by Edit Plan page
117: procedure get_plan_version_res_level
118: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
119: p_entered_amts_only_flag IN VARCHAR2,
120: x_resource_level OUT NOCOPY VARCHAR2, -- 'R' = resource, 'G' = resource group, --File.Sql.39 bug 4440895
121: -- 'M' = mixed, 'N' = not applicable (ungrouped resource list)
122: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895