APPS.FND_OID_PLUG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 132

            g_option.delete(name); --cancel the cache

Line: 144

PROCEDURE deleteOption( name in varchar2)
is
l_module_source varchar2(200) := G_MODULE_SOURCE || 'saveOption: ';

Line: 151

            g_option.delete(name); --cancel the cache

Line: 154

END deleteOption;

Line: 493

       if old_val('REALM') is null then old_val.delete('REALM'); end if;

Line: 494

       if old_val('CREATE_BASE') is null then old_val.delete('CREATE_BASE'); end if;

Line: 495

       if old_val('CN_ATT_CACHED') is null then old_val.delete('CN_ATT_CACHED'); end if;

Line: 505

     FND_PREFERENCE.DELETE_ALL('#INTERNAL','OID_CONF');

Line: 607

         select count(*) into c  from user_objects where object_name=n
         and object_type in ('PACKAGE','PACKAGE BODY') and status='VALID';

Line: 619

            select count(*) into c  from dba_objects where
            owner=o and
            object_name=n and
            object_type in ('PACKAGE','PACKAGE BODY') and status='VALID';

Line: 666

                deleteOption('REALM');

Line: 667

                deleteOption('DEFAULT_CREATE_BASE');

Line: 668

                deleteOption('CREATE_BASE');

Line: 1166

      select user_guid into l_guid from FND_USER
      where user_name=username;

Line: 2115

   d2.delete;