APPS.WMS_WORKFLOW_WRAPPERS dependencies on WMS_DISPATCHED_TASKS

Line 449: FROM wms_dispatched_tasks

445: END IF;
446: BEGIN
447: SELECT task_id
448: INTO l_task_id
449: FROM wms_dispatched_tasks
450: WHERE transaction_temp_id=l_transaction_temp_id;
451: IF (l_debug = 1) THEN
452: mdebug('IN ELSE after : l_task_id: '||l_task_id);
453: END IF;

Line 990: SELECT WMS_DISPATCHED_TASKS_S.nextval INTO l_sequence_number FROM DUAL ;

986: END IF;
987:
988: -- generate item key using sequence number and concat with txnworkflow 'twflow'.
989: -- This is needed to create the workflow process
990: SELECT WMS_DISPATCHED_TASKS_S.nextval INTO l_sequence_number FROM DUAL ;
991:
992: l_item_key := 'twflow' || l_sequence_number ;
993: IF (l_debug = 1) THEN
994: mdebug('Item key is: '|| l_item_key);

Line 2358: FROM wms_dispatched_tasks

2354: IF p_tsk_id>0 THEN
2355: -- get necessary data to call workflow
2356: SELECT transaction_temp_id
2357: INTO l_transaction_temp_id
2358: FROM wms_dispatched_tasks
2359: WHERE task_id=p_tsk_id;
2360: IF (l_debug = 1) THEN
2361: mdebug('l_transaction_temp_id: '|| l_transaction_temp_id);
2362: END IF;

Line 2590: --Get MMTT id from WMS_Dispatched_tasks

2586: END IF;
2587:
2588:
2589: -- get data to call suggest_alternate_locatoin
2590: --Get MMTT id from WMS_Dispatched_tasks
2591: SELECT transaction_temp_id
2592: INTO lp_mmtt_id
2593: FROM wms_dispatched_tasks
2594: WHERE task_id=lp_task_id;

Line 2593: FROM wms_dispatched_tasks

2589: -- get data to call suggest_alternate_locatoin
2590: --Get MMTT id from WMS_Dispatched_tasks
2591: SELECT transaction_temp_id
2592: INTO lp_mmtt_id
2593: FROM wms_dispatched_tasks
2594: WHERE task_id=lp_task_id;
2595: IF (l_debug = 1) THEN
2596: mdebug('lp_mmtt_id: '|| lp_mmtt_id);
2597: END IF;