eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_PMF_MIGRATION_PVT dependencies on BIS_TARGET_LEVELS

Line 23: REM | order in bis_target_levels. |

19: REM | 21-July-2000 amkulkar Creation |
20: REM | 03-JUN-2004 ankgoel Modified for bug#3583357. Added procedures for |
21: REM | re-sequencing dimensions in |
22: REM | bis_indicator_dimensions using the dim level |
23: REM | order in bis_target_levels. |
24: REM +=======================================================================+
25: */
26: --
27: --

Line 33: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE

29: This record type may already be there but did not have time to dig thru
30: */
31: TYPE target_level_rec IS RECORD(
32: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
33: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
34: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
35: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
36: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
37: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE

Line 34: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE

30: */
31: TYPE target_level_rec IS RECORD(
32: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
33: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
34: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
35: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
36: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
37: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
38: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE

Line 35: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE

31: TYPE target_level_rec IS RECORD(
32: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
33: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
34: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
35: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
36: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
37: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
38: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
39: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE

Line 36: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE

32: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
33: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
34: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
35: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
36: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
37: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
38: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
39: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE
40: ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID%TYPE

Line 37: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE

33: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
34: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
35: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
36: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
37: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
38: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
39: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE
40: ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID%TYPE
41: );

Line 38: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE

34: ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
35: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
36: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
37: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
38: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
39: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE
40: ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID%TYPE
41: );
42: --

Line 39: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE

35: ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
36: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
37: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
38: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
39: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE
40: ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID%TYPE
41: );
42: --
43: TYPE dim_values_rec IS RECORD (

Line 40: ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID%TYPE

36: ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
37: ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
38: ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
39: ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE
40: ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID%TYPE
41: );
42: --
43: TYPE dim_values_rec IS RECORD (
44: measure_id BIS_INDICATORS.INDICATOR_ID%TYPE

Line 45: ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE

41: );
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