APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on BSC_SYS_DIM_LEVEL_RELS

Line 1617: l_relation_type BSC_SYS_DIM_LEVEL_RELS.RELATION_TYPE%TYPE;

1613: ,x_msg_data OUT NOCOPY VARCHAR2
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;

Line 1649: -- if it is a 1 X n relationship or not related (no entries in bsc_sys_dim_level_rels)

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: */
1648: l_restrict_all_value := ' a.code <> 0';
1649: -- if it is a 1 X n relationship or not related (no entries in bsc_sys_dim_level_rels)
1650: IF (l_relation_type IS NULL OR l_relation_type = 1) THEN
1651: IF (p_dim_rel_info_rec.relation_col IS NOT NULL) THEN -- entry in bsc_sys_dim_level_rels.
1652: x_data_source := ' (SELECT a.code id, a.name value, ' || p_dim_rel_info_rec.relation_col || ' parent_id FROM '|| l_child_level_view_name || ' a WHERE ' || l_restrict_all_value || ')';
1653: x_select_string := 'SELECT id, value FROM ' || x_data_source;

Line 1651: IF (p_dim_rel_info_rec.relation_col IS NOT NULL) THEN -- entry in bsc_sys_dim_level_rels.

1647: */
1648: l_restrict_all_value := ' a.code <> 0';
1649: -- if it is a 1 X n relationship or not related (no entries in bsc_sys_dim_level_rels)
1650: IF (l_relation_type IS NULL OR l_relation_type = 1) THEN
1651: IF (p_dim_rel_info_rec.relation_col IS NOT NULL) THEN -- entry in bsc_sys_dim_level_rels.
1652: x_data_source := ' (SELECT a.code id, a.name value, ' || p_dim_rel_info_rec.relation_col || ' parent_id FROM '|| l_child_level_view_name || ' a WHERE ' || l_restrict_all_value || ')';
1653: x_select_string := 'SELECT id, value FROM ' || x_data_source;
1654: x_parent_name := 'PARENT_ID';
1655: ELSE -- only for a un-related BSC dim level - to prepare the data source similar to BIS.

Line 1805: * bsc_sys_dim_level_rels does not have WHO columns.

1801: --===================================================================
1802: /* bug# 4699787
1803: * For pre-seeded relationships, do not append the dynamic where clause
1804: * for parent-child relationship.
1805: * bsc_sys_dim_level_rels does not have WHO columns.
1806: */
1807: FUNCTION is_append_where_clause(
1808: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
1809: ,p_is_relation_recursive IN VARCHAR2

Line 2100: l_relation_type BSC_SYS_DIM_LEVEL_RELS.RELATION_TYPE%TYPE;

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;
2104: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;