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_SIMULATION_VIEW_PVT dependencies on BSC_SIMULATION_VIEW_PVT

Line 1: PACKAGE BODY BSC_SIMULATION_VIEW_PVT AS

1: PACKAGE BODY BSC_SIMULATION_VIEW_PVT AS
2: /* $Header: BSCSIMVB.pls 120.6.12000000.1 2007/07/17 07:44:29 appldev noship $ */
3:
4: FUNCTION Get_Default_Node
5: (

Line 69: l_grouping_separator := BSC_SIMULATION_VIEW_PVT.C_COMMA;

65: l_decimal_separator := SUBSTR(TRIM(l_number_format),0,1);
66: l_grouping_separator := SUBSTR(TRIM(l_number_format),2,2);
67:
68: ELSE
69: l_grouping_separator := BSC_SIMULATION_VIEW_PVT.C_COMMA;
70: l_decimal_separator := BSC_SIMULATION_VIEW_PVT.C_DOT;
71: END IF;
72:
73: OPEN l_cursor FOR l_sql USING l_grouping_separator,l_grouping_separator,

Line 70: l_decimal_separator := BSC_SIMULATION_VIEW_PVT.C_DOT;

66: l_grouping_separator := SUBSTR(TRIM(l_number_format),2,2);
67:
68: ELSE
69: l_grouping_separator := BSC_SIMULATION_VIEW_PVT.C_COMMA;
70: l_decimal_separator := BSC_SIMULATION_VIEW_PVT.C_DOT;
71: END IF;
72:
73: OPEN l_cursor FOR l_sql USING l_grouping_separator,l_grouping_separator,
74: l_decimal_separator;

Line 82: l_attribute7 := REPLACE(l_attribute7,BSC_SIMULATION_VIEW_PVT.C_COMMA,'G');

78: END LOOP;
79:
80: --PMVs requirement is to replace , with G and . with D
81:
82: l_attribute7 := REPLACE(l_attribute7,BSC_SIMULATION_VIEW_PVT.C_COMMA,'G');
83: l_attribute7 := REPLACE(l_attribute7,BSC_SIMULATION_VIEW_PVT.C_DOT,'D');
84:
85: RETURN l_attribute7;
86:

Line 83: l_attribute7 := REPLACE(l_attribute7,BSC_SIMULATION_VIEW_PVT.C_DOT,'D');

79:
80: --PMVs requirement is to replace , with G and . with D
81:
82: l_attribute7 := REPLACE(l_attribute7,BSC_SIMULATION_VIEW_PVT.C_COMMA,'G');
83: l_attribute7 := REPLACE(l_attribute7,BSC_SIMULATION_VIEW_PVT.C_DOT,'D');
84:
85: RETURN l_attribute7;
86:
87: END Get_Format;

Line 137: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_SYSTEM_TABLE ;

133: x_Table_Number := 0;
134:
135: x_Table_Number := x_Table_Number + 1;
136: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_SYS_IMAGES_MAP_TL';
137: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_SYSTEM_TABLE ;
138: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_SOURCE_CODE;
139: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
140: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
141:

Line 138: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_SOURCE_CODE;

134:
135: x_Table_Number := x_Table_Number + 1;
136: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_SYS_IMAGES_MAP_TL';
137: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_SYSTEM_TABLE ;
138: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_SOURCE_CODE;
139: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
140: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
141:
142:

Line 145: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_SYSTEM_TABLE;

141:
142:
143: x_Table_Number := x_Table_Number + 1;
144: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_SYS_IMAGES';
145: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_SYSTEM_TABLE;
146: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_IMAGE_ID;
147: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
148: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
149:

Line 146: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_IMAGE_ID;

142:
143: x_Table_Number := x_Table_Number + 1;
144: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_SYS_IMAGES';
145: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_SYSTEM_TABLE;
146: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_IMAGE_ID;
147: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
148: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
149:
150:

Line 153: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_TAB_VIEW_TABLE ;

149:
150:
151: x_Table_Number := x_Table_Number + 1;
152: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_TAB_VIEW_LABELS_B';
153: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_TAB_VIEW_TABLE ;
154: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_TAB_VIEW ;
155: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
156: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
157:

Line 154: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_TAB_VIEW ;

150:
151: x_Table_Number := x_Table_Number + 1;
152: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_TAB_VIEW_LABELS_B';
153: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_TAB_VIEW_TABLE ;
154: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_TAB_VIEW ;
155: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
156: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
157:
158: x_Table_Number := x_Table_Number + 1;

Line 160: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_TAB_VIEW_TABLE;

156: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
157:
158: x_Table_Number := x_Table_Number + 1;
159: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_TAB_VIEW_LABELS_TL';
160: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_TAB_VIEW_TABLE;
161: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_TAB_VIEW;
162: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
163: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
164:

Line 161: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_TAB_VIEW;

157:
158: x_Table_Number := x_Table_Number + 1;
159: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_TAB_VIEW_LABELS_TL';
160: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_TAB_VIEW_TABLE;
161: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_TAB_VIEW;
162: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
163: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
164:
165: x_Table_Number := x_Table_Number + 1;

Line 167: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_KPI_TABLE ;

163: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
164:
165: x_Table_Number := x_Table_Number + 1;
166: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_KPI_TREE_NODES_B';
167: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_KPI_TABLE ;
168: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_INDICATOR ;
169: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
170: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
171:

Line 168: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_INDICATOR ;

164:
165: x_Table_Number := x_Table_Number + 1;
166: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_KPI_TREE_NODES_B';
167: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_KPI_TABLE ;
168: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_INDICATOR ;
169: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
170: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
171:
172:

Line 175: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_KPI_TABLE ;

171:
172:
173: x_Table_Number := x_Table_Number + 1;
174: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_KPI_TREE_NODES_TL';
175: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_KPI_TABLE ;
176: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_INDICATOR ;
177: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
178: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
179:

Line 176: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_INDICATOR ;

172:
173: x_Table_Number := x_Table_Number + 1;
174: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_KPI_TREE_NODES_TL';
175: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_KPI_TABLE ;
176: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_INDICATOR ;
177: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
178: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
179:
180: IF(p_copy_Ak_Tables=FND_API.G_TRUE)THEN

Line 184: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

180: IF(p_copy_Ak_Tables=FND_API.G_TRUE)THEN
181:
182: x_Table_Number := x_Table_Number + 1;
183: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGIONS';
184: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
185: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
186: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
187: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
188:

Line 185: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

181:
182: x_Table_Number := x_Table_Number + 1;
183: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGIONS';
184: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
185: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
186: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
187: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
188:
189:

Line 192: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

188:
189:
190: x_Table_Number := x_Table_Number + 1;
191: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGIONS_TL';
192: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
193: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
194: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
195: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
196:

Line 193: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

189:
190: x_Table_Number := x_Table_Number + 1;
191: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGIONS_TL';
192: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
193: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
194: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
195: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
196:
197:

Line 200: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

196:
197:
198: x_Table_Number := x_Table_Number + 1;
199: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGION_ITEMS';
200: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
201: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
202: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
203: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
204:

Line 201: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

197:
198: x_Table_Number := x_Table_Number + 1;
199: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGION_ITEMS';
200: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
201: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
202: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
203: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
204:
205:

Line 208: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

204:
205:
206: x_Table_Number := x_Table_Number + 1;
207: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGION_ITEMS_TL';
208: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
209: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
210: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
211: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
212:

Line 209: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

205:
206: x_Table_Number := x_Table_Number + 1;
207: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGION_ITEMS_TL';
208: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
209: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
210: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
211: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
212:
213: x_Table_Number := x_Table_Number + 1;

Line 215: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

211: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
212:
213: x_Table_Number := x_Table_Number + 1;
214: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_CUSTOMIZATIONS';
215: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
216: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
217: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.NO;
218:
219:

Line 216: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

212:
213: x_Table_Number := x_Table_Number + 1;
214: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_CUSTOMIZATIONS';
215: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
216: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
217: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.NO;
218:
219:
220: x_Table_Number := x_Table_Number + 1;

Line 222: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

218:
219:
220: x_Table_Number := x_Table_Number + 1;
221: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_CUSTOMIZATIONS_TL';
222: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
223: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
224: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
225: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
226:

Line 223: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

219:
220: x_Table_Number := x_Table_Number + 1;
221: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_CUSTOMIZATIONS_TL';
222: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
223: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
224: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
225: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
226:
227:

Line 230: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

226:
227:
228: x_Table_Number := x_Table_Number + 1;
229: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_CUSTOM_REGIONS';
230: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
231: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
232: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
233: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
234:

Line 231: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

227:
228: x_Table_Number := x_Table_Number + 1;
229: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_CUSTOM_REGIONS';
230: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
231: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
232: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
233: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
234:
235:

Line 238: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

234:
235:
236: x_Table_Number := x_Table_Number + 1;
237: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_CUSTOM_REGIONS_TL';
238: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
239: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
240: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
241: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
242:

Line 239: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

235:
236: x_Table_Number := x_Table_Number + 1;
237: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_CUSTOM_REGIONS_TL';
238: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
239: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
240: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
241: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
242:
243: x_Table_Number := x_Table_Number + 1;

Line 245: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

241: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
242:
243: x_Table_Number := x_Table_Number + 1;
244: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_CUSTOM_REGION_ITEMS';
245: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
246: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
247: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
248: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
249:

Line 246: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

242:
243: x_Table_Number := x_Table_Number + 1;
244: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_CUSTOM_REGION_ITEMS';
245: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
246: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
247: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
248: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
249:
250:

Line 253: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

249:
250:
251: x_Table_Number := x_Table_Number + 1;
252: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_CUSTOM_REGION_ITEMS_TL';
253: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
254: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
255: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
256: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
257:

Line 254: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

250:
251: x_Table_Number := x_Table_Number + 1;
252: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_CUSTOM_REGION_ITEMS_TL';
253: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
254: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
255: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
256: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
257:
258:

Line 261: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

257:
258:
259: x_Table_Number := x_Table_Number + 1;
260: x_kpi_metadata_tables(x_Table_Number).table_name := 'BIS_AK_CUSTOM_REGION_ITEMS';
261: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
262: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
263: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
264: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
265:

Line 262: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

258:
259: x_Table_Number := x_Table_Number + 1;
260: x_kpi_metadata_tables(x_Table_Number).table_name := 'BIS_AK_CUSTOM_REGION_ITEMS';
261: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
262: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
263: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
264: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
265:
266: x_Table_Number := x_Table_Number + 1;

Line 268: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

264: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
265:
266: x_Table_Number := x_Table_Number + 1;
267: x_kpi_metadata_tables(x_Table_Number).table_name := 'BIS_AK_CUSTOM_REGIONS';
268: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
269: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
270: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
271: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
272:

Line 269: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

265:
266: x_Table_Number := x_Table_Number + 1;
267: x_kpi_metadata_tables(x_Table_Number).table_name := 'BIS_AK_CUSTOM_REGIONS';
268: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
269: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
270: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
271: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
272:
273: x_Table_Number := x_Table_Number + 1;

Line 275: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

271: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
272:
273: x_Table_Number := x_Table_Number + 1;
274: x_kpi_metadata_tables(x_Table_Number).table_name := 'BIS_AK_REGION_EXTENSION';
275: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
276: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
277: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
278: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
279:

Line 276: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

272:
273: x_Table_Number := x_Table_Number + 1;
274: x_kpi_metadata_tables(x_Table_Number).table_name := 'BIS_AK_REGION_EXTENSION';
275: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
276: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
277: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
278: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
279:
280: x_Table_Number := x_Table_Number + 1;

Line 282: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

278: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
279:
280: x_Table_Number := x_Table_Number + 1;
281: x_kpi_metadata_tables(x_Table_Number).table_name := 'BIS_AK_REGION_ITEM_EXTENSION';
282: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
283: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
284: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
285: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
286:

Line 283: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;

279:
280: x_Table_Number := x_Table_Number + 1;
281: x_kpi_metadata_tables(x_Table_Number).table_name := 'BIS_AK_REGION_ITEM_EXTENSION';
282: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;
283: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_AK_COLUMN ;
284: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
285: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
286:
287:

Line 291: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE ;

287:
288: --////////////Fnd form functions table //////////////
289: x_Table_Number := x_Table_Number + 1;
290: x_kpi_metadata_tables(x_Table_Number).table_name := 'FND_FORM_FUNCTIONS';
291: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE ;
292: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_FORM_COLUMN ;
293: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
294: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
295:

Line 292: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_FORM_COLUMN ;

288: --////////////Fnd form functions table //////////////
289: x_Table_Number := x_Table_Number + 1;
290: x_kpi_metadata_tables(x_Table_Number).table_name := 'FND_FORM_FUNCTIONS';
291: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE ;
292: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_FORM_COLUMN ;
293: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
294: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.NO;
295:
296:

Line 299: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE ;

295:
296:
297: x_Table_Number := x_Table_Number + 1;
298: x_kpi_metadata_tables(x_Table_Number).table_name := 'FND_FORM_FUNCTIONS_TL';
299: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE ;
300: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_FORM_COLUMN ;
301: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
302: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
303:

Line 300: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_FORM_COLUMN ;

296:
297: x_Table_Number := x_Table_Number + 1;
298: x_kpi_metadata_tables(x_Table_Number).table_name := 'FND_FORM_FUNCTIONS_TL';
299: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE ;
300: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_FORM_COLUMN ;
301: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
302: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
303:
304: END IF;

Line 375: IF(p_table_type =BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN

371: FETCH cd INTO l_region_code;
372: CLOSE cd;
373:
374: l_new_region_code := p_new_region_code;
375: IF(p_table_type =BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN
376: h_key_name := 'FUNCTION_NAME';
377: l_new_function_id := p_new_form_function;
378: h_condition := 'FUNCTION_NAME =''' || l_region_code || '''';
379:

Line 483: IF( p_table_column = BSC_SIMULATION_VIEW_PVT.C_SOURCE_CODE )THEN

479:
480: BSC_APPS.Init_Bsc_Apps;
481:
482: h_key_name := 'TAB_VIEW_ID';
483: IF( p_table_column = BSC_SIMULATION_VIEW_PVT.C_SOURCE_CODE )THEN
484: h_key_name := 'SOURCE_CODE';
485: ELSIF (p_table_column = BSC_SIMULATION_VIEW_PVT.C_INDICATOR) THEN
486: h_key_name := 'INDICATOR';
487: END IF;

Line 485: ELSIF (p_table_column = BSC_SIMULATION_VIEW_PVT.C_INDICATOR) THEN

481:
482: h_key_name := 'TAB_VIEW_ID';
483: IF( p_table_column = BSC_SIMULATION_VIEW_PVT.C_SOURCE_CODE )THEN
484: h_key_name := 'SOURCE_CODE';
485: ELSIF (p_table_column = BSC_SIMULATION_VIEW_PVT.C_INDICATOR) THEN
486: h_key_name := 'INDICATOR';
487: END IF;
488:
489:

Line 616: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array

612:
613: IF( l_count =0 )THEN
614: BSC_APPS.Init_Bsc_Apps;
615:
616: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array
617: (
618: p_copy_Ak_Tables => FND_API.G_FALSE
619: ,x_Table_Number => l_Table_Number
620: ,x_kpi_metadata_tables => l_kpi_metadata_tables

Line 711: BSC_SIMULATION_VIEW_PVT.set_default_node

707: l_dataset_id:= l_node_id;
708: END IF;
709: END IF;
710:
711: BSC_SIMULATION_VIEW_PVT.set_default_node
712: (
713: p_indicator => p_target_kpi
714: ,p_default_node => 1
715: ,p_dataset_id => l_dataset_id

Line 974: SELECT DECODE(p_color_flag,1,BSC_SIMULATION_VIEW_PVT.C_SHOW_COLOR,BSC_SIMULATION_VIEW_PVT.C_DISABLE_COLOR)

970: --This flag is used to show the color of the sim node in the objective layout page.
971: --As of now I am passing the value as 'F' i.e to show the color always.
972: --DECODE(p_color_flag,1,'F','Y')
973:
974: SELECT DECODE(p_color_flag,1,BSC_SIMULATION_VIEW_PVT.C_SHOW_COLOR,BSC_SIMULATION_VIEW_PVT.C_DISABLE_COLOR)
975: INTO l_kpi_measure_rec.disable_color
976: FROM DUAL;
977:
978: l_kpi_measure_rec.objective_id := p_indicator;

Line 1289: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array

1285: x_return_status := FND_API.G_RET_STS_SUCCESS;
1286:
1287: BSC_APPS.Init_Bsc_Apps;
1288:
1289: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array
1290: (
1291: p_copy_Ak_Tables => FND_API.G_TRUE
1292: ,x_Table_Number => l_Table_Number
1293: ,x_kpi_metadata_tables => l_kpi_metadata_tables

Line 1313: IF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND (l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_AK_TABLE AND l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)) THEN

1309: END LOOP;
1310:
1311: FOR i_index IN 1..l_Table_Number LOOP
1312:
1313: IF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND (l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_AK_TABLE AND l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)) THEN
1314: Copy_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, p_source_kpi, p_target_kpi);
1315: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_AK_TABLE) THEN
1316: Copy_Ak_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, p_source_kpi, p_target_kpi,l_new_region_code,NULL);
1317: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN

Line 1315: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_AK_TABLE) THEN

1311: FOR i_index IN 1..l_Table_Number LOOP
1312:
1313: IF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND (l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_AK_TABLE AND l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)) THEN
1314: Copy_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, p_source_kpi, p_target_kpi);
1315: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_AK_TABLE) THEN
1316: Copy_Ak_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, p_source_kpi, p_target_kpi,l_new_region_code,NULL);
1317: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN
1318: Copy_Ak_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, p_source_kpi, p_target_kpi,l_new_region_code,l_new_function_id);
1319: END IF;

Line 1317: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN

1313: IF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND (l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_AK_TABLE AND l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)) THEN
1314: Copy_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, p_source_kpi, p_target_kpi);
1315: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_AK_TABLE) THEN
1316: Copy_Ak_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, p_source_kpi, p_target_kpi,l_new_region_code,NULL);
1317: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN
1318: Copy_Ak_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, p_source_kpi, p_target_kpi,l_new_region_code,l_new_function_id);
1319: END IF;
1320: END LOOP;
1321:

Line 1327: SET attribute8 = p_target_kpi || '.'||BSC_SIMULATION_VIEW_PVT.C_DEFAULT_ANA_OPTION

1323: SET short_name =l_new_region_code
1324: WHERE indicator =p_target_kpi;
1325:
1326: UPDATE ak_regions
1327: SET attribute8 = p_target_kpi || '.'||BSC_SIMULATION_VIEW_PVT.C_DEFAULT_ANA_OPTION
1328: WHERE region_code =l_new_region_code;
1329:
1330: UPDATE bsc_kpi_analysis_options_b
1331: SET short_name =l_new_region_code

Line 1364: AND a.attribute1=BSC_SIMULATION_VIEW_PVT.C_MEASURE_NOTARGET

1360: FROM ak_region_items_vl a,ak_region_items_vl b
1361: WHERE a.region_code =b.region_code
1362: AND b.attribute2(+)=a.attribute_code
1363: AND a.REGION_CODE = l_region_code
1364: AND a.attribute1=BSC_SIMULATION_VIEW_PVT.C_MEASURE_NOTARGET
1365: AND a.attribute2= l_meas_short_name;
1366:
1367: BEGIN
1368: SAVEPOINT SetAkFormatId;

Line 1465: l_shared_Obj_Tbl BSC_SIMULATION_VIEW_PVT.Bsc_Shared_Obj_Tbl_Type ;

1461: l_source_kpi BSC_KPIS_B.indicator%TYPE;
1462: l_target_kpi BSC_KPIS_B.indicator%TYPE;
1463: l_default_node BSC_SYS_DATASETS_VL.dataset_id%TYPE;
1464: l_count NUMBER;
1465: l_shared_Obj_Tbl BSC_SIMULATION_VIEW_PVT.Bsc_Shared_Obj_Tbl_Type ;
1466: l_function_name FND_FORM_FUNCTIONS.function_name%TYPE;
1467:
1468: BEGIN
1469:

Line 1513: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array

1509: --Now we will initialize the tables from where we need to copy the data to sim objectives
1510:
1511: BSC_APPS.Init_Bsc_Apps;
1512:
1513: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array
1514: (
1515: p_copy_Ak_Tables => FND_API.G_TRUE
1516: ,x_Table_Number => l_Table_Number
1517: ,x_kpi_metadata_tables => l_kpi_metadata_tables

Line 1529: IF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND (l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_AK_TABLE AND l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)) THEN

1525: l_target_kpi := l_shared_Obj_Tbl(i).target_kpi;
1526: l_function_id := l_shared_Obj_Tbl(i).function_id ;
1527:
1528: FOR i_index IN 1..l_Table_Number LOOP
1529: IF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND (l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_AK_TABLE AND l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)) THEN
1530: Copy_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, l_source_kpi, l_target_kpi);
1531: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_AK_TABLE) THEN
1532: Copy_Ak_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, l_source_kpi, l_target_kpi,l_region_code,NULL);
1533: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN

Line 1531: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_AK_TABLE) THEN

1527:
1528: FOR i_index IN 1..l_Table_Number LOOP
1529: IF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND (l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_AK_TABLE AND l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)) THEN
1530: Copy_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, l_source_kpi, l_target_kpi);
1531: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_AK_TABLE) THEN
1532: Copy_Ak_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, l_source_kpi, l_target_kpi,l_region_code,NULL);
1533: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN
1534: Copy_Ak_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, l_source_kpi, l_target_kpi,l_region_code,l_function_id);
1535: END IF;

Line 1533: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN

1529: IF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND (l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_AK_TABLE AND l_kpi_metadata_tables(i_index).table_type<>BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)) THEN
1530: Copy_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, l_source_kpi, l_target_kpi);
1531: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_AK_TABLE) THEN
1532: Copy_Ak_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, l_source_kpi, l_target_kpi,l_region_code,NULL);
1533: ELSIF(l_kpi_metadata_tables(i_index).duplicate_data = bsc_utility.YES AND l_kpi_metadata_tables(i_index).table_type=BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN
1534: Copy_Ak_Record_Table(l_kpi_metadata_tables(i_index).table_name,l_kpi_metadata_tables(i_index).table_type,l_kpi_metadata_tables(i_index).table_column, l_source_kpi, l_target_kpi,l_region_code,l_function_id);
1535: END IF;
1536: END LOOP;
1537:

Line 1539: SET attribute8 = l_target_kpi || '.'||BSC_SIMULATION_VIEW_PVT.C_DEFAULT_ANA_OPTION

1535: END IF;
1536: END LOOP;
1537:
1538: UPDATE ak_regions
1539: SET attribute8 = l_target_kpi || '.'||BSC_SIMULATION_VIEW_PVT.C_DEFAULT_ANA_OPTION
1540: WHERE region_code =l_region_code;
1541:
1542: IF(l_default_node IS NOT NULL) THEN
1543:

Line 1740: x_msg_data := x_msg_data || ' ->BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';

1736: WHEN NO_DATA_FOUND THEN
1737: ROLLBACK TO BscSimCopyDimGrp;
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1739: IF (x_msg_data IS NOT NULL) THEN
1740: x_msg_data := x_msg_data || ' ->BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';
1741: ELSE
1742: x_msg_data := SQLERRM || 'at BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';
1743: END IF;
1744: WHEN OTHERS THEN

Line 1742: x_msg_data := SQLERRM || 'at BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';

1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1739: IF (x_msg_data IS NOT NULL) THEN
1740: x_msg_data := x_msg_data || ' ->BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';
1741: ELSE
1742: x_msg_data := SQLERRM || 'at BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';
1743: END IF;
1744: WHEN OTHERS THEN
1745: ROLLBACK TO BscSimCopyDimGrp;
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1748: x_msg_data := x_msg_data || ' ->BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';

1744: WHEN OTHERS THEN
1745: ROLLBACK TO BscSimCopyDimGrp;
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: IF (x_msg_data IS NOT NULL) THEN
1748: x_msg_data := x_msg_data || ' ->BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';
1749: ELSE
1750: x_msg_data := SQLERRM || ' at BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';
1751: END IF;
1752: END Copy_Dimension_Group;

Line 1750: x_msg_data := SQLERRM || ' at BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';

1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: IF (x_msg_data IS NOT NULL) THEN
1748: x_msg_data := x_msg_data || ' ->BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';
1749: ELSE
1750: x_msg_data := SQLERRM || ' at BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';
1751: END IF;
1752: END Copy_Dimension_Group;
1753:
1754: /***************************************

Line 1865: END BSC_SIMULATION_VIEW_PVT;

1861: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1862:
1863: END Set_Sim_Key_Values;
1864:
1865: END BSC_SIMULATION_VIEW_PVT;