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 BSC_UTILITY

Line 301: , p_Action_Type => BSC_UTILITY.C_CREATE

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)
301: , p_Action_Type => BSC_UTILITY.C_CREATE
302: , x_Region_Code => l_Param_Region_Code
303: , x_Region_Application_Id => l_Param_Region_Application_Id
304: , x_Return_Status => x_Return_Status
305: , x_Msg_Count => x_Msg_Count

Line 1447: --DBMS_OUTPUT.PUT_LINE('region_code = ' || BSC_UTILITY.C_BSC_UNDERSCORE || p_kpi_id);

1443: ,x_msg_count => x_msg_count
1444: ,x_msg_data => x_msg_data
1445: );
1446:
1447: --DBMS_OUTPUT.PUT_LINE('region_code = ' || BSC_UTILITY.C_BSC_UNDERSCORE || p_kpi_id);
1448: --DBMS_OUTPUT.PUT_LINE('return_status_for dim_ak_region_item = ' || x_return_status);
1449:
1450: END Create_Dim_Level_Region_Item;
1451:

Line 2477: --DBMS_OUTPUT.PUT_LINE('region_code = ' || BSC_UTILITY.C_BSC_UNDERSCORE || p_kpi_id);

2473: IF (x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
2474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2475: END IF;
2476:
2477: --DBMS_OUTPUT.PUT_LINE('region_code = ' || BSC_UTILITY.C_BSC_UNDERSCORE || p_kpi_id);
2478: --DBMS_OUTPUT.PUT_LINE('return_status_for measure_region_item = ' || x_return_status);
2479: EXCEPTION
2480: WHEN FND_API.G_EXC_ERROR THEN
2481: IF (x_msg_data IS NULL) THEN

Line 3148: x_Kpi_Id := SUBSTR(p_Region_Code, (LENGTH(BSC_UTILITY.C_BSC_UNDERSCORE)+1), (INSTR(p_Region_Code, '_', '5') - (LENGTH(BSC_UTILITY.C_BSC_UNDERSCORE)+1)));

3144: x_Kpi_Id := -1;
3145: x_Analysis_Option_Id := -1;
3146:
3147: IF p_Region_Code IS NOT NULL THEN
3148: x_Kpi_Id := SUBSTR(p_Region_Code, (LENGTH(BSC_UTILITY.C_BSC_UNDERSCORE)+1), (INSTR(p_Region_Code, '_', '5') - (LENGTH(BSC_UTILITY.C_BSC_UNDERSCORE)+1)));
3149: x_Analysis_Option_Id := SUBSTR(p_Region_Code, (INSTR(p_Region_Code, '_', '5')+1)) ;
3150: END IF;
3151:
3152: END Get_KPI_AO_From_Region;

Line 3163: IF (NVL(INSTR(SUBSTR(p_Region_Code, LENGTH(BSC_UTILITY.C_BSC_UNDERSCORE)+1), '_'), -1) > 0) THEN

3159: FUNCTION has_Region_Per_Measure (
3160: p_Region_Code IN VARCHAR2
3161: ) RETURN BOOLEAN IS
3162: BEGIN
3163: IF (NVL(INSTR(SUBSTR(p_Region_Code, LENGTH(BSC_UTILITY.C_BSC_UNDERSCORE)+1), '_'), -1) > 0) THEN
3164: RETURN TRUE;
3165: ELSE
3166: RETURN FALSE;
3167: END IF;

Line 3560: l_appended := BSC_UTILITY.get_Next_DispName(l_appended);

3556: l_temp1 := SUBSTR(l_short_name, 1, (l_len1-(LENGTH(l_Append_String)+2)));
3557: l_appended := l_temp1;
3558:
3559: WHILE (l_exist_cnt <> 0) LOOP
3560: l_appended := BSC_UTILITY.get_Next_DispName(l_appended);
3561: l_temp2 := REPLACE(l_appended , ' ', '_');
3562: l_Final_String := l_temp2 || l_Append_String;
3563:
3564: SELECT COUNT(1) INTO l_exist_cnt

Line 5003: IF (BSC_UTILITY.Is_Adv_Summarization_Enabled = FND_API.G_FALSE) THEN

4999: -- This is fix for Bug#4327887
5000: -- Check if AS_OF_DATE is enabled at the Paramter Portlet
5001: IF ((is_XTD_Enabled(p_Param_Portlet_Region_Code) = FND_API.G_TRUE) OR (l_Is_From_Report_Designer)) THEN
5002: -- Check if Advance Summarization Profile > 1, else throw and error.
5003: IF (BSC_UTILITY.Is_Adv_Summarization_Enabled = FND_API.G_FALSE) THEN
5004: FND_MESSAGE.SET_NAME('BSC','BSC_ENABLE_ADV_SUMMARIZATION');
5005: FND_MSG_PUB.ADD;
5006: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5007: END IF;

Line 5354: IF (BSC_UTILITY.Is_Measure_Seeded(p_Measure_Short_Name) = FND_API.G_FALSE AND BSC_UTILITY.is_Calculated_kpi(p_Measure_Short_Name)= FND_API.G_FALSE) THEN

5350: -- Passed AK type and AK source (pl/sql), since they were getting updated to null
5351: -- modified condition for Bug#4599432
5352:
5353:
5354: IF (BSC_UTILITY.Is_Measure_Seeded(p_Measure_Short_Name) = FND_API.G_FALSE AND BSC_UTILITY.is_Calculated_kpi(p_Measure_Short_Name)= FND_API.G_FALSE) THEN
5355:
5356: BSC_BIS_MEASURE_PUB.Update_Measure(
5357: p_Commit => p_Commit
5358: ,p_Dataset_Id => l_Dataset_Id

Line 6464: l_Region_Code := BSC_UTILITY.C_BSC_UNDERSCORE || p_Kpi_Id || '_' || l_Next_Analysis_Option;

6460: WHERE INDICATOR = p_Kpi_Id
6461: AND ANALYSIS_GROUP_ID = NVL(p_Analysis_Group0, 0);
6462:
6463:
6464: l_Region_Code := BSC_UTILITY.C_BSC_UNDERSCORE || p_Kpi_Id || '_' || l_Next_Analysis_Option;
6465:
6466: RETURN l_Region_Code;
6467:
6468: EXCEPTION

Line 7128: IF (BSC_UTILITY.Is_Adv_Summarization_Enabled = FND_API.G_FALSE) THEN

7124:
7125: -- Check if AS_OF_DATE is enabled at the Paramter Portlet
7126: IF (is_XTD_Enabled(p_Param_Portlet_Region_Code) = FND_API.G_TRUE) THEN
7127: -- Check if Advance Summarization Profile >= 0, else throw and error.
7128: IF (BSC_UTILITY.Is_Adv_Summarization_Enabled = FND_API.G_FALSE) THEN
7129: FND_MESSAGE.SET_NAME('BSC','BSC_ENABLE_ADV_SUMMARIZATION');
7130: FND_MSG_PUB.ADD;
7131: RAISE FND_API.G_EXC_ERROR;
7132: END IF;

Line 9907: IF(p_Action_Type = BSC_UTILITY.c_CREATE) THEN

9903: , x_Msg_Count OUT NOCOPY NUMBER
9904: , x_Msg_Data OUT NOCOPY VARCHAR2
9905: ) IS
9906: BEGIN
9907: IF(p_Action_Type = BSC_UTILITY.c_CREATE) THEN
9908: IF (Is_Dim_Exist_In_Nested_Region(
9909: p_Param_Region_Code,
9910: p_Param_Region_Application_Id
9911: ) = FND_API.G_TRUE) THEN

Line 9934: ELSIF (p_Action_Type = BSC_UTILITY.c_UPDATE) THEN

9930: ELSE
9931: x_Region_Code := p_Param_Region_Code;
9932: x_Region_Application_Id := p_Param_Region_Application_Id;
9933: END IF;
9934: ELSIF (p_Action_Type = BSC_UTILITY.c_UPDATE) THEN
9935: x_Region_Code := Get_Param_Portlet_By_Dashboard(p_Page_Function_Name);
9936: x_Region_Application_Id := Get_Region_Application_Id(x_Region_Code);
9937: ELSIF (p_Action_Type = BSC_UTILITY.c_DELETE) THEN
9938: x_Region_Code := Get_Param_Portlet_By_Dashboard(p_Page_Function_Name);

Line 9937: ELSIF (p_Action_Type = BSC_UTILITY.c_DELETE) THEN

9933: END IF;
9934: ELSIF (p_Action_Type = BSC_UTILITY.c_UPDATE) THEN
9935: x_Region_Code := Get_Param_Portlet_By_Dashboard(p_Page_Function_Name);
9936: x_Region_Application_Id := Get_Region_Application_Id(x_Region_Code);
9937: ELSIF (p_Action_Type = BSC_UTILITY.c_DELETE) THEN
9938: x_Region_Code := Get_Param_Portlet_By_Dashboard(p_Page_Function_Name);
9939: x_Region_Application_Id := Get_Region_Application_Id(x_Region_Code);
9940: END IF;
9941: EXCEPTION

Line 10362: l_Old_Attribute_Code_App_Ids BSC_UTILITY.Varchar_Tabletype;

10358: , x_Return_Status OUT NOCOPY VARCHAR
10359: , x_Msg_Count OUT NOCOPY NUMBER
10360: , x_Msg_Data OUT NOCOPY VARCHAR
10361: ) IS
10362: l_Old_Attribute_Code_App_Ids BSC_UTILITY.Varchar_Tabletype;
10363: l_Old_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;
10364: l_New_Attribute_Code_App_Ids BSC_UTILITY.Varchar_Tabletype;
10365: l_New_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;
10366: l_Count_Old_App_Ids NUMBER;

Line 10363: l_Old_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;

10359: , x_Msg_Count OUT NOCOPY NUMBER
10360: , x_Msg_Data OUT NOCOPY VARCHAR
10361: ) IS
10362: l_Old_Attribute_Code_App_Ids BSC_UTILITY.Varchar_Tabletype;
10363: l_Old_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;
10364: l_New_Attribute_Code_App_Ids BSC_UTILITY.Varchar_Tabletype;
10365: l_New_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;
10366: l_Count_Old_App_Ids NUMBER;
10367: l_Count_Old_Attribute_Codes NUMBER;

Line 10364: l_New_Attribute_Code_App_Ids BSC_UTILITY.Varchar_Tabletype;

10360: , x_Msg_Data OUT NOCOPY VARCHAR
10361: ) IS
10362: l_Old_Attribute_Code_App_Ids BSC_UTILITY.Varchar_Tabletype;
10363: l_Old_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;
10364: l_New_Attribute_Code_App_Ids BSC_UTILITY.Varchar_Tabletype;
10365: l_New_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;
10366: l_Count_Old_App_Ids NUMBER;
10367: l_Count_Old_Attribute_Codes NUMBER;
10368: l_Count_New_App_Ids NUMBER;

Line 10365: l_New_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;

10361: ) IS
10362: l_Old_Attribute_Code_App_Ids BSC_UTILITY.Varchar_Tabletype;
10363: l_Old_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;
10364: l_New_Attribute_Code_App_Ids BSC_UTILITY.Varchar_Tabletype;
10365: l_New_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;
10366: l_Count_Old_App_Ids NUMBER;
10367: l_Count_Old_Attribute_Codes NUMBER;
10368: l_Count_New_App_Ids NUMBER;
10369: l_Count_New_Attribute_Codes NUMBER;

Line 10661: IF (BSC_UTILITY.Is_Measure_Seeded(l_Measure_Short_Name) = FND_API.G_FALSE AND

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
10664:
10665: FOR cMP IN cMeasureProperties LOOP

Line 10785: l_Old_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;

10781: l_char VARCHAR2(1);
10782: l_Formula_Temp VARCHAR2(2000);
10783: l_Comma_Old_Attribute_Codes VARCHAR2(2000);
10784: l_Comma_New_Attribute_Codes VARCHAR2(2000);
10785: l_Old_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;
10786: l_New_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;
10787: l_Count1 NUMBER;
10788: l_Count2 NUMBER;
10789:

Line 10786: l_New_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;

10782: l_Formula_Temp VARCHAR2(2000);
10783: l_Comma_Old_Attribute_Codes VARCHAR2(2000);
10784: l_Comma_New_Attribute_Codes VARCHAR2(2000);
10785: l_Old_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;
10786: l_New_Attribute_Codes BSC_UTILITY.Varchar_Tabletype;
10787: l_Count1 NUMBER;
10788: l_Count2 NUMBER;
10789:
10790: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

Line 10806: BSC_UTILITY.Parse_String

10802:
10803: l_Comma_Old_Attribute_Codes := p_Old_Attribute_Codes;
10804: l_Comma_New_Attribute_Codes := p_New_Attribute_Codes;
10805:
10806: BSC_UTILITY.Parse_String
10807: (
10808: p_List => l_Comma_Old_Attribute_Codes
10809: , p_Separator => ','
10810: , p_List_Data => l_Old_Attribute_Codes

Line 10814: BSC_UTILITY.Parse_String

10810: , p_List_Data => l_Old_Attribute_Codes
10811: , p_List_number => l_Count1
10812: );
10813:
10814: BSC_UTILITY.Parse_String
10815: (
10816: p_List => l_Comma_New_Attribute_Codes
10817: , p_Separator => ','
10818: , p_List_Data => l_New_Attribute_Codes