[Home] [Help]
20:
21: 1. The repair record is updated with quantity_received = 1 and
22: a history is written with a status of SPLIT.
23: 2. LOOP from 1 to (x_total_quantity - 1)
24: Get the next repair_line_id from cs_repairs_s
25: Insert into cs_repairs (quantity_received=1) by setting all
26: other columns the same as in the original repair line
27: Insert repair history records.
28:
28:
29: If we have to split into 2 lines with user_defined quantities
30: 1. The original repair record is updated with quantity_received =
31: x_first_quantity and history is written indicating the split.
32: 2. Get the next repair_line_id from cs_repairs_s
33: 3. Insert into cs_repairs (quantity_received = x_total_quantity -
34: x_first_quantity)
35: 4. Insert history records.
36: */
124: /* original repair line. */
125:
126: FOR split_lines in 1..(X_total_quantity - 1) LOOP
127:
128: SELECT cs_repairs_s.nextval
129: INTO new_line_id
130: FROM dual;
131:
132: SELECT to_number(cs_repair_number_s.nextval)
418: /* Insert a repair line with the total_quantity - first_quantity */
419:
420: /* dbms_output.put_line('New repair record'); */
421:
422: SELECT cs_repairs_s.nextval
423: INTO new_line_id
424: FROM dual;
425:
426: SELECT to_number(cs_repair_number_s.nextval)