APPS.BIS_PMF_MIGRATION_PVT dependencies on BIS_TARGET_VALUES

Line 46: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE

42: --
43: TYPE dim_values_rec IS RECORD (
44: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
45: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
46: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE
47: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
48: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
49: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
50: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE

Line 47: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE

43: TYPE dim_values_rec IS RECORD (
44: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
45: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
46: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE
47: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
48: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
49: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
50: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
51: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE

Line 48: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE

44: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
45: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
46: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE
47: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
48: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
49: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
50: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
51: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
52: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE

Line 49: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE

45: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
46: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE
47: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
48: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
49: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
50: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
51: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
52: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE
53: ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE

Line 50: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE

46: ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE
47: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
48: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
49: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
50: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
51: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
52: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE
53: ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE
54: );

Line 51: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE

47: ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
48: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
49: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
50: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
51: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
52: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE
53: ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE
54: );
55: --

Line 52: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE

48: ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
49: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
50: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
51: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
52: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE
53: ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE
54: );
55: --
56: TYPE resequenced_dimensions IS RECORD (

Line 53: ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE

49: ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
50: ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
51: ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
52: ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE
53: ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE
54: );
55: --
56: TYPE resequenced_dimensions IS RECORD (
57: dim_level_col VARCHAR2(20000)