DBA Data[Home] [Help]

APPS.BSC_BIS_WRAPPER_PVT dependencies on BSC_BIS_WRAPPER_PVT

Line 1: PACKAGE BODY BSC_BIS_WRAPPER_PVT AS

1: PACKAGE BODY BSC_BIS_WRAPPER_PVT AS
2: /* $Header: BSCVBISB.pls 120.0 2005/06/01 16:30:01 appldev noship $ */
3:
4: /************************************************************************************
5: ************************************************************************************/

Line 130: --dbms_output.put_line('Begin BSC_BIS_WRAPPER_PVT.Get_Actual_Value_From_PMV' );

126:
127: x_actual_value := NULL;
128: x_compareto_value := NULL;
129:
130: --dbms_output.put_line('Begin BSC_BIS_WRAPPER_PVT.Get_Actual_Value_From_PMV' );
131:
132: -- Get pmf measure info
133: l_measure_id := p_kpi_info_rec.measure_id;
134: l_function_name := p_kpi_info_rec.function_name;

Line 278: --dbms_output.put_line('End BSC_BIS_WRAPPER_PVT.Get_Actual_Value_From_PMV' );

274:
275: x_actual_value := l_actual_value;
276: x_compareto_value := l_compareto_value;
277:
278: --dbms_output.put_line('End BSC_BIS_WRAPPER_PVT.Get_Actual_Value_From_PMV' );
279:
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1074: --dbms_output.put_line('Begin BSC_BIS_WRAPPER_PVT.Get_Target_Value_From_PMF' );

1070: FND_MSG_PUB.initialize;
1071:
1072: x_target_value := NULL;
1073:
1074: --dbms_output.put_line('Begin BSC_BIS_WRAPPER_PVT.Get_Target_Value_From_PMF' );
1075:
1076: -- Get pmf measure info
1077: l_measure_id := p_kpi_info_rec.measure_id;
1078: l_function_name := p_kpi_info_rec.function_name;

Line 1285: --dbms_output.put_line('End BSC_BIS_WRAPPER_PVT.Get_Target_Value_From_PMF' );

1281: --FOR l_i IN 1 .. l_error_tbl.COUNT LOOP
1282: -- dbms_output.put_line('Error_Description='||l_error_tbl(l_i).Error_Description);
1283: --END LOOP;
1284:
1285: --dbms_output.put_line('End BSC_BIS_WRAPPER_PVT.Get_Target_Value_From_PMF' );
1286:
1287: EXCEPTION
1288: WHEN FND_API.G_EXC_ERROR THEN
1289: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1512: --dbms_OUTPUT.PUT_LINE('Begin BSC_BIS_WRAPPER_PVT.Get_Default_Dimension_Levels' );

1508:
1509: -- By design, the ViewBy dimension Level is define in the column BKL.DEFAULT_VALUE with the value 'C'
1510: -- The other Default Dimension Levels are define in the column BKL.DEFAULT_VALUE with the value 'LD'
1511:
1512: --dbms_OUTPUT.PUT_LINE('Begin BSC_BIS_WRAPPER_PVT.Get_Default_Dimension_Levels' );
1513:
1514: l_sql := 'SELECT BID.SHORT_NAME DIMENSION_SHORTNAME, '||
1515: ' BKL.LEVEL_SHORTNAME, '||
1516: ' DECODE(BKL.DEFAULT_VALUE,''C'', 1, ''LD'', 1, 0) DEFAULT_FLAG '||

Line 1656: -- dbms_output.put_line('End BSC_BIS_WRAPPER_PVT.Get_Default_Dimension_Levels');

1652: x_default_dimension_levels := l_default_dimension_levels;
1653: x_default_time_level_from := l_default_time_level_from;
1654: x_default_time_level_to := l_default_time_level_to;
1655:
1656: -- dbms_output.put_line('End BSC_BIS_WRAPPER_PVT.Get_Default_Dimension_Levels');
1657: --FOR i IN 1..x_default_dimension_levels.COUNT LOOP
1658: -- dbms_output.put_line('x_default_dimension_levels(i).dimension_short_name='||x_default_dimension_levels(i).dimension_short_name);
1659: -- dbms_output.put_line('x_default_dimension_levels(i).level_short_name='||x_default_dimension_levels(i).level_short_name);
1660: -- dbms_output.put_line('x_default_dimension_levels(i).level_value_id='||x_default_dimension_levels(i).level_value_id);

Line 1830: BSC_BIS_WRAPPER_PVT.Get_AO_Defaults(

1826:
1827: --dbms_output.put_line('*l_kpi_code='||l_kpi_code);
1828:
1829: -- Get the default analysis option combination
1830: BSC_BIS_WRAPPER_PVT.Get_AO_Defaults(
1831: p_kpi_code => l_kpi_code,
1832: x_analysis_option0 => l_analysis_option0,
1833: x_analysis_option1 => l_analysis_option1,
1834: x_analysis_option2 => l_analysis_option2,

Line 3028: END BSC_BIS_WRAPPER_PVT;

3024: ,p_data => x_msg_data);
3025: --dbms_output.put_line('*sqlerrm='||sqlerrm);
3026: END Populate_Measure_Data;
3027:
3028: END BSC_BIS_WRAPPER_PVT;