DBA Data[Home] [Help]

APPS.BSC_UTILITY dependencies on AD_DDL

Line 3597: AD_DDL.Do_DDL(p_Fnd_Apps_Schema,

3593: p_Apps_Short_Name IN VARCHAR2
3594: ) IS
3595: PRAGMA AUTONOMOUS_TRANSACTION;
3596: BEGIN
3597: AD_DDL.Do_DDL(p_Fnd_Apps_Schema,
3598: p_Apps_Short_Name,
3599: p_Statement_Type,
3600: p_Statement,
3601: p_Object_Name);

Line 3648: BSC_UTILITY.Do_Ddl_AT(l_Sql_View, AD_DDL.CREATE_VIEW, l_Temp_View_Name, 'APPS', 'BIS');

3644: l_Sql_View := l_Sql_View || ' AS ';
3645: l_Sql_View := l_Sql_View || p_Sql_String;
3646:
3647: l_Stage := 'CREATE_VIEW';
3648: BSC_UTILITY.Do_Ddl_AT(l_Sql_View, AD_DDL.CREATE_VIEW, l_Temp_View_Name, 'APPS', 'BIS');
3649:
3650: -- View has been created successfully, if it reaches here.
3651:
3652: FOR cGCN IN c_Get_Column_Names LOOP

Line 3662: BSC_UTILITY.Do_Ddl_AT(l_Sql_View, AD_DDL.DROP_VIEW, l_Temp_View_Name, 'APPS', 'BIS');

3658: END LOOP;
3659:
3660: l_Sql_View := 'DROP VIEW ' || l_Temp_View_Name;
3661: l_Stage := 'DROP_VIEW';
3662: BSC_UTILITY.Do_Ddl_AT(l_Sql_View, AD_DDL.DROP_VIEW, l_Temp_View_Name, 'APPS', 'BIS');
3663:
3664: EXCEPTION
3665: WHEN OTHERS THEN
3666: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;