APPS.BSC_DIM_FILTERS_PVT dependencies on BSC_APPS

Line 331: BSC_APPS.Init_Bsc_Apps;

327: -- IF COUNT <> 0 means view exists and must to be delteted
328: IF (l_Count <> 0) THEN
329: -- sql_to_drop_view
330: l_sql:= 'DROP VIEW ' ||l_Filter_Level_View_Name ;
331: BSC_APPS.Init_Bsc_Apps;
332: --BSC_APPS.do_ddl(l_sql,x_statement_type, l_Filter_Level_View_Name);
333: BSC_APPS.Execute_DDL(l_sql);
334: --BSC_APPS.DO_DDL_AT(l_sql, ad_ddl.drop_view, l_Filter_Level_View_Name,
335: -- BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

Line 332: --BSC_APPS.do_ddl(l_sql,x_statement_type, l_Filter_Level_View_Name);

328: IF (l_Count <> 0) THEN
329: -- sql_to_drop_view
330: l_sql:= 'DROP VIEW ' ||l_Filter_Level_View_Name ;
331: BSC_APPS.Init_Bsc_Apps;
332: --BSC_APPS.do_ddl(l_sql,x_statement_type, l_Filter_Level_View_Name);
333: BSC_APPS.Execute_DDL(l_sql);
334: --BSC_APPS.DO_DDL_AT(l_sql, ad_ddl.drop_view, l_Filter_Level_View_Name,
335: -- BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
336: -- we need to commit after delete the view to ensure the View objects match

Line 333: BSC_APPS.Execute_DDL(l_sql);

329: -- sql_to_drop_view
330: l_sql:= 'DROP VIEW ' ||l_Filter_Level_View_Name ;
331: BSC_APPS.Init_Bsc_Apps;
332: --BSC_APPS.do_ddl(l_sql,x_statement_type, l_Filter_Level_View_Name);
333: BSC_APPS.Execute_DDL(l_sql);
334: --BSC_APPS.DO_DDL_AT(l_sql, ad_ddl.drop_view, l_Filter_Level_View_Name,
335: -- BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
336: -- we need to commit after delete the view to ensure the View objects match
337: -- with the metadata defined for the View.

Line 334: --BSC_APPS.DO_DDL_AT(l_sql, ad_ddl.drop_view, l_Filter_Level_View_Name,

330: l_sql:= 'DROP VIEW ' ||l_Filter_Level_View_Name ;
331: BSC_APPS.Init_Bsc_Apps;
332: --BSC_APPS.do_ddl(l_sql,x_statement_type, l_Filter_Level_View_Name);
333: BSC_APPS.Execute_DDL(l_sql);
334: --BSC_APPS.DO_DDL_AT(l_sql, ad_ddl.drop_view, l_Filter_Level_View_Name,
335: -- BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
336: -- we need to commit after delete the view to ensure the View objects match
337: -- with the metadata defined for the View.
338: ----DBMS_OUTPUT.PUT_LINE(' Deleted Filter View : ' || l_Filter_Level_View_Name );

Line 335: -- BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

331: BSC_APPS.Init_Bsc_Apps;
332: --BSC_APPS.do_ddl(l_sql,x_statement_type, l_Filter_Level_View_Name);
333: BSC_APPS.Execute_DDL(l_sql);
334: --BSC_APPS.DO_DDL_AT(l_sql, ad_ddl.drop_view, l_Filter_Level_View_Name,
335: -- BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
336: -- we need to commit after delete the view to ensure the View objects match
337: -- with the metadata defined for the View.
338: ----DBMS_OUTPUT.PUT_LINE(' Deleted Filter View : ' || l_Filter_Level_View_Name );
339: END IF;