[Home] [Help]
1: PACKAGE BODY BSC_BIS_KPI_CRUD_PUB AS
2: /* $Header: BSCCRUDB.pls 120.51 2007/10/09 13:03:34 bijain ship $ */
3:
4: /*
5: REM +=======================================================================+
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;
294:
295: -- added for Bug#4558279
296: BSC_BIS_KPI_CRUD_PUB.Cascade_Parameter_Portlet (
297: p_Commit => p_Commit
298: , p_Page_Function_Name => p_Page_Function_Name
299: , p_Param_Region_Code => p_Param_Portlet_Region_Code
300: , p_Param_Region_Application_Id => Get_Region_Application_Id(p_Param_Portlet_Region_Code)
311:
312: l_User_Page_Name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(p_Page_Function_Name);
313: l_User_Portlet_Name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(p_Kpi_Portlet_Function_Name);
314:
315: l_Does_Kpi_Exist := BSC_BIS_KPI_CRUD_PUB.Does_KPI_Exist(p_Page_Function_Name);
316:
317: BSC_BIS_KPI_CRUD_PUB.Create_Bsc_Bis_Metadata(
318: p_Commit => p_Commit
319: , p_Create_Region_Per_Ao => p_Create_Region_Per_Ao
313: l_User_Portlet_Name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(p_Kpi_Portlet_Function_Name);
314:
315: l_Does_Kpi_Exist := BSC_BIS_KPI_CRUD_PUB.Does_KPI_Exist(p_Page_Function_Name);
316:
317: BSC_BIS_KPI_CRUD_PUB.Create_Bsc_Bis_Metadata(
318: p_Commit => p_Commit
319: , p_Create_Region_Per_Ao => p_Create_Region_Per_Ao
320: , p_Param_Portlet_Region_Code => l_Param_Region_Code
321: , p_Page_Function_Name => p_Page_Function_Name
358: END IF;
359:
360: -- Get the KPI Associated
361: l_Kpi_Id := x_Kpi_Id;
362: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(x_Measure_Short_Name);
363: l_Analysis_Option := BSC_BIS_KPI_CRUD_PUB.Get_AO_Id_By_Measure(l_Kpi_Id, l_Dataset_Id);
364:
365: IF ((p_Create_Region_Per_AO = FND_API.G_TRUE) OR (l_Does_Kpi_Exist = FALSE)) THEN
366:
359:
360: -- Get the KPI Associated
361: l_Kpi_Id := x_Kpi_Id;
362: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(x_Measure_Short_Name);
363: l_Analysis_Option := BSC_BIS_KPI_CRUD_PUB.Get_AO_Id_By_Measure(l_Kpi_Id, l_Dataset_Id);
364:
365: IF ((p_Create_Region_Per_AO = FND_API.G_TRUE) OR (l_Does_Kpi_Exist = FALSE)) THEN
366:
367: BSC_BIS_KPI_CRUD_PUB.Create_Ak_Metadata(
363: l_Analysis_Option := BSC_BIS_KPI_CRUD_PUB.Get_AO_Id_By_Measure(l_Kpi_Id, l_Dataset_Id);
364:
365: IF ((p_Create_Region_Per_AO = FND_API.G_TRUE) OR (l_Does_Kpi_Exist = FALSE)) THEN
366:
367: BSC_BIS_KPI_CRUD_PUB.Create_Ak_Metadata(
368: p_Commit => p_Commit
369: , p_Create_Region_Per_AO => p_Create_Region_Per_AO
370: , p_Kpi_Id => l_Kpi_Id
371: , p_Analysis_Option_Id => l_Analysis_Option
374: , p_Measure_Name => p_Measure_Name
375: , p_Measure_Description => p_Measure_Description
376: , p_User_Portlet_Name => l_User_Portlet_Name
377: , p_Dataset_Format_Id => p_Dataset_Format_Id
378: , p_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID -- BSC
379: , p_Disable_View_By => 'N'
380: , p_Param_Portlet_Region_Code => l_Param_Region_Code
381: , x_Return_Status => x_Return_Status
382: , x_Msg_Count => x_Msg_Count
389:
390: -- Single Region (BSC_
391: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(l_Kpi_Id, -1);
392:
393: l_Max_Seq_Number := BSC_BIS_KPI_CRUD_PUB.Find_Max_Seq_Of_Region_Item(l_Region_Code);
394: l_Max_Seq_Number := l_Max_Seq_Number + 10;
395:
396: BSC_BIS_KPI_CRUD_PUB.Create_Measure_Region_Item(
397: p_Commit => p_Commit
392:
393: l_Max_Seq_Number := BSC_BIS_KPI_CRUD_PUB.Find_Max_Seq_Of_Region_Item(l_Region_Code);
394: l_Max_Seq_Number := l_Max_Seq_Number + 10;
395:
396: BSC_BIS_KPI_CRUD_PUB.Create_Measure_Region_Item(
397: p_Commit => p_Commit
398: ,p_Measure_Short_Name => x_Measure_Short_Name
399: ,p_Sequence_Number => l_Max_Seq_Number
400: ,p_Kpi_Id => l_Kpi_Id
440: WHEN NO_DATA_FOUND THEN
441: ROLLBACK TO CreateEndToEndKPI;
442: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
443: IF (x_msg_data IS NOT NULL) THEN
444: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Kpi_End_To_End ';
445: ELSE
446: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Kpi_End_To_End ';
447: END IF;
448: WHEN OTHERS THEN
442: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
443: IF (x_msg_data IS NOT NULL) THEN
444: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Kpi_End_To_End ';
445: ELSE
446: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Kpi_End_To_End ';
447: END IF;
448: WHEN OTHERS THEN
449: ROLLBACK TO CreateEndToEndKPI;
450: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
448: WHEN OTHERS THEN
449: ROLLBACK TO CreateEndToEndKPI;
450: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
451: IF (x_msg_data IS NOT NULL) THEN
452: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Kpi_End_To_End ';
453: ELSE
454: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Kpi_End_To_End ';
455: END IF;
456: END Create_Kpi_End_To_End;
450: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
451: IF (x_msg_data IS NOT NULL) THEN
452: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Kpi_End_To_End ';
453: ELSE
454: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Kpi_End_To_End ';
455: END IF;
456: END Create_Kpi_End_To_End;
457:
458:
521: FND_MSG_PUB.Initialize;
522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523:
524: -- Get the KPI ID from the Measure Short_Name (Bug#3766839)
525: l_Kpi_Id := NVL(BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_Kpi(p_Measure_Short_Name),
526: BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY);
527: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name);
528: l_sequence := 10;
529:
522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523:
524: -- Get the KPI ID from the Measure Short_Name (Bug#3766839)
525: l_Kpi_Id := NVL(BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_Kpi(p_Measure_Short_Name),
526: BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY);
527: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name);
528: l_sequence := 10;
529:
530: -- Validate Input Parameters.
523:
524: -- Get the KPI ID from the Measure Short_Name (Bug#3766839)
525: l_Kpi_Id := NVL(BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_Kpi(p_Measure_Short_Name),
526: BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY);
527: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name);
528: l_sequence := 10;
529:
530: -- Validate Input Parameters.
531: -- check if the KPI is in production mode, if yes throw and exception
537: END IF;
538:
539: --DBMS_OUTPUT.PUT_LINE('is_Indicator_In_Production');
540:
541: l_AO_Id := BSC_BIS_KPI_CRUD_PUB.Get_AO_Id_By_Measure (l_Kpi_Id, l_Dataset_Id);
542: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code (l_Kpi_Id ,l_AO_Id);
543:
544:
545: BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code(
541: l_AO_Id := BSC_BIS_KPI_CRUD_PUB.Get_AO_Id_By_Measure (l_Kpi_Id, l_Dataset_Id);
542: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code (l_Kpi_Id ,l_AO_Id);
543:
544:
545: BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code(
546: p_Param_Portlet_Region_Code => BSC_BIS_KPI_CRUD_PUB.Get_Param_Portlet_By_Region(l_Region_Code)
547: , x_Non_Time_Dimension_Groups => x_Non_Time_Dimension_Groups
548: , x_Non_Time_Dimension_Objects => x_Non_Time_Dimension_Objects
549: , x_Non_Time_Dim_Obj_Short_Names => x_Non_Time_Dim_Obj_Short_Names
542: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code (l_Kpi_Id ,l_AO_Id);
543:
544:
545: BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code(
546: p_Param_Portlet_Region_Code => BSC_BIS_KPI_CRUD_PUB.Get_Param_Portlet_By_Region(l_Region_Code)
547: , x_Non_Time_Dimension_Groups => x_Non_Time_Dimension_Groups
548: , x_Non_Time_Dimension_Objects => x_Non_Time_Dimension_Objects
549: , x_Non_Time_Dim_Obj_Short_Names => x_Non_Time_Dim_Obj_Short_Names
550: , x_All_Dim_Group_Ids => x_All_Dim_Group_Ids
566: -- Need to update the Region Item FORMAT_ID and AUTOSCALE FLAG
567: --l_sequence
568:
569:
570: l_Sequence := BSC_BIS_KPI_CRUD_PUB.Get_Sequence_Id_By_Region(
571: p_Region_Code => l_Region_Code
572: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID -- BSC
573: , p_Attribute_Code => p_Measure_Short_Name
574: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID -- BSC
568:
569:
570: l_Sequence := BSC_BIS_KPI_CRUD_PUB.Get_Sequence_Id_By_Region(
571: p_Region_Code => l_Region_Code
572: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID -- BSC
573: , p_Attribute_Code => p_Measure_Short_Name
574: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID -- BSC
575: );
576:
570: l_Sequence := BSC_BIS_KPI_CRUD_PUB.Get_Sequence_Id_By_Region(
571: p_Region_Code => l_Region_Code
572: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID -- BSC
573: , p_Attribute_Code => p_Measure_Short_Name
574: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID -- BSC
575: );
576:
577:
578:
575: );
576:
577:
578:
579: IF BSC_BIS_KPI_CRUD_PUB.is_Valid_Region_Code(l_Region_Code) THEN
580: l_Analysis_Option_Id := l_AO_Id;
581: ELSE
582: l_Analysis_Option_Id := NULL;
583: END IF;
629: ,p_Measure_Max_Bud_Value => NULL
630: ,p_Measure_App_Id => p_Measure_App_Id
631: ,p_Measure_Col => NULL
632: ,p_Measure_Group_Id => NULL
633: ,p_Measure_Projection_Id => BSC_BIS_KPI_CRUD_PUB.C_NO_PROJECTION
634: ,p_Measure_Type => p_measure_type
635: ,p_Measure_Apply_Rollup => NULL
636: ,p_Measure_Function_Name => l_Region_Code
637: ,p_Measure_Enable_Link => 'Y'
656:
657:
658:
659: --DBMS_OUTPUT.PUT_LINE('Outside Update_Kpi_Analysis_Option' );
660: BSC_BIS_KPI_CRUD_PUB.Update_Kpi_Analysis_Option(
661: p_Commit => p_Commit
662: ,p_Kpi_Id => l_Kpi_Id
663: ,p_Dataset_Id => l_Dataset_Id
664: ,p_Measure_Name => p_Measure_Name
685: -- IF Analysis_Option is passed as NULL, the lower APIs
686: -- ASSUME that the format of the Region Code is of the format
687: -- BSC_
688:
689: BSC_BIS_KPI_CRUD_PUB.Update_Measure_Region_Item(
690: p_commit => p_commit,
691: p_measure_short_name => p_measure_short_name,
692: p_sequence_number => l_sequence,
693: p_kpi_id => l_Kpi_Id,
702: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
704: END IF;
705:
706: BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items(
707: p_commit => p_commit
708: , p_Region_Code => l_Region_Code
709: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
710: , p_Display_Format => Get_Format_Mask(p_Dataset_Format_Id)
705:
706: BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items(
707: p_commit => p_commit
708: , p_Region_Code => l_Region_Code
709: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
710: , p_Display_Format => Get_Format_Mask(p_Dataset_Format_Id)
711: , p_Format_Id => p_Dataset_Format_Id
712: , p_Measure_Short_Name => p_measure_short_name
713: , x_return_status => x_return_status
722:
723: -- Do not update Region if the region is not in the format BSC_
724: -- The Measures exists under the same AK Region (common Dimensions)
725: IF (l_Analysis_Option_Id IS NOT NULL AND (l_Analysis_Option_Id <> -1)) THEN
726: BSC_BIS_KPI_CRUD_PUB.Update_Region_By_AO (
727: p_Commit => p_Commit
728: , p_Kpi_Id => l_Kpi_Id
729: , p_Analysis_Option_Id => l_Analysis_Option_Id
730: , p_Dim_Set_Id => 0
729: , p_Analysis_Option_Id => l_Analysis_Option_Id
730: , p_Dim_Set_Id => 0
731: , p_Region_Name => p_Measure_Name
732: , p_Region_Description => p_Measure_Description
733: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID -- BSC
734: , p_Disable_View_By => 'N'
735: , x_return_status => x_return_status
736: , x_msg_count => x_msg_count
737: , x_msg_data => x_msg_data
746: || '&' || 'pParameters=pParamIds@Y';
747:
748: FND_FORM_FUNCTIONS_PKG.UPDATE_ROW
749: (
750: X_FUNCTION_ID => BSC_BIS_KPI_CRUD_PUB.Get_Function_Id_By_Name(l_Region_Code)
751: ,X_WEB_HOST_NAME => ''
752: ,X_WEB_AGENT_NAME => ''
753: ,X_WEB_HTML_CALL => BSC_BIS_KPI_CRUD_PUB.c_bisreportpg
754: ,X_WEB_ENCRYPT_PARAMETERS => 'N'
749: (
750: X_FUNCTION_ID => BSC_BIS_KPI_CRUD_PUB.Get_Function_Id_By_Name(l_Region_Code)
751: ,X_WEB_HOST_NAME => ''
752: ,X_WEB_AGENT_NAME => ''
753: ,X_WEB_HTML_CALL => BSC_BIS_KPI_CRUD_PUB.c_bisreportpg
754: ,X_WEB_ENCRYPT_PARAMETERS => 'N'
755: ,X_WEB_SECURED => 'N'
756: ,X_WEB_ICON => ''
757: ,X_OBJECT_ID => NULL
793: ROLLBACK TO UpdateEndToEndKPI;
794: WHEN NO_DATA_FOUND THEN
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: IF (x_msg_data IS NOT NULL) THEN
797: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Kpi_End_To_End ';
798: ELSE
799: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Kpi_End_To_End ';
800: END IF;
801: ROLLBACK TO UpdateEndToEndKPI;
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: IF (x_msg_data IS NOT NULL) THEN
797: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Kpi_End_To_End ';
798: ELSE
799: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Kpi_End_To_End ';
800: END IF;
801: ROLLBACK TO UpdateEndToEndKPI;
802: WHEN OTHERS THEN
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: ROLLBACK TO UpdateEndToEndKPI;
802: WHEN OTHERS THEN
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: IF (x_msg_data IS NOT NULL) THEN
805: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Kpi_End_To_End ';
806: ELSE
807: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Kpi_End_To_End ';
808: END IF;
809: ROLLBACK TO UpdateEndToEndKPI;
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: IF (x_msg_data IS NOT NULL) THEN
805: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Kpi_End_To_End ';
806: ELSE
807: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Kpi_End_To_End ';
808: END IF;
809: ROLLBACK TO UpdateEndToEndKPI;
810: END Update_Kpi_End_To_End;
811:
865:
866:
867: -- should take l_kpi_id from the measure_short_name only and not from
868: -- the Page function name. Bug#3766839
869: l_Kpi_Id := NVL(BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_Kpi(p_Measure_Short_Name),
870: BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY);
871: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name);
872:
873: -- If the KPI has been deleted, throw a valid message
866:
867: -- should take l_kpi_id from the measure_short_name only and not from
868: -- the Page function name. Bug#3766839
869: l_Kpi_Id := NVL(BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_Kpi(p_Measure_Short_Name),
870: BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY);
871: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name);
872:
873: -- If the KPI has been deleted, throw a valid message
874:
867: -- should take l_kpi_id from the measure_short_name only and not from
868: -- the Page function name. Bug#3766839
869: l_Kpi_Id := NVL(BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_Kpi(p_Measure_Short_Name),
870: BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY);
871: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name);
872:
873: -- If the KPI has been deleted, throw a valid message
874:
875: SELECT COUNT(1) INTO l_Count
893: END IF;
894:
895: --DBMS_OUTPUT.PUT_LINE('Get_Num_Measures_By_Kpi -> ' || Get_Num_Measures_By_Kpi(l_Kpi_Id));
896:
897: IF(BSC_BIS_KPI_CRUD_PUB.Get_Num_Measures_By_Kpi(l_Kpi_Id) > 1) THEN
898: -- Start deleting the PMV/AK Metadata
899: -- Delete the Measure Metadata
900: -- IF the Measure has its own AK Region, we need to delete it.
901: IF(has_Measure_AK_Region(l_Kpi_Id, l_Dataset_Id)) THEN
903: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(l_Kpi_Id, l_Analysis_Option_Id);
904:
905:
906: -- Need to find out Param Portlet before AK is deleted
907: l_Parameter_Portlet := BSC_BIS_KPI_CRUD_PUB.Get_Param_Portlet_By_Region(l_Region_Code);
908:
909: -- Deletes all the AK Metadata Related to the Analysis Option
910: BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata(
911: p_Commit => p_Commit
906: -- Need to find out Param Portlet before AK is deleted
907: l_Parameter_Portlet := BSC_BIS_KPI_CRUD_PUB.Get_Param_Portlet_By_Region(l_Region_Code);
908:
909: -- Deletes all the AK Metadata Related to the Analysis Option
910: BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata(
911: p_Commit => p_Commit
912: , p_Region_Code => l_Region_Code
913: , p_Region_Code_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
914: , x_Return_Status => x_Return_Status
909: -- Deletes all the AK Metadata Related to the Analysis Option
910: BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata(
911: p_Commit => p_Commit
912: , p_Region_Code => l_Region_Code
913: , p_Region_Code_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
914: , x_Return_Status => x_Return_Status
915: , x_Msg_Count => x_Msg_Count
916: , x_Msg_Data => x_Msg_Data
917: );
922: ELSE -- If the Analysis Option does not have its own AK Region
923: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(l_Kpi_Id, NULL);
924:
925: -- Need to find out Param Portlet before AK is deleted
926: l_Parameter_Portlet := BSC_BIS_KPI_CRUD_PUB.Get_Param_Portlet_By_Region(l_Region_Code);
927:
928: BSC_BIS_KPI_CRUD_PUB.Delete_Measure_Region_Item(
929: p_Commit => p_commit
930: ,p_Param_Portlet_Region_Code => l_Region_Code
924:
925: -- Need to find out Param Portlet before AK is deleted
926: l_Parameter_Portlet := BSC_BIS_KPI_CRUD_PUB.Get_Param_Portlet_By_Region(l_Region_Code);
927:
928: BSC_BIS_KPI_CRUD_PUB.Delete_Measure_Region_Item(
929: p_Commit => p_commit
930: ,p_Param_Portlet_Region_Code => l_Region_Code
931: ,p_Measure_Short_Name => p_Measure_Short_Name
932: ,p_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID -- BSC
928: BSC_BIS_KPI_CRUD_PUB.Delete_Measure_Region_Item(
929: p_Commit => p_commit
930: ,p_Param_Portlet_Region_Code => l_Region_Code
931: ,p_Measure_Short_Name => p_Measure_Short_Name
932: ,p_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID -- BSC
933: ,x_return_status => x_return_status
934: ,x_msg_count => x_msg_count
935: ,x_msg_data => x_msg_data
936: );
939: END IF;
940: END IF;
941:
942:
943: BSC_BIS_KPI_CRUD_PUB.Unassign_Kpi_Analysis_Option (
944: p_Commit => p_commit
945: ,p_Kpi_Id => l_kpi_Id
946: ,p_Dataset_Id => l_Dataset_Id
947: ,x_return_status => x_return_status
977: FROM BSC_KPI_ANALYSIS_MEASURES_B
978: WHERE INDICATOR = l_kpi_Id;
979:
980: IF(l_Analysis_Option_Id <= l_Last_Analysis_Option) THEN
981: BSC_BIS_KPI_CRUD_PUB.Referesh_AK_Metadata (
982: p_Commit => p_Commit
983: , p_Kpi_Id => l_Kpi_Id
984: , p_Deleted_AO_Index => l_Analysis_Option_Id
985: , p_Param_Portlet_Region_Code => l_Parameter_Portlet
1003: ELSE
1004: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(l_Kpi_Id, NULL); -- Tyep BSC_
1005: END IF;
1006:
1007: BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata(
1008: p_Commit => p_Commit
1009: , p_Region_Code => l_Region_Code
1010: , p_Region_Code_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
1011: , x_Return_Status => x_Return_Status
1006:
1007: BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata(
1008: p_Commit => p_Commit
1009: , p_Region_Code => l_Region_Code
1010: , p_Region_Code_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
1011: , x_Return_Status => x_Return_Status
1012: , x_Msg_Count => x_Msg_Count
1013: , x_Msg_Data => x_Msg_Data
1014: );
1045: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1047: END IF;
1048:
1049: l_Parameter_Portlet := BSC_BIS_KPI_CRUD_PUB.Get_Param_Portlet_By_Region(l_Region_Code);
1050:
1051: -- parameter was dynamically created - so delete it and its region/region items
1052: -- added for Bug#4558279
1053: IF (p_Param_Portlet_Region_Code <> l_Parameter_Portlet) THEN
1050:
1051: -- parameter was dynamically created - so delete it and its region/region items
1052: -- added for Bug#4558279
1053: IF (p_Param_Portlet_Region_Code <> l_Parameter_Portlet) THEN
1054: BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata(
1055: p_Commit => p_Commit
1056: , p_Region_Code => l_Parameter_Portlet
1057: , p_Region_Code_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
1058: , x_Return_Status => x_Return_Status
1053: IF (p_Param_Portlet_Region_Code <> l_Parameter_Portlet) THEN
1054: BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata(
1055: p_Commit => p_Commit
1056: , p_Region_Code => l_Parameter_Portlet
1057: , p_Region_Code_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
1058: , x_Return_Status => x_Return_Status
1059: , x_Msg_Count => x_Msg_Count
1060: , x_Msg_Data => x_Msg_Data
1061: );
1102: ROLLBACK TO DeleteEndToEndKPI;
1103: WHEN NO_DATA_FOUND THEN
1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105: IF (x_msg_data IS NOT NULL) THEN
1106: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_Kpi_End_To_End ';
1107: ELSE
1108: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_Kpi_End_To_End ';
1109: END IF;
1110: ROLLBACK TO DeleteEndToEndKPI;
1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105: IF (x_msg_data IS NOT NULL) THEN
1106: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_Kpi_End_To_End ';
1107: ELSE
1108: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_Kpi_End_To_End ';
1109: END IF;
1110: ROLLBACK TO DeleteEndToEndKPI;
1111: WHEN OTHERS THEN
1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1110: ROLLBACK TO DeleteEndToEndKPI;
1111: WHEN OTHERS THEN
1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1113: IF (x_msg_data IS NOT NULL) THEN
1114: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_Kpi_End_To_End ';
1115: ELSE
1116: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_Kpi_End_To_End ';
1117: END IF;
1118: ROLLBACK TO DeleteEndToEndKPI;
1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1113: IF (x_msg_data IS NOT NULL) THEN
1114: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_Kpi_End_To_End ';
1115: ELSE
1116: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_Kpi_End_To_End ';
1117: END IF;
1118: ROLLBACK TO DeleteEndToEndKPI;
1119: END Delete_Kpi_End_To_End;
1120:
1197: EXIT WHEN c_dim%NOTFOUND;
1198: l_dimension_grp(l_counter) := substr(l_ak_attr2, 1, instr(l_ak_attr2,'+')-1);
1199: l_dimension_object(l_counter) := substr(l_ak_attr2, instr(l_ak_attr2,'+')+1);
1200:
1201: IF ((l_dimension_grp(l_counter) <> BSC_BIS_KPI_CRUD_PUB.c_oltp_time) AND
1202: (l_dimension_grp(l_counter) <> BSC_BIS_KPI_CRUD_PUB.c_edw_time)) THEN
1203:
1204: x_non_time_dimension_groups(x_non_time_counter) := l_dimension_grp(l_counter);
1205: x_non_time_dimension_objects(x_non_time_counter) := l_dimension_object(l_counter);
1198: l_dimension_grp(l_counter) := substr(l_ak_attr2, 1, instr(l_ak_attr2,'+')-1);
1199: l_dimension_object(l_counter) := substr(l_ak_attr2, instr(l_ak_attr2,'+')+1);
1200:
1201: IF ((l_dimension_grp(l_counter) <> BSC_BIS_KPI_CRUD_PUB.c_oltp_time) AND
1202: (l_dimension_grp(l_counter) <> BSC_BIS_KPI_CRUD_PUB.c_edw_time)) THEN
1203:
1204: x_non_time_dimension_groups(x_non_time_counter) := l_dimension_grp(l_counter);
1205: x_non_time_dimension_objects(x_non_time_counter) := l_dimension_object(l_counter);
1206:
1290: CLOSE c_Dim;
1291: END IF;
1292:
1293: IF (x_msg_data IS NOT NULL) THEN
1294: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code ';
1295: ELSE
1296: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code ';
1297: END IF;
1298: WHEN OTHERS THEN
1292:
1293: IF (x_msg_data IS NOT NULL) THEN
1294: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code ';
1295: ELSE
1296: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code ';
1297: END IF;
1298: WHEN OTHERS THEN
1299: IF c_Dim%ISOPEN THEN
1300: CLOSE c_Dim;
1300: CLOSE c_Dim;
1301: END IF;
1302:
1303: IF (x_msg_data IS NOT NULL) THEN
1304: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code ';
1305: ELSE
1306: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code ';
1307: END IF;
1308:
1302:
1303: IF (x_msg_data IS NOT NULL) THEN
1304: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code ';
1305: ELSE
1306: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code ';
1307: END IF;
1308:
1309: END Get_Dim_Info_From_Region_Code;
1310:
1339: FOR l_dim IN 1..p_non_time_counter LOOP
1340:
1341:
1342: l_region_item_rec.Attribute_Code := p_non_time_dimension_objects(l_dim);
1343: l_region_item_rec.Attribute_Application_Id := BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID;
1344: l_region_item_rec.Display_Sequence := x_sequence;
1345: l_region_item_rec.Node_Display_Flag := ' ';
1346: l_region_item_rec.Required_Flag := ' ';
1347: l_region_item_rec.Queryable_Flag := 'Y';
1385: FOR l_dim IN 1..p_time_counter LOOP
1386:
1387:
1388: l_region_item_rec.Attribute_Code := p_time_dimension_objects(l_dim);
1389: l_region_item_rec.Attribute_Application_Id := BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID;
1390: l_region_item_rec.Display_Sequence := x_sequence;
1391: l_region_item_rec.Node_Display_Flag := ' ';
1392: l_region_item_rec.Required_Flag := ' ';
1393: l_region_item_rec.Queryable_Flag := 'Y';
1436: BIS_PMV_REGION_ITEMS_PVT.CREATE_REGION_ITEMS
1437: (
1438: p_commit => p_commit
1439: ,p_region_code => l_Region_Code
1440: ,p_region_application_id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
1441: ,p_Region_Item_Tbl => l_region_item_table_dim_set
1442: ,x_return_status => x_return_status
1443: ,x_msg_count => x_msg_count
1444: ,x_msg_data => x_msg_data
1531: ,p_measure_max_bud_value => NULL
1532: ,p_measure_app_id => p_Measure_App_Id
1533: ,p_measure_col => NULL
1534: ,p_measure_group_id => p_measure_group_id
1535: ,p_measure_projection_id => BSC_BIS_KPI_CRUD_PUB.C_NO_PROJECTION
1536: ,p_measure_type => p_measure_type
1537: ,p_measure_apply_rollup => NULL
1538: ,p_measure_function_name => p_measure_function_name
1539: ,p_measure_enable_link => 'N'
1598: WHEN NO_DATA_FOUND THEN
1599: ROLLBACK TO CreateMeasureSP;
1600: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1601: IF (x_msg_data IS NOT NULL) THEN
1602: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Measure ';
1603: ELSE
1604: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Measure ';
1605: END IF;
1606: WHEN OTHERS THEN
1600: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1601: IF (x_msg_data IS NOT NULL) THEN
1602: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Measure ';
1603: ELSE
1604: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Measure ';
1605: END IF;
1606: WHEN OTHERS THEN
1607: ROLLBACK TO CreateMeasureSP;
1608: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1606: WHEN OTHERS THEN
1607: ROLLBACK TO CreateMeasureSP;
1608: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1609: IF (x_msg_data IS NOT NULL) THEN
1610: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Measure ';
1611: ELSE
1612: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Measure ';
1613: END IF;
1614: END Create_Measure;
1608: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1609: IF (x_msg_data IS NOT NULL) THEN
1610: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Measure ';
1611: ELSE
1612: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Measure ';
1613: END IF;
1614: END Create_Measure;
1615:
1616:
1646: x_measure_short_name := l_measure_short_name;
1647:
1648: --Call procedure to assign the real measure to the analysis option group.
1649: -- As of now passing AO Group Id as 0
1650: l_Region_Code := BSC_BIS_KPI_CRUD_PUB.Get_Next_Region_Code_By_AO(
1651: p_Kpi_Id => p_Indicator
1652: ,p_Analysis_Group0 => 0
1653: );
1654:
1712: WHEN NO_DATA_FOUND THEN
1713: ROLLBACK TO AssociateKPIToAO;
1714: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1715: IF (x_msg_data IS NOT NULL) THEN
1716: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Associate_KPI_To_AO ';
1717: ELSE
1718: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Associate_KPI_To_AO ';
1719: END IF;
1720: WHEN OTHERS THEN
1714: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1715: IF (x_msg_data IS NOT NULL) THEN
1716: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Associate_KPI_To_AO ';
1717: ELSE
1718: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Associate_KPI_To_AO ';
1719: END IF;
1720: WHEN OTHERS THEN
1721: ROLLBACK TO AssociateKPIToAO;
1722: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1720: WHEN OTHERS THEN
1721: ROLLBACK TO AssociateKPIToAO;
1722: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1723: IF (x_msg_data IS NOT NULL) THEN
1724: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Associate_KPI_To_AO ';
1725: ELSE
1726: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Associate_KPI_To_AO ';
1727: END IF;
1728: END Associate_KPI_To_AO;
1722: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1723: IF (x_msg_data IS NOT NULL) THEN
1724: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Associate_KPI_To_AO ';
1725: ELSE
1726: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Associate_KPI_To_AO ';
1727: END IF;
1728: END Associate_KPI_To_AO;
1729:
1730:
1752:
1753: --DBMS_OUTPUT.PUT_LINE('Create_Measure_Region_Item - region_code = ' || l_Region_Code);
1754:
1755: l_region_item_rec.Attribute_Code := p_measure_short_name;
1756: l_region_item_rec.Attribute_Application_Id := BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID;
1757: l_region_item_rec.Display_Sequence := p_sequence_number;
1758: l_region_item_rec.Node_Display_Flag := 'Y';
1759: l_region_item_rec.Required_Flag := ' ';
1760: l_region_item_rec.Queryable_Flag := ' ';
1763: l_region_item_rec.Sort_Sequence := NULL;
1764: l_region_item_rec.Initial_Sort_Sequence := NULL;
1765: l_region_item_rec.Sort_Direction := NULL;
1766: l_region_item_rec.Url := NULL;
1767: l_region_item_rec.Attribute_Type := BSC_BIS_KPI_CRUD_PUB.C_MEASURE_ATTRIBURE_TYPE;
1768: -- We need to reconvert the format_id to a correct mask
1769: l_region_item_rec.Display_Format := Get_Format_Mask(p_dataset_format_id);
1770: l_region_item_rec.Display_Type := NULL;
1771: l_region_item_rec.Measure_Level := p_measure_short_name;
1793:
1794: BIS_PMV_REGION_ITEMS_PVT.CREATE_REGION_ITEMS(
1795: p_commit => p_commit
1796: ,p_region_code => l_Region_Code
1797: ,p_region_application_id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
1798: ,p_Region_Item_Tbl => l_region_item_table_measure
1799: ,x_return_status => x_return_status
1800: ,x_msg_count => x_msg_count
1801: ,x_msg_data => x_msg_data
1962:
1963: WHEN NO_DATA_FOUND THEN
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1965: IF (x_msg_data IS NOT NULL) THEN
1966: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.RETRIEVE_DIMENSION_OBJECTS ';
1967: ELSE
1968: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.RETRIEVE_DIMENSION_OBJECTS ';
1969: END IF;
1970: WHEN OTHERS THEN
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1965: IF (x_msg_data IS NOT NULL) THEN
1966: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.RETRIEVE_DIMENSION_OBJECTS ';
1967: ELSE
1968: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.RETRIEVE_DIMENSION_OBJECTS ';
1969: END IF;
1970: WHEN OTHERS THEN
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1972: IF (x_msg_data IS NOT NULL) THEN
1969: END IF;
1970: WHEN OTHERS THEN
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1972: IF (x_msg_data IS NOT NULL) THEN
1973: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.RETRIEVE_DIMENSION_OBJECTS ';
1974: ELSE
1975: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.RETRIEVE_DIMENSION_OBJECTS ';
1976: END IF;
1977:
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1972: IF (x_msg_data IS NOT NULL) THEN
1973: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.RETRIEVE_DIMENSION_OBJECTS ';
1974: ELSE
1975: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.RETRIEVE_DIMENSION_OBJECTS ';
1976: END IF;
1977:
1978: END RETRIEVE_DIMENSION_OBJECTS;
1979:
1991: RETURN l_tab_id;
1992:
1993: EXCEPTION
1994: WHEN OTHERS THEN
1995: RETURN BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY;
1996: END Get_Tab_Id;
1997:
1998:
1999: -- Returns the KPI Group Id (aka Objective Group)
2007: SELECT A.IND_GROUP_ID
2008: FROM BSC_TAB_IND_GROUPS_B A
2009: WHERE A.SHORT_NAME = p_Kpi_Portlet_Function_Name;
2010: BEGIN
2011: l_Group_Id := BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY;
2012: FOR cGetId IN c_GetId LOOP
2013: l_Group_Id := cGetId.IND_GROUP_ID;
2014: END LOOP;
2015: RETURN l_group_id;
2015: RETURN l_group_id;
2016:
2017: EXCEPTION
2018: WHEN OTHERS THEN
2019: RETURN BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY;
2020:
2021: END Get_Group_Id;
2022:
2023:
2112: ,p_dim_name => l_Time_Dim_Obj_sh)) LOOP
2113: l_periodicity_id := NULL;
2114:
2115: -- added condition for Calendar Enhancement#4376162
2116: IF (BSC_BIS_KPI_CRUD_PUB.Is_DimObj_Periodicity(l_Time_Dim_Obj_Sh) = FND_API.G_TRUE) THEN
2117: BSC_BIS_KPI_CRUD_PUB.Get_Non_DBI_Periodicities (
2118: p_Time_Short_Name => l_Time_Dim_Obj_Sh
2119: , x_Periodicity_Id => l_Periodicity_Id
2120: , x_Calendar_Id => l_Calendar_Id_Aux
2113: l_periodicity_id := NULL;
2114:
2115: -- added condition for Calendar Enhancement#4376162
2116: IF (BSC_BIS_KPI_CRUD_PUB.Is_DimObj_Periodicity(l_Time_Dim_Obj_Sh) = FND_API.G_TRUE) THEN
2117: BSC_BIS_KPI_CRUD_PUB.Get_Non_DBI_Periodicities (
2118: p_Time_Short_Name => l_Time_Dim_Obj_Sh
2119: , x_Periodicity_Id => l_Periodicity_Id
2120: , x_Calendar_Id => l_Calendar_Id_Aux
2121: , x_Return_Status => x_Return_Status
2240: WHEN OTHERS THEN
2241: ROLLBACK TO BSCAsgnKpiPeriodicities;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: IF (x_msg_data IS NOT NULL) THEN
2244: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Assign_Kpi_Periodicities ';
2245: ELSE
2246: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Assign_Kpi_Periodicities ';
2247: END IF;
2248: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: IF (x_msg_data IS NOT NULL) THEN
2244: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Assign_Kpi_Periodicities ';
2245: ELSE
2246: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Assign_Kpi_Periodicities ';
2247: END IF;
2248: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2249:
2250: end Assign_Kpi_Periodicities;
2362: EXCEPTION
2363:
2364: WHEN NO_DATA_FOUND THEN
2365: IF (x_msg_data IS NOT NULL) THEN
2366: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Dim_Dim_Level_Columns ';
2367: ELSE
2368: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Dim_Dim_Level_Columns ';
2369: END IF;
2370: WHEN OTHERS THEN
2364: WHEN NO_DATA_FOUND THEN
2365: IF (x_msg_data IS NOT NULL) THEN
2366: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Dim_Dim_Level_Columns ';
2367: ELSE
2368: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Dim_Dim_Level_Columns ';
2369: END IF;
2370: WHEN OTHERS THEN
2371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2372: IF (x_msg_data IS NOT NULL) THEN
2369: END IF;
2370: WHEN OTHERS THEN
2371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2372: IF (x_msg_data IS NOT NULL) THEN
2373: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Dim_Dim_Level_Columns ';
2374: ELSE
2375: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Dim_Dim_Level_Columns ';
2376: END IF;
2377:
2371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2372: IF (x_msg_data IS NOT NULL) THEN
2373: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Dim_Dim_Level_Columns ';
2374: ELSE
2375: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Dim_Dim_Level_Columns ';
2376: END IF;
2377:
2378: END Update_Dim_Dim_Level_Columns;
2379:
2413:
2414: l_Colspan_Attr_Code := get_Unique_Attribute_Code (
2415: p_Region_Code => l_Region_Code
2416: , p_Measure_Short_Name => p_Measure_Short_Name
2417: , p_Append_String => BSC_BIS_KPI_CRUD_PUB.C_COLSPAN
2418: );
2419:
2420: l_region_item_rec.Attribute_Code := p_measure_short_name;
2421: l_region_item_rec.Attribute_Application_Id := BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID;
2417: , p_Append_String => BSC_BIS_KPI_CRUD_PUB.C_COLSPAN
2418: );
2419:
2420: l_region_item_rec.Attribute_Code := p_measure_short_name;
2421: l_region_item_rec.Attribute_Application_Id := BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID;
2422:
2423: -- We currently do not have a retrive API to get the Sequence Numbers.
2424: l_region_item_rec.Display_Sequence := p_sequence_number;
2425:
2433: l_Region_Item_Rec.Sort_Sequence := NULL;
2434: l_Region_Item_Rec.Initial_Sort_Sequence := NULL;
2435: l_Region_Item_Rec.Sort_Direction := NULL;
2436: l_Region_Item_Rec.Url := NULL;
2437: l_Region_Item_Rec.Attribute_Type := BSC_BIS_KPI_CRUD_PUB.C_MEASURE_ATTRIBURE_TYPE;
2438: l_Region_Item_Rec.Display_Format := Get_Format_Mask(p_Dataset_Format_Id);
2439: l_Region_Item_Rec.Display_Type := BSC_BIS_KPI_CRUD_PUB.C_AUTOFACTOR_GROUP1;
2440: l_Region_Item_Rec.Measure_Level := p_Measure_Short_Name; -- Earlier we were using l_Colspan_Attr_Code;
2441: l_Region_Item_Rec.Base_Column := NULL;
2435: l_Region_Item_Rec.Sort_Direction := NULL;
2436: l_Region_Item_Rec.Url := NULL;
2437: l_Region_Item_Rec.Attribute_Type := BSC_BIS_KPI_CRUD_PUB.C_MEASURE_ATTRIBURE_TYPE;
2438: l_Region_Item_Rec.Display_Format := Get_Format_Mask(p_Dataset_Format_Id);
2439: l_Region_Item_Rec.Display_Type := BSC_BIS_KPI_CRUD_PUB.C_AUTOFACTOR_GROUP1;
2440: l_Region_Item_Rec.Measure_Level := p_Measure_Short_Name; -- Earlier we were using l_Colspan_Attr_Code;
2441: l_Region_Item_Rec.Base_Column := NULL;
2442: l_Region_Item_Rec.Lov_Where_Clause := NULL;
2443: l_Region_Item_Rec.Graph_Position := 1;
2463:
2464: BIS_PMV_REGION_ITEMS_PVT.UPDATE_REGION_ITEMS(
2465: p_Commit => p_Commit
2466: ,p_Region_Code => l_Region_Code
2467: ,p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
2468: ,p_Region_Item_Tbl => l_Region_Item_Table_Measure
2469: ,x_Return_Status => x_Return_Status
2470: ,x_Msg_Count => x_Msg_Count
2471: ,x_Msg_Data => x_Msg_Data
2498:
2499: WHEN NO_DATA_FOUND THEN
2500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2501: IF (x_msg_data IS NOT NULL) THEN
2502: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Measure_Region_Item ';
2503: ELSE
2504: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Measure_Region_Item ';
2505: END IF;
2506: WHEN OTHERS THEN
2500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2501: IF (x_msg_data IS NOT NULL) THEN
2502: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Measure_Region_Item ';
2503: ELSE
2504: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Measure_Region_Item ';
2505: END IF;
2506: WHEN OTHERS THEN
2507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2508: IF (x_msg_data IS NOT NULL) THEN
2505: END IF;
2506: WHEN OTHERS THEN
2507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2508: IF (x_msg_data IS NOT NULL) THEN
2509: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Measure_Region_Item ';
2510: ELSE
2511: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Measure_Region_Item ';
2512: END IF;
2513: END Update_Measure_Region_Item;
2507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2508: IF (x_msg_data IS NOT NULL) THEN
2509: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Measure_Region_Item ';
2510: ELSE
2511: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Measure_Region_Item ';
2512: END IF;
2513: END Update_Measure_Region_Item;
2514:
2515:
2977: l_report_region_rec.Group_By := NULL;
2978: l_report_region_rec.Order_By := NULL;
2979: l_report_region_rec.Plsql_For_Report_Query := p_Kpi_Id||'.'||p_Analysis_Option_Id;
2980: l_report_region_rec.Display_Subtotals := NULL;
2981: l_report_region_rec.Data_Source := BSC_BIS_KPI_CRUD_PUB.C_BSC_SOURCE;
2982: l_report_region_rec.Where_Clause := NULL;
2983: l_report_region_rec.Dimension_Group := NULL;
2984: l_report_region_rec.Parameter_Layout := NULL;
2985: l_report_region_rec.Kpi_Id := p_Kpi_Id;
3017: END IF;
3018:
3019: WHEN NO_DATA_FOUND THEN
3020: IF (x_msg_data IS NOT NULL) THEN
3021: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Region_By_AO ';
3022: ELSE
3023: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Region_By_AO ';
3024: END IF;
3025: WHEN OTHERS THEN
3019: WHEN NO_DATA_FOUND THEN
3020: IF (x_msg_data IS NOT NULL) THEN
3021: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Region_By_AO ';
3022: ELSE
3023: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Region_By_AO ';
3024: END IF;
3025: WHEN OTHERS THEN
3026: IF (x_msg_data IS NOT NULL) THEN
3027: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Region_By_AO ';
3023: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Region_By_AO ';
3024: END IF;
3025: WHEN OTHERS THEN
3026: IF (x_msg_data IS NOT NULL) THEN
3027: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Region_By_AO ';
3028: ELSE
3029: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Region_By_AO ';
3030: END IF;
3031:
3025: WHEN OTHERS THEN
3026: IF (x_msg_data IS NOT NULL) THEN
3027: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Region_By_AO ';
3028: ELSE
3029: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Region_By_AO ';
3030: END IF;
3031:
3032: END Create_Region_By_AO;
3033:
3073: l_report_region_rec.Group_By := NULL;
3074: l_report_region_rec.Order_By := NULL;
3075: l_report_region_rec.Plsql_For_Report_Query := p_Kpi_Id||'.'||p_Analysis_Option_Id;
3076: l_report_region_rec.Display_Subtotals := NULL;
3077: l_report_region_rec.Data_Source := BSC_BIS_KPI_CRUD_PUB.C_BSC_SOURCE;
3078: l_report_region_rec.Where_Clause := NULL;
3079: l_report_region_rec.Dimension_Group := NULL;
3080: l_report_region_rec.Parameter_Layout := NULL;
3081: l_report_region_rec.Kpi_Id := p_Kpi_Id;
3113: END IF;
3114:
3115: WHEN NO_DATA_FOUND THEN
3116: IF (x_msg_data IS NOT NULL) THEN
3117: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Region_By_AO ';
3118: ELSE
3119: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Region_By_AO ';
3120: END IF;
3121: WHEN OTHERS THEN
3115: WHEN NO_DATA_FOUND THEN
3116: IF (x_msg_data IS NOT NULL) THEN
3117: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Region_By_AO ';
3118: ELSE
3119: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Region_By_AO ';
3120: END IF;
3121: WHEN OTHERS THEN
3122: IF (x_msg_data IS NOT NULL) THEN
3123: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Region_By_AO ';
3119: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Region_By_AO ';
3120: END IF;
3121: WHEN OTHERS THEN
3122: IF (x_msg_data IS NOT NULL) THEN
3123: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Region_By_AO ';
3124: ELSE
3125: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Region_By_AO ';
3126: END IF;
3127:
3121: WHEN OTHERS THEN
3122: IF (x_msg_data IS NOT NULL) THEN
3123: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Region_By_AO ';
3124: ELSE
3125: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Region_By_AO ';
3126: END IF;
3127:
3128:
3129: END Update_Region_By_AO;
3302:
3303: BEGIN
3304:
3305: l_region_item_rec.Attribute_Code := p_Param_Portlet_Region_Code;
3306: l_region_item_rec.Attribute_Application_Id := BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID;
3307: l_region_item_rec.Display_Sequence := p_sequence_number;
3308: l_region_item_rec.Node_Display_Flag := 'Y';
3309: l_region_item_rec.Required_Flag := ' ';
3310: l_region_item_rec.Queryable_Flag := ' ';
3347:
3348: BIS_PMV_REGION_ITEMS_PVT.CREATE_REGION_ITEMS(
3349: p_commit => p_commit
3350: ,p_region_code => p_Root_AK_Region_Code
3351: ,p_region_application_id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
3352: ,p_Region_Item_Tbl => l_region_item_table_nest
3353: ,x_return_status => x_return_status
3354: ,x_msg_count => x_msg_count
3355: ,x_msg_data => x_msg_data
3374: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
3375: BEGIN
3376:
3377: l_Attribute_Code_Tbl(1) := p_Nested_Region_Code;
3378: l_Attribute_App_Id_Tbl(1) := BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID;
3379:
3380: BIS_PMV_REGION_ITEMS_PVT.DELETE_REGION_ITEMS
3381: ( p_commit => p_commit
3382: , p_region_code => p_Root_AK_Region
3694: l_Colspan_Attr_Code VARCHAR2(30);
3695: l_Format_Type VARCHAR2(3);
3696: l_Base_Column NUMBER;
3697: l_has_comp_or_plan BOOLEAN;
3698: l_non_time_dimension_groups BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3699: l_non_time_dimension_objects BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3700: l_non_time_dim_obj_short_names VARCHAR2(32000);
3701: l_all_dim_group_ids BSC_BIS_KPI_CRUD_PUB.BSC_NUMBER_TBL_TYPE;
3702: l_non_time_counter NUMBER;
3695: l_Format_Type VARCHAR2(3);
3696: l_Base_Column NUMBER;
3697: l_has_comp_or_plan BOOLEAN;
3698: l_non_time_dimension_groups BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3699: l_non_time_dimension_objects BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3700: l_non_time_dim_obj_short_names VARCHAR2(32000);
3701: l_all_dim_group_ids BSC_BIS_KPI_CRUD_PUB.BSC_NUMBER_TBL_TYPE;
3702: l_non_time_counter NUMBER;
3703: l_time_dimension_groups BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3697: l_has_comp_or_plan BOOLEAN;
3698: l_non_time_dimension_groups BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3699: l_non_time_dimension_objects BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3700: l_non_time_dim_obj_short_names VARCHAR2(32000);
3701: l_all_dim_group_ids BSC_BIS_KPI_CRUD_PUB.BSC_NUMBER_TBL_TYPE;
3702: l_non_time_counter NUMBER;
3703: l_time_dimension_groups BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3704: l_time_dimension_objects BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3705: l_time_dim_obj_short_names VARCHAR2(32000);
3699: l_non_time_dimension_objects BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3700: l_non_time_dim_obj_short_names VARCHAR2(32000);
3701: l_all_dim_group_ids BSC_BIS_KPI_CRUD_PUB.BSC_NUMBER_TBL_TYPE;
3702: l_non_time_counter NUMBER;
3703: l_time_dimension_groups BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3704: l_time_dimension_objects BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3705: l_time_dim_obj_short_names VARCHAR2(32000);
3706: l_time_counter NUMBER;
3707: l_msg_data VARCHAR2(2000);
3700: l_non_time_dim_obj_short_names VARCHAR2(32000);
3701: l_all_dim_group_ids BSC_BIS_KPI_CRUD_PUB.BSC_NUMBER_TBL_TYPE;
3702: l_non_time_counter NUMBER;
3703: l_time_dimension_groups BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3704: l_time_dimension_objects BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
3705: l_time_dim_obj_short_names VARCHAR2(32000);
3706: l_time_counter NUMBER;
3707: l_msg_data VARCHAR2(2000);
3708: BEGIN
3708: BEGIN
3709:
3710: FND_MSG_PUB.Initialize;
3711: x_return_status := FND_API.G_RET_STS_SUCCESS;
3712: l_has_comp_or_plan := BSC_BIS_KPI_CRUD_PUB.Has_Compare_To_Or_Plan (p_Param_Portlet_Region_Code);
3713:
3714: -- Create a new Nested Region Item (with Param Region Code)
3715: Create_Sim_Generic_Region_Item(
3716: p_commit => p_Commit
3716: p_commit => p_Commit
3717: , p_Region_Code => p_Region_Code
3718: , p_Region_Application_Id => p_Region_Application_Id
3719: , p_Attribute_Code => p_Param_Portlet_Region_Code
3720: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
3721: , p_Display_Sequence => (p_Display_Sequence + 10)
3722: , p_Node_Display_Flag => 'Y'
3723: , p_Required_Flag => ' '
3724: , p_Queryable_Flag => ' '
3753: Daily Periodicity time parameter and pass it on to PMV
3754: Added by visuri for Enhancement 4065098
3755: */
3756:
3757: BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code(
3758: p_param_portlet_region_code=>p_Param_Portlet_Region_Code
3759: ,x_non_time_dimension_groups=>l_non_time_dimension_groups
3760: ,x_non_time_dimension_objects=>l_non_time_dimension_objects
3761: ,x_non_time_dim_obj_short_names=> l_non_time_dim_obj_short_names
3773: END IF;
3774:
3775: IF (l_time_dim_obj_short_names IS NULL) THEN
3776:
3777: BSC_BIS_KPI_CRUD_PUB.Create_Sim_Generic_Region_Item(
3778: p_commit => p_Commit
3779: , p_Region_Code => p_Region_Code
3780: , p_Region_Application_Id => p_Region_Application_Id
3781: , p_Attribute_Code => BSC_BIS_KPI_CRUD_PUB.C_DAILY_PERIOD_ATTR_CODE
3777: BSC_BIS_KPI_CRUD_PUB.Create_Sim_Generic_Region_Item(
3778: p_commit => p_Commit
3779: , p_Region_Code => p_Region_Code
3780: , p_Region_Application_Id => p_Region_Application_Id
3781: , p_Attribute_Code => BSC_BIS_KPI_CRUD_PUB.C_DAILY_PERIOD_ATTR_CODE
3782: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BIS_APPLICATION_ID
3783: , p_Display_Sequence =>(p_Display_Sequence + 15)
3784: , p_Node_Display_Flag => 'N'
3785: , p_Required_Flag => 'N'
3778: p_commit => p_Commit
3779: , p_Region_Code => p_Region_Code
3780: , p_Region_Application_Id => p_Region_Application_Id
3781: , p_Attribute_Code => BSC_BIS_KPI_CRUD_PUB.C_DAILY_PERIOD_ATTR_CODE
3782: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BIS_APPLICATION_ID
3783: , p_Display_Sequence =>(p_Display_Sequence + 15)
3784: , p_Node_Display_Flag => 'N'
3785: , p_Required_Flag => 'N'
3786: , p_Queryable_Flag => 'Y'
3786: , p_Queryable_Flag => 'Y'
3787: , p_Display_Length => 0
3788: , p_Long_Label => NULL
3789: , p_Url => NULL
3790: , p_Attribute_Type => BSC_BIS_KPI_CRUD_PUB.C_HIDE_PARAMETER
3791: , p_Display_Format => NULL
3792: , p_Display_Type => NULL
3793: , p_Measure_Level => BSC_BIS_KPI_CRUD_PUB.C_DAILY_PERIOD_ATTR2
3794: , p_Base_Column => NULL
3789: , p_Url => NULL
3790: , p_Attribute_Type => BSC_BIS_KPI_CRUD_PUB.C_HIDE_PARAMETER
3791: , p_Display_Format => NULL
3792: , p_Display_Type => NULL
3793: , p_Measure_Level => BSC_BIS_KPI_CRUD_PUB.C_DAILY_PERIOD_ATTR2
3794: , p_Base_Column => NULL
3795: , p_Graph_Position => NULL
3796: , p_Graph_Style => NULL
3797: , p_Aggregate_Function => NULL
3818: -- Get the column spand attribute code.
3819: l_Colspan_Attr_Code := get_Unique_Attribute_Code (
3820: p_Region_Code => p_Region_Code
3821: , p_Measure_Short_Name => p_Measure_Short_Name
3822: , p_Append_String => BSC_BIS_KPI_CRUD_PUB.C_COLSPAN
3823: );
3824:
3825:
3826: -- Create a new Measure Region Item
3829: p_commit => p_Commit
3830: , p_Region_Code => p_Region_Code
3831: , p_Region_Application_Id => p_Region_Application_Id
3832: , p_Attribute_Code => p_Measure_Short_Name
3833: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
3834: , p_Display_Sequence => (p_Display_Sequence + 20)
3835: , p_Node_Display_Flag => 'Y'
3836: , p_Required_Flag => ' '
3837: , p_Queryable_Flag => ' '
3837: , p_Queryable_Flag => ' '
3838: , p_Display_Length => NVL(LENGTH(p_Analysis_Option_Name), 0)
3839: , p_Long_Label => p_Analysis_Option_Name
3840: , p_Url => NULL
3841: , p_Attribute_Type => BSC_BIS_KPI_CRUD_PUB.C_MEASURE_ATTRIBURE_TYPE
3842: , p_Display_Format => p_Display_Format
3843: , p_Display_Type => BSC_BIS_KPI_CRUD_PUB.C_AUTOFACTOR_GROUP1
3844: , p_Measure_Level => p_Measure_Short_Name --Earlier COLSPAN l_Colspan_Attr_Code -- COLSPAN Attribute as level
3845: , p_Base_Column => NULL
3839: , p_Long_Label => p_Analysis_Option_Name
3840: , p_Url => NULL
3841: , p_Attribute_Type => BSC_BIS_KPI_CRUD_PUB.C_MEASURE_ATTRIBURE_TYPE
3842: , p_Display_Format => p_Display_Format
3843: , p_Display_Type => BSC_BIS_KPI_CRUD_PUB.C_AUTOFACTOR_GROUP1
3844: , p_Measure_Level => p_Measure_Short_Name --Earlier COLSPAN l_Colspan_Attr_Code -- COLSPAN Attribute as level
3845: , p_Base_Column => NULL
3846: , p_Graph_Position => 1
3847: , p_Graph_Style => NULL
3865: IF (l_has_comp_or_plan) THEN
3866: l_Attribute_Code := get_Unique_Attribute_Code (
3867: p_Region_Code => p_Region_Code
3868: , p_Measure_Short_Name => p_Measure_Short_Name
3869: , p_Append_String => BSC_BIS_KPI_CRUD_PUB.C_COMPARISON_APPEND_STRING
3870: );
3871: l_Compare_Column := l_Attribute_Code;
3872:
3873: l_Lookup_Meaning := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'COMPARE_TO'); -- creates Prior
3876: p_commit => p_Commit
3877: , p_Region_Code => p_Region_Code
3878: , p_Region_Application_Id => p_Region_Application_Id
3879: , p_Attribute_Code => l_Attribute_Code
3880: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
3881: , p_Display_Sequence => p_Display_Sequence + 30
3882: , p_Node_Display_Flag => 'Y'
3883: , p_Required_Flag => ' '
3884: , p_Queryable_Flag => ' '
3884: , p_Queryable_Flag => ' '
3885: , p_Display_Length => NVL(LENGTH(l_Lookup_Meaning), 0)
3886: , p_Long_Label => l_Lookup_Meaning
3887: , p_Url => NULL
3888: , p_Attribute_Type => BSC_BIS_KPI_CRUD_PUB.C_COMPARE_ATTRIBURE_TYPE
3889: , p_Display_Format => p_Display_Format
3890: , p_Display_Type => BSC_BIS_KPI_CRUD_PUB.C_AUTOFACTOR_GROUP1
3891: , p_Measure_Level => p_Measure_Short_Name
3892: , p_Base_Column => NULL
3886: , p_Long_Label => l_Lookup_Meaning
3887: , p_Url => NULL
3888: , p_Attribute_Type => BSC_BIS_KPI_CRUD_PUB.C_COMPARE_ATTRIBURE_TYPE
3889: , p_Display_Format => p_Display_Format
3890: , p_Display_Type => BSC_BIS_KPI_CRUD_PUB.C_AUTOFACTOR_GROUP1
3891: , p_Measure_Level => p_Measure_Short_Name
3892: , p_Base_Column => NULL
3893: , p_Graph_Position => 1
3894: , p_Graph_Style => NULL
3911:
3912: -- Create a Change Region Item
3913:
3914: -- Added for Bug#3919666
3915: l_Format_Type := BSC_BIS_KPI_CRUD_PUB.Get_Change_Disp_Type_By_Mask(p_Format_Id);
3916:
3917: IF (l_Format_Type = BSC_BIS_KPI_CRUD_PUB.C_FORMAT_INTEGER) THEN
3918: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_INTEGER;
3919: ELSE
3913:
3914: -- Added for Bug#3919666
3915: l_Format_Type := BSC_BIS_KPI_CRUD_PUB.Get_Change_Disp_Type_By_Mask(p_Format_Id);
3916:
3917: IF (l_Format_Type = BSC_BIS_KPI_CRUD_PUB.C_FORMAT_INTEGER) THEN
3918: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_INTEGER;
3919: ELSE
3920: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_PERCENT;
3921: END IF;
3914: -- Added for Bug#3919666
3915: l_Format_Type := BSC_BIS_KPI_CRUD_PUB.Get_Change_Disp_Type_By_Mask(p_Format_Id);
3916:
3917: IF (l_Format_Type = BSC_BIS_KPI_CRUD_PUB.C_FORMAT_INTEGER) THEN
3918: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_INTEGER;
3919: ELSE
3920: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_PERCENT;
3921: END IF;
3922:
3916:
3917: IF (l_Format_Type = BSC_BIS_KPI_CRUD_PUB.C_FORMAT_INTEGER) THEN
3918: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_INTEGER;
3919: ELSE
3920: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_PERCENT;
3921: END IF;
3922:
3923: l_Attribute_Code := get_Unique_Attribute_Code (
3924: p_Region_Code => p_Region_Code
3922:
3923: l_Attribute_Code := get_Unique_Attribute_Code (
3924: p_Region_Code => p_Region_Code
3925: , p_Measure_Short_Name => p_Measure_Short_Name
3926: , p_Append_String => BSC_BIS_KPI_CRUD_PUB.C_CHANGE_APPEND_STRING
3927: );
3928:
3929: l_Lookup_Meaning := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'CHANGE');
3930: Create_Sim_Generic_Region_Item(
3931: p_commit => p_Commit
3932: , p_Region_Code => p_Region_Code
3933: , p_Region_Application_Id => p_Region_Application_Id
3934: , p_Attribute_Code => l_Attribute_Code
3935: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
3936: , p_Display_Sequence => (p_Display_Sequence + 40)
3937: , p_Node_Display_Flag => 'Y'
3938: , p_Required_Flag => ' '
3939: , p_Queryable_Flag => ' '
3939: , p_Queryable_Flag => ' '
3940: , p_Display_Length => NVL(LENGTH(l_Lookup_Meaning), 0)
3941: , p_Long_Label => l_Lookup_Meaning
3942: , p_Url => NULL
3943: , p_Attribute_Type => BSC_BIS_KPI_CRUD_PUB.C_CHANGE_ATTRIBURE_TYPE
3944: , p_Display_Format => NULL
3945: , p_Display_Type => l_Format_Type
3946: , p_Measure_Level => p_Measure_Short_Name -- Earlier using l_Colspan_Attr_Code -- COLSPAN Attribute as level
3947: , p_Base_Column => l_Base_Column
3972: p_commit => p_Commit
3973: , p_Region_Code => p_Region_Code
3974: , p_Region_Application_Id => p_Region_Application_Id
3975: , p_Attribute_Code => l_Colspan_Attr_Code
3976: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
3977: , p_Display_Sequence => (p_Display_Sequence + 70)
3978: , p_Node_Display_Flag => 'Y'
3979: , p_Required_Flag => ' '
3980: , p_Queryable_Flag => ' '
3980: , p_Queryable_Flag => ' '
3981: , p_Display_Length => NVL(LENGTH(l_Colspan_Attr_Code), 0)
3982: , p_Long_Label => l_Colspan_Attr_Code
3983: , p_Url => NULL
3984: , p_Attribute_Type => BSC_BIS_KPI_CRUD_PUB.C_COLUMN_SPAN_ATTRIBURE_TYPE
3985: , p_Display_Format => NULL
3986: , p_Display_Type => NULL
3987: , p_Measure_Level => NULL
3988: , p_Base_Column => NULL
4022: END IF;
4023:
4024: WHEN NO_DATA_FOUND THEN
4025: IF (x_msg_data IS NOT NULL) THEN
4026: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4027: ELSE
4028: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4029: END IF;
4030: WHEN OTHERS THEN
4024: WHEN NO_DATA_FOUND THEN
4025: IF (x_msg_data IS NOT NULL) THEN
4026: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4027: ELSE
4028: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4029: END IF;
4030: WHEN OTHERS THEN
4031: IF (x_msg_data IS NOT NULL) THEN
4032: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4028: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4029: END IF;
4030: WHEN OTHERS THEN
4031: IF (x_msg_data IS NOT NULL) THEN
4032: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4033: ELSE
4034: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4035: END IF;
4036: END Create_Addl_Ak_Region_Items;
4030: WHEN OTHERS THEN
4031: IF (x_msg_data IS NOT NULL) THEN
4032: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4033: ELSE
4034: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Addl_Ak_Region_Items ';
4035: END IF;
4036: END Create_Addl_Ak_Region_Items;
4037:
4038:
4206: CURSOR c_Upd_Change IS
4207: SELECT ATTRIBUTE_CODE
4208: FROM AK_REGION_ITEMS
4209: WHERE REGION_CODE = p_Region_Code
4210: AND ATTRIBUTE1 = BSC_BIS_KPI_CRUD_PUB.C_CHANGE_ATTRIBURE_TYPE;
4211:
4212: CURSOR c_Upd_CompareTo IS
4213: SELECT ATTRIBUTE_CODE
4214: FROM AK_REGION_ITEMS
4212: CURSOR c_Upd_CompareTo IS
4213: SELECT ATTRIBUTE_CODE
4214: FROM AK_REGION_ITEMS
4215: WHERE REGION_CODE = p_Region_Code
4216: AND ATTRIBUTE1 = BSC_BIS_KPI_CRUD_PUB.C_COMPARE_ATTRIBURE_TYPE;
4217:
4218: CURSOR c_Upd_GT_Actual IS
4219: SELECT ATTRIBUTE_CODE
4220: FROM AK_REGION_ITEMS
4218: CURSOR c_Upd_GT_Actual IS
4219: SELECT ATTRIBUTE_CODE
4220: FROM AK_REGION_ITEMS
4221: WHERE REGION_CODE = p_Region_Code
4222: AND ATTRIBUTE1 = BSC_BIS_KPI_CRUD_PUB.C_GRAND_TOTAL_ATTRIBURE_TYPE
4223: AND ATTRIBUTE3 = p_Measure_Short_Name;
4224:
4225: CURSOR c_Upd_GT_Compare IS
4226: SELECT ATTRIBUTE_CODE
4225: CURSOR c_Upd_GT_Compare IS
4226: SELECT ATTRIBUTE_CODE
4227: FROM AK_REGION_ITEMS
4228: WHERE REGION_CODE = p_Region_Code
4229: AND ATTRIBUTE1 = BSC_BIS_KPI_CRUD_PUB.C_GRAND_TOTAL_ATTRIBURE_TYPE
4230: AND ATTRIBUTE3 = l_Compare_Column;
4231:
4232: BEGIN
4233:
4238:
4239: l_Colspan_Attr_Code := get_Unique_Attribute_Code (
4240: p_Region_Code => p_Region_Code
4241: , p_Measure_Short_Name => p_Measure_Short_Name
4242: , p_Append_String => BSC_BIS_KPI_CRUD_PUB.C_COLSPAN
4243: );
4244:
4245: -- Update a Compare-To Region Item
4246: FOR cUComp IN c_Upd_CompareTo LOOP
4248: l_Attribute_Code := cUComp.Attribute_Code;
4249: l_Compare_Column := l_Attribute_Code;
4250: l_Display_Sequence := Get_Sequence_Id_By_Region(
4251: p_Region_Code => p_Region_Code
4252: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4253: , p_Attribute_Code => l_Attribute_Code
4254: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4255: );
4256:
4250: l_Display_Sequence := Get_Sequence_Id_By_Region(
4251: p_Region_Code => p_Region_Code
4252: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4253: , p_Attribute_Code => l_Attribute_Code
4254: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4255: );
4256:
4257: -- currently we do not have lookup for "Compare To"
4258: l_Lookup_Value := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'COMPARE_TO');
4261: p_commit => p_Commit
4262: , p_Region_Code => p_Region_Code
4263: , p_Region_Application_Id => p_Region_Application_Id
4264: , p_Attribute_Code => l_Attribute_Code
4265: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4266: , p_Display_Sequence => l_Display_Sequence
4267: , p_Node_Display_Flag => 'Y'
4268: , p_Required_Flag => ' '
4269: , p_Queryable_Flag => ' '
4269: , p_Queryable_Flag => ' '
4270: , p_Display_Length => LENGTH(l_Lookup_Value)
4271: , p_Long_Label => l_Lookup_Value
4272: , p_Url => NULL
4273: , p_Attribute_Type => BSC_BIS_KPI_CRUD_PUB.C_COMPARE_ATTRIBURE_TYPE
4274: , p_Display_Format => p_Display_Format
4275: , p_Display_Type => BSC_BIS_KPI_CRUD_PUB.C_AUTOFACTOR_GROUP1
4276: , p_Measure_Level => p_Measure_Short_Name
4277: , p_Base_Column => NULL
4271: , p_Long_Label => l_Lookup_Value
4272: , p_Url => NULL
4273: , p_Attribute_Type => BSC_BIS_KPI_CRUD_PUB.C_COMPARE_ATTRIBURE_TYPE
4274: , p_Display_Format => p_Display_Format
4275: , p_Display_Type => BSC_BIS_KPI_CRUD_PUB.C_AUTOFACTOR_GROUP1
4276: , p_Measure_Level => p_Measure_Short_Name
4277: , p_Base_Column => NULL
4278: , p_Graph_Position => 1
4279: , p_Graph_Style => NULL
4303: l_Attribute_Code := cUChange.Attribute_Code;
4304:
4305: l_Display_Sequence := Get_Sequence_Id_By_Region(
4306: p_Region_Code => p_Region_Code
4307: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4308: , p_Attribute_Code => l_Attribute_Code
4309: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4310: );
4311:
4305: l_Display_Sequence := Get_Sequence_Id_By_Region(
4306: p_Region_Code => p_Region_Code
4307: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4308: , p_Attribute_Code => l_Attribute_Code
4309: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4310: );
4311:
4312:
4313: l_Lookup_Value := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'CHANGE');
4312:
4313: l_Lookup_Value := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'CHANGE');
4314:
4315: -- Added for Bug#3919666
4316: l_Format_Type := BSC_BIS_KPI_CRUD_PUB.Get_Change_Disp_Type_By_Mask(p_Format_Id);
4317:
4318: IF (l_Format_Type = BSC_BIS_KPI_CRUD_PUB.C_FORMAT_INTEGER) THEN
4319: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_INTEGER;
4320: ELSE
4314:
4315: -- Added for Bug#3919666
4316: l_Format_Type := BSC_BIS_KPI_CRUD_PUB.Get_Change_Disp_Type_By_Mask(p_Format_Id);
4317:
4318: IF (l_Format_Type = BSC_BIS_KPI_CRUD_PUB.C_FORMAT_INTEGER) THEN
4319: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_INTEGER;
4320: ELSE
4321: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_PERCENT;
4322: END IF;
4315: -- Added for Bug#3919666
4316: l_Format_Type := BSC_BIS_KPI_CRUD_PUB.Get_Change_Disp_Type_By_Mask(p_Format_Id);
4317:
4318: IF (l_Format_Type = BSC_BIS_KPI_CRUD_PUB.C_FORMAT_INTEGER) THEN
4319: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_INTEGER;
4320: ELSE
4321: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_PERCENT;
4322: END IF;
4323:
4317:
4318: IF (l_Format_Type = BSC_BIS_KPI_CRUD_PUB.C_FORMAT_INTEGER) THEN
4319: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_INTEGER;
4320: ELSE
4321: l_Base_Column := BSC_BIS_KPI_CRUD_PUB.C_CHANGE_TYPE_PERCENT;
4322: END IF;
4323:
4324:
4325: Update_Sim_Generic_Region_Item(
4326: p_commit => p_Commit
4327: , p_Region_Code => p_Region_Code
4328: , p_Region_Application_Id => p_Region_Application_Id
4329: , p_Attribute_Code => l_Attribute_Code
4330: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4331: , p_Display_Sequence => l_Display_Sequence
4332: , p_Node_Display_Flag => 'Y'
4333: , p_Required_Flag => ' '
4334: , p_Queryable_Flag => ' '
4334: , p_Queryable_Flag => ' '
4335: , p_Display_Length => LENGTH(l_Lookup_Value)
4336: , p_Long_Label => l_Lookup_Value
4337: , p_Url => NULL
4338: , p_Attribute_Type => BSC_BIS_KPI_CRUD_PUB.C_CHANGE_ATTRIBURE_TYPE
4339: , p_Display_Format => NULL
4340: , p_Display_Type => l_Format_Type
4341: , p_Measure_Level => p_Measure_Short_Name
4342: , p_Base_Column => l_Base_Column
4381: END IF;
4382:
4383: WHEN NO_DATA_FOUND THEN
4384: IF (x_msg_data IS NOT NULL) THEN
4385: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4386: ELSE
4387: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4388: END IF;
4389: WHEN OTHERS THEN
4383: WHEN NO_DATA_FOUND THEN
4384: IF (x_msg_data IS NOT NULL) THEN
4385: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4386: ELSE
4387: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4388: END IF;
4389: WHEN OTHERS THEN
4390: IF (x_msg_data IS NOT NULL) THEN
4391: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4387: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4388: END IF;
4389: WHEN OTHERS THEN
4390: IF (x_msg_data IS NOT NULL) THEN
4391: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4392: ELSE
4393: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4394: END IF;
4395: END Update_Addl_Ak_Region_Items;
4389: WHEN OTHERS THEN
4390: IF (x_msg_data IS NOT NULL) THEN
4391: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4392: ELSE
4393: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Update_Addl_Ak_Region_Items ';
4394: END IF;
4395: END Update_Addl_Ak_Region_Items;
4396:
4397:
4435: WHEN OTHERS THEN
4436: x_return_status := FND_API.G_RET_STS_ERROR;
4437: x_msg_data := BSC_APPS.GET_MESSAGE( 'BSC_KPI_ETE_MEASURE_GROUP_ERR');
4438:
4439: RETURN BSC_BIS_KPI_CRUD_PUB.c_measure_group_id_error;
4440:
4441:
4442: END get_measure_group_id;
4443:
4482: p_Commit IN VARCHAR2 := FND_API.G_FALSE
4483: ,p_Dim_Short_Name IN VARCHAR2
4484: ,p_Display_Name IN VARCHAR2
4485: ,p_Description IN VARCHAR2
4486: ,p_Dim_Objs_Record IN BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE
4487: ,p_Dim_Obj_Short_Names IN VARCHAR2
4488: ,p_Dim_Objects_Counter IN NUMBER
4489: ,p_Application_Id IN NUMBER
4490: ,p_hide IN VARCHAR2 := FND_API.G_FALSE
4536: ,p_dim_short_name => p_Dim_Short_Name
4537: ,p_display_name => p_Dim_Short_Name
4538: ,p_description => p_Dim_Short_Name
4539: ,p_dim_obj_short_names => p_Dim_Obj_Short_Names
4540: ,p_application_id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID -- BSC
4541: ,p_hide => p_hide
4542: ,x_return_status => x_Return_Status
4543: ,x_msg_count => x_Msg_Count
4544: ,x_msg_data => x_Msg_Data
4637: CLOSE c_Get_Prop_Dim;
4638: END IF;
4639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4640: IF (x_msg_data IS NOT NULL) THEN
4641: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Dimension ';
4642: ELSE
4643: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Dimension ';
4644: END IF;
4645: WHEN OTHERS THEN
4639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4640: IF (x_msg_data IS NOT NULL) THEN
4641: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Dimension ';
4642: ELSE
4643: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Dimension ';
4644: END IF;
4645: WHEN OTHERS THEN
4646: ROLLBACK TO KpiCrudCreateDimension;
4647: IF (c_Get_Prop_Dim%ISOPEN) THEN
4648: CLOSE c_Get_Prop_Dim;
4649: END IF;
4650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4651: IF (x_msg_data IS NOT NULL) THEN
4652: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Dimension ';
4653: ELSE
4654: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Dimension ';
4655: END IF;
4656: END Create_Dimension;
4650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4651: IF (x_msg_data IS NOT NULL) THEN
4652: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Dimension ';
4653: ELSE
4654: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Dimension ';
4655: END IF;
4656: END Create_Dimension;
4657:
4658:
4724: -- Create Compare TO and Change Region Items
4725: Create_Addl_Ak_Region_Items(
4726: p_commit => p_Commit
4727: , p_Region_Code => l_Region_Code
4728: , p_Region_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4729: , p_Display_Sequence => l_Max_Seq_Number
4730: , p_Display_Format => Get_Format_Mask(p_Dataset_Format_Id)
4731: , p_Format_Id => p_Dataset_Format_Id
4732: , p_Measure_Short_Name => p_Measure_Short_Name
4772: ( X_ROWID => l_Rowid
4773: ,X_FUNCTION_ID => l_Fid
4774: ,X_WEB_HOST_NAME => ''
4775: ,X_WEB_AGENT_NAME => ''
4776: ,X_WEB_HTML_CALL => BSC_BIS_KPI_CRUD_PUB.c_bisreportpg
4777: ,X_WEB_ENCRYPT_PARAMETERS => 'N'
4778: ,X_WEB_SECURED => 'N'
4779: ,X_WEB_ICON => ''
4780: ,X_OBJECT_ID => NULL
4820: WHEN NO_DATA_FOUND THEN
4821: ROLLBACK TO CreateAkMetadata;
4822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4823: IF (x_msg_data IS NOT NULL) THEN
4824: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Ak_Metadata ';
4825: ELSE
4826: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Ak_Metadata ';
4827: END IF;
4828: WHEN OTHERS THEN
4822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4823: IF (x_msg_data IS NOT NULL) THEN
4824: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Ak_Metadata ';
4825: ELSE
4826: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Ak_Metadata ';
4827: END IF;
4828: WHEN OTHERS THEN
4829: ROLLBACK TO CreateAkMetadata;
4830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4828: WHEN OTHERS THEN
4829: ROLLBACK TO CreateAkMetadata;
4830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4831: IF (x_msg_data IS NOT NULL) THEN
4832: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Ak_Metadata ';
4833: ELSE
4834: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Ak_Metadata ';
4835: END IF;
4836:
4830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4831: IF (x_msg_data IS NOT NULL) THEN
4832: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Ak_Metadata ';
4833: ELSE
4834: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Ak_Metadata ';
4835: END IF;
4836:
4837: END Create_Ak_Metadata;
4838:
5023:
5024:
5025: IF (l_Is_From_Report_Designer = FALSE) THEN
5026: -- Get the Dimenension Object Info from the Parameter Portler Region
5027: BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code(
5028: p_Param_Portlet_Region_Code => p_Param_Portlet_Region_Code
5029: , x_Non_Time_Dimension_Groups => x_Non_Time_Dimension_Groups
5030: , x_Non_Time_Dimension_Objects => x_Non_Time_Dimension_Objects
5031: , x_Non_Time_Dim_Obj_Short_Names => x_Non_Time_Dim_Obj_Short_Names
5041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5042: END IF;
5043: ELSE
5044: IF (p_Dim_Obj_Short_Names IS NOT NULL) THEN
5045: BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_ParamPortlet(
5046: p_Dimension_Info => p_Dim_Obj_Short_Names
5047: ,x_non_time_dimension_groups => x_Non_Time_Dimension_Groups
5048: ,x_non_time_dimension_objects => x_Non_Time_Dimension_Objects
5049: ,x_non_time_dim_obj_short_names => x_Non_Time_Dim_Obj_Short_Names
5078: -- need to verify why this will be used in future.
5079: l_User_Portlet_Name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(p_Kpi_Portlet_Function_Name);
5080:
5081: IF (l_Is_From_Report_Designer = TRUE) THEN
5082: l_Measure_Group_Id := BSC_BIS_KPI_CRUD_PUB.C_DEFAULT_MEASURE_GROUP_ID;
5083: ELSE
5084: -- Get the Source Group ID to be populated to BSC_DB_MEASURE_COLS_VL
5085: l_Measure_Group_Id := Get_Measure_Group_Id(l_Key_Short_Name, x_Return_Status, x_Msg_Data);
5086: IF (x_Msg_Data IS NOT NULL) THEN
5105: l_Tab_Id := Get_Tab_Id(l_Key_Short_Name);
5106:
5107: --DBMS_OUTPUT.PUT_LINE('STAGE 4 - ' ||l_Tab_Id);
5108:
5109: IF (l_Tab_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY AND p_Obj_Type = BSC_BIS_KPI_CRUD_PUB.C_MULTI_BAR_INDICATOR) THEN
5110: BSC_PMF_UI_WRAPPER.Create_Tab(
5111: p_Commit => p_Commit
5112: ,p_Responsibility_Id => p_Responsibility_Id
5113: ,p_Parent_Tab_Id => NULL
5133:
5134: l_Kpi_Group_Id := Get_Group_Id(l_Key_Short_Name);
5135: --DBMS_OUTPUT.PUT_LINE('STAGE 5 - ' ||l_Kpi_Group_Id);
5136:
5137: IF (l_Kpi_Group_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
5138: -- Create a new KPI Group, aka Objective Group
5139: BSC_PMF_UI_WRAPPER.Create_Kpi_Group(
5140: p_Commit => p_Commit
5141: ,p_Tab_Id => NULL
5190: -- added condition for AGRD
5191: IF (l_Is_From_Report_Designer = FALSE) THEN
5192: IF (is_XTD_Enabled(p_Param_Portlet_Region_Code) = FND_API.G_TRUE) THEN
5193:
5194: BSC_BIS_KPI_CRUD_PUB.Enable_Kpi_Calculation (
5195: p_Commit => p_Commit
5196: , p_Kpi_Id => l_Kpi_Id
5197: , p_Calculation_Id => BSC_BIS_KPI_CRUD_PUB.C_CALC_XTD
5198: , p_Default_Checked => BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_KPI
5193:
5194: BSC_BIS_KPI_CRUD_PUB.Enable_Kpi_Calculation (
5195: p_Commit => p_Commit
5196: , p_Kpi_Id => l_Kpi_Id
5197: , p_Calculation_Id => BSC_BIS_KPI_CRUD_PUB.C_CALC_XTD
5198: , p_Default_Checked => BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_KPI
5199: , x_Return_Status => x_Return_Status
5200: , x_Msg_Count => x_Msg_Count
5201: , x_Msg_Data => x_Msg_Data
5194: BSC_BIS_KPI_CRUD_PUB.Enable_Kpi_Calculation (
5195: p_Commit => p_Commit
5196: , p_Kpi_Id => l_Kpi_Id
5197: , p_Calculation_Id => BSC_BIS_KPI_CRUD_PUB.C_CALC_XTD
5198: , p_Default_Checked => BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_KPI
5199: , x_Return_Status => x_Return_Status
5200: , x_Msg_Count => x_Msg_Count
5201: , x_Msg_Data => x_Msg_Data
5202: );
5215: --DBMS_OUTPUT.PUT_LINE('l_Tab_Id - ' ||l_Tab_Id);
5216:
5217:
5218:
5219: IF(l_Tab_Id <> BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
5220:
5221: --DBMS_OUTPUT.PUT_LINE('INSIDE l_Kpi_Group_Id - ' ||l_Kpi_Group_Id);
5222: IF(l_obj_type = BSC_BIS_KPI_CRUD_PUB.C_SIMULATION_INDICATOR) THEN
5223:
5218:
5219: IF(l_Tab_Id <> BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
5220:
5221: --DBMS_OUTPUT.PUT_LINE('INSIDE l_Kpi_Group_Id - ' ||l_Kpi_Group_Id);
5222: IF(l_obj_type = BSC_BIS_KPI_CRUD_PUB.C_SIMULATION_INDICATOR) THEN
5223:
5224: BSC_PMF_UI_WRAPPER.Assign_KPI(
5225: p_Commit => FND_API.G_FALSE
5226: ,p_kpi_id => l_kpi_id
5250: END IF;
5251: END IF;
5252:
5253:
5254: IF(p_Obj_Type = BSC_BIS_KPI_CRUD_PUB.C_SIMULATION_INDICATOR AND p_Obj_Tab_Id IS NOT NULL) THEN
5255:
5256: --Check if the indicator is attahced to the scorecard or not
5257: --if not then attach it
5258: --
5293: FROM BIS_INDICATORS
5294: WHERE SHORT_NAME = p_measure_short_name;
5295:
5296: l_Region_Code := BIS_PMV_UTIL.GetReportRegion(p_Region_Function_Name);
5297: l_attribute_code := BSC_BIS_KPI_CRUD_PUB.Get_Attribute_Code_For_Measure(l_Region_Code,p_Measure_Short_Name);
5298: IF (l_Count <> 0 AND l_Is_From_Report_Designer = TRUE) THEN
5299: l_Returned_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_AGKpi(p_Measure_Short_Name);
5300:
5301:
5295:
5296: l_Region_Code := BIS_PMV_UTIL.GetReportRegion(p_Region_Function_Name);
5297: l_attribute_code := BSC_BIS_KPI_CRUD_PUB.Get_Attribute_Code_For_Measure(l_Region_Code,p_Measure_Short_Name);
5298: IF (l_Count <> 0 AND l_Is_From_Report_Designer = TRUE) THEN
5299: l_Returned_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_AGKpi(p_Measure_Short_Name);
5300:
5301:
5302:
5303: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name);
5299: l_Returned_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_AGKpi(p_Measure_Short_Name);
5300:
5301:
5302:
5303: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name);
5304:
5305: -- the Update_Measure API expects Measure_Id1 to be present as a non-Null parameter.
5306: SELECT
5307: m.measure_id
5319: --DBMS_OUTPUT.PUT_LINE('STAGE 7D - ' || BSC_BIS_MEASURE_PUB.c_BSC);
5320: --DBMS_OUTPUT.PUT_LINE('STAGE 7E - ' || l_Bsc_Measure_Id);
5321: --DBMS_OUTPUT.PUT_LINE('STAGE 7F - ' || p_Region_Function_Name || '.' || p_Measure_Short_Name);
5322:
5323: l_Actual_Data_Source := BSC_BIS_KPI_CRUD_PUB.Get_Actual_Source_Data(p_Measure_Short_Name);
5324: l_Actual_Data_Source_Type := BSC_BIS_KPI_CRUD_PUB.Get_Actual_Source_Data_Type(p_Measure_Short_Name);
5325: l_Function_Name := BSC_BIS_KPI_CRUD_PUB.Get_Measure_Function_Name(p_Measure_Short_Name);
5326:
5327: IF (l_Actual_Data_Source IS NULL) THEN
5320: --DBMS_OUTPUT.PUT_LINE('STAGE 7E - ' || l_Bsc_Measure_Id);
5321: --DBMS_OUTPUT.PUT_LINE('STAGE 7F - ' || p_Region_Function_Name || '.' || p_Measure_Short_Name);
5322:
5323: l_Actual_Data_Source := BSC_BIS_KPI_CRUD_PUB.Get_Actual_Source_Data(p_Measure_Short_Name);
5324: l_Actual_Data_Source_Type := BSC_BIS_KPI_CRUD_PUB.Get_Actual_Source_Data_Type(p_Measure_Short_Name);
5325: l_Function_Name := BSC_BIS_KPI_CRUD_PUB.Get_Measure_Function_Name(p_Measure_Short_Name);
5326:
5327: IF (l_Actual_Data_Source IS NULL) THEN
5328: l_Actual_Data_Source := l_Region_Code || '.' || l_attribute_code;
5321: --DBMS_OUTPUT.PUT_LINE('STAGE 7F - ' || p_Region_Function_Name || '.' || p_Measure_Short_Name);
5322:
5323: l_Actual_Data_Source := BSC_BIS_KPI_CRUD_PUB.Get_Actual_Source_Data(p_Measure_Short_Name);
5324: l_Actual_Data_Source_Type := BSC_BIS_KPI_CRUD_PUB.Get_Actual_Source_Data_Type(p_Measure_Short_Name);
5325: l_Function_Name := BSC_BIS_KPI_CRUD_PUB.Get_Measure_Function_Name(p_Measure_Short_Name);
5326:
5327: IF (l_Actual_Data_Source IS NULL) THEN
5328: l_Actual_Data_Source := l_Region_Code || '.' || l_attribute_code;
5329: END IF;
5343: l_Comparison_Source := NULL;
5344: END IF;
5345:
5346: ELSE
5347: l_Comparison_Source := BSC_BIS_KPI_CRUD_PUB.Get_Comparison_Source(p_Measure_Short_Name);
5348: END IF;
5349:
5350: -- Passed AK type and AK source (pl/sql), since they were getting updated to null
5351: -- modified condition for Bug#4599432
5380: ,p_Measure_Max_Bud_Value => NULL
5381: ,p_Measure_App_Id => p_Measure_App_Id
5382: ,p_Measure_Col => NULL
5383: ,p_Measure_Group_Id => NULL
5384: ,p_Measure_Projection_Id => BSC_BIS_KPI_CRUD_PUB.C_NO_PROJECTION
5385: ,p_Measure_Type => p_Measure_Type
5386: ,p_Measure_Apply_Rollup => NULL
5387: ,p_Measure_Function_Name => l_Function_Name
5388: ,p_Measure_Enable_Link => 'Y'
5415: FROM BSC_KPI_ANALYSIS_MEASURES_B B
5416: WHERE B.DATASET_ID = l_Dataset_Id
5417: AND B.INDICATOR = l_Kpi_id;
5418:
5419: IF((l_Returned_Kpi_Id =BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY AND l_Measure_Source =BSC_BIS_MEASURE_PUB.c_BSC) OR l_Count1 = 0) THEN
5420: l_Anal_Opt_Rec.Bsc_Kpi_Id := l_Kpi_Id;
5421: l_Anal_Opt_Rec.Bsc_Dataset_Id := l_Dataset_Id;
5422: l_Anal_Opt_Rec.Bsc_Dataset_Default_Value := 1;
5423: l_Anal_Opt_Rec.Bsc_Measure_Long_Name := p_Measure_Name;
5443:
5444:
5445: ELSE
5446: l_Anal_Opt_Rec.Bsc_Kpi_Id := l_Kpi_Id;
5447: l_Anal_Opt_Rec.Bsc_Dataset_Series_Id := BSC_BIS_KPI_CRUD_PUB.Get_Data_Series_Id(l_Kpi_Id, l_Dataset_Id);
5448: l_Anal_Opt_Rec.Bsc_Option_Group0 := 0;
5449: l_Anal_Opt_Rec.Bsc_Option_Group1 := 0;
5450: l_Anal_Opt_Rec.Bsc_Option_Group2 := 0;
5451: l_Anal_Opt_Rec.Bsc_Dataset_Default_Value := 1;
5469:
5470: ELSE
5471: IF ((p_Measure_Short_Name IS NOT NULL) OR (l_Is_From_Report_Designer = FALSE)) THEN -- check if the report is null
5472: -- Changed from l_Measure_Short_Name to p_Measure_Short_Name
5473: BSC_BIS_KPI_CRUD_PUB.Create_Measure(
5474: p_Commit => p_Commit
5475: ,x_Dataset_Id => l_Dataset_Id
5476: ,p_Kpi_Id => l_Kpi_Id
5477: ,p_Dataset_Source => l_Dataset_Source
5509:
5510: --DBMS_OUTPUT.PUT_LINE('STAGE 8');
5511:
5512: -- Update Disabled Calcuations -- Pending Approval
5513: BSC_BIS_KPI_CRUD_PUB.Apply_Disabled_Calculations (
5514: p_Commit => p_Commit
5515: , p_Dataset_Id => l_Dataset_Id
5516: , x_Return_Status => x_Return_Status
5517: , x_Msg_Count => x_Msg_Count
5596:
5597:
5598: ELSE
5599:
5600: BSC_BIS_KPI_CRUD_PUB.Associate_KPI_To_AO(
5601: p_Commit => p_Commit
5602: , p_Indicator => l_Kpi_Id
5603: , p_Dataset_Id => l_Dataset_Id
5604: , p_Measure_Name => p_Measure_Name
5620: --DBMS_OUTPUT.PUT_LINE('STAGE 11');
5621:
5622: IF (l_Is_From_Report_Designer) THEN
5623: l_Dimension_Short_Name := l_Key_Short_Name;
5624: l_Is_XTD_Enabled := BSC_BIS_KPI_CRUD_PUB.is_XTD_Enabled(BIS_PMV_UTIL.GetReportRegion(p_Region_Function_Name));
5625: ELSE
5626: l_Dimension_Short_Name := p_Param_Portlet_Region_Code;
5627: l_Is_XTD_Enabled := BSC_BIS_KPI_CRUD_PUB.is_XTD_Enabled(p_Param_Portlet_Region_Code);
5628: END IF;
5623: l_Dimension_Short_Name := l_Key_Short_Name;
5624: l_Is_XTD_Enabled := BSC_BIS_KPI_CRUD_PUB.is_XTD_Enabled(BIS_PMV_UTIL.GetReportRegion(p_Region_Function_Name));
5625: ELSE
5626: l_Dimension_Short_Name := p_Param_Portlet_Region_Code;
5627: l_Is_XTD_Enabled := BSC_BIS_KPI_CRUD_PUB.is_XTD_Enabled(p_Param_Portlet_Region_Code);
5628: END IF;
5629: l_Does_Dim_Group_Exist := Does_Dim_Grp_Exist(l_Dimension_Short_Name);
5630:
5631:
5636:
5637: -- Create a Dimension Group, if it does not exist for
5638: -- Parameter Portlet. It updates the Dimension Object Properties as well.
5639:
5640: BSC_BIS_KPI_CRUD_PUB.Create_Dimension(
5641: p_Commit => p_Commit
5642: ,p_Dim_Short_Name => l_Dimension_Short_Name
5643: ,p_Display_Name => l_Dimension_Short_Name
5644: ,p_Description => l_Dimension_Short_Name
5644: ,p_Description => l_Dimension_Short_Name
5645: ,p_Dim_Objs_Record => x_Non_Time_Dimension_Objects
5646: ,p_Dim_Obj_Short_Names => x_Non_Time_Dim_Obj_Short_Names
5647: ,p_Dim_Objects_Counter => NVL(x_Non_Time_Counter, 0)
5648: ,p_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
5649: ,p_hide => FND_API.G_TRUE
5650: ,x_Return_Status => x_Return_Status
5651: ,x_Msg_Count => x_Msg_Count
5652: ,x_Msg_Data => x_Msg_Data
5659:
5660: --DBMS_OUTPUT.PUT_LINE('STAGE 12');
5661:
5662: -- Assign the Time dimension peroidicities to the KPI (Objective)
5663: BSC_BIS_KPI_CRUD_PUB.Assign_KPI_Periodicities(
5664: p_Commit => p_Commit
5665: ,p_Kpi_Id => l_Kpi_Id
5666: ,p_Time_Dim_Obj_Sns => x_Time_Dim_Obj_Short_Names
5667: ,p_Dft_Dim_Obj_Sn => NULL
5731: --DBMS_OUTPUT.PUT_LINE('STAGE 11A');
5732:
5733: -- code to recreate Periodicities goes here.
5734:
5735: BSC_BIS_KPI_CRUD_PUB.Assign_KPI_Periodicities(
5736: p_Commit => p_Commit
5737: ,p_Kpi_Id => l_Kpi_Id
5738: ,p_Time_Dim_Obj_Sns => x_Time_Dim_Obj_Short_Names
5739: ,p_Dft_Dim_Obj_Sn => NULL
5787:
5788: ROLLBACK TO CreateBscBisMetadata;
5789: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
5790: IF (x_msg_data IS NOT NULL) THEN
5791: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Bsc_Bis_Metadata ';
5792: ELSE
5793: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Bsc_Bis_Metadata ';
5794: END IF;
5795: WHEN OTHERS THEN
5789: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
5790: IF (x_msg_data IS NOT NULL) THEN
5791: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Bsc_Bis_Metadata ';
5792: ELSE
5793: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Bsc_Bis_Metadata ';
5794: END IF;
5795: WHEN OTHERS THEN
5796:
5797: ROLLBACK TO CreateBscBisMetadata;
5796:
5797: ROLLBACK TO CreateBscBisMetadata;
5798: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
5799: IF (x_msg_data IS NOT NULL) THEN
5800: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Bsc_Bis_Metadata ';
5801: ELSE
5802: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Bsc_Bis_Metadata ';
5803: END IF;
5804: END Create_Bsc_Bis_Metadata;
5798: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
5799: IF (x_msg_data IS NOT NULL) THEN
5800: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Bsc_Bis_Metadata ';
5801: ELSE
5802: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Bsc_Bis_Metadata ';
5803: END IF;
5804: END Create_Bsc_Bis_Metadata;
5805:
5806:
5820:
5821: -- Initialize Procedure Variables.
5822: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
5823:
5824: BSC_BIS_KPI_CRUD_PUB.Delete_Misc_Region_Items(
5825: p_commit => p_commit
5826: , p_Region_Code => p_Region_Code
5827: , p_Application_Id => p_Region_Code_Application_Id
5828: , x_return_status => x_return_status
5846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5847: END IF;
5848:
5849: FND_FORM_FUNCTIONS_PKG.DELETE_ROW (
5850: X_FUNCTION_ID => BSC_BIS_KPI_CRUD_PUB.Get_Function_Id_By_Name(p_Region_Code)
5851: );
5852:
5853: EXCEPTION
5854: WHEN FND_API.G_EXC_ERROR THEN
5874: WHEN NO_DATA_FOUND THEN
5875: ROLLBACK TO DeleteAKMetadata;
5876: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
5877: IF (x_msg_data IS NOT NULL) THEN
5878: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata ';
5879: ELSE
5880: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata ';
5881: END IF;
5882: WHEN OTHERS THEN
5876: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
5877: IF (x_msg_data IS NOT NULL) THEN
5878: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata ';
5879: ELSE
5880: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata ';
5881: END IF;
5882: WHEN OTHERS THEN
5883: ROLLBACK TO DeleteAKMetadata;
5884: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
5882: WHEN OTHERS THEN
5883: ROLLBACK TO DeleteAKMetadata;
5884: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
5885: IF (x_msg_data IS NOT NULL) THEN
5886: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata ';
5887: ELSE
5888: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata ';
5889: END IF;
5890:
5884: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
5885: IF (x_msg_data IS NOT NULL) THEN
5886: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata ';
5887: ELSE
5888: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata ';
5889: END IF;
5890:
5891: END Delete_AK_Metadata;
5892:
5929:
5930: -- Delete all AK Data Starting from p_Deleted_AO_Index (Analysis Option Index + 1)
5931: FOR cRefresh IN c_RefreshAK LOOP
5932: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(p_Kpi_Id, (cRefresh.ANALYSIS_OPTION0)+1);
5933: BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata(
5934: p_Commit => p_Commit
5935: , p_Region_Code => l_Region_Code
5936: , p_Region_Code_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
5937: , x_Return_Status => x_Return_Status
5932: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(p_Kpi_Id, (cRefresh.ANALYSIS_OPTION0)+1);
5933: BSC_BIS_KPI_CRUD_PUB.Delete_AK_Metadata(
5934: p_Commit => p_Commit
5935: , p_Region_Code => l_Region_Code
5936: , p_Region_Code_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
5937: , x_Return_Status => x_Return_Status
5938: , x_Msg_Count => x_Msg_Count
5939: , x_Msg_Data => x_Msg_Data
5940: );
5945:
5946:
5947: -- Recreate AK Metadata with new Analysis Option combination
5948: FOR cRefresh IN c_RefreshAK LOOP
5949: BSC_BIS_KPI_CRUD_PUB.Create_Ak_Metadata(
5950: p_Commit => p_Commit
5951: , p_Create_Region_Per_AO => FND_API.G_TRUE
5952: , p_Kpi_Id => p_Kpi_Id
5953: , p_Analysis_Option_Id => cRefresh.ANALYSIS_OPTION0
5956: , p_Measure_Name => cRefresh.NAME
5957: , p_Measure_Description => cRefresh.HELP
5958: , p_User_Portlet_Name => cRefresh.NAME
5959: , p_Dataset_Format_Id => cRefresh.FORMAT_ID
5960: , p_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
5961: , p_Disable_View_By => 'N'
5962: , p_Param_Portlet_Region_Code => p_Param_Portlet_Region_Code
5963: , x_Return_Status => x_Return_Status
5964: , x_Msg_Count => x_Msg_Count
5993: WHEN NO_DATA_FOUND THEN
5994: ROLLBACK TO RefereshAKMetadata;
5995: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
5996: IF (x_msg_data IS NOT NULL) THEN
5997: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Referesh_AK_Metadata ';
5998: ELSE
5999: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Referesh_AK_Metadata ';
6000: END IF;
6001: WHEN OTHERS THEN
5995: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
5996: IF (x_msg_data IS NOT NULL) THEN
5997: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Referesh_AK_Metadata ';
5998: ELSE
5999: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Referesh_AK_Metadata ';
6000: END IF;
6001: WHEN OTHERS THEN
6002: ROLLBACK TO RefereshAKMetadata;
6003: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6001: WHEN OTHERS THEN
6002: ROLLBACK TO RefereshAKMetadata;
6003: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6004: IF (x_msg_data IS NOT NULL) THEN
6005: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Referesh_AK_Metadata ';
6006: ELSE
6007: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Referesh_AK_Metadata ';
6008: END IF;
6009:
6003: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6004: IF (x_msg_data IS NOT NULL) THEN
6005: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Referesh_AK_Metadata ';
6006: ELSE
6007: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Referesh_AK_Metadata ';
6008: END IF;
6009:
6010: END Referesh_AK_Metadata;
6011:
6028: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
6029:
6030: -- Call type Constructor.
6031: l_Disable_Calc_List := BSC_NUM_LIST(
6032: BSC_BIS_KPI_CRUD_PUB.C_CALC_TC
6033: , BSC_BIS_KPI_CRUD_PUB.C_CALC_GROWTH
6034: , BSC_BIS_KPI_CRUD_PUB.C_CALC_QTD
6035: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YDG
6036: , BSC_BIS_KPI_CRUD_PUB.C_CALC_AVG
6029:
6030: -- Call type Constructor.
6031: l_Disable_Calc_List := BSC_NUM_LIST(
6032: BSC_BIS_KPI_CRUD_PUB.C_CALC_TC
6033: , BSC_BIS_KPI_CRUD_PUB.C_CALC_GROWTH
6034: , BSC_BIS_KPI_CRUD_PUB.C_CALC_QTD
6035: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YDG
6036: , BSC_BIS_KPI_CRUD_PUB.C_CALC_AVG
6037: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YYG
6030: -- Call type Constructor.
6031: l_Disable_Calc_List := BSC_NUM_LIST(
6032: BSC_BIS_KPI_CRUD_PUB.C_CALC_TC
6033: , BSC_BIS_KPI_CRUD_PUB.C_CALC_GROWTH
6034: , BSC_BIS_KPI_CRUD_PUB.C_CALC_QTD
6035: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YDG
6036: , BSC_BIS_KPI_CRUD_PUB.C_CALC_AVG
6037: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YYG
6038: , BSC_BIS_KPI_CRUD_PUB.C_CALC_DV
6031: l_Disable_Calc_List := BSC_NUM_LIST(
6032: BSC_BIS_KPI_CRUD_PUB.C_CALC_TC
6033: , BSC_BIS_KPI_CRUD_PUB.C_CALC_GROWTH
6034: , BSC_BIS_KPI_CRUD_PUB.C_CALC_QTD
6035: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YDG
6036: , BSC_BIS_KPI_CRUD_PUB.C_CALC_AVG
6037: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YYG
6038: , BSC_BIS_KPI_CRUD_PUB.C_CALC_DV
6039: );
6032: BSC_BIS_KPI_CRUD_PUB.C_CALC_TC
6033: , BSC_BIS_KPI_CRUD_PUB.C_CALC_GROWTH
6034: , BSC_BIS_KPI_CRUD_PUB.C_CALC_QTD
6035: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YDG
6036: , BSC_BIS_KPI_CRUD_PUB.C_CALC_AVG
6037: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YYG
6038: , BSC_BIS_KPI_CRUD_PUB.C_CALC_DV
6039: );
6040:
6033: , BSC_BIS_KPI_CRUD_PUB.C_CALC_GROWTH
6034: , BSC_BIS_KPI_CRUD_PUB.C_CALC_QTD
6035: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YDG
6036: , BSC_BIS_KPI_CRUD_PUB.C_CALC_AVG
6037: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YYG
6038: , BSC_BIS_KPI_CRUD_PUB.C_CALC_DV
6039: );
6040:
6041: -- Apply the disabled Calculations.
6034: , BSC_BIS_KPI_CRUD_PUB.C_CALC_QTD
6035: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YDG
6036: , BSC_BIS_KPI_CRUD_PUB.C_CALC_AVG
6037: , BSC_BIS_KPI_CRUD_PUB.C_CALC_YYG
6038: , BSC_BIS_KPI_CRUD_PUB.C_CALC_DV
6039: );
6040:
6041: -- Apply the disabled Calculations.
6042: BSC_BIS_MEASURE_PUB.Apply_Dataset_Calc(
6075: WHEN NO_DATA_FOUND THEN
6076: ROLLBACK TO ApplyDisableCalculations;
6077: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6078: IF (x_msg_data IS NOT NULL) THEN
6079: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Apply_Disable_Calculations ';
6080: ELSE
6081: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Apply_Disable_Calculations ';
6082: END IF;
6083: WHEN OTHERS THEN
6077: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6078: IF (x_msg_data IS NOT NULL) THEN
6079: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Apply_Disable_Calculations ';
6080: ELSE
6081: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Apply_Disable_Calculations ';
6082: END IF;
6083: WHEN OTHERS THEN
6084: ROLLBACK TO ApplyDisableCalculations;
6085: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6083: WHEN OTHERS THEN
6084: ROLLBACK TO ApplyDisableCalculations;
6085: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6086: IF (x_msg_data IS NOT NULL) THEN
6087: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Apply_Disable_Calculations ';
6088: ELSE
6089: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Apply_Disable_Calculations ';
6090: END IF;
6091: END Apply_Disabled_Calculations;
6085: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6086: IF (x_msg_data IS NOT NULL) THEN
6087: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Apply_Disable_Calculations ';
6088: ELSE
6089: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Apply_Disable_Calculations ';
6090: END IF;
6091: END Apply_Disabled_Calculations;
6092:
6093:
6112: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
6113:
6114: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := p_Kpi_Id;
6115: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id := p_Calculation_Id;
6116: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U0;
6117: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U1;
6118: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := p_Default_Checked;
6119:
6120: -- Call the private API to update BSC_KPI_CALCULATIONS.DEFAULT_VALUE, USER_LEVEL0, USER_LEVEL1
6113:
6114: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := p_Kpi_Id;
6115: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id := p_Calculation_Id;
6116: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U0;
6117: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U1;
6118: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := p_Default_Checked;
6119:
6120: -- Call the private API to update BSC_KPI_CALCULATIONS.DEFAULT_VALUE, USER_LEVEL0, USER_LEVEL1
6121: BSC_KPI_PVT.Update_Kpi_Calculations(
6153: WHEN NO_DATA_FOUND THEN
6154: ROLLBACK TO EnableKpiCalculation;
6155: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6156: IF (x_msg_data IS NOT NULL) THEN
6157: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Enable_Kpi_Calculation ';
6158: ELSE
6159: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Enable_Kpi_Calculation ';
6160: END IF;
6161: WHEN OTHERS THEN
6155: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6156: IF (x_msg_data IS NOT NULL) THEN
6157: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Enable_Kpi_Calculation ';
6158: ELSE
6159: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Enable_Kpi_Calculation ';
6160: END IF;
6161: WHEN OTHERS THEN
6162: ROLLBACK TO EnableKpiCalculation;
6163: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6161: WHEN OTHERS THEN
6162: ROLLBACK TO EnableKpiCalculation;
6163: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6164: IF (x_msg_data IS NOT NULL) THEN
6165: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Enable_Kpi_Calculation ';
6166: ELSE
6167: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Enable_Kpi_Calculation ';
6168: END IF;
6169: END Enable_Kpi_Calculation;
6163: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6164: IF (x_msg_data IS NOT NULL) THEN
6165: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Enable_Kpi_Calculation ';
6166: ELSE
6167: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Enable_Kpi_Calculation ';
6168: END IF;
6169: END Enable_Kpi_Calculation;
6170:
6171:
6190: BEGIN
6191: FND_MSG_PUB.Initialize;
6192: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
6193:
6194: BSC_BIS_KPI_CRUD_PUB.Get_Dim_Obj_By_Dimension (
6195: p_Dim_Short_Name => p_Dim_Short_Name
6196: , x_Time_Dim_Obj_Short_Names => x_Time_Dim_Obj_Short_Names
6197: , x_Time_Dim_Obj_Counter => x_Time_Dim_Obj_Counter
6198: , x_Non_Time_Dim_Obj_Short_Names => l_Dummy_Non_Time_Dims
6218: END IF;
6219: WHEN OTHERS THEN
6220: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6221: IF (x_msg_data IS NOT NULL) THEN
6222: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Time_Dim_Obj_By_Dim ';
6223: ELSE
6224: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Time_Dim_Obj_By_Dim ';
6225: END IF;
6226: END Get_Time_Dim_Obj_By_Dim;
6220: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6221: IF (x_msg_data IS NOT NULL) THEN
6222: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Time_Dim_Obj_By_Dim ';
6223: ELSE
6224: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Time_Dim_Obj_By_Dim ';
6225: END IF;
6226: END Get_Time_Dim_Obj_By_Dim;
6227:
6228:
6246:
6247: FND_MSG_PUB.Initialize;
6248: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
6249:
6250: BSC_BIS_KPI_CRUD_PUB.Get_Dim_Obj_By_Dimension (
6251: p_Dim_Short_Name => p_Dim_Short_Name
6252: , x_Time_Dim_Obj_Short_Names => l_Dummy_Time_Dims
6253: , x_Time_Dim_Obj_Counter => l_Dummy_Time_Counter
6254: , x_Non_Time_Dim_Obj_Short_Names => x_Non_Time_Dim_Obj_Short_Names
6274: END IF;
6275: WHEN OTHERS THEN
6276: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6277: IF (x_msg_data IS NOT NULL) THEN
6278: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Non_Time_Dim_Obj_By_Dim ';
6279: ELSE
6280: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Non_Time_Dim_Obj_By_Dim ';
6281: END IF;
6282: END Get_Non_Time_Dim_Obj_By_Dim;
6276: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6277: IF (x_msg_data IS NOT NULL) THEN
6278: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Non_Time_Dim_Obj_By_Dim ';
6279: ELSE
6280: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Non_Time_Dim_Obj_By_Dim ';
6281: END IF;
6282: END Get_Non_Time_Dim_Obj_By_Dim;
6283:
6284:
6326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6327: END IF;
6328:
6329: FOR c_DSN IN c_Dim_Obj_Short_Name LOOP
6330: IF(BSC_BIS_KPI_CRUD_PUB.Is_Time_Dim_Obj(c_DSN.SHORT_NAME) = FND_API.G_TRUE) THEN
6331: IF(x_Time_Dim_Obj_Counter = 0) THEN
6332: x_Time_Dim_Obj_Short_Names := c_DSN.SHORT_NAME;
6333: ELSE
6334: x_Time_Dim_Obj_Short_Names := x_Time_Dim_Obj_Short_Names || ',' || c_DSN.SHORT_NAME;
6357: END IF;
6358: WHEN OTHERS THEN
6359: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6360: IF (x_msg_data IS NOT NULL) THEN
6361: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Dim_Obj_By_Dimension ';
6362: ELSE
6363: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Dim_Obj_By_Dimension ';
6364: END IF;
6365: END Get_Dim_Obj_By_Dimension;
6359: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
6360: IF (x_msg_data IS NOT NULL) THEN
6361: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Dim_Obj_By_Dimension ';
6362: ELSE
6363: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Dim_Obj_By_Dimension ';
6364: END IF;
6365: END Get_Dim_Obj_By_Dimension;
6366:
6367:
6384: BSC_SYS_DIM_LEVELS_BY_GROUP DD,
6385: BSC_SYS_DIM_LEVELS_B DO
6386: WHERE DG.DIM_GROUP_ID = DD.DIM_GROUP_ID
6387: AND DD.DIM_LEVEL_ID = DO.DIM_LEVEL_ID
6388: AND ((DG.SHORT_NAME = BSC_BIS_KPI_CRUD_PUB.C_OLTP_TIME) OR (DG.SHORT_NAME = BSC_BIS_KPI_CRUD_PUB.C_EDW_TIME))
6389: AND DO.SHORT_NAME = p_Dim_Obj_Short_Name;
6390:
6391: RETURN l_Is_Time_Dim_Obj;
6392:
6411: BSC_SYS_DIM_LEVELS_BY_GROUP DD,
6412: BSC_SYS_DIM_LEVELS_B DO
6413: WHERE DG.DIM_GROUP_ID = DD.DIM_GROUP_ID
6414: AND DD.DIM_LEVEL_ID = DO.DIM_LEVEL_ID
6415: AND ((DG.SHORT_NAME = BSC_BIS_KPI_CRUD_PUB.C_OLTP_TIME) OR (DG.SHORT_NAME = BSC_BIS_KPI_CRUD_PUB.C_EDW_TIME))
6416: AND DO.SHORT_NAME = p_Dim_Obj_Short_Name;
6417:
6418: END Is_Time_Dim_Obj;
6419:
6425: , x_Is_Time_Dimension OUT NOCOPY VARCHAR2
6426: ) IS
6427: BEGIN
6428:
6429: IF((p_Dimension_Short_Name = BSC_BIS_KPI_CRUD_PUB.C_OLTP_TIME) OR
6430: (p_Dimension_Short_Name = BSC_BIS_KPI_CRUD_PUB.C_EDW_TIME)) THEN
6431: x_Is_Time_Dimension := FND_API.G_TRUE;
6432: ELSE
6433: x_Is_Time_Dimension := FND_API.G_FALSE;
6426: ) IS
6427: BEGIN
6428:
6429: IF((p_Dimension_Short_Name = BSC_BIS_KPI_CRUD_PUB.C_OLTP_TIME) OR
6430: (p_Dimension_Short_Name = BSC_BIS_KPI_CRUD_PUB.C_EDW_TIME)) THEN
6431: x_Is_Time_Dimension := FND_API.G_TRUE;
6432: ELSE
6433: x_Is_Time_Dimension := FND_API.G_FALSE;
6434: END IF;
6563: SELECT COUNT(1)
6564: INTO l_Count
6565: FROM AK_REGION_ITEMS
6566: WHERE REGION_CODE = p_Region_Code
6567: AND ATTRIBUTE_CODE = BSC_BIS_KPI_CRUD_PUB.C_AS_OF_DATE;
6568:
6569: IF (l_Count = 0) THEN
6570: RETURN FND_API.G_FALSE;
6571: ELSE
6586: IS
6587: BEGIN
6588:
6589: FOR i IN 1..p_Time_Dimension_Objects.COUNT LOOP
6590: IF (p_Time_Dimension_Objects(i) = BSC_BIS_KPI_CRUD_PUB.C_AS_OF_DATE) THEN
6591: RETURN FND_API.G_TRUE;
6592: END IF;
6593: END LOOP;
6594:
6622: SELECT (KV.INDICATOR || ' - ' || KV.NAME) XTDOBJECTIVE
6623: FROM BSC_KPIS_VL KV
6624: ,BSC_KPI_CALCULATIONS KC
6625: WHERE KC.INDICATOR = KV.INDICATOR
6626: AND KC.CALCULATION_ID = BSC_BIS_KPI_CRUD_PUB.C_CALC_XTD
6627: AND KC.USER_LEVEL0 = BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U0
6628: AND KC.USER_LEVEL1 = BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U1
6629: AND KV.SHORT_NAME IS NOT NULL
6630: ORDER BY KV.INDICATOR;
6623: FROM BSC_KPIS_VL KV
6624: ,BSC_KPI_CALCULATIONS KC
6625: WHERE KC.INDICATOR = KV.INDICATOR
6626: AND KC.CALCULATION_ID = BSC_BIS_KPI_CRUD_PUB.C_CALC_XTD
6627: AND KC.USER_LEVEL0 = BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U0
6628: AND KC.USER_LEVEL1 = BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U1
6629: AND KV.SHORT_NAME IS NOT NULL
6630: ORDER BY KV.INDICATOR;
6631:
6624: ,BSC_KPI_CALCULATIONS KC
6625: WHERE KC.INDICATOR = KV.INDICATOR
6626: AND KC.CALCULATION_ID = BSC_BIS_KPI_CRUD_PUB.C_CALC_XTD
6627: AND KC.USER_LEVEL0 = BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U0
6628: AND KC.USER_LEVEL1 = BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U1
6629: AND KV.SHORT_NAME IS NOT NULL
6630: ORDER BY KV.INDICATOR;
6631:
6632: BEGIN
6643: END IF;
6644: l_Count := l_Count + 1;
6645:
6646: -- We are restricting display to a maximum of 200 Objectives.
6647: IF (l_Count > BSC_BIS_KPI_CRUD_PUB.C_MAX_OBJECTIVES_DISPLAY) THEN
6648: EXIT;
6649: END IF;
6650: END LOOP;
6651:
6659:
6660:
6661: --
6662: -- Returns if the Dimension Object(level) has been excluded from Constant Class
6663: -- BSC_BIS_KPI_CRUD_PUB.G_EXCLUDE_DIMOBJ_CLASS
6664: --
6665: -- Returns "T" if Dimension Object is excluded, else returns "F"
6666: -- Example : PLAN_SNAPSHOT will return "T"
6667: --
6767: l_Trigger_Warning := FALSE;
6768:
6769: l_Msg_Count_Size := 0;
6770: l_Tmp_Msg_Count_Size := 0;
6771: l_Msg_Max_Count_Size := BSC_BIS_KPI_CRUD_PUB.C_MAX_MESSAGE_SIZE;
6772: l_Msg_Exceeds_Size := FALSE;
6773:
6774: FOR cReportList IN c_Report_List LOOP
6775: l_Report_Function_Name := cReportList.FUNCTION_NAME;
6998: , p_data => x_Msg_Data
6999: );
7000:
7001: IF (x_Msg_Data IS NOT NULL) THEN
7002: x_Msg_Data := x_Msg_Data; --||' -> BSC_BIS_KPI_CRUD_PUB.Validate_Kpi_Delete ';
7003: ELSE
7004: x_Msg_Data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Validate_Kpi_Delete ';
7005: END IF;
7006: x_Return_Status := FND_API.G_RET_STS_ERROR;
7000:
7001: IF (x_Msg_Data IS NOT NULL) THEN
7002: x_Msg_Data := x_Msg_Data; --||' -> BSC_BIS_KPI_CRUD_PUB.Validate_Kpi_Delete ';
7003: ELSE
7004: x_Msg_Data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Validate_Kpi_Delete ';
7005: END IF;
7006: x_Return_Status := FND_API.G_RET_STS_ERROR;
7007:
7008:
7049: , p_data => x_Msg_Data
7050: );
7051:
7052: IF (x_Msg_Data IS NOT NULL) THEN
7053: x_Msg_Data := x_Msg_Data||' -> BSC_BIS_KPI_CRUD_PUB.Populate_DBI_Calendar ';
7054: ELSE
7055: x_Msg_Data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Populate_DBI_Calendar ';
7056: END IF;
7057: x_Return_Status := FND_API.G_RET_STS_ERROR;
7051:
7052: IF (x_Msg_Data IS NOT NULL) THEN
7053: x_Msg_Data := x_Msg_Data||' -> BSC_BIS_KPI_CRUD_PUB.Populate_DBI_Calendar ';
7054: ELSE
7055: x_Msg_Data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Populate_DBI_Calendar ';
7056: END IF;
7057: x_Return_Status := FND_API.G_RET_STS_ERROR;
7058:
7059: END Populate_DBI_Calendar;
7077:
7078: l_Count := 0;
7079: x_Region_Codes := NULL;
7080:
7081: l_Kpi_Id := NVL(Get_Objective_By_Kpi(p_Short_Name), BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY);
7082:
7083: IF l_Kpi_Id <> BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY THEN
7084: FOR cRgn IN c_Regions LOOP
7085: IF l_Count = 0 THEN
7079: x_Region_Codes := NULL;
7080:
7081: l_Kpi_Id := NVL(Get_Objective_By_Kpi(p_Short_Name), BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY);
7082:
7083: IF l_Kpi_Id <> BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY THEN
7084: FOR cRgn IN c_Regions LOOP
7085: IF l_Count = 0 THEN
7086: x_Region_Codes := cRgn.SHORT_NAME;
7087: ELSE
7148: , p_data => x_Msg_Data
7149: );
7150:
7151: IF (x_Msg_Data IS NOT NULL) THEN
7152: x_Msg_Data := x_Msg_Data||' -> BSC_BIS_KPI_CRUD_PUB.Check_XTD_Summarization ';
7153: ELSE
7154: x_Msg_Data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Check_XTD_Summarization ';
7155: END IF;
7156: x_Return_Status := FND_API.G_RET_STS_ERROR;
7150:
7151: IF (x_Msg_Data IS NOT NULL) THEN
7152: x_Msg_Data := x_Msg_Data||' -> BSC_BIS_KPI_CRUD_PUB.Check_XTD_Summarization ';
7153: ELSE
7154: x_Msg_Data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Check_XTD_Summarization ';
7155: END IF;
7156: x_Return_Status := FND_API.G_RET_STS_ERROR;
7157:
7158: END Check_XTD_Summarization;
7212:
7213: BEGIN
7214:
7215: l_Format_Id := p_Format_Id;
7216: l_Display_Type := BSC_BIS_KPI_CRUD_PUB.C_FORMAT_POINTER; -- displays %age
7217:
7218: -- Check for standard format ids
7219: IF (p_Format_Id NOT IN (0, 1, 2, 5, 6, 7)) THEN
7220: l_Format_Id := 0;
7224: -- percentage, we then should return integer, else we must return
7225: -- percentage as the display type
7226:
7227: IF (l_Format_Id IN (0, 1, 2)) THEN
7228: l_Display_Type := BSC_BIS_KPI_CRUD_PUB.C_FORMAT_INTEGER;
7229: ELSE
7230: l_Display_Type := BSC_BIS_KPI_CRUD_PUB.C_FORMAT_POINTER;
7231: END IF;
7232:
7226:
7227: IF (l_Format_Id IN (0, 1, 2)) THEN
7228: l_Display_Type := BSC_BIS_KPI_CRUD_PUB.C_FORMAT_INTEGER;
7229: ELSE
7230: l_Display_Type := BSC_BIS_KPI_CRUD_PUB.C_FORMAT_POINTER;
7231: END IF;
7232:
7233:
7234: RETURN l_Display_Type;
7306: l_index := l_measure_names.first;
7307: WHILE l_index IS NOT NULL
7308: LOOP
7309: l_measure_shortname := l_measure_names(l_index);
7310: BSC_BIS_KPI_CRUD_PUB.Delete_Kpi_End_To_End(
7311: p_Commit => p_commit,
7312: p_Param_Portlet_Region_Code => 'DUMMY',
7313: p_Measure_Short_Name => l_measure_shortname,
7314: p_Page_Function_Name => NULL,
7770: END IF;
7771:
7772: IF ((l_Dimension_Grp(l_counter) <> C_TIME_COMPARISON)
7773: AND ( NOT((l_Dimension_Grp(l_counter) = C_AS_OF_DATE) OR (l_Dimension_Object(l_counter) = C_AS_OF_DATE)))) THEN
7774: IF ((l_Dimension_Grp(l_Counter) <> BSC_BIS_KPI_CRUD_PUB.C_OLTP_TIME) AND
7775: (l_Dimension_Grp(l_Counter) <> BSC_BIS_KPI_CRUD_PUB.C_EDW_TIME) AND
7776: (BSC_BIS_KPI_CRUD_PUB.Is_Dimension_Calendar(l_Dimension_Grp(l_Counter)) <> FND_API.G_TRUE)) THEN
7777:
7778: x_Non_Time_Dimension_Groups(x_Non_Time_Counter) := l_Dimension_Grp(l_Counter);
7771:
7772: IF ((l_Dimension_Grp(l_counter) <> C_TIME_COMPARISON)
7773: AND ( NOT((l_Dimension_Grp(l_counter) = C_AS_OF_DATE) OR (l_Dimension_Object(l_counter) = C_AS_OF_DATE)))) THEN
7774: IF ((l_Dimension_Grp(l_Counter) <> BSC_BIS_KPI_CRUD_PUB.C_OLTP_TIME) AND
7775: (l_Dimension_Grp(l_Counter) <> BSC_BIS_KPI_CRUD_PUB.C_EDW_TIME) AND
7776: (BSC_BIS_KPI_CRUD_PUB.Is_Dimension_Calendar(l_Dimension_Grp(l_Counter)) <> FND_API.G_TRUE)) THEN
7777:
7778: x_Non_Time_Dimension_Groups(x_Non_Time_Counter) := l_Dimension_Grp(l_Counter);
7779: x_Non_Time_Dimension_Objects(x_Non_Time_Counter) := l_dimension_object(l_Counter);
7772: IF ((l_Dimension_Grp(l_counter) <> C_TIME_COMPARISON)
7773: AND ( NOT((l_Dimension_Grp(l_counter) = C_AS_OF_DATE) OR (l_Dimension_Object(l_counter) = C_AS_OF_DATE)))) THEN
7774: IF ((l_Dimension_Grp(l_Counter) <> BSC_BIS_KPI_CRUD_PUB.C_OLTP_TIME) AND
7775: (l_Dimension_Grp(l_Counter) <> BSC_BIS_KPI_CRUD_PUB.C_EDW_TIME) AND
7776: (BSC_BIS_KPI_CRUD_PUB.Is_Dimension_Calendar(l_Dimension_Grp(l_Counter)) <> FND_API.G_TRUE)) THEN
7777:
7778: x_Non_Time_Dimension_Groups(x_Non_Time_Counter) := l_Dimension_Grp(l_Counter);
7779: x_Non_Time_Dimension_Objects(x_Non_Time_Counter) := l_dimension_object(l_Counter);
7780:
7843: END IF;
7844:
7845: WHEN NO_DATA_FOUND THEN
7846: IF (x_msg_data IS NOT NULL) THEN
7847: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_ParamPortlet ';
7848: ELSE
7849: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_ParamPortlet ';
7850: END IF;
7851: WHEN OTHERS THEN
7845: WHEN NO_DATA_FOUND THEN
7846: IF (x_msg_data IS NOT NULL) THEN
7847: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_ParamPortlet ';
7848: ELSE
7849: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_ParamPortlet ';
7850: END IF;
7851: WHEN OTHERS THEN
7852: IF (x_msg_data IS NOT NULL) THEN
7853: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_ParamPortlet ';
7849: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_ParamPortlet ';
7850: END IF;
7851: WHEN OTHERS THEN
7852: IF (x_msg_data IS NOT NULL) THEN
7853: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_ParamPortlet ';
7854: ELSE
7855: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_ParamPortlet ';
7856: END IF;
7857:
7851: WHEN OTHERS THEN
7852: IF (x_msg_data IS NOT NULL) THEN
7853: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_ParamPortlet ';
7854: ELSE
7855: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_ParamPortlet ';
7856: END IF;
7857:
7858: END Get_Dim_Info_From_ParamPortlet;
7859:
7925:
7926: WHEN NO_DATA_FOUND THEN
7927:
7928: IF (x_msg_data IS NOT NULL) THEN
7929: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
7930: ELSE
7931: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
7932: END IF;
7933: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7927:
7928: IF (x_msg_data IS NOT NULL) THEN
7929: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
7930: ELSE
7931: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
7932: END IF;
7933: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7934:
7935: WHEN OTHERS THEN
7934:
7935: WHEN OTHERS THEN
7936:
7937: IF (x_msg_data IS NOT NULL) THEN
7938: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
7939: ELSE
7940: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
7941: END IF;
7942: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7936:
7937: IF (x_msg_data IS NOT NULL) THEN
7938: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
7939: ELSE
7940: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
7941: END IF;
7942: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7943:
7944: END Refresh_Ak_Bsc_Bis_Metadata;
8003: l_report_region_rec.Group_By := NULL;
8004: l_report_region_rec.Order_By := NULL;
8005: l_report_region_rec.Plsql_For_Report_Query := p_Kpi_Id||'.'||p_Analysis_Option_Id;
8006: l_report_region_rec.Display_Subtotals := NULL;
8007: l_report_region_rec.Data_Source := BSC_BIS_KPI_CRUD_PUB.C_BSC_SOURCE;
8008: l_report_region_rec.Where_Clause := NULL;
8009: l_report_region_rec.Dimension_Group := NULL;
8010: l_report_region_rec.Parameter_Layout := NULL;
8011: l_report_region_rec.Kpi_Id := p_Kpi_Id;
8036:
8037: x_Non_Time_Dim_Obj_Short_Names := NULL;
8038:
8039: IF (p_Dim_Obj_Short_Names IS NOT NULL) THEN
8040: BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_ParamPortlet(
8041: p_Dimension_Info => p_Dim_Obj_Short_Names
8042: ,x_non_time_dimension_groups => x_Non_Time_Dimension_Groups
8043: ,x_non_time_dimension_objects => x_Non_Time_Dimension_Objects
8044: ,x_non_time_dim_obj_short_names => x_Non_Time_Dim_Obj_Short_Names
8054:
8055: -- code to recreate Periodicities goes here.
8056:
8057: IF (Has_Time_Dim_Obj_Changed(x_Time_Dim_Obj_Short_Names, p_Kpi_Id, l_Is_XTD_Enabled) = FND_API.G_TRUE) THEN
8058: BSC_BIS_KPI_CRUD_PUB.Assign_KPI_Periodicities(
8059: p_Commit => p_Commit
8060: ,p_Kpi_Id => p_Kpi_Id
8061: ,p_Time_Dim_Obj_Sns => x_Time_Dim_Obj_Short_Names
8062: ,p_Dft_Dim_Obj_Sn => NULL
8110: END IF;
8111:
8112:
8113: -- reorder the Measure at the series level (Including delete/add)
8114: l_Measure_Short_Names := BSC_BIS_KPI_CRUD_PUB.Get_DS_Sequence_From_AK(p_Region_Code, p_Kpi_Id);
8115:
8116: IF (Has_Measure_Column_Changed(l_Measure_Short_Names, p_Kpi_Id) = FND_API.G_TRUE) THEN
8117: BSC_ANALYSIS_OPTION_PUB.Rearrange_Data_Series(
8118: p_commit => FND_API.G_FALSE
8197: WHEN NO_DATA_FOUND THEN
8198: ROLLBACK TO RefreshAkBscBisMeta;
8199:
8200: IF (x_msg_data IS NOT NULL) THEN
8201: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
8202: ELSE
8203: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
8204: END IF;
8205: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
8199:
8200: IF (x_msg_data IS NOT NULL) THEN
8201: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
8202: ELSE
8203: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
8204: END IF;
8205: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
8206:
8207: WHEN OTHERS THEN
8207: WHEN OTHERS THEN
8208: ROLLBACK TO RefreshAkBscBisMeta;
8209:
8210: IF (x_msg_data IS NOT NULL) THEN
8211: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
8212: ELSE
8213: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
8214: END IF;
8215: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
8209:
8210: IF (x_msg_data IS NOT NULL) THEN
8211: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
8212: ELSE
8213: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Refresh_Ak_Bsc_Bis_Metadata ';
8214: END IF;
8215: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
8216:
8217: END Refresh_Ak_Bsc_Bis_Metadata;
8241:
8242: FOR cMSN IN cMeasureShortNames LOOP
8243: l_Measure_Short_Name := cMSN.ATTRIBUTE2;
8244:
8245: l_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_AGKpi(l_Measure_Short_Name);
8246:
8247: IF(p_Kpi_Id = l_Kpi_Id) THEN
8248: IF (l_Measure_Short_Names IS NULL) THEN
8249: l_Measure_Short_Names := l_Measure_Short_Name;
8250: ELSE
8251: l_Measure_Short_Names := l_Measure_Short_Names || ',' || l_Measure_Short_Name;
8252: END IF;
8253: ELSE
8254: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(l_Measure_Short_Name);
8255:
8256: SELECT COUNT(1) INTO l_Count
8257: FROM BSC_KPI_ANALYSIS_MEASURES_B B
8258: WHERE B.DATASET_ID = l_Dataset_Id
8299: RETURN l_Data_Series_Id;
8300:
8301: EXCEPTION
8302: WHEN OTHERS THEN
8303: RETURN BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY;
8304: END Get_Data_Series_Id;
8305:
8306:
8307: PROCEDURE Get_Dep_Obj_Func_Name( p_dep_object_name IN VARCHAR2
8371: m.source = BSC_BIS_MEASURE_PUB.c_BSC;
8372:
8373: -- Measure Does not exist or not a BSC Measure
8374: IF l_Count = 0 THEN
8375: RETURN BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY;
8376: END IF;
8377:
8378: SELECT DISTINCT INDICATOR
8379: INTO l_Kpi_Id
8385: RETURN l_Kpi_Id;
8386:
8387: EXCEPTION
8388: WHEN OTHERS THEN
8389: RETURN BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY;
8390:
8391: END Get_Objective_By_AGKpi;
8392:
8393:
8424: BEGIN
8425: SAVEPOINT MigAGRVBR;
8426: x_return_status := FND_API.G_RET_STS_SUCCESS;
8427:
8428: l_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Kpi_Id(p_Region_Code);
8429:
8430: IF (l_Kpi_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
8431: FND_MESSAGE.SET_NAME('BSC','BSC_SETUP_REPORT_DEF');
8432: FND_MSG_PUB.ADD;
8426: x_return_status := FND_API.G_RET_STS_SUCCESS;
8427:
8428: l_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Kpi_Id(p_Region_Code);
8429:
8430: IF (l_Kpi_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
8431: FND_MESSAGE.SET_NAME('BSC','BSC_SETUP_REPORT_DEF');
8432: FND_MSG_PUB.ADD;
8433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8434: END IF;
8442:
8443: l_Delete_Measure := FND_API.G_FALSE;
8444: l_Delete_Dimensions := FND_API.G_FALSE;
8445:
8446: BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata (
8447: p_Commit => p_Commit
8448: , p_Region_Code => p_Region_Code
8449: , p_Delete_Measures => l_Delete_Measure
8450: , p_Delete_Dimensions => l_Delete_Dimensions
8477: + Retain BIS_INDICATORS.FUNCTION_NAME to the current function - no changes
8478: + Manipulate BIS_INDICATORS.ACTUAL_DATA_SOURCE - Open Issue
8479:
8480: */
8481: --DBMS_OUTPUT.PUT_LINE('Coming to ... BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type');
8482:
8483: IF (l_Delete_Measure = FND_API.G_FALSE) THEN
8484: FOR iCount IN 0..l_Measure_List.LAST LOOP
8485: --DBMS_OUTPUT.PUT_LINE('loop ... BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type ... ' || l_Measure_List(iCount));
8481: --DBMS_OUTPUT.PUT_LINE('Coming to ... BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type');
8482:
8483: IF (l_Delete_Measure = FND_API.G_FALSE) THEN
8484: FOR iCount IN 0..l_Measure_List.LAST LOOP
8485: --DBMS_OUTPUT.PUT_LINE('loop ... BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type ... ' || l_Measure_List(iCount));
8486: BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type (
8487: p_Commit => p_Commit
8488: , p_Measure_Short_Name => l_Measure_List(iCount)
8489: , p_Target_Source => BSC_BIS_MEASURE_PUB.c_PMF
8482:
8483: IF (l_Delete_Measure = FND_API.G_FALSE) THEN
8484: FOR iCount IN 0..l_Measure_List.LAST LOOP
8485: --DBMS_OUTPUT.PUT_LINE('loop ... BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type ... ' || l_Measure_List(iCount));
8486: BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type (
8487: p_Commit => p_Commit
8488: , p_Measure_Short_Name => l_Measure_List(iCount)
8489: , p_Target_Source => BSC_BIS_MEASURE_PUB.c_PMF
8490: , p_Delete_Columns => FND_API.G_FALSE
8572: ROLLBACK TO MigAGRVBR;
8573: WHEN NO_DATA_FOUND THEN
8574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8575: IF (x_msg_data IS NOT NULL) THEN
8576: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Convert_AutoGen_To_ViewBased ';
8577: ELSE
8578: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Convert_AutoGen_To_ViewBased ';
8579: END IF;
8580: ROLLBACK TO MigAGRVBR;
8574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8575: IF (x_msg_data IS NOT NULL) THEN
8576: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Convert_AutoGen_To_ViewBased ';
8577: ELSE
8578: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Convert_AutoGen_To_ViewBased ';
8579: END IF;
8580: ROLLBACK TO MigAGRVBR;
8581: WHEN OTHERS THEN
8582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8580: ROLLBACK TO MigAGRVBR;
8581: WHEN OTHERS THEN
8582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8583: IF (x_msg_data IS NOT NULL) THEN
8584: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Convert_AutoGen_To_ViewBased ';
8585: ELSE
8586: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Convert_AutoGen_To_ViewBased ';
8587: END IF;
8588: ROLLBACK TO MigAGRVBR;
8582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8583: IF (x_msg_data IS NOT NULL) THEN
8584: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Convert_AutoGen_To_ViewBased ';
8585: ELSE
8586: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Convert_AutoGen_To_ViewBased ';
8587: END IF;
8588: ROLLBACK TO MigAGRVBR;
8589:
8590: END Convert_AutoGen_To_ViewBased;
8628: -- Deleting of the Dimension has been disabled since, it will from now on have the
8629: -- where clase and during conversion from AG to PLSQL we need to retain the whereclase,
8630: l_Delete_Dimension := FND_API.G_FALSE;
8631:
8632: l_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Kpi_Id(p_Region_Code);
8633:
8634: IF (l_Kpi_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
8635: FND_MESSAGE.SET_NAME('BSC','BSC_SETUP_REPORT_DEF');
8636: FND_MSG_PUB.ADD;
8630: l_Delete_Dimension := FND_API.G_FALSE;
8631:
8632: l_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Kpi_Id(p_Region_Code);
8633:
8634: IF (l_Kpi_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
8635: FND_MESSAGE.SET_NAME('BSC','BSC_SETUP_REPORT_DEF');
8636: FND_MSG_PUB.ADD;
8637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8638: END IF;
8645: --DBMS_OUTPUT.PUT_LINE('l_Measure_List(' || l_Count || ') - ' || cMSN.SHORT_NAME);
8646: END LOOP;
8647:
8648:
8649: l_Tab_Id := BSC_BIS_KPI_CRUD_PUB.Get_Tab_Id(p_Region_Code);
8650: l_kpi_Group_Id := BSC_BIS_KPI_CRUD_PUB.Get_Group_Id(p_Region_Code);
8651:
8652: --DBMS_OUTPUT.PUT_LINE(' l_Tab_Id - ' || l_Tab_Id);
8653: --DBMS_OUTPUT.PUT_LINE(' l_kpi_Group_Id - ' || l_kpi_Group_Id);
8646: END LOOP;
8647:
8648:
8649: l_Tab_Id := BSC_BIS_KPI_CRUD_PUB.Get_Tab_Id(p_Region_Code);
8650: l_kpi_Group_Id := BSC_BIS_KPI_CRUD_PUB.Get_Group_Id(p_Region_Code);
8651:
8652: --DBMS_OUTPUT.PUT_LINE(' l_Tab_Id - ' || l_Tab_Id);
8653: --DBMS_OUTPUT.PUT_LINE(' l_kpi_Group_Id - ' || l_kpi_Group_Id);
8654:
8693:
8694: /*
8695: + Delete the Objective Group created for the AG Report
8696: */
8697: IF(l_Tab_Id <> BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY AND l_kpi_Group_Id <> BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
8698:
8699: BSC_PMF_UI_WRAPPER.Delete_Kpi_Group(
8700: p_commit => p_Commit
8701: ,p_kpi_group_id => l_kpi_Group_Id
8777: --DBMS_OUTPUT.PUT_LINE(' l_Measure_List.LAST - ' || l_Measure_List.LAST);
8778:
8779: FOR iCount IN 0..l_Measure_List.LAST LOOP
8780:
8781: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(l_Measure_List(iCount));
8782:
8783: --DBMS_OUTPUT.PUT_LINE(' l_Dataset_Id - ' || l_Dataset_Id);
8784: --DBMS_OUTPUT.PUT_LINE(' l_Measure_List(iCount) - ' || l_Measure_List(iCount));
8785:
8826: ROLLBACK TO DelAGRBscMD;
8827: WHEN NO_DATA_FOUND THEN
8828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8829: IF (x_msg_data IS NOT NULL) THEN
8830: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
8831: ELSE
8832: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
8833: END IF;
8834: ROLLBACK TO DelAGRBscMD;
8828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8829: IF (x_msg_data IS NOT NULL) THEN
8830: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
8831: ELSE
8832: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
8833: END IF;
8834: ROLLBACK TO DelAGRBscMD;
8835: WHEN OTHERS THEN
8836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8834: ROLLBACK TO DelAGRBscMD;
8835: WHEN OTHERS THEN
8836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8837: IF (x_msg_data IS NOT NULL) THEN
8838: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
8839: ELSE
8840: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
8841: END IF;
8842: ROLLBACK TO DelAGRBscMD;
8836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8837: IF (x_msg_data IS NOT NULL) THEN
8838: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
8839: ELSE
8840: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
8841: END IF;
8842: ROLLBACK TO DelAGRBscMD;
8843:
8844: END Delete_AG_Bsc_Metadata;
8878: UPDATE BSC_SYS_MEASURES M
8879: SET M.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF
8880: WHERE M.SHORT_NAME = p_Measure_Short_Name;
8881:
8882: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name);
8883: --DBMS_OUTPUT.PUT_LINE('Suceess - Update - BSC_SYS_MEASURES - ' || l_Dataset_Id);
8884:
8885: UPDATE BSC_SYS_DATASETS_B D
8886: SET D.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF
8885: UPDATE BSC_SYS_DATASETS_B D
8886: SET D.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF
8887: WHERE D.DATASET_ID = l_Dataset_Id;
8888:
8889: --DBMS_OUTPUT.PUT_LINE('Suceess - Update - BSC_SYS_DATASETS_B -- ' || BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name));
8890:
8891: EXCEPTION
8892: WHEN OTHERS THEN
8893: --DBMS_OUTPUT.PUT_LINE('Error - ' || SQLERRM);
8936: ROLLBACK TO SwitchMeasureType;
8937: WHEN NO_DATA_FOUND THEN
8938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8939: IF (x_msg_data IS NOT NULL) THEN
8940: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type ';
8941: ELSE
8942: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type ';
8943: END IF;
8944: ROLLBACK TO SwitchMeasureType;
8938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8939: IF (x_msg_data IS NOT NULL) THEN
8940: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type ';
8941: ELSE
8942: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type ';
8943: END IF;
8944: ROLLBACK TO SwitchMeasureType;
8945: WHEN OTHERS THEN
8946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8944: ROLLBACK TO SwitchMeasureType;
8945: WHEN OTHERS THEN
8946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8947: IF (x_msg_data IS NOT NULL) THEN
8948: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type ';
8949: ELSE
8950: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type ';
8951: END IF;
8952: ROLLBACK TO SwitchMeasureType;
8946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8947: IF (x_msg_data IS NOT NULL) THEN
8948: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type ';
8949: ELSE
8950: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type ';
8951: END IF;
8952: ROLLBACK TO SwitchMeasureType;
8953: END Switch_Measure_Type;
8954:
9001:
9002: -- When AG Report is deleted the actual_data_source of measures having this report as primary
9003: -- data source was not getting updated .This condition will check for such measures.
9004: l_meas_source := Get_Measure_Source(p_Measures_Short_Name);
9005: IF (l_count = 0 AND (BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_AGKpi(p_Measures_Short_Name) = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) AND
9006: (l_meas_source = BSC_BIS_MEASURE_PUB.c_PMF OR l_meas_source = BSC_BIS_MEASURE_PUB.c_BSC)) THEN
9007: RETURN FND_API.G_FALSE;
9008: END IF;
9009:
9069: WHERE function_name = l_Measure_Function_Name;
9070:
9071: -- For BSC Type of measure an invalid function name should be overwritten.
9072: --This happens only if the report with this function name is deleted
9073: IF (l_Count = 0 AND (BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_AGKpi(p_Measures_Short_Name) = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) AND
9074: Get_Measure_Source(p_Measures_Short_Name) = BSC_BIS_MEASURE_PUB.c_BSC) THEN
9075: RETURN NULL;
9076: ELSE
9077: RETURN l_Measure_Function_Name;
9468:
9469: WHEN NO_DATA_FOUND THEN
9470: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
9471: IF (x_Msg_Data IS NOT NULL) THEN
9472: x_msg_data := x_Msg_Data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_Tab_And_TabViews ';
9473: ELSE
9474: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_Tab_And_TabViews ';
9475: END IF;
9476:
9470: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
9471: IF (x_Msg_Data IS NOT NULL) THEN
9472: x_msg_data := x_Msg_Data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_Tab_And_TabViews ';
9473: ELSE
9474: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_Tab_And_TabViews ';
9475: END IF;
9476:
9477: --DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
9478:
9478:
9479: WHEN OTHERS THEN
9480: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
9481: IF (x_Msg_Data IS NOT NULL) THEN
9482: x_Msg_Data := x_Msg_Data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_Tab_And_TabViews ';
9483: ELSE
9484: x_Msg_Data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_Tab_And_TabViews ';
9485: END IF;
9486:
9480: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
9481: IF (x_Msg_Data IS NOT NULL) THEN
9482: x_Msg_Data := x_Msg_Data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_Tab_And_TabViews ';
9483: ELSE
9484: x_Msg_Data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_Tab_And_TabViews ';
9485: END IF;
9486:
9487: END Delete_Tab_And_TabViews;
9488:
9569: EXCEPTION
9570: WHEN OTHERS THEN
9571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9572: IF (x_msg_data IS NOT NULL) THEN
9573: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Measures_From_CustomView ';
9574: ELSE
9575: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Measures_From_CustomView ';
9576: END IF;
9577: END Get_Measures_From_CustomView;
9571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9572: IF (x_msg_data IS NOT NULL) THEN
9573: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Get_Measures_From_CustomView ';
9574: ELSE
9575: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Get_Measures_From_CustomView ';
9576: END IF;
9577: END Get_Measures_From_CustomView;
9578:
9579:
9609: OPEN c_form_function;
9610: FETCH c_form_function INTO l_web_html_call;
9611: CLOSE c_form_function;
9612:
9613: IF((UPPER(l_web_html_call)=BSC_BIS_KPI_CRUD_PUB.C_BISVIEWER_SHOWREPORT) OR (UPPER(l_web_html_call) = UPPER(BSC_BIS_KPI_CRUD_PUB.c_bisreportpg)))THEN
9614: RETURN FND_API.G_TRUE;
9615: END IF;
9616:
9617: RETURN FND_API.G_FALSE;
9767: EXCEPTION
9768: WHEN OTHERS THEN
9769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9770: IF (x_msg_data IS NOT NULL) THEN
9771: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Is_Struct_Change_For_AG_Report ';
9772: ELSE
9773: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Is_Struct_Change_For_AG_Report ';
9774: END IF;
9775: END Is_Struct_Change_For_AG_Report;
9769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9770: IF (x_msg_data IS NOT NULL) THEN
9771: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Is_Struct_Change_For_AG_Report ';
9772: ELSE
9773: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Is_Struct_Change_For_AG_Report ';
9774: END IF;
9775: END Is_Struct_Change_For_AG_Report;
9776:
9777: FUNCTION Get_Attribute_Code_For_Measure
9909: p_Param_Region_Code,
9910: p_Param_Region_Application_Id
9911: ) = FND_API.G_TRUE) THEN
9912: IF (NOT Does_KPI_Exist(p_Page_Function_Name)) THEN
9913: BSC_BIS_KPI_CRUD_PUB.Create_Parameter_Portlet (
9914: p_Commit => p_Commit
9915: , p_Region_Code => p_Param_Region_Code
9916: , p_Region_Application_Id => p_Param_Region_Application_Id
9917: , x_Region_Code => x_Region_Code
9959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9960: WHEN NO_DATA_FOUND THEN
9961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9962: IF (x_msg_data IS NOT NULL) THEN
9963: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Parameter_Portlet ';
9964: ELSE
9965: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Parameter_Portlet ';
9966: END IF;
9967: WHEN OTHERS THEN
9961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9962: IF (x_msg_data IS NOT NULL) THEN
9963: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Parameter_Portlet ';
9964: ELSE
9965: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Parameter_Portlet ';
9966: END IF;
9967: WHEN OTHERS THEN
9968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9969: IF (x_msg_data IS NOT NULL) THEN
9966: END IF;
9967: WHEN OTHERS THEN
9968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9969: IF (x_msg_data IS NOT NULL) THEN
9970: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Parameter_Portlet ';
9971: ELSE
9972: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Parameter_Portlet ';
9973: END IF;
9974: END Cascade_Parameter_Portlet;
9968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9969: IF (x_msg_data IS NOT NULL) THEN
9970: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Parameter_Portlet ';
9971: ELSE
9972: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Parameter_Portlet ';
9973: END IF;
9974: END Cascade_Parameter_Portlet;
9975:
9976: /*******************************************
10002:
10003: l_Report_Region_Rec.Region_Code := l_Region_Code;
10004: l_Report_Region_Rec.Region_Name := l_Region_Code;
10005: l_Report_Region_Rec.Region_Description := l_Region_Code;
10006: l_Report_Region_Rec.Region_Application_Id := BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID;
10007: l_Report_Region_Rec.Database_Object_Name := C_ICX_PROMPTS;
10008: l_Report_Region_Rec.Region_Style := C_TABLE;
10009: l_Report_Region_Rec.Region_Object_Type := NULL;
10010: l_Report_Region_Rec.Help_Target := NULL;
10037: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10039: END IF;
10040:
10041: BSC_BIS_KPI_CRUD_PUB.Unroll_RegionItems_Into_Record (
10042: p_Region_Code => p_Region_Code
10043: , p_Region_Application_Id => p_Region_Application_Id
10044: , x_Region_Item_Tbl => l_Region_Item_Tbl
10045: );
10046:
10047: BIS_PMV_REGION_ITEMS_PVT.CREATE_REGION_ITEMS(
10048: p_commit => p_commit
10049: ,p_region_code => l_Region_Code
10050: ,p_region_application_id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
10051: ,p_Region_Item_Tbl => l_Region_Item_Tbl
10052: ,x_return_status => x_return_status
10053: ,x_msg_count => x_msg_count
10054: ,x_msg_data => x_msg_data
10057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10058: END IF;
10059:
10060: x_Region_Code := l_Region_Code;
10061: x_Region_Application_Id := BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID;
10062:
10063: EXCEPTION
10064: WHEN FND_API.G_EXC_ERROR THEN
10065: IF (x_msg_data IS NULL) THEN
10083: ROLLBACK TO CascadeParamPortlet;
10084: WHEN NO_DATA_FOUND THEN
10085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10086: IF (x_msg_data IS NOT NULL) THEN
10087: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Parameter_Portlet ';
10088: ELSE
10089: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Parameter_Portlet ';
10090: END IF;
10091: ROLLBACK TO CascadeParamPortlet;
10085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10086: IF (x_msg_data IS NOT NULL) THEN
10087: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Parameter_Portlet ';
10088: ELSE
10089: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Parameter_Portlet ';
10090: END IF;
10091: ROLLBACK TO CascadeParamPortlet;
10092: WHEN OTHERS THEN
10093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10091: ROLLBACK TO CascadeParamPortlet;
10092: WHEN OTHERS THEN
10093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10094: IF (x_msg_data IS NOT NULL) THEN
10095: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Parameter_Portlet ';
10096: ELSE
10097: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Parameter_Portlet ';
10098: END IF;
10099: ROLLBACK TO CascadeParamPortlet;
10093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10094: IF (x_msg_data IS NOT NULL) THEN
10095: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Create_Parameter_Portlet ';
10096: ELSE
10097: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Create_Parameter_Portlet ';
10098: END IF;
10099: ROLLBACK TO CascadeParamPortlet;
10100: END Create_Parameter_Portlet;
10101:
10138: l_Count := 0;
10139:
10140: -- Get the items from nested region_items
10141: FOR cGNRI IN c_Get_Nested_Region_Items LOOP
10142: BSC_BIS_KPI_CRUD_PUB.Get_Non_Nested_Into_Rec (
10143: p_Region_Code => cGNRI.NESTED_REGION_CODE
10144: , p_Region_Application_Id => cGNRI.NESTED_REGION_APPLICATION_ID
10145: , x_Region_Item_Tbl => l_Region_Item_Tbl
10146: );
10153:
10154: l_Count := x_Region_Item_Tbl.COUNT;
10155: END LOOP;
10156:
10157: BSC_BIS_KPI_CRUD_PUB.Get_Non_Nested_Into_Rec (
10158: p_Region_Code => p_Region_Code
10159: , p_Region_Application_Id => p_Region_Application_Id
10160: , x_Region_Item_Tbl => l_Region_Item_Tbl
10161: );
10331: FROM BIS_INDICATORS B
10332: WHERE B.SHORT_NAME = p_Measures_Short_Name;
10333:
10334: -- Invalid Data sources should be returned as NULL (so that they are updatable)
10335: IF ((BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_AGKpi(p_Measures_Short_Name) = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY)
10336: AND Get_Measure_Source(p_Measures_Short_Name) <> BSC_BIS_MEASURE_PUB.c_PMF) THEN
10337: RETURN NULL;
10338: ELSE
10339: RETURN l_Comparison_Source;
10381: --DBMS_OUTPUT.PUT_LINE(' Line 2 ');
10382: l_Delete_Measure := FND_API.G_FALSE;
10383: l_Delete_Dimensions := FND_API.G_FALSE;
10384:
10385: BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata (
10386: p_Commit => p_Commit
10387: , p_Region_Code => p_Region_Code
10388: , p_Delete_Measures => l_Delete_Measure
10389: , p_Delete_Dimensions => l_Delete_Dimensions
10414: l_report_region_rec.Group_By := BIS_COMMON_UTILS.G_DEF_CHAR;
10415: l_report_region_rec.Order_By := BIS_COMMON_UTILS.G_DEF_CHAR;
10416: l_report_region_rec.Plsql_For_Report_Query := p_Plsql_For_Report_Query;
10417: l_report_region_rec.Display_Subtotals := BIS_COMMON_UTILS.G_DEF_CHAR;
10418: l_report_region_rec.Data_Source := BSC_BIS_KPI_CRUD_PUB.C_PLSQL_SOURCE;
10419: l_report_region_rec.Where_Clause := BIS_COMMON_UTILS.G_DEF_CHAR;
10420: l_report_region_rec.Dimension_Group := BIS_COMMON_UTILS.G_DEF_CHAR;
10421: l_report_region_rec.Parameter_Layout := BIS_COMMON_UTILS.G_DEF_CHAR;
10422: l_report_region_rec.Kpi_Id := BIS_COMMON_UTILS.G_DEF_NUM;
10434: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10436: END IF;
10437:
10438: BSC_BIS_KPI_CRUD_PUB.Cascade_Attr_Code_Into_Measure (
10439: p_Commit => p_Commit
10440: , p_Region_Code => p_Region_Code
10441: , p_Region_Application_Id => p_Region_Application_Id
10442: , p_Old_Attribute_Codes => p_Old_Attribute_Codes
10476: WHEN NO_DATA_FOUND THEN
10477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10478: ROLLBACK TO MigrateAGRTOPLSQL1;
10479: IF (x_msg_data IS NOT NULL) THEN
10480: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10481: ELSE
10482: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10483: END IF;
10484: WHEN OTHERS THEN
10478: ROLLBACK TO MigrateAGRTOPLSQL1;
10479: IF (x_msg_data IS NOT NULL) THEN
10480: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10481: ELSE
10482: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10483: END IF;
10484: WHEN OTHERS THEN
10485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10486: ROLLBACK TO MigrateAGRTOPLSQL1;
10484: WHEN OTHERS THEN
10485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10486: ROLLBACK TO MigrateAGRTOPLSQL1;
10487: IF (x_msg_data IS NOT NULL) THEN
10488: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10489: ELSE
10490: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10491: END IF;
10492: END Migrate_AGR_To_PLSQL;
10486: ROLLBACK TO MigrateAGRTOPLSQL1;
10487: IF (x_msg_data IS NOT NULL) THEN
10488: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10489: ELSE
10490: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10491: END IF;
10492: END Migrate_AGR_To_PLSQL;
10493:
10494:
10512: FND_MSG_PUB.Initialize;
10513:
10514: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
10515:
10516: BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL (
10517: p_Commit => p_Commit
10518: , p_Region_Application_Id => p_Region_Application_Id
10519: , p_Region_Code => p_Region_Code
10520: , p_Update_AK_Metadata => FND_API.G_FALSE
10558: WHEN NO_DATA_FOUND THEN
10559: ROLLBACK TO MigrateAGRTOPLSQL;
10560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10561: IF (x_msg_data IS NOT NULL) THEN
10562: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10563: ELSE
10564: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10565: END IF;
10566: WHEN OTHERS THEN
10560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10561: IF (x_msg_data IS NOT NULL) THEN
10562: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10563: ELSE
10564: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10565: END IF;
10566: WHEN OTHERS THEN
10567: ROLLBACK TO MigrateAGRTOPLSQL;
10568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10566: WHEN OTHERS THEN
10567: ROLLBACK TO MigrateAGRTOPLSQL;
10568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10569: IF (x_msg_data IS NOT NULL) THEN
10570: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10571: ELSE
10572: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10573: END IF;
10574: END Migrate_AGR_To_PLSQL;
10568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10569: IF (x_msg_data IS NOT NULL) THEN
10570: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10571: ELSE
10572: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL ';
10573: END IF;
10574: END Migrate_AGR_To_PLSQL;
10575:
10576:
10584: l_Return VARCHAR2(1);
10585: BEGIN
10586: l_Return := FND_API.G_FALSE;
10587:
10588: l_Actual_Data_Source := BSC_BIS_KPI_CRUD_PUB.Get_Actual_Source_Data(p_Measure_Short_Name);
10589: IF((l_Actual_Data_Source IS NOT NULL) AND (p_Region_Code IS NOT NULL)) THEN
10590: l_Region_Code := SUBSTR(l_Actual_Data_Source, 1, INSTR(l_Actual_Data_Source, '.')-1);
10591:
10592: IF ((l_Region_Code IS NOT NULL) AND (l_Region_Code = p_Region_Code)) THEN
10655:
10656: FOR cMSN IN cMeasureShortNames LOOP
10657: l_Measure_Short_Name := cMSN.ATTRIBUTE2;
10658: l_Measure_Attr_Code := cMSN.ATTRIBUTE_CODE;
10659: l_Compare_Attr_Code := BSC_BIS_KPI_CRUD_PUB.Get_Compare_Attribute_Code(p_Region_Code, l_Measure_Short_Name);
10660:
10661: IF (BSC_UTILITY.Is_Measure_Seeded(l_Measure_Short_Name) = FND_API.G_FALSE AND
10662: BSC_BIS_KPI_CRUD_PUB.Is_Primary_Source_Of_Measure(l_Measure_Short_Name, p_Region_Code)
10663: = FND_API.G_FALSE) THEN
10658: l_Measure_Attr_Code := cMSN.ATTRIBUTE_CODE;
10659: l_Compare_Attr_Code := BSC_BIS_KPI_CRUD_PUB.Get_Compare_Attribute_Code(p_Region_Code, l_Measure_Short_Name);
10660:
10661: IF (BSC_UTILITY.Is_Measure_Seeded(l_Measure_Short_Name) = FND_API.G_FALSE AND
10662: BSC_BIS_KPI_CRUD_PUB.Is_Primary_Source_Of_Measure(l_Measure_Short_Name, p_Region_Code)
10663: = FND_API.G_FALSE) THEN
10664:
10665: FOR cMP IN cMeasureProperties LOOP
10666: l_Actual_Data_Source_Type := cMP.ACTUAL_DATA_SOURCE_TYPE;
10691: END IF;
10692:
10693: IF (Get_Measure_Source(l_Measure_Short_Name) = BSC_BIS_MEASURE_PUB.c_CDS) THEN
10694: IF ((p_Old_Attribute_Codes IS NOT NULL) AND (p_New_Attribute_Codes IS NOT NULL)) THEN
10695: BSC_BIS_KPI_CRUD_PUB.Cascade_Changes_Into_Forumla (
10696: p_Commit => p_Commit
10697: , p_Measure_Short_Name => l_Measure_Short_Name
10698: , p_Old_Attribute_Codes => p_Old_Attribute_Codes
10699: , p_Old_Attribute_Code_App_Ids => p_Old_Attribute_Code_App_Ids
10734: WHEN NO_DATA_FOUND THEN
10735: ROLLBACK TO CascdAttrCode;
10736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10737: IF (x_msg_data IS NOT NULL) THEN
10738: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Attr_Code_Into_Measure ';
10739: ELSE
10740: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Attr_Code_Into_Measure ';
10741: END IF;
10742: WHEN OTHERS THEN
10736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10737: IF (x_msg_data IS NOT NULL) THEN
10738: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Attr_Code_Into_Measure ';
10739: ELSE
10740: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Attr_Code_Into_Measure ';
10741: END IF;
10742: WHEN OTHERS THEN
10743: ROLLBACK TO CascdAttrCode;
10744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10742: WHEN OTHERS THEN
10743: ROLLBACK TO CascdAttrCode;
10744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10745: IF (x_msg_data IS NOT NULL) THEN
10746: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Attr_Code_Into_Measure ';
10747: ELSE
10748: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Attr_Code_Into_Measure ';
10749: END IF;
10750: END Cascade_Attr_Code_Into_Measure;
10744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10745: IF (x_msg_data IS NOT NULL) THEN
10746: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Attr_Code_Into_Measure ';
10747: ELSE
10748: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Attr_Code_Into_Measure ';
10749: END IF;
10750: END Cascade_Attr_Code_Into_Measure;
10751:
10752:
10891: WHEN NO_DATA_FOUND THEN
10892: ROLLBACK TO CascdAttrCodeIntoForm;
10893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10894: IF (x_msg_data IS NOT NULL) THEN
10895: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Changes_Into_Forumla ';
10896: ELSE
10897: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Changes_Into_Forumla ';
10898: END IF;
10899: WHEN OTHERS THEN
10893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10894: IF (x_msg_data IS NOT NULL) THEN
10895: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Changes_Into_Forumla ';
10896: ELSE
10897: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Changes_Into_Forumla ';
10898: END IF;
10899: WHEN OTHERS THEN
10900: ROLLBACK TO CascdAttrCodeIntoForm;
10901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10899: WHEN OTHERS THEN
10900: ROLLBACK TO CascdAttrCodeIntoForm;
10901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10902: IF (x_msg_data IS NOT NULL) THEN
10903: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Changes_Into_Forumla ';
10904: ELSE
10905: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Changes_Into_Forumla ';
10906: END IF;
10907: END Cascade_Changes_Into_Forumla;
10901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10902: IF (x_msg_data IS NOT NULL) THEN
10903: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Changes_Into_Forumla ';
10904: ELSE
10905: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Changes_Into_Forumla ';
10906: END IF;
10907: END Cascade_Changes_Into_Forumla;
10908:
10909:
10948: , x_Msg_Data OUT NOCOPY VARCHAR
10949: ) IS
10950: BEGIN
10951:
10952: BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata (
10953: p_Commit => p_Commit
10954: , p_Region_Code => p_Region_Code
10955: , p_Delete_Measures => p_Delete_Measures
10956: , p_Delete_Dimensions => FND_API.G_TRUE
10983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10984: WHEN NO_DATA_FOUND THEN
10985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10986: IF (x_msg_data IS NOT NULL) THEN
10987: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
10988: ELSE
10989: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
10990: END IF;
10991: WHEN OTHERS THEN
10985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10986: IF (x_msg_data IS NOT NULL) THEN
10987: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
10988: ELSE
10989: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
10990: END IF;
10991: WHEN OTHERS THEN
10992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10993: IF (x_msg_data IS NOT NULL) THEN
10990: END IF;
10991: WHEN OTHERS THEN
10992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10993: IF (x_msg_data IS NOT NULL) THEN
10994: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
10995: ELSE
10996: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
10997: END IF;
10998: END Delete_AG_Bsc_Metadata;
10992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10993: IF (x_msg_data IS NOT NULL) THEN
10994: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
10995: ELSE
10996: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata ';
10997: END IF;
10998: END Delete_AG_Bsc_Metadata;
10999:
11000: --
11015: SAVEPOINT DelAGRep;
11016: FND_MSG_PUB.Initialize;
11017: x_return_status := FND_API.G_RET_STS_SUCCESS;
11018:
11019: l_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Kpi_Id(p_Region_Code);
11020: IF (l_Kpi_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
11021: FND_MESSAGE.SET_NAME('BSC','BSC_SETUP_REPORT_DEF');
11022: FND_MSG_PUB.ADD;
11023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11016: FND_MSG_PUB.Initialize;
11017: x_return_status := FND_API.G_RET_STS_SUCCESS;
11018:
11019: l_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Kpi_Id(p_Region_Code);
11020: IF (l_Kpi_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
11021: FND_MESSAGE.SET_NAME('BSC','BSC_SETUP_REPORT_DEF');
11022: FND_MSG_PUB.ADD;
11023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11024: END IF;
11039: IF ((x_Return_Status IS NOT NULL) AND (x_Return_Status <> FND_API.G_RET_STS_SUCCESS)) THEN
11040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11041: END IF;
11042:
11043: BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata (
11044: p_Commit => FND_API.G_FALSE
11045: ,p_Region_Code => p_Region_Code
11046: ,p_Delete_Measures => p_Delete_Measures
11047: ,x_return_status => x_return_status
11074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11075: WHEN NO_DATA_FOUND THEN
11076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11077: IF (x_msg_data IS NOT NULL) THEN
11078: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AG_Report ';
11079: ELSE
11080: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AG_Report ';
11081: END IF;
11082: WHEN OTHERS THEN
11076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11077: IF (x_msg_data IS NOT NULL) THEN
11078: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AG_Report ';
11079: ELSE
11080: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AG_Report ';
11081: END IF;
11082: WHEN OTHERS THEN
11083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11084: IF (x_msg_data IS NOT NULL) THEN
11081: END IF;
11082: WHEN OTHERS THEN
11083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11084: IF (x_msg_data IS NOT NULL) THEN
11085: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AG_Report ';
11086: ELSE
11087: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AG_Report ';
11088: END IF;
11089: END Delete_AG_Report;
11083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11084: IF (x_msg_data IS NOT NULL) THEN
11085: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Delete_AG_Report ';
11086: ELSE
11087: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Delete_AG_Report ';
11088: END IF;
11089: END Delete_AG_Report;
11090:
11091:
11108:
11109: l_Delete_Measure := FND_API.G_FALSE;
11110: l_Delete_Dimensions := FND_API.G_FALSE;
11111:
11112: BSC_BIS_KPI_CRUD_PUB.Delete_AG_Bsc_Metadata (
11113: p_Commit => p_Commit
11114: , p_Region_Code => p_Region_Code
11115: , p_Delete_Measures => l_Delete_Measure
11116: , p_Delete_Dimensions => l_Delete_Dimensions
11146: WHEN NO_DATA_FOUND THEN
11147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11148: ROLLBACK TO MigrateAGRTOVBR;
11149: IF (x_msg_data IS NOT NULL) THEN
11150: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_VBR ';
11151: ELSE
11152: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_VBR ';
11153: END IF;
11154: WHEN OTHERS THEN
11148: ROLLBACK TO MigrateAGRTOVBR;
11149: IF (x_msg_data IS NOT NULL) THEN
11150: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_VBR ';
11151: ELSE
11152: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_VBR ';
11153: END IF;
11154: WHEN OTHERS THEN
11155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11156: ROLLBACK TO MigrateAGRTOVBR;
11154: WHEN OTHERS THEN
11155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11156: ROLLBACK TO MigrateAGRTOVBR;
11157: IF (x_msg_data IS NOT NULL) THEN
11158: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_VBR ';
11159: ELSE
11160: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_VBR ';
11161: END IF;
11162: END Migrate_AGR_To_VBR;
11156: ROLLBACK TO MigrateAGRTOVBR;
11157: IF (x_msg_data IS NOT NULL) THEN
11158: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_VBR ';
11159: ELSE
11160: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_VBR ';
11161: END IF;
11162: END Migrate_AGR_To_VBR;
11163:
11164:
11176: SAVEPOINT MigrateAGRTOEXTNSRC;
11177: FND_MSG_PUB.Initialize;
11178: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
11179:
11180: IF (p_Existing_Report_Type = BSC_BIS_KPI_CRUD_PUB.C_PLSQL_BASED_REPORT_TYPE) THEN
11181: BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL (
11182: p_Commit => p_Commit
11183: , p_Region_Application_Id => p_Region_Application_Id
11184: , p_Region_Code => p_Region_Code
11177: FND_MSG_PUB.Initialize;
11178: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
11179:
11180: IF (p_Existing_Report_Type = BSC_BIS_KPI_CRUD_PUB.C_PLSQL_BASED_REPORT_TYPE) THEN
11181: BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_PLSQL (
11182: p_Commit => p_Commit
11183: , p_Region_Application_Id => p_Region_Application_Id
11184: , p_Region_Code => p_Region_Code
11185: , x_Return_Status => x_Return_Status
11188: );
11189: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11191: END IF;
11192: ELSIF (p_Existing_Report_Type = BSC_BIS_KPI_CRUD_PUB.C_VIEW_BASED_REPORT_TYPE) THEN
11193: BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_VBR (
11194: p_Commit => p_Commit
11195: , p_Region_Application_Id => p_Region_Application_Id
11196: , p_Region_Code => p_Region_Code
11189: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11191: END IF;
11192: ELSIF (p_Existing_Report_Type = BSC_BIS_KPI_CRUD_PUB.C_VIEW_BASED_REPORT_TYPE) THEN
11193: BSC_BIS_KPI_CRUD_PUB.Migrate_AGR_To_VBR (
11194: p_Commit => p_Commit
11195: , p_Region_Application_Id => p_Region_Application_Id
11196: , p_Region_Code => p_Region_Code
11197: , x_Return_Status => x_Return_Status
11227: WHEN NO_DATA_FOUND THEN
11228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11229: ROLLBACK TO MigrateAGRTOEXTNSRC;
11230: IF (x_msg_data IS NOT NULL) THEN
11231: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_To_Existing_Source ';
11232: ELSE
11233: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_To_Existing_Source ';
11234: END IF;
11235: WHEN OTHERS THEN
11229: ROLLBACK TO MigrateAGRTOEXTNSRC;
11230: IF (x_msg_data IS NOT NULL) THEN
11231: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_To_Existing_Source ';
11232: ELSE
11233: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_To_Existing_Source ';
11234: END IF;
11235: WHEN OTHERS THEN
11236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11237: ROLLBACK TO MigrateAGRTOEXTNSRC;
11235: WHEN OTHERS THEN
11236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11237: ROLLBACK TO MigrateAGRTOEXTNSRC;
11238: IF (x_msg_data IS NOT NULL) THEN
11239: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_To_Existing_Source ';
11240: ELSE
11241: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_To_Existing_Source ';
11242: END IF;
11243: END Migrate_To_Existing_Source;
11237: ROLLBACK TO MigrateAGRTOEXTNSRC;
11238: IF (x_msg_data IS NOT NULL) THEN
11239: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Migrate_To_Existing_Source ';
11240: ELSE
11241: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Migrate_To_Existing_Source ';
11242: END IF;
11243: END Migrate_To_Existing_Source;
11244:
11245: /*
11331:
11332: FOR cOL IN c_Objective_List LOOP
11333: l_Kpi_Id := cOL.INDICATOR;
11334:
11335: BSC_BIS_KPI_CRUD_PUB.Get_Dim_Info_From_Region_Code(
11336: p_Param_Portlet_Region_Code => p_Region_Code
11337: , x_Non_Time_Dimension_Groups => x_Non_Time_Dimension_Groups
11338: , x_Non_Time_Dimension_Objects => x_Non_Time_Dimension_Objects
11339: , x_Non_Time_Dim_Obj_Short_Names => x_Non_Time_Dim_Obj_Short_Names
11345: , x_Time_Counter => x_Time_Counter
11346: , x_Msg_Data => x_Msg_Data
11347: );
11348:
11349: l_Is_XTD_Enabled := BSC_BIS_KPI_CRUD_PUB.is_XTD_Enabled(p_Region_Code);
11350: IF ((Has_Time_Dim_Obj_Changed(x_Time_Dim_Obj_Short_Names, l_Kpi_Id, l_Is_XTD_Enabled) = FND_API.G_TRUE) OR
11351: (p_Force_Change = FND_API.G_TRUE)) THEN
11352: BSC_BIS_KPI_CRUD_PUB.Assign_KPI_Periodicities(
11353: p_Commit => p_Commit
11348:
11349: l_Is_XTD_Enabled := BSC_BIS_KPI_CRUD_PUB.is_XTD_Enabled(p_Region_Code);
11350: IF ((Has_Time_Dim_Obj_Changed(x_Time_Dim_Obj_Short_Names, l_Kpi_Id, l_Is_XTD_Enabled) = FND_API.G_TRUE) OR
11351: (p_Force_Change = FND_API.G_TRUE)) THEN
11352: BSC_BIS_KPI_CRUD_PUB.Assign_KPI_Periodicities(
11353: p_Commit => p_Commit
11354: ,p_Kpi_Id => l_Kpi_Id
11355: ,p_Time_Dim_Obj_Sns => x_Time_Dim_Obj_Short_Names
11356: ,p_Dft_Dim_Obj_Sn => NULL
11408: ROLLBACK TO CascadeDimByRegion;
11409: WHEN NO_DATA_FOUND THEN
11410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11411: IF (x_msg_data IS NOT NULL) THEN
11412: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Dimension_By_Region ';
11413: ELSE
11414: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Dimension_By_Region ';
11415: END IF;
11416: ROLLBACK TO CascadeDimByRegion;
11410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11411: IF (x_msg_data IS NOT NULL) THEN
11412: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Dimension_By_Region ';
11413: ELSE
11414: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Dimension_By_Region ';
11415: END IF;
11416: ROLLBACK TO CascadeDimByRegion;
11417: WHEN OTHERS THEN
11418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11416: ROLLBACK TO CascadeDimByRegion;
11417: WHEN OTHERS THEN
11418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11419: IF (x_msg_data IS NOT NULL) THEN
11420: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Dimension_By_Region ';
11421: ELSE
11422: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Dimension_By_Region ';
11423: END IF;
11424: ROLLBACK TO CascadeDimByRegion;
11418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11419: IF (x_msg_data IS NOT NULL) THEN
11420: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_CRUD_PUB.Cascade_Dimension_By_Region ';
11421: ELSE
11422: x_msg_data := SQLERRM||' at BSC_BIS_KPI_CRUD_PUB.Cascade_Dimension_By_Region ';
11423: END IF;
11424: ROLLBACK TO CascadeDimByRegion;
11425: END Cascade_Dimension_By_Region;
11426:
11485: , x_Msg_Count OUT NOCOPY NUMBER
11486: , x_Msg_Data OUT NOCOPY VARCHAR2
11487: )IS
11488: BEGIN
11489: BSC_BIS_KPI_CRUD_PUB.Create_Bsc_Bis_Metadata(
11490: p_Commit => p_Commit
11491: , p_Create_Region_Per_Ao => p_Create_Region_Per_Ao
11492: , p_Param_Portlet_Region_Code => p_Param_Portlet_Region_Code
11493: , p_Page_Function_Name => p_Page_Function_Name
11513: , p_Measure_App_Id => p_Measure_App_Id
11514: , p_Func_Area_Short_Name => p_Func_Area_Short_Name
11515: , p_Obj_Grp_Id => NULL
11516: , p_Obj_Tab_Id => NULL
11517: , p_Obj_Type => BSC_BIS_KPI_CRUD_PUB.C_MULTI_BAR_INDICATOR
11518: , x_Measure_Short_Name => x_Measure_Short_Name
11519: , x_Kpi_Id => x_Kpi_Id
11520: , x_Return_Status => x_Return_Status
11521: , x_Msg_Count => x_Msg_Count
11569: l_region_code VARCHAR2(100);
11570:
11571: BEGIN
11572:
11573: SELECT BSC_BIS_KPI_CRUD_PUB.C_PMD || TO_CHAR(SYSDATE,'ddmmyyhh24miss')
11574: INTO l_region_code
11575: FROM dual;
11576: RETURN l_region_code;
11577:
11613: IF(p_region_code IS NOT NULL) THEN
11614: FOR cd IN c_dim_dimObj LOOP
11615: l_attribute2 := cd.attribute2;
11616: l_dim := SUBSTR(l_attribute2, 1, INSTR(l_attribute2,'+')-1);
11617: IF((l_dim <> BSC_BIS_KPI_CRUD_PUB.c_oltp_time) AND
11618: (l_dim <> BSC_BIS_KPI_CRUD_PUB.c_edw_time) AND
11619: (BSC_BIS_KPI_CRUD_PUB.Is_Dimension_Calendar(l_dim) <> FND_API.G_TRUE)) THEN
11620: x_non_time_counter:=x_non_time_counter + 1;
11621: x_non_time_dim_dimObjs(x_non_time_counter) := l_attribute2;
11614: FOR cd IN c_dim_dimObj LOOP
11615: l_attribute2 := cd.attribute2;
11616: l_dim := SUBSTR(l_attribute2, 1, INSTR(l_attribute2,'+')-1);
11617: IF((l_dim <> BSC_BIS_KPI_CRUD_PUB.c_oltp_time) AND
11618: (l_dim <> BSC_BIS_KPI_CRUD_PUB.c_edw_time) AND
11619: (BSC_BIS_KPI_CRUD_PUB.Is_Dimension_Calendar(l_dim) <> FND_API.G_TRUE)) THEN
11620: x_non_time_counter:=x_non_time_counter + 1;
11621: x_non_time_dim_dimObjs(x_non_time_counter) := l_attribute2;
11622: END IF;
11615: l_attribute2 := cd.attribute2;
11616: l_dim := SUBSTR(l_attribute2, 1, INSTR(l_attribute2,'+')-1);
11617: IF((l_dim <> BSC_BIS_KPI_CRUD_PUB.c_oltp_time) AND
11618: (l_dim <> BSC_BIS_KPI_CRUD_PUB.c_edw_time) AND
11619: (BSC_BIS_KPI_CRUD_PUB.Is_Dimension_Calendar(l_dim) <> FND_API.G_TRUE)) THEN
11620: x_non_time_counter:=x_non_time_counter + 1;
11621: x_non_time_dim_dimObjs(x_non_time_counter) := l_attribute2;
11622: END IF;
11623: END LOOP;
11627: x_non_time_counter :=0;
11628: END Get_Non_Time_Dim_And_DimObjs;
11629:
11630:
11631: END BSC_BIS_KPI_CRUD_PUB;