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_PS_NODES

Line 66: FROM CZ_PS_NODES a WHERE NOT EXISTS

62: BEGIN
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

Line 73: FROM CZ_PS_NODES a WHERE NOT EXISTS

69:
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;

Line 83: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before logical delete of CZ_PS_NODES : 2','CZ_PS_NODES',0,1);

79: t_ps_node_id.delete; t_intl_text_id.delete;
80: FETCH C1 BULK COLLECT INTO t_ps_node_id,t_intl_text_id LIMIT CZ_BASE_MGR.BATCH_SIZE;
81: EXIT WHEN C1%NOTFOUND AND t_ps_node_id.COUNT = 0;
82:
83: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before logical delete of CZ_PS_NODES : 2','CZ_PS_NODES',0,1);
84: IF t_ps_node_id.Count>0 THEN
85: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
86: UPDATE CZ_PS_NODES SET deleted_flag='1'
87: WHERE ps_node_id=t_ps_node_id(i);

Line 86: UPDATE CZ_PS_NODES SET deleted_flag='1'

82:
83: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before logical delete of CZ_PS_NODES : 2','CZ_PS_NODES',0,1);
84: IF t_ps_node_id.Count>0 THEN
85: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
86: UPDATE CZ_PS_NODES SET deleted_flag='1'
87: WHERE ps_node_id=t_ps_node_id(i);
88: COMMIT;
89: END IF;
90:

Line 91: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After logical delete of CZ_PS_NODES : 2','CZ_PS_NODES',t_ps_node_id.COUNT,1);

87: WHERE ps_node_id=t_ps_node_id(i);
88: COMMIT;
89: END IF;
90:
91: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After logical delete of CZ_PS_NODES : 2','CZ_PS_NODES',t_ps_node_id.COUNT,1);
92: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LOCALIZED_TEXTS : 2','CZ_LOCALIZED_TEXTS',0,2);
93: IF t_intl_text_id.Count>0 THEN
94: FORALL i IN t_intl_text_id.First..t_intl_text_id.Last
95: DELETE FROM CZ_LOCALIZED_TEXTS a

Line 97: AND not exists (SELECT null FROM CZ_PS_NODES b

93: IF t_intl_text_id.Count>0 THEN
94: FORALL i IN t_intl_text_id.First..t_intl_text_id.Last
95: DELETE FROM CZ_LOCALIZED_TEXTS a
96: WHERE a.intl_text_id=t_intl_text_id(i) AND a.seeded_flag<>'1'
97: AND not exists (SELECT null FROM CZ_PS_NODES b
98: WHERE b.deleted_flag='0'
99: and b.intl_text_id = a.intl_text_id);
100: COMMIT;
101: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LOCALIZED_TEXTS : 2','CZ_LOCALIZED_TEXTS',t_intl_text_id.COUNT,2);

Line 164: CZ_BASE_MGR.exec('CZ_PS_NODES','WHERE NOT EXISTS '||

160: CZ_BASE_MGR.LOG_REPORT('CZ_PS_MGR.delete_Orphaned_Nodes',SQLERRM );
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

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 174: -- '(SELECT null FROM CZ_PS_NODES WHERE ps_node_id=cz_ps_prop_vals.ps_node_id)',

170: --This is safe to remove as the clean up is done and there will not be any orphan cz_ps_prop_vals
171: -- CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before Physical delete of CZ_PS_PROP_VALS (Orphan):','CZ_PS_PROP_VALS',0,2);
172:
173: -- CZ_BASE_MGR.exec('CZ_PS_PROP_VALS','WHERE NOT EXISTS '||
174: -- '(SELECT null FROM CZ_PS_NODES WHERE ps_node_id=cz_ps_prop_vals.ps_node_id)',
175: -- 'ps_node_id', TRUE);
176:
177: -- CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After Physical delete of CZ_PS_PROP_VALS (Orphan):','CZ_PS_PROP_VALS',0,2);
178:

Line 207: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before logical delete of CZ_PS_NODES : 1','CZ_PS_NODES',0,1);

203:
204: PROCEDURE update_deleted_flag(p_ps_node_id IN NUMBER) IS
205: updCount NUMBER:=0;
206: BEGIN
207: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before logical delete of CZ_PS_NODES : 1','CZ_PS_NODES',0,1);
208: FOR child IN (SELECT ps_node_id FROM cz_ps_nodes WHERE parent_id = p_ps_node_id
209: AND deleted_flag = '0') LOOP
210:
211: UPDATE cz_ps_nodes SET deleted_flag = '1' WHERE ps_node_id = child.ps_node_id;

Line 208: FOR child IN (SELECT ps_node_id FROM cz_ps_nodes WHERE parent_id = p_ps_node_id

204: PROCEDURE update_deleted_flag(p_ps_node_id IN NUMBER) IS
205: updCount NUMBER:=0;
206: BEGIN
207: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before logical delete of CZ_PS_NODES : 1','CZ_PS_NODES',0,1);
208: FOR child IN (SELECT ps_node_id FROM cz_ps_nodes WHERE parent_id = p_ps_node_id
209: AND deleted_flag = '0') LOOP
210:
211: UPDATE cz_ps_nodes SET deleted_flag = '1' WHERE ps_node_id = child.ps_node_id;
212: updCount := updCount + SQL%ROWCOUNT;

Line 211: UPDATE cz_ps_nodes SET deleted_flag = '1' WHERE ps_node_id = child.ps_node_id;

207: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before logical delete of CZ_PS_NODES : 1','CZ_PS_NODES',0,1);
208: FOR child IN (SELECT ps_node_id FROM cz_ps_nodes WHERE parent_id = p_ps_node_id
209: AND deleted_flag = '0') LOOP
210:
211: UPDATE cz_ps_nodes SET deleted_flag = '1' WHERE ps_node_id = child.ps_node_id;
212: updCount := updCount + SQL%ROWCOUNT;
213: update_deleted_flag(child.ps_node_id);
214: END LOOP;
215: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After logical delete of CZ_PS_NODES : 1','CZ_PS_NODES',updCount, 1);

Line 215: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After logical delete of CZ_PS_NODES : 1','CZ_PS_NODES',updCount, 1);

211: UPDATE cz_ps_nodes SET deleted_flag = '1' WHERE ps_node_id = child.ps_node_id;
212: updCount := updCount + SQL%ROWCOUNT;
213: update_deleted_flag(child.ps_node_id);
214: END LOOP;
215: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After logical delete of CZ_PS_NODES : 1','CZ_PS_NODES',updCount, 1);
216: updCount := 0;
217: END update_deleted_flag;
218:
219: procedure Propogate_DeletedFlag is

Line 233: CZ_BASE_MGR.exec('CZ_PS_NODES','where deleted_flag='''||'0'||''' AND '||

229: -- Just for Sun, a temporary change. We must have done this by a parallel script.
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?

Line 239: for n in(select ps_node_id from cz_ps_nodes where deleted_flag='1')

235: 'ps_node_id',FALSE);
236:
237: -- necessary?
238: /*
239: for n in(select ps_node_id from cz_ps_nodes where deleted_flag='1')
240: loop
241: update cz_ps_nodes
242: set deleted_flag='1' where deleted_flag='0' and ps_node_id in
243: (select ps_node_id from cz_ps_nodes

Line 241: update cz_ps_nodes

237: -- necessary?
238: /*
239: for n in(select ps_node_id from cz_ps_nodes where deleted_flag='1')
240: loop
241: update cz_ps_nodes
242: set deleted_flag='1' where deleted_flag='0' and ps_node_id in
243: (select ps_node_id from cz_ps_nodes
244: start with ps_node_id=n.ps_node_id
245: connect by prior ps_node_id=parent_id);

Line 243: (select ps_node_id from cz_ps_nodes

239: for n in(select ps_node_id from cz_ps_nodes where deleted_flag='1')
240: loop
241: update cz_ps_nodes
242: set deleted_flag='1' where deleted_flag='0' and ps_node_id in
243: (select ps_node_id from cz_ps_nodes
244: start with ps_node_id=n.ps_node_id
245: connect by prior ps_node_id=parent_id);
246: commit;
247: end loop;

Line 272: 'owned_by_node_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',

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);
276: CZ_BASE_MGR.exec('CZ_PS_PROP_VALS','where deleted_flag='''||'0'||''' AND '||

Line 277: 'ps_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);
276: CZ_BASE_MGR.exec('CZ_PS_PROP_VALS','where deleted_flag='''||'0'||''' AND '||
277: 'ps_node_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
278: 'property_id','ps_node_id',TRUE);
279: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_PS_PROP_VALS : 1','CZ_PS_PROP_VALS',0,2);
280:
281: CZ_BASE_MGR.exec('CZ_SUB_CON_SETS','where deleted_flag='''||'0'||''' AND '||

Line 282: 'sub_cons_id in(select sub_cons_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',

278: 'property_id','ps_node_id',TRUE);
279: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_PS_PROP_VALS : 1','CZ_PS_PROP_VALS',0,2);
280:
281: CZ_BASE_MGR.exec('CZ_SUB_CON_SETS','where deleted_flag='''||'0'||''' AND '||
282: 'sub_cons_id in(select sub_cons_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
283: 'sub_cons_id',FALSE);
284:
285: CZ_BASE_MGR.exec('CZ_FILTER_SETS','where deleted_flag='''||'0'||''' AND '||
286: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',

Line 294: 'component_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',

290: 'rule_id in(select rule_id from CZ_RULES where deleted_flag='''||'1'||''')',
291: 'expr_node_id',TRUE);
292:
293: CZ_BASE_MGR.exec('CZ_LCE_HEADERS','where deleted_flag='''||'0'||''' AND '||
294: 'component_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
295: 'lce_header_id',FALSE);
296:
297: CZ_BASE_MGR.exec('CZ_LCE_LOAD_SPECS','where deleted_flag='''||'0'||''' AND '||
298: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',

Line 309: ' EXISTS(select NULL from CZ_PS_NODES where intl_text_id=cz_localized_texts.intl_text_id and deleted_flag=''1'''||

305: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LCE_TEXTS : 1','CZ_LCE_TEXTS',0,2);
306:
307: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LOCALIZED_TEXTS (ps_nodes.intl_text_id): 1','CZ_LOCALIZED_TEXTS',0,2);
308: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag=''0'' AND seeded_flag<>'''||'1'||''' AND '||
309: ' EXISTS(select NULL from CZ_PS_NODES where intl_text_id=cz_localized_texts.intl_text_id and deleted_flag=''1'''||
310: ') and not exists(select null from CZ_PS_NODES where intl_text_id=cz_localized_texts.intl_text_id and '||
311: ' deleted_flag=''0'')',
312: 'language','intl_text_id',TRUE);
313: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LOCALIZED_TEXTS (ps_nodes.intl_text_id): 1','CZ_LOCALIZED_TEXTS',0,2);

Line 310: ') and not exists(select null from CZ_PS_NODES where intl_text_id=cz_localized_texts.intl_text_id and '||

306:
307: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LOCALIZED_TEXTS (ps_nodes.intl_text_id): 1','CZ_LOCALIZED_TEXTS',0,2);
308: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag=''0'' AND seeded_flag<>'''||'1'||''' AND '||
309: ' EXISTS(select NULL from CZ_PS_NODES where intl_text_id=cz_localized_texts.intl_text_id and deleted_flag=''1'''||
310: ') and not exists(select null from CZ_PS_NODES where intl_text_id=cz_localized_texts.intl_text_id and '||
311: ' deleted_flag=''0'')',
312: 'language','intl_text_id',TRUE);
313: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LOCALIZED_TEXTS (ps_nodes.intl_text_id): 1','CZ_LOCALIZED_TEXTS',0,2);
314:

Line 350: 'exists (select violation_text_id from CZ_PS_NODES where violation_text_id = cz_localized_texts.intl_text_id and deleted_flag='''||'1'||''')',

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);
349: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag='''||'0'||''' AND '||
350: 'exists (select violation_text_id from CZ_PS_NODES where violation_text_id = cz_localized_texts.intl_text_id and deleted_flag='''||'1'||''')',
351: 'language','intl_text_id',TRUE);
352: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LOCALIZED_TEXTS (ps_nodes.violation_text): 4','CZ_LOCALIZED_TEXTS',0,2);
353:
354: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LOCALIZED_TEXTS (cz_rules.unsatisfied_msg): 5','CZ_LOCALIZED_TEXTS',0,2);

Line 389: FROM CZ_PS_NODES a WHERE a.reference_id IS NOT NULL AND NOT EXISTS

385: -- this cursor returns model nodes which refer to a model that does not exist.
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;

Line 421: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_PS_NODES : 1','CZ_PS_NODES',0,2);

417: CZ_BASE_MGR.PURGE('PS');
418:
419: OPEN del_nodes_cur;
420:
421: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_PS_NODES : 1','CZ_PS_NODES',0,2);
422: LOOP
423: FETCH del_nodes_cur BULK COLLECT INTO t_ps_node_id
424: LIMIT 10000;
425: EXIT WHEN del_nodes_cur%NOTFOUND AND t_ps_node_id.COUNT = 0;

Line 429: DELETE FROM CZ_PS_NODES

425: EXIT WHEN del_nodes_cur%NOTFOUND AND t_ps_node_id.COUNT = 0;
426:
427: IF t_ps_node_id.Count>0 THEN
428: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
429: DELETE FROM CZ_PS_NODES
430: WHERE ps_node_id=t_ps_node_id(i);
431: COMMIT;
432: END IF;
433: END LOOP;

Line 435: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_PS_NODES : 1','CZ_PS_NODES',t_ps_node_id.COUNT,2);

431: COMMIT;
432: END IF;
433: END LOOP;
434:
435: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_PS_NODES : 1','CZ_PS_NODES',t_ps_node_id.COUNT,2);
436:
437: CLOSE del_nodes_cur;
438:
439: exception