APPS.BSC_KPI_ANALYSIS_MEASURES_PKG dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 22: cursor C is select ROWID from BSC_KPI_ANALYSIS_MEASURES_B

18: X_BM_COLOR in NUMBER,
19: X_NAME in VARCHAR2,
20: X_HELP in VARCHAR2
21: ) is
22: cursor C is select ROWID from BSC_KPI_ANALYSIS_MEASURES_B
23: where INDICATOR = X_INDICATOR
24: and ANALYSIS_OPTION0 = X_ANALYSIS_OPTION0
25: and ANALYSIS_OPTION1 = X_ANALYSIS_OPTION1
26: and ANALYSIS_OPTION2 = X_ANALYSIS_OPTION2

Line 30: insert into BSC_KPI_ANALYSIS_MEASURES_B (

26: and ANALYSIS_OPTION2 = X_ANALYSIS_OPTION2
27: and SERIES_ID = X_SERIES_ID
28: ;
29: begin
30: insert into BSC_KPI_ANALYSIS_MEASURES_B (
31: ANALYSIS_OPTION2,
32: SERIES_ID,
33: DATASET_ID,
34: AXIS,

Line 132: from BSC_KPI_ANALYSIS_MEASURES_B

128: BUDGET_FLAG,
129: DEFAULT_VALUE,
130: SERIES_COLOR,
131: BM_COLOR
132: from BSC_KPI_ANALYSIS_MEASURES_B
133: where INDICATOR = X_INDICATOR
134: and ANALYSIS_OPTION0 = X_ANALYSIS_OPTION0
135: and ANALYSIS_OPTION1 = X_ANALYSIS_OPTION1
136: and ANALYSIS_OPTION2 = X_ANALYSIS_OPTION2

Line 217: from bsc_kpi_analysis_measures_b

213: begin
214:
215: -- mdamle 4/23/2003 - PMD - Measure Definer - Update flag if dataset changed
216: select dataset_id into l_old_dataset_id
217: from bsc_kpi_analysis_measures_b
218: where INDICATOR = X_INDICATOR
219: and ANALYSIS_OPTION0 = X_ANALYSIS_OPTION0
220: and ANALYSIS_OPTION1 = X_ANALYSIS_OPTION1
221: and ANALYSIS_OPTION2 = X_ANALYSIS_OPTION2

Line 228: update BSC_KPI_ANALYSIS_MEASURES_B set

224: if (l_old_dataset_id <> X_DATASET_ID) then
225: BSC_DESIGNER_PVT.ActionFlag_Change(x_indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
226: end if;
227:
228: update BSC_KPI_ANALYSIS_MEASURES_B set
229: DATASET_ID = X_DATASET_ID,
230: AXIS = X_AXIS,
231: SERIES_TYPE = X_SERIES_TYPE,
232: STACK_SERIES_ID = X_STACK_SERIES_ID,

Line 283: delete from BSC_KPI_ANALYSIS_MEASURES_B

279: if (sql%notfound) then
280: raise no_data_found;
281: end if;
282:
283: delete from BSC_KPI_ANALYSIS_MEASURES_B
284: where INDICATOR = X_INDICATOR
285: and ANALYSIS_OPTION0 = X_ANALYSIS_OPTION0
286: and ANALYSIS_OPTION1 = X_ANALYSIS_OPTION1
287: and ANALYSIS_OPTION2 = X_ANALYSIS_OPTION2

Line 301: from BSC_KPI_ANALYSIS_MEASURES_B B

297: begin
298: delete from BSC_KPI_ANALYSIS_MEASURES_TL T
299: where not exists
300: (select NULL
301: from BSC_KPI_ANALYSIS_MEASURES_B B
302: where B.INDICATOR = T.INDICATOR
303: and B.ANALYSIS_OPTION0 = T.ANALYSIS_OPTION0
304: and B.ANALYSIS_OPTION1 = T.ANALYSIS_OPTION1
305: and B.ANALYSIS_OPTION2 = T.ANALYSIS_OPTION2