DBA Data[Home] [Help]

APPS.AD_ZD dependencies on AD_ZD_PARALLEL_EXEC

Line 115: ad_zd_parallel_exec.load(

111: ** x_sql - sql statement or pl/sql block to be executed.
112: */
113: procedure LOAD_DDL(X_PHASE in varchar2, X_SQL in varchar2) is
114: begin
115: ad_zd_parallel_exec.load(
116: x_phase => x_phase,
117: x_sql => to_clob(x_sql),
118: x_unique => true); -- check for uniqueness
119: end;

Line 728: ad_zd_parallel_exec.cleanup;

724: log(c_module, 'PROCEDURE', 'begin: '||x_mode);
725: ad_zd_log.clear;
726:
727: -- Clear ALL ddls
728: ad_zd_parallel_exec.cleanup;
729:
730: -- TODO: verify EBS_LOGON trigger exists and is enabled.
731:
732: -- Check freespace: does not work

Line 841: ad_zd_parallel_exec.execute('CUTOVER', 1, 1, NULL);

837: if (x_mode is null) then
838: log(c_module, 'EVENT', 'Executing CUTOVER actions');
839:
840: -- Execute stored CUTOVER DDL
841: ad_zd_parallel_exec.execute('CUTOVER', 1, 1, NULL);
842:
843: -- Cutover sub-components
844: ad_zd_seed.cutover;
845: ad_zd_mview.cutover(x_execute => 1);

Line 902: ad_zd_parallel_exec.execute('CLEANUP', 1, 1, NULL);

898: drop_covered_objects;
899: end if;
900:
901: -- Execute stored CLEANUP DDL
902: ad_zd_parallel_exec.execute('CLEANUP', 1, 1, NULL);
903:
904: -- Cleanup sub-components
905: ad_zd_seed.cleanup;
906: ad_zd_table.cleanup(NULL, NULL, x_mode);

Line 908: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_cutover);

904: -- Cleanup sub-components
905: ad_zd_seed.cleanup;
906: ad_zd_table.cleanup(NULL, NULL, x_mode);
907:
908: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_cutover);
909: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_abort);
910: if ( x_mode = 'FULL') then
911: ad_zd.drop_old_editions();
912: end if;

Line 909: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_abort);

905: ad_zd_seed.cleanup;
906: ad_zd_table.cleanup(NULL, NULL, x_mode);
907:
908: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_cutover);
909: ad_zd_parallel_exec.cleanup(ad_zd_parallel_exec.c_phase_abort);
910: if ( x_mode = 'FULL') then
911: ad_zd.drop_old_editions();
912: end if;
913: log(c_module, 'PROCEDURE', 'end');

Line 944: ad_zd_parallel_exec.cleanup('CUTOVER');

940: kill_sessions('PATCH');
941:
942: log(c_module, 'EVENT', 'Aborting Patch Edition');
943: -- Cleanup deferred DDLs that are no longer relevant
944: ad_zd_parallel_exec.cleanup('CUTOVER');
945: ad_zd_parallel_exec.cleanup('CLEANUP');
946:
947: -- Undo any effectively editioned changes
948: ad_zd_seed.abort;

Line 945: ad_zd_parallel_exec.cleanup('CLEANUP');

941:
942: log(c_module, 'EVENT', 'Aborting Patch Edition');
943: -- Cleanup deferred DDLs that are no longer relevant
944: ad_zd_parallel_exec.cleanup('CUTOVER');
945: ad_zd_parallel_exec.cleanup('CLEANUP');
946:
947: -- Undo any effectively editioned changes
948: ad_zd_seed.abort;
949: ad_zd_table.abort;