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_PVT

Line 1: PACKAGE BODY wms_waveplan_tasks_pvt AS

1: PACKAGE BODY wms_waveplan_tasks_pvt AS
2: /* $Header: WMSVTKPB.pls 120.66.12020000.12 2013/03/26 13:02:18 pyerrams ship $ */
3: --
4: g_record_count NUMBER;
5: -- Messages

Line 119: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,

115: END;
116:
117: --Procedures for labor estimations
118: PROCEDURE mark_rows (
119: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
120: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
121: x_return_status OUT NOCOPY VARCHAR2
122: )
123: IS

Line 120: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,

116:
117: --Procedures for labor estimations
118: PROCEDURE mark_rows (
119: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
120: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
121: x_return_status OUT NOCOPY VARCHAR2
122: )
123: IS
124: BEGIN

Line 479: l_parent_temp_ids_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;

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
482: IF l_debug = 1
483: THEN

Line 486: 'WMS_WAVEPLAN_TASKS_PVT'

482: IF l_debug = 1
483: THEN
484: DEBUG ( 'set_num_of_cc_child_tasks entered '
485: || TO_CHAR (SYSDATE, 'YYYY-MM-DD HH:DD:SS'),
486: 'WMS_WAVEPLAN_TASKS_PVT'
487: );
488: END IF;
489:
490: l_progress := 10;

Line 532: 'WMS_WAVEPLAN_TASKS_PVT'

528: IF l_debug = 1
529: THEN
530: DEBUG ( 'set_num_of_cc_child_tasks exited '
531: || TO_CHAR (SYSDATE, 'YYYY-MM-DD HH:DD:SS'),
532: 'WMS_WAVEPLAN_TASKS_PVT'
533: );
534: END IF;
535: EXCEPTION
536: WHEN OTHERS

Line 543: 'WMS_WAVEPLAN_TASKS_PVT'

539: THEN
540: DEBUG
541: ( 'set_num_of_cc_child_tasks OTHERS exception after l_progress '
542: || l_progress,
543: 'WMS_WAVEPLAN_TASKS_PVT'
544: );
545: DEBUG
546: ( 'sqlerrm '
547: || sqlerrm,

Line 548: 'WMS_WAVEPLAN_TASKS_PVT'

544: );
545: DEBUG
546: ( 'sqlerrm '
547: || sqlerrm,
548: 'WMS_WAVEPLAN_TASKS_PVT'
549: );
550: END IF;
551: END set_num_of_cc_child_tasks;
552: -- Finding CC child_tasks count END

Line 567: l_parent_temp_ids_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;

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
569: IF l_debug = 1
570: THEN
571: DEBUG ( 'set_num_of_child_tasks entered '

Line 573: 'WMS_WAVEPLAN_TASKS_PVT'

569: IF l_debug = 1
570: THEN
571: DEBUG ( 'set_num_of_child_tasks entered '
572: || TO_CHAR (SYSDATE, 'YYYY-MM-DD HH:DD:SS'),
573: 'WMS_WAVEPLAN_TASKS_PVT'
574: );
575: END IF;
576:
577: l_progress := 10;

Line 607: 'WMS_WAVEPLAN_TASKS_PVT'

603: IF l_debug = 1
604: THEN
605: DEBUG ( 'set_num_of_child_tasks exited '
606: || TO_CHAR (SYSDATE, 'YYYY-MM-DD HH:DD:SS'),
607: 'WMS_WAVEPLAN_TASKS_PVT'
608: );
609: END IF;
610: EXCEPTION
611: WHEN NO_DATA_FOUND

Line 618: 'WMS_WAVEPLAN_TASKS_PVT'

614: THEN
615: DEBUG
616: ( 'set_num_of_child_tasks no_data_found after l_progress '
617: || l_progress,
618: 'WMS_WAVEPLAN_TASKS_PVT'
619: );
620:
621: IF l_progress = 10
622: THEN

Line 627: 'WMS_WAVEPLAN_TASKS_PVT'

623: DEBUG
624: ( 'set_num_of_child_tasks exited normally with no parent '
625: || 'task found '
626: || TO_CHAR (SYSDATE, 'YYYY-MM-DD HH:DD:SS'),
627: 'WMS_WAVEPLAN_TASKS_PVT'
628: );
629: END IF;
630: END IF;
631: WHEN OTHERS

Line 638: 'WMS_WAVEPLAN_TASKS_PVT'

634: THEN
635: DEBUG
636: ( 'set_num_of_child_tasks OTHERS exception after l_progress '
637: || l_progress,
638: 'WMS_WAVEPLAN_TASKS_PVT'
639: );
640: END IF;
641: END set_num_of_child_tasks;
642:

Line 8981: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type := wms_waveplan_tasks_pvt.g_task_type_cycle_count;

8977: IF DBMS_SQL.FETCH_ROWS(l_query_handle) = 0 THEN
8978: EXIT;
8979: END IF;
8980: END LOOP;
8981: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type := wms_waveplan_tasks_pvt.g_task_type_cycle_count;
8982: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count := g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count + dbms_sql.last_row_count;
8983: IF l_debug = 1 THEN
8984: debug(' Query :' || l_query , 'query_cc_tasks');
8985: debug('Task Type :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type, 'query_cycle_count_tasks');

Line 8982: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count := g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count + dbms_sql.last_row_count;

8978: EXIT;
8979: END IF;
8980: END LOOP;
8981: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type := wms_waveplan_tasks_pvt.g_task_type_cycle_count;
8982: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count := g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count + dbms_sql.last_row_count;
8983: IF l_debug = 1 THEN
8984: debug(' Query :' || l_query , 'query_cc_tasks');
8985: debug('Task Type :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type, 'query_cycle_count_tasks');
8986: debug('TaskCount :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count, 'query_cycle_count_tasks');

Line 8985: debug('Task Type :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type, 'query_cycle_count_tasks');

8981: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type := wms_waveplan_tasks_pvt.g_task_type_cycle_count;
8982: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count := g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count + dbms_sql.last_row_count;
8983: IF l_debug = 1 THEN
8984: debug(' Query :' || l_query , 'query_cc_tasks');
8985: debug('Task Type :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type, 'query_cycle_count_tasks');
8986: debug('TaskCount :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count, 'query_cycle_count_tasks');
8987: END IF;
8988: END IF;
8989:

Line 8986: debug('TaskCount :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count, 'query_cycle_count_tasks');

8982: g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count := g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count + dbms_sql.last_row_count;
8983: IF l_debug = 1 THEN
8984: debug(' Query :' || l_query , 'query_cc_tasks');
8985: debug('Task Type :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type, 'query_cycle_count_tasks');
8986: debug('TaskCount :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count, 'query_cycle_count_tasks');
8987: END IF;
8988: END IF;
8989:
8990: DBMS_SQL.close_cursor(l_query_handle);

Line 10956: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,

10952: END;
10953:
10954:
10955: PROCEDURE update_task (
10956: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
10957: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
10958: p_employee IN VARCHAR2,
10959: p_employee_id IN NUMBER,
10960: p_user_task_type IN VARCHAR2,

Line 10957: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,

10953:
10954:
10955: PROCEDURE update_task (
10956: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
10957: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
10958: p_employee IN VARCHAR2,
10959: p_employee_id IN NUMBER,
10960: p_user_task_type IN VARCHAR2,
10961: p_user_task_type_id IN NUMBER,

Line 10972: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,

10968: p_to_status_id IN NUMBER,
10969: p_update_priority_type IN VARCHAR2,
10970: p_update_priority IN NUMBER,
10971: p_clear_priority IN VARCHAR2,
10972: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
10973: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
10974: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,
10975: x_return_status OUT NOCOPY VARCHAR2,
10976: x_return_msg OUT NOCOPY VARCHAR2,

Line 10973: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,

10969: p_update_priority_type IN VARCHAR2,
10970: p_update_priority IN NUMBER,
10971: p_clear_priority IN VARCHAR2,
10972: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
10973: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
10974: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,
10975: x_return_status OUT NOCOPY VARCHAR2,
10976: x_return_msg OUT NOCOPY VARCHAR2,
10977: x_msg_count OUT NOCOPY NUMBER

Line 10974: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,

10970: p_update_priority IN NUMBER,
10971: p_clear_priority IN VARCHAR2,
10972: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
10973: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
10974: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,
10975: x_return_status OUT NOCOPY VARCHAR2,
10976: x_return_msg OUT NOCOPY VARCHAR2,
10977: x_msg_count OUT NOCOPY NUMBER
10978: )

Line 10987: l_transaction_temp_ids wms_waveplan_tasks_pvt.transaction_temp_table_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;
10990: l_messages wms_waveplan_tasks_pvt.message_table_type;
10991: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;

Line 10988: l_task_type_ids wms_waveplan_tasks_pvt.task_type_id_table_type;

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;
10990: l_messages wms_waveplan_tasks_pvt.message_table_type;
10991: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;
10992: l_device_id NUMBER;

Line 10990: l_messages wms_waveplan_tasks_pvt.message_table_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;
10990: l_messages wms_waveplan_tasks_pvt.message_table_type;
10991: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;
10992: l_device_id NUMBER;
10993: BEGIN
10994: IF g_cannot_update_putaway IS NULL

Line 10991: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;

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;
10990: l_messages wms_waveplan_tasks_pvt.message_table_type;
10991: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;
10992: l_device_id NUMBER;
10993: BEGIN
10994: IF g_cannot_update_putaway IS NULL
10995: THEN

Line 11419: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,

11415: DEBUG ('Sql Error: ' || SQLERRM, 'Task Planning.Task Update');
11416: END update_task;
11417:
11418: PROCEDURE cancel_task (
11419: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
11420: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
11421: p_is_crossdock IN BOOLEAN DEFAULT FALSE, /* Bug 5623122 */
11422: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
11423: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,

Line 11420: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,

11416: END update_task;
11417:
11418: PROCEDURE cancel_task (
11419: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
11420: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
11421: p_is_crossdock IN BOOLEAN DEFAULT FALSE, /* Bug 5623122 */
11422: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
11423: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
11424: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,

Line 11422: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,

11418: PROCEDURE cancel_task (
11419: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
11420: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
11421: p_is_crossdock IN BOOLEAN DEFAULT FALSE, /* Bug 5623122 */
11422: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
11423: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
11424: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,
11425: x_return_status OUT NOCOPY VARCHAR2,
11426: x_return_msg OUT NOCOPY VARCHAR2,

Line 11423: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,

11419: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
11420: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
11421: p_is_crossdock IN BOOLEAN DEFAULT FALSE, /* Bug 5623122 */
11422: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
11423: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
11424: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,
11425: x_return_status OUT NOCOPY VARCHAR2,
11426: x_return_msg OUT NOCOPY VARCHAR2,
11427: x_msg_count OUT NOCOPY NUMBER

Line 11424: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,

11420: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
11421: p_is_crossdock IN BOOLEAN DEFAULT FALSE, /* Bug 5623122 */
11422: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
11423: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
11424: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,
11425: x_return_status OUT NOCOPY VARCHAR2,
11426: x_return_msg OUT NOCOPY VARCHAR2,
11427: x_msg_count OUT NOCOPY NUMBER
11428: )

Line 11436: l_transaction_temp_ids wms_waveplan_tasks_pvt.transaction_temp_table_type;

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;
11439: l_messages wms_waveplan_tasks_pvt.message_table_type;
11440: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;

Line 11437: l_task_type_ids wms_waveplan_tasks_pvt.task_type_id_table_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;
11439: l_messages wms_waveplan_tasks_pvt.message_table_type;
11440: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;
11441: BEGIN

Line 11439: l_messages wms_waveplan_tasks_pvt.message_table_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;
11439: l_messages wms_waveplan_tasks_pvt.message_table_type;
11440: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;
11441: BEGIN
11442:
11443: /*IF g_cannot_update_putaway IS NULL

Line 11440: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;

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;
11439: l_messages wms_waveplan_tasks_pvt.message_table_type;
11440: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;
11441: BEGIN
11442:
11443: /*IF g_cannot_update_putaway IS NULL
11444: THEN

Line 11529: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,

11525: DEBUG ('Sql Error: ' || SQLERRM, 'Task Planning.Cancel Task');
11526: END cancel_task;
11527:
11528: PROCEDURE remove_tasks (
11529: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
11530: x_record_count OUT NOCOPY NUMBER,
11531: x_return_status OUT NOCOPY VARCHAR2,
11532: x_msg_data OUT NOCOPY VARCHAR2
11533: )

Line 12232: p_time_per_task IN wms_waveplan_tasks_pvt.time_per_task_table_type,

12228: END get_type_dist;
12229:
12230: PROCEDURE calculate_summary (
12231: p_calculate_time IN BOOLEAN DEFAULT FALSE,
12232: p_time_per_task IN wms_waveplan_tasks_pvt.time_per_task_table_type,
12233: p_time_per_task_uom IN wms_waveplan_tasks_pvt.time_uom_table_type,
12234: p_time_uom_code IN VARCHAR2 DEFAULT NULL,
12235: p_time_uom IN VARCHAR2 DEFAULT NULL,
12236: p_calculate_volume IN BOOLEAN DEFAULT FALSE,

Line 12233: p_time_per_task_uom IN wms_waveplan_tasks_pvt.time_uom_table_type,

12229:
12230: PROCEDURE calculate_summary (
12231: p_calculate_time IN BOOLEAN DEFAULT FALSE,
12232: p_time_per_task IN wms_waveplan_tasks_pvt.time_per_task_table_type,
12233: p_time_per_task_uom IN wms_waveplan_tasks_pvt.time_uom_table_type,
12234: p_time_uom_code IN VARCHAR2 DEFAULT NULL,
12235: p_time_uom IN VARCHAR2 DEFAULT NULL,
12236: p_calculate_volume IN BOOLEAN DEFAULT FALSE,
12237: p_volume_uom_code IN VARCHAR2 DEFAULT NULL,

Line 12681: x_ret_code OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,

12677: END;
12678:
12679: PROCEDURE cancel_plans (
12680: x_return_status OUT NOCOPY VARCHAR2,
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;

Line 12682: p_transaction_temp_table wms_waveplan_tasks_pvt.transaction_temp_table_type

12678:
12679: PROCEDURE cancel_plans (
12680: x_return_status OUT NOCOPY VARCHAR2,
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);

Line 13337: END wms_waveplan_tasks_pvt;

13333: EXCEPTION
13334: WHEN OTHERS THEN
13335: DEBUG('ENTERED INTOEXCEPTION'||SQLERRM);
13336: END query_picknone_bulk_tasks;
13337: END wms_waveplan_tasks_pvt;