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_LC_MGR dependencies on CZ_BASE_MGR

Line 29: cz_base_mgr.REDO_STATISTICS('LC');

25: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
26:
27: PROCEDURE redo_statistics IS
28: BEGIN
29: cz_base_mgr.REDO_STATISTICS('LC');
30: END;
31:
32: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
33: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 38: cz_base_mgr.TRIGGERS_ENABLED('LC',Switch);

34:
35: PROCEDURE triggers_enabled
36: (Switch IN VARCHAR2) IS
37: BEGIN
38: cz_base_mgr.TRIGGERS_ENABLED('LC',Switch);
39: END;
40:
41: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
42: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 47: cz_base_mgr.CONSTRAINTS_ENABLED('LC',Switch);

43:
44: PROCEDURE constraints_enabled
45: (Switch IN VARCHAR2) IS
46: BEGIN
47: cz_base_mgr.CONSTRAINTS_ENABLED('LC',Switch);
48: END;
49:
50: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
51: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 57: cz_base_mgr.REDO_SEQUENCES('LC',RedoStart_Flag,incr);

53: PROCEDURE redo_sequences
54: (RedoStart_Flag IN VARCHAR2,
55: incr IN INTEGER DEFAULT NULL) IS
56: BEGIN
57: cz_base_mgr.REDO_SEQUENCES('LC',RedoStart_Flag,incr);
58: END;
59:
60: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
61: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

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 69: CZ_BASE_MGR.exec('CZ_LCE_LOAD_SPECS','where deleted_flag='''||'0'||''' AND '||

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

Line 73: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LCE_TEXTS : 2','CZ_LCE_TEXTS',0,2);

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

Line 74: CZ_BASE_MGR.exec('CZ_LCE_TEXTS','where '||

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 '||
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;

Line 77: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LCE_TEXTS : 2','CZ_LCE_TEXTS',0,2);

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:
80: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
81: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 86: cz_base_mgr.PURGE('LC');

82:
83: PROCEDURE purge IS
84: BEGIN
85: Propogate_DeletedFlag;
86: cz_base_mgr.PURGE('LC');
87: END;
88:
89: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
90: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 103: cz_base_mgr.MODIFIED('LC',AS_OF);

99:
100: PROCEDURE modified
101: (AS_OF IN OUT NOCOPY DATE) IS
102: BEGIN
103: cz_base_mgr.MODIFIED('LC',AS_OF);
104: END;
105:
106: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
107: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 746: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LCE_TEXTS : 3','CZ_LCE_TEXTS',0,2);

742: v_text_field_Table(text_field_counter):='REM -- End Component: '||to_char(v_header_cursor.component_id);
743: text_field_counter := text_field_counter + 1;
744: v_text_field_Table(text_field_counter):= ENDOFLINE1;
745:
746: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LCE_TEXTS : 3','CZ_LCE_TEXTS',0,2);
747: DELETE FROM cz_lce_texts where lce_header_id = p_lce_header_id;
748: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LCE_TEXTS : 3(lce_hdr based)','CZ_LCE_TEXTS',SQL%ROWCOUNT,2);
749:
750: BEGIN

Line 748: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LCE_TEXTS : 3(lce_hdr based)','CZ_LCE_TEXTS',SQL%ROWCOUNT,2);

744: v_text_field_Table(text_field_counter):= ENDOFLINE1;
745:
746: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','Before physical delete of CZ_LCE_TEXTS : 3','CZ_LCE_TEXTS',0,2);
747: DELETE FROM cz_lce_texts where lce_header_id = p_lce_header_id;
748: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG','After physical delete of CZ_LCE_TEXTS : 3(lce_hdr based)','CZ_LCE_TEXTS',SQL%ROWCOUNT,2);
749:
750: BEGIN
751: SELECT NVL(MAX(seq_nbr),0)
752: INTO v_seq_no

Line 789: cz_base_mgr.LOG_REPORT('CZ_LC_MGR.cz_generate_lce_varchar','ERROR : '||SQLERRM);

785: COMMIT;
786: CLOSE lines_cursor ;
787: EXCEPTION
788: WHEN OTHERS THEN
789: cz_base_mgr.LOG_REPORT('CZ_LC_MGR.cz_generate_lce_varchar','ERROR : '||SQLERRM);
790:
791: END;
792:
793: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>