DBA Data[Home] [Help]

APPS.WMS_WIP_XDOCK_PVT dependencies on WMS_TASK_DISPATCH_PUT_AWAY

Line 134: wms_task_dispatch_put_away.crdk_wip_info_table.DELETE;

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

Line 135: wms_task_dispatch_put_away.crdk_wip_table_index := 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
139: INTO l_count

Line 467: wms_task_dispatch_put_away.crdk_wip_table_index :=

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;

Line 468: wms_task_dispatch_put_away.crdk_wip_table_index + 1;

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;

Line 469: indx := wms_task_dispatch_put_away.crdk_wip_table_index;

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;

Line 470: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_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;

Line 471: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;

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:

Line 472: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;

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

Line 473: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;

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;

Line 474: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;

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

Line 483: wms_task_dispatch_put_away.create_mo_line(

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

Line 596: wms_task_dispatch_put_away.crdk_wip_table_index :=

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;

Line 597: wms_task_dispatch_put_away.crdk_wip_table_index + 1;

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;

Line 599: wms_task_dispatch_put_away.crdk_wip_table_index;

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;

Line 600: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_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;

Line 601: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;

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:

Line 602: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;

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

Line 603: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;

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 ');

Line 604: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;

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;

Line 610: wms_task_dispatch_put_away.create_mo_line(

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

Line 675: wms_task_dispatch_put_away.crdk_wip_table_index :=

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;

Line 676: wms_task_dispatch_put_away.crdk_wip_table_index + 1;

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;

Line 677: indx := wms_task_dispatch_put_away.crdk_wip_table_index;

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;

Line 678: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_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;

Line 679: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;

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;

Line 680: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;

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

Line 681: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;

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

Line 682: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;

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');

Line 751: wms_task_dispatch_put_away.crdk_wip_table_index :=

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;

Line 752: wms_task_dispatch_put_away.crdk_wip_table_index + 1;

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;

Line 754: wms_task_dispatch_put_away.crdk_wip_table_index;

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;

Line 755: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_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;

Line 756: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;

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:

Line 757: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;

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

Line 758: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;

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 ');

Line 759: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;

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;

Line 765: wms_task_dispatch_put_away.create_mo_line(

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

Line 822: wms_task_dispatch_put_away.crdk_wip_table_index :=

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;

Line 823: wms_task_dispatch_put_away.crdk_wip_table_index + 1;

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;

Line 824: indx := wms_task_dispatch_put_away.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;
828: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;

Line 825: wms_task_dispatch_put_away.crdk_wip_info_table(indx).move_order_line_id := l_line_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;

Line 826: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_entity_id := l_wip_id;

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:

Line 827: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;

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

Line 828: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;

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');

Line 829: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;

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;