APPS.PA_FIN_PLAN_TYPE_GLOBAL dependencies on PA_BUDGET_VERSIONS

Line 26: (p_project_id IN pa_budget_versions.project_id%TYPE,

22: END Get_Plan_Class_Code;
23: */
24:
25: PROCEDURE set_global_variables
26: (p_project_id IN pa_budget_versions.project_id%TYPE,
27: -- p_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
28: x_factor_by_code OUT NOCOPY pa_proj_fp_options.factor_by_code%TYPE, --File.Sql.39 bug 4440895
29: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
30: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 66: from pa_budget_versions

62: )
63: IS
64: cursor cb_csr is
65: select budget_version_id
66: from pa_budget_versions
67: where project_id = p_project_id and
68: fin_plan_type_id = p_plan_type_id and
69: version_type = 'ORG_FORECAST' and
70: current_flag = 'Y';

Line 75: from pa_budget_versions

71: cb_rec cb_csr%ROWTYPE;
72:
73: cursor cw_csr is
74: select budget_version_id
75: from pa_budget_versions
76: where project_id = p_project_id and
77: fin_plan_type_id = p_plan_type_id and
78: version_type = 'ORG_FORECAST' and
79: current_working_flag = 'Y';

Line 128: from pa_budget_versions

124:
125: -- we will get only one version per cursor
126: cursor working_cost_csr is
127: select budget_version_id
128: from pa_budget_versions
129: where project_id = p_project_id and
130: fin_plan_type_id = p_plan_type_id and
131: version_type in ('COST', 'ALL') and
132: current_working_flag = 'Y';

Line 137: from pa_budget_versions

133: working_cost_rec working_cost_csr%ROWTYPE;
134:
135: cursor working_revenue_csr is
136: select budget_version_id
137: from pa_budget_versions
138: where project_id = p_project_id and
139: fin_plan_type_id = p_plan_type_id and
140: version_type in ('REVENUE', 'ALL') and
141: current_working_flag = 'Y';

Line 146: from pa_budget_versions

142: working_revenue_rec working_revenue_csr%ROWTYPE;
143:
144: cursor baselined_cost_csr is
145: select budget_version_id
146: from pa_budget_versions
147: where project_id = p_project_id and
148: fin_plan_type_id = p_plan_type_id and
149: version_type in ('COST', 'ALL') and
150: current_flag = 'Y';

Line 155: from pa_budget_versions

151: baselined_cost_rec baselined_cost_csr%ROWTYPE;
152:
153: cursor baselined_revenue_csr is
154: select budget_version_id
155: from pa_budget_versions
156: where project_id = p_project_id and
157: fin_plan_type_id = p_plan_type_id and
158: version_type in ('REVENUE', 'ALL') and
159: current_flag = 'Y';

Line 215: (p_project_id IN pa_budget_versions.project_id%TYPE,

211: END pa_fp_get_finplan_version_id;
212: /* ------------------------------------------------------------------- */
213:
214: PROCEDURE delete_plan_type_from_project
215: (p_project_id IN pa_budget_versions.project_id%TYPE,
216: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
217: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
218: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
219: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 216: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,

212: /* ------------------------------------------------------------------- */
213:
214: PROCEDURE delete_plan_type_from_project
215: (p_project_id IN pa_budget_versions.project_id%TYPE,
216: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
217: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
218: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
219: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
220: is

Line 224: from pa_budget_versions

220: is
221:
222: cursor plan_type_versions_csr is
223: select budget_version_id
224: from pa_budget_versions
225: where project_id = p_project_id and
226: fin_plan_type_id = p_fin_plan_type_id;
227: plan_type_versions_rec plan_type_versions_csr%ROWTYPE;
228:

Line 569: (p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE)

565: -- APPROVED_BUDGET - if the version is an approved budget plan class
566: -- NON_APPROVED_BUDGET - if the version is a non-approved budget plan class
567: -- This is used for FUNCTION SECURITY checks in Budgeting/Forecasting OA pages
568: FUNCTION planversion_to_planclass
569: (p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE)
570: return VARCHAR2 is
571: l_return_value VARCHAR2(80);
572: BEGIN
573: return l_return_value;