DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on WMS_DISPATCHED_TASKS_S

Line 2191: (wms_dispatched_tasks_s.NEXTVAL,

2187: task_type,
2188: operation_plan_id,
2189: move_order_line_id)
2190: VALUES
2191: (wms_dispatched_tasks_s.NEXTVAL,
2192: p_transaction_temp_id,
2193: p_organization_id,
2194: l_standard_operation_id,
2195: p_employee_id,

Line 3220: (wms_dispatched_tasks_s.NEXTVAL,

3216: device_request_id,
3217: task_group_id,
3218: task_method) -- add for cluster picking but others can use it too
3219: VALUES
3220: (wms_dispatched_tasks_s.NEXTVAL,
3221: task_record.transaction_temp_id,
3222: p_organization_id,
3223: NVL(task_record.standard_operation_id, 2),
3224: p_employee_id,

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

3640: FROM dual;
3641: SELECT mtl_material_transactions_s.NEXTVAL
3642: INTO l_new_transaction_temp_id
3643: FROM dual;
3644: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
3645: IF g_debug = 1 THEN
3646: mydebug( ' Calling split_mmtt for Txn. temp id : '||p_source_transaction_number,'split_task');
3647: END IF;
3648: split_mmtt(