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_BIS_WRAPPER_PVT dependencies on BSC_BIS_WRAPPER_PUB

Line 81: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,

77: /************************************************************************************
78: ************************************************************************************/
79:
80: PROCEDURE Get_Actual_Value_From_PMV(
81: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,
82: p_user_id IN VARCHAR2,
83: p_responsibility_id IN VARCHAR2,
84: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
85: p_time_level_from IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

Line 84: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,

80: PROCEDURE Get_Actual_Value_From_PMV(
81: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,
82: p_user_id IN VARCHAR2,
83: p_responsibility_id IN VARCHAR2,
84: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
85: p_time_level_from IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
86: p_time_level_to IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
87: p_time_comparison_type IN VARCHAR2,
88: p_viewby_level IN VARCHAR2,

Line 85: p_time_level_from IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

81: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,
82: p_user_id IN VARCHAR2,
83: p_responsibility_id IN VARCHAR2,
84: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
85: p_time_level_from IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
86: p_time_level_to IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
87: p_time_comparison_type IN VARCHAR2,
88: p_viewby_level IN VARCHAR2,
89: x_actual_value OUT NOCOPY VARCHAR2,

Line 86: p_time_level_to IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

82: p_user_id IN VARCHAR2,
83: p_responsibility_id IN VARCHAR2,
84: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
85: p_time_level_from IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
86: p_time_level_to IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
87: p_time_comparison_type IN VARCHAR2,
88: p_viewby_level IN VARCHAR2,
89: x_actual_value OUT NOCOPY VARCHAR2,
90: x_compareto_value OUT NOCOPY VARCHAR2,

Line 97: l_measure_dimensions BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type;

93: x_msg_data OUT NOCOPY VARCHAR2
94: ) IS
95: -- Measure Info dimensions
96: l_measure_id NUMBER;
97: l_measure_dimensions BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type;
98:
99: -- parameters to get actual from pmv
100: l_region_code VARCHAR2(2000) := NULL;
101: l_function_name VARCHAR2(2000) := NULL;

Line 113: l_dimension_level BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;

109: -- Others
110: l_i NUMBER;
111: l_j NUMBER;
112: l_dimensionX_short_name VARCHAR2(2000);
113: l_dimension_level BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
114: l_total_dimlevel_short_name VARCHAR2(2000);
115: l_total_dimlevel_value_id NUMBER;
116: l_total_dimlevel_value_name VARCHAR2(2000);
117: l_dim_level_index NUMBER;

Line 361: l_time_dimension_level BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;

357: l_current_period_id VARCHAR2(2000);
358: l_current_period_name VARCHAR2(2000);
359:
360: l_dimset_id NUMBER;
361: l_time_dimension_level BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
362:
363: l_return_status VARCHAR2(32000);
364: l_msg_count VARCHAR2(32000);
365: l_msg_data VARCHAR2(32000);

Line 448: p_time_dimension_level IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

444: /************************************************************************************
445: ************************************************************************************/
446:
447: FUNCTION Get_DBI_Current_Period(
448: p_time_dimension_level IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
449: p_as_of_date IN VARCHAR2
450:
451: ) RETURN VARCHAR2 IS
452:

Line 798: x_kpi_info_rec OUT NOCOPY BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type

794: p_analysis_option0 IN NUMBER,
795: p_analysis_option1 IN NUMBER,
796: p_analysis_option2 IN NUMBER,
797: p_series_id IN NUMBER,
798: x_kpi_info_rec OUT NOCOPY BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type
799: ) IS
800:
801: l_kpi_info_rec BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type;
802:

Line 801: l_kpi_info_rec BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type;

797: p_series_id IN NUMBER,
798: x_kpi_info_rec OUT NOCOPY BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type
799: ) IS
800:
801: l_kpi_info_rec BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type;
802:
803: l_measure_id1 NUMBER;
804: l_operation VARCHAR2(2000);
805: l_measure_id2 NUMBER;

Line 1033: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,

1029: /************************************************************************************
1030: ************************************************************************************/
1031:
1032: PROCEDURE Get_Target_Value_From_PMF(
1033: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,
1034: p_user_id IN VARCHAR2,
1035: p_responsibility_id IN VARCHAR2,
1036: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
1037: p_time_level IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

Line 1036: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,

1032: PROCEDURE Get_Target_Value_From_PMF(
1033: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,
1034: p_user_id IN VARCHAR2,
1035: p_responsibility_id IN VARCHAR2,
1036: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
1037: p_time_level IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
1038: x_target_value OUT NOCOPY VARCHAR2,
1039: x_return_status OUT NOCOPY VARCHAR2,
1040: x_msg_count OUT NOCOPY NUMBER,

Line 1037: p_time_level IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

1033: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,
1034: p_user_id IN VARCHAR2,
1035: p_responsibility_id IN VARCHAR2,
1036: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
1037: p_time_level IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
1038: x_target_value OUT NOCOPY VARCHAR2,
1039: x_return_status OUT NOCOPY VARCHAR2,
1040: x_msg_count OUT NOCOPY NUMBER,
1041: x_msg_data OUT NOCOPY VARCHAR2

Line 1045: l_measure_dimensions BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type;

1041: x_msg_data OUT NOCOPY VARCHAR2
1042: ) IS
1043: -- Measure Info
1044: l_measure_id NUMBER;
1045: l_measure_dimensions BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type;
1046:
1047: l_region_code VARCHAR2(2000) := NULL;
1048: l_function_name VARCHAR2(2000) := NULL;
1049: l_actual_attribute_code VARCHAR2(2000) := NULL;

Line 1063: l_dimension_level BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;

1059:
1060: -- Others
1061: l_i NUMBER;
1062: l_dimensionX_short_name VARCHAR2(2000);
1063: l_dimension_level BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
1064: l_total_dimlevel_short_name VARCHAR2(2000);
1065: l_total_dimlevel_value_id NUMBER;
1066: l_total_dimlevel_value_name VARCHAR2(2000);
1067: l_dim_level_index NUMBER;

Line 1399: ,p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type

1395: ************************************************************************************/
1396:
1397: FUNCTION Get_Dimension_Level_Index(
1398: p_dimension_short_name IN VARCHAR2
1399: ,p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type
1400: ) RETURN NUMBER IS
1401: l_index NUMBER := 0;
1402: BEGIN
1403:

Line 1425: ,x_time_dimension_level OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type

1421:
1422: PROCEDURE Get_Default_Time_Level(
1423: p_kpi_code IN NUMBER
1424: ,p_dimset_id IN NUMBER
1425: ,x_time_dimension_level OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type
1426: ) IS
1427:
1428: TYPE RefCurTyp IS REF CURSOR;
1429: cv RefCurTyp;

Line 1431: l_dim_level BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;

1427:
1428: TYPE RefCurTyp IS REF CURSOR;
1429: cv RefCurTyp;
1430: l_sql VARCHAR2(32000);
1431: l_dim_level BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
1432:
1433: BEGIN
1434:
1435: -- By design, the ViewBy dimension Level is define in the column BKL.DEFAULT_VALUE with the value 'C'

Line 1472: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,

1468:
1469: PROCEDURE Get_Default_Dimension_Levels(
1470: p_kpi_code IN NUMBER,
1471: p_dimset_id IN NUMBER,
1472: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
1473: x_default_dimension_levels OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
1474: x_default_time_level_from OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
1475: x_default_time_level_to OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type
1476: ) IS

Line 1473: x_default_dimension_levels OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,

1469: PROCEDURE Get_Default_Dimension_Levels(
1470: p_kpi_code IN NUMBER,
1471: p_dimset_id IN NUMBER,
1472: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
1473: x_default_dimension_levels OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
1474: x_default_time_level_from OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
1475: x_default_time_level_to OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type
1476: ) IS
1477:

Line 1474: x_default_time_level_from OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

1470: p_kpi_code IN NUMBER,
1471: p_dimset_id IN NUMBER,
1472: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
1473: x_default_dimension_levels OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
1474: x_default_time_level_from OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
1475: x_default_time_level_to OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type
1476: ) IS
1477:
1478: TYPE RefCurTyp IS REF CURSOR;

Line 1475: x_default_time_level_to OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type

1471: p_dimset_id IN NUMBER,
1472: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
1473: x_default_dimension_levels OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
1474: x_default_time_level_from OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
1475: x_default_time_level_to OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type
1476: ) IS
1477:
1478: TYPE RefCurTyp IS REF CURSOR;
1479: cv RefCurTyp;

Line 1483: l_default_dimension_levels BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type;

1479: cv RefCurTyp;
1480: l_sql VARCHAR2(32000);
1481: i NUMBER := 1;
1482:
1483: l_default_dimension_levels BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type;
1484: l_default_time_level_from BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
1485: l_default_time_level_to BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
1486:
1487: l_dimension_short_name VARCHAR2(2000);

Line 1484: l_default_time_level_from BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;

1480: l_sql VARCHAR2(32000);
1481: i NUMBER := 1;
1482:
1483: l_default_dimension_levels BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type;
1484: l_default_time_level_from BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
1485: l_default_time_level_to BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
1486:
1487: l_dimension_short_name VARCHAR2(2000);
1488: l_level_short_name VARCHAR2(2000);

Line 1485: l_default_time_level_to BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;

1481: i NUMBER := 1;
1482:
1483: l_default_dimension_levels BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type;
1484: l_default_time_level_from BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
1485: l_default_time_level_to BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
1486:
1487: l_dimension_short_name VARCHAR2(2000);
1488: l_level_short_name VARCHAR2(2000);
1489: l_default_flag NUMBER;

Line 1492: l_page_parameter BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Type;

1488: l_level_short_name VARCHAR2(2000);
1489: l_default_flag NUMBER;
1490:
1491: l_page_parameter_name VARCHAR2(32000);
1492: l_page_parameter BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Type;
1493: l_dimension_level BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
1494: l_dimension_level_index NUMBER;
1495:
1496: -- parameters to get current period info

Line 1493: l_dimension_level BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;

1489: l_default_flag NUMBER;
1490:
1491: l_page_parameter_name VARCHAR2(32000);
1492: l_page_parameter BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Type;
1493: l_dimension_level BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
1494: l_dimension_level_index NUMBER;
1495:
1496: -- parameters to get current period info
1497: l_dim_source VARCHAR2(2000);

Line 1721: l_kpi_info_rec BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type;

1717: l_analysis_option1 NUMBER;
1718: l_analysis_option2 NUMBER;
1719: l_series_id NUMBER;
1720:
1721: l_kpi_info_rec BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type;
1722: l_kpi_info_tbl BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type;
1723:
1724: l_caching_key VARCHAR2(200);
1725: i NUMBER := 1;

Line 1722: l_kpi_info_tbl BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type;

1718: l_analysis_option2 NUMBER;
1719: l_series_id NUMBER;
1720:
1721: l_kpi_info_rec BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type;
1722: l_kpi_info_tbl BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type;
1723:
1724: l_caching_key VARCHAR2(200);
1725: i NUMBER := 1;
1726:

Line 1734: l_page_parameters BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type;

1730:
1731: l_db_user_id NUMBER;
1732: l_sysdate DATE := SYSDATE;
1733:
1734: l_page_parameters BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type;
1735:
1736: BEGIN
1737: FND_MSG_PUB.initialize;
1738:

Line 1990: x_page_parameters OUT NOCOPY BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,

1986:
1987: PROCEDURE Get_Page_Parameters(
1988: p_user_id IN VARCHAR2,
1989: p_page_id IN VARCHAR2,
1990: x_page_parameters OUT NOCOPY BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
1991: x_return_status OUT NOCOPY VARCHAR2,
1992: x_msg_count OUT NOCOPY NUMBER,
1993: x_msg_data OUT NOCOPY VARCHAR2
1994: ) IS

Line 2094: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,

2090: /************************************************************************************
2091: ************************************************************************************/
2092:
2093: PROCEDURE Get_Page_Parameter(
2094: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
2095: p_page_parameter_name IN VARCHAR2,
2096: x_page_parameter OUT NOCOPY BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Type
2097: ) IS
2098: i NUMBER;

Line 2096: x_page_parameter OUT NOCOPY BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Type

2092:
2093: PROCEDURE Get_Page_Parameter(
2094: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
2095: p_page_parameter_name IN VARCHAR2,
2096: x_page_parameter OUT NOCOPY BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Type
2097: ) IS
2098: i NUMBER;
2099: BEGIN
2100:

Line 2113: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type

2109: /************************************************************************************
2110: ************************************************************************************/
2111:
2112: FUNCTION Get_Time_Comparison_Parameter(
2113: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type
2114: ) RETURN VARCHAR2 IS
2115: i NUMBER;
2116: BEGIN
2117: FOR i IN 1..p_page_parameters.COUNT LOOP

Line 2133: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,

2129:
2130: PROCEDURE Get_Kpis_Data_From_PMF_PMV(
2131: p_user_id IN VARCHAR2,
2132: p_responsibility_id IN VARCHAR2,
2133: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
2134: p_page_id IN VARCHAR2,
2135: p_kpi_info_tbl IN OUT NOCOPY BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type,
2136: x_return_status OUT NOCOPY VARCHAR2,
2137: x_msg_count OUT NOCOPY NUMBER,

Line 2135: p_kpi_info_tbl IN OUT NOCOPY BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type,

2131: p_user_id IN VARCHAR2,
2132: p_responsibility_id IN VARCHAR2,
2133: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
2134: p_page_id IN VARCHAR2,
2135: p_kpi_info_tbl IN OUT NOCOPY BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type,
2136: x_return_status OUT NOCOPY VARCHAR2,
2137: x_msg_count OUT NOCOPY NUMBER,
2138: x_msg_data OUT NOCOPY VARCHAR2
2139: ) IS

Line 2144: l_ak_regions BSC_BIS_WRAPPER_PUB.t_array_of_varchar2;

2140:
2141: i NUMBER;
2142: j NUMBER;
2143: k NUMBER;
2144: l_ak_regions BSC_BIS_WRAPPER_PUB.t_array_of_varchar2;
2145: l_num_ak_regions NUMBER := 0;
2146:
2147: l_return_status VARCHAR2(2000);
2148: l_msg_count NUMBER;

Line 2152: l_default_dimension_levels BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type;

2148: l_msg_count NUMBER;
2149: l_msg_data VARCHAR2(32000);
2150:
2151: l_viewby_level VARCHAR2(200);
2152: l_default_dimension_levels BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type;
2153: l_default_time_level_from BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
2154: l_default_time_level_to BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
2155: l_time_comparison_type VARCHAR2(32000);
2156:

Line 2153: l_default_time_level_from BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;

2149: l_msg_data VARCHAR2(32000);
2150:
2151: l_viewby_level VARCHAR2(200);
2152: l_default_dimension_levels BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type;
2153: l_default_time_level_from BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
2154: l_default_time_level_to BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
2155: l_time_comparison_type VARCHAR2(32000);
2156:
2157: l_actual_value VARCHAR2(2000);

Line 2154: l_default_time_level_to BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;

2150:
2151: l_viewby_level VARCHAR2(200);
2152: l_default_dimension_levels BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type;
2153: l_default_time_level_from BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
2154: l_default_time_level_to BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
2155: l_time_comparison_type VARCHAR2(32000);
2156:
2157: l_actual_value VARCHAR2(2000);
2158: l_target_value VARCHAR2(2000);

Line 2461: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,

2457:
2458: PROCEDURE Get_Kpi_view_by(
2459: p_kpi_code IN NUMBER,
2460: p_dimset_id IN VARCHAR2,
2461: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
2462: x_viewby_level OUT NOCOPY VARCHAR2,
2463: x_return_status OUT NOCOPY VARCHAR2,
2464: x_msg_count OUT NOCOPY NUMBER,
2465: x_msg_data OUT NOCOPY VARCHAR2

Line 2472: l_level_view_by BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;

2468: TYPE RefCurTyp IS REF CURSOR;
2469: cv RefCurTyp;
2470:
2471: l_sql VARCHAR2(32000);
2472: l_level_view_by BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type;
2473:
2474: l_dimension_short_name VARCHAR2(2000);
2475: l_level_short_name VARCHAR2(2000);
2476: l_page_parameter_name VARCHAR2(32000);

Line 2477: l_page_parameter BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Type;

2473:
2474: l_dimension_short_name VARCHAR2(2000);
2475: l_level_short_name VARCHAR2(2000);
2476: l_page_parameter_name VARCHAR2(32000);
2477: l_page_parameter BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Type;
2478:
2479: BEGIN
2480: x_viewby_level := NULL;
2481:

Line 2744: p_array IN BSC_BIS_WRAPPER_PUB.t_array_of_varchar2,

2740: ***********************************************************************************/
2741:
2742: FUNCTION Item_Belong_To_Array_Varchar2(
2743: p_item IN VARCHAR2,
2744: p_array IN BSC_BIS_WRAPPER_PUB.t_array_of_varchar2,
2745: p_num_items IN NUMBER
2746: ) RETURN BOOLEAN IS
2747:
2748: h_i NUMBER;

Line 2769: p_kpi_info_tbl IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type,

2765: PROCEDURE Post_Measure_Data(
2766: p_user_id IN VARCHAR2,
2767: p_responsibility_id IN VARCHAR2,
2768: p_caching_key IN VARCHAR2,
2769: p_kpi_info_tbl IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type,
2770: x_return_status OUT NOCOPY VARCHAR2,
2771: x_msg_count OUT NOCOPY NUMBER,
2772: x_msg_data OUT NOCOPY VARCHAR2
2773: ) IS

Line 2982: l_kpi_info_tbl BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type;

2978:
2979: l_return_status VARCHAR2(2000);
2980: l_msg_count NUMBER;
2981: l_msg_data VARCHAR2(32000);
2982: l_kpi_info_tbl BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type;
2983:
2984: BEGIN
2985: FND_MSG_PUB.initialize;
2986: