11: -- accordingly.
12: -- record_changed_flag_tab tells us whether the respective delivery detail needs to be updated or
13: -- or not.
14: TYPE update_detail_rec_type is RECORD (
15: del_det_id_tab wsh_util_core.id_tab_type,
16: requested_qty_tab wsh_util_core.id_tab_type,
17: requested_qty2_tab wsh_util_core.id_tab_type,
18: shipped_qty_tab wsh_util_core.id_tab_type,
19: shipped_qty2_tab wsh_util_core.id_tab_type,
12: -- record_changed_flag_tab tells us whether the respective delivery detail needs to be updated or
13: -- or not.
14: TYPE update_detail_rec_type is RECORD (
15: del_det_id_tab wsh_util_core.id_tab_type,
16: requested_qty_tab wsh_util_core.id_tab_type,
17: requested_qty2_tab wsh_util_core.id_tab_type,
18: shipped_qty_tab wsh_util_core.id_tab_type,
19: shipped_qty2_tab wsh_util_core.id_tab_type,
20: received_qty_tab wsh_util_core.id_tab_type,
13: -- or not.
14: TYPE update_detail_rec_type is RECORD (
15: del_det_id_tab wsh_util_core.id_tab_type,
16: requested_qty_tab wsh_util_core.id_tab_type,
17: requested_qty2_tab wsh_util_core.id_tab_type,
18: shipped_qty_tab wsh_util_core.id_tab_type,
19: shipped_qty2_tab wsh_util_core.id_tab_type,
20: received_qty_tab wsh_util_core.id_tab_type,
21: received_qty2_tab wsh_util_core.id_tab_type,
14: TYPE update_detail_rec_type is RECORD (
15: del_det_id_tab wsh_util_core.id_tab_type,
16: requested_qty_tab wsh_util_core.id_tab_type,
17: requested_qty2_tab wsh_util_core.id_tab_type,
18: shipped_qty_tab wsh_util_core.id_tab_type,
19: shipped_qty2_tab wsh_util_core.id_tab_type,
20: received_qty_tab wsh_util_core.id_tab_type,
21: received_qty2_tab wsh_util_core.id_tab_type,
22: returned_qty_tab wsh_util_core.id_tab_type,
15: del_det_id_tab wsh_util_core.id_tab_type,
16: requested_qty_tab wsh_util_core.id_tab_type,
17: requested_qty2_tab wsh_util_core.id_tab_type,
18: shipped_qty_tab wsh_util_core.id_tab_type,
19: shipped_qty2_tab wsh_util_core.id_tab_type,
20: received_qty_tab wsh_util_core.id_tab_type,
21: received_qty2_tab wsh_util_core.id_tab_type,
22: returned_qty_tab wsh_util_core.id_tab_type,
23: returned_qty2_tab wsh_util_core.id_tab_type,
16: requested_qty_tab wsh_util_core.id_tab_type,
17: requested_qty2_tab wsh_util_core.id_tab_type,
18: shipped_qty_tab wsh_util_core.id_tab_type,
19: shipped_qty2_tab wsh_util_core.id_tab_type,
20: received_qty_tab wsh_util_core.id_tab_type,
21: received_qty2_tab wsh_util_core.id_tab_type,
22: returned_qty_tab wsh_util_core.id_tab_type,
23: returned_qty2_tab wsh_util_core.id_tab_type,
24: shipment_line_id_tab wsh_util_core.id_tab_type,
17: requested_qty2_tab wsh_util_core.id_tab_type,
18: shipped_qty_tab wsh_util_core.id_tab_type,
19: shipped_qty2_tab wsh_util_core.id_tab_type,
20: received_qty_tab wsh_util_core.id_tab_type,
21: received_qty2_tab wsh_util_core.id_tab_type,
22: returned_qty_tab wsh_util_core.id_tab_type,
23: returned_qty2_tab wsh_util_core.id_tab_type,
24: shipment_line_id_tab wsh_util_core.id_tab_type,
25: released_sts_tab wsh_util_core.column_tab_type,
18: shipped_qty_tab wsh_util_core.id_tab_type,
19: shipped_qty2_tab wsh_util_core.id_tab_type,
20: received_qty_tab wsh_util_core.id_tab_type,
21: received_qty2_tab wsh_util_core.id_tab_type,
22: returned_qty_tab wsh_util_core.id_tab_type,
23: returned_qty2_tab wsh_util_core.id_tab_type,
24: shipment_line_id_tab wsh_util_core.id_tab_type,
25: released_sts_tab wsh_util_core.column_tab_type,
26: record_changed_flag_tab wsh_util_core.column_tab_type,
19: shipped_qty2_tab wsh_util_core.id_tab_type,
20: received_qty_tab wsh_util_core.id_tab_type,
21: received_qty2_tab wsh_util_core.id_tab_type,
22: returned_qty_tab wsh_util_core.id_tab_type,
23: returned_qty2_tab wsh_util_core.id_tab_type,
24: shipment_line_id_tab wsh_util_core.id_tab_type,
25: released_sts_tab wsh_util_core.column_tab_type,
26: record_changed_flag_tab wsh_util_core.column_tab_type,
27: wv_changed_flag_tab wsh_util_core.column_tab_type,
20: received_qty_tab wsh_util_core.id_tab_type,
21: received_qty2_tab wsh_util_core.id_tab_type,
22: returned_qty_tab wsh_util_core.id_tab_type,
23: returned_qty2_tab wsh_util_core.id_tab_type,
24: shipment_line_id_tab wsh_util_core.id_tab_type,
25: released_sts_tab wsh_util_core.column_tab_type,
26: record_changed_flag_tab wsh_util_core.column_tab_type,
27: wv_changed_flag_tab wsh_util_core.column_tab_type,
28: net_weight_tab wsh_util_core.id_tab_type,
21: received_qty2_tab wsh_util_core.id_tab_type,
22: returned_qty_tab wsh_util_core.id_tab_type,
23: returned_qty2_tab wsh_util_core.id_tab_type,
24: shipment_line_id_tab wsh_util_core.id_tab_type,
25: released_sts_tab wsh_util_core.column_tab_type,
26: record_changed_flag_tab wsh_util_core.column_tab_type,
27: wv_changed_flag_tab wsh_util_core.column_tab_type,
28: net_weight_tab wsh_util_core.id_tab_type,
29: gross_weight_tab wsh_util_core.id_tab_type,
22: returned_qty_tab wsh_util_core.id_tab_type,
23: returned_qty2_tab wsh_util_core.id_tab_type,
24: shipment_line_id_tab wsh_util_core.id_tab_type,
25: released_sts_tab wsh_util_core.column_tab_type,
26: record_changed_flag_tab wsh_util_core.column_tab_type,
27: wv_changed_flag_tab wsh_util_core.column_tab_type,
28: net_weight_tab wsh_util_core.id_tab_type,
29: gross_weight_tab wsh_util_core.id_tab_type,
30: volume_tab wsh_util_core.id_tab_type);
23: returned_qty2_tab wsh_util_core.id_tab_type,
24: shipment_line_id_tab wsh_util_core.id_tab_type,
25: released_sts_tab wsh_util_core.column_tab_type,
26: record_changed_flag_tab wsh_util_core.column_tab_type,
27: wv_changed_flag_tab wsh_util_core.column_tab_type,
28: net_weight_tab wsh_util_core.id_tab_type,
29: gross_weight_tab wsh_util_core.id_tab_type,
30: volume_tab wsh_util_core.id_tab_type);
31:
24: shipment_line_id_tab wsh_util_core.id_tab_type,
25: released_sts_tab wsh_util_core.column_tab_type,
26: record_changed_flag_tab wsh_util_core.column_tab_type,
27: wv_changed_flag_tab wsh_util_core.column_tab_type,
28: net_weight_tab wsh_util_core.id_tab_type,
29: gross_weight_tab wsh_util_core.id_tab_type,
30: volume_tab wsh_util_core.id_tab_type);
31:
32: -- This record is used to handle the remaining requested quantity
25: released_sts_tab wsh_util_core.column_tab_type,
26: record_changed_flag_tab wsh_util_core.column_tab_type,
27: wv_changed_flag_tab wsh_util_core.column_tab_type,
28: net_weight_tab wsh_util_core.id_tab_type,
29: gross_weight_tab wsh_util_core.id_tab_type,
30: volume_tab wsh_util_core.id_tab_type);
31:
32: -- This record is used to handle the remaining requested quantity
33: -- on open delivery details.
26: record_changed_flag_tab wsh_util_core.column_tab_type,
27: wv_changed_flag_tab wsh_util_core.column_tab_type,
28: net_weight_tab wsh_util_core.id_tab_type,
29: gross_weight_tab wsh_util_core.id_tab_type,
30: volume_tab wsh_util_core.id_tab_type);
31:
32: -- This record is used to handle the remaining requested quantity
33: -- on open delivery details.
34: -- please refer to the process_remaining_req_quantity procedure