APPS.FEM_DIMENSION_UTIL_PKG dependencies on FEM_DIMENSIONS_TL

Line 1118: v_dim_name FEM_DIMENSIONS_TL.dimension_name%TYPE;

1114:
1115: v_base_dimgrp_id FEM_CAL_PERIODS_B.calendar_id%TYPE;
1116: v_base_calendar_id FEM_CAL_PERIODS_B.dimension_group_id%TYPE;
1117: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
1118: v_dim_name FEM_DIMENSIONS_TL.dimension_name%TYPE;
1119: v_dim_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
1120: v_dim_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;
1121: v_cal_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
1122: v_cal_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;

Line 2307: FROM fem_dimensions_tl

2303: THEN
2304: BEGIN
2305: SELECT dimension_name
2306: INTO v_dim_name
2307: FROM fem_dimensions_tl
2308: WHERE dimension_id = p_dim_id
2309: AND language = userenv('LANG');
2310: EXCEPTION
2311: WHEN no_data_found THEN

Line 2435: FROM fem_dimensions_tl

2431: THEN
2432: BEGIN
2433: SELECT dimension_name
2434: INTO v_dim_name
2435: FROM fem_dimensions_tl
2436: WHERE dimension_id = p_dim_id
2437: AND language = userenv('LANG');
2438: EXCEPTION
2439: WHEN no_data_found THEN

Line 9082: FROM fem_dimensions_tl

9078: BEGIN
9079:
9080: SELECT dimension_name
9081: INTO v_dim_name
9082: FROM fem_dimensions_tl
9083: WHERE dimension_id = p_dim_id
9084: AND language = userenv('LANG');
9085:
9086: RETURN v_dim_name;

Line 9105: fem_dimensions_tl T

9101:
9102: SELECT T.dimension_name
9103: INTO v_dim_name
9104: FROM fem_dimensions_b B,
9105: fem_dimensions_tl T
9106: WHERE B.dimension_varchar_label = p_dim_label
9107: AND T.dimension_id = B.dimension_id
9108: AND T.language = userenv('LANG');
9109: