[Home] [Help]
15: X_USER_LEVEL2_DEFAULT in NUMBER,
16: X_NAME in VARCHAR2,
17: X_HELP in VARCHAR2
18: ) is
19: cursor C is select ROWID from BSC_KPI_ANALYSIS_OPTIONS_B
20: where INDICATOR = X_INDICATOR
21: and ANALYSIS_GROUP_ID = X_ANALYSIS_GROUP_ID
22: and OPTION_ID = X_OPTION_ID
23: and PARENT_OPTION_ID = X_PARENT_OPTION_ID
23: and PARENT_OPTION_ID = X_PARENT_OPTION_ID
24: and GRANDPARENT_OPTION_ID = X_GRANDPARENT_OPTION_ID
25: ;
26: begin
27: insert into BSC_KPI_ANALYSIS_OPTIONS_B (
28: INDICATOR,
29: ANALYSIS_GROUP_ID,
30: OPTION_ID,
31: PARENT_OPTION_ID,
113: USER_LEVEL1,
114: USER_LEVEL1_DEFAULT,
115: USER_LEVEL2,
116: USER_LEVEL2_DEFAULT
117: from BSC_KPI_ANALYSIS_OPTIONS_B
118: where INDICATOR = X_INDICATOR
119: and ANALYSIS_GROUP_ID = X_ANALYSIS_GROUP_ID
120: and OPTION_ID = X_OPTION_ID
121: and PARENT_OPTION_ID = X_PARENT_OPTION_ID
192: X_NAME in VARCHAR2,
193: X_HELP in VARCHAR2
194: ) is
195: begin
196: update BSC_KPI_ANALYSIS_OPTIONS_B set
197: DIM_SET_ID = X_DIM_SET_ID,
198: USER_LEVEL0 = X_USER_LEVEL0,
199: USER_LEVEL1 = X_USER_LEVEL1,
200: USER_LEVEL1_DEFAULT = X_USER_LEVEL1_DEFAULT,
244: if (sql%notfound) then
245: raise no_data_found;
246: end if;
247:
248: delete from BSC_KPI_ANALYSIS_OPTIONS_B
249: where INDICATOR = X_INDICATOR
250: and ANALYSIS_GROUP_ID = X_ANALYSIS_GROUP_ID
251: and OPTION_ID = X_OPTION_ID
252: and PARENT_OPTION_ID = X_PARENT_OPTION_ID
262: begin
263: delete from BSC_KPI_ANALYSIS_OPTIONS_TL T
264: where not exists
265: (select NULL
266: from BSC_KPI_ANALYSIS_OPTIONS_B B
267: where B.INDICATOR = T.INDICATOR
268: and B.ANALYSIS_GROUP_ID = T.ANALYSIS_GROUP_ID
269: and B.OPTION_ID = T.OPTION_ID
270: and B.PARENT_OPTION_ID = T.PARENT_OPTION_ID