eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_MO_HELPER_PKG dependencies on BSC_KPI_PROPERTIES

Line 1591: -- Write the given variable of the given indicator in BSC_KPI_PROPERTIES

1587: --****************************************************************************
1588: -- WriteInfoMatrix : EscribirMatrixInfo
1589: --
1590: -- DESCRIPTION:
1591: -- Write the given variable of the given indicator in BSC_KPI_PROPERTIES
1592: -- table.
1593: --
1594: -- PARAMETERS:
1595: -- Indic: indicator code

Line 1603: SELECT PROPERTY_CODE FROM BSC_KPI_PROPERTIES

1599: --****************************************************************************
1600: PROCEDURE WriteInfoMatrix(Indic IN NUMBER, Variable IN VARCHAR2, Valor IN NUMBER) IS
1601:
1602: CURSOR C1 IS
1603: SELECT PROPERTY_CODE FROM BSC_KPI_PROPERTIES
1604: WHERE INDICATOR = Indic
1605: AND UPPER(PROPERTY_CODE) = UPPER(Variable);
1606: l_Value varchar2(20);
1607: l_error VARCHAR2(400);

Line 1615: UPDATE BSC_KPI_PROPERTIES SET PROPERTY_VALUE = Valor

1611: OPEN c1;
1612: FETCH c1 INTO l_VALUE;
1613:
1614: IF c1%FOUND THEN
1615: UPDATE BSC_KPI_PROPERTIES SET PROPERTY_VALUE = Valor
1616: WHERE INDICATOR = Indic AND PROPERTY_CODE = Variable;
1617:
1618: Else
1619: INSERT INTO BSC_KPI_PROPERTIES (INDICATOR, PROPERTY_CODE, PROPERTY_VALUE)

Line 1619: INSERT INTO BSC_KPI_PROPERTIES (INDICATOR, PROPERTY_CODE, PROPERTY_VALUE)

1615: UPDATE BSC_KPI_PROPERTIES SET PROPERTY_VALUE = Valor
1616: WHERE INDICATOR = Indic AND PROPERTY_CODE = Variable;
1617:
1618: Else
1619: INSERT INTO BSC_KPI_PROPERTIES (INDICATOR, PROPERTY_CODE, PROPERTY_VALUE)
1620: VALUES(Indic, Variable, Valor);
1621: End IF;
1622: Close c1;
1623:

Line 1635: -- Write in BSC_KPI_PROPERTIES the Optimization Mode of the kpis

1631: --****************************************************************************
1632: -- SaveOptimizationMode: GuardarOptimizationMode
1633: --
1634: -- DESCRIPTION:
1635: -- Write in BSC_KPI_PROPERTIES the Optimization Mode of the kpis
1636: --
1637: --****************************************************************************
1638:
1639: PROCEDURE SaveOptimizationMode IS

Line 2970: -- table BSC_KPI_PROPERTIES.

2966: --***************************************************************************
2967: -- getKPIPropertyValue : LeerMatrixINfo
2968: -- DESCRIPTION:
2969: -- Return the value oif the given variable of the given indicator from
2970: -- table BSC_KPI_PROPERTIES.
2971: --
2972: -- PARAMETERS:
2973: -- Indic: indicator code
2974: -- Variable: variable name

Line 2989: FROM BSC_KPI_PROPERTIES

2985: l_error VARCHAR2(400);
2986:
2987: CURSOR cProperty IS
2988: SELECT PROPERTY_VALUE
2989: FROM BSC_KPI_PROPERTIES
2990: WHERE INDICATOR = Indic
2991: AND PROPERTY_CODE = Variable;
2992:
2993: BEGIN

Line 4406: AND EXISTS ( SELECT P.PROPERTY_CODE FROM BSC_KPI_PROPERTIES P

4402: CURSOR cEDWIndics IS
4403: SELECT DISTINCT K.INDICATOR
4404: FROM BSC_KPIS_B K
4405: WHERE EDW_FLAG = 1
4406: AND EXISTS ( SELECT P.PROPERTY_CODE FROM BSC_KPI_PROPERTIES P
4407: WHERE P.INDICATOR = K.INDICATOR AND P.PROPERTY_VALUE = 0
4408: AND P.PROPERTY_CODE IN ('EDW_DATASET_STATUS', 'EDW_CALENDAR_STATUS', 'EDW_DIMENSION_STATUS'));
4409:
4410: BEGIN

Line 4414: --There are 3 flags in BSC_KPI_PROPERTIES to check when a EDW Kpi

4410: BEGIN
4411: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
4412: writeTmp( 'Inside CheckAllEDWIndicsFullyMapped');--commit;
4413: END IF;
4414: --There are 3 flags in BSC_KPI_PROPERTIES to check when a EDW Kpi
4415: --is fully mapped
4416:
4417: kpilist := null;
4418: OPEN cEDWIndics;

Line 6374: -- If the system is in summary tables mode, then bsc_kpi_properties.implementation_type should be 1

6370: END IF;
6371: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6372: BSC_MO_HELPER_PKG.writeTmp('Deleted invalid entries from metadata tables '||get_time, FND_LOG.LEVEL_PROCEDURE);
6373: END IF;
6374: -- If the system is in summary tables mode, then bsc_kpi_properties.implementation_type should be 1
6375: -- clean up any corruption caused by foll. case
6376: -- System in in Summary tables. User changes MV level to 2. User sets KPI as AW impl.
6377: -- Then user changes MV level to null (note that he may have NOT run database generator)
6378: IF (BSC_METADATA_OPTIMIZER_PKG.g_BSC_mv=false) THEN

Line 6379: UPDATE BSC_KPI_PROPERTIES set property_value = 1 where property_code = BSC_METADATA_OPTIMIZER_PKG.IMPL_TYPE;

6375: -- clean up any corruption caused by foll. case
6376: -- System in in Summary tables. User changes MV level to 2. User sets KPI as AW impl.
6377: -- Then user changes MV level to null (note that he may have NOT run database generator)
6378: IF (BSC_METADATA_OPTIMIZER_PKG.g_BSC_mv=false) THEN
6379: UPDATE BSC_KPI_PROPERTIES set property_value = 1 where property_code = BSC_METADATA_OPTIMIZER_PKG.IMPL_TYPE;
6380: END IF;
6381: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6382: BSC_MO_HELPER_PKG.writeTmp('Updated kpi_properties '||get_time, FND_LOG.LEVEL_PROCEDURE);
6383: END IF;

Line 7265: from bsc_kpi_properties p

7261: FUNCTION aw_objective_exists return boolean is
7262: l_count number;
7263: begin
7264: select count(1) into l_count
7265: from bsc_kpi_properties p
7266: , bsc_kpis_vl k
7267: where p.indicator=k.indicator
7268: and p.property_code=bsc_metadata_optimizer_pkg.impl_type
7269: and p.property_value = 2