eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on WMS_WAVEPLAN_TASKS_TEMP

Line 6: g_task_updated wms_waveplan_tasks_temp.error%TYPE;

2: /* $Header: WMSVTKPB.pls 120.66.12020000.12 2013/03/26 13:02:18 pyerrams ship $ */
3: --
4: g_record_count NUMBER;
5: -- Messages
6: g_task_updated wms_waveplan_tasks_temp.error%TYPE;
7: g_task_saved wms_waveplan_tasks_temp.error%TYPE;
8: g_cannot_update_putaway wms_waveplan_tasks_temp.error%TYPE;
9: g_cannot_update_staging_move wms_waveplan_tasks_temp.error%TYPE;
10: g_cannot_unrelease_cc wms_waveplan_tasks_temp.error%TYPE;

Line 7: g_task_saved wms_waveplan_tasks_temp.error%TYPE;

3: --
4: g_record_count NUMBER;
5: -- Messages
6: g_task_updated wms_waveplan_tasks_temp.error%TYPE;
7: g_task_saved wms_waveplan_tasks_temp.error%TYPE;
8: g_cannot_update_putaway wms_waveplan_tasks_temp.error%TYPE;
9: g_cannot_update_staging_move wms_waveplan_tasks_temp.error%TYPE;
10: g_cannot_unrelease_cc wms_waveplan_tasks_temp.error%TYPE;
11: g_summarized_time wms_waveplan_tasks_temp.error%TYPE;

Line 8: g_cannot_update_putaway wms_waveplan_tasks_temp.error%TYPE;

4: g_record_count NUMBER;
5: -- Messages
6: g_task_updated wms_waveplan_tasks_temp.error%TYPE;
7: g_task_saved wms_waveplan_tasks_temp.error%TYPE;
8: g_cannot_update_putaway wms_waveplan_tasks_temp.error%TYPE;
9: g_cannot_update_staging_move wms_waveplan_tasks_temp.error%TYPE;
10: g_cannot_unrelease_cc wms_waveplan_tasks_temp.error%TYPE;
11: g_summarized_time wms_waveplan_tasks_temp.error%TYPE;
12: g_cannot_summarize_time wms_waveplan_tasks_temp.error%TYPE;

Line 9: g_cannot_update_staging_move wms_waveplan_tasks_temp.error%TYPE;

5: -- Messages
6: g_task_updated wms_waveplan_tasks_temp.error%TYPE;
7: g_task_saved wms_waveplan_tasks_temp.error%TYPE;
8: g_cannot_update_putaway wms_waveplan_tasks_temp.error%TYPE;
9: g_cannot_update_staging_move wms_waveplan_tasks_temp.error%TYPE;
10: g_cannot_unrelease_cc wms_waveplan_tasks_temp.error%TYPE;
11: g_summarized_time wms_waveplan_tasks_temp.error%TYPE;
12: g_cannot_summarize_time wms_waveplan_tasks_temp.error%TYPE;
13: g_time_uom_error wms_waveplan_tasks_temp.error%TYPE;

Line 10: g_cannot_unrelease_cc wms_waveplan_tasks_temp.error%TYPE;

6: g_task_updated wms_waveplan_tasks_temp.error%TYPE;
7: g_task_saved wms_waveplan_tasks_temp.error%TYPE;
8: g_cannot_update_putaway wms_waveplan_tasks_temp.error%TYPE;
9: g_cannot_update_staging_move wms_waveplan_tasks_temp.error%TYPE;
10: g_cannot_unrelease_cc wms_waveplan_tasks_temp.error%TYPE;
11: g_summarized_time wms_waveplan_tasks_temp.error%TYPE;
12: g_cannot_summarize_time wms_waveplan_tasks_temp.error%TYPE;
13: g_time_uom_error wms_waveplan_tasks_temp.error%TYPE;
14: g_summarized_volume wms_waveplan_tasks_temp.error%TYPE;

Line 11: g_summarized_time wms_waveplan_tasks_temp.error%TYPE;

7: g_task_saved wms_waveplan_tasks_temp.error%TYPE;
8: g_cannot_update_putaway wms_waveplan_tasks_temp.error%TYPE;
9: g_cannot_update_staging_move wms_waveplan_tasks_temp.error%TYPE;
10: g_cannot_unrelease_cc wms_waveplan_tasks_temp.error%TYPE;
11: g_summarized_time wms_waveplan_tasks_temp.error%TYPE;
12: g_cannot_summarize_time wms_waveplan_tasks_temp.error%TYPE;
13: g_time_uom_error wms_waveplan_tasks_temp.error%TYPE;
14: g_summarized_volume wms_waveplan_tasks_temp.error%TYPE;
15: g_cannot_summarize_vol wms_waveplan_tasks_temp.error%TYPE;

Line 12: g_cannot_summarize_time wms_waveplan_tasks_temp.error%TYPE;

8: g_cannot_update_putaway wms_waveplan_tasks_temp.error%TYPE;
9: g_cannot_update_staging_move wms_waveplan_tasks_temp.error%TYPE;
10: g_cannot_unrelease_cc wms_waveplan_tasks_temp.error%TYPE;
11: g_summarized_time wms_waveplan_tasks_temp.error%TYPE;
12: g_cannot_summarize_time wms_waveplan_tasks_temp.error%TYPE;
13: g_time_uom_error wms_waveplan_tasks_temp.error%TYPE;
14: g_summarized_volume wms_waveplan_tasks_temp.error%TYPE;
15: g_cannot_summarize_vol wms_waveplan_tasks_temp.error%TYPE;
16: g_vol_uom_error wms_waveplan_tasks_temp.error%TYPE;

Line 13: g_time_uom_error wms_waveplan_tasks_temp.error%TYPE;

9: g_cannot_update_staging_move wms_waveplan_tasks_temp.error%TYPE;
10: g_cannot_unrelease_cc wms_waveplan_tasks_temp.error%TYPE;
11: g_summarized_time wms_waveplan_tasks_temp.error%TYPE;
12: g_cannot_summarize_time wms_waveplan_tasks_temp.error%TYPE;
13: g_time_uom_error wms_waveplan_tasks_temp.error%TYPE;
14: g_summarized_volume wms_waveplan_tasks_temp.error%TYPE;
15: g_cannot_summarize_vol wms_waveplan_tasks_temp.error%TYPE;
16: g_vol_uom_error wms_waveplan_tasks_temp.error%TYPE;
17: g_no_item_vol wms_waveplan_tasks_temp.error%TYPE;

Line 14: g_summarized_volume wms_waveplan_tasks_temp.error%TYPE;

10: g_cannot_unrelease_cc wms_waveplan_tasks_temp.error%TYPE;
11: g_summarized_time wms_waveplan_tasks_temp.error%TYPE;
12: g_cannot_summarize_time wms_waveplan_tasks_temp.error%TYPE;
13: g_time_uom_error wms_waveplan_tasks_temp.error%TYPE;
14: g_summarized_volume wms_waveplan_tasks_temp.error%TYPE;
15: g_cannot_summarize_vol wms_waveplan_tasks_temp.error%TYPE;
16: g_vol_uom_error wms_waveplan_tasks_temp.error%TYPE;
17: g_no_item_vol wms_waveplan_tasks_temp.error%TYPE;
18: g_summarized_weight wms_waveplan_tasks_temp.error%TYPE;

Line 15: g_cannot_summarize_vol wms_waveplan_tasks_temp.error%TYPE;

11: g_summarized_time wms_waveplan_tasks_temp.error%TYPE;
12: g_cannot_summarize_time wms_waveplan_tasks_temp.error%TYPE;
13: g_time_uom_error wms_waveplan_tasks_temp.error%TYPE;
14: g_summarized_volume wms_waveplan_tasks_temp.error%TYPE;
15: g_cannot_summarize_vol wms_waveplan_tasks_temp.error%TYPE;
16: g_vol_uom_error wms_waveplan_tasks_temp.error%TYPE;
17: g_no_item_vol wms_waveplan_tasks_temp.error%TYPE;
18: g_summarized_weight wms_waveplan_tasks_temp.error%TYPE;
19: g_cannot_summarize_wt wms_waveplan_tasks_temp.error%TYPE;

Line 16: g_vol_uom_error wms_waveplan_tasks_temp.error%TYPE;

12: g_cannot_summarize_time wms_waveplan_tasks_temp.error%TYPE;
13: g_time_uom_error wms_waveplan_tasks_temp.error%TYPE;
14: g_summarized_volume wms_waveplan_tasks_temp.error%TYPE;
15: g_cannot_summarize_vol wms_waveplan_tasks_temp.error%TYPE;
16: g_vol_uom_error wms_waveplan_tasks_temp.error%TYPE;
17: g_no_item_vol wms_waveplan_tasks_temp.error%TYPE;
18: g_summarized_weight wms_waveplan_tasks_temp.error%TYPE;
19: g_cannot_summarize_wt wms_waveplan_tasks_temp.error%TYPE;
20: g_wt_uom_error wms_waveplan_tasks_temp.error%TYPE;

Line 17: g_no_item_vol wms_waveplan_tasks_temp.error%TYPE;

13: g_time_uom_error wms_waveplan_tasks_temp.error%TYPE;
14: g_summarized_volume wms_waveplan_tasks_temp.error%TYPE;
15: g_cannot_summarize_vol wms_waveplan_tasks_temp.error%TYPE;
16: g_vol_uom_error wms_waveplan_tasks_temp.error%TYPE;
17: g_no_item_vol wms_waveplan_tasks_temp.error%TYPE;
18: g_summarized_weight wms_waveplan_tasks_temp.error%TYPE;
19: g_cannot_summarize_wt wms_waveplan_tasks_temp.error%TYPE;
20: g_wt_uom_error wms_waveplan_tasks_temp.error%TYPE;
21: g_no_item_wt wms_waveplan_tasks_temp.error%TYPE;

Line 18: g_summarized_weight wms_waveplan_tasks_temp.error%TYPE;

14: g_summarized_volume wms_waveplan_tasks_temp.error%TYPE;
15: g_cannot_summarize_vol wms_waveplan_tasks_temp.error%TYPE;
16: g_vol_uom_error wms_waveplan_tasks_temp.error%TYPE;
17: g_no_item_vol wms_waveplan_tasks_temp.error%TYPE;
18: g_summarized_weight wms_waveplan_tasks_temp.error%TYPE;
19: g_cannot_summarize_wt wms_waveplan_tasks_temp.error%TYPE;
20: g_wt_uom_error wms_waveplan_tasks_temp.error%TYPE;
21: g_no_item_wt wms_waveplan_tasks_temp.error%TYPE;
22: g_plan_cancelled wms_waveplan_tasks_temp.error%TYPE;

Line 19: g_cannot_summarize_wt wms_waveplan_tasks_temp.error%TYPE;

15: g_cannot_summarize_vol wms_waveplan_tasks_temp.error%TYPE;
16: g_vol_uom_error wms_waveplan_tasks_temp.error%TYPE;
17: g_no_item_vol wms_waveplan_tasks_temp.error%TYPE;
18: g_summarized_weight wms_waveplan_tasks_temp.error%TYPE;
19: g_cannot_summarize_wt wms_waveplan_tasks_temp.error%TYPE;
20: g_wt_uom_error wms_waveplan_tasks_temp.error%TYPE;
21: g_no_item_wt wms_waveplan_tasks_temp.error%TYPE;
22: g_plan_cancelled wms_waveplan_tasks_temp.error%TYPE;
23: -- Global variables to determine if a column is visible or not

Line 20: g_wt_uom_error wms_waveplan_tasks_temp.error%TYPE;

16: g_vol_uom_error wms_waveplan_tasks_temp.error%TYPE;
17: g_no_item_vol wms_waveplan_tasks_temp.error%TYPE;
18: g_summarized_weight wms_waveplan_tasks_temp.error%TYPE;
19: g_cannot_summarize_wt wms_waveplan_tasks_temp.error%TYPE;
20: g_wt_uom_error wms_waveplan_tasks_temp.error%TYPE;
21: g_no_item_wt wms_waveplan_tasks_temp.error%TYPE;
22: g_plan_cancelled wms_waveplan_tasks_temp.error%TYPE;
23: -- Global variables to determine if a column is visible or not
24: g_allocated_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;

Line 21: g_no_item_wt wms_waveplan_tasks_temp.error%TYPE;

17: g_no_item_vol wms_waveplan_tasks_temp.error%TYPE;
18: g_summarized_weight wms_waveplan_tasks_temp.error%TYPE;
19: g_cannot_summarize_wt wms_waveplan_tasks_temp.error%TYPE;
20: g_wt_uom_error wms_waveplan_tasks_temp.error%TYPE;
21: g_no_item_wt wms_waveplan_tasks_temp.error%TYPE;
22: g_plan_cancelled wms_waveplan_tasks_temp.error%TYPE;
23: -- Global variables to determine if a column is visible or not
24: g_allocated_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
25: g_assembly_visible jtf_custom_grid_cols.visible_flag%TYPE;

Line 22: g_plan_cancelled wms_waveplan_tasks_temp.error%TYPE;

18: g_summarized_weight wms_waveplan_tasks_temp.error%TYPE;
19: g_cannot_summarize_wt wms_waveplan_tasks_temp.error%TYPE;
20: g_wt_uom_error wms_waveplan_tasks_temp.error%TYPE;
21: g_no_item_wt wms_waveplan_tasks_temp.error%TYPE;
22: g_plan_cancelled wms_waveplan_tasks_temp.error%TYPE;
23: -- Global variables to determine if a column is visible or not
24: g_allocated_lpn_visible jtf_custom_grid_cols.visible_flag%TYPE;
25: g_assembly_visible jtf_custom_grid_cols.visible_flag%TYPE;
26: g_carrier_visible jtf_custom_grid_cols.visible_flag%TYPE;

Line 98: FROM wms_waveplan_tasks_temp

94: IS
95: SELECT transaction_temp_id, task_id, is_modified, status_id,
96: status_id_original, person_id, person_id_original, priority,
97: priority_original
98: FROM wms_waveplan_tasks_temp
99: WHERE is_modified = 'Y';
100: BEGIN
101: IF l_debug = 1 then
102: FOR rec_wwtt IN cur_wwtt

Line 127: UPDATE wms_waveplan_tasks_temp

123: IS
124: BEGIN
125: x_return_status := 'S';
126: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
127: UPDATE wms_waveplan_tasks_temp
128: SET RESULT = DECODE (RESULT, NULL, 'X', 'S', 'Y', 'E', 'Z')
129: WHERE transaction_temp_id = p_transaction_temp_id (i)
130: AND task_type_id = p_task_type_id (i);
131: g_rows_marked := TRUE;

Line 144: UPDATE wms_waveplan_tasks_temp

140: IS
141: BEGIN
142: IF g_rows_marked
143: THEN
144: UPDATE wms_waveplan_tasks_temp
145: SET RESULT =
146: DECODE (RESULT,
147: 'Y', 'S',
148: 'Z', 'E',

Line 348: UPDATE wms_waveplan_tasks_temp wwtt

344: END IF;
345:
346: IF g_project_enabled_organization = 'Y'
347: THEN
348: UPDATE wms_waveplan_tasks_temp wwtt
349: SET LOCATOR =
350: inv_project.get_locator (wwtt.locator_id,
351: wwtt.organization_id
352: )

Line 357: UPDATE wms_waveplan_tasks_temp wwtt

353: WHERE LOCATOR IS NULL;
354:
355: IF g_to_locator_visible = 'T'
356: THEN
357: UPDATE wms_waveplan_tasks_temp wwtt
358: SET to_locator =
359: inv_project.get_locator (wwtt.to_locator_id,
360: wwtt.organization_id
361: )

Line 369: TYPE source_header_type IS TABLE OF wms_waveplan_tasks_temp.source_header%TYPE;

365: END;
366:
367: PROCEDURE set_inbound_source_header_line
368: IS
369: TYPE source_header_type IS TABLE OF wms_waveplan_tasks_temp.source_header%TYPE;
370:
371: TYPE line_number_type IS TABLE OF wms_waveplan_tasks_temp.line_number%TYPE;
372:
373: TYPE temp_id_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE;

Line 371: TYPE line_number_type IS TABLE OF wms_waveplan_tasks_temp.line_number%TYPE;

367: PROCEDURE set_inbound_source_header_line
368: IS
369: TYPE source_header_type IS TABLE OF wms_waveplan_tasks_temp.source_header%TYPE;
370:
371: TYPE line_number_type IS TABLE OF wms_waveplan_tasks_temp.line_number%TYPE;
372:
373: TYPE temp_id_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE;
374:
375: TYPE task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE;

Line 373: TYPE temp_id_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE;

369: TYPE source_header_type IS TABLE OF wms_waveplan_tasks_temp.source_header%TYPE;
370:
371: TYPE line_number_type IS TABLE OF wms_waveplan_tasks_temp.line_number%TYPE;
372:
373: TYPE temp_id_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE;
374:
375: TYPE task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE;
376:
377: l_source_header source_header_type;

Line 375: TYPE task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE;

371: TYPE line_number_type IS TABLE OF wms_waveplan_tasks_temp.line_number%TYPE;
372:
373: TYPE temp_id_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE;
374:
375: TYPE task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE;
376:
377: l_source_header source_header_type;
378: l_line_number line_number_type;
379: l_temp_id temp_id_type;

Line 389: wms_waveplan_tasks_temp wwtt

385: l_task_type_id
386: FROM po_line_locations_trx_v pll,--CLM Changes, using CLM views instead of base tables
387: po_headers_trx_v ph,
388: po_lines_trx_v pl,
389: wms_waveplan_tasks_temp wwtt
390: WHERE pll.line_location_id = wwtt.reference_id
391: AND pll.po_line_id = pl.po_line_id
392: AND ph.po_header_id = pl.po_header_id
393: AND wwtt.REFERENCE = 'PO_LINE_LOCATION_ID'

Line 400: UPDATE wms_waveplan_tasks_temp wwtt

396:
397: IF l_temp_id.COUNT > 0
398: THEN
399: FORALL i IN l_temp_id.FIRST .. l_temp_id.LAST
400: UPDATE wms_waveplan_tasks_temp wwtt
401: SET source_header = l_source_header (i),
402: line_number = l_line_number (i)
403: WHERE wwtt.transaction_temp_id = l_temp_id (i)
404: AND wwtt.task_type_id = l_task_type_id (i);

Line 413: wms_waveplan_tasks_temp wwtt

409: BULK COLLECT INTO l_source_header, l_line_number, l_temp_id,
410: l_task_type_id
411: FROM oe_order_lines_all ool,
412: oe_order_headers_all ooh,
413: wms_waveplan_tasks_temp wwtt
414: WHERE ool.line_id = wwtt.reference_id
415: AND ooh.header_id = ool.header_id
416: AND wwtt.REFERENCE = 'ORDER_LINE_ID'
417: AND wwtt.source_header IS NULL

Line 423: UPDATE wms_waveplan_tasks_temp wwtt

419:
420: IF l_temp_id.COUNT > 0
421: THEN
422: FORALL i IN l_temp_id.FIRST .. l_temp_id.LAST
423: UPDATE wms_waveplan_tasks_temp wwtt
424: SET source_header = l_source_header (i),
425: line_number = l_line_number (i)
426: WHERE wwtt.transaction_temp_id = l_temp_id (i)
427: AND wwtt.task_type_id = l_task_type_id (i);

Line 448: wms_waveplan_tasks_temp wwtt

444: FROM po_requisition_headers_all prh,
445: po_requisition_lines_all prl,
446: rcv_shipment_lines rsl,
447: rcv_shipment_headers rsh,
448: wms_waveplan_tasks_temp wwtt
449: WHERE rsl.shipment_line_id = wwtt.reference_id
450: AND prh.requisition_header_id(+) = prl.requisition_header_id
451: AND rsl.requisition_line_id = prl.requisition_line_id(+)
452: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 460: UPDATE wms_waveplan_tasks_temp wwtt

456:
457: IF l_temp_id.COUNT > 0
458: THEN
459: FORALL i IN l_temp_id.FIRST .. l_temp_id.LAST
460: UPDATE wms_waveplan_tasks_temp wwtt
461: SET source_header = l_source_header (i),
462: line_number = l_line_number (i)
463: WHERE wwtt.transaction_temp_id = l_temp_id (i)
464: AND wwtt.task_type_id = l_task_type_id (i);

Line 477: TYPE num_of_child_tasks_type IS TABLE OF wms_waveplan_tasks_temp.num_of_child_tasks%TYPE;

473: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
474: l_progress NUMBER;
475: l_count_same_sku_cc_tasks NUMBER := 0;
476:
477: TYPE num_of_child_tasks_type IS TABLE OF wms_waveplan_tasks_temp.num_of_child_tasks%TYPE;
478: l_num_of_child_tasks_tbl num_of_child_tasks_type;
479: l_parent_temp_ids_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
480:
481: BEGIN

Line 496: FROM wms_waveplan_tasks_temp wwtt,mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

492: --MMTT used to get children task.
493: --wwtt used to get the parent task.
494: SELECT COUNT (1), wwtt.transaction_temp_id
495: BULK COLLECT INTO l_num_of_child_tasks_tbl, l_parent_temp_ids_tbl
496: FROM wms_waveplan_tasks_temp wwtt,mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
497: WHERE mcce.cycle_count_header_id = mcch.cycle_count_header_id
498: AND mcce.inventory_item_id = wwtt.inventory_item_id
499: AND mcce.subinventory = wwtt.subinventory
500: AND mcce.locator_id = wwtt.locator_id

Line 519: UPDATE wms_waveplan_tasks_temp wwtt

515: IF l_num_of_child_tasks_tbl.COUNT > 0
516: THEN
517: l_progress := 30;
518: FORALL i IN l_num_of_child_tasks_tbl.FIRST .. l_num_of_child_tasks_tbl.LAST
519: UPDATE wms_waveplan_tasks_temp wwtt
520: SET wwtt.num_of_child_tasks = l_num_of_child_tasks_tbl (i)
521: WHERE wwtt.transaction_temp_id = l_parent_temp_ids_tbl (i)
522: AND l_num_of_child_tasks_tbl (i) <> 1;
523: l_progress := 40;

Line 564: TYPE num_of_child_tasks_type IS TABLE OF wms_waveplan_tasks_temp.num_of_child_tasks%TYPE;

560: l_debug NUMBER
561: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
562: l_progress NUMBER;
563:
564: TYPE num_of_child_tasks_type IS TABLE OF wms_waveplan_tasks_temp.num_of_child_tasks%TYPE;
565:
566: l_num_of_child_tasks_tbl num_of_child_tasks_type;
567: l_parent_temp_ids_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
568: BEGIN

Line 583: FROM wms_waveplan_tasks_temp wwtt,

579: --MMTT used to get children task.
580: --wwtt used to get the parent task.
581: SELECT COUNT (1), wwtt.transaction_temp_id
582: BULK COLLECT INTO l_num_of_child_tasks_tbl, l_parent_temp_ids_tbl
583: FROM wms_waveplan_tasks_temp wwtt,
584: mtl_material_transactions_temp mmtt
585: WHERE wwtt.transaction_temp_id = mmtt.parent_line_id
586: AND wwtt.transaction_temp_id <> mmtt.transaction_temp_id
587: GROUP BY wwtt.transaction_temp_id;

Line 595: UPDATE wms_waveplan_tasks_temp wwtt

591: IF l_num_of_child_tasks_tbl.COUNT > 0
592: THEN
593: l_progress := 30;
594: FORALL i IN l_num_of_child_tasks_tbl.FIRST .. l_num_of_child_tasks_tbl.LAST
595: UPDATE wms_waveplan_tasks_temp wwtt
596: SET wwtt.num_of_child_tasks = l_num_of_child_tasks_tbl (i)
597: WHERE wwtt.transaction_temp_id = l_parent_temp_ids_tbl (i);
598: l_progress := 40;
599: END IF;

Line 655: UPDATE wms_waveplan_tasks_temp

651: IF g_picked_lpn_visible = 'T' OR g_loaded_lpn_visible = 'T' OR g_drop_lpn_visible = 'T' THEN
652:
653: /* commented for bug 14535546 and modified loaded_lpn_id
654:
655: UPDATE wms_waveplan_tasks_temp
656: -- transfer_lpn_id would be null if it is loaded into the same lpn as that of picked.
657: SET picked_lpn_id = NVL(content_lpn_id,from_lpn_id), /*12984304 Changed the order in NVL * /
658: loaded_lpn_id = Nvl(to_lpn_id, Nvl(content_lpn_id,from_lpn_id))/*12984304 Changed the order in NVL * /
659: WHERE task_type_id IN (1, 4, 5, 6)

Line 663: UPDATE wms_waveplan_tasks_temp wwtt

659: WHERE task_type_id IN (1, 4, 5, 6)
660: AND status_id = 6;
661:
662: */
663: UPDATE wms_waveplan_tasks_temp wwtt
664: -- transfer_lpn_id would be null if it is loaded into the same lpn as that of picked.
665: SET wwtt.picked_lpn_id = NVL(wwtt.content_lpn_id,wwtt.from_lpn_id), /*12984304 Changed the order in NVL */
666: wwtt.loaded_lpn_id = NVL((select transfer_lpn_id from wms_dispatched_tasks_history wdth where wdth.task_id = wwtt.task_id),
667: NVL(wwtt.to_lpn_id, NVL(wwtt.content_lpn_id, wwtt.from_lpn_id)))

Line 674: UPDATE wms_waveplan_tasks_temp

670:
671: END IF;
672:
673: IF g_picked_lpn_visible = 'T' THEN
674: UPDATE wms_waveplan_tasks_temp
675: SET picked_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = picked_lpn_id)
676: WHERE picked_lpn_id IS NOT NULL
677: AND task_type_id IN (1, 4, 5, 6)
678: AND status_id = 6;

Line 682: UPDATE wms_waveplan_tasks_temp

678: AND status_id = 6;
679: END IF;
680:
681: IF g_loaded_lpn_visible = 'T' THEN
682: UPDATE wms_waveplan_tasks_temp
683: SET loaded_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = loaded_lpn_id)
684: WHERE loaded_lpn_id IS NOT NULL
685: AND task_type_id IN (1, 4, 5, 6)
686: AND status_id = 6;

Line 690: UPDATE wms_waveplan_tasks_temp wstt

686: AND status_id = 6;
687: END IF;
688:
689: IF g_drop_lpn_visible = 'T' THEN
690: UPDATE wms_waveplan_tasks_temp wstt
691: SET drop_lpn = Nvl((select license_plate_number
692: FROM wms_license_plate_numbers wlpn, mtl_material_transactions mmt
693: WHERE wlpn.lpn_id = mmt.transfer_lpn_id
694: AND mmt.transaction_action_id = 50

Line 706: UPDATE wms_waveplan_tasks_temp

702:
703: IF p_is_loaded THEN
704: -- Loaded Tasks
705: IF g_picked_lpn_visible = 'T' OR g_loaded_lpn_visible = 'T' THEN
706: UPDATE wms_waveplan_tasks_temp
707: -- transfer_lpn_id would be null if it is loaded into the same lpn as that of picked.
708: SET picked_lpn_id = NVL(content_lpn_id,from_lpn_id), /*12984304 Changed the order in NVL*/
709: loaded_lpn_id = to_lpn_id
710: WHERE task_type_id IN (1, 4, 5, 6)

Line 715: UPDATE wms_waveplan_tasks_temp

711: AND status_id = 4;
712: END IF;
713:
714: IF g_picked_lpn_visible = 'T' THEN
715: UPDATE wms_waveplan_tasks_temp
716: SET picked_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = picked_lpn_id)
717: WHERE picked_lpn_id IS NOT NULL
718: AND task_type_id IN (1, 4, 5, 6)
719: AND status_id = 4;

Line 723: UPDATE wms_waveplan_tasks_temp

719: AND status_id = 4;
720: END IF;
721:
722: IF g_loaded_lpn_visible = 'T' THEN
723: UPDATE wms_waveplan_tasks_temp
724: SET loaded_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = loaded_lpn_id)
725: WHERE loaded_lpn_id IS NOT NULL
726: AND task_type_id IN (1, 4, 5, 6)
727: AND status_id = 4;

Line 772: l_insert_generic := 'INSERT INTO wms_waveplan_tasks_temp( ';

768: -- Query records present both in MMTT and WDT
769: l_join_wdt := TRUE;
770: END IF;
771:
772: l_insert_generic := 'INSERT INTO wms_waveplan_tasks_temp( ';
773: /* Patchset J - ATF - we have to insert expansion_code, plans_tasks also
774: * into the temp table
775: */
776: l_insert_generic := l_insert_generic || 'expansion_code';

Line 2275: || ', (select distinct parent_line_id from wms_waveplan_tasks_temp where task_type_id <> 3) wwtt';

2271: IF p_populate_merged_tasks
2272: THEN
2273: l_from_generic :=
2274: l_from_generic
2275: || ', (select distinct parent_line_id from wms_waveplan_tasks_temp where task_type_id <> 3) wwtt';
2276: END IF;
2277:
2278: -- l_from_generic := l_from_generic || ', mtl_system_items_kfv msiv ';
2279: l_from_generic := l_from_generic || ', mtl_system_items_vl msiv '; --Bug 11798973 Modified to fetch translated value

Line 2441: 'WHERE NOT exists (SELECT 1 FROM wms_waveplan_tasks_temp ';

2437: -- Build the generic where section of the query
2438: IF p_add
2439: THEN
2440: l_where_generic :=
2441: 'WHERE NOT exists (SELECT 1 FROM wms_waveplan_tasks_temp ';
2442: l_where_generic :=
2443: l_where_generic
2444: || 'WHERE transaction_temp_id = mmtt.transaction_temp_id ';
2445: l_where_generic := l_where_generic || 'AND task_type_id <> 3) ';

Line 3032: 'WHERE NOT exists (SELECT 1 FROM wms_waveplan_tasks_temp ';

3028: THEN
3029: IF p_add
3030: THEN
3031: l_where_generic :=
3032: 'WHERE NOT exists (SELECT 1 FROM wms_waveplan_tasks_temp ';
3033: l_where_generic :=
3034: l_where_generic
3035: || 'WHERE transaction_temp_id = mmt.transaction_id) ';
3036: ELSE

Line 3439: 'WHERE NOT exists (SELECT 1 FROM wms_waveplan_tasks_temp ';

3435: --completed children.
3436: IF p_add
3437: THEN
3438: l_where_generic :=
3439: 'WHERE NOT exists (SELECT 1 FROM wms_waveplan_tasks_temp ';
3440: l_where_generic :=
3441: l_where_generic
3442: || 'WHERE transaction_temp_id = wdth.transaction_id) ';
3443: ELSE

Line 3796: DELETE FROM wms_waveplan_tasks_temp

3792: RETURN;
3793: END IF;
3794:
3795: -- Delete all the parent records that have been queries up
3796: DELETE FROM wms_waveplan_tasks_temp
3797: WHERE task_type_id <> 3
3798: AND transaction_temp_id IN (
3799: SELECT parent_line_id
3800: FROM wms_waveplan_tasks_temp

Line 3800: FROM wms_waveplan_tasks_temp

3796: DELETE FROM wms_waveplan_tasks_temp
3797: WHERE task_type_id <> 3
3798: AND transaction_temp_id IN (
3799: SELECT parent_line_id
3800: FROM wms_waveplan_tasks_temp
3801: WHERE parent_line_id IS NOT NULL
3802: AND task_type_id <> 3
3803: --Change
3804: --Check for outbound and wip tasks below

Line 3826: FROM wms_waveplan_tasks_temp

3822: INTO l_query_count
3823: FROM DUAL
3824: WHERE EXISTS (
3825: SELECT parent_line_id
3826: FROM wms_waveplan_tasks_temp
3827: WHERE parent_line_id IS NOT NULL
3828: AND task_type_id <> 3
3829: --Change
3830: --check for outbound and wip tasks below

Line 4003: DELETE FROM wms_waveplan_tasks_temp

3999: -- Delete the child tasks from the temp table
4000: --Bulk Picking Enhancement:
4001: --Added the condition status_id <> 6 because we want to show
4002: --completed children associated with a partially completed(Active) parent
4003: DELETE FROM wms_waveplan_tasks_temp
4004: WHERE parent_line_id IS NOT NULL
4005: AND status_id <> 6
4006: --Change
4007: --check for outbound and wip tasks below

Line 4034: FROM wms_waveplan_tasks_temp

4030: INTO l_query_count
4031: FROM DUAL
4032: WHERE EXISTS (
4033: SELECT parent_line_id
4034: FROM wms_waveplan_tasks_temp
4035: WHERE parent_line_id IS NOT NULL
4036: AND task_type_id <> 3
4037: --Change
4038: --check for outbound and wip tasks below

Line 8053: l_insert_cc := 'INSERT INTO wms_waveplan_tasks_temp( ';

8049: THEN -- Completed tasks
8050: l_join_wdt := TRUE;
8051: END IF;
8052:
8053: l_insert_cc := 'INSERT INTO wms_waveplan_tasks_temp( ';
8054: l_insert_cc := l_insert_cc || 'transaction_temp_id ';
8055: l_insert_cc := l_insert_cc || ', inventory_item_id ';
8056: l_insert_cc := l_insert_cc || ', item ';
8057: l_insert_cc := l_insert_cc || ', item_description ';--Added for Bug 8540985

Line 8374: 'WHERE NOT exists (SELECT 1 FROM wms_waveplan_tasks_temp ';

8370: -- Build the generic where section of the query
8371: IF p_add
8372: THEN
8373: l_where_cc :=
8374: 'WHERE NOT exists (SELECT 1 FROM wms_waveplan_tasks_temp ';
8375: l_where_cc :=
8376: l_where_cc
8377: || 'WHERE transaction_temp_id = mcce.cycle_count_entry_id ';
8378: l_where_cc := l_where_cc || 'AND task_type_id = 3) ';

Line 10167: -- wms_waveplan_tasks_temp based on the input parameters.

10163:
10164: -- Prodedure query_tasks
10165: -- Input: Parameters that define the kind of task
10166: -- Output: This procedure populates the global temp table
10167: -- wms_waveplan_tasks_temp based on the input parameters.
10168: PROCEDURE query_tasks (
10169: p_add BOOLEAN DEFAULT FALSE,
10170: p_organization_id NUMBER DEFAULT NULL,
10171: p_subinventory_code VARCHAR2 DEFAULT NULL,

Line 10300: DELETE FROM wms_waveplan_tasks_temp;

10296: IF NOT p_add
10297: THEN
10298: wms_plan_tasks_pvt.clear_globals ();
10299:
10300: DELETE FROM wms_waveplan_tasks_temp;
10301:
10302: g_record_count := 0;
10303: END IF;
10304:

Line 10773: DELETE FROM wms_waveplan_tasks_temp

10769: IF l_debug = 1 THEN
10770: debug('Deleting unreleased tasks','query_tasks');
10771: END IF;
10772:
10773: DELETE FROM wms_waveplan_tasks_temp
10774: WHERE status_id = 8;
10775:
10776: g_wms_task_summary_tbl(g_task_type_pick).task_count := g_wms_task_summary_tbl(g_task_type_pick).task_count - SQL%ROWCOUNT;
10777: --subtract the same from the summary information

Line 10792: DELETE FROM wms_waveplan_tasks_temp

10788: IF l_debug = 1 THEN
10789: debug('Done populating merged tasks. Delete unwanted tasks','query_tasks');
10790: END IF;
10791:
10792: DELETE FROM wms_waveplan_tasks_temp
10793: WHERE status_id = 1;
10794:
10795: g_wms_task_summary_tbl(g_task_type_pick).task_count := g_wms_task_summary_tbl(g_task_type_pick).task_count - SQL%ROWCOUNT; --subtract the same from the summary information
10796: g_record_count := g_record_count - SQL%ROWCOUNT;

Line 10810: DELETE FROM wms_waveplan_tasks_temp

10806:
10807: /* Bug - 5446146 If a user task type has been entered, delete the records which are not associated with a user task type */
10808: IF p_user_task_type_id IS NOT NULL THEN
10809:
10810: DELETE FROM wms_waveplan_tasks_temp
10811: WHERE user_task_type_id IS NULL;
10812:
10813: g_record_count := g_record_count - SQL%ROWCOUNT;
10814: END IF;

Line 10982: l_message wms_waveplan_tasks_temp.error%TYPE;

10978: )
10979: IS
10980: l_task_id NUMBER;
10981: l_index NUMBER;
10982: l_message wms_waveplan_tasks_temp.error%TYPE;
10983: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
10984:
10985: TYPE status_table_type IS TABLE OF wms_waveplan_tasks_temp.status%TYPE;
10986:

Line 10985: TYPE status_table_type IS TABLE OF wms_waveplan_tasks_temp.status%TYPE;

10981: l_index NUMBER;
10982: l_message wms_waveplan_tasks_temp.error%TYPE;
10983: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
10984:
10985: TYPE status_table_type IS TABLE OF wms_waveplan_tasks_temp.status%TYPE;
10986:
10987: l_transaction_temp_ids wms_waveplan_tasks_pvt.transaction_temp_table_type;
10988: l_task_type_ids wms_waveplan_tasks_pvt.task_type_id_table_type;
10989: l_statuses status_table_type;

Line 11007: UPDATE wms_waveplan_tasks_temp

11003: g_cannot_unrelease_cc := fnd_message.get;
11004: END IF;
11005:
11006: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
11007: UPDATE wms_waveplan_tasks_temp
11008: SET RESULT = 'X'
11009: WHERE transaction_temp_id = p_transaction_temp_id (i)
11010: AND task_type_id = p_task_type_id (i);
11011:

Line 11023: UPDATE wms_waveplan_tasks_temp

11019: -- 6 Move Order Issue
11020: -- 7 Staging Move
11021:
11022: -- Cannot update putaway tasks or staging moves
11023: UPDATE wms_waveplan_tasks_temp
11024: SET RESULT = 'E',
11025: error =
11026: DECODE (task_type_id,
11027: 2, g_cannot_update_putaway,

Line 11035: UPDATE wms_waveplan_tasks_temp

11031:
11032: -- Cannot set cycle count tasks to unreleased
11033: IF p_to_status_id = 8
11034: THEN
11035: UPDATE wms_waveplan_tasks_temp
11036: SET RESULT = 'E',
11037: error = g_cannot_unrelease_cc
11038: WHERE RESULT = 'X' AND task_type_id = 3;
11039: END IF;

Line 11046: FROM wms_waveplan_tasks_temp

11042: IF p_to_status_id IS NOT NULL
11043: THEN
11044: SELECT transaction_temp_id, task_type_id, status
11045: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
11046: FROM wms_waveplan_tasks_temp
11047: WHERE RESULT = 'X'
11048: AND NOT ( (status_id = 8 AND p_to_status_id IN (1, 2)
11049: ) -- Unreleased to pending or queued
11050: OR (status_id = 1 AND p_to_status_id IN (2, 8)

Line 11073: UPDATE wms_waveplan_tasks_temp

11069: l_messages (i) := fnd_message.get;
11070: END LOOP;
11071:
11072: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
11073: UPDATE wms_waveplan_tasks_temp
11074: SET RESULT = 'E',
11075: error = l_messages (i)
11076: WHERE transaction_temp_id = l_transaction_temp_ids (i)
11077: AND task_type_id = l_task_type_ids (i);

Line 11088: FROM wms_waveplan_tasks_temp wwtt, mtl_material_transactions_temp mmtt, WMS_DISPATCHED_TASKS wdt

11084:
11085: --BUG: 4707588
11086: SELECT wwtt.transaction_temp_id, wwtt.task_type_id, wwtt.status
11087: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
11088: FROM wms_waveplan_tasks_temp wwtt, mtl_material_transactions_temp mmtt, WMS_DISPATCHED_TASKS wdt
11089: WHERE wwtt.transaction_temp_id = wdt.transaction_temp_id AND
11090: wwtt.transaction_temp_id = mmtt.transaction_temp_id AND
11091: wwtt.RESULT = 'X' AND
11092: wwtt.status_id = 3 AND

Line 11120: UPDATE wms_waveplan_tasks_temp

11116: END LOOP;
11117:
11118:
11119: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
11120: UPDATE wms_waveplan_tasks_temp
11121: SET RESULT = 'E',
11122: error = 'This group of tasks is currently being worked, cannot change status'
11123: WHERE transaction_temp_id = l_transaction_temp_ids (i)
11124: AND task_type_id = l_task_type_ids (i);

Line 11131: FROM wms_waveplan_tasks_temp wwtt

11127: -- if the original task status is Active, check if the user whom the task is assigned is
11128: -- logged on to the system
11129: SELECT transaction_temp_id, task_type_id, status
11130: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
11131: FROM wms_waveplan_tasks_temp wwtt
11132: WHERE RESULT = 'X' AND
11133: status_id = 9 AND
11134: EXISTS ( SELECT 1 FROM MTL_MOBILE_LOGIN_HIST MMLH, WMS_DISPATCHED_TASKS WDT
11135: WHERE WDT.TRANSACTION_TEMP_ID = WWTT.TRANSACTION_TEMP_ID AND

Line 11144: UPDATE wms_waveplan_tasks_temp

11140:
11141: IF l_transaction_temp_ids.COUNT > 0
11142: THEN
11143: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
11144: UPDATE wms_waveplan_tasks_temp
11145: SET RESULT = 'E',
11146: error = 'This task is currently being worked, cannot change status'
11147: WHERE transaction_temp_id = l_transaction_temp_ids (i)
11148: AND task_type_id = l_task_type_ids (i);

Line 11162: UPDATE wms_waveplan_tasks_temp wwtt

11158: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_EMPLOYEE');
11159: fnd_message.set_token ('EMPLOYEE', p_employee);
11160: l_message := fnd_message.get;
11161:
11162: UPDATE wms_waveplan_tasks_temp wwtt
11163: SET RESULT = 'E',
11164: error = l_message
11165: WHERE RESULT = 'X'
11166: AND NOT EXISTS (

Line 11177: FROM wms_waveplan_tasks_temp

11173:
11174: --j Develop
11175: SELECT transaction_temp_id
11176: BULK COLLECT INTO l_transaction_temp_ids_temp
11177: FROM wms_waveplan_tasks_temp
11178: WHERE RESULT = 'X';
11179:
11180: IF (l_transaction_temp_ids_temp.COUNT > 0)
11181: THEN

Line 11200: UPDATE wms_waveplan_tasks_temp wwtt

11196: ' Update_TAsk :'
11197: );
11198: end if;
11199:
11200: UPDATE wms_waveplan_tasks_temp wwtt
11201: SET RESULT = 'E',
11202: error = l_message
11203: WHERE transaction_temp_id = l_transaction_temp_ids_temp (i)
11204: AND NOT EXISTS (

Line 11215: UPDATE wms_waveplan_tasks_temp wwtt

11211: END IF;
11212: -- End of J Develop
11213: END IF;
11214:
11215: UPDATE wms_waveplan_tasks_temp wwtt
11216: SET person_resource_id =
11217: (SELECT bre.resource_id
11218: FROM bom_std_op_resources bsor, bom_resource_employees bre
11219: WHERE wwtt.user_task_type_id = bsor.standard_operation_id

Line 11230: UPDATE wms_waveplan_tasks_temp wwtt

11226: THEN
11227: -- R12: Can update User Task Type if task is dispatched, active IF
11228: -- Dispatched or Active tasks are in the process of getting updated to pending or Unreleased
11229: IF p_to_status_id IS NOT NULL THEN
11230: UPDATE wms_waveplan_tasks_temp wwtt
11231: SET RESULT = 'E',
11232: error = l_message
11233: WHERE RESULT = 'X' AND (status_id NOT IN (1, 2, 3, 8, 9) AND p_to_status_id IN (1, 8))
11234: RETURNING transaction_temp_id, task_type_id, status

Line 11239: UPDATE wms_waveplan_tasks_temp wwtt

11235: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses;
11236: ELSE
11237: -- R12: Cannot update User Task Type if task is dispatched, active or loaded IF
11238: -- Dispatched or Active tasks are NOT in the process of getting updated to pending or Unreleased
11239: UPDATE wms_waveplan_tasks_temp wwtt
11240: SET RESULT = 'E',
11241: error = l_message
11242: WHERE RESULT = 'X' AND status_id NOT IN (1, 8)
11243: RETURNING transaction_temp_id, task_type_id, status

Line 11258: UPDATE wms_waveplan_tasks_temp

11254: l_messages (i) := fnd_message.get;
11255: END LOOP;
11256:
11257: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
11258: UPDATE wms_waveplan_tasks_temp
11259: SET RESULT = 'E',
11260: error = l_messages (i)
11261: WHERE transaction_temp_id = l_transaction_temp_ids (i)
11262: AND task_type_id = l_task_type_ids (i);

Line 11272: UPDATE wms_waveplan_tasks_temp wwtt

11268: THEN
11269: -- R12: Can update priority if task is dispatched, active IF
11270: -- Dispatched or Active tasks are in the process of getting updated to pending or Unreleased
11271: IF p_to_status_id IS NOT NULL THEN
11272: UPDATE wms_waveplan_tasks_temp wwtt
11273: SET RESULT = 'E',
11274: error = l_message
11275: WHERE RESULT = 'X' AND (status_id NOT IN (1, 2, 3, 8, 9) AND p_to_status_id IN (1, 8))
11276: RETURNING transaction_temp_id, task_type_id, status

Line 11281: UPDATE wms_waveplan_tasks_temp wwtt

11277: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses;
11278: ELSE
11279: -- R12: Cannot update priority if task is dispatched, active or loaded IF
11280: -- Dispatched or Active tasks are NOT in the process of getting updated to pending or Unreleased
11281: UPDATE wms_waveplan_tasks_temp wwtt
11282: SET RESULT = 'E',
11283: error = l_message
11284: WHERE RESULT = 'X' AND status_id NOT IN (1, 2, 8)
11285: RETURNING transaction_temp_id, task_type_id, status

Line 11300: UPDATE wms_waveplan_tasks_temp

11296: l_messages (i) := fnd_message.get;
11297: END LOOP;
11298:
11299: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
11300: UPDATE wms_waveplan_tasks_temp
11301: SET RESULT = 'E',
11302: error = l_messages (i)
11303: WHERE transaction_temp_id = l_transaction_temp_ids (i)
11304: AND task_type_id = l_task_type_ids (i);

Line 11311: UPDATE wms_waveplan_tasks_temp

11307:
11308: -- If changing status to Queued
11309: IF p_to_status_id = 2
11310: THEN
11311: UPDATE wms_waveplan_tasks_temp
11312: SET task_id = NVL (task_id, wms_dispatched_tasks_s.NEXTVAL),
11313: status = p_to_status,
11314: status_id = p_to_status_id,
11315: priority =

Line 11341: UPDATE wms_waveplan_tasks_temp

11337: ELSE
11338: if l_debug = 1 then
11339: DEBUG ('Else Part ______________________: ', ' Update_TAsk :');
11340: end if;
11341: UPDATE wms_waveplan_tasks_temp
11342: SET task_id = DECODE (p_to_status_id, 1, NULL, 8, NULL, task_id),
11343: status = NVL (p_to_status, status),
11344: status_id = NVL (p_to_status_id, status_id),
11345: user_task_type = NVL (p_user_task_type, user_task_type), -- R12: Assign User Task Type

Line 11403: UPDATE wms_waveplan_tasks_temp

11399: end if;
11400: END IF;
11401:
11402: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
11403: UPDATE wms_waveplan_tasks_temp
11404: SET RESULT = RESULT
11405: WHERE transaction_temp_id = p_transaction_temp_id (i)
11406: AND task_type_id = p_task_type_id (i)
11407: RETURNING task_id, RESULT, error

Line 11432: l_message wms_waveplan_tasks_temp.error%TYPE;

11428: )
11429: IS
11430: l_task_id NUMBER;
11431: l_index NUMBER;
11432: l_message wms_waveplan_tasks_temp.error%TYPE;
11433:
11434: TYPE status_table_type IS TABLE OF wms_waveplan_tasks_temp.status%TYPE;
11435:
11436: l_transaction_temp_ids wms_waveplan_tasks_pvt.transaction_temp_table_type;

Line 11434: TYPE status_table_type IS TABLE OF wms_waveplan_tasks_temp.status%TYPE;

11430: l_task_id NUMBER;
11431: l_index NUMBER;
11432: l_message wms_waveplan_tasks_temp.error%TYPE;
11433:
11434: TYPE status_table_type IS TABLE OF wms_waveplan_tasks_temp.status%TYPE;
11435:
11436: l_transaction_temp_ids wms_waveplan_tasks_pvt.transaction_temp_table_type;
11437: l_task_type_ids wms_waveplan_tasks_pvt.task_type_id_table_type;
11438: l_statuses status_table_type;

Line 11457: UPDATE wms_waveplan_tasks_temp

11453: END IF;*/
11454:
11455:
11456: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
11457: UPDATE wms_waveplan_tasks_temp
11458: SET RESULT = 'X'
11459: WHERE transaction_temp_id = p_transaction_temp_id (i)
11460: AND task_type_id = p_task_type_id (i);
11461:

Line 11472: UPDATE wms_waveplan_tasks_temp

11468: -- 6 Move Order Issue
11469: -- 7 Staging Move
11470:
11471: -- Cannot update the following :
11472: UPDATE wms_waveplan_tasks_temp
11473: SET RESULT = 'E',
11474: error =
11475: DECODE (task_type_id,
11476: 1, 'Can not cancel pick task',

Line 11488: UPDATE wms_waveplan_tasks_temp

11484:
11485: /* Bug 5623122 */
11486: -- Cannot update Putaway tasks
11487: IF NOT p_is_crossdock THEN
11488: UPDATE wms_waveplan_tasks_temp
11489: SET RESULT = 'E',
11490: error =
11491: DECODE (task_type_id,
11492: 2, 'Can not cancel putaway task'

Line 11499: UPDATE wms_waveplan_tasks_temp

11495: END IF;
11496: /* End of Bug 5623122 */
11497:
11498: -- cannot update completed tasks
11499: UPDATE wms_waveplan_tasks_temp
11500: SET RESULT = 'E',
11501: error = 'Can not cancel completed tasks'
11502: WHERE RESULT = 'X' AND status_id = 6;
11503:

Line 11504: UPDATE wms_waveplan_tasks_temp

11500: SET RESULT = 'E',
11501: error = 'Can not cancel completed tasks'
11502: WHERE RESULT = 'X' AND status_id = 6;
11503:
11504: UPDATE wms_waveplan_tasks_temp
11505: SET status_id = 12,
11506: status = g_status_codes(12),
11507: is_modified = 'Y',
11508: RESULT = 'S',

Line 11513: UPDATE wms_waveplan_tasks_temp

11509: error = 'Task Canceled'
11510: WHERE RESULT = 'X';
11511:
11512: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
11513: UPDATE wms_waveplan_tasks_temp
11514: SET RESULT = RESULT
11515: WHERE transaction_temp_id = p_transaction_temp_id (i)
11516: AND task_type_id = p_task_type_id (i)
11517: RETURNING task_id, RESULT, error

Line 11539: DELETE FROM wms_waveplan_tasks_temp

11535: l_removed_count NUMBER := 0;
11536: BEGIN
11537: x_return_status := 'S';
11538: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
11539: DELETE FROM wms_waveplan_tasks_temp
11540: WHERE transaction_temp_id = p_transaction_temp_id (i);
11541: l_removed_count := SQL%ROWCOUNT;
11542: g_record_count := g_record_count - l_removed_count;
11543: x_record_count := g_record_count;

Line 11583: TYPE task_type_id IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE

11579:
11580: TYPE effective_end_date IS TABLE OF wms_dispatched_tasks.effective_end_date%TYPE
11581: INDEX BY BINARY_INTEGER;
11582:
11583: TYPE task_type_id IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE
11584: INDEX BY BINARY_INTEGER;
11585:
11586: TYPE user_task_type_id IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE -- R12: Update User Task Type Id
11587: INDEX BY BINARY_INTEGER;

Line 11586: TYPE user_task_type_id IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE -- R12: Update User Task Type Id

11582:
11583: TYPE task_type_id IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE
11584: INDEX BY BINARY_INTEGER;
11585:
11586: TYPE user_task_type_id IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE -- R12: Update User Task Type Id
11587: INDEX BY BINARY_INTEGER;
11588:
11589: l_transaction_temp_id_table transaction_temp_id_table_type;
11590: l_wms_task_status_table wms_task_status_table_type;

Line 11612: FROM wms_waveplan_tasks_temp wwtt

11608: mmtt_last_update_date, wdt_last_updated_by,
11609: wdt_last_update_date, person_id, person_id_original,person_resource_id,/* Bug 5630187 - Added person_resource_id */
11610: effective_start_date, effective_end_date, status_id,
11611: status_id_original, priority, priority_original, user_task_type_id, num_of_child_tasks -- R12: Added User Task Type Id
11612: FROM wms_waveplan_tasks_temp wwtt
11613: WHERE wwtt.is_modified = 'Y';
11614:
11615: --Patchset J: Bulk picking
11616: --Get the transaction_temp_id of the children tasks

Line 11657: UPDATE wms_waveplan_tasks_temp

11653: g_plan_cancelled := fnd_message.get;
11654: END IF;
11655:
11656:
11657: UPDATE wms_waveplan_tasks_temp
11658: SET is_modified = 'N',
11659: RESULT = 'S',
11660: error = g_plan_cancelled
11661: WHERE transaction_temp_id = rec_wwtt.transaction_temp_id;

Line 11830: FROM wms_waveplan_tasks_temp wwtt, mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

11826: last_update_login = p_login_id,
11827: standard_operation_id = l_user_task_type_id (i) --R12: Update User Task Type Id
11828: WHERE cycle_count_entry_id IN (
11829: SELECT mcce.cycle_count_entry_id
11830: FROM wms_waveplan_tasks_temp wwtt, mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
11831: WHERE wwtt.transaction_temp_id=l_transaction_temp_id_table (i)
11832: AND wwtt.is_modified = 'Y'
11833: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
11834: AND mcce.inventory_item_id = wwtt.inventory_item_id

Line 11852: FROM wms_waveplan_tasks_temp wwtt

11848: DELETE wms_dispatched_tasks wdt
11849: WHERE wdt.status IN (2, 3, 9) -- R12: Delete the Active or Dispatched tasks which were updated to pending/Unreleased
11850: AND wdt.transaction_temp_id IN (
11851: SELECT transaction_temp_id
11852: FROM wms_waveplan_tasks_temp wwtt
11853: WHERE wwtt.status_id IN (1, 8)
11854: AND wwtt.is_modified = 'Y'
11855: -- adding following condition to delete WDT's with no child tasks
11856: AND (

Line 11885: FROM wms_waveplan_tasks_temp wwtt

11881: NULL, l_update_date, p_user_id, l_update_date, p_user_id,
11882: p_login_id, wwtt.task_type_id, wwtt.priority,
11883: wwtt.move_order_line_id, wwtt.operation_plan_id,
11884: wwtt.to_lpn_id
11885: FROM wms_waveplan_tasks_temp wwtt
11886: WHERE wwtt.status_id = 2
11887: AND wwtt.status_id_original IN (1, 8)
11888: AND wwtt.is_modified = 'Y'
11889: -- bug 11705135 : adding following condition to insert WDT record with no child tasks

Line 11917: FROM wms_waveplan_tasks_temp wwtt

11913: last_updated_by = p_user_id,
11914: last_update_login = p_login_id
11915: WHERE wdt.transaction_temp_id IN ( --modified the where condition for bug 14663231
11916: SELECT wwtt.transaction_temp_id
11917: FROM wms_waveplan_tasks_temp wwtt
11918: WHERE wwtt.transaction_temp_id = l_transaction_temp_id_table (i)
11919: --AND wwtt.status_id IN (1, 8) -- Bug 15898611
11920: AND wwtt.status_id IN (1, 2, 8) -- Bug 15898611
11921: AND wwtt.is_modified = 'Y'

Line 11943: FROM wms_waveplan_tasks_temp wwtt, mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

11939: WHERE wdt.status IN (2, 3)
11940: AND wdt.task_type = 3
11941: AND wdt.transaction_temp_id IN (
11942: SELECT mcce.cycle_count_entry_id
11943: FROM wms_waveplan_tasks_temp wwtt, mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
11944: WHERE wwtt.status_id IN (1, 8)
11945: AND wwtt.is_modified = 'Y'
11946: AND NVL(wwtt.num_of_child_tasks,1)>1
11947: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id

Line 11978: FROM wms_waveplan_tasks_temp wwtt, mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

11974: NULL, l_update_date, p_user_id, l_update_date, p_user_id,
11975: p_login_id, wwtt.task_type_id, wwtt.priority,
11976: wwtt.move_order_line_id, wwtt.operation_plan_id,
11977: wwtt.to_lpn_id
11978: FROM wms_waveplan_tasks_temp wwtt, mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
11979: WHERE NVL(wwtt.NUM_OF_CHILD_TASKS,1) > 1
11980: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
11981: AND mcce.inventory_item_id = wwtt.inventory_item_id
11982: AND mcce.subinventory = wwtt.subinventory

Line 12013: FROM wms_waveplan_tasks_temp wwtt, mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch

12009: last_update_login = p_login_id
12010: WHERE task_type = 3
12011: AND transaction_temp_id IN (
12012: SELECT mcce.cycle_count_entry_id
12013: FROM wms_waveplan_tasks_temp wwtt, mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
12014: WHERE wwtt.transaction_temp_id=l_transaction_temp_id_table (i)
12015: AND wwtt.is_modified = 'Y'
12016: AND NVL(wwtt.num_of_child_tasks,1)>1
12017: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id

Line 12051: UPDATE wms_waveplan_tasks_temp

12047: END IF;
12048:
12049: -- forall i IN l_transaction_temp_id_table.first..l_transaction_temp_id_table.last
12050: FORALL i IN 1 .. l_transaction_temp_id_table.COUNT
12051: UPDATE wms_waveplan_tasks_temp
12052: SET RESULT = 'S',
12053: error = g_task_saved,
12054: is_modified = 'N',
12055: person_id_original = l_person_id_table (i),

Line 12095: UPDATE wms_waveplan_tasks_temp

12091: , x_msg_data => x_msg_data
12092: , x_msg_count => x_msg_count
12093: );
12094: IF x_return_status = fnd_api.g_ret_sts_success THEN
12095: UPDATE wms_waveplan_tasks_temp
12096: SET RESULT = 'S',
12097: error = 'Task Cancelled',
12098: is_modified = 'N'
12099: WHERE transaction_temp_id = rec_wwtt.transaction_temp_id;

Line 12110: UPDATE wms_waveplan_tasks_temp

12106:
12107: fnd_message.set_name ('FND', 'FORM_RECORD_CHANGED');
12108: l_error_message := fnd_message.get;
12109:
12110: UPDATE wms_waveplan_tasks_temp
12111: SET RESULT = 'E',
12112: error = l_error_message
12113: WHERE is_modified = 'Y';
12114:

Line 12150: FROM wms_waveplan_tasks_temp

12146: IS
12147: CURSOR status_cursor
12148: IS
12149: SELECT status_id, COUNT (*) task_count
12150: FROM wms_waveplan_tasks_temp
12151: WHERE task_type_id = NVL (p_task_type_id, task_type_id)
12152: GROUP BY status_id;
12153:
12154: l_loop_index NUMBER;

Line 12197: FROM wms_waveplan_tasks_temp

12193: IS
12194: CURSOR type_cursor
12195: IS
12196: SELECT task_type_id, COUNT (*) task_count
12197: FROM wms_waveplan_tasks_temp
12198: WHERE task_type_id = NVL (p_task_type_id, task_type_id)
12199: GROUP BY task_type_id;
12200:
12201: l_loop_index NUMBER;

Line 12251: TYPE user_task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE

12247: x_msg_data OUT NOCOPY VARCHAR2,
12248: x_msg_count OUT NOCOPY NUMBER
12249: )
12250: IS
12251: TYPE user_task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE
12252: INDEX BY BINARY_INTEGER;
12253:
12254: TYPE time_type IS TABLE OF wms_waveplan_tasks_temp.time_estimate%TYPE
12255: INDEX BY BINARY_INTEGER;

Line 12254: TYPE time_type IS TABLE OF wms_waveplan_tasks_temp.time_estimate%TYPE

12250: IS
12251: TYPE user_task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE
12252: INDEX BY BINARY_INTEGER;
12253:
12254: TYPE time_type IS TABLE OF wms_waveplan_tasks_temp.time_estimate%TYPE
12255: INDEX BY BINARY_INTEGER;
12256:
12257: TYPE volume_type IS TABLE OF wms_waveplan_tasks_temp.unit_volume%TYPE
12258: INDEX BY BINARY_INTEGER;

Line 12257: TYPE volume_type IS TABLE OF wms_waveplan_tasks_temp.unit_volume%TYPE

12253:
12254: TYPE time_type IS TABLE OF wms_waveplan_tasks_temp.time_estimate%TYPE
12255: INDEX BY BINARY_INTEGER;
12256:
12257: TYPE volume_type IS TABLE OF wms_waveplan_tasks_temp.unit_volume%TYPE
12258: INDEX BY BINARY_INTEGER;
12259:
12260: TYPE weight_type IS TABLE OF wms_waveplan_tasks_temp.unit_weight%TYPE
12261: INDEX BY BINARY_INTEGER;

Line 12260: TYPE weight_type IS TABLE OF wms_waveplan_tasks_temp.unit_weight%TYPE

12256:
12257: TYPE volume_type IS TABLE OF wms_waveplan_tasks_temp.unit_volume%TYPE
12258: INDEX BY BINARY_INTEGER;
12259:
12260: TYPE weight_type IS TABLE OF wms_waveplan_tasks_temp.unit_weight%TYPE
12261: INDEX BY BINARY_INTEGER;
12262:
12263: TYPE volume_uom_type IS TABLE OF wms_waveplan_tasks_temp.volume_uom_code%TYPE
12264: INDEX BY BINARY_INTEGER;

Line 12263: TYPE volume_uom_type IS TABLE OF wms_waveplan_tasks_temp.volume_uom_code%TYPE

12259:
12260: TYPE weight_type IS TABLE OF wms_waveplan_tasks_temp.unit_weight%TYPE
12261: INDEX BY BINARY_INTEGER;
12262:
12263: TYPE volume_uom_type IS TABLE OF wms_waveplan_tasks_temp.volume_uom_code%TYPE
12264: INDEX BY BINARY_INTEGER;
12265:
12266: TYPE weight_uom_type IS TABLE OF wms_waveplan_tasks_temp.weight_uom_code%TYPE
12267: INDEX BY BINARY_INTEGER;

Line 12266: TYPE weight_uom_type IS TABLE OF wms_waveplan_tasks_temp.weight_uom_code%TYPE

12262:
12263: TYPE volume_uom_type IS TABLE OF wms_waveplan_tasks_temp.volume_uom_code%TYPE
12264: INDEX BY BINARY_INTEGER;
12265:
12266: TYPE weight_uom_type IS TABLE OF wms_waveplan_tasks_temp.weight_uom_code%TYPE
12267: INDEX BY BINARY_INTEGER;
12268:
12269: TYPE item_id_type IS TABLE OF wms_waveplan_tasks_temp.inventory_item_id%TYPE
12270: INDEX BY BINARY_INTEGER;

Line 12269: TYPE item_id_type IS TABLE OF wms_waveplan_tasks_temp.inventory_item_id%TYPE

12265:
12266: TYPE weight_uom_type IS TABLE OF wms_waveplan_tasks_temp.weight_uom_code%TYPE
12267: INDEX BY BINARY_INTEGER;
12268:
12269: TYPE item_id_type IS TABLE OF wms_waveplan_tasks_temp.inventory_item_id%TYPE
12270: INDEX BY BINARY_INTEGER;
12271:
12272: TYPE quantity_type IS TABLE OF wms_waveplan_tasks_temp.transaction_quantity%TYPE
12273: INDEX BY BINARY_INTEGER;

Line 12272: TYPE quantity_type IS TABLE OF wms_waveplan_tasks_temp.transaction_quantity%TYPE

12268:
12269: TYPE item_id_type IS TABLE OF wms_waveplan_tasks_temp.inventory_item_id%TYPE
12270: INDEX BY BINARY_INTEGER;
12271:
12272: TYPE quantity_type IS TABLE OF wms_waveplan_tasks_temp.transaction_quantity%TYPE
12273: INDEX BY BINARY_INTEGER;
12274:
12275: TYPE result_type IS TABLE OF wms_waveplan_tasks_temp.RESULT%TYPE
12276: INDEX BY BINARY_INTEGER;

Line 12275: TYPE result_type IS TABLE OF wms_waveplan_tasks_temp.RESULT%TYPE

12271:
12272: TYPE quantity_type IS TABLE OF wms_waveplan_tasks_temp.transaction_quantity%TYPE
12273: INDEX BY BINARY_INTEGER;
12274:
12275: TYPE result_type IS TABLE OF wms_waveplan_tasks_temp.RESULT%TYPE
12276: INDEX BY BINARY_INTEGER;
12277:
12278: TYPE ERROR_TYPE IS TABLE OF wms_waveplan_tasks_temp.error%TYPE
12279: INDEX BY BINARY_INTEGER;

Line 12278: TYPE ERROR_TYPE IS TABLE OF wms_waveplan_tasks_temp.error%TYPE

12274:
12275: TYPE result_type IS TABLE OF wms_waveplan_tasks_temp.RESULT%TYPE
12276: INDEX BY BINARY_INTEGER;
12277:
12278: TYPE ERROR_TYPE IS TABLE OF wms_waveplan_tasks_temp.error%TYPE
12279: INDEX BY BINARY_INTEGER;
12280:
12281: l_user_task_type_id user_task_type_id_type;
12282: l_time time_type;

Line 12302: FROM wms_waveplan_tasks_temp

12298: inventory_item_id, transaction_quantity
12299: BULK COLLECT INTO l_transaction_temp_id, l_task_type_id, l_user_task_type_id,
12300: l_volume, l_volume_uom_code, l_weight, l_weight_uom_code,
12301: l_inventory_item_id, l_quantity
12302: FROM wms_waveplan_tasks_temp
12303: WHERE RESULT IN ('X', 'Y', 'Z');
12304:
12305: x_total_tasks := l_transaction_temp_id.COUNT;
12306:

Line 12638: UPDATE wms_waveplan_tasks_temp

12634: END IF;
12635: END LOOP;
12636:
12637: FORALL i IN l_transaction_temp_id.FIRST .. l_transaction_temp_id.LAST
12638: UPDATE wms_waveplan_tasks_temp
12639: SET time_estimate = l_time (i),
12640: display_weight = l_weight (i),
12641: display_volume = l_volume (i)
12642: WHERE transaction_temp_id = l_transaction_temp_id (i)

Line 12658: FROM wms_waveplan_tasks_temp wwtt, bom_standard_operations bso

12654: ROUND (SUM (wwtt.time_estimate), 1), p_time_uom,
12655: ROUND (SUM (wwtt.display_weight), 1), p_weight_uom,
12656: ROUND (SUM (wwtt.display_volume), 1), p_volume_uom,
12657: wwtt.organization_id
12658: FROM wms_waveplan_tasks_temp wwtt, bom_standard_operations bso
12659: WHERE wwtt.RESULT IN ('X', 'Y', 'Z')
12660: AND wwtt.user_task_type_id = bso.standard_operation_id(+)
12661: AND wwtt.organization_id = bso.organization_id(+)
12662: GROUP BY wwtt.user_task_type_id,

Line 12668: UPDATE wms_waveplan_tasks_temp

12664: bso.operation_description,
12665: wwtt.organization_id;
12666:
12667: FORALL i IN l_transaction_temp_id.FIRST .. l_transaction_temp_id.LAST
12668: UPDATE wms_waveplan_tasks_temp
12669: SET RESULT = l_result (i),
12670: error = l_error (i)
12671: WHERE transaction_temp_id = l_transaction_temp_id (i)
12672: AND task_type_id = l_task_type_id (i);

Line 12685: l_transaction_temp_id wms_waveplan_tasks_temp.transaction_temp_id%TYPE;

12681: x_ret_code OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
12682: p_transaction_temp_table wms_waveplan_tasks_pvt.transaction_temp_table_type
12683: )
12684: IS
12685: l_transaction_temp_id wms_waveplan_tasks_temp.transaction_temp_id%TYPE;
12686: l_return_status VARCHAR2 (1);
12687: l_msg_data VARCHAR2 (2000);
12688: l_msg_count NUMBER;
12689: l_error_code NUMBER;

Line 12700: FROM wms_waveplan_tasks_temp

12696: BEGIN
12697:
12698: SELECT transaction_temp_id
12699: INTO l_transaction_temp_id
12700: FROM wms_waveplan_tasks_temp
12701: WHERE parent_line_id = p_transaction_temp_table (i)
12702: AND status = 'Pending';
12703:
12704: l_cancel_plan := TRUE;

Line 12757: UPDATE wms_waveplan_tasks_temp

12753: END LOOP;
12754:
12755: FORALL i IN 1 .. p_transaction_temp_table.COUNT
12756:
12757: UPDATE wms_waveplan_tasks_temp
12758: SET is_modified = 'Y',
12759: status_id = 12,
12760: status = g_status_codes(12)
12761: WHERE transaction_temp_id = p_transaction_temp_table (i)

Line 12769: DELETE FROM wms_waveplan_tasks_temp

12765: DEBUG ('No of records updated are' || SQL%ROWCOUNT);
12766: end if;
12767:
12768: FORALL j IN 1..p_transaction_temp_table.COUNT
12769: DELETE FROM wms_waveplan_tasks_temp
12770: WHERE parent_line_id = p_transaction_temp_table (j)
12771: AND status_id = 1
12772: AND x_ret_code (j) = fnd_api.g_ret_sts_success;
12773:

Line 12816: FROM wms_waveplan_tasks_temp wwtt

12812: begin
12813:
12814: If p_is_picknone then
12815: DELETE
12816: FROM wms_waveplan_tasks_temp wwtt
12817: WHERE 1=1
12818: AND status_id =13
12819: AND not exists
12820: (SELECT 1