APPS.CZ_LC_MGR dependencies on CZ_LCE_HEADERS

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

61: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
62:
63: PROCEDURE Propogate_DeletedFlag IS
64: BEGIN
65: CZ_BASE_MGR.exec('CZ_LCE_HEADERS','where deleted_flag='''||'0'||''' AND '||
66: 'component_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
67: 'lce_header_id',FALSE);
68:
69: CZ_BASE_MGR.exec('CZ_LCE_LOAD_SPECS','where deleted_flag='''||'0'||''' AND '||

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

66: 'component_id in(select ps_node_id from CZ_PS_NODES where deleted_flag='''||'1'||''')',
67: 'lce_header_id',FALSE);
68:
69: CZ_BASE_MGR.exec('CZ_LCE_LOAD_SPECS','where deleted_flag='''||'0'||''' AND '||
70: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',
71: 'lce_header_id','attachment_expl_id','required_expl_id',FALSE);
72:
73: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LCE_TEXTS : 2','CZ_LCE_TEXTS',0,2);
74: CZ_BASE_MGR.exec('CZ_LCE_TEXTS','where '||

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

71: 'lce_header_id','attachment_expl_id','required_expl_id',FALSE);
72:
73: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LCE_TEXTS : 2','CZ_LCE_TEXTS',0,2);
74: CZ_BASE_MGR.exec('CZ_LCE_TEXTS','where '||
75: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',
76: 'lce_header_id','seq_nbr',TRUE);
77: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LCE_TEXTS : 2','CZ_LCE_TEXTS',0,2);
78: END;
79:

Line 160: FROM cz_lce_headers

156: SELECT lce_header_id,
157: desc_text,
158: component_id,
159: gen_version
160: FROM cz_lce_headers
161: WHERE Lce_header_id = p_lce_header_id;
162:
163: CURSOR lines_cursor(p_lce_header_id NUMBER) IS
164: SELECT lce_line_id,