[Home] [Help]
1: PACKAGE BODY AD_ZD_SYS AS
2: /* $Header: adgrants.sql 120.67.12020000.13 2013/05/15 11:19:38 mkumandu ship $ */
3:
4: C_PACKAGE constant varchar2(80) := 'ad.plsql.ad_zd_sys.';
5:
1: PACKAGE BODY AD_ZD_SYS AS
2: /* $Header: adgrants.sql 120.67.12020000.13 2013/05/15 11:19:38 mkumandu ship $ */
3:
4: C_PACKAGE constant varchar2(80) := 'ad.plsql.ad_zd_sys.';
5:
6: /*
7: ** Exceptions we handle
8: */
420: -- Store drop action in DDL Handler for parallel execution
421: l_sql := 'insert into '|| l_applsys ||'.ad_zd_ddl_handler ' ||
422: '(phase, ddl_id, sql_lob, executed, status) values (' ||
423: q'['DROP_COVERED_OBJS',]' || l_applsys ||'.ad_zd_ddl_handler_ddl_s.nextval, ' ||
424: q'['begin sys.ad_zd_sys.drop_covered_object('']' || l_owner||
425: q'['','']' || l_object_name ||
426: q'['','']' || l_object_type ||
427: q'['','']' || l_edition_name ||
428: q'[''); end;', 'N', 'NOT-EXEC')]' ;
764:
765: l_sql := 'insert into '|| l_applsys ||'.ad_zd_ddl_handler ' ||
766: '(phase, ddl_id, sql_lob, executed, status) values (''' || l_phase ||
767: q'[',]' || l_applsys ||'.ad_zd_ddl_handler_ddl_s.nextval, ' ||
768: q'['begin sys.ad_zd_sys.actualize_object('']' || l_owner||
769: q'['','']' || l_object_name ||
770: q'['','']' || l_object_type ||
771: q'[''); end;', 'N', 'NOT-EXEC')]' ;
772:
887:
888: end ACTUALIZE_ALL;
889:
890:
891: END AD_ZD_SYS;