[Home] [Help]
978: l_split_from_wave_line.crossdock_uom)
979: returning WAVE_LINE_ID into l_new_wave_line_id;
980:
981: --call APIs to re-calculate actual_fill_rate and pick_fill_rate
982: wms_wave_planning_pvt.update_line_pick_fill_rate(l_new_wave_line_id);
983: wms_wave_planning_pvt.update_line_pick_fill_rate(l_split_from_wave_line.wave_line_id);
984: wms_wave_planning_pvt.update_line_actual_fill_rate(l_new_wave_line_id);
985: wms_wave_planning_pvt.update_line_actual_fill_rate(l_split_from_wave_line.wave_line_id);
986:
979: returning WAVE_LINE_ID into l_new_wave_line_id;
980:
981: --call APIs to re-calculate actual_fill_rate and pick_fill_rate
982: wms_wave_planning_pvt.update_line_pick_fill_rate(l_new_wave_line_id);
983: wms_wave_planning_pvt.update_line_pick_fill_rate(l_split_from_wave_line.wave_line_id);
984: wms_wave_planning_pvt.update_line_actual_fill_rate(l_new_wave_line_id);
985: wms_wave_planning_pvt.update_line_actual_fill_rate(l_split_from_wave_line.wave_line_id);
986:
987: end loop;
980:
981: --call APIs to re-calculate actual_fill_rate and pick_fill_rate
982: wms_wave_planning_pvt.update_line_pick_fill_rate(l_new_wave_line_id);
983: wms_wave_planning_pvt.update_line_pick_fill_rate(l_split_from_wave_line.wave_line_id);
984: wms_wave_planning_pvt.update_line_actual_fill_rate(l_new_wave_line_id);
985: wms_wave_planning_pvt.update_line_actual_fill_rate(l_split_from_wave_line.wave_line_id);
986:
987: end loop;
988: exception
981: --call APIs to re-calculate actual_fill_rate and pick_fill_rate
982: wms_wave_planning_pvt.update_line_pick_fill_rate(l_new_wave_line_id);
983: wms_wave_planning_pvt.update_line_pick_fill_rate(l_split_from_wave_line.wave_line_id);
984: wms_wave_planning_pvt.update_line_actual_fill_rate(l_new_wave_line_id);
985: wms_wave_planning_pvt.update_line_actual_fill_rate(l_split_from_wave_line.wave_line_id);
986:
987: end loop;
988: exception
989: when others then