SYSTEM.AD_INVOKER dependencies on AD_TIMESTAMPS

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 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 110: -- is missing from AD_TIMESTAMPS, get_rewrite_pkgs() will fail in

106: -- 'TRUE' - only process PL/SQL objects that have changed since last run
107: -- 'FALSE' - process all applicable PL/SQL objects
108: --
109: -- If for some reason the row for 'Invoker Maintenance', 'Last Run'
110: -- is missing from AD_TIMESTAMPS, get_rewrite_pkgs() will fail in
111: -- incremental mode. This can be fixed by running the whole
112: -- Invoker's Rights processing logic in non-incremental mode
113: -- (via adadmin "Compile APPS Schema(s)")
114: --

Line 242: -- is missing from AD_TIMESTAMPS, get_grant_pkgs() will fail in

238: -- 'TRUE' - only process objects that have changed since last run
239: -- 'FALSE' - process all applicable objects
240: --
241: -- If for some reason the row for 'Invoker Maintenance', 'Last Run'
242: -- is missing from AD_TIMESTAMPS, get_grant_pkgs() will fail in
243: -- incremental mode. This can be fixed by running the whole
244: -- Invoker's Rights processing logic in non-incremental mode
245: -- (via adadmin "Compile APPS Schema(s)")
246: --

Line 2263: -- Updates/Inserts the row in AD_TIMESTAMPS for the specified

2259: (in_type in varchar2,
2260: in_attribute in varchar2,
2261: in_timestamp in date)
2262: --
2263: -- Updates/Inserts the row in AD_TIMESTAMPS for the specified
2264: -- type and attribute
2265: --
2266: is
2267: begin

Line 2271: update ad_timestamps

2267: begin
2268: --
2269: -- First try to update
2270: --
2271: update ad_timestamps
2272: set timestamp = in_timestamp
2273: where type = in_type
2274: and attribute = in_attribute;
2275:

Line 2282: insert into ad_timestamps

2278: end if;
2279: --
2280: -- Insert if no rows updated
2281: --
2282: insert into ad_timestamps
2283: (type, attribute, timestamp)
2284: values (in_type, in_attribute, in_timestamp);
2285:
2286: exception