DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on WMS_WAVEPLAN_TASKS_PVT

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

715: debug(' l_wms_task_type : ' || l_wms_task_type, 'query_inbound');
716: debug(' l_wms_task_count : ' || l_task_count, 'query_inbound');
717: END IF;
718: IF l_wms_task_type > 0 THEN
719: wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
720: 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;
721: ELSIF l_wms_task_type = -1 THEN
722: /* 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*/
723:

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

716: debug(' l_wms_task_count : ' || l_task_count, 'query_inbound');
717: END IF;
718: IF l_wms_task_type > 0 THEN
719: wms_waveplan_tasks_pvt.g_wms_task_summary_tbl(l_wms_task_type).wms_task_type := l_wms_task_type;
720: 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;
721: ELSIF l_wms_task_type = -1 THEN
722: /* 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*/
723:
724: 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 724: 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;

720: 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;
721: ELSIF l_wms_task_type = -1 THEN
722: /* 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*/
723:
724: 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;
725: END IF;
726: ELSE
727: EXIT; -- no more rows returned from dynamic SQL
728: END IF;

Line 1529: l_tasks_select_str := wms_waveplan_tasks_pvt.get_generic_select(

1525:
1526: IF p_summary_mode = 1 THEN
1527: l_tasks_select_str := ' SELECT mmtt.wms_task_type, count(*) ';
1528: ELSE
1529: l_tasks_select_str := wms_waveplan_tasks_pvt.get_generic_select(
1530: p_is_pending => l_is_pending
1531: , p_is_loaded => l_is_loaded
1532: , p_is_completed => FALSE
1533: );

Line 1543: wms_waveplan_tasks_pvt.get_generic_from(

1539: debug('l_tasks_select_str ' || l_tasks_select_str,'get_tasks');
1540: debug('query for loaded and pending tasks. calling get_generic_from ','get_tasks');
1541: END IF;
1542: l_tasks_from_str :=
1543: wms_waveplan_tasks_pvt.get_generic_from(
1544: p_is_loaded => l_is_loaded
1545: , p_is_completed => FALSE
1546: , p_item_category_id => wms_plan_tasks_pvt.g_item_category_id
1547: , p_category_set_id => wms_plan_tasks_pvt.g_category_set_id

Line 1551: wms_waveplan_tasks_pvt.get_generic_where(

1547: , p_category_set_id => wms_plan_tasks_pvt.g_category_set_id
1548: );
1549:
1550: l_tasks_where_str :=
1551: wms_waveplan_tasks_pvt.get_generic_where(
1552: p_add => wms_plan_tasks_pvt.g_is_add
1553: , p_organization_id => wms_plan_tasks_pvt.g_organization_id
1554: , p_subinventory_code => wms_plan_tasks_pvt.g_subinventory_code
1555: , p_locator_id => wms_plan_tasks_pvt.g_locator_id

Line 1826: l_completed_tasks_select_str := wms_waveplan_tasks_pvt.get_generic_select(

1822: g_inbound_cycle := TRUE;
1823: IF p_summary_mode = 1 THEN
1824: l_completed_tasks_select_str := ' SELECT wdth.task_type, count(*) ';
1825: ELSE
1826: l_completed_tasks_select_str := wms_waveplan_tasks_pvt.get_generic_select(
1827: p_is_pending => FALSE
1828: , p_is_loaded => FALSE
1829: , p_is_completed => l_is_completed
1830: );

Line 1836: wms_waveplan_tasks_pvt.get_generic_from(

1832:
1833: g_inbound_cycle := FALSE;
1834:
1835: l_completed_tasks_from_str :=
1836: wms_waveplan_tasks_pvt.get_generic_from(
1837: p_is_loaded => FALSE
1838: , p_is_completed => l_is_completed
1839: , p_item_category_id => wms_plan_tasks_pvt.g_item_category_id
1840: , p_category_set_id => wms_plan_tasks_pvt.g_category_set_id

Line 1844: wms_waveplan_tasks_pvt.get_generic_where(

1840: , p_category_set_id => wms_plan_tasks_pvt.g_category_set_id
1841: );
1842:
1843: l_completed_tasks_where_str :=
1844: wms_waveplan_tasks_pvt.get_generic_where(
1845: p_add => wms_plan_tasks_pvt.g_is_add
1846: , p_organization_id => wms_plan_tasks_pvt.g_organization_id
1847: , p_subinventory_code => wms_plan_tasks_pvt.g_subinventory_code
1848: , p_locator_id => wms_plan_tasks_pvt.g_locator_id

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

2831:
2832:
2833:
2834: /*
2835: IF wms_waveplan_tasks_pvt.g_task_types.count > 0 THEN
2836: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types.count LOOP
2837: wms_plan_tasks_pvt.g_task_types(i) := wms_waveplan_tasks_pvt.g_task_types(i);
2838: END LOOP;
2839: END IF;

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

2832:
2833:
2834: /*
2835: IF wms_waveplan_tasks_pvt.g_task_types.count > 0 THEN
2836: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types.count LOOP
2837: wms_plan_tasks_pvt.g_task_types(i) := wms_waveplan_tasks_pvt.g_task_types(i);
2838: END LOOP;
2839: END IF;
2840:

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

2833:
2834: /*
2835: IF wms_waveplan_tasks_pvt.g_task_types.count > 0 THEN
2836: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types.count LOOP
2837: wms_plan_tasks_pvt.g_task_types(i) := wms_waveplan_tasks_pvt.g_task_types(i);
2838: END LOOP;
2839: END IF;
2840:
2841: IF wms_waveplan_tasks_pvt.g_task_types_orig.count > 0 THEN

Line 2841: IF wms_waveplan_tasks_pvt.g_task_types_orig.count > 0 THEN

2837: wms_plan_tasks_pvt.g_task_types(i) := wms_waveplan_tasks_pvt.g_task_types(i);
2838: END LOOP;
2839: END IF;
2840:
2841: IF wms_waveplan_tasks_pvt.g_task_types_orig.count > 0 THEN
2842: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types_orig.count LOOP
2843: wms_plan_tasks_pvt.g_task_types_orig(i) := wms_waveplan_tasks_pvt.g_task_types_orig(i);
2844: END LOOP;
2845: END IF;

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

2838: END LOOP;
2839: END IF;
2840:
2841: IF wms_waveplan_tasks_pvt.g_task_types_orig.count > 0 THEN
2842: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types_orig.count LOOP
2843: wms_plan_tasks_pvt.g_task_types_orig(i) := wms_waveplan_tasks_pvt.g_task_types_orig(i);
2844: END LOOP;
2845: END IF;
2846:

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

2839: END IF;
2840:
2841: IF wms_waveplan_tasks_pvt.g_task_types_orig.count > 0 THEN
2842: FOR i IN 1..wms_waveplan_tasks_pvt.g_task_types_orig.count LOOP
2843: wms_plan_tasks_pvt.g_task_types_orig(i) := wms_waveplan_tasks_pvt.g_task_types_orig(i);
2844: END LOOP;
2845: END IF;
2846:
2847: IF wms_waveplan_tasks_pvt.g_status_codes.count > 0 THEN

Line 2847: IF wms_waveplan_tasks_pvt.g_status_codes.count > 0 THEN

2843: wms_plan_tasks_pvt.g_task_types_orig(i) := wms_waveplan_tasks_pvt.g_task_types_orig(i);
2844: END LOOP;
2845: END IF;
2846:
2847: IF wms_waveplan_tasks_pvt.g_status_codes.count > 0 THEN
2848: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes.count LOOP
2849: wms_plan_tasks_pvt.g_status_codes(i) := wms_waveplan_tasks_pvt.g_status_codes(i);
2850: END LOOP;
2851: END IF;

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

2844: END LOOP;
2845: END IF;
2846:
2847: IF wms_waveplan_tasks_pvt.g_status_codes.count > 0 THEN
2848: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes.count LOOP
2849: wms_plan_tasks_pvt.g_status_codes(i) := wms_waveplan_tasks_pvt.g_status_codes(i);
2850: END LOOP;
2851: END IF;
2852:

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

2845: END IF;
2846:
2847: IF wms_waveplan_tasks_pvt.g_status_codes.count > 0 THEN
2848: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes.count LOOP
2849: wms_plan_tasks_pvt.g_status_codes(i) := wms_waveplan_tasks_pvt.g_status_codes(i);
2850: END LOOP;
2851: END IF;
2852:
2853: IF wms_waveplan_tasks_pvt.g_status_codes_orig.count > 0 THEN

Line 2853: IF wms_waveplan_tasks_pvt.g_status_codes_orig.count > 0 THEN

2849: wms_plan_tasks_pvt.g_status_codes(i) := wms_waveplan_tasks_pvt.g_status_codes(i);
2850: END LOOP;
2851: END IF;
2852:
2853: IF wms_waveplan_tasks_pvt.g_status_codes_orig.count > 0 THEN
2854: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes_orig.count LOOP
2855: wms_plan_tasks_pvt.g_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_status_codes_orig(i);
2856: END LOOP;
2857: END IF;

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

2850: END LOOP;
2851: END IF;
2852:
2853: IF wms_waveplan_tasks_pvt.g_status_codes_orig.count > 0 THEN
2854: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes_orig.count LOOP
2855: wms_plan_tasks_pvt.g_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_status_codes_orig(i);
2856: END LOOP;
2857: END IF;
2858:

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

2851: END IF;
2852:
2853: IF wms_waveplan_tasks_pvt.g_status_codes_orig.count > 0 THEN
2854: FOR i IN 1..wms_waveplan_tasks_pvt.g_status_codes_orig.count LOOP
2855: wms_plan_tasks_pvt.g_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_status_codes_orig(i);
2856: END LOOP;
2857: END IF;
2858:
2859: IF wms_waveplan_tasks_pvt.g_plan_task_types.count > 0 THEN

Line 2859: IF wms_waveplan_tasks_pvt.g_plan_task_types.count > 0 THEN

2855: wms_plan_tasks_pvt.g_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_status_codes_orig(i);
2856: END LOOP;
2857: END IF;
2858:
2859: IF wms_waveplan_tasks_pvt.g_plan_task_types.count > 0 THEN
2860: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types.count LOOP
2861: wms_plan_tasks_pvt.g_plan_task_types(i) := wms_waveplan_tasks_pvt.g_plan_task_types(i);
2862: END LOOP;
2863: END IF;

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

2856: END LOOP;
2857: END IF;
2858:
2859: IF wms_waveplan_tasks_pvt.g_plan_task_types.count > 0 THEN
2860: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types.count LOOP
2861: wms_plan_tasks_pvt.g_plan_task_types(i) := wms_waveplan_tasks_pvt.g_plan_task_types(i);
2862: END LOOP;
2863: END IF;
2864:

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

2857: END IF;
2858:
2859: IF wms_waveplan_tasks_pvt.g_plan_task_types.count > 0 THEN
2860: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types.count LOOP
2861: wms_plan_tasks_pvt.g_plan_task_types(i) := wms_waveplan_tasks_pvt.g_plan_task_types(i);
2862: END LOOP;
2863: END IF;
2864:
2865: IF wms_waveplan_tasks_pvt.g_plan_task_types_orig.count > 0 THEN

Line 2865: IF wms_waveplan_tasks_pvt.g_plan_task_types_orig.count > 0 THEN

2861: wms_plan_tasks_pvt.g_plan_task_types(i) := wms_waveplan_tasks_pvt.g_plan_task_types(i);
2862: END LOOP;
2863: END IF;
2864:
2865: IF wms_waveplan_tasks_pvt.g_plan_task_types_orig.count > 0 THEN
2866: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types_orig.count LOOP
2867: wms_plan_tasks_pvt.g_plan_task_types_orig(i) := wms_waveplan_tasks_pvt.g_plan_task_types_orig(i);
2868: END LOOP;
2869: END IF;

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

2862: END LOOP;
2863: END IF;
2864:
2865: IF wms_waveplan_tasks_pvt.g_plan_task_types_orig.count > 0 THEN
2866: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types_orig.count LOOP
2867: wms_plan_tasks_pvt.g_plan_task_types_orig(i) := wms_waveplan_tasks_pvt.g_plan_task_types_orig(i);
2868: END LOOP;
2869: END IF;
2870:

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

2863: END IF;
2864:
2865: IF wms_waveplan_tasks_pvt.g_plan_task_types_orig.count > 0 THEN
2866: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_task_types_orig.count LOOP
2867: wms_plan_tasks_pvt.g_plan_task_types_orig(i) := wms_waveplan_tasks_pvt.g_plan_task_types_orig(i);
2868: END LOOP;
2869: END IF;
2870:
2871: IF wms_waveplan_tasks_pvt.g_plan_status_codes.count > 0 THEN

Line 2871: IF wms_waveplan_tasks_pvt.g_plan_status_codes.count > 0 THEN

2867: wms_plan_tasks_pvt.g_plan_task_types_orig(i) := wms_waveplan_tasks_pvt.g_plan_task_types_orig(i);
2868: END LOOP;
2869: END IF;
2870:
2871: IF wms_waveplan_tasks_pvt.g_plan_status_codes.count > 0 THEN
2872: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes.count LOOP
2873: wms_plan_tasks_pvt.g_plan_status_codes(i) := wms_waveplan_tasks_pvt.g_plan_status_codes(i);
2874: END LOOP;
2875: END IF;

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

2868: END LOOP;
2869: END IF;
2870:
2871: IF wms_waveplan_tasks_pvt.g_plan_status_codes.count > 0 THEN
2872: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes.count LOOP
2873: wms_plan_tasks_pvt.g_plan_status_codes(i) := wms_waveplan_tasks_pvt.g_plan_status_codes(i);
2874: END LOOP;
2875: END IF;
2876:

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

2869: END IF;
2870:
2871: IF wms_waveplan_tasks_pvt.g_plan_status_codes.count > 0 THEN
2872: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes.count LOOP
2873: wms_plan_tasks_pvt.g_plan_status_codes(i) := wms_waveplan_tasks_pvt.g_plan_status_codes(i);
2874: END LOOP;
2875: END IF;
2876:
2877: IF wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count > 0 THEN

Line 2877: IF wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count > 0 THEN

2873: wms_plan_tasks_pvt.g_plan_status_codes(i) := wms_waveplan_tasks_pvt.g_plan_status_codes(i);
2874: END LOOP;
2875: END IF;
2876:
2877: IF wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count > 0 THEN
2878: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count LOOP
2879: wms_plan_tasks_pvt.g_plan_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_plan_status_codes_orig(i);
2880: END LOOP;
2881: END IF;

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

2874: END LOOP;
2875: END IF;
2876:
2877: IF wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count > 0 THEN
2878: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count LOOP
2879: wms_plan_tasks_pvt.g_plan_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_plan_status_codes_orig(i);
2880: END LOOP;
2881: END IF;
2882: */

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

2875: END IF;
2876:
2877: IF wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count > 0 THEN
2878: FOR i IN 1..wms_waveplan_tasks_pvt.g_plan_status_codes_orig.count LOOP
2879: wms_plan_tasks_pvt.g_plan_status_codes_orig(i) := wms_waveplan_tasks_pvt.g_plan_status_codes_orig(i);
2880: END LOOP;
2881: END IF;
2882: */
2883:

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

2880: END LOOP;
2881: END IF;
2882: */
2883:
2884: wms_plan_tasks_pvt.g_task_types := wms_waveplan_tasks_pvt.g_task_types;
2885: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;
2886: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2887: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2888: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;

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

2881: END IF;
2882: */
2883:
2884: wms_plan_tasks_pvt.g_task_types := wms_waveplan_tasks_pvt.g_task_types;
2885: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;
2886: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2887: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2888: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2889: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;

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

2882: */
2883:
2884: wms_plan_tasks_pvt.g_task_types := wms_waveplan_tasks_pvt.g_task_types;
2885: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;
2886: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2887: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2888: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2889: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2890: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;

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

2883:
2884: wms_plan_tasks_pvt.g_task_types := wms_waveplan_tasks_pvt.g_task_types;
2885: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;
2886: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2887: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2888: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2889: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2890: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;
2891: wms_plan_tasks_pvt.g_plan_status_codes_orig := wms_waveplan_tasks_pvt.g_plan_status_codes_orig;

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

2884: wms_plan_tasks_pvt.g_task_types := wms_waveplan_tasks_pvt.g_task_types;
2885: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;
2886: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2887: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2888: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2889: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2890: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;
2891: wms_plan_tasks_pvt.g_plan_status_codes_orig := wms_waveplan_tasks_pvt.g_plan_status_codes_orig;
2892:

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

2885: wms_plan_tasks_pvt.g_task_types_orig := wms_waveplan_tasks_pvt.g_task_types_orig;
2886: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2887: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2888: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2889: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2890: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;
2891: wms_plan_tasks_pvt.g_plan_status_codes_orig := wms_waveplan_tasks_pvt.g_plan_status_codes_orig;
2892:
2893: wms_plan_tasks_pvt.g_plans_tasks_record_count := 0;

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

2886: wms_plan_tasks_pvt.g_status_codes := wms_waveplan_tasks_pvt.g_status_codes;
2887: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2888: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2889: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2890: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;
2891: wms_plan_tasks_pvt.g_plan_status_codes_orig := wms_waveplan_tasks_pvt.g_plan_status_codes_orig;
2892:
2893: wms_plan_tasks_pvt.g_plans_tasks_record_count := 0;
2894:

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

2887: wms_plan_tasks_pvt.g_status_codes_orig := wms_waveplan_tasks_pvt.g_status_codes_orig;
2888: wms_plan_tasks_pvt.g_plan_task_types := wms_waveplan_tasks_pvt.g_plan_task_types;
2889: wms_plan_tasks_pvt.g_plan_task_types_orig := wms_waveplan_tasks_pvt.g_plan_task_types_orig;
2890: wms_plan_tasks_pvt.g_plan_status_codes := wms_waveplan_tasks_pvt.g_plan_status_codes;
2891: wms_plan_tasks_pvt.g_plan_status_codes_orig := wms_waveplan_tasks_pvt.g_plan_status_codes_orig;
2892:
2893: wms_plan_tasks_pvt.g_plans_tasks_record_count := 0;
2894:
2895: END set_globals;