DBA Data[Home] [Help]

APPS.ZPB_FEM_UTILS_PKG dependencies on ZPB_HIER_VERS_OBJ

Line 304: l_ret ZPB_HIER_VERS_OBJ;

300: function GET_BUSAREA_HIERARCHIES(p_business_area in number,
301: p_version_type in varchar2)
302: return ZPB_HIER_VERS_T PIPELINED
303: is
304: l_ret ZPB_HIER_VERS_OBJ;
305: l_business_area NUMBER;
306: l_count NUMBER;
307: cursor hiers is
308: select A.HIERARCHY_ID, C.OBJECT_DEFINITION_ID, A.KEEP_VERSION,

Line 336: l_ret := ZPB_HIER_VERS_OBJ(null, null, null, null);

332: where OBJECT_ID = l_hier
333: and EFFECTIVE_START_DATE < sysdate
334: order by EFFECTIVE_END_DATE DESC;
335: begin
336: l_ret := ZPB_HIER_VERS_OBJ(null, null, null, null);
337: l_business_area := nvl(p_business_area,
338: sys_context('ZPB_CONTEXT', 'business_area_id'));
339: for each in hiers loop
340: