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

Line 97: So, pa_proj_fp_options_id is used to fetch options_id

93: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
94: /* bug 3106741
95: pa_fp_txn_curr table doesn't have any index on plan_version_id.
96: But index is available on proj_fp_options_id.
97: So, pa_proj_fp_options_id is used to fetch options_id
98: */
99: cursor unentered_csr is
100: select txn_currency_code
101: from pa_fp_txn_currencies txncurr,

Line 102: pa_proj_fp_options pfo

98: */
99: cursor unentered_csr is
100: select txn_currency_code
101: from pa_fp_txn_currencies txncurr,
102: pa_proj_fp_options pfo
103: where pfo.fin_plan_version_id = l_budget_version_id and
104: txncurr.proj_fp_options_id = pfo.proj_fp_options_id and
105: not (txn_currency_code in
106: (select distinct txn_currency_code

Line 225: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895

221: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895
222: x_multicurrency_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
223: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
224: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
225: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
226: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
227: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
228: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
229: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

227: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
228: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
229: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
230: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
231: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
232: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
233: x_plan_class_code OUT NOCOPY VARCHAR2, -- FP L: Plan Class Security --File.Sql.39 bug 4440895
234: x_display_res_flag OUT NOCOPY VARCHAR2, -- bug 3081511 --File.Sql.39 bug 4440895
235: x_display_resgp_flag OUT NOCOPY VARCHAR2, -- bug 3081511 --File.Sql.39 bug 4440895

Line 243: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

239: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
240: )
241: is
242:
243: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
244: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
245: l_working_or_baselined VARCHAR2(30);
246: l_cost_or_revenue VARCHAR2(30);
247: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

Line 244: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

240: )
241: is
242:
243: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
244: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
245: l_working_or_baselined VARCHAR2(30);
246: l_cost_or_revenue VARCHAR2(30);
247: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
248: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

Line 251: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

247: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
248: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
249: l_c_budget_status_code pa_budget_versions.budget_status_code%TYPE;
250: l_r_budget_status_code pa_budget_versions.budget_status_code%TYPE;
251: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
252: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
253: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
254: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
255: l_grouping_type VARCHAR2(30);

Line 252: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

248: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
249: l_c_budget_status_code pa_budget_versions.budget_status_code%TYPE;
250: l_r_budget_status_code pa_budget_versions.budget_status_code%TYPE;
251: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
252: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
253: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
254: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
255: l_grouping_type VARCHAR2(30);
256: l_compl_grouping_type VARCHAR2(30);

Line 253: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

249: l_c_budget_status_code pa_budget_versions.budget_status_code%TYPE;
250: l_r_budget_status_code pa_budget_versions.budget_status_code%TYPE;
251: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
252: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
253: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
254: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
255: l_grouping_type VARCHAR2(30);
256: l_compl_grouping_type VARCHAR2(30);
257: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 254: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;

250: l_r_budget_status_code pa_budget_versions.budget_status_code%TYPE;
251: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
252: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
253: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
254: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
255: l_grouping_type VARCHAR2(30);
256: l_compl_grouping_type VARCHAR2(30);
257: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
258: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 257: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

253: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
254: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
255: l_grouping_type VARCHAR2(30);
256: l_compl_grouping_type VARCHAR2(30);
257: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
258: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
259: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
260: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
261: l_rv_number pa_budget_versions.record_version_number%TYPE;

Line 258: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

254: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
255: l_grouping_type VARCHAR2(30);
256: l_compl_grouping_type VARCHAR2(30);
257: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
258: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
259: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
260: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
261: l_rv_number pa_budget_versions.record_version_number%TYPE;
262: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;

Line 357: from pa_proj_fp_options

353: proj_fp_options_id
354: into l_fin_plan_type_id,
355: l_multi_curr_flag,
356: l_proj_fp_options_id
357: from pa_proj_fp_options
358: where project_id = p_project_id and
359: fin_plan_version_id = l_version_id and
360: fin_plan_option_level_code = 'PLAN_VERSION';
361: x_fin_plan_type_id := l_fin_plan_type_id;

Line 371: from pa_proj_fp_options

367: select proj_fp_options_id,
368: fin_plan_preference_code
369: into x_plan_type_fp_options_id,
370: l_fp_preference_code
371: from pa_proj_fp_options
372: where project_id = p_project_id and
373: fin_plan_type_id = l_fin_plan_type_id and
374: fin_plan_option_level_code = 'PLAN_TYPE';
375: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;

Line 390: from pa_proj_fp_options

386: select report_labor_hrs_from_code,
387: margin_derived_from_code
388: into l_report_labor_hrs_from_code,
389: l_margin_derived_code
390: from pa_proj_fp_options
391: where project_id = p_project_id and
392: fin_plan_type_id = l_fin_plan_type_id and
393: fin_plan_option_level_code = 'PLAN_TYPE';
394: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;

Line 523: FROM pa_proj_fp_options

519:
520: -- planning level code for cost version: P, T, L, or M
521: SELECT cost_fin_plan_level_code
522: INTO l_cost_planning_level
523: FROM pa_proj_fp_options
524: WHERE proj_fp_options_id = l_proj_fp_options_id;
525:
526: -- planning level code for revenue (compl) version
527: SELECT revenue_fin_plan_level_code

Line 529: FROM pa_proj_fp_options

525:
526: -- planning level code for revenue (compl) version
527: SELECT revenue_fin_plan_level_code
528: INTO l_rev_planning_level
529: FROM pa_proj_fp_options
530: WHERE fin_plan_version_id = p_rev_version_id;
531:
532: -- PLANNING LEVEL = 'P' if one of the planning levels is P
533: IF (l_cost_planning_level = 'P') or (l_rev_planning_level = 'P') THEN

Line 543: FROM pa_proj_fp_options

539: ELSIF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'ANY') THEN
540:
541: SELECT all_fin_plan_level_code
542: INTO l_cost_planning_level
543: FROM pa_proj_fp_options
544: WHERE fin_plan_version_id = p_cost_version_id;
545:
546: x_planning_level := l_cost_planning_level;
547:

Line 552: FROM pa_proj_fp_options

548: ELSIF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'REVENUE') THEN
549:
550: SELECT revenue_fin_plan_level_code
551: INTO l_rev_planning_level
552: FROM pa_proj_fp_options
553: WHERE fin_plan_version_id = p_rev_version_id;
554:
555: x_planning_level := l_rev_planning_level;
556:

Line 561: FROM pa_proj_fp_options

557: ELSIF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'COST') THEN
558:
559: SELECT cost_fin_plan_level_code
560: INTO l_cost_planning_level
561: FROM pa_proj_fp_options
562: WHERE fin_plan_version_id = p_cost_version_id;
563:
564: x_planning_level := l_cost_planning_level;
565:

Line 862: -- p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,

858: -- BUG 2813661
859: procedure nonhgrid_edit_initialize
860: (p_project_id IN pa_budget_versions.project_id%TYPE,
861: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
862: -- p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
863: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
864: -- p_working_or_baselined IN VARCHAR2,
865: -- p_cost_or_revenue IN VARCHAR2,
866: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

Line 863: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,

859: procedure nonhgrid_edit_initialize
860: (p_project_id IN pa_budget_versions.project_id%TYPE,
861: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
862: -- p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
863: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
864: -- p_working_or_baselined IN VARCHAR2,
865: -- p_cost_or_revenue IN VARCHAR2,
866: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
867: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895

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

876: x_multicurrency_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
877: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
878: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
879: x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
880: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
881: x_plan_version_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
882: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
883: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
884: x_auto_baselined_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

877: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
878: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
879: x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
880: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
881: x_plan_version_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
882: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
883: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
884: x_auto_baselined_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
885: x_plan_class_code OUT NOCOPY VARCHAR2, -- FP L: Plan Class Security --File.Sql.39 bug 4440895

Line 894: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

890: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
891: )
892: is
893:
894: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
895: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
896: l_working_or_baselined VARCHAR2(30);
897: l_cost_or_revenue VARCHAR2(30);
898: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

Line 895: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

891: )
892: is
893:
894: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
895: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
896: l_working_or_baselined VARCHAR2(30);
897: l_cost_or_revenue VARCHAR2(30);
898: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
899: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

Line 904: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

900: l_ci_id pa_budget_versions.ci_id%TYPE;
901: l_agreement_id pa_budget_versions.agreement_id%TYPE;
902: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
903:
904: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
905: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
906: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
907: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
908: l_grouping_type VARCHAR2(30);

Line 905: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

901: l_agreement_id pa_budget_versions.agreement_id%TYPE;
902: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
903:
904: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
905: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
906: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
907: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
908: l_grouping_type VARCHAR2(30);
909: l_compl_grouping_type VARCHAR2(30);

Line 906: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

902: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
903:
904: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
905: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
906: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
907: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
908: l_grouping_type VARCHAR2(30);
909: l_compl_grouping_type VARCHAR2(30);
910: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 907: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;

903:
904: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
905: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
906: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
907: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
908: l_grouping_type VARCHAR2(30);
909: l_compl_grouping_type VARCHAR2(30);
910: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
911: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 910: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

906: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
907: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
908: l_grouping_type VARCHAR2(30);
909: l_compl_grouping_type VARCHAR2(30);
910: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
911: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
912: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
913: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
914: l_version_type pa_budget_versions.version_type%TYPE;

Line 911: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

907: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
908: l_grouping_type VARCHAR2(30);
909: l_compl_grouping_type VARCHAR2(30);
910: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
911: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
912: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
913: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
914: l_version_type pa_budget_versions.version_type%TYPE;
915: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

Line 1009: from pa_proj_fp_options

1005: proj_fp_options_id
1006: into l_fin_plan_type_id,
1007: l_multi_curr_flag,
1008: l_proj_fp_options_id
1009: from pa_proj_fp_options
1010: where project_id = p_project_id and
1011: fin_plan_version_id = p_budget_version_id and
1012: fin_plan_option_level_code = 'PLAN_VERSION';
1013:

Line 1025: from pa_proj_fp_options

1021: select proj_fp_options_id,
1022: fin_plan_preference_code
1023: into x_plan_type_fp_options_id,
1024: l_fp_preference_code
1025: from pa_proj_fp_options
1026: where project_id = p_project_id and
1027: fin_plan_type_id = l_fin_plan_type_id and
1028: fin_plan_option_level_code = 'PLAN_TYPE';
1029:

Line 1038: from pa_proj_fp_options

1034: select report_labor_hrs_from_code,
1035: margin_derived_from_code
1036: into l_report_labor_hrs_from_code,
1037: l_margin_derived_code
1038: from pa_proj_fp_options
1039: where project_id = p_project_id and
1040: fin_plan_type_id = l_fin_plan_type_id and
1041: fin_plan_option_level_code = 'PLAN_TYPE';
1042: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;

Line 1065: from pa_proj_fp_options

1061: x_grouping_type := l_grouping_type;
1062: -- set planning level code for page: P, T, L, or M
1063: select all_fin_plan_level_code
1064: into l_cost_planning_level
1065: from pa_proj_fp_options
1066: where proj_fp_options_id = l_proj_fp_options_id;
1067: x_planning_level := l_cost_planning_level;
1068: x_cost_rl_id := l_resource_list_id;
1069: x_rev_rl_id := l_resource_list_id;

Line 1082: from pa_proj_fp_options

1078: x_grouping_type := l_grouping_type;
1079: -- set planning level code for page: P, T, L, or M
1080: select cost_fin_plan_level_code
1081: into l_cost_planning_level
1082: from pa_proj_fp_options
1083: where proj_fp_options_id = l_proj_fp_options_id;
1084: x_planning_level := l_cost_planning_level;
1085: x_cost_rl_id := l_resource_list_id;
1086: x_rev_rl_id := -1;

Line 1099: from pa_proj_fp_options

1095: x_grouping_type := l_grouping_type;
1096: -- set planning level code for page: P, T, L, or M
1097: select revenue_fin_plan_level_code
1098: into l_rev_planning_level
1099: from pa_proj_fp_options
1100: where proj_fp_options_id = l_proj_fp_options_id;
1101: x_planning_level := l_rev_planning_level;
1102: x_cost_rl_id := -1;
1103: x_rev_rl_id := l_resource_list_id;

Line 1124: from pa_proj_fp_options

1120: x_grouping_type := l_grouping_type;
1121: -- set planning level code for page: P, T, L, or M
1122: select cost_fin_plan_level_code
1123: into l_cost_planning_level
1124: from pa_proj_fp_options
1125: where proj_fp_options_id = l_proj_fp_options_id;
1126: x_planning_level := l_cost_planning_level;
1127: x_cost_rl_id := l_resource_list_id;
1128: x_rev_rl_id := -1;

Line 1140: from pa_proj_fp_options

1136: x_grouping_type := l_grouping_type;
1137: -- set planning level code for page: P, T, L, or M
1138: select revenue_fin_plan_level_code
1139: into l_rev_planning_level
1140: from pa_proj_fp_options
1141: where proj_fp_options_id = l_proj_fp_options_id;
1142: x_planning_level := l_rev_planning_level;
1143: x_cost_rl_id := -1;
1144: x_rev_rl_id := l_resource_list_id;

Line 1862: l_cost_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

1858: l_r_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1859: l_r_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1860: l_r_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1861:
1862: l_cost_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1863: l_rev_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1864: l_both_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1865: l_rec_counter NUMBER;
1866: l_compl_found BOOLEAN;

Line 1863: l_rev_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

1859: l_r_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1860: l_r_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1861:
1862: l_cost_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1863: l_rev_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1864: l_both_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1865: l_rec_counter NUMBER;
1866: l_compl_found BOOLEAN;
1867:

Line 1864: l_both_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

1860: l_r_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1861:
1862: l_cost_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1863: l_rev_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1864: l_both_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1865: l_rec_counter NUMBER;
1866: l_compl_found BOOLEAN;
1867:
1868: BEGIN

Line 1886: from pa_proj_fp_options

1882: --hr_utility.trace('p_get_display_from = ANY');
1883: -- test to see if version is planned in multicurrency
1884: select nvl(plan_in_multi_curr_flag, 'N')
1885: into l_rev_multi_curr_flag
1886: from pa_proj_fp_options
1887: where project_id = p_project_id and
1888: fin_plan_version_id = p_both_version_id and
1889: fin_plan_option_level_code = 'PLAN_VERSION';
1890: if l_rev_multi_curr_flag = 'Y' then

Line 1964: from pa_proj_fp_options

1960: --hr_utility.trace('p_get_display_from = COST');
1961: -- test to see if version is planned in multicurrency
1962: select nvl(plan_in_multi_curr_flag, 'N')
1963: into l_cost_multi_curr_flag
1964: from pa_proj_fp_options
1965: where project_id = p_project_id and
1966: fin_plan_version_id = p_cost_version_id and
1967: fin_plan_option_level_code = 'PLAN_VERSION';
1968: if l_cost_multi_curr_flag = 'Y' then

Line 2044: from pa_proj_fp_options

2040: --hr_utility.trace('p_get_display_from = REVENUE');
2041: -- test to see if version is planned in multicurrency
2042: select nvl(plan_in_multi_curr_flag, 'N')
2043: into l_rev_multi_curr_flag
2044: from pa_proj_fp_options
2045: where project_id = p_project_id and
2046: fin_plan_version_id = p_revenue_version_id and
2047: fin_plan_option_level_code = 'PLAN_VERSION';
2048: if l_rev_multi_curr_flag = 'Y' then

Line 2113: from pa_proj_fp_options

2109: --hr_utility.trace('p_get_display_from = BOTH');
2110: -- test to see if COST version is planned in multicurrency
2111: select nvl(plan_in_multi_curr_flag, 'N')
2112: into l_cost_multi_curr_flag
2113: from pa_proj_fp_options
2114: where project_id = p_project_id and
2115: fin_plan_version_id = p_cost_version_id and
2116: fin_plan_option_level_code = 'PLAN_VERSION';
2117: --hr_utility.trace('l_cost_multi_curr_flag= ' || l_cost_multi_curr_flag);

Line 2160: from pa_proj_fp_options

2156: end if; -- multicurrency test for COST
2157: -- test to see if REVENUE version is planned in multicurrency
2158: select nvl(plan_in_multi_curr_flag, 'N')
2159: into l_rev_multi_curr_flag
2160: from pa_proj_fp_options
2161: where project_id = p_project_id and
2162: fin_plan_version_id = p_revenue_version_id and
2163: fin_plan_option_level_code = 'PLAN_VERSION';
2164: --hr_utility.trace('l_rev_multi_curr_flag= ' || l_rev_multi_curr_flag);

Line 2380: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895

2376: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895
2377: x_multicurrency_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
2378: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
2379: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
2380: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
2381: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
2382: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
2383: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2384: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

2382: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
2383: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2384: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2385: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2386: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
2387: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
2388: x_auto_baselined_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2389: x_display_res_flag OUT NOCOPY VARCHAR2, -- bug 3081511 --File.Sql.39 bug 4440895
2390: x_display_resgp_flag OUT NOCOPY VARCHAR2, -- bug 3081511 --File.Sql.39 bug 4440895

Line 2396: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

2392: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2393: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2394: ) is
2395:
2396: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
2397: l_fin_plan_type_id2 pa_proj_fp_options.fin_plan_type_id%TYPE;
2398: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2399: l_proj_fp_options_id2 pa_proj_fp_options.proj_fp_options_id%TYPE;
2400: l_working_or_baselined VARCHAR2(30);

Line 2397: l_fin_plan_type_id2 pa_proj_fp_options.fin_plan_type_id%TYPE;

2393: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2394: ) is
2395:
2396: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
2397: l_fin_plan_type_id2 pa_proj_fp_options.fin_plan_type_id%TYPE;
2398: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2399: l_proj_fp_options_id2 pa_proj_fp_options.proj_fp_options_id%TYPE;
2400: l_working_or_baselined VARCHAR2(30);
2401: l_cost_or_revenue VARCHAR2(30);

Line 2398: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

2394: ) is
2395:
2396: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
2397: l_fin_plan_type_id2 pa_proj_fp_options.fin_plan_type_id%TYPE;
2398: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2399: l_proj_fp_options_id2 pa_proj_fp_options.proj_fp_options_id%TYPE;
2400: l_working_or_baselined VARCHAR2(30);
2401: l_cost_or_revenue VARCHAR2(30);
2402: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

Line 2399: l_proj_fp_options_id2 pa_proj_fp_options.proj_fp_options_id%TYPE;

2395:
2396: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
2397: l_fin_plan_type_id2 pa_proj_fp_options.fin_plan_type_id%TYPE;
2398: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2399: l_proj_fp_options_id2 pa_proj_fp_options.proj_fp_options_id%TYPE;
2400: l_working_or_baselined VARCHAR2(30);
2401: l_cost_or_revenue VARCHAR2(30);
2402: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2403: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

Line 2410: pa_proj_fp_options po

2406: select bv.budget_version_id,
2407: po.proj_fp_options_id,
2408: NVL(po.plan_in_multi_curr_flag, 'N') as plan_in_multi_curr_flag
2409: from pa_budget_versions bv,
2410: pa_proj_fp_options po
2411: where bv.project_id = p_project_id and
2412: bv.ci_id = p_ci_id and
2413: bv.budget_version_id = po.fin_plan_version_id and
2414: po.fin_plan_option_level_code='PLAN_VERSION';

Line 2418: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

2414: po.fin_plan_option_level_code='PLAN_VERSION';
2415: ci_rec ci_csr%ROWTYPE;
2416:
2417:
2418: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2419: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2420: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2421: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
2422: l_grouping_type VARCHAR2(30);

Line 2419: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

2415: ci_rec ci_csr%ROWTYPE;
2416:
2417:
2418: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2419: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2420: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2421: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
2422: l_grouping_type VARCHAR2(30);
2423: l_compl_grouping_type VARCHAR2(30);

Line 2420: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

2416:
2417:
2418: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2419: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2420: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2421: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
2422: l_grouping_type VARCHAR2(30);
2423: l_compl_grouping_type VARCHAR2(30);
2424: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 2421: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;

2417:
2418: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2419: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2420: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2421: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
2422: l_grouping_type VARCHAR2(30);
2423: l_compl_grouping_type VARCHAR2(30);
2424: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2425: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 2424: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

2420: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2421: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
2422: l_grouping_type VARCHAR2(30);
2423: l_compl_grouping_type VARCHAR2(30);
2424: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2425: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2426: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2427: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2428: l_rv_number pa_budget_versions.record_version_number%TYPE;

Line 2425: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

2421: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;
2422: l_grouping_type VARCHAR2(30);
2423: l_compl_grouping_type VARCHAR2(30);
2424: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2425: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2426: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2427: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2428: l_rv_number pa_budget_versions.record_version_number%TYPE;
2429: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;

Line 2483: from pa_proj_fp_options

2479: select fin_plan_type_id,
2480: proj_fp_options_id
2481: into l_fin_plan_type_id,
2482: l_proj_fp_options_id
2483: from pa_proj_fp_options
2484: where project_id = p_project_id and
2485: fin_plan_version_id = ci_rec.budget_version_id and
2486: fin_plan_option_level_code = 'PLAN_VERSION';
2487:

Line 2566: from pa_proj_fp_options

2562: select proj_fp_options_id,
2563: fin_plan_preference_code
2564: into x_plan_type_fp_options_id,
2565: l_fp_preference_code
2566: from pa_proj_fp_options
2567: where project_id = p_project_id and
2568: fin_plan_type_id = l_fin_plan_type_id and
2569: fin_plan_option_level_code = 'PLAN_TYPE';
2570:

Line 2576: from pa_proj_fp_options

2572: select report_labor_hrs_from_code,
2573: margin_derived_from_code
2574: into l_report_labor_hrs_from_code,
2575: l_margin_derived_code
2576: from pa_proj_fp_options
2577: where project_id = p_project_id and
2578: fin_plan_type_id = l_fin_plan_type_id and
2579: fin_plan_option_level_code = 'PLAN_TYPE';
2580: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;

Line 2596: from pa_proj_fp_options

2592: x_grouping_type := l_grouping_type;
2593: -- set planning level code for page: P, T, L, or M
2594: select all_fin_plan_level_code
2595: into l_cost_planning_level
2596: from pa_proj_fp_options
2597: where proj_fp_options_id = l_proj_fp_options_id;
2598: x_planning_level := l_cost_planning_level;
2599: x_cost_rv_number := l_rv_number;
2600: x_rev_rv_number := l_rv_number;

Line 2614: from pa_proj_fp_options

2610: x_grouping_type := l_grouping_type;
2611: -- set planning level code for page: P, T, L, or M
2612: select cost_fin_plan_level_code
2613: into l_cost_planning_level
2614: from pa_proj_fp_options
2615: where proj_fp_options_id = l_proj_fp_options_id;
2616: x_planning_level := l_cost_planning_level;
2617: x_cost_rv_number := l_rv_number;
2618: x_rev_rv_number := -1;

Line 2632: from pa_proj_fp_options

2628: x_grouping_type := l_grouping_type;
2629: -- set planning level code for page: P, T, L, or M
2630: select revenue_fin_plan_level_code
2631: into l_rev_planning_level
2632: from pa_proj_fp_options
2633: where proj_fp_options_id = l_proj_fp_options_id;
2634: x_planning_level := l_rev_planning_level;
2635: x_cost_rv_number := -1;
2636: x_rev_rv_number := l_rv_number;

Line 2655: from pa_proj_fp_options

2651: select fin_plan_type_id,
2652: proj_fp_options_id
2653: into l_fin_plan_type_id2,
2654: l_proj_fp_options_id2
2655: from pa_proj_fp_options
2656: where project_id = p_project_id and
2657: fin_plan_version_id = ci_rec.budget_version_id and
2658: fin_plan_option_level_code = 'PLAN_VERSION';
2659: select report_labor_hrs_from_code,

Line 2663: from pa_proj_fp_options

2659: select report_labor_hrs_from_code,
2660: margin_derived_from_code
2661: into l_report_labor_hrs_from_code,
2662: l_margin_derived_code
2663: from pa_proj_fp_options
2664: where project_id = p_project_id and
2665: fin_plan_type_id = l_fin_plan_type_id2 and
2666: fin_plan_option_level_code = 'PLAN_TYPE';
2667:

Line 2709: from pa_proj_fp_options

2705: x_rev_rl_id := l_compl_resource_list_id;
2706: -- planning level code for cost version: P, T, L, or M
2707: select cost_fin_plan_level_code
2708: into l_cost_planning_level
2709: from pa_proj_fp_options
2710: where proj_fp_options_id = l_proj_fp_options_id;
2711: -- planning level code for revenue (compl) version
2712: select revenue_fin_plan_level_code
2713: into l_rev_planning_level

Line 2714: from pa_proj_fp_options

2710: where proj_fp_options_id = l_proj_fp_options_id;
2711: -- planning level code for revenue (compl) version
2712: select revenue_fin_plan_level_code
2713: into l_rev_planning_level
2714: from pa_proj_fp_options
2715: where proj_fp_options_id = ci_rec.proj_fp_options_id;
2716: -- PLANNING LEVEL = 'P' if one of the planning levels is P
2717: if (l_cost_planning_level = 'P') or (l_rev_planning_level = 'P') then
2718: x_planning_level := 'P';

Line 2767: from pa_proj_fp_options

2763: x_rev_rl_id := l_compl_resource_list_id;
2764: -- planning level code for cost (compl) version: P, T, L, or M
2765: select cost_fin_plan_level_code
2766: into l_cost_planning_level
2767: from pa_proj_fp_options
2768: where proj_fp_options_id = ci_rec.proj_fp_options_id;
2769: -- planning level code for revenue version
2770: select revenue_fin_plan_level_code
2771: into l_rev_planning_level

Line 2772: from pa_proj_fp_options

2768: where proj_fp_options_id = ci_rec.proj_fp_options_id;
2769: -- planning level code for revenue version
2770: select revenue_fin_plan_level_code
2771: into l_rev_planning_level
2772: from pa_proj_fp_options
2773: where proj_fp_options_id = l_proj_fp_options_id;
2774: -- PLANNING LEVEL = 'P' if one of the planning levels is P
2775: if (l_cost_planning_level = 'P') or (l_rev_planning_level = 'P') then
2776: x_planning_level := 'P';

Line 2834: from pa_proj_fp_options

2830: x_rev_rl_id := l_compl_resource_list_id;
2831: -- planning level code for cost (compl) version: P, T, L, or M
2832: select cost_fin_plan_level_code
2833: into l_cost_planning_level
2834: from pa_proj_fp_options
2835: where proj_fp_options_id = ci_rec.proj_fp_options_id;
2836: -- planning level code for revenue version
2837: select revenue_fin_plan_level_code
2838: into l_rev_planning_level

Line 2839: from pa_proj_fp_options

2835: where proj_fp_options_id = ci_rec.proj_fp_options_id;
2836: -- planning level code for revenue version
2837: select revenue_fin_plan_level_code
2838: into l_rev_planning_level
2839: from pa_proj_fp_options
2840: where proj_fp_options_id = l_proj_fp_options_id;
2841: -- PLANNING LEVEL = 'P' if one of the planning levels is P
2842: if (l_cost_planning_level = 'P') or (l_rev_planning_level = 'P') then
2843: x_planning_level := 'P';

Line 2900: from pa_proj_fp_options

2896: x_rev_rl_id := l_compl_resource_list_id;
2897: -- planning level code for cost version: P, T, L, or M
2898: select cost_fin_plan_level_code
2899: into l_cost_planning_level
2900: from pa_proj_fp_options
2901: where proj_fp_options_id = l_proj_fp_options_id;
2902: -- planning level code for revenue (compl) version
2903: select revenue_fin_plan_level_code
2904: into l_rev_planning_level

Line 2905: from pa_proj_fp_options

2901: where proj_fp_options_id = l_proj_fp_options_id;
2902: -- planning level code for revenue (compl) version
2903: select revenue_fin_plan_level_code
2904: into l_rev_planning_level
2905: from pa_proj_fp_options
2906: where proj_fp_options_id = ci_rec.proj_fp_options_id;
2907: -- PLANNING LEVEL = 'P' if one of the planning levels is P
2908: if (l_cost_planning_level = 'P') or (l_rev_planning_level = 'P') then
2909: x_planning_level := 'P';