APPS.PA_FIN_PLAN_TYPE_GLOBAL dependencies on PA_FIN_PLAN_TYPES_B

Line 27: -- p_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,

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
31: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 231: from pa_fin_plan_types_b

227: plan_type_versions_rec plan_type_versions_csr%ROWTYPE;
228:
229: cursor plan_type_code_csr is
230: select fin_plan_type_code
231: from pa_fin_plan_types_b
232: where fin_plan_type_id = p_fin_plan_type_id;
233: plan_type_code_rec plan_type_code_csr%ROWTYPE;
234:
235: -- Bug 3619687 Cursor to return all the fp options that need to be

Line 273: l_def_gen_src_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

269: AND o.fin_plan_type_id = pt.fin_plan_type_id
270: AND nvl(pt.use_for_workplan_flag, 'N') = 'N'
271: ORDER BY name ASC;
272:
273: l_def_gen_src_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
274: l_def_gen_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
275:
276: -- error handling variables
277: l_msg_count NUMBER := 0;

Line 274: l_def_gen_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

270: AND nvl(pt.use_for_workplan_flag, 'N') = 'N'
271: ORDER BY name ASC;
272:
273: l_def_gen_src_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
274: l_def_gen_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
275:
276: -- error handling variables
277: l_msg_count NUMBER := 0;
278: l_data VARCHAR2(2000);

Line 514: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

510: FUNCTION plantype_to_planclass
511: (p_project_id IN pa_proj_fp_options.project_id%TYPE,
512: p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE)
513: return VARCHAR2 is
514: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
515: l_approved_cost_pt_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;
516: l_approved_rev_pt_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;
517: l_return_value VARCHAR2(80);
518: BEGIN

Line 515: l_approved_cost_pt_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;

511: (p_project_id IN pa_proj_fp_options.project_id%TYPE,
512: p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE)
513: return VARCHAR2 is
514: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
515: l_approved_cost_pt_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;
516: l_approved_rev_pt_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;
517: l_return_value VARCHAR2(80);
518: BEGIN
519: select plan_class_code

Line 516: l_approved_rev_pt_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;

512: p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE)
513: return VARCHAR2 is
514: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
515: l_approved_cost_pt_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;
516: l_approved_rev_pt_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;
517: l_return_value VARCHAR2(80);
518: BEGIN
519: select plan_class_code
520: into l_plan_class_code

Line 521: from pa_fin_plan_types_b

517: l_return_value VARCHAR2(80);
518: BEGIN
519: select plan_class_code
520: into l_plan_class_code
521: from pa_fin_plan_types_b
522: where fin_plan_type_id = p_fin_plan_type_id;
523: select approved_cost_plan_type_flag,
524: approved_rev_plan_type_flag
525: into l_approved_cost_pt_flag,