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.45.12010000.3 2008/10/08 10:40:15 satishku 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 480: l_parent_temp_ids_tbl wms_waveplan_tasks_pvt.transaction_temp_table_type;

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
482: IF l_debug = 1
483: THEN
484: DEBUG ( 'set_num_of_child_tasks entered '

Line 486: 'WMS_WAVEPLAN_TASKS_PVT'

482: IF l_debug = 1
483: THEN
484: DEBUG ( 'set_num_of_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 520: 'WMS_WAVEPLAN_TASKS_PVT'

516: IF l_debug = 1
517: THEN
518: DEBUG ( 'set_num_of_child_tasks exited '
519: || TO_CHAR (SYSDATE, 'YYYY-MM-DD HH:DD:SS'),
520: 'WMS_WAVEPLAN_TASKS_PVT'
521: );
522: END IF;
523: EXCEPTION
524: WHEN NO_DATA_FOUND

Line 531: 'WMS_WAVEPLAN_TASKS_PVT'

527: THEN
528: DEBUG
529: ( 'set_num_of_child_tasks no_data_found after l_progress '
530: || l_progress,
531: 'WMS_WAVEPLAN_TASKS_PVT'
532: );
533:
534: IF l_progress = 10
535: THEN

Line 540: 'WMS_WAVEPLAN_TASKS_PVT'

536: DEBUG
537: ( 'set_num_of_child_tasks exited normally with no parent '
538: || 'task found '
539: || TO_CHAR (SYSDATE, 'YYYY-MM-DD HH:DD:SS'),
540: 'WMS_WAVEPLAN_TASKS_PVT'
541: );
542: END IF;
543: END IF;
544: WHEN OTHERS

Line 551: 'WMS_WAVEPLAN_TASKS_PVT'

547: THEN
548: DEBUG
549: ( 'set_num_of_child_tasks OTHERS exception after l_progress '
550: || l_progress,
551: 'WMS_WAVEPLAN_TASKS_PVT'
552: );
553: END IF;
554: END set_num_of_child_tasks;
555:

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

8190: IF DBMS_SQL.FETCH_ROWS(l_query_handle) = 0 THEN
8191: EXIT;
8192: END IF;
8193: END LOOP;
8194: 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;
8195: 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;
8196: IF l_debug = 1 THEN
8197: debug(' Query :' || l_query , 'query_cc_tasks');
8198: 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 8195: 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;

8191: EXIT;
8192: END IF;
8193: END LOOP;
8194: 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;
8195: 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;
8196: IF l_debug = 1 THEN
8197: debug(' Query :' || l_query , 'query_cc_tasks');
8198: debug('Task Type :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type, 'query_cycle_count_tasks');
8199: debug('TaskCount :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count, 'query_cycle_count_tasks');

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

8194: 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;
8195: 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;
8196: IF l_debug = 1 THEN
8197: debug(' Query :' || l_query , 'query_cc_tasks');
8198: debug('Task Type :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type, 'query_cycle_count_tasks');
8199: debug('TaskCount :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count, 'query_cycle_count_tasks');
8200: END IF;
8201: END IF;
8202:

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

8195: 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;
8196: IF l_debug = 1 THEN
8197: debug(' Query :' || l_query , 'query_cc_tasks');
8198: debug('Task Type :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).wms_task_type, 'query_cycle_count_tasks');
8199: debug('TaskCount :' || g_wms_task_summary_tbl(wms_waveplan_tasks_pvt.g_task_type_cycle_count).task_count, 'query_cycle_count_tasks');
8200: END IF;
8201: END IF;
8202:
8203: DBMS_SQL.close_cursor(l_query_handle);

Line 9951: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,

9947: END;
9948:
9949:
9950: PROCEDURE update_task (
9951: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
9952: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
9953: p_employee IN VARCHAR2,
9954: p_employee_id IN NUMBER,
9955: p_user_task_type IN VARCHAR2,

Line 9952: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,

9948:
9949:
9950: PROCEDURE update_task (
9951: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
9952: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
9953: p_employee IN VARCHAR2,
9954: p_employee_id IN NUMBER,
9955: p_user_task_type IN VARCHAR2,
9956: p_user_task_type_id IN NUMBER,

Line 9967: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,

9963: p_to_status_id IN NUMBER,
9964: p_update_priority_type IN VARCHAR2,
9965: p_update_priority IN NUMBER,
9966: p_clear_priority IN VARCHAR2,
9967: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
9968: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
9969: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,
9970: x_return_status OUT NOCOPY VARCHAR2,
9971: x_return_msg OUT NOCOPY VARCHAR2,

Line 9968: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,

9964: p_update_priority_type IN VARCHAR2,
9965: p_update_priority IN NUMBER,
9966: p_clear_priority IN VARCHAR2,
9967: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
9968: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
9969: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,
9970: x_return_status OUT NOCOPY VARCHAR2,
9971: x_return_msg OUT NOCOPY VARCHAR2,
9972: x_msg_count OUT NOCOPY NUMBER

Line 9969: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,

9965: p_update_priority IN NUMBER,
9966: p_clear_priority IN VARCHAR2,
9967: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
9968: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
9969: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,
9970: x_return_status OUT NOCOPY VARCHAR2,
9971: x_return_msg OUT NOCOPY VARCHAR2,
9972: x_msg_count OUT NOCOPY NUMBER
9973: )

Line 9982: l_transaction_temp_ids wms_waveplan_tasks_pvt.transaction_temp_table_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;
9985: l_messages wms_waveplan_tasks_pvt.message_table_type;
9986: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;

Line 9983: l_task_type_ids wms_waveplan_tasks_pvt.task_type_id_table_type;

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;
9985: l_messages wms_waveplan_tasks_pvt.message_table_type;
9986: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;
9987: l_device_id NUMBER;

Line 9985: l_messages wms_waveplan_tasks_pvt.message_table_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;
9985: l_messages wms_waveplan_tasks_pvt.message_table_type;
9986: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;
9987: l_device_id NUMBER;
9988: BEGIN
9989: IF g_cannot_update_putaway IS NULL

Line 9986: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;

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;
9985: l_messages wms_waveplan_tasks_pvt.message_table_type;
9986: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;
9987: l_device_id NUMBER;
9988: BEGIN
9989: IF g_cannot_update_putaway IS NULL
9990: THEN

Line 10414: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,

10410: DEBUG ('Sql Error: ' || SQLERRM, 'Task Planning.Task Update');
10411: END update_task;
10412:
10413: PROCEDURE cancel_task (
10414: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
10415: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
10416: p_is_crossdock IN BOOLEAN DEFAULT FALSE, /* Bug 5623122 */
10417: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
10418: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,

Line 10415: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,

10411: END update_task;
10412:
10413: PROCEDURE cancel_task (
10414: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
10415: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
10416: p_is_crossdock IN BOOLEAN DEFAULT FALSE, /* Bug 5623122 */
10417: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
10418: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
10419: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,

Line 10417: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,

10413: PROCEDURE cancel_task (
10414: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
10415: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
10416: p_is_crossdock IN BOOLEAN DEFAULT FALSE, /* Bug 5623122 */
10417: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
10418: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
10419: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,
10420: x_return_status OUT NOCOPY VARCHAR2,
10421: x_return_msg OUT NOCOPY VARCHAR2,

Line 10418: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,

10414: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
10415: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
10416: p_is_crossdock IN BOOLEAN DEFAULT FALSE, /* Bug 5623122 */
10417: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
10418: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
10419: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,
10420: x_return_status OUT NOCOPY VARCHAR2,
10421: x_return_msg OUT NOCOPY VARCHAR2,
10422: x_msg_count OUT NOCOPY NUMBER

Line 10419: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,

10415: p_task_type_id IN wms_waveplan_tasks_pvt.task_type_id_table_type,
10416: p_is_crossdock IN BOOLEAN DEFAULT FALSE, /* Bug 5623122 */
10417: x_result OUT NOCOPY wms_waveplan_tasks_pvt.result_table_type,
10418: x_message OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,
10419: x_task_id OUT NOCOPY wms_waveplan_tasks_pvt.task_id_table_type,
10420: x_return_status OUT NOCOPY VARCHAR2,
10421: x_return_msg OUT NOCOPY VARCHAR2,
10422: x_msg_count OUT NOCOPY NUMBER
10423: )

Line 10431: l_transaction_temp_ids wms_waveplan_tasks_pvt.transaction_temp_table_type;

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

Line 10432: l_task_type_ids wms_waveplan_tasks_pvt.task_type_id_table_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;
10434: l_messages wms_waveplan_tasks_pvt.message_table_type;
10435: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;
10436: BEGIN

Line 10434: l_messages wms_waveplan_tasks_pvt.message_table_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;
10434: l_messages wms_waveplan_tasks_pvt.message_table_type;
10435: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;
10436: BEGIN
10437:
10438: /*IF g_cannot_update_putaway IS NULL

Line 10435: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;

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;
10434: l_messages wms_waveplan_tasks_pvt.message_table_type;
10435: l_transaction_temp_ids_temp wms_waveplan_tasks_pvt.transaction_temp_table_type;
10436: BEGIN
10437:
10438: /*IF g_cannot_update_putaway IS NULL
10439: THEN

Line 10524: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,

10520: DEBUG ('Sql Error: ' || SQLERRM, 'Task Planning.Cancel Task');
10521: END cancel_task;
10522:
10523: PROCEDURE remove_tasks (
10524: p_transaction_temp_id IN wms_waveplan_tasks_pvt.transaction_temp_table_type,
10525: x_record_count OUT NOCOPY NUMBER,
10526: x_return_status OUT NOCOPY VARCHAR2,
10527: x_msg_data OUT NOCOPY VARCHAR2
10528: )

Line 11089: p_time_per_task IN wms_waveplan_tasks_pvt.time_per_task_table_type,

11085: END get_type_dist;
11086:
11087: PROCEDURE calculate_summary (
11088: p_calculate_time IN BOOLEAN DEFAULT FALSE,
11089: p_time_per_task IN wms_waveplan_tasks_pvt.time_per_task_table_type,
11090: p_time_per_task_uom IN wms_waveplan_tasks_pvt.time_uom_table_type,
11091: p_time_uom_code IN VARCHAR2 DEFAULT NULL,
11092: p_time_uom IN VARCHAR2 DEFAULT NULL,
11093: p_calculate_volume IN BOOLEAN DEFAULT FALSE,

Line 11090: p_time_per_task_uom IN wms_waveplan_tasks_pvt.time_uom_table_type,

11086:
11087: PROCEDURE calculate_summary (
11088: p_calculate_time IN BOOLEAN DEFAULT FALSE,
11089: p_time_per_task IN wms_waveplan_tasks_pvt.time_per_task_table_type,
11090: p_time_per_task_uom IN wms_waveplan_tasks_pvt.time_uom_table_type,
11091: p_time_uom_code IN VARCHAR2 DEFAULT NULL,
11092: p_time_uom IN VARCHAR2 DEFAULT NULL,
11093: p_calculate_volume IN BOOLEAN DEFAULT FALSE,
11094: p_volume_uom_code IN VARCHAR2 DEFAULT NULL,

Line 11538: x_ret_code OUT NOCOPY wms_waveplan_tasks_pvt.message_table_type,

11534: END;
11535:
11536: PROCEDURE cancel_plans (
11537: x_return_status OUT NOCOPY VARCHAR2,
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;

Line 11539: p_transaction_temp_table wms_waveplan_tasks_pvt.transaction_temp_table_type

11535:
11536: PROCEDURE cancel_plans (
11537: x_return_status OUT NOCOPY VARCHAR2,
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);

Line 11664: END wms_waveplan_tasks_pvt;

11660: BEGIN
11661: g_wms_task_summary_tbl := p_wms_task_summary_tbl;
11662: END set_task_summary;
11663:
11664: END wms_waveplan_tasks_pvt;