[Home] [Help]
627: , ppfo.approved_cost_plan_type_flag
628: , ppfo.primary_cost_forecast_flag
629: , ppfo.primary_rev_forecast_flag);
630: /*
631: Pji_Rep_Util.Derive_Default_Plan_Type_Ids(p_project_id
632: , x_cstforecast_plan_type_id
633: , x_cstbudget_plan_type_id
634: , l_temp_id
635: , x_revforecast_plan_type_id
678:
679: /*
680:
681:
682: Pji_Rep_Util.Derive_Plan_Version_Ids(p_project_id
683: , x_cstforecast_plan_type_id
684: , x_cstbudget_plan_type_id
685: , p_cstbudget2_plan_type_id
686: , x_revforecast_plan_type_id
721: /*
722: l_i := 1;
723: WHILE l_i <= l_plan_version_ids.COUNT AND x_wbs_version_id IS NULL LOOP
724: IF l_plan_version_ids(l_i) IS NOT NULL THEN
725: Pji_Rep_Util.Derive_Default_WBS_Parameters(p_project_id
726: , l_plan_version_ids(l_i)
727: , x_WBS_Version_ID, x_WBS_Element_Id
728: , x_return_status, x_msg_count, x_msg_data);
729: END IF;
735: x_wbs_version_id := -1;
736: x_wbs_element_id := -1;
737: END IF;
738:
739: Pji_Rep_Util.Derive_Perf_RBS_Parameters(p_project_id
740: , l_temp_id
741: , 'N'
742: , x_RBS_Version_ID, x_RBS_Element_Id
743: , x_return_status, x_msg_count, x_msg_data);
742: , x_RBS_Version_ID, x_RBS_Element_Id
743: , x_return_status, x_msg_count, x_msg_data);
744:
745:
746: Pji_Rep_Util.Derive_Project_Type(p_project_id
747: , x_project_type
748: , x_return_status
749: , x_msg_count
750: , x_msg_data);
822: EXCEPTION
823: WHEN OTHERS THEN
824: x_msg_count := x_msg_count + 1;
825: x_return_status := Fnd_Api.G_RET_STS_ERROR;
826: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_RP_Util.Derive_Currency_Info');
827: RAISE;
828: END Derive_Currency_Info;
829:
830:
985: EXCEPTION
986: WHEN NO_DATA_FOUND THEN
987: x_msg_count := x_msg_count + 1;
988: x_return_status := Fnd_Api.G_RET_STS_ERROR;
989: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'CURRENT PERIOD');
990: x_report_date :=2;
991: WHEN OTHERS THEN
992: x_msg_count := x_msg_count + 1;
993: x_return_status := Fnd_Api.G_RET_STS_ERROR;
990: x_report_date :=2;
991: WHEN OTHERS THEN
992: x_msg_count := x_msg_count + 1;
993: x_return_status := Fnd_Api.G_RET_STS_ERROR;
994: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Report_Period');
995: RAISE;
996: END Derive_Calendar_Info;
997:
998: FUNCTION Get_Percent_Complete
1008: l_return_status VARCHAR2(255);
1009: l_msg_count NUMBER;
1010: l_msg_data VARCHAR2(255);
1011: BEGIN
1012: Pji_Rep_Util.Derive_Percent_Complete
1013: ( p_project_id
1014: , p_wbs_version_id
1015: , p_wbs_element_id
1016: , 'Y'