[Home] [Help]
176: SELECT lce_line_id,
177: operand_seq,
178: operand_type,
179: name
180: FROM cz_lce_operands
181: WHERE lce_header_id = p_lce_header_id
182: ORDER BY lce_line_id, operand_seq;
183:
184: v_header_cursor header_cursor%ROWTYPE;
183:
184: v_header_cursor header_cursor%ROWTYPE;
185: v_lines_cursor lines_cursor%ROWTYPE;
186: v_operands_cursor operands_cursor%ROWTYPE;
187: v_op_type cz_lce_operands.operand_type%TYPE;
188: v_name VARCHAR2(255);
189: v_generic_type CHAR(1);
190: v_line_type CHAR(1);
191: v_op1 VARCHAR2(255);
208: v_prop VARCHAR2(255);
209: v_withcell_value VARCHAR2(255);
210:
211: TYPE t_operandsRecord IS RECORD (
212: lce_line_id cz_lce_operands.lce_line_id%TYPE,
213: operand_seq cz_lce_operands.operand_seq%TYPE,
214: operand_type cz_lce_operands.operand_type%TYPE,
215: name cz_lce_operands.name%TYPE
216: );
209: v_withcell_value VARCHAR2(255);
210:
211: TYPE t_operandsRecord IS RECORD (
212: lce_line_id cz_lce_operands.lce_line_id%TYPE,
213: operand_seq cz_lce_operands.operand_seq%TYPE,
214: operand_type cz_lce_operands.operand_type%TYPE,
215: name cz_lce_operands.name%TYPE
216: );
217:
210:
211: TYPE t_operandsRecord IS RECORD (
212: lce_line_id cz_lce_operands.lce_line_id%TYPE,
213: operand_seq cz_lce_operands.operand_seq%TYPE,
214: operand_type cz_lce_operands.operand_type%TYPE,
215: name cz_lce_operands.name%TYPE
216: );
217:
218: TYPE operandsTable IS TABLE OF t_operandsRecord INDEX BY BINARY_INTEGER;
211: TYPE t_operandsRecord IS RECORD (
212: lce_line_id cz_lce_operands.lce_line_id%TYPE,
213: operand_seq cz_lce_operands.operand_seq%TYPE,
214: operand_type cz_lce_operands.operand_type%TYPE,
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;