APPS.FND_ADG_MANAGE SQL Statements

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

Line: 73

cursor c1 is select a.dbid,a.name
               from v$database a;

Line: 76

cursor c2 is select a.sid,a.serial#,a.audsid
               from v$session a
              where a.sid = ( select distinct b.sid from v$mystat b);

Line: 176

cursor c1 is select a.dbid,a.name
               from v$database a;

Line: 181

cursor c2 is select a.sid,a.serial#,a.audsid
               from v$session a
              where a.sid = ( select distinct b.sid from v$mystat b);

Line: 300

cursor c1 is select 1
               from dba_objects a,dba_objects b
              where a.owner = p_rpcDescriptor.owner
                and a.object_name = p_rpcDescriptor.package_name
                and a.object_type = 'PACKAGE'
                and b.owner = p_rpcDescriptor.owner
                and b.object_name = p_rpcDescriptor.rpc_package_name
                and b.object_type = 'PACKAGE'
                and to_date(b.timestamp,'YYYY-MM-DD:HH24:MI:SS') >=
                       to_date(a.timestamp,'YYYY-MM-DD:HH24:MI:SS') ;

Line: 331

cursor c1 is select 1
               from dba_synonyms a, dba_synonyms b
              where a.owner = p_rpcDescriptor.owner
                and a.synonym_name = fnd_adg_object.C_ADG_MANAGE_NAME_REMOTE
                and ( a.table_owner = p_rpcDescriptor.owner or
                      a.table_owner is null )
                and a.table_name  = fnd_adg_object.C_ADG_MANAGE_PACKAGE
                and b.owner = p_rpcDescriptor.owner
                and b.synonym_name = p_rpcDescriptor.rpc_synonym_name
                and ( b.table_owner = p_rpcDescriptor.owner or
                      b.table_owner is null )
                and b.table_name  = p_rpcDescriptor.rpc_package_name
                and a.db_link     = b.db_link
                and a.db_link is not null
                and b.db_link is not null;

Line: 433

	-- Initial insert takes place on slave so row may not exist yet.
  begin

    select a.commit_count
      into l_commit_count
      from fnd_adg_commit_wait a
     where a.session_id = G_SLAVE_SESSION_ID;

Line: 463

  update fnd_adg_commit_wait a
     set a.commit_count = a.commit_count + 1
   where a.session_id = G_SLAVE_SESSION_ID;

Line: 469

     insert into fnd_adg_commit_wait(session_id,commit_count)
                       values (G_SLAVE_SESSION_ID,0);

Line: 536

      select a.commit_count
        into l_commit_count
        from fnd_adg_commit_wait a
       where a.session_id = G_SLAVE_SESSION_ID;