APPS.AD_ZD_MVIEW dependencies on AD_ZD_PARALLEL_EXEC

Line 524: l_phase varchar2(80) := ad_zd_parallel_exec.C_PHASE_CUTOVER;

520: is
521: c_module varchar2(25) := 'drop_recreate';
522: l_exp_mvdef clob;
523: l_exist number;
524: l_phase varchar2(80) := ad_zd_parallel_exec.C_PHASE_CUTOVER;
525: l_ddl_defs ddl_defs;
526: begin
527: log(c_module, 'PROCEDURE', 'begin: '||p_owner||'.'||p_mview_name);
528:

Line 530: l_phase := ad_zd_parallel_exec.C_PHASE_UPGRADE_MVIEW;

526: begin
527: log(c_module, 'PROCEDURE', 'begin: '||p_owner||'.'||p_mview_name);
528:
529: if (ad_zd.get_edition('PATCH') is null) then
530: l_phase := ad_zd_parallel_exec.C_PHASE_UPGRADE_MVIEW;
531: end if;
532:
533: -- If MVLog exist then install mvlog marker
534: select count(1) into l_exist

Line 566: ad_zd_parallel_exec.load(

562: when others then
563: log(c_module, 'ERROR', 'MV creation failed. Storing all dependent DDLs in AD_ZD_DDL_HANDLER table');
564: for idx in 1..l_ddl_defs.count
565: loop
566: ad_zd_parallel_exec.load(
567: x_phase => l_phase,
568: x_sql => l_ddl_defs(idx),
569: x_unique => true);
570: log(c_module, 'ERROR', l_ddl_defs(idx));

Line 583: ad_zd_parallel_exec.load(

579: exec(c_module, l_ddl_defs(idx));
580: exception
581: when others then
582: log(c_module, 'ERROR', 'Dependent object creation failed. Storing DDL in AD_ZD_DDL_HANDLER table');
583: ad_zd_parallel_exec.load(
584: x_phase => l_phase,
585: x_sql => l_ddl_defs(idx),
586: x_unique => true);
587: log(c_module, 'ERROR', l_ddl_defs(idx));

Line 1792: ad_zd_parallel_exec.load(

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(
1793: x_phase => ad_zd_parallel_exec.c_phase_cutover,
1794: x_sql => l_stmt,
1795: x_unique => true); /* there are channces for duplicacy */
1796:

Line 1793: x_phase => ad_zd_parallel_exec.c_phase_cutover,

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(
1793: x_phase => ad_zd_parallel_exec.c_phase_cutover,
1794: x_sql => l_stmt,
1795: x_unique => true); /* there are channces for duplicacy */
1796:
1797: end if;

Line 1915: ad_zd_parallel_exec.load(

1911: for obj in c_mvs loop
1912: if (x_execute = 1) then
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;

Line 1916: ad_zd_parallel_exec.c_phase_upgrade_mview,

1912: if (x_execute = 1) then
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;