eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_PS_MGR dependencies on CZ_RULES

Line 108: UPDATE CZ_RULES SET deleted_flag='1'

104: CLOSE C1;
105: END;
106: IF t_devl_project_id.Count>0 THEN
107: FORALL i IN t_devl_project_id.First..t_devl_project_id.Last
108: UPDATE CZ_RULES SET deleted_flag='1'
109: WHERE devl_project_id=t_devl_project_id(i);
110: COMMIT;
111: END IF;
112:

Line 122: FROM CZ_RULES a

118:
119: DECLARE
120: CURSOR C1 IS
121: SELECT rule_id,reason_id
122: FROM CZ_RULES a
123: WHERE NOT EXISTS
124: (SELECT devl_project_id FROM CZ_DEVL_PROJECTS WHERE devl_project_id=a.devl_project_id
125: AND deleted_flag='0') AND a.seeded_flag<>'1' AND devl_project_id NOT IN(0,1);
126:

Line 144: UPDATE CZ_RULES SET deleted_flag='1'

140: END IF;
141:
142: IF t_rule_id.Count>0 THEN
143: FORALL i IN t_rule_id.First..t_rule_id.Last
144: UPDATE CZ_RULES SET deleted_flag='1'
145: WHERE rule_id=t_rule_id(i) AND seeded_flag<>'1';
146: COMMIT;
147: END IF;
148: END LOOP;

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

201: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag=''1'' and devl_project_id NOT IN(0,1))',
202: 'rule_folder_id','object_type',FALSE);
203:
204:
205: CZ_BASE_MGR.exec('CZ_RULES','where deleted_flag='''||'0'||''' AND seeded_flag<>'''||'1'||''' AND '||
206: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag=''1'' and devl_project_id NOT IN(0,1))',
207: 'rule_id',FALSE);
208:
209: CZ_BASE_MGR.exec('CZ_GRID_DEFS','where deleted_flag='''||'0'||''' AND '||

Line 218: 'rule_id in(select rule_id from cz_rules where deleted_flag='''||'1'||''')',

214: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
215: 'func_comp_id',FALSE);
216:
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'||''')',

Line 234: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',

230: 'sub_cons_id in(select sub_cons_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
231: 'sub_cons_id',FALSE);
232:
233: CZ_BASE_MGR.exec('CZ_FILTER_SETS','where deleted_flag='''||'0'||''' AND '||
234: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',
235: 'filter_set_id',FALSE);
236:
237: CZ_BASE_MGR.exec('CZ_EXPRESSION_NODES','where deleted_flag='''||'0'||''' AND seeded_flag<>'''||'1'||''' AND '||
238: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',

Line 238: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',

234: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',
235: 'filter_set_id',FALSE);
236:
237: CZ_BASE_MGR.exec('CZ_EXPRESSION_NODES','where deleted_flag='''||'0'||''' AND seeded_flag<>'''||'1'||''' AND '||
238: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',
239: 'expr_node_id',TRUE);
240:
241: CZ_BASE_MGR.exec('CZ_LCE_HEADERS','where deleted_flag='''||'0'||''' AND '||
242: 'component_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',

Line 260: 'exists (select reason_id from CZ_RULES where reason_id = cz_localized_texts.intl_text_id and deleted_flag='''||'1'||''') and '||

256: ' deleted_flag=''0'')',
257: 'language','intl_text_id',TRUE);
258:
259: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag='''||'0'||''' AND seeded_flag<>'''||'1'||''' AND '||
260: 'exists (select reason_id from CZ_RULES where reason_id = cz_localized_texts.intl_text_id and deleted_flag='''||'1'||''') and '||
261: 'not exists(select reason_id from CZ_RULES where reason_id=cz_localized_texts.intl_text_id and deleted_flag='''||'0'||''')',
262: 'language','intl_text_id',TRUE);
263:
264: CZ_BASE_MGR.exec('CZ_DES_CHART_CELLS','where deleted_flag='''||'0'||''' AND '||

Line 261: 'not exists(select reason_id from CZ_RULES where reason_id=cz_localized_texts.intl_text_id and deleted_flag='''||'0'||''')',

257: 'language','intl_text_id',TRUE);
258:
259: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag='''||'0'||''' AND seeded_flag<>'''||'1'||''' AND '||
260: 'exists (select reason_id from CZ_RULES where reason_id = cz_localized_texts.intl_text_id and deleted_flag='''||'1'||''') and '||
261: 'not exists(select reason_id from CZ_RULES where reason_id=cz_localized_texts.intl_text_id and deleted_flag='''||'0'||''')',
262: 'language','intl_text_id',TRUE);
263:
264: CZ_BASE_MGR.exec('CZ_DES_CHART_CELLS','where deleted_flag='''||'0'||''' AND '||
265: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',

Line 265: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',

261: 'not exists(select reason_id from CZ_RULES where reason_id=cz_localized_texts.intl_text_id and deleted_flag='''||'0'||''')',
262: 'language','intl_text_id',TRUE);
263:
264: CZ_BASE_MGR.exec('CZ_DES_CHART_CELLS','where deleted_flag='''||'0'||''' AND '||
265: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',
266: 'RULE_ID','PRIMARY_OPT_ID','SECONDARY_OPT_ID','SECONDARY_FEAT_EXPL_ID',TRUE);
267:
268: CZ_BASE_MGR.exec('CZ_DES_CHART_COLUMNS','where '||
269: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',

Line 269: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',

265: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',
266: 'RULE_ID','PRIMARY_OPT_ID','SECONDARY_OPT_ID','SECONDARY_FEAT_EXPL_ID',TRUE);
267:
268: CZ_BASE_MGR.exec('CZ_DES_CHART_COLUMNS','where '||
269: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',
270: 'rule_id','option_id',TRUE);
271:
272: CZ_BASE_MGR.exec('CZ_DES_CHART_FEATURES','where deleted_flag='''||'0'||''' AND '||
273: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',

Line 273: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',

269: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',
270: 'rule_id','option_id',TRUE);
271:
272: CZ_BASE_MGR.exec('CZ_DES_CHART_FEATURES','where deleted_flag='''||'0'||''' AND '||
273: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',
274: 'RULE_ID', 'FEATURE_ID', 'MODEL_REF_EXPL_ID', FALSE);
275:
276: CZ_BASE_MGR.exec('CZ_ARCHIVE_REFS','where deleted_flag='''||'0'||''' AND '||
277: 'archive_id in (select archive_id from cz_archives where deleted_flag='''||'1'||''')',

Line 293: 'exists (select unsatisfied_msg_id from CZ_RULES where unsatisfied_msg_id = cz_localized_texts.intl_text_id and deleted_flag='''||'1'||''')',

289: 'exists (select violation_text_id from CZ_PS_NODES where violation_text_id = cz_localized_texts.intl_text_id and deleted_flag='''||'1'||''')',
290: 'language','intl_text_id',TRUE);
291:
292: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag='''||'0'||''' AND '||
293: 'exists (select unsatisfied_msg_id from CZ_RULES where unsatisfied_msg_id = cz_localized_texts.intl_text_id and deleted_flag='''||'1'||''')',
294: 'language','intl_text_id',TRUE);
295:
296: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag='''||'0'||''' AND '||
297: 'exists (select devl_project_id from CZ_DEVL_PROJECTS where devl_project_id = cz_localized_texts.model_id and deleted_flag=''1'' and devl_project_id NOT IN(0,1))',