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_VIEW_PLANS_PUB dependencies on PA_PROJ_FP_OPTIONS

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

40: x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
41: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
42: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
43: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
44: x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
45: x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
46: x_factor_by_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
47: x_diff_pd_profile_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
48: x_old_pd_profile_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 91: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;

87: l_rev_version_number pa_budget_versions.version_number%TYPE;
88: l_cost_version_name pa_budget_versions.version_name%TYPE;
89: l_rev_version_name pa_budget_versions.version_name%TYPE;
90: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
91: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
92: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
93: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
94: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
95:

Line 92: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

88: l_cost_version_name pa_budget_versions.version_name%TYPE;
89: l_rev_version_name pa_budget_versions.version_name%TYPE;
90: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
91: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
92: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
93: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
94: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
95:
96: l_user_bv_flag VARCHAR2(1);

Line 93: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

89: l_rev_version_name pa_budget_versions.version_name%TYPE;
90: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
91: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
92: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
93: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
94: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
95:
96: l_user_bv_flag VARCHAR2(1);
97: l_is_cost_locked_by_user VARCHAR2(1);

Line 94: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

90: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
91: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
92: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
93: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
94: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
95:
96: l_user_bv_flag VARCHAR2(1);
97: l_is_cost_locked_by_user VARCHAR2(1);
98: l_cost_locked_by_person_id NUMBER;

Line 127: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

123: l_plan_processing_code2 pa_budget_versions.plan_processing_code%TYPE;
124: l_request_id pa_budget_versions.request_id%TYPE;
125:
126: -- variables for default settings
127: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
128: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
129: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE; --for costandrevsep
130: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE; --for costandrevtog
131: l_version_type pa_budget_versions.version_type%TYPE;

Line 195: from pa_proj_fp_options

191: -- default_amount_subtype_code
192: into ll_plan_start_date,ll_plan_end_date, l_fin_plan_type_id
193: -- l_default_amount_type_code,
194: -- l_default_amount_subtype_code
195: from pa_proj_fp_options
196: where fin_plan_version_id = p_orgfcst_version_id;
197:
198: -- PLAN CLASS CODE (for Plan Class Security: FPL)
199: x_plan_class_code := pa_fin_plan_type_global.plantype_to_planclass

Line 209: from pa_proj_fp_options

205: report_labor_hrs_from_code
206: into x_plan_fp_options_id, -- OUTPUT: x_plan_fp_options_id
207: l_margin_derived_from_code,
208: l_labor_hours_from_code
209: from pa_proj_fp_options
210: where project_id = l_project_id and
211: fin_plan_type_id = l_fin_plan_type_id and
212: fin_plan_option_level_code='PLAN_TYPE';
213: EXCEPTION

Line 270: pa_proj_fp_options po

266: l_version_type,
267: -- x_factor_by_code,
268: l_plan_pref_code
269: from pa_budget_versions bv,
270: pa_proj_fp_options po
271: where bv.budget_version_id = p_orgfcst_version_id and
272: bv.fin_plan_type_id = po.fin_plan_type_id and
273: po.project_id = l_project_id and
274: po.fin_plan_option_level_code = 'PLAN_TYPE';

Line 280: from pa_proj_fp_options po

276: -- *** 01/30/03: 2778424 - If PROJECT-LEVEL row does not exist, return 1
277: BEGIN
278: select nvl(po.factor_by_code, 1)
279: into x_factor_by_code -- OUTPUT: x_factor_by_code
280: from pa_proj_fp_options po
281: where po.project_id = l_project_id and
282: po.fin_plan_option_level_code = 'PROJECT';
283: EXCEPTION WHEN NO_DATA_FOUND THEN
284: x_factor_by_code := 1;

Line 412: from pa_proj_fp_options

408: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_user_rev_version_id;
409: end if;
410: select approved_rev_plan_type_flag
411: into x_ar_flag -- OUTPUT: x_ar_flag
412: from pa_proj_fp_options
413: where project_id = l_project_id and
414: fin_plan_type_id = l_fin_plan_type_id and
415: fin_plan_option_level_code='PLAN_TYPE';
416:

Line 662: from pa_proj_fp_options

658: -- also set preceding/succeeding periods flags
659: if pa_fp_view_plans_pub.G_DISPLAY_FROM = 'ANY' then
660: select nvl(all_time_phased_code, 'N')
661: into x_time_phase_code -- OUTPUT: x_time_phase_code
662: from pa_proj_fp_options
663: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID;
664: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
665: (pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID);
666: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods

Line 684: from pa_proj_fp_options

680: end if;
681: elsif pa_fp_view_plans_pub.G_DISPLAY_FROM = 'COST' then
682: select nvl(cost_time_phased_code, 'N')
683: into x_time_phase_code -- OUTPUT: x_time_phase_code
684: from pa_proj_fp_options
685: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
686: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
687: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID);
688: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods

Line 706: from pa_proj_fp_options

702: end if;
703: elsif pa_fp_view_plans_pub.G_DISPLAY_FROM = 'REVENUE' then
704: select nvl(revenue_time_phased_code, 'N')
705: into x_time_phase_code -- OUTPUT: x_time_phase_code
706: from pa_proj_fp_options
707: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
708: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
709: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID);
710: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods

Line 728: from pa_proj_fp_options

724: end if;
725: else
726: select nvl(cost_time_phased_code, 'N')
727: into l_cost_time_phase_code
728: from pa_proj_fp_options
729: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
730: select nvl(revenue_time_phased_code, 'N')
731: into l_rev_time_phase_code
732: from pa_proj_fp_options

Line 732: from pa_proj_fp_options

728: from pa_proj_fp_options
729: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
730: select nvl(revenue_time_phased_code, 'N')
731: into l_rev_time_phase_code
732: from pa_proj_fp_options
733: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
734: -- if cost and rev versions have different time phase codes, there is no way to
735: -- merge them in periodic view
736: if l_cost_time_phase_code <> l_rev_time_phase_code then

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

960: x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
961: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
962: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
963: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
964: x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
965: x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
966: x_factor_by_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
967: x_diff_pd_profile_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
968: x_old_pd_profile_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1004: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;

1000: l_rev_version_number pa_budget_versions.version_number%TYPE;
1001: l_cost_version_name pa_budget_versions.version_name%TYPE;
1002: l_rev_version_name pa_budget_versions.version_name%TYPE;
1003: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1004: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1005: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
1006: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
1007: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
1008:

Line 1005: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

1001: l_cost_version_name pa_budget_versions.version_name%TYPE;
1002: l_rev_version_name pa_budget_versions.version_name%TYPE;
1003: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1004: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1005: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
1006: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
1007: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
1008:
1009: l_user_bv_flag VARCHAR2(1);

Line 1006: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

1002: l_rev_version_name pa_budget_versions.version_name%TYPE;
1003: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1004: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1005: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
1006: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
1007: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
1008:
1009: l_user_bv_flag VARCHAR2(1);
1010: l_is_cost_locked_by_user VARCHAR2(1);

Line 1007: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

1003: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1004: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1005: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
1006: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
1007: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
1008:
1009: l_user_bv_flag VARCHAR2(1);
1010: l_is_cost_locked_by_user VARCHAR2(1);
1011: l_cost_locked_by_person_id NUMBER;

Line 1040: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

1036: l_display_revenue VARCHAR2(1);
1037: l_display_margin VARCHAR2(1);
1038: l_display_marginpct VARCHAR2(1);
1039:
1040: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1041: l_working_or_baselined VARCHAR2(30);
1042: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
1043: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
1044:

Line 1050: pa_proj_fp_options po

1046: select bv.budget_version_id,
1047: po.proj_fp_options_id,
1048: NVL(po.plan_in_multi_curr_flag, 'N') as plan_in_multi_curr_flag
1049: from pa_budget_versions bv,
1050: pa_proj_fp_options po
1051: where bv.project_id = p_project_id and
1052: bv.ci_id = p_ci_id and
1053: bv.budget_version_id = po.fin_plan_version_id and
1054: po.fin_plan_option_level_code='PLAN_VERSION';

Line 1057: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

1053: bv.budget_version_id = po.fin_plan_version_id and
1054: po.fin_plan_option_level_code='PLAN_VERSION';
1055: ci_rec ci_csr%ROWTYPE;
1056:
1057: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1058: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
1059: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1060: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1061: l_grouping_type VARCHAR2(30);

Line 1058: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

1054: po.fin_plan_option_level_code='PLAN_VERSION';
1055: ci_rec ci_csr%ROWTYPE;
1056:
1057: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1058: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
1059: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1060: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1061: l_grouping_type VARCHAR2(30);
1062: l_compl_grouping_type VARCHAR2(30);

Line 1059: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

1055: ci_rec ci_csr%ROWTYPE;
1056:
1057: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1058: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
1059: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1060: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1061: l_grouping_type VARCHAR2(30);
1062: l_compl_grouping_type VARCHAR2(30);
1063: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 1060: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;

1056:
1057: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1058: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
1059: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1060: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1061: l_grouping_type VARCHAR2(30);
1062: l_compl_grouping_type VARCHAR2(30);
1063: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1064: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 1063: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

1059: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1060: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1061: l_grouping_type VARCHAR2(30);
1062: l_compl_grouping_type VARCHAR2(30);
1063: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1064: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1065: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1066: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1067: l_rv_number pa_budget_versions.record_version_number%TYPE;

Line 1064: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

1060: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1061: l_grouping_type VARCHAR2(30);
1062: l_compl_grouping_type VARCHAR2(30);
1063: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1064: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1065: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1066: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1067: l_rv_number pa_budget_versions.record_version_number%TYPE;
1068: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;

Line 1128: from pa_proj_fp_options

1124: select fin_plan_type_id,
1125: proj_fp_options_id
1126: into l_fin_plan_type_id,
1127: l_proj_fp_options_id
1128: from pa_proj_fp_options
1129: where project_id = p_project_id and
1130: fin_plan_version_id = ci_rec.budget_version_id and
1131: fin_plan_option_level_code = 'PLAN_VERSION';
1132:

Line 1192: from pa_proj_fp_options

1188: end if;
1189: */
1190: select fin_plan_preference_code
1191: into l_fp_preference_code
1192: from pa_proj_fp_options
1193: where project_id = p_project_id and
1194: fin_plan_type_id = l_fin_plan_type_id and
1195: fin_plan_option_level_code = 'PLAN_TYPE';
1196:

Line 1202: from pa_proj_fp_options

1198: select report_labor_hrs_from_code,
1199: margin_derived_from_code
1200: into l_report_labor_hrs_from_code,
1201: l_margin_derived_code
1202: from pa_proj_fp_options
1203: where project_id = p_project_id and
1204: fin_plan_type_id = l_fin_plan_type_id and
1205: fin_plan_option_level_code = 'PLAN_TYPE';
1206: pa_fp_view_plans_pub.G_FP_CALC_QUANTITY_FROM := l_report_labor_hrs_from_code;

Line 1223: from pa_proj_fp_options

1219: -- set planning level code for page: P, T, L, or M
1220: /*
1221: select all_fin_plan_level_code
1222: into l_cost_planning_level
1223: from pa_proj_fp_options
1224: where proj_fp_options_id = l_proj_fp_options_id;
1225: x_planning_level := l_cost_planning_level;
1226: */
1227: x_cost_rv_number := l_rv_number;

Line 1243: from pa_proj_fp_options

1239: -- set planning level code for page: P, T, L, or M
1240: /*
1241: select cost_fin_plan_level_code
1242: into l_cost_planning_level
1243: from pa_proj_fp_options
1244: where proj_fp_options_id = l_proj_fp_options_id;
1245: x_planning_level := l_cost_planning_level;
1246: */
1247: x_cost_rv_number := l_rv_number;

Line 1263: from pa_proj_fp_options

1259: -- set planning level code for page: P, T, L, or M
1260: /*
1261: select revenue_fin_plan_level_code
1262: into l_rev_planning_level
1263: from pa_proj_fp_options
1264: where proj_fp_options_id = l_proj_fp_options_id;
1265: x_planning_level := l_rev_planning_level;
1266: */
1267: x_cost_rv_number := -1;

Line 1322: from pa_proj_fp_options

1318: -- planning level code for cost version: P, T, L, or M
1319: /*
1320: select cost_fin_plan_level_code
1321: into l_cost_planning_level
1322: from pa_proj_fp_options
1323: where proj_fp_options_id = l_proj_fp_options_id;
1324: -- planning level code for revenue (compl) version
1325: select revenue_fin_plan_level_code
1326: into l_rev_planning_level

Line 1327: from pa_proj_fp_options

1323: where proj_fp_options_id = l_proj_fp_options_id;
1324: -- planning level code for revenue (compl) version
1325: select revenue_fin_plan_level_code
1326: into l_rev_planning_level
1327: from pa_proj_fp_options
1328: where proj_fp_options_id = ci_rec.proj_fp_options_id;
1329: -- PLANNING LEVEL = 'P' if one of the planning levels is P
1330: if (l_cost_planning_level = 'P') or (l_rev_planning_level = 'P') then
1331: x_planning_level := 'P';

Line 1384: from pa_proj_fp_options

1380: -- planning level code for cost (compl) version: P, T, L, or M
1381: /*
1382: select cost_fin_plan_level_code
1383: into l_cost_planning_level
1384: from pa_proj_fp_options
1385: where proj_fp_options_id = ci_rec.proj_fp_options_id;
1386: -- planning level code for revenue version
1387: select revenue_fin_plan_level_code
1388: into l_rev_planning_level

Line 1389: from pa_proj_fp_options

1385: where proj_fp_options_id = ci_rec.proj_fp_options_id;
1386: -- planning level code for revenue version
1387: select revenue_fin_plan_level_code
1388: into l_rev_planning_level
1389: from pa_proj_fp_options
1390: where proj_fp_options_id = l_proj_fp_options_id;
1391: -- PLANNING LEVEL = 'P' if one of the planning levels is P
1392: if (l_cost_planning_level = 'P') or (l_rev_planning_level = 'P') then
1393: x_planning_level := 'P';

Line 1447: from pa_proj_fp_options

1443: -- planning level code for cost (compl) version: P, T, L, or M
1444: /*
1445: select cost_fin_plan_level_code
1446: into l_cost_planning_level
1447: from pa_proj_fp_options
1448: where proj_fp_options_id = ci_rec.proj_fp_options_id;
1449: -- planning level code for revenue version
1450: select revenue_fin_plan_level_code
1451: into l_rev_planning_level

Line 1452: from pa_proj_fp_options

1448: where proj_fp_options_id = ci_rec.proj_fp_options_id;
1449: -- planning level code for revenue version
1450: select revenue_fin_plan_level_code
1451: into l_rev_planning_level
1452: from pa_proj_fp_options
1453: where proj_fp_options_id = l_proj_fp_options_id;
1454: -- PLANNING LEVEL = 'P' if one of the planning levels is P
1455: if (l_cost_planning_level = 'P') or (l_rev_planning_level = 'P') then
1456: x_planning_level := 'P';

Line 1509: from pa_proj_fp_options

1505: -- planning level code for cost version: P, T, L, or M
1506: /*
1507: select cost_fin_plan_level_code
1508: into l_cost_planning_level
1509: from pa_proj_fp_options
1510: where proj_fp_options_id = l_proj_fp_options_id;
1511: -- planning level code for revenue (compl) version
1512: select revenue_fin_plan_level_code
1513: into l_rev_planning_level

Line 1514: from pa_proj_fp_options

1510: where proj_fp_options_id = l_proj_fp_options_id;
1511: -- planning level code for revenue (compl) version
1512: select revenue_fin_plan_level_code
1513: into l_rev_planning_level
1514: from pa_proj_fp_options
1515: where proj_fp_options_id = ci_rec.proj_fp_options_id;
1516: -- PLANNING LEVEL = 'P' if one of the planning levels is P
1517: if (l_cost_planning_level = 'P') or (l_rev_planning_level = 'P') then
1518: x_planning_level := 'P';

Line 1560: from pa_proj_fp_options

1556: -- default_amount_subtype_code
1557: into ll_plan_start_date,ll_plan_end_date, l_fin_plan_type_id
1558: -- l_default_amount_type_code,
1559: -- l_default_amount_subtype_code
1560: from pa_proj_fp_options
1561: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID;
1562:
1563: -- DERIVE MARGIN FROM CODE: get from PLAN TYPE entry
1564: select proj_fp_options_id,

Line 1570: from pa_proj_fp_options

1566: report_labor_hrs_from_code
1567: into x_plan_fp_options_id, -- OUTPUT: x_plan_fp_options_id
1568: l_margin_derived_from_code,
1569: l_labor_hours_from_code
1570: from pa_proj_fp_options
1571: where project_id = l_project_id and
1572: fin_plan_type_id = l_fin_plan_type_id and
1573: fin_plan_option_level_code='PLAN_TYPE';
1574: EXCEPTION

Line 1621: pa_proj_fp_options po

1617: into l_amount_set_id,
1618: l_version_type,
1619: x_factor_by_code -- OUTPUT: x_factor_by_code
1620: from pa_budget_versions bv,
1621: pa_proj_fp_options po
1622: where bv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID and
1623: bv.fin_plan_type_id = po.fin_plan_type_id and
1624: po.project_id = l_project_id and
1625: po.fin_plan_option_level_code = 'PLAN_TYPE';

Line 1694: from pa_proj_fp_options

1690: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_user_rev_version_id;
1691: end if;
1692: select approved_rev_plan_type_flag
1693: into x_ar_flag -- OUTPUT: x_ar_flag
1694: from pa_proj_fp_options
1695: where project_id = l_project_id and
1696: fin_plan_type_id = l_fin_plan_type_id and
1697: fin_plan_option_level_code='PLAN_TYPE';
1698:

Line 1902: from pa_proj_fp_options

1898: -- figure out x_time_phase_code: to decide whether or not to display the amt/pd toggle
1899: if pa_fp_view_plans_pub.G_DISPLAY_FROM = 'ANY' then
1900: select nvl(all_time_phased_code, 'N')
1901: into x_time_phase_code -- OUTPUT: x_time_phase_code
1902: from pa_proj_fp_options
1903: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID;
1904: elsif pa_fp_view_plans_pub.G_DISPLAY_FROM = 'COST' then
1905: select nvl(cost_time_phased_code, 'N')
1906: into x_time_phase_code -- OUTPUT: x_time_phase_code

Line 1907: from pa_proj_fp_options

1903: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID;
1904: elsif pa_fp_view_plans_pub.G_DISPLAY_FROM = 'COST' then
1905: select nvl(cost_time_phased_code, 'N')
1906: into x_time_phase_code -- OUTPUT: x_time_phase_code
1907: from pa_proj_fp_options
1908: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
1909: elsif pa_fp_view_plans_pub.G_DISPLAY_FROM = 'REVENUE' then
1910: select nvl(revenue_time_phased_code, 'N')
1911: into x_time_phase_code -- OUTPUT: x_time_phase_code

Line 1912: from pa_proj_fp_options

1908: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
1909: elsif pa_fp_view_plans_pub.G_DISPLAY_FROM = 'REVENUE' then
1910: select nvl(revenue_time_phased_code, 'N')
1911: into x_time_phase_code -- OUTPUT: x_time_phase_code
1912: from pa_proj_fp_options
1913: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
1914: else
1915: select nvl(cost_time_phased_code, 'N')
1916: into l_cost_time_phase_code

Line 1917: from pa_proj_fp_options

1913: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
1914: else
1915: select nvl(cost_time_phased_code, 'N')
1916: into l_cost_time_phase_code
1917: from pa_proj_fp_options
1918: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
1919: select nvl(revenue_time_phased_code, 'N')
1920: into l_rev_time_phase_code
1921: from pa_proj_fp_options

Line 1921: from pa_proj_fp_options

1917: from pa_proj_fp_options
1918: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
1919: select nvl(revenue_time_phased_code, 'N')
1920: into l_rev_time_phase_code
1921: from pa_proj_fp_options
1922: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
1923: if l_cost_time_phase_code <> 'Y' and l_rev_time_phase_code <> 'Y' then
1924: x_time_phase_code := 'N'; -- OUTPUT: x_time_phase_code
1925: else

Line 2600: from pa_proj_fp_options po,

2596: /*
2597: cursor l_compl_c_w_csr is
2598: select bv.budget_version_id,
2599: po.proj_fp_options_id
2600: from pa_proj_fp_options po,
2601: pa_budget_versions bv
2602: where po.project_id = p_project_id and
2603: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2604: po.fin_plan_preference_code = 'REVENUE_ONLY' and

Line 2613: from pa_proj_fp_options po,

2609:
2610: cursor l_compl_c_b_csr is
2611: select bv.budget_version_id,
2612: po.proj_fp_options_id
2613: from pa_proj_fp_options po,
2614: pa_budget_versions bv
2615: where po.project_id = p_project_id and
2616: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2617: po.fin_plan_preference_code = 'REVENUE_ONLY' and

Line 2626: from pa_proj_fp_options po,

2622:
2623: cursor l_compl_r_w_csr is
2624: select bv.budget_version_id,
2625: po.proj_fp_options_id
2626: from pa_proj_fp_options po,
2627: pa_budget_versions bv
2628: where po.project_id = p_project_id and
2629: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2630: po.fin_plan_preference_code = 'COST_ONLY' and

Line 2639: from pa_proj_fp_options po,

2635:
2636: cursor l_compl_r_b_csr is
2637: select bv.budget_version_id,
2638: po.proj_fp_options_id
2639: from pa_proj_fp_options po,
2640: pa_budget_versions bv
2641: where po.project_id = p_project_id and
2642: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2643: po.fin_plan_preference_code = 'COST_ONLY' and

Line 2652: from pa_proj_fp_options po,

2648: */
2649: cursor l_compl_crsep_c_w_csr is
2650: select bv.budget_version_id,
2651: po.proj_fp_options_id
2652: from pa_proj_fp_options po,
2653: pa_budget_versions bv
2654: where po.project_id = p_project_id and
2655: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2656: -- po.fin_plan_preference_code = 'COST_AND_REV_SEP' and

Line 2666: from pa_proj_fp_options po,

2662:
2663: cursor l_compl_crsep_r_w_csr is
2664: select bv.budget_version_id,
2665: po.proj_fp_options_id
2666: from pa_proj_fp_options po,
2667: pa_budget_versions bv
2668: where po.project_id = p_project_id and
2669: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2670: -- po.fin_plan_preference_code = 'COST_AND_REV_SEP' and

Line 2683: from pa_proj_fp_options po,

2679: -- ie. "l_compl_crsep_c_b_csr" means that our version is a baselined cost version
2680: cursor l_compl_crsep_c_b_csr is
2681: select bv.budget_version_id,
2682: po.proj_fp_options_id
2683: from pa_proj_fp_options po,
2684: pa_budget_versions bv
2685: where po.project_id = p_project_id and
2686: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2687: -- po.fin_plan_preference_code = 'COST_AND_REV_SEP' and

Line 2697: from pa_proj_fp_options po,

2693:
2694: cursor l_compl_crsep_r_b_csr is
2695: select bv.budget_version_id,
2696: po.proj_fp_options_id
2697: from pa_proj_fp_options po,
2698: pa_budget_versions bv
2699: where po.project_id = p_project_id and
2700: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2701: -- po.fin_plan_preference_code = 'COST_AND_REV_SEP' and

Line 2708: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

2704: bv.version_type = 'COST' and
2705: bv.current_flag = 'Y';
2706: l_compl_crsep_r_b_rec l_compl_crsep_r_b_csr%ROWTYPE;
2707:
2708: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2709: l_working_or_baselined VARCHAR2(1);
2710: l_compl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2711: l_compl_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2712: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

Line 2711: l_compl_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

2707:
2708: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2709: l_working_or_baselined VARCHAR2(1);
2710: l_compl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2711: l_compl_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2712: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2713: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2714: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2715: l_cost_version_number pa_budget_versions.version_number%TYPE;

Line 2712: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

2708: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2709: l_working_or_baselined VARCHAR2(1);
2710: l_compl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2711: l_compl_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2712: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2713: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2714: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2715: l_cost_version_number pa_budget_versions.version_number%TYPE;
2716: l_rev_version_number pa_budget_versions.version_number%TYPE;

Line 2770: from pa_proj_fp_options

2766: where budget_version_id = p_budget_version_id;
2767: -- retrieve fin_plan_preference_code from PLAN_TYPE record
2768: select fin_plan_preference_code
2769: into l_fp_preference_code
2770: from pa_proj_fp_options
2771: where fin_plan_type_id = l_fin_plan_type_id and
2772: fin_plan_option_level_code = 'PLAN_TYPE' and
2773: project_id = p_project_id;
2774:

Line 2980: from pa_proj_fp_options

2976: where budget_version_id = p_budget_version_id;
2977: -- retrieve fin_plan_preference_code from PLAN_TYPE record
2978: select fin_plan_preference_code
2979: into l_fp_preference_code
2980: from pa_proj_fp_options
2981: where fin_plan_type_id = l_fin_plan_type_id and
2982: fin_plan_option_level_code = 'PLAN_TYPE' and
2983: project_id = p_project_id;
2984:

Line 3634: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

3630: )
3631: is
3632: /* local variables */
3633: l_found_complement BOOLEAN;
3634: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3635: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
3636: l_quantity_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
3637: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
3638: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin

Line 3641: l_default_amount_type_code pa_proj_fp_options.default_amount_type_code%TYPE;

3637: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
3638: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
3639: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin
3640: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
3641: l_default_amount_type_code pa_proj_fp_options.default_amount_type_code%TYPE;
3642: l_default_amount_subtype_code pa_proj_fp_options.default_amount_subtype_code%TYPE;
3643: l_currency_type VARCHAR2(30);
3644:
3645: cursor av_cost_csr is

Line 3642: l_default_amount_subtype_code pa_proj_fp_options.default_amount_subtype_code%TYPE;

3638: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
3639: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin
3640: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
3641: l_default_amount_type_code pa_proj_fp_options.default_amount_type_code%TYPE;
3642: l_default_amount_subtype_code pa_proj_fp_options.default_amount_subtype_code%TYPE;
3643: l_currency_type VARCHAR2(30);
3644:
3645: cursor av_cost_csr is
3646: select ra.project_id,

Line 3859: from pa_proj_fp_options po,

3855: into l_report_labor_hrs_from_code,
3856: l_default_amount_type_code,
3857: l_default_amount_subtype_code,
3858: l_period_profile_id
3859: from pa_proj_fp_options po,
3860: pa_budget_versions bv
3861: where bv.budget_version_id = p_cost_budget_version_id and
3862: bv.fin_plan_type_id = po.fin_plan_type_id and
3863: po.project_id = p_project_id and

Line 6256: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

6252: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
6253: is
6254:
6255: /* LOCAL VARIABLES */
6256: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
6257: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
6258: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
6259: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
6260: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin

Line 6262: l_default_amount_type_code pa_proj_fp_options.default_amount_type_code%TYPE;

6258: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
6259: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
6260: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin
6261: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
6262: l_default_amount_type_code pa_proj_fp_options.default_amount_type_code%TYPE;
6263: l_default_amount_subtype_code pa_proj_fp_options.default_amount_subtype_code%TYPE;
6264: l_currency_type VARCHAR2(30);
6265:
6266: cursor av_csr is

Line 6263: l_default_amount_subtype_code pa_proj_fp_options.default_amount_subtype_code%TYPE;

6259: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
6260: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin
6261: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
6262: l_default_amount_type_code pa_proj_fp_options.default_amount_type_code%TYPE;
6263: l_default_amount_subtype_code pa_proj_fp_options.default_amount_subtype_code%TYPE;
6264: l_currency_type VARCHAR2(30);
6265:
6266: cursor av_csr is
6267: select ra.project_id,

Line 6339: pa_proj_fp_options po

6335: ra.resource_list_member_id,
6336: null,
6337: 'A') as has_child_element
6338: from pa_resource_assignments ra,
6339: pa_proj_fp_options po
6340: where ra.budget_version_id = p_budget_version_id and
6341: ra.budget_version_id = po.fin_plan_version_id and
6342: po.fin_plan_option_level_code='PLAN_VERSION' and
6343: ((ra.resource_assignment_type = 'USER_ENTERED' and

Line 6434: from pa_proj_fp_options po,

6430: into l_report_labor_hrs_from_code,
6431: l_default_amount_type_code,
6432: l_default_amount_subtype_code,
6433: l_period_profile_id
6434: from pa_proj_fp_options po,
6435: pa_budget_versions bv
6436: where bv.budget_version_id = p_budget_version_id and
6437: bv.fin_plan_type_id = po.fin_plan_type_id and
6438: po.project_id = p_project_id and

Line 7338: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

7334: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
7335: as
7336:
7337: /* local variables */
7338: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
7339: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
7340: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
7341: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
7342: l_default_amount_type_code VARCHAR2(30);

Line 7396: pa_proj_fp_options po

7392: ra.resource_list_member_id,
7393: null,
7394: 'A') as has_child_element
7395: from pa_resource_assignments ra,
7396: pa_proj_fp_options po
7397: where ra.budget_version_id = p_budget_version_id and
7398: ra.budget_version_id = po.fin_plan_version_id and
7399: po.fin_plan_option_level_code='PLAN_VERSION' and
7400: ((ra.resource_assignment_type = 'USER_ENTERED' and

Line 7454: pa_proj_fp_options po

7450: ra.resource_list_member_id,
7451: null,
7452: 'A') as has_child_element
7453: from pa_resource_assignments ra,
7454: pa_proj_fp_options po
7455: where ra.budget_version_id = p_budget_version_id and
7456: ra.budget_version_id = po.fin_plan_version_id and
7457: po.fin_plan_option_level_code='PLAN_VERSION' and
7458: ((ra.resource_assignment_type = 'USER_ENTERED' and

Line 7548: from pa_proj_fp_options po,

7544: into l_report_labor_hrs_from_code,
7545: l_default_amount_type_code,
7546: l_default_amount_subtype_code,
7547: l_period_profile_id
7548: from pa_proj_fp_options po,
7549: pa_budget_versions bv
7550: where bv.budget_version_id = p_budget_version_id and
7551: bv.fin_plan_type_id = po.fin_plan_type_id and
7552: po.project_id = p_project_id and