APPS.AD_ZD dependencies on AD_ZD_SYS

Line 160: sys.ad_zd_sys.alter_logon_trigger('DISABLE');

156: begin
157: log(c_module, 'EVENT', 'alter logon trigger : '|| x_status);
158: -- If anyone passes DISABLED or DISABLE or disable
159: if(upper(x_status) like 'DISABLE%') then
160: sys.ad_zd_sys.alter_logon_trigger('DISABLE');
161: elsif (upper(x_status) like 'ENABLE%') then
162: sys.ad_zd_sys.alter_logon_trigger('ENABLE');
163: else
164: error(c_module, 'The status: ' || x_status ||' is not a valid trigger status');

Line 162: sys.ad_zd_sys.alter_logon_trigger('ENABLE');

158: -- If anyone passes DISABLED or DISABLE or disable
159: if(upper(x_status) like 'DISABLE%') then
160: sys.ad_zd_sys.alter_logon_trigger('DISABLE');
161: elsif (upper(x_status) like 'ENABLE%') then
162: sys.ad_zd_sys.alter_logon_trigger('ENABLE');
163: else
164: error(c_module, 'The status: ' || x_status ||' is not a valid trigger status');
165: end if;
166: end ALTER_LOGON_TRIGGER;

Line 527: sys.ad_zd_sys.drop_covered_object(objrec.owner, objrec.object_name, objrec.object_type, objrec.edition_name);

523: log(c_module, 'STATEMENT', 'Dropping covered objects in '||objrec.edition_name);
524: l_last_edition := objrec.edition_name;
525: end if;
526: begin
527: sys.ad_zd_sys.drop_covered_object(objrec.owner, objrec.object_name, objrec.object_type, objrec.edition_name);
528: exception
529: when c_user_cancel then
530: error(c_module, 'Cleanup cancelled');
531: when others then

Line 620: sys.ad_zd_sys.retire_edition(l_edition);

616: and table_name = l_edition
617: and grantee = 'PUBLIC';
618:
619: if (l_grantor = 'SYS') then
620: sys.ad_zd_sys.retire_edition(l_edition);
621: else
622: log(c_module, 'EVENT', 'Retire Edition: '||l_edition);
623: exec('revoke use on edition '||l_edition||' from PUBLIC', c_module);
624: end if;

Line 666: sys.ad_zd_sys.drop_edition(erec.edition_name);

662: exit when l_empty = 'N';
663:
664: -- drop empty old edition
665: begin
666: sys.ad_zd_sys.drop_edition(erec.edition_name);
667: exception
668: when others then
669: log(c_module, 'WARNING', 'Could not drop empty edition '||erec.edition_name);
670: exit;

Line 703: sys.ad_zd_sys.drop_edition(l_edition);

699: -- do it
700: if x_edition_type = 'OLD' then
701: ad_zd.drop_old_editions;
702: else
703: sys.ad_zd_sys.drop_edition(l_edition);
704: end if;
705:
706: log(c_module, 'PROCEDURE', 'end');
707: end;