739: debug(' l_wms_task_type : ' || l_wms_task_type, 'query_inbound');
740: debug(' l_wms_task_count : ' || l_task_count, 'query_inbound');
741: END IF;
742: IF l_wms_task_type > 0 THEN
743: wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
744: wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(l_wms_task_type).task_count := wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;
745: ELSIF l_wms_task_type = -1 THEN
746: /* There are some taks populated with task_type as -1, we will show them as putaway tasks, not sure if this is correct. Doing it this way inorder to be consitent with the results grid*/
747:
740: debug(' l_wms_task_count : ' || l_task_count, 'query_inbound');
741: END IF;
742: IF l_wms_task_type > 0 THEN
743: wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
744: wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(l_wms_task_type).task_count := wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;
745: ELSIF l_wms_task_type = -1 THEN
746: /* There are some taks populated with task_type as -1, we will show them as putaway tasks, not sure if this is correct. Doing it this way inorder to be consitent with the results grid*/
747:
748: wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_putaway).task_count := wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_putaway).task_count + l_task_count;
744: wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(l_wms_task_type).task_count := wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(l_wms_task_type).task_count + l_task_count;
745: ELSIF l_wms_task_type = -1 THEN
746: /* There are some taks populated with task_type as -1, we will show them as putaway tasks, not sure if this is correct. Doing it this way inorder to be consitent with the results grid*/
747:
748: wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_putaway).task_count := wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_putaway).task_count + l_task_count;
749: END IF;
750: ELSE
751: EXIT; -- no more rows returned from dynamic SQL
752: END IF;
1550:
1551: IF p_summary_mode = 1 THEN
1552: l_tasks_select_str := ' SELECT mmtt.wms_task_type, count(*) ';
1553: ELSE
1554: l_tasks_select_str := wms_waveplan_tasks_pvt.get_generic_select(
1555: p_is_pending => l_is_pending
1556: , p_is_loaded => l_is_loaded
1557: , p_is_completed => FALSE
1558: );
1564: debug('l_tasks_select_str ' || l_tasks_select_str,'get_tasks');
1565: debug('query for loaded and pending tasks. calling get_generic_from ','get_tasks');
1566: END IF;
1567: l_tasks_from_str :=
1568: wms_waveplan_tasks_pvt.get_generic_from(
1569: p_is_loaded => l_is_loaded
1570: , p_is_completed => FALSE
1571: , p_item_category_id => wms_plan_tasks_pvt.g_item_category_id
1572: , p_category_set_id => wms_plan_tasks_pvt.g_category_set_id
1572: , p_category_set_id => wms_plan_tasks_pvt.g_category_set_id
1573: );
1574:
1575: l_tasks_where_str :=
1576: wms_waveplan_tasks_pvt.get_generic_where(
1577: p_add => wms_plan_tasks_pvt.g_is_add
1578: , p_organization_id => wms_plan_tasks_pvt.g_organization_id
1579: , p_subinventory_code => wms_plan_tasks_pvt.g_subinventory_code
1580: , p_locator_id => wms_plan_tasks_pvt.g_locator_id
1851: g_inbound_cycle := TRUE;
1852: IF p_summary_mode = 1 THEN
1853: l_completed_tasks_select_str := ' SELECT wdth.task_type, count(*) ';
1854: ELSE
1855: l_completed_tasks_select_str := wms_waveplan_tasks_pvt.get_generic_select(
1856: p_is_pending => FALSE
1857: , p_is_loaded => FALSE
1858: , p_is_completed => l_is_completed
1859: );
1861:
1862: g_inbound_cycle := FALSE;
1863:
1864: l_completed_tasks_from_str :=
1865: wms_waveplan_tasks_pvt.get_generic_from(
1866: p_is_loaded => FALSE
1867: , p_is_completed => l_is_completed
1868: , p_item_category_id => wms_plan_tasks_pvt.g_item_category_id
1869: , p_category_set_id => wms_plan_tasks_pvt.g_category_set_id
1869: , p_category_set_id => wms_plan_tasks_pvt.g_category_set_id
1870: );
1871:
1872: l_completed_tasks_where_str :=
1873: wms_waveplan_tasks_pvt.get_generic_where(
1874: p_add => wms_plan_tasks_pvt.g_is_add
1875: , p_organization_id => wms_plan_tasks_pvt.g_organization_id
1876: , p_subinventory_code => wms_plan_tasks_pvt.g_subinventory_code
1877: , p_locator_id => wms_plan_tasks_pvt.g_locator_id
2881:
2882:
2883:
2884: /*
2885: IF wms_waveplan_tasks_pvt.g_task_types.count > 0 THEN
2886: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types.count LOOP
2887: wms_plan_tasks_pvt.g_task_types(i) := wms_waveplan_tasks_pvt.g_task_types(i);
2888: END LOOP;
2889: END IF;
2882:
2883:
2884: /*
2885: IF wms_waveplan_tasks_pvt.g_task_types.count > 0 THEN
2886: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types.count LOOP
2887: wms_plan_tasks_pvt.g_task_types(i) := wms_waveplan_tasks_pvt.g_task_types(i);
2888: END LOOP;
2889: END IF;
2890:
2883:
2884: /*
2885: IF wms_waveplan_tasks_pvt.g_task_types.count > 0 THEN
2886: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types.count LOOP
2887: wms_plan_tasks_pvt.g_task_types(i) := wms_waveplan_tasks_pvt.g_task_types(i);
2888: END LOOP;
2889: END IF;
2890:
2891: IF wms_waveplan_tasks_pvt.g_task_types_orig.count > 0 THEN
2887: wms_plan_tasks_pvt.g_task_types(i) := wms_waveplan_tasks_pvt.g_task_types(i);
2888: END LOOP;
2889: END IF;
2890:
2891: IF wms_waveplan_tasks_pvt.g_task_types_orig.count > 0 THEN
2892: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types_orig.count LOOP
2893: wms_plan_tasks_pvt.g_task_types_orig(i) := wms_waveplan_tasks_pvt.g_task_types_orig(i);
2894: END LOOP;
2895: END IF;
2888: END LOOP;
2889: END IF;
2890:
2891: IF wms_waveplan_tasks_pvt.g_task_types_orig.count > 0 THEN
2892: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types_orig.count LOOP
2893: wms_plan_tasks_pvt.g_task_types_orig(i) := wms_waveplan_tasks_pvt.g_task_types_orig(i);
2894: END LOOP;
2895: END IF;
2896:
2889: END IF;
2890:
2891: IF wms_waveplan_tasks_pvt.g_task_types_orig.count > 0 THEN
2892: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types_orig.count LOOP
2893: wms_plan_tasks_pvt.g_task_types_orig(i) := wms_waveplan_tasks_pvt.g_task_types_orig(i);
2894: END LOOP;
2895: END IF;
2896:
2897: IF wms_waveplan_tasks_pvt.g_status_codes.count > 0 THEN
2893: wms_plan_tasks_pvt.g_task_types_orig(i) := wms_waveplan_tasks_pvt.g_task_types_orig(i);
2894: END LOOP;
2895: END IF;
2896:
2897: IF wms_waveplan_tasks_pvt.g_status_codes.count > 0 THEN
2898: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes.count LOOP
2899: wms_plan_tasks_pvt.g_status_codes(i) := wms_waveplan_tasks_pvt.g_status_codes(i);
2900: END LOOP;
2901: END IF;
2894: END LOOP;
2895: END IF;
2896:
2897: IF wms_waveplan_tasks_pvt.g_status_codes.count > 0 THEN
2898: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes.count LOOP
2899: wms_plan_tasks_pvt.g_status_codes(i) := wms_waveplan_tasks_pvt.g_status_codes(i);
2900: END LOOP;
2901: END IF;
2902:
2895: END IF;
2896:
2897: IF wms_waveplan_tasks_pvt.g_status_codes.count > 0 THEN
2898: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes.count LOOP
2899: wms_plan_tasks_pvt.g_status_codes(i) := wms_waveplan_tasks_pvt.g_status_codes(i);
2900: END LOOP;
2901: END IF;
2902:
2903: IF wms_waveplan_tasks_pvt.g_status_codes_orig.count > 0 THEN
2899: wms_plan_tasks_pvt.g_status_codes(i) := wms_waveplan_tasks_pvt.g_status_codes(i);
2900: END LOOP;
2901: END IF;
2902:
2903: IF wms_waveplan_tasks_pvt.g_status_codes_orig.count > 0 THEN
2904: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes_orig.count LOOP
2905: wms_plan_tasks_pvt.g_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_status_codes_orig(i);
2906: END LOOP;
2907: END IF;
2900: END LOOP;
2901: END IF;
2902:
2903: IF wms_waveplan_tasks_pvt.g_status_codes_orig.count > 0 THEN
2904: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes_orig.count LOOP
2905: wms_plan_tasks_pvt.g_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_status_codes_orig(i);
2906: END LOOP;
2907: END IF;
2908:
2901: END IF;
2902:
2903: IF wms_waveplan_tasks_pvt.g_status_codes_orig.count > 0 THEN
2904: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes_orig.count LOOP
2905: wms_plan_tasks_pvt.g_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_status_codes_orig(i);
2906: END LOOP;
2907: END IF;
2908:
2909: IF wms_waveplan_tasks_pvt.g_plan_task_types.count > 0 THEN
2905: wms_plan_tasks_pvt.g_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_status_codes_orig(i);
2906: END LOOP;
2907: END IF;
2908:
2909: IF wms_waveplan_tasks_pvt.g_plan_task_types.count > 0 THEN
2910: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types.count LOOP
2911: wms_plan_tasks_pvt.g_plan_task_types(i) := wms_waveplan_tasks_pvt.g_plan_task_types(i);
2912: END LOOP;
2913: END IF;
2906: END LOOP;
2907: END IF;
2908:
2909: IF wms_waveplan_tasks_pvt.g_plan_task_types.count > 0 THEN
2910: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types.count LOOP
2911: wms_plan_tasks_pvt.g_plan_task_types(i) := wms_waveplan_tasks_pvt.g_plan_task_types(i);
2912: END LOOP;
2913: END IF;
2914:
2907: END IF;
2908:
2909: IF wms_waveplan_tasks_pvt.g_plan_task_types.count > 0 THEN
2910: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types.count LOOP
2911: wms_plan_tasks_pvt.g_plan_task_types(i) := wms_waveplan_tasks_pvt.g_plan_task_types(i);
2912: END LOOP;
2913: END IF;
2914:
2915: IF wms_waveplan_tasks_pvt.g_plan_task_types_orig.count > 0 THEN
2911: wms_plan_tasks_pvt.g_plan_task_types(i) := wms_waveplan_tasks_pvt.g_plan_task_types(i);
2912: END LOOP;
2913: END IF;
2914:
2915: IF wms_waveplan_tasks_pvt.g_plan_task_types_orig.count > 0 THEN
2916: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types_orig.count LOOP
2917: wms_plan_tasks_pvt.g_plan_task_types_orig(i) := wms_waveplan_tasks_pvt.g_plan_task_types_orig(i);
2918: END LOOP;
2919: END IF;
2912: END LOOP;
2913: END IF;
2914:
2915: IF wms_waveplan_tasks_pvt.g_plan_task_types_orig.count > 0 THEN
2916: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types_orig.count LOOP
2917: wms_plan_tasks_pvt.g_plan_task_types_orig(i) := wms_waveplan_tasks_pvt.g_plan_task_types_orig(i);
2918: END LOOP;
2919: END IF;
2920:
2913: END IF;
2914:
2915: IF wms_waveplan_tasks_pvt.g_plan_task_types_orig.count > 0 THEN
2916: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types_orig.count LOOP
2917: wms_plan_tasks_pvt.g_plan_task_types_orig(i) := wms_waveplan_tasks_pvt.g_plan_task_types_orig(i);
2918: END LOOP;
2919: END IF;
2920:
2921: IF wms_waveplan_tasks_pvt.g_plan_status_codes.count > 0 THEN
2917: wms_plan_tasks_pvt.g_plan_task_types_orig(i) := wms_waveplan_tasks_pvt.g_plan_task_types_orig(i);
2918: END LOOP;
2919: END IF;
2920:
2921: IF wms_waveplan_tasks_pvt.g_plan_status_codes.count > 0 THEN
2922: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes.count LOOP
2923: wms_plan_tasks_pvt.g_plan_status_codes(i) := wms_waveplan_tasks_pvt.g_plan_status_codes(i);
2924: END LOOP;
2925: END IF;
2918: END LOOP;
2919: END IF;
2920:
2921: IF wms_waveplan_tasks_pvt.g_plan_status_codes.count > 0 THEN
2922: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes.count LOOP
2923: wms_plan_tasks_pvt.g_plan_status_codes(i) := wms_waveplan_tasks_pvt.g_plan_status_codes(i);
2924: END LOOP;
2925: END IF;
2926:
2919: END IF;
2920:
2921: IF wms_waveplan_tasks_pvt.g_plan_status_codes.count > 0 THEN
2922: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes.count LOOP
2923: wms_plan_tasks_pvt.g_plan_status_codes(i) := wms_waveplan_tasks_pvt.g_plan_status_codes(i);
2924: END LOOP;
2925: END IF;
2926:
2927: IF wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count > 0 THEN
2923: wms_plan_tasks_pvt.g_plan_status_codes(i) := wms_waveplan_tasks_pvt.g_plan_status_codes(i);
2924: END LOOP;
2925: END IF;
2926:
2927: IF wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count > 0 THEN
2928: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count LOOP
2929: wms_plan_tasks_pvt.g_plan_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_plan_status_codes_orig(i);
2930: END LOOP;
2931: END IF;
2924: END LOOP;
2925: END IF;
2926:
2927: IF wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count > 0 THEN
2928: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count LOOP
2929: wms_plan_tasks_pvt.g_plan_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_plan_status_codes_orig(i);
2930: END LOOP;
2931: END IF;
2932: */
2925: END IF;
2926:
2927: IF wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count > 0 THEN
2928: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count LOOP
2929: wms_plan_tasks_pvt.g_plan_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_plan_status_codes_orig(i);
2930: END LOOP;
2931: END IF;
2932: */
2933:
2930: END LOOP;
2931: END IF;
2932: */
2933:
2934: wms_plan_tasks_pvt.g_task_types := wms_waveplan_tasks_pvt.g_task_types;
2935: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;
2936: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2937: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2938: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2931: END IF;
2932: */
2933:
2934: wms_plan_tasks_pvt.g_task_types := wms_waveplan_tasks_pvt.g_task_types;
2935: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;
2936: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2937: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2938: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2939: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2932: */
2933:
2934: wms_plan_tasks_pvt.g_task_types := wms_waveplan_tasks_pvt.g_task_types;
2935: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;
2936: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2937: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2938: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2939: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2940: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;
2933:
2934: wms_plan_tasks_pvt.g_task_types := wms_waveplan_tasks_pvt.g_task_types;
2935: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;
2936: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2937: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2938: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2939: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2940: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;
2941: wms_plan_tasks_pvt.g_plan_status_codes_orig := wms_waveplan_tasks_pvt.g_plan_status_codes_orig;
2934: wms_plan_tasks_pvt.g_task_types := wms_waveplan_tasks_pvt.g_task_types;
2935: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;
2936: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2937: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2938: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2939: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2940: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;
2941: wms_plan_tasks_pvt.g_plan_status_codes_orig := wms_waveplan_tasks_pvt.g_plan_status_codes_orig;
2942:
2935: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;
2936: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2937: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2938: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2939: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2940: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;
2941: wms_plan_tasks_pvt.g_plan_status_codes_orig := wms_waveplan_tasks_pvt.g_plan_status_codes_orig;
2942:
2943: wms_plan_tasks_pvt.g_plans_tasks_record_count := 0;
2936: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2937: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2938: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2939: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2940: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;
2941: wms_plan_tasks_pvt.g_plan_status_codes_orig := wms_waveplan_tasks_pvt.g_plan_status_codes_orig;
2942:
2943: wms_plan_tasks_pvt.g_plans_tasks_record_count := 0;
2944:
2937: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2938: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2939: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2940: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;
2941: wms_plan_tasks_pvt.g_plan_status_codes_orig := wms_waveplan_tasks_pvt.g_plan_status_codes_orig;
2942:
2943: wms_plan_tasks_pvt.g_plans_tasks_record_count := 0;
2944:
2945: END set_globals;