eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 295: l_def_gen_src_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

291: WHERE rbs_version_id = c_rbs_version_id
292: AND project_id=c_project_id
293: AND fin_plan_option_level_code = 'PLAN_TYPE';
294:
295: l_def_gen_src_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
296: l_def_gen_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
297:
298: -- error handling variables
299: l_msg_count NUMBER := 0;

Line 296: l_def_gen_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

292: AND project_id=c_project_id
293: AND fin_plan_option_level_code = 'PLAN_TYPE';
294:
295: l_def_gen_src_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
296: l_def_gen_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
297:
298: -- error handling variables
299: l_msg_count NUMBER := 0;
300: l_data VARCHAR2(2000);

Line 588: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

584: FUNCTION plantype_to_planclass
585: (p_project_id IN pa_proj_fp_options.project_id%TYPE,
586: p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE)
587: return VARCHAR2 is
588: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
589: l_approved_cost_pt_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;
590: l_approved_rev_pt_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;
591: l_return_value VARCHAR2(80);
592: BEGIN

Line 589: l_approved_cost_pt_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;

585: (p_project_id IN pa_proj_fp_options.project_id%TYPE,
586: p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE)
587: return VARCHAR2 is
588: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
589: l_approved_cost_pt_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;
590: l_approved_rev_pt_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;
591: l_return_value VARCHAR2(80);
592: BEGIN
593: select plan_class_code

Line 590: l_approved_rev_pt_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;

586: p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE)
587: return VARCHAR2 is
588: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
589: l_approved_cost_pt_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;
590: l_approved_rev_pt_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;
591: l_return_value VARCHAR2(80);
592: BEGIN
593: select plan_class_code
594: into l_plan_class_code

Line 595: from pa_fin_plan_types_b

591: l_return_value VARCHAR2(80);
592: BEGIN
593: select plan_class_code
594: into l_plan_class_code
595: from pa_fin_plan_types_b
596: where fin_plan_type_id = p_fin_plan_type_id;
597: select approved_cost_plan_type_flag,
598: approved_rev_plan_type_flag
599: into l_approved_cost_pt_flag,