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);
76: BEGIN
77: OPEN C1;

Line 84: UPDATE CZ_PS_NODES SET deleted_flag='1'

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: IF t_ps_node_id.Count>0 THEN
83: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
84: UPDATE CZ_PS_NODES SET deleted_flag='1'
85: WHERE ps_node_id=t_ps_node_id(i);
86: COMMIT;
87: END IF;
88: IF t_intl_text_id.Count>0 THEN

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

88: IF t_intl_text_id.Count>0 THEN
89: FORALL i IN t_intl_text_id.First..t_intl_text_id.Last
90: DELETE FROM CZ_LOCALIZED_TEXTS a
91: WHERE a.intl_text_id=t_intl_text_id(i) AND a.seeded_flag<>'1'
92: AND not exists (SELECT null FROM CZ_PS_NODES b
93: WHERE b.deleted_flag='0'
94: and b.intl_text_id = a.intl_text_id);
95: COMMIT;
96: END IF;

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

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

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 167: FOR child IN (SELECT ps_node_id FROM cz_ps_nodes WHERE parent_id = p_ps_node_id

163: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
164:
165: PROCEDURE update_deleted_flag(p_ps_node_id IN NUMBER) IS
166: BEGIN
167: FOR child IN (SELECT ps_node_id FROM cz_ps_nodes WHERE parent_id = p_ps_node_id
168: AND deleted_flag = '0') LOOP
169:
170: UPDATE cz_ps_nodes SET deleted_flag = '1' WHERE ps_node_id = child.ps_node_id;
171: update_deleted_flag(child.ps_node_id);

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

166: BEGIN
167: FOR child IN (SELECT ps_node_id FROM cz_ps_nodes WHERE parent_id = p_ps_node_id
168: AND deleted_flag = '0') LOOP
169:
170: UPDATE cz_ps_nodes SET deleted_flag = '1' WHERE ps_node_id = child.ps_node_id;
171: update_deleted_flag(child.ps_node_id);
172: END LOOP;
173: END update_deleted_flag;
174:

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

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'||''')',
185: 'ps_node_id',FALSE);
186:
187: -- necessary?

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

185: 'ps_node_id',FALSE);
186:
187: -- necessary?
188: /*
189: for n in(select ps_node_id from cz_ps_nodes where deleted_flag='1')
190: loop
191: update cz_ps_nodes
192: set deleted_flag='1' where deleted_flag='0' and ps_node_id in
193: (select ps_node_id from cz_ps_nodes

Line 191: update cz_ps_nodes

187: -- necessary?
188: /*
189: for n in(select ps_node_id from cz_ps_nodes where deleted_flag='1')
190: loop
191: update cz_ps_nodes
192: set deleted_flag='1' where deleted_flag='0' and ps_node_id in
193: (select ps_node_id from cz_ps_nodes
194: start with ps_node_id=n.ps_node_id
195: connect by prior ps_node_id=parent_id);

Line 193: (select ps_node_id from cz_ps_nodes

189: for n in(select ps_node_id from cz_ps_nodes where deleted_flag='1')
190: loop
191: update cz_ps_nodes
192: set deleted_flag='1' where deleted_flag='0' and ps_node_id in
193: (select ps_node_id from cz_ps_nodes
194: start with ps_node_id=n.ps_node_id
195: connect by prior ps_node_id=parent_id);
196: commit;
197: end loop;

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

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'||''')',
223: 'populator_id',FALSE);
224:
225: CZ_BASE_MGR.exec('CZ_PS_PROP_VALS','where deleted_flag='''||'0'||''' AND '||
226: 'ps_node_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',

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

222: 'owned_by_node_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
223: 'populator_id',FALSE);
224:
225: CZ_BASE_MGR.exec('CZ_PS_PROP_VALS','where deleted_flag='''||'0'||''' AND '||
226: 'ps_node_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
227: 'property_id','ps_node_id',TRUE);
228:
229: CZ_BASE_MGR.exec('CZ_SUB_CON_SETS','where deleted_flag='''||'0'||''' AND '||
230: 'sub_cons_id in(select sub_cons_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',

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

226: 'ps_node_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
227: 'property_id','ps_node_id',TRUE);
228:
229: CZ_BASE_MGR.exec('CZ_SUB_CON_SETS','where deleted_flag='''||'0'||''' AND '||
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'||''')',

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

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'||''')',
243: 'lce_header_id',FALSE);
244:
245: CZ_BASE_MGR.exec('CZ_LCE_LOAD_SPECS','where deleted_flag='''||'0'||''' AND '||
246: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',

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

250: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',
251: 'lce_header_id','seq_nbr',TRUE);
252:
253: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag=''0'' AND seeded_flag<>'''||'1'||''' AND '||
254: ' EXISTS(select NULL from CZ_PS_NODES where intl_text_id=cz_localized_texts.intl_text_id and deleted_flag=''1'''||
255: ') and not exists(select null from CZ_PS_NODES where intl_text_id=cz_localized_texts.intl_text_id and '||
256: ' deleted_flag=''0'')',
257: 'language','intl_text_id',TRUE);
258:

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

251: 'lce_header_id','seq_nbr',TRUE);
252:
253: CZ_BASE_MGR.exec('CZ_LOCALIZED_TEXTS','where deleted_flag=''0'' AND seeded_flag<>'''||'1'||''' AND '||
254: ' EXISTS(select NULL from CZ_PS_NODES where intl_text_id=cz_localized_texts.intl_text_id and deleted_flag=''1'''||
255: ') and not exists(select null from CZ_PS_NODES where intl_text_id=cz_localized_texts.intl_text_id 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 '||

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

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

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

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

Line 362: DELETE FROM CZ_PS_NODES

358: EXIT WHEN del_nodes_cur%NOTFOUND AND t_ps_node_id.COUNT = 0;
359:
360: IF t_ps_node_id.Count>0 THEN
361: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
362: DELETE FROM CZ_PS_NODES
363: WHERE ps_node_id=t_ps_node_id(i);
364: COMMIT;
365: END IF;
366: END LOOP;