[Home] [Help]
217: CZ_BASE_MGR.exec('CZ_COMBO_FEATURES','where deleted_flag='''||'0'||''' AND '||
218: 'rule_id in(select rule_id from cz_rules where deleted_flag='''||'1'||''')',
219: 'feature_id','model_ref_expl_id','rule_id',FALSE);
220:
221: CZ_BASE_MGR.exec('CZ_POPULATORS','where deleted_flag='''||'0'||''' AND seeded_flag<>'''||'1'||''' AND '||
222: 'owned_by_node_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
223: 'populator_id',FALSE);
224:
225: CZ_BASE_MGR.exec('CZ_PS_PROP_VALS','where deleted_flag='''||'0'||''' AND '||
334:
335: --
336: -- delete views associated with the deleted Populators --
337: --
338: for i in(select view_name from cz_populators where deleted_flag='1')
339: loop
340: begin
341: execute immediate 'drop view '||i.view_name;
342: exception