DBA Data[Home] [Help]

APPS.CZ_PS_MGR dependencies on CZ_POPULATORS

Line 271: CZ_BASE_MGR.exec('CZ_POPULATORS','where deleted_flag='''||'0'||''' AND seeded_flag<>'''||'1'||''' AND '||

267: CZ_BASE_MGR.exec('CZ_COMBO_FEATURES','where deleted_flag='''||'0'||''' AND '||
268: 'rule_id in(select rule_id from cz_rules where deleted_flag='''||'1'||''')',
269: 'feature_id','model_ref_expl_id','rule_id',FALSE);
270:
271: CZ_BASE_MGR.exec('CZ_POPULATORS','where deleted_flag='''||'0'||''' AND seeded_flag<>'''||'1'||''' AND '||
272: 'owned_by_node_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
273: 'populator_id',FALSE);
274:
275: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_PS_PROP_VALS : 1','CZ_PS_PROP_VALS',0,2);

Line 404: for i in(select view_name from cz_populators where deleted_flag='1')

400:
401: --
402: -- delete views associated with the deleted Populators --
403: --
404: for i in(select view_name from cz_populators where deleted_flag='1')
405: loop
406: begin
407: execute immediate 'drop view '||i.view_name;
408: exception