391:
392: BEGIN
393: SELECT 1
394: INTO l_ignore
395: FROM ALL_VIEWS
396: WHERE VIEW_NAME = UPPER(l_view_name)
397: AND OWNER = UPPER(l_view_owner);
398:
399: EXECUTE IMMEDIATE 'DROP VIEW ' || l_view_name;
548: l_view_owner := Get_AppsSchemaName;
549: BEGIN
550: EXECUTE IMMEDIATE
551: 'SELECT VIEW_NAME
552: FROM ALL_VIEWS
553: WHERE VIEW_NAME = UPPER(:source_type_view)
554: AND OWNER = UPPER(:owner)'
555: INTO l_ignore
556: USING x_source_type_view