SYSTEM.AD_PARALLEL_COMPILE_PKG dependencies on USER$

Line 30: sName sys.user$.name%type;

26: -- | performance reasons
27: -- |*=====================================================================*
28:
29: -- declare local variable.
30: sName sys.user$.name%type;
31:
32: begin
33:
34: -- uppercase the schema name once rather

Line 73: sys.user$ u

69: 'INVALID',
70: o.status
71: from
72: sys.obj$ o,
73: sys.user$ u
74: where
75: u.user# = o.owner#
76: and u.name = sName
77: and o.name not like 'BIN$%'

Line 111: sys.user$ u

107: 'INVALID',
108: o.status
109: from
110: sys.obj$ o,
111: sys.user$ u
112: where
113: u.user# = o.owner#
114: and u.name = sName
115: and o.name not like 'BIN$%'

Line 142: sys.user$ u

138: o.obj#
139: from
140: sys.obj$ o,
141: sys.trigger$ t,
142: sys.user$ u
143: where
144: u.user# = o.owner#
145: and u.name = sName
146: and o.obj# = t.obj#

Line 182: sName sys.user$.name%type;

178: -- |
179: -- |*=====================================================================*
180:
181: -- Declare local variable
182: sName sys.user$.name%type;
183:
184: begin
185:
186: -- Uppercase the schema name once rather

Line 198: sys.user$ u

194: o.obj#
195: from
196: sys.obj$ o,
197: sys.error$ e,
198: sys.user$ u
199: where
200: u.name = sName
201: and o.owner# = u.user#
202: and e.obj# = o.obj#

Line 262: sName sys.user$.name%type;

258: -- |
259: -- |*=====================================================================*
260:
261: -- Declare local variable
262: sName sys.user$.name%type;
263: rows_processed integer;
264: tree_depth integer;
265: max_tree_depth integer;
266: begin

Line 300: from sys.user$ where name = sName));

296: from ad_parallel_compile p
297: where p.owner = nvl(sName, p.owner)
298: and p.depend_level = tree_depth - 1)
299: and d.d_owner# = (select user#
300: from sys.user$ where name = sName));
301:
302: rows_processed := SQL%ROWCOUNT;
303:
304: -- Handle circular depencencies, if any

Line 400: sName sys.user$.name%type;

396: -- |
397: -- |*=====================================================================*
398:
399: -- Declare local variable
400: sName sys.user$.name%type;
401: l_status varchar2(30);
402: begin
403: -- Uppercase the schema name once rather
404: -- than each time it is used in a select statement

Line 469: sName sys.user$.name%type;

465: decode(type, 'PACKAGE',1,'VIEW',2,'PACKAGE BODY',4,3),
466: name;
467:
468: -- Declare local variable
469: sName sys.user$.name%type;
470: counter pls_integer;
471: num_workers_local pls_integer;
472: num_java_classes pls_integer := 0;
473: num_jobs_per_worker pls_integer := 0;