APPS.CZ_LC_MGR dependencies on CZ_LCE_TEXTS

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

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.exec('CZ_LCE_TEXTS','where '||
74: 'lce_header_id in(select lce_header_id from CZ_LCE_HEADERS where deleted_flag='''||'1'||''')',
75: 'lce_header_id','seq_nbr',TRUE);
76: END;
77:

Line 219: TYPE text_field_Table IS TABLE OF cz_lce_texts.lce_text%TYPE INDEX BY BINARY_INTEGER;

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

Line 744: DELETE FROM cz_lce_texts where lce_header_id = p_lce_header_id;

740: v_text_field_Table(text_field_counter):='REM -- End Component: '||to_char(v_header_cursor.component_id);
741: text_field_counter := text_field_counter + 1;
742: v_text_field_Table(text_field_counter):= ENDOFLINE1;
743:
744: DELETE FROM cz_lce_texts where lce_header_id = p_lce_header_id;
745: BEGIN
746: SELECT NVL(MAX(seq_nbr),0)
747: INTO v_seq_no
748: FROM cz_lce_texts

Line 748: FROM cz_lce_texts

744: DELETE FROM cz_lce_texts where lce_header_id = p_lce_header_id;
745: BEGIN
746: SELECT NVL(MAX(seq_nbr),0)
747: INTO v_seq_no
748: FROM cz_lce_texts
749: WHERE lce_header_id = p_lce_header_id ;
750:
751: EXCEPTION
752: WHEN OTHERS THEN

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

757: FOR i IN 1..text_field_counter LOOP
758: v_buffer_length := NVL(LENGTH(v_buffer),0);
759: IF ((v_buffer_length + NVL(LENGTH(v_text_field_Table(i)),0)) > 2000) THEN
760: v_seq_no := v_seq_no +1;
761: INSERT INTO cz_lce_texts(LCE_HEADER_ID,SEQ_NBR,LCE_TEXT)
762: values(p_lce_header_id, v_seq_no, v_buffer);
763: v_buffer := v_text_field_Table(i);
764:
765: IF BATCH_Counter>=BATCH_size THEN

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

774: END IF;
775: END LOOP;
776:
777: v_seq_no := v_seq_no +1;
778: INSERT INTO cz_lce_texts(LCE_HEADER_ID,SEQ_NBR,LCE_TEXT)
779: values(p_lce_header_id, v_seq_no, v_buffer);
780: COMMIT;
781: CLOSE lines_cursor ;
782: EXCEPTION