DBA Data[Home] [Help]

APPS.ZPB_FEM_UTILS_PKG dependencies on ZPB_BUSINESS_AREAS

Line 396: l_business_area ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;

392: p_version_type IN VARCHAR2)
393: return ZPB_HIER_MEMBER_T PIPELINED
394: is
395: l_ret ZPB_HIER_MEMBER_OBJ;
396: l_business_area ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
397:
398: cursor cache(p_business_area_id NUMBER, p_logical_dim_id NUMBER) is
399: select HIERARCHY_ID, VERSION_ID, PARENT_ID, CHILD_ID, PARENT_DEPTH,
400: CHILD_DEPTH, PARENT_GROUP, CHILD_GROUP, DISPLAY_ORDER,

Line 488: l_business_area ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;

484: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
485: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
486: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
487: l_use_cond ZPB_BUSAREA_DIMENSIONS.USE_MEMBER_CONDITIONS%type;
488: l_business_area ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
489: l_operation ZPB_BUSAREA_CONDITIONS.OPERATION%type;
490:
491: cursor conditions is
492: select B.ATTRIBUTE_ID, D.VERSION_ID, B.VALUE, B.VALUE_SET_ID,

Line 697: l_business_area ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;

693: l_curs EPB_CURS_TYPE;
694: l_member_hash MEMBER_HASH_TYPE;
695: l_null_hash MEMBER_HASH_TYPE;
696:
697: l_business_area ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
698:
699: cursor hiers is
700: select A.HIERARCHY_ID, A.VERSION_ID, A.CURRENT_VERSION,
701: C.INCLUDE_ALL_TOP_MEMBERS, C.INCLUDE_ALL_LEVELS,