DBA Data[Home] [Help]

APPS.AD_ZD_SEED dependencies on AD_ZD_PARALLEL_EXEC

Line 793: ad_zd_parallel_exec.load('UPGRADE_SEED',

789: -- get parallel servers info
790: select to_number(value) into v_parallel
791: from v$parameter where name='parallel_max_servers';
792:
793: ad_zd_parallel_exec.load('UPGRADE_SEED',
794: 'begin '||ad_zd.apps_schema||'.ad_zd_seed.upgrade('''||x_table_name||'''); end;',
795: true);
796: ad_zd_parallel_exec.load('COLLECT_STATS',
797: 'begin '||ad_zd.apps_schema||'.fnd_stats.gather_table_stats('''||l_table_owner||''','''||x_table_name||''', 100, '||v_parallel||'); end;',

Line 796: ad_zd_parallel_exec.load('COLLECT_STATS',

792:
793: ad_zd_parallel_exec.load('UPGRADE_SEED',
794: 'begin '||ad_zd.apps_schema||'.ad_zd_seed.upgrade('''||x_table_name||'''); end;',
795: true);
796: ad_zd_parallel_exec.load('COLLECT_STATS',
797: 'begin '||ad_zd.apps_schema||'.fnd_stats.gather_table_stats('''||l_table_owner||''','''||x_table_name||''', 100, '||v_parallel||'); end;',
798: true);
799: commit;
800: log(c_module, 'PROCEDURE', 'end');