APPS.BSC_KPIS_PKG dependencies on BSC_KPIS_B

Line 21: cursor C is select ROWID from BSC_KPIS_B

17: X_IND_GROUP_ID in NUMBER,
18: X_NAME in VARCHAR2,
19: X_HELP in VARCHAR2
20: ) is
21: cursor C is select ROWID from BSC_KPIS_B
22: where INDICATOR = X_INDICATOR
23: ;
24: begin
25: insert into BSC_KPIS_B (

Line 25: insert into BSC_KPIS_B (

21: cursor C is select ROWID from BSC_KPIS_B
22: where INDICATOR = X_INDICATOR
23: ;
24: begin
25: insert into BSC_KPIS_B (
26: SHARE_FLAG,
27: PERIODICITY_ID,
28: BM_GROUP_ID,
29: APPLY_COLOR_FLAG,

Line 115: from BSC_KPIS_B

111: CONFIG_TYPE,
112: SOURCE_INDICATOR,
113: CSF_ID,
114: IND_GROUP_ID
115: from BSC_KPIS_B
116: where INDICATOR = X_INDICATOR
117: for update of INDICATOR nowait;
118: recinfo c%rowtype;
119:

Line 191: update BSC_KPIS_B set

187: X_NAME in VARCHAR2,
188: X_HELP in VARCHAR2
189: ) is
190: begin
191: update BSC_KPIS_B set
192: SHARE_FLAG = X_SHARE_FLAG,
193: PERIODICITY_ID = X_PERIODICITY_ID,
194: BM_GROUP_ID = X_BM_GROUP_ID,
195: APPLY_COLOR_FLAG = X_APPLY_COLOR_FLAG,

Line 233: delete from BSC_KPIS_B

229: if (sql%notfound) then
230: raise no_data_found;
231: end if;
232:
233: delete from BSC_KPIS_B
234: where INDICATOR = X_INDICATOR;
235:
236: if (sql%notfound) then
237: raise no_data_found;

Line 247: from BSC_KPIS_B B

243: begin
244: delete from BSC_KPIS_TL T
245: where not exists
246: (select NULL
247: from BSC_KPIS_B B
248: where B.INDICATOR = T.INDICATOR
249: );
250:
251: update BSC_KPIS_TL T set (