APPS.BSC_DIMENSION_LEVELS_PVT dependencies on BSC_APPS

Line 272: BSC_APPS.Init_Bsc_Apps;

268: begin
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270: FND_MSG_PUB.Initialize;
271: SAVEPOINT DeleteBSCDimLevPVT;
272: BSC_APPS.Init_Bsc_Apps;
273:
274: l_Dim_Level_Rec := p_Dim_Level_Rec;
275: -- Validate level id exists.
276: if p_Dim_Level_Rec.Bsc_Level_Id is not null then

Line 313: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_view, l_Dim_Level_Rec.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

309:
310: -- SQL to drop dimension level view.
311: l_sql := 'DROP VIEW ' || l_Dim_Level_Rec.Bsc_Level_Name;
312: --EXECUTE IMMEDIATE l_sql;
313: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_view, l_Dim_Level_Rec.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
314: end if;
315: ELSIF(l_Dim_Level_Rec.Bsc_Source = 'BSC') THEN
316: --delete the enteries from BSC_DB_TABLES and BSC_DB_TABLES_RELS
317: DELETE FROM BSC_DB_TABLES

Line 332: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_view, 'BSC_D_'||l_Dim_Level_Rec.Bsc_Level_Id||'_VL', BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

328:
329: IF (l_count <> 0) THEN
330: l_sql := 'DROP VIEW BSC_D_'||l_Dim_Level_Rec.Bsc_Level_Id||'_VL';
331: --EXECUTE IMMEDIATE l_sql;
332: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_view, 'BSC_D_'||l_Dim_Level_Rec.Bsc_Level_Id||'_VL', BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
333: END IF;
334:
335: --DROP MASTER TABLE
336: l_sql := ' SELECT COUNT(1) FROM USER_OBJECTS '||

Line 342: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_table, l_Dim_Level_Rec.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

338: EXECUTE IMMEDIATE l_sql INTO l_count USING l_Dim_Level_Rec.Bsc_Level_Name ;
339:
340: IF (l_count <> 0) THEN
341: l_sql := 'DROP TABLE '||l_Dim_Level_Rec.Bsc_Level_Name;
342: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_table, l_Dim_Level_Rec.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
343: END IF;
344:
345: --DROP INPUT TABLE
346: l_view_name := 'BSC_DI_'||l_Dim_Level_Rec.Bsc_Level_Id;

Line 352: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_table, 'BSC_DI_'||l_Dim_Level_Rec.Bsc_Level_Id, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

348: ' WHERE OBJECT_NAME = :1';
349: EXECUTE IMMEDIATE l_sql INTO l_count USING l_view_name;
350: IF (l_count <> 0) THEN
351: l_sql := 'DROP TABLE BSC_DI_'||l_Dim_Level_Rec.Bsc_Level_Id;
352: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_table, 'BSC_DI_'||l_Dim_Level_Rec.Bsc_Level_Id, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
353: END IF;
354:
355: --remove/drop filter views if any
356: BSC_DIM_FILTERS_PUB.Drop_Filter_By_Dim_Obj