SYSTEM.AD_INVOKER SQL Statements

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

Line: 9

  select /*+ ORDERED */
    u.name owner, o.name object_name,
    decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', '??')
    object_type
  from fnd_oracle_userid fou, sys.user$ u, sys.obj$ o, sys.procedure$ p
  where fou.read_only_flag = 'U'
  and   fou.install_group_num = 1
  and   u.name = fou.oracle_username
  and   o.owner# = u.user#
  and   o.type# in (7, 8, 9)
  and   o.name not in ('APPS_DDL', 'APPS_ARRAY_DDL')
  and   o.obj# = p.obj#
  and   bitand(p.options, 16) <> 16;

Line: 24

  select /*+ FULL(o), ORDERED */
    u.name owner, o.name object_name,
    decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', '??')
    object_type
  from sys.obj$ o, ad_timestamps t, fnd_oracle_userid fou, sys.user$ u,
       sys.procedure$ p
  where fou.read_only_flag = 'U'
  and   fou.install_group_num = 1
  and   u.name = fou.oracle_username
  and   o.owner# = u.user#
  and   o.type# in (7, 8, 9)
  and   o.name not in ('APPS_DDL', 'APPS_ARRAY_DDL')
  and   o.obj# = p.obj#
  and   bitand(p.options, 16) <> 16
  and   t.type = 'Invoker Maintenance'
  and   t.attribute = 'Last Run'
  and   o.mtime >= t.timestamp;

Line: 43

  select do.owner, do.object_name, do.object_type, u.oracle_username
  from dba_objects do, fnd_oracle_userid u
  where do.owner =
    (select o.oracle_username
     from fnd_oracle_userid o
     where o.read_only_flag = 'U'
     and   o.install_group_num = 1)
  and do.object_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION',
                         'JAVA CLASS')
  and do.object_name not in ('APPS_DDL', 'APPS_ARRAY_DDL')
  and u.read_only_flag = 'U'
  and u.install_group_num > 1;

Line: 57

  select do.owner, do.object_name, do.object_type, u.oracle_username
  from dba_objects do, fnd_oracle_userid u, ad_timestamps t
  where do.owner =
    (select o.oracle_username
     from fnd_oracle_userid o
     where o.read_only_flag = 'U'
     and   o.install_group_num = 1)
  and do.object_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION',
                         'JAVA CLASS')
  and do.object_name not in ('APPS_DDL', 'APPS_ARRAY_DDL')
  and u.read_only_flag = 'U'
  and u.install_group_num > 1
  and t.type = 'Invoker Maintenance'
  and t.attribute = 'Last Run'
  and do.last_ddl_time >= t.timestamp;

Line: 74

  select do.owner, do.object_name, do.object_type
  from dba_objects do
  where do.owner = upper(c_apps_schema)
  and do.object_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION',
                         'JAVA CLASS')
  and do.object_name not in ('APPS_DDL', 'APPS_ARRAY_DDL')
  and do.object_name not like 'FFP%';

Line: 136

         insert into ad_invoker_tasks (
           phase, owner, name, type, other_schema,
           worker, done_flag, authid_flag, invoker_flag, boundary_flag)
         values (
           1, c1.owner, c1.object_name, c1.object_type, c1.owner,
           0, 'N', null, null, 'N');

Line: 158

         insert into ad_invoker_tasks (
           phase, owner, name, type, other_schema,
           worker, done_flag, authid_flag, invoker_flag, boundary_flag)
         values (
           1, c1.owner, c1.object_name, c1.object_type, c1.owner,
           0, 'N', null, null, 'N');

Line: 205

    'insert into ad_invoker_tasks ('||
    'phase, owner, name, type, other_schema,'||
    'worker, done_flag, authid_flag, invoker_flag, boundary_flag)'||
    'values ('||
    '2, ''Boundary'', ''Boundary'', ''Boundary'', to_char(:wrk_num),'||
    ':wrk_num, ''N'', null, null, ''Y'')';

Line: 272

       insert into ad_invoker_tasks (
	 phase, owner, name, type, other_schema,
	 worker, done_flag, authid_flag, invoker_flag, boundary_flag)
       values (
	 3, c1.owner, c1.object_name, c1.object_type, c1.oracle_username,
	 0, 'N', 'X', 'X', 'N');

Line: 286

       insert into ad_invoker_tasks (
	 phase, owner, name, type, other_schema,
	 worker, done_flag, authid_flag, invoker_flag, boundary_flag)
       values (
	 3, c1.owner, c1.object_name, c1.object_type, c1.oracle_username,
	 0, 'N', 'X', 'X', 'N');

Line: 447

  update_timestamp('Invoker Maintenance','Last Run');

Line: 588

    select rowid, owner, name, type
    from ad_invoker_tasks
    where phase = 3
    and   type not like 'JAVA%'
    and   worker = calculate_grant_types.worker_num;

Line: 603

         update ad_invoker_tasks
         set authid_flag = 'N',
             invoker_flag = null
         where rowid = c1.rowid;

Line: 610

         update ad_invoker_tasks
         set authid_flag = 'Y',
             invoker_flag = calculate_grant_types.invoker_flag
         where rowid = c1.rowid;

Line: 639

    select rowid
    from ad_invoker_tasks
    where phase = phase_num;

Line: 658

    update ad_invoker_tasks
    set worker = counter
    where rowid = the_rec.rowid;

Line: 682

    update ad_invoker_tasks
    set worker = counter
    where rowid = the_rec.rowid;

Line: 708

    select count(*)
    from ad_invoker_tasks
    where phase in (1, 3);

Line: 712

    select oracle_username
    from fnd_oracle_userid
    where read_only_flag = 'U';

Line: 762

procedure update_done
           (what_row in rowid)
--
-- Sets AD_INVOKER_TASKS.DONE_FLAG to 'Y' for this particular row.
-- Commits the changes using an autonomous transaction
--
is
  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 772

  update ad_invoker_tasks
  set done_flag = 'Y'
  where rowid = what_row;

Line: 780

    ad_apps_private.error_buf := 'update_done('||
      what_row||'): '||
      ad_apps_private.error_buf;

Line: 784

end update_done;

Line: 803

    select rowid the_row_id
    from ad_invoker_tasks
    where phase = 1
    and   worker = worker_number;

Line: 808

    select owner, name, type, other_schema, done_flag
    from ad_invoker_tasks
    where rowid = c_row_id;

Line: 851

      update_done(rows_to_process(row_index));

Line: 883

    select text from dba_source
    where owner = upper(rewrite_a_package.owner)
    and name = upper(rewrite_a_package.name)
    and type = upper(rewrite_a_package.type)
    order by line;

Line: 915

      insert into ad_parallel_compile_errors (
	     owner, worker_number, timestamp, type, text)
      select upper(owner),
	     0,
	     timestamp,
	     '1 REWRITE ERROR',
             upper(type)||' '||upper(owner)||'.'||upper(name)||
	       ': Object type "'||upper(type)||'" not supported.'
      from sys.dual;

Line: 1029

            insert into ad_parallel_compile_errors (
                   owner, worker_number, timestamp, type, text)
            select upper(owner),
                   0,
                   timestamp,
                   '1 REWRITE MESSAGE',
                   upper(type)||' '||upper(owner)||'.'||upper(name)||
                     ' contains AUTHID - Not rewritten'
            from sys.dual;

Line: 1069

	insert into ad_parallel_compile_errors (
	       owner, worker_number, timestamp, type, text)
	select upper(owner),
	       0,
	       timestamp,
	       '1 REWRITE MESSAGE',
	       upper(type)||' '||upper(owner)||'.'||upper(name)||
		 ' contains line(s) > 255 chars - Not rewritten'
	from sys.dual;

Line: 1134

      insert into ad_parallel_compile_errors (
             owner, worker_number, timestamp, type, text)
      select upper(owner),
             0,
             timestamp,
             '1 REWRITE ERROR',
             upper(type)||' '||upper(owner)||'.'||upper(name)||
               ' has no IS/AS keyword - Not rewritten'
      from sys.dual;

Line: 1165

      insert into ad_parallel_compile_errors (
	     owner, worker_number, timestamp, type, text)
      select upper(owner),
	     0,
	     timestamp,
	     '1 REWRITE ERROR',
	     upper(type)||' '||upper(owner)||'.'||upper(name)||
	       ' has IS/AS keyword on long line - Not rewritten'
      from sys.dual;

Line: 1232

	insert into ad_parallel_compile_errors (
	       owner, worker_number, timestamp, type, text)
	select upper(owner),
	       0,
	       timestamp,
	       '1 REWRITE ERROR - A',
               upper(type)||' '||upper(owner)||'.'||upper(name)||
		 ': Generic error occurred.'
	from sys.dual;

Line: 1244

	insert into ad_parallel_compile_errors (
	       owner, worker_number, timestamp, type, text)
	select upper(owner),
	       0,
	       timestamp,
	       '1 REWRITE ERROR - B',
               substr(upper(type)||' '||upper(owner)||'.'||upper(name)||
	       ': '||sql_error,1,1996)
	from sys.dual;

Line: 1256

	  insert into ad_parallel_compile_errors (
		 owner, worker_number, timestamp, type, text)
	  select upper(owner),
		 0,
		 timestamp,
 		 '1 REWRITE ERROR - C',
                 substr(upper(type)||' '||upper(owner)||'.'||upper(name)||
	           ': '||ad_apps_private.error_buf,1,1996)
	  from sys.dual;

Line: 1502

    select rowid, owner, name, type, other_schema,
      authid_flag, invoker_flag, done_flag
    from ad_invoker_tasks
    where phase = 3
    and   worker = worker_number;

Line: 1526

      update_done(c1_rec.rowid);

Line: 1582

      insert into ad_parallel_compile_errors (
	     owner, worker_number, timestamp, type, text)
      select upper(owner),
	     0,
	     timestamp,
	     '3 GRANT ERROR',
             upper(type)||' '||upper(owner)||'.'||upper(name)||
	       ': Object type "'||upper(type)||'" not supported.'
      from sys.dual;

Line: 1640

	insert into ad_parallel_compile_errors (
	       owner, worker_number, timestamp, type, text)
	select upper(owner),
	       0,
	       timestamp,
	       '3 GRANT ERROR',
	       upper(type)||' '||upper(owner)||'.'||upper(name)||
               ': Invalid value for invoker_flag: "'||invoker_flag||'"'
	from sys.dual;

Line: 1670

      insert into ad_parallel_compile_errors (
	     owner, worker_number, timestamp, type, text)
      select upper(owner),
	     0,
	     timestamp,
	     '3 GRANT ERROR',
	     upper(type)||' '||upper(owner)||'.'||upper(name)||
	     ': Invalid value for authid_flag: "'||authid_flag||'"'
      from sys.dual;

Line: 1906

	      insert into ad_parallel_compile_errors (
		     owner, worker_number, timestamp, type, text)
	      select upper(owner),
		     0,
		     timestamp,
		     '3 GRANT ERROR',
		     upper(type)||' '||upper(owner)||'.'||upper(name)||
		     ': Internal error [pkg]'
	      from sys.dual;

Line: 1979

      insert into ad_parallel_compile_errors (
	     owner, worker_number, timestamp, type, text)
      select upper(owner),
	     0,
	     timestamp,
	     '3 GRANT ERROR',
	     upper(type)||' '||upper(owner)||'.'||upper(name)||
	     ': Internal error [classification]'
      from sys.dual;

Line: 2011

	insert into ad_parallel_compile_errors (
	       owner, worker_number, timestamp, type, text)
	select upper(owner),
	       0,
	       timestamp,
	       '3 GRANT ERROR - A',
               upper(type)||' '||upper(owner)||'.'||upper(name)||
		 ': Generic error occurred.'
	from sys.dual;

Line: 2023

	insert into ad_parallel_compile_errors (
	       owner, worker_number, timestamp, type, text)
	select upper(owner),
	       0,
	       timestamp,
	       '3 GRANT ERROR - B',
               substr(upper(type)||' '||upper(owner)||'.'||upper(name)||
	       ': '||sql_error,1,1996)
	from sys.dual;

Line: 2035

	  insert into ad_parallel_compile_errors (
		 owner, worker_number, timestamp, type, text)
	  select upper(owner),
		 0,
		 timestamp,
 		 '3 GRANT ERROR - C',
                 substr(upper(type)||' '||upper(owner)||'.'||upper(name)||
	           ': '||ad_apps_private.error_buf,1,1996)
	  from sys.dual;

Line: 2094

      insert into ad_parallel_compile_errors (
	     owner, worker_number, timestamp, type, text)
      select upper(owner),
	     0,
	     timestamp,
	     '3 GRANT ERROR',
             upper(type)||' '||upper(owner)||'.'||name||
	       ': Object type "'||upper(type)||'" not supported.'
      from sys.dual;

Line: 2184

	insert into ad_parallel_compile_errors (
	       owner, worker_number, timestamp, type, text)
	select upper(owner),
	       0,
	       timestamp,
	       '3 GRANT ERROR - A',
               upper(type)||' '||upper(owner)||'.'||name||
		 ': Generic error occurred.'
	from sys.dual;

Line: 2196

	insert into ad_parallel_compile_errors (
	       owner, worker_number, timestamp, type, text)
	select upper(owner),
	       0,
	       timestamp,
	       '3 GRANT ERROR - B',
               substr(upper(type)||' '||upper(owner)||'.'||name||
	       ': '||sql_error,1,1996)
	from sys.dual;

Line: 2208

	  insert into ad_parallel_compile_errors (
		 owner, worker_number, timestamp, type, text)
	  select upper(owner),
		 0,
		 timestamp,
 		 '3 GRANT ERROR - C',
                 substr(upper(type)||' '||upper(owner)||'.'||name||
	           ': '||ad_apps_private.error_buf,1,1996)
	  from sys.dual;

Line: 2244

procedure update_timestamp
           (in_type      in varchar2,
            in_attribute in varchar2)
is
begin
  update_timestamp
    (in_type      => in_type,
     in_attribute => in_attribute,
     in_timestamp => sysdate);

Line: 2258

procedure update_timestamp
           (in_type      in varchar2,
            in_attribute in varchar2,
            in_timestamp in date)
--
-- Updates/Inserts the row in AD_TIMESTAMPS for the specified
--  type and attribute
--
is
begin
--
-- First try to update
--
  update ad_timestamps
  set timestamp = in_timestamp
  where type = in_type
  and attribute = in_attribute;

Line: 2282

  insert into ad_timestamps
  (type, attribute, timestamp)
  values (in_type, in_attribute, in_timestamp);

Line: 2288

    ad_apps_private.error_buf := 'update_timestamp('
      || in_type ||', '|| in_attribute ||', '||
      to_char(in_timestamp,'YYYY-MM-DD:HH24:MI:SS') ||'): '||
      ad_apps_private.error_buf;

Line: 2293

end update_timestamp;

Line: 2471

    select text from dba_source
    where owner = upper(classify_plsql_object.owner)
    and name = upper(classify_plsql_object.name)
    and type = upper(classify_plsql_object.type)
    order by line;

Line: 2479

    select
       substr(s.text, instr(s.text,'$Header'||': '),
              ((instr(s.text,' $', instr(s.text,'$Header'||': ')) + 2)
               - instr(s.text,'$Header'||': ')))
    from dba_source s
    where s.owner= upper(c_owner)
    and   s.name = upper(c_name)
    and   s.type = upper(c_type)
    and   s.line between 2 and 5
    and   s.text like '%$Header'||': % $%';