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) AND deleted_flag <> '1';
76: BEGIN
77: OPEN C1;
78: LOOP

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

126: CURSOR C1 IS
127: SELECT rule_id,reason_id
128: FROM CZ_RULES a
129: WHERE NOT EXISTS
130: (SELECT devl_project_id FROM CZ_DEVL_PROJECTS WHERE devl_project_id=a.devl_project_id
131: AND deleted_flag='0') AND a.seeded_flag<>'1' AND devl_project_id NOT IN(0,1);
132:
133: BEGIN
134: OPEN C1;

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

161: raise;
162: END;
163:
164: CZ_BASE_MGR.exec('CZ_PS_NODES','WHERE NOT EXISTS '||
165: '(SELECT devl_project_id FROM CZ_DEVL_PROJECTS WHERE devl_project_id=cz_ps_nodes.devl_project_id)',
166: 'ps_node_id', FALSE);
167:
168: --SKM:Bug13927565 . Physical Delete of Orphan Record for cz_ps_prop_vals
169: --SKM:Bug16042373. Removing Orphan cz_ps_prop_vals deletion as this causes publication & Purge concurrency issue that SUN reported.

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

220:
221: begin
222:
223: CZ_BASE_MGR.exec('CZ_MODEL_REF_EXPLS','where deleted_flag='''||'0'||''' AND '||
224: 'model_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
225: 'model_ref_expl_id',FALSE);
226:
227: --
228: -- vsingava 24th Dec '10. Bug10425915

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

230: -- TODO: IMPORTANT We need to revert this change.
231: -- Reverted the changes as a part of the bug#12608421 (As a one part of it)
232:
233: CZ_BASE_MGR.exec('CZ_PS_NODES','where deleted_flag='''||'0'||''' AND '||
234: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
235: 'ps_node_id',FALSE);
236:
237: -- necessary?
238: /*

Line 251: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag=''1'' and devl_project_id NOT IN(0,1))',

247: end loop;
248: */
249:
250: CZ_BASE_MGR.exec('CZ_RULE_FOLDERS','where deleted_flag='''||'0'||''' AND '||
251: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag=''1'' and devl_project_id NOT IN(0,1))',
252: 'rule_folder_id','object_type',FALSE);
253:
254:
255: CZ_BASE_MGR.exec('CZ_RULES','where deleted_flag='''||'0'||''' AND seeded_flag<>'''||'1'||''' AND '||

Line 256: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag=''1'' and devl_project_id NOT IN(0,1))',

252: 'rule_folder_id','object_type',FALSE);
253:
254:
255: CZ_BASE_MGR.exec('CZ_RULES','where deleted_flag='''||'0'||''' AND seeded_flag<>'''||'1'||''' AND '||
256: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag=''1'' and devl_project_id NOT IN(0,1))',
257: 'rule_id',FALSE);
258:
259: CZ_BASE_MGR.exec('CZ_GRID_DEFS','where deleted_flag='''||'0'||''' AND '||
260: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',

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

256: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag=''1'' and devl_project_id NOT IN(0,1))',
257: 'rule_id',FALSE);
258:
259: CZ_BASE_MGR.exec('CZ_GRID_DEFS','where deleted_flag='''||'0'||''' AND '||
260: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
261: 'grid_id',FALSE);
262:
263: CZ_BASE_MGR.exec('CZ_FUNC_COMP_SPECS','where deleted_flag='''||'0'||''' AND '||
264: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',

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

260: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
261: 'grid_id',FALSE);
262:
263: CZ_BASE_MGR.exec('CZ_FUNC_COMP_SPECS','where deleted_flag='''||'0'||''' AND '||
264: 'devl_project_id in(select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
265: 'func_comp_id',FALSE);
266:
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'||''')',

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

335: 'archive_id in (select archive_id from cz_archives where deleted_flag='''||'1'||''')',
336: 'DEVL_PROJECT_ID', 'SEQ_NBR', 'ARCHIVE_ID', FALSE);
337:
338: CZ_BASE_MGR.exec('CZ_ARCHIVE_REFS','where deleted_flag='''||'0'||''' AND '||
339: 'devl_project_id in (select devl_project_id from cz_devl_projects where deleted_flag='''||'1'||''')',
340: 'DEVL_PROJECT_ID', 'SEQ_NBR', 'ARCHIVE_ID', FALSE);
341:
342: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LOCALIZED_TEXTS (devl_proj.intl_text_id): 3','CZ_LOCALIZED_TEXTS',0,2);
343: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag='''||'0'||''' AND '||

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

340: 'DEVL_PROJECT_ID', 'SEQ_NBR', 'ARCHIVE_ID', FALSE);
341:
342: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LOCALIZED_TEXTS (devl_proj.intl_text_id): 3','CZ_LOCALIZED_TEXTS',0,2);
343: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag='''||'0'||''' AND '||
344: '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))',
345: 'language','intl_text_id',TRUE);
346: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LOCALIZED_TEXTS (devl_proj.intl_text_id): 3','CZ_LOCALIZED_TEXTS',0,2);
347:
348: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LOCALIZED_TEXTS (ps_nodes.violation_text): 4','CZ_LOCALIZED_TEXTS',0,2);

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

358: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LOCALIZED_TEXTS (cz_rules.unsatisfied_msg): 5','CZ_LOCALIZED_TEXTS',0,2);
359:
360: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LOCALIZED_TEXTS (deleted model_id): 6','CZ_LOCALIZED_TEXTS',0,2);
361: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag='''||'0'||''' AND '||
362: '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))',
363: 'language','intl_text_id',TRUE);
364: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LOCALIZED_TEXTS (deleted model_id): 6','CZ_LOCALIZED_TEXTS',0,2);
365:
366: delete_Orphaned_Nodes;

Line 390: (SELECT NULL FROM CZ_DEVL_PROJECTS b

386: -- ( such nodes will be deleted )
387: CURSOR del_nodes_cur IS
388: SELECT a.ps_node_id
389: FROM CZ_PS_NODES a WHERE a.reference_id IS NOT NULL AND NOT EXISTS
390: (SELECT NULL FROM CZ_DEVL_PROJECTS b
391: WHERE b.devl_project_id=a.reference_id AND b.deleted_flag='0');
392:
393: t_ps_node_id number_tbl_type;
394: