148:
149: l_Indicator_Region_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
150: l_Target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
151: l_Target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
152: l_Org_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
153: l_dim1_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
154: l_dim2_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
155: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
156: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
149: l_Indicator_Region_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
150: l_Target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
151: l_Target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
152: l_Org_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
153: l_dim1_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
154: l_dim2_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
155: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
156: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
157: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
150: l_Target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
151: l_Target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
152: l_Org_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
153: l_dim1_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
154: l_dim2_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
155: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
156: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
157: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
158: -- mdamle 01/15/2001 - Add Dim6 and Dim7
151: l_Target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
152: l_Org_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
153: l_dim1_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
154: l_dim2_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
155: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
156: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
157: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
158: -- mdamle 01/15/2001 - Add Dim6 and Dim7
159: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
152: l_Org_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
153: l_dim1_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
154: l_dim2_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
155: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
156: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
157: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
158: -- mdamle 01/15/2001 - Add Dim6 and Dim7
159: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
160: l_dim7_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
153: l_dim1_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
154: l_dim2_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
155: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
156: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
157: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
158: -- mdamle 01/15/2001 - Add Dim6 and Dim7
159: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
160: l_dim7_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
161:
155: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
156: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
157: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
158: -- mdamle 01/15/2001 - Add Dim6 and Dim7
159: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
160: l_dim7_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
161:
162: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
163: l_sob_level_id NUMBER;
156: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
157: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
158: -- mdamle 01/15/2001 - Add Dim6 and Dim7
159: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
160: l_dim7_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
161:
162: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
163: l_sob_level_id NUMBER;
164: l_time_level_id NUMBER;
161:
162: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
163: l_sob_level_id NUMBER;
164: l_time_level_id NUMBER;
165: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
166:
167: l_Org_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
168:
169:
163: l_sob_level_id NUMBER;
164: l_time_level_id NUMBER;
165: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
166:
167: l_Org_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
168:
169:
170: BEGIN
171:
451:
452: l_Indicator_Region_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
453: l_Target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
454: l_Target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
455: l_Org_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
456: l_dim1_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
457: l_dim2_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
458: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
459: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
452: l_Indicator_Region_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
453: l_Target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
454: l_Target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
455: l_Org_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
456: l_dim1_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
457: l_dim2_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
458: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
459: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
460: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
453: l_Target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
454: l_Target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
455: l_Org_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
456: l_dim1_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
457: l_dim2_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
458: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
459: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
460: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
461: -- mdamle 01/15/2001 - Add Dim6 and Dim7
454: l_Target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
455: l_Org_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
456: l_dim1_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
457: l_dim2_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
458: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
459: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
460: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
461: -- mdamle 01/15/2001 - Add Dim6 and Dim7
462: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
455: l_Org_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
456: l_dim1_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
457: l_dim2_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
458: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
459: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
460: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
461: -- mdamle 01/15/2001 - Add Dim6 and Dim7
462: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
463: l_dim7_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
456: l_dim1_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
457: l_dim2_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
458: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
459: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
460: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
461: -- mdamle 01/15/2001 - Add Dim6 and Dim7
462: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
463: l_dim7_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
464:
458: l_dim3_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
459: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
460: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
461: -- mdamle 01/15/2001 - Add Dim6 and Dim7
462: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
463: l_dim7_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
464:
465: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
466: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
459: l_dim4_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
460: l_dim5_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
461: -- mdamle 01/15/2001 - Add Dim6 and Dim7
462: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
463: l_dim7_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
464:
465: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
466: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
467: l_Org_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
462: l_dim6_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
463: l_dim7_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
464:
465: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
466: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
467: l_Org_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
468:
469: CURSOR c_user_ind_selection IS
470: select * from bis_user_ind_selections
463: l_dim7_level_value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
464:
465: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
466: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
467: l_Org_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
468:
469: CURSOR c_user_ind_selection IS
470: select * from bis_user_ind_selections
471: where Target_Level_ID = p_target_level_id;