APPS.BSC_KPI_DIM_LEVELS_PKG dependencies on BSC_KPI_DIM_LEVELS_B

Line 39: cursor C is select ROWID from BSC_KPI_DIM_LEVELS_B

35: X_HELP in VARCHAR2,
36: X_TOTAL_DISP_NAME in VARCHAR2,
37: X_COMP_DISP_NAME in VARCHAR2
38: ) is
39: cursor C is select ROWID from BSC_KPI_DIM_LEVELS_B
40: where INDICATOR = X_INDICATOR
41: and DIM_SET_ID = X_DIM_SET_ID
42: and DIM_LEVEL_INDEX = X_DIM_LEVEL_INDEX
43: ;

Line 45: insert into BSC_KPI_DIM_LEVELS_B (

41: and DIM_SET_ID = X_DIM_SET_ID
42: and DIM_LEVEL_INDEX = X_DIM_LEVEL_INDEX
43: ;
44: begin
45: insert into BSC_KPI_DIM_LEVELS_B (
46: INDICATOR,
47: DIM_SET_ID,
48: DIM_LEVEL_INDEX,
49: LEVEL_TABLE_NAME,

Line 209: from BSC_KPI_DIM_LEVELS_B

205: USER_LEVEL1,
206: USER_LEVEL1_DEFAULT,
207: USER_LEVEL2,
208: USER_LEVEL2_DEFAULT
209: from BSC_KPI_DIM_LEVELS_B
210: where INDICATOR = X_INDICATOR
211: and DIM_SET_ID = X_DIM_SET_ID
212: and DIM_LEVEL_INDEX = X_DIM_LEVEL_INDEX
213: for update of INDICATOR nowait;

Line 345: update BSC_KPI_DIM_LEVELS_B set

341: X_TOTAL_DISP_NAME in VARCHAR2,
342: X_COMP_DISP_NAME in VARCHAR2
343: ) is
344: begin
345: update BSC_KPI_DIM_LEVELS_B set
346: LEVEL_TABLE_NAME = X_LEVEL_TABLE_NAME,
347: LEVEL_VIEW_NAME = X_LEVEL_VIEW_NAME,
348: FILTER_COLUMN = X_FILTER_COLUMN,
349: FILTER_VALUE = X_FILTER_VALUE,

Line 411: delete from BSC_KPI_DIM_LEVELS_B

407: if (sql%notfound) then
408: raise no_data_found;
409: end if;
410:
411: delete from BSC_KPI_DIM_LEVELS_B
412: where INDICATOR = X_INDICATOR
413: and DIM_SET_ID = X_DIM_SET_ID
414: and DIM_LEVEL_INDEX = X_DIM_LEVEL_INDEX;
415:

Line 427: from BSC_KPI_DIM_LEVELS_B B

423: begin
424: delete from BSC_KPI_DIM_LEVELS_TL T
425: where not exists
426: (select NULL
427: from BSC_KPI_DIM_LEVELS_B B
428: where B.INDICATOR = T.INDICATOR
429: and B.DIM_SET_ID = T.DIM_SET_ID
430: and B.DIM_LEVEL_INDEX = T.DIM_LEVEL_INDEX
431: );