APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_SYS_DIM_GROUPS_TL

Line 1818: FROM BSC_SYS_DIM_GROUPS_TL A

1814: BEGIN
1815:
1816: SELECT COUNT(1)
1817: INTO l_Has_One_Row
1818: FROM BSC_SYS_DIM_GROUPS_TL A
1819: WHERE A.SHORT_NAME = p_Param_Portlet_Region_Code
1820: AND A.LANGUAGE = USERENV('LANG');
1821:
1822: IF (l_Has_One_Row > 0) THEN

Line 2323: FROM bsc_sys_dim_groups_tl a,

2319:
2320: x_Msg_Data := BSC_APPS.Get_Message('BSC_DIP_ERR_GET_GROUP_ID');
2321: SELECT d.total_flag, d.comparison_flag, d.where_clause
2322: INTO l_total_flag, l_comparison_flag, l_where_clause
2323: FROM bsc_sys_dim_groups_tl a,
2324: bis_dimensions b,
2325: bis_levels c,
2326: bsc_sys_dim_levels_by_group d,
2327: bsc_sys_dim_levels_b e

Line 2340: FROM bsc_sys_dim_groups_tl a,

2336:
2337: x_Msg_Data := BSC_APPS.Get_Message('BSC_DIP_ERR_GET_DIM_REL');
2338: SELECT d.dim_group_id, d.dim_level_id
2339: INTO l_dim_group_id, l_dim_level_id
2340: FROM bsc_sys_dim_groups_tl a,
2341: bsc_sys_dim_levels_by_group d,
2342: bsc_sys_dim_levels_b e
2343: WHERE d.dim_group_id = a.dim_group_id
2344: AND a.short_name = p_dim_object_short_name

Line 3492: p_Short_Name Corresponds to BSC_SYS_DIM_GROUPS_TL.Short_Name

3488:
3489: This function assumes the Short_Name passed is valid and exists in
3490: BSC Metadata. It will not be checked from BSC tables due to performance reasons.
3491:
3492: p_Short_Name Corresponds to BSC_SYS_DIM_GROUPS_TL.Short_Name
3493: */
3494: FUNCTION is_KPI_EndToEnd_Dimension(p_Short_Name VARCHAR2)
3495: RETURN VARCHAR2 IS
3496: l_Count NUMBER;

Line 4505: FROM BSC_SYS_DIM_GROUPS_TL A,

4501: CURSOR c_Get_Prop_Dim IS
4502: SELECT D.TOTAL_FLAG,
4503: D.COMPARISON_FLAG,
4504: D.WHERE_CLAUSE
4505: FROM BSC_SYS_DIM_GROUPS_TL A,
4506: BIS_DIMENSIONS B,
4507: BIS_LEVELS C,
4508: BSC_SYS_DIM_LEVELS_BY_GROUP D,
4509: BSC_SYS_DIM_LEVELS_B E

Line 4926: l_Dimension_Short_Name BSC_SYS_DIM_GROUPS_TL.SHORT_NAME%TYPE;

4922: l_Is_From_Report_Designer BOOLEAN;
4923: l_Key_Short_Name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
4924: l_Anal_Opt_Rec APPS.BSC_ANALYSIS_OPTION_PUB.BSC_OPTION_REC_TYPE;
4925: x_Anal_Opt_Rec APPS.BSC_ANALYSIS_OPTION_PUB.BSC_OPTION_REC_TYPE;
4926: l_Dimension_Short_Name BSC_SYS_DIM_GROUPS_TL.SHORT_NAME%TYPE;
4927: l_Is_XTD_Enabled VARCHAR2(1);
4928: l_Bsc_Measure_Id NUMBER;
4929: l_Measure_Source BSC_SYS_MEASURES.SOURCE%TYPE;
4930: l_Returned_Kpi_Id NUMBER;