597: l_gen_api_call_flag := 'N';
598: END IF;
599:
600: l_unspent_amt_period :=
601: PA_FP_GEN_FCST_PG_PKG.GET_UNSPENT_AMT_PERIOD(lx_budget_version_id);
602: -- dbms_output.put_line('Value of l_unspent_amt_period: '||l_unspent_amt_period);
603: -- hr_utility.trace('Value of l_unspent_amt_period: '||l_unspent_amt_period);
604: l_act_from_period :=
605: PA_FP_GEN_FCST_PG_PKG.GET_ACT_FRM_PERIOD(lx_budget_version_id);
601: PA_FP_GEN_FCST_PG_PKG.GET_UNSPENT_AMT_PERIOD(lx_budget_version_id);
602: -- dbms_output.put_line('Value of l_unspent_amt_period: '||l_unspent_amt_period);
603: -- hr_utility.trace('Value of l_unspent_amt_period: '||l_unspent_amt_period);
604: l_act_from_period :=
605: PA_FP_GEN_FCST_PG_PKG.GET_ACT_FRM_PERIOD(lx_budget_version_id);
606: -- dbms_output.put_line('Value of l_act_from_period: '||l_act_from_period);
607: -- hr_utility.trace('Value of l_act_from_period: '||l_act_from_period);
608: l_act_to_period :=
609: PA_FP_GEN_FCST_PG_PKG.GET_ACT_TO_PERIOD(lx_budget_version_id);
605: PA_FP_GEN_FCST_PG_PKG.GET_ACT_FRM_PERIOD(lx_budget_version_id);
606: -- dbms_output.put_line('Value of l_act_from_period: '||l_act_from_period);
607: -- hr_utility.trace('Value of l_act_from_period: '||l_act_from_period);
608: l_act_to_period :=
609: PA_FP_GEN_FCST_PG_PKG.GET_ACT_TO_PERIOD(lx_budget_version_id);
610: -- hr_utility.trace('Value of l_act_from_period: '||l_act_from_period);
611: -- hr_utility.trace('Value of l_act_to_period: '||l_act_to_period);
612: --dbms_output.put_line('Value of l_act_to_period: '||l_act_to_period);
613: l_etc_from_period :=
610: -- hr_utility.trace('Value of l_act_from_period: '||l_act_from_period);
611: -- hr_utility.trace('Value of l_act_to_period: '||l_act_to_period);
612: --dbms_output.put_line('Value of l_act_to_period: '||l_act_to_period);
613: l_etc_from_period :=
614: PA_FP_GEN_FCST_PG_PKG.GET_ETC_FRM_PERIOD(lx_budget_version_id);
615: --dbms_output.put_line('Value of l_etc_from_period: '||l_etc_from_period);
616: --hr_utility.trace('Value of l_etc_frm_period: '||l_etc_from_period);
617: l_etc_to_period :=
618: PA_FP_GEN_FCST_PG_PKG.GET_ETC_TO_PERIOD(lx_budget_version_id);
614: PA_FP_GEN_FCST_PG_PKG.GET_ETC_FRM_PERIOD(lx_budget_version_id);
615: --dbms_output.put_line('Value of l_etc_from_period: '||l_etc_from_period);
616: --hr_utility.trace('Value of l_etc_frm_period: '||l_etc_from_period);
617: l_etc_to_period :=
618: PA_FP_GEN_FCST_PG_PKG.GET_ETC_TO_PERIOD(lx_budget_version_id);
619: --dbms_output.put_line('Value of l_etc_to_period: '||l_etc_to_period);
620: --hr_utility.trace('Value of l_etc_to_period: '||l_etc_to_period);
621: l_act_thru_period :=
622: PA_FP_GEN_FCST_PG_PKG.GET_ACTUALS_THRU_PERIOD_DTLS(lx_budget_version_id, 'PERIOD');
618: PA_FP_GEN_FCST_PG_PKG.GET_ETC_TO_PERIOD(lx_budget_version_id);
619: --dbms_output.put_line('Value of l_etc_to_period: '||l_etc_to_period);
620: --hr_utility.trace('Value of l_etc_to_period: '||l_etc_to_period);
621: l_act_thru_period :=
622: PA_FP_GEN_FCST_PG_PKG.GET_ACTUALS_THRU_PERIOD_DTLS(lx_budget_version_id, 'PERIOD');
623: --dbms_output.put_line('Value of l_act_thru_period: '||l_act_thru_period);
624: --hr_utility.trace('Value of l_act_thru_period: '||l_act_thru_period);
625: l_act_thru_date := to_date(
626: PA_FP_GEN_FCST_PG_PKG.GET_ACTUALS_THRU_PERIOD_DTLS(lx_budget_version_id,'END_DATE'),'RRRRMMDD');
622: PA_FP_GEN_FCST_PG_PKG.GET_ACTUALS_THRU_PERIOD_DTLS(lx_budget_version_id, 'PERIOD');
623: --dbms_output.put_line('Value of l_act_thru_period: '||l_act_thru_period);
624: --hr_utility.trace('Value of l_act_thru_period: '||l_act_thru_period);
625: l_act_thru_date := to_date(
626: PA_FP_GEN_FCST_PG_PKG.GET_ACTUALS_THRU_PERIOD_DTLS(lx_budget_version_id,'END_DATE'),'RRRRMMDD');
627: --dbms_output.put_line('Value of l_act_thru_date: '||l_act_thru_date);
628: --hr_utility.trace('Value of l_act_thru_date: '||l_act_thru_date);
629: --------------------------------------
630:
878: BEGIN --Begining of the block for validation_for_copy_etc_flag
879: IF p_pa_debug_mode = 'Y' THEN
880: pa_fp_gen_amount_utils.fp_debug
881: (p_msg => 'Before calling
882: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag',
883: p_module_name => l_module_name,
884: p_log_level => 5);
885: END IF;
886: -- Calling the following method to validate time phase and ETC source of
884: p_log_level => 5);
885: END IF;
886: -- Calling the following method to validate time phase and ETC source of
887: -- source plan
888: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag
889: (p_project_id => l_fp_cols_rec.x_project_id,
890: p_wp_version_id => l_etc_wp_fin_ver_id,
891: p_etc_plan_version_id => l_etc_fp_ver_id,
892: x_return_status => l_return_status,
894: x_msg_data => l_msg_data);
895: IF p_pa_debug_mode = 'Y' THEN
896: pa_fp_gen_amount_utils.fp_debug
897: (p_msg => 'Status after calling
898: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag: '
899: ||l_return_status,
900: p_module_name => l_module_name,
901: p_log_level => 5);
902: END IF;