APPS.FEM_WEBADI_MEMBER_UTILS_PVT dependencies on FEM_XDIM_DIMENSIONS

Line 874: FROM FEM_XDIM_DIMENSIONS_VL D

870: , l_sequence_num
871: , 274
872: , L.LANGUAGE_CODE
873: , B.SOURCE_LANG
874: FROM FEM_XDIM_DIMENSIONS_VL D
875: , FEM_DIM_ATTRIBUTES_B A
876: , FEM_DIM_ATTRIBUTES_TL B
877: , FND_NEW_MESSAGES M
878: , FND_LANGUAGES L

Line 1041: FROM FEM_XDIM_DIMENSIONS_VL D

1037: , l_sequence_num
1038: , 274
1039: , L.LANGUAGE_CODE
1040: , B.SOURCE_LANG
1041: FROM FEM_XDIM_DIMENSIONS_VL D
1042: , FEM_DIM_ATTRIBUTES_B A
1043: , FEM_DIM_ATTRIBUTES_TL B
1044: , FND_NEW_MESSAGES M
1045: , FND_LANGUAGES L

Line 1255: FROM FEM_XDIM_DIMENSIONS_VL D

1251: , l_max_sequence_num
1252: , 274
1253: , L.LANGUAGE_CODE
1254: , B.SOURCE_LANG
1255: FROM FEM_XDIM_DIMENSIONS_VL D
1256: , FEM_DIM_ATTRIBUTES_B A
1257: , FEM_DIM_ATTRIBUTES_TL B
1258: , FND_NEW_MESSAGES M
1259: , FND_LANGUAGES L

Line 2356: FROM FEM_XDIM_DIMENSIONS_VL

2352: , l_interface_name
2353: , l_dimension_type_code
2354: , l_value_set_required_flag
2355: , l_group_use_code
2356: FROM FEM_XDIM_DIMENSIONS_VL
2357: WHERE DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label;
2358:
2359:
2360: IF SQL%NOTFOUND THEN

Line 2756: fem_xdim_dimensions_vl xDimVL

2752: , dimension_type_code
2753: , group_use_code
2754: , value_set_required_flag
2755: FROM
2756: fem_xdim_dimensions_vl xDimVL
2757: WHERE
2758: xDimVL.dimension_varchar_label = p_dimension_varchar_label ;
2759:
2760: -- Retrieve all the mappings for

Line 2990: , fem_xdim_dimensions_vl xdim

2986: attrmap.interface_col
2987: , dimattr.attribute_data_type_code
2988: FROM
2989: fem_dim_attributes_b dimattr
2990: , fem_xdim_dimensions_vl xdim
2991: , fem_webadi_dim_attr_maps attrmap
2992: WHERE
2993: attrmap.dimension_varchar_label = p_dimension_varchar_label
2994: AND xdim.dimension_varchar_label = attrmap.dimension_varchar_label

Line 3009: , fem_xdim_dimensions_vl xdim

3005: dimattr.attribute_varchar_label
3006: , dimattr.attribute_data_type_code
3007: FROM
3008: fem_dim_attributes_b dimattr
3009: , fem_xdim_dimensions_vl xdim
3010: WHERE
3011: xdim.dimension_varchar_label = p_dimension_varchar_label
3012: AND xdim.dimension_id = dimattr.dimension_id
3013: AND NOT EXISTS

Line 3081: , fem_xdim_dimensions_vl xdim

3077: ( SELECT
3078: attr.attribute_varchar_label
3079: FROM
3080: fem_dim_attributes_b attr
3081: , fem_xdim_dimensions_vl xdim
3082: WHERE
3083: xdim.dimension_varchar_label = attrmap.dimension_varchar_label
3084: AND attr.dimension_id = xdim.dimension_id
3085: ) ;

Line 4078: -- This information needs outer join with fem_xdim_dimensions

4074: l_date_attribute_value DATE;
4075: l_adi_format_mask VARCHAR2(20) := FND_PROFILE.VALUE('FEM_INTF_ATTR_DATE_FORMAT_MASK');
4076: -- Find out attribute_dimension_id, version_display_code,
4077: -- attribute_value_set_required_flag.
4078: -- This information needs outer join with fem_xdim_dimensions
4079: -- table as attribute_dimension_id might be null in
4080: -- fem_dim_attributes_b table.
4081: CURSOR l_attr_csr
4082: ( dim_id NUMBER

Line 4094: , fem_xdim_dimensions xDim

4090: , xDim.value_set_required_flag
4091: FROM
4092: fem_dim_attributes_b Attr
4093: , fem_dim_attr_versions_b AttrVer
4094: , fem_xdim_dimensions xDim
4095: WHERE
4096: Attr.dimension_id = dim_id
4097: AND Attr.attribute_varchar_label = attr_label
4098: AND Attr.attribute_id = AttrVer.attribute_id