9: --Function GetColConfigForIndic(Indic IN NUMBER) return DBMS_SQL.NUMBER_TABLE ;
10:
11: PROCEDURE IndicatorTables ;
12: Function keyFieldExists(
13: colCamposLlaves IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
14: keyName IN VARCHAR2) return Boolean ;
15: Function dataFieldExists(colMeasures IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField, measure IN VARCHAR2) RETURN BOOLEAN ;
16: Function dataFieldExistsForSource(colMeasures IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,
17: measure IN VARCHAR2,
11: PROCEDURE IndicatorTables ;
12: Function keyFieldExists(
13: colCamposLlaves IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
14: keyName IN VARCHAR2) return Boolean ;
15: Function dataFieldExists(colMeasures IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField, measure IN VARCHAR2) RETURN BOOLEAN ;
16: Function dataFieldExistsForSource(colMeasures IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,
17: measure IN VARCHAR2,
18: p_source IN VARCHAR2
19: ) RETURN BOOLEAN ;
12: Function keyFieldExists(
13: colCamposLlaves IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
14: keyName IN VARCHAR2) return Boolean ;
15: Function dataFieldExists(colMeasures IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField, measure IN VARCHAR2) RETURN BOOLEAN ;
16: Function dataFieldExistsForSource(colMeasures IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,
17: measure IN VARCHAR2,
18: p_source IN VARCHAR2
19: ) RETURN BOOLEAN ;
20:
18: p_source IN VARCHAR2
19: ) RETURN BOOLEAN ;
20:
21: Function IndexRelation1N(tablename IN VARCHAR2, masterTableName IN VARCHAR2 ) RETURN NUMBER ;
22: Function GetKeyOrigin(keyNamesOri IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, keyName IN VARCHAR2) return VARCHAR2;
23: Function GetConfigurationsForIndic(Indic IN NUMBER) return DBMS_SQL.NUMBER_TABLE ;
24: Function GetLevelCollection(Indic IN NUMBER, Configuration IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels ;
25: Function GetFreeDivZeroExpression(expression IN VARCHAR2) RETURN VARCHAR2 ;
26: Function IsIndicatorPnL(Ind IN Integer, pUseGIndics boolean) return Boolean ;
20:
21: Function IndexRelation1N(tablename IN VARCHAR2, masterTableName IN VARCHAR2 ) RETURN NUMBER ;
22: Function GetKeyOrigin(keyNamesOri IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, keyName IN VARCHAR2) return VARCHAR2;
23: Function GetConfigurationsForIndic(Indic IN NUMBER) return DBMS_SQL.NUMBER_TABLE ;
24: Function GetLevelCollection(Indic IN NUMBER, Configuration IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels ;
25: Function GetFreeDivZeroExpression(expression IN VARCHAR2) RETURN VARCHAR2 ;
26: Function IsIndicatorPnL(Ind IN Integer, pUseGIndics boolean) return Boolean ;
27: Function GetDataFields(Indic IN NUMBER, Configuration IN NUMBER, WithInternalColumns IN Boolean)
28: RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField ;
24: Function GetLevelCollection(Indic IN NUMBER, Configuration IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels ;
25: Function GetFreeDivZeroExpression(expression IN VARCHAR2) RETURN VARCHAR2 ;
26: Function IsIndicatorPnL(Ind IN Integer, pUseGIndics boolean) return Boolean ;
27: Function GetDataFields(Indic IN NUMBER, Configuration IN NUMBER, WithInternalColumns IN Boolean)
28: RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField ;
29:
30: Function IsIndicatorBalanceOrPnL(Ind IN Integer, pUseGIndics boolean ) return Boolean;
31:
32: