eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_FEM_UTILS_PKG dependencies on ZPB_MEMBER_TABLE_T

Line 122: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair

118: -- pipelined
119: --
120: -- IN: p_dimension_id - The IF of the dimension to get the members from
121: --
122: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
123: ----------------------------------------------------------------------------
124: function GET_MEMBERS (p_dimension_id NUMBER)
125: return ZPB_MEMBER_TABLE_T PIPELINED is
126: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;

Line 125: return ZPB_MEMBER_TABLE_T PIPELINED is

121: --
122: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
123: ----------------------------------------------------------------------------
124: function GET_MEMBERS (p_dimension_id NUMBER)
125: return ZPB_MEMBER_TABLE_T PIPELINED is
126: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
127: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
128: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
129: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;

Line 178: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair

174: -- Same as GET_MEMBERS, but returns the members with varchar ID's
175: --
176: -- IN: p_dimension_id - The IF of the dimension to get the members from
177: --
178: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
179: ----------------------------------------------------------------------------
180: function GET_VARCHAR_MEMBERS (p_dimension_id NUMBER)
181: return ZPB_VAR_MEMBER_TABLE_T PIPELINED is
182: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;

Line 233: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair

229: --
230: -- Returns the name, description of the top level hierarchy members
231: --
232: -- IN: p_hier_vers_id - The hierarchy version ID
233: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
234: ----------------------------------------------------------------------------
235: function GET_TOP_HIER_MEMBERS (p_hier_vers_id IN NUMBER)
236: return ZPB_MEMBER_TABLE_T PIPELINED is
237: l_dimension_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;

Line 236: return ZPB_MEMBER_TABLE_T PIPELINED is

232: -- IN: p_hier_vers_id - The hierarchy version ID
233: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
234: ----------------------------------------------------------------------------
235: function GET_TOP_HIER_MEMBERS (p_hier_vers_id IN NUMBER)
236: return ZPB_MEMBER_TABLE_T PIPELINED is
237: l_dimension_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;
238: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
239: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
240: l_ret ZPB_MEMBER_TABLE_OBJ;