APPS.BIS_DIMS_AND_LEVELS_PKG dependencies on BIS_DIMS_AND_LEVELS_PKG

Line 1: PACKAGE BODY BIS_DIMS_AND_LEVELS_PKG AS

1: PACKAGE BODY BIS_DIMS_AND_LEVELS_PKG AS
2: /* $Header: BISKDDLB.pls 120.2 2006/09/01 04:59:17 ankgoel noship $ */
3:
4:
5: FUNCTION bis_kpi_report ( p_params IN BIS_PMV_PAGE_PARAMETER_TBL )

Line 103: , SUBSTR(NVL(BIS_DIMS_AND_LEVELS_PKG.get_level_names(bi.indicator_id), '' ''),1,180) LEVEL_NAMES

99: l_ret_string := '
100: SELECT
101: bi.name KPI_NAME2
102: , SUBSTR(NVL(bi.description, '' ''),1,180) KPI_DESCRIPTION1
103: , SUBSTR(NVL(BIS_DIMS_AND_LEVELS_PKG.get_level_names(bi.indicator_id), '' ''),1,180) LEVEL_NAMES
104: , SUBSTR(NVL(f.application_name, '' ''),1,180) Owning_applicn_name2
105: FROM
106: bis_indicators_vl bi
107: , bis_levels_vl bl

Line 443: , SUBSTR(NVL(BIS_DIMS_AND_LEVELS_PKG.get_kpi_names(bl.level_id), '' ''),1,180) Kpi_names

439: , bl.short_name Level_Internal_name
440: , aa.attribute_label_long Level_Short_name
441: , SUBSTR(NVL(bl.description, '' ''),1,180) Level_description
442: , bl.source Level_value_Source_type1
443: , SUBSTR(NVL(BIS_DIMS_AND_LEVELS_PKG.get_kpi_names(bl.level_id), '' ''),1,180) Kpi_names
444: FROM
445: bis_levels_vl bl
446: , ak_attributes_vl aa
447: , bis_dimensions_vl bd

Line 673: END BIS_DIMS_AND_LEVELS_PKG;

669:
670: END get_kpi_names;
671:
672:
673: END BIS_DIMS_AND_LEVELS_PKG;