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_ZD_PREP dependencies on AD_ZD_PARALLEL_EXEC

Line 71: -- Calls ad_zd_parallel_exec.load with same parameters.

67: log(l_module, 'ERROR', 'ERROR: ->['|| substr(sqlerrm,1,400) || ' ] ' );
68: end if;
69: end exec;
70:
71: -- Calls ad_zd_parallel_exec.load with same parameters.
72: procedure LOAD(
73: X_PHASE varchar2,
74: X_SQL clob)
75: is

Line 79: ad_zd_parallel_exec.load(x_phase, x_sql, false);

75: is
76: begin
77: -- SQLs from DB Prep flow can NOT be duplicate, so
78: -- should not be checked for duplicity i.e. x_unique => false.
79: ad_zd_parallel_exec.load(x_phase, x_sql, false);
80: end;
81:
82: --
83: --

Line 223: load(x_phase=> ad_zd_parallel_exec.c_phase_compile_type,

219: begin
220: if(x_exec) then
221: exec('begin dbms_utility.compile_schema(schema=>'''||g_apps_ne_schema||'''); end;', l_module);
222: else
223: load(x_phase=> ad_zd_parallel_exec.c_phase_compile_type,
224: x_sql => 'begin dbms_utility.compile_schema(schema=>'''|| g_apps_ne_schema||'''); end;');
225: end if;
226: end compile_ne_schema;
227:

Line 491: load(x_phase => ad_zd_parallel_exec.c_phase_drop_unused_object,

487:
488: begin
489:
490: for queue in c_queues loop
491: load(x_phase => ad_zd_parallel_exec.c_phase_drop_unused_object,
492: x_sql => 'begin ad_zd_prep.drop_queues('
493: || '''' || queue.owner || ''', '''
494: || queue.name || '''); end; ');
495: end loop;

Line 882: load(x_phase => ad_zd_parallel_exec.c_phase_copy_type,

878:
879: for t in all_types loop
880: if( is_type_evolved(t.referenced_owner, t.referenced_name) <> 'Y') then
881: -- normal UDTs
882: load(x_phase => ad_zd_parallel_exec.c_phase_copy_type,
883: x_sql => 'begin ad_zd_prep.copy_type('''
884: || t.referenced_owner || ''', '''
885: || t.referenced_name || ''','''
886: || g_apps_ne_schema || '''); end;');

Line 896: load(x_phase => ad_zd_parallel_exec.c_phase_fix_type,

892: put_obj_to_recompile(t.referenced_owner, t.referenced_name);
893:
894: -- FIX_TYPE will check dependency, if exist, will try to fix before
895: -- dropping a type.
896: load(x_phase => ad_zd_parallel_exec.c_phase_fix_type,
897: x_sql => 'begin ad_zd_prep.fix_type('''
898: || t.referenced_owner || ''', '''
899: || t.referenced_name || '''); end; ');
900:

Line 989: load(x_phase=> ad_zd_parallel_exec.c_phase_fix_type,

985: l_type_name := l_evolve_type_list(i).type_name;
986:
987: exec('GRANT EXECUTE ON "'||g_apps_ne_schema||'"."' || l_type_name || '" TO PUBLIC ', l_module, true);
988:
989: load(x_phase=> ad_zd_parallel_exec.c_phase_fix_type,
990: x_sql => 'begin ad_zd_prep.fix_type('
991: || '''' || l_owner || ''', '''
992: || l_type_name || '''); end; ');
993:

Line 1239: load(x_phase => ad_zd_parallel_exec.c_phase_copy_evolved_type,

1235:
1236: if(l_count > 0 ) then
1237: -- Note: Evolved types should be created in a proper order and dependent TYPEs should be VALID.
1238: -- otherwise ALTER TYPE command will fail. So let it be run by a single worker.
1239: load(x_phase => ad_zd_parallel_exec.c_phase_copy_evolved_type,
1240: x_sql => 'begin ad_zd_prep.copy_evolved_types; end; ');
1241:
1242: end if;
1243: log(l_module, 'PROCEDURE', 'end');

Line 1328: load(x_phase => ad_zd_parallel_exec.c_phase_fix_column,

1324: l_sql := 'begin ad_zd_prep.fix_types(' ||
1325: 'x_source_schema =>''' || g_udt_obj_list(idx).owner || ''', ' ||
1326: 'x_target_schema => '''|| g_apps_ne_schema || ''') ; end;' ;
1327:
1328: load(x_phase => ad_zd_parallel_exec.c_phase_fix_column,
1329: x_sql => l_sql);
1330:
1331: l_type_owner(g_udt_obj_list(idx).owner) := 1;
1332: end if;

Line 1373: load(x_phase => ad_zd_parallel_exec.c_phase_copy_type,

1369: fetch c_queues INTO l_queue, l_queue_type;
1370: --
1371: -- Merging with COPY_TYPE phase as both are independent.
1372: while (c_queues%found) loop
1373: load(x_phase => ad_zd_parallel_exec.c_phase_copy_type,
1374: x_sql => 'begin ad_zd_prep.stop_queue(''' || l_queue ||'''); end;');
1375:
1376: fetch c_queues INTO l_queue, l_queue_type;
1377: end loop;

Line 1385: load(x_phase => ad_zd_parallel_exec.c_phase_recreate_aq_object,

1381: fix_column(x_owner, x_table, x_column);
1382:
1383: -- This phase should be executed after DROP_OBJECT, so if still there is any UDT reference
1384: -- , can be fixed.
1385: load(x_phase => ad_zd_parallel_exec.c_phase_recreate_aq_object,
1386: x_sql => 'begin ad_zd_prep.recreate_aq_object(''' || x_owner ||''', ''' || x_table ||'''); end;');
1387:
1388: log(l_module, 'PROCEDURE', 'end');
1389: end FIX_QUEUE;

Line 1623: load(x_phase=> ad_zd_parallel_exec.c_phase_fix_public_synonym,

1619: 'TRIGGER','FUNCTION'));
1620: begin
1621: log(l_module, 'PROCEDURE', 'begin');
1622: for rec in c_public_synonyms loop
1623: load(x_phase=> ad_zd_parallel_exec.c_phase_fix_public_synonym,
1624: x_sql => 'begin ad_zd_prep.fix_public_synonym(''' || rec.synonym_name || ''', ''' ||
1625: rec.table_owner || ''',''' || rec.table_name ||''','''|| rec.db_link || '''); end;');
1626:
1627: end loop;

Line 1786: load(x_phase => ad_zd_parallel_exec.c_phase_drop_object,

1782:
1783: begin
1784: log(l_module, 'PROCEDURE', 'begin');
1785: for rec in ctxpkg loop
1786: load(x_phase => ad_zd_parallel_exec.c_phase_drop_object,
1787: x_sql => 'begin ad_zd_prep.drop_ctxsys_pkg(''' || rec.name || '''); end;');
1788:
1789: end loop;
1790:

Line 1793: load(x_phase => ad_zd_parallel_exec.c_phase_drop_object,

1789: end loop;
1790:
1791: -- drop problematic synonyms
1792: for rec in c_synonyms loop
1793: load(x_phase => ad_zd_parallel_exec.c_phase_drop_object,
1794: x_sql => 'begin ad_zd_prep.drop_ctxsys_synonym(''' || rec.synonym_name || '''); end;');
1795: end loop;
1796: log(l_module, 'PROCEDURE', 'end');
1797: end FIX_CTXSYS;

Line 2121: load(x_phase => ad_zd_parallel_exec.c_phase_enable_editioning,

2117: begin
2118: log(l_module, 'PROCEDURE', 'begin');
2119:
2120: for rec in c_users loop
2121: load(x_phase => ad_zd_parallel_exec.c_phase_enable_editioning,
2122: x_sql => 'begin ad_zd_prep.enable_user_4edition('''||rec.username||'''); end;');
2123:
2124: end loop;
2125: log(l_module, 'PROCEDURE', 'end');

Line 2147: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_unused_object);

2143: log(c_module, 'STATEMENT', 'Cleaning up AD_ZD_DDL_HANDLER table' );
2144:
2145: -- **** Clean ONLY DB PREP data, as SEED-UPGRADE data
2146: -- has already been populated *****.
2147: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_unused_object);
2148: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_type);
2149: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_compile_type);
2150: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_evolved_type);
2151: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_column);

Line 2148: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_type);

2144:
2145: -- **** Clean ONLY DB PREP data, as SEED-UPGRADE data
2146: -- has already been populated *****.
2147: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_unused_object);
2148: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_type);
2149: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_compile_type);
2150: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_evolved_type);
2151: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_column);
2152: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_type);

Line 2149: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_compile_type);

2145: -- **** Clean ONLY DB PREP data, as SEED-UPGRADE data
2146: -- has already been populated *****.
2147: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_unused_object);
2148: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_type);
2149: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_compile_type);
2150: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_evolved_type);
2151: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_column);
2152: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_type);
2153: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_public_synonym);

Line 2150: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_evolved_type);

2146: -- has already been populated *****.
2147: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_unused_object);
2148: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_type);
2149: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_compile_type);
2150: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_evolved_type);
2151: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_column);
2152: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_type);
2153: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_public_synonym);
2154: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_recreate_aq_object);

Line 2151: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_column);

2147: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_unused_object);
2148: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_type);
2149: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_compile_type);
2150: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_evolved_type);
2151: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_column);
2152: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_type);
2153: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_public_synonym);
2154: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_recreate_aq_object);
2155: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_object);

Line 2152: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_type);

2148: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_type);
2149: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_compile_type);
2150: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_evolved_type);
2151: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_column);
2152: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_type);
2153: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_public_synonym);
2154: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_recreate_aq_object);
2155: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_object);
2156: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_enable_editioning);

Line 2153: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_public_synonym);

2149: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_compile_type);
2150: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_evolved_type);
2151: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_column);
2152: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_type);
2153: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_public_synonym);
2154: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_recreate_aq_object);
2155: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_object);
2156: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_enable_editioning);
2157: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_table);

Line 2154: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_recreate_aq_object);

2150: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_copy_evolved_type);
2151: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_column);
2152: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_type);
2153: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_public_synonym);
2154: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_recreate_aq_object);
2155: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_object);
2156: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_enable_editioning);
2157: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_table);
2158: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_mview);

Line 2155: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_object);

2151: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_column);
2152: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_type);
2153: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_public_synonym);
2154: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_recreate_aq_object);
2155: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_object);
2156: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_enable_editioning);
2157: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_table);
2158: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_mview);
2159:

Line 2156: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_enable_editioning);

2152: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_type);
2153: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_public_synonym);
2154: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_recreate_aq_object);
2155: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_object);
2156: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_enable_editioning);
2157: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_table);
2158: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_mview);
2159:
2160: -- STEP#1)

Line 2157: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_table);

2153: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_fix_public_synonym);
2154: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_recreate_aq_object);
2155: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_object);
2156: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_enable_editioning);
2157: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_table);
2158: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_mview);
2159:
2160: -- STEP#1)
2161: log(c_module, 'STATEMENT', 'Invoking drop_temp_queues ' );

Line 2158: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_mview);

2154: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_recreate_aq_object);
2155: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_drop_object);
2156: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_enable_editioning);
2157: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_table);
2158: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_upgrade_mview);
2159:
2160: -- STEP#1)
2161: log(c_module, 'STATEMENT', 'Invoking drop_temp_queues ' );
2162: drop_temp_queues;