eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_BIS_KPI_CRUD_PUB dependencies on AK_REGIONS

Line 42: REM | 14-JUN-04 adrao Modified Update and Create AK Regions for |

38: REM | 27-MAY-04 adrao Modularized all CRUD APIs |
39: REM | 04-JUN-04 adrao Added Autofactoring for Measure, Compare To |
40: REM | 10-JUN-04 adrao Modified Create_Measure and Update_Measure |
41: REM | to disable Projection |
42: REM | 14-JUN-04 adrao Modified Update and Create AK Regions for |
43: REM | Bug#3688263 and Bug#3688300 |
44: REM | 14-JUN-04 adrao Added APIs to check for Time Dimension Objs |
45: REM | 17-JUN-04 adrao Modified Bug3698962 and Bug3698936 to remove |
46: REM | ATTRIBUTE3 to NULL except CHANGE_MEASURE and |

Line 280: l_Param_Region_Code AK_REGIONS.REGION_CODE%TYPE;

276:
277: -- added for Bug#4064587
278: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
279:
280: l_Param_Region_Code AK_REGIONS.REGION_CODE%TYPE;
281: l_Param_Region_Application_Id AK_REGIONS.REGION_APPLICATION_ID%TYPE;
282:
283: BEGIN
284: SAVEPOINT CreateEndToEndKPI;

Line 281: l_Param_Region_Application_Id AK_REGIONS.REGION_APPLICATION_ID%TYPE;

277: -- added for Bug#4064587
278: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
279:
280: l_Param_Region_Code AK_REGIONS.REGION_CODE%TYPE;
281: l_Param_Region_Application_Id AK_REGIONS.REGION_APPLICATION_ID%TYPE;
282:
283: BEGIN
284: SAVEPOINT CreateEndToEndKPI;
285: FND_MSG_PUB.Initialize;

Line 1630: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;

1626: ,x_Msg_Data OUT NOCOPY VARCHAR2)
1627: IS
1628:
1629: l_Measure_Short_Name VARCHAR2(1000);
1630: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
1631:
1632:
1633: BEGIN
1634: SAVEPOINT AssociateKPIToAO;

Line 3185: FROM AK_REGIONS

3181: l_Count := 0;
3182:
3183: SELECT COUNT(1)
3184: INTO l_Count
3185: FROM AK_REGIONS
3186: WHERE REGION_CODE = p_Region_Code;
3187:
3188: IF (l_Count > 0) THEN
3189: RETURN TRUE;

Line 3270: FROM AK_REGIONS A

3266: l_App_Id := -1;
3267:
3268: SELECT A.REGION_APPLICATION_ID
3269: INTO l_App_Id
3270: FROM AK_REGIONS A
3271: WHERE A.REGION_CODE = p_Region_Code;
3272:
3273:
3274: RETURN l_App_Id;

Line 3505: FROM AK_REGIONS

3501:
3502: l_Count := 0;
3503:
3504: SELECT COUNT(1) INTO l_Count
3505: FROM AK_REGIONS
3506: WHERE Region_Code = p_Short_Name;
3507: --AND Region_Application_Id = 271;--hardcoded application id will be removed with a constant
3508:
3509: IF (l_Count = 0) THEN

Line 4910: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;

4906: l_User_Page_Report_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4907: l_User_Portlet_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4908: l_Analysis_Option NUMBER;
4909: l_Measure_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
4910: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
4911: l_Count NUMBER;
4912: l_Function_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4913: l_Measure_Group_Id NUMBER;
4914:

Line 5905: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;

5901: , x_Return_Status OUT NOCOPY VARCHAR2
5902: , x_Msg_Count OUT NOCOPY NUMBER
5903: , x_Msg_Data OUT NOCOPY VARCHAR2
5904: ) IS
5905: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
5906:
5907: CURSOR c_RefreshAK IS
5908: SELECT A.ANALYSIS_OPTION0 ,
5909: A.DATASET_ID,

Line 6449: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;

6445: p_Kpi_Id IN NUMBER
6446: , p_Analysis_Group0 IN NUMBER
6447: ) RETURN VARCHAR2
6448: IS
6449: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
6450: l_Next_Analysis_Option NUMBER;
6451: l_Count NUMBER;
6452: BEGIN
6453:

Line 6754: AK_REGIONS_VL R

6750:
6751: CURSOR c_PMV_Report_List IS
6752: SELECT DISTINCT R.NAME NAME
6753: FROM AK_REGION_ITEMS RI,
6754: AK_REGIONS_VL R
6755: WHERE RI.ATTRIBUTE1 IN ('MEASURE', 'MEASURE_NOTARGET')
6756: AND RI.ATTRIBUTE2 = l_Measure_Short_Name
6757: AND RI.REGION_CODE = R.REGION_CODE;
6758: BEGIN

Line 7973: l_Region_Name Ak_Regions_Tl.NAME%TYPE;

7969: x_Non_Time_Counter NUMBER;
7970: x_Time_Counter NUMBER;
7971: l_Measure_Short_Names VARCHAR2(4096);
7972:
7973: l_Region_Name Ak_Regions_Tl.NAME%TYPE;
7974: l_Region_Description Ak_Regions_Tl.DESCRIPTION%TYPE;
7975: l_Region_Created_By Ak_Regions_Tl.CREATED_BY%TYPE;
7976: l_Region_Creation_Date Ak_Regions_Tl.CREATION_DATE%TYPE;
7977: l_Region_Last_Updated_By Ak_Regions_Tl.LAST_UPDATED_BY%TYPE;

Line 7974: l_Region_Description Ak_Regions_Tl.DESCRIPTION%TYPE;

7970: x_Time_Counter NUMBER;
7971: l_Measure_Short_Names VARCHAR2(4096);
7972:
7973: l_Region_Name Ak_Regions_Tl.NAME%TYPE;
7974: l_Region_Description Ak_Regions_Tl.DESCRIPTION%TYPE;
7975: l_Region_Created_By Ak_Regions_Tl.CREATED_BY%TYPE;
7976: l_Region_Creation_Date Ak_Regions_Tl.CREATION_DATE%TYPE;
7977: l_Region_Last_Updated_By Ak_Regions_Tl.LAST_UPDATED_BY%TYPE;
7978: l_Region_Last_Update_Date Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE;

Line 7975: l_Region_Created_By Ak_Regions_Tl.CREATED_BY%TYPE;

7971: l_Measure_Short_Names VARCHAR2(4096);
7972:
7973: l_Region_Name Ak_Regions_Tl.NAME%TYPE;
7974: l_Region_Description Ak_Regions_Tl.DESCRIPTION%TYPE;
7975: l_Region_Created_By Ak_Regions_Tl.CREATED_BY%TYPE;
7976: l_Region_Creation_Date Ak_Regions_Tl.CREATION_DATE%TYPE;
7977: l_Region_Last_Updated_By Ak_Regions_Tl.LAST_UPDATED_BY%TYPE;
7978: l_Region_Last_Update_Date Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE;
7979: l_Region_Last_Update_Login Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE;

Line 7976: l_Region_Creation_Date Ak_Regions_Tl.CREATION_DATE%TYPE;

7972:
7973: l_Region_Name Ak_Regions_Tl.NAME%TYPE;
7974: l_Region_Description Ak_Regions_Tl.DESCRIPTION%TYPE;
7975: l_Region_Created_By Ak_Regions_Tl.CREATED_BY%TYPE;
7976: l_Region_Creation_Date Ak_Regions_Tl.CREATION_DATE%TYPE;
7977: l_Region_Last_Updated_By Ak_Regions_Tl.LAST_UPDATED_BY%TYPE;
7978: l_Region_Last_Update_Date Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE;
7979: l_Region_Last_Update_Login Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE;
7980: l_Is_XTD_Enabled VARCHAR2(1);

Line 7977: l_Region_Last_Updated_By Ak_Regions_Tl.LAST_UPDATED_BY%TYPE;

7973: l_Region_Name Ak_Regions_Tl.NAME%TYPE;
7974: l_Region_Description Ak_Regions_Tl.DESCRIPTION%TYPE;
7975: l_Region_Created_By Ak_Regions_Tl.CREATED_BY%TYPE;
7976: l_Region_Creation_Date Ak_Regions_Tl.CREATION_DATE%TYPE;
7977: l_Region_Last_Updated_By Ak_Regions_Tl.LAST_UPDATED_BY%TYPE;
7978: l_Region_Last_Update_Date Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE;
7979: l_Region_Last_Update_Login Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE;
7980: l_Is_XTD_Enabled VARCHAR2(1);
7981:

Line 7978: l_Region_Last_Update_Date Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE;

7974: l_Region_Description Ak_Regions_Tl.DESCRIPTION%TYPE;
7975: l_Region_Created_By Ak_Regions_Tl.CREATED_BY%TYPE;
7976: l_Region_Creation_Date Ak_Regions_Tl.CREATION_DATE%TYPE;
7977: l_Region_Last_Updated_By Ak_Regions_Tl.LAST_UPDATED_BY%TYPE;
7978: l_Region_Last_Update_Date Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE;
7979: l_Region_Last_Update_Login Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE;
7980: l_Is_XTD_Enabled VARCHAR2(1);
7981:
7982: BEGIN

Line 7979: l_Region_Last_Update_Login Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE;

7975: l_Region_Created_By Ak_Regions_Tl.CREATED_BY%TYPE;
7976: l_Region_Creation_Date Ak_Regions_Tl.CREATION_DATE%TYPE;
7977: l_Region_Last_Updated_By Ak_Regions_Tl.LAST_UPDATED_BY%TYPE;
7978: l_Region_Last_Update_Date Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE;
7979: l_Region_Last_Update_Login Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE;
7980: l_Is_XTD_Enabled VARCHAR2(1);
7981:
7982: BEGIN
7983: SAVEPOINT RefreshAkBscBisMeta;

Line 7988: -- 1) Cascaded back to AK Metadata (AK_REGIONS, AK_REGION_ITEMS, FND_FORM_FUNCTIONS_VL

7984:
7985: FND_MSG_PUB.Initialize;
7986: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
7987:
7988: -- 1) Cascaded back to AK Metadata (AK_REGIONS, AK_REGION_ITEMS, FND_FORM_FUNCTIONS_VL
7989: l_report_region_rec.Region_Code := p_Region_Code;
7990: l_report_region_rec.Region_Name := BIS_COMMON_UTILS.G_DEF_CHAR;
7991: l_report_region_rec.Region_Description := BIS_COMMON_UTILS.G_DEF_CHAR;
7992: l_report_region_rec.Region_Application_Id := p_Region_Application_Id;

Line 8992: l_region_code AK_REGIONS.REGION_CODE%TYPE;

8988: ) RETURN VARCHAR2
8989: IS
8990: l_meas_source BSC_SYS_MEASURES.SOURCE%TYPE;
8991: l_count NUMBER := 0;
8992: l_region_code AK_REGIONS.REGION_CODE%TYPE;
8993: BEGIN
8994:
8995: l_region_code := SUBSTR(p_Actual_Data_Source, 1, INSTR(p_Actual_Data_Source, '.') - 1);
8996:

Line 8999: FROM ak_regions

8995: l_region_code := SUBSTR(p_Actual_Data_Source, 1, INSTR(p_Actual_Data_Source, '.') - 1);
8996:
8997: SELECT COUNT(1)
8998: INTO l_count
8999: FROM ak_regions
9000: WHERE region_code = l_region_code;
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.

Line 9804: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

9800: by Bug#4558279
9801: ********************************************/
9802:
9803: FUNCTION Is_Dim_Exist_In_Current_Region (
9804: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
9805: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
9806: ) RETURN VARCHAR2 IS
9807: l_Count NUMBER;
9808: BEGIN

Line 9805: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

9801: ********************************************/
9802:
9803: FUNCTION Is_Dim_Exist_In_Current_Region (
9804: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
9805: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
9806: ) RETURN VARCHAR2 IS
9807: l_Count NUMBER;
9808: BEGIN
9809: l_Count := 0;

Line 9846: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

9842:
9843: ********************************************/
9844:
9845: FUNCTION Is_Dim_Exist_In_Nested_Region (
9846: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
9847: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
9848: ) RETURN VARCHAR2 IS
9849: CURSOR c_Get_Nested_Region_Items IS
9850: SELECT A.NESTED_REGION_CODE

Line 9847: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

9843: ********************************************/
9844:
9845: FUNCTION Is_Dim_Exist_In_Nested_Region (
9846: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
9847: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
9848: ) RETURN VARCHAR2 IS
9849: CURSOR c_Get_Nested_Region_Items IS
9850: SELECT A.NESTED_REGION_CODE
9851: ,A.NESTED_REGION_APPLICATION_ID

Line 9879: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

9875: /*******************************************
9876:
9877: ********************************************/
9878: FUNCTION Is_New_Param_Portlet_Required (
9879: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
9880: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
9881: ) RETURN VARCHAR2 IS
9882: BEGIN
9883: IF ((Is_Dim_Exist_In_Current_Region(p_Region_Code, p_Region_Application_Id) = FND_API.G_TRUE) AND

Line 9880: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

9876:
9877: ********************************************/
9878: FUNCTION Is_New_Param_Portlet_Required (
9879: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
9880: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
9881: ) RETURN VARCHAR2 IS
9882: BEGIN
9883: IF ((Is_Dim_Exist_In_Current_Region(p_Region_Code, p_Region_Application_Id) = FND_API.G_TRUE) AND
9884: (Is_Dim_Exist_In_Nested_Region(p_Region_Code,p_Region_Application_Id) = FND_API.G_TRUE)) THEN

Line 9897: , p_Param_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

9893:
9894: PROCEDURE Cascade_Parameter_Portlet (
9895: p_Commit IN VARCHAR2
9896: , p_Page_Function_Name IN VARCHAR2
9897: , p_Param_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
9898: , p_Param_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
9899: , p_Action_Type IN VARCHAR2
9900: , x_Region_Code OUT NOCOPY VARCHAR2
9901: , x_Region_Application_Id OUT NOCOPY NUMBER

Line 9898: , p_Param_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

9894: PROCEDURE Cascade_Parameter_Portlet (
9895: p_Commit IN VARCHAR2
9896: , p_Page_Function_Name IN VARCHAR2
9897: , p_Param_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
9898: , p_Param_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
9899: , p_Action_Type IN VARCHAR2
9900: , x_Region_Code OUT NOCOPY VARCHAR2
9901: , x_Region_Application_Id OUT NOCOPY NUMBER
9902: , x_Return_Status OUT NOCOPY VARCHAR2

Line 9982: , p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

9978: ********************************************/
9979:
9980: PROCEDURE Create_Parameter_Portlet (
9981: p_Commit IN VARCHAR2
9982: , p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
9983: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
9984: , x_Region_Code OUT NOCOPY VARCHAR2
9985: , x_Region_Application_Id OUT NOCOPY NUMBER
9986: , x_Return_Status OUT NOCOPY VARCHAR2

Line 9983: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

9979:
9980: PROCEDURE Create_Parameter_Portlet (
9981: p_Commit IN VARCHAR2
9982: , p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
9983: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
9984: , x_Region_Code OUT NOCOPY VARCHAR2
9985: , x_Region_Application_Id OUT NOCOPY NUMBER
9986: , x_Return_Status OUT NOCOPY VARCHAR2
9987: , x_Msg_Count OUT NOCOPY NUMBER

Line 9990: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;

9986: , x_Return_Status OUT NOCOPY VARCHAR2
9987: , x_Msg_Count OUT NOCOPY NUMBER
9988: , x_Msg_Data OUT NOCOPY VARCHAR2
9989: ) IS
9990: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
9991: l_Report_Region_Rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
9992: l_Region_Item_Tbl BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type;
9993: BEGIN
9994:

Line 10119: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

10115:
10116: -- Unrolls all the Dimension based region items into the table BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
10117: -- for any given region_code, this API all
10118: PROCEDURE Unroll_RegionItems_Into_Record (
10119: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
10120: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
10121: , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
10122: ) IS
10123:

Line 10120: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

10116: -- Unrolls all the Dimension based region items into the table BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
10117: -- for any given region_code, this API all
10118: PROCEDURE Unroll_RegionItems_Into_Record (
10119: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
10120: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
10121: , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
10122: ) IS
10123:
10124: CURSOR c_Get_Nested_Region_Items IS

Line 10176: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE

10172: END Unroll_RegionItems_Into_Record;
10173:
10174: -- gets all the region items into the PL/SQL table BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
10175: PROCEDURE Get_Non_Nested_Into_Rec (
10176: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
10177: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
10178: , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
10179: ) IS
10180: CURSOR c_NonNested IS

Line 10177: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE

10173:
10174: -- gets all the region items into the PL/SQL table BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
10175: PROCEDURE Get_Non_Nested_Into_Rec (
10176: p_Region_Code IN AK_REGIONS.REGION_CODE%TYPE
10177: , p_Region_Application_Id IN AK_REGIONS.REGION_APPLICATION_ID%TYPE
10178: , x_Region_Item_Tbl OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
10179: ) IS
10180: CURSOR c_NonNested IS
10181: SELECT

Line 10582: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;

10578: FUNCTION Is_Primary_Source_Of_Measure (
10579: p_Measure_Short_Name IN VARCHAR2
10580: , p_Region_Code IN VARCHAR2
10581: ) RETURN VARCHAR2 IS
10582: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
10583: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
10584: l_Return VARCHAR2(1);
10585: BEGIN
10586: l_Return := FND_API.G_FALSE;

Line 11583: p_region_code IN AK_REGIONS.region_code%TYPE

11579:
11580:
11581: PROCEDURE Get_Non_Time_Dim_And_DimObjs
11582: (
11583: p_region_code IN AK_REGIONS.region_code%TYPE
11584: ,x_non_time_dim_dimObjs OUT NOCOPY BSC_VARCHAR2_TBL_TYPE
11585: ,x_non_time_counter OUT NOCOPY NUMBER
11586: ) IS
11587: