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_DEVL_PROJECTS

Line 67: (SELECT devl_project_id FROM CZ_DEVL_PROJECTS WHERE devl_project_id=a.devl_project_id

63:
64: SELECT DISTINCT devl_project_id
65: BULK COLLECT INTO t_devl_project_id
66: FROM CZ_PS_NODES a WHERE NOT EXISTS
67: (SELECT devl_project_id FROM CZ_DEVL_PROJECTS WHERE devl_project_id=a.devl_project_id
68: AND deleted_flag='0') AND devl_project_id NOT IN(0,1);
69:
70: DECLARE
71: CURSOR C1 IS

Line 74: (SELECT devl_project_id FROM CZ_DEVL_PROJECTS WHERE devl_project_id=a.devl_project_id

70: DECLARE
71: CURSOR C1 IS
72: SELECT ps_node_id,intl_text_id
73: FROM CZ_PS_NODES a WHERE NOT EXISTS
74: (SELECT devl_project_id FROM CZ_DEVL_PROJECTS WHERE devl_project_id=a.devl_project_id
75: AND deleted_flag='0') AND devl_project_id NOT IN(0,1);
76: BEGIN
77: OPEN C1;
78: LOOP

Line 124: (SELECT devl_project_id FROM CZ_DEVL_PROJECTS WHERE devl_project_id=a.devl_project_id

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:
127: BEGIN
128: OPEN C1;

Line 157: '(SELECT devl_project_id FROM CZ_DEVL_PROJECTS WHERE devl_project_id=cz_ps_nodes.devl_project_id)',

153: raise;
154: END;
155:
156: CZ_BASE_MGR.exec('CZ_PS_NODES','WHERE NOT EXISTS '||
157: '(SELECT devl_project_id FROM CZ_DEVL_PROJECTS WHERE devl_project_id=cz_ps_nodes.devl_project_id)',
158: 'ps_node_id', FALSE);
159:
160: END;
161:

Line 180: 'model_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',

176:
177: begin
178:
179: CZ_BASE_MGR.exec('CZ_MODEL_REF_EXPLS','where deleted_flag='''||'0'||''' AND '||
180: 'model_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
181: 'model_ref_expl_id',FALSE);
182:
183: CZ_BASE_MGR.exec('CZ_PS_NODES','where deleted_flag='''||'0'||''' AND '||
184: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',

Line 184: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',

180: 'model_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
181: 'model_ref_expl_id',FALSE);
182:
183: CZ_BASE_MGR.exec('CZ_PS_NODES','where deleted_flag='''||'0'||''' AND '||
184: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
185: 'ps_node_id',FALSE);
186:
187: -- necessary?
188: /*

Line 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))',

197: end loop;
198: */
199:
200: CZ_BASE_MGR.exec('CZ_RULE_FOLDERS','where deleted_flag='''||'0'||''' 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 '||

Line 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))',

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 '||
210: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',

Line 210: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',

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 '||
210: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
211: 'grid_id',FALSE);
212:
213: CZ_BASE_MGR.exec('CZ_FUNC_COMP_SPECS','where deleted_flag='''||'0'||''' AND '||
214: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',

Line 214: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',

210: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
211: 'grid_id',FALSE);
212:
213: CZ_BASE_MGR.exec('CZ_FUNC_COMP_SPECS','where deleted_flag='''||'0'||''' AND '||
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'||''')',

Line 281: 'devl_project_id in (select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',

277: 'archive_id in (select archive_id from cz_archives where deleted_flag='''||'1'||''')',
278: 'DEVL_PROJECT_ID', 'SEQ_NBR', 'ARCHIVE_ID', FALSE);
279:
280: CZ_BASE_MGR.exec('CZ_ARCHIVE_REFS','where deleted_flag='''||'0'||''' AND '||
281: 'devl_project_id in (select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
282: 'DEVL_PROJECT_ID', 'SEQ_NBR', 'ARCHIVE_ID', FALSE);
283:
284: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag='''||'0'||''' AND '||
285: 'exists (select intl_text_id from CZ_DEVL_PROJECTS where intl_text_id = cz_localized_texts.intl_text_id and deleted_flag=''1'' and devl_project_id NOT IN(0,1))',

Line 285: 'exists (select intl_text_id from CZ_DEVL_PROJECTS where intl_text_id = cz_localized_texts.intl_text_id and deleted_flag=''1'' and devl_project_id NOT IN(0,1))',

281: 'devl_project_id in (select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
282: 'DEVL_PROJECT_ID', 'SEQ_NBR', 'ARCHIVE_ID', FALSE);
283:
284: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag='''||'0'||''' AND '||
285: 'exists (select intl_text_id from CZ_DEVL_PROJECTS where intl_text_id = cz_localized_texts.intl_text_id and deleted_flag=''1'' and devl_project_id NOT IN(0,1))',
286: 'language','intl_text_id',TRUE);
287:
288: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag='''||'0'||''' AND '||
289: 'exists (select violation_text_id from CZ_PS_NODES where violation_text_id = cz_localized_texts.intl_text_id and deleted_flag='''||'1'||''')',

Line 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))',

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))',
298: 'language','intl_text_id',TRUE);
299:
300: delete_Orphaned_Nodes;
301:

Line 324: (SELECT NULL FROM CZ_DEVL_PROJECTS b

320: -- ( such nodes will be deleted )
321: CURSOR del_nodes_cur IS
322: SELECT a.ps_node_id
323: FROM CZ_PS_NODES a WHERE a.reference_id IS NOT NULL AND NOT EXISTS
324: (SELECT NULL FROM CZ_DEVL_PROJECTS b
325: WHERE b.devl_project_id=a.reference_id AND b.deleted_flag='0');
326:
327: t_ps_node_id number_tbl_type;
328: