SYSTEM.AD_INVOKER dependencies on FND_ORACLE_USERID

Line 13: from fnd_oracle_userid fou, sys.user$ u, sys.obj$ o, sys.procedure$ p

9: select /*+ ORDERED */
10: u.name owner, o.name object_name,
11: decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', '??')
12: object_type
13: from fnd_oracle_userid fou, sys.user$ u, sys.obj$ o, sys.procedure$ p
14: where fou.read_only_flag = 'U'
15: and fou.install_group_num = 1
16: and u.name = fou.oracle_username
17: and o.owner# = u.user#

Line 28: from sys.obj$ o, ad_timestamps t, fnd_oracle_userid fou, sys.user$ u,

24: select /*+ FULL(o), ORDERED */
25: u.name owner, o.name object_name,
26: decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', '??')
27: object_type
28: from sys.obj$ o, ad_timestamps t, fnd_oracle_userid fou, sys.user$ u,
29: sys.procedure$ p
30: where fou.read_only_flag = 'U'
31: and fou.install_group_num = 1
32: and u.name = fou.oracle_username

Line 44: from dba_objects do, fnd_oracle_userid u

40: and o.mtime >= t.timestamp;
41:
42: cursor GRANTS_NOT_INCR is
43: select do.owner, do.object_name, do.object_type, u.oracle_username
44: from dba_objects do, fnd_oracle_userid u
45: where do.owner =
46: (select o.oracle_username
47: from fnd_oracle_userid o
48: where o.read_only_flag = 'U'

Line 47: from fnd_oracle_userid o

43: select do.owner, do.object_name, do.object_type, u.oracle_username
44: from dba_objects do, fnd_oracle_userid u
45: where do.owner =
46: (select o.oracle_username
47: from fnd_oracle_userid o
48: where o.read_only_flag = 'U'
49: and o.install_group_num = 1)
50: and do.object_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION',
51: 'JAVA CLASS')

Line 58: from dba_objects do, fnd_oracle_userid u, ad_timestamps t

54: and u.install_group_num > 1;
55:
56: cursor GRANTS_INCR is
57: select do.owner, do.object_name, do.object_type, u.oracle_username
58: from dba_objects do, fnd_oracle_userid u, ad_timestamps t
59: where do.owner =
60: (select o.oracle_username
61: from fnd_oracle_userid o
62: where o.read_only_flag = 'U'

Line 61: from fnd_oracle_userid o

57: select do.owner, do.object_name, do.object_type, u.oracle_username
58: from dba_objects do, fnd_oracle_userid u, ad_timestamps t
59: where do.owner =
60: (select o.oracle_username
61: from fnd_oracle_userid o
62: where o.read_only_flag = 'U'
63: and o.install_group_num = 1)
64: and do.object_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION',
65: 'JAVA CLASS')

Line 713: from fnd_oracle_userid

709: from ad_invoker_tasks
710: where phase in (1, 3);
711: cursor APPS_SCHEMAS is
712: select oracle_username
713: from fnd_oracle_userid
714: where read_only_flag = 'U';
715: num_rows number;
716: begin
717: --