130: l_cnt1 := 0;
131: l_insp_cnt := 0;
132: -- First check to see if there are any crossdock opportunities
133: -- at all
134: wms_task_dispatch_put_away.crdk_wip_info_table.DELETE;
135: wms_task_dispatch_put_away.crdk_wip_table_index := 0;
136:
137: BEGIN
138: SELECT 1
131: l_insp_cnt := 0;
132: -- First check to see if there are any crossdock opportunities
133: -- at all
134: wms_task_dispatch_put_away.crdk_wip_info_table.DELETE;
135: wms_task_dispatch_put_away.crdk_wip_table_index := 0;
136:
137: BEGIN
138: SELECT 1
139: INTO l_count
463: IF (l_debug = 1) THEN
464: mydebug('updating crdk_wip_table ');
465: END IF;
466:
467: wms_task_dispatch_put_away.crdk_wip_table_index :=
468: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
469: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
470: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
471: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
464: mydebug('updating crdk_wip_table ');
465: END IF;
466:
467: wms_task_dispatch_put_away.crdk_wip_table_index :=
468: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
469: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
470: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
471: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
472: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
465: END IF;
466:
467: wms_task_dispatch_put_away.crdk_wip_table_index :=
468: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
469: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
470: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
471: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
472: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
473: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
466:
467: wms_task_dispatch_put_away.crdk_wip_table_index :=
468: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
469: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
470: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
471: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
472: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
473: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
474: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
467: wms_task_dispatch_put_away.crdk_wip_table_index :=
468: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
469: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
470: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
471: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
472: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
473: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
474: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
475:
468: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
469: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
470: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
471: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
472: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
473: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
474: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
475:
476: -- reduce lpn_qty
469: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
470: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
471: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
472: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
473: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
474: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
475:
476: -- reduce lpn_qty
477: --l_lpn_qty:=l_lpn_qty-l_wip_qty;
470: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
471: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
472: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
473: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
474: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
475:
476: -- reduce lpn_qty
477: --l_lpn_qty:=l_lpn_qty-l_wip_qty;
478: IF (l_debug = 1) THEN
479: mydebug('creating new lines..');
480: END IF;
481:
482: -- create new mo line
483: wms_task_dispatch_put_away.create_mo_line(
484: p_org_id => l_org_id
485: , p_inventory_item_id => l_inventory_item_id
486: , p_qty => l_lpn_qty - l_quantity_allocated
487: , p_uom => l_uom
592: IF (l_debug = 1) THEN
593: mydebug('updating the crdk_wip_table');
594: END IF;
595:
596: wms_task_dispatch_put_away.crdk_wip_table_index :=
597: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
598: indx :=
599: wms_task_dispatch_put_away.crdk_wip_table_index;
600: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
593: mydebug('updating the crdk_wip_table');
594: END IF;
595:
596: wms_task_dispatch_put_away.crdk_wip_table_index :=
597: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
598: indx :=
599: wms_task_dispatch_put_away.crdk_wip_table_index;
600: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
601: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
595:
596: wms_task_dispatch_put_away.crdk_wip_table_index :=
597: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
598: indx :=
599: wms_task_dispatch_put_away.crdk_wip_table_index;
600: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
601: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
602: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
603: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
596: wms_task_dispatch_put_away.crdk_wip_table_index :=
597: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
598: indx :=
599: wms_task_dispatch_put_away.crdk_wip_table_index;
600: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
601: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
602: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
603: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
604: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
597: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
598: indx :=
599: wms_task_dispatch_put_away.crdk_wip_table_index;
600: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
601: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
602: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
603: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
604: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
605:
598: indx :=
599: wms_task_dispatch_put_away.crdk_wip_table_index;
600: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
601: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
602: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
603: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
604: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
605:
606: IF (l_debug = 1) THEN
599: wms_task_dispatch_put_away.crdk_wip_table_index;
600: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
601: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
602: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
603: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
604: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
605:
606: IF (l_debug = 1) THEN
607: mydebug('creating a mol for the rest ');
600: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
601: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
602: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
603: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
604: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
605:
606: IF (l_debug = 1) THEN
607: mydebug('creating a mol for the rest ');
608: END IF;
606: IF (l_debug = 1) THEN
607: mydebug('creating a mol for the rest ');
608: END IF;
609:
610: wms_task_dispatch_put_away.create_mo_line(
611: p_org_id => l_org_id
612: , p_inventory_item_id => l_inventory_item_id
613: , p_qty => l_lpn_qty - l_quantity_allocated
614: , p_uom => l_uom
671: IF (l_debug = 1) THEN
672: mydebug(' updating the crdk_wip_table ');
673: END IF;
674:
675: wms_task_dispatch_put_away.crdk_wip_table_index :=
676: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
677: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
678: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
679: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
672: mydebug(' updating the crdk_wip_table ');
673: END IF;
674:
675: wms_task_dispatch_put_away.crdk_wip_table_index :=
676: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
677: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
678: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
679: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
680: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
673: END IF;
674:
675: wms_task_dispatch_put_away.crdk_wip_table_index :=
676: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
677: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
678: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
679: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
680: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
681: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
674:
675: wms_task_dispatch_put_away.crdk_wip_table_index :=
676: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
677: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
678: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
679: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
680: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
681: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
682: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
675: wms_task_dispatch_put_away.crdk_wip_table_index :=
676: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
677: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
678: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
679: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
680: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
681: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
682: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
683: --l_lpn_qty:=0;
676: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
677: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
678: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
679: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
680: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
681: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
682: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
683: --l_lpn_qty:=0;
684: ELSIF l_lpn_qty = l_wip_qty THEN
677: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
678: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
679: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
680: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
681: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
682: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
683: --l_lpn_qty:=0;
684: ELSIF l_lpn_qty = l_wip_qty THEN
685: IF (l_debug = 1) THEN
678: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
679: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
680: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
681: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
682: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
683: --l_lpn_qty:=0;
684: ELSIF l_lpn_qty = l_wip_qty THEN
685: IF (l_debug = 1) THEN
686: mydebug('MOL=DEL');
747: IF (l_debug = 1) THEN
748: mydebug('updating the crdk_wip_table ');
749: END IF;
750:
751: wms_task_dispatch_put_away.crdk_wip_table_index :=
752: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
753: indx :=
754: wms_task_dispatch_put_away.crdk_wip_table_index;
755: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
748: mydebug('updating the crdk_wip_table ');
749: END IF;
750:
751: wms_task_dispatch_put_away.crdk_wip_table_index :=
752: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
753: indx :=
754: wms_task_dispatch_put_away.crdk_wip_table_index;
755: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
756: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
750:
751: wms_task_dispatch_put_away.crdk_wip_table_index :=
752: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
753: indx :=
754: wms_task_dispatch_put_away.crdk_wip_table_index;
755: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
756: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
757: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
758: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
751: wms_task_dispatch_put_away.crdk_wip_table_index :=
752: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
753: indx :=
754: wms_task_dispatch_put_away.crdk_wip_table_index;
755: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
756: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
757: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
758: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
759: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
752: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
753: indx :=
754: wms_task_dispatch_put_away.crdk_wip_table_index;
755: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
756: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
757: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
758: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
759: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
760:
753: indx :=
754: wms_task_dispatch_put_away.crdk_wip_table_index;
755: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
756: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
757: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
758: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
759: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
760:
761: IF (l_debug = 1) THEN
754: wms_task_dispatch_put_away.crdk_wip_table_index;
755: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
756: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
757: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
758: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
759: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
760:
761: IF (l_debug = 1) THEN
762: mydebug('creating new mol for the rest ');
755: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
756: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
757: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
758: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
759: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
760:
761: IF (l_debug = 1) THEN
762: mydebug('creating new mol for the rest ');
763: END IF;
761: IF (l_debug = 1) THEN
762: mydebug('creating new mol for the rest ');
763: END IF;
764:
765: wms_task_dispatch_put_away.create_mo_line(
766: p_org_id => l_org_id
767: , p_inventory_item_id => l_inventory_item_id
768: , p_qty => l_lpn_qty - l_quantity_allocated
769: , p_uom => l_uom
818: IF (l_debug = 1) THEN
819: mydebug('updating the crdk_wip_table_index ');
820: END IF;
821:
822: wms_task_dispatch_put_away.crdk_wip_table_index :=
823: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
824: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
825: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
826: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
819: mydebug('updating the crdk_wip_table_index ');
820: END IF;
821:
822: wms_task_dispatch_put_away.crdk_wip_table_index :=
823: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
824: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
825: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
826: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
827: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
820: END IF;
821:
822: wms_task_dispatch_put_away.crdk_wip_table_index :=
823: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
824: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
825: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
826: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
827: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
828: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
821:
822: wms_task_dispatch_put_away.crdk_wip_table_index :=
823: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
824: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
825: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
826: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
827: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
828: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
829: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
822: wms_task_dispatch_put_away.crdk_wip_table_index :=
823: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
824: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
825: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
826: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
827: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
828: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
829: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
830:
823: wms_task_dispatch_put_away.crdk_wip_table_index + 1;
824: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
825: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
826: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
827: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
828: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
829: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
830:
831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
824: indx := wms_task_dispatch_put_away.crdk_wip_table_index;
825: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
826: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
827: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
828: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
829: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
830:
831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
832: fnd_message.set_name('WMS', 'WMS_TD_MK_DEL_ERROR');
825: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_id;
826: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;
827: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
828: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
829: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
830:
831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
832: fnd_message.set_name('WMS', 'WMS_TD_MK_DEL_ERROR');
833: fnd_msg_pub.ADD;