APPS.FEM_DIM_UTILS_PVT dependencies on FEM_XDIM_DIMENSIONS

Line 39: from fem_xdim_dimensions

35:
36: -- Cursor to determine the base member table name for a dimension
37: cursor l_xdim_csr is
38: select member_b_table_name
39: from fem_xdim_dimensions
40: where dimension_id = p_dimension_id;
41:
42: BEGIN
43:

Line 133: from fem_xdim_dimensions

129: -- Cursor to determine group use code and attribute table name of dim.
130: --
131: Cursor l_dim_csr is
132: Select group_use_code, attribute_table_name
133: from fem_xdim_dimensions
134: where dimension_id = l_dimension_id;
135:
136: l_result number;
137:

Line 270: from fem_xdim_dimensions

266: -- Cursor to determine group use code and attribute table name of dim.
267: --
268: Cursor l_dim_csr is
269: Select group_use_code, attribute_table_name
270: from fem_xdim_dimensions
271: where dimension_id = l_dimension_id;
272:
273: -- For Bug# 3980015
274: --Cursor to determine if there are levels associated witha dimension

Line 483: FROM fem_xdim_dimensions

479: IF p_operation_type='D' THEN
480: FOR l_xdim_rec IN
481: (
482: SELECT member_vl_object_name
483: FROM fem_xdim_dimensions
484: WHERE dimension_id = p_dimension_id
485: )
486: LOOP
487: l_member_tbl_name := l_xdim_rec.member_vl_object_name;

Line 596: FROM fem_xdim_dimensions

592: FOR l_xdim_rec IN
593: (
594: SELECT hierarchy_table_name,
595: personal_hierarchy_table_name
596: FROM fem_xdim_dimensions
597: WHERE dimension_id = g_dimension_id
598: )
599: LOOP
600:

Line 626: FROM fem_xdim_dimensions

622: FOR l_xdim_rec IN
623: (
624: SELECT hierarchy_table_name,
625: personal_hierarchy_table_name
626: FROM fem_xdim_dimensions
627: WHERE dimension_id = g_dimension_id
628: )
629: LOOP
630:

Line 731: From fem_xdim_dimensions_vl

727: Where Dimension_Group_Id = p_dim_group_id;
728:
729: Cursor l_xdim_csr is
730: Select ATTRIBUTE_TABLE_NAME
731: From fem_xdim_dimensions_vl
732: Where dimension_id = l_dimension_id;
733:
734: BEGIN
735:

Line 825: FROM fem_xdim_dimensions_vl

821: member_col,
822: member_display_code_col,
823: member_name_col,
824: value_set_required_flag
825: FROM fem_xdim_dimensions_vl
826: WHERE dimension_varchar_label = p_dimension_varchar_label;
827:
828: BEGIN
829: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 4939: FROM fem_xdim_dimensions_vl

4935: MEMBER_DESCRIPTION_COL,
4936: VALUE_SET_REQUIRED_FLAG,
4937: GROUP_USE_CODE,
4938: READ_ONLY_FLAG
4939: FROM fem_xdim_dimensions_vl
4940: WHERE dimension_varchar_label = p_dimension_varchar_label
4941: )
4942: LOOP
4943:

Line 8862: FROM fem_xdim_dimensions_vl

8858: MEMBER_DESCRIPTION_COL,
8859: VALUE_SET_REQUIRED_FLAG,
8860: GROUP_USE_CODE,
8861: READ_ONLY_FLAG
8862: FROM fem_xdim_dimensions_vl
8863: WHERE dimension_varchar_label = p_dimension_varchar_label
8864: )
8865: LOOP
8866:

Line 8996: l_member_vl_object_name fem_xdim_dimensions.member_vl_object_name%TYPE;

8992: p_member_id IN VARCHAR2,
8993: p_value_set_id IN VARCHAR2
8994: )
8995: IS
8996: l_member_vl_object_name fem_xdim_dimensions.member_vl_object_name%TYPE;
8997: l_stmt VARCHAR2(240);
8998: BEGIN
8999: --
9000: SAVEPOINT Delete_Row_Pvt ;

Line 9220: FROM fem_xdim_dimensions_vl

9216: FOR l_dim_rec IN
9217: (
9218: SELECT member_vl_object_name,
9219: member_col
9220: FROM fem_xdim_dimensions_vl
9221: WHERE dimension_varchar_label = p_dimension_varchar_label
9222: )
9223: LOOP
9224:

Line 9241: FROM fem_xdim_dimensions_vl

9237: FOR l_dim_attr_rec IN
9238: (
9239: SELECT attribute_table_name,
9240: member_col
9241: FROM fem_xdim_dimensions_vl
9242: WHERE dimension_varchar_label = p_dimension_varchar_label
9243: )
9244: LOOP
9245: IF l_dim_attr_rec.attribute_table_name IS NOT NULL THEn

Line 9370: 'FROM FEM_XDIM_DIMENSIONS_VL ' ||

9366: -- Bug 3605296: Replace the variable v_xdim_meta_data_query
9367: l_xdim_meta_data_query := 'SELECT MEMBER_VL_OBJECT_NAME, ' ||
9368: 'MEMBER_NAME_COL, ' ||
9369: 'MEMBER_COL ' ||
9370: 'FROM FEM_XDIM_DIMENSIONS_VL ' ||
9371: 'WHERE DIMENSION_ID = :1 ';
9372:
9373:
9374: OPEN c_attr_version for v_attr_version_query

Line 10395: FROM Fem_Xdim_Dimensions_VL

10391: THEN
10392:
10393: SELECT default_member_display_code
10394: INTO l_uom_code
10395: FROM Fem_Xdim_Dimensions_VL
10396: WHERE dimension_varchar_label = 'UOM';
10397:
10398: IF l_uom_code IS NULL THEN
10399: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_COST_OBJ_UOM_ERROR');

Line 10570: FROM Fem_Xdim_Dimensions_VL

10566:
10567: IF p_segment_3 = '-999' THEN
10568:
10569: SELECT default_member_display_code INTO l_uom_code
10570: FROM Fem_Xdim_Dimensions_VL
10571: WHERE dimension_varchar_label = 'UOM';
10572:
10573: IF l_uom_code IS NULL THEN
10574: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_COST_OBJ_UOM_ERROR');