APPS.BSC_SYS_DATASETS_PKG dependencies on BSC_SYS_DATASETS_B

Line 20: insert into BSC_SYS_DATASETS_B (

16: X_LAST_UPDATED_BY in NUMBER DEFAULT NULL,
17: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL
18: ) is
19: begin
20: insert into BSC_SYS_DATASETS_B (
21: PROJECTION_FLAG,
22: DATASET_ID,
23: MEASURE_ID1,
24: OPERATION,

Line 103: from BSC_SYS_DATASETS_B

99: OPERATION,
100: MEASURE_ID2,
101: FORMAT_ID,
102: COLOR_METHOD
103: from BSC_SYS_DATASETS_B
104: where DATASET_ID = X_DATASET_ID
105: for update of DATASET_ID nowait;
106: recinfo c%rowtype;
107:

Line 173: update BSC_SYS_DATASETS_B set

169: X_LAST_UPDATED_BY in NUMBER DEFAULT NULL,
170: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL
171: ) is
172: begin
173: update BSC_SYS_DATASETS_B set
174: PROJECTION_FLAG = X_PROJECTION_FLAG,
175: MEASURE_ID1 = X_MEASURE_ID1,
176: OPERATION = X_OPERATION,
177: MEASURE_ID2 = X_MEASURE_ID2,

Line 212: delete from BSC_SYS_DATASETS_B

208: if (sql%notfound) then
209: raise no_data_found;
210: end if;
211:
212: delete from BSC_SYS_DATASETS_B
213: where DATASET_ID = X_DATASET_ID;
214:
215: if (sql%notfound) then
216: raise no_data_found;

Line 226: from BSC_SYS_DATASETS_B B

222: begin
223: delete from BSC_SYS_DATASETS_TL T
224: where not exists
225: (select NULL
226: from BSC_SYS_DATASETS_B B
227: where B.DATASET_ID = T.DATASET_ID
228: );
229:
230: update BSC_SYS_DATASETS_TL T set (