DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on ALL_OBJECTS

Line 14829: FROM all_objects

14825: );
14826:
14827: CURSOR c_check_obj_name (cp_agv_name IN VARCHAR2, cp_appl_id IN NUMBER) IS
14828: SELECT object_name
14829: FROM all_objects
14830: where object_name = cp_agv_name
14831: and owner in (EGO_EXT_FWK_PUB.Get_Application_Owner(cp_appl_id), EGO_EXT_FWK_PUB.Get_Oracle_UserName);
14832:
14833: l_api_version CONSTANT NUMBER := 1.0 ;

Line 16193: FROM SYS.all_objects

16189: obj_name VARCHAR2(30) ;
16190: l_drop_sql VARCHAR2(100);
16191: CURSOR C iS
16192: SELECT object_name
16193: FROM SYS.all_objects
16194: WHERE object_name = p_view_name
16195: AND Upper(object_type)='VIEW';
16196:
16197: fnd_apps_schema VARCHAR2(30) := NULL;

Line 16239: FROM SYS.all_objects

16235: WHERE attr_group_id = p_attr_grp_id ;
16236:
16237: CURSOR csr2 IS
16238: SELECT object_name
16239: FROM SYS.all_objects
16240: WHERE object_name = view_name
16241: AND UPPER(object_type)='VIEW';
16242:
16243: CURSOR csr3 iS