APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on ALL_OBJECTS

Line 308: FROM ALL_OBJECTS

304: FUNCTION Drop_Temp_Tab_PVT(pTableName VARCHAR2) RETURN BOOLEAN
305: IS
306: CURSOR c_query_object( p_objname IN VARCHAR2, p_objtype IN VARCHAR2, p_obj_sch IN VARCHAR2) IS
307: SELECT 1
308: FROM ALL_OBJECTS
309: WHERE object_name= upper(p_objname)
310: AND object_type = p_objtype
311: AND owner = p_obj_sch ;
312:

Line 318: --check if table exists in all_objects

314: BEGIN
315: trc('st:Drop_Temp_Tab_PVT :' || pTableName);
316: /* dropTemparyTable; */
317: lv_object_exist := SYS_NO;
318: --check if table exists in all_objects
319: OPEN c_query_object( pTableName,'TABLE',v_msc_schema);
320: FETCH c_query_object INTO lv_object_exist;
321: CLOSE c_query_object;
322:

Line 336: --check if view exists in all_objects

332:
333:
334: -- drop temp table view created in APPS schema which is created for PAT Bug# 15854386 --
335: lv_object_exist := SYS_NO;
336: --check if view exists in all_objects
337: OPEN c_query_object( pTableName,'VIEW',MSC_UTIL.G_APPS_SCHEMA);
338: FETCH c_query_object INTO lv_object_exist;
339: CLOSE c_query_object;
340: