DBA Data[Home] [Help]

APPS.BIS_PMF_MIGRATION_PUB dependencies on BIS_TARGET_LEVELS

Line 30: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE

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

Line 31: ,org_levelid BIS_TARGET_LEVELS.ORG_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

Line 32: ,time_levelid BIS_TARGET_LEVELS.TIME_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

Line 33: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_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

Line 34: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_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: );

Line 35: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_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: );
39: --

Line 36: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_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: --
40: TYPE target_rec IS RECORD (

Line 37: ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_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 (
41: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE

Line 42: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_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