DBA Data[Home] [Help]

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 58: from AD_OBSOLETE_OBJECTS

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

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

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

Line 100: from AD_OBSOLETE_OBJECTS

96: -- Do a bulk collect of table and objects from AOO
97:
98: select object_name,object_type
99: bulk collect into obs_object_name, obs_object_type
100: from AD_OBSOLETE_OBJECTS
101: where APPLICATION_ID = x_appl_id
102: and object_type in ('TABLE', 'INDEX')
103: and (UPPER(dropped) = 'N' or upper(dropped) is null);
104:

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

115: || obs_object_name(n)
116: || '"';
117:
118:
119: l_upd_statement := 'update AD_OBSOLETE_OBJECTS set DROPPED = '
120: ||'''Y'''||' where APPLICATION_ID = '|| x_appl_id
121: ||' and OBJECT_NAME = '||''''||
122: obs_object_name(n)||''''||' and OBJECT_TYPE = '||
123: ''''||obs_object_type(n)||'''';

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

141:
142: procedure drop_synonym_all (x_appl_id in number,
143: x_app_short_name in varchar2) is
144: TYPE ds_obj_name IS TABLE OF dba_synonyms.synonym_name%TYPE;
145: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
146: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
147:
148: ds_object_name ds_obj_name;
149: obs_object_type obs_obj_type;

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

142: procedure drop_synonym_all (x_appl_id in number,
143: x_app_short_name in varchar2) is
144: TYPE ds_obj_name IS TABLE OF dba_synonyms.synonym_name%TYPE;
145: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
146: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
147:
148: ds_object_name ds_obj_name;
149: obs_object_type obs_obj_type;
150: obs_object_name obs_obj_name;

Line 192: from AD_OBSOLETE_OBJECTS

188: from dba_synonyms
189: where TABLE_OWNER = l_schema_name
190: and synonym_name not in
191: (select object_name
192: from AD_OBSOLETE_OBJECTS
193: where APPLICATION_ID = x_appl_id
194: and OBJECT_TYPE = 'SYNONYM'
195: and (UPPER(dropped) = 'N' or upper(dropped) is null));
196:

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

204: || ds_object_name(n)
205: || '"';
206:
207:
208: l_insert_statement := 'insert into AD_OBSOLETE_OBJECTS '||
209: '(APPLICATION_ID, OBJECT_NAME, '||
210: 'OBJECT_TYPE, LAST_UPDATED_BY, '||
211: ' CREATED_BY, CREATION_DATE, '||
212: 'LAST_UPDATE_DATE, DROPPED) values ('||x_appl_id||

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

259: || '."'
260: || obs_object_name(n)
261: || '"';
262:
263: l_insert_statement := 'insert into AD_OBSOLETE_OBJECTS '||
264: '(APPLICATION_ID, OBJECT_NAME, '||
265: 'OBJECT_TYPE, LAST_UPDATED_BY, '||
266: ' CREATED_BY, CREATION_DATE, '||
267: 'LAST_UPDATE_DATE, DROPPED) values ('||x_appl_id||

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

308:
309:
310:
311: procedure drop_apps_objects(x_appl_id in number) is
312: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
313: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
314: obs_object_type obs_obj_type;
315: obs_object_name obs_obj_name;
316: l_drop_statement varchar2(200);

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

309:
310:
311: procedure drop_apps_objects(x_appl_id in number) is
312: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
313: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
314: obs_object_type obs_obj_type;
315: obs_object_name obs_obj_name;
316: l_drop_statement varchar2(200);
317: l_upd_statement varchar2(200);

Line 345: from AD_OBSOLETE_OBJECTS aoo

341: -- Do a bulk collect
342:
343: select aoo.object_name, aoo.object_type
344: bulk collect into obs_object_name, obs_object_type
345: from AD_OBSOLETE_OBJECTS aoo
346: where aoo.APPLICATION_ID = x_appl_id
347: and (UPPER(dropped) = 'N' or upper(dropped) is null)
348: and aoo.object_type <> 'SYNONYM'
349: and exists

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

363: || obs_object_name(n)
364: || '"';
365:
366:
367: l_upd_statement := 'update AD_OBSOLETE_OBJECTS set DROPPED = '
368: ||'''Y'''||' where OBJECT_NAME = '||''''||
369: obs_object_name(n)||''''||' and OBJECT_TYPE = '||
370: ''''||obs_object_type(n)||''''||
371: ' and APPLICATION_ID = '|| x_appl_id;