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_BUDGET_VERSIONS

Line 22: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

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
26: x_proj_fp_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895

Line 24: x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895

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
26: x_proj_fp_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
27: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
28: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 25: x_plan_processing_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE, --File.Sql.39 bug 4440895

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
26: x_proj_fp_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
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

Line 30: l_version_type pa_budget_versions.version_type%type;

26: x_proj_fp_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
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;

Line 46: l_bdgt_version_id pa_budget_versions.budget_version_id%TYPE; -- Added for bug 4089561

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
47: l_approved_rev_plan_type_flag VARCHAR2(1);
48:
49:
50: BEGIN

Line 642: p_version_type IN pa_budget_versions.version_type%TYPE,

638: for page. */
639:
640: PROCEDURE get_app_budget_pt_id(
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

Line 800: p_version_type IN pa_budget_versions.version_type%TYPE,

796: option selected in the Project Home. If the plan type does not exist, then
797: the URL will be returned with appropriate information. */
798: PROCEDURE get_fcst_plan_type_id(
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

Line 960: p_version_type IN pa_budget_versions.version_type%TYPE,

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,
964: p_context IN VARCHAR2,

Line 965: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%type, --File.Sql.39 bug 4440895

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
966: x_redirect_url OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
967: x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895
968: x_plan_processing_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE, --File.Sql.39 bug 4440895
969: x_proj_fp_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895

Line 967: x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895

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
966: x_redirect_url OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
967: x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895
968: x_plan_processing_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE, --File.Sql.39 bug 4440895
969: x_proj_fp_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
970: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
971: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 968: x_plan_processing_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE, --File.Sql.39 bug 4440895

964: p_context IN VARCHAR2,
965: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%type, --File.Sql.39 bug 4440895
966: x_redirect_url OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
967: x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895
968: x_plan_processing_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE, --File.Sql.39 bug 4440895
969: x_proj_fp_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
970: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
971: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
972: x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895

Line 973: l_locked_by_person_id pa_budget_versions.locked_by_person_id%type;

969: x_proj_fp_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
970: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
971: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
972: x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
973: l_locked_by_person_id pa_budget_versions.locked_by_person_id%type;
974: l_budget_status_code pa_budget_versions.budget_status_code%type;
975: l_rec_ver_number pa_budget_versions.record_version_number%type;
976: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%type;
977: l_person_id NUMBER;

Line 974: l_budget_status_code pa_budget_versions.budget_status_code%type;

970: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
971: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
972: x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
973: l_locked_by_person_id pa_budget_versions.locked_by_person_id%type;
974: l_budget_status_code pa_budget_versions.budget_status_code%type;
975: l_rec_ver_number pa_budget_versions.record_version_number%type;
976: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%type;
977: l_person_id NUMBER;
978: l_resource_id NUMBER;

Line 975: l_rec_ver_number pa_budget_versions.record_version_number%type;

971: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
972: x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
973: l_locked_by_person_id pa_budget_versions.locked_by_person_id%type;
974: l_budget_status_code pa_budget_versions.budget_status_code%type;
975: l_rec_ver_number pa_budget_versions.record_version_number%type;
976: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%type;
977: l_person_id NUMBER;
978: l_resource_id NUMBER;
979: l_resource_name VARCHAR2(200);

Line 983: /* l_process_wbs_flag pa_budget_versions.process_update_wbs_flag%TYPE; * 3604167 */

979: l_resource_name VARCHAR2(200);
980: l_webadi_enabled_flag VARCHAR2(30);
981: l_msg_code varchar2(30);
982: l_fp_opt_id pa_proj_fp_options.proj_fp_options_id%type;
983: /* l_process_wbs_flag pa_budget_versions.process_update_wbs_flag%TYPE; * 3604167 */
984: l_editable_flag VARCHAR2(1) := 'Y';
985: BEGIN
986: x_return_status := FND_API.G_RET_STS_SUCCESS;
987: l_webadi_enabled_flag := nvl(FND_PROFILE.value('PA_FP_WEBADI_ENABLE'), 'N');

Line 1020: FROM pa_budget_versions bv

1016: l_rec_ver_number,
1017: x_request_id,
1018: x_plan_processing_code
1019: -- l_process_wbs_flag
1020: FROM pa_budget_versions bv
1021: WHERE project_id = p_project_id AND
1022: fin_plan_type_id = p_fin_plan_type_id AND
1023: current_working_Flag ='Y' AND
1024: version_type IN (p_version_type,'ALL');