APPS.CZ_PS_MGR dependencies on CZ_LCE_HEADERS

Line 105: UPDATE CZ_LCE_HEADERS SET deleted_flag='1'

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);
102: END IF;
103: IF t_ps_node_id.Count>0 THEN
104: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
105: UPDATE CZ_LCE_HEADERS SET deleted_flag='1'
106: WHERE component_id=t_ps_node_id(i);
107: COMMIT;
108: END IF;
109: END LOOP;

Line 293: CZ_BASE_MGR.exec('CZ_LCE_HEADERS','where deleted_flag='''||'0'||''' AND '||

289: CZ_BASE_MGR.exec('CZ_EXPRESSION_NODES','where deleted_flag='''||'0'||''' AND seeded_flag<>'''||'1'||''' AND '||
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 '||

Line 298: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',

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'||''')',
299: 'lce_header_id','attachment_expl_id','required_expl_id',TRUE);
300:
301: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LCE_TEXTS : 1','CZ_LCE_TEXTS',0,2);
302: CZ_BASE_MGR.exec('CZ_LCE_TEXTS','where '||

Line 303: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',

299: 'lce_header_id','attachment_expl_id','required_expl_id',TRUE);
300:
301: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LCE_TEXTS : 1','CZ_LCE_TEXTS',0,2);
302: CZ_BASE_MGR.exec('CZ_LCE_TEXTS','where '||
303: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',
304: 'lce_header_id','seq_nbr',TRUE);
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);