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_LCE_TEXTS

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 221: TYPE text_field_Table IS TABLE OF cz_lce_texts.lce_text%TYPE INDEX BY BINARY_INTEGER;

217: name cz_lce_operands.name%TYPE
218: );
219:
220: TYPE operandsTable IS TABLE OF t_operandsRecord INDEX BY BINARY_INTEGER;
221: TYPE text_field_Table IS TABLE OF cz_lce_texts.lce_text%TYPE INDEX BY BINARY_INTEGER;
222: v_operandsTable operandsTable;
223: v_text_field_Table text_field_Table;
224: text_field_counter NUMBER:=0;
225:

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 747: DELETE FROM cz_lce_texts where lce_header_id = p_lce_header_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
751: SELECT NVL(MAX(seq_nbr),0)

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 753: FROM cz_lce_texts

749:
750: BEGIN
751: SELECT NVL(MAX(seq_nbr),0)
752: INTO v_seq_no
753: FROM cz_lce_texts
754: WHERE lce_header_id = p_lce_header_id ;
755:
756: EXCEPTION
757: WHEN OTHERS THEN

Line 766: INSERT INTO cz_lce_texts(LCE_HEADER_ID,SEQ_NBR,LCE_TEXT)

762: FOR i IN 1..text_field_counter LOOP
763: v_buffer_length := NVL(LENGTH(v_buffer),0);
764: IF ((v_buffer_length + NVL(LENGTH(v_text_field_Table(i)),0)) > 2000) THEN
765: v_seq_no := v_seq_no +1;
766: INSERT INTO cz_lce_texts(LCE_HEADER_ID,SEQ_NBR,LCE_TEXT)
767: values(p_lce_header_id, v_seq_no, v_buffer);
768: v_buffer := v_text_field_Table(i);
769:
770: IF BATCH_Counter>=BATCH_size THEN

Line 783: INSERT INTO cz_lce_texts(LCE_HEADER_ID,SEQ_NBR,LCE_TEXT)

779: END IF;
780: END LOOP;
781:
782: v_seq_no := v_seq_no +1;
783: INSERT INTO cz_lce_texts(LCE_HEADER_ID,SEQ_NBR,LCE_TEXT)
784: values(p_lce_header_id, v_seq_no, v_buffer);
785: COMMIT;
786: CLOSE lines_cursor ;
787: EXCEPTION