DBA Data[Home] [Help]

APPS.BIS_UTIL dependencies on BIS_PMV_BSC_API_PUB

Line 1686: /*This function uses PMV Function BIS_PMV_BSC_API_PUB.Get_DimLevel_Viewby to retrieve Dimension Short Name

1682: x_msg_data := SQLERRM || ' at BIS_UTIL.get_parent_objects';
1683: END IF;
1684: END get_parent_objects;
1685:
1686: /*This function uses PMV Function BIS_PMV_BSC_API_PUB.Get_DimLevel_Viewby to retrieve Dimension Short Name
1687: Values in ATTRIBUTE2 of AK_REGION_ITEMS */
1688:
1689: FUNCTION get_dims_for_region(
1690: x_RegionCode IN VARCHAR2

Line 1694: l_DimObj_ViewBy_Tbl BIS_PMV_BSC_API_PUB.DimLevel_Viewby_Tbl_Type;

1690: x_RegionCode IN VARCHAR2
1691: )
1692: RETURN VARCHAR2 IS
1693:
1694: l_DimObj_ViewBy_Tbl BIS_PMV_BSC_API_PUB.DimLevel_Viewby_Tbl_Type;
1695: l_return_status VARCHAR2(10);
1696: l_msg_count NUMBER;
1697: l_msg_data VARCHAR2(255);
1698: l_Dim_Value VARCHAR(1000) := NULL;

Line 1703: BIS_PMV_BSC_API_PUB.Get_DimLevel_Viewby(

1699: l_dimension BIS_DIMENSIONS.SHORT_NAME%TYPE;
1700:
1701: BEGIN
1702:
1703: BIS_PMV_BSC_API_PUB.Get_DimLevel_Viewby(
1704: p_api_version => 1
1705: , p_Region_Code => x_RegionCode
1706: , p_Measure_Short_Name => NULL
1707: , x_DimLevel_Viewby_Tbl => l_DimObj_ViewBy_Tbl