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.

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.45.12010000.3 2008/10/08 10:40:15 satishku 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_all pll,
387: po_headers_all ph,
388: po_lines_all 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: l_debug NUMBER
474: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
475: l_progress NUMBER;
476:
477: TYPE num_of_child_tasks_type IS TABLE OF wms_waveplan_tasks_temp.num_of_child_tasks%TYPE;
478:
479: l_num_of_child_tasks_tbl num_of_child_tasks_type;
480: l_parent_temp_ids_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;
481: BEGIN

Line 496: FROM wms_waveplan_tasks_temp wwtt,

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,
497: mtl_material_transactions_temp mmtt
498: WHERE wwtt.transaction_temp_id = mmtt.parent_line_id
499: AND wwtt.transaction_temp_id <> mmtt.transaction_temp_id
500: GROUP BY wwtt.transaction_temp_id;

Line 508: UPDATE wms_waveplan_tasks_temp wwtt

504: IF l_num_of_child_tasks_tbl.COUNT > 0
505: THEN
506: l_progress := 30;
507: FORALL i IN l_num_of_child_tasks_tbl.FIRST .. l_num_of_child_tasks_tbl.LAST
508: UPDATE wms_waveplan_tasks_temp wwtt
509: SET wwtt.num_of_child_tasks = l_num_of_child_tasks_tbl (i)
510: WHERE wwtt.transaction_temp_id = l_parent_temp_ids_tbl (i);
511: l_progress := 40;
512: END IF;

Line 565: UPDATE wms_waveplan_tasks_temp

561:
562: IF p_is_completed THEN
563: -- Completed Tasks
564: IF g_picked_lpn_visible = 'T' OR g_loaded_lpn_visible = 'T' OR g_drop_lpn_visible = 'T' THEN
565: UPDATE wms_waveplan_tasks_temp
566: -- transfer_lpn_id would be null if it is loaded into the same lpn as that of picked.
567: SET picked_lpn_id = NVL(from_lpn_id, content_lpn_id),
568: loaded_lpn_id = Nvl(to_lpn_id, Nvl(from_lpn_id, content_lpn_id))
569: WHERE task_type_id IN (1, 4, 5, 6)

Line 574: UPDATE wms_waveplan_tasks_temp

570: AND status_id = 6;
571: END IF;
572:
573: IF g_picked_lpn_visible = 'T' THEN
574: UPDATE wms_waveplan_tasks_temp
575: SET picked_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = picked_lpn_id)
576: WHERE picked_lpn_id IS NOT NULL
577: AND task_type_id IN (1, 4, 5, 6)
578: AND status_id = 6;

Line 582: UPDATE wms_waveplan_tasks_temp

578: AND status_id = 6;
579: END IF;
580:
581: IF g_loaded_lpn_visible = 'T' THEN
582: UPDATE wms_waveplan_tasks_temp
583: SET loaded_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = loaded_lpn_id)
584: WHERE loaded_lpn_id IS NOT NULL
585: AND task_type_id IN (1, 4, 5, 6)
586: AND status_id = 6;

Line 590: UPDATE wms_waveplan_tasks_temp wstt

586: AND status_id = 6;
587: END IF;
588:
589: IF g_drop_lpn_visible = 'T' THEN
590: UPDATE wms_waveplan_tasks_temp wstt
591: SET drop_lpn = Nvl((select license_plate_number
592: FROM wms_license_plate_numbers wlpn, mtl_material_transactions mmt
593: WHERE wlpn.lpn_id = mmt.transfer_lpn_id
594: AND mmt.transaction_action_id = 50

Line 606: UPDATE wms_waveplan_tasks_temp

602:
603: IF p_is_loaded THEN
604: -- Loaded Tasks
605: IF g_picked_lpn_visible = 'T' OR g_loaded_lpn_visible = 'T' THEN
606: UPDATE wms_waveplan_tasks_temp
607: -- transfer_lpn_id would be null if it is loaded into the same lpn as that of picked.
608: SET picked_lpn_id = Nvl(from_lpn_id, content_lpn_id),
609: loaded_lpn_id = to_lpn_id
610: WHERE task_type_id IN (1, 4, 5, 6)

Line 615: UPDATE wms_waveplan_tasks_temp

611: AND status_id = 4;
612: END IF;
613:
614: IF g_picked_lpn_visible = 'T' THEN
615: UPDATE wms_waveplan_tasks_temp
616: SET picked_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = picked_lpn_id)
617: WHERE picked_lpn_id IS NOT NULL
618: AND task_type_id IN (1, 4, 5, 6)
619: AND status_id = 4;

Line 623: UPDATE wms_waveplan_tasks_temp

619: AND status_id = 4;
620: END IF;
621:
622: IF g_loaded_lpn_visible = 'T' THEN
623: UPDATE wms_waveplan_tasks_temp
624: SET loaded_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = loaded_lpn_id)
625: WHERE loaded_lpn_id IS NOT NULL
626: AND task_type_id IN (1, 4, 5, 6)
627: AND status_id = 4;

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

666: -- Query records present both in MMTT and WDT
667: l_join_wdt := TRUE;
668: END IF;
669:
670: l_insert_generic := 'INSERT INTO wms_waveplan_tasks_temp( ';
671: /* Patchset J - ATF - we have to insert expansion_code, plans_tasks also
672: * into the temp table
673: */
674: l_insert_generic := l_insert_generic || 'expansion_code';

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

1971: IF p_populate_merged_tasks
1972: THEN
1973: l_from_generic :=
1974: l_from_generic
1975: || ', (select distinct parent_line_id from wms_waveplan_tasks_temp where task_type_id <> 3) wwtt';
1976: END IF;
1977:
1978: l_from_generic := l_from_generic || ', mtl_system_items_kfv msiv ';
1979: l_from_generic := l_from_generic || ', mtl_item_locations_kfv milv ';

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

2134: -- Build the generic where section of the query
2135: IF p_add
2136: THEN
2137: l_where_generic :=
2138: 'WHERE NOT exists (SELECT 1 FROM wms_waveplan_tasks_temp ';
2139: l_where_generic :=
2140: l_where_generic
2141: || 'WHERE transaction_temp_id = mmtt.transaction_temp_id ';
2142: l_where_generic := l_where_generic || 'AND task_type_id <> 3) ';

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

2702: THEN
2703: IF p_add
2704: THEN
2705: l_where_generic :=
2706: 'WHERE NOT exists (SELECT 1 FROM wms_waveplan_tasks_temp ';
2707: l_where_generic :=
2708: l_where_generic
2709: || 'WHERE transaction_temp_id = mmt.transaction_id) ';
2710: ELSE

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

3087: --completed children.
3088: IF p_add
3089: THEN
3090: l_where_generic :=
3091: 'WHERE NOT exists (SELECT 1 FROM wms_waveplan_tasks_temp ';
3092: l_where_generic :=
3093: l_where_generic
3094: || 'WHERE transaction_temp_id = wdth.transaction_id) ';
3095: ELSE

Line 3273: DELETE FROM wms_waveplan_tasks_temp

3269: RETURN;
3270: END IF;
3271:
3272: -- Delete all the parent records that have been queries up
3273: DELETE FROM wms_waveplan_tasks_temp
3274: WHERE task_type_id <> 3
3275: AND transaction_temp_id IN (
3276: SELECT parent_line_id
3277: FROM wms_waveplan_tasks_temp

Line 3277: FROM wms_waveplan_tasks_temp

3273: DELETE FROM wms_waveplan_tasks_temp
3274: WHERE task_type_id <> 3
3275: AND transaction_temp_id IN (
3276: SELECT parent_line_id
3277: FROM wms_waveplan_tasks_temp
3278: WHERE parent_line_id IS NOT NULL
3279: AND task_type_id <> 3
3280: --Change
3281: --Check for outbound and wip tasks below

Line 3303: FROM wms_waveplan_tasks_temp

3299: INTO l_query_count
3300: FROM DUAL
3301: WHERE EXISTS (
3302: SELECT parent_line_id
3303: FROM wms_waveplan_tasks_temp
3304: WHERE parent_line_id IS NOT NULL
3305: AND task_type_id <> 3
3306: --Change
3307: --check for outbound and wip tasks below

Line 3478: DELETE FROM wms_waveplan_tasks_temp

3474: -- Delete the child tasks from the temp table
3475: --Bulk Picking Enhancement:
3476: --Added the condition status_id <> 6 because we want to show
3477: --completed children associated with a partially completed(Active) parent
3478: DELETE FROM wms_waveplan_tasks_temp
3479: WHERE parent_line_id IS NOT NULL
3480: AND status_id <> 6
3481: --Change
3482: --check for outbound and wip tasks below

Line 3509: FROM wms_waveplan_tasks_temp

3505: INTO l_query_count
3506: FROM DUAL
3507: WHERE EXISTS (
3508: SELECT parent_line_id
3509: FROM wms_waveplan_tasks_temp
3510: WHERE parent_line_id IS NOT NULL
3511: AND task_type_id <> 3
3512: --Change
3513: --check for outbound and wip tasks below

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

7212: THEN -- Completed tasks
7213: l_join_wdt := TRUE;
7214: END IF;
7215:
7216: l_insert_cc := 'INSERT INTO wms_waveplan_tasks_temp( ';
7217: l_insert_cc := l_insert_cc || 'transaction_temp_id ';
7218: l_insert_cc := l_insert_cc || ', inventory_item_id ';
7219: l_insert_cc := l_insert_cc || ', item ';
7220: l_insert_cc := l_insert_cc || ', organization_id ';

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

7595: -- Build the generic where section of the query
7596: IF p_add
7597: THEN
7598: l_where_cc :=
7599: 'WHERE NOT exists (SELECT 1 FROM wms_waveplan_tasks_temp ';
7600: l_where_cc :=
7601: l_where_cc
7602: || 'WHERE transaction_temp_id = mcce.cycle_count_entry_id ';
7603: l_where_cc := l_where_cc || 'AND task_type_id = 3) ';

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

9269:
9270: -- Prodedure query_tasks
9271: -- Input: Parameters that define the kind of task
9272: -- Output: This procedure populates the global temp table
9273: -- wms_waveplan_tasks_temp based on the input parameters.
9274: PROCEDURE query_tasks (
9275: p_add BOOLEAN DEFAULT FALSE,
9276: p_organization_id NUMBER DEFAULT NULL,
9277: p_subinventory_code VARCHAR2 DEFAULT NULL,

Line 9401: DELETE FROM wms_waveplan_tasks_temp;

9397: IF NOT p_add
9398: THEN
9399: wms_plan_tasks_pvt.clear_globals ();
9400:
9401: DELETE FROM wms_waveplan_tasks_temp;
9402:
9403: g_record_count := 0;
9404: END IF;
9405:

Line 9869: DELETE FROM wms_waveplan_tasks_temp

9865: IF l_debug = 1 THEN
9866: debug('Done populating merged tasks. Delete unwanted tasks','query_tasks');
9867: END IF;
9868:
9869: DELETE FROM wms_waveplan_tasks_temp
9870: WHERE status_id = 1;
9871:
9872: 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
9873: g_record_count := g_record_count - SQL%ROWCOUNT;

Line 9887: DELETE FROM wms_waveplan_tasks_temp

9883:
9884: /* Bug - 5446146 If a user task type has been entered, delete the records which are not associated with a user task type */
9885: IF p_user_task_type_id IS NOT NULL THEN
9886:
9887: DELETE FROM wms_waveplan_tasks_temp
9888: WHERE user_task_type_id IS NULL;
9889:
9890: g_record_count := g_record_count - SQL%ROWCOUNT;
9891: END IF;

Line 9977: l_message wms_waveplan_tasks_temp.error%TYPE;

9973: )
9974: IS
9975: l_task_id NUMBER;
9976: l_index NUMBER;
9977: l_message wms_waveplan_tasks_temp.error%TYPE;
9978: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
9979:
9980: TYPE status_table_type IS TABLE OF wms_waveplan_tasks_temp.status%TYPE;
9981:

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

9976: l_index NUMBER;
9977: l_message wms_waveplan_tasks_temp.error%TYPE;
9978: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
9979:
9980: TYPE status_table_type IS TABLE OF wms_waveplan_tasks_temp.status%TYPE;
9981:
9982: l_transaction_temp_ids wms_waveplan_tasks_pvt.transaction_temp_table_type;
9983: l_task_type_ids wms_waveplan_tasks_pvt.task_type_id_table_type;
9984: l_statuses status_table_type;

Line 10002: UPDATE wms_waveplan_tasks_temp

9998: g_cannot_unrelease_cc := fnd_message.get;
9999: END IF;
10000:
10001: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
10002: UPDATE wms_waveplan_tasks_temp
10003: SET RESULT = 'X'
10004: WHERE transaction_temp_id = p_transaction_temp_id (i)
10005: AND task_type_id = p_task_type_id (i);
10006:

Line 10018: UPDATE wms_waveplan_tasks_temp

10014: -- 6 Move Order Issue
10015: -- 7 Staging Move
10016:
10017: -- Cannot update putaway tasks or staging moves
10018: UPDATE wms_waveplan_tasks_temp
10019: SET RESULT = 'E',
10020: error =
10021: DECODE (task_type_id,
10022: 2, g_cannot_update_putaway,

Line 10030: UPDATE wms_waveplan_tasks_temp

10026:
10027: -- Cannot set cycle count tasks to unreleased
10028: IF p_to_status_id = 8
10029: THEN
10030: UPDATE wms_waveplan_tasks_temp
10031: SET RESULT = 'E',
10032: error = g_cannot_unrelease_cc
10033: WHERE RESULT = 'X' AND task_type_id = 3;
10034: END IF;

Line 10041: FROM wms_waveplan_tasks_temp

10037: IF p_to_status_id IS NOT NULL
10038: THEN
10039: SELECT transaction_temp_id, task_type_id, status
10040: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
10041: FROM wms_waveplan_tasks_temp
10042: WHERE RESULT = 'X'
10043: AND NOT ( (status_id = 8 AND p_to_status_id IN (1, 2)
10044: ) -- Unreleased to pending or queued
10045: OR (status_id = 1 AND p_to_status_id IN (2, 8)

Line 10068: UPDATE wms_waveplan_tasks_temp

10064: l_messages (i) := fnd_message.get;
10065: END LOOP;
10066:
10067: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10068: UPDATE wms_waveplan_tasks_temp
10069: SET RESULT = 'E',
10070: error = l_messages (i)
10071: WHERE transaction_temp_id = l_transaction_temp_ids (i)
10072: AND task_type_id = l_task_type_ids (i);

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

10079:
10080: --BUG: 4707588
10081: SELECT wwtt.transaction_temp_id, wwtt.task_type_id, wwtt.status
10082: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
10083: FROM wms_waveplan_tasks_temp wwtt, mtl_material_transactions_temp mmtt, WMS_DISPATCHED_TASKS wdt
10084: WHERE wwtt.transaction_temp_id = wdt.transaction_temp_id AND
10085: wwtt.transaction_temp_id = mmtt.transaction_temp_id AND
10086: wwtt.RESULT = 'X' AND
10087: wwtt.status_id = 3 AND

Line 10115: UPDATE wms_waveplan_tasks_temp

10111: END LOOP;
10112:
10113:
10114: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10115: UPDATE wms_waveplan_tasks_temp
10116: SET RESULT = 'E',
10117: error = 'This group of tasks is currently being worked, cannot change status'
10118: WHERE transaction_temp_id = l_transaction_temp_ids (i)
10119: AND task_type_id = l_task_type_ids (i);

Line 10126: FROM wms_waveplan_tasks_temp wwtt

10122: -- if the original task status is Active, check if the user whom the task is assigned is
10123: -- logged on to the system
10124: SELECT transaction_temp_id, task_type_id, status
10125: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
10126: FROM wms_waveplan_tasks_temp wwtt
10127: WHERE RESULT = 'X' AND
10128: status_id = 9 AND
10129: EXISTS ( SELECT 1 FROM MTL_MOBILE_LOGIN_HIST MMLH, WMS_DISPATCHED_TASKS WDT
10130: WHERE WDT.TRANSACTION_TEMP_ID = WWTT.TRANSACTION_TEMP_ID AND

Line 10139: UPDATE wms_waveplan_tasks_temp

10135:
10136: IF l_transaction_temp_ids.COUNT > 0
10137: THEN
10138: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10139: UPDATE wms_waveplan_tasks_temp
10140: SET RESULT = 'E',
10141: error = 'This task is currently being worked, cannot change status'
10142: WHERE transaction_temp_id = l_transaction_temp_ids (i)
10143: AND task_type_id = l_task_type_ids (i);

Line 10157: UPDATE wms_waveplan_tasks_temp wwtt

10153: fnd_message.set_name ('WMS', 'WMS_CANNOT_UPDATE_EMPLOYEE');
10154: fnd_message.set_token ('EMPLOYEE', p_employee);
10155: l_message := fnd_message.get;
10156:
10157: UPDATE wms_waveplan_tasks_temp wwtt
10158: SET RESULT = 'E',
10159: error = l_message
10160: WHERE RESULT = 'X'
10161: AND NOT EXISTS (

Line 10172: FROM wms_waveplan_tasks_temp

10168:
10169: --j Develop
10170: SELECT transaction_temp_id
10171: BULK COLLECT INTO l_transaction_temp_ids_temp
10172: FROM wms_waveplan_tasks_temp
10173: WHERE RESULT = 'X';
10174:
10175: IF (l_transaction_temp_ids_temp.COUNT > 0)
10176: THEN

Line 10195: UPDATE wms_waveplan_tasks_temp wwtt

10191: ' Update_TAsk :'
10192: );
10193: end if;
10194:
10195: UPDATE wms_waveplan_tasks_temp wwtt
10196: SET RESULT = 'E',
10197: error = l_message
10198: WHERE transaction_temp_id = l_transaction_temp_ids_temp (i)
10199: AND NOT EXISTS (

Line 10210: UPDATE wms_waveplan_tasks_temp wwtt

10206: END IF;
10207: -- End of J Develop
10208: END IF;
10209:
10210: UPDATE wms_waveplan_tasks_temp wwtt
10211: SET person_resource_id =
10212: (SELECT bre.resource_id
10213: FROM bom_std_op_resources bsor, bom_resource_employees bre
10214: WHERE wwtt.user_task_type_id = bsor.standard_operation_id

Line 10225: UPDATE wms_waveplan_tasks_temp wwtt

10221: THEN
10222: -- R12: Can update User Task Type if task is dispatched, active IF
10223: -- Dispatched or Active tasks are in the process of getting updated to pending or Unreleased
10224: IF p_to_status_id IS NOT NULL THEN
10225: UPDATE wms_waveplan_tasks_temp wwtt
10226: SET RESULT = 'E',
10227: error = l_message
10228: WHERE RESULT = 'X' AND (status_id NOT IN (1, 2, 3, 8, 9) AND p_to_status_id IN (1, 8))
10229: RETURNING transaction_temp_id, task_type_id, status

Line 10234: UPDATE wms_waveplan_tasks_temp wwtt

10230: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses;
10231: ELSE
10232: -- R12: Cannot update User Task Type if task is dispatched, active or loaded IF
10233: -- Dispatched or Active tasks are NOT in the process of getting updated to pending or Unreleased
10234: UPDATE wms_waveplan_tasks_temp wwtt
10235: SET RESULT = 'E',
10236: error = l_message
10237: WHERE RESULT = 'X' AND status_id NOT IN (1, 8)
10238: RETURNING transaction_temp_id, task_type_id, status

Line 10253: UPDATE wms_waveplan_tasks_temp

10249: l_messages (i) := fnd_message.get;
10250: END LOOP;
10251:
10252: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10253: UPDATE wms_waveplan_tasks_temp
10254: SET RESULT = 'E',
10255: error = l_messages (i)
10256: WHERE transaction_temp_id = l_transaction_temp_ids (i)
10257: AND task_type_id = l_task_type_ids (i);

Line 10267: UPDATE wms_waveplan_tasks_temp wwtt

10263: THEN
10264: -- R12: Can update priority if task is dispatched, active IF
10265: -- Dispatched or Active tasks are in the process of getting updated to pending or Unreleased
10266: IF p_to_status_id IS NOT NULL THEN
10267: UPDATE wms_waveplan_tasks_temp wwtt
10268: SET RESULT = 'E',
10269: error = l_message
10270: WHERE RESULT = 'X' AND (status_id NOT IN (1, 2, 3, 8, 9) AND p_to_status_id IN (1, 8))
10271: RETURNING transaction_temp_id, task_type_id, status

Line 10276: UPDATE wms_waveplan_tasks_temp wwtt

10272: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses;
10273: ELSE
10274: -- R12: Cannot update priority if task is dispatched, active or loaded IF
10275: -- Dispatched or Active tasks are NOT in the process of getting updated to pending or Unreleased
10276: UPDATE wms_waveplan_tasks_temp wwtt
10277: SET RESULT = 'E',
10278: error = l_message
10279: WHERE RESULT = 'X' AND status_id NOT IN (1, 2, 8)
10280: RETURNING transaction_temp_id, task_type_id, status

Line 10295: UPDATE wms_waveplan_tasks_temp

10291: l_messages (i) := fnd_message.get;
10292: END LOOP;
10293:
10294: FORALL i IN l_transaction_temp_ids.FIRST .. l_transaction_temp_ids.LAST
10295: UPDATE wms_waveplan_tasks_temp
10296: SET RESULT = 'E',
10297: error = l_messages (i)
10298: WHERE transaction_temp_id = l_transaction_temp_ids (i)
10299: AND task_type_id = l_task_type_ids (i);

Line 10306: UPDATE wms_waveplan_tasks_temp

10302:
10303: -- If changing status to Queued
10304: IF p_to_status_id = 2
10305: THEN
10306: UPDATE wms_waveplan_tasks_temp
10307: SET task_id = NVL (task_id, wms_dispatched_tasks_s.NEXTVAL),
10308: status = p_to_status,
10309: status_id = p_to_status_id,
10310: priority =

Line 10336: UPDATE wms_waveplan_tasks_temp

10332: ELSE
10333: if l_debug = 1 then
10334: DEBUG ('Else Part ______________________: ', ' Update_TAsk :');
10335: end if;
10336: UPDATE wms_waveplan_tasks_temp
10337: SET task_id = DECODE (p_to_status_id, 1, NULL, 8, NULL, task_id),
10338: status = NVL (p_to_status, status),
10339: status_id = NVL (p_to_status_id, status_id),
10340: user_task_type = NVL (p_user_task_type, user_task_type), -- R12: Assign User Task Type

Line 10398: UPDATE wms_waveplan_tasks_temp

10394: end if;
10395: END IF;
10396:
10397: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
10398: UPDATE wms_waveplan_tasks_temp
10399: SET RESULT = RESULT
10400: WHERE transaction_temp_id = p_transaction_temp_id (i)
10401: AND task_type_id = p_task_type_id (i)
10402: RETURNING task_id, RESULT, error

Line 10427: l_message wms_waveplan_tasks_temp.error%TYPE;

10423: )
10424: IS
10425: l_task_id NUMBER;
10426: l_index NUMBER;
10427: l_message wms_waveplan_tasks_temp.error%TYPE;
10428:
10429: TYPE status_table_type IS TABLE OF wms_waveplan_tasks_temp.status%TYPE;
10430:
10431: l_transaction_temp_ids wms_waveplan_tasks_pvt.transaction_temp_table_type;

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

10425: l_task_id NUMBER;
10426: l_index NUMBER;
10427: l_message wms_waveplan_tasks_temp.error%TYPE;
10428:
10429: TYPE status_table_type IS TABLE OF wms_waveplan_tasks_temp.status%TYPE;
10430:
10431: l_transaction_temp_ids wms_waveplan_tasks_pvt.transaction_temp_table_type;
10432: l_task_type_ids wms_waveplan_tasks_pvt.task_type_id_table_type;
10433: l_statuses status_table_type;

Line 10452: UPDATE wms_waveplan_tasks_temp

10448: END IF;*/
10449:
10450:
10451: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
10452: UPDATE wms_waveplan_tasks_temp
10453: SET RESULT = 'X'
10454: WHERE transaction_temp_id = p_transaction_temp_id (i)
10455: AND task_type_id = p_task_type_id (i);
10456:

Line 10467: UPDATE wms_waveplan_tasks_temp

10463: -- 6 Move Order Issue
10464: -- 7 Staging Move
10465:
10466: -- Cannot update the following :
10467: UPDATE wms_waveplan_tasks_temp
10468: SET RESULT = 'E',
10469: error =
10470: DECODE (task_type_id,
10471: 1, 'Can not cancel pick task',

Line 10483: UPDATE wms_waveplan_tasks_temp

10479:
10480: /* Bug 5623122 */
10481: -- Cannot update Putaway tasks
10482: IF NOT p_is_crossdock THEN
10483: UPDATE wms_waveplan_tasks_temp
10484: SET RESULT = 'E',
10485: error =
10486: DECODE (task_type_id,
10487: 2, 'Can not cancel putaway task'

Line 10494: UPDATE wms_waveplan_tasks_temp

10490: END IF;
10491: /* End of Bug 5623122 */
10492:
10493: -- cannot update completed tasks
10494: UPDATE wms_waveplan_tasks_temp
10495: SET RESULT = 'E',
10496: error = 'Can not cancel completed tasks'
10497: WHERE RESULT = 'X' AND status_id = 6;
10498:

Line 10499: UPDATE wms_waveplan_tasks_temp

10495: SET RESULT = 'E',
10496: error = 'Can not cancel completed tasks'
10497: WHERE RESULT = 'X' AND status_id = 6;
10498:
10499: UPDATE wms_waveplan_tasks_temp
10500: SET status_id = 12,
10501: status = g_status_codes(12),
10502: is_modified = 'Y',
10503: RESULT = 'S',

Line 10508: UPDATE wms_waveplan_tasks_temp

10504: error = 'Task Canceled'
10505: WHERE RESULT = 'X';
10506:
10507: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
10508: UPDATE wms_waveplan_tasks_temp
10509: SET RESULT = RESULT
10510: WHERE transaction_temp_id = p_transaction_temp_id (i)
10511: AND task_type_id = p_task_type_id (i)
10512: RETURNING task_id, RESULT, error

Line 10534: DELETE FROM wms_waveplan_tasks_temp

10530: l_removed_count NUMBER := 0;
10531: BEGIN
10532: x_return_status := 'S';
10533: FORALL i IN p_transaction_temp_id.FIRST .. p_transaction_temp_id.LAST
10534: DELETE FROM wms_waveplan_tasks_temp
10535: WHERE transaction_temp_id = p_transaction_temp_id (i);
10536: l_removed_count := SQL%ROWCOUNT;
10537: g_record_count := g_record_count - l_removed_count;
10538: x_record_count := g_record_count;

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

10574:
10575: TYPE effective_end_date IS TABLE OF wms_dispatched_tasks.effective_end_date%TYPE
10576: INDEX BY BINARY_INTEGER;
10577:
10578: TYPE task_type_id IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE
10579: INDEX BY BINARY_INTEGER;
10580:
10581: TYPE user_task_type_id IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE -- R12: Update User Task Type Id
10582: INDEX BY BINARY_INTEGER;

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

10577:
10578: TYPE task_type_id IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE
10579: INDEX BY BINARY_INTEGER;
10580:
10581: TYPE user_task_type_id IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE -- R12: Update User Task Type Id
10582: INDEX BY BINARY_INTEGER;
10583:
10584: l_transaction_temp_id_table transaction_temp_id_table_type;
10585: l_wms_task_status_table wms_task_status_table_type;

Line 10607: FROM wms_waveplan_tasks_temp wwtt

10603: mmtt_last_update_date, wdt_last_updated_by,
10604: wdt_last_update_date, person_id, person_id_original,person_resource_id,/* Bug 5630187 - Added person_resource_id */
10605: effective_start_date, effective_end_date, status_id,
10606: status_id_original, priority, priority_original, user_task_type_id, num_of_child_tasks -- R12: Added User Task Type Id
10607: FROM wms_waveplan_tasks_temp wwtt
10608: WHERE wwtt.is_modified = 'Y';
10609:
10610: --Patchset J: Bulk picking
10611: --Get the transaction_temp_id of the children tasks

Line 10652: UPDATE wms_waveplan_tasks_temp

10648: g_plan_cancelled := fnd_message.get;
10649: END IF;
10650:
10651:
10652: UPDATE wms_waveplan_tasks_temp
10653: SET is_modified = 'N',
10654: RESULT = 'S',
10655: error = g_plan_cancelled
10656: WHERE transaction_temp_id = rec_wwtt.transaction_temp_id;

Line 10834: FROM wms_waveplan_tasks_temp wwtt

10830: DELETE wms_dispatched_tasks wdt
10831: WHERE wdt.status IN (2, 3, 9) -- R12: Delete the Active or Dispatched tasks which were updated to pending/Unreleased
10832: AND wdt.transaction_temp_id IN (
10833: SELECT transaction_temp_id
10834: FROM wms_waveplan_tasks_temp wwtt
10835: WHERE wwtt.status_id IN (1, 8)
10836: AND wwtt.is_modified = 'Y');
10837: if l_debug = 1 then
10838: DEBUG ('No of records deleted are-555 ' || SQL%ROWCOUNT);

Line 10863: FROM wms_waveplan_tasks_temp wwtt

10859: NULL, l_update_date, p_user_id, l_update_date, p_user_id,
10860: p_login_id, wwtt.task_type_id, wwtt.priority,
10861: wwtt.move_order_line_id, wwtt.operation_plan_id,
10862: wwtt.to_lpn_id
10863: FROM wms_waveplan_tasks_temp wwtt
10864: WHERE wwtt.status_id = 2
10865: AND wwtt.status_id_original IN (1, 8)
10866: AND wwtt.is_modified = 'Y'
10867: AND NOT EXISTS (

Line 10908: UPDATE wms_waveplan_tasks_temp

10904: END IF;
10905:
10906: -- forall i IN l_transaction_temp_id_table.first..l_transaction_temp_id_table.last
10907: FORALL i IN 1 .. l_transaction_temp_id_table.COUNT
10908: UPDATE wms_waveplan_tasks_temp
10909: SET RESULT = 'S',
10910: error = g_task_saved,
10911: is_modified = 'N',
10912: person_id_original = l_person_id_table (i),

Line 10952: UPDATE wms_waveplan_tasks_temp

10948: , x_msg_data => x_msg_data
10949: , x_msg_count => x_msg_count
10950: );
10951: IF x_return_status = fnd_api.g_ret_sts_success THEN
10952: UPDATE wms_waveplan_tasks_temp
10953: SET RESULT = 'S',
10954: error = 'Task Cancelled',
10955: is_modified = 'N'
10956: WHERE transaction_temp_id = rec_wwtt.transaction_temp_id;

Line 10967: UPDATE wms_waveplan_tasks_temp

10963:
10964: fnd_message.set_name ('FND', 'FORM_RECORD_CHANGED');
10965: l_error_message := fnd_message.get;
10966:
10967: UPDATE wms_waveplan_tasks_temp
10968: SET RESULT = 'E',
10969: error = l_error_message
10970: WHERE is_modified = 'Y';
10971:

Line 11007: FROM wms_waveplan_tasks_temp

11003: IS
11004: CURSOR status_cursor
11005: IS
11006: SELECT status_id, COUNT (*) task_count
11007: FROM wms_waveplan_tasks_temp
11008: WHERE task_type_id = NVL (p_task_type_id, task_type_id)
11009: GROUP BY status_id;
11010:
11011: l_loop_index NUMBER;

Line 11054: FROM wms_waveplan_tasks_temp

11050: IS
11051: CURSOR type_cursor
11052: IS
11053: SELECT task_type_id, COUNT (*) task_count
11054: FROM wms_waveplan_tasks_temp
11055: WHERE task_type_id = NVL (p_task_type_id, task_type_id)
11056: GROUP BY task_type_id;
11057:
11058: l_loop_index NUMBER;

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

11104: x_msg_data OUT NOCOPY VARCHAR2,
11105: x_msg_count OUT NOCOPY NUMBER
11106: )
11107: IS
11108: TYPE user_task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE
11109: INDEX BY BINARY_INTEGER;
11110:
11111: TYPE time_type IS TABLE OF wms_waveplan_tasks_temp.time_estimate%TYPE
11112: INDEX BY BINARY_INTEGER;

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

11107: IS
11108: TYPE user_task_type_id_type IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE
11109: INDEX BY BINARY_INTEGER;
11110:
11111: TYPE time_type IS TABLE OF wms_waveplan_tasks_temp.time_estimate%TYPE
11112: INDEX BY BINARY_INTEGER;
11113:
11114: TYPE volume_type IS TABLE OF wms_waveplan_tasks_temp.unit_volume%TYPE
11115: INDEX BY BINARY_INTEGER;

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

11110:
11111: TYPE time_type IS TABLE OF wms_waveplan_tasks_temp.time_estimate%TYPE
11112: INDEX BY BINARY_INTEGER;
11113:
11114: TYPE volume_type IS TABLE OF wms_waveplan_tasks_temp.unit_volume%TYPE
11115: INDEX BY BINARY_INTEGER;
11116:
11117: TYPE weight_type IS TABLE OF wms_waveplan_tasks_temp.unit_weight%TYPE
11118: INDEX BY BINARY_INTEGER;

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

11113:
11114: TYPE volume_type IS TABLE OF wms_waveplan_tasks_temp.unit_volume%TYPE
11115: INDEX BY BINARY_INTEGER;
11116:
11117: TYPE weight_type IS TABLE OF wms_waveplan_tasks_temp.unit_weight%TYPE
11118: INDEX BY BINARY_INTEGER;
11119:
11120: TYPE volume_uom_type IS TABLE OF wms_waveplan_tasks_temp.volume_uom_code%TYPE
11121: INDEX BY BINARY_INTEGER;

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

11116:
11117: TYPE weight_type IS TABLE OF wms_waveplan_tasks_temp.unit_weight%TYPE
11118: INDEX BY BINARY_INTEGER;
11119:
11120: TYPE volume_uom_type IS TABLE OF wms_waveplan_tasks_temp.volume_uom_code%TYPE
11121: INDEX BY BINARY_INTEGER;
11122:
11123: TYPE weight_uom_type IS TABLE OF wms_waveplan_tasks_temp.weight_uom_code%TYPE
11124: INDEX BY BINARY_INTEGER;

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

11119:
11120: TYPE volume_uom_type IS TABLE OF wms_waveplan_tasks_temp.volume_uom_code%TYPE
11121: INDEX BY BINARY_INTEGER;
11122:
11123: TYPE weight_uom_type IS TABLE OF wms_waveplan_tasks_temp.weight_uom_code%TYPE
11124: INDEX BY BINARY_INTEGER;
11125:
11126: TYPE item_id_type IS TABLE OF wms_waveplan_tasks_temp.inventory_item_id%TYPE
11127: INDEX BY BINARY_INTEGER;

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

11122:
11123: TYPE weight_uom_type IS TABLE OF wms_waveplan_tasks_temp.weight_uom_code%TYPE
11124: INDEX BY BINARY_INTEGER;
11125:
11126: TYPE item_id_type IS TABLE OF wms_waveplan_tasks_temp.inventory_item_id%TYPE
11127: INDEX BY BINARY_INTEGER;
11128:
11129: TYPE quantity_type IS TABLE OF wms_waveplan_tasks_temp.transaction_quantity%TYPE
11130: INDEX BY BINARY_INTEGER;

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

11125:
11126: TYPE item_id_type IS TABLE OF wms_waveplan_tasks_temp.inventory_item_id%TYPE
11127: INDEX BY BINARY_INTEGER;
11128:
11129: TYPE quantity_type IS TABLE OF wms_waveplan_tasks_temp.transaction_quantity%TYPE
11130: INDEX BY BINARY_INTEGER;
11131:
11132: TYPE result_type IS TABLE OF wms_waveplan_tasks_temp.RESULT%TYPE
11133: INDEX BY BINARY_INTEGER;

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

11128:
11129: TYPE quantity_type IS TABLE OF wms_waveplan_tasks_temp.transaction_quantity%TYPE
11130: INDEX BY BINARY_INTEGER;
11131:
11132: TYPE result_type IS TABLE OF wms_waveplan_tasks_temp.RESULT%TYPE
11133: INDEX BY BINARY_INTEGER;
11134:
11135: TYPE ERROR_TYPE IS TABLE OF wms_waveplan_tasks_temp.error%TYPE
11136: INDEX BY BINARY_INTEGER;

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

11131:
11132: TYPE result_type IS TABLE OF wms_waveplan_tasks_temp.RESULT%TYPE
11133: INDEX BY BINARY_INTEGER;
11134:
11135: TYPE ERROR_TYPE IS TABLE OF wms_waveplan_tasks_temp.error%TYPE
11136: INDEX BY BINARY_INTEGER;
11137:
11138: l_user_task_type_id user_task_type_id_type;
11139: l_time time_type;

Line 11159: FROM wms_waveplan_tasks_temp

11155: inventory_item_id, transaction_quantity
11156: BULK COLLECT INTO l_transaction_temp_id, l_task_type_id, l_user_task_type_id,
11157: l_volume, l_volume_uom_code, l_weight, l_weight_uom_code,
11158: l_inventory_item_id, l_quantity
11159: FROM wms_waveplan_tasks_temp
11160: WHERE RESULT IN ('X', 'Y', 'Z');
11161:
11162: x_total_tasks := l_transaction_temp_id.COUNT;
11163:

Line 11495: UPDATE wms_waveplan_tasks_temp

11491: END IF;
11492: END LOOP;
11493:
11494: FORALL i IN l_transaction_temp_id.FIRST .. l_transaction_temp_id.LAST
11495: UPDATE wms_waveplan_tasks_temp
11496: SET time_estimate = l_time (i),
11497: display_weight = l_weight (i),
11498: display_volume = l_volume (i)
11499: WHERE transaction_temp_id = l_transaction_temp_id (i)

Line 11515: FROM wms_waveplan_tasks_temp wwtt, bom_standard_operations bso

11511: ROUND (SUM (wwtt.time_estimate), 1), p_time_uom,
11512: ROUND (SUM (wwtt.display_weight), 1), p_weight_uom,
11513: ROUND (SUM (wwtt.display_volume), 1), p_volume_uom,
11514: wwtt.organization_id
11515: FROM wms_waveplan_tasks_temp wwtt, bom_standard_operations bso
11516: WHERE wwtt.RESULT IN ('X', 'Y', 'Z')
11517: AND wwtt.user_task_type_id = bso.standard_operation_id(+)
11518: AND wwtt.organization_id = bso.organization_id(+)
11519: GROUP BY wwtt.user_task_type_id,

Line 11525: UPDATE wms_waveplan_tasks_temp

11521: bso.operation_description,
11522: wwtt.organization_id;
11523:
11524: FORALL i IN l_transaction_temp_id.FIRST .. l_transaction_temp_id.LAST
11525: UPDATE wms_waveplan_tasks_temp
11526: SET RESULT = l_result (i),
11527: error = l_error (i)
11528: WHERE transaction_temp_id = l_transaction_temp_id (i)
11529: AND task_type_id = l_task_type_id (i);

Line 11542: l_transaction_temp_id wms_waveplan_tasks_temp.transaction_temp_id%TYPE;

11538: x_ret_code OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
11539: p_transaction_temp_table wms_waveplan_tasks_pvt.transaction_temp_table_type
11540: )
11541: IS
11542: l_transaction_temp_id wms_waveplan_tasks_temp.transaction_temp_id%TYPE;
11543: l_return_status VARCHAR2 (1);
11544: l_msg_data VARCHAR2 (2000);
11545: l_msg_count NUMBER;
11546: l_error_code NUMBER;

Line 11557: FROM wms_waveplan_tasks_temp

11553: BEGIN
11554:
11555: SELECT transaction_temp_id
11556: INTO l_transaction_temp_id
11557: FROM wms_waveplan_tasks_temp
11558: WHERE parent_line_id = p_transaction_temp_table (i)
11559: AND status = 'Pending';
11560:
11561: l_cancel_plan := TRUE;

Line 11614: UPDATE wms_waveplan_tasks_temp

11610: END LOOP;
11611:
11612: FORALL i IN 1 .. p_transaction_temp_table.COUNT
11613:
11614: UPDATE wms_waveplan_tasks_temp
11615: SET is_modified = 'Y',
11616: status_id = 12,
11617: status = g_status_codes(12)
11618: WHERE transaction_temp_id = p_transaction_temp_table (i)

Line 11626: DELETE FROM wms_waveplan_tasks_temp

11622: DEBUG ('No of records updated are' || SQL%ROWCOUNT);
11623: end if;
11624:
11625: FORALL j IN 1..p_transaction_temp_table.COUNT
11626: DELETE FROM wms_waveplan_tasks_temp
11627: WHERE parent_line_id = p_transaction_temp_table (j)
11628: AND status_id = 1
11629: AND x_ret_code (j) = fnd_api.g_ret_sts_success;
11630: