DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on WMS_DISPATCHED_TASKS_S

Line 2451: (wms_dispatched_tasks_s.NEXTVAL,

2447: task_type,
2448: operation_plan_id,
2449: move_order_line_id)
2450: VALUES
2451: (wms_dispatched_tasks_s.NEXTVAL,
2452: p_transaction_temp_id,
2453: p_organization_id,
2454: l_standard_operation_id,
2455: p_employee_id,

Line 3599: (wms_dispatched_tasks_s.NEXTVAL,

3595: device_request_id,
3596: task_group_id,
3597: task_method) -- add for cluster picking but others can use it too
3598: VALUES
3599: (wms_dispatched_tasks_s.NEXTVAL,
3600: task_record.transaction_temp_id,
3601: p_organization_id,
3602: NVL(task_record.standard_operation_id, 2),
3603: p_employee_id,

Line 4072: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;

4068: FROM dual;
4069: SELECT mtl_material_transactions_s.NEXTVAL
4070: INTO l_new_transaction_temp_id
4071: FROM dual;
4072: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
4073: IF g_debug = 1 THEN
4074: mydebug( ' Calling split_mmtt for Txn. temp id : '||p_source_transaction_number,'split_task');
4075: END IF;
4076: split_mmtt(