DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on WMS_WAVEPLAN_TASKS_PVT

Line 743: wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;

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:

Line 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;

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;

Line 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;

Line 1554: l_tasks_select_str := wms_waveplan_tasks_pvt.get_generic_select(

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

Line 1568: wms_waveplan_tasks_pvt.get_generic_from(

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

Line 1576: wms_waveplan_tasks_pvt.get_generic_where(

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

Line 1855: l_completed_tasks_select_str := wms_waveplan_tasks_pvt.get_generic_select(

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

Line 1865: wms_waveplan_tasks_pvt.get_generic_from(

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

Line 1873: wms_waveplan_tasks_pvt.get_generic_where(

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

Line 2885: IF wms_waveplan_tasks_pvt.g_task_types.count > 0 THEN

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;

Line 2886: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types.count LOOP

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:

Line 2887: wms_plan_tasks_pvt.g_task_types(i) := wms_waveplan_tasks_pvt.g_task_types(i);

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

Line 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;

Line 2892: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types_orig.count LOOP

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:

Line 2893: wms_plan_tasks_pvt.g_task_types_orig(i) := wms_waveplan_tasks_pvt.g_task_types_orig(i);

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

Line 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;

Line 2898: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes.count LOOP

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:

Line 2899: wms_plan_tasks_pvt.g_status_codes(i) := wms_waveplan_tasks_pvt.g_status_codes(i);

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

Line 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;

Line 2904: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes_orig.count LOOP

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:

Line 2905: wms_plan_tasks_pvt.g_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_status_codes_orig(i);

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

Line 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;

Line 2910: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types.count LOOP

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:

Line 2911: wms_plan_tasks_pvt.g_plan_task_types(i) := wms_waveplan_tasks_pvt.g_plan_task_types(i);

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

Line 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;

Line 2916: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types_orig.count LOOP

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:

Line 2917: wms_plan_tasks_pvt.g_plan_task_types_orig(i) := wms_waveplan_tasks_pvt.g_plan_task_types_orig(i);

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

Line 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;

Line 2922: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes.count LOOP

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:

Line 2923: wms_plan_tasks_pvt.g_plan_status_codes(i) := wms_waveplan_tasks_pvt.g_plan_status_codes(i);

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

Line 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;

Line 2928: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count LOOP

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: */

Line 2929: wms_plan_tasks_pvt.g_plan_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_plan_status_codes_orig(i);

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:

Line 2934: wms_plan_tasks_pvt.g_task_types := wms_waveplan_tasks_pvt.g_task_types;

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;

Line 2935: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;

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;

Line 2936: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;

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;

Line 2937: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;

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;

Line 2938: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;

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:

Line 2939: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;

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;

Line 2940: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;

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:

Line 2941: wms_plan_tasks_pvt.g_plan_status_codes_orig := wms_waveplan_tasks_pvt.g_plan_status_codes_orig;

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;