APPS.AD_OBSOLETE_PRODUCTS dependencies on AD_ZD

Line 53: l_editions_enabled := ad_zd.is_editions_enabled;

49:
50: l_schema_name := x_app_short_name;
51: end if;
52:
53: l_editions_enabled := ad_zd.is_editions_enabled;
54:
55: -- dbms_output.put_line('l_schema_name: ' || l_schema_name);
56:
57: -- Do a bulk collect of non table objects from AOO

Line 90: ad_zd_mview.drop_mv(null,

86: -- dbms_output.put_line(' ');
87:
88: if (l_editions_enabled = 'Y' and UPPER(obs_object_type(n)) = 'MATERIALIZED VIEW')
89: then
90: ad_zd_mview.drop_mv(null,
91: obs_object_name(n),
92: l_drop_statement,
93: l_upd_statement,
94: l_dropped);

Line 144: ad_zd_table.drop_table(l_schema_name,

140: -- dbms_output.put_line(' ');
141:
142: if (l_editions_enabled = 'Y' and UPPER(obs_object_type(n)) = 'TABLE')
143: then
144: ad_zd_table.drop_table(l_schema_name,
145: obs_object_name(n),
146: l_drop_statement,
147: l_upd_statement,
148: l_dropped);

Line 209: l_editions_enabled := ad_zd.is_editions_enabled;

205: end if;
206:
207: -- dbms_output.put_line('l_schema_name: ' || l_schema_name);
208:
209: l_editions_enabled := ad_zd.is_editions_enabled;
210:
211: -- get the list of all
212:
213: select synonym_name

Line 305: ad_zd_mview.drop_mv(l_schema_name,

301: -- dbms_output.put_line('Insert statement: ' || l_insert_statement );
302:
303: if (l_editions_enabled = 'Y' and UPPER(obs_object_type(n)) = 'MATERIALIZED VIEW')
304: then
305: ad_zd_mview.drop_mv(l_schema_name,
306: obs_object_name(n),
307: l_drop_statement,
308: l_insert_statement,
309: l_dropped);

Line 312: ad_zd_table.drop_table(l_schema_name,

308: l_insert_statement,
309: l_dropped);
310: elsif (l_editions_enabled = 'Y' and UPPER(obs_object_type(n)) = 'TABLE')
311: then
312: ad_zd_table.drop_table(l_schema_name,
313: obs_object_name(n),
314: l_drop_statement,
315: l_insert_statement,
316: l_dropped);

Line 389: l_editions_enabled := ad_zd.is_editions_enabled;

385: end;
386:
387: -- dbms_output.put_line('l_apps_oracle_name: ' || l_apps_oracle_name);
388:
389: l_editions_enabled := ad_zd.is_editions_enabled;
390:
391: -- Do a bulk collect
392:
393: select aoo.object_name, aoo.object_type, aoo.dropped

Line 435: ad_zd_table.drop_table(null,

431: ''''||obs_object_type(n)||'''';
432:
433: if (UPPER(obs_object_type(n)) = 'TABLE')
434: then
435: ad_zd_table.drop_table(null,
436: obs_object_name(n),
437: l_drop_statement,
438: l_upd_statement,
439: l_dropped);

Line 441: ad_zd_mview.drop_mv(null,

437: l_drop_statement,
438: l_upd_statement,
439: l_dropped);
440: else
441: ad_zd_mview.drop_mv(null,
442: obs_object_name(n),
443: l_drop_statement,
444: l_upd_statement,
445: l_dropped);