43: -- pipelined
44: --
45: -- IN: p_dimension_id - The IF of the dimension to get the members from
46: --
47: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
48: ----------------------------------------------------------------------------
49: function GET_MEMBERS (p_dimension_id NUMBER)
50: return ZPB_MEMBER_TABLE_T PIPELINED;
51:
46: --
47: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
48: ----------------------------------------------------------------------------
49: function GET_MEMBERS (p_dimension_id NUMBER)
50: return ZPB_MEMBER_TABLE_T PIPELINED;
51:
52: ----------------------------------------------------------------------------
53: -- GET_VARCHAR_MEMBERS
54: --
55: -- Same as GET_MEMBERS, but returns the members with varchar ID's
56: --
57: -- IN: p_dimension_id - The IF of the dimension to get the members from
58: --
59: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
60: ----------------------------------------------------------------------------
61: function GET_VARCHAR_MEMBERS (p_dimension_id NUMBER)
62: return ZPB_VAR_MEMBER_TABLE_T PIPELINED;
63:
66: --
67: -- Returns the name, description of the top level hierarchy members
68: --
69: -- IN: p_hier_vers_id - The hierarchy version ID
70: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
71: ----------------------------------------------------------------------------
72: function GET_TOP_HIER_MEMBERS (p_hier_vers_id IN NUMBER)
73: return ZPB_MEMBER_TABLE_T PIPELINED;
74:
69: -- IN: p_hier_vers_id - The hierarchy version ID
70: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
71: ----------------------------------------------------------------------------
72: function GET_TOP_HIER_MEMBERS (p_hier_vers_id IN NUMBER)
73: return ZPB_MEMBER_TABLE_T PIPELINED;
74:
75: ----------------------------------------------------------------------------
76: -- GET_BUSAREA_HIERARCHIES
77: --