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_PROJ_FP_OPTIONS

Line 26: x_proj_fp_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_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
30: l_version_type pa_budget_versions.version_type%type;

Line 35: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%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;
37: l_msg_count NUMBER;
38: l_msg_data VARCHAR2(2000);
39: l_data VARCHAR2(2000);

Line 43: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

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

Line 44: l_temp_pref_code pa_proj_fp_options.fin_plan_preference_code%type;

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

Line 147: FROM pa_proj_fp_options

143: IF p_context IS NULL THEN
144:
145: SELECT NVL(approved_rev_plan_type_flag,'N')
146: INTO l_approved_rev_plan_type_flag
147: FROM pa_proj_fp_options
148: WHERE Project_Id = p_project_id
149: AND fin_plan_type_id = px_fin_plan_type_id
150: AND fin_plan_version_id IS NULL
151: AND fin_plan_option_level_code = 'PLAN_TYPE';

Line 391: FROM pa_proj_fp_options po

387: x_log_level => 3);
388: END IF;
389:
390: SELECT po.fin_plan_preference_code INTO l_fin_plan_preference_code
391: FROM pa_proj_fp_options po
392: WHERE po.project_id = p_project_id AND
393: po.fin_plan_option_level_code = 'PLAN_TYPE' AND
394: po.fin_plan_type_id = px_fin_plan_type_id;
395:

Line 446: FROM pa_proj_fp_options

442: END IF;
443: BEGIN
444: SELECT fin_plan_preference_code
445: INTO l_temp_pref_code
446: FROM pa_proj_fp_options
447: WHERE project_id = p_project_id
448: AND fin_plan_type_id = l_cost_fin_plan_type_id
449: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
450: EXCEPTION

Line 653: FROM pa_proj_fp_options po,

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

Line 667: FROM pa_proj_fp_options po,

663:
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

Line 680: FROM pa_proj_fp_options po,

676:
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

Line 812: FROM pa_proj_fp_options po,

808:
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

Line 826: FROM pa_proj_fp_options po,

822:
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

Line 839: FROM pa_proj_fp_options po,

835:
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

Line 969: x_proj_fp_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895

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
973: l_locked_by_person_id pa_budget_versions.locked_by_person_id%type;

Line 976: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%type;

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);
980: l_webadi_enabled_flag VARCHAR2(30);

Line 982: l_fp_opt_id pa_proj_fp_options.proj_fp_options_id%type;

978: l_resource_id NUMBER;
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;

Line 994: FROM pa_proj_fp_options

990:
991: SELECT fin_plan_preference_code,
992: proj_fp_options_id
993: INTO l_fin_plan_preference_code,l_fp_opt_id
994: FROM pa_proj_fp_options
995: WHERE
996: project_id = p_project_id AND
997: fin_plan_option_level_code = 'PLAN_TYPE' AND
998: fin_plan_type_id = p_fin_plan_type_id;