APPS.WMS_TASK_ACTION_PVT dependencies on WMS_WAVEPLAN_TASKS_TEMP

Line 149: l_transaction_temp_id wms_waveplan_tasks_temp.transaction_temp_id%type;

145: x_return_message OUT NOCOPY VARCHAR2
146: )
147: IS
148: i NUMBER;
149: l_transaction_temp_id wms_waveplan_tasks_temp.transaction_temp_id%type;
150: l_task_type_id wms_waveplan_tasks_temp.task_type_id%type;
151: CURSOR c_transaction_task_ids( p_task_type_id NUMBER)
152: IS
153: SELECT DISTINCT transaction_temp_id

Line 150: l_task_type_id wms_waveplan_tasks_temp.task_type_id%type;

146: )
147: IS
148: i NUMBER;
149: l_transaction_temp_id wms_waveplan_tasks_temp.transaction_temp_id%type;
150: l_task_type_id wms_waveplan_tasks_temp.task_type_id%type;
151: CURSOR c_transaction_task_ids( p_task_type_id NUMBER)
152: IS
153: SELECT DISTINCT transaction_temp_id
154: FROM wms_waveplan_tasks_temp

Line 154: FROM wms_waveplan_tasks_temp

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

Line 207: FROM wms_waveplan_tasks_temp wwtt,

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

Line 365: FROM wms_waveplan_tasks_temp wwtt,

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