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.BIS_PMF_GET_DIMLEVELS_PVT dependencies on BSC_SYS_DIM_LEVELS_B

Line 250: ,x_child_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE

246: PROCEDURE Get_Bsc_Dim_Obj_details
247: (
248: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
249: ,p_region_code IN ak_regions.region_code%TYPE
250: ,x_child_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
251: ,x_child_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
252: ,x_parent_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
253: ,x_parent_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
254: ,x_return_status OUT NOCOPY VARCHAR2

Line 251: ,x_child_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE

247: (
248: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
249: ,p_region_code IN ak_regions.region_code%TYPE
250: ,x_child_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
251: ,x_child_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
252: ,x_parent_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
253: ,x_parent_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
254: ,x_return_status OUT NOCOPY VARCHAR2
255: ,x_msg_count OUT NOCOPY NUMBER

Line 252: ,x_parent_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE

248: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
249: ,p_region_code IN ak_regions.region_code%TYPE
250: ,x_child_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
251: ,x_child_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
252: ,x_parent_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
253: ,x_parent_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
254: ,x_return_status OUT NOCOPY VARCHAR2
255: ,x_msg_count OUT NOCOPY NUMBER
256: ,x_msg_data OUT NOCOPY VARCHAR2

Line 253: ,x_parent_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE

249: ,p_region_code IN ak_regions.region_code%TYPE
250: ,x_child_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
251: ,x_child_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
252: ,x_parent_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
253: ,x_parent_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
254: ,x_return_status OUT NOCOPY VARCHAR2
255: ,x_msg_count OUT NOCOPY NUMBER
256: ,x_msg_data OUT NOCOPY VARCHAR2
257:

Line 876: FROM bis_levels lvl, bis_dimensions dim, bsc_sys_dim_levels_b bscdl

872: )
873: IS
874: CURSOR c_dimlvls IS
875: SELECT lvl.short_name, dim.short_name, lvl.level_values_view_name, bscdl.source, bscdl.level_view_name
876: FROM bis_levels lvl, bis_dimensions dim, bsc_sys_dim_levels_b bscdl
877: WHERE lvl.dimension_id = dim.dimension_id AND
878: (lvl.short_name = p_dim_level_name AND p_dim_level_name IS NOT NULL)
879: AND bscdl.short_name = lvl.short_name
880: ;

Line 1325: l_is_pmf_bsc_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;

1321: l_bis_source bis_levels.source%TYPE;
1322: l_is_relationship_found VARCHAR2(10);
1323: l_dim_level_short_name VARCHAR2(80);
1324: l_dim_rel_info_rec bis_pmf_get_dimlevels_pub.dim_rel_info_rec;
1325: l_is_pmf_bsc_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;
1326: l_dim_un_rel_info_rec bis_pmf_get_dimlevels_pub.dim_rel_info_rec;
1327: BEGIN
1328: x_return_status := FND_API.G_RET_STS_SUCCESS;
1329: l_bis_source := p_bis_source;

Line 1450: l_is_pmf_bsc_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;

1446: ,x_msg_count OUT NOCOPY NUMBER
1447: ,x_msg_data OUT NOCOPY VARCHAR2
1448: )
1449: IS
1450: l_is_pmf_bsc_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;
1451: BEGIN
1452: x_return_status := FND_API.G_RET_STS_SUCCESS;
1453:
1454: l_is_pmf_bsc_source := get_dim_level_source (p_dim_rel_info_rec.dimension_level_short_name);

Line 1618: l_child_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;

1614: )
1615: IS
1616:
1617: l_relation_type BSC_SYS_DIM_LEVEL_RELS.RELATION_TYPE%TYPE;
1618: l_child_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
1619: l_child_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
1620: l_parent_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
1621: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
1622: l_restrict_all_value VARCHAR2(100);

Line 1619: l_child_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;

1615: IS
1616:
1617: l_relation_type BSC_SYS_DIM_LEVEL_RELS.RELATION_TYPE%TYPE;
1618: l_child_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
1619: l_child_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
1620: l_parent_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
1621: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
1622: l_restrict_all_value VARCHAR2(100);
1623:

Line 1620: l_parent_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;

1616:
1617: l_relation_type BSC_SYS_DIM_LEVEL_RELS.RELATION_TYPE%TYPE;
1618: l_child_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
1619: l_child_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
1620: l_parent_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
1621: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
1622: l_restrict_all_value VARCHAR2(100);
1623:
1624: BEGIN

Line 1621: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;

1617: l_relation_type BSC_SYS_DIM_LEVEL_RELS.RELATION_TYPE%TYPE;
1618: l_child_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
1619: l_child_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
1620: l_parent_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
1621: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
1622: l_restrict_all_value VARCHAR2(100);
1623:
1624: BEGIN
1625:

Line 1643: /* PMV appends "All" based on All enabled/disabled (bsc_sys_dim_levels_by_group.total_flag.

1639: );
1640: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: END IF;
1643: /* PMV appends "All" based on All enabled/disabled (bsc_sys_dim_levels_by_group.total_flag.
1644: * In PMF views (level_values_view_name), All is not present (or restricted by product team where clause).
1645: * In BSC views (level_view_name), All is always present with code as 0. This needs to be filtered out so that
1646: * PMV can continue the same logic irrespective of a PMF or BSC dim level.
1647: */

Line 2021: * Returns the source from bsc_sys_dim_levels_b table, given the

2017: END get_oltp_edw_cols;
2018:
2019: --===================================================================
2020: /**
2021: * Returns the source from bsc_sys_dim_levels_b table, given the
2022: * dim level short name
2023: */
2024: ----=================================================================
2025: FUNCTION get_dim_level_source (

Line 2029: l_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;

2025: FUNCTION get_dim_level_source (
2026: p_dim_level_short_name IN VARCHAR2
2027: ) RETURN VARCHAR2
2028: IS
2029: l_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;
2030: CURSOR c_dim_source(cp_dimLevelName IN VARCHAR2) IS
2031: SELECT source
2032: FROM bsc_sys_dim_levels_b
2033: WHERE short_name = cp_dimLevelName ;

Line 2032: FROM bsc_sys_dim_levels_b

2028: IS
2029: l_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;
2030: CURSOR c_dim_source(cp_dimLevelName IN VARCHAR2) IS
2031: SELECT source
2032: FROM bsc_sys_dim_levels_b
2033: WHERE short_name = cp_dimLevelName ;
2034: BEGIN
2035:
2036: IF ( c_dim_source%ISOPEN) THEN

Line 2065: ,x_child_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE

2061: PROCEDURE Get_Bsc_Dim_Obj_details
2062: (
2063: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
2064: ,p_region_code IN ak_regions.region_code%TYPE
2065: ,x_child_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
2066: ,x_child_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
2067: ,x_parent_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
2068: ,x_parent_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
2069: ,x_return_status OUT NOCOPY VARCHAR2

Line 2066: ,x_child_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE

2062: (
2063: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
2064: ,p_region_code IN ak_regions.region_code%TYPE
2065: ,x_child_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
2066: ,x_child_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
2067: ,x_parent_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
2068: ,x_parent_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
2069: ,x_return_status OUT NOCOPY VARCHAR2
2070: ,x_msg_count OUT NOCOPY NUMBER

Line 2067: ,x_parent_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE

2063: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
2064: ,p_region_code IN ak_regions.region_code%TYPE
2065: ,x_child_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
2066: ,x_child_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
2067: ,x_parent_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
2068: ,x_parent_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
2069: ,x_return_status OUT NOCOPY VARCHAR2
2070: ,x_msg_count OUT NOCOPY NUMBER
2071: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2068: ,x_parent_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE

2064: ,p_region_code IN ak_regions.region_code%TYPE
2065: ,x_child_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
2066: ,x_child_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
2067: ,x_parent_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
2068: ,x_parent_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
2069: ,x_return_status OUT NOCOPY VARCHAR2
2070: ,x_msg_count OUT NOCOPY NUMBER
2071: ,x_msg_data OUT NOCOPY VARCHAR2
2072:

Line 2074: CURSOR c_bsc_level_metadata(cp_dimlevelSN IN BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE) IS

2070: ,x_msg_count OUT NOCOPY NUMBER
2071: ,x_msg_data OUT NOCOPY VARCHAR2
2072:
2073: ) IS
2074: CURSOR c_bsc_level_metadata(cp_dimlevelSN IN BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE) IS
2075: SELECT level_pk_col
2076: ,level_view_name
2077: FROM bsc_sys_dim_levels_vl
2078: WHERE short_name = cp_dimlevelSN;

Line 2098: l_dimlevel_short_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;

2094: FROM bsc_kpis_b
2095: WHERE short_name = p_region_code;
2096:
2097:
2098: l_dimlevel_short_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;
2099: l_parent_dimlevel_short_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;
2100: l_relation_type BSC_SYS_DIM_LEVEL_RELS.RELATION_TYPE%TYPE;
2101: l_child_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
2102: l_child_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;

Line 2099: l_parent_dimlevel_short_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;

2095: WHERE short_name = p_region_code;
2096:
2097:
2098: l_dimlevel_short_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;
2099: l_parent_dimlevel_short_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;
2100: l_relation_type BSC_SYS_DIM_LEVEL_RELS.RELATION_TYPE%TYPE;
2101: l_child_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
2102: l_child_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
2103: l_parent_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;

Line 2101: l_child_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;

2097:
2098: l_dimlevel_short_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;
2099: l_parent_dimlevel_short_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;
2100: l_relation_type BSC_SYS_DIM_LEVEL_RELS.RELATION_TYPE%TYPE;
2101: l_child_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
2102: l_child_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
2103: l_parent_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
2104: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
2105: l_restrict_all_value VARCHAR2(100);

Line 2102: l_child_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;

2098: l_dimlevel_short_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;
2099: l_parent_dimlevel_short_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;
2100: l_relation_type BSC_SYS_DIM_LEVEL_RELS.RELATION_TYPE%TYPE;
2101: l_child_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
2102: l_child_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
2103: l_parent_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
2104: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
2105: l_restrict_all_value VARCHAR2(100);
2106:

Line 2103: l_parent_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;

2099: l_parent_dimlevel_short_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;
2100: l_relation_type BSC_SYS_DIM_LEVEL_RELS.RELATION_TYPE%TYPE;
2101: l_child_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
2102: l_child_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
2103: l_parent_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
2104: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
2105: l_restrict_all_value VARCHAR2(100);
2106:
2107: l_region_code ak_regions.region_code%TYPE;

Line 2104: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;

2100: l_relation_type BSC_SYS_DIM_LEVEL_RELS.RELATION_TYPE%TYPE;
2101: l_child_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
2102: l_child_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
2103: l_parent_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
2104: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
2105: l_restrict_all_value VARCHAR2(100);
2106:
2107: l_region_code ak_regions.region_code%TYPE;
2108: l_indicator bsc_kpis_b.indicator%TYPE;