APPS.WMS_TASK_ACTION_PVT dependencies on WMS_WAVEPLAN_TASKS_TEMP

Line 145: l_transaction_temp_id wms_waveplan_tasks_temp.transaction_temp_id%type;

141: x_return_message OUT NOCOPY VARCHAR2
142: )
143: IS
144: i NUMBER;
145: l_transaction_temp_id wms_waveplan_tasks_temp.transaction_temp_id%type;
146: l_task_type_id wms_waveplan_tasks_temp.task_type_id%type;
147: CURSOR c_transaction_task_ids( p_task_type_id NUMBER)
148: IS
149: SELECT DISTINCT transaction_temp_id

Line 146: l_task_type_id wms_waveplan_tasks_temp.task_type_id%type;

142: )
143: IS
144: i NUMBER;
145: l_transaction_temp_id wms_waveplan_tasks_temp.transaction_temp_id%type;
146: l_task_type_id wms_waveplan_tasks_temp.task_type_id%type;
147: CURSOR c_transaction_task_ids( p_task_type_id NUMBER)
148: IS
149: SELECT DISTINCT transaction_temp_id
150: FROM wms_waveplan_tasks_temp

Line 150: FROM wms_waveplan_tasks_temp

146: l_task_type_id wms_waveplan_tasks_temp.task_type_id%type;
147: CURSOR c_transaction_task_ids( p_task_type_id NUMBER)
148: IS
149: SELECT DISTINCT transaction_temp_id
150: FROM wms_waveplan_tasks_temp
151: WHERE task_type_id = p_task_type_id;
152: BEGIN
153: DEBUG( 'Inside GET_TRANSACTION_TASK_IDS procedure.');
154: DEBUG( 'p_task_type_id = ' || p_task_type_id);

Line 203: FROM wms_waveplan_tasks_temp wwtt,

199: CURSOR c_task_type_id
200: IS
201: SELECT distinct to_number(wwtt.task_type_id) task_type_id,
202: mfl.meaning
203: FROM wms_waveplan_tasks_temp wwtt,
204: mfg_lookups mfl
205: WHERE wwtt.task_type_id = mfl.lookup_code
206: AND mfl.lookup_type = 'WMS_TASK_TYPES';
207: BEGIN

Line 361: FROM wms_waveplan_tasks_temp wwtt,

357: CURSOR c_task_type_id
358: IS
359: SELECT distinct to_number(wwtt.task_type_id) task_type_id,
360: mfl.meaning
361: FROM wms_waveplan_tasks_temp wwtt,
362: mfg_lookups mfl
363: WHERE wwtt.task_type_id = mfl.lookup_code
364: AND mfl.lookup_type = 'WMS_TASK_TYPES';
365: BEGIN