APPS.ZPB_FEM_UTILS_PKG dependencies on ZPB_MEMBER_TABLE_OBJ

Line 132: l_ret ZPB_MEMBER_TABLE_OBJ;

128: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
129: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
130: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
131: l_command VARCHAR2(500);
132: l_ret ZPB_MEMBER_TABLE_OBJ;
133:
134: l_curs EPB_CURS_TYPE;
135: begin
136: if (p_dimension_id is null) then

Line 140: l_ret := ZPB_MEMBER_TABLE_OBJ(null, null, null, null);

136: if (p_dimension_id is null) then
137: return;
138: end if;
139:
140: l_ret := ZPB_MEMBER_TABLE_OBJ(null, null, null, null);
141:
142: select MEMBER_VL_OBJECT_NAME, MEMBER_NAME_COL, MEMBER_DESCRIPTION_COL,
143: MEMBER_COL, VALUE_SET_REQUIRED_FLAG
144: into l_dim_vl_table, l_dim_name_col, l_dim_desc_col, l_dim_col, l_vs_req

Line 240: l_ret ZPB_MEMBER_TABLE_OBJ;

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;
241: l_command VARCHAR2(2000);
242:
243: l_curs EPB_CURS_TYPE;
244: begin

Line 246: l_ret := ZPB_MEMBER_TABLE_OBJ(null, null, null, null);

242:
243: l_curs EPB_CURS_TYPE;
244: begin
245:
246: l_ret := ZPB_MEMBER_TABLE_OBJ(null, null, null, null);
247:
248: select A.DIMENSION_ID, A.VALUE_SET_REQUIRED_FLAG, A.HIERARCHY_TABLE_NAME
249: into l_dimension_id, l_vs_req, l_hier_table
250: from FEM_XDIM_DIMENSIONS A, FEM_HIERARCHIES B, FEM_OBJECT_DEFINITION_B C