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_FP_SHORTCUTS_PKG dependencies on PA_FIN_PLAN_TYPES_B

Line 21: px_fin_plan_type_id IN OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895

17: p_function_code IN VARCHAR2,
18: p_context IN VARCHAR2 DEFAULT NULL,
19: p_user_id IN NUMBER,
20: p_same_org_id_flag IN VARCHAR2, -- Bug 5276024: Making this field mandatory -- DEFAULT 'N',
21: px_fin_plan_type_id IN OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
22: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
23: x_redirect_url OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24: x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895
25: x_plan_processing_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE, --File.Sql.39 bug 4440895

Line 31: l_plan_class_code pa_fin_plan_types_b.plan_class_code%type;

27: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
28: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
29: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
30: l_version_type pa_budget_versions.version_type%type;
31: l_plan_class_code pa_fin_plan_types_b.plan_class_code%type;
32: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%type;
33: l_edit_in_excel_flag VARCHAR2(1) := 'N';
34: l_no_of_fcst_plan_types NUMBER;
35: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%type;

Line 32: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%type;

28: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
29: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
30: l_version_type pa_budget_versions.version_type%type;
31: l_plan_class_code pa_fin_plan_types_b.plan_class_code%type;
32: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%type;
33: l_edit_in_excel_flag VARCHAR2(1) := 'N';
34: l_no_of_fcst_plan_types NUMBER;
35: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%type;
36: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

Line 41: l_cost_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%type;

37: l_msg_count NUMBER;
38: l_msg_data VARCHAR2(2000);
39: l_data VARCHAR2(2000);
40: l_msg_index_out NUMBER;
41: l_cost_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%type;
42: l_rev_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%type;
43: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
44: l_temp_pref_code pa_proj_fp_options.fin_plan_preference_code%type;
45: l_same_org_id VARCHAR2(1);

Line 42: l_rev_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%type;

38: l_msg_data VARCHAR2(2000);
39: l_data VARCHAR2(2000);
40: l_msg_index_out NUMBER;
41: l_cost_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%type;
42: l_rev_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%type;
43: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
44: l_temp_pref_code pa_proj_fp_options.fin_plan_preference_code%type;
45: l_same_org_id VARCHAR2(1);
46: l_bdgt_version_id pa_budget_versions.budget_version_id%TYPE; -- Added for bug 4089561

Line 645: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895

641: p_project_id IN pa_projects_all.project_id%TYPE,
642: p_version_type IN pa_budget_versions.version_type%TYPE,
643: p_context IN VARCHAR2,
644: p_function_code IN VARCHAR2 DEFAULT NULL,
645: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
646: x_redirect_url OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
647: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
648: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
649: x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895

Line 654: pa_fin_plan_types_b pt

650: CURSOR approved_budget_csr IS
651: SELECT pt.fin_plan_type_id,
652: po.fin_plan_preference_code
653: FROM pa_proj_fp_options po,
654: pa_fin_plan_types_b pt
655: WHERE po.project_id = p_project_id AND
656: po.fin_plan_option_level_code = 'PLAN_TYPE' AND
657: po.fin_plan_type_id = pt.fin_plan_type_id AND
658: (pt.approved_cost_plan_type_flag = 'Y' OR

Line 668: pa_fin_plan_types_b pt

664: CURSOR approved_cost_csr IS
665: SELECT pt.fin_plan_type_id,
666: po.fin_plan_preference_code
667: FROM pa_proj_fp_options po,
668: pa_fin_plan_types_b pt
669: WHERE po.project_id = p_project_id AND
670: po.fin_plan_option_level_code = 'PLAN_TYPE' AND
671: po.fin_plan_type_id = pt.fin_plan_type_id AND
672: po.fin_plan_preference_code <> 'REVENUE_ONLY' AND

Line 681: pa_fin_plan_types_b pt

677: CURSOR approved_revenue_csr IS
678: SELECT pt.fin_plan_type_id,
679: po.fin_plan_preference_code
680: FROM pa_proj_fp_options po,
681: pa_fin_plan_types_b pt
682: WHERE po.project_id = p_project_id AND
683: po.fin_plan_option_level_code = 'PLAN_TYPE' AND
684: po.fin_plan_type_id = pt.fin_plan_type_id AND
685: po.fin_plan_preference_code <> 'COST_ONLY' AND

Line 803: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895

799: p_project_id IN pa_projects_all.project_id%TYPE,
800: p_version_type IN pa_budget_versions.version_type%TYPE,
801: p_context IN VARCHAR2,
802: p_function_code IN VARCHAR2 DEFAULT NULL,
803: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
804: x_redirect_url OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
805: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
806: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
807: x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895

Line 813: pa_fin_plan_types_b pt

809: CURSOR primary_budget_csr IS
810: SELECT pt.fin_plan_type_id,
811: po.fin_plan_preference_code
812: FROM pa_proj_fp_options po,
813: pa_fin_plan_types_b pt
814: WHERE po.project_id = p_project_id AND
815: po.fin_plan_option_level_code = 'PLAN_TYPE' AND
816: po.fin_plan_type_id = pt.fin_plan_type_id AND
817: (pt.primary_cost_forecast_flag = 'Y' OR

Line 827: pa_fin_plan_types_b pt

823: CURSOR primary_cost_csr IS
824: SELECT pt.fin_plan_type_id,
825: po.fin_plan_preference_code
826: FROM pa_proj_fp_options po,
827: pa_fin_plan_types_b pt
828: WHERE po.project_id = p_project_id AND
829: po.fin_plan_option_level_code = 'PLAN_TYPE' AND
830: po.fin_plan_type_id = pt.fin_plan_type_id AND
831: po.fin_plan_preference_code <> 'REVENUE_ONLY' AND

Line 840: pa_fin_plan_types_b pt

836: CURSOR primary_revenue_csr IS
837: SELECT pt.fin_plan_type_id,
838: po.fin_plan_preference_code
839: FROM pa_proj_fp_options po,
840: pa_fin_plan_types_b pt
841: WHERE po.project_id = p_project_id AND
842: po.fin_plan_option_level_code = 'PLAN_TYPE' AND
843: po.fin_plan_type_id = pt.fin_plan_type_id AND
844: po.fin_plan_preference_code <> 'COST_ONLY' AND

Line 959: p_plan_class_code in pa_fin_plan_types_b.plan_class_Code%type,

955: if the version is either locked or in submitted status, then the URL will be set
956: for Budgeting and Forecasting page with appropriate error message. */
957:
958: PROCEDURE get_cw_version( p_project_id IN pa_projects_all.project_id%TYPE,
959: p_plan_class_code in pa_fin_plan_types_b.plan_class_Code%type,
960: p_version_type IN pa_budget_versions.version_type%TYPE,
961: p_fin_plan_type_id in pa_fin_plan_types_b.fin_plan_type_id%TYPE,
962: p_edit_in_excel_Flag IN varchar2,
963: p_user_id in number,

Line 961: p_fin_plan_type_id in pa_fin_plan_types_b.fin_plan_type_id%TYPE,

957:
958: PROCEDURE get_cw_version( p_project_id IN pa_projects_all.project_id%TYPE,
959: p_plan_class_code in pa_fin_plan_types_b.plan_class_Code%type,
960: p_version_type IN pa_budget_versions.version_type%TYPE,
961: p_fin_plan_type_id in pa_fin_plan_types_b.fin_plan_type_id%TYPE,
962: p_edit_in_excel_Flag IN varchar2,
963: p_user_id in number,
964: p_context IN VARCHAR2,
965: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%type, --File.Sql.39 bug 4440895