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.

APPS.AD_OBSOLETE_PRODUCTS dependencies on AD_OBSOLETE_OBJECTS

Line 18: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;

14: --
15:
16: procedure drop_synonym_list (x_appl_id in number,
17: x_app_short_name in varchar2) is
18: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
19: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
20: obs_object_type obs_obj_type;
21: obs_object_name obs_obj_name;
22: l_drop_statement varchar2(200);

Line 19: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;

15:
16: procedure drop_synonym_list (x_appl_id in number,
17: x_app_short_name in varchar2) is
18: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
19: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
20: obs_object_type obs_obj_type;
21: obs_object_name obs_obj_name;
22: l_drop_statement varchar2(200);
23: l_upd_statement varchar2(200);

Line 61: from AD_OBSOLETE_OBJECTS

57: -- Do a bulk collect of non table objects from AOO
58:
59: select object_name,object_type
60: bulk collect into obs_object_name, obs_object_type
61: from AD_OBSOLETE_OBJECTS
62: where APPLICATION_ID = x_appl_id
63: and object_type not in ('TABLE', 'INDEX', 'SEQUENCE')
64: and (UPPER(dropped) = 'N' or upper(dropped) is null);
65:

Line 78: l_upd_statement := 'update AD_OBSOLETE_OBJECTS set DROPPED = '

74: || ' ' || '"'
75: || obs_object_name(n)
76: || '"';
77:
78: l_upd_statement := 'update AD_OBSOLETE_OBJECTS set DROPPED = '
79: ||'''Y'''||' where APPLICATION_ID = '|| x_appl_id
80: ||' and OBJECT_NAME = '||''''||
81: obs_object_name(n)||''''||' and OBJECT_TYPE = '||
82: ''''||obs_object_type(n)||'''';

Line 113: from AD_OBSOLETE_OBJECTS

109: -- Do a bulk collect of table and objects from AOO
110:
111: select object_name,object_type
112: bulk collect into obs_object_name, obs_object_type
113: from AD_OBSOLETE_OBJECTS
114: where APPLICATION_ID = x_appl_id
115: and object_type in ('TABLE', 'INDEX', 'SEQUENCE')
116: and (UPPER(dropped) = 'N' or upper(dropped) is null);
117:

Line 132: l_upd_statement := 'update AD_OBSOLETE_OBJECTS set DROPPED = '

128: || obs_object_name(n)
129: || '"';
130:
131:
132: l_upd_statement := 'update AD_OBSOLETE_OBJECTS set DROPPED = '
133: ||'''Y'''||' where APPLICATION_ID = '|| x_appl_id
134: ||' and OBJECT_NAME = '||''''||
135: obs_object_name(n)||''''||' and OBJECT_TYPE = '||
136: ''''||obs_object_type(n)||'''';

Line 169: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;

165:
166: procedure drop_synonym_all (x_appl_id in number,
167: x_app_short_name in varchar2) is
168: TYPE ds_obj_name IS TABLE OF dba_synonyms.synonym_name%TYPE;
169: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
170: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
171:
172: ds_object_name ds_obj_name;
173: obs_object_type obs_obj_type;

Line 170: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;

166: procedure drop_synonym_all (x_appl_id in number,
167: x_app_short_name in varchar2) is
168: TYPE ds_obj_name IS TABLE OF dba_synonyms.synonym_name%TYPE;
169: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
170: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
171:
172: ds_object_name ds_obj_name;
173: obs_object_type obs_obj_type;
174: obs_object_name obs_obj_name;

Line 219: from AD_OBSOLETE_OBJECTS

215: from dba_synonyms
216: where TABLE_OWNER = l_schema_name
217: and synonym_name not in
218: (select object_name
219: from AD_OBSOLETE_OBJECTS
220: where APPLICATION_ID = x_appl_id
221: and OBJECT_TYPE = 'SYNONYM'
222: and (UPPER(dropped) = 'N' or upper(dropped) is null));
223:

Line 235: l_insert_statement := 'insert into AD_OBSOLETE_OBJECTS '||

231: || ds_object_name(n)
232: || '"';
233:
234:
235: l_insert_statement := 'insert into AD_OBSOLETE_OBJECTS '||
236: '(APPLICATION_ID, OBJECT_NAME, '||
237: 'OBJECT_TYPE, LAST_UPDATED_BY, '||
238: ' CREATED_BY, CREATION_DATE, '||
239: 'LAST_UPDATE_DATE, DROPPED) values ('||x_appl_id||

Line 290: l_insert_statement := 'insert into AD_OBSOLETE_OBJECTS '||

286: || '."'
287: || obs_object_name(n)
288: || '"';
289:
290: l_insert_statement := 'insert into AD_OBSOLETE_OBJECTS '||
291: '(APPLICATION_ID, OBJECT_NAME, '||
292: 'OBJECT_TYPE, LAST_UPDATED_BY, '||
293: ' CREATED_BY, CREATION_DATE, '||
294: 'LAST_UPDATE_DATE, DROPPED) values ('||x_appl_id||

Line 357: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;

353:
354:
355:
356: procedure drop_apps_objects(x_appl_id in number) is
357: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
358: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
359: TYPE obs_obj_flag IS TABLE OF AD_OBSOLETE_OBJECTS.dropped%TYPE;
360: obs_object_type obs_obj_type;
361: obs_object_name obs_obj_name;

Line 358: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;

354:
355:
356: procedure drop_apps_objects(x_appl_id in number) is
357: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
358: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
359: TYPE obs_obj_flag IS TABLE OF AD_OBSOLETE_OBJECTS.dropped%TYPE;
360: obs_object_type obs_obj_type;
361: obs_object_name obs_obj_name;
362: obs_object_flag obs_obj_flag;

Line 359: TYPE obs_obj_flag IS TABLE OF AD_OBSOLETE_OBJECTS.dropped%TYPE;

355:
356: procedure drop_apps_objects(x_appl_id in number) is
357: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
358: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
359: TYPE obs_obj_flag IS TABLE OF AD_OBSOLETE_OBJECTS.dropped%TYPE;
360: obs_object_type obs_obj_type;
361: obs_object_name obs_obj_name;
362: obs_object_flag obs_obj_flag;
363: l_drop_statement varchar2(200);

Line 395: from AD_OBSOLETE_OBJECTS aoo

391: -- Do a bulk collect
392:
393: select aoo.object_name, aoo.object_type, aoo.dropped
394: bulk collect into obs_object_name, obs_object_type, obs_object_flag
395: from AD_OBSOLETE_OBJECTS aoo
396: where aoo.APPLICATION_ID = x_appl_id
397: and (UPPER(dropped) = 'N' or upper(dropped) is null)
398: and aoo.object_type <> 'SYNONYM'
399: and exists

Line 427: l_upd_statement := 'update AD_OBSOLETE_OBJECTS set DROPPED = '

423:
424: if (l_editions_enabled = 'Y' and (UPPER(obs_object_type(n)) = 'TABLE' or
425: UPPER(obs_object_type(n)) = 'MATERIALIZED VIEW'))
426: then
427: l_upd_statement := 'update AD_OBSOLETE_OBJECTS set DROPPED = '
428: ||'''Y'''||' where APPLICATION_ID = '|| x_appl_id
429: ||' and OBJECT_NAME = '||''''||
430: obs_object_name(n)||''''||' and OBJECT_TYPE = '||
431: ''''||obs_object_type(n)||'''';

Line 467: update ad_obsolete_objects set dropped = obs_object_flag(n)

463:
464: /* Updates all object rows, but dropped is set to Y or N based on
465: success or failure */
466: FORALL n in obs_object_name.first .. obs_object_name.last
467: update ad_obsolete_objects set dropped = obs_object_flag(n)
468: where object_name = obs_object_name(n)
469: and object_type = obs_object_type(n)
470: and application_id = x_appl_id;
471:

Line 551: l_delete_statement := 'delete from AD_OBSOLETE_OBJECTS '||

547: x_object_name in varchar2,
548: x_object_type in varchar2) is
549: l_delete_statement varchar2(500);
550: begin
551: l_delete_statement := 'delete from AD_OBSOLETE_OBJECTS '||
552: 'where APPLICATION_ID = '|| x_appl_id ||
553: ' and OBJECT_NAME = '''||x_object_name ||
554: ''' and OBJECT_TYPE = '''|| x_object_type
555: || '''';