DBA Data[Home] [Help]

APPS.BSC_BIS_WRAPPER_PVT dependencies on BIS_PMV_ACTUAL_PVT

Line 102: l_time_parameter BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;

98:
99: -- parameters to get actual from pmv
100: l_region_code VARCHAR2(2000) := NULL;
101: l_function_name VARCHAR2(2000) := NULL;
102: l_time_parameter BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
103: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
104: l_time_parameter_tmp BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
105: l_parameters_tmp BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
106: l_actual_attribute_code VARCHAR2(2000) := NULL;

Line 103: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;

99: -- parameters to get actual from pmv
100: l_region_code VARCHAR2(2000) := NULL;
101: l_function_name VARCHAR2(2000) := NULL;
102: l_time_parameter BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
103: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
104: l_time_parameter_tmp BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
105: l_parameters_tmp BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
106: l_actual_attribute_code VARCHAR2(2000) := NULL;
107: l_compareto_attribute_code VARCHAR2(2000) := NULL;

Line 104: l_time_parameter_tmp BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;

100: l_region_code VARCHAR2(2000) := NULL;
101: l_function_name VARCHAR2(2000) := NULL;
102: l_time_parameter BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
103: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
104: l_time_parameter_tmp BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
105: l_parameters_tmp BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
106: l_actual_attribute_code VARCHAR2(2000) := NULL;
107: l_compareto_attribute_code VARCHAR2(2000) := NULL;
108:

Line 105: l_parameters_tmp BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;

101: l_function_name VARCHAR2(2000) := NULL;
102: l_time_parameter BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
103: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
104: l_time_parameter_tmp BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
105: l_parameters_tmp BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
106: l_actual_attribute_code VARCHAR2(2000) := NULL;
107: l_compareto_attribute_code VARCHAR2(2000) := NULL;
108:
109: -- Others

Line 118: l_act_tbl BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_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;
118: l_act_tbl BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE;
119: l_actual_value NUMBER := NULL;
120: l_compareto_value NUMBER := NULL;
121: l_sum_actual_value NUMBER := NULL;
122: l_sum_compareto_value NUMBER := NULL;

Line 2161: l_time_parameter BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;

2157: l_actual_value VARCHAR2(2000);
2158: l_target_value VARCHAR2(2000);
2159: l_compareto_value VARCHAR2(2000);
2160:
2161: l_time_parameter BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
2162: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
2163: l_measure_attribute_codes BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE;
2164: l_ranking_level VARCHAR2(200);
2165: l_measure_tbl BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE;

Line 2162: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;

2158: l_target_value VARCHAR2(2000);
2159: l_compareto_value VARCHAR2(2000);
2160:
2161: l_time_parameter BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
2162: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
2163: l_measure_attribute_codes BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE;
2164: l_ranking_level VARCHAR2(200);
2165: l_measure_tbl BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE;
2166:

Line 2163: l_measure_attribute_codes BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE;

2159: l_compareto_value VARCHAR2(2000);
2160:
2161: l_time_parameter BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
2162: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
2163: l_measure_attribute_codes BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE;
2164: l_ranking_level VARCHAR2(200);
2165: l_measure_tbl BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE;
2166:
2167: l_fnd_miss_num NUMBER := 9.99E125;

Line 2165: l_measure_tbl BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE;

2161: l_time_parameter BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
2162: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
2163: l_measure_attribute_codes BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE;
2164: l_ranking_level VARCHAR2(200);
2165: l_measure_tbl BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE;
2166:
2167: l_fnd_miss_num NUMBER := 9.99E125;
2168:
2169: l_sum_actual_value NUMBER := NULL;