890: opr_step_qty number_idx_tbl;
891:
892: opr_step_qty_uom uom_code_tbl;
893:
894: TYPE operation_description IS TABLE OF msc_st_routing_operations.operation_description%TYPE
895: INDEX BY BINARY_INTEGER;
896: opr_operation_description operation_description ;
897: empty_opr_description operation_description ;
898: TYPE department_code IS TABLE OF msc_st_routing_operations.department_code%TYPE
894: TYPE operation_description IS TABLE OF msc_st_routing_operations.operation_description%TYPE
895: INDEX BY BINARY_INTEGER;
896: opr_operation_description operation_description ;
897: empty_opr_description operation_description ;
898: TYPE department_code IS TABLE OF msc_st_routing_operations.department_code%TYPE
899: INDEX BY BINARY_INTEGER;
900: opr_department_code department_code ;
901: empty_opr_department_code department_code ;
902:
7129: stmt_no := 906 ;
7130: i := 1 ;
7131: IF opr_operation_sequence_id.FIRST > 0 THEN
7132: FORALL i IN opr_operation_sequence_id.FIRST..opr_operation_sequence_id.LAST
7133: INSERT INTO msc_st_routing_operations (
7134: operation_sequence_id,
7135: routing_sequence_id,
7136: operation_seq_num,
7137: sr_instance_id,