DBA Data[Home] [Help]

APPS.FEM_MIR_PKG dependencies on FEM_DIMENSION_UTIL_PKG

Line 1504: SELECT FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_Display_Code(

1500: ,p_module => c_module_pkg||'.'||l_api_name
1501: ,p_msg_text => 'Begining Function'
1502: );
1503:
1504: SELECT FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_Display_Code(
1505: XDIM.dimension_id
1506: ,p_member_id
1507: ,DECODE(XDIM.value_set_required_flag
1508: ,'Y',

Line 1509: FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(XDIM.dimension_id)

1505: XDIM.dimension_id
1506: ,p_member_id
1507: ,DECODE(XDIM.value_set_required_flag
1508: ,'Y',
1509: FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(XDIM.dimension_id)
1510: ,NULL)
1511: )
1512: INTO l_member_display_code
1513: FROM fem_xdim_dimensions_vl XDIM

Line 1609: SELECT FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_Display_Code(

1605: ,p_module => c_module_pkg||'.'||l_api_name
1606: ,p_msg_text => 'Begining Function'
1607: );
1608:
1609: SELECT FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_Display_Code(
1610: XDIM.dimension_id
1611: ,p_member_id
1612: ,DECODE(XDIM.value_set_required_flag
1613: ,'Y'

Line 1614: ,FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(XDIM.dimension_id)

1610: XDIM.dimension_id
1611: ,p_member_id
1612: ,DECODE(XDIM.value_set_required_flag
1613: ,'Y'
1614: ,FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(XDIM.dimension_id)
1615: ,NULL)
1616: )
1617: INTO l_member_display_code
1618: FROM fem_xdim_dimensions_vl XDIM

Line 1735: ,FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(XDIM.dimension_id)

1731: );
1732:
1733: SELECT DECODE(XDIM.value_set_required_flag
1734: ,'Y'
1735: ,FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(XDIM.dimension_id)
1736: ,NULL
1737: )
1738: INTO l_value_set_id
1739: FROM fem_xdim_dimensions_vl XDIM

Line 1768: l_member_id := FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_ID (

1764: END IF;
1765: -------------------------------
1766: --Get Member ID
1767: -------------------------------
1768: l_member_id := FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_ID (
1769: p_api_version => 1.0
1770: ,p_init_msg_list => p_init_msg_list
1771: ,p_commit => p_commit
1772: ,p_encoded => p_encoded

Line 1915: ,FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(XDIM.dimension_id)

1911: --Getting Value Set ID
1912: -------------------------------
1913: SELECT DECODE(XDIM.value_set_required_flag
1914: ,'Y'
1915: ,FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(XDIM.dimension_id)
1916: ,NULL
1917: )
1918: INTO l_value_set_id
1919: FROM fem_xdim_dimensions_vl XDIM

Line 1965: l_member_id := FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_ID (

1961:
1962: ---------------------------------
1963: --Getting Member Id
1964: ---------------------------------
1965: l_member_id := FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_ID (
1966: p_api_version => 1.0
1967: ,p_init_msg_list => p_init_msg_list
1968: ,p_commit => p_commit
1969: ,p_encoded => p_encoded