APPS.BSC_KPI_DEFAULTS_PKG dependencies on BSC_KPI_DEFAULTS_B

Line 44: cursor C is select ROWID from BSC_KPI_DEFAULTS_B

40: X_DIM_LEVEL6_TEXT in VARCHAR2,
41: X_DIM_LEVEL7_TEXT in VARCHAR2,
42: X_DIM_LEVEL8_TEXT in VARCHAR2
43: ) is
44: cursor C is select ROWID from BSC_KPI_DEFAULTS_B
45: where TAB_ID = X_TAB_ID
46: and INDICATOR = X_INDICATOR
47: ;
48: begin

Line 49: insert into BSC_KPI_DEFAULTS_B (

45: where TAB_ID = X_TAB_ID
46: and INDICATOR = X_INDICATOR
47: ;
48: begin
49: insert into BSC_KPI_DEFAULTS_B (
50: TAB_ID,
51: INDICATOR,
52: FORMAT_MASK,
53: COLOR_METHOD,

Line 214: from BSC_KPI_DEFAULTS_B

210: DIM_LEVEL5_VALUE,
211: DIM_LEVEL6_VALUE,
212: DIM_LEVEL7_VALUE,
213: DIM_LEVEL8_VALUE
214: from BSC_KPI_DEFAULTS_B
215: where TAB_ID = X_TAB_ID
216: and INDICATOR = X_INDICATOR
217: for update of TAB_ID nowait;
218: recinfo c%rowtype;

Line 390: update BSC_KPI_DEFAULTS_B set

386: X_DIM_LEVEL7_TEXT in VARCHAR2,
387: X_DIM_LEVEL8_TEXT in VARCHAR2
388: ) is
389: begin
390: update BSC_KPI_DEFAULTS_B set
391: FORMAT_MASK = X_FORMAT_MASK,
392: COLOR_METHOD = X_COLOR_METHOD,
393: COLOR_LEVEL1 = X_COLOR_LEVEL1,
394: COLOR_LEVEL2 = X_COLOR_LEVEL2,

Line 458: delete from BSC_KPI_DEFAULTS_B

454: if (sql%notfound) then
455: raise no_data_found;
456: end if;
457:
458: delete from BSC_KPI_DEFAULTS_B
459: where TAB_ID = X_TAB_ID
460: and INDICATOR = X_INDICATOR;
461:
462: if (sql%notfound) then

Line 473: from BSC_KPI_DEFAULTS_B B

469: begin
470: delete from BSC_KPI_DEFAULTS_TL T
471: where not exists
472: (select NULL
473: from BSC_KPI_DEFAULTS_B B
474: where B.TAB_ID = T.TAB_ID
475: and B.INDICATOR = T.INDICATOR
476: );
477: