APPS.AD_ZD_MVIEW dependencies on AD_ZD_MVIEW

Line 1: PACKAGE BODY AD_ZD_MVIEW AS

1: PACKAGE BODY AD_ZD_MVIEW AS
2: -- $Header: ADZDMVB.pls 120.38.12020000.12 2013/05/09 14:49:45 rraam ship $
3:
4:
5: /*******************************************************************

Line 17: AD_ZD_LOG.Message('ad.plsql.ad_zd_mview.'||p_module, p_log_type, p_message);

13: -- Diagnostic Log shortcut
14: procedure LOG(p_module varchar2, p_log_type varchar2, p_message varchar2)
15: is
16: begin
17: AD_ZD_LOG.Message('ad.plsql.ad_zd_mview.'||p_module, p_log_type, p_message);
18: end;
19:
20:
21: /*-----------------------------------------------------------------+

Line 1744: , ad_zd_mview.get_mv_name(lvv.view_name) mv_name

1740: case when lvx.status=1 then NULL else sysdate end
1741: else
1742: lvx.mtime
1743: end lv_changed
1744: , ad_zd_mview.get_mv_name(lvv.view_name) mv_name
1745: , mvo.created mv_changed
1746: from
1747: sys.obj$ lvx
1748: , ( select

Line 1788: l_stmt := 'begin '||ad_zd.apps_schema||'.ad_zd_mview.upgrade('''||

1784: -- execute cutover action
1785: upgrade(row.owner, row.mv_name);
1786: else
1787: -- store cutover action
1788: l_stmt := 'begin '||ad_zd.apps_schema||'.ad_zd_mview.upgrade('''||
1789: row.owner||''','''||row.mv_name||'''); end;';
1790:
1791: log(c_module, 'STATEMENT', 'Storing cutover action for: '||row.mv_name);
1792: ad_zd_parallel_exec.load(

Line 1871: and v.view_name = ad_zd_mview.get_mvq_name(m.mview_name) )

1867: where read_only_flag in ('A', 'E', 'U', 'B') )
1868: and not exists
1869: ( select 'X' from dba_views v
1870: where v.owner = m.owner
1871: and v.view_name = ad_zd_mview.get_mvq_name(m.mview_name) )
1872: and not exists
1873: ( select 'X'
1874: from fnd_oracle_userid fou
1875: , fnd_product_installations fpi

Line 1884: ad_zd_mview.get_mv_name(v.view_name) name

1880: and aoo.object_name = m.mview_name
1881: and aoo.object_type = 'MATERIALIZED VIEW' )
1882: union
1883: select v.owner owner,
1884: ad_zd_mview.get_mv_name(v.view_name) name
1885: from dba_views v
1886: where v.view_name like '%'||'#'
1887: and v.editioning_view = 'N'
1888: and v.owner in

Line 1894: and m.object_name = ad_zd_mview.get_mv_name(v.view_name)

1890: where read_only_flag in ('A', 'E', 'U', 'B') )
1891: and not exists
1892: ( select 'X' from dba_objects m
1893: where m.owner = v.owner
1894: and m.object_name = ad_zd_mview.get_mv_name(v.view_name)
1895: and m.object_type = 'MATERIALIZED VIEW'
1896: and m.status = 'VALID' )
1897: and not exists
1898: ( select 'X'

Line 1917: 'begin '||ad_zd.apps_schema||'.ad_zd_mview.upgrade('''||

1913: upgrade(obj.owner, obj.name);
1914: else
1915: ad_zd_parallel_exec.load(
1916: ad_zd_parallel_exec.c_phase_upgrade_mview,
1917: 'begin '||ad_zd.apps_schema||'.ad_zd_mview.upgrade('''||
1918: obj.owner||''','''||obj.name||'''); end;');
1919: end if;
1920: end loop;
1921:

Line 1955: ad_zd_mview.drop_mvq(l_mv_owner, x_mview_name);

1951: l_mv_owner := trim(nvl(x_mview_owner, l_appsname));
1952: log(C_MODULE, 'PROCEDURE', 'begin: '|| l_mv_owner ||'.'||x_mview_name);
1953:
1954: -- Drop Logical view pointing to the materialized view
1955: ad_zd_mview.drop_mvq(l_mv_owner, x_mview_name);
1956:
1957: -- (Deferred) drop materialized view logic
1958: if ad_zd.get_edition_type = 'RUN' then
1959: -- Drop materialized view

Line 2016: END AD_ZD_MVIEW;

2012: log( c_module, 'PROCEDURE', 'end');
2013: commit;
2014: end DROP_MV;
2015:
2016: END AD_ZD_MVIEW;