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_BIS_CUSTOM_KPI_UTIL_PUB

Line 161: REM | BSC_BIS_CUSTOM_KPI_UTIL_PUB since pure BIS can use it too. |

157: REM | as required by Bug#4558279 |
158: REM | 23-SEP-2005 akoduri Bug #4389280 Removing all the measures from |
159: REM | an AG Report is not showing warning |
160: REM | 26-SEP-2005 arhegde bug# 4624100 Moved get_format_mask code to |
161: REM | BSC_BIS_CUSTOM_KPI_UTIL_PUB since pure BIS can use it too. |
162: REM | 28-SEP-2005 akoduri Bug #4626935 Unchecking all the periodicities|
163: REM | is not updating bsc_kpi_periodicities |
164: REM | 26-SEP-2005 ashankar Bug#4619367 Made chnages to the following API|
165: REM | 1.Has_Time_Dim_Obj_Changed |

Line 312: l_User_Page_Name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(p_Page_Function_Name);

308: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
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:

Line 313: l_User_Portlet_Name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(p_Kpi_Portlet_Function_Name);

309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
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(

Line 391: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(l_Kpi_Id, -1);

387: END IF;
388: ELSE
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:

Line 542: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code (l_Kpi_Id ,l_AO_Id);

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(
546: p_Param_Portlet_Region_Code => BSC_BIS_KPI_CRUD_PUB.Get_Param_Portlet_By_Region(l_Region_Code)

Line 903: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(l_Kpi_Id, l_Analysis_Option_Id);

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
902: l_Analysis_Option_Id := Get_AO_Id_By_Measure (l_Kpi_Id, l_Dataset_Id);
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);

Line 923: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(l_Kpi_Id, NULL);

919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
920: END IF;
921:
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:

Line 1002: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(l_Kpi_Id, l_Analysis_Option_Id);

998: -- Delete the Measure Metadata
999: --DBMS_OUTPUT.PUT_LINE('Outside Delete_Measure_Region_Item' );
1000: IF(has_Measure_AK_Region(l_Kpi_Id, l_Dataset_Id)) THEN
1001: l_Analysis_Option_Id := Get_AO_Id_By_Measure (l_Kpi_Id, l_Dataset_Id);
1002: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(l_Kpi_Id, l_Analysis_Option_Id);
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:

Line 1004: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(l_Kpi_Id, NULL); -- Tyep BSC_

1000: IF(has_Measure_AK_Region(l_Kpi_Id, l_Dataset_Id)) THEN
1001: l_Analysis_Option_Id := Get_AO_Id_By_Measure (l_Kpi_Id, l_Dataset_Id);
1002: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(l_Kpi_Id, l_Analysis_Option_Id);
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

Line 1430: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(

1426: x_sequence := x_sequence + 10;
1427:
1428: END LOOP;
1429:
1430: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(
1431: p_Kpi_Id => p_kpi_id,
1432: p_AO_Id => p_Analysis_Option
1433: );
1434:

Line 1751: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(p_Kpi_Id, p_Analysis_Option);

1747: l_Region_Code VARCHAR2(80);
1748:
1749: BEGIN
1750:
1751: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(p_Kpi_Id, p_Analysis_Option);
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;

Line 2277: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(

2273: );
2274: END IF;
2275:
2276:
2277: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(
2278: p_Kpi_Id => p_kpi_id,
2279: p_AO_Id => l_Analysis_Option
2280: );
2281:

Line 2412: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.get_Region_Code (p_Kpi_Id, p_Analysis_Option);

2408:
2409: --DBMS_OUTPUT.PUT_LINE( 'measure sequence = ' || p_sequence_number);
2410: -- Currently we cannot use Column Span Bug#3688263, its not supported.
2411:
2412: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.get_Region_Code (p_Kpi_Id, p_Analysis_Option);
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

Line 2958: l_report_region_rec.Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(

2954:
2955: --DBMS_OUTPUT.PUT_LINE('p_Kpi_Id = ' || p_Kpi_Id);
2956: --DBMS_OUTPUT.PUT_LINE('p_Analysis_Option_Id = ' || p_Analysis_Option_Id);
2957:
2958: l_report_region_rec.Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(
2959: p_Kpi_Id => p_Kpi_Id,
2960: p_AO_Id => p_Analysis_Option_Id
2961: );
2962: --DBMS_OUTPUT.PUT_LINE('l_report_region_rec.Region_Code = ' || l_report_region_rec.Region_Code);

Line 3056: l_report_region_rec.Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(

3052:
3053: BEGIN
3054:
3055:
3056: l_report_region_rec.Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(
3057: p_Kpi_Id => p_Kpi_Id,
3058: p_AO_Id => p_Analysis_Option_Id
3059: );
3060: l_report_region_rec.Region_Name := p_Region_Name;

Line 3213: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(p_Kpi_Id, l_Analysis_Option);

3209:
3210: BEGIN
3211:
3212: l_Analysis_Option := Get_AO_Id_By_Measure(p_Kpi_Id, p_Dataset_Id);
3213: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(p_Kpi_Id, l_Analysis_Option);
3214:
3215: IF is_Valid_Region_Code(l_Region_Code) THEN
3216: RETURN TRUE;
3217: ELSE

Line 3285: RETURN BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Format_Mask(p_Format_Id);

3281: FUNCTION Get_Format_Mask (
3282: p_Format_Id NUMBER
3283: ) RETURN VARCHAR2 IS
3284: BEGIN
3285: RETURN BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Format_Mask(p_Format_Id);
3286: END Get_Format_Mask;
3287:
3288:
3289: PROCEDURE Create_Nested_Region_Item(

Line 4714: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(p_Kpi_Id, p_Analysis_Option_Id);

4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: END IF;
4712:
4713:
4714: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(p_Kpi_Id, p_Analysis_Option_Id);
4715: --DBMS_OUTPUT.PUT_LINE('Region Code - ' || l_Region_Code);
4716:
4717: -- Create a Nested Region Item for a Parameter Portlet Region.
4718: l_Max_Seq_Number := Find_Max_Seq_Of_Region_Item(l_Region_Code);

Line 5065: l_User_Page_Report_Name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(l_Key_Short_Name);

5061:
5062: --DBMS_OUTPUT.PUT_LINE('STAGE 2');
5063:
5064: -- Get the User DBI Page name to be populated into Scorecards (a.k.a Tabs)
5065: l_User_Page_Report_Name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(l_Key_Short_Name);
5066:
5067: IF(p_Obj_Tab_Id IS NOT NULL) THEN
5068: l_tab_name := Get_Tab_Name(p_Obj_Tab_Id);
5069: ELSE

Line 5070: l_tab_name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Unqiue_Tab_Name(l_User_Page_Report_Name);

5066:
5067: IF(p_Obj_Tab_Id IS NOT NULL) THEN
5068: l_tab_name := Get_Tab_Name(p_Obj_Tab_Id);
5069: ELSE
5070: l_tab_name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Unqiue_Tab_Name(l_User_Page_Report_Name);
5071: END IF;
5072:
5073: IF(p_Obj_Grp_Id IS NOT NULL)THEN
5074: l_group_name := Get_Objective_Group_Name(p_Obj_Grp_Id);

Line 5076: l_group_name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Unqiue_Tab_Group_Name(l_User_Page_Report_Name);

5072:
5073: IF(p_Obj_Grp_Id IS NOT NULL)THEN
5074: l_group_name := Get_Objective_Group_Name(p_Obj_Grp_Id);
5075: ELSE
5076: l_group_name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Unqiue_Tab_Group_Name(l_User_Page_Report_Name);
5077: END IF;
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:

Line 5079: l_User_Portlet_Name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(p_Kpi_Portlet_Function_Name);

5075: ELSE
5076: l_group_name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Unqiue_Tab_Group_Name(l_User_Page_Report_Name);
5077: END IF;
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

Line 5932: l_Region_Code := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Region_Code(p_Kpi_Id, (cRefresh.ANALYSIS_OPTION0)+1);

5928: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
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

Line 6824: FND_MESSAGE.SET_TOKEN('DEP_OBJECT',BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(l_Parent_Obj_Table(l_Index_Count).Object_Name));

6820: l_Trigger_Exception := TRUE;
6821:
6822: END IF;
6823:
6824: FND_MESSAGE.SET_TOKEN('DEP_OBJECT',BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(l_Parent_Obj_Table(l_Index_Count).Object_Name));
6825: l_Dep_Message := '

'||FND_MESSAGE.GET || '

';
6826:
6827:
6828: IF (LENGTH(l_Message||l_Dep_Message) >= l_Msg_Max_Count_Size) THEN