APPS.FEM_CONDITIONS_API dependencies on FEM_DIMENSION_UTIL_PKG

Line 3841: select FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_Display_Code(

3837: l_member_display_code varchar2(150):= null;
3838:
3839: BEGIN
3840:
3841: select FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_Display_Code(
3842: xdim.dimension_id
3843: ,p_member_id
3844: ,decode(xdim.value_set_required_flag
3845: ,'Y',FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(xdim.dimension_id)

Line 3845: ,'Y',FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(xdim.dimension_id)

3841: select FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_Display_Code(
3842: xdim.dimension_id
3843: ,p_member_id
3844: ,decode(xdim.value_set_required_flag
3845: ,'Y',FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(xdim.dimension_id)
3846: ,null))
3847: into l_member_display_code
3848: from fem_xdim_dimensions_vl xdim
3849: where xdim.dimension_id = p_dimension_id;

Line 3884: select FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_Name(

3880: l_member_name varchar2(150):= null;
3881:
3882: BEGIN
3883:
3884: select FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_Name(
3885: xdim.dimension_id
3886: ,p_member_id
3887: ,decode(xdim.value_set_required_flag
3888: ,'Y',FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(xdim.dimension_id)

Line 3888: ,'Y',FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(xdim.dimension_id)

3884: select FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_Name(
3885: xdim.dimension_id
3886: ,p_member_id
3887: ,decode(xdim.value_set_required_flag
3888: ,'Y',FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(xdim.dimension_id)
3889: ,null))
3890: into l_member_name
3891: from fem_xdim_dimensions_vl xdim
3892: where xdim.dimension_id = p_dimension_id;