1: PACKAGE wms_waveplan_tasks_pvt AUTHID CURRENT_USER AS
2: /* $Header: WMSVTKPS.pls 120.9.12020000.3 2013/03/25 13:39:27 pyerrams ship $ */
3:
4: TYPE transaction_temp_table_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
5: TYPE task_type_id_table_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE INDEX BY BINARY_INTEGER;
6: TYPE result_table_type IS TABLE OF wms_waveplan_tasks_temp.result%TYPE INDEX BY BINARY_INTEGER;
7: TYPE message_table_type IS TABLE OF wms_waveplan_tasks_temp.error%TYPE INDEX BY BINARY_INTEGER;
8: TYPE task_id_table_type IS TABLE OF wms_waveplan_tasks_temp.task_id%TYPE INDEX BY BINARY_INTEGER;
1: PACKAGE wms_waveplan_tasks_pvt AUTHID CURRENT_USER AS
2: /* $Header: WMSVTKPS.pls 120.9.12020000.3 2013/03/25 13:39:27 pyerrams ship $ */
3:
4: TYPE transaction_temp_table_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
5: TYPE task_type_id_table_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE INDEX BY BINARY_INTEGER;
6: TYPE result_table_type IS TABLE OF wms_waveplan_tasks_temp.result%TYPE INDEX BY BINARY_INTEGER;
7: TYPE message_table_type IS TABLE OF wms_waveplan_tasks_temp.error%TYPE INDEX BY BINARY_INTEGER;
8: TYPE task_id_table_type IS TABLE OF wms_waveplan_tasks_temp.task_id%TYPE INDEX BY BINARY_INTEGER;
9: TYPE time_per_task_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2: /* $Header: WMSVTKPS.pls 120.9.12020000.3 2013/03/25 13:39:27 pyerrams ship $ */
3:
4: TYPE transaction_temp_table_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
5: TYPE task_type_id_table_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE INDEX BY BINARY_INTEGER;
6: TYPE result_table_type IS TABLE OF wms_waveplan_tasks_temp.result%TYPE INDEX BY BINARY_INTEGER;
7: TYPE message_table_type IS TABLE OF wms_waveplan_tasks_temp.error%TYPE INDEX BY BINARY_INTEGER;
8: TYPE task_id_table_type IS TABLE OF wms_waveplan_tasks_temp.task_id%TYPE INDEX BY BINARY_INTEGER;
9: TYPE time_per_task_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10: TYPE time_uom_table_type IS TABLE OF bom_resources.unit_of_measure%TYPE INDEX BY BINARY_INTEGER;
3:
4: TYPE transaction_temp_table_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
5: TYPE task_type_id_table_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE INDEX BY BINARY_INTEGER;
6: TYPE result_table_type IS TABLE OF wms_waveplan_tasks_temp.result%TYPE INDEX BY BINARY_INTEGER;
7: TYPE message_table_type IS TABLE OF wms_waveplan_tasks_temp.error%TYPE INDEX BY BINARY_INTEGER;
8: TYPE task_id_table_type IS TABLE OF wms_waveplan_tasks_temp.task_id%TYPE INDEX BY BINARY_INTEGER;
9: TYPE time_per_task_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10: TYPE time_uom_table_type IS TABLE OF bom_resources.unit_of_measure%TYPE INDEX BY BINARY_INTEGER;
11:
4: TYPE transaction_temp_table_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
5: TYPE task_type_id_table_type IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE INDEX BY BINARY_INTEGER;
6: TYPE result_table_type IS TABLE OF wms_waveplan_tasks_temp.result%TYPE INDEX BY BINARY_INTEGER;
7: TYPE message_table_type IS TABLE OF wms_waveplan_tasks_temp.error%TYPE INDEX BY BINARY_INTEGER;
8: TYPE task_id_table_type IS TABLE OF wms_waveplan_tasks_temp.task_id%TYPE INDEX BY BINARY_INTEGER;
9: TYPE time_per_task_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10: TYPE time_uom_table_type IS TABLE OF bom_resources.unit_of_measure%TYPE INDEX BY BINARY_INTEGER;
11:
12: TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE INDEX BY BINARY_INTEGER;