APPS.ZPB_FEM_UTILS_PKG dependencies on ZPB_VAR_MEMBER_TABLE_OBJ

Line 188: l_ret ZPB_VAR_MEMBER_TABLE_OBJ;

184: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
185: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
186: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
187: l_command VARCHAR2(500);
188: l_ret ZPB_VAR_MEMBER_TABLE_OBJ;
189:
190: l_curs EPB_CURS_TYPE;
191: begin
192: if (p_dimension_id is null) then

Line 196: l_ret := ZPB_VAR_MEMBER_TABLE_OBJ(null, null, null, null);

192: if (p_dimension_id is null) then
193: return;
194: end if;
195:
196: l_ret := ZPB_VAR_MEMBER_TABLE_OBJ(null, null, null, null);
197:
198: select MEMBER_VL_OBJECT_NAME, MEMBER_NAME_COL, MEMBER_DESCRIPTION_COL,
199: MEMBER_COL, VALUE_SET_REQUIRED_FLAG
200: into l_dim_vl_table, l_dim_name_col, l_dim_desc_col, l_dim_col, l_vs_req

Line 475: l_ret ZPB_VAR_MEMBER_TABLE_OBJ;

471: return ZPB_VAR_MEMBER_TABLE_T PIPELINED is
472: l_curs EPB_CURS_TYPE;
473: l_count NUMBER;
474: l_count2 NUMBER;
475: l_ret ZPB_VAR_MEMBER_TABLE_OBJ;
476: l_vset_id NUMBER;
477: l_command VARCHAR2(16000);
478: l_sel_command VARCHAR2(1000);
479: l_from_command VARCHAR2(4000);

Line 511: l_ret := ZPB_VAR_MEMBER_TABLE_OBJ(null, null, null, null);

507: begin
508: l_business_area := nvl(p_Business_area,
509: sys_context('ZPB_CONTEXT', 'business_area_id'));
510:
511: l_ret := ZPB_VAR_MEMBER_TABLE_OBJ(null, null, null, null);
512:
513: --
514: -- Hardcoded for line account types and ledgers dim
515: --