DBA Data[Home] [Help]

APPS.BSC_PERIODS_PUB dependencies on BSC_APPS

Line 643: BSC_APPS.Do_Ddl_AT(l_Sql_Stmt, ad_ddl.create_view, x_Periodicity_View_Name, 'APPS', 'BSC');

639: ' GROUP BY BP.PERIOD_ID, BP.NAME, BP.YEAR ' ||
640: ' ORDER BY BP.YEAR, BP.PERIOD_ID ';
641: END IF;
642:
643: BSC_APPS.Do_Ddl_AT(l_Sql_Stmt, ad_ddl.create_view, x_Periodicity_View_Name, 'APPS', 'BSC');
644: END IF;
645: --dbms_output.put_line('END :Create_Periodicity_View :- ' ||DBMS_UTILITY.GET_TIME);
646:
647: EXCEPTION

Line 677: BSC_APPS.Do_Ddl_AT(l_Sql_Stmt, ad_ddl.drop_view, p_Periodicity_View, 'APPS', 'BSC');

673: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
674:
675: l_Sql_Stmt := 'DROP VIEW ' || p_Periodicity_View;
676:
677: BSC_APPS.Do_Ddl_AT(l_Sql_Stmt, ad_ddl.drop_view, p_Periodicity_View, 'APPS', 'BSC');
678:
679:
680: EXCEPTION
681: WHEN OTHERS THEN