APPS.AD_ZD_TABLE dependencies on AD_ZD_PARALLEL_EXEC

Line 36: ad_zd_parallel_exec.load(

32: -- immediate execution
33: ad_zd.exec(x_sql, x_log_mod, x_ignore);
34: else
35: -- deferred execution: < Control won't come here as of 22-Aug-2012 >
36: ad_zd_parallel_exec.load(
37: x_phase => x_phase,
38: x_sql => x_sql,
39: x_unique => true );
40: end if;

Line 55: ad_zd_parallel_exec.load(

51: -- immediate execution
52: ad_zd.exec(x_sql, x_log_mod, x_ignore);
53: else
54: -- deferred execution:
55: ad_zd_parallel_exec.load(
56: x_phase => x_phase,
57: x_sql => x_sql,
58: x_unique => true);
59: end if;

Line 1353: ad_zd_parallel_exec.load(

1349:
1350: -- Process tables that need upgrade
1351: for tab_rec in c_upgrade_tables loop
1352: log(c_module, 'STATEMENT', 'Store Upgrade action for table '||tab_rec.table_name );
1353: ad_zd_parallel_exec.load(
1354: x_phase => ad_zd_parallel_exec.c_phase_upgrade_table,
1355: x_sql => 'begin ad_zd_table.upgrade('''||tab_rec.table_owner ||''', '''|| tab_rec.table_name || '''); end;' ,
1356: x_unique => false );
1357: end loop;

Line 1354: x_phase => ad_zd_parallel_exec.c_phase_upgrade_table,

1350: -- Process tables that need upgrade
1351: for tab_rec in c_upgrade_tables loop
1352: log(c_module, 'STATEMENT', 'Store Upgrade action for table '||tab_rec.table_name );
1353: ad_zd_parallel_exec.load(
1354: x_phase => ad_zd_parallel_exec.c_phase_upgrade_table,
1355: x_sql => 'begin ad_zd_table.upgrade('''||tab_rec.table_owner ||''', '''|| tab_rec.table_name || '''); end;' ,
1356: x_unique => false );
1357: end loop;
1358:

Line 1362: ad_zd_parallel_exec.load(

1358:
1359: -- Process tables that need re-upgrade.
1360: for tab_rec in c_reupgrade_tables loop
1361: log(c_module, 'STATEMENT', 'Store Re-Upgrade action for table '||tab_rec.table_name );
1362: ad_zd_parallel_exec.load(
1363: x_phase => ad_zd_parallel_exec.c_phase_upgrade_table,
1364: x_sql => 'begin ad_zd_table.upgrade('''||tab_rec.table_owner ||''', '''|| tab_rec.table_name || '''); end;' ,
1365: x_unique => false);
1366:

Line 1363: x_phase => ad_zd_parallel_exec.c_phase_upgrade_table,

1359: -- Process tables that need re-upgrade.
1360: for tab_rec in c_reupgrade_tables loop
1361: log(c_module, 'STATEMENT', 'Store Re-Upgrade action for table '||tab_rec.table_name );
1362: ad_zd_parallel_exec.load(
1363: x_phase => ad_zd_parallel_exec.c_phase_upgrade_table,
1364: x_sql => 'begin ad_zd_table.upgrade('''||tab_rec.table_owner ||''', '''|| tab_rec.table_name || '''); end;' ,
1365: x_unique => false);
1366:
1367: end loop;

Line 2151: ad_zd_parallel_exec.load(

2147: revise_indexes(tablerec.owner, tablerec.name);
2148:
2149: -- Store cutover action: Check for uniqueness also:22-Aug-2012
2150: if (tablerec.status = 'N') then
2151: ad_zd_parallel_exec.load(
2152: x_phase => ad_zd_parallel_exec.c_phase_cutover,
2153: x_sql => 'begin ad_zd_table.cutover('||
2154: ''''||tablerec.owner||''', '||
2155: ''''||tablerec.name||'''); end;',

Line 2152: x_phase => ad_zd_parallel_exec.c_phase_cutover,

2148:
2149: -- Store cutover action: Check for uniqueness also:22-Aug-2012
2150: if (tablerec.status = 'N') then
2151: ad_zd_parallel_exec.load(
2152: x_phase => ad_zd_parallel_exec.c_phase_cutover,
2153: x_sql => 'begin ad_zd_table.cutover('||
2154: ''''||tablerec.owner||''', '||
2155: ''''||tablerec.name||'''); end;',
2156: x_unique => true);