26: This record type may already be there but did not have time to dig thru
27: */
28: TYPE target_level_rec IS RECORD(
29: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
30: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
31: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
32: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
33: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
34: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
27: */
28: TYPE target_level_rec IS RECORD(
29: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
30: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
31: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
32: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
33: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
34: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
35: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
28: TYPE target_level_rec IS RECORD(
29: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
30: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
31: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
32: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
33: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
34: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
35: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
36: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE
29: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
30: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
31: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
32: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
33: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
34: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
35: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
36: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE
37: ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID%TYPE
30: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
31: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
32: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
33: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
34: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
35: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
36: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE
37: ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID%TYPE
38: );
31: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
32: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
33: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
34: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
35: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
36: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE
37: ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID%TYPE
38: );
39: --
32: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
33: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
34: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
35: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
36: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE
37: ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID%TYPE
38: );
39: --
40: TYPE target_rec IS RECORD (
33: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
34: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
35: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
36: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE
37: ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID%TYPE
38: );
39: --
40: TYPE target_rec IS RECORD (
41: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
38: );
39: --
40: TYPE target_rec IS RECORD (
41: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
42: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
43: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE
44: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
45: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
46: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE