PACKAGE: APPS.BSC_MO_INDICATOR_PKG

Source

1 Package BSC_MO_INDICATOR_PKG AS
2 /* $Header: BSCMOIDS.pls 120.0 2005/05/31 18:56:05 appldev noship $ */
3 Function GetStrCombinationsMN(combo IN dbms_sql.varchar2_table)
4  return dbms_sql.varchar2_table ;
5 
6 TYPE CurTyp IS REF CURSOR;
7 
8 --Function GetSourceDimensionSet(Indic IN NUMBER, DimSet IN NUMBER) RETURN VARCHAR2;
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,
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 ;
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 
33 Function GetProjectionTableName(TableName IN VARCHAR2) RETURN VARCHAR2 ;
34 
35 Function GetColConfigForIndic(Indic IN NUMBER) return DBMS_SQL.NUMBER_TABLE ;
36 
37 END BSC_MO_INDICATOR_PKG;