APPS.CZ_PS_MGR dependencies on CZ_LCE_HEADERS

Line 99: UPDATE CZ_LCE_HEADERS SET deleted_flag='1'

95: COMMIT;
96: END IF;
97: IF t_ps_node_id.Count>0 THEN
98: FORALL i IN t_ps_node_id.First..t_ps_node_id.Last
99: UPDATE CZ_LCE_HEADERS SET deleted_flag='1'
100: WHERE component_id=t_ps_node_id(i);
101: COMMIT;
102: END IF;
103: END LOOP;

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

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

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

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'||''')',
247: 'lce_header_id','attachment_expl_id','required_expl_id',TRUE);
248:
249: CZ_BASE_MGR.exec('CZ_LCE_TEXTS','where '||
250: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',

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

246: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',
247: 'lce_header_id','attachment_expl_id','required_expl_id',TRUE);
248:
249: CZ_BASE_MGR.exec('CZ_LCE_TEXTS','where '||
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'''||