APPS.WMS_WORKFLOW_WRAPPERS dependencies on WMS_DISPATCHED_TASKS

Line 448: FROM wms_dispatched_tasks

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

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

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

Line 2324: FROM wms_dispatched_tasks

2320: IF p_tsk_id>0 THEN
2321: -- get necessary data to call workflow
2322: SELECT transaction_temp_id
2323: INTO l_transaction_temp_id
2324: FROM wms_dispatched_tasks
2325: WHERE task_id=p_tsk_id;
2326: IF (l_debug = 1) THEN
2327: mdebug('l_transaction_temp_id: '|| l_transaction_temp_id);
2328: END IF;

Line 2556: --Get MMTT id from WMS_Dispatched_tasks

2552: END IF;
2553:
2554:
2555: -- get data to call suggest_alternate_locatoin
2556: --Get MMTT id from WMS_Dispatched_tasks
2557: SELECT transaction_temp_id
2558: INTO lp_mmtt_id
2559: FROM wms_dispatched_tasks
2560: WHERE task_id=lp_task_id;

Line 2559: FROM wms_dispatched_tasks

2555: -- get data to call suggest_alternate_locatoin
2556: --Get MMTT id from WMS_Dispatched_tasks
2557: SELECT transaction_temp_id
2558: INTO lp_mmtt_id
2559: FROM wms_dispatched_tasks
2560: WHERE task_id=lp_task_id;
2561: IF (l_debug = 1) THEN
2562: mdebug('lp_mmtt_id: '|| lp_mmtt_id);
2563: END IF;