eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYSTEM.AD_APPS_PRIVATE dependencies on DBA_OBJECTS

Line 334: from dba_objects

330: if NOT found_session
331: then
332: select count(*)
333: into dummy
334: from dba_objects
335: where object_type in ('PACKAGE', 'PACKAGE BODY')
336: and object_name in ('APPS_DDL', 'APPS_ARRAY_DDL')
337: and status = 'VALID'
338: and owner = upper(schema_name);

Line 404: l_owner_schema_name dba_objects.owner%TYPE;

400: p_with_grant_option IN BOOLEAN DEFAULT TRUE,
401: p_recursion_depth IN NUMBER DEFAULT NULL)
402: IS
403: l_statement VARCHAR2(500);
404: l_owner_schema_name dba_objects.owner%TYPE;
405: l_object_type dba_objects.object_type%TYPE;
406: l_recursion_depth NUMBER;
407: l_exists NUMBER;
408: l_queue_owner VARCHAR2(30);

Line 405: l_object_type dba_objects.object_type%TYPE;

401: p_recursion_depth IN NUMBER DEFAULT NULL)
402: IS
403: l_statement VARCHAR2(500);
404: l_owner_schema_name dba_objects.owner%TYPE;
405: l_object_type dba_objects.object_type%TYPE;
406: l_recursion_depth NUMBER;
407: l_exists NUMBER;
408: l_queue_owner VARCHAR2(30);
409:

Line 436: FROM dba_objects

432: --
433: BEGIN
434: SELECT object_type
435: INTO l_object_type
436: FROM dba_objects
437: WHERE owner = p_grantor_schema_name
438: AND object_name = p_object_name;
439: EXCEPTION
440: WHEN OTHERS THEN

Line 495: and use dba_queues that is faster than using dba_objects */

491:
492: EXCEPTION
493: /* Added for bug2765486 to trap ORA -1720 */
494: /* BUG 2892989, Since APPLSYS owns WF queues, we don't use the owner condition
495: and use dba_queues that is faster than using dba_objects */
496:
497: WHEN no_grant_exist THEN
498: BEGIN
499: SELECT 1, owner into l_exists, l_queue_owner

Line 542: l_object_type dba_objects.object_type%TYPE;

538: p_to_object_name IN VARCHAR2,
539: p_replace_existing IN BOOLEAN)
540: IS
541: l_statement VARCHAR2(500);
542: l_object_type dba_objects.object_type%TYPE;
543:
544: name_is_already_used EXCEPTION;
545: PRAGMA EXCEPTION_INIT(name_is_already_used, -955);
546: BEGIN

Line 559: FROM dba_objects

555: if (p_replace_existing = TRUE) then
556: BEGIN
557: SELECT object_type
558: INTO l_object_type
559: FROM dba_objects
560: WHERE owner = p_to_schema_name
561: AND object_name = p_to_object_name;
562: EXCEPTION
563: WHEN OTHERS THEN

Line 1993: l_from_schema_name dba_objects.owner%TYPE;

1989:
1990: -- customized object is not there, but it is a synonym
1991: -- create it
1992: DECLARE
1993: l_from_schema_name dba_objects.owner%TYPE;
1994: BEGIN
1995: IF (points_to_schema(cust_row_index) = 'BASE') THEN
1996: l_from_schema_name := base_schema;
1997: ELSE

Line 2035: l_from_schema_name dba_objects.owner%TYPE;

2031: apps_name(cust_row_index), 'SYNONYM');
2032:
2033: -- Recreate synonym
2034: DECLARE
2035: l_from_schema_name dba_objects.owner%TYPE;
2036: BEGIN
2037: IF (points_to_schema(cust_row_index) = 'BASE') THEN
2038: l_from_schema_name := base_schema;
2039: ELSE

Line 2463: from dba_objects

2459: -- Get view_date
2460: select nvl(min(last_ddl_time),
2461: to_date('01/01/1970','DD/MM/YYYY'))
2462: into view_date
2463: from dba_objects
2464: where object_name = upper(l_table_name)
2465: and object_type = 'VIEW'
2466: and owner = upper(apps_schema);
2467:

Line 2473: from dba_objects

2469: select nvl(min(decode(last_ddl_time,sysdate,
2470: to_date('31/12/2199','DD/MM/YYYY'),last_ddl_time)),
2471: to_date('01/01/1970','DD/MM/YYYY'))
2472: into table_date
2473: from dba_objects
2474: where object_name = upper(l_table_name)
2475: and object_type = 'TABLE'
2476: and owner = upper(table_schema);
2477:

Line 2687: from dba_objects do, dba_objects do2

2683: -- don't do the apps_ddl procedure, because using it to drop
2684: -- and recreate itself is problematic
2685: cursor src_pls_obj is
2686: select do.object_name, do.object_type, do2.object_name name2
2687: from dba_objects do, dba_objects do2
2688: where do.owner = upper(copy_stored_progs.fromschema)
2689: and do.object_type in (
2690: decode(copy_stored_progs.p_object_type,
2691: 'B',null, 'P',null, 'F',null,

Line 2876: from dba_objects

2872:
2873: cursor FIND_OBJ (c_owner in varchar2,
2874: c_object_name in varchar2) is
2875: select object_type
2876: from dba_objects
2877: where owner = c_owner
2878: and object_name = c_object_name
2879: order by decode(object_type, 'PACKAGE', 1, 2);
2880:

Line 3164: from dba_objects

3160: -- check to see if object exists in dest schema
3161:
3162: select object_name
3163: into dummy
3164: from dba_objects
3165: where owner = recompile_schema
3166: and object_name = obj_names(i)
3167: and object_type = obj_types(i);
3168:

Line 4224: 'from dba_objects ' ||

4220: c := dbms_sql.open_cursor;
4221: log_message('inside is_object_actualised ..');
4222:
4223: c_statement:='select count(1) ' ||
4224: 'from dba_objects ' ||
4225: 'where edition_name=:edition_name ' ||
4226: ' and owner=:schema_name ' ||
4227: ' and object_type=:object_type ' ||
4228: ' and object_name=:object_name';