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.BSC_DESIGNER_PVT dependencies on BSC_UTILITY

Line 20: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

16: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;
17: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_MEASURES_B';
18: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_type := C_KPI_MEAS_TABLE;
19: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_column := C_INDICATOR;
20: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
21: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;
22: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).copy_type := C_MASTER_KPI;
23:
24: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;

Line 21: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;

17: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_MEASURES_B';
18: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_type := C_KPI_MEAS_TABLE;
19: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_column := C_INDICATOR;
20: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
21: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;
22: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).copy_type := C_MASTER_KPI;
23:
24: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;
25: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_KPI_MEASURE_PROPS';

Line 28: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

24: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;
25: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_KPI_MEASURE_PROPS';
26: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_type := C_KPI_MEAS_TABLE;
27: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_column := C_INDICATOR;
28: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
29: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;
30: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).copy_type := C_MASTER_KPI;
31:
32: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;

Line 29: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;

25: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_KPI_MEASURE_PROPS';
26: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_type := C_KPI_MEAS_TABLE;
27: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_column := C_INDICATOR;
28: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
29: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;
30: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).copy_type := C_MASTER_KPI;
31:
32: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;
33: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_COLOR_TYPE_PROPS';

Line 36: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

32: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;
33: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_COLOR_TYPE_PROPS';
34: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_type := C_KPI_MEAS_TABLE;
35: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_column := C_INDICATOR;
36: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
37: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;
38: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).copy_type := C_MASTER_KPI;
39:
40: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;

Line 37: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;

33: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_COLOR_TYPE_PROPS';
34: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_type := C_KPI_MEAS_TABLE;
35: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_column := C_INDICATOR;
36: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
37: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;
38: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).copy_type := C_MASTER_KPI;
39:
40: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;
41: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_KPI_MEASURE_WEIGHTS';

Line 44: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

40: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;
41: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_KPI_MEASURE_WEIGHTS';
42: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_type := C_KPI_MEAS_TABLE;
43: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_column := C_INDICATOR;
44: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
45: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;
46: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).copy_type := C_MASTER_KPI;
47:
48: /* No need to copy calculated color data since the Shared Objective and KPIs

Line 45: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;

41: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_KPI_MEASURE_WEIGHTS';
42: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_type := C_KPI_MEAS_TABLE;
43: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_column := C_INDICATOR;
44: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
45: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;
46: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).copy_type := C_MASTER_KPI;
47:
48: /* No need to copy calculated color data since the Shared Objective and KPIs
49: are put to prototype mode, when duplicated.

Line 54: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;*/

50: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;
51: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_SYS_KPI_COLORS';
52: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_type := C_KPI_MEAS_TABLE;
53: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_column := C_INDICATOR;
54: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;*/
55:
56: /* TABLES TO BE COPIED BASED ON OBJECTIVE */
57: g_num_kpi_metadata_tables := 0;
58:

Line 63: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

59: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
60: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPIS_B';
61: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE;
62: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR;
63: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
64: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
65: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
66:
67: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 64: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

60: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPIS_B';
61: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE;
62: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR;
63: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
64: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
65: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
66:
67: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
68: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPIS_TL';

Line 71: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

67: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
68: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPIS_TL';
69: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
70: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
71: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
72: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
73: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
74:
75: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 72: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

68: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPIS_TL';
69: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
70: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
71: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
72: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
73: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
74:
75: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
76: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_GROUPS';

Line 79: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

75: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
76: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_GROUPS';
77: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
78: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
79: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
80: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
81: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
82:
83: /*g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 80: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

76: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_GROUPS';
77: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
78: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
79: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
80: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
81: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
82:
83: /*g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
84: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_MEASURES_B';

Line 87: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;*/

83: /*g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
84: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_MEASURES_B';
85: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
86: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
87: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;*/
88:
89: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
90: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_MEASURES_TL';
91: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;

Line 93: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

89: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
90: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_MEASURES_TL';
91: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
92: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
93: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
94: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
95: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
96:
97: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 94: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

90: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_MEASURES_TL';
91: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
92: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
93: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
94: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
95: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
96:
97: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
98: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPTIONS_B';

Line 101: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

97: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
98: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPTIONS_B';
99: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
100: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
101: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
102: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
103: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
104:
105: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 102: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

98: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPTIONS_B';
99: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
100: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
101: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
102: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
103: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
104:
105: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
106: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPTIONS_TL';

Line 109: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

105: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
106: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPTIONS_TL';
107: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
108: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
109: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
110: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
111: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
112:
113: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 110: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

106: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPTIONS_TL';
107: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
108: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
109: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
110: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
111: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
112:
113: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
114: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPT_USER';

Line 117: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

113: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
114: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPT_USER';
115: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
116: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
117: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
118: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
119: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
120:
121: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 118: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

114: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPT_USER';
115: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
116: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
117: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
118: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
119: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
120:
121: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
122: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CALCULATIONS';

Line 125: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

121: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
122: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CALCULATIONS';
123: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
124: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
125: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
126: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
127: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
128:
129: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 126: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

122: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CALCULATIONS';
123: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
124: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
125: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
126: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
127: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
128:
129: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
130: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CALCULATIONS_USER';

Line 133: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

129: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
130: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CALCULATIONS_USER';
131: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
132: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
133: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
134: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
135: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
136:
137: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 134: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

130: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CALCULATIONS_USER';
131: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
132: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
133: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
134: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
135: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
136:
137: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
138: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CAUSE_EFFECT_RELS';

Line 141: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

137: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
138: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CAUSE_EFFECT_RELS';
139: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
140: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_CAUSE_INDICATOR ;
141: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
142: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
143: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
144:
145: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 142: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

138: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CAUSE_EFFECT_RELS';
139: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
140: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_CAUSE_INDICATOR ;
141: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
142: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
143: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
144:
145: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
146: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CAUSE_EFFECT_RELS';

Line 149: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

145: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
146: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CAUSE_EFFECT_RELS';
147: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
148: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_EFFECT_INDICATOR ;
149: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
150: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
151: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
152:
153: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 150: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

146: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CAUSE_EFFECT_RELS';
147: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
148: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_EFFECT_INDICATOR ;
149: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
150: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
151: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
152:
153: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
154: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DATA_TABLES';

Line 157: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

153: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
154: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DATA_TABLES';
155: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
156: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
157: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
158: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
159: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
160:
161: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 158: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

154: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DATA_TABLES';
155: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
156: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
157: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
158: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
159: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
160:
161: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
162: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DEFAULTS_B';

Line 165: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

161: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
162: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DEFAULTS_B';
163: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
164: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
165: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
166: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
167: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
168:
169: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 166: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

162: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DEFAULTS_B';
163: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
164: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
165: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
166: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
167: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
168:
169: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
170: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DEFAULTS_TL';

Line 173: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

169: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
170: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DEFAULTS_TL';
171: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
172: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
173: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
174: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
175: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
176:
177: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 174: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

170: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DEFAULTS_TL';
171: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
172: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
173: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
174: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
175: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
176:
177: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
178: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_GROUPS';

Line 181: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

177: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
178: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_GROUPS';
179: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
180: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
181: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
182: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
183: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_SHARED_KPI;
184:
185: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 182: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

178: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_GROUPS';
179: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
180: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
181: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
182: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
183: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_SHARED_KPI;
184:
185: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
186: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVELS_B';

Line 189: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

185: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
186: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVELS_B';
187: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
188: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
189: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
190: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
191: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
192:
193: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 190: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

186: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVELS_B';
187: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
188: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
189: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
190: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
191: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
192:
193: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
194: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVELS_TL';

Line 197: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

193: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
194: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVELS_TL';
195: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
196: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
197: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
198: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
199: --g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
200: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
201:

Line 198: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

194: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVELS_TL';
195: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
196: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
197: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
198: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
199: --g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
200: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
201:
202: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 206: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

202: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
203: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVELS_USER';
204: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
205: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
206: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
207: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
208: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
209:
210: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 207: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

203: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVELS_USER';
204: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
205: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
206: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
207: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
208: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
209:
210: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
211: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVEL_PROPERTIES';

Line 214: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

210: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
211: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVEL_PROPERTIES';
212: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
213: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
214: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
215: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
216: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
217:
218: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 215: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

211: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVEL_PROPERTIES';
212: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
213: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
214: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
215: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
216: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
217:
218: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
219: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_SETS_TL';

Line 222: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

218: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
219: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_SETS_TL';
220: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
221: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
222: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
223: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
224: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
225:
226: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 223: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

219: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_SETS_TL';
220: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
221: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
222: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
223: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
224: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
225:
226: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
227: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_GRAPHS';

Line 230: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

226: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
227: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_GRAPHS';
228: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
229: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
230: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
231: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
232: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
233:
234: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 231: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

227: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_GRAPHS';
228: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
229: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
230: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
231: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
232: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
233:
234: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
235: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_MM_CONTROLS';

Line 238: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

234: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
235: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_MM_CONTROLS';
236: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
237: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
238: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
239: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
240: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
241:
242: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 239: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

235: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_MM_CONTROLS';
236: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
237: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
238: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
239: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
240: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
241:
242: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
243: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PERIODICITIES';

Line 246: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

242: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
243: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PERIODICITIES';
244: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
245: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
246: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
247: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
248: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
249:
250: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 247: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

243: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PERIODICITIES';
244: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
245: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
246: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
247: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
248: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
249:
250: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
251: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PERIODICITIES_USER';

Line 254: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

250: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
251: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PERIODICITIES_USER';
252: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
253: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
254: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
255: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
256: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_SHARED_KPI;
257:
258: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 255: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

251: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PERIODICITIES_USER';
252: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
253: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
254: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
255: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
256: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_SHARED_KPI;
257:
258: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
259: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PROPERTIES';

Line 262: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

258: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
259: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PROPERTIES';
260: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
261: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
262: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
263: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
264: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
265:
266: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 263: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

259: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PROPERTIES';
260: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
261: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
262: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
263: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
264: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
265:
266: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
267: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_SERIES_COLORS';

Line 270: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

266: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
267: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_SERIES_COLORS';
268: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
269: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
270: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
271: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
272: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
273:
274: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 271: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

267: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_SERIES_COLORS';
268: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
269: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
270: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
271: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
272: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
273:
274: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
275: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_SHELL_CMDS_TL';

Line 278: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

274: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
275: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_SHELL_CMDS_TL';
276: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
277: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
278: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
279: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
280: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
281:
282: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 279: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

275: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_SHELL_CMDS_TL';
276: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
277: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
278: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
279: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
280: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
281:
282: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
283: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_SHELL_CMDS_USER';

Line 286: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

282: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
283: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_SHELL_CMDS_USER';
284: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
285: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
286: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
287: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
288: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
289:
290: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 287: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

283: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_SHELL_CMDS_USER';
284: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
285: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
286: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
287: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
288: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
289:
290: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
291: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_SUBTITLES_TL';

Line 294: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

290: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
291: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_SUBTITLES_TL';
292: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
293: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
294: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
295: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
296: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
297:
298: --Removed this as the simulation tree tables are copied separately

Line 295: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

291: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_SUBTITLES_TL';
292: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
293: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
294: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
295: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
296: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
297:
298: --Removed this as the simulation tree tables are copied separately
299: /*g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 303: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

299: /*g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
300: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_TREE_NODES_B';
301: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
302: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
303: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
304: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
305: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
306:
307: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 304: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

300: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_TREE_NODES_B';
301: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
302: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
303: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
304: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
305: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
306:
307: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
308: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_TREE_NODES_TL';

Line 311: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

307: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
308: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_TREE_NODES_TL';
309: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
310: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
311: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
312: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
313: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;*/
314:
315: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 312: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

308: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_TREE_NODES_TL';
309: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
310: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
311: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
312: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
313: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;*/
314:
315: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
316: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_FILES';

Line 319: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

315: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
316: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_FILES';
317: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
318: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
319: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
320: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
321: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
322:
323: /* No need to copy calculated color data since the Shared Objective and KPIs

Line 320: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

316: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_FILES';
317: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
318: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
319: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
320: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
321: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
322:
323: /* No need to copy calculated color data since the Shared Objective and KPIs
324: are put to prototype mode, when duplicated.

Line 329: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

325: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
326: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_KPI_COLORS';
327: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
328: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
329: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
330:
331: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
332: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_OBJECTIVE_COLORS';
333: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;

Line 335: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;*/

331: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
332: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_OBJECTIVE_COLORS';
333: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
334: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
335: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;*/
336:
337: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
338: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_LABELS_B';
339: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_SYSTEM_TABLE;

Line 341: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

337: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
338: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_LABELS_B';
339: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_SYSTEM_TABLE;
340: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_SOURCE_CODE ;
341: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
342: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
343: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
344:
345: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 342: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

338: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_LABELS_B';
339: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_SYSTEM_TABLE;
340: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_SOURCE_CODE ;
341: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
342: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
343: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
344:
345: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
346: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_LABELS_TL';

Line 349: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

345: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
346: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_LABELS_TL';
347: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_SYSTEM_TABLE ;
348: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_SOURCE_CODE ;
349: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
350: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
351: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
352:
353: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 350: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

346: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_LABELS_TL';
347: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_SYSTEM_TABLE ;
348: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_SOURCE_CODE ;
349: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
350: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
351: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
352:
353: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
354: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_LINES';

Line 357: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

353: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
354: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_LINES';
355: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_SYSTEM_TABLE ;
356: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_SOURCE_CODE ;
357: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
358: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
359: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
360:
361: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 358: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

354: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_LINES';
355: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_SYSTEM_TABLE ;
356: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_SOURCE_CODE ;
357: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
358: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
359: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
360:
361: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
362: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_USER_OPTIONS';

Line 365: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

361: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
362: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_USER_OPTIONS';
363: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_SYSTEM_TABLE ;
364: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_SOURCE_CODE ;
365: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
366: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
367: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
368:
369: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 366: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

362: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_SYS_USER_OPTIONS';
363: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_SYSTEM_TABLE ;
364: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_SOURCE_CODE ;
365: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
366: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
367: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
368:
369: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
370: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_TAB_INDICATORS';

Line 373: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.NO;

369: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
370: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_TAB_INDICATORS';
371: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
372: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
373: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.NO;
374: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
375: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
376:
377: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 374: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

370: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_TAB_INDICATORS';
371: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
372: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
373: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.NO;
374: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
375: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
376:
377: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
378: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_TAB_VIEW_KPI_TL';

Line 381: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

377: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
378: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_TAB_VIEW_KPI_TL';
379: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
380: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
381: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
382: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
383: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
384:
385: --Bug #5955966. This table should not be copied while creating a shared indicator

Line 382: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

378: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_TAB_VIEW_KPI_TL';
379: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
380: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
381: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
382: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
383: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
384:
385: --Bug #5955966. This table should not be copied while creating a shared indicator
386: /*g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 390: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

386: /*g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
387: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_USER_KPIGRAPH_PLUGS';
388: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
389: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
390: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
391: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
392: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;*/
393:
394: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;

Line 391: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

387: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_USER_KPIGRAPH_PLUGS';
388: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
389: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
390: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
391: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
392: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;*/
393:
394: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
395: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_USER_KPI_ACCESS';

Line 398: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;

394: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
395: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_USER_KPI_ACCESS';
396: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
397: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
398: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
399: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
400: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
401:
402: END Init_Kpi_Metadata_Tables_Array;

Line 399: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

395: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_USER_KPI_ACCESS';
396: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
397: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
398: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
399: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
400: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
401:
402: END Init_Kpi_Metadata_Tables_Array;
403: /********************************************************************************************/

Line 2060: IF (g_obj_kpi_metadata_tables(i).duplicate_data = BSC_UTILITY.YES) THEN

2056: Init_Kpi_Metadata_Tables_Array();
2057:
2058: -- Delete all the existing rows for the Target Objective (if any)
2059: FOR i IN 1 .. g_num_obj_kpi_metadata_tables LOOP
2060: IF (g_obj_kpi_metadata_tables(i).duplicate_data = BSC_UTILITY.YES) THEN
2061: h_sql := 'DELETE ' || g_obj_kpi_metadata_tables(i).table_name ||
2062: ' WHERE indicator = ' || p_trg_kpi;
2063: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
2064:

Line 2078: IF (g_obj_kpi_metadata_tables(i).duplicate_data = BSC_UTILITY.YES) THEN

2074:
2075: SELECT bsc_kpi_measure_s.NEXTVAL INTO l_trg_kpi_measure_id from dual;
2076:
2077: FOR i IN 1 .. g_num_obj_kpi_metadata_tables LOOP
2078: IF (g_obj_kpi_metadata_tables(i).duplicate_data = BSC_UTILITY.YES) THEN
2079: insert_kpi_meas_data (
2080: p_table_name => g_obj_kpi_metadata_tables(i).table_name
2081: , p_src_kpi => p_src_kpi
2082: , p_trg_kpi => p_trg_kpi

Line 2235: IF(g_kpi_metadata_tables(i).duplicate_data = bsc_utility.YES) THEN

2231:
2232: x_num := 0;
2233: IF x_Shared_apply = 0 THEN
2234: FOR i IN 1..g_num_kpi_metadata_tables LOOP
2235: IF(g_kpi_metadata_tables(i).duplicate_data = bsc_utility.YES) THEN
2236: l_num_kpi_metadata_tables := l_num_kpi_metadata_tables + 1;
2237: l_kpi_metadata_tables(l_num_kpi_metadata_tables).table_name := g_kpi_metadata_tables(i).table_name;
2238: l_kpi_metadata_tables(l_num_kpi_metadata_tables).table_type := g_kpi_metadata_tables(i).table_type;
2239: l_kpi_metadata_tables(l_num_kpi_metadata_tables).table_column := g_kpi_metadata_tables(i).table_column;

Line 3367: g_kpi_metadata_tables(i).mls_table = bsc_utility.YES THEN

3363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3364: END IF;
3365:
3366: IF g_kpi_metadata_tables(i).mls_table IS NOT NULL AND
3367: g_kpi_metadata_tables(i).mls_table = bsc_utility.YES THEN
3368: Process_TL_Table(
3369: p_commit => FND_API.G_FALSE
3370: ,p_DbLink_Name => p_DbLink_Name
3371: ,p_Table_Name => g_kpi_metadata_tables(i).table_name